[Libreoffice-bugs] [Bug 141508] New: LibreCalc gets slower when progressing through large spreadsheets

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 141508
           Summary: LibreCalc gets slower when progressing through large
                    spreadsheets
           Product: LibreOffice
           Version: 7.0.5.2 release
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: vannerwinner at gmail.com

Description:
As a volunteer census checker I often work with spreadsheets of 5K to 6K lines.
When I first start working through a sheet response from Calc is great. As I
get up to line 2000 however Calc begins to get sluggish - I have been making
changes to the data every 5 rows or so on average. Clicking in a field now
takes seconds to respond. Scrolling with the mouse wheel ditto, and most other
actions including saving the file all take palpable seconds to be actioned.
This only occurs from that point in the file onwards. Previously all these
actions work in the blink of an eye, so it is not the size of the file per se,
but one's position in it, or the number of accumulated changes that is the
problem.
I am using vn 7.0.5.2 (x64) on W10 19042 with 8 CPU threads. The problem has
been around for some time, it is not just this vn of LibreOffice.
All other programs and apps work normally.
I have tried searching the Community for similar problems, and have tried some
of the suggestions but they have made no difference, and I haven't found an
issue described in the same way.

Steps to Reproduce:
1. Load a file with 5k+ rows
2. Make some changes, save the file etc. All works normally.
3. Continue making changes every 5 rows or so u to around row 2000.
4. Now actions very sluggish.

Actual Results:
Even after closing and reloading the file, returning to line 1 and making
changes the sluggishness is still there.

Expected Results:
Response should be near instantaneous when the file had not received so many
changes.


Reproducible: Always


User Profile Reset: No


OpenGL enabled: Yes

Additional Info:
Version: 7.0.5.2 (x64)
Build ID: 64390860c6cd0aca4beafafcfd84613dd9dfb63a
CPU threads: 8; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win
Locale: en-GB (en_GB); UI: en-US
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/20210406/98301a55/attachment.htm>