Bug 134301 - 3 seconds delay of inserting a row and 6 seconds delay deleting a row in a larger spreadsheet
Summary: 3 seconds delay of inserting a row and 6 seconds delay deleting a row in a la...
Status: RESOLVED DUPLICATE of bug 131894
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.3.0.4 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisected, bisected, perf, regression
Depends on:
Blocks: Cell-Add-Delete
  Show dependency tree / graph
 
Reported: 2020-06-25 14:29 UTC by Telesto
Modified: 2022-03-05 21:45 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Attachments
Bibisect log (3.83 KB, text/plain)
2020-06-25 14:31 UTC, Telesto 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Telesto 2020-06-25 14:29:34 UTC 
Description:
3 seconds delay of inserting a row and 6 seconds delay deleting a row in a larger spreadsheet

Steps to Reproduce:
1. Open attachment 161647 [details]
2. Copy column A-C
3. Paste it always next the other, so DEF GHI KLM NOP (needed to feel the performance degradation; so create more if you want to wait longer.. less if you want to wait sorter.. 
4. Insert a row -> 3 seconds -> create more columns; not really difference
5. Delete the row -> 7 seconds -> This tends to decrease with more columns

Actual Results:
3 seconds for insertion
6 for deletion

Expected Results:
1 seconds as before


Reproducible: Always


User Profile Reset: No



Additional Info:
Found in
Version: 7.0.0.0.beta1+
Build ID: c344de1b9985b6ca10b354e24151d0bdf92dc20e
CPU threads: 2; OS: Linux 5.3; UI render: default; VCL: x11
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded

and in 4.3.7.2

but no in 
4.2
Comment 1 Telesto 2020-06-25 14:31:14 UTC 
Created attachment 162407 [details]
Bibisect log

Bisected to
telesto@telesto-VirtualBox:~/bibisect-43max$ git bisect good 592049de352d2fd0fe256fe499a2edd175c2bb0b is the first bad commit
commit 592049de352d2fd0fe256fe499a2edd175c2bb0b
Author: Matthew Francis <mjay.francis@gmail.com>
Date:   Thu May 28 19:46:09 2015 +0800

    source-hash-f32df2d590d0ee14f09664934457ba9e8de8cbe6
    
    commit f32df2d590d0ee14f09664934457ba9e8de8cbe6
    Author:     Kohei Yoshida <kohei.yoshida@collabora.com>
    AuthorDate: Fri Feb 28 21:25:01 2014 -0500
    Commit:     Kohei Yoshida <kohei.yoshida@collabora.com>
    CommitDate: Fri Feb 28 21:28:57 2014 -0500
    
        fdo#75053: Adjust reference update on shift for formula groups.
    
        This is similar to my earlier fix for reference update on moving of
        cells.
    
        Change-Id: I592599507bfcab12f611eeae7b56c99da6c31919
Comment 2 Bob Vo 2020-07-22 01:56:33 UTC 

*** This bug has been marked as a duplicate of bug 134271 ***
Comment 3 Michael Warner 2020-07-23 03:14:08 UTC 
> 4. Insert a row -> 3 seconds -> create more columns; not really difference

So, for me when I added about 10 more columns the time this took increased to about 7 seconds. Then, without adding any more columns, I tried to insert another row, and Calc hung up my whole PC (even the mouse cursor wouldn't move) and eventually crashed.
Comment 4 Buovjaga 2022-03-03 14:27:58 UTC 
Took 2 secs to insert and 4 secs to delete (obeyed the recommendation in step 3), so it seems to not be back to the original performance level.

Version: 7.4.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: 04f9a8957c04b8c5abaa58140328d2c83381f4ff
CPU threads: 2; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win
Locale: fi-FI (fi_FI); UI: en-US
Calc: threaded Jumbo
Comment 5 Luboš Luňák 2022-03-05 21:45:11 UTC 

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