46613 – Evaluator string comparisons should be case insensitive

Bug 46613 - Evaluator string comparisons should be case insensitive

Summary: Evaluator string comparisons should be case insensitive

Status:	RESOLVED FIXED

Alias:	None

Product:	POI
Classification:	Unclassified
Component:	HSSF (show other bugs)
Version:	3.0-FINAL
Hardware:	PC Windows XP

Importance:	P2 normal (vote)
Target Milestone:	---
Assignee:	POI Developers List

URL:
Keywords:

Depends on:
Blocks:

Reported:	2009-01-27 10:59 UTC by Josh Micich
Modified:	2009-01-27 11:06 UTC (History)
CC List:	0 users

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.

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.