test/testgui/source/fvt/gui/sc/rowcolumn/InsertRowAndColumn.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.gui.sc.rowcolumn;

import static org.junit.Assert.*;
import static testlib.gui.AppTool.*;
import static testlib.gui.UIMap.*;

import org.junit.After;
import org.junit.Before;
import org.junit.Rule;
import org.junit.Test;
import org.openoffice.test.common.Logger;

import testlib.gui.AppTool;
import testlib.gui.SCTool;

public class InsertRowAndColumn {
	@Rule
	public Logger log = Logger.getLogger(this);

	@Before
	public void setUp() throws Exception {
		app.start();
		AppTool.newSpreadsheet();
	}

	@After
	public void tearDown() throws Exception {
		app.stop();
	}

	/**
	 * Insert new entire row and column
	 *
	 * @throws Exception
	 */

	@Test
	public void testInsertEntireRowColumn() {

		// insert data in cell A2 and B2
		SCTool.selectRange("Sheet1.A2");
		typeKeys("123");
		SCTool.selectRange("Sheet1.B2");
		typeKeys("456");

		// Set expected result after executing insert one row
		String[][] expectedInsertRowResult = new String[][] { { "", "" }, { "", "" }, { "123", "456" }, };

		// Select Cell A2
		SCTool.selectRange("Sheet1.A2");

		// Insert one entire Row via menu
		calc.menuItem("Insert->Rows").select();

		// Verify results after inserting one row
		assertArrayEquals("Verify results after inserting one row", expectedInsertRowResult, SCTool.getCellTexts("A1:B3"));

		// Set expected result after executing insert column
		String[][] expectedInsertColumnResult = new String[][] { { "", "", "" }, { "", "", "" }, { "", "123", "456" }, };
		// Select Cell A3
		SCTool.selectRange("Sheet1.A3");
		// Insert one entire Column via menu
		calc.menuItem("Insert->Columns").select();

		// Verify results after inserting one column
		assertArrayEquals("Verify results after inserting one column", expectedInsertColumnResult, SCTool.getCellTexts("A1:C3"));

	}

}