You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@openoffice.apache.org by li...@apache.org on 2012/08/30 11:27:23 UTC
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...
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 ...]