3 ms·
IMHO the trick is that any moderately useful and modern VBA is likely to go way beyond the base specification. - UserForms GUI (which this does not touch on at
by doubloon 3y ago
IMHO the trick is that any moderately useful and modern VBA is likely to go way beyond the base specification.
- UserForms GUI (which this does not touch on at all)
- Microsoft libraries like mscorlib and Microsoft Scripting Runtime, to get stuff like ArrayList and FileSystemObject.
- Excel VBA is kind of notorious for mixing Excel code with the VBA, using cells of the sheet as data storage, using formulas inside of cells to calculate values, etc. For example to store a list of values and sort it, they might put the data into a tab of the spreadsheet and call Excel functions to sort it inside the spreadsheet instead of building a list in VBA and sorting it in VBA.
So I think an open source useful VBA clone would probably also need to be an Excel clone and also a clone of a bunch of Microsoft libraries
- mcbishop 3y agoI love your comment. I'm guessing that it'd be very difficult to clone Excel's relatively-new dynamic-array-formula functionality (with comparable performance).
- agumonkey 3y agoand IIRC, datatype conversion made through excel formatting options. change cell display to get decimal :) fun
- mcbishop 3y agoI'm pretty sure that modifying a cell's number format never affects the underlying value.
- agumonkey 3y agomaybe not the actual memory data, but AFAIK it does affect the behavior of other logical / arithmetic functions in strange ways
- deleted 3y ago[deleted]
- mcbishop 3y agoOkay, thanks. If this is correct... it's unsettling and not cool.
- doubloon 3y agothere are excel parsing libraries will treat the underlying data differently depending on how it is formatted. operations people basically have to do workarounds for this all the time.