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@xxxxxxxxxxxxxxxxxxxxxx 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
Attachment:
OpenPGP_signature.asc
Description: OpenPGP digital signature
