Author: liuzhe
Date: Fri Aug 17 01:47:29 2012
New Revision: 1374125
URL: http://svn.apache.org/viewvc?rev=1374125&view=rev
Log:
#120552# - [Automation][GUI] Insert cells via select insert -》 cells menu.
Patch by: Guo Bin <[email protected]>
Review by: Liu Zhe <[email protected]>
Added:
incubator/ooo/trunk/main/test/testgui/source/testcase/gui/sc/cell/
incubator/ooo/trunk/main/test/testgui/source/testcase/gui/sc/cell/InserCells.java
Added:
incubator/ooo/trunk/main/test/testgui/source/testcase/gui/sc/cell/InserCells.java
URL:
http://svn.apache.org/viewvc/incubator/ooo/trunk/main/test/testgui/source/testcase/gui/sc/cell/InserCells.java?rev=1374125&view=auto
==============================================================================
---
incubator/ooo/trunk/main/test/testgui/source/testcase/gui/sc/cell/InserCells.java
(added)
+++
incubator/ooo/trunk/main/test/testgui/source/testcase/gui/sc/cell/InserCells.java
Fri Aug 17 01:47:29 2012
@@ -0,0 +1,140 @@
+package testcase.gui.sc.cell;
+
+import static org.junit.Assert.*;
+import static testlib.gui.AppUtil.typeKeys;
+import static testlib.gui.UIMap.*;
+
+import org.junit.After;
+import org.junit.Before;
+import org.junit.Rule;
+import org.junit.Test;
+
+import testlib.gui.CalcUtil;
+import testlib.gui.Log;
+
+/**
+ * Before running the testing class, you need specify the AOO location firstly
with system property openoffice.home.
+ *
+ *
+ */
+
+public class InserCells {
+
+ @Rule
+ public Log LOG = new Log();
+
+ @Before
+ public void setUp() throws Exception {
+ app.start();
+ app.dispatch("private:factory/scalc");
+ calc.waitForExistence(10, 3);
+ }
+
+ @After
+ public void tearDown() throws Exception {
+ app.close();
+ }
+
+ /**
+ * Shift row and column, insert entire row and column
+ * @throws Exception
+ */
+
+ @Test
+ public void testShiftRowandColumn(){
+
+ //Input data to cell range A1:B2
+ CalcUtil.selectRange("A1");
+ typeKeys("1<right>2<down><left>3<right>4");
+
+ //Set expected result after executing shift cell down
+ String[][] expectedShiftCellDownResult = new String[][] {
+ {"","2"},
+ {"1","4"},
+ {"3",""},
+ };
+
+ //Select Cell A1
+ CalcUtil.selectRange("Sheet1.A1");
+
+ //Launch insert cells dialog via menu
+ calc.menuItem("Insert->Cells...").select();
+
+ //Select the first option "shift cells down" from dialog
+ typeKeys("<enter>");
+
+ //Verify results after shift one cell down
+ assertArrayEquals("Verify results after shift one cell down",
expectedShiftCellDownResult, CalcUtil.getCellTexts("A1:B3"));
+
+ //Set expected result after executing shift cell right
+ String[][] expectedShiftCellRightResult = new String[][] {
+ {"","1","2"},
+ {"3","4",""},
+ };
+
+ // Undo
+ calc.menuItem("Edit->Undo: Insert").select();
+
+ //Select cell B2
+ CalcUtil.selectRange("Sheet1.A1");
+
+ //Launch insert cells dialog via menu
+ calc.menuItem("Insert->Cells...").select();
+
+ //Select the second option "shift cells right" from dialog
+ typeKeys("<down>");
+ typeKeys("<enter>");
+
+ //Verify results after shift one cell right
+ assertArrayEquals("Verify results after shift one cell right",
expectedShiftCellRightResult, CalcUtil.getCellTexts("A1:C2"));
+
+ //Set expected result after executing insert entire row
+ String[][] expectedEntireRowResult = new String[][] {
+ {"",""},
+ {"1","2"},
+ {"3","4"},
+ };
+
+ // Undo
+ calc.menuItem("Edit->Undo: Insert").select();
+
+ //Select Cell B2
+ CalcUtil.selectRange("Sheet1.A1");
+
+ //Launch insert cells dialog via menu
+ calc.menuItem("Insert->Cells...").select();
+
+ //Select the third option "Entire row" from dialog
+ typeKeys("<down>");
+ typeKeys("<enter>");
+
+ //Verify results after insert entire row
+ assertArrayEquals("Verify results after insert entire row",
expectedEntireRowResult, CalcUtil.getCellTexts("A1:B3"));
+
+ //Set expected result after executing insert entire column
+ String[][] expectedEntireColumnResult = new String[][] {
+
+ {"","1","2"},
+ {"","3","4"},
+ };
+
+ // Undo
+ calc.menuItem("Edit->Undo: Insert").select();
+
+ //Select Cell A1
+ CalcUtil.selectRange("Sheet1.A1");
+
+ //Launch insert cells dialog via menu
+ calc.menuItem("Insert->Cells...").select();
+
+ //Select the fourth option "Entire column" from dialog
+ typeKeys("<down>");
+ typeKeys("<enter>");
+
+ //Verify the results after inserting entire column
+ assertArrayEquals("Verify the results after inserting entire
column", expectedEntireColumnResult, CalcUtil.getCellTexts("A1:C2"));
+
+
+ }
+
+}
