Created attachment 346757 [details] test sheet to demonstrate slow cell calcs Description of problem: Calculations take seconds per cell change on a tiny sheet. Reported to Open Office as their bug # 102566 and they say its peculiar to Fedora's build. on-Release number of selected component (if applicable): Version is 3.0.1-15.4.fc10 How reproducible: AutoCalculate is ON. Note at opening the sheet, how long "calculating" and "adapting row height" takes at the bottom left. Hit CTRL-END just so that you confirm how tiny this sheet is. Goto E2 Enter an integer other than the one already there and watch how quickly the sheet is calc'd. Goto E2 Enter an integer other than the one already there, and now watch how slow it is. No matter how often you alter E2, speed remains slow. Now, Highlight A15:T15, right click, copy. Goto A17, right click paste. Goto E2 Enter a number other than the one already there. Still very slow. Highlight A18:A250, right click, paste. Goto E2 Enter a number other than the one already there. Slowness is gone and the sheet is 20 times as large as it was when it was slow. But wait - there's more. Put the mouse on the row marker for row 16 and drag the mouse down to row 250. See how many "calculating" messages fly by and how incredibly slow this is? When you finally have rows 16 thru 250 highlighted, right click, delete row. Go back to E2 Enter a number other than the one already there. Back to being slow and the sheet is a small fraction of what it was when it was faster. Steps to Reproduce: 1. Every time. Just repeat steps above 2. 3. Actual results: Expected results: Additional info:
Definitely reproducible, on i686 3.1.0 F-11 as well. Upstream comment is just using the http://wiki.services.openoffice.org/wiki/CrazyDistroDefense
This reminds me vaguely of bug 387701 e.g. if you de-maximise calc and re-size the window to only show e.g. the one column E on screen I bet it flies along
Digging through with kcachegrind shows that with small numbers of cells like this the time is massively dominated by drawing the progress bar itself! We're drawing the progress bar on every percentage of cells updated, which is good when we have a few thousand of them, but not great when we have only a hundred or so
Filed a patch upstream, along with callgrind results. Patch checked into F-10/F-11/devel, will be in >= 3.0.1-15.5 if there is another update for F-10
openoffice.org-3.0.1-15.5.fc10 has been submitted as an update for Fedora 10. http://admin.fedoraproject.org/updates/openoffice.org-3.0.1-15.5.fc10
openoffice.org-3.0.1-15.6.fc10 has been submitted as an update for Fedora 10. http://admin.fedoraproject.org/updates/openoffice.org-3.0.1-15.6.fc10
openoffice.org-3.0.1-15.6.fc10 has been pushed to the Fedora 10 stable repository. If problems still persist, please make note of it in this bug report.