| Summary: | Array Formula reset to non-Array Formula after Moving and Undo (see comment 4) | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | jteera5 |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | NEW --- | ||
| Severity: | normal | CC: | ilmari.lauhakangas, jteera5, miguelangelrv |
| Priority: | medium | ||
| Version: | Inherited From OOo | ||
| Hardware: | x86-64 (AMD64) | ||
| OS: | All | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
| Bug Depends on: | |||
| Bug Blocks: | 105948 | ||
| Attachments: | A file with lots of array formula. | ||
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.
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 How do you move the row? (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. 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 |
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.