Bug 131791 - Hang dragging a large column with basic formula's
Summary: Hang dragging a large column with basic formula's
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.5.0 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: perf
Depends on:
Blocks: Performance
  Show dependency treegraph
 
Reported: 2020-04-01 13:27 UTC by Telesto
Modified: 2022-12-29 05:34 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
Example file (21.33 MB, application/vnd.oasis.opendocument.spreadsheet)
2020-04-01 13:28 UTC, Telesto
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Telesto 2020-04-01 13:27:43 UTC
Description:
Hang dragging 3 large columns with basic formula's

Steps to Reproduce:
1. Open the attached file
2. Select Column F t/m J
3. Drag the columns to the right column F being dropped on column J

Actual Results:
Hang/Freeze

Expected Results:
No hang/freeze


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 7.0.0.0.alpha0+ (x64)
Build ID: 4501a0ba623ad61c5a4e0b807da2e96f0e4ce82c
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: default; VCL: win; 
Locale: nl-NL (nl_NL); UI-Language: en-US
Calc: CL
Comment 1 Telesto 2020-04-01 13:28:25 UTC
Created attachment 159234 [details]
Example file
Comment 2 Telesto 2020-04-01 14:01:27 UTC
Dragging one column is already slow; this wasn't the when I created the document
Comment 3 Buovjaga 2020-06-20 11:59:20 UTC
(In reply to Telesto from comment #0)
> Description:
> Hang dragging 3 large columns with basic formula's
> 
> Steps to Reproduce:
> 1. Open the attached file
> 2. Select Column F t/m J
> 3. Drag the columns to the right column F being dropped on column J

I read step 2 as "select columns F-I". I don't understand what "t/m" means.

Took some secs, wouldn't call it a hang

Arch Linux 64-bit
Version: 7.1.0.0.alpha0+
Build ID: 8e4c79472644452431381733a5e4b21f98fcdcf3
CPU threads: 8; OS: Linux 5.7; UI render: default; VCL: kf5
Locale: fi-FI (fi_FI.UTF-8); UI: en-US
Calc: threaded
Built on 19 June 2020

Version: 7.1.0.0.alpha0+ (x64)
Build ID: 43c60ce1ac7629a1462e927e6ff937469f58f743
CPU threads: 4; OS: Windows 10.0 Build 18362; UI render: Skia/Raster; VCL: win
Locale: fi-FI (fi_FI); UI: en-US
Calc: threaded
Comment 4 Vladislav Kim 2021-07-22 09:05:02 UTC
No repro in 

Version: 7.1.4.2 (x64) / LibreOffice Community
Build ID: a529a4fab45b75fefc5b6226684193eb000654f6
CPU threads: 6; OS: Windows 10.0 Build 19041; UI render: Skia/Vulkan; VCL: win
Locale: ru-RU (ru_RU); UI: en-US
Calc: CL
Comment 5 Xisco Faulí 2022-05-02 12:03:43 UTC
Dear Telesto,
Could you please try to reproduce it with a master build from http://dev-builds.libreoffice.org/daily/master/ ?
You can install it alongside the standard version.
I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' if the bug is still present in the master build
Comment 6 QA Administrators 2022-10-30 03:47:24 UTC Comment hidden (obsolete)
Comment 7 Telesto 2022-10-30 20:32:31 UTC
Still slow
Version: 7.5.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 9cd0f4c2d25462feba0ffcbd906c199273821243
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: Skia/Raster; VCL: win
Locale: nl-NL (nl_NL); UI: en-US
Calc: CL threaded

1. Open the attached file
2. Select Column F t/m J
3. Drop the selection say column L -> wait (without visual feedback say progress bar). So it should faster or some progress bar is needed
Comment 8 Buovjaga 2022-12-26 18:50:19 UTC
(In reply to Telesto from comment #7)
> Still slow
> Version: 7.5.0.0.alpha0+ (X86_64) / LibreOffice Community
> Build ID: 9cd0f4c2d25462feba0ffcbd906c199273821243
> CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: Skia/Raster; VCL: win
> Locale: nl-NL (nl_NL); UI: en-US
> Calc: CL threaded
> 
> 1. Open the attached file
> 2. Select Column F t/m J
> 3. Drop the selection say column L -> wait (without visual feedback say
> progress bar). So it should faster or some progress bar is needed

Ok, I repro, it took 30 secs. Was a bit confused at first as the mouse cursor only showed the "forbidden" symbol, but then I noticed it sometimes turned into a grabby hand and with that shown I was able to drop it.

It's even slower in 4.4, 3.5.

Version: 7.5.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 9cd0f4c2d25462feba0ffcbd906c199273821243
CPU threads: 8; OS: Linux 6.1; UI render: default; VCL: kf5 (cairo+xcb)
Locale: fi-FI (fi_FI.UTF-8); UI: en-US
Calc: threaded Jumbo