test/testuno/source/fvt/uno/sc/cell/DeleteContents.java

/**************************************************************
 *
 * Licensed to the Apache Software Foundation (ASF) under one
 * or more contributor license agreements.  See the NOTICE file
 * distributed with this work for additional information
 * regarding copyright ownership.  The ASF licenses this file
 * to you under the Apache License, Version 2.0 (the
 * "License"); you may not use this file except in compliance
 * with the License.  You may obtain a copy of the License at
 *
 *   http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing,
 * software distributed under the License is distributed on an
 * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
 * KIND, either express or implied.  See the License for the
 * specific language governing permissions and limitations
 * under the License.
 *
 *************************************************************/

package fvt.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());

    }

}