Issue 55468 - Regression: Poor responsiveness with certain spreadsheet
Summary: Regression: Poor responsiveness with certain spreadsheet
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: 680m130
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
: 55467 (view as issue list)
Depends on:
Reported: 2005-10-04 21:03 UTC by rlk
Modified: 2017-05-20 11:13 UTC (History)
1 user (show)

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

Spreadsheet referenced in the issue (696.20 KB, application/vnd.sun.xml.calc)
2005-10-04 21:07 UTC, rlk
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description rlk 2005-10-04 21:03:09 UTC
I have a certain spreadsheet for which entering data is very slow (it takes
approximately 30 seconds to enter data into the spreadsheet on a 1 GHz PIII on
OOo 2.0.0rc).  For example, type 0<enter> into the freshly opened spreadsheet. 
On 1.1.5, it takes about 7 seconds (hence the regression).

Note: I *strongly* suggest opening this spreadsheet with automatic recalculation
turned off -- you may find that with automatic calculation turned on this
spreadsheet never successfully opens at all; it keeps recalculating and never
finishes before something or other starts it off again.
Comment 1 rlk 2005-10-04 21:07:16 UTC
Created attachment 30121 [details]
Spreadsheet referenced in the issue
Comment 2 frank 2005-10-04 22:43:16 UTC
*** Issue 55467 has been marked as a duplicate of this issue. ***
Comment 3 frank 2005-10-05 09:49:25 UTC
Hi Niklas,

please have a look at this one.

Comment 4 niklas.nebel 2005-10-06 16:43:39 UTC
I don't see such a large difference. I get 5 seconds in 1.1.5, 11 seconds in
2.0. Most of the time is spent in the loop in ScBroadcastAreaSlot::AreaBroadcast
(used to be SvPtrArr, now std::set). This is also called once after loading, so
it affects loading performance, too.
Comment 5 rlk 2005-10-06 17:41:49 UTC
This is a Dell Inspiron 8000 with 512 MB RAM running SUSE 9.1 with kernel
2.6.5-7.201-default.  I'm running KDE 3.4.2, which consumes quite a lot of
memory (and I did have other memory-intensive things present), but I didn't see
much if any paging activity.

What does AreaBroadcast do?  The name is somewhat suggestive, and I've seen
other performance issues involving screen redraw (in particular, sometimes it
redraws very slowly, sometimes redraws 2-3 times, and sometimes redraws
literally dozens of times.  Unfortunately I can't reproduce them reliably enough
to file a bug.
Comment 6 ooo 2005-10-07 10:54:12 UTC

@rlk: AreaBroadcast broadcasts changes of cells in areas where other formulas
are listening to. Implementation changed with the numbers of rows increased to
64k. It is not related to screen redraws.
Comment 7 Marcus 2017-05-20 11:13:07 UTC
Reset assigne to the default "".