Bug 138411

Summary:	Calc gets very slow with diagram and large number of rows EDITING, FILESAVE
Product:	LibreOffice	Reporter:	Wolf <dk4rw>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	NEW ---
Severity:	normal	CC:	buzea.bogdan, dk4rw, ilmari.lauhakangas
Priority:	medium	Keywords:	perf
Version:	3.5.0 release
Hardware:	x86-64 (AMD64)
OS:	Linux (All)
Whiteboard:
Crash report or crash signature:		Regression By:
Bug Depends on:
Bug Blocks:	136524
Attachments:	Calc sheet with example data and diagram

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)