summaryrefslogtreecommitdiff
path: root/sc/qa/uitest/conditional_format/tdf100793.py
diff options
context:
space:
mode:
Diffstat (limited to 'sc/qa/uitest/conditional_format/tdf100793.py')
-rw-r--r--sc/qa/uitest/conditional_format/tdf100793.py154
1 files changed, 76 insertions, 78 deletions
diff --git a/sc/qa/uitest/conditional_format/tdf100793.py b/sc/qa/uitest/conditional_format/tdf100793.py
index 36b243008deb..516090076ec8 100644
--- a/sc/qa/uitest/conditional_format/tdf100793.py
+++ b/sc/qa/uitest/conditional_format/tdf100793.py
@@ -15,83 +15,81 @@ from libreoffice.uno.propertyvalue import mkPropertyValues
class tdf100793(UITestCase):
def test_tdf100793(self):
- calc_doc = self.ui_test.load_file(get_url_for_data_file("tdf100793.ods"))
- xCalcDoc = self.xUITest.getTopFocusWindow()
- gridwin = xCalcDoc.getChild("grid_window")
- document = self.ui_test.get_component()
-
- sheet = get_sheet_from_doc(calc_doc, 2)
- conditional_format_list = get_conditional_format_from_sheet(sheet)
- self.assertEqual(conditional_format_list.getLength(), 1)
- #2) Go to sheet "plan"
- gridwin.executeAction("SELECT", mkPropertyValues({"TABLE": "2"}))
- #3) Open the conditional formatting management dialog-> The indicated range should be G18:K29,F18,F20:F29
- self.ui_test.execute_dialog_through_command(".uno:ConditionalFormatManagerDialog")
-
- xCondFormatMgr = self.xUITest.getTopFocusWindow()
-
- # check that we have exactly one conditional formats in the beginning
- xList = xCondFormatMgr.getChild("CONTAINER")
- list_state = get_state_as_dict(xList)
- self.assertEqual(list_state['Children'], '1')
-
- #3) Click Edit & try to change to intended one, F18:K33
- xEditBtn = xCondFormatMgr.getChild("edit")
- self.ui_test.execute_dialog_through_action(xEditBtn, "CLICK", event_name = "ModelessDialogVisible")
- xCondFormatDlg = self.xUITest.getTopFocusWindow()
-
- #modify textbox
- xedassign = xCondFormatDlg.getChild("edassign")
- #go at the beginning
- xedassign.executeAction("TYPE", mkPropertyValues({"KEYCODE": "END"}))
- xedassign.executeAction("TYPE", mkPropertyValues({"KEYCODE": "HOME"}))
- # 11x right
- xedassign.executeAction("TYPE", mkPropertyValues({"KEYCODE": "RIGHT"}))
- xedassign.executeAction("TYPE", mkPropertyValues({"KEYCODE": "RIGHT"}))
- xedassign.executeAction("TYPE", mkPropertyValues({"KEYCODE": "RIGHT"}))
- xedassign.executeAction("TYPE", mkPropertyValues({"KEYCODE": "RIGHT"}))
- xedassign.executeAction("TYPE", mkPropertyValues({"KEYCODE": "RIGHT"}))
- xedassign.executeAction("TYPE", mkPropertyValues({"KEYCODE": "RIGHT"}))
- xedassign.executeAction("TYPE", mkPropertyValues({"KEYCODE": "RIGHT"}))
- xedassign.executeAction("TYPE", mkPropertyValues({"KEYCODE": "RIGHT"}))
- xedassign.executeAction("TYPE", mkPropertyValues({"KEYCODE": "RIGHT"}))
- xedassign.executeAction("TYPE", mkPropertyValues({"KEYCODE": "RIGHT"}))
- xedassign.executeAction("TYPE", mkPropertyValues({"KEYCODE": "RIGHT"}))
- #now I'm at F18 - write :K33
- xedassign.executeAction("TYPE", mkPropertyValues({"TEXT":":K33"}))
-
- xCondFormatOkBtn = xCondFormatDlg.getChild("ok")
- self.ui_test.close_dialog_through_button(xCondFormatOkBtn)
-
- # we need to get a pointer again as the old window has been deleted
- xCondFormatMgr = self.xUITest.getTopFocusWindow()
-
- # check again that we still have 1 entry in the list
- # and still only 1 conditional format in the document
- xList = xCondFormatMgr.getChild("CONTAINER")
- list_state = get_state_as_dict(xList)
- self.assertEqual(list_state['Children'], '1')
-
- self.assertEqual(conditional_format_list.getLength(), 1)
-
- # close the conditional format manager
- xOKBtn = xCondFormatMgr.getChild("ok")
- self.ui_test.close_dialog_through_button(xOKBtn)
-
- #verify - reopen, check range
- self.ui_test.execute_dialog_through_command(".uno:ConditionalFormatManagerDialog")
- xCondFormatMgr = self.xUITest.getTopFocusWindow()
- xEditBtn = xCondFormatMgr.getChild("edit")
- self.ui_test.execute_dialog_through_action(xEditBtn, "CLICK", event_name = "ModelessDialogVisible")
- xCondFormatDlg = self.xUITest.getTopFocusWindow()
- xedassign = xCondFormatDlg.getChild("edassign")
- self.assertEqual(get_state_as_dict(xedassign)["Text"], "G18:K29,F18:K33,F20:F29")
- xCondFormatOkBtn = xCondFormatDlg.getChild("ok")
- self.ui_test.close_dialog_through_button(xCondFormatOkBtn)
- xCondFormatMgr = self.xUITest.getTopFocusWindow()
- xCancelBtn = xCondFormatMgr.getChild("cancel")
- self.ui_test.close_dialog_through_button(xCancelBtn)
-
- self.ui_test.close_doc()
+ with self.ui_test.load_file(get_url_for_data_file("tdf100793.ods")) as calc_doc:
+ xCalcDoc = self.xUITest.getTopFocusWindow()
+ gridwin = xCalcDoc.getChild("grid_window")
+ document = self.ui_test.get_component()
+
+ sheet = get_sheet_from_doc(calc_doc, 2)
+ conditional_format_list = get_conditional_format_from_sheet(sheet)
+ self.assertEqual(conditional_format_list.getLength(), 1)
+ #2) Go to sheet "plan"
+ gridwin.executeAction("SELECT", mkPropertyValues({"TABLE": "2"}))
+ #3) Open the conditional formatting management dialog-> The indicated range should be G18:K29,F18,F20:F29
+ self.ui_test.execute_dialog_through_command(".uno:ConditionalFormatManagerDialog")
+
+ xCondFormatMgr = self.xUITest.getTopFocusWindow()
+
+ # check that we have exactly one conditional formats in the beginning
+ xList = xCondFormatMgr.getChild("CONTAINER")
+ list_state = get_state_as_dict(xList)
+ self.assertEqual(list_state['Children'], '1')
+
+ #3) Click Edit & try to change to intended one, F18:K33
+ xEditBtn = xCondFormatMgr.getChild("edit")
+ self.ui_test.execute_dialog_through_action(xEditBtn, "CLICK", event_name = "ModelessDialogVisible")
+ xCondFormatDlg = self.xUITest.getTopFocusWindow()
+
+ #modify textbox
+ xedassign = xCondFormatDlg.getChild("edassign")
+ #go at the beginning
+ xedassign.executeAction("TYPE", mkPropertyValues({"KEYCODE": "END"}))
+ xedassign.executeAction("TYPE", mkPropertyValues({"KEYCODE": "HOME"}))
+ # 11x right
+ xedassign.executeAction("TYPE", mkPropertyValues({"KEYCODE": "RIGHT"}))
+ xedassign.executeAction("TYPE", mkPropertyValues({"KEYCODE": "RIGHT"}))
+ xedassign.executeAction("TYPE", mkPropertyValues({"KEYCODE": "RIGHT"}))
+ xedassign.executeAction("TYPE", mkPropertyValues({"KEYCODE": "RIGHT"}))
+ xedassign.executeAction("TYPE", mkPropertyValues({"KEYCODE": "RIGHT"}))
+ xedassign.executeAction("TYPE", mkPropertyValues({"KEYCODE": "RIGHT"}))
+ xedassign.executeAction("TYPE", mkPropertyValues({"KEYCODE": "RIGHT"}))
+ xedassign.executeAction("TYPE", mkPropertyValues({"KEYCODE": "RIGHT"}))
+ xedassign.executeAction("TYPE", mkPropertyValues({"KEYCODE": "RIGHT"}))
+ xedassign.executeAction("TYPE", mkPropertyValues({"KEYCODE": "RIGHT"}))
+ xedassign.executeAction("TYPE", mkPropertyValues({"KEYCODE": "RIGHT"}))
+ #now I'm at F18 - write :K33
+ xedassign.executeAction("TYPE", mkPropertyValues({"TEXT":":K33"}))
+
+ xCondFormatOkBtn = xCondFormatDlg.getChild("ok")
+ self.ui_test.close_dialog_through_button(xCondFormatOkBtn)
+
+ # we need to get a pointer again as the old window has been deleted
+ xCondFormatMgr = self.xUITest.getTopFocusWindow()
+
+ # check again that we still have 1 entry in the list
+ # and still only 1 conditional format in the document
+ xList = xCondFormatMgr.getChild("CONTAINER")
+ list_state = get_state_as_dict(xList)
+ self.assertEqual(list_state['Children'], '1')
+
+ self.assertEqual(conditional_format_list.getLength(), 1)
+
+ # close the conditional format manager
+ xOKBtn = xCondFormatMgr.getChild("ok")
+ self.ui_test.close_dialog_through_button(xOKBtn)
+
+ #verify - reopen, check range
+ self.ui_test.execute_dialog_through_command(".uno:ConditionalFormatManagerDialog")
+ xCondFormatMgr = self.xUITest.getTopFocusWindow()
+ xEditBtn = xCondFormatMgr.getChild("edit")
+ self.ui_test.execute_dialog_through_action(xEditBtn, "CLICK", event_name = "ModelessDialogVisible")
+ xCondFormatDlg = self.xUITest.getTopFocusWindow()
+ xedassign = xCondFormatDlg.getChild("edassign")
+ self.assertEqual(get_state_as_dict(xedassign)["Text"], "G18:K29,F18:K33,F20:F29")
+ xCondFormatOkBtn = xCondFormatDlg.getChild("ok")
+ self.ui_test.close_dialog_through_button(xCondFormatOkBtn)
+ xCondFormatMgr = self.xUITest.getTopFocusWindow()
+ xCancelBtn = xCondFormatMgr.getChild("cancel")
+ self.ui_test.close_dialog_through_button(xCancelBtn)
# vim: set shiftwidth=4 softtabstop=4 expandtab:
generated by cgit (git 2.34.1) at 2024-07-11 22:40:16 +0000