Bug 104776 - COUNTIFS will not match strings that contain parenthesis
Summary: COUNTIFS will not match strings that contain parenthesis
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.1.6.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2016-12-19 10:21 UTC by Brian "bex" Exelbierd
Modified: 2016-12-19 19:07 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
Sample Spreadsheet Demonstrating Error (10.24 KB, application/vnd.oasis.opendocument.spreadsheet)
2016-12-19 10:22 UTC, Brian "bex" Exelbierd
Details

Note You need to log in before you can comment on or make changes to this bug.
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.