Issue 115877 - Excel 2003 export for formulas is broken
Summary: Excel 2003 export for formulas is broken
Status: CLOSED DUPLICATE of issue 94261
Alias: None
Product: Calc
Classification: Application
Component: save-export (show other issues)
Version: OOo 3.2.1
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: michael.brauer
QA Contact: issues@sc
Depends on:
Reported: 2010-12-02 09:20 UTC by kangarolf
Modified: 2010-12-03 12:38 UTC (History)
4 users (show)

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


Note You need to log in before you can comment on or make changes to this issue.
Description kangarolf 2010-12-02 09:20:32 UTC
When exporting a simple spreadsheet containing formulas as Excel 2003 XML the
cell references are not converted properly;

My spreadsheet has one column with three rows, 
cell 1,1 = 1, 
cell 2,1 = 2, 
cell 3 is the formula summing the first and second cells (=sum(A1:A2))

This should render out in XML as "R[-2]C:R[-1]C" but is instead

This also occurs when importing a correctly formatted XML document, the formulas
are not recognised and are instead rendered as text.
Comment 2 kangarolf 2010-12-02 09:21:36 UTC
IF the same file is imported with OO2.0 everything is fine.
Comment 3 ooo 2010-12-02 10:58:41 UTC
The Excel2003 filter uses XSLT and gets ODF 1.2+ including OpenFormula as
source (in fact the configured version), which it can't cope with. So either
a) use ODF 1.0/1.1 as source for the current XSLT, which somewhere needs
   overriding the configured ODF version for specific exports => @mib
b) use current ODF as source and adapt XSLT => @sus

I'm pretty sure this is a duplicate, can't find the the other right now.

You may workaround this if you temporarily select ODF 1.0/1.1 under
Tools->Options->Load/Save->General "ODF format version", then export the
document, and set the option back to "1.2 Extended" after.
Comment 4 kangarolf 2010-12-02 11:03:22 UTC
No I couldnt either =)
Comment 5 Regina Henschel 2010-12-02 12:03:29 UTC
It sounds like issue 94261.
Comment 6 ooo 2010-12-03 12:27:53 UTC
I meant issue 95312, that is about export to .sxc but has the same cause.
For Excel 2003 export lets use this issue here, as it concisely describes the
root cause.
Comment 7 ooo 2010-12-03 12:37:39 UTC
Bah, the other issue has votes.

*** This issue has been marked as a duplicate of 94261 ***
Comment 8 ooo 2010-12-03 12:38:05 UTC