Bug 146447 - Array Formula reset to non-Array Formula after Moving and Undo (see comment 4)
Summary: Array Formula reset to non-Array Formula after Moving and Undo (see comment 4)
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: x86-64 (AMD64) All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Undo-Redo
  Show dependency tree / graph
 
Reported: 2021-12-28 10:24 UTC by jteera5
Modified: 2022-11-29 11:49 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Attachments
A file with lots of array formula. (112.05 KB, application/vnd.oasis.opendocument.spreadsheet)
2021-12-28 10:36 UTC, jteera5 		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 jteera5 2021-12-28 10:24:20 UTC 
Description:
When a row that appears in an array formula is moved (using Alt-drag or Cut-and-Paste), then Undo (Ctrl-Z). Some array formula reset to non-array formula.
Still happens in version 7.2.4.1 release.

Steps to Reproduce:
1.Choose a row within range that the array formula refer to.
2.Move the row.
3.Undo.

Actual Results:
{} are gone.

Expected Results:
The row moved back. Array formula are intact.


Reproducible: Always


User Profile Reset: No



Additional Info:
Keep the array formula's braces.
Comment 1 jteera5 2021-12-28 10:36:01 UTC 
Created attachment 177168 [details]
A file with lots of array formula.

Observe sheet 'S' cell C5 with an array formula.
Move a row in sheet 'N' from row 7 to row 13.
Undo.
S.C5 is changed. No more {} braces indicating that it's an array formula. Calculations are wrong.
Comment 2 m_a_riosv 2021-12-30 13:22:58 UTC 
I can't reproduce.
Version: 7.3.0.1 (x64) / LibreOffice Community
Build ID: 840fe2f57ae5ad80d62bfa6e25550cb10ddabd1d
CPU threads: 4; OS: Windows 10.0 Build 21390; UI render: Skia/Vulkan; VCL: win
Locale: es-ES (es_ES); UI: en-US Calc: CL
Version: 7.2.5.1 (x64) / LibreOffice Community
Build ID: 6d497ff5e83a906a307eb25cce314d40c0b8624f
CPU threads: 4; OS: Windows 10.0 Build 21390; UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: en-US Calc: CL
Comment 3 m_a_riosv 2021-12-30 13:29:13 UTC 
How do you move the row?
Comment 4 jteera5 2022-01-03 10:38:03 UTC 
(In reply to m.a.riosv from comment #3)
> How do you move the row?
Thank you for your reply.
In the attachment file, sheet 'N' is for data entry and sheet 'S' , 'A' and 'Su' contains lots of array formula.
1. Let's observe sheet 'S' cell C5 with an array formula.
2. Choose row 7 in sheet 'N' 
3. Hold the Alt key and drag the mouse to move the row from row 7 of sheet 'N' to row 13.
4. Press Ctrl-Z to undo.
S. The Cell C5 in sheet 'S' is changed. No more {} braces indicating that it's an array formula. Calculation results are wrong.

This also happens in Apache OpenOffice 4.1.11 and older versions of OpenOffice and LibreOffice, like LO 5, 6 and 7.
Comment 5 Buovjaga 2022-11-29 11:49:16 UTC 
Reproduced. Based on the previous comment, let's set to inherited.

Arch Linux 64-bit
Version: 7.5.0.0.alpha1+ (X86_64) / LibreOffice Community
Build ID: 7830ecc2e4e5dd264517c6554078fa807ff1fceb
CPU threads: 8; OS: Linux 6.0; UI render: default; VCL: kf5 (cairo+xcb)
Locale: fi-FI (fi_FI.UTF-8); UI: en-US
Calc: threaded
Built on 29 November 2022