[quote author=Sparktrician
Open Office and
Libre Office are nearly identical, being forked versions of the earlier Open Office as developed by Sun Microsystems before they were taken over by Oracle. Both are very competent products, although I prefer Libre Office due to frequent updates and bug fixes, and the no-cost model. They are allegedly MS Office-compatible, but porting some documents from one into the other is often a chancy effort. They work differently, so changing from one to the other carries a learning curve. Libre Office Calc works very closely to Excel, and is an excellent product, once you get past the frustrations of the learning curve.
[/quote]
I concur absolutely. Great office environments though for Mac users – in my experience – the Libre is/was wayyyyy better.
There were indeed some compatibility issues with some of the more high-faluting Excel functions which caused problems for a friend who HAD to go back to Microsoft. His brother, strangely, couldn't abandon MS because of certain printing functions.
Personally, I'm not a spreadsheet power-user and had no problems of
those kinds but neither O-O nor L-O would address the lack of outlining mode for authors, in spite of forum pressure and class pleading. I've therefore migrated entirely to Scrivener, abandoning the spreadsheet compatibility entirely for day-to-day use. O-O had become a
very low priority for Sun, years ago, and the Libre team is much more responsive - at least it was when I last looked.
Sorry to digress but I wanted to maybe load the choice toward Libre if that's viable for the O.P. and explain why, though nothing comes close to Scrivener for writing and I like to bang the drum for them occasionally.
What I'd
really like to see is a version of MSO that looked identical and behaved identically to the superb 1986 Word4 but running British English dictionaries on modern processors – without all the baggage of built-in drawing packages, incompetent web code generation, sat-nav, social media and bloat garbage that made us all want to leave it anyway. O-O really looked like they were going to do it for a while…
Try Libre Office. It'll probably do everything you want.