[Bug 163821] XLOOKUP does not work correctly if the search array and result array are each entered as an array with curly brackets.

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=163821

--- Comment #6 from Werner Tietz <werner-ti...@arcor.de> ---
(In reply to Werner Tietz from comment #4)
> Cannot reproduce with:
> =XLOOKUP("A";{"A"; "B"};{1;2},"")
> returns the expected result »1«
!!sorry my bad, it returns »1« because Cell A1 of the first sheet value was »1«
!!

⇒ confirmed

> 
> with me:
> _________
> Version: 24.8.2.1 (AARCH64) / LibreOffice Community
> Build ID: 0f794b6e29741098670a3b95d60478a65d05ef13
> CPU threads: 4; OS: Linux 6.6; UI render: default; VCL: gtk3
> Locale: de-DE (de_DE.UTF-8); UI: de-DE
> Flatpak
> Calc: threaded

-- 
You are receiving this mail because:
You are the assignee for the bug.