Python calc.enter_text_to_cell函数代码示例

OStack程序员社区-中国程序员成长平台 › 门户 › 编程› Python›Python编程经验

原作者: [db:作者] 来自: [db:来源] 收藏邀请

本文整理汇总了Python中uitest.uihelper.calc.enter_text_to_cell函数的典型用法代码示例。如果您正苦于以下问题：Python enter_text_to_cell函数的具体用法？Python enter_text_to_cell怎么用？Python enter_text_to_cell使用的例子？那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。

在下文中一共展示了enter_text_to_cell函数的20个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于我们的系统推荐出更棒的Python代码示例。

示例1: test_tdf125051_crash_spelling_dialog

    def test_tdf125051_crash_spelling_dialog(self):
        calc_doc = self.ui_test.create_doc_in_start_center("calc")
        xCalcDoc = self.xUITest.getTopFocusWindow()
        gridwin = xCalcDoc.getChild("grid_window")
        document = self.ui_test.get_component()
        enter_text_to_cell(gridwin, "A1", "text")
        gridwin.executeAction("SELECT", mkPropertyValues({"CELL": "A1"}))
        self.ui_test.execute_dialog_through_command(".uno:SpellDialog")
        xDialog = self.xUITest.getTopFocusWindow()  #Spelling dialog

        xDialog2 = self.xUITest.getTopFocusWindow()   # info dialog "The spellcheck of this sheet has been completed.-> OK"
        okBtn = xDialog.getChild("ok")
        self.ui_test.close_dialog_through_button(okBtn)

        xDialog = self.xUITest.getTopFocusWindow()  #Spelling dialog
        #open options
        optionsBtn = xDialog.getChild("options")
        def handle_options_dlg(dialog):
            #print(dialog.getChildren())
            xCancelBtn = dialog.getChild("cancel")
            self.ui_test.close_dialog_through_button(xCancelBtn)

        self.ui_test.execute_blocking_action(optionsBtn.executeAction, args=('CLICK', ()),
                dialog_handler=handle_options_dlg)

        closeBtn = xDialog.getChild("close")    #close Spelling dialog
        self.ui_test.close_dialog_through_button(closeBtn)

        #verify, we didn't crash
        self.assertEqual(get_cell_by_position(document, 0, 0, 0).getString(), "text")

        self.ui_test.close_doc()

开发者ID:LibreOffice，项目名称:core，代码行数:32，代码来源:tdf125051.py

示例2: test_validation

    def test_validation(self):
        self.ui_test.create_doc_in_start_center("calc")

        xGridWin = self.xUITest.getTopFocusWindow().getChild("grid_window")
        xGridWin.executeAction("SELECT", mkPropertyValues({"RANGE": "A1:C10"}))

        self.ui_test.execute_dialog_through_command(".uno:Validation")
        xValidationDlg = self.xUITest.getTopFocusWindow()

        xAllowList = xValidationDlg.getChild("allow")
        xAllowList.executeAction("SELECT", mkPropertyValues({"POS": "1"}))

        xData = xValidationDlg.getChild("data")
        xData.executeAction("SELECT", mkPropertyValues({"POS": "5"}))

        xVal = xValidationDlg.getChild("max")
        xVal.executeAction("TYPE", mkPropertyValues({"TEXT":"0"}))

        xOkBtn = xValidationDlg.getChild("ok")
        self.ui_test.close_dialog_through_button(xOkBtn)

        def enter_text(cell, text):
            enter_text_to_cell(xGridWin, cell, text)

        self.ui_test.execute_blocking_action(enter_text, "ok", args=("A1", "abc"))
        self.ui_test.execute_blocking_action(enter_text, "ok", args=("B6", "2.18"))

        enter_text_to_cell(xGridWin, "C2", "24")

        self.ui_test.close_doc()

开发者ID:beppec56，项目名称:core，代码行数:30，代码来源:calc.py

示例3: test_paste_only

    def test_paste_only(self):
        calc_doc = self.ui_test.create_doc_in_start_center("calc")
        xTopWindow = self.xUITest.getTopFocusWindow()
        document = self.ui_test.get_component()
        gridwin = xTopWindow.getChild("grid_window")

        enter_text_to_cell(gridwin, "A1", "=SUM(A2:A3)")
        gridwin.executeAction("SELECT", mkPropertyValues({"CELL": "A1"}))
        self.xUITest.executeCommand(".uno:Copy")

        gridwin.executeAction("SELECT", mkPropertyValues({"CELL": "C1"}))
        self.xUITest.executeCommand(".uno:PasteOnlyText")
        self.assertEqual(get_cell_by_position(document, 0, 2, 0).getString(), "")

        gridwin.executeAction("SELECT", mkPropertyValues({"CELL": "D1"}))
        self.xUITest.executeCommand(".uno:PasteOnlyValue")
        self.assertEqual(get_cell_by_position(document, 0, 3, 0).getString(), "0")
        self.assertEqual(get_cell_by_position(document, 0, 3, 0).getValue(), 0)

        gridwin.executeAction("SELECT", mkPropertyValues({"CELL": "E1"}))
        self.xUITest.executeCommand(".uno:PasteOnlyFormula")
        self.assertEqual(get_cell_by_position(document, 0, 4, 0).getString(), "0")
        self.assertEqual(get_cell_by_position(document, 0, 4, 0).getValue(), 0)
        self.assertEqual(get_cell_by_position(document, 0, 4, 0).getFormula(), "=SUM(E2:E3)")

        self.ui_test.close_doc()

开发者ID:LibreOffice，项目名称:core，代码行数:26，代码来源:CalcPasteOnly.py

示例4: test_protect_sheet

    def test_protect_sheet(self):
        calc_doc = self.ui_test.create_doc_in_start_center("calc")
        xCalcDoc = self.xUITest.getTopFocusWindow()
        gridwin = xCalcDoc.getChild("grid_window")
        document = self.ui_test.get_component()
        #enter password - lock
        self.ui_test.execute_dialog_through_command(".uno:Protect")
        xDialog = self.xUITest.getTopFocusWindow()
        xprotect = xDialog.getChild("protect")
        xpassword1 = xDialog.getChild("password1")
        xpassword2 = xDialog.getChild("password2")

        if (get_state_as_dict(xprotect)["Selected"]) == "false":
            xprotect.executeAction("CLICK", tuple())
        xpassword1.executeAction("TYPE", mkPropertyValues({"TEXT":"aa"}))
        xpassword2.executeAction("TYPE", mkPropertyValues({"TEXT":"aa"}))

        xOKBtn = xDialog.getChild("ok")
#        self.ui_test.close_dialog_through_button(xOKBtn)
        xOKBtn.executeAction("CLICK", tuple())
        #Unlock

        self.ui_test.execute_dialog_through_command(".uno:Protect")
        xDialog = self.xUITest.getTopFocusWindow()
        xpass1ed = xDialog.getChild("pass1ed")

        xpass1ed.executeAction("TYPE", mkPropertyValues({"TEXT":"aa"}))

        xOKBtn = xDialog.getChild("ok")
        self.ui_test.close_dialog_through_button(xOKBtn)
        #Verify - the sheet is unlocked
        enter_text_to_cell(gridwin, "B2", "A")
        self.assertEqual(get_cell_by_position(document, 0, 1, 1).getString(), "A")

        self.ui_test.close_doc()

开发者ID:LibreOffice，项目名称:core，代码行数:35，代码来源:protectSheet.py

示例5: test_paste_special

    def test_paste_special(self):
        # EN-8:Paste special with options
        # This test is to check that paste special combined with some options and link is ok.
        # Refers to tdf#84810

        self.ui_test.create_doc_in_start_center("calc")

        # Write text to cell A1
        xGridWin = self.xUITest.getTopFocusWindow().getChild("grid_window")
        enter_text_to_cell(xGridWin, "A1", "abcd")

        # Copy cell A1 to clipboard
        xGridWin.executeAction("SELECT", mkPropertyValues({"CELL": "A1"}))
        self.xUITest.executeCommand(".uno:Copy")

        # Set cursor to cell A3
        xGridWin.executeAction("SELECT", mkPropertyValues({"CELL": "A3"}))

        # Choose Paste Special Options and paste data
        self.ui_test.execute_dialog_through_command(".uno:PasteSpecial")
        xPasteSpecialDlg = self.xUITest.getTopFocusWindow()
        xAllChkBox = xPasteSpecialDlg.getChild("paste_all")
        xAllChkBox.executeAction("CLICK", tuple())
        xLinkChkBox = xPasteSpecialDlg.getChild("link")
        xLinkChkBox.executeAction("CLICK", tuple())
        xOkBtn = xPasteSpecialDlg.getChild("ok")
        self.ui_test.close_dialog_through_button(xOkBtn)

        # Assert successful paste
        document = self.ui_test.get_component()
        self.assertEqual(get_cell_by_position(document, 0, 0, 2).getString(), "abcd")
        self.ui_test.close_doc()

开发者ID:LibreOffice，项目名称:core，代码行数:32，代码来源:more_calc.py

示例6: test_expand

    def test_expand(self):

        self.ui_test.create_doc_in_start_center("calc")

        xCalcDoc = self.xUITest.getTopFocusWindow()
        xGridWindow = xCalcDoc.getChild("grid_window")
        enter_text_to_cell(xGridWindow, "B2", "=2+3+4")
        xGridWindow.executeAction("SELECT", mkPropertyValues({"CELL": "B2"}))

        self.ui_test.execute_modeless_dialog_through_command(".uno:FunctionDialog")

        xFunctionDlg = self.xUITest.getTopFocusWindow()

        xTabs = xFunctionDlg.getChild("tabs")
        select_pos(xTabs, "1")

        xTreelist = xTabs.getChild("struct")

        xTreeEntry = xTreelist.getChild('0')

        xTreeEntry.executeAction("COLLAPSE", tuple())

        xTreeEntry.executeAction("EXPAND", tuple())

        xCancelBtn = xFunctionDlg.getChild("cancel")
        xCancelBtn.executeAction("CLICK", tuple())

        self.ui_test.close_doc()

开发者ID:LibreOffice，项目名称:core，代码行数:28，代码来源:treelist.py

示例7: test_tdf43078_insert_and_delete_sheet_insert_text

    def test_tdf43078_insert_and_delete_sheet_insert_text(self):

        self.ui_test.create_doc_in_start_center("calc")
        document = self.ui_test.get_component()

        nrSheets = document.Sheets.getCount()  #default number of sheets

        self.ui_test.execute_dialog_through_command(".uno:Insert")  #insert sheet
        xDialog = self.xUITest.getTopFocusWindow()
        xOKButton = xDialog.getChild("ok")
        xOKButton.executeAction("CLICK", tuple())

        self.ui_test.execute_dialog_through_command(".uno:Insert")  #insert sheet
        xDialog = self.xUITest.getTopFocusWindow()
        xOKButton = xDialog.getChild("ok")
        xOKButton.executeAction("CLICK", tuple())

        self.assertEqual(document.Sheets.getCount(), nrSheets + 2)
        xCalcDoc = self.xUITest.getTopFocusWindow()
        xGridWindow = xCalcDoc.getChild("grid_window")
        enter_text_to_cell(xGridWindow, "B2", "abcd")

        self.ui_test.execute_dialog_through_command(".uno:Remove")  #delete sheet
        xDialog = self.xUITest.getTopFocusWindow()
        xOKButton = xDialog.getChild("yes")
        xOKButton.executeAction("CLICK", tuple())

        self.assertEqual(document.Sheets.getCount(), nrSheets + 1)
        self.xUITest.executeCommand(".uno:Undo")
        self.assertEqual(document.Sheets.getCount(), nrSheets + 2)
        self.xUITest.executeCommand(".uno:Redo")
        self.assertEqual(document.Sheets.getCount(), nrSheets + 1)

        self.ui_test.close_doc()

开发者ID:LibreOffice，项目名称:core，代码行数:34，代码来源:calcSheetDelete.py

示例8: test_tdf44398_find_replace_regexp

   def test_tdf44398_find_replace_regexp(self):
        calc_doc = self.ui_test.create_doc_in_start_center("calc")
        xCalcDoc = self.xUITest.getTopFocusWindow()
        gridwin = xCalcDoc.getChild("grid_window")
        document = self.ui_test.get_component()

        # 1. A1 => 123456
        enter_text_to_cell(gridwin, "A1", "123456")
        # 2. ctrl-h, in dialog
        # Search: ([0-9])
        # Replace: $1
        # check regular expression
        # hit replace all

        self.ui_test.execute_modeless_dialog_through_command(".uno:SearchDialog")
        xDialog = self.xUITest.getTopFocusWindow()
        searchterm = xDialog.getChild("searchterm")
        searchterm.executeAction("TYPE", mkPropertyValues({"KEYCODE":"CTRL+A"}))
        searchterm.executeAction("TYPE", mkPropertyValues({"KEYCODE":"BACKSPACE"}))
        searchterm.executeAction("TYPE", mkPropertyValues({"TEXT":"([0-9])"}))
        replaceterm = xDialog.getChild("replaceterm")
        replaceterm.executeAction("TYPE", mkPropertyValues({"TEXT":"$1"})) #replace textbox
        regexp = xDialog.getChild("regexp")
        regexp.executeAction("CLICK", tuple())   #regular expressions
        replaceall = xDialog.getChild("replaceall")
        replaceall.executeAction("CLICK", tuple())
        xcloseBtn = xDialog.getChild("close")
        self.ui_test.close_dialog_through_button(xcloseBtn)

        #verify 3. A1 => 123456
        self.assertEqual(get_cell_by_position(document, 0, 0, 0).getString(), "123456")

        self.ui_test.close_doc()

开发者ID:LibreOffice，项目名称:core，代码行数:33，代码来源:tdf44398.py

示例9: test_clear_cells_all

    def test_clear_cells_all(self):
        calc_doc = self.ui_test.create_doc_in_start_center("calc")
        xCalcDoc = self.xUITest.getTopFocusWindow()
        gridwin = xCalcDoc.getChild("grid_window")
        document = self.ui_test.get_component()
        enter_text_to_cell(gridwin, "A1", "aa")
        enter_text_to_cell(gridwin, "A2", "1")

        gridwin.executeAction("SELECT", mkPropertyValues({"RANGE": "A1:A2"}))
        self.xUITest.executeCommand(".uno:Bold")
        self.ui_test.execute_dialog_through_command(".uno:Delete")
        xDialog = self.xUITest.getTopFocusWindow()
        xdeleteall = xDialog.getChild("deleteall")
        xtext = xDialog.getChild("text")
        xdatetime = xDialog.getChild("datetime")
        xcomments = xDialog.getChild("comments")
        xobjects = xDialog.getChild("objects")
        xnumbers = xDialog.getChild("numbers")
        xformulas = xDialog.getChild("formulas")
        xformats = xDialog.getChild("formats")

        if (get_state_as_dict(xdeleteall)["Selected"]) == "false":
            xdeleteall.executeAction("CLICK", tuple())

        xOKBtn = xDialog.getChild("ok")
        self.ui_test.close_dialog_through_button(xOKBtn)
        #Verify
        self.assertEqual(get_cell_by_position(document, 0, 0, 0).getString() , "")
        self.assertEqual(get_cell_by_position(document, 0, 0, 1).getString() , "")

        self.ui_test.close_doc()

开发者ID:LibreOffice，项目名称:core，代码行数:31，代码来源:clearCells.py

示例10: test_tdf73006_text_to_columns

    def test_tdf73006_text_to_columns(self):
        calc_doc = self.ui_test.create_doc_in_start_center("calc")
        xCalcDoc = self.xUITest.getTopFocusWindow()
        gridwin = xCalcDoc.getChild("grid_window")
        document = self.ui_test.get_component()

        #Add data
        enter_text_to_cell(gridwin, "A2", "A B")
        #select column A
        gridwin.executeAction("SELECT", mkPropertyValues({"CELL": "A1"}))
        self.xUITest.executeCommand(".uno:SelectColumn")
        # Data - Text to Columns
        self.ui_test.execute_dialog_through_command(".uno:TextToColumns")
        xDialog = self.xUITest.getTopFocusWindow()
        xspace = xDialog.getChild("space")
        if (get_state_as_dict(xspace)["Selected"]) == "false":
            xspace.executeAction("CLICK", tuple())
        # Click Ok
        xOK = xDialog.getChild("ok")
        self.ui_test.close_dialog_through_button(xOK)

        #Verify
        self.assertEqual(get_cell_by_position(document, 0, 0, 1).getString(), "A")
        self.assertEqual(get_cell_by_position(document, 0, 1, 1).getString(), "B")

        self.ui_test.close_doc()

# vim: set shiftwidth=4 softtabstop=4 expandtab:

开发者ID:LibreOffice，项目名称:core，代码行数:28，代码来源:tdf73006.py

示例11: test_clear_cells_formats

    def test_clear_cells_formats(self):
        calc_doc = self.ui_test.create_doc_in_start_center("calc")
        xCalcDoc = self.xUITest.getTopFocusWindow()
        gridwin = xCalcDoc.getChild("grid_window")
        document = self.ui_test.get_component()
        enter_text_to_cell(gridwin, "A1", "aa")
        enter_text_to_cell(gridwin, "A2", "1")

        gridwin.executeAction("SELECT", mkPropertyValues({"RANGE": "A1:A2"}))
        self.xUITest.executeCommand(".uno:Bold")
        self.ui_test.execute_dialog_through_command(".uno:Delete")
        xDialog = self.xUITest.getTopFocusWindow()
        xdeleteall = xDialog.getChild("deleteall")
        xtext = xDialog.getChild("text")
        xdatetime = xDialog.getChild("datetime")
        xcomments = xDialog.getChild("comments")
        xobjects = xDialog.getChild("objects")
        xnumbers = xDialog.getChild("numbers")
        xformulas = xDialog.getChild("formulas")
        xformats = xDialog.getChild("formats")

        if (get_state_as_dict(xdeleteall)["Selected"]) == "true":
            xdeleteall.executeAction("CLICK", tuple())
        if (get_state_as_dict(xtext)["Selected"]) == "true":
            xtext.executeAction("CLICK", tuple())
        if (get_state_as_dict(xdatetime)["Selected"]) == "true":
            xdatetime.executeAction("CLICK", tuple())
        if (get_state_as_dict(xcomments)["Selected"]) == "true":
            xcomments.executeAction("CLICK", tuple())
        if (get_state_as_dict(xobjects)["Selected"]) == "true":
            xobjects.executeAction("CLICK", tuple())
        if (get_state_as_dict(xnumbers)["Selected"]) == "true":
            xnumbers.executeAction("CLICK", tuple())
        if (get_state_as_dict(xformulas)["Selected"]) == "true":
            xformulas.executeAction("CLICK", tuple())
        if (get_state_as_dict(xformats)["Selected"]) == "false":
            xformats.executeAction("CLICK", tuple())

        xOKBtn = xDialog.getChild("ok")
        self.ui_test.close_dialog_through_button(xOKBtn)
        #Verify
        gridwin.executeAction("SELECT", mkPropertyValues({"CELL": "A1"}))
        self.ui_test.execute_dialog_through_command(".uno:FormatCellDialog")
        xDialog = self.xUITest.getTopFocusWindow()
        xTabs = xDialog.getChild("tabcontrol")
        select_pos(xTabs, "1")  #tab Font

        xstylelb = xDialog.getChild("weststylelb-cjk")
        print(get_state_as_dict(xstylelb))


        self.assertEqual(get_state_as_dict(xstylelb)["Text"], "Regular")

        xOK = xDialog.getChild("ok")
        xOK.executeAction("CLICK", tuple())

        self.ui_test.close_doc()

开发者ID:LibreOffice，项目名称:core，代码行数:57，代码来源:clearCells.py

示例12: test_tdf119954_second_db_range

   def test_tdf119954_second_db_range(self):
        calc_doc = self.ui_test.load_file(get_url_for_data_file("tdf119954.ods"))
        xCalcDoc = self.xUITest.getTopFocusWindow()
        gridwin = xCalcDoc.getChild("grid_window")
        document = self.ui_test.get_component()
        #* new document
        #* in A1 enter 1
        #* in C3 enter 2
        #* on A1 define a database range 'aaa' with $Sheet1.$A$1
        #* on C3 define a database range 'bbb' with $Sheet2.$C$3
        #* in any cell enter formula =bbb
        #  => result is 1 instead of 2
        #* place cell cursor on that formula cell again
        #  => see that the formula is =aaa instead of =bbb

        gridwin.executeAction("SELECT", mkPropertyValues({"CELL": "A1"}))
        self.ui_test.execute_modeless_dialog_through_command(".uno:DefineDBName")
        xDefineNameDlg = self.xUITest.getTopFocusWindow()

        xEntryBox = xDefineNameDlg.getChild("entry")
        type_text(xEntryBox, "aaa")
        add = xDefineNameDlg.getChild("add")
        assign = xDefineNameDlg.getChild("assign")
        add.executeAction("CLICK", tuple())
        xOkBtn = xDefineNameDlg.getChild("ok")
        self.ui_test.close_dialog_through_button(xOkBtn)

        gridwin.executeAction("SELECT", mkPropertyValues({"CELL": "A1"}))
        self.ui_test.execute_modeless_dialog_through_command(".uno:DefineDBName")
        xDefineNameDlg = self.xUITest.getTopFocusWindow()
        xEntryBox = xDefineNameDlg.getChild("entry")
        assign = xDefineNameDlg.getChild("assign")
        select_all(xEntryBox)
        type_text(xEntryBox, "bbb")
        select_all(assign)
        type_text(assign, "$Sheet2.$C$3")
        add.executeAction("CLICK", tuple())

        xOkBtn = xDefineNameDlg.getChild("ok")
        self.ui_test.close_dialog_through_button(xOkBtn)

        enter_text_to_cell(gridwin, "B2", "=bbb")
        gridwin.executeAction("TYPE", mkPropertyValues({"KEYCODE": "RETURN"}))
        self.assertEqual(get_cell_by_position(document, 0, 1, 1).getValue(), 2)

        enter_text_to_cell(gridwin, "C2", "=aaa")
        gridwin.executeAction("TYPE", mkPropertyValues({"KEYCODE": "RETURN"}))
        self.assertEqual(get_cell_by_position(document, 0, 2, 1).getValue(), 1)

        self.xUITest.executeCommand(".uno:Undo")
        self.xUITest.executeCommand(".uno:Undo")
        self.assertEqual(get_cell_by_position(document, 0, 2, 1).getValue(), 0)
        self.assertEqual(get_cell_by_position(document, 0, 1, 1).getValue(), 0)
        self.assertEqual(get_cell_by_position(document, 0, 1, 2).getFormula(), "")
        self.assertEqual(get_cell_by_position(document, 0, 1, 1).getFormula(), "")

        self.ui_test.close_doc()

开发者ID:LibreOffice，项目名称:core，代码行数:57，代码来源:tdf119954.py

示例13: test_tdf79983_sort_list_case_sensitive

    def test_tdf79983_sort_list_case_sensitive(self):
        calc_doc = self.ui_test.create_doc_in_start_center("calc")
        xCalcDoc = self.xUITest.getTopFocusWindow()
        gridwin = xCalcDoc.getChild("grid_window")
        document = self.ui_test.get_component()

        enter_text_to_cell(gridwin, "A1", "AAA")
        enter_text_to_cell(gridwin, "A2", "BBB")
        enter_text_to_cell(gridwin, "A3", "CCC")
        enter_text_to_cell(gridwin, "A4", "DDD")
        gridwin.executeAction("SELECT", mkPropertyValues({"RANGE": "A1:A4"}))

        #Tools / Options / LibreOffice Calc / Sort Lists
        self.ui_test.execute_dialog_through_command(".uno:OptionsTreeDialog")  #optionsdialog
        xDialogOpt = self.xUITest.getTopFocusWindow()

        xPages = xDialogOpt.getChild("pages")
        xCalcEntry = xPages.getChild('3')                 # Calc
        xCalcEntry.executeAction("EXPAND", tuple())
        xCalcSortEntry = xCalcEntry.getChild('5')
        xCalcSortEntry.executeAction("SELECT", tuple())          #Sort List
        #copy new list from selected cells
        xcopy = xDialogOpt.getChild("copy")
        xcopy.executeAction("CLICK", tuple())
        xOKBtn = xDialogOpt.getChild("ok")
        self.ui_test.close_dialog_through_button(xOKBtn)

        gridwin.executeAction("SELECT", mkPropertyValues({"RANGE": "A1:A4"}))
        gridwin.executeAction("TYPE", mkPropertyValues({"KEYCODE": "DELETE"}))

        enter_text_to_cell(gridwin, "A1", "AAA")
        gridwin.executeAction("SELECT", mkPropertyValues({"RANGE": "A1:A4"}))
        #fill down
        self.ui_test.execute_dialog_through_command(".uno:FillSeries")
        xDialog = self.xUITest.getTopFocusWindow()
        xautofill = xDialog.getChild("autofill")
        xautofill.executeAction("CLICK", tuple())
        xOK = xDialog.getChild("ok")
        self.ui_test.close_dialog_through_button(xOK)
        #verify
        self.assertEqual(get_cell_by_position(document, 0, 0, 0).getString(), "AAA")
        self.assertEqual(get_cell_by_position(document, 0, 0, 1).getString(), "BBB")
        self.assertEqual(get_cell_by_position(document, 0, 0, 2).getString(), "CCC")
        self.assertEqual(get_cell_by_position(document, 0, 0, 3).getString(), "DDD")
        #UNDO
        self.xUITest.executeCommand(".uno:Undo")
        #verify
        self.assertEqual(get_cell_by_position(document, 0, 0, 0).getString(), "AAA")
        self.assertEqual(get_cell_by_position(document, 0, 0, 1).getString(), "")
        self.assertEqual(get_cell_by_position(document, 0, 0, 2).getString(), "")
        self.assertEqual(get_cell_by_position(document, 0, 0, 3).getString(), "")

        self.ui_test.close_doc()

# vim: set shiftwidth=4 softtabstop=4 expandtab:

开发者ID:LibreOffice，项目名称:core，代码行数:55，代码来源:tdf79983.py

示例14: test_input

    def test_input(self):

        self.ui_test.create_doc_in_start_center("calc")
        xTopWindow = self.xUITest.getTopFocusWindow()

        xGridWindow = xTopWindow.getChild("grid_window")

        enter_text_to_cell(xGridWindow, "C3", "=A1")
        enter_text_to_cell(xGridWindow, "A1", "2")

        self.ui_test.close_doc()

开发者ID:NadithM，项目名称:core，代码行数:11，代码来源:gridwindow.py

示例15: test_natural_sorting_columns

    def test_natural_sorting_columns(self):
        calc_doc = self.ui_test.create_doc_in_start_center("calc")
        xCalcDoc = self.xUITest.getTopFocusWindow()
        gridwin = xCalcDoc.getChild("grid_window")
        document = self.ui_test.get_component()
        #enter data
        enter_text_to_cell(gridwin, "A1", "MW-2")
        enter_text_to_cell(gridwin, "B1", "MW-20")
        enter_text_to_cell(gridwin, "C1", "MW-1")
        enter_text_to_cell(gridwin, "D1", "MW-18")

        gridwin.executeAction("SELECT", mkPropertyValues({"RANGE": "A1:D1"}))

        #Open sort dialog by DATA - SORT
        self.ui_test.execute_dialog_through_command(".uno:DataSort")
        xDialog = self.xUITest.getTopFocusWindow()
        xTabs = xDialog.getChild("tabcontrol")
        xleftright = xDialog.getChild("leftright")
        select_pos(xTabs, "1")
        xNatural = xDialog.getChild("naturalsort")
        xleftright.executeAction("CLICK", tuple())
        if (get_state_as_dict(xNatural)["Selected"]) == "false":
            xNatural.executeAction("CLICK", tuple())
        xOk = xDialog.getChild("ok")
        self.ui_test.close_dialog_through_button(xOk)

        #Verify
        self.assertEqual(get_cell_by_position(document, 0, 0, 0).getString(), "MW-1")
        self.assertEqual(get_cell_by_position(document, 0, 1, 0).getString(), "MW-2")
        self.assertEqual(get_cell_by_position(document, 0, 2, 0).getString(), "MW-18")
        self.assertEqual(get_cell_by_position(document, 0, 3, 0).getString(), "MW-20")

        self.ui_test.close_doc()

开发者ID:LibreOffice，项目名称:core，代码行数:33，代码来源:naturalSort.py

示例16: test_scenarios

   def test_scenarios(self):
        self.ui_test.create_doc_in_start_center("calc")
        xCalcDoc = self.xUITest.getTopFocusWindow()
        xGridWindow = xCalcDoc.getChild("grid_window")
        document = self.ui_test.get_component()

        #fill B1:B4  with 1, select B1:B4;
        enter_text_to_cell(xGridWindow, "B1", "1")
        enter_text_to_cell(xGridWindow, "B2", "1")
        enter_text_to_cell(xGridWindow, "B3", "1")
        enter_text_to_cell(xGridWindow, "B4", "1")
        xGridWindow.executeAction("SELECT", mkPropertyValues({"RANGE": "B1:B4"}))
        #scenarios - scenario A1
        self.ui_test.execute_dialog_through_command(".uno:ScenarioManager")
        xDialog = self.xUITest.getTopFocusWindow()

        name = xDialog.getChild("name")
        name.executeAction("TYPE", mkPropertyValues({"KEYCODE":"CTRL+A"}))
        name.executeAction("TYPE", mkPropertyValues({"KEYCODE":"BACKSPACE"}))
        name.executeAction("TYPE", mkPropertyValues({"TEXT":"A1"}))
        xOKBtn = xDialog.getChild("ok")
        self.ui_test.close_dialog_through_button(xOKBtn)

        #next scenarios - scenario B1
        self.ui_test.execute_dialog_through_command(".uno:ScenarioManager")
        xDialog = self.xUITest.getTopFocusWindow()

        name = xDialog.getChild("name")
        name.executeAction("TYPE", mkPropertyValues({"KEYCODE":"CTRL+A"}))
        name.executeAction("TYPE", mkPropertyValues({"KEYCODE":"BACKSPACE"}))
        name.executeAction("TYPE", mkPropertyValues({"TEXT":"B1"}))
        xOKBtn = xDialog.getChild("ok")
        self.ui_test.close_dialog_through_button(xOKBtn)

        self.ui_test.close_doc()

开发者ID:LibreOffice，项目名称:core，代码行数:35，代码来源:scenarios.py

示例17: test_transpose

    def test_transpose(self):
        self.ui_test.create_doc_in_start_center("calc")

        xGridWin = self.xUITest.getTopFocusWindow().getChild("grid_window")
        enter_text_to_cell(xGridWin, "B3", "abcd")
        enter_text_to_cell(xGridWin, "B4", "edfg")
        enter_text_to_cell(xGridWin, "C3", "35")
        enter_text_to_cell(xGridWin, "C4", "5678")

        xGridWin.executeAction("SELECT", mkPropertyValues({"RANGE": "A1:C10"}))

        self.xUITest.executeCommand(".uno:Cut")

        xGridWin.executeAction("SELECT", mkPropertyValues({"CELL": "A1"}))

        self.ui_test.execute_dialog_through_command(".uno:PasteSpecial")

        xPasteSpecialDlg = self.xUITest.getTopFocusWindow()

        xAllChkBox = xPasteSpecialDlg.getChild("paste_all")
        xAllChkBox.executeAction("CLICK", tuple())

        xTransposeChkBox = xPasteSpecialDlg.getChild("transpose")
        xTransposeChkBox.executeAction("CLICK", tuple())

        xOkBtn = xPasteSpecialDlg.getChild("ok")
        self.ui_test.close_dialog_through_button(xOkBtn)

        document = self.ui_test.get_component()
        self.assertEqual(get_cell_by_position(document, 0, 2, 1).getString(), "abcd")
        self.assertEqual(get_cell_by_position(document, 0, 2, 2).getValue(), 35)
        self.assertEqual(get_cell_by_position(document, 0, 3, 1).getString(), "edfg")
        self.assertEqual(get_cell_by_position(document, 0, 3, 2).getValue(), 5678)

        self.ui_test.close_doc()

开发者ID:beppec56，项目名称:core，代码行数:35，代码来源:calc.py

示例18: test_tdf105351_cond_format_data_bar

    def test_tdf105351_cond_format_data_bar(self):
        calc_doc = self.ui_test.create_doc_in_start_center("calc")
        xCalcDoc = self.xUITest.getTopFocusWindow()
        gridwin = xCalcDoc.getChild("grid_window")
        document = self.ui_test.get_component()
        #2. Set the value of cell A1 to 5
        enter_text_to_cell(gridwin, "A1", "5")
        #3. Select cell A1, then choose from the menus Format -> Conditional Formatting -> Data Bar
        gridwin.executeAction("SELECT", mkPropertyValues({"CELL": "A1"}))
        self.ui_test.execute_modeless_dialog_through_command(".uno:DataBarFormatDialog")
        xDialog = self.xUITest.getTopFocusWindow()
        xcolscalemin = xDialog.getChild("colscalemin")
        xedcolscalemin = xDialog.getChild("edcolscalemin")
        xcolscalemax = xDialog.getChild("colscalemax")
        xedcolscalemax = xDialog.getChild("edcolscalemax")
        #4. In the conditional formatting window, select the dropdown on the left that says "Automatic"
        #and change it to "Value". In the text field below it enter 0.
        #5. Select the dropdown on the right that says "Automatic" and change it to "Value". In the text field below it enter 10
        props = {"TEXT": "Value"}
        actionProps = mkPropertyValues(props)
        xcolscalemin.executeAction("SELECT", actionProps)
        xedcolscalemin.executeAction("TYPE", mkPropertyValues({"TEXT":"0"}))

        props2 = {"TEXT": "Value"}
        actionProps2 = mkPropertyValues(props2)
        xcolscalemax.executeAction("SELECT", actionProps2)
        xedcolscalemax.executeAction("TYPE", mkPropertyValues({"TEXT":"10"}))

        xOKBtn = xDialog.getChild("ok")
        self.ui_test.close_dialog_through_button(xOKBtn)
        #Verify : The conditions set for cell A1 should be shown and editable.
        self.ui_test.execute_modeless_dialog_through_command(".uno:DataBarFormatDialog")
        xDialog = self.xUITest.getTopFocusWindow()
        xcolscalemin = xDialog.getChild("colscalemin")
        xedcolscalemin = xDialog.getChild("edcolscalemin")
        xcolscalemax = xDialog.getChild("colscalemax")
        xedcolscalemax = xDialog.getChild("edcolscalemax")

        self.assertEqual(get_state_as_dict(xcolscalemin)["SelectEntryText"], "Value")
        self.assertEqual(get_state_as_dict(xedcolscalemin)["Text"], "0")
        self.assertEqual(get_state_as_dict(xcolscalemax)["SelectEntryText"], "Value")
        self.assertEqual(get_state_as_dict(xedcolscalemax)["Text"], "10")
        #editable - change value and then verify
        xedcolscalemax.executeAction("TYPE", mkPropertyValues({"TEXT":"1"}))
        self.assertEqual(get_state_as_dict(xedcolscalemax)["Text"], "110")

        xOKBtn = xDialog.getChild("ok")
        self.ui_test.close_dialog_through_button(xOKBtn)

        self.ui_test.close_doc()

开发者ID:LibreOffice，项目名称:core，代码行数:50，代码来源:tdf105351.py

示例19: test_tdf120174

 def test_tdf120174(self):
     calc_doc = self.ui_test.create_doc_in_start_center("calc")
     xCalcDoc = self.xUITest.getTopFocusWindow()
     gridwin = xCalcDoc.getChild("grid_window")
     document = self.ui_test.get_component()
     enter_text_to_cell(gridwin, "A1", "121")
     enter_text_to_cell(gridwin, "B1", "=A1")
     self.assertEqual(get_cell_by_position(document, 0, 1, 0).getValue(), 121) # B1
     gridwin.executeAction("SELECT", mkPropertyValues({"CELL": "A1"}))
     # Delete contents of A1
     gridwin.executeAction("TYPE", mkPropertyValues({"KEYCODE": "DELETE"}))
     # Before the fix the result would be still 121.
     self.assertEqual(get_cell_by_position(document, 0, 1, 0).getValue(), 0) # B1
     self.xUITest.executeCommand(".uno:Undo")
     self.assertEqual(get_cell_by_position(document, 0, 1, 0).getValue(), 121) # B1
     self.ui_test.close_doc()

开发者ID:LibreOffice，项目名称:core，代码行数:16，代码来源:tdf120174.py

示例20: test_tdf71339_autosum_on_selected_range

    def test_tdf71339_autosum_on_selected_range(self):
        calc_doc = self.ui_test.create_doc_in_start_center("calc")
        xCalcDoc = self.xUITest.getTopFocusWindow()
        gridwin = xCalcDoc.getChild("grid_window")
        document = self.ui_test.get_component()
        enter_text_to_cell(gridwin, "A2", "1")
        enter_text_to_cell(gridwin, "A3", "1")
        gridwin.executeAction("SELECT", mkPropertyValues({"RANGE": "A1:A3"}))
        self.xUITest.executeCommand(".uno:AutoSum")

        self.assertEqual(get_cell_by_position(document, 0, 0, 3).getValue(), 2)
        self.assertEqual(get_cell_by_position(document, 0, 0, 3).getFormula(), "=SUM(A1:A3)")

        self.ui_test.close_doc()

# vim: set shiftwidth=4 softtabstop=4 expandtab:

开发者ID:LibreOffice，项目名称:core，代码行数:16，代码来源:tdf71339.py

注：本文中的uitest.uihelper.calc.enter_text_to_cell函数示例由纯净天空整理自Github/MSDocs等源码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和

鲜花

握手

雷人

路过

鸡蛋

该文章已有0人参与评论

请发表评论

全部评论

专题导读

More+

10-27 六六分期app的软件客服如何联系？(六六分期

11-06 可心卡盟:win10系统火狐flash插件崩溃怎么

11-06 亲亲特价:怎么删除回收站图标

11-06 济南大学虚拟社区:鲁大师节能降温的具体办

11-06 xlueops.exe:无线网络安装向导

11-06 女斗合众国:win7系统cf与主机连接不稳定怎

11-06 0xc000022-[cf烟雾头]cf怎么调烟雾头

11-06 qizideyouhuo:应用程序无法正常启动0xc0000

11-06 ipz-185:win7系统vcf文件怎么打开

11-06 傻哥蹦迪:win10系统s4怎么打开usb调试

11-06 八神浩树gtaste:回收站清空了怎么恢复

11-06 妖尾之黑色守护:win10系统电脑没有1440x900

11-06 校园至尊魔王小说:win7系统浏览网页时字体

11-06 女斗合众国:win10系统访问共享文件夹提示请

11-06 tokyo hot n0654:恢复win7系统默认字体一招

11-06 雨酷仙境:设置win7系统转移临时文件夹腾出

11-06 阿穆纳伊之杖:win7系统开始菜单在右边还原

11-06 tunespotting:win10系统火狐flash插件总是

11-06 甘尔葛分析师：计谋网站seo关键词暴涨有什

11-06 蔡贵霖: 计谋网站seo关键词暴涨有什么秘密

11-06 博益网首页:ao3网页版进入不了解决方法

11-06 漏斗子专栏: 网站数据分析小白易懂精华篇

11-06 见证双虹怎么做:win7系统开启telnet命令的

11-06 颾狐蝶蜋:系统资源不足无法完成请求的服务

11-06 国光中学校歌:提交网站到alexa查询详细步骤

11-06 西安有情天:静态网页和动态网页的区别

11-06 红木雅尚斋:外部链接构造对网站的好处

11-06 前官礼遇：防止域名劫持–增强域安全性的10

11-06 密传二转答案: 中文分词算法有哪些

11-06 金泉家园邮编:百度快照劫持的表现及应对方

Python common.get_state_as_dict函数代码示例发布时间：2022-05-27

Python uictrl.element函数代码示例发布时间：2022-05-27

Python util.grid_equal函数代码示例

1 Python 入门教程

Python入门教程 Python 是一种解释型、面向对象、动态数据类型的高级程序设计语言。 P

阅读：13925|2022-01-22

2 Python wikiutil.getFrontPage函数代码示例

Python wikiutil.getFrontPage函数代码示例

阅读：10291|2022-05-24

3 Python 简介

Python 简介 Python 是一个高层次的结合了解释性、编译性、互动性和面向对象的脚本

阅读：4165|2022-01-22

4 Python tests.group函数代码示例

Python tests.group函数代码示例

阅读：4064|2022-05-27

5 Python util.check_if_user_has_permission

Python util.check_if_user_has_permission函数代码示例

阅读：3889|2022-05-27

6 Python 操练实例98

Python 练习实例98 Python 100例题目：从键盘输入一个字符串，将小写字母全部转换成大

阅读：3538|2022-01-22

7 Python 环境搭建

Python 环境搭建本章节我们将向大家介绍如何在本地搭建 Python 开发环境。 Py

阅读：3065|2022-01-22

8 Python 基础语法

Python 基础语法 Python 语言与 Perl，C 和 Java 等语言有许多相似之处。但是，也

阅读：2723|2022-01-22

9 Python output.darkgreen函数代码示例

Python output.darkgreen函数代码示例

阅读：2682|2022-05-25

10 Python 中文编码

Python 中文编码前面章节中我们已经学会了如何用 Python 输出 Hello, World!，英文没

阅读：2344|2022-01-22

客服电话

电子邮件

Python calc.enter_text_to_cell函数代码示例

示例1: test_tdf125051_crash_spelling_dialog

示例2: test_validation

示例3: test_paste_only

示例4: test_protect_sheet

示例5: test_paste_special

示例6: test_expand

示例7: test_tdf43078_insert_and_delete_sheet_insert_text

示例8: test_tdf44398_find_replace_regexp

示例9: test_clear_cells_all

示例10: test_tdf73006_text_to_columns

示例11: test_clear_cells_formats

示例12: test_tdf119954_second_db_range

示例13: test_tdf79983_sort_list_case_sensitive

示例14: test_input

示例15: test_natural_sorting_columns

示例16: test_scenarios

示例17: test_transpose

示例18: test_tdf105351_cond_format_data_bar

示例19: test_tdf120174

示例20: test_tdf71339_autosum_on_selected_range

请发表评论

全部评论

上一篇：

下一篇：

Python util.grid_equal函数代码示例

Python util.get_worker_name函数代码示例

Python util.get_webmention_target函数代

Python util.get_uuid函数代码示例

Python util.get_type_by_name函数代码示例

Python util.grid_equal函数代码示例

Python util.get_worker_name函数代码示例

Python util.get_webmention_target函数代

Python util.get_uuid函数代码示例

Python util.get_type_by_name函数代码示例

Python util.get_stdout函数代码示例

关于我们

产品与服务

解决方案

139-2527-9053