Created attachment 120238 [details] open slowly The xlsm document attach to this bug open very very slowly ...
See https://bugs.documentfoundation.org/show_bug.cgi?id=95548#c1
Same problem on windows and linux and on version 4.2.8 and 5.0.2. But issue 95548 and 95549 concern two realy differents document. It is impossible to say that they have the same issue.
Created attachment 120262 [details] open slowly - reduced This xlsm is linked, and you didn't provide a link. LO should note that and warn, but for the test, please provide that also.
Doesn't look like a duplicate of Bug 53698.
Hello, I don't have the link. I think the document should worked without this link. If the linked document is important for the test i could try to retrieve this. Best regards Anthony
It's valoris 38. MSO cannot break link without it.
Confirmed. It takes minutes, I got bored and killed it. Will try callgrind on Linux later. Win 7 Pro 64-bit Version: 5.2.0.0.alpha1+ Build ID: d848960a3e77a8608a48f3ba394928c955f1e2d9 CPU Threads: 4; OS Version: Windows 6.1; UI Render: default; TinderBox: Win-x86@39, Branch:master, Time: 2016-04-25_06:03:51 Locale: fi-FI (fi_FI)
Created attachment 124644 [details] .xlsm file with macros which opens too slowly Env: XUbuntu 14.04/amd64, Athlon64 X2 4000+, 3GB RAM, LibreOffice 5.1.2.2 build 1:5.1.2~rc2-0ubuntu1~trusty0. 1) Attached file opened in 1:25 (from pressing "Open" button in file select box to "File contains macros" warning) 2) libreoffice --convert-to ods price-april.xlsm lasts 3:25, and 1:50 from start to message "convert .../price-april.xlsm -> .../price-april.ods using filter : calc8"; new file has size ~3.8M 3) libreoffice --convert-to xls price-april.xlsm lasts 2:52, and 1:35 from start to message "convert .../price-april.xlsm -> .../price-april.xls using filter : MS Excel 97"; new file has size ~3.3M 4) .ods opened in 0:20, .xls a bit faster (from pressing "Open" to warning about macros)
*** Bug 95548 has been marked as a duplicate of this bug. ***
Here is a callgrind output of opening the file: http://s000.tinyupload.com/index.php?file_id=09685792322442464873 I used attachment 120238 [details]. It took nearly 12 hours to complete.. Unfortunately, even with tar.xz compression it went slightly over 10M :( I tried .7z, tar.bz2 and tar.lzma as well, but no luck. Arch Linux 64-bit, KDE Plasma 5 Version: 5.2.0.0.alpha1+ Build ID: 540fee2dc7553152914f7f1d8a41921e765087ef CPU Threads: 8; OS Version: Linux 4.5; UI Render: default; Locale: fi-FI (fi_FI.UTF-8) Built on April 30th 2016
Created attachment 124753 [details] Callgrind part 1, 7-zip On the urging of cloph, I decided to split the archive in two and upload so it is never lost.
Created attachment 124754 [details] Callgrind part 2, 7-zip
** Please read this message in its entirety before responding ** 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 on a currently supported version of LibreOffice (5.4.1 or 5.3.6 https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System 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) http://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: http://webchat.freenode.net/?channels=libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug-20170901
I'm having a very similar issue, using LO 5.4.2.2. I am trying to open a 16MB large XLSM file (https://www.dropbox.com/s/m4m1nurerbg0dpf/DS-NKh-Sentence%20Maker.zip?dl=0). The progress bar goes up to about 80% before the process hangs. Task manager shows me LibreOffice is using 25% of the CPU and 1.2GB of RAM, but it doesn't seem to be able to finish the task.
** Please read this message in its entirety before responding ** 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 http://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
it takes real 7m17,041s user 7m9,884s sys 0m2,841s in Version: 6.3.0.0.alpha0+ Build ID: 90e3b47b52f26420425a7417d2f51b6a386282d9 CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; Locale: ca-ES (ca_ES.UTF-8); UI-Language: en-US Calc: threaded
Dear Anthony, 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
Takes 5 seconds now to reach the dialog "The data could not be loaded completely because the maximum number of columns per sheet was exceeded." Closing as wfm Version: 7.2.0.0.alpha0+ (x64) / LibreOffice Community Build ID: 9c930c4f3109d123c0831d0fcecf9c8b32e5bbc7 CPU threads: 2; OS: Windows 10.0 Build 19042; UI render: default; VCL: win Locale: fi-FI (fi_FI); UI: en-US Calc: threaded
Still reproducible here Version: 7.2.0.0.alpha0+ / LibreOffice Community Build ID: dff586735b6618d9b011823594a33287d8f7f223 CPU threads: 4; OS: Linux 5.7; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded real 4m4,785s user 4m0,576s sys 0m2,473s
(In reply to Buovjaga from comment #18) > Takes 5 seconds now to reach the dialog "The data could not be loaded > completely because the maximum number of columns per sheet was exceeded." > > Closing as wfm > > Version: 7.2.0.0.alpha0+ (x64) / LibreOffice Community > Build ID: 9c930c4f3109d123c0831d0fcecf9c8b32e5bbc7 > CPU threads: 2; OS: Windows 10.0 Build 19042; UI render: default; VCL: win > Locale: fi-FI (fi_FI); UI: en-US > Calc: threaded @Buovjaga, could you please bisect when it improved on Windows ?
True, slow still on all Linux backends. macOS test would be nice. Can't bisect on Win yet.
4min 45 sec in Version: 7.2.0.0.alpha0+ / LibreOffice Community Build ID: a52590d76b89dc75be2aa87f4287624c89f1e82f CPU threads: 4; OS: Mac OS X 11.3; UI render: default; VCL: osx Locale: ru-RU (ru_RU.UTF-8); UI: en-US Calc: threaded
MS Excel opens it for about 10 sec It took 6 min 35 sec in Version: 7.2.0.0.alpha0+ (x64) / LibreOffice Community Build ID: 931e264590100c555580c413556e229a0f03316a CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: Skia/Raster; VCL: win Locale: ru-RU (ru_RU); UI: ru-RU Calc: threaded I don't see any improvements here for windows only
Sorry for the noise, I was testing the wrong xlsm on Windows
Noel Grandin committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/b2a1c29d5958e0cc6d8f0e68c11121131dfa1513 tdf#95549 speed up load of xls It will be available in 7.3.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/38027099e773403ffd3314a5b54493adc65150ec tdf#95549 speed up navigator tree load It will be available in 7.3.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/df6a8b15a67baa6e2717a7de7755ac93fdb46723 tdf#95549 speed up xls open It will be available in 7.3.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.
Opens in 43 secs now Version: 7.3.0.0.alpha0+ / LibreOffice Community Build ID: eae0636311d3a1b3a1af58a3e4df686b55afa3fa CPU threads: 8; OS: Linux 5.13; UI render: default; VCL: kf5 (cairo+xcb) Locale: fi-FI (fi_FI.UTF-8); UI: en-US Calc: threaded
Created attachment 174744 [details] perf flamegraph Here's a Flamegraph retrieved on pc Debian x86-64 with master sources updated today + gen rendering.
Reviewing 7.3 release notes. Situation definitely improved for attachment 120238 [details] in: Version: 7.3.0.1 / LibreOffice Community Build ID: 840fe2f57ae5ad80d62bfa6e25550cb10ddabd1d CPU threads: 4; OS: Linux 5.4; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: threaded Took 4m13 to open with 7.2.4.1, now takes 1m20. Are we keeping this opened for potential future improvements? Probably a good idea, especially if MSO can do it in 10 seconds, as per comment 23.
File opening takes around 1 minute in Version: 7.5.0.0.alpha0+ (x64) / LibreOffice Community Build ID: 9d1d668a608cc5b406601c2f7f3d8581e8f47d1c CPU threads: 4; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win Locale: ru-RU (ru_RU); UI: ru-RU Calc: threaded
Original document loads in about 11 seconds, just like in Excel since: https://git.libreoffice.org/core/+/2bda87fd8758448267c447ba26f1932325a1338d commit 2bda87fd8758448267c447ba26f1932325a1338d [log] author Caolán McNamara <caolan.mcnamara@collabora.com> Fri Aug 11 13:29:23 2023 +0100 committer Caolán McNamara <caolan.mcnamara@collabora.com> Sun Aug 13 18:13:20 2023 +0200 defer turning xlsx notes into SdrCaptions until activated Thanks Caolán!