Re:Microsoft Increases Office 365 and Microsoft 365 License ...
by d3Xt3r on Tuesday December 09, 2025 @05:17AM
(#46203321)
FWIW, both OnlyOffice and LibreOffice support XLOOKUP. In fact LibreOffice has over 500 Excel formulae, which is very close to the number of formulae Excel has.
Unless you use a lot of VBA (and you can't translate it to Python), or you've got some proprietary COM addin that you can't live without, LibreOffice's Calc is a pretty damn good replacement for Excel for the majority of users.
Word 97 was basically feature complete though (if buggy - the same bugs persist today of course), including track changes and compare/merge documents. The killer feature now is being able to work on the same document with multiple people and seeing their changes in realtime. You used to be able to do this on-prem but that product (Office Online Server) got killed. I wonder why.