With all the discussion about XML file formats, people seem to have forgotten one of the main reasons for picking an Office suite. Performance. I've always been super impressed with the Excel development team, and how well they've optimized the Excel "Calc" engine. I threw together this video that demonstrates how OpenOffice 2.0.2 compares to Excel 2003 and Excel 2007 beta 2.
Before I get flamed for spreading FUD or get accused of rigging these results, let me say a few things:
- I work for Microsoft but I do not speak for Microsoft. This is my own personal blog and I have not been asked by Microsoft to share these results. I'm simply proud of the work my co-workers have done and want to share some of the amazing features in Office. Especially features that don't get a lot of attention (but are impressive nonetheless).
- Here is a link to the test file. Please feel free to run this test on your own system. Your mileage may vary.
- The test file was created to exercise the calculation engine. It was not created to represent a typical Excel file.
- The test file is made up of SUM's, divisions, IF's and VLOOKUP's because historically these are the most often used functions within Excel.
I don't believe this is a suprise to anyone who has been paying attention. Michael Meeks discussed this OpenOffice problem at Linuxworld Boston, and of course George Ou has mentioned OpenOffice performance problems in the past as well. I don't think of this as so much a weakness of OpenOffice, rather a testament to the complexity of spreadsheets and the amount of work Microsoft has put into optimizing Excel's calc engine. I just thought it might be fun to actually see the difference visually.