Date: prev next · Thread: first prev next last
2011 Archives by date, by thread · List index

I don't find it credible that Microsoft would intentionally deviate in ways to "break" a format, 
considering the level of scrutiny they receive from regulatory authorities and everyone else.

I find it more creditable that they didn't do a terrific job in their first effort and it might not 
have been something the developers were keen about.  But I have no way of knowing nor of knowing 
the difficulties there are for mapping in and out of their own internal processing model.  They 
obviously can't support a feature that the native application can't support (as is the case for 
LibreOffice as well, of course).

In any case, Microsoft produced public implementation notes about their support for ODF 1.1 in 
Office 2007 (it was SP2, not the SP1 I mentioned in another message).  There are also 
implementation notes for Office 2010 support of ODF (and OOXML, etc.).
My old links to the Implementation Notes failed me yesterday, but I've now learned that they've 
moved!  (Deep linking into, even searching into, is one of my more 
frustrating experiences.)

Here is relevant information for those interested in the details:

 is a December 2008 blog post about the original implementation notes and their purpose.  (There 
are similar notes for OOXML.)

<> explains the 
change in location and format.

The actual notes are here:
You can get a PDF or you can get a Zip that has *all* of the Microsoft Office standards 
implementations and also disclosure of the formats, etc.  There are two versions of the notes for 
ODF, one for Office 2007, one for Office 2010.

What I'd like to point out about these implementation notes is (1) they are a fledgling effort and 
could use a lot more work too, but (2) these seem to be the only ODF implementation notes that 
*anyone* has ever produced.  They are nailed to the ODF specification. 

 - Dennis


On the web site you can explore the implementation notes for Office 2010 ODF on-line.

If you go into 2 Conformance Statements in the sidebar contents, you can then go into 2.1 Normative 

If you get to 2.1.209 Section 8.1.3, Table Cell, you'll see that table:formula is not supported in 
table cells of Word documents (and I suspect the same is true for LibreOffice Write document).  
(The table:formula attribute is an optional attribute on any ODF table cell.)

Here is the text about table:formula for Excel 2010:

"iii. The standard defines the attribute table:formula, contained within the element 
<table:table-cell>, contained within the parent element <office:spreadsheet \ table:table-row>

"This attribute is supported in core Excel 2010.

"When saving the table:formula attribute, Excel 2010 precedes the formula string with the "msoxl" 

"When saving the table:formula attribute, Excel 2010 saves a formula string that follows 
[ISO/IEC-29500-1] section 18.17, except workbook-names are written as literal values instead of 
tokens given the lack of a relationship part.

"When loading the attribute table:formula, Excel 2010 first looks at the namespace. If the 
namespace is “msoxl”, Excel 2010 will load the value of table:formula as a formula in Excel 2010.

"When loading the table:formula attribute, if the namespace is missing or unknown, the 
table:formula attribute is not loaded, and the value “office:value” is used instead. If the result 
of the formula is an error, Excel 2010 loads the <text:p> element and maps the element to an Error 
data type. Error data types that Excel 2010 does not support are mapped to #VALUE!"

Note that the formula syntax and semantics used is defined in the OOXML standard (IS 29500).

-----Original Message-----
From: e-letter [] 
Sent: Friday, July 22, 2011 07:33
Subject: Re: [tdf-discuss] ignore m$ legacy?

On 21/07/2011, Dennis E. Hamilton <> wrote:
Yes, don't confuse ODF compatibility with (or LibreOffice)
compatibility.  I was in the room on one occasion when Microsoft was asking
for advice on their approach to ODF 1.1 Spreadsheet documents.

Unfortunately, none of us blinked about how this would work for users who
are unaware that ODF 1.1 has no standard for calculation formulas but think
that Calc is the standard.

I don't believe that ODF support was "broken."  The ODF support in Office
2007 is the first time that integrated ODF support appeared in Microsoft
Office.  I know there are bugs, some of them rather

Or deliberate..?

[ ... ]

Unsubscribe instructions: E-mail to
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.