poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 51498] Countif.evaluate(int cmpResult) wrong return value for GE
Date Sat, 11 Feb 2012 13:23:44 GMT
https://issues.apache.org/bugzilla/show_bug.cgi?id=51498

Yegor Kozlov <yegor@dinom.ru> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |RESOLVED
         Resolution|                            |FIXED

--- Comment #11 from Yegor Kozlov <yegor@dinom.ru> 2012-02-11 13:23:44 UTC ---
Should be fixed in r1243054

The fix applies to number, boolean and string predicates - they all had
troubles with evaluating blank cells: "<>5", "<>"ABC"", "<>FALSE" returned
wrong result if the range contained blank cells. 

Another problem cropped up with evaluating string predicates: it appears that
string criteria in COUNTIF are case insensitive; for example, the string
"apples" and the string "APPLES" will match the same cells. This is also true
for pattern matching: "ABC*" and "abc*" match the same cells. Before r1243054
POI did everything in the case-sensitive mode which didn't agree with Excel. 

Yegor

-- 
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


Mime
View raw message