Download it now!
Bug 65043 - MATCH for text containing brackets returns #N/A
Summary: MATCH for text containing brackets returns #N/A
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: Other All
: medium normal
Assignee: Not Assigned
Depends on:
Reported: 2013-05-27 15:14 UTC by menturi
Modified: 2015-01-19 12:51 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

MATCH behavior on Sheet1 is incorrect. (9.21 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-05-27 15:14 UTC, menturi

Note You need to log in before you can comment on or make changes to this bug.
Description menturi 2013-05-27 15:14:53 UTC
Created attachment 79853 [details]
MATCH behavior on Sheet1 is incorrect.

Using the MATCH function when searching for text containing brackets results in #N/A.

There is an attached spreadsheet demonstrating the issue.

On Sheet1, in A2:A4 there is the text (without quotes) "abc" "b[c]a" and "cab" respectively. MATCH(A3,A2:A4,0) results in #N/A. The expected result is 2. However, on Sheet2, A3 was replaced with "bca" and it successfully returns 2.

This was tested only on Ubuntu 12.04 with LibreOffice
Comment 1 ign_christian 2013-05-27 16:12:21 UTC
confirm reproducible on LO (Win7 32bit)
Comment 2 GerardF 2013-05-27 16:45:11 UTC
Tools/Options/LibreOffice Calc/Calculate,
turn off "Allow regular expressions in formulas".

See the Help for "Regular expressions".