I also like Apple's office suite, the problem is network effects. I'd even argue most people don't actually need MS Office. The amount of people using PowerQuery, VBA, etc. is probably less than 2% of users.
The problem is, because everyone else (in business) already has and uses office, if you want to collaborate, that's what you have to use. Open file formats didn't win out in the end.
This is absolutely the problem - with the added issue of platform support.
I’m the only Mac user in our company of 15, which means I’m also the only person that can open a .pages file. Anyone can read a .docx, and if authored in word it will actually look the same on both computers.