Apache OpenOffice (AOO) Bugzilla – Issue 83712
oocalc 2.3 very slow for simple operations
Last modified: 2013-08-07 15:15:24 UTC
oocalc 2.3 on Fedora 8 is very slow compared to oocalc 2.0 on Fedora 6. Please see the attached file. There is a small macro in it (a math function) but it can be turned off as it doesn't affect the following results. (*) right-click on column "N" (or any other) and choose "insert columns" Then 1) in oocalc 2.3 on Fedora 8 it takes 13 seconds to do (*) 2) this time is reduced to less than 1 second if AutoCalculate is turned off. 3) in oocalc 2.0 on Fedora 6 it takes less than 1 second to do (*) whether or not AutoCalculate is on. (**) turn off AutoCalculate (via F9 or the menu) 4) in oocalc 2.3 on Fedora 8 it takes 7 seconds to accomplish (**) 5) in oocalc 2.0 on Fedora 6 it takes less than 1 second to do (**) Packages installed: On the Fedora 8 box: openoffice.org-calc-2.3.0-6.6.fc8.rpm On the Fedora 6 box: openoffice.org-calc-2.0.4-5.5.24.rpm Remark. The larger the worksheet, the longer the times in 1) and 4). For some of my worksheets, it takes an hour to add a single column in oocalc 2.3 while it takes a second or two in oocalc 2.0. It looks like oocalc 2.3 is recalculating everything thousands of times when it is not necessary. AB.
Created attachment 49702 [details] Example file
I have attached another file (test2_slow_oocalc23.ods) which shows an even stranger behavior. 1) right-click on column L and select delete columns: 6 seconds (very long). 2) undo (ctrl-z): < 1s (that's ok) 3) right-click on column L and select insert column: < 1s (that's ok) 4) undo (ctrl-z): 8 seconds (much too long) 5) select columns L and U (with ctrl), right-click on column U and select delete columns: < 1s !! (that's ok)
Created attachment 49705 [details] Example file 2
I can confirm that it's real real slow with the "vanilla" 2.3.0 rpms
Hi Eike, seems to be yours. Frank
I cannot reproduce this using a DEV300m24 Linux/x86 build, all operations mentioned to be slow above take ~1s or less. @airbete, @cmc: could you please confirm? Thanks Eike
The problem seems to be gone with openoffice.org-calc-2.4.1-17.4.fc9.i386 on Fedora 9. Thanks.
Indeed, fast in 2.4.1 again. *shrug*, the problem has "gone away"
Of course this was solved having invested a vast amount of mythical man months ;-) Thanks for verifying.
Closing.