Libre Office Calc is pretty similar to Excel for general use. For importing csv files it has always been superior to Excel. Some niche areas in Calc are also better than Excel. Inflexible users are locked into Excel, but for general purpose use Calc is all you need.
Libre Office is great for replicating what Excel did 10 years ago. Excel has a lot of things that power users use (like Power Query) that Libre Office simply isn't even trying to replicate.
When developers tell me that I could use Calc rather than Excel, I ask them if they would be OK being forced to use Emacs or Vim, whichever is the opposite of what they spent the last decade perfecting.
For legacy spreadsheets, you're 100% correct. I'll need to keep a version of Excel around forever. If they price me out of 365 by making me pay for Copilot shit I don't use or want, a perpetual license to Office 2019 runs about $20 and will do that job for me.
For new work that I might have otherwise done in Excel, there are good options. Collabora works. Libre Office works. Google sheets works. And Grist is quite good, and self-hostable.
> If they price me out of 365 by making me pay for Copilot shit I don't use or want [...]
In case you aren't aware, when they try to sneak Copilot onto your plan you can get rid of it by going to your plan management page and canceling. One of the offers they should offer to try to get you to stay is your old plan without Copilot.
That depends on your workload. I've been using Excel since 1993, and I find the things I've listed help me get things done just as well as Excel does, unless I have a pile of macros and vbscript I need to interop with.
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.
The solution is actually just not using Excel. If you're essentially using Excel as a LOB backend and database, that should probably not be in Excel.
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.
Yes, there's many many cases that should likely not be using Excel.
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.
I've been there, the problem is that replacements are not as versatile or "floppy". But that's also a good thing, because Excel is too versatile to the point where most workbooks are filled with bugs on top of bugs and nobody cares.
Yes, bugs in sheets are worst part of excel, by far.
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.
Have to disagree. It depends on what you are doing. That the alternatives can be replacements, including the open source ones, is relative and should be looked at as a percentage.
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.
A whole lot of accountants/bookkeepers (including I) will totally disagree with you. LibreOffice is very good.. and not just Calc either. Writing a novel in Writer is a pleasure.
More people should use and contribute to LibreOffice!
I want to love these, mostly because they're FOSS and Office/Google Spreadsheets seems to get more and more bloated, and subsequently slower.
But the UX is just a lot worse, and it isn't easy to go from one application to another because they're slightly different enough that your productivity takes a hit from all the small papercuts.
I'm waiting for some FOSS spreadsheet solution that doesn't just try to copy Office, but comes up with something better. Then it'll feel like it's worth it to learn a whole new program and its UX, rather than just suffering through it because you wanna use FOSS.
Many would say that the FOSS alternatives don't copy Office enough. Often, by going there own way with various tasks, they create a bigger jump. Case in point, the Linux distros that attract the most attention for common folk and not niche use, are the ones that are more Windows-like. Examples: Linux Mint, Ubuntu, Zorin, etc... The smaller the jump, the more you can convince people to switch over.
When there is a significant difference, it needs to be shown what the equivalent is in the alternative. The jump can be a bit mitigated by education or information, but usually by only so much, where it's still seen as attractive.
I think the main issue for most people is that the layout is slightly different, probably to help prevent microsoft from suing them.
But once you get used to those differences, (also, knowing that there are a handful of themes that can shorten the difference significantly) then it becomes a non-issue after less than 10 hours of use.
LibreOffice seems to have an optional ribbon-like interface for the people that happen to like it (View -> User Interface) (but I don't use this UI mode as I personally find ribbon-like UIs hard to work with).
> But the UX is just a lot worse, and it isn't easy to go from one application to another because they're slightly different enough that your productivity takes a hit from all the small papercuts.
Speak for yourself. I see that LibreOffice's default UI is still a normal WIMP UI and this is a plus for me. I hated when MS Office switched to the ribbon in Office 2007.
"So you want to insert a row in a table? Great, just click on Table > Insert > Row... Oh well. Nevermind, just show me your screen and I'll hunt the functionality in that stupid ribbon."
We don't need less, but more, Office programs that respect GUI UI conventions.
Yeah, that's the opposite of what I want, then I'll just continue using Excel... What I want is for someone to figure out a better UI and better UX, not just copy what's out there.
My hot take on a better excel: the two things excel sucks at: version control and syncing. On the backend, separate the data and the logic in the spreadsheet and put each into version control. Then use something like syncthing to share documents with colleagues. You might also need something like bitmessage for initial handshake. Now you have a spreadsheet you can collaborate on in real time over the Internet or LAN without screwing around with a server, a google account, a credit card etc.
There's two more things excel is horrible at: choice of extension language and being able to graduate your spreadsheet into a real program. You fix the extension language by using something like web assembly on the back end, and probably bundle one or more compilers to go from $lang to web assembly in order to be user friendly. Lastly you fix the last problem by virtue of doing all of the above. The second two features won't draw in new users much, so they're less important in the short run but make it a lot more sticky.
I'm not in a place in life to put much free time into that project, and ideas are cheap ...
Yes, but take OpenOffice off the list, development has slowed to a glacial pace and it’s close to abandoned in favour of LibreOffice, which is actively maintained.
Looks like there was finally a OpenOffice release recently but that was after years of people complaining of security vulnerabilities not fixed in the release version.
My problem is the knee-jerk "Google will sell/read our data" that suggesting any of their suite seems to engender. It doesn't really matter what Google says in their contracts, too many executives trust them less than MSFT.
Agreed that their actual products seem to work fine for almost everyone.
