Author: yegor
Date: Sat Jul 24 11:33:59 2010
New Revision: 978848
URL: http://svn.apache.org/viewvc?rev=978848&view=rev
Log:
added a failing unit test for bug #49612
Added:
poi/trunk/test-data/spreadsheet/49612.xls (with props)
Modified:
poi/trunk/src/testcases/org/apache/poi/hssf/usermodel/TestUnfixedBugs.java
Modified:
poi/trunk/src/testcases/org/apache/poi/hssf/usermodel/TestUnfixedBugs.java
URL:
http://svn.apache.org/viewvc/poi/trunk/src/testcases/org/apache/poi/hssf/usermodel/TestUnfixedBugs.java?rev=978848&r1=978847&r2=978848&view=diff
==============================================================================
--- poi/trunk/src/testcases/org/apache/poi/hssf/usermodel/TestUnfixedBugs.java
(original)
+++ poi/trunk/src/testcases/org/apache/poi/hssf/usermodel/TestUnfixedBugs.java
Sat Jul 24 11:33:59 2010
@@ -23,6 +23,10 @@ import junit.framework.TestCase;
import org.apache.poi.hssf.HSSFTestDataSamples;
import org.apache.poi.hssf.record.RecordFormatException;
+import java.io.IOException;
+import java.io.FileInputStream;
+import java.io.File;
+
/**
* @author aviks
*
@@ -46,4 +50,33 @@ public final class TestUnfixedBugs exten
throw e;
}
}
+
+ public void test49612() throws IOException {
+ HSSFWorkbook wb = HSSFTestDataSamples.openSampleWorkbook("49612.xls");
+ HSSFSheet sh = wb.getSheetAt(0);
+ HSSFRow row = sh.getRow(0);
+ HSSFCell c1 = row.getCell(2);
+ HSSFCell d1 = row.getCell(3);
+ HSSFCell e1 = row.getCell(2);
+
+ assertEquals("SUM(BOB+JIM)", c1.getCellFormula());
+
+ // Problem 1: java.lang.ArrayIndexOutOfBoundsException in
org.apache.poi.hssf.model.LinkTable$ExternalBookBlock.getNameText
+ assertEquals("SUM('49612.xls'!BOB+'49612.xls'!JIM)",
d1.getCellFormula());
+
+ //Problem 2
+ //junit.framework.ComparisonFailure:
+ //Expected :SUM('49612.xls'!BOB+'49612.xls'!JIM)
+ //Actual :SUM(BOB+JIM)
+ assertEquals("SUM('49612.xls'!BOB+'49612.xls'!JIM)",
e1.getCellFormula());
+
+ HSSFFormulaEvaluator eval = new HSSFFormulaEvaluator(wb);
+ assertEquals("evaluating c1", 30., eval.evaluate(c1).getNumberValue());
+
+ //Problem 3: java.lang.RuntimeException: Unexpected arg eval type
(org.apache.poi.hssf.record.formula.eval.NameXEval)
+ assertEquals("evaluating d1", 30., eval.evaluate(d1).getNumberValue());
+
+ assertEquals("evaluating e1", 30., eval.evaluate(e1).getNumberValue());
+ }
+
}
Added: poi/trunk/test-data/spreadsheet/49612.xls
URL:
http://svn.apache.org/viewvc/poi/trunk/test-data/spreadsheet/49612.xls?rev=978848&view=auto
==============================================================================
Binary file - no diff available.
Propchange: poi/trunk/test-data/spreadsheet/49612.xls
------------------------------------------------------------------------------
svn:executable = *
Propchange: poi/trunk/test-data/spreadsheet/49612.xls
------------------------------------------------------------------------------
svn:mime-type = application/octet-stream
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
