xref: /aoo41x/test/testgui/source/fvt/gui/sc/sheet/Sheets.java (revision fd348426)

/**************************************************************
 *
 * 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.sheet;

import static org.junit.Assert.*;
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;

/**
 * Before running the testing class, you need specify the AOO location firstly
 * with system property openoffice.home.
 *
 *
 */

public class Sheets {

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

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

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

	/**
	 * Insert one sheet in different place
	 *
	 * @throws Exception
	 */
	@Test
	public void testInsertMultipleSheet() {
		// Open Insert Sheet dialog via main menu Insert-> Sheet
		app.dispatch(".uno:Insert");
		// Change new sheet number into 3 to insert 3 new sheet one time
		scSheetNumber.setText("3");
		// Click OK button to create sheet with default setting
		scInsertSheetDlg.ok();
		// Verify new sheets have been inserted before Sheet1
		app.dispatch(".uno:SelectTables");
		// To support multi-language, just verify the number in the sheet name
		assertTrue("The first sheet name not contain 4",scSheetsList.getItemsText()[0].contains("4"));
		assertTrue("The second sheet name not contain 5",scSheetsList.getItemsText()[1].contains("5"));
		assertTrue("The third sheet name not contain 6",scSheetsList.getItemsText()[2].contains("6"));
		assertTrue("The fourth sheet name not contain 1",scSheetsList.getItemsText()[3].contains("1"));
		assertTrue("The fifth sheet name not contain 2",scSheetsList.getItemsText()[4].contains("2"));
		assertTrue("The sixth sheet name not contain 3",scSheetsList.getItemsText()[5].contains("3"));
		scSelectSheetsDlg.ok();
	}

	/**
	 * Insert one sheet in different place
	 *
	 * @throws Exception
	 */
	@Test
	public void testInsertOneSheet() {
		// Open Insert Sheet dialog via main menu Insert-> Sheet
		app.dispatch(".uno:Insert");
		// Click OK button to create sheet with default setting
		scInsertSheetDlg.ok();
		// Verify new sheet has been inserted before Sheet1
		app.dispatch(".uno:SelectTables");
		// To support multi-language, just verify the number in the sheet name
		assertTrue(scSheetsList.getItemsText()[0].contains("4"));
		assertTrue(scSheetsList.getItemsText()[1].contains("1"));
		assertTrue(scSheetsList.getItemsText()[2].contains("2"));
		assertTrue(scSheetsList.getItemsText()[3].contains("3"));
		scSelectSheetsDlg.ok();
	}
}