From defe020128ae0bcc7365f7fe3f781b08a640084a Mon Sep 17 00:00:00 2001 From: Javen O'Neal Date: Sun, 12 Nov 2017 06:14:43 +0000 Subject: [PATCH] github #81: sheet names are case insensitive git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1815001 13f79535-47bb-0310-9956-ffa450edef68 --- src/java/org/apache/poi/ss/formula/FormulaShifter.java | 4 ++-- 1 file 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; } -- 2.39.5