sc/qa/uitest/calc_tests2/xmlSource.py | 52 ++++++++++++++++++++++++++++++++++
sc/qa/uitest/data/xmlSource.xml | 50 ++++++++++++++++++++++++++++++++
2 files changed, 102 insertions(+)
New commits:
commit be9655420e05f55ff2df9cda0fbe5128d3a77e32
Author: Xisco Fauli <xiscofa...@libreoffice.org>
AuthorDate: Tue Dec 14 11:20:32 2021 +0100
Commit: Xisco Fauli <xiscofa...@libreoffice.org>
CommitDate: Tue Dec 14 12:29:55 2021 +0100
uitest: sc: Add test for the import xml source dialog
Change-Id: Ic52148788c96a6d37def30145aa0a874d9847a41
Reviewed-on: https://gerrit.libreoffice.org/c/core/+/126805
Tested-by: Jenkins
Reviewed-by: Xisco Fauli <xiscofa...@libreoffice.org>
diff --git a/sc/qa/uitest/calc_tests2/xmlSource.py
b/sc/qa/uitest/calc_tests2/xmlSource.py
new file mode 100644
index 000000000000..1afb31356a1b
--- /dev/null
+++ b/sc/qa/uitest/calc_tests2/xmlSource.py
@@ -0,0 +1,52 @@
+# -*- 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 libreoffice.uno.propertyvalue import mkPropertyValues
+from uitest.uihelper.common import get_state_as_dict, get_url_for_data_file
+from libreoffice.calc.document import get_cell_by_position
+
+class xmlSource(UITestCase):
+
+ def test_importXml(self):
+
+ with self.ui_test.create_doc_in_start_center("calc") as calc_doc:
+
+ with
self.ui_test.execute_modeless_dialog_through_command(".uno:ManageXMLSource") as
xDialog:
+
+ xSource = xDialog.getChild("selectsource")
+
+ with
self.ui_test.execute_blocking_action(xSource.executeAction, args=('CLICK', ()),
close_button="open") as xOpenDialog:
+ xFileName = xOpenDialog.getChild("file_name")
+ xFileName.executeAction("TYPE", mkPropertyValues({"TEXT":
get_url_for_data_file("xmlSource.xml")}))
+
+ xTree = xDialog.getChild("tree")
+ self.assertEqual('13', get_state_as_dict(xTree)["Children"])
+
+ xTree.getChild('0').executeAction("SELECT", tuple())
+ xTree.executeAction("TYPE", mkPropertyValues({"KEYCODE":
"DOWN"}))
+ xTree.executeAction("TYPE", mkPropertyValues({"KEYCODE":
"DOWN"}))
+
+ self.assertEqual("entry",
get_state_as_dict(xTree)["SelectEntryText"])
+ self.assertEqual("11",
get_state_as_dict(xTree)["SelectionCount"])
+
+ xEdit = xDialog.getChild("edit")
+ xEdit.executeAction("TYPE", mkPropertyValues({"TEXT":
"$Sheet1.$A$1"}))
+
+ # Check the headers
+ self.assertEqual("name", get_cell_by_position(calc_doc, 0, 0,
0).getString())
+ self.assertEqual("translated-address",
get_cell_by_position(calc_doc, 0, 1, 0).getString())
+ self.assertEqual("to", get_cell_by_position(calc_doc, 0, 2,
0).getString())
+ self.assertEqual("from", get_cell_by_position(calc_doc, 0, 3,
0).getString())
+ self.assertEqual("source", get_cell_by_position(calc_doc, 0, 4,
0).getString())
+ self.assertEqual("destination", get_cell_by_position(calc_doc, 0,
5, 0).getString())
+ self.assertEqual("service", get_cell_by_position(calc_doc, 0, 6,
0).getString())
+ self.assertEqual("disabled", get_cell_by_position(calc_doc, 0, 7,
0).getString())
+
+# vim: set shiftwidth=4 softtabstop=4 expandtab:
diff --git a/sc/qa/uitest/data/xmlSource.xml b/sc/qa/uitest/data/xmlSource.xml
new file mode 100644
index 000000000000..b86a2e0b171c
--- /dev/null
+++ b/sc/qa/uitest/data/xmlSource.xml
@@ -0,0 +1,50 @@
+<nat>
+ <rules>
+ <entry name="ZoneA-to-ZoneB">
+ <source-translation>
+ <dynamic-ip-and-port>
+ <translated-address>
+ IPPool_NAT-1.2.3
+ </translated-address>
+ </dynamic-ip-and-port>
+ </source-translation>
+ <to>
+ internet
+ </to>
+ <from>
+ INTRA
+ </from>
+ <source>
+ 10.60.0.0/24
+ 10.62.0.0/24
+ </source>
+ <destination>
+ any
+ </destination>
+ <service>any</service>
+ </entry>
+ <entry name="ZoneB2ZoneA">
+ <source-translation>
+ <dynamic-ip-and-port>
+ <translated-address>
+ NAT Pool 1
+ </translated-address>
+ </dynamic-ip-and-port>
+ </source-translation>
+ <to>
+ internet
+ </to>
+ <from>
+ INTRA
+ </from>
+ <source>
+ any
+ </source>
+ <destination>
+ any
+ </destination>
+ <service>any</service>
+ <disabled>no</disabled>
+ </entry>
+ </rules>
+</nat>
