Re: [libreoffice-design] Re: behavior of new functions XLOOKUP and XMATCH

2024-05-15 Thread Wol
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: [libreoffice-design] Re: behavior of new functions XLOOKUP and XMATCH

2024-05-15 Thread Heiko Tietze
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