[Libreoffice-bugs] [Bug 122060] New: Calc: FILESAVE and EDITING very slow with ods file

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 122060
           Summary: Calc: FILESAVE and EDITING very slow with ods file
           Product: LibreOffice
           Version: 6.1.3.2 release
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: urzel at nexgo.de

Description:
After opening the attached file (on openSuse Leap 15.0)
- entering a value in a column, pressing Enter. Calc freezes for about 4 s.
- entering another value in the same column -> no freeze
- entering a value in another column, pressing Enter. Calc freezes again for
about 4 s.
- switching to table "Zusammenfassung" could take up to 22 s (depending on what
editing was done before)
- saving the file. Calc freezes for up to 42 s (depending on what editing was
done before)
Workaround: Saving the file in Excel 2007-2019 format. When using this file and
when saving it back to Excel format all the freezing mentioned above does not
happen.
Why does Calc work well with a non-native file format, but is impressingly slow
with its preferred file format?
It started being slow at file saving, I think, with version 5.3.x. It seemed to
get worse with increasing version number. But 6.1.3.2 seems to be somewhat
faster than version 6.0.7.

Steps to Reproduce:
1. open the attached ods file
2. enter password: bugReport
3. enter a value in a column, press Enter -> Calc freezes for about 4 s.
4. enter a value in another column, pressing Enter. -> Calc freezes again for
about 4 s.
5. Switch to table "Zusammenfassung" -> It take up to 22 s (depending on what
editing was done before) until that table is activated (it contains 7
diagrams).
6. Save the file. Calc freezes for up to 42 s (depending on what editing and
table switching was done before).

Actual Results:
Slow response/freezing as indicated in the steps above.

Expected Results:
Editing shall not be hindered by noticeable delays.
Saving shall be performed within 2-3 seconds.


Reproducible: Always


User Profile Reset: Yes



Additional Info:
Doing the same with version 5.4.x on Windows 10 also shows a file saving delay
of around 5-6 s, but no noticeable editing delay.
As mentioned above: Using a file with the same content in xlsx format works
well.
Also: when opening such a file in ods format as it was saved 3 years ago (don't
know with what version of Calc), editing and switching to table
"Zusammenfassung" works without exceptional delays. That old file was almost
double in size, so I'm wondering if a decompressing/compressing is somehow
causing the large delays.

Version: 6.1.3.2
Build-ID: 10(Build:2)
CPU-Threads: 8; BS: Linux 4.12; UI-Render: Standard; VCL: gtk3_kde5; 
Gebietsschema: de-DE (de_DE.UTF-8); Calc: CL

-- 
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/20181212/ee4fea5c/attachment.html>