Bug 126021 - Calc - the time required to save some files (in xls or xlsx format) is up to 20x longer in 6.2.4 versus 6.1.6
Summary: Calc - the time required to save some files (in xls or xlsx format) is up to ...
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
Keywords: filter:xls, perf
Depends on:
Blocks: Save XLS
  Show dependency treegraph
Reported: 2019-06-20 08:49 UTC by kabilo
Modified: 2019-06-24 11:55 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

attached file Sesit20.xls (6.60 MB, application/vnd.ms-excel)
2019-06-21 08:46 UTC, kabilo

Note You need to log in before you can comment on or make changes to this bug.
Description kabilo 2019-06-20 08:49:35 UTC
the time required to save some files (in xls or xlsx format) is up to 20x longer in 6.2.4 versus 6.1.6. The time to save these files to ods is ok in both versions LO

Actual Results:
long time to save some file

Expected Results:
speed up the time to save the file

Reproducible: Always

User Profile Reset: No

Additional Info:
Comment 1 Xisco Faulí 2019-06-20 11:39:00 UTC
Thank you for reporting the bug. Please attach a sample document, as this makes it easier for us to verify the bug. 
(Please note that the attachment will be public, remove any sensitive information before attaching it. 
See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.)

I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided.
Comment 2 kabilo 2019-06-21 08:46:03 UTC
Created attachment 152324 [details]
attached file Sesit20.xls

saving a file Sesit20.xls takes more than 4 minutes to xls. To ods format only a few seconds.
Comment 3 Roman Kuznetsov 2019-06-24 09:50:36 UTC
saving of file from attach to XLS takes 36 sec in

Version: (x86)
Build ID: 99971d009e9c96d1d47aec14ecfbfeaa06dc140d
CPU threads: 4; OS: Windows 6.1; UI render: default; VCL: win; 
TinderBox: Win-x86@42, Branch:master, Time: 2019-06-18_03:59:27
Locale: ru-RU (ru_RU); UI-Language: en-US
Calc: threaded

and only 3 sec when I saved it to ODS
Comment 4 kabilo 2019-06-24 11:55:33 UTC
Saving of file from attach to XLS takes:
11 sec in 
256 sec in
29 sec in beta 2 (performance improvements implemented: Speed-up saving files to XLS format. tdf#85470 (Noel Grandin, Collabora)
36 sec in (x86) (see Comment 3 from Roman Kuznetsov)

Version 6.2.x has an extremely long time to save the file. Even after increasing performance in 6.3, saving a file is slower than in 6.1