aboutsummaryrefslogtreecommitdiffstats
path: root/src/testcases/org/apache/poi/hssf/usermodel/TestFormulas.java
diff options
context:
space:
mode:
authorAvik Sengupta <avik@apache.org>2005-04-22 13:12:14 +0000
committerAvik Sengupta <avik@apache.org>2005-04-22 13:12:14 +0000
commitec5e6acbf3e97b3e2e7ae47cc4b3d0b4b96e6ed8 (patch)
treee8598245aa7be1e8b978ba7295e8b6553bc2deb7 /src/testcases/org/apache/poi/hssf/usermodel/TestFormulas.java
parenta6779802bc9cba03f71b5fc81a86da2b25042ab9 (diff)
downloadpoi-ec5e6acbf3e97b3e2e7ae47cc4b3d0b4b96e6ed8.tar.gz
poi-ec5e6acbf3e97b3e2e7ae47cc4b3d0b4b96e6ed8.zip
testcase for bug 34021 , already worked fine
git-svn-id: https://svn.apache.org/repos/asf/jakarta/poi/trunk@353647 13f79535-47bb-0310-9956-ffa450edef68
Diffstat (limited to 'src/testcases/org/apache/poi/hssf/usermodel/TestFormulas.java')
-rw-r--r--src/testcases/org/apache/poi/hssf/usermodel/TestFormulas.java10
1 files changed, 10 insertions, 0 deletions
diff --git a/src/testcases/org/apache/poi/hssf/usermodel/TestFormulas.java b/src/testcases/org/apache/poi/hssf/usermodel/TestFormulas.java
index 3503757a99..9fe7c5e67e 100644
--- a/src/testcases/org/apache/poi/hssf/usermodel/TestFormulas.java
+++ b/src/testcases/org/apache/poi/hssf/usermodel/TestFormulas.java
@@ -1084,6 +1084,16 @@ extends TestCase {
assertEquals("String Cell value","XYZ",c.getStringCellValue());
}
+ /** test for bug 34021*/
+ public void testComplexSheetRefs () throws IOException {
+ HSSFWorkbook sb = new HSSFWorkbook();
+ HSSFSheet s1 = sb.createSheet("Sheet a.1");
+ HSSFSheet s2 = sb.createSheet("Sheet.A");
+ s2.createRow(1).createCell((short) 2).setCellFormula("'Sheet a.1'!A1");
+ s1.createRow(1).createCell((short) 2).setCellFormula("'Sheet.A'!A1");
+ File file = TempFile.createTempFile("testComplexSheetRefs",".xls");
+ sb.write(new FileOutputStream(file));
+ }
public static void main(String [] args) {
System.out
.println("Testing org.apache.poi.hssf.usermodel.TestFormulas");