sc/qa/uitest/statistics/sampling.py | 41 ++++++++++++++++++++++++++++++++++++
1 file changed, 41 insertions(+)
New commits:
commit fd06044c0178bb7724a735c233aa698e2dcea096
Author: Xisco Fauli <xiscofa...@libreoffice.org>
AuthorDate: Wed Nov 10 12:00:04 2021 +0100
Commit: Xisco Fauli <xiscofa...@libreoffice.org>
CommitDate: Thu Nov 11 16:05:34 2021 +0100
tdf#142986: sc: Add UItest
Change-Id: I8469056b0b38b1d714ffdc1cc006beacae6ea3c5
Reviewed-on: https://gerrit.libreoffice.org/c/core/+/124956
Tested-by: Jenkins
Reviewed-by: Xisco Fauli <xiscofa...@libreoffice.org>
diff --git a/sc/qa/uitest/statistics/sampling.py
b/sc/qa/uitest/statistics/sampling.py
index 78781e9699c5..b0f1a9bff9fe 100644
--- a/sc/qa/uitest/statistics/sampling.py
+++ b/sc/qa/uitest/statistics/sampling.py
@@ -105,4 +105,45 @@ class sampling(UITestCase):
with
self.ui_test.execute_modeless_dialog_through_command(".uno:SamplingDialog",
close_button="cancel"):
pass
+ def test_tdf142986(self):
+ with self.ui_test.create_doc_in_start_center("calc") as calc_doc:
+ xCalcDoc = self.xUITest.getTopFocusWindow()
+ gridwin = xCalcDoc.getChild("grid_window")
+ #fill data
+ gridwin.executeAction("SELECT", mkPropertyValues({"RANGE":
"A1:A200"}))
+ with
self.ui_test.execute_dialog_through_command(".uno:FillSeries") as xDialog:
+ xStartValue = xDialog.getChild("startValue")
+ xStartValue.executeAction("TYPE",
mkPropertyValues({"KEYCODE":"CTRL+A"}))
+ xStartValue.executeAction("TYPE",
mkPropertyValues({"KEYCODE":"BACKSPACE"}))
+ xStartValue.executeAction("TYPE",
mkPropertyValues({"TEXT":"1"}))
+
+ xIncrement = xDialog.getChild("increment")
+ xIncrement.executeAction("TYPE",
mkPropertyValues({"KEYCODE":"CTRL+A"}))
+ xIncrement.executeAction("TYPE",
mkPropertyValues({"KEYCODE":"BACKSPACE"}))
+ xIncrement.executeAction("TYPE",
mkPropertyValues({"TEXT":"1"}))
+
+ self.assertEqual(get_cell_by_position(calc_doc, 0, 0,
199).getValue(), 200)
+
+ with
self.ui_test.execute_modeless_dialog_through_command(".uno:SamplingDialog") as
xDialog:
+ xInputRangeEdit = xDialog.getChild("input-range-edit")
+ xOutputRangeEdit = xDialog.getChild("output-range-edit")
+ xRandomMethodRadio = xDialog.getChild("random-method-radio")
+ xSampleSizeSpin = xDialog.getChild("sample-size-spin")
+
+ self.assertEqual("$Sheet1.$A$1:$A$200",
get_state_as_dict(xInputRangeEdit)['Text'])
+
+ xOutputRangeEdit.executeAction("TYPE",
mkPropertyValues({"KEYCODE":"CTRL+A"}))
+ xOutputRangeEdit.executeAction("TYPE",
mkPropertyValues({"KEYCODE":"BACKSPACE"}))
+ xOutputRangeEdit.executeAction("TYPE",
mkPropertyValues({"TEXT":"$B$1"}))
+
+ xRandomMethodRadio.executeAction("CLICK", tuple())
+
+ xSampleSizeSpin.executeAction("TYPE",
mkPropertyValues({"KEYCODE":"CTRL+A"}))
+ xSampleSizeSpin.executeAction("TYPE",
mkPropertyValues({"KEYCODE":"BACKSPACE"}))
+ xSampleSizeSpin.executeAction("TYPE",
mkPropertyValues({"TEXT":"200"}))
+
+ for i in range(200):
+ self.assertTrue(get_cell_by_position(calc_doc, 0, 1,
i).getValue() != 0.0,
+ "Value in cell B" + str(i) + " shouldn't be equal to
0.0")
+
# vim: set shiftwidth=4 softtabstop=4 expandtab:
