None of the things you listed are suitable replacements for Excel. None.
It has nothing to do with existing files/compatibility. Excel is unparalleled.
It has nothing to do with existing files/compatibility. Excel is unparalleled.
This is not theoretical; I learned it by needing to get shit done in a context where having an activated copy of Excel wasn't practical. Excel was paralleled and in one case surpassed.
It's fine if you have a few formulas. As soon as you're busting out macros it's time to sunset the workbook and make an application. There's a lot of God Excel workbooks sitting around on share drives with no audibility or quality control.
But given that Excel is the second-best tool for everything, world runs on it.
And when you try to build systems to replace Excel for a specific task, you quickly learn how extremely powerful Excel is and how hard is to replace it and add value that customers would care about.
But many end users prefer dealing with bugs than with inflexible software that doesn’t understand all the different ways how real world is messy and hard to model.
I hate using Excel. But I 100% understand why world runs on it.
If you listed out all the things that Excel can do, we might find that the alternative is at 80% or so (just a number), with some additional things that Excel can't do. That 80% could be good enough to switch. It should not be looked at as "all or nothing", especially for every person or business.
More people should use and contribute to LibreOffice!