diff --git a/poi/src/main/java/org/apache/poi/ss/formula/functions/DStarRunner.java b/poi/src/main/java/org/apache/poi/ss/formula/functions/DStarRunner.java index 295721b4d..21aa9ed32 100644 --- a/poi/src/main/java/org/apache/poi/ss/formula/functions/DStarRunner.java +++ b/poi/src/main/java/org/apache/poi/ss/formula/functions/DStarRunner.java @@ -316,7 +316,7 @@ public final class DStarRunner implements Function3Arg { return testNumericCondition(value, operator.equal, stringOrNumber); } else { // It's a string. String valueString = value instanceof BlankEval ? "" : OperandResolver.coerceValueToString(value); - return stringOrNumber.equals(valueString); + return stringOrNumber.equalsIgnoreCase(valueString); } } else { // It's a text starts-with condition. if(conditionString.isEmpty()) { @@ -324,7 +324,8 @@ public final class DStarRunner implements Function3Arg { } else { String valueString = value instanceof BlankEval ? "" : OperandResolver.coerceValueToString(value); - return valueString.startsWith(conditionString); + return valueString.toUpperCase().toLowerCase() + .startsWith(conditionString.toUpperCase().toLowerCase()); } } } else if(condition instanceof NumericValueEval) {