Issue 123796 - Setting/unsetting auto filter takes more than 2 minutes
Summary: Setting/unsetting auto filter takes more than 2 minutes
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:
Depends on:
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: ---

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

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

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