Description: As title stated, Hello, I'm facing a performance Issue on a spreadsheet file, when it contain 700-1000 rows of data that's using chart with 3 different chart, on different sheet, it freeze, and takes time to load, but when using other office (MS[on wine or not], WPS, Only, Google on Web Browser), I don't face the same problem. I referred to open Bugs ticket on LO Bugzilla when on LiberaChat and reddit by other LO contributor. More Detail Version : Version: 7.3.6.2 Build ID: 30(Build:2) CPU threads: 4; OS: Linux 6.0; UI render: default; VCL: gtk3 Locale: id-ID (en_US.utf8); UI: en-US Calc: threaded and other version Version: 7.4.2.3 / LibreOffice Community Build ID: 382eef1f22670f7f4118c8c2dd222ec7ad009daf CPU threads: 4; OS: Linux 6.0; UI render: default; VCL: gtk3 Locale: id-ID (en_US.utf8); UI: en-US Calc: threaded This is the sampe data(in xlsx), even it's from ods, it yield same behavior https://isttsacid-my.sharepoint.com/:x:/g/personal/ben_stts_edu/ERzzHEXW9U5NnnrZXDZ3GfUB7x_rRzLwB8Wp04NoosAr1g?e=eyJaeT Could anyone test this? Is there any workaround for it? As I start using LO daily, this is a hazzle tbf for me, that I need to spin up KVM Win 10 or using Wine/CrossOver MS Office 2021...(which partially broken on Wine, and spin up KVM is also a burden sometimes) Thank you Steps to Reproduce: 1.Open the xlsx/ods that contain chart that have more than 800 data points 2. wait, and look into task manager, CPU spike, fan kick in, wait... 10-15 minutes 3. data opened, but not usable, as scrolling is very very slow Actual Results: Slow, unusable spreadsheet/calc Expected Results: Open fine like in other office suite, not making it slowdown and spike CPU Reproducible: Always User Profile Reset: Yes Additional Info: Version: 7.4.2.3 / LibreOffice Community Build ID: 382eef1f22670f7f4118c8c2dd222ec7ad009daf CPU threads: 4; OS: Linux 6.0; UI render: default; VCL: gtk3 Locale: id-ID (en_US.utf8); UI: en-US Calc: threaded Fedora 36, latest update.
Created attachment 183391 [details] The sample xlsx This is the sample xlsx, could be tested by any LO version
Confirm slowness with Version: 7.5.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 9cd0f4c2d25462feba0ffcbd906c199273821243 CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: Skia/Raster; VCL: win Locale: nl-NL (nl_NL); UI: en-US Calc: CL threaded and with 7.1
A flamegraph would be nice
Created attachment 183401 [details] Sample file modified chart ranges Seems calc doesn't like column ranges in chart ranges. Charts have column ranges, but calc doesn't treat them like that and doesn't shortcut to analyze at then end of the data. Changed in the sample file, the chart ranges to 9999 rows, runs very smoothly. It also makes load and save near instantly. And problem with the original sample, at load & save it's also in ods format.
(In reply to m.a.riosv from comment #4) > Created attachment 183401 [details] > Sample file modified chart ranges > > Seems calc doesn't like column ranges in chart ranges. > Charts have column ranges, but calc doesn't treat them like that and doesn't > shortcut to analyze at then end of the data. > Changed in the sample file, the chart ranges to 9999 rows, runs very > smoothly. > > It also makes load and save near instantly. And problem with the original > sample, at load & save it's also in ods format. Could you share the resulted ods file? I want to try here, thanks. Because last time I tried to create a brand new ods file using that method, it ends up like the xlsx, so I think it's the same problem. thanks.
Created attachment 183404 [details] Flamegraph Here's a Flamegraph retrieved on pc Debian x86-64 with master sources updated today + gen rendering.
Let's put this one to NEW since we can reproduce the slowness. Eike/Noel: perhaps you may find some ways to improve perf from the Flamegraph.
Created attachment 183424 [details] Ods file
(In reply to m.a.riosv from comment #8) > Created attachment 183424 [details] > Ods file Sadly it's worst here, 15-20 minutes waiting to load, and unresposive sadly.. hmm.... :/ My computer is i7-2640m, 12gb ram, and SATA SSD with speed of 550mb read write, hmm... For now I will spin KVM with Excel first, anyway the ods open fast in Other office, but not in libre :/
(In reply to m.a.riosv from comment #8) > Created attachment 183424 [details] > Ods file But it's usable after the ods loaded, which is nice, just the file is big, very big, 300kb to 5mb ah... Thanks for sharing!
Created attachment 183498 [details] Another demonstration document I have the same issue. Core i7 2700k with 32GB RAM and an SSD. Opening the file is slow, clicking on the graph to edit it hangs for several minutes. Version: 7.1.1.2 (x64) / LibreOffice Community Build ID: fe0b08f4af1bacafe4c7ecc87ce55bb426164676 CPU threads: 8; OS: Windows 6.3 Build 9600; UI render: Skia/Raster; VCL: win Locale: en-GB (en_GB); UI: en-GB Calc: threaded
Dear Benyamin Limanto, 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://web.libera.chat/?settings=#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
Noel Grandin committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/51ea035a6f1f05260381bf98373774cde7ce5dfa tdf#151876 speedup editing large chart It will be available in 25.8.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Noel Grandin committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/6ed923f647aaae79f36039b735c53592a4864ecb tdf#151876 speedup editing large chart (2) It will be available in 25.8.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Noel Grandin committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/b00bb0e9dcde085c103d42a7e22149bd914a91a9 tdf#151876 shave some time off chart load It will be available in 25.8.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Noel Grandin committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/8009183a7a4cd1f5b2b6e78e480ade3f10d0eff2 tdf#151876 shave some time off chart load (2) It will be available in 25.8.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Noel Grandin committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/7881f210b439fcee025daaac56115cb0f868a402 tdf#151876 shave some time off chart load (3) It will be available in 25.8.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Noel Grandin committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/f2924ccd27919f850e94e5ab68dc8f908058a066 tdf#151876 no need to insert zero here It will be available in 25.8.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Noel Grandin committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/cd22ac3f63084a4290fa5cdad8300f7a69b2030e tdf#151876 flatten data-structure a little It will be available in 25.8.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.