Bug 163015 - FILEOPEN: Opening specific XLSX file takes long time
Summary: FILEOPEN: Opening specific XLSX file takes long time
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
24.8.1.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: perf
Depends on:
Blocks: XLSX
  Show dependency tree / graph
 
Reported: 2024-09-17 18:58 UTC by Souren
Modified: 2025-03-26 13:29 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
Content of the sheet1.xml with customFormat attrbutes (33.44 KB, image/png)
2024-09-17 18:58 UTC, Souren 		Details
sample document (1.61 MB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2024-09-17 18:58 UTC, Souren 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Souren 2024-09-17 18:58:33 UTC 
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.
Comment 1 Souren 2024-09-17 18:58:53 UTC 
Created attachment 196513 [details]
sample document
Comment 2 Souren 2024-11-02 18:57:48 UTC 
Any news on this?
Comment 3 Gabor Kelemen (allotropia) 2024-11-09 21:02:27 UTC 
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.
Comment 4 Souren 2024-12-16 12:47:23 UTC 
Is there any expectation to address this issue? Thanks.
Comment 5 Buovjaga 2025-03-26 13:29:44 UTC 
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