<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - 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."
href="https://bugs.documentfoundation.org/show_bug.cgi?id=134513">134513</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>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.
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.4.3.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>Linux (All)
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>ammar.james@alumni.stonybrook.edu
</td>
</tr></table>
<p>
<div>
<pre>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.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>