https://issues.apache.org/ooo/show_bug.cgi?id=122187
Bug ID: 122187
Issue Type: DEFECT
Summary: Countif misses matches if they contain "[" "(" ")" or
"="
Classification: Application
Product: Calc
Version: AOO 3.4.1
Hardware: PC
OS: Windows XP
Status: UNCONFIRMED
Severity: normal
Priority: P3
Component: ui
Assignee: [email protected]
Reporter: [email protected]
CC: [email protected]
Created attachment 80605
--> https://issues.apache.org/ooo/attachment.cgi?id=80605&action=edit
4 cases in which the bug occurs (B4:B7) and 3 in which it doesn't (B11:B13)
If a cell contains one of the characters "[" or "(" or ")" or "=" (but
strangely not "]"), it will not count this cell, even if the cell itself is the
search criterion. In those cases, even "=countif(A1;A1)" yields 0 as result.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
