diff options
Diffstat (limited to 'sc/qa/uitest/calc_tests3/tdf77509.py')
-rw-r--r-- | sc/qa/uitest/calc_tests3/tdf77509.py | 102 |
1 files changed, 50 insertions, 52 deletions
diff --git a/sc/qa/uitest/calc_tests3/tdf77509.py b/sc/qa/uitest/calc_tests3/tdf77509.py index 4d2571c554dc..79e228c180da 100644 --- a/sc/qa/uitest/calc_tests3/tdf77509.py +++ b/sc/qa/uitest/calc_tests3/tdf77509.py @@ -13,65 +13,63 @@ from libreoffice.uno.propertyvalue import mkPropertyValues class tdf77509(UITestCase): def test_tdf77509_consolidate(self): - calc_doc = self.ui_test.load_file(get_url_for_data_file("tdf77509.xls")) - xCalcDoc = self.xUITest.getTopFocusWindow() - gridwin = xCalcDoc.getChild("grid_window") - document = self.ui_test.get_component() - #1. Open attachment: Consolidate-test.xls - #2. Select any empty cell, eg. cell D1 - gridwin.executeAction("SELECT", mkPropertyValues({"CELL": "D1"})) - #3. Tab: Data > Consolidate - self.ui_test.execute_modeless_dialog_through_command(".uno:DataConsolidate") - xDialog = self.xUITest.getTopFocusWindow() + with self.ui_test.load_file(get_url_for_data_file("tdf77509.xls")) as calc_doc: + xCalcDoc = self.xUITest.getTopFocusWindow() + gridwin = xCalcDoc.getChild("grid_window") + document = self.ui_test.get_component() + #1. Open attachment: Consolidate-test.xls + #2. Select any empty cell, eg. cell D1 + gridwin.executeAction("SELECT", mkPropertyValues({"CELL": "D1"})) + #3. Tab: Data > Consolidate + self.ui_test.execute_modeless_dialog_through_command(".uno:DataConsolidate") + xDialog = self.xUITest.getTopFocusWindow() - xfunc = xDialog.getChild("func") - xeddataarea = xDialog.getChild("eddataarea") - xadd = xDialog.getChild("add") - xbyrow = xDialog.getChild("byrow") - xbycol = xDialog.getChild("bycol") - xeddestarea = xDialog.getChild("eddestarea") + xfunc = xDialog.getChild("func") + xeddataarea = xDialog.getChild("eddataarea") + xadd = xDialog.getChild("add") + xbyrow = xDialog.getChild("byrow") + xbycol = xDialog.getChild("bycol") + xeddestarea = xDialog.getChild("eddestarea") - select_by_text(xfunc, "Sum") - #4. Source data ranges: $Sheet1.$A$1:$B$7 - #5. Click 'Add' so that ranges appear in "Consolidation ranges" - xeddataarea.executeAction("TYPE", mkPropertyValues({"TEXT":"$Sheet1.$A$1:$B$7"})) - xadd.executeAction("CLICK", tuple()) + select_by_text(xfunc, "Sum") + #4. Source data ranges: $Sheet1.$A$1:$B$7 + #5. Click 'Add' so that ranges appear in "Consolidation ranges" + xeddataarea.executeAction("TYPE", mkPropertyValues({"TEXT":"$Sheet1.$A$1:$B$7"})) + xadd.executeAction("CLICK", tuple()) - xConsAreas = xDialog.getChild("consareas") - self.assertEqual(1, len(xConsAreas.getChildren())) - self.assertEqual("$Sheet1.$A$1:$B$7", get_state_as_dict(xConsAreas.getChild("0"))['Text']) + xConsAreas = xDialog.getChild("consareas") + self.assertEqual(1, len(xConsAreas.getChildren())) + self.assertEqual("$Sheet1.$A$1:$B$7", get_state_as_dict(xConsAreas.getChild("0"))['Text']) - #6. Click 'Options' > check 'Row labels' > click OK - xbyrow.executeAction("CLICK", tuple()) - xOKBtn = xDialog.getChild("ok") - self.ui_test.close_dialog_through_button(xOKBtn) - #verify - self.assertEqual("A 1", get_cell_by_position(document, 0, 3, 0).getString()) - self.assertEqual("AB 1", get_cell_by_position(document, 0, 3, 1).getString()) - self.assertEqual("AB 12", get_cell_by_position(document, 0, 3, 2).getString()) - self.assertEqual("AB 123", get_cell_by_position(document, 0, 3, 3).getString()) - self.assertEqual("ABC 1", get_cell_by_position(document, 0, 3, 4).getString()) + #6. Click 'Options' > check 'Row labels' > click OK + xbyrow.executeAction("CLICK", tuple()) + xOKBtn = xDialog.getChild("ok") + self.ui_test.close_dialog_through_button(xOKBtn) + #verify + self.assertEqual("A 1", get_cell_by_position(document, 0, 3, 0).getString()) + self.assertEqual("AB 1", get_cell_by_position(document, 0, 3, 1).getString()) + self.assertEqual("AB 12", get_cell_by_position(document, 0, 3, 2).getString()) + self.assertEqual("AB 123", get_cell_by_position(document, 0, 3, 3).getString()) + self.assertEqual("ABC 1", get_cell_by_position(document, 0, 3, 4).getString()) - self.assertEqual(1, get_cell_by_position(document, 0, 4, 0).getValue()) - self.assertEqual(2, get_cell_by_position(document, 0, 4, 1).getValue()) - self.assertEqual(2, get_cell_by_position(document, 0, 4, 2).getValue()) - self.assertEqual(1, get_cell_by_position(document, 0, 4, 3).getValue()) - self.assertEqual(1, get_cell_by_position(document, 0, 4, 4).getValue()) + self.assertEqual(1, get_cell_by_position(document, 0, 4, 0).getValue()) + self.assertEqual(2, get_cell_by_position(document, 0, 4, 1).getValue()) + self.assertEqual(2, get_cell_by_position(document, 0, 4, 2).getValue()) + self.assertEqual(1, get_cell_by_position(document, 0, 4, 3).getValue()) + self.assertEqual(1, get_cell_by_position(document, 0, 4, 4).getValue()) - self.xUITest.executeCommand(".uno:Undo") + self.xUITest.executeCommand(".uno:Undo") - self.assertEqual("", get_cell_by_position(document, 0, 3, 0).getString()) - self.assertEqual("", get_cell_by_position(document, 0, 3, 1).getString()) - self.assertEqual("", get_cell_by_position(document, 0, 3, 2).getString()) - self.assertEqual("", get_cell_by_position(document, 0, 3, 3).getString()) - self.assertEqual("", get_cell_by_position(document, 0, 3, 4).getString()) + self.assertEqual("", get_cell_by_position(document, 0, 3, 0).getString()) + self.assertEqual("", get_cell_by_position(document, 0, 3, 1).getString()) + self.assertEqual("", get_cell_by_position(document, 0, 3, 2).getString()) + self.assertEqual("", get_cell_by_position(document, 0, 3, 3).getString()) + self.assertEqual("", get_cell_by_position(document, 0, 3, 4).getString()) - self.assertEqual(0, get_cell_by_position(document, 0, 4, 0).getValue()) - self.assertEqual(0, get_cell_by_position(document, 0, 4, 1).getValue()) - self.assertEqual(0, get_cell_by_position(document, 0, 4, 2).getValue()) - self.assertEqual(0, get_cell_by_position(document, 0, 4, 3).getValue()) - self.assertEqual(0, get_cell_by_position(document, 0, 4, 4).getValue()) - - self.ui_test.close_doc() + self.assertEqual(0, get_cell_by_position(document, 0, 4, 0).getValue()) + self.assertEqual(0, get_cell_by_position(document, 0, 4, 1).getValue()) + self.assertEqual(0, get_cell_by_position(document, 0, 4, 2).getValue()) + self.assertEqual(0, get_cell_by_position(document, 0, 4, 3).getValue()) + self.assertEqual(0, get_cell_by_position(document, 0, 4, 4).getValue()) # vim: set shiftwidth=4 softtabstop=4 expandtab: |