Bug 153542 - Libreoffice calc 7.5 very slow and unresponsive when zooming in out (wheel mouse) on large spreadsheet under Debian
Summary: Libreoffice calc 7.5 very slow and unresponsive when zooming in out (wheel mo...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.5.0.3 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Zoom Performance
  Show dependency treegraph
 
Reported: 2023-02-11 07:22 UTC by thurston.more@laposte.net
Modified: 2023-05-18 15:15 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
a very basic file, with large number of cells (with specific narrow column size). (410.44 KB, application/vnd.oasis.opendocument.spreadsheet)
2023-02-11 07:24 UTC, thurston.more@laposte.net
Details

Note You need to log in before you can comment on or make changes to this bug.
Description thurston.more@laposte.net 2023-02-11 07:22:52 UTC
Description:
I am using a quite heavy spreadsheet for years now. (150x150) rows / columns. When i try to zoom in and out, i notice quite long delay (response), which is very unconfortable. This was not the case with previous version or at least not that visible.

Steps to Reproduce:
1. create a file with large number of columns
2. an example of a file you can use is here: https://edms.cern.ch/document/2443119/1, just download it and try to open it.
3. when opened, try to zoom in and out.

Actual Results:
libreoffice starts to be unresponsive, or shows a lot of delay.

Expected Results:
normally zoom in and out. (this is what is expected).


Reproducible: Always


User Profile Reset: No

Additional Info:
This bug reminds me of one encountered in 2020, which was solved. (at least it is not the first time i encounter this behaviour).
Comment 1 thurston.more@laposte.net 2023-02-11 07:24:26 UTC
Created attachment 185310 [details]
a very basic file, with large number of cells (with specific narrow column size).
Comment 2 thurston.more@laposte.net 2023-02-11 07:34:17 UTC
Testing with stable version (7.4.5), the behaviour is the same, with file very slow to zoom in out. I am pretty sure this bug was solved in earlier version, and reappears now, since this exact challenging file had been transmitted to LibreOffice 2 years ago, and some improvements were made... which seems lost again. Hope to help
Comment 3 thurston.more@laposte.net 2023-02-11 07:58:17 UTC
i have the feeling we are back to this bug described here:
https://ask.libreoffice.org/t/libreoffice-calc-7-0-very-slow/55970/17
Comment 4 Roman Kuznetsov 2023-02-11 09:39:11 UTC
Please write here info from LibreOffice's Help->ABout dialog (there is the button Copy there, use it)
Comment 5 thurston.more@laposte.net 2023-02-11 14:08:10 UTC
Version: 7.5.0.3 (X86_64) / LibreOffice Community
Build ID: c21113d003cd3efa8c53188764377a8272d9d6de
CPU threads: 8; OS: Linux 6.0; UI render: default; VCL: gtk3
Locale: en-GB (fr_FR.UTF-8); UI: en-US
Calc: threaded
Comment 6 thurston.more@laposte.net 2023-02-11 19:22:56 UTC
i wonder if the issue is not described in detail here, since at that time, the problem was solved.
https://gerrit.libreoffice.org/c/core/+/110538
cheers
Comment 7 QA Administrators 2023-02-12 03:21:17 UTC Comment hidden (obsolete)
Comment 8 Roman Kuznetsov 2023-02-12 17:16:42 UTC
I confirm some delay when you try to scale the sheet in the attached file.
But if you set up the column widht to nornal/default - you shouldn't see the problem with the scaling

Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: d8e6b488ceaff7c88856ebcfcfec14d2d8cd7652
CPU threads: 16; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: ru-RU (ru_RU); UI: ru-RU
Calc: CL threaded

funny, if I disable Skia then LO can't open the file and uses 100% CPU instead
Comment 9 thurston.more@laposte.net 2023-02-13 14:52:05 UTC
(In reply to Roman Kuznetsov from comment #8)
> I confirm some delay when you try to scale the sheet in the attached file.
> But if you set up the column widht to nornal/default - you shouldn't see the
> problem with the scaling
> 
> Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community
> Build ID: d8e6b488ceaff7c88856ebcfcfec14d2d8cd7652
> CPU threads: 16; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL:
> win
> Locale: ru-RU (ru_RU); UI: ru-RU
> Calc: CL threaded
> 
> funny, if I disable Skia then LO can't open the file and uses 100% CPU
> instead

Thanks. And yes, i know that with normal width, the problem is less severe. I am almost sure the problem was diagnosed by collabora team, with certainly some interesting points here: https://gerrit.libreoffice.org/c/core/+/110538
cheers
Y