To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=111780 Issue #|111780 Summary|export excel 2003 xml generates massive quantities of |"Index" records, can't save medium-size spreadsheets Component|Spreadsheet Version|OOo 3.2 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|save-export Assigned to|spreadsheet Reported by|jmichae3
------- Additional comments from [email protected] Sun May 23 05:31:39 +0000 2010 ------- 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... --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
