sc/qa/uitest/calc_tests8/tdf119343.py | 7 ++-----
sc/qa/uitest/calc_tests9/tdf142763.py | 4 ++--
sc/qa/uitest/chart/chartGrids.py | 8 +++-----
sc/qa/uitest/chart/chartXAxis.py | 12 +++++-------
sc/qa/uitest/chart/chartYAxis.py | 12 +++++-------
sc/qa/uitest/chart/tdf93506_trendline.py | 14 ++++++--------
sc/qa/uitest/chart2/tdf124295.py | 2 --
sc/qa/uitest/conditional_format/tdf105466.py | 2 +-
sc/qa/uitest/conditional_format/tdf105544.py | 6 +++---
sc/qa/uitest/conditional_format/tdf81696.py | 9 +++------
sc/qa/uitest/function_wizard/tdf123479.py | 8 ++------
sc/qa/uitest/hide_cols/tdf95306.py | 5 ++---
sc/qa/uitest/inputLine/tdf54197.py | 9 ++++-----
sc/qa/uitest/key_f4/f4.py | 6 +++---
sc/qa/uitest/pasteSpecial/tdf74577.py | 3 ++-
sc/qa/uitest/protect/protectSheet.py | 7 +++----
sc/qa/uitest/protect/protectSpreadsheet.py | 9 ++-------
sc/qa/uitest/sort/naturalSort.py | 9 ++++-----
sc/qa/uitest/sort/sorting.py | 9 ++++-----
sc/qa/uitest/sort/stableSorting.py | 7 ++-----
sc/qa/uitest/sort/tdf91305.py | 8 ++++----
sc/qa/uitest/sort/tdf99773.py | 9 ++++-----
sc/qa/uitest/statistics/anova.py | 6 ++----
sc/qa/uitest/statistics/chiSquare.py | 6 ++----
sc/qa/uitest/statistics/correlation.py | 6 ++----
sc/qa/uitest/statistics/covariance.py | 6 ++----
sc/qa/uitest/statistics/descriptiveStatistics.py | 6 ++----
sc/qa/uitest/statistics/exponentialSmoothing.py | 6 ++----
sc/qa/uitest/statistics/movingAverage.py | 6 ++----
sc/qa/uitest/statistics/sampling.py | 7 +++----
sc/qa/uitest/statistics/tTest.py | 6 ++----
sc/qa/uitest/statistics/tdf76731.py | 7 ++-----
sc/qa/uitest/statistics/zTest.py | 6 ++----
33 files changed, 89 insertions(+), 144 deletions(-)
New commits:
commit 30a048cb895a3dcdd6048f3c525edd95a1371b91
Author: tagezi <lera.goncha...@gmail.com>
AuthorDate: Mon May 16 14:55:48 2022 +0300
Commit: Xisco Fauli <xiscofa...@libreoffice.org>
CommitDate: Mon May 23 14:33:38 2022 +0200
tdf#132293: Removing unused imports from uitests files.
It seems, most of the most imports were copy-pasted from one file
to a new one.
Additionally, the import block and surrounding area made more readable.
Change-Id: I8afc5debef6e758d7ad42b1a649f9556d3d7abbd
Reviewed-on: https://gerrit.libreoffice.org/c/core/+/134400
Tested-by: Jenkins
Reviewed-by: Xisco Fauli <xiscofa...@libreoffice.org>
diff --git a/sc/qa/uitest/calc_tests8/tdf119343.py
b/sc/qa/uitest/calc_tests8/tdf119343.py
index 51d35a99af93..0debe6aea848 100644
--- a/sc/qa/uitest/calc_tests8/tdf119343.py
+++ b/sc/qa/uitest/calc_tests8/tdf119343.py
@@ -8,15 +8,12 @@
#
from uitest.framework import UITestCase
from uitest.uihelper.common import get_state_as_dict, get_url_for_data_file
-from uitest.uihelper.common import select_pos
-from uitest.uihelper.calc import enter_text_to_cell
-from libreoffice.calc.document import get_sheet_from_doc
-from libreoffice.calc.conditional_format import
get_conditional_format_from_sheet
+
from libreoffice.calc.document import get_cell_by_position
from libreoffice.uno.propertyvalue import mkPropertyValues
-#Bug 119343 - EDITING: copied and pasted cells containing formulas are not
recalculated (2)
+# Bug 119343 - EDITING: copied and pasted cells containing formulas are not
recalculated (2)
class tdf119343(UITestCase):
def test_tdf119343_copy_paste_formula(self):
#numberingformatpage.ui
diff --git a/sc/qa/uitest/calc_tests9/tdf142763.py
b/sc/qa/uitest/calc_tests9/tdf142763.py
index e7885063a292..238d30833eb1 100644
--- a/sc/qa/uitest/calc_tests9/tdf142763.py
+++ b/sc/qa/uitest/calc_tests9/tdf142763.py
@@ -8,9 +8,9 @@
#
from uitest.framework import UITestCase
from uitest.uihelper.common import get_state_as_dict, get_url_for_data_file,
select_pos
+
from libreoffice.uno.propertyvalue import mkPropertyValues
-from libreoffice.calc.document import get_cell_by_position
-import time
+
class Tdf142763(UITestCase):
diff --git a/sc/qa/uitest/chart/chartGrids.py b/sc/qa/uitest/chart/chartGrids.py
index 8bff4e58296c..dda37675c4cc 100644
--- a/sc/qa/uitest/chart/chartGrids.py
+++ b/sc/qa/uitest/chart/chartGrids.py
@@ -7,14 +7,12 @@
# file, You can obtain one at http://mozilla.org/MPL/2.0/.
#
from uitest.framework import UITestCase
-from uitest.uihelper.common import select_pos
-from uitest.uihelper.calc import enter_text_to_cell
-from libreoffice.calc.document import get_cell_by_position
-from libreoffice.uno.propertyvalue import mkPropertyValues
from uitest.uihelper.common import get_state_as_dict, get_url_for_data_file,
type_text
-#Chart Enable Grids dialog
+from libreoffice.uno.propertyvalue import mkPropertyValues
+
+# Chart Enable Grids dialog
class chartGrids(UITestCase):
def test_chart_enable_grids_dialog(self):
with self.ui_test.load_file(get_url_for_data_file("tdf98390.ods")) as
calc_doc:
diff --git a/sc/qa/uitest/chart/chartXAxis.py b/sc/qa/uitest/chart/chartXAxis.py
index b5b1b8fb98cb..61fb5c11b78b 100644
--- a/sc/qa/uitest/chart/chartXAxis.py
+++ b/sc/qa/uitest/chart/chartXAxis.py
@@ -7,16 +7,14 @@
# file, You can obtain one at http://mozilla.org/MPL/2.0/.
#
from uitest.framework import UITestCase
-from uitest.uihelper.common import select_pos
-from uitest.uihelper.common import select_by_text
-from uitest.uihelper.common import change_measurement_unit
-from uitest.uihelper.calc import enter_text_to_cell
-from libreoffice.calc.document import get_cell_by_position
+from uitest.uihelper.common import change_measurement_unit, type_text
+from uitest.uihelper.common import get_state_as_dict, get_url_for_data_file
+from uitest.uihelper.common import select_by_text, select_pos
+
from libreoffice.uno.propertyvalue import mkPropertyValues
-from uitest.uihelper.common import get_state_as_dict, get_url_for_data_file,
type_text
-#Chart - X Axis
+# Chart - X Axis
class chartXAxis(UITestCase):
def test_chart_x_axis_dialog(self):
with self.ui_test.load_file(get_url_for_data_file("tdf122398.ods")) as
calc_doc:
diff --git a/sc/qa/uitest/chart/chartYAxis.py b/sc/qa/uitest/chart/chartYAxis.py
index 0138277dcf2d..6d8383a4fab6 100644
--- a/sc/qa/uitest/chart/chartYAxis.py
+++ b/sc/qa/uitest/chart/chartYAxis.py
@@ -7,16 +7,14 @@
# file, You can obtain one at http://mozilla.org/MPL/2.0/.
#
from uitest.framework import UITestCase
-from uitest.uihelper.common import select_pos
-from uitest.uihelper.common import select_by_text
-from uitest.uihelper.common import change_measurement_unit
-from uitest.uihelper.calc import enter_text_to_cell
-from libreoffice.calc.document import get_cell_by_position
+from uitest.uihelper.common import change_measurement_unit, type_text
+from uitest.uihelper.common import get_state_as_dict, get_url_for_data_file
+from uitest.uihelper.common import select_by_text, select_pos
+
from libreoffice.uno.propertyvalue import mkPropertyValues
-from uitest.uihelper.common import get_state_as_dict, get_url_for_data_file,
type_text
-#Chart - Y Axis
+# Chart - Y Axis
class chartYAxis(UITestCase):
def test_chart_y_axis_dialog(self):
with self.ui_test.load_file(get_url_for_data_file("tdf122398.ods")) as
calc_doc:
diff --git a/sc/qa/uitest/chart/tdf93506_trendline.py
b/sc/qa/uitest/chart/tdf93506_trendline.py
index 3bf0dc2e4014..263727913783 100644
--- a/sc/qa/uitest/chart/tdf93506_trendline.py
+++ b/sc/qa/uitest/chart/tdf93506_trendline.py
@@ -7,17 +7,15 @@
# file, You can obtain one at http://mozilla.org/MPL/2.0/.
#
from uitest.framework import UITestCase
-from uitest.uihelper.common import select_pos
-from uitest.uihelper.common import select_by_text
-from uitest.uihelper.common import change_measurement_unit
-from uitest.uihelper.calc import enter_text_to_cell
-from libreoffice.calc.document import get_cell_by_position
+from uitest.uihelper.common import change_measurement_unit, type_text
+from uitest.uihelper.common import get_state_as_dict, get_url_for_data_file
+from uitest.uihelper.common import select_by_text, select_pos
+
from libreoffice.uno.propertyvalue import mkPropertyValues
-from uitest.uihelper.common import get_state_as_dict, get_url_for_data_file,
type_text
-#Bug 93506 - Crash when selecting chart containing a trend line
-# test all dialog items - trend Line dialog
+# Bug 93506 - Crash when selecting chart containing a trend line
+# test all dialog items - trend Line dialog
class tdf93506(UITestCase):
def test_tdf93506_chart_trendline_dialog(self):
with self.ui_test.load_file(get_url_for_data_file("tdf93506.ods")) as
calc_doc:
diff --git a/sc/qa/uitest/chart2/tdf124295.py b/sc/qa/uitest/chart2/tdf124295.py
index 0dc013dd20ce..0c64e0e2386b 100644
--- a/sc/qa/uitest/chart2/tdf124295.py
+++ b/sc/qa/uitest/chart2/tdf124295.py
@@ -10,8 +10,6 @@
from uitest.framework import UITestCase
from uitest.uihelper.common import get_state_as_dict
-import time
-import unittest
class tdf124295(UITestCase):
diff --git a/sc/qa/uitest/conditional_format/tdf105466.py
b/sc/qa/uitest/conditional_format/tdf105466.py
index 2b0be6aefcbe..1790575fdf86 100644
--- a/sc/qa/uitest/conditional_format/tdf105466.py
+++ b/sc/qa/uitest/conditional_format/tdf105466.py
@@ -8,9 +8,9 @@
#
from uitest.framework import UITestCase
-from libreoffice.uno.propertyvalue import mkPropertyValues
from uitest.uihelper.common import select_pos
+
class tdf105466(UITestCase):
def test_changing_conditional_format(self):
diff --git a/sc/qa/uitest/conditional_format/tdf105544.py
b/sc/qa/uitest/conditional_format/tdf105544.py
index 4205da2c8d30..d89f518187e2 100644
--- a/sc/qa/uitest/conditional_format/tdf105544.py
+++ b/sc/qa/uitest/conditional_format/tdf105544.py
@@ -9,11 +9,11 @@
from uitest.framework import UITestCase
from uitest.uihelper.common import get_state_as_dict, get_url_for_data_file
-from libreoffice.calc.document import get_sheet_from_doc
-from libreoffice.calc.conditional_format import
get_conditional_format_from_sheet
+
from libreoffice.uno.propertyvalue import mkPropertyValues
-#Bug 105544 - Manage Conditional Formatting is not able to edit a condition
+
+# Bug 105544 - Manage Conditional Formatting is not able to edit a condition
class tdf105544(UITestCase):
def test_tdf105544_Manage_Conditional_Formatting_edit_condition(self):
diff --git a/sc/qa/uitest/conditional_format/tdf81696.py
b/sc/qa/uitest/conditional_format/tdf81696.py
index 0fca31e2bd98..7dfe2e99cdb2 100644
--- a/sc/qa/uitest/conditional_format/tdf81696.py
+++ b/sc/qa/uitest/conditional_format/tdf81696.py
@@ -7,16 +7,13 @@
# file, You can obtain one at http://mozilla.org/MPL/2.0/.
#
from uitest.framework import UITestCase
-from uitest.uihelper.common import get_state_as_dict, get_url_for_data_file
-from uitest.uihelper.common import select_pos
-from uitest.uihelper.calc import enter_text_to_cell
-from libreoffice.calc.document import get_sheet_from_doc
-from libreoffice.calc.conditional_format import
get_conditional_format_from_sheet
+from uitest.uihelper.common import get_state_as_dict, get_url_for_data_file,
select_pos
+
from libreoffice.calc.document import get_cell_by_position
from libreoffice.uno.propertyvalue import mkPropertyValues
-#Bug 81696 - CRASH while sorting cells with conditional formatting
+# Bug 81696 - CRASH while sorting cells with conditional formatting
class tdf81696(UITestCase):
def test_tdf81696_sort_cell_conditional_formatting(self):
diff --git a/sc/qa/uitest/function_wizard/tdf123479.py
b/sc/qa/uitest/function_wizard/tdf123479.py
index 66a3faf82fe5..aee7b97aa567 100644
--- a/sc/qa/uitest/function_wizard/tdf123479.py
+++ b/sc/qa/uitest/function_wizard/tdf123479.py
@@ -8,16 +8,12 @@
#
from uitest.framework import UITestCase
from uitest.uihelper.common import get_state_as_dict, get_url_for_data_file
-from uitest.uihelper.common import select_pos
-from uitest.uihelper.calc import enter_text_to_cell
-from libreoffice.calc.document import get_sheet_from_doc
-from libreoffice.calc.conditional_format import
get_conditional_format_from_sheet
+
from libreoffice.calc.document import get_cell_by_position
from libreoffice.uno.propertyvalue import mkPropertyValues
-#Bug 123479 - Crash in: ScFormulaResult::GetMatrixFormulaCellToken()
-
+# Bug 123479 - Crash in: ScFormulaResult::GetMatrixFormulaCellToken()
class tdf123479(UITestCase):
def test_tdf123479_Crash_ScFormulaResult_GetMatrixFormulaCellToken(self):
#numberingformatpage.ui
diff --git a/sc/qa/uitest/hide_cols/tdf95306.py
b/sc/qa/uitest/hide_cols/tdf95306.py
index 2016a5bed9b3..222e8ee3093d 100644
--- a/sc/qa/uitest/hide_cols/tdf95306.py
+++ b/sc/qa/uitest/hide_cols/tdf95306.py
@@ -7,12 +7,11 @@
# file, You can obtain one at http://mozilla.org/MPL/2.0/.
#
-from libreoffice.uno.propertyvalue import mkPropertyValues
-
from uitest.framework import UITestCase
+
from libreoffice.calc.document import get_column
+from libreoffice.uno.propertyvalue import mkPropertyValues
-import time
def get_column_hidden(doc, index):
column = get_column(doc, index)
diff --git a/sc/qa/uitest/inputLine/tdf54197.py
b/sc/qa/uitest/inputLine/tdf54197.py
index 999e9345fa7b..ba86982d91ca 100644
--- a/sc/qa/uitest/inputLine/tdf54197.py
+++ b/sc/qa/uitest/inputLine/tdf54197.py
@@ -7,15 +7,14 @@
# file, You can obtain one at http://mozilla.org/MPL/2.0/.
#
from uitest.framework import UITestCase
-from uitest.uihelper.common import get_state_as_dict
-from uitest.uihelper.common import select_pos
from uitest.uihelper.calc import enter_text_to_cell
-from libreoffice.calc.document import get_sheet_from_doc
-from libreoffice.calc.conditional_format import
get_conditional_format_from_sheet
+from uitest.uihelper.common import get_state_as_dict
+
from libreoffice.calc.document import get_cell_by_position
from libreoffice.uno.propertyvalue import mkPropertyValues
-#Bug 54197 - Calc single cell filling (Ctrl+D) does not change data at input
line
+
+# Bug 54197 - Calc single cell filling (Ctrl+D) does not change data at input
line
class tdf54197(UITestCase):
def test_tdf54197_CTRL_D_input_line_change(self):
diff --git a/sc/qa/uitest/key_f4/f4.py b/sc/qa/uitest/key_f4/f4.py
index 22565b4cb5c6..79d1cc26863d 100644
--- a/sc/qa/uitest/key_f4/f4.py
+++ b/sc/qa/uitest/key_f4/f4.py
@@ -7,12 +7,12 @@
# file, You can obtain one at http://mozilla.org/MPL/2.0/.
#
from uitest.framework import UITestCase
-import os
-from uitest.uihelper.common import get_state_as_dict
+from uitest.uihelper.calc import enter_text_to_cell
from uitest.uihelper.common import select_by_text
+
from libreoffice.uno.propertyvalue import mkPropertyValues
from libreoffice.calc.document import get_cell_by_position
-from uitest.uihelper.calc import enter_text_to_cell
+
class keyF4(UITestCase):
def test_f4(self):
diff --git a/sc/qa/uitest/pasteSpecial/tdf74577.py
b/sc/qa/uitest/pasteSpecial/tdf74577.py
index 347af8dbc5d0..324e49bef7d1 100644
--- a/sc/qa/uitest/pasteSpecial/tdf74577.py
+++ b/sc/qa/uitest/pasteSpecial/tdf74577.py
@@ -8,9 +8,10 @@
#
from uitest.framework import UITestCase
from uitest.uihelper.common import get_state_as_dict, get_url_for_data_file
-from libreoffice.uno.propertyvalue import mkPropertyValues
+
from libreoffice.calc.document import get_cell_by_position
+
class tdf74577(UITestCase):
def test_tdf74577(self):
diff --git a/sc/qa/uitest/protect/protectSheet.py
b/sc/qa/uitest/protect/protectSheet.py
index 389e83dc680f..4b65e3b9e0ee 100644
--- a/sc/qa/uitest/protect/protectSheet.py
+++ b/sc/qa/uitest/protect/protectSheet.py
@@ -7,14 +7,13 @@
# file, You can obtain one at http://mozilla.org/MPL/2.0/.
#
from uitest.framework import UITestCase
-from uitest.uihelper.common import get_state_as_dict
-from uitest.uihelper.common import select_pos
from uitest.uihelper.calc import enter_text_to_cell
-from libreoffice.calc.document import get_sheet_from_doc
-from libreoffice.calc.conditional_format import
get_conditional_format_from_sheet
+from uitest.uihelper.common import get_state_as_dict
+
from libreoffice.calc.document import get_cell_by_position
from libreoffice.uno.propertyvalue import mkPropertyValues
+
class protectSheet(UITestCase):
def test_protect_sheet(self):
with self.ui_test.create_doc_in_start_center("calc") as document:
diff --git a/sc/qa/uitest/protect/protectSpreadsheet.py
b/sc/qa/uitest/protect/protectSpreadsheet.py
index cd69a9e1ec3e..e15c5b7182ea 100644
--- a/sc/qa/uitest/protect/protectSpreadsheet.py
+++ b/sc/qa/uitest/protect/protectSpreadsheet.py
@@ -7,14 +7,10 @@
# file, You can obtain one at http://mozilla.org/MPL/2.0/.
#
from uitest.framework import UITestCase
-from uitest.uihelper.common import get_state_as_dict
-from uitest.uihelper.common import select_pos
-from uitest.uihelper.calc import enter_text_to_cell
-from libreoffice.calc.document import get_sheet_from_doc
-from libreoffice.calc.conditional_format import
get_conditional_format_from_sheet
-from libreoffice.calc.document import get_cell_by_position
+
from libreoffice.uno.propertyvalue import mkPropertyValues
+
class protectSpreadsheet(UITestCase):
def test_protect_spreadsheet(self):
with self.ui_test.create_doc_in_start_center("calc"):
@@ -35,5 +31,4 @@ class protectSpreadsheet(UITestCase):
xpass1ed.executeAction("TYPE", mkPropertyValues({"TEXT":"aa"}))
-
# vim: set shiftwidth=4 softtabstop=4 expandtab:
diff --git a/sc/qa/uitest/sort/naturalSort.py b/sc/qa/uitest/sort/naturalSort.py
index 6d9dd3edd7ca..91c2f35c3f71 100644
--- a/sc/qa/uitest/sort/naturalSort.py
+++ b/sc/qa/uitest/sort/naturalSort.py
@@ -7,15 +7,14 @@
# file, You can obtain one at http://mozilla.org/MPL/2.0/.
#
from uitest.framework import UITestCase
-from uitest.uihelper.common import get_state_as_dict
-from uitest.uihelper.common import select_pos
from uitest.uihelper.calc import enter_text_to_cell
-from libreoffice.calc.document import get_sheet_from_doc
-from libreoffice.calc.conditional_format import
get_conditional_format_from_sheet
+from uitest.uihelper.common import get_state_as_dict, select_pos
+
from libreoffice.calc.document import get_cell_by_position
from libreoffice.uno.propertyvalue import mkPropertyValues
-#Testcases Sorting TCS_Sorting
+
+# Testcases Sorting TCS_Sorting
class CalcNaturalSorting(UITestCase):
def test_natural_sorting_rows(self):
diff --git a/sc/qa/uitest/sort/sorting.py b/sc/qa/uitest/sort/sorting.py
index a3c901574109..0d6bb9ca0912 100644
--- a/sc/qa/uitest/sort/sorting.py
+++ b/sc/qa/uitest/sort/sorting.py
@@ -7,15 +7,14 @@
# file, You can obtain one at http://mozilla.org/MPL/2.0/.
#
from uitest.framework import UITestCase
-from uitest.uihelper.common import get_state_as_dict
-from uitest.uihelper.common import select_pos
from uitest.uihelper.calc import enter_text_to_cell
-from libreoffice.calc.document import get_sheet_from_doc
-from libreoffice.calc.conditional_format import
get_conditional_format_from_sheet
+from uitest.uihelper.common import get_state_as_dict, select_pos
+
from libreoffice.calc.document import get_cell_by_position
from libreoffice.uno.propertyvalue import mkPropertyValues
-#Testcases Sorting TCS_Sorting
+
+# Testcases Sorting TCS_Sorting
class CalcSorting(UITestCase):
def test_Sortingbuttons_detect_columnheaders(self):
diff --git a/sc/qa/uitest/sort/stableSorting.py
b/sc/qa/uitest/sort/stableSorting.py
index 68dfbfe4aedb..ec19956935f3 100644
--- a/sc/qa/uitest/sort/stableSorting.py
+++ b/sc/qa/uitest/sort/stableSorting.py
@@ -9,15 +9,12 @@
from uitest.framework import UITestCase
from uitest.uihelper.common import get_state_as_dict, get_url_for_data_file
-from uitest.uihelper.common import select_pos
-from uitest.uihelper.calc import enter_text_to_cell
-from libreoffice.calc.document import get_sheet_from_doc
-from libreoffice.calc.conditional_format import
get_conditional_format_from_sheet
+
from libreoffice.calc.document import get_cell_by_position
from libreoffice.uno.propertyvalue import mkPropertyValues
-#Testcases Sorting TCS_Sorting Stable sorting
+# Testcases Sorting TCS_Sorting Stable sorting
class CalcStableSorting(UITestCase):
def
test_Must_keep_sort_order_previous_sorting_toolbar_button_Ascending(self):
diff --git a/sc/qa/uitest/sort/tdf91305.py b/sc/qa/uitest/sort/tdf91305.py
index ebc452daf56f..bc0b8738fc68 100644
--- a/sc/qa/uitest/sort/tdf91305.py
+++ b/sc/qa/uitest/sort/tdf91305.py
@@ -7,15 +7,15 @@
# 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 uitest.uihelper.common import get_state_as_dict
from uitest.uihelper.common import select_pos
-from uitest.uihelper.calc import enter_text_to_cell
-from libreoffice.calc.document import get_sheet_from_doc
-from libreoffice.calc.conditional_format import
get_conditional_format_from_sheet
+
from libreoffice.calc.document import get_cell_by_position
from libreoffice.uno.propertyvalue import mkPropertyValues
-#Bug 91305 - Sort button does not sort first cell if it has text format
+
+# Bug 91305 - Sort button does not sort first cell if it has text format
class tdf91305(UITestCase):
def test_tdf91305_sort_text_cells_columns(self):
diff --git a/sc/qa/uitest/sort/tdf99773.py b/sc/qa/uitest/sort/tdf99773.py
index cd892c5e9b2c..49775899fb02 100644
--- a/sc/qa/uitest/sort/tdf99773.py
+++ b/sc/qa/uitest/sort/tdf99773.py
@@ -7,15 +7,14 @@
# file, You can obtain one at http://mozilla.org/MPL/2.0/.
#
from uitest.framework import UITestCase
-from uitest.uihelper.common import get_state_as_dict
-from uitest.uihelper.common import select_pos
from uitest.uihelper.calc import enter_text_to_cell
-from libreoffice.calc.document import get_sheet_from_doc
-from libreoffice.calc.conditional_format import
get_conditional_format_from_sheet
+from uitest.uihelper.common import get_state_as_dict, select_pos
+
from libreoffice.calc.document import get_cell_by_position
from libreoffice.uno.propertyvalue import mkPropertyValues
-#Bug 99773 - EDITING: calc freezes if sorting in natural mode
+
+# Bug 99773 - EDITING: calc freezes if sorting in natural mode
class tdf99773(UITestCase):
def test_tdf99773_natural_sorting_space(self):
with self.ui_test.create_doc_in_start_center("calc") as document:
diff --git a/sc/qa/uitest/statistics/anova.py b/sc/qa/uitest/statistics/anova.py
index b788d5d75c26..316849150511 100644
--- a/sc/qa/uitest/statistics/anova.py
+++ b/sc/qa/uitest/statistics/anova.py
@@ -7,14 +7,12 @@
# file, You can obtain one at http://mozilla.org/MPL/2.0/.
#
from uitest.framework import UITestCase
-from uitest.uihelper.common import get_state_as_dict
-from uitest.uihelper.common import select_pos
from uitest.uihelper.calc import enter_text_to_cell
-from libreoffice.calc.document import get_sheet_from_doc
-from libreoffice.calc.conditional_format import
get_conditional_format_from_sheet
+
from libreoffice.calc.document import get_cell_by_position
from libreoffice.uno.propertyvalue import mkPropertyValues
+
class anova(UITestCase):
def test_statistic_anova(self):
with self.ui_test.create_doc_in_start_center("calc") as document:
diff --git a/sc/qa/uitest/statistics/chiSquare.py
b/sc/qa/uitest/statistics/chiSquare.py
index 056471a27474..54194e587e88 100644
--- a/sc/qa/uitest/statistics/chiSquare.py
+++ b/sc/qa/uitest/statistics/chiSquare.py
@@ -7,14 +7,12 @@
# file, You can obtain one at http://mozilla.org/MPL/2.0/.
#
from uitest.framework import UITestCase
-from uitest.uihelper.common import get_state_as_dict
-from uitest.uihelper.common import select_pos
from uitest.uihelper.calc import enter_text_to_cell
-from libreoffice.calc.document import get_sheet_from_doc
-from libreoffice.calc.conditional_format import
get_conditional_format_from_sheet
+
from libreoffice.calc.document import get_cell_by_position
from libreoffice.uno.propertyvalue import mkPropertyValues
+
class chiSquare(UITestCase):
def test_chiSquare(self):
with self.ui_test.create_doc_in_start_center("calc") as document:
diff --git a/sc/qa/uitest/statistics/correlation.py
b/sc/qa/uitest/statistics/correlation.py
index 2a2fee50759b..1bcd667ddc43 100644
--- a/sc/qa/uitest/statistics/correlation.py
+++ b/sc/qa/uitest/statistics/correlation.py
@@ -7,14 +7,12 @@
# file, You can obtain one at http://mozilla.org/MPL/2.0/.
#
from uitest.framework import UITestCase
-from uitest.uihelper.common import get_state_as_dict
-from uitest.uihelper.common import select_pos
from uitest.uihelper.calc import enter_text_to_cell
-from libreoffice.calc.document import get_sheet_from_doc
-from libreoffice.calc.conditional_format import
get_conditional_format_from_sheet
+
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:
diff --git a/sc/qa/uitest/statistics/covariance.py
b/sc/qa/uitest/statistics/covariance.py
index 40e5740e9a43..2978d48547db 100644
--- a/sc/qa/uitest/statistics/covariance.py
+++ b/sc/qa/uitest/statistics/covariance.py
@@ -7,14 +7,12 @@
# file, You can obtain one at http://mozilla.org/MPL/2.0/.
#
from uitest.framework import UITestCase
-from uitest.uihelper.common import get_state_as_dict
-from uitest.uihelper.common import select_pos
from uitest.uihelper.calc import enter_text_to_cell
-from libreoffice.calc.document import get_sheet_from_doc
-from libreoffice.calc.conditional_format import
get_conditional_format_from_sheet
+
from libreoffice.calc.document import get_cell_by_position
from libreoffice.uno.propertyvalue import mkPropertyValues
+
class covariance(UITestCase):
def test_statistic_covariance_column(self):
with self.ui_test.create_doc_in_start_center("calc") as document:
diff --git a/sc/qa/uitest/statistics/descriptiveStatistics.py
b/sc/qa/uitest/statistics/descriptiveStatistics.py
index 8c24371cfa49..8241089fc710 100644
--- a/sc/qa/uitest/statistics/descriptiveStatistics.py
+++ b/sc/qa/uitest/statistics/descriptiveStatistics.py
@@ -7,14 +7,12 @@
# file, You can obtain one at http://mozilla.org/MPL/2.0/.
#
from uitest.framework import UITestCase
-from uitest.uihelper.common import get_state_as_dict
-from uitest.uihelper.common import select_pos
from uitest.uihelper.calc import enter_text_to_cell
-from libreoffice.calc.document import get_sheet_from_doc
-from libreoffice.calc.conditional_format import
get_conditional_format_from_sheet
+
from libreoffice.calc.document import get_cell_by_position
from libreoffice.uno.propertyvalue import mkPropertyValues
+
class descriptiveStatistics(UITestCase):
def test_descriptive_statistics(self):
with self.ui_test.create_doc_in_start_center("calc") as document:
diff --git a/sc/qa/uitest/statistics/exponentialSmoothing.py
b/sc/qa/uitest/statistics/exponentialSmoothing.py
index 8e18d8845095..377d65d521a6 100644
--- a/sc/qa/uitest/statistics/exponentialSmoothing.py
+++ b/sc/qa/uitest/statistics/exponentialSmoothing.py
@@ -7,14 +7,12 @@
# file, You can obtain one at http://mozilla.org/MPL/2.0/.
#
from uitest.framework import UITestCase
-from uitest.uihelper.common import get_state_as_dict
-from uitest.uihelper.common import select_pos
from uitest.uihelper.calc import enter_text_to_cell
-from libreoffice.calc.document import get_sheet_from_doc
-from libreoffice.calc.conditional_format import
get_conditional_format_from_sheet
+
from libreoffice.calc.document import get_cell_by_position
from libreoffice.uno.propertyvalue import mkPropertyValues
+
class exponentialSmoothing(UITestCase):
def test_exponential_smoothing_column(self):
with self.ui_test.create_doc_in_start_center("calc") as document:
diff --git a/sc/qa/uitest/statistics/movingAverage.py
b/sc/qa/uitest/statistics/movingAverage.py
index 52a6eecf4296..4411d8dfcc1f 100644
--- a/sc/qa/uitest/statistics/movingAverage.py
+++ b/sc/qa/uitest/statistics/movingAverage.py
@@ -7,14 +7,12 @@
# file, You can obtain one at http://mozilla.org/MPL/2.0/.
#
from uitest.framework import UITestCase
-from uitest.uihelper.common import get_state_as_dict
-from uitest.uihelper.common import select_pos
from uitest.uihelper.calc import enter_text_to_cell
-from libreoffice.calc.document import get_sheet_from_doc
-from libreoffice.calc.conditional_format import
get_conditional_format_from_sheet
+
from libreoffice.calc.document import get_cell_by_position
from libreoffice.uno.propertyvalue import mkPropertyValues
+
class movingAverage(UITestCase):
def test_moving_average_column(self):
with self.ui_test.create_doc_in_start_center("calc") as document:
diff --git a/sc/qa/uitest/statistics/sampling.py
b/sc/qa/uitest/statistics/sampling.py
index 55a88e53540f..a7a373dccfc1 100644
--- a/sc/qa/uitest/statistics/sampling.py
+++ b/sc/qa/uitest/statistics/sampling.py
@@ -7,14 +7,13 @@
# file, You can obtain one at http://mozilla.org/MPL/2.0/.
#
from uitest.framework import UITestCase
-from uitest.uihelper.common import get_state_as_dict
-from uitest.uihelper.common import select_pos
from uitest.uihelper.calc import enter_text_to_cell
-from libreoffice.calc.document import get_sheet_from_doc
-from libreoffice.calc.conditional_format import
get_conditional_format_from_sheet
+from uitest.uihelper.common import get_state_as_dict
+
from libreoffice.calc.document import get_cell_by_position
from libreoffice.uno.propertyvalue import mkPropertyValues
+
class sampling(UITestCase):
def test_statistic_sampling(self):
with self.ui_test.create_doc_in_start_center("calc") as document:
diff --git a/sc/qa/uitest/statistics/tTest.py b/sc/qa/uitest/statistics/tTest.py
index 9a99f55688b3..cd026ab44ed1 100644
--- a/sc/qa/uitest/statistics/tTest.py
+++ b/sc/qa/uitest/statistics/tTest.py
@@ -7,14 +7,12 @@
# file, You can obtain one at http://mozilla.org/MPL/2.0/.
#
from uitest.framework import UITestCase
-from uitest.uihelper.common import get_state_as_dict
-from uitest.uihelper.common import select_pos
from uitest.uihelper.calc import enter_text_to_cell
-from libreoffice.calc.document import get_sheet_from_doc
-from libreoffice.calc.conditional_format import
get_conditional_format_from_sheet
+
from libreoffice.calc.document import get_cell_by_position
from libreoffice.uno.propertyvalue import mkPropertyValues
+
class tTest(UITestCase):
def test_tTest_column(self):
with self.ui_test.create_doc_in_start_center("calc") as document:
diff --git a/sc/qa/uitest/statistics/tdf76731.py
b/sc/qa/uitest/statistics/tdf76731.py
index f19ebf17ce6c..df6cb3036311 100644
--- a/sc/qa/uitest/statistics/tdf76731.py
+++ b/sc/qa/uitest/statistics/tdf76731.py
@@ -8,15 +8,12 @@
#
from uitest.framework import UITestCase
from uitest.uihelper.common import get_state_as_dict, get_url_for_data_file
-from uitest.uihelper.common import select_pos
-from uitest.uihelper.calc import enter_text_to_cell
-from libreoffice.calc.document import get_sheet_from_doc
-from libreoffice.calc.conditional_format import
get_conditional_format_from_sheet
+
from libreoffice.calc.document import get_cell_by_position
from libreoffice.uno.propertyvalue import mkPropertyValues
-#Bug 76731 - ANOVA: F critical is not shown
+# Bug 76731 - ANOVA: F critical is not shown
class anova(UITestCase):
def test_tdf76731_anova(self):
with self.ui_test.load_file(get_url_for_data_file("tdf76731.ods")) as
calc_doc:
diff --git a/sc/qa/uitest/statistics/zTest.py b/sc/qa/uitest/statistics/zTest.py
index ae24e83926a4..aca0d9ae636f 100644
--- a/sc/qa/uitest/statistics/zTest.py
+++ b/sc/qa/uitest/statistics/zTest.py
@@ -7,14 +7,12 @@
# file, You can obtain one at http://mozilla.org/MPL/2.0/.
#
from uitest.framework import UITestCase
-from uitest.uihelper.common import get_state_as_dict
-from uitest.uihelper.common import select_pos
from uitest.uihelper.calc import enter_text_to_cell
-from libreoffice.calc.document import get_sheet_from_doc
-from libreoffice.calc.conditional_format import
get_conditional_format_from_sheet
+
from libreoffice.calc.document import get_cell_by_position
from libreoffice.uno.propertyvalue import mkPropertyValues
+
class zTest(UITestCase):
def test_zTest_column(self):
with self.ui_test.create_doc_in_start_center("calc") as document:
