Bug 79927

Summary: LibreOffice Calc very slow to plot xy line graphic
Product: LibreOffice Reporter: giovanni <giovamm1>
Component: ChartAssignee: Not Assigned <libreoffice-bugs>
Status: NEW --- QA Contact:
Severity: critical    
Priority: medium CC: blackcatred, suokunlong
Version: 4.2.4.2 release   
Hardware: x86-64 (AMD64)   
OS: Linux (All)   
See Also: https://bugs.freedesktop.org/show_bug.cgi?id=58534
Whiteboard:
i915 platform: i915 features:
Attachments: test file-8500 lines. With a graphic.

Description giovanni 2014-06-11 19:38:09 UTC
Created attachment 100900 [details]
test file-8500 lines. With a graphic.

Drawing a xy graphic with 8500+ lines takes too long.
Resizing the same graphic to a bigger size takes too long.
with over 10000 data points i needed to kill the program.

A workaround is to do the following:
1)Disable anti-aliasing. 
2)Plot/Resize.
3)Enable anti-aliasing.
This provides a much faster way, but should not be needed.


This problem does not occur with simple linear graphics.
Comment 1 Kevin Suo 2014-06-13 02:26:52 UTC
Comment on attachment 100900 [details]
test file-8500 lines. With a graphic.

Fixed MIME Type.
Comment 2 Kevin Suo 2014-06-13 03:01:54 UTC
Hi giovanni,

I do not reproduce the "long time" problem with your xy scatter chart, Drawing a xy scatter chart and resizing the chart was done within 5 seconds, no freezing.

However, I encounter the freeze issue when I was trying to draw a "line chart: lines only". It takes 20+ seconds for the chart to finish drawing. (This may be a different problem and I will consider to file a saparate bug report)

Steps to reproduce:
1. Open attachment 100900 [details];
2. Insert -> Object -> Chart -> Chart type: Line (Lines Only) -> Next -> Choose "First column as label", finish.

Current behaviour:
Calc freezes for more than 20 seconds to draw the line chart.

Version 4.2.5.1 and 4.3.0.0 beta2
OS: Windows XP SP3.
Comment 3 giovanni 2014-06-15 21:38:33 UTC
Sorry for the lack of infomation. 
Using the xy scatter chart, but not the dots only, any of the other options to draw the xy scatter chart, line and dots, only lines or the 3d lines.
Using the option to draw only the dots does not reproduce the problem.
Comment 4 Tom 2014-08-10 13:28:33 UTC
Hi,

Just to confirm - I was able to reproduce giovanni's problem in LO 4.1 and 4.3. And I have been experiencing poor performance with graphs for large data sets (around 10k rows and more) in both LibreOffice/OpenOffice. What is rendered in Excel in a snap, can take minutes in LO, to the point that it becomes unusable.

Also, I believe this should be merged with at least the following two:

"Bug 70872 - Calc very slow with charts with large numbers"
https://bugs.freedesktop.org/show_bug.cgi?id=70872

Whis was marked as a "duplicate" of:
"Bug 80677 - UI: Very sluggish with larger data sets"
https://bugs.freedesktop.org/show_bug.cgi?id=80677

Is there anyone looking at resolving this issue, please?
Comment 5 Mike 2014-10-26 19:38:16 UTC
CONFIRMED on Slack 14.1 + LO 4.4.0.0.alpha1.

Repro Steps:
- Grabbed the attachment that was provided by giovanni.

I can confirm the long drawing time for the graph, and for resizing when increasing the size of the graph.  However, shrinking the graph doesn't take long at all.

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.