xref: /trunk/test/testuno/source/fvt/uno/sc/cell/DeleteContents.java (revision eba4d44a33e5be0b2528d5a9a6f0dcbf65adaa0d)

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());

    }

}