To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=89976





------- Additional comments from [EMAIL PROTECTED] Tue May 27 20:42:58 +0000 
2008 -------
In the meantime I am pretty convinced that it is not very likely to open and
work with the initially attached spreadsheet. IF Calc uses a naive algorithm to
update downstream cells that have changed, than the worst-case scenario involves
sorting a number of 6.6 million times a column of 65,536 elements. This will
take a huge amount of time.

Therefore, I will attach a 2nd spreadsheet, with the C-column unfilled (except
for the first 3 cells). Everyone can now fill as many cells in the C-column as
he wishes. Filling the first 1,000 is likely to happen in real-time, filling the
first 10,000 will take some time on slower computers (like mine), filling 30,000
cells will likely take quite long even on a fast PC, and filling ALL 65,535
cells will take some ages. ;-)

[I anticipate that the operation behaves like O(n^2) or worse, so for every
additional cell in column C, the time increases quite significantly.]

I added further comments in the spreadsheet. Please read them carefully.
Especially interesting is the fact that Calc will display at some point in time:
"Adapt row height" and this takes quite some time, even ore than probably the
sort proper.

---------------------------------------------------------------------
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]

Reply via email to