To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102566 Issue #|102566 Summary|Tiny 1 sheet spreadsheet incredibly slow Component|Spreadsheet Version|1.0.3 Platform|Other URL| OS/Version|Linux Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|viewing Assigned to|spreadsheet Reported by|billgradwohl
------- Additional comments from billgradw...@openoffice.org Sat Jun 6 15:20:37 +0000 2009 ------- Fedora 10 x86-64 fully patched. AutoCalculate is ON. I see no way to attach a sample in this opening incident report, so I assume I'll be able to do that immediately after the incident is created via this post. This is a tiny spreadsheet that displays some odd behaviours. Note at opening the sheet, how long "calculating" and "adapting row height" takes. 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, 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. Explanation, any one? 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. This is unusable, and its a tiny uncomplicated sheet doing only simple arithmetic. No function calls, no macros, no database access, no nothing. There's a bug here somewhere. I've previously reported that cells not visible to the user are not recalculated. Draging the mouse down to reveal some of these rows of cells is what is causing the many "calculating" messages, and that's why that is so slow. These out of view cells are not recalculated even when auto recalc is on and causes problems when macros are used to interrogate an out of view cell and it contains the wrong answer. Refer to issue 100252 - I uploaded a sample of a problem there and haven't heard a word about it in months. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org