Apache OpenOffice (AOO) Bugzilla – Issue 95312
Exporting to .sxc old XML file format corrupts formulas
Last modified: 2013-08-07 15:13:10 UTC
This is a follow-up issue on issue 92530#desc13 When exporting to .sxc old XML file format and converting through ODF 1.2 the function names written in the new 'of' namespace are not converted to the old names. Sample documents available attached to issue 92530 as http://www.openoffice.org/nonav/issues/showattachment.cgi/57379/ODFoptionbug.zip
@sus: Are there plans to enhance the ODF -> old XML converter to adapt to ODF 1.2 and recognize the new 'of' namespace and convert function names? @mib: Are there plans to always write ODF 1.1 when saving to .sxc? This would be much easier than adapting the converter, and also other features may be affected as well that are not properly converted from ODF 1.2
Another consequence: Existing Calc document stored in old sxc format. Open it with OOo 3.0.0, modify, save (not save as). The modified document is no longer correctly loaded in any OOo version.
*** Issue 95742 has been marked as a duplicate of this issue. ***
Writing ODF 1.1 when a conversion to SX? is done seems to be very reasonable, and I'm surprised that this is not done. Seems to be a bug to me. Unfortunately I don't know hoe the ODEF export is configured to store ODF 1.2 or ODF 1.1, and therefore don't know how this bug can be resolved.
@mib: the implementation of XExporter::setSourceDocument() simply uses the SvtSaveOptions::ODFDefaultVersion enum obtained via SvXMLExport::getDefaultVersion() to set the formula version, so once the value from the configuration is initially overridden for .sx? export everything should be fine. Who should this issue be assigned to?
@mib, @sus: ping, see previous comment #desc6
See also issue 115877 for Excel 2003 export with the same root cause.