Issue 115229 - Match function error when looking for a string ending with parenthesis
Summary: Match function error when looking for a string ending with parenthesis
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 3.2.1
Hardware: PC Windows 7
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact: Nika
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-10-24 17:35 UTC by eduardojrobledo
Modified: 2021-08-26 12:26 UTC (History)
5 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
file with example of error (8.36 KB, application/vnd.oasis.opendocument.spreadsheet)
2010-10-24 17:37 UTC, eduardojrobledo 		no flags Details
Testing 44 cases, 8 passed (11.83 KB, application/vnd.oasis.opendocument.spreadsheet)
2021-05-10 20:41 UTC, Erik Garres 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description eduardojrobledo 2010-10-24 17:35:25 UTC 
If the search criteria string ends with parenthesis, the match function return is 
wrong:
a. if in the lookup array there are an exact match of the search criteria and a 
similar string (the search criteria without the parenthesis), the match function 
will return the position of the similar string
b. if in the lookup array there is an exact match of the search criteria and no 
similar string, the match function will return #N/A
Comment 1 eduardojrobledo 2010-10-24 17:37:24 UTC 
Created attachment 72726 [details]
file with example of error
Comment 2 Edwin Sharp 2013-10-04 11:53:28 UTC 
#N/A when parenthesis.

AOO401m5(Build:9714)  -  Rev. 1523756
2013-09-16 20:50:21 (Mo, 16 Sep 2013)
Win 7
Comment 3 Andreas Säger 2013-10-05 12:16:01 UTC 
For more than 90% of today's spreadsheet users (who actually try to use Calc as a database program):

Call Tools>Options>Calc>Calculation and turn off all the check boxes except "Search criteria = and <> must apply to whole cells". 

The default settings are completely insane for database-style lookups. None of these settings should exist anyway, unfortunately all this nonsense made it into the ODF standard.
Comment 4 Erik Garres 2021-05-10 20:41:14 UTC 
Created attachment 87024 [details]
Testing 44 cases, 8 passed

The error is not just with parenthesis at the end but anywhere, and also with square brackets
Comment 5 Andreas Säger 2021-08-26 12:26:12 UTC 
Turn off all those awful default settings.