aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorJaven O'Neal <onealj@apache.org>2017-11-12 06:14:43 +0000
committerJaven O'Neal <onealj@apache.org>2017-11-12 06:14:43 +0000
commitdefe020128ae0bcc7365f7fe3f781b08a640084a (patch)
treed29a1327a61de9f71d17a9994c0fa1b95da2b9fe
parent4cf3b2bee25ffd53006372173256c25f74ced100 (diff)
downloadpoi-defe020128ae0bcc7365f7fe3f781b08a640084a.tar.gz
poi-defe020128ae0bcc7365f7fe3f781b08a640084a.zip
github #81: sheet names are case insensitive
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1815001 13f79535-47bb-0310-9956-ffa450edef68
-rw-r--r--src/java/org/apache/poi/ss/formula/FormulaShifter.java4
1 files changed, 2 insertions, 2 deletions
diff --git a/src/java/org/apache/poi/ss/formula/FormulaShifter.java b/src/java/org/apache/poi/ss/formula/FormulaShifter.java
index d4d23135bc..345f2dff54 100644
--- a/src/java/org/apache/poi/ss/formula/FormulaShifter.java
+++ b/src/java/org/apache/poi/ss/formula/FormulaShifter.java
@@ -213,7 +213,7 @@ public final class FormulaShifter {
if(ptg instanceof Ref3DPxg) {
Ref3DPxg rpxg = (Ref3DPxg)ptg;
if (rpxg.getExternalWorkbookNumber() > 0 ||
- ! _sheetName.equals(rpxg.getSheetName())) {
+ ! _sheetName.equalsIgnoreCase(rpxg.getSheetName())) {
// only move 3D refs that refer to the sheet with cells being moved
return null;
}
@@ -239,7 +239,7 @@ public final class FormulaShifter {
if(ptg instanceof Area3DPxg) {
Area3DPxg apxg = (Area3DPxg)ptg;
if (apxg.getExternalWorkbookNumber() > 0 ||
- ! _sheetName.equals(apxg.getSheetName())) {
+ ! _sheetName.equalsIgnoreCase(apxg.getSheetName())) {
// only move 3D refs that refer to the sheet with cells being moved
return null;
}