https://issues.apache.org/ooo/show_bug.cgi?id=123925
Bug ID: 123925
Issue Type: DEFECT
Summary: COUNTIF with criterium <>number does not count empty
cells
Product: Calc
Version: 4.1.0-dev
Hardware: PC
OS: Windows, all
Status: UNCONFIRMED
Severity: normal
Priority: P3
Component: code
Assignee: [email protected]
Reporter: [email protected]
CC: [email protected]
Make sure the cell B2 is empty, that is, it has no content at all
Write the number 7 into cell B3
Write the number 8 into cell B4
Write the formula =COUNTIF(B2:B4;"<>7") into cell A1
Expected result: 2
Seen result: 1
The specification says
"For <>, if the value is not empty it matches any cell content except the
value, including empty cells."
[ODF1.2 part 2 section 4.11.8 Criterion]
Notice the part "including empty cells".
Notice, that this is not about the problem, whether a zero-length string is to
be considered as empty cell.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
