Issue 95312 - Exporting to .sxc old XML file format corrupts formulas
Summary: Exporting to .sxc old XML file format corrupts formulas
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: save-export (show other issues)
Version: OOo 3.0
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
: 95742 (view as issue list)
Depends on:
Blocks:
 
Reported: 2008-10-22 11:42 UTC by ooo
Modified: 2013-08-07 15:13 UTC (History)
4 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
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.