diff options
Diffstat (limited to 'sc/qa/uitest/calc_tests6/tdf107267.py')
-rw-r--r-- | sc/qa/uitest/calc_tests6/tdf107267.py | 102 |
1 files changed, 50 insertions, 52 deletions
diff --git a/sc/qa/uitest/calc_tests6/tdf107267.py b/sc/qa/uitest/calc_tests6/tdf107267.py index e8dd2857a252..8416cb62e2ae 100644 --- a/sc/qa/uitest/calc_tests6/tdf107267.py +++ b/sc/qa/uitest/calc_tests6/tdf107267.py @@ -17,62 +17,60 @@ class Subtotals(UITestCase): def test_tdf107267(self): - calc_doc = self.ui_test.load_file(get_url_for_data_file("tdf107267.ods")) - XcalcDoc = self.xUITest.getTopFocusWindow() - document = self.ui_test.get_component() - gridwin = XcalcDoc.getChild("grid_window") - # 1. Open the test file - gridwin.executeAction("SELECT", mkPropertyValues({"RANGE": "A1:F123"})) - # 2. Data->Subtotals - self.ui_test.execute_dialog_through_command(".uno:DataSubTotals") - xDialog = self.xUITest.getTopFocusWindow() - xTabs = xDialog.getChild("tabcontrol") - select_pos(xTabs, "0") - # = 1st group = 3. Group by "Person Number", select "shipping time" and use the Max function. - xGroupBy = xDialog.getChild("group_by") - select_by_text(xGroupBy, "Person Number") - # 4. Tick 'Calculate subtotals for' -> "shipping time" - already selected -# xCheckListMenu = xDialog.getChild("grid1") -# xTreeList = xCheckListMenu.getChild("columns") -# x6Entry = xTreeList.getChild("5") -# xFirstEntry.executeAction("CLICK", tuple()) - #use the Max function + with self.ui_test.load_file(get_url_for_data_file("tdf107267.ods")) as calc_doc: + XcalcDoc = self.xUITest.getTopFocusWindow() + document = self.ui_test.get_component() + gridwin = XcalcDoc.getChild("grid_window") + # 1. Open the test file + gridwin.executeAction("SELECT", mkPropertyValues({"RANGE": "A1:F123"})) + # 2. Data->Subtotals + self.ui_test.execute_dialog_through_command(".uno:DataSubTotals") + xDialog = self.xUITest.getTopFocusWindow() + xTabs = xDialog.getChild("tabcontrol") + select_pos(xTabs, "0") + # = 1st group = 3. Group by "Person Number", select "shipping time" and use the Max function. + xGroupBy = xDialog.getChild("group_by") + select_by_text(xGroupBy, "Person Number") + # 4. Tick 'Calculate subtotals for' -> "shipping time" - already selected + # xCheckListMenu = xDialog.getChild("grid1") + # xTreeList = xCheckListMenu.getChild("columns") + # x6Entry = xTreeList.getChild("5") + # xFirstEntry.executeAction("CLICK", tuple()) + #use the Max function - #= 2nd group =5. Group by "Person Number", select "shipping time" and use the Min function. - select_pos(xTabs, "1") - xGroupBy = xDialog.getChild("group_by") - select_by_text(xGroupBy, "Person Number") - # 4. Tick 'Calculate subtotals for' -> "shipping time" - already selected -# xCheckListMenu = xDialog.getChild("grid1") -# xTreeList = xCheckListMenu.getChild("columns") -# x6Entry = xTreeList.getChild("5") -# xFirstEntry.executeAction("CLICK", tuple()) - #use the Min function + #= 2nd group =5. Group by "Person Number", select "shipping time" and use the Min function. + select_pos(xTabs, "1") + xGroupBy = xDialog.getChild("group_by") + select_by_text(xGroupBy, "Person Number") + # 4. Tick 'Calculate subtotals for' -> "shipping time" - already selected + # xCheckListMenu = xDialog.getChild("grid1") + # xTreeList = xCheckListMenu.getChild("columns") + # x6Entry = xTreeList.getChild("5") + # xFirstEntry.executeAction("CLICK", tuple()) + #use the Min function - #= 3rd group = Group by "Person Number", select "shipping time" and use the Average function. - select_pos(xTabs, "2") - xGroupBy = xDialog.getChild("group_by") - select_by_text(xGroupBy, "Person Number") - # 4. Tick 'Calculate subtotals for' -> "shipping time" - already selected -# xCheckListMenu = xDialog.getChild("grid1") -# xTreeList = xCheckListMenu.getChild("columns") -# x6Entry = xTreeList.getChild("5") -# xFirstEntry.executeAction("CLICK", tuple()) - #use the Average function + #= 3rd group = Group by "Person Number", select "shipping time" and use the Average function. + select_pos(xTabs, "2") + xGroupBy = xDialog.getChild("group_by") + select_by_text(xGroupBy, "Person Number") + # 4. Tick 'Calculate subtotals for' -> "shipping time" - already selected + # xCheckListMenu = xDialog.getChild("grid1") + # xTreeList = xCheckListMenu.getChild("columns") + # x6Entry = xTreeList.getChild("5") + # xFirstEntry.executeAction("CLICK", tuple()) + #use the Average function - # 5. Click OK - xOKBtn = xDialog.getChild("ok") - self.ui_test.close_dialog_through_button(xOKBtn) + # 5. Click OK + xOKBtn = xDialog.getChild("ok") + self.ui_test.close_dialog_through_button(xOKBtn) - #verify - self.assertEqual(get_cell_by_position(document, 0, 0, 141).getString(), "Grand Average") - self.assertEqual(get_cell_by_position(document, 0, 0, 142).getString(), "Grand Min") - self.assertEqual(get_cell_by_position(document, 0, 0, 143).getString(), "Grand Max") + #verify + self.assertEqual(get_cell_by_position(document, 0, 0, 141).getString(), "Grand Average") + self.assertEqual(get_cell_by_position(document, 0, 0, 142).getString(), "Grand Min") + self.assertEqual(get_cell_by_position(document, 0, 0, 143).getString(), "Grand Max") - self.assertEqual(round(get_cell_by_position(document, 0, 5, 141).getValue(), 13), 3.3852459016393) - self.assertEqual(get_cell_by_position(document, 0, 5, 142).getValue(), 0) - self.assertEqual(get_cell_by_position(document, 0, 5, 143).getValue(), 26) - - self.ui_test.close_doc() + self.assertEqual(round(get_cell_by_position(document, 0, 5, 141).getValue(), 13), 3.3852459016393) + self.assertEqual(get_cell_by_position(document, 0, 5, 142).getValue(), 0) + self.assertEqual(get_cell_by_position(document, 0, 5, 143).getValue(), 26) # vim: set shiftwidth=4 softtabstop=4 expandtab: |