Pages & Numbers vs. Word & Excel

The Microsoft Office suite I currently have will no longer run if/when I upgrade my Macs to Lion, because it’s one of those pre-Intel legacy software things.

This coupled with a prof this semester who continually posts documents in a format that older Word versions (including mine) can’t open (even though the official college requirement is Word 97 or newer), has me feeling like it’s time to upgrade my productivity software.

I’m thinking of buying Pages and Numbers from the Mac App Store, rather than paying more than twice the amount for Office, since I don’t use Powerpoint and would rather throw my computer out a window than use Outlook.

My question is: is there really full compatibility? When my prof posts notes from Word 2011 in .docx format, will Pages open that document and actually let me read it? Will I be able to take the budget spreadsheet I currently have as an .xls and still have all the formulas and references work if I open it in Numbers?

I’m not a heavy duty user, especially of Excel. Even in Word, the most I do is create a simple document, I’m not writing the great American novel or a doctoral thesis or anything. My biggest concern is “will this file from this other source work?”

Out of curiosity, where do you get the “more than twice the amount” from? Presumably you’re a student, so it looks like the academic pricing works out to maybe twenty bucks more than iWork. Granted, it’s still more, but it’s not a major difference.

Even the Win and OS X versions of Word aren’t 100% compatible. If you edit a long document, you’ll find the paging is different, because lines break at different places. This becomes worse if there are pictures, since which page a picture ends up on has a big difference. Not sure if Excel 2011 is better, but Excel 2008 was terribly slow with moderately large graphs, which the Win version could handle easily.

Personally, I wouldn’t buy anything.

Download OpenOffice for Mac, which is free.

As a broke student, you have many other things to spend that money on.

I think the difference is that you can buy Pages and Numbers individually, rather than having to buy the whole suite.