Bug 46613

Summary:	Evaluator string comparisons should be case insensitive
Product:	POI	Reporter:	Josh Micich <josh>
Component:	HSSF	Assignee:	POI Developers List <dev>
Status:	RESOLVED FIXED
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:
http://www.nabble.com/Case-sensitivity-while-evaluating-formulas-td21682982.html#a21682982

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.