Bug 133879 - Format - Spreadsheet theme loads slow with a large sheet
Summary: Format - Spreadsheet theme loads slow with a large sheet
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.2.0.3 release
Hardware: All All
: medium minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: haveBacktrace, perf
Depends on:
Blocks: Performance
  Show dependency tree / graph
 
Reported: 2020-06-10 21:17 UTC by Telesto
Modified: 2022-12-29 05:57 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
Example file (4.43 MB, application/vnd.oasis.opendocument.spreadsheet)
2020-06-10 21:17 UTC, Telesto 		Details
Perf flamegraph (79.49 KB, image/svg+xml)
2020-10-17 12:51 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-10 21:17:21 UTC 
Description:
Format Spreadsheet theme loads slow  with a large sheet

Steps to Reproduce:
1. Open the attached file
2. Format -> Spreadsheet theme

Actual Results:
High CPU usage/ memory activity/ Slow (15 seconds)

Expected Results:
Data shouldn't affect loading a theme dialog


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 7.1.0.0.alpha0+ (x64)
Build ID: 59939d2490726336546c7ad05082d23031074e12
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
Comment 1 Telesto 2020-06-10 21:17:43 UTC 
Created attachment 161862 [details]
Example file
Comment 2 Telesto 2020-06-10 21:19:47 UTC 
Pressing the cancel button after dialog appears is also slow
Comment 3 Buovjaga 2020-10-17 12:51:24 UTC 
Created attachment 166460 [details]
Perf flamegraph

Repro lag

Arch Linux 64-bit
Version: 7.1.0.0.alpha0+
Build ID: 9b34dc20b6946698ae6ce2d5d859885bfb444633
CPU threads: 8; OS: Linux 5.8; UI render: default; VCL: kf5
Locale: fi-FI (fi_FI.UTF-8); UI: en-US
Calc: threaded
Built on 16 October 2020
Comment 4 Buovjaga 2022-05-12 11:48:45 UTC 
Still laggy

Version: 7.4.0.0.alpha0+ / LibreOffice Community
Build ID: 32714f966186d301435d3eb9f7f6950bc9a6bb1e
CPU threads: 8; OS: Linux 5.17; UI render: default; VCL: kf5 (cairo+xcb)
Locale: fi-FI (fi_FI.UTF-8); UI: en-US
Calc: threaded