https://bugs.documentfoundation.org/show_bug.cgi?id=159467
Balázs Varga (allotropia) changed:
What|Removed |Added
Assignee|libreoffice-b...@lists.free
https://bugs.documentfoundation.org/show_bug.cgi?id=159467
ady changed:
What|Removed |Added
Blocks||108827
--- Comment #7 from ady ---
(In
https://bugs.documentfoundation.org/show_bug.cgi?id=159467
--- Comment #6 from Balázs Varga (allotropia) ---
Thanks for the explanation and investigation Ady. :)
=XLOOKUP(A12;A2:A8;B2:B8;XLOOKUP(A12;F2:F8;G2:G8;0))
The reason why it is work and the original ones not, because in the above
https://bugs.documentfoundation.org/show_bug.cgi?id=159467
--- Comment #5 from ady ---
(In reply to ady from comment #4)
> Translated to the array formula:
> =XLOOKUP(A12;A2:A8;B2:B8;XLOOKUP(A12;F2:F8;G2:G8))
>
> ... it is only executing the search of the criterion on the second
> XLOOKUP(),
https://bugs.documentfoundation.org/show_bug.cgi?id=159467
ady changed:
What|Removed |Added
Ever confirmed|0 |1
Status|UNCONFIRMED
https://bugs.documentfoundation.org/show_bug.cgi?id=159467
--- Comment #3 from ady ---
FWIW, (in an attempt to help make sense for other readers, *I hope*)
(In reply to Gabor Kelemen (allotropia) from comment #0)
> After the patch
I guess you mean tdf#127293 comment 39, which was posted to
https://bugs.documentfoundation.org/show_bug.cgi?id=159467
--- Comment #2 from Gabor Kelemen (allotropia) ---
Created attachment 192276
--> https://bugs.documentfoundation.org/attachment.cgi?id=192276=edit
The example file after modifying the search input of XLOOKUP
--
You are receiving this
https://bugs.documentfoundation.org/show_bug.cgi?id=159467
--- Comment #1 from Gabor Kelemen (allotropia) ---
Created attachment 192275
--> https://bugs.documentfoundation.org/attachment.cgi?id=192275=edit
The example file after opening, this works
--
You are receiving this mail because:
You