Description: Suppose that you want to enter a sum of some cells in a destination cell. You go on the destination cell, you press "=SUM(" and then you should select the cells to be summed, so that their range is automatically inserted in the formula. As you do so, often the spreadsheet starts scrolling in an uncontrolled way even if there is no need to scroll to select the desired cells. In many cases the scrolling causes the cells to be selected to go out of view or the selection to get enlarged in an undesired way. Seen on linux, KDE, with the gtk3 vcl (since the kf vcls still have problems with fractional scaling). Steps to Reproduce: 1. Open spreadsheet 2. Enter '=SUM(' in a cell 3. Try to select cells to be summed Actual Results: The spreadsheet scrolls even if there is no need to, making it impossible to select what you want to select. Expected Results: What you want to select should remain visible. Reproducible: Always User Profile Reset: No Additional Info: Version: 24.2.5.2 (X86_64) / LibreOffice Community Build ID: 420(Build:2) CPU threads: 16; OS: Linux 6.9; UI render: default; VCL: gtk3 Locale: it-IT (en_US.UTF-8); UI: en-US 24.2.5-1 Calc: threaded
I also see this on the Mac version. It's been an issue for a long time, and back when I used Excel, it was an issue there too. I believe what's happening is that the rate of scrolling depends on how many cells moving on screen contain data. Once you get to a state where new cells that should scroll onto the screen are empty, scrolling speeds up a huge amount.
No problem either with an empty spreadsheet or one with data. Arch Linux 64-bit (Wayland session) Version: 25.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 4787fd4fc86230893a6da309f45964116b3a67df CPU threads: 8; OS: Linux 6.10; UI render: default; VCL: gtk3 Locale: fi-FI (fi_FI.UTF-8); UI: en-US Calc: CL threaded Built on 24 September 2024