Bug 133704 - Inserting a new sheet in a document with complex formula's very slow
Summary: Inserting a new sheet in a document with complex formula's very slow
Status: RESOLVED DUPLICATE of bug 139444
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.0.0.3 release
Hardware: All All
: medium major
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: haveBacktrace, perf
Depends on:
Blocks:
 
Reported: 2020-06-05 15:50 UTC by Telesto
Modified: 2022-05-11 10:08 UTC (History)
6 users (show)

See Also:
Crash report or crash signature:

Attachments
Perf flamegraph (50.27 KB, image/svg+xml)
2021-09-10 18:47 UTC, Buovjaga 		Details
View All 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 2020-06-05 15:50:01 UTC 
Description:
Inserting a new sheet very slow

Steps to Reproduce:
1. Open attachment 142401 [details] from bug 117896
2. Right-click sheet KROSCEK - Insert a sheet before -> Wait

Actual Results:
Takes very long (minutes)

Expected Results:
More or less in a blink


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 7.1.0.0.alpha0+ (x64)
Build ID: 191288d6a7fb52b31038a21c4e71ee57ffa3bacd
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

and in
4.0.0.3

Sheet is no working properly in 3.5.7.2 and 3.3.0
Comment 1 Telesto 2020-06-05 16:09:48 UTC 
Flamegraph would be nice, if reproducible of course
Comment 2 Julien Nabet 2020-06-05 16:13:00 UTC 
First let's wait for some feedback about other Flamegraphs.
Comment 3 Telesto 2020-06-05 16:13:25 UTC 
Another way to reach the same goal
1. Open the attached file
2. Drag Master Absensi before Master GW
3. Click KROSCEK -> Hang
Comment 4 Telesto 2020-06-05 16:22:11 UTC 
Another way the reproduce
1. Open the file
2. Save the file -> Set row height manually first.. to 0,50.. loading will take quite some time without.. bug 124098
3. Open the file 
4. Click Master sheet
Comment 5 Nelson 2020-06-06 04:18:59 UTC 
confirm this issue. took me 164s only to insert an empty sheet after KROSCEK.

Version: 6.4.3.2 (x64)
Build ID: 747b5d0ebf89f41c860ec2a39efd7cb15b54f2d8
CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: default; VCL: win; 
Locale: en-US (en_US); UI-Language: en-US
Calc: threaded
Comment 6 Nelson 2020-06-06 04:19:50 UTC Comment hidden (obsolete)
Comment 7 raal 2020-06-06 11:08:48 UTC 
Confirm with Version: 7.0.0.0.beta1+
Build ID: c344de1b9985b6ca10b354e24151d0bdf92dc20e
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3
Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US
Calc: threaded
Comment 8 Buovjaga 2021-09-10 18:47:33 UTC 
Created attachment 174955 [details]
Perf flamegraph

(In reply to Telesto from comment #0)
> Steps to Reproduce:
> 1. Open attachment 142401 [details] from bug 117896
> 2. Right-click sheet KROSCEK - Insert a sheet before -> Wait

Traced for quite some time, but did not wait until the very end.

Version: 7.3.0.0.alpha0+ / LibreOffice Community
Build ID: e6a8d312d3d7e5d81c56d5ccc0508116dd283f1f
CPU threads: 8; OS: Linux 5.14; UI render: default; VCL: kf5 (cairo+xcb)
Locale: fi-FI (fi_FI.UTF-8); UI: en-US
Calc: threaded
Comment 9 Luboš Luňák 2022-05-11 10:08:03 UTC 

*** This bug has been marked as a duplicate of bug 139444 ***