Bug 161986 - ODS fileopen got much slower in 7.4
Summary: ODS fileopen got much slower in 7.4
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.4.0.3 release
Hardware: All All
: high normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisected, bisected, perf, regression
Depends on:
Blocks:
 
Reported: 2024-07-10 17:51 UTC by Timur
Modified: 2024-07-10 21:01 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Attachments
sample ODS (1.21 MB, application/vnd.oasis.opendocument.spreadsheet)
2024-07-10 17:51 UTC, Timur 		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 Timur 2024-07-10 17:51:13 UTC 
Created attachment 195213 [details]
sample ODS

ODS fileopen got much slower in 7.4, from 15 to 90 seconds.

Bisected to:

commit 5e402bac39dc4245844efbde442bdb3bd993a157	[log]
author	Luboš Luňák <l.lunak@collabora.com>	Thu Feb 10 13:38:56 2022 
committer	Luboš Luňák <l.lunak@collabora.com>	Thu Feb 10 21:53:34 2022 
remove most hardcoded MAXCOL/MAXROW from Calc filters
Comment 1 m_a_riosv 2024-07-10 21:01:49 UTC 
The issue look comes from the whole column A cells in CHART sheet are merged in one, also column A in Sheet8 is merged.
Unmerged them and the file is saved and loaded very quick.
Version: 24.2.5.1 (X86_64) / LibreOffice Community
Build ID: 2ccb78ad6bdfe3f3356a7a7f294ec388775c5816
CPU threads: 16; OS: Windows 10.0 Build 22631; UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: en-US
Calc: CL threaded