Issue 66182

Summary:

slow update of result at bottom/right

Product:

Calc

Reporter:

norbert2 <norbert.notz>

Component:

code

Assignee:

carsten.driesner

Status:

CLOSED DUPLICATE

QA Contact:

issues@sc <issues>

Severity:

Trivial

Priority:

CC:

gercokees, issues, steve.m.frank

Version:

OOo 2.0.2

Keywords:

oooqa, regression

Target Milestone:

---

Hardware:

All

OS:

All

Issue Type:

DEFECT

Latest Confirmation in:

---

Developer Difficulty:

---

Attachments:

Description	Flags
test.ods	none

Description norbert2 2006-06-06 20:07:09 UTC

hi.

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]
test.ods

Comment 3 norbert2 2006-06-11 21:31:18 UTC

Hi.

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.

Steve

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

Hi Niklas,

one for you I think.

Frank

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

Closing.