To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=115576 Issue #|115576 Summary|Calc !sucks! (sry) at data sets with many rows Component|Spreadsheet Version|OOO320m19 Platform|Unknown URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|editing Assigned to|spreadsheet Reported by|stgries
------- Additional comments from [email protected] Sun Nov 14 19:02:59 +0000 2010 ------- OS: Ubuntu 10.10 64 bit, updated and everything, 3GB RAM OpenOffice.org 3.2.1; OOO320m19 (Build:9505); ooo-build 3.2.1.4, Ubuntu package 1:3.2.1-7ubuntu1 I have a spreadsheet which is fairly big: 35.7MB as an ods: 6 columns and approx. 580000 rows. The first row contains the header and Columns C and D contain a filename (just the basename such as "ep-00-01-17.txt") and an integer number (not larger than 10000). Not only does it take quite some time to load, but it can also not be processed properly. Case in point: I entered - into E2: 1 - into E3: =IF(C3<>C2,1,IF(D2+1=D3,E2,E2+1)) and then double-clicked on the lower-right corner to have Calc go through the column and fill in the remaining cells in column E. Thing is, wtf, IT CAN'T DO IT!! (Same on Windows 7) What's the point of having a spreadsheet software claiming to be able to handle 1m rows if one can't even use 60% of that in a not overwhelmingly large table with 3GB of RAM??? --------------------------------------------------------------------- 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]
