Description: Function VERGLEICH( value; searchmatrix; type ) isn't working like expected (but working in Excel). For example in my sheet I have a row 2 with content A B C D E ... row 2: 1 2 3 My function VERGLEICH(0;$2:$2;-1) returns the value 5. That is what I expect. But if I delete the above value 2, then I get #NV. I expect also the value 5. I try to attach the corresponding test sheet. Steps to Reproduce: 1. open attached test sheet 2. displayed in A1 is the value 5 - like expected 3. delete in row 2 the value 2 4. now in A1 a #NV is displayed 5. I expect (an see in Excel) value 5 again Actual Results: The software displays the wrong value #NV. Expected Results: The software should display value 5. Reproducible: Always User Profile Reset: Yes Additional Info: This is not a new issue. I saw it also in the previous stable version.
Created attachment 177991 [details] small file for reproducing the bug
The 4th argument -1 requires that the lookup array MUST be sorted descending, but it is not. If data is not sorted as expected, the result is arbitrary. See https://help.libreoffice.org/7.3/de/text/scalc/01/04060109.html?DbPAR=CALC#bm_id3158407 Not a bug.