[Libreoffice-bugs] [Bug 112881] New: calc needs a lot of time saving a document (ods)

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=112881

            Bug ID: 112881
           Summary: calc needs a lot of time saving a document (ods)
           Product: LibreOffice
           Version: 5.3.0.0.alpha0+
          Hardware: x86-64 (AMD64)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: p1703 at gmx.net

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

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20171004/7a621f28/attachment.html>