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.
It's probably working better with the upcoming version of LibreOffice. 188.8.131.52. Scrolling/ resizing the graphics/charts is still a bit slow, though.
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 184.108.40.206 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.
(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 220.127.116.11 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.
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: 18.104.22.168 (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
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???
Build ID: 474f0ec77f0458c9403a2e8d7452fa1885bd8a60
CPU threads: 8; OS: Linux 4.9; UI render: default; VCL: kde4;
Locale: nl-BE (en_US.UTF-8); Calc: group
Also a repro with:
Build ID: 3215f89-f603614-ab984f2-7348103-1225a5b
I'm having the same issue after updating from 5.2 to 22.214.171.124:
See my screen capture:
As you can see, scrolling is still OK with an empty or almost empty sheet. But as soon as there is some more data, the lagging starts!
My system is:
Windows 10 64-bit
nVidia GTX 970M
Let me know if you need further information!
I just realised that 126.96.36.199 was in fact not the newest version. That's strange because the automatic update of my previous 5.2 version redirected me directly to downloading 188.8.131.52.
I now installed 184.108.40.206 and the issue is gone.
(I might also add that the fonts look a lot better again than they did in the 220.127.116.11 version.)
So never mind!
The image appears to be a GDI Metafile
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
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
Built on 24 November 2018