Bug 145042 - Calc slows down on filled cells when navigating
Summary: Calc slows down on filled cells when navigating
Status: UNCONFIRMED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.1.2.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-10-10 15:38 UTC by macias
Modified: 2024-04-06 21:09 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
Sheet with choppy navigation (7.70 KB, application/vnd.oasis.opendocument.spreadsheet)
2021-10-10 18:06 UTC, macias
Details

Note You need to log in before you can comment on or make changes to this bug.
Description macias 2021-10-10 15:38:39 UTC
I tested 7.1.2.2 version running openSUSE Leap 15.3 and also 7.2.2.2 version running Fedora Rawhide.

The problem is easy to see when you have a column with some empty cells and some filled cells (just a text suffices, it does not have to be formula or anything complicated). Now I press up/down key and hold it. When the cell is empty the cursor moves with normal speed, but when it hits filled one there is some pause. When there are multiple filled cells it looks like an effect of changing the keyboard settings regarding repeat time, there is so much pausing.

If you are used to normal (fast) navigation it leads to constantly overshooting the desired cells, so basically the usage is "navigate like normal" + "correct the overshooting".

The last version (know to me) that worked as expected was 5.0.6.3 running openSUSE 13.2 (Harlequin).
Comment 1 Roman Kuznetsov 2021-10-10 16:00:25 UTC
please attach here some example file when you have the problem

and write here an info from your LibreOffice's Help-About dialog (use a Copy button there)
Comment 2 macias 2021-10-10 18:06:15 UTC
Created attachment 175625 [details]
Sheet with choppy navigation

Version: 7.1.2.2 / LibreOffice Community
Build ID: 10(Build:2)
CPU threads: 4; OS: Linux 5.3; UI render: default; VCL: gtk3
Locale: en-US (en_US.utf8); UI: en-US
Calc: threaded

I attached the example sheet. In my case, the filled cells are around half of the weight of the screen (window is maximized). Use arrow keys to move up and down trough entire visible portion of the sheet. Observe that while going through filled cells the movement gets choppy/jumpy.
Comment 3 Roman Kuznetsov 2021-10-10 18:48:42 UTC
i don't see any problem in

Version: 7.3.0.0.alpha0+ / LibreOffice Community
Build ID: 80a47aae1419842f4496f02028e2b49763aea25b
CPU threads: 4; OS: Linux 5.10; UI render: default; VCL: gtk3
Locale: ru-RU (ru_RU.UTF-8); UI: en-US
TinderBox: Linux-rpm_deb-x86_64@86-TDF, Branch:master, Time: 2021-09-13_23:40:12
Calc: threaded


Can you download LibreOffice from our official site https://libreoffice.org/download , install it and try retest in it?
Comment 4 macias 2021-10-12 19:48:20 UTC
Ok, so I installed the newer version on openSUSE 15.3 (as I mentioned I tested Fedora Rawhide, and it has even newer version, so I didn't touch it).

The choppy/jumpy effect is still there.

Here is the info from the About dialog:
Version: 7.2.1.2 / LibreOffice Community
Build ID: 87b77fad49947c1441b67c559c339af8f3517e22
CPU threads: 4; OS: Linux 5.3; UI render: default; VCL: gtk3
Locale: en-US (en_US.utf8); UI: en-US
Calc: threaded
Comment 5 Buovjaga 2021-10-21 14:44:31 UTC
Are you using X11 or Wayland? Quick way to find out via terminal:

env | grep -i wayland
Comment 6 macias 2021-10-21 15:43:27 UTC
After executing:
env | grep -i wayland

nothing showed up. So I guess X11.
Comment 7 macias 2022-04-06 14:58:11 UTC
After upgrading same story, when cursor moves through non-empty cells scrolling slows down significantly.

Version: 7.3.2.2 / LibreOffice Community
Build ID: 49f2b1bff42cfccbd8f788c8dc32c1c309559be0
CPU threads: 4; OS: Linux 5.3; UI render: default; VCL: gtk3
Locale: en-US (en_US.utf8); UI: en-US
Calc: threaded
Comment 8 macias 2022-05-01 14:11:57 UTC
Today I noticed something new. As reported when I move down/up/etc through filled cells, cursor movement is extremely slow (regression in behaviour). But when I press down and hold down shift key, meaning I am selecting the cells I move through the movement is completely smooth.

I rephrase, I move over exactly the same cells, but when I am selecting them (by pressing shift key) there is no slowdown.
Comment 9 raal 2022-05-29 21:23:54 UTC
No repro with Version: 7.4.0.0.alpha1+ / LibreOffice Community
Build ID: b6e0ae1b1bad5e222e21bbb4b2a158c1fc6f9779
CPU threads: 4; OS: Linux 5.13; UI render: default; VCL: gtk3
Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US
Calc: threaded Jumbo
Comment 10 macias 2022-09-11 12:55:37 UTC
I reinstalled entire system (i.e. openSUSE 15.3) in generic desktop mode.

Then installed basic "libreoffice" and "libreoffice-calc" packages. This by default looks off (does not match the desktop look) but the speed of moving around the cells is OK.

Then I installed "skin" package "libreoffice-gtk3" to match the look with the desktop (light theme, proper fonts). And here where the slowdown appears -- now moving around the cells is sluggish.
Comment 11 Buovjaga 2022-09-11 13:10:18 UTC
(In reply to macias from comment #10)
> I reinstalled entire system (i.e. openSUSE 15.3) in generic desktop mode.
> 
> Then installed basic "libreoffice" and "libreoffice-calc" packages. This by
> default looks off (does not match the desktop look) but the speed of moving
> around the cells is OK.
> 
> Then I installed "skin" package "libreoffice-gtk3" to match the look with
> the desktop (light theme, proper fonts). And here where the slowdown appears
> -- now moving around the cells is sluggish.

LibreOffice version is 7.3 or 7.4?
Comment 12 macias 2022-09-11 14:18:24 UTC
7.3.3
Comment 13 Armondo Lopez 2024-04-06 21:09:01 UTC
I am unable to reproduce this behavior in 

Version: 24.2.1.2 (X86_64) / LibreOffice Community
Build ID: db4def46b0453cc22e2d0305797cf981b68ef5ac
CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: default; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: threaded

or

Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: a2265e8faa099d9652efd12392c2877c2df1d1eb
CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: default; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: threaded