sc/Module_sc.mk | 1 sc/UITest_solver.mk | 20 +++++++++ sc/qa/uitest/calc_tests/data/solver.ods |binary sc/qa/uitest/solver/solver.py | 65 ++++++++++++++++++++++++++++++++ 4 files changed, 86 insertions(+)
New commits: commit 3c744c65270681d00a50ff2df80702d2ef338ed0 Author: Zdeněk Crhonek <[email protected]> Date: Tue Jun 19 18:12:50 2018 +0200 uitest Calc/Solver Change-Id: I6fdef503cdae8cb681f1acfec437c5ab3e7bcc5b Reviewed-on: https://gerrit.libreoffice.org/56121 Tested-by: Jenkins Reviewed-by: Zdenek Crhonek <[email protected]> diff --git a/sc/Module_sc.mk b/sc/Module_sc.mk index b85622c0cdd3..e8e1bb5b2bfb 100644 --- a/sc/Module_sc.mk +++ b/sc/Module_sc.mk @@ -189,6 +189,7 @@ $(eval $(call gb_Module_add_uicheck_targets,sc,\ UITest_calc_tests3 \ UITest_calc_tests4 \ UITest_statistics \ + UITest_solver \ )) endif diff --git a/sc/UITest_solver.mk b/sc/UITest_solver.mk new file mode 100644 index 000000000000..2e8e6af0076e --- /dev/null +++ b/sc/UITest_solver.mk @@ -0,0 +1,20 @@ +# -*- Mode: makefile-gmake; tab-width: 4; indent-tabs-mode: t -*- +# +# This file is part of the LibreOffice project. +# +# This Source Code Form is subject to the terms of the Mozilla Public +# License, v. 2.0. If a copy of the MPL was not distributed with this +# file, You can obtain one at http://mozilla.org/MPL/2.0/. +# + +$(eval $(call gb_UITest_UITest,solver)) + +$(eval $(call gb_UITest_add_modules,solver,$(SRCDIR)/sc/qa/uitest,\ + solver/ \ +)) + +$(eval $(call gb_UITest_set_defs,solver, \ + TDOC="$(SRCDIR)/sc/qa/uitest/calc_tests/data" \ +)) + +# vim: set noet sw=4 ts=4: diff --git a/sc/qa/uitest/calc_tests/data/solver.ods b/sc/qa/uitest/calc_tests/data/solver.ods new file mode 100644 index 000000000000..a6739664abb5 Binary files /dev/null and b/sc/qa/uitest/calc_tests/data/solver.ods differ diff --git a/sc/qa/uitest/solver/solver.py b/sc/qa/uitest/solver/solver.py new file mode 100644 index 000000000000..e6ca81029985 --- /dev/null +++ b/sc/qa/uitest/solver/solver.py @@ -0,0 +1,65 @@ +# -*- tab-width: 4; indent-tabs-mode: nil; py-indent-offset: 4 -*- +# +# This Source Code Form is subject to the terms of the Mozilla Public +# License, v. 2.0. If a copy of the MPL was not distributed with this +# file, You can obtain one at http://mozilla.org/MPL/2.0/. +# +from uitest.framework import UITestCase +from uitest.uihelper.common import get_state_as_dict +from uitest.uihelper.common import select_pos +from uitest.uihelper.calc import enter_text_to_cell +from libreoffice.calc.document import get_cell_by_position +from libreoffice.uno.propertyvalue import mkPropertyValues +from uitest.debug import sleep +# import org.libreoffice.unotest +# import pathlib +from uitest.path import get_srcdir_url +def get_url_for_data_file(file_name): +# return pathlib.Path(org.libreoffice.unotest.makeCopyFromTDOC(file_name)).as_uri() + return get_srcdir_url() + "/sc/qa/uitest/calc_tests/data/" + file_name + + +class solver(UITestCase): + def test_solver(self): + calc_doc = self.ui_test.load_file(get_url_for_data_file("solver.ods")) + xCalcDoc = self.xUITest.getTopFocusWindow() + gridwin = xCalcDoc.getChild("grid_window") + document = self.ui_test.get_component() + gridwin.executeAction("SELECT", mkPropertyValues({"CELL": "B4"})) + self.ui_test.execute_modeless_dialog_through_command(".uno:SolverDialog") + xDialog = self.xUITest.getTopFocusWindow() + xtargetedit = xDialog.getChild("targetedit") + xvalue = xDialog.getChild("value") + xvalueedit = xDialog.getChild("valueedit") + xchangeedit = xDialog.getChild("changeedit") + xref1edit = xDialog.getChild("ref1edit") + xval1edit = xDialog.getChild("val1edit") + xref2edit = xDialog.getChild("ref2edit") + xval2edit = xDialog.getChild("val2edit") + xop2list = xDialog.getChild("op2list") + + xvalue.executeAction("CLICK", tuple()) + xvalueedit.executeAction("TYPE", mkPropertyValues({"TEXT":"1000"})) + xchangeedit.executeAction("TYPE", mkPropertyValues({"TEXT":"C2"})) + xref1edit.executeAction("TYPE", mkPropertyValues({"TEXT":"C2"})) + xval1edit.executeAction("TYPE", mkPropertyValues({"TEXT":"C4"})) + xref2edit.executeAction("TYPE", mkPropertyValues({"TEXT":"C4"})) + props = {"TEXT": "=>"} + actionProps = mkPropertyValues(props) + xop2list.executeAction("SELECT", actionProps) + + xval2edit.executeAction("TYPE", mkPropertyValues({"TEXT":"0"})) + sleep(4) + xOKBtn = xDialog.getChild("solve") + def handle_OK_dlg(dialog): + #('SolverSuccessDialog', 'cancel', 'dialog-action_area1', 'dialog-vbox1', 'grid1', 'label1', 'label2', 'ok', 'result') + xYesButn = dialog.getChild("ok") + self.ui_test.close_dialog_through_button(xYesButn) + + self.ui_test.execute_blocking_action(xOKBtn.executeAction, args=('CLICK', ()), + dialog_handler=handle_OK_dlg) + #verify + self.assertEqual(get_cell_by_position(document, 0, 1, 1).getValue(), 400) + self.ui_test.close_doc() + +# vim: set shiftwidth=4 softtabstop=4 expandtab: \ No newline at end of file _______________________________________________ Libreoffice-commits mailing list [email protected] https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
