Bug 140036 - OPEN: Lot of time in 'Adapt row height' opening a spreadsheet with a large conditional format
Summary: OPEN: Lot of time in 'Adapt row height' opening a spreadsheet with a large co...
Status: RESOLVED DUPLICATE of bug 124098
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.3 all versions
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisectRequest, perf, regression
Depends on:
Blocks: File-Opening
  Show dependency tree / graph
 
Reported: 2021-01-31 13:17 UTC by m_a_riosv
Modified: 2021-07-30 12:40 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Attachments
Sample file for test (2.07 MB, application/vnd.oasis.opendocument.spreadsheet)
2021-01-31 13:18 UTC, m_a_riosv 		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 m_a_riosv 2021-01-31 13:17:48 UTC 
Description:
Since 6.3 takes a lot of time opening a spreadsheet with a large conditional format.

Steps to Reproduce:
1. Open attached file. About 2 minutes open.
2. Change the range for the conditional format to something like A2:N500
3. Save the file and close it.
4. Open the file again, about 15 seconds

Actual Results:
A lot of time to open while 'Adapt row height' with a large conditional format.

Expected Results:
Like with 6.2.7 about 10-15 seconds.


Reproducible: Always


User Profile Reset: Yes



Additional Info:
Last working fine about 30 seconds to load.
Versión: 6.2.7.1 (x64)
Id. de compilación: 23edc44b61b830b7d749943e020e96f5a7df63bf
Subprocs. CPU: 4; SO: Windows 10.0; Repres. IU: predet.; VCL: win; 
Configuración regional: es-ES (es_ES); Idioma de IU: es-ES Calc:

Reproducible with master about 2 minutes to open.
Version: 7.2.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: 6ca7be8f10deb75399377f25277b943af40f72f1
CPU threads: 4; OS: Windows 10.0 Build 21296; UI render: default; VCL: win
Locale: es-ES (es_ES); UI: en-US Calc: CL
Comment 1 m_a_riosv 2021-01-31 13:18:39 UTC 
Created attachment 169330 [details]
Sample file for test
Comment 2 Roman Kuznetsov 2021-01-31 21:07:34 UTC 
it takes about 35 sec in

Version: 7.2.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: 8c9341120c922ca5eadf64756ea858a84563ee51
CPU threads: 4; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: Skia/Raster; VCL: win
Locale: ru-RU (ru_RU); UI: ru-RU
Calc: CL
Comment 3 m_a_riosv 2021-01-31 23:16:31 UTC 
If it can make a difference:
8 GB, Intel(R) Core(TM) i7-7500U CPU @ 2.70GHz, 2 main processors, 4 logic processors
Comment 4 Xisco Faulí 2021-02-23 09:48:29 UTC 
it looks like a dupe of bug 124098

*** This bug has been marked as a duplicate of bug 124098 ***
Comment 5 V Stuart Foote 2021-07-30 12:40:41 UTC 
opening attachment 169330 [details] ODF archive and editing the content.xml to change the two row styles from 'use-optimal-row-height="true"' to "false" -- the sheet opens in about 5 seconds. With them intact in the original open in 18 seconds.

Kevin Suo gives possible approach to fix the regression caused by work on bug 62268


Version: 7.3.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: cb2827f5f65324f309fa0e3c30d0b19ad237410e
CPU threads: 8; OS: Windows 10.0 Build 19043; UI render: default; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: threaded