On 15/05/2024 08:06, Heiko Tietze wrote:
If you want, we can run a poll what users prefer.
If you can't understand what's wanted - DON'T GUESS. Especially don't
guess and hide that fact from your users!
An error of "#value" or similar seems a pretty good option ...
Cheers,
Wol
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 *,
Mike Kaganski wrote:
> Emitting error is the only sane way here. No error message means doing
> something different than user requested, without user knowing that, with no
> practical benefit (the wildcards / regexes won't be used, so the task is not
> done anyway).
>
My understanding is,
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.
On 14.05.2024 3:23, Regina Henschel wrote:
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.
...
Some arguments so far:
* No error
Hi UX-experts,
the new function XLOOKUP and XMATCH have a Match_mode with values 0, 1,
-1, 2 and a Search_mode with values 1, -1, 2, -2.
The Match_mode 2 means wildcard mode, that is ? * search or regular
expressions search. The Search_modes 2 and -2 mean binary search in a
sorted array.
