Issue 111780 - export excel 2003 xml generates massive quantities of "Index" records, can't save medium-size spreadsheets
Summary: export excel 2003 xml generates massive quantities of "Index" records, can't ...
Alias: None
Product: Calc
Classification: Application
Component: save-export (show other issues)
Version: OOo 3.2
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: oooqa
Depends on:
Reported: 2010-05-23 06:31 UTC by jmichae3
Modified: 2013-01-29 21:39 UTC (History)
2 users (show)

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

budget.xls - medium-size spreadsheet (76.00 KB, application/
2010-05-23 06:33 UTC, jmichae3
no flags Details
untitled 6.xml - exported from OOO 3.2.0 (4.12 KB, text/xml)
2010-05-23 06:35 UTC, jmichae3
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description jmichae3 2010-05-23 06:31:39 UTC
OOo 3.2.0 currently inserts about 7-15+ cell "Index" datum per
formula cell, if I am understanding what I am seeing correctly.

Issue 111666 3.2.0 (the new version) can't save budget.xls calc file
as Excel 2003 xml, export is now broken (or trying my budget spreadsheet is a
new problem I've discovered).  complicated 1-sheet spreadsheets (300-row) don't
export either.  simpler spreadsheets with only 4 entries do export, but they are
larger than they should be.  

result: 32-bit 4GB limit problem (possibly) and depending on size, error message
"Can't write". I have 300GB of disk space and no way it was coming close to that
- that would take days of writing.  but that's only a symptom of the real issue
here.  I think the root cause is the algorithm that exports these massive (7-299
index records per datum/formula) quantities of singleton Index records/rows into
the XML file.

example "index record" (there are LOTS of these for every formula and datum)
<Row ss:Height="12.8376"><Cell ss:Index="11"/></Row>  (the index number changes)
in the file, which is not necessary.  

this issue alone may be causing the "gigantic file" issue with my budget
spreadsheet, which has about 20 tabs and not a lot of data on most tabs.

I think it is this excessive cell style data is what is causing my larger
500-line spreadsheets to fail to save as XML files.

each index record has its own surrounding <Row ...> </Row> elements.  so as you
can imagine, with
7-299 of these for every formula cell it gets very big very quickly.
this is supposed to be a sparse matrix walk I thought...
Comment 1 jmichae3 2010-05-23 06:33:38 UTC
Created attachment 69579 [details]
budget.xls - medium-size spreadsheet
Comment 2 jmichae3 2010-05-23 06:35:03 UTC
Created attachment 69580 [details]
untitled 6.xml - exported from OOO 3.2.0
Comment 3 Regina Henschel 2010-05-23 11:38:32 UTC
With DEV300m77 on WinXP I get an "cannot be saved" error message, both with
general setting "ODF1.2" and "ODF1.1".
Comment 4 jmichae3 2010-11-28 05:05:04 UTC
appears to be fixed in 3.2.1.  don't know how to close this bug as fixed.
Comment 5 jmichae3 2011-01-08 01:58:35 UTC
I was incorrect, this bug is not fixed with 2003 XML files.  calc still hangs on
a complicated spreadsheet.