https://bugs.documentfoundation.org/show_bug.cgi?id=153297
--- Comment #13 from ady <[email protected]> --- Created attachment 185129 --> https://bugs.documentfoundation.org/attachment.cgi?id=185129&action=edit bug tdf 153297 demo MATCH problem in LO74x Attaching simple sample file (18KB) demonstrating the problem when the third argument for MATCH() is "1", for LO version 7.4.x. There are problems with both "sorted" possible 3rd argument (1 and -1). This file shows only the ascending case(s), for illustration purposes. * Different results for MATCH(), depending on how long the lookup array is. * Different results for MATCH(), depending on how many empty cells are part of the lookup array, but also depending on their position in the lookup array list (not just depending on amount). * The values that differ in each lookup array are all located after the first lookup value. * In each lookup array, all values until the first lookup value (1) are exactly the same ({0;1}); yet, MATCH() results are different (with LO 7.4.x). -- You are receiving this mail because: You are the assignee for the bug.
