https://bugs.documentfoundation.org/show_bug.cgi?id=158393
Bug ID: 158393
Summary: Range = Value in formula fails if own cell the
formula is in is on a different row (vlookup
replacement)
Product: LibreOffice
Version: 7.6.3.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
using the formula =--(B1=(B1:B2))
If this is in A1, returns TRUE
If this is in A3, returns #VALUE!
More generally, if the cell the formula is in is in a row outside the rows in
the formula, it returns #value!
The cell the formula is in does not take part in the evaluated value. This
occured in 5.x. Downloaded latest 20230927 version 7.x.
Steps to Reproduce:
using the formula =--(B1=(B1:B2))
If this is in A1, returns TRUE
If this is in A3, returns #VALUE!
Actual Results:
using the formula =--(B1=(B1:B2))
If this is in A1, returns TRUE
If this is in A3, returns #VALUE!
Expected Results:
For the example, always TRUE. For a more indepth example, the results should
be TRUE or FALSE depending on the data in the cells.
--(RANGE=CELL) * is a more capable Vlookup method used in intermediary skill
spreadsheets.
Reproducible: Always
User Profile Reset: No
Additional Info:
As per expected results.
--
You are receiving this mail because:
You are the assignee for the bug.
