https://issues.apache.org/bugzilla/show_bug.cgi?id=51498
Yegor Kozlov <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution| |FIXED --- Comment #11 from Yegor Kozlov <[email protected]> 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: [email protected] For additional commands, e-mail: [email protected]
