As for libreoffice I throughly dislike it compared to MS software. I have opened reproducible bugs against it in bugzilla that have been there for over a decade with no solutions. I got fed up in the end and just walked.
Saying that I dislike office packages entirely. They are a Swiss Army knife. Lots of mediocre tools in an inconvenient format but simple enough for the lowest denominator of poorly trained staff to use. We can and should do better. I managed to switch entirely over to LaTeX document authoring and dedicated software to replace spreadsheets (all open source tools). The only remaining spreadsheet I have is personal finance which I can’t find a better solution for.
As for cloud we just send PDFs around and collab on GitHub so O365 is dead for us anyway.