Issue 69301

Summary: sorting is 10x slower than Excel
Product: Calc Reporter: aziem <ahz001>
Component: editingAssignee: AOO issues mailing list <issues>
Status: ACCEPTED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues, kyoshida, www.openoffice.org
Version: OOo 2.0.3   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: ENHANCEMENT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
I sorted by column H none

Description aziem 2006-09-05 22:37:16 UTC 
Sorting the same, large spreadsheet is an order of magnitude slower in
OpenOffice.org 2.0.3 than in Excel 2000.  There should be opportunities for
optimization.

Approximate times (Windows 2000, 1GHz Intel CPU):
OpenOffice.org 2.0.3: 12 seconds
Excel 2000: 1.5 seconds

In my case, it's sorting a 40,000x20 spreadsheet by a mostly-blank text column.
 (For my case here, it's generally tolerable, but I imagine it's more serious
for other people.)
Comment 1 gercokees 2006-09-18 14:40:01 UTC 
Hi,
Can you please (if possible) attach the file where this problem occurs?
Thanks in advance...
Besides, i do thank a difference of 12 - 1,5 seconds is realy an issue...
Comment 2 aziem 2006-09-20 01:06:07 UTC 
Created attachment 39258 [details]
I sorted by column H
Comment 3 gercokees 2006-09-25 11:28:46 UTC 
Hi,
I did some tests with the attatched file, and i can confirm that excel is indeed
faster than OOo, so I confirm this issue
Comment 4 frank 2006-09-28 14:39:46 UTC 
Hi Eike,

measured 6 sec for Calc and 2 for Excel2007b2

Frank
Comment 5 ooo 2006-09-28 16:35:38 UTC 
Accepting.
Comment 6 Marcus 2017-05-20 11:13:10 UTC 
Reset assigne to the default "issues@openoffice.apache.org".