1*b1cdbd2cSJim Jagielski /************************************************************** 2*b1cdbd2cSJim Jagielski * 3*b1cdbd2cSJim Jagielski * Licensed to the Apache Software Foundation (ASF) under one 4*b1cdbd2cSJim Jagielski * or more contributor license agreements. See the NOTICE file 5*b1cdbd2cSJim Jagielski * distributed with this work for additional information 6*b1cdbd2cSJim Jagielski * regarding copyright ownership. The ASF licenses this file 7*b1cdbd2cSJim Jagielski * to you under the Apache License, Version 2.0 (the 8*b1cdbd2cSJim Jagielski * "License"); you may not use this file except in compliance 9*b1cdbd2cSJim Jagielski * with the License. You may obtain a copy of the License at 10*b1cdbd2cSJim Jagielski * 11*b1cdbd2cSJim Jagielski * http://www.apache.org/licenses/LICENSE-2.0 12*b1cdbd2cSJim Jagielski * 13*b1cdbd2cSJim Jagielski * Unless required by applicable law or agreed to in writing, 14*b1cdbd2cSJim Jagielski * software distributed under the License is distributed on an 15*b1cdbd2cSJim Jagielski * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 16*b1cdbd2cSJim Jagielski * KIND, either express or implied. See the License for the 17*b1cdbd2cSJim Jagielski * specific language governing permissions and limitations 18*b1cdbd2cSJim Jagielski * under the License. 19*b1cdbd2cSJim Jagielski * 20*b1cdbd2cSJim Jagielski *************************************************************/ 21*b1cdbd2cSJim Jagielski package fvt.gui.sc.rowcolumn; 22*b1cdbd2cSJim Jagielski 23*b1cdbd2cSJim Jagielski import static org.junit.Assert.*; 24*b1cdbd2cSJim Jagielski import static testlib.gui.AppTool.*; 25*b1cdbd2cSJim Jagielski import static testlib.gui.UIMap.*; 26*b1cdbd2cSJim Jagielski 27*b1cdbd2cSJim Jagielski import org.junit.After; 28*b1cdbd2cSJim Jagielski import org.junit.Before; 29*b1cdbd2cSJim Jagielski import org.junit.Rule; 30*b1cdbd2cSJim Jagielski import org.junit.Test; 31*b1cdbd2cSJim Jagielski import org.openoffice.test.common.Logger; 32*b1cdbd2cSJim Jagielski 33*b1cdbd2cSJim Jagielski import testlib.gui.AppTool; 34*b1cdbd2cSJim Jagielski import testlib.gui.SCTool; 35*b1cdbd2cSJim Jagielski 36*b1cdbd2cSJim Jagielski public class InsertRowAndColumn { 37*b1cdbd2cSJim Jagielski @Rule 38*b1cdbd2cSJim Jagielski public Logger log = Logger.getLogger(this); 39*b1cdbd2cSJim Jagielski 40*b1cdbd2cSJim Jagielski @Before setUp()41*b1cdbd2cSJim Jagielski public void setUp() throws Exception { 42*b1cdbd2cSJim Jagielski app.start(); 43*b1cdbd2cSJim Jagielski AppTool.newSpreadsheet(); 44*b1cdbd2cSJim Jagielski } 45*b1cdbd2cSJim Jagielski 46*b1cdbd2cSJim Jagielski @After tearDown()47*b1cdbd2cSJim Jagielski public void tearDown() throws Exception { 48*b1cdbd2cSJim Jagielski app.stop(); 49*b1cdbd2cSJim Jagielski } 50*b1cdbd2cSJim Jagielski 51*b1cdbd2cSJim Jagielski /** 52*b1cdbd2cSJim Jagielski * Insert new entire row and column 53*b1cdbd2cSJim Jagielski * 54*b1cdbd2cSJim Jagielski * @throws Exception 55*b1cdbd2cSJim Jagielski */ 56*b1cdbd2cSJim Jagielski 57*b1cdbd2cSJim Jagielski @Test testInsertEntireRowColumn()58*b1cdbd2cSJim Jagielski public void testInsertEntireRowColumn() { 59*b1cdbd2cSJim Jagielski 60*b1cdbd2cSJim Jagielski // insert data in cell A2 and B2 61*b1cdbd2cSJim Jagielski SCTool.selectRange("Sheet1.A2"); 62*b1cdbd2cSJim Jagielski typeKeys("123"); 63*b1cdbd2cSJim Jagielski SCTool.selectRange("Sheet1.B2"); 64*b1cdbd2cSJim Jagielski typeKeys("456"); 65*b1cdbd2cSJim Jagielski 66*b1cdbd2cSJim Jagielski // Set expected result after executing insert one row 67*b1cdbd2cSJim Jagielski String[][] expectedInsertRowResult = new String[][] { { "", "" }, { "", "" }, { "123", "456" }, }; 68*b1cdbd2cSJim Jagielski 69*b1cdbd2cSJim Jagielski // Select Cell A2 70*b1cdbd2cSJim Jagielski SCTool.selectRange("Sheet1.A2"); 71*b1cdbd2cSJim Jagielski 72*b1cdbd2cSJim Jagielski // Insert one entire Row via menu 73*b1cdbd2cSJim Jagielski calc.menuItem("Insert->Rows").select(); 74*b1cdbd2cSJim Jagielski 75*b1cdbd2cSJim Jagielski // Verify results after inserting one row 76*b1cdbd2cSJim Jagielski assertArrayEquals("Verify results after inserting one row", expectedInsertRowResult, SCTool.getCellTexts("A1:B3")); 77*b1cdbd2cSJim Jagielski 78*b1cdbd2cSJim Jagielski // Set expected result after executing insert column 79*b1cdbd2cSJim Jagielski String[][] expectedInsertColumnResult = new String[][] { { "", "", "" }, { "", "", "" }, { "", "123", "456" }, }; 80*b1cdbd2cSJim Jagielski // Select Cell A3 81*b1cdbd2cSJim Jagielski SCTool.selectRange("Sheet1.A3"); 82*b1cdbd2cSJim Jagielski // Insert one entire Column via menu 83*b1cdbd2cSJim Jagielski calc.menuItem("Insert->Columns").select(); 84*b1cdbd2cSJim Jagielski 85*b1cdbd2cSJim Jagielski // Verify results after inserting one column 86*b1cdbd2cSJim Jagielski assertArrayEquals("Verify results after inserting one column", expectedInsertColumnResult, SCTool.getCellTexts("A1:C3")); 87*b1cdbd2cSJim Jagielski 88*b1cdbd2cSJim Jagielski } 89*b1cdbd2cSJim Jagielski 90*b1cdbd2cSJim Jagielski } 91