/**************************************************************

 * 

 * 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.Test;

import org.openoffice.test.vcl.IDList;

import org.openoffice.test.vcl.widgets.VclMessageBox;

import testlib.CalcUtil;

import testlib.Log;

public class ValidityCellRangeSourcePicker {

	private static IDList idList = new IDList(new File("./ids"));

	public static final VclMessageBox ActiveMsgBox = new VclMessageBox(idList.getId("UID_ACTIVE"), "Message on message box.");

	/**

	 * TestCapture helps us to do

	 * 1. Take a screenshot when failure occurs.

	 * 2. Collect extra data when OpenOffice crashes.

	 */	

	@Rule

	public Log LOG = new Log();

	/**

	 * initApp helps us to do 

	 * 1. Patch the OpenOffice to enable automation if necessary.

	 * 2. Start OpenOffice with automation enabled if necessary.

	 * 3. Reset OpenOffice to startcenter.

	 * 

	 * @throws java.lang.Exception

	 */

	@Before

	public void setUp() throws Exception {

		initApp();

	}

	/**

	 * test Cell range source picker in Validity. Input from Edit Box.

	 */

	@Test

	public void testValidityCellRangeSourcePicker() {

		startcenter.menuItem("File->New->Spreadsheet").select();

		sleep(1);

		CalcUtil.selectRange("Sheet1.A1");

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

		sleep(1);	

		SC_ValidityCriteriaTabpage.select();

		SC_ValidityCriteriaAllowList.select("Cell range");

		SC_ValiditySourcePicker.click();

		assertEquals(false,SC_ValidityCriteriaAllowList.exists());

		SC_ValiditySourceInput.setText("$Sheet1.$A$2:$C$5");

		SC_ValiditySourcePicker.click();

		assertEquals(true,SC_ValidityCriteriaAllowList.exists());

		typeKeys("<enter>");

		calc.focus();

		CalcUtil.selectRange("Sheet1.A2");

		SC_CellInput.activate();

		typeKeys("test");

		typeKeys("<enter>");

		CalcUtil.selectRange("Sheet1.A1");

		SC_CellInput.activate();

		typeKeys("test32");

		typeKeys("<enter>");

		assertEquals("Invalid value.",ActiveMsgBox.getMessage());

		ActiveMsgBox.focus();

		typeKeys("<enter>");

		CalcUtil.selectRange("Sheet1.A1");

		SC_CellInput.activate();

		typeKeys("test");

		typeKeys("<enter>");

		assertEquals("Test",CalcUtil.getCellText("Sheet1.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 java.awt.Rectangle;

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.Test;

import org.openoffice.test.common.FileUtil;

import org.openoffice.test.common.GraphicsUtil;

import testlib.CalcUtil;

import testlib.Log;

/**

 *

 *

 */

public class RemoveFunctionOfGroupedField {

	/**

	 * TestCapture helps us to do 1. Take a screenshot when failure occurs. 2.

	 * Collect extra data when OpenOffice crashes.

	 */

	@Rule

	public Log LOG = new Log();

	/**

	 * initApp helps us to do 1. Patch the OpenOffice to enable automation if

	 * necessary. 2. Start OpenOffice with automation enabled if necessary. 3.

	 * Reset OpenOffice to startcenter.

	 * 

	 * @throws java.lang.Exception

	 */

	@Before

	public void setUp() throws Exception {

		initApp();

	}

	/**

	 * 

	 * Verify the Remove function of Grouped field 

	 */

	@Test

	public void test() {

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

	}

}

/**************************************************************

 * 

 * 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 java.awt.Rectangle;

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.Test;

import org.openoffice.test.common.FileUtil;

import org.openoffice.test.common.GraphicsUtil;

import testlib.CalcUtil;

import testlib.Log;

/**

 * 

 *

 */

public class MoveFieldInSameAreaManualUpdate {

	/**

	 * TestCapture helps us to do 1. Take a screenshot when failure occurs. 2.

	 * Collect extra data when OpenOffice crashes.

	 */

	@Rule

	public Log LOG = new Log();

	/**

	 * initApp helps us to do 1. Patch the OpenOffice to enable automation if

	 * necessary. 2. Start OpenOffice with automation enabled if necessary. 3.

	 * Reset OpenOffice to startcenter.

	 * 

	 * @throws java.lang.Exception

	 */

	@Before

	public void setUp() throws Exception {

		initApp();

	}

	/**

	 * 

	 * Verify that DP panel will be synchronized with table while add fields on panel.

	 */

	@Test

	public void test() {

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

	}

}

/**************************************************************

 * 

 * 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 java.awt.Rectangle;

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.Test;

import org.openoffice.test.common.FileUtil;

import org.openoffice.test.common.GraphicsUtil;

import testlib.CalcUtil;

import testlib.Log;

/**

 * 

 *

 */

public class HideShowPanel {

	/**

	 * TestCapture helps us to do 1. Take a screenshot when failure occurs. 2.

	 * Collect extra data when OpenOffice crashes.

	 */

	@Rule

	public Log LOG = new Log();

	/**

	 * initApp helps us to do 1. Patch the OpenOffice to enable automation if

	 * necessary. 2. Start OpenOffice with automation enabled if necessary. 3.

	 * Reset OpenOffice to startcenter.

	 * 

	 * @throws java.lang.Exception

	 */

	@Before

	public void setUp() throws Exception {

		initApp();

	}

	/**

	 * 

	 * Verify that DP panel while switch focus among tables with same/different source range.

	 */

	@Test

	public void test() {

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

	}

}

/**************************************************************

 * 

 * 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.presentation.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.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.Test;

import org.openoffice.test.vcl.IDList;

import org.openoffice.test.vcl.widgets.VclMessageBox;

import testlib.CalcUtil;

import testlib.Log;

public class AllowWholeNumLessThan {

	private static IDList idList = new IDList(new File("./ids"));

	public static final VclMessageBox ActiveMsgBox = new VclMessageBox(idList.getId("UID_ACTIVE"), "Message on message box.");

	/**

	 * TestCapture helps us to do

	 * 1. Take a screenshot when failure occurs.

	 * 2. Collect extra data when OpenOffice crashes.

	 */	

	@Rule

	public Log LOG = new Log();

	/**

	 * initApp helps us to do 

	 * 1. Patch the OpenOffice to enable automation if necessary.

	 * 2. Start OpenOffice with automation enabled if necessary.

	 * 3. Reset OpenOffice to startcenter.

	 * 

	 * @throws java.lang.Exception

	 */

	@Before

	public void setUp() throws Exception {

		initApp();

	}

	/**

	 * test Allow whole number, less than or equal to in Validity.

	 */

	@Test

	public void testAllowWholeNumLessThan() {

		startcenter.menuItem("File->New->Spreadsheet").select();

		sleep(1);

		CalcUtil.selectRange("Sheet1.A1:C5");

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

		sleep(1);

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

		typeKeys("<tab>");

		typeKeys("<enter>");	

		sleep(1);

		CalcUtil.selectRange("Sheet1.A1");

		SC_CellInput.activate();

		typeKeys("99");

		typeKeys("<enter>");

		assertEquals("99",CalcUtil.getCellText("Sheet1.A1"));

		CalcUtil.selectRange("Sheet1.A2");

		SC_CellInput.activate();

		typeKeys("100");

		typeKeys("<enter>");

		assertEquals("100",CalcUtil.getCellText("Sheet1.A2"));

		CalcUtil.selectRange("Sheet1.B1");

		SC_CellInput.activate();

		typeKeys("101");

		typeKeys("<enter>");

		assertEquals("Invalid value",ActiveMsgBox.getMessage());

		ActiveMsgBox.ok();

		assertEquals("",CalcUtil.getCellText("Sheet1.B1"));

		CalcUtil.selectRange("Sheet1.B2");

		SC_CellInput.activate();

		typeKeys("45.5");

		typeKeys("<enter>");

		sleep(1);

		assertEquals("Invalid value",ActiveMsgBox.getMessage());

		ActiveMsgBox.ok();

		assertEquals("",CalcUtil.getCellText("Sheet1.B2"));

		CalcUtil.selectRange("Sheet1.C1");

		SC_CellInput.activate();

		typeKeys("test");

		typeKeys("<enter>");

		sleep(1);

		assertEquals("Invalid value",ActiveMsgBox.getMessage());

		ActiveMsgBox.ok();

		assertEquals("",CalcUtil.getCellText("Sheet1.C1"));

		}

}

/**************************************************************

 * 

 * 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.textdocument.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());

	}

}

//	public static final VclWindow SD_SlidesPanel = window("HID_SD_WIN_DOCUMENT");

/**************************************************************

 * 

 * 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 java.awt.Rectangle;

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.Test;

import org.openoffice.test.common.FileUtil;

import org.openoffice.test.common.GraphicsUtil;

import testlib.CalcUtil;

import testlib.Log;

/**

 * 

 *

 */

public class CopyPasteDataPilotTable {

	/**

	 * TestCapture helps us to do 1. Take a screenshot when failure occurs. 2.

	 * Collect extra data when OpenOffice crashes.

	 */

	@Rule

	public Log LOG = new Log();

	/**

	 * initApp helps us to do 1. Patch the OpenOffice to enable automation if

	 * necessary. 2. Start OpenOffice with automation enabled if necessary. 3.

	 * Reset OpenOffice to startcenter.

	 * 

	 * @throws java.lang.Exception

	 */

	@Before

	public void setUp() throws Exception {

		initApp();

	}

	/**

	 * 

	 * Verify copy and paste Data Pilot Table

	 */

	@Test

	public void test() {

		//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"));

	}

}

/**************************************************************

 * 

 * 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.Test;

import org.openoffice.test.vcl.IDList;

import org.openoffice.test.vcl.widgets.VclMessageBox;

import testlib.CalcUtil;

import testlib.Log;

public class AllowGreaterTextLength {

	private static IDList idList = new IDList(new File("./ids"));

	public static final VclMessageBox ActiveMsgBox = new VclMessageBox(idList.getId("UID_ACTIVE"), "Message on message box.");

	/**

	 * TestCapture helps us to do

	 * 1. Take a screenshot when failure occurs.

	 * 2. Collect extra data when OpenOffice crashes.

	 */	

	@Rule

	public Log LOG = new Log();

	/**

	 * initApp helps us to do 

	 * 1. Patch the OpenOffice to enable automation if necessary.

	 * 2. Start OpenOffice with automation enabled if necessary.

	 * 3. Reset OpenOffice to startcenter.

	 * 

	 * @throws java.lang.Exception

	 */

	@Before

	public void setUp() throws Exception {

		initApp();

	}

	/**

	 * test Allow Text length,  greater than or equal to  in Validity.

	 */

	@Test

	public void testAllowDecimalEqual() {

		startcenter.menuItem("File->New->Spreadsheet").select();

		sleep(1);

		CalcUtil.selectRange("Sheet1.A1:B5");

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

		sleep(1);

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

		typeKeys("<tab>");

		typeKeys("<enter>");	

		sleep(1);

		CalcUtil.selectRange("Sheet1.A1");

		SC_CellInput.activate();

		typeKeys("testtesttesttest");

		typeKeys("<enter>");

		assertEquals("Testtesttesttest",CalcUtil.getCellText("Sheet1.A1"));

		CalcUtil.selectRange("Sheet1.A2");

		SC_CellInput.activate();

		typeKeys("test test ");

		typeKeys("<enter>");

		assertEquals("Test test ",CalcUtil.getCellText("Sheet1.A2"));

		CalcUtil.selectRange("Sheet1.A4");

		SC_CellInput.activate();

		typeKeys(" ");

		typeKeys("<enter>");

		assertEquals("Invalid value",ActiveMsgBox.getMessage());

		ActiveMsgBox.ok();

		assertEquals("",CalcUtil.getCellText("Sheet1.A4"));

		CalcUtil.selectRange("Sheet1.A3");

		SC_CellInput.activate();

		typeKeys("Testatest");

		typeKeys("<enter>");

		sleep(1);

		assertEquals("Invalid value",ActiveMsgBox.getMessage());

		ActiveMsgBox.ok();

		assertEquals("",CalcUtil.getCellText("Sheet1.A3"));

		}

}

/**************************************************************

 * 

 * 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.presentation.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);