https://bugs.freedesktop.org/show_bug.cgi?id=72348
pierre-yves samyn <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEEDINFO |NEW --- Comment #3 from pierre-yves samyn <[email protected]> --- Hello You omitted the third parameter of the formula: "type" as help says: "If Type = 1 or if this optional parameter is missing, it is assumed that the first column of the search array is sorted in ascending order" See https://help.libreoffice.org/Calc/Spreadsheet_Functions#MATCH Anyway I see indeed a difference between : Version: 4.1.3.2 Build ID: 70feb7d99726f064edab4605a8ab840c50ec57a and Version: 4.2.0.0.beta2 Build ID: 1a27be92e320f97c20d581a69ef1c8b99ea9885d Steps to reproduce: 1. Open the match.ods attached in 4.1.3.2 B1 displays 6 2. Open the match.ods attached in 4.2.0.0.beta2 B1 display #N/A even with 3rd parameter type = 1 (search array is not sorted.) Regards Pierre-Yves -- 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
