Attachment #78704 for issue #120321

View | Details | Raw Unified | Return to issue 120321
Collapse All | Expand All




/**************************************************************
 * 
 * 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 testcase.sc.validity;

import static testlib.AppUtil.submitOpenDlg;
import static testlib.AppUtil.testFile;
import static testlib.AppUtil.typeKeys;
import static testlib.UIMap.*;
import static org.junit.Assert.*;
import static org.openoffice.test.vcl.Tester.typeKeys;
import org.junit.After;
import org.junit.Before;
import org.junit.Rule;
import org.junit.Test;
import testlib.CalcUtil;
import testlib.Log;

public class ValiditySampleFile {

	@Rule
	public Log LOG = new Log();

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

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

	/**
	 * Test open MS 2003 spreadsheet with ignore blank validity.
	 * 
	 * @throws Exception
	 */
	@Test
	public void testFFCIgnoreBlank() throws Exception{
		// Open sample file
		String file = testFile("sc/FFC252FFCSC_XML_Datarange0235.xls");
		app.dispatch(".uno:Open", 3);
		submitOpenDlg(file);
		calc.waitForExistence(10, 2);

		CalcUtil.selectRange("D5");
		SC_InputBar_Input.activate();
		for(int i=1;i<=10;i++)
			typeKeys("<backspace>");
		typeKeys("<enter>");

		assertEquals("",CalcUtil.getCellText("D5"));
	}

	/**
	 * Test open MS 2003 spreadsheet with ignore blank validity.
	 * 
	 * @throws Exception
	 */
	@Test
	public void testFFCNotIgnoreBlank() throws Exception{
		//open sample file
		String file = testFile("sc/FFC252FFCSC_XML_Datarange0205.xls");
		app.dispatch(".uno:Open", 3);
		submitOpenDlg(file);
		calc.waitForExistence(10, 2);

		CalcUtil.selectRange("F5");
		SC_InputBar_Input.activate();
		typeKeys("<backspace><enter>");

		assertEquals("Invalid value.",ActiveMsgBox.getMessage());
		ActiveMsgBox.ok();
		assertEquals("8",CalcUtil.getCellText("F5"));
	}

	/**
	 * test Cell is not locked after switch from validity cell to source cells
	 */
	@Test
	public void testNotLockCellFromValidityCell() {
		//open sample file on data path
		String file = testFile("sc/sampledata.ods");
		app.dispatch(".uno:Open", 3);
		submitOpenDlg(file);
		calc.waitForExistence(10, 2);

		CalcUtil.selectRange("Sheet1.F19");
		typeKeys("d<enter>");
		CalcUtil.selectRange("Sheet1.F17");
		typeKeys("Test<enter>");

		assertEquals("Test",CalcUtil.getCellText("F17"));
	}
}




/**************************************************************
 * 
 * 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 testcase.sc.validity;

import static testlib.AppUtil.*;
import static testlib.UIMap.*;

import java.io.File;

import org.junit.After;
import static org.junit.Assert.*;
import static org.openoffice.test.vcl.Tester.*;

import org.junit.Before;
import org.junit.Rule;
import org.junit.Ignore;
import org.junit.Test;
import org.openoffice.test.vcl.IDList;
import org.openoffice.test.vcl.widgets.VclMessageBox;

import testlib.CalcUtil;
import testlib.Log;


public class ValidityDialogSetting {
	private static IDList idList = new IDList(new File("./ids"));
	public static final VclMessageBox ActiveMsgBox = new VclMessageBox(idList.getId("UID_ACTIVE"), "Message on message box.");

	@Rule
	public Log LOG = new Log();

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

		// New a spreadsheet, select cell range, open Validity dialog
		startcenter.menuItem("File->New->Spreadsheet").select();
		CalcUtil.selectRange("Sheet1.A1:C5");
		calc.menuItem("Data->Validity...").select();
	}

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

	/**
	 * test Allow not between Date type in Validity.
	 */
	@Test
	public void testAllowDateNotBetween() {
		SC_ValidityCriteriaTabpage.select();
		SC_ValidityCriteriaAllowList.select("Date");
		SC_ValidityDecimalCompareOperator.select("not between");
		SC_ValiditySourceInput.setText("01/01/08");
		SC_ValidityMaxValueInput.setText("03/01/08");
		SC_ValidityErrorAlertTabPage.select();
		SC_ValidityShowErrorMessage.check();
		SC_ValidityErrorMessageTitle.setText("Stop to enter");
		SC_ValidityErrorMessage.setText("Invalid value");
		SC_ValidityErrorAlertTabPage.ok();

		CalcUtil.selectRange("Sheet1.A1");
		SC_InputBar_Input.activate();
		typeKeys("12/31/07");
		typeKeys("<enter>");
		assertEquals("12/31/07",CalcUtil.getCellText("Sheet1.A1"));

		CalcUtil.selectRange("Sheet1.A2");
		SC_InputBar_Input.activate();
		typeKeys("03/02/08");
		typeKeys("<enter>");
		assertEquals("03/02/08",CalcUtil.getCellText("Sheet1.A2"));

		CalcUtil.selectRange("Sheet1.A3");
		SC_InputBar_Input.activate();
		typeKeys("01/01/08");
		typeKeys("<enter>");
		assertEquals("Invalid value",ActiveMsgBox.getMessage());
		ActiveMsgBox.ok();
		assertEquals("",CalcUtil.getCellText("Sheet1.A3"));

		CalcUtil.selectRange("Sheet1.A4");
		SC_InputBar_Input.activate();
		typeKeys("03/01/08");
		typeKeys("<enter>");
		assertEquals("Invalid value",ActiveMsgBox.getMessage());
		ActiveMsgBox.ok();
		assertEquals("",CalcUtil.getCellText("Sheet1.A4"));

		CalcUtil.selectRange("Sheet1.A5");
		SC_InputBar_Input.activate();
		typeKeys("01/02/08");
		typeKeys("<enter>");
		assertEquals("Invalid value",ActiveMsgBox.getMessage());
		ActiveMsgBox.ok();
		assertEquals("",CalcUtil.getCellText("Sheet1.A5"));

		CalcUtil.selectRange("Sheet1.B1");
		SC_InputBar_Input.activate();
		typeKeys("02/29/08");
		typeKeys("<enter>");
		assertEquals("Invalid value",ActiveMsgBox.getMessage());
		ActiveMsgBox.ok();
		assertEquals("",CalcUtil.getCellText("Sheet1.B1"));

		CalcUtil.selectRange("Sheet1.B2");
		SC_InputBar_Input.activate();
		typeKeys("test");
		typeKeys("<enter>");
		assertEquals("Invalid value",ActiveMsgBox.getMessage());
		ActiveMsgBox.ok();
		assertEquals("",CalcUtil.getCellText("Sheet1.B2"));

		CalcUtil.selectRange("Sheet1.B3");
		SC_InputBar_Input.activate();
		typeKeys("39448");
		typeKeys("<enter>");
		assertEquals("Invalid value",ActiveMsgBox.getMessage());
		ActiveMsgBox.ok();
		assertEquals("",CalcUtil.getCellText("Sheet1.B3"));
	}

	/**
	 * test Allow Decimal equal in Validity.
	 */
	@Test
	public void testAllowDecimalEqual() {

		SC_ValidityCriteriaTabpage.select();
		SC_ValidityCriteriaAllowList.select("Decimal");
		SC_ValidityDecimalCompareOperator.select("equal");
		SC_ValiditySourceInput.setText("0.33333333");
		SC_ValidityErrorAlertTabPage.select();
		SC_ValidityShowErrorMessage.check();
		SC_ValidityErrorMessageTitle.setText("Stop to enter");
		SC_ValidityErrorMessage.setText("Invalid value");
		SC_ValidityErrorAlertTabPage.ok();

		CalcUtil.selectRange("Sheet1.A1");
		SC_InputBar_Input.activate();
		typeKeys("0.33333333");
		typeKeys("<enter>");
		assertEquals("0.33333333",CalcUtil.getCellText("Sheet1.A1"));

		CalcUtil.selectRange("Sheet1.A2");
		SC_InputBar_Input.activate();
		typeKeys("=1/3");
		typeKeys("<enter>");
		assertEquals("Invalid value",ActiveMsgBox.getMessage());
		ActiveMsgBox.ok();
		assertEquals("",CalcUtil.getCellText("Sheet1.A2"));

		CalcUtil.selectRange("Sheet1.A3");
		SC_InputBar_Input.activate();
		typeKeys("0.3");
		typeKeys("<enter>");
		assertEquals("Invalid value",ActiveMsgBox.getMessage());
		ActiveMsgBox.ok();
		assertEquals("",CalcUtil.getCellText("Sheet1.A3"));

		CalcUtil.selectRange("Sheet1.A4");
		SC_InputBar_Input.activate();
		typeKeys("0.333333333");
		typeKeys("<enter>");
		assertEquals("Invalid value",ActiveMsgBox.getMessage());
		ActiveMsgBox.ok();
		assertEquals("",CalcUtil.getCellText("Sheet1.A4"));

		CalcUtil.selectRange("Sheet1.B2");
		SC_InputBar_Input.activate();
		typeKeys("test");
		typeKeys("<enter>");
		assertEquals("Invalid value",ActiveMsgBox.getMessage());
		ActiveMsgBox.ok();
		assertEquals("",CalcUtil.getCellText("Sheet1.B2"));
	}

	/**
	 * test Allow Text length,  greater than or equal to  in Validity.
	 */
	@Test
	public void testAllowGreaterTextLength() {

		SC_ValidityCriteriaTabpage.select();
		SC_ValidityCriteriaAllowList.select("Text length");
		SC_ValidityDecimalCompareOperator.select("greater than or equal to");
		SC_ValiditySourceInput.setText("10");
		SC_ValidityErrorAlertTabPage.select();
		SC_ValidityShowErrorMessage.check();
		SC_ValidityErrorMessageTitle.setText("Stop to enter");
		SC_ValidityErrorMessage.setText("Invalid value");
		SC_ValidityErrorAlertTabPage.ok();

		CalcUtil.selectRange("Sheet1.A1");
		SC_InputBar_Input.activate();
		typeKeys("testtesttesttest");
		typeKeys("<enter>");
		assertEquals("testtesttesttest",CalcUtil.getCellText("Sheet1.A1"));

		CalcUtil.selectRange("Sheet1.A2");
		SC_InputBar_Input.activate();
		typeKeys("test test ");
		typeKeys("<enter>");
		assertEquals("test test ",CalcUtil.getCellText("Sheet1.A2"));

		CalcUtil.selectRange("Sheet1.A4");
		SC_InputBar_Input.activate();
		typeKeys(" ");
		typeKeys("<enter>");
		assertEquals("Invalid value",ActiveMsgBox.getMessage());
		ActiveMsgBox.ok();
		assertEquals("",CalcUtil.getCellText("Sheet1.A4"));

		CalcUtil.selectRange("Sheet1.A3");
		SC_InputBar_Input.activate();
		typeKeys("Testatest");
		typeKeys("<enter>");
		assertEquals("Invalid value",ActiveMsgBox.getMessage());
		ActiveMsgBox.ok();
		assertEquals("",CalcUtil.getCellText("Sheet1.A3"));
	}

	/**
	 * test Allow Text length,  less than  in Validity.
	 */
	@Ignore("Bug 93128")
	public void testAllowLessThanTextLength() {

		calc.menuItem("Data->Validity...").select();

		SC_ValidityCriteriaTabpage.select();
		SC_ValidityCriteriaAllowList.select("Text length");
		SC_ValidityDecimalCompareOperator.select("less than");
		SC_ValiditySourceInput.setText("10");

		SC_ValidityInputHelpTabPage.select();
		SC_ValidityInputHelpCheckbox.check();
		SC_ValidityInputHelpTitle.setText("Help Info Title");
		SC_ValidityHelpMessage.setText("help info");

		SC_ValidityErrorAlertTabPage.select();
		SC_ValidityShowErrorMessage.check();
		SC_ValidityErrorAlertActionList.select("Information");
		SC_ValidityErrorMessageTitle.setText("Notes to enter");
		SC_ValidityErrorMessage.setText("Invalid value");
		SC_ValidityErrorAlertTabPage.ok();

		CalcUtil.selectRange("Sheet1.A1");
		SC_InputBar_Input.activate();
		typeKeys("testtesttesttest<enter>");
		ActiveMsgBox.ok();
		assertEquals("testtesttesttest",CalcUtil.getCellText("Sheet1.A1"));

		CalcUtil.selectRange("Sheet1.A2");
		SC_InputBar_Input.activate();
		typeKeys("sfsafsddddddd<enter>");
		ActiveMsgBox.cancel();
		assertEquals("",CalcUtil.getCellText("Sheet1.A2"));

		CalcUtil.selectRange("Sheet1.A2");
		SC_InputBar_Input.activate();
		typeKeys("10<enter>");
		assertEquals("10",CalcUtil.getCellText("Sheet1.A2"));

		CalcUtil.selectRange("Sheet1.A3");
		SC_InputBar_Input.activate();
		typeKeys("ok<enter>");
		assertEquals("ok",CalcUtil.getCellText("Sheet1.A3"));
	}

	/**
	 * test Allow list.
	 */
	@Test
	public void testAllowListSpecialChar() {

		SC_ValidityCriteriaTabpage.select();
		SC_ValidityCriteriaAllowList.select("List");
		SC_ValidityEntries.focus();
		typeKeys("a");
		typeKeys("<enter>");
		typeKeys("b");
		SC_ValidityErrorAlertTabPage.select();
		SC_ValidityShowErrorMessage.check();
		SC_ValidityErrorMessageTitle.setText("Stop to enter");
		SC_ValidityErrorMessage.setText("Invalid value");
		SC_ValidityCriteriaTabpage.select();
		SC_ValidityCriteriaTabpage.ok();

		calc.rightClick(1, 1);
		typeKeys("<shift s>");
		typeKeys("<down><enter>");	// Choose a
		assertEquals("a",CalcUtil.getCellText("Sheet1.A1"));

		CalcUtil.selectRange("Sheet1.B2");
		SC_InputBar_Input.activate();
		typeKeys("test");
		typeKeys("<enter>");
		assertEquals("Invalid value",ActiveMsgBox.getMessage());
		ActiveMsgBox.ok();
		assertEquals("",CalcUtil.getCellText("Sheet1.B2"));
	}

	/**
	 * test Allow time between  in Validity.
	 */
	@Test
	public void testAllowTimeBetween() {

		SC_ValidityCriteriaTabpage.select();
		SC_ValidityCriteriaAllowList.select("Time");
		SC_ValidityDecimalCompareOperator.select("between");
		SC_ValiditySourceInput.setText("27:00");
		SC_ValidityMaxValueInput.setText("21:00");
		SC_ValidityErrorAlertTabPage.select();
		SC_ValidityShowErrorMessage.check();
		SC_ValidityErrorMessageTitle.setText("Stop to enter");
		SC_ValidityErrorMessage.setText("Invalid value");
		SC_ValidityErrorAlertTabPage.ok();

		CalcUtil.selectRange("Sheet1.A1");
		SC_InputBar_Input.activate();
		typeKeys("21:00");
		typeKeys("<enter>");
		assertEquals("09:00:00 PM",CalcUtil.getCellText("Sheet1.A1"));

		CalcUtil.selectRange("Sheet1.A2");
		SC_InputBar_Input.activate();
		typeKeys("27:00");
		typeKeys("<enter>");
		assertEquals("27:00:00",CalcUtil.getCellText("Sheet1.A2"));

		CalcUtil.selectRange("Sheet1.A3");
		SC_InputBar_Input.activate();
		typeKeys("1.125");
		typeKeys("<enter>");
		assertEquals("1.125",CalcUtil.getCellText("Sheet1.A3"));

		CalcUtil.selectRange("Sheet1.A4");
		SC_InputBar_Input.activate();
		typeKeys("0.875");
		typeKeys("<enter>");
		assertEquals("0.875",CalcUtil.getCellText("Sheet1.A4"));

		CalcUtil.selectRange("Sheet1.B1");
		SC_InputBar_Input.activate();
		typeKeys("03:00:01");
		typeKeys("<enter>");
		assertEquals("Invalid value",ActiveMsgBox.getMessage());
		ActiveMsgBox.ok();
		assertEquals("",CalcUtil.getCellText("Sheet1.B1"));

		CalcUtil.selectRange("Sheet1.B2");
		SC_InputBar_Input.activate();
		typeKeys("20:59:59");
		typeKeys("<enter>");
		assertEquals("Invalid value",ActiveMsgBox.getMessage());
		ActiveMsgBox.ok();
		assertEquals("",CalcUtil.getCellText("Sheet1.B2"));

		CalcUtil.selectRange("Sheet1.B3");
		SC_InputBar_Input.activate();
		typeKeys("1.126");
		typeKeys("<enter>");
		assertEquals("Invalid value",ActiveMsgBox.getMessage());
		ActiveMsgBox.ok();
		assertEquals("",CalcUtil.getCellText("Sheet1.B3"));

		CalcUtil.selectRange("Sheet1.B4");
		SC_InputBar_Input.activate();
		typeKeys("0.874");
		typeKeys("<enter>");
		assertEquals("Invalid value",ActiveMsgBox.getMessage());
		ActiveMsgBox.ok();
		assertEquals("",CalcUtil.getCellText("Sheet1.B4"));

		CalcUtil.selectRange("Sheet1.C1");
		SC_InputBar_Input.activate();
		typeKeys("test");
		typeKeys("<enter>");
		assertEquals("Invalid value",ActiveMsgBox.getMessage());
		ActiveMsgBox.ok();
		assertEquals("",CalcUtil.getCellText("Sheet1.C1"));

		CalcUtil.selectRange("Sheet1.C2");
		SC_InputBar_Input.activate();
		typeKeys("24:00");
		typeKeys("<enter>");
		assertEquals("24:00:00",CalcUtil.getCellText("Sheet1.C2"));

		CalcUtil.selectRange("Sheet1.C3");
		SC_InputBar_Input.activate();
		typeKeys("12:00");
		typeKeys("<enter>");
		assertEquals("Invalid value",ActiveMsgBox.getMessage());
		ActiveMsgBox.ok();
		assertEquals("",CalcUtil.getCellText("Sheet1.C3"));
	}

	/**
	 * test Allow time Greater than and equal to  in Validity.
	 */
	@Test
	public void testAllowTimeGreaterThan() {

		SC_ValidityCriteriaTabpage.select();
		SC_ValidityCriteriaAllowList.select("Time");
		SC_ValidityDecimalCompareOperator.select("greater than or equal to");
		SC_ValiditySourceInput.setText("8:00");

		SC_ValidityErrorAlertTabPage.select();
		SC_ValidityShowErrorMessage.check();
		SC_ValidityErrorAlertActionList.select("Warning");

		SC_ValidityErrorMessageTitle.setText("warning to enter");
		SC_ValidityErrorMessage.setText("Invalid value");
		SC_ValidityErrorAlertTabPage.ok();

		CalcUtil.selectRange("Sheet1.A1");
		SC_InputBar_Input.activate();
		typeKeys("7:30");
		typeKeys("<enter>");
		assertEquals("Invalid value",ActiveMsgBox.getMessage());
		ActiveMsgBox.ok();
		assertEquals("07:30:00 AM",CalcUtil.getCellText("Sheet1.A1"));

		CalcUtil.selectRange("Sheet1.A2");
		SC_InputBar_Input.activate();
		typeKeys("6:00");
		typeKeys("<enter>");
		assertEquals("Invalid value",ActiveMsgBox.getMessage());
		ActiveMsgBox.cancel();
		assertEquals("",CalcUtil.getCellText("Sheet1.A2"));

		CalcUtil.selectRange("Sheet1.A3");
		SC_InputBar_Input.activate();
		typeKeys("8:00");
		typeKeys("<enter>");
		assertEquals("08:00:00 AM",CalcUtil.getCellText("Sheet1.A3"));
	}

	/**
	 * test Allow whole number, less than or equal to in Validity.
	 */
	@Test
	public void testAllowWholeNumLessThan() {

		SC_ValidityCriteriaTabpage.select();
		SC_ValidityCriteriaAllowList.select("Whole Numbers");
		SC_ValidityDecimalCompareOperator.select("less than or equal");
		SC_ValiditySourceInput.setText("100");
		SC_ValidityErrorAlertTabPage.select();
		SC_ValidityShowErrorMessage.check();
		SC_ValidityErrorMessageTitle.setText("Stop to enter");
		SC_ValidityErrorMessage.setText("Invalid value");
		SC_ValidityErrorAlertTabPage.ok();

		CalcUtil.selectRange("Sheet1.A1");
		SC_InputBar_Input.activate();
		typeKeys("99");
		typeKeys("<enter>");
		assertEquals("99",CalcUtil.getCellText("Sheet1.A1"));

		CalcUtil.selectRange("Sheet1.A2");
		SC_InputBar_Input.activate();
		typeKeys("100");
		typeKeys("<enter>");
		assertEquals("100",CalcUtil.getCellText("Sheet1.A2"));

		CalcUtil.selectRange("Sheet1.B1");
		SC_InputBar_Input.activate();
		typeKeys("101");
		typeKeys("<enter>");
		assertEquals("Invalid value",ActiveMsgBox.getMessage());
		ActiveMsgBox.ok();
		assertEquals("",CalcUtil.getCellText("Sheet1.B1"));

		CalcUtil.selectRange("Sheet1.B2");
		SC_InputBar_Input.activate();
		typeKeys("45.5");
		typeKeys("<enter>");
		assertEquals("Invalid value",ActiveMsgBox.getMessage());
		ActiveMsgBox.ok();
		assertEquals("",CalcUtil.getCellText("Sheet1.B2"));

		CalcUtil.selectRange("Sheet1.C1");
		SC_InputBar_Input.activate();
		typeKeys("test");
		typeKeys("<enter>");
		assertEquals("Invalid value",ActiveMsgBox.getMessage());
		ActiveMsgBox.ok();
		assertEquals("",CalcUtil.getCellText("Sheet1.C1"));
	}

	/**
	 * test default message of Error Alert in Validity.
	 */
	@Test
	public void testDefaultErrorAlertMessage() {

		SC_ValidityCriteriaTabpage.select();
		SC_ValidityCriteriaAllowList.select("Decimal");
		SC_ValidityDecimalCompareOperator.select("equal");
		SC_ValiditySourceInput.setText("1");

		SC_ValidityErrorAlertTabPage.select();
		SC_ValidityShowErrorMessage.check();
		SC_ValidityErrorAlertActionList.select("Stop");
		SC_ValidityErrorAlertTabPage.ok();

		CalcUtil.selectRange("Sheet1.A1");
		SC_InputBar_Input.activate();
		typeKeys("13");
		typeKeys("<enter>");
		assertEquals("OpenOffice.org Calc",ActiveMsgBox.getCaption());
		assertEquals("Invalid value.",ActiveMsgBox.getMessage());
		ActiveMsgBox.ok();
		assertEquals("",CalcUtil.getCellText("Sheet1.A1"));
	}

	/**
	 * test uncheck Error Alert in Validity.
	 */
	@Test
	public void testUncheckErrorAlert() {

		SC_ValidityCriteriaTabpage.select();
		SC_ValidityCriteriaAllowList.select("Decimal");
		SC_ValidityDecimalCompareOperator.select("equal");
		SC_ValiditySourceInput.setText("1");

		SC_ValidityErrorAlertTabPage.select();
		SC_ValidityShowErrorMessage.uncheck();
		SC_ValidityErrorAlertActionList.select("Stop");
		SC_ValidityErrorAlertTabPage.ok();

		CalcUtil.selectRange("Sheet1.A1");
		SC_InputBar_Input.activate();
		typeKeys("13");
		typeKeys("<enter>");
		assertEquals("13",CalcUtil.getCellText("Sheet1.A1"));
	}

	/**
	 * test Cell range source picker in Validity. Input from Edit Box.
	 */
	@Test
	public void testValidityCellRangeSourcePicker() {

		SC_ValidityCriteriaTabpage.select();
		SC_ValidityCriteriaAllowList.select("Cell range");
		SC_ValiditySourcePicker.click();
		assertEquals(false,SC_ValidityCriteriaAllowList.exists());
		SC_ValiditySourceInput.setText("$Sheet1.$E$2:$G$5");
		SC_ValiditySourcePicker.click();
		assertEquals(true,SC_ValidityCriteriaAllowList.exists());

		SC_ValidityErrorAlertTabPage.select();
		SC_ValidityShowErrorMessage.check();
		SC_ValidityErrorAlertActionList.select("Stop");
		SC_ValidityErrorAlertTabPage.ok();

		// calc.focus();
		CalcUtil.selectRange("Sheet1.E2");
		SC_InputBar_Input.activate();
		typeKeys("test");
		typeKeys("<enter>");

		CalcUtil.selectRange("Sheet1.A1");
		SC_InputBar_Input.activate();
		typeKeys("test32");
		typeKeys("<enter>");
		assertEquals("Invalid value.",ActiveMsgBox.getMessage());
		ActiveMsgBox.ok();
		assertEquals("",CalcUtil.getCellText("Sheet1.A1"));		

		CalcUtil.selectRange("Sheet1.B1");
		SC_InputBar_Input.activate();
		typeKeys("test");
		typeKeys("<enter>");
		assertEquals("test",CalcUtil.getCellText("Sheet1.B1"));
	}

	/**
	 * test Allow Blank cell Checkbox in Validity.
	 */
	@Test
	public void testAllowBlankCells() {
		SC_ValidityCriteriaTabpage.select();
		SC_ValidityCriteriaAllowList.select("Cell range");
		SC_ValiditySourceInput.setText("$E$1:$E$5");
		SC_ValidityAllowBlankCells.check();
		SC_ValidityCriteriaTabpage.ok();

		CalcUtil.selectRange("Sheet1.E1");
		typeKeys("A<enter>A<enter>A<enter>A<enter>A<enter>");

		CalcUtil.selectRange("Sheet1.A1");
		typeKeys("A<enter>");
		CalcUtil.selectRange("Sheet1.D1");
		SC_InputBar_Input.activate();
		typeKeys("<backspace><enter>");
		assertEquals("",CalcUtil.getCellText("Sheet1.D1"));

		CalcUtil.selectRange("Sheet1.B1");
		calc.menuItem("Data->Validity...").select();
		SC_ValidityCriteriaTabpage.select();
		SC_ValidityAllowBlankCells.uncheck();
		typeKeys("<enter>");

		CalcUtil.selectRange("Sheet1.B1");
		SC_InputBar_Input.activate();
		typeKeys("<backspace><enter>");
		typeKeys("<enter>");
	}
}





/**************************************************************
 * 
 * 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 testcase.sc.chart;

import static testlib.UIMap.*;
import org.junit.After;
import static org.junit.Assert.*;
import org.junit.Before;
import org.junit.Rule;
import org.junit.Test;
import testlib.Log;

/**
 * Test the setting about chart dialog in spreadsheet
 */
public class ChartDialogSetting {

	@Rule
	public Log LOG = new Log();

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

		// Create a new spreadsheet document
		startcenter.menuItem("File->New->Spreadsheet").select();
	}

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

	/**
	 * Test cancel and back button in chart wizard dialog
	 * 
	 * @throws java.lang.Exception
	 */
	@Test
	public void testChartDialogCancelBack() {
		calc.menuItem("Insert->Chart...").select();
		WizardNextButton.click();
		assertTrue(ChartRangeChooseTabPage.isEnabled());
		WizardBackButton.click();
		assertTrue(ChartTypeChooseTabPage.isEnabled());
		Chart_Wizard.cancel();
		assertFalse(Chart_Wizard.exists());
	}

	/**
	 * Verify Chart Wizard dialog title words
	 */
	@Test
	public void testChartWizardTitle() {
		calc.menuItem("Insert->Chart...").select();
		assertEquals("Chart Wizard",Chart_Wizard.getText());
		Chart_Wizard.cancel();
	}
}




/**************************************************************
 * 
 * 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 testcase.sw.table;

import static testlib.AppUtil.*;
import static testlib.UIMap.*;
import static org.junit.Assert.*;
import org.junit.After;
import org.junit.Before;
import org.junit.Rule;
import org.junit.Test;
import org.openoffice.test.common.SystemUtil;

import testlib.Log;

/**
 *
 */
public class Table {

	@Rule
	public Log LOG = new Log();

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

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

	/**
	 * Test convert table to text in text document
	 * @throws Exception
	 */
	@Test
	public void testConvertTableToText() throws Exception{

		//Create a new text document
		startcenter.menuItem("File->New->Text Document").select();
		sleep(3);

		// Insert a table and input some data
		writer.menuItem("Insert->Table...").select();
		writer_InsertTable.ok();
		writer.focus();
		typeKeys("1<right>2<right>3<right>4");
		sleep(1);

		// Convert table to text
		writer.menuItem("Table->Convert->Table to Text...").select();
		assertTrue("Convert Table to Text dialog pop up", writer_ConvertTableToTextDlg.exists());
		typeKeys("<enter>");
		sleep(1);

		// Verify if text is converted successfully
		writer.menuItem("Edit->Select All").select();
		app.dispatch(".uno:Copy");
		if (SystemUtil.isWindows())
			assertEquals("Converted text", "1\t2\r\n3\t4\r\n", app.getClipboard());	// windows�лس�������\r\n
		else
			assertEquals("Converted text", "1\t2\n3\t4\n", app.getClipboard());
	}
}




/**************************************************************
 * 
 * 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 testcase.sd.headerandfooter;

import static testlib.AppUtil.fullPath;
import static testlib.AppUtil.openStartcenter;
import static testlib.AppUtil.submitSaveDlg;
import static testlib.AppUtil.submitOpenDlg;
import static testlib.AppUtil.testFile;
import static testlib.UIMap.*;
import static org.junit.Assert.*;
import static org.openoffice.test.vcl.Tester.*;
import org.junit.After;
import org.junit.Before;
import org.junit.Rule;
import org.junit.Test;
import org.openoffice.test.common.FileUtil;
import testlib.Log;

public class OpenDocumentWithHeaderFooter {

	@Rule
	public Log LOG = new Log();

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

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

	/**
	 * Test open AOO3.4 presentation with header and footer.
	 * edit and save to ODP
	 * @throws Exception
	 */
	@Test
	public void testOpenAOO34WithHeaderFooter() throws Exception{
		//open sample file
		String file = testFile("sd/AOO3.4HeaderFooter.odp");
		app.dispatch(".uno:Open");
		submitOpenDlg(file);

		//check after reopen		
		impress.menuItem("View->Header and Footer...").select();
		sleep(1);
		assertEquals(true,SD_DateAndTimeFooterOnSlide.isChecked());
		assertEquals("fixed date",SD_FixedDateAndTimeOnSlideInput.getText());
		assertEquals(true,SD_FooterTextOnSlide.isChecked());
		assertEquals("footer test",SD_FooterTextOnSlideInput.getText());
		assertEquals(true,SD_SlideNumAsFooterOnSlide.isChecked());

		SD_SlideNumAsFooterOnSlide.uncheck();
		SD_ApplyToAllButtonOnSlideFooter.click();

		//save to odp and reopen
		impress.menuItem("File->Save As...").select();
		String saveTo2 = fullPath("temp/" + "AOO3.4HeaderFooter.odp");
		FileUtil.deleteFile(saveTo2);
		submitSaveDlg(saveTo2);	
		impress.menuItem("File->Close").select();
		sleep(1);

		openStartcenter();
		app.dispatch(".uno:Open");
		String openFrom2=fullPath("temp/" + "AOO3.4HeaderFooter.odp");
		submitOpenDlg(openFrom2);

		impress.menuItem("View->Header and Footer...").select();
		sleep(1);
		assertEquals(false,SD_SlideNumAsFooterOnSlide.isChecked());
		//end-save to odp and reopen
	}

	/**
	 * Test open ppt file with header and footer.
	 * edit and save to PPT/ODP
	 * @throws Exception
	 */
	@Test
	public void testOpenPPTWithHeaderFooter() throws Exception{
		//open sample file
		String file = testFile("sd/gfdd.ppt");
		app.dispatch(".uno:Open");
		submitOpenDlg(file);

		//check after reopen		
		impress.menuItem("View->Header and Footer...").select();
		sleep(1);
		assertEquals(true,SD_DateAndTimeFooterOnSlide.isChecked());
		assertEquals("testdte",SD_FixedDateAndTimeOnSlideInput.getText());
		assertEquals(true,SD_FooterTextOnSlide.isChecked());
		assertEquals("yesy",SD_FooterTextOnSlideInput.getText());
		assertEquals(true,SD_SlideNumAsFooterOnSlide.isChecked());

		SD_SlideNumAsFooterOnSlide.uncheck();
		SD_ApplyToAllButtonOnSlideFooter.click();

		//save to ppt and reopen
		impress.menuItem("File->Save As...").select();
		String saveTo = fullPath("temp/" + "gfdd.ppt");
		FileUtil.deleteFile(saveTo);
		submitSaveDlg(saveTo);	
		if (AlienFormatDlg.exists(3))
			AlienFormatDlg.ok();
		sleep(1);
		impress.menuItem("File->Close").select();
		sleep(1);

		openStartcenter();
		app.dispatch(".uno:Open");
		String openFrom=fullPath("temp/" + "gfdd.ppt");
		submitOpenDlg(openFrom);

		impress.menuItem("View->Header and Footer...").select();
		sleep(1);
		assertEquals(false,SD_SlideNumAsFooterOnSlide.isChecked());
		//end-save to ppt and reopen

		//close Header and Footer dialog.
		SD_ApplyButtonOnSlideFooter.focus();
		typeKeys("<tab>");
		typeKeys("<enter>");
		//end

		//save to odp and reopen
		impress.menuItem("File->Save As...").select();
		String saveTo2 = fullPath("temp/" + "gfdd.odp");
		FileUtil.deleteFile(saveTo2);
		submitSaveDlg(saveTo2);	
		impress.menuItem("File->Close").select();
		sleep(1);

		openStartcenter();
		app.dispatch(".uno:Open");
		String openFrom2=fullPath("temp/" + "gfdd.odp");
		submitOpenDlg(openFrom2);

		impress.menuItem("View->Header and Footer...").select();
		sleep(1);
		assertEquals(false,SD_SlideNumAsFooterOnSlide.isChecked());
		//end-save to odp and reopen
	}
}




/**************************************************************
 * 
 * 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 testcase.sc.sort;

import static testlib.AppUtil.*;
import static testlib.UIMap.*;
import static org.junit.Assert.*;
import static org.openoffice.test.vcl.Tester.*;
import org.junit.After;
import org.junit.Before;
import org.junit.Ignore;
import org.junit.Rule;
import org.junit.Test;
import org.openoffice.test.common.FileUtil;
import testlib.CalcUtil;
import testlib.Log;

/**
 * Test Data->Sort dialog setting
 */
public class SortDialogSetting {

	@Rule
	public Log LOG = new Log();

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

		// Create a new spreadsheet document
		startcenter.menuItem("File->New->Spreadsheet").select();
	}

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

	/**
	 * Test sort with options setting: case sensitive 
	 * @throws Exception
	 */
	@Test
	public void testSortOptionsCaseSensitive() throws Exception{

		// Input some data: A1~A6: 1ColumnName,D,C,B,A,a
		String[][] data = new String[][] {
				{"D"},
				{"C"},
				{"B"},
				{"A"},
				{"a"},
		};
		String[][] expectedSortedResult = new String[][] {
				{"a"},
				{"A"},
				{"B"},
				{"C"},
				{"D"},
		};
		CalcUtil.selectRange("A1");
		typeKeys("1ColumnName<down>D<down>C<down>B<down>A<down>a<down>");
		CalcUtil.selectRange("A6");
		app.dispatch(".uno:ChangeCaseToLower");	// In case SC capitalize first letter automatically

		// "Data->Sort...", choose "Ascending", check "Case sensitive"
		calc.menuItem("Data->Sort...").select();
		SortOptionsPage.select();
		SortOptionsPage_CaseSensitive.check();
		SortOptionsPage.ok();		

		// Verify sorted result
		assertArrayEquals("Sorted result", expectedSortedResult, CalcUtil.getCellTexts("A2:A6"));

		// Uodo/redo
		calc.menuItem("Edit->Undo: Sort").select();
		assertArrayEquals("Undo sorted result", data, CalcUtil.getCellTexts("A2:A6"));
		calc.menuItem("Edit->Redo: Sort").select();
		assertArrayEquals("Redo sorted result", expectedSortedResult, CalcUtil.getCellTexts("A2:A6"));

		// Save and close document
		String saveTo = fullPath("temp/" + "RowsSortWithOptionsCaseSensitive.ods");
		calc.menuItem("File->Save As...").select();
		FileUtil.deleteFile(saveTo);
		submitSaveDlg(saveTo);	
		calc.menuItem("File->Close").select();
		openStartcenter();

		// Reopen and verify sorted result
		startcenter.menuItem("File->Open...").select();
		submitOpenDlg(saveTo);
		calc.waitForExistence(10, 2);
		assertArrayEquals("Saved sorted result", expectedSortedResult, CalcUtil.getCellTexts("A2:A6"));
	}

	/**
	 * Test sort with options setting: copy sort result to
	 * @throws Exception
	 */
	@Ignore("Bug 119035")
	public void testSortOptionsCopyResultTo() throws Exception{

		// Input some data
		//		String[][] data = new String[][] {
		//				{"3", "D"},
		//				{"5", "FLK"},
		//				{"4", "E"},
		//				{"2", "BC"},
		//				{"6", "GE"},
		//				{"1", "AB"},
		//		};
		String[][] expectedSortedResult = new String[][] {
				{"1", "AB"},
				{"2", "BC"},
				{"3", "D"},
				{"4", "E"},
				{"5", "FLK"},
				{"6", "GE"},
		};
		CalcUtil.selectRange("A1");
		typeKeys("3<down>5<down>4<down>2<down>6<down>1");
		CalcUtil.selectRange("B1");
		typeKeys("D<down>FLK<down>E<down>BC<down>GE<down>AB");

		// Data->Sort..., choose "Ascending", check "Copy sort results to:"
		calc.menuItem("Data->Sort...").select();
		SortOptionsPage.select();
		SortOptionsPage_CopyResultTo.check();
		SortOptionsPage_CopyResultToEdit.setText("$Sheet3.$A4");
		SortOptionsPage.ok();

		// Verify sorted result
		assertArrayEquals("Copy sorted result to", expectedSortedResult, CalcUtil.getCellTexts("$Sheet3.$A4:$B9"));

		// Uodo/redo
		calc.menuItem("Edit->Undo: Sort").select();
		assertEquals("Undo sorted result", "", CalcUtil.getCellText("$Sheet3.$A4"));
		calc.menuItem("Edit->Redo: Sort").select();
		assertArrayEquals("Redo sorted result", expectedSortedResult, CalcUtil.getCellTexts("$Sheet3.$A4:$B9"));

		// Move focus to sheet2 then select a cell range, Insert->Names->Define...
		CalcUtil.selectRange("$Sheet2.$A1:$B3");
		calc.menuItem("Insert->Names->Define...").select();
		DefineNamesDlg_NameEdit.setText("cellRange");
		DefineNamesDlg.ok();

		// Set focus to the original data, Data->Sort...
		CalcUtil.selectRange("$Sheet1.$B1");
		calc.menuItem("Data->Sort...").select();
		SortOptionsPage.select();
		SortOptionsPage_CopyResultTo.check();
		SortOptionsPage_CopyResultToCellRange.select("cellRange");
		SortOptionsPage.ok();		

		// Verify sorted result
		assertArrayEquals("Copy sorted result to cell range", expectedSortedResult, CalcUtil.getCellTexts("$Sheet2.$A1:$B6"));

		// Uodo/redo
		calc.menuItem("Edit->Undo: Sort").select();
		assertEquals("Undo sorted result", "", CalcUtil.getCellText("$Sheet2.$A1"));
		calc.menuItem("Edit->Redo: Sort").select();
		assertArrayEquals("Redo sorted result", expectedSortedResult, CalcUtil.getCellTexts("$Sheet2.$A1:$B6"));

		// Save and close document
		String saveTo = fullPath("temp/" + "RowsSortWithOptionsCopyResultTo.ods");
		calc.menuItem("File->Save As...").select();
		FileUtil.deleteFile(saveTo);
		submitSaveDlg(saveTo);	
		calc.menuItem("File->Close").select();
		openStartcenter();

		// Reopen and verify sorted result
		startcenter.menuItem("File->Open...").select();
		submitOpenDlg(saveTo);
		calc.waitForExistence(10, 2);
		assertArrayEquals("Saved sorted result", expectedSortedResult, CalcUtil.getCellTexts("$Sheet3.$A4:$B9"));
		assertArrayEquals("Saved sorted result to cell range", expectedSortedResult, CalcUtil.getCellTexts("$Sheet2.$A1:$B6"));
	}

	/**
	 * Test sort criteria: sort first by
	 * @throws Exception
	 */
	@Test
	public void testSortCriteriaSortFirstBy() throws Exception{

		// Input some data
		String[][] data = new String[][] {
				{"3", "D"},
				{"5", "FLK"},
				{"4", "E"},
				{"2", "BC"},
				{"6", "GE"},
				{"1", "AB"},
		};
		String[][] expectedResultSortByColumnBAscending = new String[][] {
				{"1", "AB"},
				{"2", "BC"},
				{"3", "D"},
				{"4", "E"},
				{"5", "FLK"},
				{"6", "GE"},
		};
		String[][] expectedResultSortByColumnADescending = new String[][] {
				{"6", "GE"},
				{"5", "FLK"},
				{"4", "E"},
				{"3", "D"},
				{"2", "BC"},
				{"1", "AB"},
		};
		CalcUtil.selectRange("A1");
		typeKeys("3<down>5<down>4<down>2<down>6<down>1");
		CalcUtil.selectRange("B1");
		typeKeys("D<down>FLK<down>E<down>BC<down>GE<down>AB");

		// "Data->Sort...", choose "Ascending", sort first by Column B
		calc.menuItem("Data->Sort...").select();
		SortPage_Ascending1.check();
		SortPage_By1.select("Column B");
		SortPage.ok();

		// Verify sorted result
		assertArrayEquals("Sorted result", expectedResultSortByColumnBAscending, CalcUtil.getCellTexts("A1:B6"));

		// Uodo/redo
		calc.menuItem("Edit->Undo: Sort").select();
		assertArrayEquals("Undo sorted result", data, CalcUtil.getCellTexts("A1:B6"));
		calc.menuItem("Edit->Redo: Sort").select();
		assertArrayEquals("Redo sorted result", expectedResultSortByColumnBAscending, CalcUtil.getCellTexts("A1:B6"));
		calc.menuItem("Edit->Undo: Sort").select();

		// Save and close document
		String saveTo = fullPath("temp/" + "SortCriteriaSortFirstBy.ods");
		calc.menuItem("File->Save As...").select();
		FileUtil.deleteFile(saveTo);
		submitSaveDlg(saveTo);	
		calc.menuItem("File->Close").select();
		openStartcenter();

		// Reopen, "Data->Sort...", choose "Descending", sort first by Column A
		startcenter.menuItem("File->Open...").select();
		submitOpenDlg(saveTo);
		calc.waitForExistence(10, 2);
		calc.menuItem("Data->Sort...").select();
		SortPage_Descending1.check();
		SortPage_By1.select("Column A");
		SortPage.ok();		

		// Verify sorted result
		assertArrayEquals("Saved sorted result", expectedResultSortByColumnADescending, CalcUtil.getCellTexts("A1:B6"));
	}	

	/**
	 * Test sort criteria: sort second by
	 * @throws Exception
	 */
	@Test
	public void testSortCriteriaSortSecondBy() throws Exception{

		// Input some data
		String[][] data = new String[][] {
				{"3", "D"},
				{"5", "FLK"},
				{"4", "E"},
				{"1", "AB"},
				{"6", "GE"},
				{"2", "AB"},
		};
		String[][] expectedResultSortFirstByB = new String[][] {
				{"1", "AB"},
				{"2", "AB"},
				{"3", "D"},
				{"4", "E"},
				{"5", "FLK"},
				{"6", "GE"},
		};
		String[][] expectedResultSortSecondByA= new String[][] {
				{"2", "AB"},
				{"1", "AB"},
				{"3", "D"},
				{"4", "E"},
				{"5", "FLK"},
				{"6", "GE"},
		};
		CalcUtil.selectRange("A1");
		typeKeys("3<down>5<down>4<down>1<down>6<down>2");
		CalcUtil.selectRange("B1");
		typeKeys("D<down>FLK<down>E<down>AB<down>GE<down>AB");

		// "Data->Sort...", choose "Ascending", sort first by Column B
		calc.menuItem("Data->Sort...").select();
		SortPage_Ascending1.check();
		SortPage_By1.select("Column B");
		SortPage.ok();

		// Verify sorted result
		assertArrayEquals("Sorted result", expectedResultSortFirstByB, CalcUtil.getCellTexts("A1:B6"));

		// Uodo/redo
		calc.menuItem("Edit->Undo: Sort").select();
		assertArrayEquals("Undo sorted result", data, CalcUtil.getCellTexts("A1:B6"));
		calc.menuItem("Edit->Redo: Sort").select();
		assertArrayEquals("Redo sorted result", expectedResultSortFirstByB, CalcUtil.getCellTexts("A1:B6"));
		calc.menuItem("Edit->Undo: Sort").select();

		// Save and close document
		String saveTo = fullPath("temp/" + "SortCriteriaSortSecondBy.ods");
		calc.menuItem("File->Save As...").select();
		FileUtil.deleteFile(saveTo);
		submitSaveDlg(saveTo);	
		calc.menuItem("File->Close").select();
		openStartcenter();

		// Reopen, "Data->Sort...", sort first by Column B "Ascending", sort second by Column A "Descending"
		startcenter.menuItem("File->Open...").select();
		submitOpenDlg(saveTo);
		calc.waitForExistence(10, 2);
		calc.menuItem("Data->Sort...").select();
		SortPage_By1.select("Column B");
		SortPage_Ascending1.check();
		SortPage_By2.select("Column A");
		SortPage_Descending2.check();
		SortPage.ok();

		// Verify sorted result
		assertArrayEquals("Saved sorted result", expectedResultSortSecondByA, CalcUtil.getCellTexts("A1:B6"));
	}	

	/**
	 * Test sort criteria: sort third by
	 * @throws Exception
	 */
	@Test
	public void testSortCriteriaSortThirdBy() throws Exception{

		// Input some data
		String[][] data = new String[][] {
				{"3", "AB", "2"},
				{"8", "FLK", "5"},
				{"6", "E", "4"},
				{"1", "AB", "1"},
				{"9", "GE", "6"},
				{"2", "AB", "2"},
				{"7", "EFYU", "7"},
				{"5", "DS", "8"},
				{"4", "AB", "1"},
		};
		String[][] expectedResultSortFirstByB = new String[][] {
				{"3", "AB", "2"},
				{"1", "AB", "1"},
				{"2", "AB", "2"},
				{"4", "AB", "1"},
				{"5", "DS", "8"},
				{"6", "E", "4"},
				{"7", "EFYU", "7"},
				{"8", "FLK", "5"},
				{"9", "GE", "6"},
		};
		String[][] expectedResultSortSecondByC= new String[][] {
				{"3", "AB", "2"},
				{"2", "AB", "2"},
				{"1", "AB", "1"},
				{"4", "AB", "1"},
				{"5", "DS", "8"},
				{"6", "E", "4"},
				{"7", "EFYU", "7"},
				{"8", "FLK", "5"},
				{"9", "GE", "6"},
		};
		String[][] expectedResultSortThirdByA= new String[][] {
				{"3", "AB", "2"},
				{"2", "AB", "2"},
				{"4", "AB", "1"},
				{"1", "AB", "1"},
				{"5", "DS", "8"},
				{"6", "E", "4"},
				{"7", "EFYU", "7"},
				{"8", "FLK", "5"},
				{"9", "GE", "6"},
		};
		CalcUtil.selectRange("A1");
		typeKeys("3<down>8<down>6<down>1<down>9<down>2<down>7<down>5<down>4");
		CalcUtil.selectRange("B1");
		typeKeys("AB<down>FLK<down>E<down>AB<down>GE<down>AB<down>EFYU<down>DS<down>AB");
		CalcUtil.selectRange("C1");
		typeKeys("2<down>5<down>4<down>1<down>6<down>2<down>7<down>8<down>1");
		sleep(0.5);

		// "Data->Sort...", choose "Ascending", sort first by Column B
		calc.menuItem("Data->Sort...").select();
		SortPage_By1.select("Column B");
		SortPage_Ascending1.check();
		SortPage.ok();

		// Verify sorted result
		assertArrayEquals("Sorted result", expectedResultSortFirstByB, CalcUtil.getCellTexts("A1:C9"));

		// Uodo/redo
		calc.menuItem("Edit->Undo: Sort").select();
		assertArrayEquals("Undo sorted result", data, CalcUtil.getCellTexts("A1:C9"));
		calc.menuItem("Edit->Redo: Sort").select();
		assertArrayEquals("Redo sorted result", expectedResultSortFirstByB, CalcUtil.getCellTexts("A1:C9"));
		calc.menuItem("Edit->Undo: Sort").select();

		// Save and close document
		String saveTo = fullPath("temp/" + "SortCriteriaSortThirdBy.ods");
		calc.menuItem("File->Save As...").select();
		FileUtil.deleteFile(saveTo);
		submitSaveDlg(saveTo);	
		calc.menuItem("File->Close").select();
		openStartcenter();

		// Reopen, "Data->Sort...", sort first by Column B "Ascending", sort second by Column C "Descending"
		startcenter.menuItem("File->Open...").select();
		submitOpenDlg(saveTo);
		calc.waitForExistence(10, 2);
		calc.menuItem("Data->Sort...").select();
		SortPage_By1.select("Column B");
		SortPage_Ascending1.check();
		SortPage_By2.select("Column C");
		SortPage_Descending2.check();
		SortPage.ok();

		// Verify sorted result
		assertArrayEquals("Sorted result", expectedResultSortSecondByC, CalcUtil.getCellTexts("A1:C9"));

		// "Data->Sort...", sort first by Column B "Ascending", sort second by Column C "Descending", sort third by Column A "Descending"
		calc.menuItem("Data->Sort...").select();
		SortPage_By1.select("Column B");
		SortPage_Ascending1.check();
		SortPage_By2.select("Column C");
		SortPage_Descending2.check();
		SortPage_By3.select("Column A");
		SortPage_Descending3.check();
		SortPage.ok();

		// Verify sorted result
		assertArrayEquals("Sorted result", expectedResultSortThirdByA, CalcUtil.getCellTexts("A1:C9"));	

		// Uodo/redo
		calc.menuItem("Edit->Undo: Sort").select();
		assertArrayEquals("Undo sorted result", expectedResultSortSecondByC, CalcUtil.getCellTexts("A1:C9"));
		calc.menuItem("Edit->Redo: Sort").select();
		assertArrayEquals("Redo sorted result", expectedResultSortThirdByA, CalcUtil.getCellTexts("A1:C9"));

		// Save and close document
		saveTo = fullPath("temp/" + "SortCriteriaSortThirdBy1.ods");
		calc.menuItem("File->Save As...").select();
		FileUtil.deleteFile(saveTo);
		submitSaveDlg(saveTo);	
		calc.menuItem("File->Close").select();
		openStartcenter();

		// Reopen and verify data sort is not lost
		startcenter.menuItem("File->Open...").select();
		submitOpenDlg(saveTo);
		calc.waitForExistence(10, 2);
		assertArrayEquals("Saved sorted result", expectedResultSortThirdByA, CalcUtil.getCellTexts("A1:C9"));	
	}	

	/**
	 * Test sort options: custom sort order, predefined in preferences from copy list
	 * @throws Exception
	 */
	@Test
	public void testSortOptionsCustomSortOrderPredefineFromCopyList() throws Exception{

		// Dependencies start
		CalcUtil.selectRange("A1");
		typeKeys("red<down>yellow<down>blue<down>green<down>white<down>black");
		CalcUtil.selectRange("A1:A6");
		app.dispatch(".uno:ChangeCaseToLower");	// In case SC capitalize first letter automatically

		// Select the cell range, "Tools->Options...->OpenOffice.org Spreadsheets->Sort Lists"
		CalcUtil.selectRange("A1:A6");
		app.dispatch(".uno:OptionsTreeDialog");
		// Select "Sort Lists": start. Shrink the tree list and select
		OptionsDlgList.select(0);
		typeKeys("<left>");
		for (int i=0; i<6; i++) {
			typeKeys("<down><left>");	
		}
		OptionsDlgList.select(3);
		typeKeys("<right>");
		OptionsDlgList.select(7);
		// Select "Sort Lists": end

		// Click "Copy" button, "OK", close the document		
		OptionsDlg_SortListsTabCopy.click();
		OptionsDlg.ok();
		calc.menuItem("File->Close").select();
		MsgBox_AdditionalRowsNotSaved.no();
		// Dependencies end

		// Create a new spreadsheet document
		startcenter.menuItem("File->New->Spreadsheet").select();

		// Input some data
		String[][] data = new String[][] {
				{"Color"},
				{"black"},
				{"yellow"},
				{"blue"},
				{"black"},
				{"white"},
				{"red"},
		};
		String[][] expectedResultNoCustomSortOrder = new String[][] {
				{"Color"},
				{"black"},
				{"black"},
				{"blue"},
				{"red"},
				{"white"},
				{"yellow"},
		};
		String[][] expectedResultCustomSortOrder = new String[][] {
				{"Color"},
				{"red"},
				{"yellow"},
				{"blue"},
				{"white"},
				{"black"},
				{"black"},
		};
		CalcUtil.selectRange("A1");
		typeKeys("Color<down>black<down>yellow<down>blue<down>black<down>white<down>red");
		CalcUtil.selectRange("A2:A7");
		app.dispatch(".uno:ChangeCaseToLower");	// In case SC capitalize first letter automatically

		// "Data->Sort...", "Options" tab, check "Range contains column labels", no custom sort order, "Ascending", sort first by Color
		CalcUtil.selectRange("A1:A7");
		calc.menuItem("Data->Sort...").select();
		SortOptionsPage.select();
		SortOptionsPage_RangeContainsColumnLabels.check();
		SortOptionsPage_CustomSortOrder.uncheck();
		SortPage.select();
		SortPage_By1.select("Color");
		SortPage_Ascending1.check();
		SortPage.ok();	

		// Verify sorted result
		assertArrayEquals("Sorted result without custom sort order", expectedResultNoCustomSortOrder, CalcUtil.getCellTexts("A1:A7"));

		// Uodo/redo
		calc.menuItem("Edit->Undo: Sort").select();
		assertArrayEquals("Undo sorted result", data, CalcUtil.getCellTexts("A1:A7"));
		calc.menuItem("Edit->Redo: Sort").select();
		assertArrayEquals("Redo sorted result", expectedResultNoCustomSortOrder, CalcUtil.getCellTexts("A1:A7"));
		calc.menuItem("Edit->Undo: Sort").select();

		// Copy original data to sheet2
		CalcUtil.selectRange("A1:A7");
		calc.menuItem("Edit->Copy").select();
		CalcUtil.selectRange("Sheet2.A1");
		calc.menuItem("Edit->Paste").select();		

		// "Data->Sort...", "Options" tab, check "Range contains column labels", choose custom sort order, "Ascending", sort first by Color
		calc.menuItem("Data->Sort...").select();
		SortOptionsPage.select();
		SortOptionsPage_RangeContainsColumnLabels.check();
		SortOptionsPage_CustomSortOrder.check();
		SortOptionsPage_CustomSortOrderList.select("red,yellow,blue,green,white,black");
		SortPage.select();
		SortPage_By1.select("Color");
		SortPage_Ascending1.check();
		SortPage.ok();	

		// Verify sorted result
		assertArrayEquals("Sorted result with custom sort order", expectedResultCustomSortOrder, CalcUtil.getCellTexts("A1:A7"));

		// Uodo/redo
		calc.menuItem("Edit->Undo: Sort").select();
		assertArrayEquals("Undo sorted result", data, CalcUtil.getCellTexts("A1:A7"));
		calc.menuItem("Edit->Redo: Sort").select();
		assertArrayEquals("Redo sorted result", expectedResultCustomSortOrder, CalcUtil.getCellTexts("A1:A7"));

		// Save and close document
		String saveTo = fullPath("temp/" + "SortOptionsCustomSortOrderPredefineFromCopyList.ods");
		calc.menuItem("File->Save As...").select();
		FileUtil.deleteFile(saveTo);
		submitSaveDlg(saveTo);	
		calc.menuItem("File->Close").select();
		openStartcenter();

		// Reopen and verify sorted result
		startcenter.menuItem("File->Open...").select();
		submitOpenDlg(saveTo);
		calc.waitForExistence(10, 2);
		assertArrayEquals("Original data", data, CalcUtil.getCellTexts("$Sheet1.$A1:$A7"));
		assertArrayEquals("Saved sorted result", expectedResultCustomSortOrder, CalcUtil.getCellTexts("$Sheet2.$A1:$A7"));
	}	

	/**
	 * Test sort options: custom sort order, predefined in preferences from new list
	 * @throws Exception
	 */
	@Test
	public void testSortOptionsCustomSortOrderPredefineFromNewList() throws Exception{

		// Dependencies start
		// "Tools->Options...->OpenOffice.org Spreadsheets->Sort Lists"
		app.dispatch(".uno:OptionsTreeDialog");
		// Select "Sort Lists": start. Shrink the tree list and select
		OptionsDlgList.select(0);
		typeKeys("<left>");
		for (int i=0; i<6; i++) {
			typeKeys("<down><left>");	
		}
		OptionsDlgList.select(3);
		typeKeys("<right>");
		OptionsDlgList.select(7);
		// Select "Sort Lists": end

		// Click "New" button, input "white,red,yellow,blue,green,black", press "Add" and "OK", close the document		
		OptionsDlg_SortListsTabNew.click();
		typeKeys("white,red,yellow,blue,green,black");
		OptionsDlg_SortListsTabAdd.click();
		sleep(0.5);
		OptionsDlg.ok();
		calc.menuItem("File->Close").select();
		// Dependencies end

		// Create a new spreadsheet document
		startcenter.menuItem("File->New->Spreadsheet").select();
		sleep(3);

		// Input some data
		String[][] data = new String[][] {
				{"Color"},
				{"black"},
				{"yellow"},
				{"blue"},
				{"black"},
				{"white"},
				{"red"},
		};
		String[][] expectedResultNoCustomSortOrder = new String[][] {
				{"Color"},
				{"black"},
				{"black"},
				{"blue"},
				{"red"},
				{"white"},
				{"yellow"},
		};
		String[][] expectedResultCustomSortOrder = new String[][] {
				{"Color"},
				{"white"},
				{"red"},
				{"yellow"},
				{"blue"},
				{"black"},
				{"black"},
		};
		CalcUtil.selectRange("A1");
		typeKeys("Color<down>black<down>yellow<down>blue<down>black<down>white<down>red");
		CalcUtil.selectRange("A2:A7");
		app.dispatch(".uno:ChangeCaseToLower");	// In case SC capitalize first letter automatically

		// "Data->Sort...", "Options" tab, check "Range contains column labels", no custom sort order, "Ascending", sort first by Color
		CalcUtil.selectRange("A1:A7");
		calc.menuItem("Data->Sort...").select();
		SortOptionsPage.select();
		SortOptionsPage_RangeContainsColumnLabels.check();
		SortOptionsPage_CustomSortOrder.uncheck();
		SortPage.select();
		SortPage_By1.select("Color");
		SortPage_Ascending1.check();
		SortPage.ok();	

		// Verify sorted result
		assertArrayEquals("Sorted result without custom sort order", expectedResultNoCustomSortOrder, CalcUtil.getCellTexts("A1:A7"));

		// Uodo/redo
		calc.menuItem("Edit->Undo: Sort").select();
		assertArrayEquals("Undo sorted result", data, CalcUtil.getCellTexts("A1:A7"));
		calc.menuItem("Edit->Redo: Sort").select();
		assertArrayEquals("Redo sorted result", expectedResultNoCustomSortOrder, CalcUtil.getCellTexts("A1:A7"));
		calc.menuItem("Edit->Undo: Sort").select();

		// Copy original data to sheet2
		CalcUtil.selectRange("A1:A7");
		calc.menuItem("Edit->Copy").select();
		CalcUtil.selectRange("Sheet2.A1");
		calc.menuItem("Edit->Paste").select();		

		// "Data->Sort...", "Options" tab, check "Range contains column labels", choose custom sort order, "Ascending", sort first by Color
		calc.menuItem("Data->Sort...").select();
		SortOptionsPage.select();
		SortOptionsPage_RangeContainsColumnLabels.check();
		SortOptionsPage_CustomSortOrder.check();
		SortOptionsPage_CustomSortOrderList.select("white,red,yellow,blue,green,black");
		SortPage.select();
		SortPage_By1.select("Color");
		SortPage_Ascending1.check();
		SortPage.ok();	

		// Verify sorted result
		assertArrayEquals("Sorted result with custom sort order", expectedResultCustomSortOrder, CalcUtil.getCellTexts("A1:A7"));

		// Uodo/redo
		calc.menuItem("Edit->Undo: Sort").select();
		assertArrayEquals("Undo sorted result", data, CalcUtil.getCellTexts("A1:A7"));
		calc.menuItem("Edit->Redo: Sort").select();
		assertArrayEquals("Redo sorted result", expectedResultCustomSortOrder, CalcUtil.getCellTexts("A1:A7"));

		// Save and close document
		String saveTo = fullPath("temp/" + "SortOptionsCustomSortOrderPredefineFromNewList.ods");
		calc.menuItem("File->Save As...").select();
		FileUtil.deleteFile(saveTo);
		submitSaveDlg(saveTo);	
		calc.menuItem("File->Close").select();
		openStartcenter();

		// Reopen and verify sorted result
		startcenter.menuItem("File->Open...").select();
		submitOpenDlg(saveTo);
		calc.waitForExistence(10, 2);
		assertArrayEquals("Original data", data, CalcUtil.getCellTexts("$Sheet1.$A1:$A7"));
		assertArrayEquals("Saved sorted result", expectedResultCustomSortOrder, CalcUtil.getCellTexts("$Sheet2.$A1:$A7"));
	}	

	/**
	 * Test sort options: sort columns, direction "Left to right"
	 * @throws Exception
	 */
	@Test
	public void testSortOptionsDirectionSortColumns() throws Exception{

		// Input some data
		String[][] data = new String[][] {
				{"Units", "7", "27", "4", "12", "3", "6"},
		};
		String[][] expectedSortedResult = new String[][] {
				{"Units", "3", "4", "6", "7", "12", "27"},
		};
		CalcUtil.selectRange("A1");
		typeKeys("Units<right>7<right>27<right>4<right>12<right>3<right>6");

		// "Data->Sort...", check "Range contains column labels", "Left to right", sort first by"Units", "Ascending"
		calc.menuItem("Data->Sort...").select();
		SortOptionsPage.select();
		SortOptionsPage_RangeContainsColumnLabels.check();
		SortOptionsPage_LeftToRight.check();
		SortPage.select();
		SortPage_By1.select("Units");
		SortPage_Ascending1.check();
		SortPage.ok();		

		// Verify sorted result
		assertArrayEquals("Sorted result", expectedSortedResult, CalcUtil.getCellTexts("A1:G1"));

		// Uodo/redo
		calc.menuItem("Edit->Undo: Sort").select();
		assertArrayEquals("Undo sorted result", data, CalcUtil.getCellTexts("A1:G1"));
		calc.menuItem("Edit->Redo: Sort").select();
		assertArrayEquals("Redo sorted result", expectedSortedResult, CalcUtil.getCellTexts("A1:G1"));

		// Save and close document
		String saveTo = fullPath("temp/" + "SortOptionsDirectionSortColumns.ods");
		calc.menuItem("File->Save As...").select();
		FileUtil.deleteFile(saveTo);
		submitSaveDlg(saveTo);	
		calc.menuItem("File->Close").select();
		openStartcenter();

		// Reopen and verify sorted result
		startcenter.menuItem("File->Open...").select();
		submitOpenDlg(saveTo);
		calc.waitForExistence(10, 2);
		assertArrayEquals("Saved sorted result", expectedSortedResult, CalcUtil.getCellTexts("A1:G1"));
	}

	/**
	 * Test sort options: "Include formats"
	 * @throws Exception
	 */
	@Test
	public void testSortOptionsIncludeFormats() throws Exception{

		// Create a new spreadsheet document

		String[][] dataWithCurrencyFormats = new String[][] {
				{"Units"},
				{"$32.00"},
				{"57.00 \u20ac"},
				{"\u20a4 74"},
				{"R$ 50.00"},
				{"\u062c.\u0645. 27"},
				{"7.00 \u0440\u0443\u0431"},
		};
		String[][] expectedSortedResultIncludeFormat = new String[][] {
				{"Units"},
				{"7.00 \u0440\u0443\u0431"},
				{"\u062c.\u0645. 27"},
				{"$32.00"},
				{"R$ 50.00"},
				{"57.00 \u20ac"},
				{"\u20a4 74"},
		};
		String[][] expectedSortedResultExcludeFormat = new String[][] {
				{"Units"},
				{"$7.00"},
				{"27.00 \u20ac"},
				{"\u20a4 32"},
				{"R$ 50.00"},
				{"\u062c.\u0645. 57"},
				{"74.00 \u0440\u0443\u0431"},
		};

		// Input source data
		String file = testFile("sc/SortOptionsIncludeFormats.ods");
		//		String file = testFile("sc/FFC252FFCSC_XML_Datarange0235.xls");
		app.dispatch(".uno:Open", 3);
		submitOpenDlg(file);
		calc.waitForExistence(10, 2);

		assertArrayEquals("source", dataWithCurrencyFormats, CalcUtil.getCellTexts("A1:A7"));

		//		CalcUtil.selectRange("A1");
		//		typeKeys("Units<down>$32.00<down>57.00 \u20ac<down>\u20a4 74<down>R$ 50.00<down>\u062c.\u0645. 27.00<down>7.00 \u0440\u0443\u0431.");

		//		// Set Currency formats
		//		CalcUtil.selectRange("A2");
		//		typeKeys("<ctrl 1>");
		////		calc.menuItem("Fortmat->Cells...").select(); error: can not find item "Format"
		//		FormatCellsDlg_NumbersPage.select();
		//		FormatCellsDlg_NumbersPageCategory.select("Currency");
		//		FormatCellsDlg_NumbersPageCurrencyFormat.select("$ English (USA)");
		//		FormatCellsDlg_NumbersPage.ok();
		//		CalcUtil.selectRange("A3");
		//		typeKeys("<ctrl 1>");
		//		FormatCellsDlg_NumbersPage.select();
		//		FormatCellsDlg_NumbersPageCategory.select("Currency");
		//		FormatCellsDlg_NumbersPageCurrencyFormat.select("\u20ac Spanish (Spain)");
		//		FormatCellsDlg_NumbersPage.ok();
		//		CalcUtil.selectRange("A4");
		//		typeKeys("<ctrl 1>");
		//		FormatCellsDlg_NumbersPage.select();
		//		FormatCellsDlg_NumbersPageCategory.select("Currency");
		//		FormatCellsDlg_NumbersPageCurrencyFormat.select("\u20a4 Latin");
		//		FormatCellsDlg_NumbersPage.ok();		
		//		CalcUtil.selectRange("A5");
		//		typeKeys("<ctrl 1>");
		//		FormatCellsDlg_NumbersPage.select();
		//		FormatCellsDlg_NumbersPageCategory.select("Currency");
		//		FormatCellsDlg_NumbersPageCurrencyFormat.select("R$ Portuguese (Brazil)");
		//		FormatCellsDlg_NumbersPage.ok();	
		//		CalcUtil.selectRange("A6");
		//		typeKeys("<ctrl 1>");
		//		FormatCellsDlg_NumbersPage.select();
		//		FormatCellsDlg_NumbersPageCategory.select("Currency");
		//		FormatCellsDlg_NumbersPageCurrencyFormat.select("\u062c.\u0645. Arabic (Egypt)");
		//		FormatCellsDlg_NumbersPage.ok();	
		//		CalcUtil.selectRange("A7");
		//		typeKeys("<ctrl 1>");
		//		FormatCellsDlg_NumbersPage.select();
		//		FormatCellsDlg_NumbersPageCategory.select("Currency");
		//		FormatCellsDlg_NumbersPageCurrencyFormat.select("\u0440\u0443\u0431. Russian");
		//		FormatCellsDlg_NumbersPage.ok();	

		// "Data->Sort...", check "Range contains column labels", check "Include formats", sort first by "Units", "Ascending"
		calc.menuItem("Data->Sort...").select();
		SortOptionsPage.select();
		SortOptionsPage_RangeContainsColumnLabels.check();
		SortOptionsPage_IncludeFormats.check();
		SortPage.select();
		SortPage_By1.select("Units");
		SortPage_Ascending1.check();
		SortPage.ok();		

		// Verify sorted result
		assertArrayEquals("Sorted result include formats", expectedSortedResultIncludeFormat, CalcUtil.getCellTexts("A1:A7"));

		// Uodo/redo
		calc.menuItem("Edit->Undo: Sort").select();
		assertArrayEquals("Undo sorted result", dataWithCurrencyFormats, CalcUtil.getCellTexts("A1:A7"));
		calc.menuItem("Edit->Redo: Sort").select();
		assertArrayEquals("Redo sorted result", expectedSortedResultIncludeFormat, CalcUtil.getCellTexts("A1:A7"));
		calc.menuItem("Edit->Undo: Sort").select();

		// Copy the original data to sheet2
		CalcUtil.selectRange("A1:A7");
		calc.menuItem("Edit->Copy").select();
		CalcUtil.selectRange("Sheet2.A1");
		calc.menuItem("Edit->Paste").select();		

		// "Data->Sort...", check "Range contains column labels", uncheck "Include formats", sort first by "Units", "Ascending"
		calc.menuItem("Data->Sort...").select();
		SortOptionsPage.select();
		SortOptionsPage_RangeContainsColumnLabels.check();
		SortOptionsPage_IncludeFormats.uncheck();
		SortPage.select();
		SortPage_By1.select("Units");
		SortPage_Ascending1.check();
		SortPage.ok();		

		// Verify sorted result
		assertArrayEquals("Sorted result exclude formats", expectedSortedResultExcludeFormat, CalcUtil.getCellTexts("A1:A7"));	

		// Uodo/redo
		calc.menuItem("Edit->Undo: Sort").select();
		assertArrayEquals("Undo sorted result", dataWithCurrencyFormats, CalcUtil.getCellTexts("A1:A7"));
		calc.menuItem("Edit->Redo: Sort").select();
		assertArrayEquals("Redo sorted result", expectedSortedResultExcludeFormat, CalcUtil.getCellTexts("A1:A7"));

		// Save and close document
		String saveTo = fullPath("temp/" + "SortOptionsIncludeFormats.ods");
		calc.menuItem("File->Save As...").select();
		FileUtil.deleteFile(saveTo);
		submitSaveDlg(saveTo);	
		calc.menuItem("File->Close").select();
		openStartcenter();

		// Reopen and verify sorted result
		startcenter.menuItem("File->Open...").select();
		submitOpenDlg(saveTo);
		calc.waitForExistence(10, 2);
		assertArrayEquals("Original data", dataWithCurrencyFormats, CalcUtil.getCellTexts("$Sheet1.$A1:$A7"));
		assertArrayEquals("Saved sorted result exclude format", expectedSortedResultExcludeFormat, CalcUtil.getCellTexts("$Sheet2.$A1:$A7"));
	}

	/**
	 * Test sort options: multiple sort, data overlap
	 * @throws Exception
	 */
	@Test
	public void testSortOptionsMultipleSortDataOverlap() throws Exception{

		// Input some data
		String[][] data1 = new String[][] {
				{"D"},
				{"C"},
				{"B"},
				{"A"},
				{"E"},
		};
		String[][] expectedSortedResult1 = new String[][] {
				{"A"},
				{"B"},
				{"C"},
				{"D"},
				{"E"},
		};
		String[][] data2 = new String[][] {
				{"4"},
				{"2"},
				{"5"},
				{"1"},
				{"3"},
		};
		String[][] expectedSortedResultDataOverlap = new String[][] {
				{"A"},
				{"B"},
				{"C"},
				{"1"},
				{"2"},
				{"3"},
				{"4"},
				{"5"},
		};
		CalcUtil.selectRange("A1");
		typeKeys("D<down>C<down>B<down>A<down>E");

		// "Data->Sort...", uncheck "Range contains column labels", sort first by "Column A", "Ascending"
		calc.menuItem("Data->Sort...").select();
		SortOptionsPage.select();
		SortOptionsPage_RangeContainsColumnLabels.uncheck();
		SortPage.select();
		SortPage_By1.select("Column A");
		SortPage_Ascending1.check();
		SortPage.ok();		

		// Verify sorted result
		assertArrayEquals("Sorted result", expectedSortedResult1, CalcUtil.getCellTexts("A1:A5"));

		// Uodo/redo
		calc.menuItem("Edit->Undo: Sort").select();
		assertArrayEquals("Undo sorted result", data1, CalcUtil.getCellTexts("A1:A5"));
		calc.menuItem("Edit->Redo: Sort").select();
		assertArrayEquals("Redo sorted result", expectedSortedResult1, CalcUtil.getCellTexts("A1:A5"));

		// Input data2 into same sheet, data1 and data2 are not overlapped
		CalcUtil.selectRange("G10");
		typeKeys("4<down>2<down>5<down>1<down>3");

		// Focus on data2, "Data->Sort...", "Copy result to" partially overlap with data1, sort first by "Column G", "Ascending"
		CalcUtil.selectRange("G10");
		calc.menuItem("Data->Sort...").select();
		SortOptionsPage.select();
		SortOptionsPage_RangeContainsColumnLabels.uncheck();
		SortOptionsPage_CopyResultTo.check();
		SortOptionsPage_CopyResultToEdit.setText("A4");
		SortPage.select();
		SortPage_By1.select("Column G");
		SortPage_Ascending1.check();
		SortPage.ok();			

		// Verify sorted result
		assertArrayEquals("Sorted result data overlap", expectedSortedResultDataOverlap, CalcUtil.getCellTexts("A1:A8"));

		// Save and close document
		String saveTo = fullPath("temp/" + "SortOptionsMultipleSortDataOverlap.ods");
		calc.menuItem("File->Save As...").select();
		FileUtil.deleteFile(saveTo);
		submitSaveDlg(saveTo);	
		calc.menuItem("File->Close").select();
		openStartcenter();

		// Reopen and verify sorted result
		startcenter.menuItem("File->Open...").select();
		submitOpenDlg(saveTo);
		calc.waitForExistence(10, 2);
		assertArrayEquals("Saved sorted result", expectedSortedResultDataOverlap, CalcUtil.getCellTexts("A1:A8"));
		assertArrayEquals("Original data2", data2, CalcUtil.getCellTexts("G10:G14"));
	}

	/**
	 * Test sort options: multiple sort, no data overlap, sort parameter saved correctly
	 * @throws Exception
	 */
	@Test
	public void testSortOptionsMultipleSortSortParameterSaved() throws Exception{

		// Input some data
		String[][] data1 = new String[][] {
				{"D"},
				{"C"},
				{"B"},
				{"A"},
				{"E"},
		};
		String[][] expectedSortedResult1 = new String[][] {
				{"A"},
				{"B"},
				{"C"},
				{"D"},
				{"E"},
		};
		String[][] data2 = new String[][] {
				{"Numbers"},
				{"4"},
				{"2"},
				{"5"},
				{"1"},
				{"3"},
		};
		String[][] expectedSortedResult2 = new String[][] {
				{"Numbers"},
				{"1"},
				{"2"},
				{"3"},
				{"4"},
				{"5"},
		};
		CalcUtil.selectRange("A1");
		typeKeys("D<down>C<down>B<down>A<down>E");

		// "Data->Sort...", uncheck "Range contains column labels", check "Case sensitive" and "Include formats", sort first by "Column A", "Ascending"
		calc.menuItem("Data->Sort...").select();
		SortOptionsPage.select();
		SortOptionsPage_RangeContainsColumnLabels.uncheck();
		SortOptionsPage_CaseSensitive.check();
		SortOptionsPage_IncludeFormats.check();
		SortPage.select();
		SortPage_By1.select("Column A");
		SortPage_Ascending1.check();
		SortPage.ok();		

		// Verify sorted result
		assertArrayEquals("Sorted result1", expectedSortedResult1, CalcUtil.getCellTexts("A1:A5"));

		// Uodo/redo
		calc.menuItem("Edit->Undo: Sort").select();
		assertArrayEquals("Undo sorted result", data1, CalcUtil.getCellTexts("A1:A5"));
		calc.menuItem("Edit->Redo: Sort").select();
		assertArrayEquals("Redo sorted result", expectedSortedResult1, CalcUtil.getCellTexts("A1:A5"));

		// Input data2 into same sheet, data1 and data2 are not overlapped
		CalcUtil.selectRange("G10");
		typeKeys("Numbers<down>4<down>2<down>5<down>1<down>3");

		// Focus on data2, "Data->Sort...", check "Range contains column labels", uncheck "Case sensitive" and "Include formats", sort first by "Numbers", "Ascending"
		CalcUtil.selectRange("G10");
		calc.menuItem("Data->Sort...").select();
		SortOptionsPage.select();
		SortOptionsPage_RangeContainsColumnLabels.check();
		SortOptionsPage_CaseSensitive.uncheck();
		SortOptionsPage_IncludeFormats.uncheck();
		SortPage.select();
		SortPage_By1.select("Numbers");
		SortPage_Ascending1.check();
		SortPage.ok();			

		// Verify sorted result
		assertArrayEquals("Sorted result2", expectedSortedResult2, CalcUtil.getCellTexts("G10:G15"));

		// Uodo/redo
		calc.menuItem("Edit->Undo: Sort").select();
		assertArrayEquals("Undo sorted result", data2, CalcUtil.getCellTexts("G10:G15"));
		calc.menuItem("Edit->Redo: Sort").select();
		assertArrayEquals("Redo sorted result", expectedSortedResult2, CalcUtil.getCellTexts("G10:G15"));

		// Open sort dialog, check its setting
		calc.menuItem("Data->Sort...").select();
		SortOptionsPage.select();
		assertTrue("Range contains column labels should be checked", SortOptionsPage_RangeContainsColumnLabels.isChecked());
		assertFalse("Case sensitive should not be checked", SortOptionsPage_CaseSensitive.isChecked());
		assertFalse("Include formats should not be checked", SortOptionsPage_IncludeFormats.isChecked());
		SortOptionsPage.ok();		

		// Save and close document
		String saveTo = fullPath("temp/" + "SortOptionsMultipleSortParameterSaved.ods");
		calc.menuItem("File->Save As...").select();
		FileUtil.deleteFile(saveTo);
		submitSaveDlg(saveTo);	
		calc.menuItem("File->Close").select();
		openStartcenter();

		// Reopen and verify sorted result and sort parameters
		startcenter.menuItem("File->Open...").select();
		submitOpenDlg(saveTo);
		calc.waitForExistence(10, 2);
		assertArrayEquals("Saved sorted result1", expectedSortedResult1, CalcUtil.getCellTexts("A1:A5"));
		assertArrayEquals("Saved sorted result2", expectedSortedResult2, CalcUtil.getCellTexts("G10:G15"));
		calc.menuItem("Data->Sort...").select();
		SortOptionsPage.select();
		assertTrue("Range contains column labels should be checked", SortOptionsPage_RangeContainsColumnLabels.isChecked());
		assertFalse("Case sensitive should not be checked", SortOptionsPage_CaseSensitive.isChecked());
		assertFalse("Include formats should not be checked", SortOptionsPage_IncludeFormats.isChecked());
		SortOptionsPage.ok();	
	}

}




/**************************************************************
 * 
 * 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 testcase.sc.filter;

import static testlib.AppUtil.*;
import static testlib.UIMap.*;
import org.junit.After;
import static org.junit.Assert.*;
import static org.openoffice.test.vcl.Tester.*;
import org.junit.Before;
import org.junit.Ignore;
import org.junit.Rule;
import testlib.CalcUtil;
import testlib.Log;

/**
 * Test cases about Data->Filter in spreadsheet
 */
public class Fitler {

	@Rule
	public Log LOG = new Log();

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

		// Create a new spreadsheet document
		startcenter.menuItem("File->New->Spreadsheet").select();
	}

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

	/**
	 * 
	 * Verify Chart Wizard dialog title words
	 */
	@Ignore("Bug 120076")
	public void testAutoFilterWithPlusSign() {
		String expect ="2+";
		CalcUtil.selectRange("A1");
		typeKeys(expect + "<enter>");
		assertEquals(expect,CalcUtil.getCellText("A1"));
	}
}




/**************************************************************
 * 
 * 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 testcase.sc.datapilot;

import static testlib.AppUtil.*;
import static testlib.UIMap.*;
import org.junit.After;
import static org.junit.Assert.*;
import static org.openoffice.test.vcl.Tester.*;
import org.junit.Before;
import org.junit.Ignore;
import org.junit.Rule;
import org.openoffice.test.common.SystemUtil;
import testlib.CalcUtil;
import testlib.Log;

/**
 * Test Data->Pivot Table
 * Test cases in this class are unavailable. Because these test cases are based on symphony.
 * DataPilot of symphony is totally different from PivotTable of AOO.
 * Keep this class to track the test point.
 * TODO: Add test cases about Pivot Table.
 */
public class DataPivotTable {

	@Rule
	public Log LOG = new Log();

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

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

	/**
	 * 
	 * Verify copy and paste Data Pilot Table
	 */
	@Ignore("DataPilot in symphony is totally not the same in AOO")
	public void testCopyPasteDataPilotTable() {
		//Open the sample file
		String file = testFile("source_data01.ods");
		startcenter.menuItem("File->Open...").select();
		submitOpenDlg(file);
		sleep(2);

		//Create DataPilotTable and verify the content
		CalcUtil.selectRange("A1:E27");
		calc.menuItem("Data->DataPilot->Start...").select();		
		CreateDataPilotTableDialog.ok();
		assertEquals("New DataPilot Table",CalcUtil.getCellText("B2"));
		assertEquals("Use the DataPilot panel to assign fields to areas in the DataPilot table.",CalcUtil.getCellText("B4"));
		assertEquals("The DataPilot panel automatically displays when the DataPilot table has focus.",CalcUtil.getCellText("B5"));
		assertEquals("Page Area",CalcUtil.getCellText("B7"));
		assertEquals("Row Area",CalcUtil.getCellText("B10"));
		assertEquals("Column Area",CalcUtil.getCellText("D9"));
		assertEquals("Data Area",CalcUtil.getCellText("D11"));

		if(DataPilotAutomaticallyUpdateCheckBox.isChecked()==false){
			DataPilotAutomaticallyUpdateCheckBox.check();
		}

		//Add field into every area
		DataPilotFieldSelect.click(1, 1);
		DataPilotFieldSelect.openContextMenu();
		menuItem("Add to Page").select();
		assertEquals("Locale",CalcUtil.getCellText("A1"));
		sleep(1);

		DataPilotFieldSelect.click(1,30);
		DataPilotFieldSelect.openContextMenu();
		menuItem("Add to Column").select();
		assertEquals("Name",CalcUtil.getCellText("A3"));
		sleep(1);

		DataPilotFieldSelect.click(1,50);
		DataPilotFieldSelect.openContextMenu();
		menuItem("Add to Row").select();
		assertEquals("Date",CalcUtil.getCellText("A4"));
		sleep(1);

		DataPilotFieldSelect.click(1,70);
		DataPilotFieldSelect.openContextMenu();
		menuItem("Add to Data by->Sum").select();
		assertEquals("Sum - Order Number",CalcUtil.getCellText("A3"));
		assertEquals("266773",CalcUtil.getCellText("J23"));
		sleep(1);

		//Copy and paste the data pilot table and verify the content
		CalcUtil.selectRange("A1:J24");
		typeKeys("<$copy>");

		CalcUtil.selectRange("A26");
		typeKeys("<$paste>");
		assertEquals("Locale",CalcUtil.getCellText("A26"));
		assertEquals("Sum - Order Number",CalcUtil.getCellText("A28"));
		assertEquals("Name",CalcUtil.getCellText("B28"));
		assertEquals("Date",CalcUtil.getCellText("A29"));
		assertEquals("Total Result",CalcUtil.getCellText("A48"));
		assertEquals("Total Result",CalcUtil.getCellText("J29"));
		assertEquals("266773",CalcUtil.getCellText("J48"));
		sleep(1);

		CalcUtil.selectRange("A1:J24");
		typeKeys("<$copy>");
		CalcUtil.selectRange("$A.$A29");
		typeKeys("<$paste>");
		assertEquals("Locale",CalcUtil.getCellText("A29"));
		assertEquals("Sum - Order Number",CalcUtil.getCellText("A31"));
		assertEquals("Name",CalcUtil.getCellText("B31"));
		assertEquals("Date",CalcUtil.getCellText("A32"));
		assertEquals("Total Result",CalcUtil.getCellText("A51"));
		assertEquals("Total Result",CalcUtil.getCellText("J32"));
		assertEquals("266773",CalcUtil.getCellText("J51"));
	}

	/**
	 * 
	 * Verify that DP panel will be synchronized with table while add fields on panel.
	 */
	@Ignore("DataPilot in symphony is totally not the same in AOO")
	public void testDataPilotAddFieldsAutoUpdate() {
		//open the sample file Create DataPilotTable and verify the content
		String file = testFile("source_data01.ods");
		startcenter.menuItem("File->Open...").select();
		submitOpenDlg(file);
		sleep(2);
		CalcUtil.selectRange("A1:E27");
		calc.menuItem("Data->DataPilot->Start...").select();
		CreateDataPilotTableDialog.ok();
		assertEquals("New DataPilot Table",CalcUtil.getCellText("B2"));
		assertEquals("Use the DataPilot panel to assign fields to areas in the DataPilot table.",CalcUtil.getCellText("B4"));
		assertEquals("The DataPilot panel automatically displays when the DataPilot table has focus.",CalcUtil.getCellText("B5"));
		assertEquals("Page Area",CalcUtil.getCellText("B7"));
		assertEquals("Row Area",CalcUtil.getCellText("B10"));
		assertEquals("Column Area",CalcUtil.getCellText("D9"));
		assertEquals("Data Area",CalcUtil.getCellText("D11"));

		if(DataPilotAutomaticallyUpdateCheckBox.isChecked()==false){
			DataPilotAutomaticallyUpdateCheckBox.check();

		}
		sleep(1);

		//Add field into every area
		DataPilotFieldSelect.click(1, 30);
		DataPilotFieldSelect.openContextMenu();
		menuItem("Add to Column").select();
		assertEquals("Name",CalcUtil.getCellText("A1"));
		sleep(1);

		DataPilotFieldSelect.click(1,50);
		DataPilotFieldSelect.openContextMenu();
		menuItem("Add to Row").select();
		assertEquals("Date",CalcUtil.getCellText("A2"));
		sleep(1);

		DataPilotFieldSelect.drag(1, 1, 184, 80);
		assertEquals("Locale",CalcUtil.getCellText("A1"));
		sleep(1);

		typeKeys("<$undo>");
		assertEquals("",CalcUtil.getCellText("A1"));
		sleep(1);

		typeKeys("<$redo>");
		assertEquals("Locale",CalcUtil.getCellText("A1"));
		sleep(1);

		DataPilotFieldSelect.click(1,70);
		DataPilotFieldSelect.openContextMenu();
		menuItem("Add to Data by->Sum").select();
		assertEquals("Sum - Order Number",CalcUtil.getCellText("A3"));
		assertEquals("266773",CalcUtil.getCellText("J23"));
		sleep(1);

		typeKeys("<$undo>");
		assertEquals("",CalcUtil.getCellText("A3"));
		sleep(1);

		typeKeys("<$redo>");
		assertEquals("Sum - Order Number",CalcUtil.getCellText("A3"));
		assertEquals("266773",CalcUtil.getCellText("J23"));
		sleep(1);
	}

	/**
	 * 
	 * Verify that DP panel will be synchronized with table while add fields on panel.
	 */
	@Ignore("DataPilot in symphony is totally not the same in AOO")
	public void testDataPilotAddFieldsManualUpdate() {
		//open the sample file Create DataPilotTable and verify the content
		String file = testFile("source_data01.ods");
		startcenter.menuItem("File->Open...").select();
		submitOpenDlg(file);
		sleep(2);
		CalcUtil.selectRange("A1:E27");
		calc.menuItem("Data->DataPilot->Start...").select();
		CreateDataPilotTableDialog.ok();
		assertEquals("New DataPilot Table",CalcUtil.getCellText("B2"));
		assertEquals("Use the DataPilot panel to assign fields to areas in the DataPilot table.",CalcUtil.getCellText("B4"));
		assertEquals("The DataPilot panel automatically displays when the DataPilot table has focus.",CalcUtil.getCellText("B5"));
		assertEquals("Page Area",CalcUtil.getCellText("B7"));
		assertEquals("Row Area",CalcUtil.getCellText("B10"));
		assertEquals("Column Area",CalcUtil.getCellText("D9"));
		assertEquals("Data Area",CalcUtil.getCellText("D11"));

		if(DataPilotAutomaticallyUpdateCheckBox.isChecked()==false){
			DataPilotAutomaticallyUpdateCheckBox.check();

		}

		DataPilotAutomaticallyUpdateCheckBox.uncheck();

		sleep(1);
		DataPilotFieldSelect.click(1, 30);
		DataPilotFieldSelect.openContextMenu();
		menuItem("Add to Column").select();
		assertEquals("New DataPilot Table",CalcUtil.getCellText("B2"));
		assertEquals("Use the DataPilot panel to assign fields to areas in the DataPilot table.",CalcUtil.getCellText("B4"));
		assertEquals("The DataPilot panel automatically displays when the DataPilot table has focus.",CalcUtil.getCellText("B5"));
		assertEquals("Page Area",CalcUtil.getCellText("B7"));
		assertEquals("Row Area",CalcUtil.getCellText("B10"));
		assertEquals("Column Area",CalcUtil.getCellText("D9"));
		assertEquals("Data Area",CalcUtil.getCellText("D11"));
		sleep(1);

		DataPilotFieldSelect.click(1,50);
		DataPilotFieldSelect.openContextMenu();
		menuItem("Add to Row").select();
		assertEquals("New DataPilot Table",CalcUtil.getCellText("B2"));
		assertEquals("Use the DataPilot panel to assign fields to areas in the DataPilot table.",CalcUtil.getCellText("B4"));
		assertEquals("The DataPilot panel automatically displays when the DataPilot table has focus.",CalcUtil.getCellText("B5"));
		assertEquals("Page Area",CalcUtil.getCellText("B7"));
		assertEquals("Row Area",CalcUtil.getCellText("B10"));
		assertEquals("Column Area",CalcUtil.getCellText("D9"));
		assertEquals("Data Area",CalcUtil.getCellText("D11"));
		sleep(1);

		CalcUtil.selectRange("B20");
		ActiveMsgBox.yes();
		sleep(1);
		assertEquals("Name",CalcUtil.getCellText("B1"));
		assertEquals("Date",CalcUtil.getCellText("A2"));

		DataPilotFieldSelect.drag(1, 1, 184, 80);
		assertEquals("Name",CalcUtil.getCellText("B1"));
		assertEquals("Date",CalcUtil.getCellText("A2"));
		sleep(1);

		DataPilotFieldSelect.click(1,70);
		DataPilotFieldSelect.openContextMenu();
		menuItem("Add to Data by->Sum").select();
		assertEquals("Name",CalcUtil.getCellText("B1"));
		assertEquals("Date",CalcUtil.getCellText("A2"));
		sleep(1);

		DataPilotTableUpdateButton.click();
		assertEquals("Locale",CalcUtil.getCellText("A1"));
		assertEquals("Sum - Order Number",CalcUtil.getCellText("A3"));
		assertEquals("266773",CalcUtil.getCellText("J23"));
		sleep(1);


		typeKeys("<$undo>");
		assertEquals("Name",CalcUtil.getCellText("B1"));
		assertEquals("Date",CalcUtil.getCellText("A2"));
		sleep(1);


		typeKeys("<$redo>");
		assertEquals("Locale",CalcUtil.getCellText("A1"));
		assertEquals("Sum - Order Number",CalcUtil.getCellText("A3"));
		assertEquals("266773",CalcUtil.getCellText("J23"));
		sleep(1);

		DataPilotAutomaticallyUpdateCheckBox.check();
		assertTrue(DataPilotAutomaticallyUpdateCheckBox.isChecked());
	}

	/**
	 * 
	 * Verify that DP panel will be synchronized with table while add fields on panel.
	 */
	@Ignore("DataPilot in symphony is totally not the same in AOO")
	public void testDataPilotChangeDataFieldOptionAutoUpdate() {
		//open the sample file Create DataPilotTable and verify the content
		String file = testFile("source_data01.ods");
		startcenter.menuItem("File->Open...").select();
		submitOpenDlg(file);
		sleep(2);
		CalcUtil.selectRange("A1:E27");
		calc.menuItem("Data->DataPilot->Start...").select();
		CreateDataPilotTableDialog.ok();
		assertEquals("New DataPilot Table",CalcUtil.getCellText("B2"));
		assertEquals("Use the DataPilot panel to assign fields to areas in the DataPilot table.",CalcUtil.getCellText("B4"));
		assertEquals("The DataPilot panel automatically displays when the DataPilot table has focus.",CalcUtil.getCellText("B5"));
		assertEquals("Page Area",CalcUtil.getCellText("B7"));
		assertEquals("Row Area",CalcUtil.getCellText("B10"));
		assertEquals("Column Area",CalcUtil.getCellText("D9"));
		assertEquals("Data Area",CalcUtil.getCellText("D11"));
		if(DataPilotAutomaticallyUpdateCheckBox.isChecked()==false){
			DataPilotAutomaticallyUpdateCheckBox.check();

		}
		sleep(1);

		DataPilotFieldSelect.click(1, 1);
		DataPilotFieldSelect.openContextMenu();
		menuItem("Add to Column").select();
		assertEquals("Locale",CalcUtil.getCellText("A1"));
		sleep(1);

		DataPilotFieldSelect.click(1,30);
		DataPilotFieldSelect.openContextMenu();
		menuItem("Add to Column").select();
		assertEquals("Name",CalcUtil.getCellText("B1"));
		sleep(1);

		DataPilotFieldSelect.click(1,50);
		DataPilotFieldSelect.openContextMenu();
		menuItem("Add to Row").select();
		assertEquals("Date",CalcUtil.getCellText("A3"));
		sleep(1);

		DataPilotFieldSelect.click(1,70);
		DataPilotFieldSelect.openContextMenu();
		menuItem("Add to Row").select();
		assertEquals("Order Number",CalcUtil.getCellText("B3"));
		sleep(1);

		DataPilotFieldSelect.click(1,90);
		DataPilotFieldSelect.openContextMenu();
		menuItem("Add to Data by->Sum").select();
		assertEquals("Sum - Amount",CalcUtil.getCellText("A1"));
		assertEquals("32779.17",CalcUtil.getCellInput("K30"));
		sleep(1);

		//Change Locale option settings, and verify it
		String target = "New Locale";
		DataPilotColumnArea.click(1,1);
		DataPilotColumnArea.openContextMenu();
		menuItem("Field Option").select();
		DataPilotFieldOptionFieldTabPageDialog.select();
		DataPilotFieldDisplayNameEditBox.setText(target);
		sleep(1);

		DataPilotFieldOptionFiledSubtotalsPage.select();
		sleep(1);
		DataPilotFieldOptionSubTotalsManuallyRadioButton.check();
		sleep(1);
		SC_DataPilotOptionSubtotalFunctionList.click(9,24);
		sleep(1);

		DataPilotFieldOptionSortTabPageDialog.select();


		DataPilotFieldOptionSortDescendingRadioButton.check();
		DataPilotFieldOptionFieldTabPageDialog.select();
		DataPilotFieldOptionFieldTabPageDialog.ok();
		sleep(1);

		assertEquals("New Locale",CalcUtil.getCellText("C1"));
		assertEquals("USA",CalcUtil.getCellText("C2"));
		assertEquals("USA Count - Amount",CalcUtil.getCellInput("H2"));
		assertEquals("17",CalcUtil.getCellInput("H30"));
		assertEquals("China Count - Amount",CalcUtil.getCellInput("L2"));
		assertEquals("9",CalcUtil.getCellInput("L30"));
		assertEquals("32779.17",CalcUtil.getCellInput("M30"));

		DataPilotColumnArea.click(1,30);
		DataPilotColumnArea.openContextMenu();
		menuItem("Field Option").select();
		DataPilotFieldOptionFieldTabPageDialog.select();
		DataPilotFieldShowItemWithoutDataCheckBox.check();
		DataPilotFieldOptionFieldTabPageDialog.ok();
		assertEquals("Emmy Ma",CalcUtil.getCellText("F3"));
		assertEquals("32779.17",CalcUtil.getCellInput("U30"));

		CalcUtil.selectRange("C1");
		SpreadSheetCells.openContextMenu();
		menuItem("Field Option...").select();
		DataPilotFieldOptionFieldTabPageDialog.select();
		DataPilotFieldDisplayNameEditBox.setText("Locale");
		DataPilotFieldOptionFiledSubtotalsPage.select();
		DataPilotFieldOptionSubTotalsNeverRadioButton.check();
		sleep(1);
		DataPilotFieldOptionSortTabPageDialog.select();
		DataPilotFieldOptionSortAscendingRadioButton.check();
		DataPilotFieldOptionFieldTabPageDialog.select();
		DataPilotFieldOptionFieldTabPageDialog.ok();

		assertEquals("Locale",CalcUtil.getCellText("C1"));
		assertEquals("China",CalcUtil.getCellText("C2"));
		assertEquals("USA",CalcUtil.getCellText("K2"));
		assertEquals("32779.17",CalcUtil.getCellInput("S30"));


		CalcUtil.selectRange("D1");
		SpreadSheetCells.openContextMenu();
		menuItem("Field Option...").select();
		DataPilotFieldOptionFieldTabPageDialog.select();
		DataPilotFieldShowItemWithoutDataCheckBox.uncheck();
		DataPilotFieldOptionFieldTabPageDialog.ok();
		assertEquals("32779.17",CalcUtil.getCellInput("K30"));
	}

	/**
	 * 
	 * Verify that Verify the Drag/Move function of Grouped field 
	 */
	@Ignore("DataPilot in symphony is totally not the same in AOO")
	public void testDragMoveFunctionOfGroupedField() {
		String file = testFile("source_data01.ods");
		startcenter.menuItem("File->Open...").select();
		submitOpenDlg(file);
		sleep(2);
		CalcUtil.selectRange("A1:E27");
		calc.menuItem("Data->DataPilot->Start...").select();
		CreateDataPilotTableDialog.ok();
		assertEquals("New DataPilot Table",CalcUtil.getCellText("B2"));
		assertEquals("Use the DataPilot panel to assign fields to areas in the DataPilot table.",CalcUtil.getCellText("B4"));
		assertEquals("The DataPilot panel automatically displays when the DataPilot table has focus.",CalcUtil.getCellText("B5"));
		assertEquals("Page Area",CalcUtil.getCellText("B7"));
		assertEquals("Row Area",CalcUtil.getCellText("B10"));
		assertEquals("Column Area",CalcUtil.getCellText("D9"));
		assertEquals("Data Area",CalcUtil.getCellText("D11"));
		if(DataPilotAutomaticallyUpdateCheckBox.isChecked()==false){
			DataPilotAutomaticallyUpdateCheckBox.check();

		}

		DataPilotFieldSelect.click(1, 1);
		DataPilotFieldSelect.openContextMenu();
		menuItem("Add to Page").select();
		assertEquals("Locale",CalcUtil.getCellText("A1"));
		sleep(1);

		DataPilotFieldSelect.click(1,30);
		DataPilotFieldSelect.openContextMenu();
		menuItem("Add to Column").select();
		assertEquals("Name",CalcUtil.getCellText("A3"));
		sleep(1);

		DataPilotFieldSelect.click(1,50);
		DataPilotFieldSelect.openContextMenu();
		menuItem("Add to Row").select();
		assertEquals("Date",CalcUtil.getCellText("A4"));
		sleep(1);

		DataPilotFieldSelect.click(1,70);
		DataPilotFieldSelect.openContextMenu();
		menuItem("Add to Data by->Sum").select();
		assertEquals("Sum - Order Number",CalcUtil.getCellText("A3"));
		assertEquals("266773",CalcUtil.getCellText("J23"));
		sleep(1);

		CalcUtil.selectRange("B4:C4");
		SpreadSheetCells.openContextMenu();
		menuItem("Group->Group Selected Items").select();
		assertEquals("Name2",CalcUtil.getCellText("B3"));
		assertEquals("Name",CalcUtil.getCellText("C3"));
		assertEquals("Group1",CalcUtil.getCellText("D4"));
		assertEquals("266773",CalcUtil.getCellText("J24"));
		sleep(1);

		DataPilotColumnArea.click(1,1);
		DataPilotColumnArea.openContextMenu();
		menuItem("Move to Row").select();
		assertEquals("Name2",CalcUtil.getCellText("B4"));
		assertEquals("Group1",CalcUtil.getCellText("B6"));
		assertEquals("266773",CalcUtil.getCellText("K31"));
		sleep(1);

		typeKeys("<$undo>");
		assertEquals("Name2",CalcUtil.getCellText("B3"));
		assertEquals("Name",CalcUtil.getCellText("C3"));
		assertEquals("Group1",CalcUtil.getCellText("D4"));
		assertEquals("266773",CalcUtil.getCellText("J24"));
		sleep(1);

		typeKeys("<$redo>");
		assertEquals("Name2",CalcUtil.getCellText("B4"));
		assertEquals("Group1",CalcUtil.getCellText("B6"));
		assertEquals("266773",CalcUtil.getCellText("K31"));
	}

	/**
	 * 
	 * Verify that DP panel while switch focus among tables with same/different source range.
	 */
	@Ignore("DataPilot in symphony is totally not the same in AOO")
	public void testHideShowPanel() {
		String file = testFile("source_data01.ods");
		startcenter.menuItem("File->Open...").select();
		submitOpenDlg(file);
		sleep(2);
		CalcUtil.selectRange("A1:E27");
		calc.menuItem("Data->DataPilot->Start...").select();		
		CreateDataPilotTableDialog.ok();
		assertEquals("New DataPilot Table",CalcUtil.getCellText("B2"));
		assertEquals("Use the DataPilot panel to assign fields to areas in the DataPilot table.",CalcUtil.getCellText("B4"));
		assertEquals("The DataPilot panel automatically displays when the DataPilot table has focus.",CalcUtil.getCellText("B5"));
		assertEquals("Page Area",CalcUtil.getCellText("B7"));
		assertEquals("Row Area",CalcUtil.getCellText("B10"));
		assertEquals("Column Area",CalcUtil.getCellText("D9"));
		assertEquals("Data Area",CalcUtil.getCellText("D11"));

		if(DataPilotAutomaticallyUpdateCheckBox.isChecked()==false){
			DataPilotAutomaticallyUpdateCheckBox.check();
		}

		DataPilotFieldSelect.click(1, 1);
		DataPilotFieldSelect.openContextMenu();
		menuItem("Add to Page").select();
		assertEquals("Locale",CalcUtil.getCellText("A1"));
		sleep(1);

		DataPilotFieldSelect.click(1,30);
		DataPilotFieldSelect.openContextMenu();
		menuItem("Add to Column").select();
		assertEquals("Name",CalcUtil.getCellText("A3"));
		sleep(1);

		DataPilotFieldSelect.click(1,50);
		DataPilotFieldSelect.openContextMenu();
		menuItem("Add to Row").select();
		assertEquals("Date",CalcUtil.getCellText("A4"));
		sleep(1);

		DataPilotFieldSelect.click(1,70);
		DataPilotFieldSelect.openContextMenu();
		menuItem("Add to Data by->Sum").select();
		assertEquals("Sum - Order Number",CalcUtil.getCellText("A3"));
		assertEquals("266773",CalcUtil.getCellText("J23"));
		sleep(1);

		CalcUtil.selectRange("A1:J24");
		typeKeys("<$copy>");

		CalcUtil.selectRange("A26");
		typeKeys("<$paste>");
		assertEquals("Locale",CalcUtil.getCellText("A26"));
		assertEquals("Sum - Order Number",CalcUtil.getCellText("A28"));
		assertEquals("Name",CalcUtil.getCellText("B28"));
		assertEquals("Date",CalcUtil.getCellText("A29"));
		assertEquals("Total Result",CalcUtil.getCellText("A48"));
		assertEquals("Total Result",CalcUtil.getCellText("J29"));
		assertEquals("266773",CalcUtil.getCellText("J48"));
		sleep(1);

		CalcUtil.selectRange("A1");
		SpreadSheetCells.openContextMenu();
		menuItem("Show DataPilot Panel").select();
		assertFalse(DataPilotPanel.exists());
		sleep(1);

		CalcUtil.selectRange("A1");
		SpreadSheetCells.openContextMenu();
		menuItem("Show DataPilot Panel").select();
		assertTrue(DataPilotPanel.exists());
		sleep(1);

		DataPilotPanel.close();
		assertFalse(DataPilotPanel.exists());
		sleep(1);

		CalcUtil.selectRange("A26");
		DataPilotButton.click();
		sleep(1);
		assertTrue(DataPilotPanel.exists());
		assertEquals("Locale",CalcUtil.getCellText("A26"));
		assertEquals("Sum - Order Number",CalcUtil.getCellText("A28"));
		assertEquals("Name",CalcUtil.getCellText("B28"));
		assertEquals("Date",CalcUtil.getCellText("A29"));
		assertEquals("Total Result",CalcUtil.getCellText("A48"));
		assertEquals("Total Result",CalcUtil.getCellText("J29"));
		assertEquals("266773",CalcUtil.getCellText("J48"));
	}

	/**
	 * 
	 * Verify that DP panel will be synchronized with table while add fields on panel.
	 */
	@Ignore("DataPilot in symphony is totally not the same in AOO")
	public void testMoveFieldInSameAreaManualUpdate() {
		String file = testFile("source_data01.ods");
		startcenter.menuItem("File->Open...").select();
		submitOpenDlg(file);
		sleep(2);
		CalcUtil.selectRange("A1:E27");
		calc.menuItem("Data->DataPilot->Start...").select();
		CreateDataPilotTableDialog.ok();
		if(DataPilotAutomaticallyUpdateCheckBox.isChecked()==false){
			DataPilotAutomaticallyUpdateCheckBox.check();

		}
		assertEquals("New DataPilot Table",CalcUtil.getCellText("B2"));
		assertEquals("Use the DataPilot panel to assign fields to areas in the DataPilot table.",CalcUtil.getCellText("B4"));
		assertEquals("The DataPilot panel automatically displays when the DataPilot table has focus.",CalcUtil.getCellText("B5"));
		assertEquals("Page Area",CalcUtil.getCellText("B7"));
		assertEquals("Row Area",CalcUtil.getCellText("B10"));
		assertEquals("Column Area",CalcUtil.getCellText("D9"));
		assertEquals("Data Area",CalcUtil.getCellText("D11"));
		sleep(1);

		DataPilotFieldSelect.click(1, 1);
		DataPilotFieldSelect.openContextMenu();
		menuItem("Add to Column").select();
		assertEquals("Locale",CalcUtil.getCellText("A1"));
		sleep(1);

		DataPilotFieldSelect.click(1,30);
		DataPilotFieldSelect.openContextMenu();
		menuItem("Add to Column").select();
		assertEquals("Name",CalcUtil.getCellText("B1"));
		sleep(1);

		DataPilotFieldSelect.click(1,50);
		DataPilotFieldSelect.openContextMenu();
		menuItem("Add to Row").select();
		assertEquals("Date",CalcUtil.getCellText("A3"));
		sleep(1);

		DataPilotFieldSelect.click(1,70);
		DataPilotFieldSelect.openContextMenu();
		menuItem("Add to Row").select();
		assertEquals("Order Number",CalcUtil.getCellText("B3"));
		sleep(1);

		DataPilotFieldSelect.click(1,90);
		DataPilotFieldSelect.openContextMenu();
		menuItem("Add to Data by->Sum").select();
		assertEquals("Sum - Amount",CalcUtil.getCellText("A1"));
		assertEquals("32779.17",CalcUtil.getCellInput("K30"));
		sleep(1);

		DataPilotAutomaticallyUpdateCheckBox.uncheck();
		DataPilotColumnArea.drag(1, 1, 1, 60);
		assertEquals("Name",CalcUtil.getCellText("D1"));
		assertEquals("Locale",CalcUtil.getCellText("C1"));
		sleep(1);

		DataPilotPaneRowArea.drag(1,1, 1, 60);
		assertEquals("Order Number",CalcUtil.getCellText("B3"));
		assertEquals("Date",CalcUtil.getCellText("A3"));
		sleep(1);

		CalcUtil.selectRange("A33");
		ActiveMsgBox.yes();
		assertEquals("Name",CalcUtil.getCellText("C1"));
		assertEquals("Locale",CalcUtil.getCellText("D1"));
		assertEquals("Order Number",CalcUtil.getCellText("A3"));
		assertEquals("Date",CalcUtil.getCellText("B3"));
		sleep(1);

		DataPilotColumnArea.click(1,1);
		DataPilotColumnArea.openContextMenu();
		menuItem("Move Down").select();
		assertEquals("Name",CalcUtil.getCellText("C1"));
		assertEquals("Locale",CalcUtil.getCellText("D1"));
		sleep(1);

		DataPilotPaneRowArea.click(1,30);
		DataPilotPaneRowArea.openContextMenu();
		menuItem("Move Up").select();
		assertEquals("Order Number",CalcUtil.getCellText("A3"));
		assertEquals("Date",CalcUtil.getCellText("B3"));
		sleep(1);

		CalcUtil.selectRange("A33");
		ActiveMsgBox.yes();
		assertEquals("Name",CalcUtil.getCellText("D1"));
		assertEquals("Locale",CalcUtil.getCellText("C1"));
		assertEquals("Order Number",CalcUtil.getCellText("B3"));
		assertEquals("Date",CalcUtil.getCellText("A3"));
		assertEquals("Sum - Amount",CalcUtil.getCellText("A1"));
		assertEquals("32779.17",CalcUtil.getCellInput("K30"));
		DataPilotAutomaticallyUpdateCheckBox.check();
		sleep(1);
	}

	/**
	 * 
	 * Verify that DP panel will be synchronized with table while move fields on panel.
	 */
	@Ignore("DataPilot in symphony is totally not the same in AOO")
	public void testMoveFieldToOtherAreaAutoUpdate() {
		String file = testFile("source_data01.ods");
		startcenter.menuItem("File->Open...").select();
		submitOpenDlg(file);
		sleep(2);
		CalcUtil.selectRange("A1:E27");
		calc.menuItem("Data->DataPilot->Start...").select();
		CreateDataPilotTableDialog.ok();
		if(DataPilotAutomaticallyUpdateCheckBox.isChecked()==false){
			DataPilotAutomaticallyUpdateCheckBox.check();

		}
		assertEquals("New DataPilot Table",CalcUtil.getCellText("B2"));
		assertEquals("Use the DataPilot panel to assign fields to areas in the DataPilot table.",CalcUtil.getCellText("B4"));
		assertEquals("The DataPilot panel automatically displays when the DataPilot table has focus.",CalcUtil.getCellText("B5"));
		assertEquals("Page Area",CalcUtil.getCellText("B7"));
		assertEquals("Row Area",CalcUtil.getCellText("B10"));
		assertEquals("Column Area",CalcUtil.getCellText("D9"));
		assertEquals("Data Area",CalcUtil.getCellText("D11"));
		sleep(1);

		DataPilotFieldSelect.click(1, 1);
		DataPilotFieldSelect.openContextMenu();
		menuItem("Add to Column").select();
		assertEquals("Locale",CalcUtil.getCellText("A1"));
		sleep(1);

		DataPilotFieldSelect.click(1,30);
		DataPilotFieldSelect.openContextMenu();
		menuItem("Add to Column").select();
		assertEquals("Name",CalcUtil.getCellText("B1"));
		sleep(1);

		DataPilotFieldSelect.click(1,50);
		DataPilotFieldSelect.openContextMenu();
		menuItem("Add to Row").select();
		assertEquals("Date",CalcUtil.getCellText("A3"));
		sleep(1);

		DataPilotFieldSelect.click(1,70);
		DataPilotFieldSelect.openContextMenu();
		menuItem("Add to Row").select();
		assertEquals("Order Number",CalcUtil.getCellText("B3"));
		sleep(1);

		DataPilotFieldSelect.click(1,90);
		DataPilotFieldSelect.openContextMenu();
		menuItem("Add to Data by->Sum").select();
		assertEquals("Sum - Amount",CalcUtil.getCellText("A1"));
		assertEquals("32779.17",CalcUtil.getCellInput("K30"));
		sleep(1);

		DataPilotPaneRowArea.drag(1,1, 1, -50);
		assertEquals("Date",CalcUtil.getCellText("D1"));
		assertEquals("32779.17",CalcUtil.getCellInput("AB31"));
		sleep(1);

		DataPilotColumnArea.click(1,50);
		DataPilotColumnArea.openContextMenu();
		menuItem("Move to Row").select();
		assertEquals("Date",CalcUtil.getCellText("B3"));
		assertEquals("32779.17",CalcUtil.getCellInput("K30"));
		sleep(1);

		typeKeys("<$undo>");
		assertEquals("Date",CalcUtil.getCellText("D1"));
		assertEquals("32779.17",CalcUtil.getCellInput("AB31"));
		sleep(1);

		typeKeys("<$redo>");
		assertEquals("Date",CalcUtil.getCellText("B3"));
		assertEquals("32779.17",CalcUtil.getCellInput("K30"));
	}

	/**
	 * 
	 * Verify that DP panel will be synchronized with table while move fields on panel.
	 */
	@Ignore("DataPilot in symphony is totally not the same in AOO")
	public void testMoveFieldToOtherAreaDiscardChange() {
		String file = testFile("source_data01.ods");
		startcenter.menuItem("File->Open...").select();
		submitOpenDlg(file);
		sleep(2);
		CalcUtil.selectRange("A1:E27");
		calc.menuItem("Data->DataPilot->Start...").select();
		CreateDataPilotTableDialog.ok();
		if(DataPilotAutomaticallyUpdateCheckBox.isChecked()==false){
			DataPilotAutomaticallyUpdateCheckBox.check();

		}
		assertEquals("New DataPilot Table",CalcUtil.getCellText("B2"));
		assertEquals("Use the DataPilot panel to assign fields to areas in the DataPilot table.",CalcUtil.getCellText("B4"));
		assertEquals("The DataPilot panel automatically displays when the DataPilot table has focus.",CalcUtil.getCellText("B5"));
		assertEquals("Page Area",CalcUtil.getCellText("B7"));
		assertEquals("Row Area",CalcUtil.getCellText("B10"));
		assertEquals("Column Area",CalcUtil.getCellText("D9"));
		assertEquals("Data Area",CalcUtil.getCellText("D11"));
		sleep(1);

		DataPilotFieldSelect.click(1, 1);
		DataPilotFieldSelect.openContextMenu();
		menuItem("Add to Column").select();
		assertEquals("Locale",CalcUtil.getCellText("A1"));
		sleep(1);

		DataPilotFieldSelect.click(1,30);
		DataPilotFieldSelect.openContextMenu();
		menuItem("Add to Column").select();
		assertEquals("Name",CalcUtil.getCellText("B1"));
		sleep(1);

		DataPilotFieldSelect.click(1,50);
		DataPilotFieldSelect.openContextMenu();
		menuItem("Add to Row").select();
		assertEquals("Date",CalcUtil.getCellText("A3"));
		sleep(1);

		DataPilotFieldSelect.click(1,70);
		DataPilotFieldSelect.openContextMenu();
		menuItem("Add to Row").select();
		assertEquals("Order Number",CalcUtil.getCellText("B3"));
		sleep(1);

		DataPilotFieldSelect.click(1,90);
		DataPilotFieldSelect.openContextMenu();
		menuItem("Add to Data by->Sum").select();
		assertEquals("Sum - Amount",CalcUtil.getCellText("A1"));
		assertEquals("32779.17",CalcUtil.getCellInput("K30"));
		sleep(1);

		DataPilotAutomaticallyUpdateCheckBox.uncheck();

		DataPilotPaneRowArea.drag(1,1, 1, -50);
		assertEquals("Date",CalcUtil.getCellText("A3"));
		assertEquals("32779.17",CalcUtil.getCellInput("K30"));
		sleep(1);

		CalcUtil.selectRange("B33");
		ActiveMsgBox.yes();
		assertEquals("Date",CalcUtil.getCellText("D1"));
		assertEquals("32779.17",CalcUtil.getCellInput("AB31"));
		sleep(1);

		DataPilotColumnArea.click(1,50);
		DataPilotColumnArea.openContextMenu();
		menuItem("Move to Row").select();
		assertEquals("Date",CalcUtil.getCellText("D1"));
		assertEquals("32779.17",CalcUtil.getCellInput("AB31"));

		CalcUtil.selectRange("B33");
		ActiveMsgBox.yes();
		assertEquals("Date",CalcUtil.getCellText("B3"));
		assertEquals("32779.17",CalcUtil.getCellInput("K30"));
		sleep(1);

		DataPilotAutomaticallyUpdateCheckBox.check();
	}

	/**
	 * 
	 * Verify that DP panel will be synchronized with table while move table.
	 * After the field name get changed, when you refresh the data, the DataPilot table will change to empty table
	 * if you create table small than the empty table, the table size will get larger
	 * if there is another DataPilot table exist in the larger range, there will pop a warning.
	 */
	@Ignore("DataPilot in symphony is totally not the same in AOO")
	public void testMoveTableNarrowSpaceToShowTheTable() {
		String file = testFile("source_data01.ods");
		startcenter.menuItem("File->Open...").select();
		submitOpenDlg(file);
		sleep(2);
		CalcUtil.selectRange("A1:E27");
		calc.menuItem("Data->DataPilot->Start...").select();
		CreateDataPilotTableDialog.ok();
		assertEquals("New DataPilot Table",CalcUtil.getCellText("B2"));
		assertEquals("Use the DataPilot panel to assign fields to areas in the DataPilot table.",CalcUtil.getCellText("B4"));
		assertEquals("The DataPilot panel automatically displays when the DataPilot table has focus.",CalcUtil.getCellText("B5"));
		assertEquals("Page Area",CalcUtil.getCellText("B7"));
		assertEquals("Row Area",CalcUtil.getCellText("B10"));
		assertEquals("Column Area",CalcUtil.getCellText("D9"));
		assertEquals("Data Area",CalcUtil.getCellText("D11"));

		if(DataPilotAutomaticallyUpdateCheckBox.isChecked()==false){
			DataPilotAutomaticallyUpdateCheckBox.check();
		}

		DataPilotFieldSelect.click(1, 1);
		DataPilotFieldSelect.openContextMenu();
		menuItem("Add to Page").select();
		assertEquals("Locale",CalcUtil.getCellText("A1"));
		sleep(1);

		CalcUtil.selectRange("A1:B4");
		typeKeys("<$copy>");
		CalcUtil.selectRange("C1");
		typeKeys("<$paste>");
		sleep(1);

		CalcUtil.selectRange("$A.A1");
		typeKeys("New Locale" + "<enter>");

		CalcUtil.selectRange("$DataPilot_A_1.A1");
		SpreadSheetCells.openContextMenu();
		menuItem("Refresh Data").select();
		ActiveMsgBox.ok();

		CalcUtil.selectRange("A1:B4");
		SpreadSheetCells.drag(80, 45, 80, 350);

		assertEquals("New DataPilot Table",CalcUtil.getCellText("B20"));
		assertEquals("Use the DataPilot panel to assign fields to areas in the DataPilot table.",CalcUtil.getCellText("B22"));
		assertEquals("The DataPilot panel automatically displays when the DataPilot table has focus.",CalcUtil.getCellText("B23"));
		assertEquals("Page Area",CalcUtil.getCellText("B25"));
		assertEquals("Row Area",CalcUtil.getCellText("B28"));
		assertEquals("Column Area",CalcUtil.getCellText("D27"));
		assertEquals("Data Area",CalcUtil.getCellText("D29"));
		DataPilotPanel.close();
		sleep(1);

		CalcUtil.selectRange("C1:D4");
		SpreadSheetCells.drag(210, 50, 10, 50);
		assertEquals("New DataPilot Table",CalcUtil.getCellText("B2"));
		assertEquals("Use the DataPilot panel to assign fields to areas in the DataPilot table.",CalcUtil.getCellText("B4"));
		assertEquals("The DataPilot panel automatically displays when the DataPilot table has focus.",CalcUtil.getCellText("B5"));
		assertEquals("Page Area",CalcUtil.getCellText("B7"));
		assertEquals("Row Area",CalcUtil.getCellText("B10"));
		assertEquals("Column Area",CalcUtil.getCellText("D9"));
		assertEquals("Data Area",CalcUtil.getCellText("D11"));
	}

	/**
	 * 
	 * Verify the data pilot result table refresh after source data changed
	 */
	@Ignore("DataPilot in symphony is totally not the same in AOO")
	public void testOneMRowDataPilotRefresh() {
		String file = testFile("source_data01.ods");
		startcenter.menuItem("File->Open...").select();
		submitOpenDlg(file);
		sleep(2);
		calc.maximize();
		CalcUtil.selectRange("A1:E27");
		typeKeys("<$copy>");
		CalcUtil.selectRange("A1048540");
		typeKeys("<$paste>");
		calc.menuItem("Data->DataPilot->Start...").select();
		DataPilotTableToExistPlaceRadioButton.check();
		assertTrue(DataPilotTableToExistPlaceRadioButton.isChecked());
		DataPilotTableToExistPlaceEditBox.setText("$A.$F$1048540");
		CreateDataPilotTableDialog.ok();
		sleep(1);
		if(DataPilotAutomaticallyUpdateCheckBox.isChecked()==false){
			DataPilotAutomaticallyUpdateCheckBox.check();

		}
		DataPilotFieldSelect.click(1, 1);
		DataPilotFieldSelect.openContextMenu();
		menuItem("Add to Page").select();
		assertEquals("Locale",CalcUtil.getCellText("F1048540"));
		sleep(1);

		DataPilotFieldSelect.click(1,30);
		DataPilotFieldSelect.openContextMenu();
		menuItem("Add to Column").select();
		assertEquals("Name",CalcUtil.getCellText("F1048542"));
		sleep(1);

		DataPilotFieldSelect.click(1,50);
		DataPilotFieldSelect.openContextMenu();
		menuItem("Add to Row").select();
		assertEquals("Date",CalcUtil.getCellText("F1048543"));
		sleep(1);

		DataPilotFieldSelect.click(1,70);
		DataPilotFieldSelect.openContextMenu();
		menuItem("Add to Data by->Sum").select();
		assertEquals("Sum - Order Number",CalcUtil.getCellText("F1048542"));
		assertEquals("266773",CalcUtil.getCellText("O1048562"));
		sleep(1);

		CalcUtil.selectRange("D1048541");
		typeKeys("10000<enter>");
		sleep(1);

		CalcUtil.selectRange("O1048562");
		calc.menuItem("Data->DataPilot->Refresh").select();
		assertEquals("266525",CalcUtil.getCellText("O1048562"));
	}

	/**
	 * 
	 * Verify that DP panel will be synchronized with table while remove fields on panel.
	 */
	@Ignore("DataPilot in symphony is totally not the same in AOO")
	public void testRemoveFieldsDiscardChange() {
		String file = testFile("source_data01.ods");
		startcenter.menuItem("File->Open...").select();
		submitOpenDlg(file);
		sleep(2);
		CalcUtil.selectRange("A1:E27");
		calc.menuItem("Data->DataPilot->Start...").select();
		CreateDataPilotTableDialog.ok();
		assertEquals("New DataPilot Table",CalcUtil.getCellText("B2"));
		assertEquals("Use the DataPilot panel to assign fields to areas in the DataPilot table.",CalcUtil.getCellText("B4"));
		assertEquals("The DataPilot panel automatically displays when the DataPilot table has focus.",CalcUtil.getCellText("B5"));
		assertEquals("Page Area",CalcUtil.getCellText("B7"));
		assertEquals("Row Area",CalcUtil.getCellText("B10"));
		assertEquals("Column Area",CalcUtil.getCellText("D9"));
		assertEquals("Data Area",CalcUtil.getCellText("D11"));

		if(DataPilotAutomaticallyUpdateCheckBox.isChecked()==false){
			DataPilotAutomaticallyUpdateCheckBox.check();
		}

		DataPilotFieldSelect.click(1, 1);
		DataPilotFieldSelect.openContextMenu();
		menuItem("Add to Page").select();
		assertEquals("Locale",CalcUtil.getCellText("A1"));
		sleep(1);

		DataPilotFieldSelect.click(1,30);
		DataPilotFieldSelect.openContextMenu();
		menuItem("Add to Column").select();
		assertEquals("Name",CalcUtil.getCellText("A3"));
		sleep(1);

		DataPilotFieldSelect.click(1,50);
		DataPilotFieldSelect.openContextMenu();
		menuItem("Add to Row").select();
		assertEquals("Date",CalcUtil.getCellText("A4"));
		sleep(1);

		DataPilotFieldSelect.click(1,70);
		DataPilotFieldSelect.openContextMenu();
		menuItem("Add to Data by->Sum").select();
		assertEquals("Sum - Order Number",CalcUtil.getCellText("A3"));
		assertEquals("266773",CalcUtil.getCellText("J23"));
		sleep(1);

		DataPilotAutomaticallyUpdateCheckBox.uncheck();

		DataPilotColumnArea.drag(1, 1, -30, 1);
		assertEquals("Name",CalcUtil.getCellText("B3"));
		assertEquals("266773",CalcUtil.getCellText("J23"));
		sleep(1);

		DataPilotPaneRowArea.click(1,1);
		DataPilotPaneRowArea.openContextMenu();
		menuItem("Remove").select();
		assertEquals("Date",CalcUtil.getCellText("A4"));
		assertEquals("266773",CalcUtil.getCellText("J23"));
		sleep(1);

		DataPilotPanePageArea.drag(1, 1, -30, 1);
		assertEquals("Locale",CalcUtil.getCellText("A1"));
		assertEquals("266773",CalcUtil.getCellText("J23"));
		sleep(1);

		DataPiloPaneDataArea.openContextMenu();
		menuItem("Remove").select();
		assertEquals("Sum - Order Number",CalcUtil.getCellText("A3"));
		assertEquals("266773",CalcUtil.getCellText("J23"));

		CalcUtil.selectRange("B25");
		ActiveMsgBox.yes();
		assertEquals("New DataPilot Table",CalcUtil.getCellText("B2"));
		assertEquals("Use the DataPilot panel to assign fields to areas in the DataPilot table.",CalcUtil.getCellText("B4"));
		assertEquals("The DataPilot panel automatically displays when the DataPilot table has focus.",CalcUtil.getCellText("B5"));
		assertEquals("Page Area",CalcUtil.getCellText("B7"));
		assertEquals("Row Area",CalcUtil.getCellText("B10"));
		assertEquals("Column Area",CalcUtil.getCellText("D9"));
		assertEquals("Data Area",CalcUtil.getCellText("D11"));

		DataPilotAutomaticallyUpdateCheckBox.check();
	}

	/**
	 * 
	 * Verify the Remove function of Grouped field 
	 */
	@Ignore("DataPilot in symphony is totally not the same in AOO")
	public void testRemoveFunctionOfGroupedField() {
		String file = testFile("source_data01.ods");
		startcenter.menuItem("File->Open...").select();
		submitOpenDlg(file);
		sleep(2);
		CalcUtil.selectRange("A1:E27");
		calc.menuItem("Data->DataPilot->Start...").select();		
		CreateDataPilotTableDialog.ok();
		assertEquals("New DataPilot Table",CalcUtil.getCellText("B2"));
		assertEquals("Use the DataPilot panel to assign fields to areas in the DataPilot table.",CalcUtil.getCellText("B4"));
		assertEquals("The DataPilot panel automatically displays when the DataPilot table has focus.",CalcUtil.getCellText("B5"));
		assertEquals("Page Area",CalcUtil.getCellText("B7"));
		assertEquals("Row Area",CalcUtil.getCellText("B10"));
		assertEquals("Column Area",CalcUtil.getCellText("D9"));
		assertEquals("Data Area",CalcUtil.getCellText("D11"));

		if(DataPilotAutomaticallyUpdateCheckBox.isChecked()==false){
			DataPilotAutomaticallyUpdateCheckBox.check();
		}

		DataPilotFieldSelect.click(1, 1);
		DataPilotFieldSelect.openContextMenu();
		menuItem("Add to Page").select();
		assertEquals("Locale",CalcUtil.getCellText("A1"));
		sleep(1);

		DataPilotFieldSelect.click(1,30);
		DataPilotFieldSelect.openContextMenu();
		menuItem("Add to Column").select();
		assertEquals("Name",CalcUtil.getCellText("A3"));
		sleep(1);

		DataPilotFieldSelect.click(1,50);
		DataPilotFieldSelect.openContextMenu();
		menuItem("Add to Row").select();
		assertEquals("Date",CalcUtil.getCellText("A4"));
		sleep(1);

		DataPilotFieldSelect.click(1,70);
		DataPilotFieldSelect.openContextMenu();
		menuItem("Add to Data by->Sum").select();
		assertEquals("Sum - Order Number",CalcUtil.getCellText("A3"));
		assertEquals("266773",CalcUtil.getCellText("J23"));
		sleep(1);

		CalcUtil.selectRange("B4:C4");
		SpreadSheetCells.openContextMenu();
		menuItem("Group->Group Selected Items").select();
		assertEquals("Name2",CalcUtil.getCellText("B3"));
		assertEquals("Name",CalcUtil.getCellText("C3"));
		assertEquals("Group1",CalcUtil.getCellText("D4"));
		assertEquals("266773",CalcUtil.getCellText("J24"));
		sleep(1);

		CalcUtil.selectRange("D4");
		SpreadSheetCells.openContextMenu();
		menuItem("Group->Ungroup").select();
		assertEquals("Name",CalcUtil.getCellText("B3"));
		assertEquals("",CalcUtil.getCellText("C3"));
		assertEquals("Bill Zhang",CalcUtil.getCellText("D4"));
		assertEquals("266773",CalcUtil.getCellText("J23"));
	}

	/**
	 * 
	 * Verify that DP panel will be synchronized with table while rename fields on panel.
	 */
	@Ignore("DataPilot in symphony is totally not the same in AOO")
	public void testRenameFieldAutoUpdate() {
		String file = testFile("source_data01.ods");
		startcenter.menuItem("File->Open...").select();
		submitOpenDlg(file);
		sleep(2);
		CalcUtil.selectRange("A1:E27");
		calc.menuItem("Data->DataPilot->Start...").select();
		CreateDataPilotTableDialog.ok();
		assertEquals("New DataPilot Table",CalcUtil.getCellText("B2"));
		assertEquals("Use the DataPilot panel to assign fields to areas in the DataPilot table.",CalcUtil.getCellText("B4"));
		assertEquals("The DataPilot panel automatically displays when the DataPilot table has focus.",CalcUtil.getCellText("B5"));
		assertEquals("Page Area",CalcUtil.getCellText("B7"));
		assertEquals("Row Area",CalcUtil.getCellText("B10"));
		assertEquals("Column Area",CalcUtil.getCellText("D9"));
		assertEquals("Data Area",CalcUtil.getCellText("D11"));

		if(DataPilotAutomaticallyUpdateCheckBox.isChecked()==false){
			DataPilotAutomaticallyUpdateCheckBox.check();
		}

		DataPilotFieldSelect.click(1, 1);
		DataPilotFieldSelect.openContextMenu();
		menuItem("Add to Page").select();
		assertEquals("Locale",CalcUtil.getCellText("A1"));
		sleep(1);

		DataPilotFieldSelect.click(1,30);
		DataPilotFieldSelect.openContextMenu();
		menuItem("Add to Column").select();
		assertEquals("Name",CalcUtil.getCellText("A3"));
		sleep(1);

		DataPilotFieldSelect.click(1,50);
		DataPilotFieldSelect.openContextMenu();
		menuItem("Add to Row").select();
		assertEquals("Date",CalcUtil.getCellText("A4"));
		sleep(1);

		DataPilotFieldSelect.click(1,70);
		DataPilotFieldSelect.openContextMenu();
		menuItem("Add to Data by->Sum").select();
		assertEquals("Sum - Order Number",CalcUtil.getCellText("A3"));
		assertEquals("266773",CalcUtil.getCellText("J23"));
		sleep(1);

		DataPilotPanePageArea.click(1,1);
		DataPilotPanePageArea.openContextMenu();
		menuItem("Field Option").select();
		DataPilotFieldDisplayNameEditBox.setText("New Locale");
		DataPilotFieldOptionFieldTabPageDialog.ok();
		assertEquals("New Locale",CalcUtil.getCellText("A1"));
		sleep(1);

		typeKeys("<$undo>");
		assertEquals("Locale",CalcUtil.getCellText("A1"));
		sleep(1);

		typeKeys("<$redo>");
		assertEquals("New Locale",CalcUtil.getCellText("A1"));
		sleep(1);

		CalcUtil.selectRange("B3");
		SpreadSheetCells.openContextMenu();
		menuItem("Field Option...").select();
		DataPilotFieldDisplayNameEditBox.setText("New Name");
		DataPilotFieldOptionFieldTabPageDialog.ok();
		assertEquals("New Name",CalcUtil.getCellText("B3"));
		sleep(1);

		typeKeys("<$undo>");
		assertEquals("Name",CalcUtil.getCellText("B3"));
		sleep(1);

		typeKeys("<$redo>");
		assertEquals("New Name",CalcUtil.getCellText("B3"));
		sleep(1);

		CalcUtil.selectRange("A4");
		SpreadSheetCells.openContextMenu();
		menuItem("Field Option...").select();
		DataPilotFieldDisplayNameEditBox.setText("New Date");
		DataPilotFieldOptionFieldTabPageDialog.ok();
		assertEquals("New Date",CalcUtil.getCellText("A4"));
		sleep(1);

		typeKeys("<$undo>");
		assertEquals("Date",CalcUtil.getCellText("A4"));
		sleep(1);

		typeKeys("<$redo>");
		assertEquals("New Date",CalcUtil.getCellText("A4"));
		sleep(1);

		DataPiloPaneDataArea.openContextMenu();
		menuItem("Field Option").select();
		DataPilotFieldDisplayNameEditBox.setText("New Sum - Order Number");
		DataPilotFieldOptionFieldTabPageDialog.ok();
		assertEquals("New Sum - Order Number",CalcUtil.getCellText("A3"));
		sleep(1);

		typeKeys("<$undo>");
		assertEquals("Sum - Order Number",CalcUtil.getCellText("A3"));
		sleep(1);

		typeKeys("<$redo>");
		assertEquals("New Sum - Order Number",CalcUtil.getCellText("A3"));
		sleep(1);
	}

	/**
	 * 
	 * Verify that DP panel will be synchronized with table while add fields on panel.
	 */
	@Ignore("DataPilot in symphony is totally not the same in AOO")
	public void testSortFunctionInGroupedField() {
		String file = testFile("source_data01.ods");
		startcenter.menuItem("File->Open...").select();
		submitOpenDlg(file);
		sleep(2);
		CalcUtil.selectRange("A1:E27");
		calc.menuItem("Data->DataPilot->Start...").select();		
		CreateDataPilotTableDialog.ok();
		assertEquals("New DataPilot Table",CalcUtil.getCellText("B2"));
		assertEquals("Use the DataPilot panel to assign fields to areas in the DataPilot table.",CalcUtil.getCellText("B4"));
		assertEquals("The DataPilot panel automatically displays when the DataPilot table has focus.",CalcUtil.getCellText("B5"));
		assertEquals("Page Area",CalcUtil.getCellText("B7"));
		assertEquals("Row Area",CalcUtil.getCellText("B10"));
		assertEquals("Column Area",CalcUtil.getCellText("D9"));
		assertEquals("Data Area",CalcUtil.getCellText("D11"));

		if(DataPilotAutomaticallyUpdateCheckBox.isChecked()==false){
			DataPilotAutomaticallyUpdateCheckBox.check();
		}

		DataPilotFieldSelect.click(1, 1);
		DataPilotFieldSelect.openContextMenu();
		menuItem("Add to Page").select();
		assertEquals("Locale",CalcUtil.getCellText("A1"));
		sleep(1);

		DataPilotFieldSelect.click(1,30);
		DataPilotFieldSelect.openContextMenu();
		menuItem("Add to Column").select();
		assertEquals("Name",CalcUtil.getCellText("A3"));
		sleep(1);

		DataPilotFieldSelect.click(1,50);
		DataPilotFieldSelect.openContextMenu();
		menuItem("Add to Row").select();
		assertEquals("Date",CalcUtil.getCellText("A4"));
		sleep(1);

		DataPilotFieldSelect.click(1,70);
		DataPilotFieldSelect.openContextMenu();
		menuItem("Add to Data by->Sum").select();
		assertEquals("Sum - Order Number",CalcUtil.getCellText("A3"));
		assertEquals("266773",CalcUtil.getCellText("J23"));
		sleep(1);

		CalcUtil.selectRange("B4:C4");
		SpreadSheetCells.openContextMenu();
		menuItem("Group->Group Selected Items").select();
		assertEquals("Name2",CalcUtil.getCellText("B3"));
		assertEquals("Name",CalcUtil.getCellInput("C3"));
		assertEquals("Group1",CalcUtil.getCellText("D4"));
		assertEquals("266773",CalcUtil.getCellText("J24"));
		sleep(1);

		CalcUtil.selectRange("B3");
		SpreadSheetCells.openContextMenu();
		menuItem("Field Option...").select();
		DataPilotFieldOptionSortTabPageDialog.select();

		DataPilotFieldOptionSortDescendingRadioButton.check();
		DataPilotFieldOptionFieldTabPageDialog.select();
		DataPilotFieldOptionFieldTabPageDialog.ok();
		sleep(1);

		assertEquals("Kevin Wang",CalcUtil.getCellText("B4"));
		assertEquals("Group1",CalcUtil.getCellText("F4"));
		assertEquals("Bill Zhang",CalcUtil.getCellText("I4"));
		assertEquals("266773",CalcUtil.getCellText("J24"));

		typeKeys("<$undo>");
		assertEquals("Bill Zhang",CalcUtil.getCellText("B4"));
		assertEquals("Group1",CalcUtil.getCellText("D4"));
		assertEquals("Kevin Wang",CalcUtil.getCellText("I4"));
		assertEquals("266773",CalcUtil.getCellText("J24"));
		sleep(1);

		typeKeys("<$redo>");
		assertEquals("Kevin Wang",CalcUtil.getCellText("B4"));
		assertEquals("Group1",CalcUtil.getCellText("F4"));
		assertEquals("Bill Zhang",CalcUtil.getCellText("I4"));
		assertEquals("266773",CalcUtil.getCellText("J24"));
	}

	/**
	 * 
	 * Verify that DP panel will be synchronized with table while add fields on panel.
	 */
	@Ignore("DataPilot in symphony is totally not the same in AOO")
	public void testSubtotalsFunctionInGroupedField() {
		String file = testFile("source_data01.ods");
		startcenter.menuItem("File->Open...").select();
		submitOpenDlg(file);
		sleep(2);
		CalcUtil.selectRange("A1:E27");
		calc.menuItem("Data->DataPilot->Start...").select();		
		CreateDataPilotTableDialog.ok();
		assertEquals("New DataPilot Table",CalcUtil.getCellText("B2"));
		assertEquals("Use the DataPilot panel to assign fields to areas in the DataPilot table.",CalcUtil.getCellText("B4"));
		assertEquals("The DataPilot panel automatically displays when the DataPilot table has focus.",CalcUtil.getCellText("B5"));
		assertEquals("Page Area",CalcUtil.getCellText("B7"));
		assertEquals("Row Area",CalcUtil.getCellText("B10"));
		assertEquals("Column Area",CalcUtil.getCellText("D9"));
		assertEquals("Data Area",CalcUtil.getCellText("D11"));

		if(DataPilotAutomaticallyUpdateCheckBox.isChecked()==false){
			DataPilotAutomaticallyUpdateCheckBox.check();
		}

		DataPilotFieldSelect.click(1, 1);
		DataPilotFieldSelect.openContextMenu();
		menuItem("Add to Page").select();
		assertEquals("Locale",CalcUtil.getCellText("A1"));
		sleep(1);

		DataPilotFieldSelect.click(1,30);
		DataPilotFieldSelect.openContextMenu();
		menuItem("Add to Column").select();
		assertEquals("Name",CalcUtil.getCellText("A3"));
		sleep(1);

		DataPilotFieldSelect.click(1,50);
		DataPilotFieldSelect.openContextMenu();
		menuItem("Add to Row").select();
		assertEquals("Date",CalcUtil.getCellText("A4"));
		sleep(1);

		DataPilotFieldSelect.click(1,70);
		DataPilotFieldSelect.openContextMenu();
		menuItem("Add to Data by->Sum").select();
		assertEquals("Sum - Order Number",CalcUtil.getCellText("A3"));
		assertEquals("266773",CalcUtil.getCellText("J23"));
		sleep(1);

		CalcUtil.selectRange("B4:C4");
		SpreadSheetCells.openContextMenu();
		menuItem("Group->Group Selected Items").select();
		assertEquals("Name2",CalcUtil.getCellText("B3"));
		assertEquals("Name",CalcUtil.getCellText("C3"));
		assertEquals("Group1",CalcUtil.getCellText("D4"));
		assertEquals("266773",CalcUtil.getCellText("J24"));
		sleep(1);

		CalcUtil.selectRange("B3");
		SpreadSheetCells.openContextMenu();
		menuItem("Field Option...").select();
		DataPilotFieldOptionFiledSubtotalsPage.select();
		sleep(1);

		DataPilotFieldOptionSubTotalsManuallyRadioButton.check();

		SC_DataPilotOptionSubtotalFunctionList.click(9,24);
		sleep(1);
		DataPilotFieldOptionFieldTabPageDialog.select();
		DataPilotFieldOptionFieldTabPageDialog.ok();

		assertEquals("Bill Zhang Count - Order Number",CalcUtil.getCellText("C4"));
		assertEquals("5",CalcUtil.getCellText("C24"));

		assertEquals("Emmy Ma Count - Order Number",CalcUtil.getCellText("E4"));
		assertEquals("2",CalcUtil.getCellText("E24"));

		assertEquals("Group1 Count - Order Number",CalcUtil.getCellText("H4"));
		assertEquals("9",CalcUtil.getCellText("H24"));

		assertEquals("Harry Wu Count - Order Number",CalcUtil.getCellText("J4"));
		assertEquals("1",CalcUtil.getCellText("J24"));

		assertEquals("Jerry Lu Count - Order Number",CalcUtil.getCellText("L4"));
		assertEquals("2",CalcUtil.getCellText("L24"));

		assertEquals("Joe Liu Count - Order Number",CalcUtil.getCellText("N4"));
		assertEquals("4",CalcUtil.getCellText("N24"));

		assertEquals("Kevin Wang Count - Order Number",CalcUtil.getCellText("P4"));
		assertEquals("3",CalcUtil.getCellText("P24"));
		assertEquals("266773",CalcUtil.getCellText("Q24"));
		sleep(1);

		typeKeys("<$undo>");
		assertEquals("Emmy Ma",CalcUtil.getCellText("C4"));
		assertEquals("20518",CalcUtil.getCellText("C24"));

		assertEquals("",CalcUtil.getCellText("E4"));
		assertEquals("20528",CalcUtil.getCellText("E24"));

		assertEquals("Joe Liu",CalcUtil.getCellText("H4"));
		assertEquals("41056",CalcUtil.getCellText("H24"));

		assertEquals("Total Result",CalcUtil.getCellText("J4"));
		assertEquals("266773",CalcUtil.getCellText("J24"));

		assertEquals("",CalcUtil.getCellText("L4"));
		assertEquals("",CalcUtil.getCellText("L24"));

		assertEquals("",CalcUtil.getCellText("N4"));
		assertEquals("",CalcUtil.getCellText("N24"));

		assertEquals("",CalcUtil.getCellText("P4"));
		assertEquals("",CalcUtil.getCellText("P24"));
		assertEquals("",CalcUtil.getCellText("Q24"));
		sleep(1);

		typeKeys("<$redo>");
		assertEquals("Bill Zhang Count - Order Number",CalcUtil.getCellText("C4"));
		assertEquals("5",CalcUtil.getCellText("C24"));

		assertEquals("Emmy Ma Count - Order Number",CalcUtil.getCellText("E4"));
		assertEquals("2",CalcUtil.getCellText("E24"));

		assertEquals("Group1 Count - Order Number",CalcUtil.getCellText("H4"));
		assertEquals("9",CalcUtil.getCellText("H24"));

		assertEquals("Harry Wu Count - Order Number",CalcUtil.getCellText("J4"));
		assertEquals("1",CalcUtil.getCellText("J24"));

		assertEquals("Jerry Lu Count - Order Number",CalcUtil.getCellText("L4"));
		assertEquals("2",CalcUtil.getCellText("L24"));

		assertEquals("Joe Liu Count - Order Number",CalcUtil.getCellText("N4"));
		assertEquals("4",CalcUtil.getCellText("N24"));

		assertEquals("Kevin Wang Count - Order Number",CalcUtil.getCellText("P4"));
		assertEquals("3",CalcUtil.getCellText("P24"));
		assertEquals("266773",CalcUtil.getCellText("Q24"));
	}

	/**
	 * 
	 * Verify that DP panel will be synchronized with table while add fields on panel.
	 */
	@Ignore("DataPilot in symphony is totally not the same in AOO")
	public void testTopNFunctionInGroupedField() {
		String file = testFile("source_data01.ods");
		startcenter.menuItem("File->Open...").select();
		submitOpenDlg(file);
		sleep(2);
		CalcUtil.selectRange("A1:E27");
		calc.menuItem("Data->DataPilot->Start...").select();		
		CreateDataPilotTableDialog.ok();
		assertEquals("New DataPilot Table",CalcUtil.getCellText("B2"));
		assertEquals("Use the DataPilot panel to assign fields to areas in the DataPilot table.",CalcUtil.getCellText("B4"));
		assertEquals("The DataPilot panel automatically displays when the DataPilot table has focus.",CalcUtil.getCellText("B5"));
		assertEquals("Page Area",CalcUtil.getCellText("B7"));
		assertEquals("Row Area",CalcUtil.getCellText("B10"));
		assertEquals("Column Area",CalcUtil.getCellText("D9"));
		assertEquals("Data Area",CalcUtil.getCellText("D11"));

		if(DataPilotAutomaticallyUpdateCheckBox.isChecked()==false){
			DataPilotAutomaticallyUpdateCheckBox.check();
		}

		DataPilotFieldSelect.click(1, 1);
		DataPilotFieldSelect.openContextMenu();
		menuItem("Add to Page").select();
		assertEquals("Locale",CalcUtil.getCellText("A1"));
		sleep(1);

		DataPilotFieldSelect.click(1,30);
		DataPilotFieldSelect.openContextMenu();
		menuItem("Add to Column").select();
		assertEquals("Name",CalcUtil.getCellText("A3"));
		sleep(1);

		DataPilotFieldSelect.click(1,50);
		DataPilotFieldSelect.openContextMenu();
		menuItem("Add to Row").select();
		assertEquals("Date",CalcUtil.getCellText("A4"));
		sleep(1);

		DataPilotFieldSelect.click(1,70);
		DataPilotFieldSelect.openContextMenu();
		menuItem("Add to Data by->Sum").select();
		assertEquals("Sum - Order Number",CalcUtil.getCellInput("A3"));
		assertEquals("266773",CalcUtil.getCellText("J23"));
		sleep(1);

		CalcUtil.selectRange("B4:C4");
		SpreadSheetCells.openContextMenu();
		menuItem("Group->Group Selected Items").select();
		assertEquals("Name2",CalcUtil.getCellText("B3"));
		assertEquals("Name",CalcUtil.getCellText("C3"));
		assertEquals("Group1",CalcUtil.getCellText("D4"));
		assertEquals("266773",CalcUtil.getCellText("J24"));
		sleep(1);

		CalcUtil.selectRange("A1");
		sleep(1);

		// the Display resolution is 1280 * 1050 on windows and Linux and 1920 * 1080 on Mac
		if(SystemUtil.isWindows()){
			SpreadSheetCells.click(238, 43);
		}
		else if(SystemUtil.isLinux()){
			SpreadSheetCells.click(267, 43);
		}
		else if(SystemUtil.isMac()){
			SpreadSheetCells.click(238, 43);
		}

		typeKeys("<tab>");
		typeKeys("<tab>");
		typeKeys("<tab>");
		typeKeys("<tab>");
		typeKeys("<tab>");
		typeKeys("<tab>");
		typeKeys("<enter>");
		OnlyDisplayTopNItemCheckBox.check();
		NumberOfItemShowInTopNEditBox.setText("4");
		FieldTopNSettingDialog.ok();
		sleep(1);

		assertEquals("Bill Zhang",CalcUtil.getCellText("B4"));
		assertEquals("51299",CalcUtil.getCellText("B24"));

		assertEquals("Group1",CalcUtil.getCellText("C4"));
		assertEquals("71806",CalcUtil.getCellText("C24"));
		assertEquals("",CalcUtil.getCellText("D4"));
		assertEquals("Amy Zhao",CalcUtil.getCellText("C5"));
		assertEquals("Anne Lee",CalcUtil.getCellText("D5"));
		assertEquals("20528",CalcUtil.getCellText("D24"));

		assertEquals("Joe Liu",CalcUtil.getCellText("E4"));
		assertEquals("41056",CalcUtil.getCellText("E24"));

		assertEquals("Kevin Wang",CalcUtil.getCellText("F4"));
		assertEquals("30771",CalcUtil.getCellText("F24"));

		assertEquals("Total Result",CalcUtil.getCellText("G4"));
		assertEquals("215460",CalcUtil.getCellText("G24"));
		sleep(1);

		typeKeys("<$undo>");
		assertEquals("Name2",CalcUtil.getCellText("B3"));
		assertEquals("Name",CalcUtil.getCellText("C3"));
		assertEquals("Group1",CalcUtil.getCellText("D4"));
		assertEquals("266773",CalcUtil.getCellText("J24"));

		assertEquals("Bill Zhang",CalcUtil.getCellText("B4"));
		assertEquals("51299",CalcUtil.getCellText("B24"));

		assertEquals("Emmy Ma",CalcUtil.getCellText("C4"));
		assertEquals("20518",CalcUtil.getCellText("C24"));
		assertEquals("Group1",CalcUtil.getCellText("D4"));
		assertEquals("Emmy Ma",CalcUtil.getCellText("C5"));
		assertEquals("Amy Zhao",CalcUtil.getCellText("D5"));
		assertEquals("71806",CalcUtil.getCellText("D24"));

		assertEquals("",CalcUtil.getCellText("E4"));
		assertEquals("20528",CalcUtil.getCellText("E24"));

		assertEquals("Harry Wu",CalcUtil.getCellText("F4"));
		assertEquals("10265",CalcUtil.getCellText("F24"));

		assertEquals("Jerry Lu",CalcUtil.getCellText("G4"));
		assertEquals("20530",CalcUtil.getCellText("G24"));

		assertEquals("Total Result",CalcUtil.getCellText("J4"));
		assertEquals("266773",CalcUtil.getCellText("J24"));
		sleep(1);

		typeKeys("<$redo>");
		assertEquals("Bill Zhang",CalcUtil.getCellText("B4"));
		assertEquals("51299",CalcUtil.getCellText("B24"));

		assertEquals("Group1",CalcUtil.getCellText("C4"));
		assertEquals("71806",CalcUtil.getCellText("C24"));
		assertEquals("",CalcUtil.getCellText("D4"));
		assertEquals("Amy Zhao",CalcUtil.getCellText("C5"));
		assertEquals("Anne Lee",CalcUtil.getCellText("D5"));
		assertEquals("20528",CalcUtil.getCellText("D24"));

		assertEquals("Joe Liu",CalcUtil.getCellText("E4"));
		assertEquals("41056",CalcUtil.getCellText("E24"));

		assertEquals("Kevin Wang",CalcUtil.getCellText("F4"));
		assertEquals("30771",CalcUtil.getCellText("F24"));

		assertEquals("Total Result",CalcUtil.getCellText("G4"));
		assertEquals("215460",CalcUtil.getCellText("G24"));
	}	
}




/**************************************************************
 * 
 * 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 testcase.sc.validity;

import static testlib.UIMap.*;
import org.junit.After;
import static org.junit.Assert.*;
import org.junit.Before;
import org.junit.Rule;
import org.junit.Test;
import testlib.Log;


public class ValidityDialogDefaultValue {

	@Rule
	public Log LOG = new Log();

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

		// New a spreadsheet, open Validity dialog
		startcenter.menuItem("File->New->Spreadsheet").select();
		calc.menuItem("Data->Validity...").select();
	}

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

	/**
	 * test Data -> Validity - UI(Criteria: Cell range).
	 */
	@Test
	public void testValidityUICellRange() {

		SC_ValidityCriteriaTabpage.select();
		SC_ValidityCriteriaAllowList.select("Cell range");

		assertEquals(true,SC_ValidityAllowBlankCells.isChecked());
		assertEquals(true,SC_ValidityShowSelectionList.isChecked());
		assertEquals(false,SC_ValiditySortEntriesAscending.isChecked());
		assertEquals(true,SC_ValidityAllowBlankCells.isEnabled());
		assertEquals(true,SC_ValiditySortEntriesAscending.isEnabled());
		assertEquals(true,SC_ValiditySortEntriesAscending.isEnabled());
		assertEquals(true,SC_ValiditySourcePicker.isEnabled());
	}

	/**
	 * test Data -> Validity - UI(Error Alert: Default status)
	 */
	@Test
	public void testValidityUIErrorAlert() {

		SC_ValidityErrorAlertTabPage.select();
		assertEquals(true,SC_ValidityErrorAlertActionList.isEnabled());
		assertEquals("Stop",SC_ValidityErrorAlertActionList.getSelText());
		assertEquals(true,SC_ValidityErrorMessageTitle.isEnabled());
		assertEquals("",SC_ValidityErrorMessageTitle.getText());
		assertEquals(true,SC_ValidityErrorMessage.isEnabled());
		assertEquals("",SC_ValidityErrorMessage.getText());
		SC_ValidityErrorAlertActionList.select("Macro");
		assertEquals(true,SC_ValidityErrorBrowseButton.isEnabled());
	}

}





/**************************************************************
 * 
 * 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 testcase.sd.headerandfooter;

import static testlib.AppUtil.fullPath;
import static testlib.AppUtil.openStartcenter;
import static testlib.AppUtil.submitOpenDlg;
import static testlib.AppUtil.submitSaveDlg;
import static testlib.UIMap.*;
import static org.junit.Assert.*;
import static org.openoffice.test.vcl.Tester.*;
import org.junit.After;
import org.junit.Before;
import org.junit.Rule;
import org.junit.Test;
import org.openoffice.test.common.FileUtil;
import testlib.ImpressUtil;
import testlib.Log;

public class HeaderAndFooterSetting{

	@Rule
	public Log LOG = new Log();

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

		// New a impress, insert some slides
		app.dispatch("private:factory/simpress?slot=6686");
		PresentationWizard.ok();
		sleep(1);

		for(int i=0; i<5;i++){
			SD_InsertPageButtonOnToolbar.click();
			sleep(1);
		}
		// Pop up navigator panel
		impress.menuItem("View").select();
		if(!impress.menuItem("View->Navigator").isSelected()){
			impress.menuItem("View->Navigator").select();
		}
	}

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

	/**
	 * Test Copy slide with Apply Footer to same file and different file
	 * @throws Exception
	 */
	@Test
	public void testCopySlideWithApplyFooter() throws Exception{

		//add header and footer
		impress.menuItem("View->Header and Footer...").select();
		sleep(2);

		SD_DateAndTimeFooterOnSlide.check();
		SD_FixedDateAndTimeFooterOnSlide.check();
		SD_FixedDateAndTimeOnSlideInput.setText("Fix Date: 20120323");
		SD_FooterTextOnSlide.check();
		SD_FooterTextOnSlideInput.setText("Footer Test");
		SD_SlideNumAsFooterOnSlide.check();
		SD_ApplyToAllButtonOnSlideFooter.click();
		sleep(1);

		ImpressSlideSorter.focus();
		for(int j=0; j<=2;j++){
			typeKeys("<up>");
		}
		impress.menuItem("View->Header and Footer...").select();
		sleep(1);
		SD_SlideNumAsFooterOnSlide.uncheck();
		SD_ApplyButtonOnSlideFooter.click();

		//paste to the same file
		ImpressSlideSorter.focus();
		app.dispatch(".uno:Copy");
		app.dispatch(".uno:Paste");

		impress.menuItem("View->Header and Footer...").select();
		sleep(1);
		assertEquals("Fix Date: 20120323", SD_FixedDateAndTimeOnSlideInput.getText());
		assertEquals("Footer Test", SD_FooterTextOnSlideInput.getText());
		assertEquals(false, SD_SlideNumAsFooterOnSlide.isChecked());

		//close header and footer dialog.
		SD_ApplyButtonOnSlideFooter.focus();
		typeKeys("<tab>");
		typeKeys("<enter>");

		//paste to different file
		impress.focus();
		app.dispatch("private:factory/simpress?slot=6686");
		PresentationWizard.ok();
		sleep(1);
		app.dispatch(".uno:Paste");
		ImpressSlideSorter.focus();
		typeKeys("<down>");
		sleep(1);

		impress.menuItem("View->Header and Footer...").select();
		sleep(1);
		assertEquals("Fix Date: 20120323", SD_FixedDateAndTimeOnSlideInput.getText());
		assertEquals("Footer Test", SD_FooterTextOnSlideInput.getText());
		assertEquals(false, SD_SlideNumAsFooterOnSlide.isChecked());
	}

	/**
	 * Test Copy slide with Apply to all Footer to same file and different file
	 * @throws Exception
	 */
	@Test
	public void testCopySlideWithApplyToAllFooter() throws Exception{

		//add header and footer
		impress.menuItem("View->Header and Footer...").select();
		sleep(2);

		SD_DateAndTimeFooterOnSlide.check();
		SD_FixedDateAndTimeFooterOnSlide.check();
		sleep(1);
		SD_FixedDateAndTimeOnSlideInput.setText("Fix Date: 20120323");
		sleep(1);
		SD_FooterTextOnSlide.check();
		sleep(1);
		SD_FooterTextOnSlideInput.setText("Footer Test");
		sleep(1);
		SD_SlideNumAsFooterOnSlide.check();
		sleep(1);
		SD_ApplyToAllButtonOnSlideFooter.click();
		sleep(1);

		ImpressSlideSorter.focus();
		for(int j=0; j<=2;j++){
			typeKeys("<up>");
			sleep(1);
		}
		impress.menuItem("View->Header and Footer...").select();
		sleep(1);
		SD_SlideNumAsFooterOnSlide.uncheck();
		SD_ApplyButtonOnSlideFooter.click();

		//paste to the same file
		ImpressSlideSorter.focus();
		typeKeys("<up>");
		app.dispatch(".uno:Copy");
		typeKeys("<down>");
		sleep(1);
		app.dispatch(".uno:Paste");

		impress.menuItem("View->Header and Footer...").select();
		sleep(1);
		assertEquals("Fix Date: 20120323",SD_FixedDateAndTimeOnSlideInput.getText());
		assertEquals("Footer Test",SD_FooterTextOnSlideInput.getText());
		assertEquals(true,SD_SlideNumAsFooterOnSlide.isChecked());

		//close header and footer dialog.
		SD_ApplyButtonOnSlideFooter.focus();
		typeKeys("<tab>");
		typeKeys("<enter>");

		//paste to different file
		impress.focus();
		impress.menuItem("File->New->Presentation").select();
		sleep(1);
		app.dispatch(".uno:Paste");
		ImpressSlideSorter.focus();
		typeKeys("<down>");
		sleep(1);

		impress.menuItem("View->Header and Footer...").select();
		sleep(1);
		assertEquals("Fix Date: 20120323",SD_FixedDateAndTimeOnSlideInput.getText());
		assertEquals("Footer Test",SD_FooterTextOnSlideInput.getText());
		assertEquals(true,SD_SlideNumAsFooterOnSlide.isChecked());
	}

	/**
	 * Test Copy slide with Notes Footer to same file and different file
	 * @throws Exception
	 */
	@Test
	public void testCopySlideWithNotesHeaderFooter() throws Exception{

		//add header and footer
		impress.menuItem("View->Header and Footer...").select();
		sleep(1);
		SD_HeaderAndFooterOnNotesTabPage.select();
		SD_HeaderTextOnNotes.check();
		SD_HeaderTextOnNotesInput.setText("Header Test");
		SD_DateAndTimeFooterOnSlide.check();
		SD_FixedDateAndTimeFooterOnSlide.check();
		sleep(1);
		SD_FixedDateAndTimeOnSlideInput.setText("Fix Date: 20120329");
		sleep(1);
		SD_FooterTextOnSlide.check();
		sleep(1);
		SD_FooterTextOnSlideInput.setText("Footer Test");
		sleep(1);
		SD_SlideNumAsFooterOnSlide.check();
		sleep(1);
		SD_ApplyToAllButtonOnSlideFooter.click();
		sleep(1);

		//paste to the same file
		ImpressSlideSorter.focus();
		typeKeys("<up>");
		app.dispatch(".uno:Copy");
		typeKeys("<down>");
		sleep(1);
		app.dispatch(".uno:Paste");

		ImpressUtil.getCurView().activate();

		impress.menuItem("View->Header and Footer...").select();
		sleep(1);
		SD_HeaderAndFooterOnNotesTabPage.select();
		assertEquals("Header Test",SD_HeaderTextOnNotesInput.getText());
		assertEquals("Fix Date: 20120329",SD_FixedDateAndTimeOnSlideInput.getText());
		assertEquals("Footer Test",SD_FooterTextOnSlideInput.getText());
		assertEquals(true,SD_SlideNumAsFooterOnSlide.isChecked());

		//close header and footer dialog.
		SD_ApplyToAllButtonOnSlideFooter.focus();
		typeKeys("<tab>");
		typeKeys("<enter>");

		//paste to different file
		impress.focus();
		impress.menuItem("File->New->Presentation").select();
		sleep(1);
		app.dispatch(".uno:Paste");
		ImpressSlideSorter.focus();
		typeKeys("<down>");
		sleep(1);
		ImpressUtil.getCurView().activate();
		impress.menuItem("View->Header and Footer...").select();
		sleep(1);
		SD_HeaderAndFooterOnNotesTabPage.select();
		assertEquals("Header Test",SD_HeaderTextOnNotesInput.getText());
		assertEquals("Fix Date: 20120329",SD_FixedDateAndTimeOnSlideInput.getText());
		assertEquals("Footer Test",SD_FooterTextOnSlideInput.getText());
		assertEquals(true,SD_SlideNumAsFooterOnSlide.isChecked());
	}

	/**
	 * Test duplicate slide with Apply to all Footer to same file 
	 * @throws Exception
	 */
	@Test
	public void testDuplicateSlideWithApplyToAllFooter() throws Exception{

		//add header and footer
		impress.menuItem("View->Header and Footer...").select();
		sleep(2);

		SD_DateAndTimeFooterOnSlide.check();
		SD_FixedDateAndTimeFooterOnSlide.check();
		sleep(1);
		SD_FixedDateAndTimeOnSlideInput.setText("Fix Date: 20120323");
		sleep(1);
		SD_FooterTextOnSlide.check();
		sleep(1);
		SD_FooterTextOnSlideInput.setText("Footer Test");
		sleep(1);
		SD_SlideNumAsFooterOnSlide.check();
		sleep(1);
		SD_ApplyToAllButtonOnSlideFooter.click();
		sleep(1);


		ImpressSlideSorter.focus();
		for(int j=0; j<=2;j++){
			typeKeys("<up>");
			sleep(1);
		}
		impress.menuItem("Insert->Duplicate Slide").select();
		impress.menuItem("View->Header and Footer...").select();
		sleep(1);
		assertEquals("Fix Date: 20120323",SD_FixedDateAndTimeOnSlideInput.getText());
		assertEquals("Footer Test",SD_FooterTextOnSlideInput.getText());
		assertEquals(true,SD_SlideNumAsFooterOnSlide.isChecked());
	}

	/**
	 * Test footer not show on the first slide. 
	 * @throws Exception
	 */
	@Test
	public void testFooterNotShowOn1stSlide() throws Exception{

		//add header and footer
		impress.menuItem("View->Header and Footer...").select();
		sleep(2);
		SD_FooterTextOnSlide.check();
		sleep(1);
		SD_FooterTextOnSlideInput.setText("Footer Test");
		sleep(1);
		SD_FooterNotShowOn1stSlide.check();
		SD_ApplyToAllButtonOnSlideFooter.click();
		sleep(1);

		ImpressSlideSorter.focus();
		for(int j=0; j<5; j++){
			typeKeys("<up>");
		}

		impress.menuItem("View->Header and Footer...").select();
		sleep(1);
		assertEquals(true,SD_FooterNotShowOn1stSlide.isChecked());
		assertEquals(false,SD_FooterTextOnSlide.isChecked());
	}

	/**
	 * Test Insert Footer to focus slide.
	 * @throws Exception
	 */
	@Test
	public void testInsertApplyFooterOnSlide() throws Exception{

		//add header and footer to focus slide.
		impress.menuItem("View->Header and Footer...").select();
		sleep(2);

		SD_DateAndTimeFooterOnSlide.check();
		SD_FixedDateAndTimeFooterOnSlide.check();
		sleep(1);
		SD_FixedDateAndTimeOnSlideInput.setText("Fix Date: 20120323");
		sleep(1);
		SD_FooterTextOnSlide.check();
		sleep(1);
		SD_FooterTextOnSlideInput.setText("Footer Test");
		sleep(1);
		SD_SlideNumAsFooterOnSlide.check();
		sleep(1);
		SD_ApplyButtonOnSlideFooter.click();
		sleep(1);

		impress.menuItem("View->Header and Footer...").select();
		sleep(1);
		assertEquals(true,SD_DateAndTimeFooterOnSlide.isChecked());
		assertEquals(true,SD_FixedDateAndTimeFooterOnSlide.isChecked());
		assertEquals("Fix Date: 20120323",SD_FixedDateAndTimeOnSlideInput.getText());
		assertEquals(true,SD_FooterTextOnSlide.isChecked());
		assertEquals("Footer Test",SD_FooterTextOnSlideInput.getText());
		assertEquals(true,SD_SlideNumAsFooterOnSlide.isChecked());
		//close header and footer dialog.
		SD_ApplyButtonOnSlideFooter.focus();
		typeKeys("<tab>");
		typeKeys("<enter>");
		//end close

		ImpressSlideSorter.focus();
		typeKeys("<up>");

		impress.menuItem("View->Header and Footer...").select();
		sleep(1);
		assertEquals("",SD_FixedDateAndTimeOnSlideInput.getText());
		assertEquals("",SD_FooterTextOnSlideInput.getText());
		assertEquals(false,SD_SlideNumAsFooterOnSlide.isChecked());
		//close header and footer dialog.
		SD_ApplyButtonOnSlideFooter.focus();
		typeKeys("<tab>");
		typeKeys("<enter>");
		//end close

		SD_InsertPageButtonOnToolbar.click();
		impress.menuItem("View->Header and Footer...").select();
		sleep(1);
		assertEquals("",SD_FixedDateAndTimeOnSlideInput.getText());
		assertEquals("",SD_FooterTextOnSlideInput.getText());
		assertEquals(false,SD_SlideNumAsFooterOnSlide.isChecked());
	}

	/**
	 * Test Insert Footer to Notes View
	 * @throws Exception
	 */
	@Test
	public void testInsertApplyToAllFooterOnNotes() throws Exception{

		//add header and footer to focus slide.
		impress.menuItem("View->Header and Footer...").select();
		sleep(1);
		SD_HeaderAndFooterOnNotesTabPage.select();
		SD_HeaderTextOnNotes.check();
		SD_HeaderTextOnNotesInput.setText("Header Test");
		SD_DateAndTimeFooterOnSlide.check();
		SD_FixedDateAndTimeFooterOnSlide.check();
		sleep(1);
		SD_FixedDateAndTimeOnSlideInput.setText("Fix Date: 20120323");
		sleep(1);
		SD_FooterTextOnSlide.check();
		sleep(1);
		SD_FooterTextOnSlideInput.setText("Footer Test");
		sleep(1);
		SD_SlideNumAsFooterOnSlide.check();
		sleep(1);
		SD_ApplyToAllButtonOnSlideFooter.click();
		sleep(1);

		impress.menuItem("View->Header and Footer...").select();
		sleep(1);
		SD_HeaderAndFooterOnNotesTabPage.select();
		assertEquals(true,SD_HeaderTextOnNotes.isChecked());
		assertEquals("Header Test",SD_HeaderTextOnNotesInput.getText());
		assertEquals(true,SD_DateAndTimeFooterOnSlide.isChecked());
		assertEquals(true,SD_FixedDateAndTimeFooterOnSlide.isChecked());
		assertEquals("Fix Date: 20120323",SD_FixedDateAndTimeOnSlideInput.getText());
		assertEquals(true,SD_FooterTextOnSlide.isChecked());
		assertEquals("Footer Test",SD_FooterTextOnSlideInput.getText());
		assertEquals(true,SD_SlideNumAsFooterOnSlide.isChecked());
		//close header and footer dialog.
		SD_ApplyToAllButtonOnSlideFooter.focus();
		typeKeys("<tab>");
		typeKeys("<enter>");
		//end close

		ImpressSlideSorter.focus();
		typeKeys("<up>");

		impress.menuItem("View->Header and Footer...").select();
		sleep(1);
		SD_HeaderAndFooterOnNotesTabPage.select();
		assertEquals(true,SD_HeaderTextOnNotes.isChecked());
		assertEquals("Header Test",SD_HeaderTextOnNotesInput.getText());
		assertEquals(true,SD_DateAndTimeFooterOnSlide.isChecked());
		assertEquals(true,SD_FixedDateAndTimeFooterOnSlide.isChecked());
		assertEquals("Fix Date: 20120323",SD_FixedDateAndTimeOnSlideInput.getText());
		assertEquals(true,SD_FooterTextOnSlide.isChecked());
		assertEquals("Footer Test",SD_FooterTextOnSlideInput.getText());
		assertEquals(true,SD_SlideNumAsFooterOnSlide.isChecked());
		//close header and footer dialog.
		SD_ApplyToAllButtonOnSlideFooter.focus();
		typeKeys("<tab>");
		typeKeys("<enter>");
		//end close

		SD_InsertPageButtonOnToolbar.click();
		impress.menuItem("View->Header and Footer...").select();
		sleep(1);
		SD_HeaderAndFooterOnNotesTabPage.select();
		assertEquals(true,SD_HeaderTextOnNotes.isChecked());
		assertEquals("Header Test",SD_HeaderTextOnNotesInput.getText());
		assertEquals(true,SD_DateAndTimeFooterOnSlide.isChecked());
		assertEquals(true,SD_FixedDateAndTimeFooterOnSlide.isChecked());
		assertEquals("Fix Date: 20120323",SD_FixedDateAndTimeOnSlideInput.getText());
		assertEquals(true,SD_FooterTextOnSlide.isChecked());
		assertEquals("Footer Test",SD_FooterTextOnSlideInput.getText());
		assertEquals(true,SD_SlideNumAsFooterOnSlide.isChecked());
	}

	/**
	 * Test Insert Footer to Slide, use Apply to All
	 * @throws Exception
	 */
	@Test
	public void testInsertApplyToAllFooterOnSlide() throws Exception{

		//add header and footer to focus slide.
		impress.menuItem("View->Header and Footer...").select();
		sleep(2);

		SD_DateAndTimeFooterOnSlide.check();
		SD_FixedDateAndTimeFooterOnSlide.check();
		sleep(1);
		SD_FixedDateAndTimeOnSlideInput.setText("Fix Date: 20120323");
		sleep(1);
		SD_FooterTextOnSlide.check();
		sleep(1);
		SD_FooterTextOnSlideInput.setText("Footer Test");
		sleep(1);
		SD_SlideNumAsFooterOnSlide.check();
		sleep(1);
		SD_ApplyToAllButtonOnSlideFooter.click();
		sleep(1);

		impress.menuItem("View->Header and Footer...").select();
		sleep(1);
		assertEquals(true,SD_DateAndTimeFooterOnSlide.isChecked());
		assertEquals(true,SD_FixedDateAndTimeFooterOnSlide.isChecked());
		assertEquals("Fix Date: 20120323",SD_FixedDateAndTimeOnSlideInput.getText());
		assertEquals(true,SD_FooterTextOnSlide.isChecked());
		assertEquals("Footer Test",SD_FooterTextOnSlideInput.getText());
		assertEquals(true,SD_SlideNumAsFooterOnSlide.isChecked());
		//close header and footer dialog.
		SD_ApplyButtonOnSlideFooter.focus();
		typeKeys("<tab>");
		typeKeys("<enter>");
		//end close

		ImpressSlideSorter.focus();
		typeKeys("<up>");

		impress.menuItem("View->Header and Footer...").select();
		sleep(1);
		assertEquals(true,SD_DateAndTimeFooterOnSlide.isChecked());
		assertEquals(true,SD_FixedDateAndTimeFooterOnSlide.isChecked());
		assertEquals("Fix Date: 20120323",SD_FixedDateAndTimeOnSlideInput.getText());
		assertEquals(true,SD_FooterTextOnSlide.isChecked());
		assertEquals("Footer Test",SD_FooterTextOnSlideInput.getText());
		assertEquals(true,SD_SlideNumAsFooterOnSlide.isChecked());
		//close header and footer dialog.
		SD_ApplyButtonOnSlideFooter.focus();
		typeKeys("<tab>");
		typeKeys("<enter>");
		//end close

		SD_InsertPageButtonOnToolbar.click();
		impress.menuItem("View->Header and Footer...").select();
		sleep(1);
		assertEquals(true,SD_DateAndTimeFooterOnSlide.isChecked());
		assertEquals(true,SD_FixedDateAndTimeFooterOnSlide.isChecked());
		assertEquals("Fix Date: 20120323",SD_FixedDateAndTimeOnSlideInput.getText());
		assertEquals(true,SD_FooterTextOnSlide.isChecked());
		assertEquals("Footer Test",SD_FooterTextOnSlideInput.getText());
		assertEquals(true,SD_SlideNumAsFooterOnSlide.isChecked());
	}

	/**
	 * Test Insert update automatically time footer to slides.
	 * @throws Exception
	 */
	@Test
	public void testInsertAutoUpdateTimeFooter() throws Exception{

		//add header and footer
		impress.menuItem("View->Header and Footer...").select();
		sleep(1);
		SD_AutoUpdateTimeFooter.check();
		SD_AutoUpdateTimeFooterType.select(7);
		String currentTime=SD_AutoUpdateTimeFooterType.getItemText(7);
		SD_ApplyToAllButtonOnSlideFooter.click();
		sleep(2);

		impress.menuItem("View->Header and Footer...").select();
		sleep(1);

		String currentTime2=SD_AutoUpdateTimeFooterType.getItemText(7);
		assertFalse(currentTime.equals(currentTime2));
	}

	/**
	 * Test Insert update automatically time footer to Notes view.
	 * @throws Exception
	 */
	@Test
	public void testInsertAutoUpdateTimeFooterOnNotes() throws Exception{

		//add header and footer
		impress.menuItem("View->Header and Footer...").select();
		sleep(1);
		SD_HeaderAndFooterOnNotesTabPage.select();
		SD_AutoUpdateTimeFooter.check();
		SD_AutoUpdateTimeFooterType.select(7);
		String currentTime=SD_AutoUpdateTimeFooterType.getItemText(7);
		SD_ApplyToAllButtonOnSlideFooter.click();
		sleep(2);

		impress.menuItem("View->Header and Footer...").select();
		sleep(1);
		SD_HeaderAndFooterOnNotesTabPage.select();
		String currentTime2=SD_AutoUpdateTimeFooterType.getItemText(7);

		assertFalse(currentTime.equals(currentTime2));
	}

	/**
	 * Test Insert Header and Footer to Notes view.
	 * Save and ReOpen
	 * @throws Exception
	 */
	@Test
	public void testInsertHeaderFooterOnNotes() throws Exception{

		//add header and footer
		impress.menuItem("View->Header and Footer...").select();
		sleep(1);
		SD_HeaderAndFooterOnNotesTabPage.select();
		SD_HeaderTextOnNotes.check();
		SD_HeaderTextOnNotesInput.setText("Header Test");
		SD_DateAndTimeFooterOnSlide.check();
		SD_FixedDateAndTimeFooterOnSlide.check();
		sleep(1);
		SD_FixedDateAndTimeOnSlideInput.setText("Fix Date: 20120329");
		sleep(1);
		SD_FooterTextOnSlide.check();
		sleep(1);
		SD_FooterTextOnSlideInput.setText("Footer Test");
		sleep(1);
		SD_SlideNumAsFooterOnSlide.check();
		sleep(1);
		SD_ApplyToAllButtonOnSlideFooter.click();
		sleep(1);

		ImpressSlideSorter.focus();
		typeKeys("<up>");

		impress.menuItem("View->Header and Footer...").select();
		sleep(1);
		SD_HeaderAndFooterOnNotesTabPage.select();
		assertEquals("Header Test",SD_HeaderTextOnNotesInput.getText());
		assertEquals("Fix Date: 20120329",SD_FixedDateAndTimeOnSlideInput.getText());
		assertEquals("Footer Test",SD_FooterTextOnSlideInput.getText());
		assertEquals(true,SD_SlideNumAsFooterOnSlide.isChecked());

		//close header and footer dialog.
		SD_ApplyToAllButtonOnSlideFooter.focus();
		typeKeys("<tab>");
		typeKeys("<enter>");

		//save this file
		impress.menuItem("File->Save").select();
		String saveTo = fullPath("temp/" + "hello.odp");
		FileUtil.deleteFile(saveTo);
		submitSaveDlg(saveTo);	
		impress.menuItem("File->Close").select();
		sleep(2);

		//Reopen this file
		openStartcenter();
		app.dispatch(".uno:Open");
		String openFrom=fullPath("temp/" + "hello.odp");
		submitOpenDlg(openFrom);

		//check after reopen		
		impress.menuItem("View->Header and Footer...").select();
		sleep(1);
		SD_HeaderAndFooterOnNotesTabPage.select();
		assertEquals("Header Test",SD_HeaderTextOnNotesInput.getText());
		assertEquals("Fix Date: 20120329",SD_FixedDateAndTimeOnSlideInput.getText());
		assertEquals("Footer Test",SD_FooterTextOnSlideInput.getText());
		assertEquals(true,SD_SlideNumAsFooterOnSlide.isChecked());
	}

	/**
	 * Test Insert Header and Footer to Slide
	 * Save and Reopen
	 * @throws Exception
	 */
	@Test
	public void testInsertHeaderFooterOnSlide() throws Exception{

		//add header and footer
		impress.menuItem("View->Header and Footer...").select();
		sleep(1);
		SD_DateAndTimeFooterOnSlide.check();
		SD_FixedDateAndTimeFooterOnSlide.check();
		sleep(1);
		SD_FixedDateAndTimeOnSlideInput.setText("Fix Date: 20120329");
		sleep(1);
		SD_FooterTextOnSlide.check();
		sleep(1);
		SD_FooterTextOnSlideInput.setText("Footer Test");
		sleep(1);
		SD_SlideNumAsFooterOnSlide.check();
		sleep(1);
		SD_ApplyToAllButtonOnSlideFooter.click();
		sleep(1);

		ImpressSlideSorter.focus();
		typeKeys("<up>");

		impress.menuItem("View->Header and Footer...").select();
		sleep(1);
		assertEquals("Fix Date: 20120329",SD_FixedDateAndTimeOnSlideInput.getText());
		assertEquals("Footer Test",SD_FooterTextOnSlideInput.getText());
		assertEquals(true,SD_SlideNumAsFooterOnSlide.isChecked());

		//close header and footer dialog.
		SD_ApplyButtonOnSlideFooter.focus();
		typeKeys("<tab>");
		typeKeys("<enter>");

		//save this file
		impress.menuItem("File->Save").select();
		String saveTo = fullPath("temp/" + "hello.odp");
		FileUtil.deleteFile(saveTo);
		submitSaveDlg(saveTo);	
		impress.menuItem("File->Close").select();
		sleep(2);

		//Reopen this file
		openStartcenter();
		app.dispatch(".uno:Open");
		String openFrom=fullPath("temp/" + "hello.odp");
		submitOpenDlg(openFrom);

		//check after reopen		
		impress.menuItem("View->Header and Footer...").select();
		sleep(1);
		assertEquals("Fix Date: 20120329",SD_FixedDateAndTimeOnSlideInput.getText());
		assertEquals("Footer Test",SD_FooterTextOnSlideInput.getText());
		assertEquals(true,SD_SlideNumAsFooterOnSlide.isChecked());
	}
}

Return to issue 120321

Line 0 Link Here

(-)src/testcase/sc/validity/ValiditySampleFile.java (+116 lines)
		1	/**************************************************************
		2	*
		3	* Licensed to the Apache Software Foundation (ASF) under one
		4	* or more contributor license agreements. See the NOTICE file
		5	* distributed with this work for additional information
		6	* regarding copyright ownership. The ASF licenses this file
		7	* to you under the Apache License, Version 2.0 (the
		8	* "License"); you may not use this file except in compliance
		9	* with the License. You may obtain a copy of the License at
		10	*
		11	* http://www.apache.org/licenses/LICENSE-2.0
		12	*
		13	* Unless required by applicable law or agreed to in writing,
		14	* software distributed under the License is distributed on an
		15	* "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
		16	* KIND, either express or implied. See the License for the
		17	* specific language governing permissions and limitations
		18	* under the License.
		19	*
		20	*************************************************************/
		21
		22
		23
		24	package testcase.sc.validity;
		25
		26	import static testlib.AppUtil.submitOpenDlg;
		27	import static testlib.AppUtil.testFile;
		28	import static testlib.AppUtil.typeKeys;
		29	import static testlib.UIMap.*;
		30	import static org.junit.Assert.*;
		31	import static org.openoffice.test.vcl.Tester.typeKeys;
		32	import org.junit.After;
		33	import org.junit.Before;
		34	import org.junit.Rule;
		35	import org.junit.Test;
		36	import testlib.CalcUtil;
		37	import testlib.Log;
		38
		39	public class ValiditySampleFile {
		40
		41	@Rule
		42	public Log LOG = new Log();
		43
		44	@Before
		45	public void setUp() throws Exception {
		46	app.start();
		47	}
		48
		49	@After
		50	public void tearDown() throws Exception {
		51	app.close();
		52	}
		53
		54	/**
		55	* Test open MS 2003 spreadsheet with ignore blank validity.
		56	*
		57	* @throws Exception
		58	*/
		59	@Test
		60	public void testFFCIgnoreBlank() throws Exception{
		61	// Open sample file
		62	String file = testFile("sc/FFC252FFCSC_XML_Datarange0235.xls");
		63	app.dispatch(".uno:Open", 3);
		64	submitOpenDlg(file);
65	calc.waitForExistence(10, 2);
66
67	CalcUtil.selectRange("D5");
68	SC_InputBar_Input.activate();
69	for(int i=1;i<=10;i++)
70	typeKeys("<backspace>");
71	typeKeys("<enter>");
72
73	assertEquals("",CalcUtil.getCellText("D5"));
74	}
75
76	/**
77	* Test open MS 2003 spreadsheet with ignore blank validity.
78	*
79	* @throws Exception
80	*/
81	@Test
82	public void testFFCNotIgnoreBlank() throws Exception{
83	//open sample file
84	String file = testFile("sc/FFC252FFCSC_XML_Datarange0205.xls");
85	app.dispatch(".uno:Open", 3);
86	submitOpenDlg(file);
87	calc.waitForExistence(10, 2);
88
89	CalcUtil.selectRange("F5");
90	SC_InputBar_Input.activate();
91	typeKeys("<backspace><enter>");
92
93	assertEquals("Invalid value.",ActiveMsgBox.getMessage());
94	ActiveMsgBox.ok();
95	assertEquals("8",CalcUtil.getCellText("F5"));
96	}
97
98	/**
99	* test Cell is not locked after switch from validity cell to source cells
100	*/
101	@Test
102	public void testNotLockCellFromValidityCell() {
103	//open sample file on data path
104	String file = testFile("sc/sampledata.ods");
105	app.dispatch(".uno:Open", 3);
106	submitOpenDlg(file);
107	calc.waitForExistence(10, 2);
108
109	CalcUtil.selectRange("Sheet1.F19");
110	typeKeys("d<enter>");
111	CalcUtil.selectRange("Sheet1.F17");
112	typeKeys("Test<enter>");
113
114	assertEquals("Test",CalcUtil.getCellText("F17"));
115	}
116	}

Line 0 Link Here

(-)src/testcase/sc/validity/ValidityDialogSetting.java (+639 lines)
		1	/**************************************************************
		2	*
		3	* Licensed to the Apache Software Foundation (ASF) under one
		4	* or more contributor license agreements. See the NOTICE file
		5	* distributed with this work for additional information
		6	* regarding copyright ownership. The ASF licenses this file
		7	* to you under the Apache License, Version 2.0 (the
		8	* "License"); you may not use this file except in compliance
		9	* with the License. You may obtain a copy of the License at
		10	*
		11	* http://www.apache.org/licenses/LICENSE-2.0
		12	*
		13	* Unless required by applicable law or agreed to in writing,
		14	* software distributed under the License is distributed on an
		15	* "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
		16	* KIND, either express or implied. See the License for the
		17	* specific language governing permissions and limitations
		18	* under the License.
		19	*
		20	*************************************************************/
		21
		22
		23
		24	package testcase.sc.validity;
		25
		26	import static testlib.AppUtil.*;
		27	import static testlib.UIMap.*;
		28
		29	import java.io.File;
		30
		31	import org.junit.After;
		32	import static org.junit.Assert.*;
		33	import static org.openoffice.test.vcl.Tester.*;
		34
		35	import org.junit.Before;
		36	import org.junit.Rule;
		37	import org.junit.Ignore;
		38	import org.junit.Test;
		39	import org.openoffice.test.vcl.IDList;
		40	import org.openoffice.test.vcl.widgets.VclMessageBox;
		41
		42	import testlib.CalcUtil;
		43	import testlib.Log;
		44
		45
		46	public class ValidityDialogSetting {
		47	private static IDList idList = new IDList(new File("./ids"));
		48	public static final VclMessageBox ActiveMsgBox = new VclMessageBox(idList.getId("UID_ACTIVE"), "Message on message box.");
		49
		50	@Rule
		51	public Log LOG = new Log();
		52
		53	@Before
		54	public void setUp() throws Exception {
		55	app.start();
		56
		57	// New a spreadsheet, select cell range, open Validity dialog
		58	startcenter.menuItem("File->New->Spreadsheet").select();
		59	CalcUtil.selectRange("Sheet1.A1:C5");
		60	calc.menuItem("Data->Validity...").select();
		61	}
		62
		63	@After
		64	public void tearDown() throws Exception {
65	app.close();
66	}
67
68	/**
69	* test Allow not between Date type in Validity.
70	*/
71	@Test
72	public void testAllowDateNotBetween() {
73	SC_ValidityCriteriaTabpage.select();
74	SC_ValidityCriteriaAllowList.select("Date");
75	SC_ValidityDecimalCompareOperator.select("not between");
76	SC_ValiditySourceInput.setText("01/01/08");
77	SC_ValidityMaxValueInput.setText("03/01/08");
78	SC_ValidityErrorAlertTabPage.select();
79	SC_ValidityShowErrorMessage.check();
80	SC_ValidityErrorMessageTitle.setText("Stop to enter");
81	SC_ValidityErrorMessage.setText("Invalid value");
82	SC_ValidityErrorAlertTabPage.ok();
83
84	CalcUtil.selectRange("Sheet1.A1");
85	SC_InputBar_Input.activate();
86	typeKeys("12/31/07");
87	typeKeys("<enter>");
88	assertEquals("12/31/07",CalcUtil.getCellText("Sheet1.A1"));
89
90	CalcUtil.selectRange("Sheet1.A2");
91	SC_InputBar_Input.activate();
92	typeKeys("03/02/08");
93	typeKeys("<enter>");
94	assertEquals("03/02/08",CalcUtil.getCellText("Sheet1.A2"));
95
96	CalcUtil.selectRange("Sheet1.A3");
97	SC_InputBar_Input.activate();
98	typeKeys("01/01/08");
99	typeKeys("<enter>");
100	assertEquals("Invalid value",ActiveMsgBox.getMessage());
101	ActiveMsgBox.ok();
102	assertEquals("",CalcUtil.getCellText("Sheet1.A3"));
103
104	CalcUtil.selectRange("Sheet1.A4");
105	SC_InputBar_Input.activate();
106	typeKeys("03/01/08");
107	typeKeys("<enter>");
108	assertEquals("Invalid value",ActiveMsgBox.getMessage());
109	ActiveMsgBox.ok();
110	assertEquals("",CalcUtil.getCellText("Sheet1.A4"));
111
112	CalcUtil.selectRange("Sheet1.A5");
113	SC_InputBar_Input.activate();
114	typeKeys("01/02/08");
115	typeKeys("<enter>");
116	assertEquals("Invalid value",ActiveMsgBox.getMessage());
117	ActiveMsgBox.ok();
118	assertEquals("",CalcUtil.getCellText("Sheet1.A5"));
119
120	CalcUtil.selectRange("Sheet1.B1");
121	SC_InputBar_Input.activate();
122	typeKeys("02/29/08");
123	typeKeys("<enter>");
124	assertEquals("Invalid value",ActiveMsgBox.getMessage());
125	ActiveMsgBox.ok();
126	assertEquals("",CalcUtil.getCellText("Sheet1.B1"));
127
128	CalcUtil.selectRange("Sheet1.B2");
129	SC_InputBar_Input.activate();
130	typeKeys("test");
131	typeKeys("<enter>");
132	assertEquals("Invalid value",ActiveMsgBox.getMessage());
133	ActiveMsgBox.ok();
134	assertEquals("",CalcUtil.getCellText("Sheet1.B2"));
135
136	CalcUtil.selectRange("Sheet1.B3");
137	SC_InputBar_Input.activate();
138	typeKeys("39448");
139	typeKeys("<enter>");
140	assertEquals("Invalid value",ActiveMsgBox.getMessage());
141	ActiveMsgBox.ok();
142	assertEquals("",CalcUtil.getCellText("Sheet1.B3"));
143	}
144
145	/**
146	* test Allow Decimal equal in Validity.
147	*/
148	@Test
149	public void testAllowDecimalEqual() {
150
151	SC_ValidityCriteriaTabpage.select();
152	SC_ValidityCriteriaAllowList.select("Decimal");
153	SC_ValidityDecimalCompareOperator.select("equal");
154	SC_ValiditySourceInput.setText("0.33333333");
155	SC_ValidityErrorAlertTabPage.select();
156	SC_ValidityShowErrorMessage.check();
157	SC_ValidityErrorMessageTitle.setText("Stop to enter");
158	SC_ValidityErrorMessage.setText("Invalid value");
159	SC_ValidityErrorAlertTabPage.ok();
160
161	CalcUtil.selectRange("Sheet1.A1");
162	SC_InputBar_Input.activate();
163	typeKeys("0.33333333");
164	typeKeys("<enter>");
165	assertEquals("0.33333333",CalcUtil.getCellText("Sheet1.A1"));
166
167	CalcUtil.selectRange("Sheet1.A2");
168	SC_InputBar_Input.activate();
169	typeKeys("=1/3");
170	typeKeys("<enter>");
171	assertEquals("Invalid value",ActiveMsgBox.getMessage());
172	ActiveMsgBox.ok();
173	assertEquals("",CalcUtil.getCellText("Sheet1.A2"));
174
175	CalcUtil.selectRange("Sheet1.A3");
176	SC_InputBar_Input.activate();
177	typeKeys("0.3");
178	typeKeys("<enter>");
179	assertEquals("Invalid value",ActiveMsgBox.getMessage());
180	ActiveMsgBox.ok();
181	assertEquals("",CalcUtil.getCellText("Sheet1.A3"));
182
183	CalcUtil.selectRange("Sheet1.A4");
184	SC_InputBar_Input.activate();
185	typeKeys("0.333333333");
186	typeKeys("<enter>");
187	assertEquals("Invalid value",ActiveMsgBox.getMessage());
188	ActiveMsgBox.ok();
189	assertEquals("",CalcUtil.getCellText("Sheet1.A4"));
190
191	CalcUtil.selectRange("Sheet1.B2");
192	SC_InputBar_Input.activate();
193	typeKeys("test");
194	typeKeys("<enter>");
195	assertEquals("Invalid value",ActiveMsgBox.getMessage());
196	ActiveMsgBox.ok();
197	assertEquals("",CalcUtil.getCellText("Sheet1.B2"));
198	}
199
200	/**
201	* test Allow Text length, greater than or equal to in Validity.
202	*/
203	@Test
204	public void testAllowGreaterTextLength() {
205
206	SC_ValidityCriteriaTabpage.select();
207	SC_ValidityCriteriaAllowList.select("Text length");
208	SC_ValidityDecimalCompareOperator.select("greater than or equal to");
209	SC_ValiditySourceInput.setText("10");
210	SC_ValidityErrorAlertTabPage.select();
211	SC_ValidityShowErrorMessage.check();
212	SC_ValidityErrorMessageTitle.setText("Stop to enter");
213	SC_ValidityErrorMessage.setText("Invalid value");
214	SC_ValidityErrorAlertTabPage.ok();
215
216	CalcUtil.selectRange("Sheet1.A1");
217	SC_InputBar_Input.activate();
218	typeKeys("testtesttesttest");
219	typeKeys("<enter>");
220	assertEquals("testtesttesttest",CalcUtil.getCellText("Sheet1.A1"));
221
222	CalcUtil.selectRange("Sheet1.A2");
223	SC_InputBar_Input.activate();
224	typeKeys("test test ");
225	typeKeys("<enter>");
226	assertEquals("test test ",CalcUtil.getCellText("Sheet1.A2"));
227
228	CalcUtil.selectRange("Sheet1.A4");
229	SC_InputBar_Input.activate();
230	typeKeys(" ");
231	typeKeys("<enter>");
232	assertEquals("Invalid value",ActiveMsgBox.getMessage());
233	ActiveMsgBox.ok();
234	assertEquals("",CalcUtil.getCellText("Sheet1.A4"));
235
236	CalcUtil.selectRange("Sheet1.A3");
237	SC_InputBar_Input.activate();
238	typeKeys("Testatest");
239	typeKeys("<enter>");
240	assertEquals("Invalid value",ActiveMsgBox.getMessage());
241	ActiveMsgBox.ok();
242	assertEquals("",CalcUtil.getCellText("Sheet1.A3"));
243	}
244
245	/**
246	* test Allow Text length, less than in Validity.
247	*/
248	@Ignore("Bug 93128")
249	public void testAllowLessThanTextLength() {
250
251	calc.menuItem("Data->Validity...").select();
252
253	SC_ValidityCriteriaTabpage.select();
254	SC_ValidityCriteriaAllowList.select("Text length");
255	SC_ValidityDecimalCompareOperator.select("less than");
256	SC_ValiditySourceInput.setText("10");
257
258	SC_ValidityInputHelpTabPage.select();
259	SC_ValidityInputHelpCheckbox.check();
260	SC_ValidityInputHelpTitle.setText("Help Info Title");
261	SC_ValidityHelpMessage.setText("help info");
262
263	SC_ValidityErrorAlertTabPage.select();
264	SC_ValidityShowErrorMessage.check();
265	SC_ValidityErrorAlertActionList.select("Information");
266	SC_ValidityErrorMessageTitle.setText("Notes to enter");
267	SC_ValidityErrorMessage.setText("Invalid value");
268	SC_ValidityErrorAlertTabPage.ok();
269
270	CalcUtil.selectRange("Sheet1.A1");
271	SC_InputBar_Input.activate();
272	typeKeys("testtesttesttest<enter>");
273	ActiveMsgBox.ok();
274	assertEquals("testtesttesttest",CalcUtil.getCellText("Sheet1.A1"));
275
276	CalcUtil.selectRange("Sheet1.A2");
277	SC_InputBar_Input.activate();
278	typeKeys("sfsafsddddddd<enter>");
279	ActiveMsgBox.cancel();
280	assertEquals("",CalcUtil.getCellText("Sheet1.A2"));
281
282	CalcUtil.selectRange("Sheet1.A2");
283	SC_InputBar_Input.activate();
284	typeKeys("10<enter>");
285	assertEquals("10",CalcUtil.getCellText("Sheet1.A2"));
286
287	CalcUtil.selectRange("Sheet1.A3");
288	SC_InputBar_Input.activate();
289	typeKeys("ok<enter>");
290	assertEquals("ok",CalcUtil.getCellText("Sheet1.A3"));
291	}
292
293	/**
294	* test Allow list.
295	*/
296	@Test
297	public void testAllowListSpecialChar() {
298
299	SC_ValidityCriteriaTabpage.select();
300	SC_ValidityCriteriaAllowList.select("List");
301	SC_ValidityEntries.focus();
302	typeKeys("a");
303	typeKeys("<enter>");
304	typeKeys("b");
305	SC_ValidityErrorAlertTabPage.select();
306	SC_ValidityShowErrorMessage.check();
307	SC_ValidityErrorMessageTitle.setText("Stop to enter");
308	SC_ValidityErrorMessage.setText("Invalid value");
309	SC_ValidityCriteriaTabpage.select();
310	SC_ValidityCriteriaTabpage.ok();
311
312	calc.rightClick(1, 1);
313	typeKeys("<shift s>");
314	typeKeys("<down><enter>"); // Choose a
315	assertEquals("a",CalcUtil.getCellText("Sheet1.A1"));
316
317	CalcUtil.selectRange("Sheet1.B2");
318	SC_InputBar_Input.activate();
319	typeKeys("test");
320	typeKeys("<enter>");
321	assertEquals("Invalid value",ActiveMsgBox.getMessage());
322	ActiveMsgBox.ok();
323	assertEquals("",CalcUtil.getCellText("Sheet1.B2"));
324	}
325
326	/**
327	* test Allow time between in Validity.
328	*/
329	@Test
330	public void testAllowTimeBetween() {
331
332	SC_ValidityCriteriaTabpage.select();
333	SC_ValidityCriteriaAllowList.select("Time");
334	SC_ValidityDecimalCompareOperator.select("between");
335	SC_ValiditySourceInput.setText("27:00");
336	SC_ValidityMaxValueInput.setText("21:00");
337	SC_ValidityErrorAlertTabPage.select();
338	SC_ValidityShowErrorMessage.check();
339	SC_ValidityErrorMessageTitle.setText("Stop to enter");
340	SC_ValidityErrorMessage.setText("Invalid value");
341	SC_ValidityErrorAlertTabPage.ok();
342
343	CalcUtil.selectRange("Sheet1.A1");
344	SC_InputBar_Input.activate();
345	typeKeys("21:00");
346	typeKeys("<enter>");
347	assertEquals("09:00:00 PM",CalcUtil.getCellText("Sheet1.A1"));
348
349	CalcUtil.selectRange("Sheet1.A2");
350	SC_InputBar_Input.activate();
351	typeKeys("27:00");
352	typeKeys("<enter>");
353	assertEquals("27:00:00",CalcUtil.getCellText("Sheet1.A2"));
354
355	CalcUtil.selectRange("Sheet1.A3");
356	SC_InputBar_Input.activate();
357	typeKeys("1.125");
358	typeKeys("<enter>");
359	assertEquals("1.125",CalcUtil.getCellText("Sheet1.A3"));
360
361	CalcUtil.selectRange("Sheet1.A4");
362	SC_InputBar_Input.activate();
363	typeKeys("0.875");
364	typeKeys("<enter>");
365	assertEquals("0.875",CalcUtil.getCellText("Sheet1.A4"));
366
367	CalcUtil.selectRange("Sheet1.B1");
368	SC_InputBar_Input.activate();
369	typeKeys("03:00:01");
370	typeKeys("<enter>");
371	assertEquals("Invalid value",ActiveMsgBox.getMessage());
372	ActiveMsgBox.ok();
373	assertEquals("",CalcUtil.getCellText("Sheet1.B1"));
374
375	CalcUtil.selectRange("Sheet1.B2");
376	SC_InputBar_Input.activate();
377	typeKeys("20:59:59");
378	typeKeys("<enter>");
379	assertEquals("Invalid value",ActiveMsgBox.getMessage());
380	ActiveMsgBox.ok();
381	assertEquals("",CalcUtil.getCellText("Sheet1.B2"));
382
383	CalcUtil.selectRange("Sheet1.B3");
384	SC_InputBar_Input.activate();
385	typeKeys("1.126");
386	typeKeys("<enter>");
387	assertEquals("Invalid value",ActiveMsgBox.getMessage());
388	ActiveMsgBox.ok();
389	assertEquals("",CalcUtil.getCellText("Sheet1.B3"));
390
391	CalcUtil.selectRange("Sheet1.B4");
392	SC_InputBar_Input.activate();
393	typeKeys("0.874");
394	typeKeys("<enter>");
395	assertEquals("Invalid value",ActiveMsgBox.getMessage());
396	ActiveMsgBox.ok();
397	assertEquals("",CalcUtil.getCellText("Sheet1.B4"));
398
399	CalcUtil.selectRange("Sheet1.C1");
400	SC_InputBar_Input.activate();
401	typeKeys("test");
402	typeKeys("<enter>");
403	assertEquals("Invalid value",ActiveMsgBox.getMessage());
404	ActiveMsgBox.ok();
405	assertEquals("",CalcUtil.getCellText("Sheet1.C1"));
406
407	CalcUtil.selectRange("Sheet1.C2");
408	SC_InputBar_Input.activate();
409	typeKeys("24:00");
410	typeKeys("<enter>");
411	assertEquals("24:00:00",CalcUtil.getCellText("Sheet1.C2"));
412
413	CalcUtil.selectRange("Sheet1.C3");
414	SC_InputBar_Input.activate();
415	typeKeys("12:00");
416	typeKeys("<enter>");
417	assertEquals("Invalid value",ActiveMsgBox.getMessage());
418	ActiveMsgBox.ok();
419	assertEquals("",CalcUtil.getCellText("Sheet1.C3"));
420	}
421
422	/**
423	* test Allow time Greater than and equal to in Validity.
424	*/
425	@Test
426	public void testAllowTimeGreaterThan() {
427
428	SC_ValidityCriteriaTabpage.select();
429	SC_ValidityCriteriaAllowList.select("Time");
430	SC_ValidityDecimalCompareOperator.select("greater than or equal to");
431	SC_ValiditySourceInput.setText("8:00");
432
433	SC_ValidityErrorAlertTabPage.select();
434	SC_ValidityShowErrorMessage.check();
435	SC_ValidityErrorAlertActionList.select("Warning");
436
437	SC_ValidityErrorMessageTitle.setText("warning to enter");
438	SC_ValidityErrorMessage.setText("Invalid value");
439	SC_ValidityErrorAlertTabPage.ok();
440
441	CalcUtil.selectRange("Sheet1.A1");
442	SC_InputBar_Input.activate();
443	typeKeys("7:30");
444	typeKeys("<enter>");
445	assertEquals("Invalid value",ActiveMsgBox.getMessage());
446	ActiveMsgBox.ok();
447	assertEquals("07:30:00 AM",CalcUtil.getCellText("Sheet1.A1"));
448
449	CalcUtil.selectRange("Sheet1.A2");
450	SC_InputBar_Input.activate();
451	typeKeys("6:00");
452	typeKeys("<enter>");
453	assertEquals("Invalid value",ActiveMsgBox.getMessage());
454	ActiveMsgBox.cancel();
455	assertEquals("",CalcUtil.getCellText("Sheet1.A2"));
456
457	CalcUtil.selectRange("Sheet1.A3");
458	SC_InputBar_Input.activate();
459	typeKeys("8:00");
460	typeKeys("<enter>");
461	assertEquals("08:00:00 AM",CalcUtil.getCellText("Sheet1.A3"));
462	}
463
464	/**
465	* test Allow whole number, less than or equal to in Validity.
466	*/
467	@Test
468	public void testAllowWholeNumLessThan() {
469
470	SC_ValidityCriteriaTabpage.select();
471	SC_ValidityCriteriaAllowList.select("Whole Numbers");
472	SC_ValidityDecimalCompareOperator.select("less than or equal");
473	SC_ValiditySourceInput.setText("100");
474	SC_ValidityErrorAlertTabPage.select();
475	SC_ValidityShowErrorMessage.check();
476	SC_ValidityErrorMessageTitle.setText("Stop to enter");
477	SC_ValidityErrorMessage.setText("Invalid value");
478	SC_ValidityErrorAlertTabPage.ok();
479
480	CalcUtil.selectRange("Sheet1.A1");
481	SC_InputBar_Input.activate();
482	typeKeys("99");
483	typeKeys("<enter>");
484	assertEquals("99",CalcUtil.getCellText("Sheet1.A1"));
485
486	CalcUtil.selectRange("Sheet1.A2");
487	SC_InputBar_Input.activate();
488	typeKeys("100");
489	typeKeys("<enter>");
490	assertEquals("100",CalcUtil.getCellText("Sheet1.A2"));
491
492	CalcUtil.selectRange("Sheet1.B1");
493	SC_InputBar_Input.activate();
494	typeKeys("101");
495	typeKeys("<enter>");
496	assertEquals("Invalid value",ActiveMsgBox.getMessage());
497	ActiveMsgBox.ok();
498	assertEquals("",CalcUtil.getCellText("Sheet1.B1"));
499
500	CalcUtil.selectRange("Sheet1.B2");
501	SC_InputBar_Input.activate();
502	typeKeys("45.5");
503	typeKeys("<enter>");
504	assertEquals("Invalid value",ActiveMsgBox.getMessage());
505	ActiveMsgBox.ok();
506	assertEquals("",CalcUtil.getCellText("Sheet1.B2"));
507
508	CalcUtil.selectRange("Sheet1.C1");
509	SC_InputBar_Input.activate();
510	typeKeys("test");
511	typeKeys("<enter>");
512	assertEquals("Invalid value",ActiveMsgBox.getMessage());
513	ActiveMsgBox.ok();
514	assertEquals("",CalcUtil.getCellText("Sheet1.C1"));
515	}
516
517	/**
518	* test default message of Error Alert in Validity.
519	*/
520	@Test
521	public void testDefaultErrorAlertMessage() {
522
523	SC_ValidityCriteriaTabpage.select();
524	SC_ValidityCriteriaAllowList.select("Decimal");
525	SC_ValidityDecimalCompareOperator.select("equal");
526	SC_ValiditySourceInput.setText("1");
527
528	SC_ValidityErrorAlertTabPage.select();
529	SC_ValidityShowErrorMessage.check();
530	SC_ValidityErrorAlertActionList.select("Stop");
531	SC_ValidityErrorAlertTabPage.ok();
532
533	CalcUtil.selectRange("Sheet1.A1");
534	SC_InputBar_Input.activate();
535	typeKeys("13");
536	typeKeys("<enter>");
537	assertEquals("OpenOffice.org Calc",ActiveMsgBox.getCaption());
538	assertEquals("Invalid value.",ActiveMsgBox.getMessage());
539	ActiveMsgBox.ok();
540	assertEquals("",CalcUtil.getCellText("Sheet1.A1"));
541	}
542
543	/**
544	* test uncheck Error Alert in Validity.
545	*/
546	@Test
547	public void testUncheckErrorAlert() {
548
549	SC_ValidityCriteriaTabpage.select();
550	SC_ValidityCriteriaAllowList.select("Decimal");
551	SC_ValidityDecimalCompareOperator.select("equal");
552	SC_ValiditySourceInput.setText("1");
553
554	SC_ValidityErrorAlertTabPage.select();
555	SC_ValidityShowErrorMessage.uncheck();
556	SC_ValidityErrorAlertActionList.select("Stop");
557	SC_ValidityErrorAlertTabPage.ok();
558
559	CalcUtil.selectRange("Sheet1.A1");
560	SC_InputBar_Input.activate();
561	typeKeys("13");
562	typeKeys("<enter>");
563	assertEquals("13",CalcUtil.getCellText("Sheet1.A1"));
564	}
565
566	/**
567	* test Cell range source picker in Validity. Input from Edit Box.
568	*/
569	@Test
570	public void testValidityCellRangeSourcePicker() {
571
572	SC_ValidityCriteriaTabpage.select();
573	SC_ValidityCriteriaAllowList.select("Cell range");
574	SC_ValiditySourcePicker.click();
575	assertEquals(false,SC_ValidityCriteriaAllowList.exists());
576	SC_ValiditySourceInput.setText("$Sheet1.$E$2:$G$5");
577	SC_ValiditySourcePicker.click();
578	assertEquals(true,SC_ValidityCriteriaAllowList.exists());
579
580	SC_ValidityErrorAlertTabPage.select();
581	SC_ValidityShowErrorMessage.check();
582	SC_ValidityErrorAlertActionList.select("Stop");
583	SC_ValidityErrorAlertTabPage.ok();
584
585	// calc.focus();
586	CalcUtil.selectRange("Sheet1.E2");
587	SC_InputBar_Input.activate();
588	typeKeys("test");
589	typeKeys("<enter>");
590
591	CalcUtil.selectRange("Sheet1.A1");
592	SC_InputBar_Input.activate();
593	typeKeys("test32");
594	typeKeys("<enter>");
595	assertEquals("Invalid value.",ActiveMsgBox.getMessage());
596	ActiveMsgBox.ok();
597	assertEquals("",CalcUtil.getCellText("Sheet1.A1"));
598
599	CalcUtil.selectRange("Sheet1.B1");
600	SC_InputBar_Input.activate();
601	typeKeys("test");
602	typeKeys("<enter>");
603	assertEquals("test",CalcUtil.getCellText("Sheet1.B1"));
604	}
605
606	/**
607	* test Allow Blank cell Checkbox in Validity.
608	*/
609	@Test
610	public void testAllowBlankCells() {
611	SC_ValidityCriteriaTabpage.select();
612	SC_ValidityCriteriaAllowList.select("Cell range");
613	SC_ValiditySourceInput.setText("$E$1:$E$5");
614	SC_ValidityAllowBlankCells.check();
615	SC_ValidityCriteriaTabpage.ok();
616
617	CalcUtil.selectRange("Sheet1.E1");
618	typeKeys("A<enter>A<enter>A<enter>A<enter>A<enter>");
619
620	CalcUtil.selectRange("Sheet1.A1");
621	typeKeys("A<enter>");
622	CalcUtil.selectRange("Sheet1.D1");
623	SC_InputBar_Input.activate();
624	typeKeys("<backspace><enter>");
625	assertEquals("",CalcUtil.getCellText("Sheet1.D1"));
626
627	CalcUtil.selectRange("Sheet1.B1");
628	calc.menuItem("Data->Validity...").select();
629	SC_ValidityCriteriaTabpage.select();
630	SC_ValidityAllowBlankCells.uncheck();
631	typeKeys("<enter>");
632
633	CalcUtil.selectRange("Sheet1.B1");
634	SC_InputBar_Input.activate();
635	typeKeys("<backspace><enter>");
636	typeKeys("<enter>");
637	}
638	}
639

Line 0 Link Here

(-)src/testcase/sc/chart/ChartDialogSetting.java (+83 lines)
		1	/**************************************************************
		2	*
		3	* Licensed to the Apache Software Foundation (ASF) under one
		4	* or more contributor license agreements. See the NOTICE file
		5	* distributed with this work for additional information
		6	* regarding copyright ownership. The ASF licenses this file
		7	* to you under the Apache License, Version 2.0 (the
		8	* "License"); you may not use this file except in compliance
		9	* with the License. You may obtain a copy of the License at
		10	*
		11	* http://www.apache.org/licenses/LICENSE-2.0
		12	*
		13	* Unless required by applicable law or agreed to in writing,
		14	* software distributed under the License is distributed on an
		15	* "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
		16	* KIND, either express or implied. See the License for the
		17	* specific language governing permissions and limitations
		18	* under the License.
		19	*
		20	*************************************************************/
		21
		22
		23
		24	/**
		25	*
		26	*/
		27	package testcase.sc.chart;
		28
		29	import static testlib.UIMap.*;
		30	import org.junit.After;
		31	import static org.junit.Assert.*;
		32	import org.junit.Before;
		33	import org.junit.Rule;
		34	import org.junit.Test;
		35	import testlib.Log;
		36
		37	/**
		38	* Test the setting about chart dialog in spreadsheet
		39	*/
		40	public class ChartDialogSetting {
		41
		42	@Rule
		43	public Log LOG = new Log();
		44
		45	@Before
		46	public void setUp() throws Exception {
		47	app.start();
		48
		49	// Create a new spreadsheet document
		50	startcenter.menuItem("File->New->Spreadsheet").select();
		51	}
		52
		53	@After
		54	public void tearDown() throws Exception {
		55	app.close();
		56	}
		57
		58	/**
		59	* Test cancel and back button in chart wizard dialog
		60	*
		61	* @throws java.lang.Exception
		62	*/
		63	@Test
		64	public void testChartDialogCancelBack() {
65	calc.menuItem("Insert->Chart...").select();
66	WizardNextButton.click();
67	assertTrue(ChartRangeChooseTabPage.isEnabled());
68	WizardBackButton.click();
69	assertTrue(ChartTypeChooseTabPage.isEnabled());
70	Chart_Wizard.cancel();
71	assertFalse(Chart_Wizard.exists());
72	}
73
74	/**
75	* Verify Chart Wizard dialog title words
76	*/
77	@Test
78	public void testChartWizardTitle() {
79	calc.menuItem("Insert->Chart...").select();
80	assertEquals("Chart Wizard",Chart_Wizard.getText());
81	Chart_Wizard.cancel();
82	}
83	}

Line 0 Link Here

(-)src/testcase/sw/table/Table.java (+90 lines)
		1	/**************************************************************
		2	*
		3	* Licensed to the Apache Software Foundation (ASF) under one
		4	* or more contributor license agreements. See the NOTICE file
		5	* distributed with this work for additional information
		6	* regarding copyright ownership. The ASF licenses this file
		7	* to you under the Apache License, Version 2.0 (the
		8	* "License"); you may not use this file except in compliance
		9	* with the License. You may obtain a copy of the License at
		10	*
		11	* http://www.apache.org/licenses/LICENSE-2.0
		12	*
		13	* Unless required by applicable law or agreed to in writing,
		14	* software distributed under the License is distributed on an
		15	* "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
		16	* KIND, either express or implied. See the License for the
		17	* specific language governing permissions and limitations
		18	* under the License.
		19	*
		20	*************************************************************/
		21
		22
		23
		24	/**
		25	*
		26	*/
		27	package testcase.sw.table;
		28
		29	import static testlib.AppUtil.*;
		30	import static testlib.UIMap.*;
		31	import static org.junit.Assert.*;
		32	import org.junit.After;
		33	import org.junit.Before;
		34	import org.junit.Rule;
		35	import org.junit.Test;
		36	import org.openoffice.test.common.SystemUtil;
		37
		38	import testlib.Log;
		39
		40	/**
		41	*
		42	*/
		43	public class Table {
		44
		45	@Rule
		46	public Log LOG = new Log();
		47
		48	@Before
		49	public void setUp() throws Exception {
		50	app.start();
		51	}
		52
		53	@After
		54	public void tearDown() throws Exception {
		55	app.close();
		56	}
		57
		58	/**
		59	* Test convert table to text in text document
		60	* @throws Exception
		61	*/
		62	@Test
		63	public void testConvertTableToText() throws Exception{
		64
65	//Create a new text document
66	startcenter.menuItem("File->New->Text Document").select();
67	sleep(3);
68
69	// Insert a table and input some data
70	writer.menuItem("Insert->Table...").select();
71	writer_InsertTable.ok();
72	writer.focus();
73	typeKeys("1<right>2<right>3<right>4");
74	sleep(1);
75
76	// Convert table to text
77	writer.menuItem("Table->Convert->Table to Text...").select();
78	assertTrue("Convert Table to Text dialog pop up", writer_ConvertTableToTextDlg.exists());
79	typeKeys("<enter>");
80	sleep(1);
81
82	// Verify if text is converted successfully
83	writer.menuItem("Edit->Select All").select();
84	app.dispatch(".uno:Copy");
85	if (SystemUtil.isWindows())
86	assertEquals("Converted text", "1\t2\r\n3\t4\r\n", app.getClipboard()); // windows�лس��\r\n
87	else
88	assertEquals("Converted text", "1\t2\n3\t4\n", app.getClipboard());
89	}
90	}

Line 0 Link Here

(-)src/testcase/sd/headerandfooter/OpenDocumentWithHeaderFooter.java (+171 lines)
		1	/**************************************************************
		2	*
		3	* Licensed to the Apache Software Foundation (ASF) under one
		4	* or more contributor license agreements. See the NOTICE file
		5	* distributed with this work for additional information
		6	* regarding copyright ownership. The ASF licenses this file
		7	* to you under the Apache License, Version 2.0 (the
		8	* "License"); you may not use this file except in compliance
		9	* with the License. You may obtain a copy of the License at
		10	*
		11	* http://www.apache.org/licenses/LICENSE-2.0
		12	*
		13	* Unless required by applicable law or agreed to in writing,
		14	* software distributed under the License is distributed on an
		15	* "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
		16	* KIND, either express or implied. See the License for the
		17	* specific language governing permissions and limitations
		18	* under the License.
		19	*
		20	*************************************************************/
		21
		22
		23
		24	/**
		25	*
		26	*/
		27	package testcase.sd.headerandfooter;
		28
		29	import static testlib.AppUtil.fullPath;
		30	import static testlib.AppUtil.openStartcenter;
		31	import static testlib.AppUtil.submitSaveDlg;
		32	import static testlib.AppUtil.submitOpenDlg;
		33	import static testlib.AppUtil.testFile;
		34	import static testlib.UIMap.*;
		35	import static org.junit.Assert.*;
		36	import static org.openoffice.test.vcl.Tester.*;
		37	import org.junit.After;
		38	import org.junit.Before;
		39	import org.junit.Rule;
		40	import org.junit.Test;
		41	import org.openoffice.test.common.FileUtil;
		42	import testlib.Log;
		43
		44	public class OpenDocumentWithHeaderFooter {
		45
		46	@Rule
		47	public Log LOG = new Log();
		48
		49	@Before
		50	public void setUp() throws Exception {
		51	app.start();
		52	}
		53
		54	@After
		55	public void tearDown() throws Exception {
		56	app.close();
		57	}
		58
		59	/**
		60	* Test open AOO3.4 presentation with header and footer.
		61	* edit and save to ODP
		62	* @throws Exception
		63	*/
		64	@Test
65	public void testOpenAOO34WithHeaderFooter() throws Exception{
66	//open sample file
67	String file = testFile("sd/AOO3.4HeaderFooter.odp");
68	app.dispatch(".uno:Open");
69	submitOpenDlg(file);
70
71	//check after reopen
72	impress.menuItem("View->Header and Footer...").select();
73	sleep(1);
74	assertEquals(true,SD_DateAndTimeFooterOnSlide.isChecked());
75	assertEquals("fixed date",SD_FixedDateAndTimeOnSlideInput.getText());
76	assertEquals(true,SD_FooterTextOnSlide.isChecked());
77	assertEquals("footer test",SD_FooterTextOnSlideInput.getText());
78	assertEquals(true,SD_SlideNumAsFooterOnSlide.isChecked());
79
80	SD_SlideNumAsFooterOnSlide.uncheck();
81	SD_ApplyToAllButtonOnSlideFooter.click();
82
83	//save to odp and reopen
84	impress.menuItem("File->Save As...").select();
85	String saveTo2 = fullPath("temp/" + "AOO3.4HeaderFooter.odp");
86	FileUtil.deleteFile(saveTo2);
87	submitSaveDlg(saveTo2);
88	impress.menuItem("File->Close").select();
89	sleep(1);
90
91	openStartcenter();
92	app.dispatch(".uno:Open");
93	String openFrom2=fullPath("temp/" + "AOO3.4HeaderFooter.odp");
94	submitOpenDlg(openFrom2);
95
96	impress.menuItem("View->Header and Footer...").select();
97	sleep(1);
98	assertEquals(false,SD_SlideNumAsFooterOnSlide.isChecked());
99	//end-save to odp and reopen
100	}
101
102	/**
103	* Test open ppt file with header and footer.
104	* edit and save to PPT/ODP
105	* @throws Exception
106	*/
107	@Test
108	public void testOpenPPTWithHeaderFooter() throws Exception{
109	//open sample file
110	String file = testFile("sd/gfdd.ppt");
111	app.dispatch(".uno:Open");
112	submitOpenDlg(file);
113
114	//check after reopen
115	impress.menuItem("View->Header and Footer...").select();
116	sleep(1);
117	assertEquals(true,SD_DateAndTimeFooterOnSlide.isChecked());
118	assertEquals("testdte",SD_FixedDateAndTimeOnSlideInput.getText());
119	assertEquals(true,SD_FooterTextOnSlide.isChecked());
120	assertEquals("yesy",SD_FooterTextOnSlideInput.getText());
121	assertEquals(true,SD_SlideNumAsFooterOnSlide.isChecked());
122
123	SD_SlideNumAsFooterOnSlide.uncheck();
124	SD_ApplyToAllButtonOnSlideFooter.click();
125
126	//save to ppt and reopen
127	impress.menuItem("File->Save As...").select();
128	String saveTo = fullPath("temp/" + "gfdd.ppt");
129	FileUtil.deleteFile(saveTo);
130	submitSaveDlg(saveTo);
131	if (AlienFormatDlg.exists(3))
132	AlienFormatDlg.ok();
133	sleep(1);
134	impress.menuItem("File->Close").select();
135	sleep(1);
136
137	openStartcenter();
138	app.dispatch(".uno:Open");
139	String openFrom=fullPath("temp/" + "gfdd.ppt");
140	submitOpenDlg(openFrom);
141
142	impress.menuItem("View->Header and Footer...").select();
143	sleep(1);
144	assertEquals(false,SD_SlideNumAsFooterOnSlide.isChecked());
145	//end-save to ppt and reopen
146
147	//close Header and Footer dialog.
148	SD_ApplyButtonOnSlideFooter.focus();
149	typeKeys("<tab>");
150	typeKeys("<enter>");
151	//end
152
153	//save to odp and reopen
154	impress.menuItem("File->Save As...").select();
155	String saveTo2 = fullPath("temp/" + "gfdd.odp");
156	FileUtil.deleteFile(saveTo2);
157	submitSaveDlg(saveTo2);
158	impress.menuItem("File->Close").select();
159	sleep(1);
160
161	openStartcenter();
162	app.dispatch(".uno:Open");
163	String openFrom2=fullPath("temp/" + "gfdd.odp");
164	submitOpenDlg(openFrom2);
165
166	impress.menuItem("View->Header and Footer...").select();
167	sleep(1);
168	assertEquals(false,SD_SlideNumAsFooterOnSlide.isChecked());
169	//end-save to odp and reopen
170	}
171	}

Line 0 Link Here

(-)src/testcase/sc/filter/Fitler.java (+72 lines)
		1	/**************************************************************
		2	*
		3	* Licensed to the Apache Software Foundation (ASF) under one
		4	* or more contributor license agreements. See the NOTICE file
		5	* distributed with this work for additional information
		6	* regarding copyright ownership. The ASF licenses this file
		7	* to you under the Apache License, Version 2.0 (the
		8	* "License"); you may not use this file except in compliance
		9	* with the License. You may obtain a copy of the License at
		10	*
		11	* http://www.apache.org/licenses/LICENSE-2.0
		12	*
		13	* Unless required by applicable law or agreed to in writing,
		14	* software distributed under the License is distributed on an
		15	* "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
		16	* KIND, either express or implied. See the License for the
		17	* specific language governing permissions and limitations
		18	* under the License.
		19	*
		20	*************************************************************/
		21
		22
		23
		24	/**
		25	*
		26	*/
		27	package testcase.sc.filter;
		28
		29	import static testlib.AppUtil.*;
		30	import static testlib.UIMap.*;
		31	import org.junit.After;
		32	import static org.junit.Assert.*;
		33	import static org.openoffice.test.vcl.Tester.*;
		34	import org.junit.Before;
		35	import org.junit.Ignore;
		36	import org.junit.Rule;
		37	import testlib.CalcUtil;
		38	import testlib.Log;
		39
		40	/**
		41	* Test cases about Data->Filter in spreadsheet
		42	*/
		43	public class Fitler {
		44
		45	@Rule
		46	public Log LOG = new Log();
		47
		48	@Before
		49	public void setUp() throws Exception {
		50	app.start();
		51
		52	// Create a new spreadsheet document
		53	startcenter.menuItem("File->New->Spreadsheet").select();
		54	}
		55
		56	@After
		57	public void tearDown() throws Exception {
		58	app.close();
		59	}
		60
		61	/**
		62	*
		63	* Verify Chart Wizard dialog title words
		64	*/
65	@Ignore("Bug 120076")
66	public void testAutoFilterWithPlusSign() {
67	String expect ="2+";
68	CalcUtil.selectRange("A1");
69	typeKeys(expect + "<enter>");
70	assertEquals(expect,CalcUtil.getCellText("A1"));
71	}
72	}