Issue 123796 - Setting/unsetting auto filter takes more than 2 minutes
Summary: Setting/unsetting auto filter takes more than 2 minutes
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: 4.1.0-dev
Hardware: PC All
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2013-12-02 16:35 UTC by Gunter
Modified: 2013-12-03 14:46 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
one column ods file for filter test. (199.33 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-12-02 16:35 UTC, Gunter 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description Gunter 2013-12-02 16:35:30 UTC 
Created attachment 82025 [details]
one column ods file for filter test.

I imported a 50.000 line csv file which took about 5 Minutes (compared to excel: less than 3 Seconds!).

I stored as ods file. Trying to apply a filter takes again more than 2 minutes. Seems to be a problem with the data in the cells. This is probably the same issue during import of file.

Opening the file takes a lot of calculation. This is only text to my understanding.

Attached is example file.
Comment 1 Edwin Sharp 2013-12-02 19:54:13 UTC 
2 minutes 34 seconds for auto filter.

AOO410m1(Build:9750)  -  Rev. 1539999
2013-11-09_04:08:11 - Rev. 1540252
Debian

Host/Kernel/OS  "aptosidbox" running Linux 3.12-0.slh.3-aptosid-amd64 x86_64 [ aptosid 2013-01 Ἑσπερίδες - kde-lite - (201305050307) ]
CPU Info        2x AMD Athlon II X2 250 clocked at [ 1800.000 MHz ]
Videocard       Advanced Micro Devices, [AMD/ATI] Cedar [Radeon HD 5000/6000/7350/8350 Series]     [  ]
Processes 127 | Uptime 13:11 | Memory 552.4/3960.1MB | HDD Size 500GB (1%used) | Client Shell | Infobash v3.46
Comment 2 Oliver Brinzing 2013-12-03 14:46:47 UTC 
.