[Libreoffice-bugs] [Bug 131915] New: CALC freezes on undo or delete of long column

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 131915
           Summary: CALC freezes on undo or delete of long column
           Product: LibreOffice
           Version: 6.4.2.2 release
          Hardware: x86-64 (AMD64)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: minor
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: milan.berta at gmail.com

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

-- 
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/20200405/9369f79d/attachment.htm>