initial support for SXSSF tests

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1124177 13f79535-47bb-0310-9956-ffa450edef68

3 files changed, 32 insertions, 32 deletions

diff --git a/src/testcases/org/apache/poi/ss/usermodel/BaseTestCell.java b/src/testcases/org/apache/poi/ss/usermodel/BaseTestCell.java
index dbbad380d4..e521aa59c7 100644
--- a/src/testcases/org/apache/poi/ss/usermodel/BaseTestCell.java
+++ b/src/testcases/org/apache/poi/ss/usermodel/BaseTestCell.java
@@ -39,7 +39,7 @@ public abstract class BaseTestCell extends TestCase {
 		_testDataProvider = testDataProvider;
 	}
 
-	public final void testSetValues() {
+	public void testSetValues() {
 		Workbook book = _testDataProvider.createWorkbook();
 		Sheet sheet = book.createSheet("test");
 		Row row = sheet.createRow(0);
@@ -127,7 +127,7 @@ public abstract class BaseTestCell extends TestCase {
 	/**
 	 * test that Boolean and Error types (BoolErrRecord) are supported properly.
 	 */
-	public final void testBoolErr() {
+	public void testBoolErr() {
 
 		Workbook wb = _testDataProvider.createWorkbook();
 		Sheet s = wb.createSheet("testSheet1");
@@ -168,7 +168,7 @@ public abstract class BaseTestCell extends TestCase {
 	/**
 	 * test that Cell Styles being applied to formulas remain intact
 	 */
-	public final void testFormulaStyle() {
+	public void testFormulaStyle() {
 
 		Workbook wb = _testDataProvider.createWorkbook();
 		Sheet s = wb.createSheet("testSheet1");
@@ -209,7 +209,7 @@ public abstract class BaseTestCell extends TestCase {
 	}
 
 	/**tests the toString() method of HSSFCell*/
-	public final void testToString() {
+	public void testToString() {
 		Workbook wb = _testDataProvider.createWorkbook();
 		Row r = wb.createSheet("Sheet1").createRow(0);
 		CreationHelper factory = wb.getCreationHelper();
@@ -240,7 +240,7 @@ public abstract class BaseTestCell extends TestCase {
 	/**
 	 *  Test that setting cached formula result keeps the cell type
 	 */
-	public final void testSetFormulaValue() {
+	public void testSetFormulaValue() {
 		Workbook wb = _testDataProvider.createWorkbook();
 		Sheet s = wb.createSheet();
 		Row r = s.createRow(0);
@@ -274,7 +274,7 @@ public abstract class BaseTestCell extends TestCase {
 	}
 
 
-	public final void testChangeTypeStringToBool() {
+	public void testChangeTypeStringToBool() {
 		Cell cell = createACell();
 
 		cell.setCellValue("TRUE");
@@ -300,7 +300,7 @@ public abstract class BaseTestCell extends TestCase {
 		assertEquals("FALSE", cell.getRichStringCellValue().getString());
 	}
 
-	public final void testChangeTypeBoolToString() {
+	public void testChangeTypeBoolToString() {
 		Cell cell = createACell();
 
 		cell.setCellValue(true);
@@ -316,7 +316,7 @@ public abstract class BaseTestCell extends TestCase {
 		assertEquals("TRUE", cell.getRichStringCellValue().getString());
 	}
 
-	public final void testChangeTypeErrorToNumber() {
+	public void testChangeTypeErrorToNumber() {
 		Cell cell = createACell();
 		cell.setCellErrorValue((byte)ErrorConstants.ERROR_NAME);
 		try {
@@ -327,7 +327,7 @@ public abstract class BaseTestCell extends TestCase {
 		assertEquals(2.5, cell.getNumericCellValue(), 0.0);
 	}
 
-	public final void testChangeTypeErrorToBoolean() {
+	public void testChangeTypeErrorToBoolean() {
 		Cell cell = createACell();
 		cell.setCellErrorValue((byte)ErrorConstants.ERROR_NAME);
 		cell.setCellValue(true);
@@ -348,7 +348,7 @@ public abstract class BaseTestCell extends TestCase {
 	 * {@link FormulaEvaluator#evaluateInCell(Cell)} with a
 	 * string result type.
 	 */
-	public final void testConvertStringFormulaCell() {
+	public void testConvertStringFormulaCell() {
 		Cell cellA1 = createACell();
 		cellA1.setCellFormula("\"abc\"");
 
@@ -370,7 +370,7 @@ public abstract class BaseTestCell extends TestCase {
 	 * similar to {@link #testConvertStringFormulaCell()} but  checks at a
 	 * lower level that {#link {@link Cell#setCellType(int)} works properly
 	 */
-	public final void testSetTypeStringOnFormulaCell() {
+	public void testSetTypeStringOnFormulaCell() {
 		Cell cellA1 = createACell();
 		FormulaEvaluator fe = cellA1.getSheet().getWorkbook().getCreationHelper().createFormulaEvaluator();
 
@@ -465,7 +465,7 @@ public abstract class BaseTestCell extends TestCase {
 		assertEquals("SUM(A1:B1)", cell.getCellFormula());
 	}
 
-	public final void testSetStringInFormulaCell_bug44606() {
+	public void testSetStringInFormulaCell_bug44606() {
 		Workbook wb = _testDataProvider.createWorkbook();
 		Cell cell = wb.createSheet("Sheet1").createRow(0).createCell(0);
 		cell.setCellFormula("B1&C1");
diff --git a/src/testcases/org/apache/poi/ss/usermodel/BaseTestRow.java b/src/testcases/org/apache/poi/ss/usermodel/BaseTestRow.java
index a229804a09..51f8db91b2 100644
--- a/src/testcases/org/apache/poi/ss/usermodel/BaseTestRow.java
+++ b/src/testcases/org/apache/poi/ss/usermodel/BaseTestRow.java
@@ -35,7 +35,7 @@ public abstract class BaseTestRow extends TestCase {
         _testDataProvider = testDataProvider;
     }
 
-    public final void testLastAndFirstColumns() {
+    public void testLastAndFirstColumns() {
         Workbook workbook = _testDataProvider.createWorkbook();
         Sheet sheet = workbook.createSheet();
         Row row = sheet.createRow(0);
@@ -63,7 +63,7 @@ public abstract class BaseTestRow extends TestCase {
      * Make sure that there is no cross-talk between rows especially with getFirstCellNum and getLastCellNum
      * This test was added in response to bug report 44987.
      */
-    public final void testBoundsInMultipleRows() {
+    public void testBoundsInMultipleRows() {
         Workbook workbook = _testDataProvider.createWorkbook();
         Sheet sheet = workbook.createSheet();
         Row rowA = sheet.createRow(0);
@@ -87,7 +87,7 @@ public abstract class BaseTestRow extends TestCase {
         assertEquals(31, rowB.getLastCellNum());
     }
 
-    public final void testRemoveCell() {
+    public void testRemoveCell() {
         Workbook workbook = _testDataProvider.createWorkbook();
         Sheet sheet = workbook.createSheet();
         Row row = sheet.createRow(0);
@@ -188,7 +188,7 @@ public abstract class BaseTestRow extends TestCase {
      * Prior to patch 43901, POI was producing files with the wrong last-column
      * number on the row
      */
-    public final void testLastCellNumIsCorrectAfterAddCell_bug43901(){
+    public void testLastCellNumIsCorrectAfterAddCell_bug43901(){
         Workbook workbook = _testDataProvider.createWorkbook();
         Sheet sheet = workbook.createSheet("test");
         Row row = sheet.createRow(0);
@@ -210,7 +210,7 @@ public abstract class BaseTestRow extends TestCase {
     /**
      * Tests for the missing/blank cell policy stuff
      */
-    public final void testGetCellPolicy() {
+    public void testGetCellPolicy() {
         Workbook workbook = _testDataProvider.createWorkbook();
         Sheet sheet = workbook.createSheet("test");
         Row row = sheet.createRow(0);
@@ -279,7 +279,7 @@ public abstract class BaseTestRow extends TestCase {
         assertEquals(Cell.CELL_TYPE_NUMERIC, row.getCell(5).getCellType());
     }
 
-    public final void testRowHeight() {
+    public void testRowHeight() {
         Workbook workbook = _testDataProvider.createWorkbook();
         Sheet sheet = workbook.createSheet();
         Row row1 = sheet.createRow(0);
@@ -331,7 +331,7 @@ public abstract class BaseTestRow extends TestCase {
     /**
      * Test adding cells to a row in various places and see if we can find them again.
      */
-    public final void testCellIterator() {
+    public void testCellIterator() {
         Workbook wb = _testDataProvider.createWorkbook();
         Sheet sheet = wb.createSheet();
         Row row = sheet.createRow(0);
diff --git a/src/testcases/org/apache/poi/ss/usermodel/BaseTestWorkbook.java b/src/testcases/org/apache/poi/ss/usermodel/BaseTestWorkbook.java
index c3ddee0dda..a4a8d29cc8 100644
--- a/src/testcases/org/apache/poi/ss/usermodel/BaseTestWorkbook.java
+++ b/src/testcases/org/apache/poi/ss/usermodel/BaseTestWorkbook.java
@@ -37,7 +37,7 @@ public abstract class BaseTestWorkbook extends TestCase {
     _testDataProvider = testDataProvider;
     }
 
-    public final void testCreateSheet() {
+    public void testCreateSheet() {
         Workbook wb = _testDataProvider.createWorkbook();
         assertEquals(0, wb.getNumberOfSheets());
 
@@ -125,7 +125,7 @@ public abstract class BaseTestWorkbook extends TestCase {
      * avoid funny duplicate sheet name errors, POI enforces uniqueness on only the first 31 chars.
      * but for the purpose of uniqueness long sheet names are silently truncated to 31 chars.
      */
-    public final void testCreateSheetWithLongNames() {
+    public void testCreateSheetWithLongNames() {
         Workbook wb = _testDataProvider.createWorkbook();
 
         String sheetName1 = "My very long sheet name which is longer than 31 chars";
@@ -155,7 +155,7 @@ public abstract class BaseTestWorkbook extends TestCase {
         assertEquals(1, wb.getSheetIndex(sheetName3));
     }
 
-    public final void testRemoveSheetAt() {
+    public void testRemoveSheetAt() {
         Workbook workbook = _testDataProvider.createWorkbook();
         workbook.createSheet("sheet1");
         workbook.createSheet("sheet2");
@@ -177,7 +177,7 @@ public abstract class BaseTestWorkbook extends TestCase {
         assertEquals(3, workbook.getNumberOfSheets());
     }
 
-    public final void testDefaultValues() {
+    public void testDefaultValues() {
         Workbook b = _testDataProvider.createWorkbook();
         assertEquals(0, b.getActiveSheetIndex());
         assertEquals(0, b.getFirstVisibleTab());
@@ -185,7 +185,7 @@ public abstract class BaseTestWorkbook extends TestCase {
         assertEquals(0, b.getNumberOfSheets());
     }
 
-    public final void testSheetSelection() {
+    public void testSheetSelection() {
         Workbook b = _testDataProvider.createWorkbook();
         b.createSheet("Sheet One");
         b.createSheet("Sheet Two");
@@ -196,7 +196,7 @@ public abstract class BaseTestWorkbook extends TestCase {
         assertEquals(1, b.getFirstVisibleTab());
     }
 
-    public final void testPrintArea() {
+    public void testPrintArea() {
         Workbook workbook = _testDataProvider.createWorkbook();
         Sheet sheet1 = workbook.createSheet("Test Print Area");
         String sheetName1 = sheet1.getSheetName();
@@ -215,7 +215,7 @@ public abstract class BaseTestWorkbook extends TestCase {
         assertNull(workbook.getPrintArea(0));
     }
 
-    public final void testGetSetActiveSheet(){
+    public void testGetSetActiveSheet(){
         Workbook workbook = _testDataProvider.createWorkbook();
         assertEquals(0, workbook.getActiveSheetIndex());
 
@@ -232,7 +232,7 @@ public abstract class BaseTestWorkbook extends TestCase {
         assertEquals(0, workbook.getActiveSheetIndex());
     }
 
-    public final void testSetSheetOrder() {
+    public void testSetSheetOrder() {
         Workbook wb = _testDataProvider.createWorkbook();
 
         for (int i=0; i < 10; i++) {
@@ -288,7 +288,7 @@ public abstract class BaseTestWorkbook extends TestCase {
         }
     }
 
-    public final void testCloneSheet() {
+    public void testCloneSheet() {
         Workbook book = _testDataProvider.createWorkbook();
         Sheet sheet = book.createSheet("TEST");
         sheet.createRow(0).createCell(0).setCellValue("Test");
@@ -316,7 +316,7 @@ public abstract class BaseTestWorkbook extends TestCase {
 
     }
 
-    public final void testParentReferences(){
+    public void testParentReferences(){
         Workbook workbook = _testDataProvider.createWorkbook();
         Sheet sheet = workbook.createSheet();
         assertSame(workbook, sheet.getWorkbook());
@@ -340,7 +340,7 @@ public abstract class BaseTestWorkbook extends TestCase {
         assertSame(row, cell.getRow());
     }
 
-    public final void testSetRepeatingRowsAnsColumns(){
+    public void testSetRepeatingRowsAnsColumns(){
         Workbook wb = _testDataProvider.createWorkbook();
         Sheet sheet1 = wb.createSheet();
         wb.setRepeatingRowsAndColumns(wb.getSheetIndex(sheet1), 0, 0, 0, 3);
@@ -353,7 +353,7 @@ public abstract class BaseTestWorkbook extends TestCase {
     /**
      * Tests that all of the unicode capable string fields can be set, written and then read back
      */
-    public final void testUnicodeInAll() {
+    public void testUnicodeInAll() {
         Workbook wb = _testDataProvider.createWorkbook();
         CreationHelper factory = wb.getCreationHelper();
         //Create a unicode dataformat (contains euro symbol)
@@ -467,7 +467,7 @@ public abstract class BaseTestWorkbook extends TestCase {
      *
      * @see <a href="https://issues.apache.org/bugzilla/show_bug.cgi?id=47100">Bugzilla 47100</a>
      */
-    public final void testSetSheetName() throws Exception {
+    public void testSetSheetName() throws Exception {
 
         Workbook wb = newSetSheetNameTestingWorkbook();