incubator-ooo-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From liu...@apache.org
Subject svn commit: r1374129 - /incubator/ooo/trunk/main/test/testuno/source/testcase/uno/sc/rowcolumn/InsertDeleteRowAndColumn.java
Date Fri, 17 Aug 2012 02:01:36 GMT
Author: liuzhe
Date: Fri Aug 17 02:01:35 2012
New Revision: 1374129

URL: http://svn.apache.org/viewvc?rev=1374129&view=rev
Log:
#120591# - [Automation][UNO] Insert/Delete Rows and Columns in Spreadsheet.
Patch by: Guo Bin <binbjguo@gmail.com>
Review by: Liu Zhe <aliuzhe@gmail.com>

Added:
    incubator/ooo/trunk/main/test/testuno/source/testcase/uno/sc/rowcolumn/InsertDeleteRowAndColumn.java

Added: incubator/ooo/trunk/main/test/testuno/source/testcase/uno/sc/rowcolumn/InsertDeleteRowAndColumn.java
URL: http://svn.apache.org/viewvc/incubator/ooo/trunk/main/test/testuno/source/testcase/uno/sc/rowcolumn/InsertDeleteRowAndColumn.java?rev=1374129&view=auto
==============================================================================
--- incubator/ooo/trunk/main/test/testuno/source/testcase/uno/sc/rowcolumn/InsertDeleteRowAndColumn.java
(added)
+++ incubator/ooo/trunk/main/test/testuno/source/testcase/uno/sc/rowcolumn/InsertDeleteRowAndColumn.java
Fri Aug 17 02:01:35 2012
@@ -0,0 +1,143 @@
+
+
+
+
+package testcase.uno.sc.rowcolumn;
+
+import static org.junit.Assert.*;
+
+
+import org.junit.After;
+import org.junit.Before;
+import org.junit.Test;
+
+import org.openoffice.test.uno.UnoApp;
+
+
+import com.sun.star.lang.XComponent;
+import com.sun.star.sheet.XSpreadsheet;
+import com.sun.star.sheet.XSpreadsheetDocument;
+import com.sun.star.sheet.XSpreadsheets;
+import com.sun.star.table.XCell;
+import com.sun.star.uno.UnoRuntime;
+import com.sun.star.table.XTableColumns;
+import com.sun.star.table.XTableRows;
+import com.sun.star.table.XColumnRowRange;
+
+/**
+ * Test insert or delete rows and columns
+ * @author test
+ *
+ */
+
+public class InsertDeleteRowAndColumn {
+	
+	UnoApp unoApp = new UnoApp();
+	XSpreadsheetDocument scDocument = null;
+	XComponent scComponent = null;
+	
+	@Before
+	public void setUp() throws Exception {
+		unoApp.start();
+	}
+
+	@After
+	public void tearDown() throws Exception {
+		unoApp.closeDocument(scComponent);
+		unoApp.close();
+		}
+	
+	@Test
+	public void testInsertDeleteRows() throws Exception {
+	
+		String sheetname = "sheet1";
+		scComponent = unoApp.newDocument("scalc");
+		scDocument = (XSpreadsheetDocument) UnoRuntime.queryInterface(XSpreadsheetDocument.class,
scComponent);
+		XSpreadsheets spreadsheets = scDocument.getSheets();
+		Object sheetObj = spreadsheets.getByName(sheetname);
+	
+		
+		XSpreadsheet sheet = (XSpreadsheet) UnoRuntime.queryInterface(XSpreadsheet.class, sheetObj);
+		XColumnRowRange xCRRange = (XColumnRowRange) UnoRuntime.queryInterface( XColumnRowRange.class,
sheet );
+	    XTableRows xRows = xCRRange.getRows();
+	    
+		// Create a cell series "A2:A8" with the values 1 ... 7.
+	    int nRow = 1;
+	    for (int i = 1; i < 8; ++i) {
+	        sheet.getCellByPosition( 0, nRow ).setValue( nRow );
+            nRow += 1;
+		}
+  		
+        //Insert a row between row 2 and row 3
+   		xRows.insertByIndex( 2, 1 );
+   		 
+        //Get value of cell A3 
+        XCell cell = sheet.getCellByPosition(0, 2);
+        double checkvalue = 0.0;
+        
+        //Verify after insert row
+        assertEquals("Verify one new row inserted after Row 2",checkvalue, cell.getValue(),0);
+        
+        //Delete the row 3 and row 4
+        xRows.removeByIndex( 2, 2 );
+        
+        //Get value of cell A3 and A4  
+        XCell cellA3 = sheet.getCellByPosition(0, 2);
+        XCell cellA4 = sheet.getCellByPosition(0, 3);        
+        double checkvalueA3 = 3.0;
+        double checkvalueA4 = 4.0;
+        
+        //Verify after delete row3 and row4 
+        assertEquals("Verify tow rows deleted the value of row 3",checkvalueA3, cellA3.getValue(),0);
+        assertEquals("Verify tow rows deleted the value of row 4",checkvalueA4, cellA4.getValue(),0);
+    
+}
+
+@Test
+public void testInsertDeleteColumns() throws Exception {
+	
+	String sheetname = "sheet1";
+	scComponent = unoApp.newDocument("scalc");
+	scDocument = (XSpreadsheetDocument) UnoRuntime.queryInterface(XSpreadsheetDocument.class,
scComponent);
+	XSpreadsheets spreadsheets = scDocument.getSheets();
+	Object sheetObj = spreadsheets.getByName(sheetname);
+
+	
+	XSpreadsheet sheet = (XSpreadsheet) UnoRuntime.queryInterface(XSpreadsheet.class, sheetObj);
+	XColumnRowRange xCRRange = (XColumnRowRange) UnoRuntime.queryInterface( XColumnRowRange.class,
sheet );
+    XTableColumns xColumns = xCRRange.getColumns();
+	
+	// Create a cell series "A2:A8" with the values 1 ... 7.
+    int nRow = 1;
+    for (int i = 1; i < 8; ++i) {
+        sheet.getCellByPosition( 1, nRow ).setValue( nRow );
+        nRow += 1;
+	}
+		
+    //Insert a row between row 2 and row 3
+	xColumns.insertByIndex( 0, 1 );
+		 
+    //Get value of cell C2 
+    XCell cell = sheet.getCellByPosition(2, 1);
+    double checkvalue = 1.0;
+    
+    //Verify after insert row
+    assertEquals("Verify if one new column inserted after Column A",checkvalue, cell.getValue(),0);
+    
+    //Delete the row 3 and row 4
+    xColumns.removeByIndex( 0, 1 );
+    
+    //Get value of cell A3 and A4  
+    XCell cellA3 = sheet.getCellByPosition(1, 2);
+    XCell cellA4 = sheet.getCellByPosition(1, 3);        
+    double checkvalueA3 = 2.0;
+    double checkvalueA4 = 3.0;
+    
+    //Verify after delete row3 and row4 
+    assertEquals("Verify after tow rows deleted, the value of A3",checkvalueA3, cellA3.getValue(),0);
+    assertEquals("Verify after tow rows deleted, the value of A4",checkvalueA4, cellA4.getValue(),0);
+
+  }
+
+}
+



Mime
View raw message