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 message would make use of the functions in macros and forms
easier.
* No error message might be better for using the functions in
automatically calculations without UI.
* Using linear search can be unexpected slow on a huge Lookup_array. An
error message makes the problem visible to the user.
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). Calculations without UI means either prepared
document (and there a sane set of options must be used), or
programmatically defined formulas (and there a sane set of options must
be used).
--
Best regards,
Mike Kaganski
