XLOOKUP is so nice though.
The other stuff I can live without, especially the UI on data connections changing all the time and the connections breaking anyway.
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.
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.