https://bugs.documentfoundation.org/show_bug.cgi?id=171074
Bug ID: 171074
Summary: CALC: UNDO: ARRAY formula using INDEX appears to
corrupt references when complete rows in either the
source or destination are removed and then the removal
is UNDONE
Product: LibreOffice
Version: 7.5.9.2 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
In the Result Array An ARRAY function using INDEX and a key entered in the "ID"
column to extract a 7x1 matrix from an adjacent table "Source Array", will be
corrupted if a small but complete segment of the Result Array is selected and
deleted using [Ctrl]+[-] (shift up or left - it's all the same effect) AND that
action is undone utilising MENU>Edit>Undo:Delete OR [Ctrl]+[Z] OR the UNDO
rotor in a customised ribbon.
The deleted rows will be returned but the array data fills all the elements of
the result arrays IMMEDIATELY below the reverted arrays with the contents of
the first element of the relevant "Source Array" entry.
No user action can reinstate the viability of the original data. Even saving
the file with the damage and then reloading it in the forlorn hope that some
form of sheet refresh functionality upon loading may mitigate is unsuccessful.
If the same deletion method is applied to the source array then initially the
Result array will simply display the next highest result similar to a VLOOKUP()
drop UP default but then reinstating the rows forces ALL the Result array to
adopt the first element reproduction error
Steps to Reproduce:
Using the attached file enter any number less than 22 into the blank ID cell at
S3 to visualise the response. Then
Select the range L5:S6
[Ctrl]+[-] selecting shift up
observe the resulting display of Result Array
Undo the action utilising your favourite method
It is totally destructive so it's necessary to exit and reload the file to
conduct a similar test with a select range of the Source Array
Actual Results:
Result Array is now corrupted with the display of the first element of the
identified Source Array items for all the Results FOLLOWING the reinstated
array.
A similar test removing a portion of the Source Array initially results in the
Result array finding the wrong Source row but the UNDO corrupts all elements of
the Result Array
Expected Results:
Result Array to retain the data associated with the rows in the Source Array.
I'm uncertain what should happen if the Source Array doesn't contain a matching
record as the live environment will always have more Source elements than the
Result Array requires
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 25.8.3.2 (X86_64)
Build ID: 8ca8d55c161d602844f5428fa4b58097424e324e
CPU threads: 4; OS: Windows 10 X86_64 (build 19045); UI render: Skia/Raster;
VCL: win
Locale: sv-SE (en_SE); UI: en-GB
Calc: threaded
xxxxxxxxxxxxxxxxxxxxxxxxxxearliest tested
Version: 7.5.9.2 (X86_64) / LibreOffice Community
Build ID: cdeefe45c17511d326101eed8008ac4092f278a9
CPU threads: 12; OS: Windows 10.0 Build 26200; UI render: Skia/Vulkan; VCL: win
Locale: en-GB (en_GB); UI: en-GB
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
