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 ...
Status: UNCONFIRMED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.2.4.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
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:


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

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
Description:
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: 6.4.0.0.alpha0+ (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 6.1.6.3 
256 sec in 6.2.5.1
29 sec in 6.3.0.0 beta 2 (performance improvements implemented: Speed-up saving files to XLS format. tdf#85470 (Noel Grandin, Collabora)
36 sec in 6.4.0.0.alpha0+ (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