|
Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
| Summary: | Countif misses matches if they contain "[" "(" ")" or "=" | ||||||||
|---|---|---|---|---|---|---|---|---|---|
| Product: | Calc | Reporter: | sm0090 | ||||||
| Component: | ui | Assignee: | AOO issues mailing list <issues> | ||||||
| Status: | CONFIRMED --- | QA Contact: | |||||||
| Severity: | Normal | ||||||||
| Priority: | P3 | CC: | elish, issues | ||||||
| Version: | 3.4.1 | ||||||||
| Target Milestone: | --- | ||||||||
| Hardware: | PC | ||||||||
| OS: | Windows, all | ||||||||
| Issue Type: | DEFECT | Latest Confirmation in: | --- | ||||||
| Developer Difficulty: | --- | ||||||||
| Attachments: |
|
||||||||
Created attachment 81500 [details]
Calc vs. Gnumeric
Gnumeric 1.10.16
Confirmed with Rev. 1520602 Win 7 |
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.