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

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 ?