Created attachment 196512 [details] Content of the sheet1.xml with customFormat attrbutes FILEOPEN: When opening specific XLSX file with (customFomat="1") attributes on the sheetData row element, it takes 5+ minutes to open such a file. Attached the screenshot of the <sheetData> content and a sample document.
Created attachment 196513 [details] sample document
Any news on this?
Confirming behavior in Version: 25.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 9e3803ae438ddcf91ec0e15431be379561d28ba6 CPU threads: 14; OS: Windows 10 X86_64 (10.0 build 19045); UI render: Skia/Raster; VCL: win Locale: hu-HU (hu_HU); UI: en-US Calc: default was not really better in earlier versions, so not a regression.
Is there any expectation to address this issue? Thanks.
Seems there is a recent pessimisation. In 25.2.1 this takes real 0m54,973s user 0m54,317s sys 0m1,220s while latest master takes real 1m45,889s user 1m44,989s sys 0m1,257s Not yet seen in the last commit of linux-64-25.8 repo with: Date: Thu Mar 20 07:47:57 2025 +0100 Arch Linux 64-bit Version: 25.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 535c1f2561570b85c64eab846d6f95da6cf1ff64 CPU threads: 8; OS: Linux 6.13; UI render: default; VCL: gtk3 Locale: fi-FI (fi_FI.UTF-8); UI: en-US Calc: CL threaded Built on 26 March 2025
(In reply to Buovjaga from comment #5) > Seems there is a recent pessimisation. In 25.2.1 this takes > > real 0m54,973s > user 0m54,317s > sys 0m1,220s > > while latest master takes > > real 1m45,889s > user 1m44,989s > sys 0m1,257s > > Not yet seen in the last commit of linux-64-25.8 repo with: Date: Thu Mar > 20 07:47:57 2025 +0100 It seems this happened with commit 2824c9ca4ba53f015f9b8f279b347585ee847818 use more concrete UNO in sc
Noel Grandin committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/0d62ab61e982a0967386e40f21829fc95870b969 tdf#163015 FILEOPEN: Opening specific XLSX file takes long time 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.
Rather good now: real 0m15,619s user 0m13,187s sys 0m1,621s Arch Linux 64-bit Version: 25.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 0d62ab61e982a0967386e40f21829fc95870b969 CPU threads: 8; OS: Linux 6.14; UI render: default; VCL: kf6 (cairo+wayland) Locale: fi-FI (fi_FI.UTF-8); UI: en-US Calc: CL threaded Built on 10 May 2025