upvote
> LibreOffice Calc

Mentioning libreoffice as competitor to Excel and Access is like you haven't understood the market, at all.

Excel is a cross department business automation database, which can sync/pull/push datasets across filesystems and networks.

VBA is the single most used language in Enterprise because it allows to automate pretty much any financial workflow. And more importantly: automated by non-programmers.

Libreoffice is made for private users, and that's not the same users that VBA powered office documents have.

reply
are you trying to say that i cant use libre, to automate, share, or collaborate datasets across a network?

https://help.libreoffice.org/latest/lo/text/sbasic/shared/vb...

are you trying to say its too hard to step into libre from VBS?

https://libreoffice-basic-reference.readthedocs.io/en/latest...

you can stay with MS if you want, but really you dont have to.

also i didnt mention libre as competitor, but as replacement.

reply
You can do all those things. But as someone who used VBA extensively and often got hired because of my automation skills, not having VBA and other aspects of excel would be a non-starter.
reply
your sure?

its really not that hard, and it might be useful, if MS ends up finding that final straw that breaks it for everyone, you would be better off having a head start and level ground, rather than staring up a wall for employment.

i recommend you orient to it, for future proofing.

scripting:

https://help.libreoffice.org/latest/en-US/text/shared/guide/...

API:

https://api.libreoffice.org/docs/idl/ref/annotated.html

BASIC:

https://wiki.documentfoundation.org/Documentation/BASIC_Guid...

Working with VBA Macros

https://help.libreoffice.org/latest/lo/text/sbasic/shared/vb...

reply
The French government decided on Grist as their replacement. It looks pretty promising: https://www.getgrist.com/
reply