Today I did my first advanced spreadsheet on LibreOffice after switching to Linux, and it handled itself pretty well. I had to search for some features on the web at first, but after I got it down, I felt comfortable using it. Also, LibreOffice’s default menu layout is not pretty, but I can find all of the functions with just a click, unlike MS Office’s ribbon menu where I had to click around to find what I was looking for. Sorry for bad English.
Except for MS format compatiblity, not my experience, Not sure where MS format compatibility stands now, but that has histically been the biggest issue.
Keep on mind that MS supplied LibreOffice translator is not great either so they have issues too. MS really does not plan on being compatible even between versions of their own software.
There are still a few issues left to fix in my experience.