Can confirm! Calc is fine as long as you’re not trying to do anything too advanced. Then again, when you bump into those limits, you might want to consider switching to R or Python anyway. Excel just allows you to delay that inevitability a little bit longer.
Very interesting… I guess my calculations can be supercharged while still technically remaining in the realm of a spreadsheet.
Hopefully Python still runs with its usual consistency. VBA is a total nightmare in this regard. The code can randomly throw some useless error for no obvious reason. You can run the same code a few hours later and everything works perfectly even though you didn’t change anything. Can’t really use anything that unstable for anything serious.
Can confirm! Calc is fine as long as you’re not trying to do anything too advanced. Then again, when you bump into those limits, you might want to consider switching to R or Python anyway. Excel just allows you to delay that inevitability a little bit longer.
I mean, you can run python (or their own language “LibreOffice Basic”) from within a Libreoffice Calc sheet.
Calc’s scripting is actually more powerful than the aging VBA thing Excel uses for macros, imho.
Very interesting… I guess my calculations can be supercharged while still technically remaining in the realm of a spreadsheet.
Hopefully Python still runs with its usual consistency. VBA is a total nightmare in this regard. The code can randomly throw some useless error for no obvious reason. You can run the same code a few hours later and everything works perfectly even though you didn’t change anything. Can’t really use anything that unstable for anything serious.
This is the real thing of it. By the time you reach that you shouldn’t be using a damn spreadsheet program.
At least for greenfield set it up right now. There’s plenty of actual programs that do things theyre supposed to.