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 standard anymore. Here’s fsfe’ stance to it, calling it a pseudo-standard.
Results in basic formatting having to be reverse-engineered.
To be fair, LibreOffice had (don’t know if it still has!) problems rendering OpenOffice .odt files in the past.