behavior of new functions XLOOKUP and XMATCH

[Heiko Tietze]

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. Rather use design@ for input from the UI/UX group.

On 14.05.24 12:23 AM, Regina Henschel wrote:
> 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.
> 
> 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.
> 
> The ODF TC is currently working on the specification for these new functions. 
> The TC could either follow Excel's way or LibreOffice's way. From a developer 
> state of view it is no large effort to change the current behavior of 
> LibreOffice. The TC does not know yet whether Microsoft would be willing to 
> switch to LibreOffice's behavior.
> 
> I write to you for to get your opinion what will be the best solution from a 
> _user_ point of view.
> 
> 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.
> 
> I would love to hear your opinion.
> 
> Kind regards,
> Regina
> 
> 
> 
> 
> 

-- 
Dr. Heiko Tietze, UX-Architect and UI-Designer
Tel: +49 30 5557992-63 | Mail: heiko.tietze at documentfoundation.org
The Document Foundation, Winterfeldtstraße 52, 10781 Berlin, DE
Gemeinnützige rechtsfähige Stiftung des bürgerlichen Rechts
Legal details: https://www.documentfoundation.org/imprint
-------------- next part --------------
A non-text attachment was scrubbed...
Name: OpenPGP_signature.asc
Type: application/pgp-signature
Size: 495 bytes
Desc: OpenPGP digital signature
URL: <https://lists.freedesktop.org/archives/libreoffice/attachments/20240514/955a0ac9/attachment.sig>