Author: centic
Date: Fri Aug 23 18:56:32 2013
New Revision: 1516982
URL: http://svn.apache.org/r1516982
Log:
Tried to reproduce Bug 47090, but seems to be fixed now.
Added:
poi/trunk/test-data/spreadsheet/47090.xlsx
Modified:
poi/trunk/src/ooxml/testcases/org/apache/poi/xssf/usermodel/TestXSSFWorkbook.java
Modified:
poi/trunk/src/ooxml/testcases/org/apache/poi/xssf/usermodel/TestXSSFWorkbook.java
URL:
http://svn.apache.org/viewvc/poi/trunk/src/ooxml/testcases/org/apache/poi/xssf/usermodel/TestXSSFWorkbook.java?rev=1516982&r1=1516981&r2=1516982&view=diff
==============================================================================
---
poi/trunk/src/ooxml/testcases/org/apache/poi/xssf/usermodel/TestXSSFWorkbook.java
(original)
+++
poi/trunk/src/ooxml/testcases/org/apache/poi/xssf/usermodel/TestXSSFWorkbook.java
Fri Aug 23 18:56:32 2013
@@ -528,4 +528,50 @@ public final class TestXSSFWorkbook exte
}
System.out.println("Done");
}
+
+ public void testBug47090a() {
+ Workbook workbook =
XSSFTestDataSamples.openSampleWorkbook("47090.xlsx");
+ assertSheetOrder(workbook, "Sheet1", "Sheet2");
+ workbook.removeSheetAt(0);
+ assertSheetOrder(workbook, "Sheet2");
+ workbook.createSheet();
+ assertSheetOrder(workbook, "Sheet2", "Sheet1");
+ Workbook read = XSSFTestDataSamples.writeOutAndReadBack(workbook);
+ assertSheetOrder(read, "Sheet2", "Sheet1");
+ }
+
+ public void testBug47090b() {
+ Workbook workbook =
XSSFTestDataSamples.openSampleWorkbook("47090.xlsx");
+ assertSheetOrder(workbook, "Sheet1", "Sheet2");
+ workbook.removeSheetAt(1);
+ assertSheetOrder(workbook, "Sheet1");
+ workbook.createSheet();
+ assertSheetOrder(workbook, "Sheet1", "Sheet0"); //
Sheet0 because it uses "Sheet" + sheets.size() as starting point!
+ Workbook read = XSSFTestDataSamples.writeOutAndReadBack(workbook);
+ assertSheetOrder(read, "Sheet1", "Sheet0");
+ }
+
+ public void testBug47090c() {
+ Workbook workbook =
XSSFTestDataSamples.openSampleWorkbook("47090.xlsx");
+ assertSheetOrder(workbook, "Sheet1", "Sheet2");
+ workbook.removeSheetAt(0);
+ assertSheetOrder(workbook, "Sheet2");
+ workbook.cloneSheet(0);
+ assertSheetOrder(workbook, "Sheet2", "Sheet2 (2)");
+ Workbook read = XSSFTestDataSamples.writeOutAndReadBack(workbook);
+ assertSheetOrder(read, "Sheet2", "Sheet2 (2)");
+ }
+
+ public void testBug47090d() {
+ Workbook workbook =
XSSFTestDataSamples.openSampleWorkbook("47090.xlsx");
+ assertSheetOrder(workbook, "Sheet1", "Sheet2");
+ workbook.createSheet();
+ assertSheetOrder(workbook, "Sheet1", "Sheet2", "Sheet0");
+ workbook.removeSheetAt(0);
+ assertSheetOrder(workbook, "Sheet2", "Sheet0");
+ workbook.createSheet();
+ assertSheetOrder(workbook, "Sheet2", "Sheet0", "Sheet1");
+ Workbook read = XSSFTestDataSamples.writeOutAndReadBack(workbook);
+ assertSheetOrder(read, "Sheet2", "Sheet0", "Sheet1");
+ }
}
Added: poi/trunk/test-data/spreadsheet/47090.xlsx
URL:
http://svn.apache.org/viewvc/poi/trunk/test-data/spreadsheet/47090.xlsx?rev=1516982&view=auto
==============================================================================
Files poi/trunk/test-data/spreadsheet/47090.xlsx (added) and
poi/trunk/test-data/spreadsheet/47090.xlsx Fri Aug 23 18:56:32 2013 differ
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
