2 ms·
Calc has several options for languages to use for macros, for instance Python – I'm not certain about VBA support, but it would seem that many industries are sl
by BlueTemplar 6y ago
Calc has several options for languages to use for macros, for instance Python – I'm not certain about VBA support, but it would seem that many industries are slowly migrating to Python anyway :
https://news.ycombinator.com/item?id=25588720 https://news.ycombinator.com/item?id=25588720
- ojnabieoot 6y agoThe point is that VBA macros are portable across Excel but not between Excel and Calc. Calc does not support VBA macros. As many businesses need to consume spreadsheets with VBA macros, and since porting VBA to Python isn’t sustainable, Calc is simply not a good enough replacement for enterprise. I am not sure that one anecdotal blogpost supports the idea that industries are moving from Excel to Python. It is more likely that people are productionizing Excel spreadsheets with Python these days, instead of C++ or Java.