poi-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From cen...@apache.org
Subject svn commit: r1701133 - in /poi/trunk: src/ooxml/testcases/org/apache/poi/xssf/usermodel/TestXSSFBugs.java test-data/spreadsheet/53105.xlsx
Date Thu, 03 Sep 2015 20:46:14 GMT
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


Mime
View raw message