You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@poi.apache.org by ce...@apache.org on 2015/09/03 22:46:14 UTC
svn commit: r1701133 - in /poi/trunk:
src/ooxml/testcases/org/apache/poi/xssf/usermodel/TestXSSFBugs.java
test-data/spreadsheet/53105.xlsx
Author: centic
Date: Thu Sep 3 20:46:14 2015
New Revision: 1701133
URL: http://svn.apache.org/r1701133
Log:
Add unit test which verifies that bug 53105 is actually fixed now
Added:
poi/trunk/test-data/spreadsheet/53105.xlsx
Modified:
poi/trunk/src/ooxml/testcases/org/apache/poi/xssf/usermodel/TestXSSFBugs.java
Modified: poi/trunk/src/ooxml/testcases/org/apache/poi/xssf/usermodel/TestXSSFBugs.java
URL: http://svn.apache.org/viewvc/poi/trunk/src/ooxml/testcases/org/apache/poi/xssf/usermodel/TestXSSFBugs.java?rev=1701133&r1=1701132&r2=1701133&view=diff
==============================================================================
--- poi/trunk/src/ooxml/testcases/org/apache/poi/xssf/usermodel/TestXSSFBugs.java (original)
+++ poi/trunk/src/ooxml/testcases/org/apache/poi/xssf/usermodel/TestXSSFBugs.java Thu Sep 3 20:46:14 2015
@@ -2616,4 +2616,21 @@ public final class TestXSSFBugs extends
wb.close();
}
+
+ @Test
+ public void test53105() throws IOException {
+ Workbook wb = XSSFTestDataSamples.openSampleWorkbook("53105.xlsx");
+ assertNotNull(wb);
+
+
+ // Act
+ // evaluate SUM('Skye Lookup Input'!A4:XFD4), cells in range each contain "1"
+ FormulaEvaluator evaluator = wb.getCreationHelper().createFormulaEvaluator();
+ double numericValue = evaluator.evaluate(wb.getSheetAt(0).getRow(1).getCell(0)).getNumberValue();
+
+ // Assert
+ assertEquals(16384.0, numericValue, 0.0);
+
+ wb.close();
+ }
}
Added: poi/trunk/test-data/spreadsheet/53105.xlsx
URL: http://svn.apache.org/viewvc/poi/trunk/test-data/spreadsheet/53105.xlsx?rev=1701133&view=auto
==============================================================================
Binary files poi/trunk/test-data/spreadsheet/53105.xlsx (added) and poi/trunk/test-data/spreadsheet/53105.xlsx Thu Sep 3 20:46:14 2015 differ
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@poi.apache.org
For additional commands, e-mail: commits-help@poi.apache.org