https://bugs.documentfoundation.org/show_bug.cgi?id=167355
--- Comment #5 from Regina Henschel <[email protected]> --- (In reply to m_a_riosv from comment #4) > Even if you are right, the behavior differs from Excel. I was not right. I have missed, that you use linear search. For such, ordering of search vector is not needed. Excel treats blank > number. The ODF specification of XLOOKUP is not finished. So we could do it same way as Excel and ask the ODF TC to specify it that way. It is not obvious, how Google Sheet treats blank as query value. -- You are receiving this mail because: You are the assignee for the bug.
