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:bm_witn...@yahoo.com.INVALID] Sent: Tuesday, September 22, 2015 08:39 To: users@openoffice.apache.org; dennis.hamil...@acm.org 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: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
