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.
There is Office software that can handle Microsoft formats better than other Office software. Still, Microsoft’s file formats are open.
That’s a sham. Only basic stuff is open standard, the rest is proprietary extensions. Such a format can’t usually be standardized; there’s an entire Wikipedia article about MS’ shenanigans to make it happen. But MS doesn’t even keep to that ambiguous 600-pages standard anymore. Here’s fsfe’ stance to it, calling it a pseudo-standard.
Which results in basic formatting having to be reverse-engineered. Better use Open Document Format.
To be fair, LibreOffice had (don’t know if it still has!) problems rendering OpenOffice .odt files in the past.