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. 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/
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.
(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.
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
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
Also a repro with: LibreOffice 3.5.7.2 Build ID: 3215f89-f603614-ab984f2-7348103-1225a5b
I'm having the same issue after updating from 5.2 to 5.3.6.1: See my screen capture: https://www.youtube.com/watch?v=o1E0pRjvqhw 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 i7-6820HK 2.70GHz 32GB RAM nVidia GTX 970M Let me know if you need further information!
I just realised that 5.3.6.1 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 5.3.6.1. I now installed 5.3.7.2 and the issue is gone. (I might also add that the fonts look a lot better again than they did in the 5.3.6.1 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 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
Dear Dr. Matthias Weisser, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
There is an almost unnoticeable delay when scrolling past the chart. Matthias: should we close this? Version: 7.4.0.0.alpha0+ / LibreOffice Community Build ID: 32714f966186d301435d3eb9f7f6950bc9a6bb1e CPU threads: 8; OS: Linux 5.17; UI render: default; VCL: kf5 (cairo+xcb) Locale: fi-FI (fi_FI.UTF-8); UI: en-US Calc: threaded
this is hard to say because I do not want to install this at the moment. I tested an earlier 7 version but this was not usable well because of picture loss problem. This was a NoGo for me - so I had to switch back to LO 5.4.7.2. which has other problems. I am sorry to say that LO problems and less performance led to use of an old ppt version from year 2000 instead of LO.
(In reply to Dr. Matthias Weisser from comment #13) > this is hard to say because I do not want to install this at the moment. > > I tested an earlier 7 version but this was not usable well because of > picture loss problem. > > This was a NoGo for me - so I had to switch back to LO 5.4.7.2. which has > other problems. > > I am sorry to say that LO problems and less performance led to use of an old > ppt version from year 2000 instead of LO. If you use Windows, you can install a daily build Win-x86_64@tb77-TDF from https://dev-builds.libreoffice.org/daily/master/current.html and it will not mess with your stable build. LibreOffice performance is being improved every day. To get an idea, you can skim the monthly QA/dev reports https://qa.blog.documentfoundation.org/category/reports/
I have just tested in LO 7.4 and I felt almost no lag while scrolling past the chart. If I wasn't looking for it, I wouldn't have noticed any lag. System info: Version: 7.4.0.0.alpha1+ / LibreOffice Community Build ID: b2467d6c7af988f8ed4e090ebf9472be6c84fb06 CPU threads: 12; OS: Linux 5.13; UI render: default; VCL: kf5 (cairo+xcb) Locale: pt-BR (pt_BR.UTF-8); UI: en-US Calc: CL
Let's close and if Matthias reproduces later with 7.4, we can change the status.