sc/Module_sc.mk | 1 sc/UITest_key_f4.mk | 20 +++++++++++++ sc/qa/uitest/calc_tests/data/tdf102525.ods |binary sc/qa/uitest/key_f4/tdf102525.py | 43 +++++++++++++++++++++++++++++ 4 files changed, 64 insertions(+)
New commits: commit e72577d1ebd58a4d79bfd7c51086e3542170f1d2 Author: Zdeněk Crhonek <zcrho...@gmail.com> AuthorDate: Sun Jul 15 23:08:14 2018 +0200 Commit: Zdenek Crhonek <zcrho...@gmail.com> CommitDate: Mon Jul 16 18:59:47 2018 +0200 uitest for bug tdf#102525 Change-Id: Idb3810d99ebbd33bf0961f362694d0f4961fb912 Reviewed-on: https://gerrit.libreoffice.org/57463 Tested-by: Jenkins Reviewed-by: Zdenek Crhonek <zcrho...@gmail.com> diff --git a/sc/Module_sc.mk b/sc/Module_sc.mk index df10cdb32299..b27abde64ed2 100644 --- a/sc/Module_sc.mk +++ b/sc/Module_sc.mk @@ -194,6 +194,7 @@ $(eval $(call gb_Module_add_uicheck_targets,sc,\ UITest_protect \ UITest_options \ UITest_validity \ + UITest_key_f4 \ )) endif diff --git a/sc/UITest_key_f4.mk b/sc/UITest_key_f4.mk new file mode 100644 index 000000000000..85ef4babca1e --- /dev/null +++ b/sc/UITest_key_f4.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,key_f4)) + +$(eval $(call gb_UITest_add_modules,key_f4,$(SRCDIR)/sc/qa/uitest,\ + key_f4/ \ +)) + +$(eval $(call gb_UITest_set_defs,key_f4, \ + TDOC="$(SRCDIR)/sc/qa/uitest/calc_tests/data" \ +)) + +# vim: set noet sw=4 ts=4: diff --git a/sc/qa/uitest/calc_tests/data/tdf102525.ods b/sc/qa/uitest/calc_tests/data/tdf102525.ods new file mode 100644 index 000000000000..533d2d2ba0b5 Binary files /dev/null and b/sc/qa/uitest/calc_tests/data/tdf102525.ods differ diff --git a/sc/qa/uitest/key_f4/tdf102525.py b/sc/qa/uitest/key_f4/tdf102525.py new file mode 100644 index 000000000000..b93062b309b6 --- /dev/null +++ b/sc/qa/uitest/key_f4/tdf102525.py @@ -0,0 +1,43 @@ +# -*- 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 +import os +from uitest.uihelper.common import get_state_as_dict +from uitest.debug import sleep +from libreoffice.uno.propertyvalue import mkPropertyValues +from libreoffice.calc.document import get_cell_by_position +import org.libreoffice.unotest +import pathlib +def get_url_for_data_file(file_name): + return pathlib.Path(org.libreoffice.unotest.makeCopyFromTDOC(file_name)).as_uri() +#Bug 102525 - F4 breaks array formula +class tdf102525(UITestCase): + def test_tdf102525_F4_key_array_formula(self): + calc_doc = self.ui_test.load_file(get_url_for_data_file("tdf102525.ods")) + xCalcDoc = self.xUITest.getTopFocusWindow() + gridwin = xCalcDoc.getChild("grid_window") + document = self.ui_test.get_component() + + #select B1:B4 + gridwin.executeAction("SELECT", mkPropertyValues({"RANGE": "B1:B4"})) + #F4 + gridwin.executeAction("TYPE", mkPropertyValues({"KEYCODE": "F4"})) + #verify + self.assertEqual(get_cell_by_position(document, 0, 1, 0).getValue(), 2) + self.assertEqual(get_cell_by_position(document, 0, 1, 0).getFormula(), "{=IF($A$1:$A$4>2;1;2)}") + self.assertEqual(get_cell_by_position(document, 0, 1, 1).getValue(), 2) + self.assertEqual(get_cell_by_position(document, 0, 1, 2).getValue(), 1) + self.assertEqual(get_cell_by_position(document, 0, 1, 3).getValue(), 1) + #Undo + self.xUITest.executeCommand(".uno:Undo") + #verify + self.assertEqual(get_cell_by_position(document, 0, 1, 0).getValue(), 2) + self.assertEqual(get_cell_by_position(document, 0, 1, 0).getFormula(), "{=IF(A1:A4>2;1;2)}") + + self.ui_test.close_doc() + +# vim: set shiftwidth=4 softtabstop=4 expandtab: _______________________________________________ Libreoffice-commits mailing list libreoffice-comm...@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits