ODF didn't specify spreadsheet formulas until ODF 1.2, when OpenFormula was introduce. The formulas that OpenOffice (this community, not an "ODF Community") supported were in a unique OpenOffice namespace, not an ODF one.
Office 2013 and presumably 2016 support OpenFormula in ODF 1.2 Documents, just as Apache OpenOffice does. - Dennis -----Original Message----- From: BRM [mailto:[email protected]] Sent: Tuesday, September 22, 2015 08:39 To: [email protected]; [email protected] Subject: Re: MS Office support for ODF (was RE: To delete Open Office) Did Microsoft ever fix their interoperability issues with other ODF vendors? >From what I understand that is the single biggest reason for not using ODF >with MS Office - they move all formulas, etc (e.g anything that doesn't have a >formal standard regardless of support by the ODF community) into MS only >namespaces in the document, even if importing from another source. So you >AOO/LO ODS will be usable by everyone, but just open/save it using MS Office >and now everyone else only gets static values as the formulas are only >accessible to Excel. Now, it's be great if they fixed that and actually made an interoperable version; but last I heard (admittedly a few years back) they were doing extremely strict compliance to the standard and only the standard, as opposed to focusing on real interoperability which is what ODF is about. $0.02 Ben [ ... ] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
