Bug 131674 - Dragging sheet 2 before sheet 1 takes forever with 120k of comments
Summary: Dragging sheet 2 before sheet 1 takes forever with 120k of comments
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.1.6.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: perf
Depends on:
Blocks: Calc-Comments
  Show dependency treegraph
 
Reported: 2020-03-29 15:49 UTC by Telesto
Modified: 2023-05-01 05:41 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Telesto 2020-03-29 15:49:02 UTC
Description:
Dragging sheet 2 before sheet 1 takes forever with 120k of comments

Steps to Reproduce:
1. Open attachment 156113 [details]
2. Insert a new sheet
2. Drag Sheet 2 before sheet 1 & wait, wait wait

Actual Results:
Hang

Expected Results:
More efficient way


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 7.0.0.0.alpha0+ (x64)
Build ID: 7ae9c9572ccac55c0926b8a9779bb63c4236291c
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: Skia/Raster; VCL: win; 
Locale: nl-NL (nl_NL); UI-Language: en-US
Calc: CL
Comment 1 Telesto 2020-04-05 20:37:03 UTC
Deleting a column/row is also slow
Comment 2 b. 2020-05-11 00:41:51 UTC
for the BUG Hunting Session 7.0.0.a1+: 

1st move, empty sheet2 before sheet1 - less than a second 

2nd movement, sheet 1 with comments back again before sheet 2 - kiss your computer good night, maybe it will talk to you again tomorrow ... 

i've an unsure feeling that there are some improvements, it's possible to get focus on other maps / files - after reasonable wait - in win and work in them, but the main problem isn't solved ... 

linux (debian) worse than windows, system freeze, but both unusable :-(

ver. 4.1.6.2 already affected /win - crash), probably inherited from OOo

'new', not a dup but 'related' to plenty other comment slowdown bugs
Comment 3 QA Administrators 2022-08-12 03:50:06 UTC Comment hidden (obsolete)
Comment 4 Tex2002ans 2023-05-01 05:41:43 UTC
I confirm b's instructions in Comment #2.

If you:

1. Open Attachment.

2. Create a new Sheet2 and drag before Sheet1, it's fine.

3. Drag Sheet1 before Sheet2.

Hang.

- - -

Version: 7.5.2.2 (X86_64) / LibreOffice Community
Build ID: 53bb9681a964705cf672590721dbc85eb4d0c3a2
CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: Skia/Vulkan; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: CL threaded