| Summary: | in Calc function VERGLEICH isn't working like expected (version 7.3.0.3 x64) | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | jwschuetz1954 |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | CLOSED NOTABUG | ||
| Severity: | normal | ||
| Priority: | medium | ||
| Version: | 7.3.0.2 rc | ||
| Hardware: | All | ||
| OS: | All | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
| Attachments: | small file for reproducing the bug | ||
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. |
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.