LibreOffice Sheets doesn’t compete with Excel 2024, it competes more with Excel 2003. Granted, this is fine for a lot of (most?) people but it’s still not a “replacement” in my mind.
I ended up just building a Nix Flake to properly run Excel. At least then the operating system itself isn’t MS.
Even without the VBA though, it’s missing basically any feature added in 2019 like Lambda and filter and dynamic arrays.
I wouldn’t consider myself a power user, I would say I am a “high level basic user”, and even I have noticed the shortcomings. And this is also coming from a dude who very much wants a FOSS thing to succeed over Microsoft.
I think the only way we can actually solve the problem is to get a FOSS product up to snuff with Excel. I use Julia if I need really elaborate number crunching, but I don’t view it as a substitute for Excel; the interactivity of spreadsheets is really useful, especially when you’re actively developing stuff.
Valve is making desktop computers now; maybe the next thing they could improve is LibreOffice to try and appeal to businesses.
It supports Office 365 and Office 2024 Home works as of about two days ago.
I think it would require very little if any effort to get Home and Business working but the license for that was too expensive (though pull requests are welcome!)
Currently limited to stuff that can be activated on Microsoft’s website. I tried very hard and was ultimately unsuccessful at getting Office 2024 Pro Plus working from a gray-market key I bought on Groupon, because the MAK activation stuff appears to depend on a lot of stuff that Wine/Proton doesn’t implement. Again, pull requests are welcome if someone here figures out how to do it.