https://bugs.documentfoundation.org/show_bug.cgi?id=104776
Bug ID: 104776
Summary: COUNTIFS will not match strings that contain
parenthesis
Product: LibreOffice
Version: 5.1.6.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: b...@pobox.com
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
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs