[Libreoffice-bugs] [Bug 134513] New: EDITING: Librecalc slows down incredibly (or crashes) if you Ctrl-Down in a column with rows having more than a handful of formulas and the lowest modified row is a formula.

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 134513
           Summary: EDITING: Librecalc slows down incredibly (or crashes)
                    if you Ctrl-Down in a column with rows having more
                    than a handful of formulas and the lowest modified row
                    is a formula.
           Product: LibreOffice
           Version: 6.4.3.2 release
          Hardware: All
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: ammar.james at alumni.stonybrook.edu

Description:
Something strange happens if I hit Ctrl+Down. Suppose the following condition
are met:
1. A column has "more than a handful of formulas" (in my bug tests I need at
least 19, but I don't think this is some magic number -- it could be 19 on my 
machine given my hardware and 25 for you)
2. The last modified row (say, around row 200), is a formula
3. I'm on the last modified row

If these condition are met and I hit Ctrl+Down to warp to the lowest possible
row (row 1048576 on my machine), then libreoffice gets VERY slow and sometimes
crashes if the number of formulas is higher than 19 (in my case). 

My hardware is as follows:
Processor: Intel i7-10875H 5.1Ghz
RAM: 32G Dual Channel DDR4 at 3200Mhz
Gfx: NVidia RTX 2070 w/ 2304 CUDA Cores

Steps to Reproduce:
Suppose the following condition are met:
1. A column has "more than a handful of formulas" (in my bug tests I need at
least 19, but I don't think this is some magic number -- it could be 19 on my 
machine given my hardware and 25 for you)
2. The last modified row (say, around row 200), is a formula
3. I'm on the last modified row

If these condition are met and I hit Ctrl+Down to warp to the lowest possible
row (row 1048576 on my machine), then libreoffice gets VERY slow and sometimes
crashes if the number of formulas is higher than 19 (in my case). 

I'm not sure how to share a spreadsheet in this bug tracker, so I've pasted my
spreadsheet below so you can cut/paste.

ROW        COLUMN A
 1         476
 2         1561
 3         -152
 4         =SUM(A2:A3)
 5
 6         =A4
 7         =A63
 8         =A6-A7
 9
10         340
11
12         225
13         -140
14         1
15         11
16         32
17         0
18         -16
19         1
20         =3+51
21
22         169
23         222
24         =-209+303-541
25         0
26         0
27         0
28         =-430+387
29         "=SUM(A10,A12:A20,A22:A28)"
30
31         -200
32         =-148+220
33         0
34         =25-90
35         0
36         -185
37         -3
38         =SUM(A31:A37)
39
40         0
41         -2
42         263
43         0
44         -248
45         0
46         0
47         -183
48         0
49         =-10
50         =SUM(A40:A49)
51
52         0
53
54         619
55         942
56         =SUM(A54:A55)
57
58         1561
59         -152
60         =SUM(A58:A59)
61
62         =A60
63         933
64         =A62-A63
65
66         "=IF(ROUND(A64,2)=ROUND(A1,2),""-"",""Error"")"
67         "=IF(ROUND(A64,2)=ROUND(A8,2),""-"",""Error"")"


Actual Results:
Librecalc gets VERY slow if I try to use my arrow keys to move around cells
near the bottom of the spreadsheet, or if I try to Ctrl+Up back to the top. 

Expected Results:
Librecalc should remain quick and responsive.


Reproducible: Always


User Profile Reset: Yes



Additional Info:
N/A.

-- 
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/20200704/430154ed/attachment.htm>