LibreOffice is preinstalled in Pop OS, and as someone who loves the idea of FOSS I want to use it, but inevitably I just use Google docs or Office Online. Is it really worth learning? Has anyone successfully incorporated it into your workflow?
I use LibreOffice daily (mostly Writer, but also Calc) to run my small consulting business. I compile reports which can be quite long and complex including front matter sections, table of contents, index of tables and multiple levels of headers. Lots of internal referencing and footnotes as well.
I have also used it in windows within a company where everyone else was using Word, without any more issues than the Word users were having.
The main problem with Word documents is the build-up of auto-generated "styles" and people's use of direct formatting for everything. This leads to inconsistencies.
With LibreOffice, the use of styles is much more integrated at all levels than in Word and learning to use them properly is a game changer. I have found the direct generation of PDF from Libreoffice to produce a better result.
I like Calc better than Excel but they use different but similar macro languages so Excel macros are not always directly compatible in Calc.