Issue 103497 - regregression: editing medium size table slow (quite annoying to work with)
Summary: regregression: editing medium size table slow (quite annoying to work with)
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 3.1
Hardware: PC All
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: oooqa, performance
Depends on:
Reported: 2009-07-13 09:57 UTC by akeiron
Modified: 2014-01-15 13:36 UTC (History)
5 users (show)

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

The name says it all (265.84 KB, application/vnd.oasis.opendocument.spreadsheet)
2009-07-13 09:59 UTC, akeiron
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description akeiron 2009-07-13 09:57:40 UTC
I've looked for a similar issue by putting "calc slow" and "spreadsheet slow" in
the search field, but I wasn't able to find anything related to version 3.x.x.

In fact, the problem arouse after upgrading from version 2.4.2 to version 3.0.x
and 3.1.x., which forced me to downgrade. It seems version 2.4.2 is not affected
at all. I tested this on a Pentium-M 1.8 Ghz, and a AMD X2 2Ghz, both under
Linux (I'm using gentoo, package openoffice-bin which is basically the Sun
precompiled distribution) and Windows XP (the version that comes straight from
the download center). Both the PCs have 1 GB RAM.

The problem is: doing simple editing in calc files is painful. Insertion,
deletion, editing of values has become moderately slow and it's very annoying
with files beyond a certain size, like the one I'm going to post.

I'm going to attach a sample file.
Comment 1 akeiron 2009-07-13 09:59:40 UTC
Created attachment 63508 [details]
The name says it all
Comment 2 amy2008 2009-07-14 03:48:04 UTC
Pls check it
Comment 3 akeiron 2009-09-16 05:47:41 UTC
I've tried this on my new laptop, which is an Intel Core2 Duo P8600, in Windows
Vista: obviously things works better, but the bug is still there.
Try this: open the attached example with any 3.x version and insert a new line
wherever there's a column with numeric values (e.g. line 15), try and insert a
numeric value in the new space created in column J. Note if you have to make
frequent insertions or changes the slow down is unacceptable.
Try the same thing in any 2.4.x version and... surprise: no slow-down.
Please someone confirm!
Comment 4 Douglas Lenz 2013-11-10 20:47:17 UTC
Tested using attachment on version 4.01 Rev. 1524958, Windows 7, Intel Core i5-480M, 4 GB ram, Intel HD graphics. Reproduced slowness even in newer build.
Comment 5 Kyle 2013-11-11 20:28:58 UTC
Kyle B, 11/11/13,

I was able to reproduce this bug also inc Calc: 4.0.1 Build:9714 - Rev. 152495. I am running open office on Windows 8.1, with intel i7 2.8 Ghz processor and 6 gb of ram. I also am experiencing slow down or delayed responsiveness when editing the provided file above. After I edit one cell and click to another cell and begin to type I notice a few seconds of delay before I see the result of my keystrokes.

To reproduce the bug:
1. Open the file in calc.
2. click 1 cell edit it.
3. Click another cell and edit it.
4. Repeat step 3 a few times and bug will result.

This bug is an important issue simply because it can significantly cut down on the productivity of the user. If the user is forced to wait a few seconds to see if their edits are being applied to the cell then they will take much longer to complete any given task. This also makes errors by the user more likely as they wouldn't even be able to see if they made an error until a few keystrokes later, and when working quickly it is common to forget to go back and check.
Comment 6 Edwin Sharp 2014-01-15 13:36:00 UTC
Confirmed with
AOO410m1(Build:9750)  -  Rev. 1557669
2014-01-14_04:11:13 - Rev. 1557927