Bug 113495 - Calc: very slow scrolling - nearly impossible to work with a graphic inside
Summary: Calc: very slow scrolling - nearly impossible to work with a graphic inside
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.5.7.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: haveBacktrace, perf
Depends on:
Blocks: Scrolling-PageUpDown
  Show dependency treegraph
 
Reported: 2017-10-28 16:37 UTC by Dr. Matthias Weisser
Modified: 2019-03-01 09:30 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
calc sheet with test data (1.58 MB, application/vnd.ms-excel)
2017-10-28 16:37 UTC, Dr. Matthias Weisser
Details
Callgrind output from master (902.20 KB, application/x-xz)
2018-11-24 18:00 UTC, Buovjaga
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Dr. Matthias Weisser 2017-10-28 16:37:38 UTC
Created attachment 137342 [details]
calc sheet with test data

I am using a spreadsheet with 15301 lines. File size is about 1MB. A graphics was done inside for showing data from 2 columns. The graphics was made some bigger by using the mouse. Now its nearly impossible working with this any longer. The Laptop often responds with "keine Rückmeldung". The fan comes up loudly. 

Saving this as .xls and opening using the very old "MS Excel 2000" program this really works fast instead. In comparison there is really no problem working on the graphics now. Everything works fine. 

Why is it not possible getting such performance in the much newer LO version? 
I really would like using LO but as it seems it is not possible as it is now.

I really hope that this will change. If this could be the case as soon as possible this would be useful.

Thank you for your understanding.
Comment 1 Telesto 2017-10-28 19:06:42 UTC
It's probably working better with the upcoming version of LibreOffice. 5.3.7.2. Scrolling/ resizing the graphics/charts is still a bit slow, though. 

http://downloadarchive.documentfoundation.org/libreoffice/old/5.3.7.2/win/
Comment 2 Dr. Matthias Weisser 2017-10-29 08:46:48 UTC
thank you very much for this hint  (In reply to Telesto from comment #1)
> It's probably working better with the upcoming version of LibreOffice.

Thank you very much for this hint Telesto.

I also reported performance problems in Writer with several versions and hoped that there would be relief. So you think 5.3.7.2 would be a good try for both Writer and Calc?

I really hope for more performance because working would be more convenient. In comparison today there is much more pc power there compared to year 2000. Therefore things should work much faster - not slower.
Comment 3 Telesto 2017-10-29 09:18:46 UTC
(In reply to Dr. Matthias Weisser from comment #2)
Software development isn't a straight line of improvement. So things get fixed, others broken. 

Anyway. LibreOffice 5.3.7.2 fix a performance regression introduced with LibreOffice 5.3.2 (https://bugs.documentfoundation.org/showdependencytree.cgi?id=112486&hide_resolved=0)

It affects Calc & Writer. So bug 108388 should be fixed too.
Comment 4 Phoebus 2017-11-09 08:43:42 UTC
I have similar a problem - calc is so slow that it's ununsable. Even small (1 page spreadheet) is unscrollable (few seconds delay for each mouse wheel "turn-click").


Computer is new and has fresh install of LO(=blank profile). Disabling GL rendering does not help.

Version: 5.4.2.2 (x64)
Build ID: 22b09f6418e8c2d508a9eaf86b2399209b0990f4
CPU threads: 4; OS: Windows 6.19; UI render: GL; 
Locale: en-US (en_SI); Calc: group

Computer: i7 7600u + nvidia 940MX
Comment 5 Xavier Van Wijmeersch 2017-11-09 15:05:54 UTC
I did some test with the attachment
When cutting the chart from the data sheet and pasting the chart in another sheet, the data sheet is scrolling nice. But when scrolling the chart sheet it becomes slow and mostly unworkable. My thought on it, i think it is the chart wish cause the problem. Maybe the rendering bit of the chart???

Best regards

Version: 6.0.0.0.alpha1+
Build ID: 474f0ec77f0458c9403a2e8d7452fa1885bd8a60
CPU threads: 8; OS: Linux 4.9; UI render: default; VCL: kde4; 
Locale: nl-BE (en_US.UTF-8); Calc: group
Comment 6 Telesto 2017-11-09 16:37:09 UTC
Also a repro with:
LibreOffice 3.5.7.2 
Build ID: 3215f89-f603614-ab984f2-7348103-1225a5b
Comment 7 Linus 2017-11-12 20:24:07 UTC Comment hidden (obsolete)
Comment 8 Linus 2017-11-12 20:40:44 UTC Comment hidden (obsolete)
Comment 9 Telesto 2018-07-10 15:33:32 UTC
The image appears to be a GDI Metafile
Comment 10 Buovjaga 2018-11-24 18:00:17 UTC
Created attachment 147006 [details]
Callgrind output from master

For me, the delay is slight. Not unworkable by any standards. I took a callgrind trace nevertheless.

Arch Linux 64-bit
Version: 6.3.0.0.alpha0+
Build ID: 51e6a95757906dff8b2819a4141bf3dc7938e95f
CPU threads: 8; OS: Linux 4.19; UI render: default; VCL: gtk3_kde5; 
Locale: fi-FI (fi_FI.UTF-8); UI-Language: en-US
Calc: threaded
Built on 24 November 2018