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/15 16:36:31 UTC

svn commit: r1748606 - in /poi/trunk: src/ooxml/testcases/org/apache/poi/xssf/usermodel/TestXSSFBugs.java test-data/spreadsheet/ExcelTables.xlsx

Author: onealj
Date: Wed Jun 15 16:36:31 2016
New Revision: 1748606

URL: http://svn.apache.org/viewvc?rev=1748606&view=rev
Log:
add disabled unit test for bug 55273: contributed by Martin Studer

Added:
    poi/trunk/test-data/spreadsheet/ExcelTables.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=1748606&r1=1748605&r2=1748606&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 Wed Jun 15 16:36:31 2016
@@ -3049,4 +3049,22 @@ public final class TestXSSFBugs extends
         
         nwb.close();
     }
+
+    @Ignore("currently fails on POI 3.15 beta 2")
+    @Test
+    public void test55273() {
+        Workbook wb = XSSFTestDataSamples.openSampleWorkbook("ExcelTables.xlsx");
+        Sheet sheet = wb.getSheet("ExcelTable");
+
+        Name name = wb.getName("TableAsRangeName");
+        assertEquals("TableName[#All]", name.getRefersToFormula());
+        // POI 3.15-beta 2 (2016-06-15): getSheetName throws IllegalArgumentException: Invalid CellReference: TableName[#All]
+        assertEquals("TableName", name.getSheetName());
+
+        XSSFSheet xsheet = (XSSFSheet) sheet;
+        List<XSSFTable> tables = xsheet.getTables();
+        assertEquals(2, tables.size()); //FIXME: how many tables are there in this spreadsheet?
+        assertEquals("Table1", tables.get(0).getName()); //FIXME: what is the table name?
+        assertEquals("Table2", tables.get(1).getName()); //FIXME: what is the table name?
+    }
 }

Added: poi/trunk/test-data/spreadsheet/ExcelTables.xlsx
URL: http://svn.apache.org/viewvc/poi/trunk/test-data/spreadsheet/ExcelTables.xlsx?rev=1748606&view=auto
==============================================================================
Binary file - no diff available.

Propchange: poi/trunk/test-data/spreadsheet/ExcelTables.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