{"id":1386,"date":"2009-04-30T20:50:21","date_gmt":"2009-04-30T19:50:21","guid":{"rendered":"http:\/\/www.itwriting.com\/blog\/1386-opendocument-comes-to-microsoft-word-and-excel.html"},"modified":"2009-04-30T20:50:21","modified_gmt":"2009-04-30T19:50:21","slug":"opendocument-comes-to-microsoft-word-and-excel","status":"publish","type":"post","link":"https:\/\/www.itwriting.com\/blog\/1386-opendocument-comes-to-microsoft-word-and-excel.html","title":{"rendered":"OpenDocument comes to Microsoft Word and Excel"},"content":{"rendered":"

After the intense interest in OOXML vs ODF during last year\u2019s ISO document standardisation wars, I\u2019m surprised that the inclusion of OpenDocument support in the newly-released Office 2007 SP2<\/a> has attracted so little attention. Well, not really surprised. The general public doesn\u2019t care much about document formats as such, just that the documents they send and receive open OK. The anti-OOXML fervour was about exploiting a chink in the armour of Microsoft’s de facto near-monopoly in Office suites.<\/p>\n

Well, Microsoft has ticked the box now. I haven\u2019t done exhaustive tests; but I did some sanity checks. I opened a .docx (OOXML) in Word, saved it as OpenDocument Text; opened in OpenOffice.org, saved it out to a new .odt document, opened that in Word, saved it out as docx. And you know what? It looks the same. Even the styles are still there. What\u2019s more the conversion was fast and convenient, just a Save As. All in all, a contrast with the wretched experience<\/a> I had with the earlier Microsoft-sponsored converter.<\/p>\n

Next, I tried a small stress-test; a .doc bidding card for Contract Bridge that has some tricky tables. This document crashed WordPerfect\u2019s .odt converter. Word could happily save it as .odt and reopen. Opening the exported .odt in OpenOffice showed some minor differences \u2013 part of the table went slightly out of alignment, as the illustration shows (Word is on the left, OpenOffice 3.0 on the right), but nothing drastic.<\/p>\n

<\/p>\n

Is this the end of the format wars? Not quite; there is still a long list of features not supported by the conversion, and if you want an easy life it still pays to stay with one vendor\u2019s Office suite. My impression though is that Microsoft has done a decent job, and that for everyday documents the conversion will work as expected.<\/p>\n

For the OpenDocument crowd, getting the format incorporated into Microsoft Office is a victory of sorts, but not the real goal, which is to establish it as the universal document format. Microsoft is betting that its inclusion will help it sell Office, but that customers will still mostly use .doc or .docx (and the Excel equivalents). If enough institutions mandate OpenDocument, that bet could yet fail, but right now that looks unlikely.<\/p>\n

Update<\/strong><\/p>\n

Ivan Zlatev reports on a less successful import here<\/a>.<\/p>\n

Update 2<\/strong><\/p>\n

While word processing import and export is reasonable in some circumstances, there is a deal-breaking problem with spreadsheet import and export: all formulae are either ignored or broken. That is, you can save from Excel to .ods, open in OpenOffice.org Calc, and get cells like msoxl:=SUM(C6:C8) (in plain text). You can save from OpenOffice.org Calc, open in Excel, and find formulae converted to plain text. If you save and open sheets from Excel, but in .ods format, it works; the clue why is in the OpenOffice.org rendering. It appears Microsoft has stuck by the letter of the standard, which does not specify how formulae work, but broken any kind of meaningful interoperability.<\/p>\n

Technorati Tags: microsoft office<\/a>,opendocument<\/a>,xml<\/a>,ooxml<\/a>,odt<\/a><\/div>\n","protected":false},"excerpt":{"rendered":"

After the intense interest in OOXML vs ODF during last year\u2019s ISO document standardisation wars, I\u2019m surprised that the inclusion of OpenDocument support in the newly-released Office 2007 SP2 has attracted so little attention. Well, not really surprised. The general public doesn\u2019t care much about document formats as such, just that the documents they send … Continue reading OpenDocument comes to Microsoft Word and Excel<\/span> →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[55,62,101],"tags":[],"class_list":["post-1386","post","type-post","status-publish","format-standard","hentry","category-microsoft","category-open-source","category-xml"],"_links":{"self":[{"href":"https:\/\/www.itwriting.com\/blog\/wp-json\/wp\/v2\/posts\/1386","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.itwriting.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.itwriting.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.itwriting.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.itwriting.com\/blog\/wp-json\/wp\/v2\/comments?post=1386"}],"version-history":[{"count":0,"href":"https:\/\/www.itwriting.com\/blog\/wp-json\/wp\/v2\/posts\/1386\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.itwriting.com\/blog\/wp-json\/wp\/v2\/media?parent=1386"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.itwriting.com\/blog\/wp-json\/wp\/v2\/categories?post=1386"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.itwriting.com\/blog\/wp-json\/wp\/v2\/tags?post=1386"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}