Issue 105189 - Filter rows with notes: extremely slow
Summary: Filter rows with notes: extremely slow
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: DEV300m59
Hardware: PC All
: P2 Trivial with 6 votes (vote)
Target Milestone: ---
Assignee: daniel.rentz
QA Contact: issues@sc
Keywords: oooqa, regression
Depends on:
Reported: 2009-09-18 20:28 UTC by pmike
Modified: 2011-02-16 18:29 UTC (History)
2 users (show)

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

sample (16.50 KB, application/vnd.oasis.opendocument.spreadsheet)
2009-09-18 20:28 UTC, pmike
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description pmike 2009-09-18 20:28:12 UTC
open attached file and filter column B, select "Text 1"
filtering is VERY slow

this is a regression from 3.0.x (it filters fast).

PS. please consider as P2, OOo 3.2 tends to be much faster than 3.1.x
Comment 1 pmike 2009-09-18 20:28:39 UTC
Created attachment 64848 [details]
Comment 2 Rainer Bielefeld 2009-09-22 07:08:47 UTC
I checked "FilterNoteSample.ods" with "Ooo 3.1.1 WIN XP DE-multilingual version
German UI activated [OOO310m19 (Build 9420)]" and can confirm the reported
effect, filtering rows with notes is incredible slow, it takes several minutes
(I did not wait until the end).

Same problem with standard filter.

I also checked with "2.4.1  Multilingual version German UI WIN XP:
[680m17(Build9310)]", here everything works fin, filtering as reported takes
much less than 1 second.

Pls. specify your OS!
Comment 3 oc 2009-09-22 13:56:41 UTC
Hi Daniel, please have a look
Comment 4 pmike 2009-09-22 18:19:36 UTC
rainerbielefeld: Linux and Windows
Comment 5 niklas.nebel 2011-02-16 18:29:06 UTC
In 3.3, with the changes for issue 116164, it takes 2 seconds for the first
filter selection, less than a second for following selections. The 2 seconds are
caused by creating the caption objects, for which issue 107216 is open. The
specific problems with filtering no longer occur, so this issue can be closed.
Comment 6 niklas.nebel 2011-02-16 18:29:34 UTC