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. |
Description
jteera5
2021-12-28 10:24:20 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.
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 |