Apache OpenOffice (AOO) Bugzilla – Issue 84689
Unacceptably long sort times
Last modified: 2013-08-07 15:14:13 UTC
A Calc document has 31 columns and some 19000 rows, populated exclusively by strings. Sorting this document takes only some 5 seconds (probably less), regardless of sort key. If the same document contains conditional formatting, the sort takes roughly 25 minutes, uses 100% of one CPU, and locks out all other OpenOffice activities. There are two different conditional variations: 1) Formula is: LEN(X1)=0: Cell Style: Unknown (which sets Font color, Bold, Italic). Affected cell is A1. This condition is applied to one column only. 2) Formula is: G1<>" ": Cell Style: Verified (which sets Font color). Affected cell is H1. This condition is applied to 5 column pairs. I no longer remember when this problem was first seen, but possibly when OpenOffice level 2 was introduced.
Created attachment 50409 [details] Zip-ed files PRFILE (cond.format) and PRFILEX (plain)
Confirming using 2.4m241 on WinXP - as described. For example, sorting by column W takes 20 minutes with conitional formatting and several seconds without one.
*** Issue 80932 has been marked as a duplicate of this issue. ***
Additional observations: 1) Having done a Select All of a conditionally formatted sheet, a Copy operation takes "no time", but a Cut operation takes several minutes. Even a Paste operation takes quite some time. 2) As above, a Delete Contents / Delete all operation takes several minuts (probably the same operation as a Cut).
Fixed on CWS "dr58".
(That was fast! If only issues 55266 and 18728 could be resolved that fast too)
forgot to reassign
back to QA for verification
verified in internal version cws_dr58
This issue is closed automatically and wasn't rechecked in a current version of OOo. The fixed issue should be integrated in OOo since more than half a year. If you think this issue isn't fixed in a current version (OOo 3.1), please reopen it and change the field 'Target Milestone' accordingly. If you want to download a current version of OOo => http://download.openoffice.org/index.html If you want to know more about the handling of fixed/verified issues => http://wiki.services.openoffice.org/wiki/Handle_fixed_verified_issues
I've been experiencing this problem since version 3.1.0. I read this issue and issue 103023 but this problem is not still fixed on current version (3.1.1). So i ask for reopening this issue. I've installed OOo 3.1.1 on brand new PCs, first time install, and this problem still occurs here and on every computer of my network. Several people here are using large spreadsheets and sorting a bunch of rows takes a long time, several seconds in the better case. I have a number of computers here so i can test the problem in different conditions: fresh installations, reinstalls, upgrades, etc. All installations of OO 3.1.0 and 3.1.1 show the problem, version 3.0.1 instead doesn't. Something has changed in relation to the sorting feature with the 3.1.x branch and the problem is not trivial for productivity, especially in a enterprise environment. Please, it's apposite to make some checks about this and reopen this issue.
cianoz, sort with both files from attached PRFILEX.zip is fast in m56. Please check your files with recent dev build. If you still get slow sort then please open new issue and include kpalagin in CC. Thanks®ards, KP.