To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=106083 Issue #|106083 Summary|Error message "too many rows" when saving XLS file wit |h new file name (save as) Component|Spreadsheet Version|1.0.0 Platform|All URL| OS/Version|All Status|NEW Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|save-export Assigned to|dr Reported by|ja
------- Additional comments from j...@openoffice.org Tue Oct 20 10:55:11 +0000 2009 ------- All documents mentioned within this issue have been provided directly to Daniel Renz. I cannot add them because they're confidential The document is a XLS file, this file generate an error message (second file) when saving the document. To reproduce the problem : 1. open the file 2. save it as 3. In the dialog, choose a name and type it 4. don't change the format!!! 5. confirm saving by clicking on the "save" button in the dialog You get the error message (see screenshot provided) Root cause are the print ranges on second and following sheets. These are defined to span the whole sheet area (65536 rows, 256 columns, A1:IV65536) in Excel. On import into Calc, these ranges are expanded to Calc's full sheet area (1024 columns, A1:AMJ65536). The export filter does not shrink them accordingly but detects a cell range overflow and thus shows a warning. --------------------------------------------------------------------- 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org