uitest/manual_tests/calc.py

   1 # -*- tab-width: 4; indent-tabs-mode: nil; py-indent-offset: 4 -*-
   2 #
   3 # This Source Code Form is subject to the terms of the Mozilla Public
   4 # License, v. 2.0. If a copy of the MPL was not distributed with this
   5 # file, You can obtain one at http://mozilla.org/MPL/2.0/.
   6 #
   7
   8 from uitest.framework import UITestCase
   9
  10 from libreoffice.uno.propertyvalue import mkPropertyValues
  11 from libreoffice.calc.document import get_cell_by_position
  12
  13 from uitest.uihelper.common import get_state_as_dict, type_text
  14 from uitest.uihelper.calc import enter_text_to_cell
  15 from uitest.path import get_srcdir_url
  16
  17 import time
  18
  19 def get_url_for_data_file(file_name):
  20     return get_srcdir_url() + "/uitest/manual_tests/data/" + file_name
  21
  22 class ManualCalcTests(UITestCase):
  23
  24     # http://manual-test.libreoffice.org/manage/case/189/
  25     def test_define_database_range(self):
  26
  27         self.ui_test.create_doc_in_start_center("calc")
  28
  29         # Select range A1:D10
  30         xGridWin = self.xUITest.getTopFocusWindow().getChild("grid_window")
  31         xGridWin.executeAction("SELECT", mkPropertyValues({"RANGE": "A1:D10"}))
  32
  33         # Execute "Define DB Range dialog"
  34         self.ui_test.execute_modeless_dialog_through_command(".uno:DefineDBName")
  35
  36         xDefineNameDlg = self.xUITest.getTopFocusWindow()
  37
  38         xEntryBox = xDefineNameDlg.getChild("entry")
  39         type_text(xEntryBox, "my_database")
  40
  41         xOkBtn = xDefineNameDlg.getChild("ok")
  42         self.ui_test.close_dialog_through_button(xOkBtn)
  43
  44         # Deselect range
  45         xGridWin.executeAction("SELECT", mkPropertyValues({"CELL": "A1"}))
  46
  47         # Execute "Select DB Range dialog"
  48         self.ui_test.execute_dialog_through_command(".uno:SelectDB")
  49         xSelectNameDlg = self.xUITest.getTopFocusWindow()
  50
  51         xListBox = xSelectNameDlg.getChild("treeview")
  52         xListBoxState = get_state_as_dict(xListBox)
  53         self.assertEqual(xListBoxState["SelectEntryCount"], "1")
  54         self.assertEqual(xListBoxState["SelectEntryText"], "my_database")
  55
  56         xOkBtn = xSelectNameDlg.getChild("ok")
  57         self.ui_test.close_dialog_through_button(xOkBtn)
  58
  59         # Assert that the correct range has been selected
  60         gridWinState = get_state_as_dict(xGridWin)
  61         self.assertEqual(gridWinState["MarkedArea"], "Sheet1.A1:Sheet1.D10")
  62
  63         self.ui_test.close_doc()
  64
  65     # http://manual-test.libreoffice.org/manage/case/190/
  66     def test_sort_data(self):
  67         self.ui_test.create_doc_in_start_center("calc")
  68
  69         # Insert data
  70         xGridWin = self.xUITest.getTopFocusWindow().getChild("grid_window")
  71         enter_text_to_cell(xGridWin, "B1", "3")
  72         enter_text_to_cell(xGridWin, "B2", "25")
  73         enter_text_to_cell(xGridWin, "B3", "17")
  74         enter_text_to_cell(xGridWin, "B4", "9")
  75         enter_text_to_cell(xGridWin, "B5", "19")
  76         enter_text_to_cell(xGridWin, "B6", "0")
  77         enter_text_to_cell(xGridWin, "B7", "107")
  78         enter_text_to_cell(xGridWin, "B8", "89")
  79         enter_text_to_cell(xGridWin, "B9", "8")
  80         enter_text_to_cell(xGridWin, "B10", "33")
  81
  82         xGridWin.executeAction("SELECT", mkPropertyValues({"RANGE": "B1:B10"}))
  83
  84         # Execute "Sort" dialog
  85         self.ui_test.execute_dialog_through_command(".uno:DataSort")
  86         xSortDlg = self.xUITest.getTopFocusWindow()
  87
  88         xOkBtn = xSortDlg.getChild("ok")
  89         self.ui_test.close_dialog_through_button(xOkBtn)
  90
  91         document = self.ui_test.get_component()
  92
  93         self.assertEqual(get_cell_by_position(document, 0, 1, 0).getValue(), 0)
  94         self.assertEqual(get_cell_by_position(document, 0, 1, 1).getValue(), 3)
  95         self.assertEqual(get_cell_by_position(document, 0, 1, 2).getValue(), 8)
  96         self.assertEqual(get_cell_by_position(document, 0, 1, 3).getValue(), 9)
  97         self.assertEqual(get_cell_by_position(document, 0, 1, 4).getValue(), 17)
  98         self.assertEqual(get_cell_by_position(document, 0, 1, 5).getValue(), 19)
  99         self.assertEqual(get_cell_by_position(document, 0, 1, 6).getValue(), 25)
 100         self.assertEqual(get_cell_by_position(document, 0, 1, 7).getValue(), 33)
 101         self.assertEqual(get_cell_by_position(document, 0, 1, 8).getValue(), 89)
 102         self.assertEqual(get_cell_by_position(document, 0, 1, 9).getValue(), 107)
 103
 104         time.sleep(2)
 105         self.ui_test.close_doc()
 106
 107     # http://manual-test.libreoffice.org/manage/case/191/
 108     def test_validation(self):
 109         self.ui_test.create_doc_in_start_center("calc")
 110
 111         xGridWin = self.xUITest.getTopFocusWindow().getChild("grid_window")
 112         xGridWin.executeAction("SELECT", mkPropertyValues({"RANGE": "A1:C10"}))
 113
 114         self.ui_test.execute_dialog_through_command(".uno:Validation")
 115         xValidationDlg = self.xUITest.getTopFocusWindow()
 116
 117         xAllowList = xValidationDlg.getChild("allow")
 118         xAllowList.executeAction("SELECT", mkPropertyValues({"POS": "1"}))
 119
 120         xData = xValidationDlg.getChild("data")
 121         xData.executeAction("SELECT", mkPropertyValues({"POS": "5"}))
 122
 123         xVal = xValidationDlg.getChild("max")
 124         xVal.executeAction("TYPE", mkPropertyValues({"TEXT":"0"}))
 125
 126         xOkBtn = xValidationDlg.getChild("ok")
 127         self.ui_test.close_dialog_through_button(xOkBtn)
 128
 129         def enter_text(cell, text):
 130             enter_text_to_cell(xGridWin, cell, text)
 131
 132         self.ui_test.execute_blocking_action(enter_text, "ok", args=("A1", "abc"))
 133         self.ui_test.execute_blocking_action(enter_text, "ok", args=("B6", "2.18"))
 134
 135         enter_text_to_cell(xGridWin, "C2", "24")
 136
 137         self.ui_test.close_doc()
 138
 139     # http://manual-test.libreoffice.org/manage/case/187/
 140     def test_transpose(self):
 141         self.ui_test.create_doc_in_start_center("calc")
 142
 143         xGridWin = self.xUITest.getTopFocusWindow().getChild("grid_window")
 144         enter_text_to_cell(xGridWin, "B3", "abcd")
 145         enter_text_to_cell(xGridWin, "B4", "edfg")
 146         enter_text_to_cell(xGridWin, "C3", "35")
 147         enter_text_to_cell(xGridWin, "C4", "5678")
 148
 149         xGridWin.executeAction("SELECT", mkPropertyValues({"RANGE": "A1:C10"}))
 150
 151         self.xUITest.executeCommand(".uno:Cut")
 152
 153         xGridWin.executeAction("SELECT", mkPropertyValues({"CELL": "A1"}))
 154
 155         self.ui_test.execute_dialog_through_command(".uno:PasteSpecial")
 156
 157         xPasteSpecialDlg = self.xUITest.getTopFocusWindow()
 158
 159         xAllChkBox = xPasteSpecialDlg.getChild("paste_all")
 160         xAllChkBox.executeAction("CLICK", tuple())
 161
 162         xTransposeChkBox = xPasteSpecialDlg.getChild("transpose")
 163         xTransposeChkBox.executeAction("CLICK", tuple())
 164
 165         xOkBtn = xPasteSpecialDlg.getChild("ok")
 166         self.ui_test.close_dialog_through_button(xOkBtn)
 167
 168         document = self.ui_test.get_component()
 169         self.assertEqual(get_cell_by_position(document, 0, 2, 1).getString(), "abcd")
 170         self.assertEqual(get_cell_by_position(document, 0, 2, 2).getValue(), 35)
 171         self.assertEqual(get_cell_by_position(document, 0, 3, 1).getString(), "edfg")
 172         self.assertEqual(get_cell_by_position(document, 0, 3, 2).getValue(), 5678)
 173
 174         self.ui_test.close_doc()
 175
 176     # http://manual-test.libreoffice.org/manage/case/151/
 177     def test_cell_recalc(self):
 178         doc = self.ui_test.load_file(get_url_for_data_file("cell_recalc.ods"))
 179
 180         xGridWin = self.xUITest.getTopFocusWindow().getChild("grid_window")
 181         xGridWin.executeAction("SELECT", mkPropertyValues({"RANGE": "D2:D9"}))
 182         self.xUITest.executeCommand(".uno:Cut")
 183
 184         self.assertEqual(get_cell_by_position(doc, 0, 3, 15).getValue(), 0)
 185
 186         self.xUITest.executeCommand(".uno:Undo")
 187
 188         for i in range(1, 9):
 189             self.assertTrue(get_cell_by_position(doc, 0, 3, i).getValue() != 0)
 190
 191         self.assertEqual(get_cell_by_position(doc, 0, 3, 15).getValue(), 195)
 192
 193         self.ui_test.close_doc()
 194
 195     # http://manual-test.libreoffice.org/manage/case/143/
 196     def test_random_numbers(self):
 197         self.ui_test.create_doc_in_start_center("calc")
 198         xGridWin = self.xUITest.getTopFocusWindow().getChild("grid_window")
 199
 200         xGridWin.executeAction("SELECT", mkPropertyValues({"RANGE": "A2:A10"}))
 201
 202         self.ui_test.execute_modeless_dialog_through_command(".uno:RandomNumberGeneratorDialog")
 203         xRandomNumberDlg = self.xUITest.getTopFocusWindow()
 204         xDistributionLstBox = xRandomNumberDlg.getChild("distribution-combo")
 205         xDistributionLstBox.executeAction("SELECT", mkPropertyValues({"POS": "1"}))
 206
 207         xMin = xRandomNumberDlg.getChild("parameter1-spin")
 208         xMin.executeAction("TYPE", mkPropertyValues({"KEYCODE": "CTRL+A"}))
 209         xMin.executeAction("TYPE", mkPropertyValues({"TEXT": "-2"}))
 210         xMax = xRandomNumberDlg.getChild("parameter2-spin")
 211         xMax.executeAction("TYPE", mkPropertyValues({"KEYCODE": "CTRL+A"}))
 212         xMax.executeAction("TYPE", mkPropertyValues({"TEXT": "10"}))
 213
 214         xApplyBtn = xRandomNumberDlg.getChild("apply")
 215         xApplyBtn.executeAction("CLICK", tuple())
 216
 217         doc = self.ui_test.get_component()
 218
 219         def check_random_values():
 220             for i in range(1, 9):
 221                 val = get_cell_by_position(doc, 0, 0, i).getValue()
 222                 self.assertTrue(val <= 10 and val >= -2)
 223
 224         check_random_values()
 225
 226         xOkBtn = xRandomNumberDlg.getChild("ok")
 227         self.ui_test.close_dialog_through_button(xOkBtn)
 228
 229         # we might want to check that clicking 'ok' actually changes the values
 230         check_random_values()
 231
 232         self.ui_test.close_doc()
 233
 234 # vim: set shiftwidth=4 softtabstop=4 expandtab: