Issue 115229

Summary:

Match function error when looking for a string ending with parenthesis

Product:

Calc

Reporter:

eduardojrobledo <gte.ejecutivo>

Component:

code

Assignee:

AOO issues mailing list <issues>

Status:

CONFIRMED ---

QA Contact:

Nika <nika.kovach>

Severity:

Trivial

Priority:

CC:

egarres, elish, issues, mseidel, villeroy

Version:

OOo 3.2.1

Target Milestone:

---

Hardware:

OS:

Windows 7

Issue Type:

DEFECT

Latest Confirmation in:

---

Developer Difficulty:

---

Attachments:

Description	Flags
file with example of error	none
Testing 44 cases, 8 passed	none

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.