diff options
Diffstat (limited to 'sc/qa/uitest/calc_tests6/tdf118638.py')
-rw-r--r-- | sc/qa/uitest/calc_tests6/tdf118638.py | 74 |
1 files changed, 36 insertions, 38 deletions
diff --git a/sc/qa/uitest/calc_tests6/tdf118638.py b/sc/qa/uitest/calc_tests6/tdf118638.py index cc5c97f34a30..bd1151f569f9 100644 --- a/sc/qa/uitest/calc_tests6/tdf118638.py +++ b/sc/qa/uitest/calc_tests6/tdf118638.py @@ -16,43 +16,41 @@ class Subtotals(UITestCase): def test_tdf118638_subtotal_format(self): - calc_doc = self.ui_test.load_file(get_url_for_data_file("tdf118638.ods")) - XcalcDoc = self.xUITest.getTopFocusWindow() - document = self.ui_test.get_component() - gridwin = XcalcDoc.getChild("grid_window") - # Open the test file - gridwin.executeAction("SELECT", mkPropertyValues({"RANGE": "A1:B15"})) - #Data->Subtotals - self.ui_test.execute_dialog_through_command(".uno:DataSubTotals") - xDialog = self.xUITest.getTopFocusWindow() - xTabs = xDialog.getChild("tabcontrol") - select_pos(xTabs, "0") - xGroupBy = xDialog.getChild("group_by") - select_by_text(xGroupBy, "Store Name") - xCheckListMenu = xDialog.getChild("grid1") - xTreeList = xCheckListMenu.getChild("columns") - xEntry = xTreeList.getChild("1") - xEntry.executeAction("CLICK", tuple()) - - #use the SUM function -# xfunctions = xDialog.getChild("functions") -# propsF = {"TEXT": "Sum"} -# actionPropsF = mkPropertyValues(propsF) -# xfunctions.executeAction("SELECT", actionPropsF) - - xOKBtn = xDialog.getChild("ok") - self.ui_test.close_dialog_through_button(xOKBtn) - - #verify - self.assertEqual(get_cell_by_position(document, 0, 0, 15).getString(), "5408 Sum") - self.assertEqual(get_cell_by_position(document, 0, 0, 16).getString(), "Grand Sum") - - self.assertEqual(round(get_cell_by_position(document, 0, 1, 15).getValue(),12), 238.89) - self.assertEqual(round(get_cell_by_position(document, 0, 1, 16).getValue(),12), 238.89) - - self.assertEqual(get_cell_by_position(document, 0, 1, 15).getString(), "$238.89") - self.assertEqual(get_cell_by_position(document, 0, 1, 16).getString(), "$238.89") - - self.ui_test.close_doc() + with self.ui_test.load_file(get_url_for_data_file("tdf118638.ods")) as calc_doc: + XcalcDoc = self.xUITest.getTopFocusWindow() + document = self.ui_test.get_component() + gridwin = XcalcDoc.getChild("grid_window") + # Open the test file + gridwin.executeAction("SELECT", mkPropertyValues({"RANGE": "A1:B15"})) + #Data->Subtotals + self.ui_test.execute_dialog_through_command(".uno:DataSubTotals") + xDialog = self.xUITest.getTopFocusWindow() + xTabs = xDialog.getChild("tabcontrol") + select_pos(xTabs, "0") + xGroupBy = xDialog.getChild("group_by") + select_by_text(xGroupBy, "Store Name") + xCheckListMenu = xDialog.getChild("grid1") + xTreeList = xCheckListMenu.getChild("columns") + xEntry = xTreeList.getChild("1") + xEntry.executeAction("CLICK", tuple()) + + #use the SUM function + # xfunctions = xDialog.getChild("functions") + # propsF = {"TEXT": "Sum"} + # actionPropsF = mkPropertyValues(propsF) + # xfunctions.executeAction("SELECT", actionPropsF) + + xOKBtn = xDialog.getChild("ok") + self.ui_test.close_dialog_through_button(xOKBtn) + + #verify + self.assertEqual(get_cell_by_position(document, 0, 0, 15).getString(), "5408 Sum") + self.assertEqual(get_cell_by_position(document, 0, 0, 16).getString(), "Grand Sum") + + self.assertEqual(round(get_cell_by_position(document, 0, 1, 15).getValue(),12), 238.89) + self.assertEqual(round(get_cell_by_position(document, 0, 1, 16).getValue(),12), 238.89) + + self.assertEqual(get_cell_by_position(document, 0, 1, 15).getString(), "$238.89") + self.assertEqual(get_cell_by_position(document, 0, 1, 16).getString(), "$238.89") # vim: set shiftwidth=4 softtabstop=4 expandtab: |