Bug 112881 - calc needs a lot of time saving a document (ods)
Summary: calc needs a lot of time saving a document (ods)
Status: RESOLVED DUPLICATE of bug 105844
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.3.0.0.alpha0+
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2017-10-04 17:50 UTC by Patrick T.
Modified: 2017-10-08 15:06 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
example document (82.25 KB, application/vnd.oasis.opendocument.spreadsheet)
2017-10-04 18:21 UTC, Patrick T.
Details
without password protection (88.06 KB, application/vnd.oasis.opendocument.spreadsheet)
2017-10-05 18:07 UTC, Patrick T.
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Patrick T. 2017-10-04 17:50:41 UTC
Description:
I have a document to have an overview about my financial planning over some months. It contains 4 tabs which reference the first tab for diagrams and stuff. So it's a quite small document - A1:K55 on the first (mostly filled) tab. Normally it is saved to SSD in a fraction of a second on my Core i7-6700HQ (quad) laptop. Sometimes I change some numbers in the document, insert or delete rows, move rows and re-calculate sums. After some weeks, saving the documens (by ctrl+s) suddenly takes several seconds and LibreOffice is non-responsive during that time. If once happened, this happens everytime on saving.

Workarounds found:
(1) Wait several seconds on each and every "save document" (INACCEPTABLE)
(2) create a new document, copy contents of each tab into new document, save as a new file, delete the old file (INACCEPTABLE)

Maybe the bug started to happen a few versions earlier (I don't remember exactly, but it was anytime between 5.1.x and the currently used version 5.4.1.2 on Windows 10 x64. I was thinking, it's so critical that it should already be fixed.

Steps to Reproduce:
(see detailled description)
1. create a small ods document and save it
2. open it several dozens of times, do tiny modifications (numbers, insertions, deletions, references/calculations) and save+close it
3. in case it doesn't happen, repeat (2) for several weeks up to 2 months (needing no more than 5 modifications bi-daily).

Actual Results:  
Saving a document normally works quickly. After some (tiny) changes in the document it suddenly takes a lot of time, everytime you save again, even after re-opening.

Expected Results:
Saving a document with really tiny changes shouldn't suddenly take several seconds blocking the complete user interface. It works well until some point, then it will always take a lot of time.


Reproducible: Always

User Profile Reset: No

Additional Info:
Locale: de
Module: SpreadsheetDocument
OS: Windows (All)
OS is 64bit: yes
File Format: ods
Builds ID: LibreOffice 5.4.1.2


User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/61.0.3163.100 Safari/537.36
Comment 1 m_a_riosv 2017-10-04 17:56:02 UTC
Can attach a file showing the issue?
Comment 2 Patrick T. 2017-10-04 18:21:20 UTC
Created attachment 136764 [details]
example document

The attached file takes ~4 seconds to save right now. It blocks the UI even on auto-save for that time. Copy all tabs to a new document and save it to another file name - then you'll see how it works correctly. Opening seems to take also some more time. And I notice a significant cpu load (e.g. the fan gets quite loud which is not supposed to happen saving a 84kB file). Additionally, file size changes nearly everytime, even if I don't modify anything!
Comment 3 Patrick T. 2017-10-04 18:21:57 UTC
Comment on attachment 136764 [details]
example document

The attached file takes ~4 seconds to save right now. It blocks the UI even on auto-save for that time. Copy all tabs to a new document and save it to another file name - then you'll see how it works correctly. Opening seems to take also some more time. And I notice a significant cpu load (e.g. the fan gets quite loud which is not supposed to happen saving a 84kB file). Additionally, file size changes nearly everytime, even if I don't modify anything!
Comment 4 Patrick T. 2017-10-04 18:23:04 UTC
The attached file takes ~4 seconds to save right now. It blocks the UI even on auto-save for that time. Copy all tabs to a new document and save it to another file name - then you'll see how it works correctly. Opening seems to take also some more time. And I notice a significant cpu load (e.g. the fan gets quite loud which is not supposed to happen saving a ~84kB file). Additionally, file size changes nearly everytime, even if I don't modify anything!
Comment 5 V Stuart Foote 2017-10-04 19:32:38 UTC
As you are on Windows this seems very similar to just resolved issue for bug 112486.

Could you please check against a copy of the document with a current build of 6.0 master, or the daily 5.3.7

Found here:
5.3.7
http://dev-builds.libreoffice.org/daily/libreoffice-5-3/Win-x86_64@62-TDF/current/

6.0.0
http://dev-builds.libreoffice.org/daily/master/Win-x86_64@42/current/

=-ref-=
https://wiki.documentfoundation.org/Installing_in_parallel/Windows
Comment 6 Patrick T. 2017-10-05 13:25:45 UTC
I have checked it now in 6.0.0-alpha0-master (daily-2017-10-05) and the problem is still present. Saving the little file blocks the GUI for 4+ seconds.

I would appreciate if you would look for the cause of the problem using my previously attached example file instead of guessing for duplicates.
Comment 7 m_a_riosv 2017-10-05 16:30:18 UTC
What's the password to open the file?
Comment 8 Patrick T. 2017-10-05 18:07:46 UTC
Created attachment 136786 [details]
without password protection

Sorry, I forgot to remove password protection. Here is the unprotected document.

But this showed me some other facts:
(1) After removing the password, the bug doesn't happen anymore. But trust me, encryption overhead cannot be the (only) cause of the problem since I always use a password for this file, in former times saving was quick and 4+ seconds are way too much to encrypt just 82kB of data.
(2) Save it again using your own password and the failure appears.
(3) Sadly, the workaround to copy tab by tab into a new (encrypted ods) file doesn't seem to work anymore.
Comment 9 Telesto 2017-10-08 15:06:01 UTC
Sounds like bug 105844.

*** This bug has been marked as a duplicate of bug 105844 ***