https://issues.apache.org/bugzilla/show_bug.cgi?id=46647
Summary: COUNTIF function evaluates "<>" operator incorrectly
Product: POI
Version: 3.2-FINAL
Platform: PC
OS/Version: Windows XP
Status: NEW
Severity: critical
Priority: P4
Component: HSSF
AssignedTo: [email protected]
ReportedBy: [email protected]
Should have "case NE: return cmpResult != 0;" on line 131:
http://svn.apache.org/viewvc/poi/trunk/src/java/org/apache/poi/hssf/record/formula/functions/Countif.java?annotate=734243
There are also problems with string to number conversion, for example:
'<>123' should always match string values, even '123' (the only thing it
doesn't match is 123).
'>5' should never match any string value, even '6'
No string-to-number conversion is ever required for operators besides '=' and
'' (no operator, very similar to '=')
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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]
