Bug 56505 - VIEWING: Scrolling complex chart is *very* sluggish
Summary: VIEWING: Scrolling complex chart is *very* sluggish
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: UI (show other bugs)
Version:
(earliest affected)
3.6.1.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: BSA
Keywords:
Depends on:
Blocks:
 
Reported: 2012-10-28 21:00 UTC by Troy Sankey
Modified: 2013-09-24 16:27 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
document with graphs that have >1000 data points (750.24 KB, application/vnd.oasis.opendocument.text)
2012-11-05 01:56 UTC, Troy Sankey
Details
spreadsheet that scrolls slowly (268.53 KB, application/vnd.oasis.opendocument.spreadsheet)
2012-11-05 06:41 UTC, Troy Sankey
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Troy Sankey 2012-10-28 21:00:57 UTC
Problem description:
A chart with a lot of data points will cause scrolling to take *very* long when the chart is partially exposed. I seems like the chart is completely recalculated, when it only needs to be calculated once then cached.

This is a general LibreOffice problem, not specific to Calc.

Steps to reproduce:
1. in Calc create a chart with 3,000 data points. The chart now sits between rows 1 and 20
2. scroll down to row 25
3. scroll down to row 50

Current behavior:
Scrolling to row 25 takes very long (on my core i7). Scrolling to 50 is quick.

Expected behavior:
Scrolling should have no delay.

Platform (if different from the browser): 
              
Browser: Mozilla/5.0 (X11; Linux x86_64; rv:16.0) Gecko/20100101 Firefox/16.0
Comment 1 Troy Sankey 2012-10-28 22:35:09 UTC
Also, try scrolling up from below (gradually expose the chart).
Comment 2 Jean-Baptiste Faure 2012-11-04 17:03:25 UTC
Please attach a document showing the problem.

Best regards. JBF
Comment 3 Troy Sankey 2012-11-05 01:56:23 UTC
Created attachment 69531 [details]
document with graphs that have >1000 data points

There are several graphs in this document, but only two of them are slow to scroll across (figures 3 and 4).
Comment 4 Jean-Baptiste Faure 2012-11-05 05:29:44 UTC
Thank you for the attachment, but it is a text document while your bug report is about charts in a spreadsheet. It is not the same problem. Could you attach a spreadsheet showing the original problem ?

When you insert a chart in a text document, you can choose the format of the caption by using paste special in Edit menu. If you don't need to modify the chart from Writer, you should choose to insert the chart as image.

Best regards. JBF
Comment 5 Troy Sankey 2012-11-05 06:41:53 UTC
Created attachment 69533 [details]
spreadsheet that scrolls slowly

Like I said in the first post, this is a general LibreOffice problem not specific to Calc.

I created a spreadsheet with >2000 data points and charted it. Scroll down 50 rows, then back up to row 1.

> If you don't need to modify the chart from Writer, you should choose to insert the chart as image.

Thanks for the tip!
Comment 6 Jean-Baptiste Faure 2012-11-08 06:28:10 UTC
I think the problem comes from anti-aliasing for graphics which is very cpu consuming. You can disable it in the options : menu Tools > Options > LibreOffice > View

If I disable anti-aliasing for graphics, scrolling is smooth. If I enable it scrolling is less smooth. After, that depends on your graphic card.
I did my test with LO 3.6.3 and LO 3.6.4.0+ under Ubuntu 12.04 x86_64

Please, could you try this workaround?

Best regards. JBF
Comment 7 Troy Sankey 2012-11-08 08:52:07 UTC
I have disabled anti-aliasing, and the graphs do look more jagged, but they still scroll very slowly (no change).

LibreOffice 3.5:build-413
radeon OSS graphics drivers on linux 3.6
Comment 8 Troy Sankey 2012-11-08 08:54:34 UTC
Initially I made this report using LO 3.6.1.2 release, but now I've moved to 3.5 temporarily. Problem exists in both versions.
Comment 9 Francisco 2013-01-14 20:32:48 UTC
Hello.

I have experimented the same bug when having complex charts in Calc or even in charts paseted from Calc in Writer. I experimented this not only with a complex chart but also when there are many simple of them. This also happens with big tables on Writer.

In my case, turning off font antialiasing solved the problem, althogh charts look horrble know.

Info about my system is:
Kubuntu 12.04. LibreOffice 3.5.6 (from repos) and 4.0.0.1 (from Libreoffice).
Graphic card: 
1) NVidia 8200GM. Driver version: 304.6, though it has happen with other prior versions.
2) NVIdia 9500G. This is more powerful than the 8200 one, so scrolling is much more faster, totally normal on tables, but it's still noticeable some lag when passing through the charts.


There says "need info". What kind of information is needed?
Comment 10 Troy Sankey 2013-01-14 20:40:12 UTC
Hi Francisco,

1. Can you attach sample .odt and .ods files for me to test?
2. Can you test the sample spreadsheet I attached (comment 5, attachment 69533 [details])?

Previously, disabling antialiasing did *not* fix the problem for me, so I want to test it with your data.
Comment 11 Troy Sankey 2013-01-14 21:47:08 UTC
I just tested attachment 69533 [details] again, but on a different computer.

old computer: core i7 + radeon hd 5870 (radeon open source video drivers)
new computer: core i5 + intel hd 4000 (intel open source video drivers)

Now, everything scrolls smoothly! Perhaps the radeon drivers did not support the 2D acceleration required to display several thousand data points. I still get a little delay scrolling, but disabling antialiasing completely fixes that.

I still consider this a problem/bug, because I feel that an image of the graph should be cached to prevent unnecessary re-rendering. I think it should only render the graph when the cache misses or the view is zoomed.
Comment 12 QA Administrators 2013-09-24 01:54:56 UTC
Dear Bug Submitter,

This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INVALID due to lack of needed information.

For more information about our NEEDINFO policy please read the wiki located here: 
https://wiki.documentfoundation.org/QA/FDO/NEEDINFO

If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed.


Thank you for helping us make LibreOffice even better for everyone!


Warm Regards,
QA Team
Comment 13 Jean-Baptiste Faure 2013-09-24 16:27:17 UTC
Due to comment #11, I will close this bug report as WorksForMe.

Please, feel free to reopen if needed.

Best regards. JBF