Bug 140036

Summary:	OPEN: Lot of time in 'Adapt row height' opening a spreadsheet with a large conditional format
Product:	LibreOffice	Reporter:	m_a_riosv <miguelangelrv>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED DUPLICATE
Severity:	normal	CC:	79045_79045, vsfoote, xiscofauli
Priority:	medium	Keywords:	bibisectRequest, perf, regression
Version:	6.3 all versions
Hardware:	All
OS:	Windows (All)
Whiteboard:
Crash report or crash signature:		Regression By:
Bug Depends on:
Bug Blocks:	109530
Attachments:	Sample file for test

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