Rob Weir's Doubt: MS Office 2007 ODF Compatibility?
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."
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."
Comments
comments powered by DisqusSubscribe to our Linux Newsletters
Find Linux and Open Source Jobs
Subscribe to our ADMIN Newsletters
Support Our Work
Linux Magazine content is made possible with support from readers like you. Please consider contributing when you’ve found an article to be beneficial.
News
-
Gnome 47.1 Released with a Few Fixes
The latest release of the Gnome desktop is all about fixing a few nagging issues and not about bringing new features into the mix.
-
System76 Unveils an Ampere-Powered Thelio Desktop
If you're looking for a new desktop system for developing autonomous driving and software-defined vehicle solutions. System76 has you covered.
-
VirtualBox 7.1.4 Includes Initial Support for Linux kernel 6.12
The latest version of VirtualBox has arrived and it not only adds initial support for kernel 6.12 but another feature that will make using the virtual machine tool much easier.
-
New Slimbook EVO with Raw AMD Ryzen Power
If you're looking for serious power in a 14" ultrabook that is powered by Linux, Slimbook has just the thing for you.
-
The Gnome Foundation Struggling to Stay Afloat
The foundation behind the Gnome desktop environment is having to go through some serious belt-tightening due to continued financial problems.
-
Thousands of Linux Servers Infected with Stealth Malware Since 2021
Perfctl is capable of remaining undetected, which makes it dangerous and hard to mitigate.
-
Halcyon Creates Anti-Ransomware Protection for Linux
As more Linux systems are targeted by ransomware, Halcyon is stepping up its protection.
-
Valve and Arch Linux Announce Collaboration
Valve and Arch have come together for two projects that will have a serious impact on the Linux distribution.
-
Hacker Successfully Runs Linux on a CPU from the Early ‘70s
From the office of "Look what I can do," Dmitry Grinberg was able to get Linux running on a processor that was created in 1971.
-
OSI and LPI Form Strategic Alliance
With a goal of strengthening Linux and open source communities, this new alliance aims to nurture the growth of more highly skilled professionals.
MS Office will never be 100% ODF compatible