https://issues.apache.org/ooo/show_bug.cgi?id=125813
Issue ID: 125813
Issue Type: DEFECT
Summary: VLOOKUP() doesn't work like expected
Product: Calc
Version: 4.1.1
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: P3
Component: ui
Assignee: [email protected]
Reporter: [email protected]
Created attachment 84131
--> https://issues.apache.org/ooo/attachment.cgi?id=84131&action=edit
.ods that use VLOOKUP() on same radix strings
the VLOOKUP() function with 3th parameter at 0 or FALSE, work with not sorted
elements, and should return exact match only.
But sometimes get confused by similar element that match too, when should match
with 3th parameter to 1 or TRUE or missing
It happen when the radix part of a string is found in another entry, followed
by other text.
Attach an example where the bug is shown.
I exported the .ods file as .xls and tested in both AOO and Excel, and so work
as expected, return exact match only.
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
