incubator-ooo-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From liu...@apache.org
Subject svn commit: r1378870 [3/6] - in /incubator/ooo/trunk/main/test: ./ inc/ prj/ source/ testcommon/ testcommon/source/org/openoffice/test/common/ testgui/source/testcase/gui/ testgui/source/testcase/gui/bvt/ testgui/source/testcase/gui/formula/catalog/ te...
Date Thu, 30 Aug 2012 09:27:23 GMT
Modified: incubator/ooo/trunk/main/test/testgui/source/testcase/gui/sc/datapilot/DataPivotTable.java
URL: http://svn.apache.org/viewvc/incubator/ooo/trunk/main/test/testgui/source/testcase/gui/sc/datapilot/DataPivotTable.java?rev=1378870&r1=1378869&r2=1378870&view=diff
==============================================================================
--- incubator/ooo/trunk/main/test/testgui/source/testcase/gui/sc/datapilot/DataPivotTable.java (original)
+++ incubator/ooo/trunk/main/test/testgui/source/testcase/gui/sc/datapilot/DataPivotTable.java Thu Aug 30 09:27:21 2012
@@ -19,38 +19,36 @@
  * 
  *************************************************************/
 
-
-
 /**
  * 
  */
 package testcase.gui.sc.datapilot;
 
+import static org.junit.Assert.*;
+import static org.openoffice.test.common.Testspace.*;
+import static org.openoffice.test.vcl.Tester.*;
 import static testlib.gui.AppUtil.*;
 import static testlib.gui.UIMap.*;
-import static org.openoffice.test.common.Testspace.*;
+
 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.Logger;
 import org.openoffice.test.common.SystemUtil;
 
 import testlib.gui.CalcUtil;
-import testlib.gui.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.
+ * 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();
+	public Logger log = Logger.getLogger(this);
 
 	@Before
 	public void setUp() throws Exception {
@@ -59,7 +57,7 @@ public class DataPivotTable {
 
 	@After
 	public void tearDown() throws Exception {
-		
+
 	}
 
 	/**
@@ -68,89 +66,90 @@ public class DataPivotTable {
 	 */
 	@Ignore("DataPilot in symphony is totally not the same in AOO")
 	public void testCopyPasteDataPilotTable() {
-		//Open the sample file
+		// Open the sample file
 		String file = prepareData("source_data01.ods");
 		startcenter.menuItem("File->Open...").select();
 		submitOpenDlg(file);
 		sleep(2);
 
-		//Create DataPilotTable and verify the content
+		// Create DataPilotTable and verify the content
 		CalcUtil.selectRange("A1:E27");
-		calc.menuItem("Data->DataPilot->Start...").select();		
+		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"));
+		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){
+		if (DataPilotAutomaticallyUpdateCheckBox.isChecked() == false) {
 			DataPilotAutomaticallyUpdateCheckBox.check();
 		}
 
-		//Add field into every area
+		// Add field into every area
 		DataPilotFieldSelect.click(1, 1);
 		DataPilotFieldSelect.openContextMenu();
 		menuItem("Add to Page").select();
-		assertEquals("Locale",CalcUtil.getCellText("A1"));
+		assertEquals("Locale", CalcUtil.getCellText("A1"));
 		sleep(1);
 
-		DataPilotFieldSelect.click(1,30);
+		DataPilotFieldSelect.click(1, 30);
 		DataPilotFieldSelect.openContextMenu();
 		menuItem("Add to Column").select();
-		assertEquals("Name",CalcUtil.getCellText("A3"));
+		assertEquals("Name", CalcUtil.getCellText("A3"));
 		sleep(1);
 
-		DataPilotFieldSelect.click(1,50);
+		DataPilotFieldSelect.click(1, 50);
 		DataPilotFieldSelect.openContextMenu();
 		menuItem("Add to Row").select();
-		assertEquals("Date",CalcUtil.getCellText("A4"));
+		assertEquals("Date", CalcUtil.getCellText("A4"));
 		sleep(1);
 
-		DataPilotFieldSelect.click(1,70);
+		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"));
+		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
+		// 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"));
+		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"));
+		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.
+	 * 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
+		// open the sample file Create DataPilotTable and verify the content
 		String file = prepareData("source_data01.ods");
 		startcenter.menuItem("File->Open...").select();
 		submitOpenDlg(file);
@@ -158,69 +157,70 @@ public class DataPivotTable {
 		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"));
+		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){
+		if (DataPilotAutomaticallyUpdateCheckBox.isChecked() == false) {
 			DataPilotAutomaticallyUpdateCheckBox.check();
 
 		}
 		sleep(1);
 
-		//Add field into every area
+		// Add field into every area
 		DataPilotFieldSelect.click(1, 30);
 		DataPilotFieldSelect.openContextMenu();
 		menuItem("Add to Column").select();
-		assertEquals("Name",CalcUtil.getCellText("A1"));
+		assertEquals("Name", CalcUtil.getCellText("A1"));
 		sleep(1);
 
-		DataPilotFieldSelect.click(1,50);
+		DataPilotFieldSelect.click(1, 50);
 		DataPilotFieldSelect.openContextMenu();
 		menuItem("Add to Row").select();
-		assertEquals("Date",CalcUtil.getCellText("A2"));
+		assertEquals("Date", CalcUtil.getCellText("A2"));
 		sleep(1);
 
 		DataPilotFieldSelect.drag(1, 1, 184, 80);
-		assertEquals("Locale",CalcUtil.getCellText("A1"));
+		assertEquals("Locale", CalcUtil.getCellText("A1"));
 		sleep(1);
 
 		typeKeys("<$undo>");
-		assertEquals("",CalcUtil.getCellText("A1"));
+		assertEquals("", CalcUtil.getCellText("A1"));
 		sleep(1);
 
 		typeKeys("<$redo>");
-		assertEquals("Locale",CalcUtil.getCellText("A1"));
+		assertEquals("Locale", CalcUtil.getCellText("A1"));
 		sleep(1);
 
-		DataPilotFieldSelect.click(1,70);
+		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"));
+		assertEquals("Sum - Order Number", CalcUtil.getCellText("A3"));
+		assertEquals("266773", CalcUtil.getCellText("J23"));
 		sleep(1);
 
 		typeKeys("<$undo>");
-		assertEquals("",CalcUtil.getCellText("A3"));
+		assertEquals("", CalcUtil.getCellText("A3"));
 		sleep(1);
 
 		typeKeys("<$redo>");
-		assertEquals("Sum - Order Number",CalcUtil.getCellText("A3"));
-		assertEquals("266773",CalcUtil.getCellText("J23"));
+		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.
+	 * 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
+		// open the sample file Create DataPilotTable and verify the content
 		String file = prepareData("source_data01.ods");
 		startcenter.menuItem("File->Open...").select();
 		submitOpenDlg(file);
@@ -228,15 +228,15 @@ public class DataPivotTable {
 		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"));
+		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){
+		if (DataPilotAutomaticallyUpdateCheckBox.isChecked() == false) {
 			DataPilotAutomaticallyUpdateCheckBox.check();
 
 		}
@@ -247,62 +247,60 @@ public class DataPivotTable {
 		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"));
+		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.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"));
+		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"));
+		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"));
+		assertEquals("Name", CalcUtil.getCellText("B1"));
+		assertEquals("Date", CalcUtil.getCellText("A2"));
 		sleep(1);
 
-		DataPilotFieldSelect.click(1,70);
+		DataPilotFieldSelect.click(1, 70);
 		DataPilotFieldSelect.openContextMenu();
 		menuItem("Add to Data by->Sum").select();
-		assertEquals("Name",CalcUtil.getCellText("B1"));
-		assertEquals("Date",CalcUtil.getCellText("A2"));
+		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"));
+		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"));
+		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"));
+		assertEquals("Locale", CalcUtil.getCellText("A1"));
+		assertEquals("Sum - Order Number", CalcUtil.getCellText("A3"));
+		assertEquals("266773", CalcUtil.getCellText("J23"));
 		sleep(1);
 
 		DataPilotAutomaticallyUpdateCheckBox.check();
@@ -311,11 +309,12 @@ public class DataPivotTable {
 
 	/**
 	 * 
-	 * Verify that DP panel will be synchronized with table while add fields on panel.
+	 * 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
+		// open the sample file Create DataPilotTable and verify the content
 		String file = prepareData("source_data01.ods");
 		startcenter.menuItem("File->Open...").select();
 		submitOpenDlg(file);
@@ -323,14 +322,14 @@ public class DataPivotTable {
 		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){
+		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();
 
 		}
@@ -339,37 +338,37 @@ public class DataPivotTable {
 		DataPilotFieldSelect.click(1, 1);
 		DataPilotFieldSelect.openContextMenu();
 		menuItem("Add to Column").select();
-		assertEquals("Locale",CalcUtil.getCellText("A1"));
+		assertEquals("Locale", CalcUtil.getCellText("A1"));
 		sleep(1);
 
-		DataPilotFieldSelect.click(1,30);
+		DataPilotFieldSelect.click(1, 30);
 		DataPilotFieldSelect.openContextMenu();
 		menuItem("Add to Column").select();
-		assertEquals("Name",CalcUtil.getCellText("B1"));
+		assertEquals("Name", CalcUtil.getCellText("B1"));
 		sleep(1);
 
-		DataPilotFieldSelect.click(1,50);
+		DataPilotFieldSelect.click(1, 50);
 		DataPilotFieldSelect.openContextMenu();
 		menuItem("Add to Row").select();
-		assertEquals("Date",CalcUtil.getCellText("A3"));
+		assertEquals("Date", CalcUtil.getCellText("A3"));
 		sleep(1);
 
-		DataPilotFieldSelect.click(1,70);
+		DataPilotFieldSelect.click(1, 70);
 		DataPilotFieldSelect.openContextMenu();
 		menuItem("Add to Row").select();
-		assertEquals("Order Number",CalcUtil.getCellText("B3"));
+		assertEquals("Order Number", CalcUtil.getCellText("B3"));
 		sleep(1);
 
-		DataPilotFieldSelect.click(1,90);
+		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"));
+		assertEquals("Sum - Amount", CalcUtil.getCellText("A1"));
+		assertEquals("32779.17", CalcUtil.getCellInput("K30"));
 		sleep(1);
 
-		//Change Locale option settings, and verify it
+		// Change Locale option settings, and verify it
 		String target = "New Locale";
-		DataPilotColumnArea.click(1,1);
+		DataPilotColumnArea.click(1, 1);
 		DataPilotColumnArea.openContextMenu();
 		menuItem("Field Option").select();
 		DataPilotFieldOptionFieldTabPageDialog.select();
@@ -380,33 +379,32 @@ public class DataPivotTable {
 		sleep(1);
 		DataPilotFieldOptionSubTotalsManuallyRadioButton.check();
 		sleep(1);
-		SC_DataPilotOptionSubtotalFunctionList.click(9,24);
+		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"));
+		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.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"));
+		assertEquals("Emmy Ma", CalcUtil.getCellText("F3"));
+		assertEquals("32779.17", CalcUtil.getCellInput("U30"));
 
 		CalcUtil.selectRange("C1");
 		SpreadSheetCells.openContextMenu();
@@ -421,11 +419,10 @@ public class DataPivotTable {
 		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"));
-
+		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();
@@ -433,12 +430,12 @@ public class DataPivotTable {
 		DataPilotFieldOptionFieldTabPageDialog.select();
 		DataPilotFieldShowItemWithoutDataCheckBox.uncheck();
 		DataPilotFieldOptionFieldTabPageDialog.ok();
-		assertEquals("32779.17",CalcUtil.getCellInput("K30"));
+		assertEquals("32779.17", CalcUtil.getCellInput("K30"));
 	}
 
 	/**
 	 * 
-	 * Verify that Verify the Drag/Move function of Grouped field 
+	 * Verify that Verify the Drag/Move function of Grouped field
 	 */
 	@Ignore("DataPilot in symphony is totally not the same in AOO")
 	public void testDragMoveFunctionOfGroupedField() {
@@ -449,14 +446,14 @@ public class DataPivotTable {
 		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){
+		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();
 
 		}
@@ -464,61 +461,62 @@ public class DataPivotTable {
 		DataPilotFieldSelect.click(1, 1);
 		DataPilotFieldSelect.openContextMenu();
 		menuItem("Add to Page").select();
-		assertEquals("Locale",CalcUtil.getCellText("A1"));
+		assertEquals("Locale", CalcUtil.getCellText("A1"));
 		sleep(1);
 
-		DataPilotFieldSelect.click(1,30);
+		DataPilotFieldSelect.click(1, 30);
 		DataPilotFieldSelect.openContextMenu();
 		menuItem("Add to Column").select();
-		assertEquals("Name",CalcUtil.getCellText("A3"));
+		assertEquals("Name", CalcUtil.getCellText("A3"));
 		sleep(1);
 
-		DataPilotFieldSelect.click(1,50);
+		DataPilotFieldSelect.click(1, 50);
 		DataPilotFieldSelect.openContextMenu();
 		menuItem("Add to Row").select();
-		assertEquals("Date",CalcUtil.getCellText("A4"));
+		assertEquals("Date", CalcUtil.getCellText("A4"));
 		sleep(1);
 
-		DataPilotFieldSelect.click(1,70);
+		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"));
+		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"));
+		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.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"));
+		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"));
+		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"));
+		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.
+	 * 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() {
@@ -527,43 +525,43 @@ public class DataPivotTable {
 		submitOpenDlg(file);
 		sleep(2);
 		CalcUtil.selectRange("A1:E27");
-		calc.menuItem("Data->DataPilot->Start...").select();		
+		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"));
+		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){
+		if (DataPilotAutomaticallyUpdateCheckBox.isChecked() == false) {
 			DataPilotAutomaticallyUpdateCheckBox.check();
 		}
 
 		DataPilotFieldSelect.click(1, 1);
 		DataPilotFieldSelect.openContextMenu();
 		menuItem("Add to Page").select();
-		assertEquals("Locale",CalcUtil.getCellText("A1"));
+		assertEquals("Locale", CalcUtil.getCellText("A1"));
 		sleep(1);
 
-		DataPilotFieldSelect.click(1,30);
+		DataPilotFieldSelect.click(1, 30);
 		DataPilotFieldSelect.openContextMenu();
 		menuItem("Add to Column").select();
-		assertEquals("Name",CalcUtil.getCellText("A3"));
+		assertEquals("Name", CalcUtil.getCellText("A3"));
 		sleep(1);
 
-		DataPilotFieldSelect.click(1,50);
+		DataPilotFieldSelect.click(1, 50);
 		DataPilotFieldSelect.openContextMenu();
 		menuItem("Add to Row").select();
-		assertEquals("Date",CalcUtil.getCellText("A4"));
+		assertEquals("Date", CalcUtil.getCellText("A4"));
 		sleep(1);
 
-		DataPilotFieldSelect.click(1,70);
+		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"));
+		assertEquals("Sum - Order Number", CalcUtil.getCellText("A3"));
+		assertEquals("266773", CalcUtil.getCellText("J23"));
 		sleep(1);
 
 		CalcUtil.selectRange("A1:J24");
@@ -571,13 +569,13 @@ public class DataPivotTable {
 
 		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"));
+		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");
@@ -600,18 +598,19 @@ public class DataPivotTable {
 		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"));
+		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.
+	 * 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() {
@@ -622,98 +621,99 @@ public class DataPivotTable {
 		CalcUtil.selectRange("A1:E27");
 		calc.menuItem("Data->DataPilot->Start...").select();
 		CreateDataPilotTableDialog.ok();
-		if(DataPilotAutomaticallyUpdateCheckBox.isChecked()==false){
+		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"));
+		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"));
+		assertEquals("Locale", CalcUtil.getCellText("A1"));
 		sleep(1);
 
-		DataPilotFieldSelect.click(1,30);
+		DataPilotFieldSelect.click(1, 30);
 		DataPilotFieldSelect.openContextMenu();
 		menuItem("Add to Column").select();
-		assertEquals("Name",CalcUtil.getCellText("B1"));
+		assertEquals("Name", CalcUtil.getCellText("B1"));
 		sleep(1);
 
-		DataPilotFieldSelect.click(1,50);
+		DataPilotFieldSelect.click(1, 50);
 		DataPilotFieldSelect.openContextMenu();
 		menuItem("Add to Row").select();
-		assertEquals("Date",CalcUtil.getCellText("A3"));
+		assertEquals("Date", CalcUtil.getCellText("A3"));
 		sleep(1);
 
-		DataPilotFieldSelect.click(1,70);
+		DataPilotFieldSelect.click(1, 70);
 		DataPilotFieldSelect.openContextMenu();
 		menuItem("Add to Row").select();
-		assertEquals("Order Number",CalcUtil.getCellText("B3"));
+		assertEquals("Order Number", CalcUtil.getCellText("B3"));
 		sleep(1);
 
-		DataPilotFieldSelect.click(1,90);
+		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"));
+		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"));
+		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"));
+		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"));
+		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.click(1, 1);
 		DataPilotColumnArea.openContextMenu();
 		menuItem("Move Down").select();
-		assertEquals("Name",CalcUtil.getCellText("C1"));
-		assertEquals("Locale",CalcUtil.getCellText("D1"));
+		assertEquals("Name", CalcUtil.getCellText("C1"));
+		assertEquals("Locale", CalcUtil.getCellText("D1"));
 		sleep(1);
 
-		DataPilotPaneRowArea.click(1,30);
+		DataPilotPaneRowArea.click(1, 30);
 		DataPilotPaneRowArea.openContextMenu();
 		menuItem("Move Up").select();
-		assertEquals("Order Number",CalcUtil.getCellText("A3"));
-		assertEquals("Date",CalcUtil.getCellText("B3"));
+		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"));
+		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.
+	 * 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() {
@@ -724,75 +724,76 @@ public class DataPivotTable {
 		CalcUtil.selectRange("A1:E27");
 		calc.menuItem("Data->DataPilot->Start...").select();
 		CreateDataPilotTableDialog.ok();
-		if(DataPilotAutomaticallyUpdateCheckBox.isChecked()==false){
+		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"));
+		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"));
+		assertEquals("Locale", CalcUtil.getCellText("A1"));
 		sleep(1);
 
-		DataPilotFieldSelect.click(1,30);
+		DataPilotFieldSelect.click(1, 30);
 		DataPilotFieldSelect.openContextMenu();
 		menuItem("Add to Column").select();
-		assertEquals("Name",CalcUtil.getCellText("B1"));
+		assertEquals("Name", CalcUtil.getCellText("B1"));
 		sleep(1);
 
-		DataPilotFieldSelect.click(1,50);
+		DataPilotFieldSelect.click(1, 50);
 		DataPilotFieldSelect.openContextMenu();
 		menuItem("Add to Row").select();
-		assertEquals("Date",CalcUtil.getCellText("A3"));
+		assertEquals("Date", CalcUtil.getCellText("A3"));
 		sleep(1);
 
-		DataPilotFieldSelect.click(1,70);
+		DataPilotFieldSelect.click(1, 70);
 		DataPilotFieldSelect.openContextMenu();
 		menuItem("Add to Row").select();
-		assertEquals("Order Number",CalcUtil.getCellText("B3"));
+		assertEquals("Order Number", CalcUtil.getCellText("B3"));
 		sleep(1);
 
-		DataPilotFieldSelect.click(1,90);
+		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"));
+		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"));
+		DataPilotPaneRowArea.drag(1, 1, 1, -50);
+		assertEquals("Date", CalcUtil.getCellText("D1"));
+		assertEquals("32779.17", CalcUtil.getCellInput("AB31"));
 		sleep(1);
 
-		DataPilotColumnArea.click(1,50);
+		DataPilotColumnArea.click(1, 50);
 		DataPilotColumnArea.openContextMenu();
 		menuItem("Move to Row").select();
-		assertEquals("Date",CalcUtil.getCellText("B3"));
-		assertEquals("32779.17",CalcUtil.getCellInput("K30"));
+		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"));
+		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"));
+		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.
+	 * 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() {
@@ -803,73 +804,73 @@ public class DataPivotTable {
 		CalcUtil.selectRange("A1:E27");
 		calc.menuItem("Data->DataPilot->Start...").select();
 		CreateDataPilotTableDialog.ok();
-		if(DataPilotAutomaticallyUpdateCheckBox.isChecked()==false){
+		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"));
+		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"));
+		assertEquals("Locale", CalcUtil.getCellText("A1"));
 		sleep(1);
 
-		DataPilotFieldSelect.click(1,30);
+		DataPilotFieldSelect.click(1, 30);
 		DataPilotFieldSelect.openContextMenu();
 		menuItem("Add to Column").select();
-		assertEquals("Name",CalcUtil.getCellText("B1"));
+		assertEquals("Name", CalcUtil.getCellText("B1"));
 		sleep(1);
 
-		DataPilotFieldSelect.click(1,50);
+		DataPilotFieldSelect.click(1, 50);
 		DataPilotFieldSelect.openContextMenu();
 		menuItem("Add to Row").select();
-		assertEquals("Date",CalcUtil.getCellText("A3"));
+		assertEquals("Date", CalcUtil.getCellText("A3"));
 		sleep(1);
 
-		DataPilotFieldSelect.click(1,70);
+		DataPilotFieldSelect.click(1, 70);
 		DataPilotFieldSelect.openContextMenu();
 		menuItem("Add to Row").select();
-		assertEquals("Order Number",CalcUtil.getCellText("B3"));
+		assertEquals("Order Number", CalcUtil.getCellText("B3"));
 		sleep(1);
 
-		DataPilotFieldSelect.click(1,90);
+		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"));
+		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"));
+		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"));
+		assertEquals("Date", CalcUtil.getCellText("D1"));
+		assertEquals("32779.17", CalcUtil.getCellInput("AB31"));
 		sleep(1);
 
-		DataPilotColumnArea.click(1,50);
+		DataPilotColumnArea.click(1, 50);
 		DataPilotColumnArea.openContextMenu();
 		menuItem("Move to Row").select();
-		assertEquals("Date",CalcUtil.getCellText("D1"));
-		assertEquals("32779.17",CalcUtil.getCellInput("AB31"));
+		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"));
+		assertEquals("Date", CalcUtil.getCellText("B3"));
+		assertEquals("32779.17", CalcUtil.getCellInput("K30"));
 		sleep(1);
 
 		DataPilotAutomaticallyUpdateCheckBox.check();
@@ -878,9 +879,10 @@ public class DataPivotTable {
 	/**
 	 * 
 	 * 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.
+	 * 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() {
@@ -891,22 +893,22 @@ public class DataPivotTable {
 		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"));
+		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){
+		if (DataPilotAutomaticallyUpdateCheckBox.isChecked() == false) {
 			DataPilotAutomaticallyUpdateCheckBox.check();
 		}
 
 		DataPilotFieldSelect.click(1, 1);
 		DataPilotFieldSelect.openContextMenu();
 		menuItem("Add to Page").select();
-		assertEquals("Locale",CalcUtil.getCellText("A1"));
+		assertEquals("Locale", CalcUtil.getCellText("A1"));
 		sleep(1);
 
 		CalcUtil.selectRange("A1:B4");
@@ -926,25 +928,25 @@ public class DataPivotTable {
 		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"));
+		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"));
+		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"));
 	}
 
 	/**
@@ -968,33 +970,33 @@ public class DataPivotTable {
 		DataPilotTableToExistPlaceEditBox.setText("$A.$F$1048540");
 		CreateDataPilotTableDialog.ok();
 		sleep(1);
-		if(DataPilotAutomaticallyUpdateCheckBox.isChecked()==false){
+		if (DataPilotAutomaticallyUpdateCheckBox.isChecked() == false) {
 			DataPilotAutomaticallyUpdateCheckBox.check();
 
 		}
 		DataPilotFieldSelect.click(1, 1);
 		DataPilotFieldSelect.openContextMenu();
 		menuItem("Add to Page").select();
-		assertEquals("Locale",CalcUtil.getCellText("F1048540"));
+		assertEquals("Locale", CalcUtil.getCellText("F1048540"));
 		sleep(1);
 
-		DataPilotFieldSelect.click(1,30);
+		DataPilotFieldSelect.click(1, 30);
 		DataPilotFieldSelect.openContextMenu();
 		menuItem("Add to Column").select();
-		assertEquals("Name",CalcUtil.getCellText("F1048542"));
+		assertEquals("Name", CalcUtil.getCellText("F1048542"));
 		sleep(1);
 
-		DataPilotFieldSelect.click(1,50);
+		DataPilotFieldSelect.click(1, 50);
 		DataPilotFieldSelect.openContextMenu();
 		menuItem("Add to Row").select();
-		assertEquals("Date",CalcUtil.getCellText("F1048543"));
+		assertEquals("Date", CalcUtil.getCellText("F1048543"));
 		sleep(1);
 
-		DataPilotFieldSelect.click(1,70);
+		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"));
+		assertEquals("Sum - Order Number", CalcUtil.getCellText("F1048542"));
+		assertEquals("266773", CalcUtil.getCellText("O1048562"));
 		sleep(1);
 
 		CalcUtil.selectRange("D1048541");
@@ -1003,12 +1005,13 @@ public class DataPivotTable {
 
 		CalcUtil.selectRange("O1048562");
 		calc.menuItem("Data->DataPilot->Refresh").select();
-		assertEquals("266525",CalcUtil.getCellText("O1048562"));
+		assertEquals("266525", CalcUtil.getCellText("O1048562"));
 	}
 
 	/**
 	 * 
-	 * Verify that DP panel will be synchronized with table while remove fields on panel.
+	 * 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() {
@@ -1019,83 +1022,83 @@ public class DataPivotTable {
 		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"));
+		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){
+		if (DataPilotAutomaticallyUpdateCheckBox.isChecked() == false) {
 			DataPilotAutomaticallyUpdateCheckBox.check();
 		}
 
 		DataPilotFieldSelect.click(1, 1);
 		DataPilotFieldSelect.openContextMenu();
 		menuItem("Add to Page").select();
-		assertEquals("Locale",CalcUtil.getCellText("A1"));
+		assertEquals("Locale", CalcUtil.getCellText("A1"));
 		sleep(1);
 
-		DataPilotFieldSelect.click(1,30);
+		DataPilotFieldSelect.click(1, 30);
 		DataPilotFieldSelect.openContextMenu();
 		menuItem("Add to Column").select();
-		assertEquals("Name",CalcUtil.getCellText("A3"));
+		assertEquals("Name", CalcUtil.getCellText("A3"));
 		sleep(1);
 
-		DataPilotFieldSelect.click(1,50);
+		DataPilotFieldSelect.click(1, 50);
 		DataPilotFieldSelect.openContextMenu();
 		menuItem("Add to Row").select();
-		assertEquals("Date",CalcUtil.getCellText("A4"));
+		assertEquals("Date", CalcUtil.getCellText("A4"));
 		sleep(1);
 
-		DataPilotFieldSelect.click(1,70);
+		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"));
+		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"));
+		assertEquals("Name", CalcUtil.getCellText("B3"));
+		assertEquals("266773", CalcUtil.getCellText("J23"));
 		sleep(1);
 
-		DataPilotPaneRowArea.click(1,1);
+		DataPilotPaneRowArea.click(1, 1);
 		DataPilotPaneRowArea.openContextMenu();
 		menuItem("Remove").select();
-		assertEquals("Date",CalcUtil.getCellText("A4"));
-		assertEquals("266773",CalcUtil.getCellText("J23"));
+		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"));
+		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"));
+		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"));
+		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 
+	 * Verify the Remove function of Grouped field
 	 */
 	@Ignore("DataPilot in symphony is totally not the same in AOO")
 	public void testRemoveFunctionOfGroupedField() {
@@ -1104,66 +1107,67 @@ public class DataPivotTable {
 		submitOpenDlg(file);
 		sleep(2);
 		CalcUtil.selectRange("A1:E27");
-		calc.menuItem("Data->DataPilot->Start...").select();		
+		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"));
+		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){
+		if (DataPilotAutomaticallyUpdateCheckBox.isChecked() == false) {
 			DataPilotAutomaticallyUpdateCheckBox.check();
 		}
 
 		DataPilotFieldSelect.click(1, 1);
 		DataPilotFieldSelect.openContextMenu();
 		menuItem("Add to Page").select();
-		assertEquals("Locale",CalcUtil.getCellText("A1"));
+		assertEquals("Locale", CalcUtil.getCellText("A1"));
 		sleep(1);
 
-		DataPilotFieldSelect.click(1,30);
+		DataPilotFieldSelect.click(1, 30);
 		DataPilotFieldSelect.openContextMenu();
 		menuItem("Add to Column").select();
-		assertEquals("Name",CalcUtil.getCellText("A3"));
+		assertEquals("Name", CalcUtil.getCellText("A3"));
 		sleep(1);
 
-		DataPilotFieldSelect.click(1,50);
+		DataPilotFieldSelect.click(1, 50);
 		DataPilotFieldSelect.openContextMenu();
 		menuItem("Add to Row").select();
-		assertEquals("Date",CalcUtil.getCellText("A4"));
+		assertEquals("Date", CalcUtil.getCellText("A4"));
 		sleep(1);
 
-		DataPilotFieldSelect.click(1,70);
+		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"));
+		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"));
+		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"));
+		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.
+	 * 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() {
@@ -1174,57 +1178,57 @@ public class DataPivotTable {
 		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"));
+		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){
+		if (DataPilotAutomaticallyUpdateCheckBox.isChecked() == false) {
 			DataPilotAutomaticallyUpdateCheckBox.check();
 		}
 
 		DataPilotFieldSelect.click(1, 1);
 		DataPilotFieldSelect.openContextMenu();
 		menuItem("Add to Page").select();
-		assertEquals("Locale",CalcUtil.getCellText("A1"));
+		assertEquals("Locale", CalcUtil.getCellText("A1"));
 		sleep(1);
 
-		DataPilotFieldSelect.click(1,30);
+		DataPilotFieldSelect.click(1, 30);
 		DataPilotFieldSelect.openContextMenu();
 		menuItem("Add to Column").select();
-		assertEquals("Name",CalcUtil.getCellText("A3"));
+		assertEquals("Name", CalcUtil.getCellText("A3"));
 		sleep(1);
 
-		DataPilotFieldSelect.click(1,50);
+		DataPilotFieldSelect.click(1, 50);
 		DataPilotFieldSelect.openContextMenu();
 		menuItem("Add to Row").select();
-		assertEquals("Date",CalcUtil.getCellText("A4"));
+		assertEquals("Date", CalcUtil.getCellText("A4"));
 		sleep(1);
 
-		DataPilotFieldSelect.click(1,70);
+		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"));
+		assertEquals("Sum - Order Number", CalcUtil.getCellText("A3"));
+		assertEquals("266773", CalcUtil.getCellText("J23"));
 		sleep(1);
 
-		DataPilotPanePageArea.click(1,1);
+		DataPilotPanePageArea.click(1, 1);
 		DataPilotPanePageArea.openContextMenu();
 		menuItem("Field Option").select();
 		DataPilotFieldDisplayNameEditBox.setText("New Locale");
 		DataPilotFieldOptionFieldTabPageDialog.ok();
-		assertEquals("New Locale",CalcUtil.getCellText("A1"));
+		assertEquals("New Locale", CalcUtil.getCellText("A1"));
 		sleep(1);
 
 		typeKeys("<$undo>");
-		assertEquals("Locale",CalcUtil.getCellText("A1"));
+		assertEquals("Locale", CalcUtil.getCellText("A1"));
 		sleep(1);
 
 		typeKeys("<$redo>");
-		assertEquals("New Locale",CalcUtil.getCellText("A1"));
+		assertEquals("New Locale", CalcUtil.getCellText("A1"));
 		sleep(1);
 
 		CalcUtil.selectRange("B3");
@@ -1232,15 +1236,15 @@ public class DataPivotTable {
 		menuItem("Field Option...").select();
 		DataPilotFieldDisplayNameEditBox.setText("New Name");
 		DataPilotFieldOptionFieldTabPageDialog.ok();
-		assertEquals("New Name",CalcUtil.getCellText("B3"));
+		assertEquals("New Name", CalcUtil.getCellText("B3"));
 		sleep(1);
 
 		typeKeys("<$undo>");
-		assertEquals("Name",CalcUtil.getCellText("B3"));
+		assertEquals("Name", CalcUtil.getCellText("B3"));
 		sleep(1);
 
 		typeKeys("<$redo>");
-		assertEquals("New Name",CalcUtil.getCellText("B3"));
+		assertEquals("New Name", CalcUtil.getCellText("B3"));
 		sleep(1);
 
 		CalcUtil.selectRange("A4");
@@ -1248,36 +1252,37 @@ public class DataPivotTable {
 		menuItem("Field Option...").select();
 		DataPilotFieldDisplayNameEditBox.setText("New Date");
 		DataPilotFieldOptionFieldTabPageDialog.ok();
-		assertEquals("New Date",CalcUtil.getCellText("A4"));
+		assertEquals("New Date", CalcUtil.getCellText("A4"));
 		sleep(1);
 
 		typeKeys("<$undo>");
-		assertEquals("Date",CalcUtil.getCellText("A4"));
+		assertEquals("Date", CalcUtil.getCellText("A4"));
 		sleep(1);
 
 		typeKeys("<$redo>");
-		assertEquals("New Date",CalcUtil.getCellText("A4"));
+		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"));
+		assertEquals("New Sum - Order Number", CalcUtil.getCellText("A3"));
 		sleep(1);
 
 		typeKeys("<$undo>");
-		assertEquals("Sum - Order Number",CalcUtil.getCellText("A3"));
+		assertEquals("Sum - Order Number", CalcUtil.getCellText("A3"));
 		sleep(1);
 
 		typeKeys("<$redo>");
-		assertEquals("New Sum - Order Number",CalcUtil.getCellText("A3"));
+		assertEquals("New Sum - Order Number", CalcUtil.getCellText("A3"));
 		sleep(1);
 	}
 
 	/**
 	 * 
-	 * Verify that DP panel will be synchronized with table while add fields on panel.
+	 * 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() {
@@ -1286,52 +1291,52 @@ public class DataPivotTable {
 		submitOpenDlg(file);
 		sleep(2);
 		CalcUtil.selectRange("A1:E27");
-		calc.menuItem("Data->DataPilot->Start...").select();		
+		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"));
+		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){
+		if (DataPilotAutomaticallyUpdateCheckBox.isChecked() == false) {
 			DataPilotAutomaticallyUpdateCheckBox.check();
 		}
 
 		DataPilotFieldSelect.click(1, 1);
 		DataPilotFieldSelect.openContextMenu();
 		menuItem("Add to Page").select();
-		assertEquals("Locale",CalcUtil.getCellText("A1"));
+		assertEquals("Locale", CalcUtil.getCellText("A1"));
 		sleep(1);
 
-		DataPilotFieldSelect.click(1,30);
+		DataPilotFieldSelect.click(1, 30);
 		DataPilotFieldSelect.openContextMenu();
 		menuItem("Add to Column").select();
-		assertEquals("Name",CalcUtil.getCellText("A3"));
+		assertEquals("Name", CalcUtil.getCellText("A3"));
 		sleep(1);
 
-		DataPilotFieldSelect.click(1,50);
+		DataPilotFieldSelect.click(1, 50);
 		DataPilotFieldSelect.openContextMenu();
 		menuItem("Add to Row").select();
-		assertEquals("Date",CalcUtil.getCellText("A4"));
+		assertEquals("Date", CalcUtil.getCellText("A4"));
 		sleep(1);
 
-		DataPilotFieldSelect.click(1,70);
+		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"));
+		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"));
+		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");
@@ -1344,28 +1349,29 @@ public class DataPivotTable {
 		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"));
+		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"));
+		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"));
+		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.
+	 * 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() {
@@ -1374,52 +1380,52 @@ public class DataPivotTable {
 		submitOpenDlg(file);
 		sleep(2);
 		CalcUtil.selectRange("A1:E27");
-		calc.menuItem("Data->DataPilot->Start...").select();		
+		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"));
+		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){
+		if (DataPilotAutomaticallyUpdateCheckBox.isChecked() == false) {
 			DataPilotAutomaticallyUpdateCheckBox.check();
 		}
 
 		DataPilotFieldSelect.click(1, 1);
 		DataPilotFieldSelect.openContextMenu();
 		menuItem("Add to Page").select();
-		assertEquals("Locale",CalcUtil.getCellText("A1"));
+		assertEquals("Locale", CalcUtil.getCellText("A1"));
 		sleep(1);
 
-		DataPilotFieldSelect.click(1,30);
+		DataPilotFieldSelect.click(1, 30);
 		DataPilotFieldSelect.openContextMenu();
 		menuItem("Add to Column").select();
-		assertEquals("Name",CalcUtil.getCellText("A3"));
+		assertEquals("Name", CalcUtil.getCellText("A3"));
 		sleep(1);
 
-		DataPilotFieldSelect.click(1,50);
+		DataPilotFieldSelect.click(1, 50);
 		DataPilotFieldSelect.openContextMenu();
 		menuItem("Add to Row").select();
-		assertEquals("Date",CalcUtil.getCellText("A4"));
+		assertEquals("Date", CalcUtil.getCellText("A4"));
 		sleep(1);
 
-		DataPilotFieldSelect.click(1,70);
+		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"));
+		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"));
+		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");
@@ -1430,85 +1436,86 @@ public class DataPivotTable {
 
 		DataPilotFieldOptionSubTotalsManuallyRadioButton.check();
 
-		SC_DataPilotOptionSubtotalFunctionList.click(9,24);
+		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("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("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("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("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("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("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"));
+		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("Emmy Ma", CalcUtil.getCellText("C4"));
+		assertEquals("20518", CalcUtil.getCellText("C24"));
 
-		assertEquals("",CalcUtil.getCellText("E4"));
-		assertEquals("20528",CalcUtil.getCellText("E24"));
+		assertEquals("", CalcUtil.getCellText("E4"));
+		assertEquals("20528", CalcUtil.getCellText("E24"));
 
-		assertEquals("Joe Liu",CalcUtil.getCellText("H4"));
-		assertEquals("41056",CalcUtil.getCellText("H24"));
+		assertEquals("Joe Liu", CalcUtil.getCellText("H4"));
+		assertEquals("41056", CalcUtil.getCellText("H24"));
 
-		assertEquals("Total Result",CalcUtil.getCellText("J4"));
-		assertEquals("266773",CalcUtil.getCellText("J24"));
+		assertEquals("Total Result", CalcUtil.getCellText("J4"));
+		assertEquals("266773", CalcUtil.getCellText("J24"));
 
-		assertEquals("",CalcUtil.getCellText("L4"));
-		assertEquals("",CalcUtil.getCellText("L24"));
+		assertEquals("", CalcUtil.getCellText("L4"));
+		assertEquals("", CalcUtil.getCellText("L24"));
 
-		assertEquals("",CalcUtil.getCellText("N4"));
-		assertEquals("",CalcUtil.getCellText("N24"));
+		assertEquals("", CalcUtil.getCellText("N4"));
+		assertEquals("", CalcUtil.getCellText("N24"));
 
-		assertEquals("",CalcUtil.getCellText("P4"));
-		assertEquals("",CalcUtil.getCellText("P24"));
-		assertEquals("",CalcUtil.getCellText("Q24"));
+		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("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("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("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("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("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("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"));
+		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.
+	 * 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() {
@@ -1517,65 +1524,64 @@ public class DataPivotTable {
 		submitOpenDlg(file);
 		sleep(2);
 		CalcUtil.selectRange("A1:E27");
-		calc.menuItem("Data->DataPilot->Start...").select();		
+		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"));
+		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){
+		if (DataPilotAutomaticallyUpdateCheckBox.isChecked() == false) {
 			DataPilotAutomaticallyUpdateCheckBox.check();
 		}
 
 		DataPilotFieldSelect.click(1, 1);
 		DataPilotFieldSelect.openContextMenu();
 		menuItem("Add to Page").select();
-		assertEquals("Locale",CalcUtil.getCellText("A1"));
+		assertEquals("Locale", CalcUtil.getCellText("A1"));
 		sleep(1);
 
-		DataPilotFieldSelect.click(1,30);
+		DataPilotFieldSelect.click(1, 30);
 		DataPilotFieldSelect.openContextMenu();
 		menuItem("Add to Column").select();
-		assertEquals("Name",CalcUtil.getCellText("A3"));
+		assertEquals("Name", CalcUtil.getCellText("A3"));
 		sleep(1);
 
-		DataPilotFieldSelect.click(1,50);
+		DataPilotFieldSelect.click(1, 50);
 		DataPilotFieldSelect.openContextMenu();
 		menuItem("Add to Row").select();
-		assertEquals("Date",CalcUtil.getCellText("A4"));
+		assertEquals("Date", CalcUtil.getCellText("A4"));
 		sleep(1);
 
-		DataPilotFieldSelect.click(1,70);
+		DataPilotFieldSelect.click(1, 70);
 		DataPilotFieldSelect.openContextMenu();
 		menuItem("Add to Data by->Sum").select();

[... 168 lines stripped ...]


Mime
View raw message