Hi List,
> Combining parameter values for wildcard mode and binary search is
possible. But there exist no way to actually do it. Excel gives an error
messages in such cases. LibreOffice silently switches to linear search.
So the fix for the error is "do not to combine the parameters wildcard
Re-adding the dev ML; Regina's full reply at
https://listarchives.libreoffice.org/global/design/2024/msg00045.html
On 15.05.24 2:03 AM, Regina Henschel wrote:
The problem is, what should be the output, when the user sets Match_mode 2
together with Search_mode 2 or -2.
Excel returns #VALUE! for
Hi Heiko,
I write to you directly too, because I don't know whether the design
list allows attachments.
Heiko Tietze schrieb am 14.05.2024 um 08:21:
Correct me but
=XLOOKUP(C3;A$1:A$3;B$1:B$3;"INV";_3_;1) returns #VALUE! (Excel) or
The parameter Match_mode can only have the values
0 exa
Correct me but
=XLOOKUP(C3;A$1:A$3;B$1:B$3;"INV";_3_;1) returns #VALUE! (Excel) or Err:504 (LO)
=_Y_LOOKUP(C4;A$1:A$3;B$1:B$3;"INV";0;1) returns #NAME? (both)
What exactly will change?
PS: ux-advice@ is the forward mailing list from Bugzilla and I'm not sure how
many people have registered. Ra