https://issues.apache.org/ooo/show_bug.cgi?id=124625
Rainer Bielefeld <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |CONFIRMED Version|4.1.0-beta |OOo 3.3 or older Summary|.xls broken with |large row numbers exceeding |SUM($Sheet1.A1:A65537) | .xls limit become | |unpredictable broken row | |numbers in .xls Ever confirmed|0 |1 --- Comment #6 from Rainer Bielefeld <[email protected]> --- Excel Specifications can be found here: <http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP005199291.aspx>: Maximum limit 65536 rows by 256 columns (a) If I save a document with contents in rows 65536 or bigger I get a warning "too many rows for target format". That warning is missing in LibO, AOO does it better (b) No concrete message if only a reference in a formula has a too large row number (c) The problem is not limited to SUM. Also in Additions seem to be broken (d) Currently I am not 100% sure, but it seems that export to .xls breaks Numbering in a crazy way. A row number 100 000 will be shown as 34464 (what is the difference betwene 100 000 and excel limit 65536 rows, But the correct looking "Tabelle1.A34464)" does not work before I replace a digit with the same digit typed manually (e) There also is a problem with simple references to large row numbers: "=Tabelle1.A65535" ub .ods becomes =$#REF!.IW65535 in exported .xls what might be related (f) I think too big row numbers simply should be cut to .xls maximum. (g) similar problems (but with different details in some cases) already with OOo 3.3.0 This research still is rather incomplete, not "ready for fixing", but I currently do not have the time to continue. -- You are receiving this mail because: You are the assignee for the issue. You are watching all issue changes.
