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
Can attach a file showing the issue?
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 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!
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!
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
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.
What's the password to open the file?
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.
Sounds like bug 105844. *** This bug has been marked as a duplicate of bug 105844 ***