https://bugs.documentfoundation.org/show_bug.cgi?id=91751
Bug ID: 91751
Summary: VLOOKUP ignores some characters
Product: LibreOffice
Version: 4.4.1.2 release
Hardware: Other
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 116174
--> https://bugs.documentfoundation.org/attachment.cgi?id=116174&action=edit
Example of VLOOKUP bug
When doing a VLOOKUP on a string in a list, some characters (e.g. + are ignored
completely and instead strings that shouldn't match do.
In my example (attached), I have a set of grades with + and - so C+, C and C-
with the relevant scores. Doing a VLOOKUP() with a value of C+ matches the C-
row
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
