Bug 126326 - FILESAVE XLSX Saving empty file with many sheets is slow
Summary: FILESAVE XLSX Saving empty file with many sheets is slow
Status: NEEDINFO
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.4.0.0.alpha0+ Master
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisectRequest, filter:xlsx, perf, regression
Depends on:
Blocks:
 
Reported: 2019-07-10 13:32 UTC by NISZ LibreOffice Team
Modified: 2019-08-15 13:02 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Attachments
Example file from Calc (8.30 KB, application/vnd.oasis.opendocument.spreadsheet)
2019-07-10 13:32 UTC, NISZ LibreOffice Team 		Details
Screenshot of system monitor on Ubuntu during xlsx save (269.55 KB, image/png)
2019-07-14 18:54 UTC, Gabor Kelemen 		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 NISZ LibreOffice Team 2019-07-10 13:32:06 UTC 
Description:
If a spreadsheet contains many (~250) sheets, saving it to XLSX takes a rather long time.

Steps to Reproduce:
1.	Open Settings – Calc – Defaults and change the number of sheets in a new document to 250
2.	Create a new spreadsheet.
3.	Save it to XLSX


Actual Results:
The save takes about 20 seconds in LO 6.2.0.
In LO 6.4master it is still about 15 seconds. 
Similarly it takes 15-20 seconds in:

Verzió: 5.0.0.5
Build az.: 1b1a90865e348b492231e1c451437d7a15bb262b
Területi beállítások: hu-HU (hu_HU)

Verzió: 4.2.0.4
Build az.: 05dceb5d363845f2cf968344d7adab8dcfb2ba71

Verzió: 4.1.0.4
Build az.: 89ea49ddacd9aa532507cbf852f2bb22b1ace28

It’s much better, about 5 seconds in:
Verzió: 4.0.0.3 (Build az.: 7545bee9c2a0782548772a21bc84a9dcc583b89)



Expected Results:
It should happen faster than that. Excel can do this on the same machine in < 1 second.


Reproducible: Always


User Profile Reset: No



Additional Info:
LibreOffice details:
Version: 6.4.0.0.alpha0+ (x86)
Build ID: 49422a469646ad8be43ba828ca24c2484c26b9e8
CPU threads: 4; OS: Windows 6.3; UI render: GL; VCL: win; 
TinderBox: Win-x86@42, Branch:master, Time: 2019-07-08_00:50:19
Locale: hu-HU (hu_HU); UI-Language: en-US
Calc: CL
Comment 1 NISZ LibreOffice Team 2019-07-10 13:32:53 UTC 
Created attachment 152708 [details]
Example file from Calc
Comment 2 Durgapriyanka 2019-07-10 15:56:18 UTC 
Thank you for reporting the bug. I couldn't reproduce the bug in 

Version: 6.3.0.0.alpha0+
Build ID: b6b28931435e44aca92b8c0e1659f701e3ed1a87
CPU threads: 2; OS: Windows 6.1; UI render: default; VCL: win; 
TinderBox: Win-x86@42, Branch:master, Time: 2019-01-30_06:57:04
Locale: en-US (en_US); UI-Language: en-US
Calc: threaded

and
LibreOffice 3.3.0 
OOO330m19 (Build:6)
tag libreoffice-3.3.0.4

It takes less than 2 seconds to save empty file with many sheets.
Comment 3 Gabor Kelemen 2019-07-14 18:54:12 UTC 
Created attachment 152767 [details]
Screenshot of system monitor on Ubuntu during xlsx save

It's also slow on my local master build (but maybe because of the debug build), saving takes about 2 MINUTES:

Verzió: 6.4.0.0.alpha0+
Build az.: a871265f202255702541e990d67b605d778d5a92
CPU szálak: 4; OS: Linux 4.15; Felületmegjelenítés: alapértelmezett; VCL: gtk3; 
Területi beállítások: hu-HU (hu_HU.UTF-8); UI-Language: hu-HU
Calc: threaded
Comment 4 Xisco Faulí 2019-08-15 13:02:28 UTC 
it takes ~8 seconds in

Version: 6.4.0.0.alpha0+
Build ID: fe00a724a918606e5c8c2c32b155bc50b33d56bd
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; 
Locale: ca-ES (ca_ES.UTF-8); UI-Language: en-US
Calc: threaded

@Gabor, could you please try with a non-debug build ?