Apache OpenOffice (AOO) Bugzilla – Issue 103497
regregression: editing medium size table slow (quite annoying to work with)
Last modified: 2014-01-15 13:36:00 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 openoffice.org 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.
Created attachment 63508 [details] The name says it all
Pls check it
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!
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.
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.
Confirmed with AOO410m1(Build:9750) - Rev. 1557669 2014-01-14_04:11:13 - Rev. 1557927 Debian