Issue 96336 - Filtering is unacceptably slow with attached file.
Summary: Filtering is unacceptably slow with attached file.
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: OOo 3.0
Hardware: All All
: P3 Trivial with 2 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: performance
Depends on:
Reported: 2008-11-19 08:12 UTC by kpalagin
Modified: 2017-05-20 11:11 UTC (History)
1 user (show)

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

problematic file (780.23 KB, application/vnd.oasis.opendocument.spreadsheet)
2008-11-19 08:14 UTC, kpalagin
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description kpalagin 2008-11-19 08:12:58 UTC
1. Open attached file, Data - Filter - Autofilter.
2. In column B click arrow down, click any value, for example 4004 - Calc 
takes 4 minutes to provide result, which does not allow productive work.
Needless to say that competing spreadsheet filters in about two seconds.
Comment 1 kpalagin 2008-11-19 08:14:31 UTC
Created attachment 58111 [details]
problematic file
Comment 2 ooo 2008-11-19 13:59:39 UTC
Needed about 30s with my Solaris-x86 machine, but anyway, that's too slow..
Adding keyword performance.
Comment 3 bormant 2008-11-20 14:31:23 UTC
Problematic file has some cell styles in content.xml.

If we 
1) select all (Ctrl+A)and copy (Ctrl+C)
2) create new spreadsheet
3) press v (arrow down) on paste button, select "unformatted text"
4) select Separated by (*) Tab in Text import dialog, press [Ok]
5) try steps 1, 2 from initial comment
problem doesn't appear.
Comment 4 Marcus 2017-05-20 11:11:16 UTC
Reset assigne to the default "".