For personal use, Libre office does everything I need. For work, Excel is an absolute beast. It doesn’t necessarily scale, but for those one off data comparison, manipulation, or validation often I can do it faster and easier than I can in SQL. VLookup was kinda cool. Index match is definitely powerful.
I still generally avoid the vb macros though I’ve found solutions online occasionally where they’re useful. (Reviewing the code to confirm it’s not malicious first of course.).
Since Google sheets came around I’ve always found freaking with excel more of a headache so I’ve not touched it for a loooong time. Only the reader version when someone sends me an xlsx in an email
Fair, I still use Office 2007 via Wine. Even the newest one has the killer features (unless it’s the awful web version) but your willingness to use it depends on how strong your aversion towards proprietary OSs and AI is
deleted by creator
For personal use, Libre office does everything I need. For work, Excel is an absolute beast. It doesn’t necessarily scale, but for those one off data comparison, manipulation, or validation often I can do it faster and easier than I can in SQL. VLookup was kinda cool. Index match is definitely powerful.
I still generally avoid the vb macros though I’ve found solutions online occasionally where they’re useful. (Reviewing the code to confirm it’s not malicious first of course.).
I mostly just import the data into PostgreSQL and write queries. Not because excel can’t do it, but because I hate it.
I only need simple excel and mostly rely on word processing so I’ve never actually known what exactly ms excel has that libre doesn’t
Is it like actual macro/coding capabilities within excel or just convenience/file compatibility stuff?
I think the main issue I’ve seen is when people need bug-for-bug (or nearly so) compatibility with VB macros.
For me it’s the macros. Simple ones will work in LibreOffice Calc but the more complex ones crash.
Since Google sheets came around I’ve always found freaking with excel more of a headache so I’ve not touched it for a loooong time. Only the reader version when someone sends me an xlsx in an email
Fair, I still use Office 2007 via Wine. Even the newest one has the killer features (unless it’s the awful web version) but your willingness to use it depends on how strong your aversion towards proprietary OSs and AI is