Bug 46613

Summary: Evaluator string comparisons should be case insensitive
Product: POI Reporter: Josh Micich <josh>
Component: HSSFAssignee: POI Developers List <dev>
Severity: normal    
Priority: P2    
Version: 3.0-FINAL   
Target Milestone: ---   
Hardware: PC   
OS: Windows XP   

Description Josh Micich 2009-01-27 10:59:51 UTC
Created due to the following posting from Stanko:

For example, Excel evaluates this formula: {"yes"="yEs"} to TRUE.  POI currently evaluates it to FALSE.
Comment 1 Josh Micich 2009-01-27 11:06:32 UTC
Fixed in svn r738188.

Junit added.  Note - all comparison operators were affected by this change. So now, "AA"<"aa" evaluates to FALSE and "AA">"aa" also evaluates to FALSE.