https://bugs.documentfoundation.org/show_bug.cgi?id=167698
Mike Kaganski <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Resolution|--- |NOTABUG Status|UNCONFIRMED |RESOLVED --- Comment #3 from Mike Kaganski <[email protected]> --- As help for this function explains [1]: > If the Sorted parameter is omitted or set to TRUE or one, it is assumed that > the > data is sorted in ascending order. In this case, if the exact Lookup is not > found, the last value that is smaller than the criterion will be returned. [1] https://help.libreoffice.org/25.2/en-US/text/scalc/01/04060109.html?DbPAR=CALC#bm_id3153152 -- You are receiving this mail because: You are the assignee for the bug.
