Apache OpenOffice (AOO) Bugzilla – Issue 111780
export excel 2003 xml generates massive quantities of "Index" records, can't save medium-size spreadsheets
Last modified: 2013-01-29 21:39:27 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...
Created attachment 69579 [details] budget.xls - medium-size spreadsheet
Created attachment 69580 [details] untitled 6.xml - exported from OOO 3.2.0
With DEV300m77 on WinXP I get an "cannot be saved" error message, both with general setting "ODF1.2" and "ODF1.1".
appears to be fixed in 3.2.1. don't know how to close this bug as fixed.
I was incorrect, this bug is not fixed with 2003 XML files. calc still hangs on a complicated spreadsheet.