https://bugs.freedesktop.org/show_bug.cgi?id=73081
Priority: medium Bug ID: 73081 Assignee: libreoffice-bugs@lists.freedesktop.org Summary: COUNTIF with criterium <>number does not count empty cells. Severity: normal Classification: Unclassified OS: Windows (All) Reporter: rb.hensc...@t-online.de 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 Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs