sc/qa/uitest/calc_tests/goToSheet.py | 64 +++++++++++++++++++++++++++++++++++
1 file changed, 64 insertions(+)
New commits:
commit 7251b2ecd728bb6bd1af4cc4199da3f06e2e1ca3
Author: Laurent BP <laurent.balland-poir...@laposte.net>
AuthorDate: Sat Jun 11 10:08:58 2022 +0200
Commit: Xisco Fauli <xiscofa...@libreoffice.org>
CommitDate: Thu Sep 22 15:53:27 2022 +0200
tdf#129674 "Go to Sheet" UITest
Add UITest to new dialog
Sheet > Navigate > Go to Sheet
Check search entry behavior
Change-Id: I4b22328f24744ba554320c65ef95c20eb35dfe3f
Reviewed-on: https://gerrit.libreoffice.org/c/core/+/135632
Tested-by: Jenkins
Reviewed-by: Xisco Fauli <xiscofa...@libreoffice.org>
diff --git a/sc/qa/uitest/calc_tests/goToSheet.py
b/sc/qa/uitest/calc_tests/goToSheet.py
new file mode 100644
index 000000000000..ab2311374b71
--- /dev/null
+++ b/sc/qa/uitest/calc_tests/goToSheet.py
@@ -0,0 +1,64 @@
+# -*- tab-width: 4; indent-tabs-mode: nil; py-indent-offset: 4 -*-
+#
+# 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/.
+#
+from uitest.framework import UITestCase
+from uitest.uihelper.common import get_state_as_dict
+from libreoffice.uno.propertyvalue import mkPropertyValues
+
+class goToSheet(UITestCase):
+ def test_go_to_sheet(self):
+ with self.ui_test.create_doc_in_start_center("calc") as document:
+
+ xCalcDoc = self.xUITest.getTopFocusWindow()
+ xGridWindow = xCalcDoc.getChild("grid_window")
+
+ for i in range(3):
+ with
self.ui_test.execute_dialog_through_command(".uno:Insert"):
+ pass
+
+ with
self.ui_test.execute_dialog_through_command(".uno:RenameTable") as
xDialogRename:
+ xname_entry = xDialogRename.getChild("name_entry")
+ xname_entry.executeAction("TYPE",
mkPropertyValues({"TEXT":"NewName"}))
+
+ with
self.ui_test.execute_dialog_through_command(".uno:JumpToTable") as
xDialogGoToSheet:
+ xentry_mask = xDialogGoToSheet.getChild("entry-mask")
+ xtree_view = xDialogGoToSheet.getChild("treeview")
+
+ # Empty mask lists all sheets
+ self.assertEqual(get_state_as_dict(xtree_view)["Children"],
"4")
+
+ # None sheet contains 'E': Search entry is case sensitive
+ xentry_mask.executeAction("TYPE",
mkPropertyValues({"TEXT":"E"}))
+ self.assertEqual(get_state_as_dict(xtree_view)["Children"],
"0")
+
+ xentry_mask.executeAction("TYPE",
mkPropertyValues({"KEYCODE":"BACKSPACE"}))
+ self.assertEqual(get_state_as_dict(xtree_view)["Children"],
"4")
+
+ # All sheets contains 'e'
+ xentry_mask.executeAction("TYPE",
mkPropertyValues({"TEXT":"e"}))
+ self.assertEqual(get_state_as_dict(xtree_view)["Children"],
"4")
+
+ # List Sheet3, Sheet2 and Sheet1
+ xentry_mask.executeAction("TYPE",
mkPropertyValues({"TEXT":"e"}))
+ self.assertEqual(get_state_as_dict(xtree_view)["Children"],
"3")
+
+ #if no name selected, active sheet remains unchanged
+ self.assertEqual(get_state_as_dict(xGridWindow)["SelectedTable"],
"0")
+
+ with
self.ui_test.execute_dialog_through_command(".uno:JumpToTable") as
xDialogGoToSheet:
+ xentry_mask = xDialogGoToSheet.getChild("entry-mask")
+ xtree_view = xDialogGoToSheet.getChild("treeview")
+ # List Sheet3, Sheet2 and Sheet1
+ xentry_mask.executeAction("TYPE",
mkPropertyValues({"TEXT":"ee"}))
+ self.assertEqual(get_state_as_dict(xtree_view)["Children"],
"3")
+ # Select Sheet2
+ xtree_view.getChild('1').executeAction("SELECT", tuple())
+
+ self.assertEqual(get_state_as_dict(xGridWindow)["SelectedTable"],
"2")
+
+# vim: set shiftwidth=4 softtabstop=4 expandtab:
