Issue 122187 - Countif misses matches if they contain "[" "(" ")" or "="
Summary: Countif misses matches if they contain "[" "(" ")" or "="
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: 3.4.1
Hardware: PC Windows, all
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2013-04-29 09:25 UTC by sm0090
Modified: 2013-09-10 07:10 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
4 cases in which the bug occurs (B4:B7) and 3 in which it doesn't (B11:B13) (8.94 KB, application/x-vnd.oasis.opendocument.spreadsheet)
2013-04-29 09:25 UTC, sm0090 		no flags Details
Calc vs. Gnumeric (120.82 KB, image/jpeg)
2013-09-10 07:09 UTC, Edwin Sharp 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description sm0090 2013-04-29 09:25:39 UTC 
Created attachment 80605 [details]
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.
Comment 1 Edwin Sharp 2013-09-10 07:09:11 UTC 
Created attachment 81500 [details]
Calc vs. Gnumeric

Gnumeric 1.10.16
Comment 2 Edwin Sharp 2013-09-10 07:10:04 UTC 
Confirmed with Rev. 1520602 Win 7