Issue 104766

Summary: Automatic scrolling when marking cells scrolls much too far when there are many charts on sheet
Product: Calc Reporter: deepriver <deepriver_>
Component: uiAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues, kyoshida
Version: OOo 3.1.1   
Target Milestone: ---   
Hardware: PC   
OS: Windows XP   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
Spreadsheet file that contains the variant with many charts
none
Spreadsheet file with one chart containing 35k data, showing the same bug none

Description deepriver 2009-09-03 19:18:26 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
Comment 1 deepriver 2009-09-03 19:34:28 UTC
Created attachment 64530 [details]
Spreadsheet file that contains the variant with many charts
Comment 2 kyoshida 2009-09-03 19:40:03 UTC
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.
Comment 3 deepriver 2009-09-03 19:55:21 UTC
Created attachment 64531 [details]
Spreadsheet file with one chart containing 35k data, showing the same bug
Comment 4 deepriver 2009-09-04 11:59:34 UTC
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