diff options
| author | Javen O'Neal <onealj@apache.org> | 2016-06-20 06:27:12 +0000 |
|---|---|---|
| committer | Javen O'Neal <onealj@apache.org> | 2016-06-20 06:27:12 +0000 |
| commit | 7c9effb080a4e1545ad2bec51575b5d5a11db293 (patch) | |
| tree | 2e1586461e3aea162939676fb4939b80c77f5e03 | |
| parent | 5668323b5de0884e974e1e37aae41adc91218f63 (diff) | |
| download | poi-7c9effb080a4e1545ad2bec51575b5d5a11db293.tar.gz poi-7c9effb080a4e1545ad2bec51575b5d5a11db293.zip | |
bug 57523: add unit test written by Dominik Stadler
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1749267 13f79535-47bb-0310-9956-ffa450edef68
| -rw-r--r-- | src/ooxml/testcases/org/apache/poi/xssf/usermodel/TestXSSFBugs.java | 15 | ||||
| -rw-r--r-- | test-data/spreadsheet/57523.xlsx | bin | 0 -> 50590 bytes |
2 files changed, 15 insertions, 0 deletions
diff --git a/src/ooxml/testcases/org/apache/poi/xssf/usermodel/TestXSSFBugs.java b/src/ooxml/testcases/org/apache/poi/xssf/usermodel/TestXSSFBugs.java index 31a54bf14f..fc5070395d 100644 --- a/src/ooxml/testcases/org/apache/poi/xssf/usermodel/TestXSSFBugs.java +++ b/src/ooxml/testcases/org/apache/poi/xssf/usermodel/TestXSSFBugs.java @@ -3067,4 +3067,19 @@ public final class TestXSSFBugs extends BaseTestBugzillaIssues { 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); + } } diff --git a/test-data/spreadsheet/57523.xlsx b/test-data/spreadsheet/57523.xlsx Binary files differnew file mode 100644 index 0000000000..99fe81d4d5 --- /dev/null +++ b/test-data/spreadsheet/57523.xlsx |