Bug 98835 - Function MATCH() not working with parenthesis
Summary: Function MATCH() not working with parenthesis
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.1.1.2 rc
Hardware: All Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2016-03-23 10:30 UTC by Mamoth
Modified: 2016-03-25 11:40 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Simple example (13.11 KB, application/vnd.oasis.opendocument.spreadsheet)
2016-03-23 10:30 UTC, Mamoth 		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 Mamoth 2016-03-23 10:30:31 UTC 
Created attachment 123788 [details]
Simple example

Hello.

I just found that the MATCH function does not seem to work when the value of the 'search criterion' parameter is a text containing parenthesis. The function then returns #N/A.

See attached file for an example.
Comment 1 raal 2016-03-23 20:34:23 UTC 
Turn off regular expression in the options. Each option in "menu:Tools>Options...Calc>Calculate" is stored with the current document only.
Comment 2 Mamoth 2016-03-25 11:40:47 UTC 
It works. Thanks.