Apache OpenOffice (AOO) Bugzilla – Issue 104766
Automatic scrolling when marking cells scrolls much too far when there are many charts on sheet
Last modified: 2013-01-29 21:51:39 UTC
If there are many charts or charts with many data points in a sheet, the automatic scrolling when marking or duplicating cells does not work properly. Once you trigger scrolling through moving the cursor on the border of the window, Calc begins to scroll, but it does not stop when moving the cursor back. Instead, it scrolls for about 1 or 2 minutes, until it finally stops. While scrolling, OOo does not react to user input (also Writer and other documents). Seems to me like a redrawing bug which might depend on machine power. I use Win xp on a 1,8GHz Dual Core Machine To reproduce do the following: Open a new sheet, insert some data and generate a chart from it (I use XY Charts). duplicate this chart a few times (15, for example). -or simply open the attached file. Then try to mark a few cells that lie partially outside the screen with the mouse. The problem also occurs with one chart with many datapoints (35K on my machine). The document I am currently working on shows the same problem. It contains 4 charts with 110 data points each and a few smaller charts. regards, deepriver
Created attachment 64530 [details] Spreadsheet file that contains the variant with many charts
Yup, I discovered this problem also with Calc's selection and scrolling. The problem happens when redrawing requests during the scroll occurs much faster than the actual redrawing, in which case the redraw requests simply just keep accumulating and getting executed whenever the CPU cycle becomes available. While it's happening Calc doesn't receive any key or mouse inputs. Understandably, this tends to happen more often on slower machines, but it can also happen on blazing fast machines under the right condition. Also, Windows tend to exhibit this more often than Linux. My initial thought is to get this sort of excessive redraw requests properly handled at the framework level. But I haven't looked deeper into this yet, so no guarantee whether my thinking is correct.
Created attachment 64531 [details] Spreadsheet file with one chart containing 35k data, showing the same bug
You're right, on my Linux box the problem does not occur - at least not with OOo 3.0.1. I tried it with ten times more diagrams on a 1.3 GHz AMD Duron machine on Ubuntu Jaunty - It behaved slow, but did not block user input, and thus did not scroll too far. If I find time, I'll try with OOo 3.1.1 on Linux