Issue 96336 - Filtering is unacceptably slow with attached file.
Summary: Filtering is unacceptably slow with attached file.
Status: CONFIRMED
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:
URL:
Keywords: performance
Depends on:
Blocks:
 
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: ---

Attachments
problematic file (780.23 KB, application/vnd.oasis.opendocument.spreadsheet)
2008-11-19 08:14 UTC, kpalagin 		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 kpalagin 2008-11-19 08:12:58 UTC 
Repro:
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 "issues@openoffice.apache.org".