I am the only Mac user in my company. I have to use MS office to share files with my colleagues. I have one BIG GRIPE with Mac MS Office against PC MS office.
To date I have not found any BIG issue with the excel part of Mac MS office. I have small gripes but generally they are compatible.
In word and powerpoint vs iworks (or vice versa) I have BIG issues.
I can construct a Keynote or .ppt in the Mac and develop a great looking presentation with more transition effects in .ppt than are in Keynote iworks. Fact. But if I send my Mac version to a colleague on a PC you can guarantee that when you play the .ppt in presentation mode, first those great transition you get in the Mac version, all but disappear.
Secondly, graphs or inserts that you have shrunck to fit the .ppt slide in the Mac version and actually present great in the Mac version, all come out misplaced and words overlaid with one another in the PC version. Not good, I have loads of trouble with this. The way I get round this is download my Mac .ppt file to a USB go to a work PC, load it run the .ppt in presentation mode. The slides that come out with misplaced inserts and text, you can correct if you made the data in the .ppt. If you imported the data then you have to double click it, where you then get the original graph or spreadsheet or whatever document appear, and you simply click it and return to the .ppt and generally that fixes the problem. Then I can reload to my Mac, overwrite the original file, now I can send it to a PC colleague and it will still work great on my Mac and a PC. Yes you are correct, that means my work desk has my Mac on it and a work PC for these and other MS Mac compatible issues. I hate that as I fly the Apple flag often, but still have to cower sometimes to a PC.
What bugs me is they are both MS and they are not 100% compatible.
The same goes for the word on both systems, but you cant double click a section to correct it as you do in .ppt, you have to physically reposition or retype it.
From Pages I can make great documents, with bullets, pictures, graphs etc, but convert it to a .doc on a Mac, you may be OK at this stage, not always. Send this .doc to a PC and your screwed. Nothing lines up, most formatting is misplaced.
So if they could fix this or anyone knows how to fix this I would be a happy bunny.
That's my two cents worth of PC vs Mac MS office and iworks, Actually felt more like 100 cents worth.
Phil