https://bugs.freedesktop.org/show_bug.cgi?id=74075
Tarun Kumar <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |ASSIGNED Assignee|[email protected] |[email protected] |desktop.org | --- Comment #11 from Tarun Kumar <[email protected]> --- Created attachment 95772 --> https://bugs.freedesktop.org/attachment.cgi?id=95772&action=edit Updated file with ascending and descending lookup_array I think this function is working as expected (kindly correct me If I am wrong). Pasting a link as how it works in MS excel: http://office.microsoft.com/en-in/excel-help/match-function-HP010062414.aspx #1 For Match_type=0, exact match is found and hence it is working fine in all cases. #2 For Match_type = 1 and empty cases (default value is 1) prerequisite is lookup_array must be placed in ascending order. #3 For Match_type = -1 prerequisite is lookup_array must be placed in ascending order. I have attached same file with ascending and descending lookup_array and it seems to be working fine. If it is not the case, then let me know and I would like to take it for fixing. -- 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
