https://bugs.documentfoundation.org/show_bug.cgi?id=163821
Bug ID: 163821
Summary: XLOOKUP does not work correctly if the search array
and result array are each entered as an array with
curly brackets.
Product: LibreOffice
Version: 24.8.0.0 alpha0+
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
If you enter the formula: =XLOOKUP("A",{"A"; "B"},{1;2},"") in Calc, you will
not get the expected result "A" but the content from cell A1 of the first
worksheet. XLOOKUP works if you have stored the search array and result array
in cells somewhere in the worksheet and refer to it.
Steps to Reproduce:
1. write "Hello world" in cell A1
2. write the formula =XLOOKUP("A",{"A"; "B"},{1;2},"") in any other cell in the
worksheet
Actual Results:
"Hello world"
Expected Results:
"A"
Reproducible: Always
User Profile Reset: Yes
Additional Info:
With =XLOOKUP("B",{"A"; "B"},{1;2},"") you get the result of cell B1.
To see changes you must recalculate Hard.
In Microsoft Excel you get the correct result "A".
--
You are receiving this mail because:
You are the assignee for the bug.
