Bug 157015 - Super slow performance/navigation in Calc when hiding all unused rows and columns in a spreadsheet
Summary: Super slow performance/navigation in Calc when hiding all unused rows and col...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.6.0.3 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: perf
Depends on:
Blocks: Cell-Management
  Show dependency tree / graph
 
Reported: 2023-08-30 14:17 UTC by Andrew
Modified: 2024-09-30 04:44 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Andrew 2023-08-30 14:17:42 UTC 
Description:
I want to only see used rows+columns in a spreadsheet. Therefore, I select the rest of the rows+columns and hide them. But this makes Calc performance to degrade greatly: scrolling with gestures/scrollbar takes more than a second for each UI update/refresh, cell navigation with keyboard isn't instant (unlike when a huge number of rows+columns isn't hidden).

I use Debian-based OS (with DEB packages) and GNOME DE (haven't tried KDE yet).

Steps to Reproduce:
1. Select all unused rows and hide them.
2. Select all unused columns and hide them.
3. Try to scroll through visible/used rows/columns.

Actual Results:
Very slow overall performance, lags.

Expected Results:
Smooth scrolling, quick cell navigation, no lags.


Reproducible: Always


User Profile Reset: Yes

Additional Info:
[Information automatically included from LibreOffice]
Locale: en-US
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Linux (All)
OS is 64bit: yes
Comment 1 Andrew 2023-08-30 14:20:08 UTC 
This bug was also present in previous versions (100% in v7.4).
Comment 2 m_a_riosv 2023-08-30 21:53:28 UTC 
Looks a bit when the hidden rows/columns are in the window.

Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 33ae7c12bbdf19b76ced472ca8aed6cf66477bbe
CPU threads: 16; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: en-US
Calc: CL threaded Jumbo