Rob Weir's Doubt: MS Office 2007 ODF Compatibility?

May 06, 2009

A recent test shows that the promised Open Document Format (ODF) compatibility of Microsoft Office Service Pack 2 is far from it. At least table calculations in Excel SP2 demonstrate big problems when converting ODF values.

IBM colleague and standards activist Rob Weir tested compatibility of the free ODF documentation standard in different combinations with various office software. His conclusion: "This is a big step backwards." In a similar test beginning of March, Weir had come to more positive results, albeit with some recommendations, mainly because he had used the Sun plugin and Microsoft's own CleverAge to populate the Excel cells. In the meantime, Microsoft released MS Office 2007 SP2 that was supposed to support ODF.

So Weir tested again, this time with MS Office 2007 SP2 with integrated ODF support, and he wasn't too happy with the results. He writes in his blog, "Unfortunately this support did not fare well in my tests." Weir found that Excel SP2 stripped out formulas, leaving the previously saved values. He concluded, "In general, SP2 converts an ODF spreadsheet into a mere 'table of numbers' and any calculation logic is lost."

ODF data in Excel
ODF data in Excel after conversion.

Even table formulas exported from Excel to ODF spreadsheets presented problems. "Excel 2007 SP2 does include spreadsheet formulas but places them into an Excel namespace. This namespace is not what OpenOffice and other ODF applications use... It isn't even the OOXML namespace."

Weir's disappointment contrasts sharply with his hopefulness two months ago. In his view, technical complexity can't be the problem: "Spreadsheet interoperability is not hard. This is not rocket science... To get this wrong requires more effort than getting it right. It is especially frustrating when we know that the underlying applications support the same fundamental formula language, or something very close to it...." He doesn't want to speculate whether this is accidental or intentional, but encouraged Microsoft to remove the code from SP2 that was the source of the problem. "... I cannot fail to notice that the same application -- Microsoft Excel 2007 -- will process ODF spreadsheet documents without problems when loaded via the Sun or CleverAge plugins, but will miserably fail when using the 'improved' integrated code in Office 2007 SP2."

Related content

  • ODF Alliance: Microsoft Support for ODF is Lacking

    The Open Document Format (ODF) Alliance has analyzed whether Microsoft’s Service Pack 2 for Office 2007 fulfills the promise for compatibility with the free document standard. Their findings give little reason to hope.

    more »
  • ODF vs. CDF: Storm in a Tea Cup?

    An organization calling itself the Open Document Foundation has given rise to rumors and speculation concerning the free document standard Open Document Format, ODF, of late. Leading members of the ODF Alliance say that it would be wrong to overestimate the significance of the Open Document Foundation.

    more »
  • Gnumeric

    OpenOffice Calc is fine for most spreadsheet applications, but if you’re looking for better performance and a smaller footprint, try Calc’s lean competitor, Gnumeric.

    more »
  • New ODF Plugins for Microsoft Office

    Version 1.1 of Sun Microsystems' ODF Plugin for Microsoft’s Office suite now includes a multi-language package. A new version of the OpenXML-ODF Translator is now available for downloading from Sourceforge.

    more »
  • Office Suites

    If OpenOffice is too fat and feature-rich for your taste, try one of the office alternatives. We found much to like and much to wish for when we put six office suites to the test.

    more »

Comments

  • MS Office will never be 100% ODF compatible

    Imagine if that happens ... and most business users start migrating to ODF for all future documents -- and then migrate to OO.org! Nope, MS would never do it.
comments powered by Disqus