https://bugs.freedesktop.org/show_bug.cgi?id=73081
Priority: medium
Bug ID: 73081
Assignee: [email protected]
Summary: COUNTIF with criterium <>number does not count empty
cells.
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: x86 (IA32)
Status: UNCONFIRMED
Version: 4.1.3.2 release
Component: Spreadsheet
Product: LibreOffice
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 the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
