Bug 58534 - : Resizing a plot scatter x-y plot with large data causes freeze
Summary: : Resizing a plot scatter x-y plot with large data causes freeze
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Chart (show other bugs)
Version:
(earliest affected)
3.5.4 release
Hardware: Other Linux (All)
: high minor
Assignee: Not Assigned
URL:
Whiteboard: BSA
Keywords: perf
Depends on:
Blocks: XY-Scatter-Chart
  Show dependency tree / graph
 
Reported: 2012-12-19 20:45 UTC by ferran.obon
Modified: 2025-04-05 15:26 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:

Attachments
This is a file for testing. The procedure is explained in the bug report (261.38 KB, application/vnd.oasis.opendocument.spreadsheet)
2012-12-19 20:45 UTC, ferran.obon 		Details
Test file with a chart already built (256.77 KB, application/vnd.oasis.opendocument.spreadsheet)
2025-04-05 15:26 UTC, Laurent Balland 		Details
Show Obsolete (1) 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 ferran.obon 2012-12-19 20:45:19 UTC 
Created attachment 71820 [details]
This is a file for testing. The procedure is explained in the bug report

Problem description: 

When trying to resize a xy scatter plot with large amount of data (two plots with 4096 rows in my case), the program freezes and/or takes a large amount of time to complete the action (if it ever gets completed). It should not be the case in a core i7.
Operating system Debian wheezy and running under KDE.


Steps to reproduce:
1. Create a xy scatter (only lines) plot with large data
2. Resize the plot.
3. The program freezes
4. The attached spreadsheet can be used. Add to a plot scatter plot xy (only lines) with two sets of data:
   - x values: J5 to J4100
   - y1 values: B5 to B4100
   - y2 values: M5 to M4100

Expected behavior: The size of the plot should change in a few seconds maximum and not staying idle using 100% workload on a single core for long time (sometimes more than 10 min).



              
Operating System: Debian
Version: 3.5.4 release
Comment 1 Joel Madero 2013-05-29 18:27:07 UTC 
Thank you for reporting this issue! I have been able to confirm the issue on:
Version: 4.2.0.0.alpha0+Build ID: b0a1666f756aa5f5315366eca9d7d02ddd55d2b
Date:   Tue May 28 08:51:01 2013 +0300 
Platform: Bodhi Linux 2.2 x64

+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +

Per discussion with Markus, this is a known issue that's essentially caused because every resize redraws the points. Anything past about 1000 rows can cause issues with smoothing. 

What I can confirm:
Creating the original scatter plot is quite slow (maybe good to have an attachment with it already made) On my system (dual core 64bit,2.2 ghz, 4 gigs RAM, it's been 10ish minutes and still just calculating stuff)

Resizing will have the same issue since it's just recreating it from scratch essentially.


Marking as:
New (confirmed)
Minor - doesn't prevent high quality work but definitely can slow it down substantially
High - 1000 row threshold is quite low for professional power users. But fix is probably going to be tough and require substantial code changes.




Cc'ing Markus as he's the pro


Thanks for reporting!

+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
LibreOffice is powered by a team of volunteers, every bug is confirmed (triaged) by human beings who mostly give their time for free. We invite you to join our triaging by checking out this link:
https://wiki.documentfoundation.org/QA/BugTriage and join us on freenode at #libreoffice-qa

There are also other ways to get involved including with marketing, UX, documentation, and of course developing -  http://www.libreoffice.org/get-help/mailing-lists/. 

Lastly, good bug reports help tremendously in making the process go smoother, please always provide reproducible steps (even if it seems easy) and attach any and all relevant material
Comment 2 Robinson Tryon (qubit) 2015-12-10 02:02:46 UTC Comment hidden (obsolete)
Comment 3 QA Administrators 2017-01-03 19:40:38 UTC Comment hidden (obsolete)
Comment 4 QA Administrators 2020-11-03 04:00:53 UTC Comment hidden (obsolete)
Comment 5 Buovjaga 2021-11-06 14:47:39 UTC 
(In reply to ferran.obon from comment #0)
> Steps to reproduce:
> 1. Create a xy scatter (only lines) plot with large data
> 2. Resize the plot.
> 3. The program freezes
> 4. The attached spreadsheet can be used. Add to a plot scatter plot xy (only
> lines) with two sets of data:
>    - x values: J5 to J4100
>    - y1 values: B5 to B4100
>    - y2 values: M5 to M4100

I don't understand how to create this chart, the steps are not precise enough. It would be better to have an example file.
Comment 6 QA Administrators 2023-11-07 03:14:28 UTC Comment hidden (obsolete)
Comment 7 Laurent Balland 2025-04-05 15:26:35 UTC 
Created attachment 200178 [details]
Test file with a chart already built

Confirmed with Version: 24.8.6.2 (X86_64) / LibreOffice Community
Build ID: d50be90c1d90f0f90a5235ffcbbafbbfa38a83c2
CPU threads: 8; OS: Linux 6.11; UI render: default; VCL: gtk3
Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR
Calc: threaded
Actually any operation is quite slow, as said in comment 1

Add a test file with the chart as requested in comment 5