Bug 65043 - MATCH for text containing brackets returns #N/A
Summary: MATCH for text containing brackets returns #N/A
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.0.3.3 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
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:

Attachments
MATCH behavior on Sheet1 is incorrect. (9.21 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-05-27 15:14 UTC, menturi 		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 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 4.0.3.3.
Comment 1 ign_christian 2013-05-27 16:12:21 UTC 
confirm reproducible on LO 4.0.3.3 (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".