https://bugs.documentfoundation.org/show_bug.cgi?id=160155
Bug ID: 160155
Summary: VLOOKUP-INDEX-MATCH: unexpected behaviour with
alphanumeric values
Product: LibreOffice
Version: 24.2.0.3 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 193065
--> https://bugs.documentfoundation.org/attachment.cgi?id=193065&action=edit
VLOOKUP-INDEX-MATCH-Scenarios showing to discrepancy seen from standpoint of
End User.
Hi and Good day everyone.
I expect a VLOOKUP is behaving the same way, no matter whether it's numeric or
alphanumeric search-criterias (no matter whether it's the search value and or
the searched value in the lookup table).
I understand what the MATCH-parameter 1 or 0 means.
I did create a couple scenarios showing these cases.
The same behaviour actually goes when using just LOOKUP or even the "handish"
way with INDEX and MATCH.
When fields in question are alphanumeric, it's not behaving as expected.
Sad.
I mean, a numeric content is a value, a alphanumeric content is a value too
seen from the standpoint of a end user.
I know the technical background and difference of numeric and alphanumeric
values. But an application like libreoffice is for end users, not only for
computer nerds... ;-)
See attached calc sheet demonstrating these cases
Thanks!
Lukas
--
You are receiving this mail because:
You are the assignee for the bug.
