You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@poi.apache.org by on...@apache.org on 2016/06/20 06:27:12 UTC
svn commit: r1749267 - in /poi/trunk:
src/ooxml/testcases/org/apache/poi/xssf/usermodel/TestXSSFBugs.java
test-data/spreadsheet/57523.xlsx
Author: onealj
Date: Mon Jun 20 06:27:12 2016
New Revision: 1749267
URL: http://svn.apache.org/viewvc?rev=1749267&view=rev
Log:
bug 57523: add unit test written by Dominik Stadler
Added:
poi/trunk/test-data/spreadsheet/57523.xlsx (with props)
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=1749267&r1=1749266&r2=1749267&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 Mon Jun 20 06:27:12 2016
@@ -3067,4 +3067,19 @@ public final class TestXSSFBugs extends
assertEquals("Table1", tables.get(0).getName()); //FIXME: what is the table name?
assertEquals("Table2", tables.get(1).getName()); //FIXME: what is the table name?
}
+
+ @Test
+ public void test57523() {
+ Workbook wb = XSSFTestDataSamples.openSampleWorkbook("57523.xlsx");
+ Sheet sheet = wb.getSheet("Attribute Master");
+ Row row = sheet.getRow(16);
+
+ int N = CellReference.convertColStringToIndex("N");
+ Cell N16 = row.getCell(N);
+ assertEquals(500.0, N16.getNumericCellValue(), 0.00001);
+
+ int P = CellReference.convertColStringToIndex("P");
+ Cell P16 = row.getCell(P);
+ assertEquals(10.0, P16.getNumericCellValue(), 0.00001);
+ }
}
Added: poi/trunk/test-data/spreadsheet/57523.xlsx
URL: http://svn.apache.org/viewvc/poi/trunk/test-data/spreadsheet/57523.xlsx?rev=1749267&view=auto
==============================================================================
Binary file - no diff available.
Propchange: poi/trunk/test-data/spreadsheet/57523.xlsx
------------------------------------------------------------------------------
svn:mime-type = application/octet-stream
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@poi.apache.org
For additional commands, e-mail: commits-help@poi.apache.org