Bug 97620 - VLOOKUP can't find matches with parentheses characters
Summary: VLOOKUP can't find matches with parentheses characters
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.0.4.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2016-02-07 16:26 UTC by pleaseiwantthem
Modified: 2016-02-07 21:13 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Example ODS file that triggers the bug (508.58 KB, application/vnd.oasis.opendocument.spreadsheet)
2016-02-07 16:26 UTC, pleaseiwantthem 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description pleaseiwantthem 2016-02-07 16:26:32 UTC 
Created attachment 122424 [details]
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.
Comment 1 m_a_riosv 2016-02-07 21:13:36 UTC 
Because parentheses are part of regular expressions.
https://help.libreoffice.org/Common/List_of_Regular_Expressions

You need to disable their use in Menu/Tools/Options/LibreOffice calc/Calculate - Enable regular expressions in formulas.

If you need to use regular expression you can esc those characters with a backslash before them '\('.

Resolved as notabug, please if you are not agree, reopen it.

https://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Calc_Guide