About 10 years ago the Ubuntu package manager borked my installation of LibreOffice (or maybe it was OpenOffice then). I only used it for spreadsheets and Gnumeric was able to open the ODS files just fine. There was only one function that I need to change (DaysInYear for handling leap years).

If for any reason I have to go back to it, I think I can.

Gnumeric is great. It's the only one that holds up with massive CSV files and remains snappy. So I tend to prefer it. Functions are more limited than Calc though.