Simple excel sheets are also hit or miss.

I found that wps office seems to work better than LibreOffice in terms of compatibility with complicated MSOffice files. It's free but not open source, if you care about that.

Libreofice calc sheets do not work at all in Excel, so the criticism is unwarranted. Just work in the native format.