<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 - CALC freezes on undo or delete of long column"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=131915">131915</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>CALC freezes on undo or delete of long column
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.4.2.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>x86-64 (AMD64)
</td>
</tr>
<tr>
<th>OS</th>
<td>Windows (All)
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>minor
</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>milan.berta@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>Description:
by generating a long column of values and trying to delete it or by applying
undo CALC freezes and it is 'waiting for response'.
Steps to Reproduce:
1. Open attached file. The file contains three sheets. Sheet1: 2-by-2 matrix
filled with single digit integers. Sheet2: 2-by-1 matrix filled with single
digit integers. Sheet3: 2-by-1 matrix filled with integers generated by
{=MMULT($Sheet1.A1:B2;$Sheet2.A1:A2)}
2. Select Column A
3. Click into the Formula bar, select the whole formula
'=MMULT($Sheet1.A1:B2;$Sheet2.A1:A2)' and copy it
4. ESC (the column A remains selected)
5. press Del (delete the column)
6. Click into the Formula bar, paste the formula
'=MMULT($Sheet1.A1:B2;$Sheet2.A1:A2)' and press CTRL+ENTER to apply array
formula
7. the whole column A is filled with #N/A except the first to cells
8. The user finds out the mistake -- the user should have deselected the column
and enter the formula only into the first cell of the column.
9. press CTRL+Z
10. CALC freezes (better to kill CALC and let it recover the file)
There is no workaround, when the user saves the file with the generated
super-long column. CALC is not able to delete such a long column either. One
has to create a new file and copy the content of the sheets.
Note: The example given does not make sense in such a small example. The
example is very specific and the user may avoid the freeze by not applying the
array formula onto the whole column -- only to the first cell, CALC would fill
in the column to the last meaningful cell.
The example makes sense when updating the calculation and changing the size of
the original matrix in size 123-by-123 in Sheet1 and finally deleting the whole
column in Sheet3 -- which was my case.
Actual Results:
Waiting for response, CALC window freezes.
Expected Results:
CALC shall undo the column edit and clear the column in no time.
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 6.4.2.2 (x64)
Build ID: 4e471d8c02c9c90f512f7f9ead8875b57fcb1ec3
CPU threads: 8; OS: Windows 10.0 Build 18362; UI render: default; VCL: win;
Locale: cs-CZ (cs_CZ); UI-Language: en-US
Calc: threaded</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>