https://bugs.documentfoundation.org/show_bug.cgi?id=160893
--- Comment #13 from ady <[email protected]> --- (In reply to Eike Rathke from comment #12) > MATCH and [HVX]LOOKUP never consider cell format and should not. What > happens however is that if the search criterion can be interpreted as a > number (which a date string is also) a numeric lookup is performed. Comment 2 shows not a change in "search criterion", but a change in display format of (part of) the data. I admit I am now confused by what the expected behavior should be. Also, if a string that resembles a date (between quotation marks) is considered as a number in "search criterion" (as Eike mentions in comment 12), is there any way to search for such "date" as a string (and not as a number)? > > IIRC that was implemented because Excel did it that way. That seems to have > changed? Or Excel first tries to find the string match and only if there is > none it retries with a conversion to number if possible? I don't have access to Excel 2021 in order to create a sample case anew (from scratch) with Excel itself only (and without relying on Calc at all). @Regina? @Miguel? > > Anyhow, our XLOOKUP implementation is at least wrong for any case returning > "no invoice" in attachment 193924 [details], i.e. C8 and C10. Note that you > may have to Ctrl+F9 hard recalculate to get the current implementation's > results. So, is this related to all lookup functions (including MATCH)? Or only to XLOOKUP/XMATCH)? Do we have more than one different behavior between Calc and Excel? @thb (comment 10), @Balázs (comment 7), @Eike (comment 12) ? -- You are receiving this mail because: You are the assignee for the bug.
