I've reached the next stage in the process of reclaiming control over my tech and that entails switching my spreadsheets away from Google. Stage one was about turning off notifications, removing bloatware and changing settings to be more privacy-oriented whenever I got a new device, etc. Second stage: replacing numerous different software with Obsidian, a huge productivity and convenience win. So these days I use Obsidian for almost everything but it doesn't do spreadsheets yet (if ever).
So I did some research and it looks like LibreOffice is the only option that doesn't come with some sort of AI stuff and makes the .xls(x) file format I can display in Obsidian. This conversation is not about why I'm choosing to avoid AI features and companies that won't allow me to turn them off, but that's what I aim to do, as much as possible. Edit: I also want a local installation that works offline and doesn't send anything to some cloud.
I searched Tildes for LibreOffice and found some damning comments but they were all fairly vague and I'm unsure how much the disappointment applies to LibreOffice Calc specifically, so I thought I'd ask about people's experiences.
My use case is primarily for personal finance calculations, as well as costing sheets for work. Not super complex high level math but there are some more complicated formulas and I do like to have conditional formatting options too. Mainly I'm interested in reliability, even if the thing isn't as feature-packed as Google Sheets. I'm on MacOS if that matters.