Issue 94261

Created attachment 57014 [details]
simple example of sum excel xml 2003

I see the error in German OOo3.0RC3. But is was already there in OOoDEV300m29. I
see it also in DEV300m20, but that is my own build, so I'm not sure. It is OK in
OOo2.4.1.

Hi Daniel,

I know 2k3 xml filters are developed by sus but afaik he didn't changed anything
for for OOo3. So please have a look at this one.

frank

Created attachment 57118 [details]
new example created with OOO 3 RC4

the new example created with the last release candidate OOO 3 RC4 shows that the
code for the sum formula written in the file in excel 2003 xml format  is the
same that is written in the ods format ->  of:]=SUM([.A1:.A3])

What you see are problems with the new namespace, which is needed for ODFv1.2.

To solve the problem for _export_, go to Tools > Options > Load/Save > General
and set the ODF format version to 1.0/1.1. If you now export the spreadsheet to
the Excel 2003 XML format, you will get correct formulas.

But this setting does not solve the import error.

excel xml 2003 file with AVERAGE() function will do the same thing. adds an
extra right peren.  I am pretty sure you will find that all functions will do this.
result in OOo3.0.0 is a formula =AVERAGE(A1:A2])) and resulting #NAME?

Created attachment 57398 [details]
new example with other formulas created with OOO 3.0

This issue occurs in ja locale in OOo 3.0.
Please see the attached screenshot.

Created attachment 57490 [details]
screenshot for SUM in Excel and Calc

Created attachment 57492 [details]
Excel SpreadSheet 2003 xml file with Japanese

*** Issue 95733 has been marked as a duplicate of this issue. ***

retargeted due to 3.1 deadline

*** Issue 96018 has been marked as a duplicate of this issue. ***

new target, this file format is not very important

The problem that I had with this issue seems to be fixed in OOo3.1.1 for
windows.  Is anyone still seeing this issue?

After discussion with other OOo users, let me clarify what works and what does
not work with Excel 2003 xml files and OOo calc.

READING an Excel 2003 xml file seems to work in OOo 3.1.1 (310m19 Build:9420).

WRITING an Excel 2003 xml file does NOT work and results in a corrupt file.
Regina's work around (set the ODF format version to 1.0/1.1) does write good
files, but this work around is annoying and confusing for casual users.

dr: while this format may not be "very important" in terms of total usage, for
those of us who have applications that read and write this format, it is
critical to have this working before we can recommend OOo to our users.

I see no error in OOo3.2.0 (Build 9483). Thanks.

*** Issue 115812 has been marked as a duplicate of this issue. ***

The error is still there in DEV300m93 on WinXP.

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 propose a)

See also issue 95312 for .sxc export.

*** Issue 115877 has been marked as a duplicate of this issue. ***

mib->er: I'm not responsible for the XSLTFilterAdapter. That's sus.

But actually, I could imagine that it is easier to correct the Excel export XSLT
than to add an option to the XSLTFilterAdapter that allows to select the ODF
version to use for all such filters individually.

This was changed to P4 on 2011-01-13, apparently the change was lost when moving to the new infrastructure.

(In reply to sethnakht from comment #1)
> Created attachment 57014 [details]
> simple example of sum excel xml 2003

This file opens perfectly in the latest Git.

However the topic of this bug changed, to the issue in exporting cell references to the MS Office 2003 SpreadsheetML format, and that belongs in the "save-export" component, not "open-import".