summaryrefslogtreecommitdiffstats
path: root/uitest/manual_tests
diff options
context:
space:
mode:
Diffstat (limited to 'uitest/manual_tests')
-rw-r--r--uitest/manual_tests/__init__.py0
-rw-r--r--uitest/manual_tests/calc.py235
-rw-r--r--uitest/manual_tests/data/cell_recalc.odsbin0 -> 34064 bytes
-rw-r--r--uitest/manual_tests/more_calc.py52
4 files changed, 287 insertions, 0 deletions
diff --git a/uitest/manual_tests/__init__.py b/uitest/manual_tests/__init__.py
new file mode 100644
index 000000000..e69de29bb
--- /dev/null
+++ b/uitest/manual_tests/__init__.py
diff --git a/uitest/manual_tests/calc.py b/uitest/manual_tests/calc.py
new file mode 100644
index 000000000..1b7897983
--- /dev/null
+++ b/uitest/manual_tests/calc.py
@@ -0,0 +1,235 @@
+# -*- 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 libreoffice.uno.propertyvalue import mkPropertyValues
+from libreoffice.calc.document import get_cell_by_position
+
+from uitest.uihelper.common import get_state_as_dict, type_text
+from uitest.uihelper.calc import enter_text_to_cell
+
+import org.libreoffice.unotest
+import pathlib
+import time
+
+def get_url_for_data_file(file_name):
+ return pathlib.Path(org.libreoffice.unotest.makeCopyFromTDOC(file_name)).as_uri()
+
+class ManualCalcTests(UITestCase):
+
+ # http://manual-test.libreoffice.org/manage/case/189/
+ def test_define_database_range(self):
+
+ self.ui_test.create_doc_in_start_center("calc")
+
+ # Select range A1:D10
+ xGridWin = self.xUITest.getTopFocusWindow().getChild("grid_window")
+ xGridWin.executeAction("SELECT", mkPropertyValues({"RANGE": "A1:D10"}))
+
+ # Execute "Define DB Range dialog"
+ self.ui_test.execute_modeless_dialog_through_command(".uno:DefineDBName")
+
+ xDefineNameDlg = self.xUITest.getTopFocusWindow()
+
+ xEntryBox = xDefineNameDlg.getChild("entry")
+ type_text(xEntryBox, "my_database")
+
+ xOkBtn = xDefineNameDlg.getChild("ok")
+ self.ui_test.close_dialog_through_button(xOkBtn)
+
+ # Deselect range
+ xGridWin.executeAction("SELECT", mkPropertyValues({"CELL": "A1"}))
+
+ # Execute "Select DB Range dialog"
+ self.ui_test.execute_dialog_through_command(".uno:SelectDB")
+ xSelectNameDlg = self.xUITest.getTopFocusWindow()
+
+ xListBox = xSelectNameDlg.getChild("treeview")
+ xListBoxState = get_state_as_dict(xListBox)
+ self.assertEqual(xListBoxState["SelectionCount"], "1")
+ self.assertEqual(xListBoxState["SelectEntryText"], "my_database")
+
+ xOkBtn = xSelectNameDlg.getChild("ok")
+ self.ui_test.close_dialog_through_button(xOkBtn)
+
+ # Assert that the correct range has been selected
+ gridWinState = get_state_as_dict(xGridWin)
+ self.assertEqual(gridWinState["MarkedArea"], "Sheet1.A1:Sheet1.D10")
+
+ self.ui_test.close_doc()
+
+ # http://manual-test.libreoffice.org/manage/case/190/
+ def test_sort_data(self):
+ self.ui_test.create_doc_in_start_center("calc")
+
+ # Insert data
+ xGridWin = self.xUITest.getTopFocusWindow().getChild("grid_window")
+ enter_text_to_cell(xGridWin, "B1", "3")
+ enter_text_to_cell(xGridWin, "B2", "25")
+ enter_text_to_cell(xGridWin, "B3", "17")
+ enter_text_to_cell(xGridWin, "B4", "9")
+ enter_text_to_cell(xGridWin, "B5", "19")
+ enter_text_to_cell(xGridWin, "B6", "0")
+ enter_text_to_cell(xGridWin, "B7", "107")
+ enter_text_to_cell(xGridWin, "B8", "89")
+ enter_text_to_cell(xGridWin, "B9", "8")
+ enter_text_to_cell(xGridWin, "B10", "33")
+
+ xGridWin.executeAction("SELECT", mkPropertyValues({"RANGE": "B1:B10"}))
+
+ # Execute "Sort" dialog
+ self.ui_test.execute_dialog_through_command(".uno:DataSort")
+ xSortDlg = self.xUITest.getTopFocusWindow()
+
+ xOkBtn = xSortDlg.getChild("ok")
+ self.ui_test.close_dialog_through_button(xOkBtn)
+
+ document = self.ui_test.get_component()
+
+ self.assertEqual(get_cell_by_position(document, 0, 1, 0).getValue(), 0)
+ self.assertEqual(get_cell_by_position(document, 0, 1, 1).getValue(), 3)
+ self.assertEqual(get_cell_by_position(document, 0, 1, 2).getValue(), 8)
+ self.assertEqual(get_cell_by_position(document, 0, 1, 3).getValue(), 9)
+ self.assertEqual(get_cell_by_position(document, 0, 1, 4).getValue(), 17)
+ self.assertEqual(get_cell_by_position(document, 0, 1, 5).getValue(), 19)
+ self.assertEqual(get_cell_by_position(document, 0, 1, 6).getValue(), 25)
+ self.assertEqual(get_cell_by_position(document, 0, 1, 7).getValue(), 33)
+ self.assertEqual(get_cell_by_position(document, 0, 1, 8).getValue(), 89)
+ self.assertEqual(get_cell_by_position(document, 0, 1, 9).getValue(), 107)
+
+ time.sleep(2)
+ self.ui_test.close_doc()
+
+ # http://manual-test.libreoffice.org/manage/case/191/
+ 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()
+
+ # http://manual-test.libreoffice.org/manage/case/187/
+ 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()
+
+ # http://manual-test.libreoffice.org/manage/case/151/
+ def test_cell_recalc(self):
+ doc = self.ui_test.load_file(get_url_for_data_file("cell_recalc.ods"))
+
+ xGridWin = self.xUITest.getTopFocusWindow().getChild("grid_window")
+ xGridWin.executeAction("SELECT", mkPropertyValues({"RANGE": "D2:D9"}))
+ self.xUITest.executeCommand(".uno:Cut")
+
+ self.assertEqual(get_cell_by_position(doc, 0, 3, 15).getValue(), 0)
+
+ self.xUITest.executeCommand(".uno:Undo")
+
+ for i in range(1, 9):
+ self.assertTrue(get_cell_by_position(doc, 0, 3, i).getValue() != 0)
+
+ self.assertEqual(get_cell_by_position(doc, 0, 3, 15).getValue(), 195)
+
+ self.ui_test.close_doc()
+
+ # http://manual-test.libreoffice.org/manage/case/143/
+ def test_random_numbers(self):
+ self.ui_test.create_doc_in_start_center("calc")
+ xGridWin = self.xUITest.getTopFocusWindow().getChild("grid_window")
+
+ xGridWin.executeAction("SELECT", mkPropertyValues({"RANGE": "A2:A10"}))
+
+ self.ui_test.execute_modeless_dialog_through_command(".uno:RandomNumberGeneratorDialog")
+ xRandomNumberDlg = self.xUITest.getTopFocusWindow()
+ xDistributionLstBox = xRandomNumberDlg.getChild("distribution-combo")
+ xDistributionLstBox.executeAction("SELECT", mkPropertyValues({"POS": "1"}))
+
+ xMin = xRandomNumberDlg.getChild("parameter1-spin")
+ xMin.executeAction("TYPE", mkPropertyValues({"KEYCODE": "CTRL+A"}))
+ xMin.executeAction("TYPE", mkPropertyValues({"TEXT": "-2"}))
+ xMax = xRandomNumberDlg.getChild("parameter2-spin")
+ xMax.executeAction("TYPE", mkPropertyValues({"KEYCODE": "CTRL+A"}))
+ xMax.executeAction("TYPE", mkPropertyValues({"TEXT": "10"}))
+
+ xApplyBtn = xRandomNumberDlg.getChild("apply")
+ xApplyBtn.executeAction("CLICK", tuple())
+
+ doc = self.ui_test.get_component()
+
+ def check_random_values():
+ for i in range(1, 9):
+ val = get_cell_by_position(doc, 0, 0, i).getValue()
+ self.assertTrue(val <= 10 and val >= -2)
+
+ check_random_values()
+
+ xOkBtn = xRandomNumberDlg.getChild("ok")
+ self.ui_test.close_dialog_through_button(xOkBtn)
+
+ # we might want to check that clicking 'ok' actually changes the values
+ check_random_values()
+
+ self.ui_test.close_doc()
+
+# vim: set shiftwidth=4 softtabstop=4 expandtab:
diff --git a/uitest/manual_tests/data/cell_recalc.ods b/uitest/manual_tests/data/cell_recalc.ods
new file mode 100644
index 000000000..4b125fd2e
--- /dev/null
+++ b/uitest/manual_tests/data/cell_recalc.ods
Binary files differ
diff --git a/uitest/manual_tests/more_calc.py b/uitest/manual_tests/more_calc.py
new file mode 100644
index 000000000..08aeb654e
--- /dev/null
+++ b/uitest/manual_tests/more_calc.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.calc.document import get_cell_by_position
+from libreoffice.uno.propertyvalue import mkPropertyValues
+
+from uitest.uihelper.calc import enter_text_to_cell
+
+
+class ManualCalcTests(UITestCase):
+ 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()
+
+# vim: set shiftwidth=4 softtabstop=4 expandtab:
generated by cgit v1.2.3 (git 2.39.1) at 2025-02-03 18:52:05 +0000