https://bugs.documentfoundation.org/show_bug.cgi?id=97620
Bug ID: 97620
Summary: VLOOKUP can't find matches with parentheses characters
Product: LibreOffice
Version: 5.0.4.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 122424
--> https://bugs.documentfoundation.org/attachment.cgi?id=122424&action=edit
Example ODS file that triggers the bug
When using the VLOOKUP function in the input line of a cell, it is unable to
find a match between 2 cells containing identical strings if their values
contain parentheses characters. If this occurs, the function incorrectly
returns "#N/A" instead of the expected value.
See cell Boards.M4 in the attached file as an example.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
