I've used OpenOffice in the past (since 2005-ish), switched to Libreoffice when it came out. During the same time I used Microsoft Office at work. About a year ago I changed my job and now I get to use macOS.
Some huuuge surprises: 1. libreoffice unfortunately is really slow on macos with retina display. 2. The web version of excel does not hold a candle to Google sheets. 3. Excel for windows is not interoperable with macos. Eg: have data in one sheet in excel, create a separate sheet with pivotable from first sheet. Open the file on macos's excel and it will complain that this usage of data sources is not availabale on macos. I thought it was a funky excel file but no. Easily repeatable with very simple cases.
Also, styles management in libreoffice writer is many times easier and understandable than in microsoft word.