Office software for Mac - which is best?

[Knowz]

Hi everyone, recently I bought a rMBP and installed Mountain Lion on it.
One of the most important things for me is being able to use a good office suite (especially a word processor) which is fully compatible (formatting, styles, etc) with Microsoft Office on Windows (I'll need to be transferring files a lot to computers with MS office for Windows on them, for others to view/edit/print, etc).

What office suite / program(s) would you recommend?

Is Microsoft Office for Mac 2011 good? What are your opinions on it? Is it completely compatible MS office for Windows?
Additionally I've heard that MS office for Mac 2011 is not yet ready for the Retina display - does it really look bad or it bearable?

Other than that what else would you recommend? Is Apple's Pages completely compatible with every version MS Office for Windows?

I've currently installed LibreOffice and it has several compatibility problems with MS Office for Windows - and I'd really need a word processing program which will have no problem compatibility-wise in regards to formatting, styles, etc. Are there any other open-source ones which are fully compatible?

----
Most importantly, I want an office suite (and a word processing program in particular) which is:
1. Fully compatible with all versions of MS Office for Windows (i.e. no styling/formatting, etc problems when sending files back-and-forth)
2. Looks fairly good on the Retina Display

--Thanks.,
Knowz

 

[GGJstudios]

I prefer MS Office for Mac, for maximum compatibility with Windows users. If you don't want MS Office for some reason, there are many alternatives, such as iWork, NeoOffice, LibreOffice, OpenOffice, Google Docs, etc. Searching the forum will reveal dozens of threads discussing these various alternatives and the pros and cons of each, such as this small sampling:

MS Office 2011 and Retina Display
Microsoft Office 2011 on Retina Macbook Pro
Microsoft office on retinaMountain Lion & MS Office 2011
Microsoft Confirms Office 2011 and 2008 Compatibility with OS X Mountain Lion
Microsoft office 2011 compatable with mountain lion?
Poll: iWork vs Office vs something else
Office or iWorks?
iWork (09?) VS Office 2011 for Mac
Office 2011 Mac vs iWorks?
iWork 09 vs Office 2011 on MBA
Poll: MS Office for Mac 2011 vs iWork
Poll: Office or iWork?
iWork vs MS Office 2011 for the basic user​

 

[hafr]

I prefer MS Office for Mac, for maximum compatibility with Windows users. If you don't want MS Office for some reason, there are many alternatives, such as iWork, NeoOffice, LibreOffice, OpenOffice, Google Docs, etc. Searching the forum will reveal dozens of threads discussing these various alternatives and the pros and cons of each, such as this small sampling:

MS Office 2011 and Retina Display
Microsoft Office 2011 on Retina Macbook Pro
Microsoft office on retinaMountain Lion & MS Office 2011
Microsoft Confirms Office 2011 and 2008 Compatibility with OS X Mountain Lion
Microsoft office 2011 compatable with mountain lion?
Poll: iWork vs Office vs something else
Office or iWorks?
iWork (09?) VS Office 2011 for Mac
Office 2011 Mac vs iWorks?
iWork 09 vs Office 2011 on MBA
Poll: MS Office for Mac 2011 vs iWork
Poll: Office or iWork?
iWork vs MS Office 2011 for the basic user​

Isn't LibreOffice just the new name of OpenOffice? Libre being the french word for open in the sense of free...

 

[Quotenfrau]

Isn't LibreOffice just the new name of OpenOffice? Libre being the french word for open in the sense of free...

No "new name" is wrong. It's a fork. See hole story at Wikipedia https://en.wikipedia.org/wiki/LibreOffice

 

[Bobby.e]

No word processor is 100% compatible with all versions of Office. Even Office isn't 100% compatible with each other. Office 2011 for Mac will be your best Mac software though.

 

[samh]

No word processor is 100% compatible with all versions of Office. Even Office isn't 100% compatible with each other. Office 2011 for Mac will be your best Mac software though.

Indeed, fonts and print setups can cause the same document to appear different in the SAME version of Word for Windows on different machines/installations.

Having spent many, many years in the Windows world and knowing MS Word VERY well, I actually LIKE Word and Excel 2011. Powerpoint is OK. There are a couple of obnoxious things about Excel (the keyboard shortcut to edit cell contents without overwriting is by default an unfriendly combination). I did not care for Pages, and of course the native file format is no compatible anywhere else.

I have found Compatibility to be pretty good between the PC and Mac side (Word 07/2010 and Word 2011 for Mac, that is).

 

[MacDawg]

Most importantly, I want an office suite (and a word processing program in particular) which is:
1. Fully compatible with all versions of MS Office for Windows (i.e. no styling/formatting, etc problems when sending files back-and-forth)

As other posters have pointed out, this is not happening
Not even among different versions of Office on Windows

Office 2011 is the best Mac version for compatibility at this point, but it is not perfect
But it will be better than any Open Office variation or other software for compatibility purposes

 

[kemo]

How about Parallels + Windows and use MS Office for Windows? If you are so much after compatibility there is no better way now.

 

[MacDawg]

How about Parallels + Windows and use MS Office for Windows? If you are so much after compatibility there is no better way now.

While that definitely works (I do it some myself), it does require an investment in:
Parallels or VMware (unless VirtualBox is used)
Windows (Win7 likely)
MS Office for Windows

Quite a hefty $$ investment

 

[-tWv-]

I love Office 2011 for the Mac. I've never had any issues with compatibility for windows machines and I think the interface is great. It does take some getting used to if you come from using the Windows version, but it's pretty self explanatory and definitely a big step up from the previous version of office for mac.

 

[MacDawg]

Typically, as the complexity of a document increases, the likelihood for complete compatibility decreases

 

[Meyvn]

Office for Mac 2011 is definitely going to be the best choice for compatibility. It's also going to be the most expensive, and honestly, I don't think any of the listed options are truly problematic compatibility-wise unless you're talking about cooperative page design or cooperative presentation work. And if you are talking about those things, we're the wrong people to ask; you should just coordinate with your coworkers to use the same software & fonts, whatever those may be.

As far as UI, I think iWork is the best if we're talking about the whole suite. It's also much less expensive than Office, especially when you factor in the "buy once, use on all your Macs" advantage. If word processing is really the only thing you need, Bean is excellent, and free.

If you need spreadsheet & presentation software and don't want to pay for it, LibreOffice is really the only game in town. Its UI is pretty crappy, though, and if you are working in a shared environment, its presentation component is going to have the worst compatibility problems of anything out there.

 

[etsi]

Is iwork compatible with ms office? I don't work with complicated word/excel documents. I don't like LibreOffice.

 

[MacDawg]

Is iwork compatible with ms office? I don't work with complicated word/excel documents. I don't like LibreOffice.

You can export Pages documents as Word docs, etc
But compatibility can be spotty at times

I like Numbers, but it is not a substitute for Excel