Author: onealj
Date: Sun Nov 12 06:14:43 2017
New Revision: 1815001
URL: http://svn.apache.org/viewvc?rev=1815001&view=rev
Log:
github #81: sheet names are case insensitive
Modified:
poi/trunk/src/java/org/apache/poi/ss/formula/FormulaShifter.java
Modified: poi/trunk/src/java/org/apache/poi/ss/formula/FormulaShifter.java
URL:
http://svn.apache.org/viewvc/poi/trunk/src/java/org/apache/poi/ss/formula/FormulaShifter.java?rev=1815001&r1=1815000&r2=1815001&view=diff
==============================================================================
--- poi/trunk/src/java/org/apache/poi/ss/formula/FormulaShifter.java (original)
+++ poi/trunk/src/java/org/apache/poi/ss/formula/FormulaShifter.java Sun Nov 12
06:14:43 2017
@@ -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;
}
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
