Bug 166725 - Deleting column/moving a column by drag and drop triggers Adapt Row Height Calculation causing a substantial lag
Summary: Deleting column/moving a column by drag and drop triggers Adapt Row Height Ca...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Cell-Add-Delete Regressions-row-height
  Show dependency tree / graph
 
Reported: 2025-05-25 19:05 UTC by Telesto
Modified: 2025-05-26 11:36 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 Telesto 2025-05-25 19:05:16 UTC 
Description:
Deleting column/moving a column by drag and drop riggers Adapt Row Height Calculation causing a substantial lag

Steps to Reproduce:
1. Open attachment 151324 [details] bug 125236 
2. Delete a column -> wait 20 seconds
3. Alternative: select a column: drag it to different column (move)

Actual Results:
Slow

Expected Results:
Well adapt row height being calculated on file-open. Next again on deleting a column

Is there now way to buffer the results? Instead of calculating the row height over and over. 


Reproducible: Always


User Profile Reset: No

Additional Info:
Found in
Version: 25.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 9bc5b89c149497a83117edfadc3fb0b96d2f9899
CPU threads: 4; OS: Windows 10 X86_64 (build 19045); UI render: Skia/Raster; VCL: win
Locale: nl-NL (nl_NL); UI: en-US
Calc: CL threaded

and in
Version: 7.1.8.0.0+ (x64) / LibreOffice Community
Build ID: a94b58277c7aeaa83ce14347cd0b8f7137969d03
CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: nl-NL (nl_NL); UI: en-US
Calc: CL

and in
Versie: 6.3.0.4 (x86)
Build ID: 057fc023c990d676a43019934386b85b21a9ee99
CPU-threads: 4; Besturingssysteem: Windows 10.0; UI-render: GL; VCL: win; 
Locale: nl-NL (nl_NL); UI-taal: nl-NL
Calc: CL

and in
Version: 6.1.6.3
Build ID: 5896ab1714085361c45cf540f76f60673dd96a72
CPU threads: 4; OS: Windows 10.0; UI render: default; 
Locale: nl-NL (nl_NL); Calc: CL

and in
Version: 5.2.5.0.0+
Build ID: a4d4fbeb623013f6377b30711ceedb38ea4b49f8
CPU Threads: 4; OS Version: Windows 6.2; UI Render: GL; 
TinderBox: Win-x86@62-merge-TDF, Branch:libreoffice-5-2, Time: 2016-12-24_14:43:55
Locale: nl-NL (nl_NL); Calc: CL

and in
4.4.7.2

and in
LibreOffice 3.3.0 
OOO330m19 (Build:6)
tag libreoffice-3.3.0.4
Comment 1 m_a_riosv 2025-05-25 21:30:44 UTC 
Why it should be?

Perhaps there are calculations that can change the height of the row, by moving it, not only in that column but in other columns, maybe not common but possible. For example, with a TEXTJOIN function.
Comment 2 Jeremy Norvell 2025-05-25 21:34:39 UTC 
Thank you for reporting the bug. I can reproduce the behavior described using the versions of LibreOffice listed below. Deletion of a column takes about 15 seconds with the cursor changing to the 'busy' color wheel on MacOS.

Of note is that other operations such as opening are slow as well. Likely due to the calculations noted on file-open.

Version: 25.8.0.0.alpha1+ (X86_64) / LibreOffice Community
Build ID: 84da1f50ca8261129909901c2ff72adb9c67510a
CPU threads: 8; OS: macOS 15.2; UI render: Skia/Raster; VCL: osx
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded

Version: 25.2.3.2 (X86_64) / LibreOffice Community
Build ID: bbb074479178df812d175f709636b368952c2ce3
CPU threads: 8; OS: macOS 15.2; UI render: Skia/Raster; VCL: osx
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded