Issue 66182 - slow update of result at bottom/right
Summary: slow update of result at bottom/right
Status: CLOSED DUPLICATE of issue 55112
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 2.0.2
Hardware: All All
: P4 Trivial (vote)
Target Milestone: ---
Assignee: carsten.driesner
QA Contact: issues@sc
Keywords: oooqa, regression
Depends on:
Reported: 2006-06-06 20:07 UTC by norbert2
Modified: 2013-08-07 15:14 UTC (History)
3 users (show)

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

test.ods (13.71 KB, application/vnd.oasis.opendocument.spreadsheet)
2006-06-11 21:22 UTC, norbert2
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description norbert2 2006-06-06 20:07:09 UTC

at the bottom/right of the calc window, there is a result displayed that (by
default) calculates the sum of the selected cells. If you change the selection
you will notice a slow update of the result. Much slower than Excel. This is
impractical. Excel updates without noticeable delay; this is like Calc should do.

(I thought this would be caused by issue 55112, but a comment there tells me to
file a separate issue.)
Comment 1 gercokees 2006-06-07 15:15:28 UTC
I tried a few things but mine is pretty fast. What exactly did you do? Is it
possible to attatch a file were the problem occurs? 
Comment 2 norbert2 2006-06-11 21:22:32 UTC
Created attachment 37056 [details]
Comment 3 norbert2 2006-06-11 21:31:18 UTC

I have attached a file that contains some values.

please ...

- open that attached spreadsheet

- hold down SHIFT

- press arrow down a few times while watching the calculated sum at the bottom
/right of the calc window (in the status bar)

On OOo 2.0.2 you will notice a slow update. For example if you want to select
cells until a defined value is reached, you have to wait after each pressing of
arrow down to wait for the calculated value to be updated.

Now try the same with OOo 1.1.5: It updates directly withoout noticeable delay.
(You don't have to wait for updated values.)

Try the same with Excel. It is as fast as OOo 1.1.5.

So this is a 1.x->2.x regression bug.

I'm still convinced that this is issue 55112.

I would like to have the fast response of OOo 1.1.5 back for OOo 2.x.
Comment 4 atdsm 2006-06-30 14:11:34 UTC
Confirmed. On my machine (Pentium4 w/ Windows XP SP2) there is a noticeable
delay between selecting the next cell in the range and the update -
approximately 1 second. It seems that OOo waits until it thinks the user is done
changing the range before bothering to recalculate the sum, rather than
recalculating at every cell change as Excel does.

Changing to P4 however, because this is a cosmetic issue with an obvious
workaround (simply wait a second for the updated sum) and it will affect
relatively few users.

Still, it would be quite nice not to have to wait for the update all the time.
Comment 5 atdsm 2006-06-30 14:13:57 UTC
Also, it seems that when you hold the shift key and click a new range, the sum
is not updated until the shift key is released. (This is a tricky one, because
if at any point you use the arrow keys in addition to clicking, then the sum
DOES update - after a second or so.)
Comment 6 norbert2 2006-07-01 12:51:08 UTC
Could someone please edit the summary to underline that this is a regression bug!?
Comment 7 atdsm 2006-07-03 13:07:16 UTC
Added "regression" keyword.

Comment 8 frank 2006-07-10 11:42:13 UTC
Hi Niklas,

one for you I think.

Comment 9 niklas.nebel 2006-07-10 17:20:13 UTC
It is the same as issue 55112. The status bar controller is updated using the
normal slot mechanism (slot SID_TABLE_CELL), and the delays are the same as for
toolbox controllers.
Comment 10 atdsm 2006-07-10 18:15:07 UTC
According to nn, this issue has the same root cause as issue 55112. Therefore, I
am marking as duplicate.

*** This issue has been marked as a duplicate of 55112 ***
Comment 11 atdsm 2006-07-10 18:16:10 UTC