Issue 95312

Summary: Exporting to .sxc old XML file format corrupts formulas
Product: Calc Reporter: ooo
Component: save-exportAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues, marcelly.bernard, michael.brauer, svante.schubert
Version: OOo 3.0   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---

Description ooo 2008-10-22 11:42:55 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
Comment 1 ooo 2008-10-22 11:49:30 UTC 
@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
Comment 2 bmarcelly 2008-10-22 12:37:00 UTC 
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.
Comment 3 ooo 2008-11-03 11:24:59 UTC 
*** Issue 95742 has been marked as a duplicate of this issue. ***
Comment 4 michael.brauer 2008-12-19 12:26:59 UTC 
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.
Comment 5 ooo 2009-01-05 13:53:14 UTC 
@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?
Comment 6 ooo 2010-06-01 12:13:25 UTC 
@mib, @sus: ping, see previous comment #desc6
Comment 7 ooo 2010-12-03 12:28:47 UTC 
See also issue 115877 for Excel 2003 export with the same root cause.