https://bugs.documentfoundation.org/show_bug.cgi?id=167355
--- Comment #3 from Regina Henschel <[email protected]> --- Match Mode 1 and -1 require, that the search vector is sorted. In the examples there are empty cells in the middle and at the end of the search vector. So independent of the question where empty cells are placed in a sorted area, this search vector is surely not sorted. In case the search vector is not sorted, no error is produced but the result is simply not usable. Producing an error is not required, because that would have enormous performance consequences as evaluators would be forced to scan the search vector linearly. It is up to the author of the spreadsheet to guarantee a sorted search vector. So I think, there is no bug at all. -- You are receiving this mail because: You are the assignee for the bug.
