Bug 138411 - Calc gets very slow with diagram and large number of rows EDITING, FILESAVE
Summary: Calc gets very slow with diagram and large number of rows EDITING, FILESAVE
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.5.0 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: perf
Depends on:
Blocks: Performance
  Show dependency tree / graph
 
Reported: 2020-11-22 14:40 UTC by Wolf
Modified: 2022-12-29 06:19 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Attachments
Calc sheet with example data and diagram (3.85 MB, application/vnd.oasis.opendocument.spreadsheet)
2020-11-22 14:43 UTC, Wolf 		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 Wolf 2020-11-22 14:40:49 UTC 
Description:
Adding a diagram to a spreadsheeet with 2 colums and 50.000 rows makes Calc very slow. Editing or dragging the diagram takes several 10s. Saving the file takes about 30 s.
Without the diagram Calc reacts normal, file save takes a few seconds.
An example file is attached.  

Steps to Reproduce:
see attached file


Actual Results:
Calc gets very slow as soon as a diagram is added

Expected Results:
response time should be less than 5 s


Reproducible: Always


User Profile Reset: No


OpenGL enabled: Yes

Additional Info:
in some not easy to reproduce cases LO crashes when editing diagrams in sheets of similar structure and size
Comment 1 Wolf 2020-11-22 14:43:12 UTC 
Created attachment 167475 [details]
Calc sheet with example data and diagram
Comment 2 Buovjaga 2021-07-29 12:34:33 UTC 
Yeah, it's very slow even of my beefy laptop

NixOS
Version: 7.3.0.0.alpha0+ / LibreOffice Community
Build ID: 67e47070a7580a17804adce812cc2f98bfe7b51f
CPU threads: 16; OS: Linux 5.13; UI render: default; VCL: x11
Locale: fi-FI (fi_FI.UTF-8); UI: en-US
Calc: threaded
Comment 3 Buovjaga 2021-08-12 06:54:33 UTC 
Slowness also seen in 6.3, 5.0 and 3.5 (checked with Linux bibisect repos)