https://bz.apache.org/bugzilla/show_bug.cgi?id=69853
Bug ID: 69853
Summary: COUNTIF with <> (i.e. "not empty") ignores numeric
values
Product: POI
Version: 5.4.1-FINAL
Hardware: PC
OS: Linux
Status: NEW
Severity: normal
Priority: P2
Component: SS Common
Assignee: [email protected]
Reporter: [email protected]
Target Milestone: ---
Created attachment 40119
--> https://bz.apache.org/bugzilla/attachment.cgi?id=40119&action=edit
example
=COUNTIF(range, "<>") is supposed to count the non-empty cells in the range
However, POI seems to ignore non-empty numeric cells
In the attached spreadsheet, cell A3 is supposed to show the value 2 (confirmed
in both Excel and LibreOffice Calc), but POI evaluates it as 1
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
