On the funny note: as powerful excel is, it cannot open two files with the same name from different folders! Or at least my version can't.
> Why did you choose the expensive version
Big companies have (sometimes hard negotiated) volume contracts with Microsoft, which makes Excel much cheaper to them than to, say, small companies. Thus Excel is not really expensive for them.
Concerning
> where you never know what it will cost next year in the first place
For open source software there exists a similar risk that you don't know into which direction the product will develop.
In the past, Microsoft has been quite reliable in keeping backwards compatible, and continue selling office for decades.
In my observation, the zigzag course that Microsoft starting doing with Windows (but is now also doing with office), and, relatedly, deviating from the course of being very insanely dependable in delivering the software that companies need from them, is what by now got big companies at least have a look at what possible alternatives to Microsoft products could be.
You know what's really interesting to me about this argument point?
It is actually the proprietary solution that is at risk of this, and we feel it daily. The next version of Microsofts own flagship product (Windows) is nearly universally denigrated, but people are forced to upgrade.
With FOSS, there's significantly less risk, if the product changes direction you and your other company friends can just use old versions or in the worst case.. fork it.
This is really bad for a lot of reasons. Of course it's painfully slow, but it's also incredibly brittle and foot-gunny. Excel IS NOT a competent database engine or application engine. It makes JS and C++ look sane and safe.
Excel shouldn't be switched out to LibreOffice. It should be switched out to a proper application with a proper database. What, finance bros don't know how to navigate a database. Tough fucking luck! In the 70s, secretaries could do that. They better figure it out. Because these existing "systems" are a disaster waiting to happen.
Finance and insurance industries are full of Excel powerusers.
> LibreOffice is enough for the vast majority of use cases.
Often (from my job experience I can at least attest this for the finance and insurance sectors), Excel is an integrated part of many large workflows. Changing from Excel to LibreOffice would mean rewriting important parts of central business applications, so you better have a really good reason why you want to do the switch from Excel to LibreOffice.