Issue 75877 - Slow reaction in Conditional Formatting
Summary: Slow reaction in Conditional Formatting
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 2.2
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
: 76880 (view as issue list)
Depends on:
Blocks:
 
Reported: 2007-03-29 19:09 UTC by patwwh
Modified: 2017-05-20 11:13 UTC (History)
3 users (show)

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

Attachments
Demo (52.50 KB, application/vnd.ms-excel)
2007-03-29 19:11 UTC, patwwh 		no flags Details
cond-format.ods (63.91 KB, application/vnd.oasis.opendocument.spreadsheet)
2007-06-04 09:50 UTC, gercokees 		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 patwwh 2007-03-29 19:09:53 UTC 
When compared with MS Excel, Calc's algorithm for conditional formatting seems
abnormally slower. Please see attachment. When you pull the scroll bar inside,
the color will be changed slowly in Calc, but very very quick in MS Excel.
Comment 1 patwwh 2007-03-29 19:11:16 UTC 
Created attachment 44026 [details]
Demo
Comment 2 kpalagin 2007-03-30 14:19:39 UTC 
Confirming - Calc is substantially slower than competitor when I move 
scrollbar slider.
Comment 3 gercokees 2007-05-22 07:51:27 UTC 
*** Issue 76880 has been marked as a duplicate of this issue. ***
Comment 4 gercokees 2007-05-22 07:52:15 UTC 
According to Issue 75877 this might be a regression bug.
Comment 5 gercokees 2007-06-04 09:49:49 UTC 
Hi all,
I did some further testing on this one.
Please download my cond-formating.ods and try the following:

OOo 2.2.0   change the value in cell A4
            notice that updating the view takes some time: approx    12 sec (may
vary)
            now, delete the view-split: Window > Freeze (uncheck)
            change the value in cell A4
            notice that updating the view takes less time: approx     1 sec	
            now, split the window again (in cell D4)
            change the value in cell A4
            updating takes now:                                      1 sec
            save the file
            change the value in cell A4: updating takes now:        12 sec


OOo 2.1.0   repeat above procedure
            updating will not exceed approx                            1 sec

Because performance in 2.1 was better than in 2.2 i mark this issue as a defect
*and* a regression

Greetz
Comment 6 gercokees 2007-06-04 09:50:45 UTC 
Created attachment 45631 [details]
cond-format.ods
Comment 7 frank 2007-06-26 15:51:21 UTC 
Hi Niklas,

checked it with the second attachment and even with cws aw046 it takes
measureable longer to change the formats with freeze set compared to a document
wihout window-freeze.

Frank
Comment 8 Martin Hollmichel 2007-11-09 16:53:01 UTC 
change target from 2.x to 3.x according to
http://wiki.services.openoffice.org/wiki/Target_3x
Comment 9 gercokees 2007-11-12 08:43:46 UTC 
According to
http://wiki.services.openoffice.org/wiki/Target_3x
Regressions should not be moved.....
Comment 10 Martin Hollmichel 2007-11-12 14:07:48 UTC 
you're right, sorry this was an oversight.
Comment 11 gercokees 2007-11-12 14:10:11 UTC 
no problem ;-)
Comment 12 niklas.nebel 2008-01-09 19:55:32 UTC 
The problem with cond-format.ods is related to issue 75877, and not the same as
with Vertex42 gantt-chart-template-MF.xls, which this issue should cover.
Adjusting target and flags.
Comment 13 niklas.nebel 2008-01-09 20:07:44 UTC 
"related to issue 84689", the previous comment should read.
Comment 14 Marcus 2017-05-20 11:13:43 UTC 
Reset assigne to the default "issues@openoffice.apache.org".