https://bugs.documentfoundation.org/show_bug.cgi?id=147129
Bug ID: 147129
Summary: in Calc function VERGLEICH isn't working like expected
(version 7.3.0.3 x64)
Product: LibreOffice
Version: 7.3.0.2 rc
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
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.
--
You are receiving this mail because:
You are the assignee for the bug.
