sc/qa/uitest/statistics/correlation.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 from uitest.framework import UITestCase
   8 from uitest.uihelper.common import get_state_as_dict
   9 from uitest.uihelper.common import select_pos
  10 from uitest.uihelper.calc import enter_text_to_cell
  11 from libreoffice.calc.document import get_sheet_from_doc
  12 from libreoffice.calc.conditional_format import get_conditional_format_from_sheet
  13 from uitest.debug import sleep
  14 from libreoffice.calc.document import get_cell_by_position
  15 from libreoffice.uno.propertyvalue import mkPropertyValues
  16
  17 class correlation(UITestCase):
  18     def test_statistic_correlation_column(self):
  19         calc_doc = self.ui_test.create_doc_in_start_center("calc")
  20         xCalcDoc = self.xUITest.getTopFocusWindow()
  21         gridwin = xCalcDoc.getChild("grid_window")
  22         document = self.ui_test.get_component()
  23         #fill data
  24         enter_text_to_cell(gridwin, "A1", "Maths")
  25         enter_text_to_cell(gridwin, "A2", "47")
  26         enter_text_to_cell(gridwin, "A3", "36")
  27         enter_text_to_cell(gridwin, "A4", "40")
  28         enter_text_to_cell(gridwin, "A5", "39")
  29         enter_text_to_cell(gridwin, "A7", "47")
  30         enter_text_to_cell(gridwin, "A8", "29")
  31         enter_text_to_cell(gridwin, "A9", "27")
  32         enter_text_to_cell(gridwin, "A10", "57")
  33         enter_text_to_cell(gridwin, "A11", "56")
  34         enter_text_to_cell(gridwin, "A12", "57")
  35         enter_text_to_cell(gridwin, "A13", "26")
  36
  37         enter_text_to_cell(gridwin, "B1", "Physics")
  38         enter_text_to_cell(gridwin, "B2", "67")
  39         enter_text_to_cell(gridwin, "B3", "68")
  40         enter_text_to_cell(gridwin, "B4", "65")
  41         enter_text_to_cell(gridwin, "B5", "64")
  42         enter_text_to_cell(gridwin, "B6", "38")
  43         enter_text_to_cell(gridwin, "B7", "84")
  44         enter_text_to_cell(gridwin, "B8", "80")
  45         enter_text_to_cell(gridwin, "B9", "49")
  46         enter_text_to_cell(gridwin, "B10", "49")
  47         enter_text_to_cell(gridwin, "B11", "33")
  48
  49         enter_text_to_cell(gridwin, "C1", "Biology")
  50         enter_text_to_cell(gridwin, "C2", "33")
  51         enter_text_to_cell(gridwin, "C3", "42")
  52         enter_text_to_cell(gridwin, "C4", "44")
  53         enter_text_to_cell(gridwin, "C5", "60")
  54         enter_text_to_cell(gridwin, "C6", "43")
  55         enter_text_to_cell(gridwin, "C7", "62")
  56         enter_text_to_cell(gridwin, "C8", "51")
  57         enter_text_to_cell(gridwin, "C9", "40")
  58         enter_text_to_cell(gridwin, "C10", "12")
  59         enter_text_to_cell(gridwin, "C11", "60")
  60         gridwin.executeAction("SELECT", mkPropertyValues({"RANGE": "A1:C13"}))
  61         self.ui_test.execute_modeless_dialog_through_command(".uno:CorrelationDialog")
  62         xDialog = self.xUITest.getTopFocusWindow()
  63         xinputrangeedit = xDialog.getChild("input-range-edit")
  64         xoutputrangeedit = xDialog.getChild("output-range-edit")
  65         xgroupedbyrowsradio = xDialog.getChild("groupedby-rows-radio")
  66         xgroupedbycolumnsradio = xDialog.getChild("groupedby-columns-radio")
  67
  68         xinputrangeedit.executeAction("TYPE", mkPropertyValues({"KEYCODE":"CTRL+A"}))
  69         xinputrangeedit.executeAction("TYPE", mkPropertyValues({"KEYCODE":"BACKSPACE"}))
  70         xinputrangeedit.executeAction("TYPE", mkPropertyValues({"TEXT":"$Sheet1.$A$1:$C$13"}))
  71         xoutputrangeedit.executeAction("TYPE", mkPropertyValues({"KEYCODE":"CTRL+A"}))
  72         xoutputrangeedit.executeAction("TYPE", mkPropertyValues({"KEYCODE":"BACKSPACE"}))
  73         xoutputrangeedit.executeAction("TYPE", mkPropertyValues({"TEXT":"$F$1"}))
  74         xgroupedbyrowsradio.executeAction("CLICK", tuple())
  75         xgroupedbycolumnsradio.executeAction("CLICK", tuple())
  76         xOKBtn = xDialog.getChild("ok")
  77         self.ui_test.close_dialog_through_button(xOKBtn)
  78
  79         #Verify
  80         self.assertEqual(get_cell_by_position(document, 0, 5, 0).getString(), "Correlations")
  81         self.assertEqual(get_cell_by_position(document, 0, 5, 1).getString(), "Column 1")
  82         self.assertEqual(get_cell_by_position(document, 0, 5, 2).getString(), "Column 2")
  83         self.assertEqual(get_cell_by_position(document, 0, 5, 3).getString(), "Column 3")
  84
  85         self.assertEqual(get_cell_by_position(document, 0, 6, 0).getString(), "Column 1")
  86         self.assertEqual(get_cell_by_position(document, 0, 6, 1).getValue(), 1)
  87         self.assertEqual(round(get_cell_by_position(document, 0, 6, 2).getValue(),14), -0.40292549168204)
  88         self.assertEqual(round(get_cell_by_position(document, 0, 6, 3).getValue(),14), -0.21076428363645)
  89
  90         self.assertEqual(get_cell_by_position(document, 0, 7, 0).getString(), "Column 2")
  91         self.assertEqual(get_cell_by_position(document, 0, 7, 2).getValue(), 1)
  92         self.assertEqual(round(get_cell_by_position(document, 0, 7, 3).getValue(),14), 0.23097140475091)
  93
  94         self.assertEqual(get_cell_by_position(document, 0, 8, 0).getString(), "Column 3")
  95         self.assertEqual(get_cell_by_position(document, 0, 8, 3).getValue(), 1)
  96
  97         #undo
  98         self.xUITest.executeCommand(".uno:Undo")
  99         self.assertEqual(get_cell_by_position(document, 0, 5, 0).getString(), "")
 100
 101         # test cancel button
 102         self.ui_test.execute_modeless_dialog_through_command(".uno:CorrelationDialog")
 103         xDialog = self.xUITest.getTopFocusWindow()
 104         xCancelBtn = xDialog.getChild("cancel")
 105         self.ui_test.close_dialog_through_button(xCancelBtn)
 106
 107         self.ui_test.close_doc()
 108
 109     def test_statistic_correlation_row(self):
 110         calc_doc = self.ui_test.create_doc_in_start_center("calc")
 111         xCalcDoc = self.xUITest.getTopFocusWindow()
 112         gridwin = xCalcDoc.getChild("grid_window")
 113         document = self.ui_test.get_component()
 114         #fill data
 115         enter_text_to_cell(gridwin, "A1", "Maths")
 116         enter_text_to_cell(gridwin, "A2", "Physics")
 117         enter_text_to_cell(gridwin, "A3", "Biology")
 118
 119         enter_text_to_cell(gridwin, "B1", "47")
 120         enter_text_to_cell(gridwin, "B2", "67")
 121         enter_text_to_cell(gridwin, "B3", "33")
 122
 123         enter_text_to_cell(gridwin, "C1", "36")
 124         enter_text_to_cell(gridwin, "C2", "68")
 125         enter_text_to_cell(gridwin, "C3", "42")
 126
 127         enter_text_to_cell(gridwin, "D1", "40")
 128         enter_text_to_cell(gridwin, "D2", "65")
 129         enter_text_to_cell(gridwin, "D3", "44")
 130
 131         enter_text_to_cell(gridwin, "E1", "39")
 132         enter_text_to_cell(gridwin, "E2", "64")
 133         enter_text_to_cell(gridwin, "E3", "60")
 134
 135         enter_text_to_cell(gridwin, "F2", "38")
 136         enter_text_to_cell(gridwin, "F3", "43")
 137
 138         enter_text_to_cell(gridwin, "G1", "47")
 139         enter_text_to_cell(gridwin, "G2", "84")
 140         enter_text_to_cell(gridwin, "G3", "62")
 141
 142         enter_text_to_cell(gridwin, "H1", "29")
 143         enter_text_to_cell(gridwin, "H2", "80")
 144         enter_text_to_cell(gridwin, "H3", "51")
 145
 146         enter_text_to_cell(gridwin, "I1", "27")
 147         enter_text_to_cell(gridwin, "I2", "49")
 148         enter_text_to_cell(gridwin, "I3", "40")
 149
 150         enter_text_to_cell(gridwin, "J1", "57")
 151         enter_text_to_cell(gridwin, "J2", "49")
 152         enter_text_to_cell(gridwin, "J3", "12")
 153
 154         enter_text_to_cell(gridwin, "K1", "56")
 155         enter_text_to_cell(gridwin, "K2", "33")
 156         enter_text_to_cell(gridwin, "K3", "60")
 157
 158         enter_text_to_cell(gridwin, "L1", "57")
 159
 160         enter_text_to_cell(gridwin, "M1", "26")
 161
 162         gridwin.executeAction("SELECT", mkPropertyValues({"RANGE": "A1:M3"}))
 163         self.ui_test.execute_modeless_dialog_through_command(".uno:CorrelationDialog")
 164         xDialog = self.xUITest.getTopFocusWindow()
 165         xinputrangeedit = xDialog.getChild("input-range-edit")
 166         xoutputrangeedit = xDialog.getChild("output-range-edit")
 167         xgroupedbyrowsradio = xDialog.getChild("groupedby-rows-radio")
 168         xgroupedbycolumnsradio = xDialog.getChild("groupedby-columns-radio")
 169
 170         xinputrangeedit.executeAction("TYPE", mkPropertyValues({"KEYCODE":"CTRL+A"}))
 171         xinputrangeedit.executeAction("TYPE", mkPropertyValues({"KEYCODE":"BACKSPACE"}))
 172         xinputrangeedit.executeAction("TYPE", mkPropertyValues({"TEXT":"$Sheet1.$A$1:$M$3"}))
 173         xoutputrangeedit.executeAction("TYPE", mkPropertyValues({"KEYCODE":"CTRL+A"}))
 174         xoutputrangeedit.executeAction("TYPE", mkPropertyValues({"KEYCODE":"BACKSPACE"}))
 175         xoutputrangeedit.executeAction("TYPE", mkPropertyValues({"TEXT":"$A$7"}))
 176         xgroupedbyrowsradio.executeAction("CLICK", tuple())
 177         xOKBtn = xDialog.getChild("ok")
 178         self.ui_test.close_dialog_through_button(xOKBtn)
 179         #Verify
 180         self.assertEqual(get_cell_by_position(document, 0, 0, 6).getString(), "Correlations")
 181         self.assertEqual(get_cell_by_position(document, 0, 0, 7).getString(), "Row 1")
 182         self.assertEqual(get_cell_by_position(document, 0, 0, 8).getString(), "Row 2")
 183         self.assertEqual(get_cell_by_position(document, 0, 0, 9).getString(), "Row 3")
 184
 185         self.assertEqual(get_cell_by_position(document, 0, 1, 6).getString(), "Row 1")
 186         self.assertEqual(get_cell_by_position(document, 0, 1, 7).getValue(), 1)
 187         self.assertEqual(round(get_cell_by_position(document, 0, 1, 8).getValue(),15), -0.402925491682042)
 188         self.assertEqual(round(get_cell_by_position(document, 0, 1, 9).getValue(),15), -0.210764283636454)
 189
 190         self.assertEqual(get_cell_by_position(document, 0, 2, 6).getString(), "Row 2")
 191         self.assertEqual(get_cell_by_position(document, 0, 2, 8).getValue(), 1)
 192         self.assertEqual(round(get_cell_by_position(document, 0, 2, 9).getValue(),14), 0.23097140475091)
 193
 194         self.assertEqual(get_cell_by_position(document, 0, 3, 6).getString(), "Row 3")
 195         self.assertEqual(get_cell_by_position(document, 0, 3, 9).getValue(), 1)
 196
 197         #undo
 198         self.xUITest.executeCommand(".uno:Undo")
 199         self.assertEqual(get_cell_by_position(document, 0, 5, 0).getString(), "")
 200
 201         self.ui_test.close_doc()
 202 # vim: set shiftwidth=4 softtabstop=4 expandtab: