Bug 91161 - MATCH function gets confused with plus (+) at the end of the text
Summary: MATCH function gets confused with plus (+) at the end of the text
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.3.6.2 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-05-08 13:01 UTC by skiani
Modified: 2015-05-09 22:42 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Simple example of MATCH function problem (14.10 KB, application/vnd.oasis.opendocument.spreadsheet)
2015-05-08 13:01 UTC, skiani 		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 skiani 2015-05-08 13:01:51 UTC 
Created attachment 115449 [details]
Simple example of MATCH function problem

When doing an exact MATCH and the index/search has a plus sign (+) in the field. For example if you have list:

a
b
c+
d

and you do match with a "c+" it will not find it correctly. Try same thing in excel and no problem. See attach simple example.
Comment 1 m_a_riosv 2015-05-09 22:42:00 UTC 
Hi @skiani, thanks for reporting.

Function works properly, the issue is that the file has activated regular expression for search.
Menu/Tools/Options/LibreOffice calc/Calculate - Enable regular expressions in formula.
Disable it so it must work fine.

You can look about regular expressions in the inner help.

'+' is part of the regular expression, if you want use regex then for search for '+' you need to disable their special meaning, with a backslash before it '\+'