https://bugs.documentfoundation.org/show_bug.cgi?id=165459
Bug ID: 165459
Summary: Third argument of VLOOKUP survives column deletion
Product: LibreOffice
Version: 24.8.4.2 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Let
A1 be 10,
B1 be 20,
C1 be 30, and
D1 be =VLOOKUP(11;$A$1:$C$1;3).
Works, OC: D1 becomes 30.
But if you now delete column B
D1 is not completely adjusted:
D1 is =VLOOKUP(11;$A$1:$B$1;3).
However, the third argument should be 2.
It neither is adjusted
if you insert a column between A and B.
Should this be too complicated
the third argument should be set to zero times old
to force an error and catch the attention.
Steps to Reproduce:
see description
Actual Results:
see description
Expected Results:
see description
Reproducible: Always
User Profile Reset: No
Additional Info:
I'll call it bug because it silently does what you don't expect.
--
You are receiving this mail because:
You are the assignee for the bug.
