Libre office is not even 10% MS Office. Don't know why people recommend it. It messes up my word formatting.
As for the formatting - yeah, MS doesn't seem to follow its own document formatting standards, even for the newer documents. That puts other suites in a hard spot: a) follow standards and present imperfect documents, or b) invest immense resources into bug-for-bug compatibility?
I don't know Excel but I know there are people running entire departments on Excel spreadsheets.
(Having seen many Excel spreadsheets, 80% of the work is done by rudimentary means: pivot tables are Advanced Magic in this regard)