[Libreoffice-bugs] [Bug 146447] Array Formula reset to non-Array Formula after Moving and Undo (see comment 4)
https://bugs.documentfoundation.org/show_bug.cgi?id=146447 Buovjaga changed: What|Removed |Added Version|7.2.4.1 release |Inherited From OOo OS|Windows (All) |All Blocks||105948 Ever confirmed|0 |1 CC||ilmari.lauhakangas@libreoff ||ice.org Status|UNCONFIRMED |NEW Summary|Array Formula reset to |Array Formula reset to |non-Array Formula after |non-Array Formula after |Moving and Undo.|Moving and Undo (see ||comment 4) --- Comment #5 from Buovjaga --- 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 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=105948 [Bug 105948] [META] Undo/Redo bugs and enhancements -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 146447] Array Formula reset to non-Array Formula after Moving and Undo.
https://bugs.documentfoundation.org/show_bug.cgi?id=146447
jtee...@hotmail.com changed:
What|Removed |Added
Version|5.4.0.3 release |7.2.4.1 release
--- Comment #4 from jtee...@hotmail.com ---
(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.
--
You are receiving this mail because:
You are the assignee for the bug.
[Libreoffice-bugs] [Bug 146447] Array Formula reset to non-Array Formula after Moving and Undo.
https://bugs.documentfoundation.org/show_bug.cgi?id=146447 --- Comment #3 from m.a.riosv --- How do you move the row? -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 146447] Array Formula reset to non-Array Formula after Moving and Undo.
https://bugs.documentfoundation.org/show_bug.cgi?id=146447 m.a.riosv changed: What|Removed |Added CC||miguelangelrv@libreoffice.o ||rg --- Comment #2 from m.a.riosv --- 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 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 146447] Array Formula reset to non-Array Formula after Moving and Undo.
https://bugs.documentfoundation.org/show_bug.cgi?id=146447
jtee...@hotmail.com changed:
What|Removed |Added
CC||jtee...@hotmail.com
--- Comment #1 from jtee...@hotmail.com ---
Created attachment 177168
--> https://bugs.documentfoundation.org/attachment.cgi?id=177168=edit
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.
--
You are receiving this mail because:
You are the assignee for the bug.
