# -*- 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.calc
import enter_text_to_cell
from libreoffice.calc.document
import get_cell_by_position
from libreoffice.uno.propertyvalue
import mkPropertyValues
class correlation(UITestCase):
def test_statistic_correlation_column(self):
with self.ui_test.create_doc_in_start_center(
"calc" )
as document:
xCalcDoc = self.xUITest.getTopFocusWindow()
gridwin = xCalcDoc.getChild(
"grid_window" )
#fill data
enter_text_to_cell(gridwin,
"A1" ,
"Maths" )
enter_text_to_cell(gridwin,
"A2" ,
"47" )
enter_text_to_cell(gridwin,
"A3" ,
"36" )
enter_text_to_cell(gridwin,
"A4" ,
"40" )
enter_text_to_cell(gridwin,
"A5" ,
"39" )
enter_text_to_cell(gridwin,
"A7" ,
"47" )
enter_text_to_cell(gridwin,
"A8" ,
"29" )
enter_text_to_cell(gridwin,
"A9" ,
"27" )
enter_text_to_cell(gridwin,
"A10" ,
"57" )
enter_text_to_cell(gridwin,
"A11" ,
"56" )
enter_text_to_cell(gridwin,
"A12" ,
"57" )
enter_text_to_cell(gridwin,
"A13" ,
"26" )
enter_text_to_cell(gridwin,
"B1" ,
"Physics" )
enter_text_to_cell(gridwin,
"B2" ,
"67" )
enter_text_to_cell(gridwin,
"B3" ,
"68" )
enter_text_to_cell(gridwin,
"B4" ,
"65" )
enter_text_to_cell(gridwin,
"B5" ,
"64" )
enter_text_to_cell(gridwin,
"B6" ,
"38" )
enter_text_to_cell(gridwin,
"B7" ,
"84" )
enter_text_to_cell(gridwin,
"B8" ,
"80" )
enter_text_to_cell(gridwin,
"B9" ,
"49" )
enter_text_to_cell(gridwin,
"B10" ,
"49" )
enter_text_to_cell(gridwin,
"B11" ,
"33" )
enter_text_to_cell(gridwin,
"C1" ,
"Biology" )
enter_text_to_cell(gridwin,
"C2" ,
"33" )
enter_text_to_cell(gridwin,
"C3" ,
"42" )
enter_text_to_cell(gridwin,
"C4" ,
"44" )
enter_text_to_cell(gridwin,
"C5" ,
"60" )
enter_text_to_cell(gridwin,
"C6" ,
"43" )
enter_text_to_cell(gridwin,
"C7" ,
"62" )
enter_text_to_cell(gridwin,
"C8" ,
"51" )
enter_text_to_cell(gridwin,
"C9" ,
"40" )
enter_text_to_cell(gridwin,
"C10" ,
"12" )
enter_text_to_cell(gridwin,
"C11" ,
"60" )
gridwin.executeAction(
"SELECT" , mkPropertyValues({
"RANGE" :
"A1:C13" }))
with self.ui_test.execute_modeless_dialog_through_command(
".uno:CorrelationDialog" )
as xDialog:
xinputrangeedit = xDialog.getChild(
"input-range-edit" )
xoutputrangeedit = xDialog.getChild(
"output-range-edit" )
xgroupedbyrowsradio = xDialog.getChild(
"groupedby-rows-radio" )
xgroupedbycolumnsradio = xDialog.getChild(
"groupedby-columns-radio" )
xinputrangeedit.executeAction(
"TYPE" , mkPropertyValues({
"KEYCODE" :
"CTRL+A" }))
xinputrangeedit.executeAction(
"TYPE" , mkPropertyValues({
"KEYCODE" :
"BACKSPACE" }))
xinputrangeedit.executeAction(
"TYPE" , mkPropertyValues({
"TEXT" :
"$Sheet1.$A$1:$C$13" }))
xoutputrangeedit.executeAction(
"TYPE" , mkPropertyValues({
"KEYCODE" :
"CTRL+A" }))
xoutputrangeedit.executeAction(
"TYPE" , mkPropertyValues({
"KEYCODE" :
"BACKSPACE" }))
xoutputrangeedit.executeAction(
"TYPE" , mkPropertyValues({
"TEXT" :
"$F$1" }))
xgroupedbyrowsradio.executeAction(
"CLICK" , tuple())
xgroupedbycolumnsradio.executeAction(
"CLICK" , tuple())
#Verify
self.assertEqual(get_cell_by_position(document,
0 ,
5 ,
0 ).getString(),
"Correlations" )0 , 5 , 1 ).getString(), "Column 1" )0 , 5 , 2 ).getString(), "Column 2" )0 , 5 , 3 ).getString(), "Column 3" )0 , 6 , 0 ).getString(), "Column 1" )0 , 6 , 1 ).getValue(), 1 )0 , 6 , 2 ).getValue(),14 ), -0 .40292549168204 )0 , 6 , 3 ).getValue(),14 ), -0 .21076428363645 )0 , 7 , 0 ).getString(), "Column 2" )0 , 7 , 2 ).getValue(), 1 )0 , 7 , 3 ).getValue(),14 ), 0 .23097140475091 )0 , 8 , 0 ).getString(), "Column 3" )0 , 8 , 3 ).getValue(), 1 )#undo ".uno:Undo" )0 , 5 , 0 ).getString(), "" )# test cancel button with self.ui_test.execute_modeless_dialog_through_command(".uno:CorrelationDialog" , close_button="cancel" ):pass def test_statistic_correlation_row(self):with self.ui_test.create_doc_in_start_center("calc" ) as document:"grid_window" )#fill data "A1" , "Maths" )"A2" , "Physics" )"A3" , "Biology" )"B1" , "47" )"B2" , "67" )"B3" , "33" )"C1" , "36" )"C2" , "68" )"C3" , "42" )"D1" , "40" )"D2" , "65" )"D3" , "44" )"E1" , "39" )"E2" , "64" )"E3" , "60" )"F2" , "38" )"F3" , "43" )"G1" , "47" )"G2" , "84" )"G3" , "62" )"H1" , "29" )"H2" , "80" )"H3" , "51" )"I1" , "27" )"I2" , "49" )"I3" , "40" )"J1" , "57" )"J2" , "49" )"J3" , "12" )"K1" , "56" )"K2" , "33" )"K3" , "60" )"L1" , "57" )"M1" , "26" )"SELECT" , mkPropertyValues({"RANGE" : "A1:M3" }))with self.ui_test.execute_modeless_dialog_through_command(".uno:CorrelationDialog" ) as xDialog:"input-range-edit" )"output-range-edit" )"groupedby-rows-radio" )"TYPE" , mkPropertyValues({"KEYCODE" :"CTRL+A" }))"TYPE" , mkPropertyValues({"KEYCODE" :"BACKSPACE" }))"TYPE" , mkPropertyValues({"TEXT" :"$Sheet1.$A$1:$M$3" }))"TYPE" , mkPropertyValues({"KEYCODE" :"CTRL+A" }))"TYPE" , mkPropertyValues({"KEYCODE" :"BACKSPACE" }))"TYPE" , mkPropertyValues({"TEXT" :"$A$7" }))"CLICK" , tuple())#Verify 0 , 0 , 6 ).getString(), "Correlations" )0 , 0 , 7 ).getString(), "Row 1" )0 , 0 , 8 ).getString(), "Row 2" )0 , 0 , 9 ).getString(), "Row 3" )0 , 1 , 6 ).getString(), "Row 1" )0 , 1 , 7 ).getValue(), 1 )0 , 1 , 8 ).getValue(),15 ), -0 .402925491682042 )0 , 1 , 9 ).getValue(),15 ), -0 .210764283636454 )0 , 2 , 6 ).getString(), "Row 2" )0 , 2 , 8 ).getValue(), 1 )0 , 2 , 9 ).getValue(),14 ), 0 .23097140475091 )0 , 3 , 6 ).getString(), "Row 3" )0 , 3 , 9 ).getValue(), 1 )#undo ".uno:Undo" )0 , 5 , 0 ).getString(), "" )# vim: set shiftwidth=4 softtabstop=4 expandtab: Messung V0.5 in Prozent C=92 H=100 G=95
¤ Dauer der Verarbeitung: 0.10 Sekunden
(vorverarbeitet am 2026-06-08)
¤ *© Formatika GbR, Deutschland
