Bug 104776

Summary: COUNTIFS will not match strings that contain parenthesis
Product: LibreOffice Reporter: Brian "bex" Exelbierd <bex>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED NOTABUG    
Severity: normal CC: ilmari.lauhakangas
Priority: medium    
Version: 5.1.6.2 release   
Hardware: All   
OS: All   
Whiteboard:
Crash report or crash signature: Regression By:
Attachments: Sample Spreadsheet Demonstrating Error

Description Brian "bex" Exelbierd 2016-12-19 10:21:52 UTC 
Description:
In Column A I have a list of values containing strings such as "a (b)" or "b (c)"

In column E I have a list containing each unique value in column A.

Column D consists of this equation:

=countifs(a:a,e1)

in this case e1 contains a value from column A.

The count is always zero.

Steps to Reproduce:
See description for required spreadsheet.

Expected Results:
Count of values


Reproducible: Always

User Profile Reset: No

Additional Info:


User-Agent: Mozilla/5.0 (X11; Fedora; Linux x86_64; rv:50.0) Gecko/20100101 Firefox/50.0
Comment 1 Brian "bex" Exelbierd 2016-12-19 10:22:38 UTC 
Created attachment 129772 [details]
Sample Spreadsheet Demonstrating Error
Comment 2 Buovjaga 2016-12-19 19:07:07 UTC 
Tools > Options > LibreOffice Calc > Calculate
Enable regular expressions in formulas is causing this. Set the radio button to somewhere else for a quick fix.

For a more industrial-strength solution, check the file attached by Lupp in an answer to this: https://ask.libreoffice.org/en/question/33779/how-do-i-escape-a-cell-value-to-stop-it-being-treated-as-a-regular-expression/?answer=34614#post-id-34614

Closing.