incubator-ooo-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From liu...@apache.org
Subject svn commit: r1383816 - in /incubator/ooo/trunk/test/testuno: data/uno/sc/ data/uno/sc/cell/ data/uno/sc/cell/TestDeleteContents.ods source/testcase/uno/sc/cell/DeleteContents.java
Date Wed, 12 Sep 2012 07:34:13 GMT
Author: liuzhe
Date: Wed Sep 12 07:34:13 2012
New Revision: 1383816

URL: http://svn.apache.org/viewvc?rev=1383816&view=rev
Log:
#120817 - [testuno] Delete contents in Spreadsheet.
Patch By: Guo Bin <binbjguo@gmail.com>
Review By: Liu Zhe <aliuzhe@gmail.com>

Added:
    incubator/ooo/trunk/test/testuno/data/uno/sc/
    incubator/ooo/trunk/test/testuno/data/uno/sc/cell/
    incubator/ooo/trunk/test/testuno/data/uno/sc/cell/TestDeleteContents.ods   (with props)
    incubator/ooo/trunk/test/testuno/source/testcase/uno/sc/cell/DeleteContents.java

Added: incubator/ooo/trunk/test/testuno/data/uno/sc/cell/TestDeleteContents.ods
URL: http://svn.apache.org/viewvc/incubator/ooo/trunk/test/testuno/data/uno/sc/cell/TestDeleteContents.ods?rev=1383816&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/ooo/trunk/test/testuno/data/uno/sc/cell/TestDeleteContents.ods
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: incubator/ooo/trunk/test/testuno/source/testcase/uno/sc/cell/DeleteContents.java
URL: http://svn.apache.org/viewvc/incubator/ooo/trunk/test/testuno/source/testcase/uno/sc/cell/DeleteContents.java?rev=1383816&view=auto
==============================================================================
--- incubator/ooo/trunk/test/testuno/source/testcase/uno/sc/cell/DeleteContents.java (added)
+++ incubator/ooo/trunk/test/testuno/source/testcase/uno/sc/cell/DeleteContents.java Wed Sep
12 07:34:13 2012
@@ -0,0 +1,166 @@
+package testcase.uno.sc.cell;
+
+import static org.junit.Assert.*;
+
+import org.junit.After;
+import org.junit.AfterClass;
+import org.junit.Before;
+import org.junit.BeforeClass;
+import org.junit.Test;
+
+import org.openoffice.test.common.Testspace;
+import org.openoffice.test.uno.UnoApp;
+
+import testlib.uno.SCUtil;
+import com.sun.star.lang.XComponent;
+import com.sun.star.sheet.XSpreadsheet;
+import com.sun.star.sheet.XSpreadsheetDocument;
+import com.sun.star.table.XCell;
+import com.sun.star.uno.UnoRuntime;
+import com.sun.star.table.XCellRange;
+import com.sun.star.sheet.XSheetAnnotations;
+import com.sun.star.sheet.XSheetAnnotationsSupplier;
+import com.sun.star.sheet.XSheetOperation;
+import com.sun.star.drawing.XDrawPage;
+import com.sun.star.drawing.XDrawPageSupplier;
+import com.sun.star.drawing.XShapes;
+
+/**
+ * Test delete contents
+ * @author BinGuo 9/4/2012
+ *
+ */
+
+public class DeleteContents {
+	
+	UnoApp unoApp = new UnoApp();
+	XSpreadsheetDocument scDocument = null;
+	XComponent scComponent = null;
+	private String filename = "uno/sc/cell/TestDeleteContents.ods";
+	XDrawPage xpage = null;
+	XShapes xShapes = null;
+	
+	@Before
+	public void setUp() throws Exception {
+		unoApp.start();
+	}
+
+	@After
+	public void tearDown() throws Exception {
+		unoApp.closeDocument(scComponent);
+		unoApp.close();
+		}
+	
+	@BeforeClass
+	public static void setUpConnection() throws Exception {
+//		unoApp.start();
+	}
+
+	@AfterClass
+	public static void tearDownConnection() throws InterruptedException, Exception {
+//		unoApp.close();
+		SCUtil.clearTempDir();	
+	}
+	
+	/**
+	 * Open existing ODS file with contents in cell range B5:C15
+	 * Execute delete Text, Verify results after delete text
+	 * Execute delete Number, Verify results after delete number
+	 * Execute delete Formula, Verify results after delete formula
+	 * Execute delete Comment, Verify results after delete comment
+	 * Execute delete Format, Verify results after delete format
+	 * Execute delete Drawing Object, Verify results after delete object
+	 */	
+	
+	@Test
+	public void testDeleteContents() throws Exception {
+	
+		// Prepare test data
+		String sample = Testspace.prepareData(filename);
+		
+		// Open document
+		scDocument = SCUtil.openFile(sample, unoApp);
+		
+		// Get current sheet
+		XSpreadsheet xSheet = SCUtil.getCurrentSheet(scDocument);
+	    
+		// Get cell range B5:C15 by position - (column, row, column, row)
+        XCellRange xCellRange = xSheet.getCellRangeByPosition( 1, 4, 2, 14 );
+        XSheetOperation xSheetOp = (XSheetOperation) UnoRuntime.queryInterface(XSheetOperation.class,
xCellRange);
+        
+        //Get Cell B5
+        XCell cellB5 = xSheet.getCellByPosition(1, 4);
+        
+        //Delete Text from Cell Range B5:C15
+        xSheetOp.clearContents(4);
+             
+        //Verify results after execute delete 'Text' contents.
+        double NullCellValue = 0.0;
+        assertEquals("Verify after execute delete 'Text' contents.",NullCellValue, cellB5.getValue(),0);
+               
+        //Get Cell B7
+        XCell cellB7 = xSheet.getCellByPosition(1, 6);
+        
+        //Delete Date & Time from Cell Range B5:C15
+        xSheetOp.clearContents(2);
+
+        //Verify results after execute delete 'Date & Time' contents.
+        assertEquals("Verify after execute delete 'Date & Time' contents.",NullCellValue,
cellB7.getValue(),0);
+        
+        //Get Cell B8
+        XCell cellB8 = xSheet.getCellByPosition(1, 7);
+        
+        //Delete Formula from Cell Range B5:C15
+        xSheetOp.clearContents(16);
+        
+        //Verify results after execute delete 'Formula' contents.
+        assertEquals("Verify after execute delete 'Formula' contents.",NullCellValue, cellB8.getValue(),0);
+        
+        //Delete Comment from Cell Range B5:C15
+        xSheetOp.clearContents(8);
+
+        XSheetAnnotationsSupplier xAnnotationsSupp =
+		         (XSheetAnnotationsSupplier) UnoRuntime.queryInterface(
+		             XSheetAnnotationsSupplier.class, xSheet);
+		XSheetAnnotations xAnnotations = xAnnotationsSupp.getAnnotations();
+
+        //Verify comment is deleted.
+		assertEquals("Verify total number of annotations after execute delete annotations."
+	    		  ,0, xAnnotations.getCount());      
+        //Delete contents with Formatted from Cell Range B5:C15
+//        xSheetOp.clearContents(512); @Ignore("#BUGID 120816 - BUG TITLE Method clearContents()
clears 'Formatted' contents of the cells used does not work, If constants of com.sun.star.sheet.CellFlags
is '512'. ")
+        
+        //Get Cell B6 and B10
+        XCell cellB6 = xSheet.getCellByPosition(1, 5);
+        XCell cellB10 = xSheet.getCellByPosition(1, 9);
+        
+        xSheetOp.clearContents(1);
+        
+        //Verify results after execute delete 'Number' contents.
+        assertEquals("Verify after execute delete 'Number' contents in B6.",NullCellValue,
cellB6.getValue(),0);
+        assertEquals("Verify after execute delete 'Number' contents in B10.",NullCellValue,
cellB10.getValue(),0);
+
+        //Get Draw page
+        XDrawPageSupplier xDrawPageSupplier =
+        		(XDrawPageSupplier)UnoRuntime.queryInterface(XDrawPageSupplier.class, xSheet);
+        XDrawPage xDrawPage = xDrawPageSupplier.getDrawPage();
+        
+        XShapes xShapes = (XShapes) UnoRuntime.queryInterface(XShapes.class, xDrawPage);
+        
+        //Verify number of shape in sheet.
+        assertEquals("Verify number of shape in sheet.",1, xShapes.getCount());
+        
+        //Delete drawing object from Cell Range B5:C15
+        xSheetOp.clearContents(128);
+      
+        xShapes = (XShapes) UnoRuntime.queryInterface(XShapes.class, xDrawPage);
+  
+        //Verify results after execute delete 'Objects' contents in cell range. 
+        assertEquals("Verify shape is deleted in sheet after execute delete 'Objects' contents
in cell range."
+    		  ,0, xShapes.getCount());
+
+    }
+	
+}
+
+



Mime
View raw message