I upgraded to 7.4 but found that opening an xlsx spreadsheet has become very slow. I tried the latest available release with the same result. I have reverted to 7.3.7 and that is fine. Not a large spreadsheet, so that should not be the problem, I will continue with 7.3 in the meantime.
Please attach a sample file showing the issue. BTW Please test in safe mode, Menu/Help/Restart in Safe Mode
I have now removed V7.4 from my system so cannot do further testing. The simple fact is that any xlsx file opens very slowly on 7.4.x, as shown by progress bar, but almost instantly on 7.3. I am sticking with 7.3
[Automated Action] NeedInfo-To-Unconfirmed
We can't help and deveopers can't fix the problem if you will not give us the file example Set to NEEDINFO while we'll get the exaple. Thanks
Created attachment 183561 [details] xlsx Spreadsheet I have attached a xlsx document for you. It is academic because any xlsx spreadsheet has the same delay in opening.
Something no good for calc at load the xlsx, it doesn't disappear save as ods and reopening and saving as xlsx. What makes clean the issue is selecting all sheet and copying to a new file (through Menu/Sheets/Copy-Move, right-click breaks the selection). Even cleaning all data and formatting, saving as ods, then as xlsx, and load. The delay persist. Reproducible Version: 7.4.3.1 (x64) / LibreOffice Community Build ID: 3793858a34d8fef5b92f8fee233f97766f05e281 CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL Version: 7.5.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 3c0be5564afe1b9cc843a49aba88b72af74c43ab CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded Last working much much better Version: 7.3.7.2 (x64) / LibreOffice Community Build ID: e114eadc50a9ff8d8c8a0567d6da8f454beeb84f CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Vulkan; VCL: win Locale: es-ES (es_ES); UI: es-ES Calc: CL
I bisected this one in win64-7.4 bisect repo and got https://git.libreoffice.org/core/commit/4c5f8ccf0a2320432b8fe91add1dcadf54d9fd58 https://gerrit.libreoffice.org/c/core/+/131180 Added to CC: Luboš Luňák Luboš, please take a look, thanks.
7.3 latest 1,55s user 0,24s system 73% cpu 2,460 total 7.4 latest 7,72s user 0,25s system 93% cpu 8,487 total 7.5 latest 7,53s user 0,23s system 90% cpu 8,524 total 7.6+ 7,41s user 0,20s system 91% cpu 8,327 total
Noel, may you can look at this perf regression?
https://gerrit.libreoffice.org/c/core/+/153006
Noel Grandin committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/e0ef3fed69864530da49cecb09fcc2fcc9acfeaa tdf#151946 cache LocaleDataWrapper It will be available in 24.2.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 "libreoffice-7-6": https://git.libreoffice.org/core/commit/ce28e756c3dde56b59cf80c7e6f21f305e76eb25 tdf#151946 cache LocaleDataWrapper It will be available in 7.6.0.0.beta2. 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.