https://bugs.documentfoundation.org/show_bug.cgi?id=92054
m.a.riosv <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEEDINFO |RESOLVED CC| |[email protected] | |rg Resolution|--- |NOTABUG --- Comment #2 from m.a.riosv <[email protected]> --- The function returns the last that is equal or less than searched value when sort order is defined as sorted ascending. As there is not enable the option: Menu/Tools/Options/LibreOffice calc/Calculate - Search criteria = and <> must apply to the whole cells. the function return the last equal or less containing the searched value, enable the option and results become corrects. In my experience it's not a very good idea use a sort order in the function when keys for search are strings or unique keys. On the other hand useful. Please review the help: https://help.libreoffice.org/index.php?title=4.4/Calc/Spreadsheet_Functions&Language=en-US&System=WIN&Version=4.4#bm_id3152809. Resolved as not a bug. Please if you are not agree, please reopen it. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
