tdf#132293: Removing unused imports from uitests files.

It seems, the most imports were copy-pasted from a file to a new one.
Additionally, the import block and surrounding area made more readable.

Change-Id: Ie1f31c489cb1e744b5d01d35e3908f1071313e90
Reviewed-on: https://gerrit.libreoffice.org/c/core/+/134413
Tested-by: Jenkins
Reviewed-by: Xisco Fauli <xiscofauli@libreoffice.org>

63 files changed, 204 insertions, 243 deletions

diff --git a/sc/qa/uitest/calc_tests3/tdf139974.py b/sc/qa/uitest/calc_tests3/tdf139974.py
index 1e7009b36fce..c30a05f90c19 100644
--- a/sc/qa/uitest/calc_tests3/tdf139974.py
+++ b/sc/qa/uitest/calc_tests3/tdf139974.py
@@ -9,7 +9,8 @@
 from uitest.framework import UITestCase
 from libreoffice.calc.document import get_cell_by_position
 from libreoffice.uno.propertyvalue import mkPropertyValues
-from uitest.uihelper.common import get_url_for_data_file, get_state_as_dict
+from uitest.uihelper.common import get_url_for_data_file
+
 
 class tdf139974(UITestCase):
 
diff --git a/sc/qa/uitest/calc_tests4/exportToPDF.py b/sc/qa/uitest/calc_tests4/exportToPDF.py
index 565a5337e9ee..a67b572e61d2 100644
--- a/sc/qa/uitest/calc_tests4/exportToPDF.py
+++ b/sc/qa/uitest/calc_tests4/exportToPDF.py
@@ -7,13 +7,15 @@
 # file, You can obtain one at http://mozilla.org/MPL/2.0/.
 #
 
+import os.path
+from tempfile import TemporaryDirectory
+
 from uitest.framework import UITestCase
 from uitest.uihelper.calc import enter_text_to_cell
-from uitest.uihelper.common import get_state_as_dict, get_url_for_data_file
+from uitest.uihelper.common import get_state_as_dict
 from libreoffice.uno.propertyvalue import mkPropertyValues
 from org.libreoffice.unotest import systemPathToFileUrl
-from tempfile import TemporaryDirectory
-import os.path
+
 
 class exportToPDF(UITestCase):
 
diff --git a/sc/qa/uitest/calc_tests4/saveToCSV.py b/sc/qa/uitest/calc_tests4/saveToCSV.py
index 503c7ed2386a..d3876f8174a6 100644
--- a/sc/qa/uitest/calc_tests4/saveToCSV.py
+++ b/sc/qa/uitest/calc_tests4/saveToCSV.py
@@ -7,14 +7,15 @@
 # file, You can obtain one at http://mozilla.org/MPL/2.0/.
 #
 
+import os.path
+from tempfile import TemporaryDirectory
+
 from uitest.framework import UITestCase
 from uitest.uihelper.calc import enter_text_to_cell
-from uitest.uihelper.common import get_state_as_dict, get_url_for_data_file
+from uitest.uihelper.common import get_state_as_dict
 from uitest.uihelper.common import select_by_text
 from libreoffice.uno.propertyvalue import mkPropertyValues
-from org.libreoffice.unotest import systemPathToFileUrl
-from tempfile import TemporaryDirectory
-import os.path
+
 
 class saveToCSV(UITestCase):
 
diff --git a/sc/qa/uitest/calc_tests8/tdf125051.py b/sc/qa/uitest/calc_tests8/tdf125051.py
index 8c314151ecf7..b1ece2a319c6 100644
--- a/sc/qa/uitest/calc_tests8/tdf125051.py
+++ b/sc/qa/uitest/calc_tests8/tdf125051.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_cell_by_position
 from libreoffice.uno.propertyvalue import mkPropertyValues
 
-#Bug 125051 - EDITING: CRASH when start SpellCheck
 
+# Bug 125051 - EDITING: CRASH when start SpellCheck
 class tdf125051(UITestCase):
     def test_tdf125051_crash_spelling_dialog(self):
         with self.ui_test.create_doc_in_start_center("calc") as document:
diff --git a/sc/qa/uitest/calc_tests9/tdf126673.py b/sc/qa/uitest/calc_tests9/tdf126673.py
index 04733a91f755..e8faa073d454 100644
--- a/sc/qa/uitest/calc_tests9/tdf126673.py
+++ b/sc/qa/uitest/calc_tests9/tdf126673.py
@@ -7,15 +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.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 get_state_as_dict, get_url_for_data_file
+
 from libreoffice.uno.propertyvalue import mkPropertyValues
 
-#Bug 126673 - Calc: Auto-fit column and auto-fit row don't work with line break
 
+# Bug 126673 - Calc: Auto-fit column and auto-fit row don't work with line break
 class tdf126673(UITestCase):
     def test_tdf126673_auto_fit_row_height(self):
         with self.ui_test.load_file(get_url_for_data_file("tdf126673.ods")) as calc_doc:
diff --git a/sc/qa/uitest/calc_tests9/tdf141244.py b/sc/qa/uitest/calc_tests9/tdf141244.py
index f71f76e8bbbf..b292bfefedb6 100644
--- a/sc/qa/uitest/calc_tests9/tdf141244.py
+++ b/sc/qa/uitest/calc_tests9/tdf141244.py
@@ -7,9 +7,9 @@
 # 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 libreoffice.uno.propertyvalue import mkPropertyValues
 from uitest.uihelper.calc import enter_text_to_cell
+from uitest.uihelper.common import get_state_as_dict
+
 
 class tdf141244(UITestCase):
 
diff --git a/sc/qa/uitest/calc_tests9/tdf144996.py b/sc/qa/uitest/calc_tests9/tdf144996.py
index 970f9a0bcba3..eabd61ddb117 100644
--- a/sc/qa/uitest/calc_tests9/tdf144996.py
+++ b/sc/qa/uitest/calc_tests9/tdf144996.py
@@ -8,8 +8,9 @@
 #
 from uitest.framework import UITestCase
 from uitest.uihelper.common import get_url_for_data_file
+
 from libreoffice.uno.propertyvalue import mkPropertyValues
-from org.libreoffice.unotest import systemPathToFileUrl
+
 
 class tdf144996(UITestCase):
 
diff --git a/sc/qa/uitest/chart/chartArea.py b/sc/qa/uitest/chart/chartArea.py
index 5c32bbf71e9f..44040f8e835f 100644
--- a/sc/qa/uitest/chart/chartArea.py
+++ b/sc/qa/uitest/chart/chartArea.py
@@ -7,15 +7,13 @@
 # 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 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, select_pos
+from uitest.uihelper.common import get_state_as_dict, get_url_for_data_file
+
 from libreoffice.uno.propertyvalue import mkPropertyValues
-from uitest.uihelper.common import get_state_as_dict, type_text, get_url_for_data_file
 
-#Chart Area dialog
 
+# Chart Area dialog
 class chartArea(UITestCase):
    def test_chart_area_dialog(self):
     with self.ui_test.load_file(get_url_for_data_file("chartArea.ods")) as calc_doc:
diff --git a/sc/qa/uitest/chart/chartAxes.py b/sc/qa/uitest/chart/chartAxes.py
index bdf4353fec2d..07cf1a349c20 100644
--- a/sc/qa/uitest/chart/chartAxes.py
+++ b/sc/qa/uitest/chart/chartAxes.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 uitest.uihelper.common import get_state_as_dict, get_url_for_data_file
+
 from libreoffice.uno.propertyvalue import mkPropertyValues
-from uitest.uihelper.common import get_state_as_dict, type_text, get_url_for_data_file
 
-#Chart Enable Axes dialog
 
+# Chart Enable Axes dialog
 class chartAxes(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/chartDataLabels.py b/sc/qa/uitest/chart/chartDataLabels.py
index 78b6d681c081..5eaad0a766ed 100644
--- a/sc/qa/uitest/chart/chartDataLabels.py
+++ b/sc/qa/uitest/chart/chartDataLabels.py
@@ -7,18 +7,16 @@
 # 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 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
 
 from com.sun.star.lang import Locale
 
-#Chart Display Data Labels dialog
 
+# Chart Display Data Labels dialog
 class chartDataLabels(UITestCase):
    def test_chart_data_labels_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/chartGrid.py b/sc/qa/uitest/chart/chartGrid.py
index 58abceea28bf..0fc680a8b708 100644
--- a/sc/qa/uitest/chart/chartGrid.py
+++ b/sc/qa/uitest/chart/chartGrid.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 select_pos
-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, select_pos
+from uitest.uihelper.common import get_state_as_dict, get_url_for_data_file
 from libreoffice.uno.propertyvalue import mkPropertyValues
-from uitest.uihelper.common import get_state_as_dict, get_url_for_data_file, type_text
 
-#Chart Grid dialog
-#Bug 98390 - Crash when modifying minor grid
 
+# Chart Grid dialog
+# Bug 98390 - Crash when modifying minor grid
 class chartGrid(UITestCase):
    def test_tdf98390_chart_grid_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/chartLegend.py b/sc/qa/uitest/chart/chartLegend.py
index 4372e47948b5..07c257b1bc36 100644
--- a/sc/qa/uitest/chart/chartLegend.py
+++ b/sc/qa/uitest/chart/chartLegend.py
@@ -7,15 +7,13 @@
 # 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 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 get_state_as_dict, get_url_for_data_file
+
 from libreoffice.uno.propertyvalue import mkPropertyValues
-from uitest.uihelper.common import get_state_as_dict, get_url_for_data_file, type_text
 
-#Chart Display Legend dialog
 
+# Chart Display Legend dialog
 class chartLegend(UITestCase):
    def test_chart_display_legend_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/chartWall.py b/sc/qa/uitest/chart/chartWall.py
index c3adccfd0377..4ca6d240d465 100644
--- a/sc/qa/uitest/chart/chartWall.py
+++ b/sc/qa/uitest/chart/chartWall.py
@@ -7,15 +7,13 @@
 # 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 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, select_pos
+from uitest.uihelper.common import get_state_as_dict, get_url_for_data_file
+
 from libreoffice.uno.propertyvalue import mkPropertyValues
-from uitest.uihelper.common import get_state_as_dict, get_url_for_data_file, type_text
 
-#Chart Wall dialog
 
+# Chart Wall dialog
 class chartWall(UITestCase):
    def test_chart_wall_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/formatDataSeries.py b/sc/qa/uitest/chart/formatDataSeries.py
index af050104efa4..b6ba762b2370 100644
--- a/sc/qa/uitest/chart/formatDataSeries.py
+++ b/sc/qa/uitest/chart/formatDataSeries.py
@@ -7,15 +7,13 @@
 # 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 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, select_pos
+from uitest.uihelper.common import get_state_as_dict, get_url_for_data_file
+
 from libreoffice.uno.propertyvalue import mkPropertyValues
-from uitest.uihelper.common import get_state_as_dict, type_text, get_url_for_data_file
 
-# test Chart - Data series dialog  /core/chart2/uiconfig/ui/tp_SeriesToAxis.ui
 
+# test Chart - Data series dialog  /core/chart2/uiconfig/ui/tp_SeriesToAxis.ui
 class chartFormatDataSeries(UITestCase):
    def test_chart_format_data_series_dialog(self):
     with self.ui_test.load_file(get_url_for_data_file("tdf93506.ods")) as calc_doc:
diff --git a/sc/qa/uitest/chart/tdf122011.py b/sc/qa/uitest/chart/tdf122011.py
index af1e09940812..478c44a3a8fb 100644
--- a/sc/qa/uitest/chart/tdf122011.py
+++ b/sc/qa/uitest/chart/tdf122011.py
@@ -7,9 +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, get_url_for_data_file
-from libreoffice.uno.propertyvalue import mkPropertyValues
 from uitest.uihelper.calc import enter_text_to_cell
+from uitest.uihelper.common import get_url_for_data_file
+from libreoffice.uno.propertyvalue import mkPropertyValues
+
 
 class tdf122011(UITestCase):
 
diff --git a/sc/qa/uitest/chart/tdf46885.py b/sc/qa/uitest/chart/tdf46885.py
index 554a8be49a9d..6c3c0d3dc013 100644
--- a/sc/qa/uitest/chart/tdf46885.py
+++ b/sc/qa/uitest/chart/tdf46885.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, 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_cell_by_position
 from libreoffice.uno.propertyvalue import mkPropertyValues
 
-#Bug 46885 - LibO crash when creating chart with no cells selected
 
+# Bug 46885 - LibO crash when creating chart with no cells selected
 class tdf46885(UITestCase):
     def test_tdf46885_crash_chart_no_cell_selected_nextButton(self):
         with self.ui_test.create_doc_in_start_center("calc") as document:
diff --git a/sc/qa/uitest/chart/tdf62349.py b/sc/qa/uitest/chart/tdf62349.py
index 420d08a241b3..f6cbc0261f9a 100644
--- a/sc/qa/uitest/chart/tdf62349.py
+++ b/sc/qa/uitest/chart/tdf62349.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, get_url_for_data_file
-from uitest.uihelper.common import select_pos
-from uitest.uihelper.calc import enter_text_to_cell
+from uitest.uihelper.common import get_url_for_data_file
+
 from libreoffice.calc.document import get_cell_by_position
 from libreoffice.uno.propertyvalue import mkPropertyValues
 
-#Bug 62349 - Calc crashes when a newly created chart copied to clipboard
 
+# Bug 62349 - Calc crashes when a newly created chart copied to clipboard
 class tdf62349(UITestCase):
     def test_tdf62349_crash_copy_chart_clipboard(self):
         with self.ui_test.load_file(get_url_for_data_file("tdf62349.ods")) as calc_doc:
diff --git a/sc/qa/uitest/chart/tdf99069.py b/sc/qa/uitest/chart/tdf99069.py
index 7dff807856a9..6af8869444b7 100644
--- a/sc/qa/uitest/chart/tdf99069.py
+++ b/sc/qa/uitest/chart/tdf99069.py
@@ -7,14 +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_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_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
 
-#Bug 99069 - assertion "SolarMutex not locked" from <Cancel> Data Ranges dialog
 
+# Bug 99069 - assertion "SolarMutex not locked" from <Cancel> Data Ranges dialog
 class tdf99069(UITestCase):
    def test_tdf99069_chart_cancel_data_ranges_dialog(self):
     with self.ui_test.load_file(get_url_for_data_file("tdf99069.ods")) as calc_doc:
diff --git a/sc/qa/uitest/chart2/tdf101894.py b/sc/qa/uitest/chart2/tdf101894.py
index 086f84d934a9..83b91540c4fc 100644
--- a/sc/qa/uitest/chart2/tdf101894.py
+++ b/sc/qa/uitest/chart2/tdf101894.py
@@ -7,10 +7,10 @@
 # file, You can obtain one at http://mozilla.org/MPL/2.0/.
 #
 from uitest.framework import UITestCase
-from libreoffice.calc.document import get_cell_by_position
+from uitest.uihelper.common import get_state_as_dict, get_url_for_data_file
+
 from libreoffice.uno.propertyvalue import mkPropertyValues
-from uitest.uihelper.common import get_url_for_data_file
-from uitest.uihelper.common import get_state_as_dict
+
 
 class tdf101894(UITestCase):
 
diff --git a/sc/qa/uitest/chart2/tdf120348.py b/sc/qa/uitest/chart2/tdf120348.py
index abe9963e02cf..9f3a6483705d 100644
--- a/sc/qa/uitest/chart2/tdf120348.py
+++ b/sc/qa/uitest/chart2/tdf120348.py
@@ -7,10 +7,11 @@
 # 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_url_for_data_file
+
 from libreoffice.calc.document import get_cell_by_position
 from libreoffice.uno.propertyvalue import mkPropertyValues
-from uitest.uihelper.common import get_url_for_data_file
+
 
 class tdf120348(UITestCase):
 
diff --git a/sc/qa/uitest/chart2/tdf122398.py b/sc/qa/uitest/chart2/tdf122398.py
index d5126cd21636..dc054c190f4e 100644
--- a/sc/qa/uitest/chart2/tdf122398.py
+++ b/sc/qa/uitest/chart2/tdf122398.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, 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_cell_by_position
+
 from libreoffice.uno.propertyvalue import mkPropertyValues
-from uitest.uihelper.common import get_state_as_dict, type_text, get_url_for_data_file
 
-# Bug 122398 - UI: Cannot specify min/max in axis scale or axis position. Limited between 0 and 100
 
+# Bug 122398 - UI: Cannot specify min/max in axis scale or axis position. Limited between 0 and 100
 class tdf122398(UITestCase):
    def test_tdf122398_chart_min_max_x_axis(self):
     with self.ui_test.load_file(get_url_for_data_file("tdf122398.ods")) as calc_doc:
diff --git a/sc/qa/uitest/chart2/tdf123013.py b/sc/qa/uitest/chart2/tdf123013.py
index 38238b004d24..4f8e104ba8de 100644
--- a/sc/qa/uitest/chart2/tdf123013.py
+++ b/sc/qa/uitest/chart2/tdf123013.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, 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_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
 
-#Bug 123013 - Can not change Trendline name in charts
 
+# Bug 123013 - Can not change Trendline name in charts
 class tdf123013(UITestCase):
    def test_tdf96432_chart_trendline_name(self):
     with self.ui_test.load_file(get_url_for_data_file("tdf123013.ods")) as calc_doc:
diff --git a/sc/qa/uitest/chart2/tdf123231.py b/sc/qa/uitest/chart2/tdf123231.py
index 539bc944c406..d850abc2ec7f 100644
--- a/sc/qa/uitest/chart2/tdf123231.py
+++ b/sc/qa/uitest/chart2/tdf123231.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, 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_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
 
-#Bug 123231 - Chart set trendline format regression type Power twice
 
+# Bug 123231 - Chart set trendline format regression type Power twice
 class tdf123231(UITestCase):
    def test_tdf123231_chart_trendline_dialog_power(self):
     with self.ui_test.load_file(get_url_for_data_file("tdf93506.ods")) as calc_doc:
diff --git a/sc/qa/uitest/chart2/tdf123520.py b/sc/qa/uitest/chart2/tdf123520.py
index 1e36b89864b5..b3ac7a3b13e4 100644
--- a/sc/qa/uitest/chart2/tdf123520.py
+++ b/sc/qa/uitest/chart2/tdf123520.py
@@ -7,15 +7,13 @@
 # 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.calc import enter_text_to_cell
-from libreoffice.calc.document import get_cell_by_position
+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 123520 - Y axis - positioning tab, textbox "Cross other axis at" date changed
 
+# Bug 123520 - Y axis - positioning tab, textbox "Cross other axis at" date changed
 class tdf123520(UITestCase):
    def test_tdf123520_chart_y_cross_other_axis(self):
     with self.ui_test.load_file(get_url_for_data_file("tdf123520.ods")) as calc_doc:
diff --git a/sc/qa/uitest/chart2/tdf124111.py b/sc/qa/uitest/chart2/tdf124111.py
index 50d4dcae9402..9ec377898090 100644
--- a/sc/qa/uitest/chart2/tdf124111.py
+++ b/sc/qa/uitest/chart2/tdf124111.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, 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_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
 
-#Bug 124111 - Cannot enter negative number for cross other axis at value
 
+# Bug 124111 - Cannot enter negative number for cross other axis at value
 class tdf124111(UITestCase):
    def test_tdf124111_chart_x_negative_cross(self):
     with self.ui_test.load_file(get_url_for_data_file("tdf124111.ods")) as calc_doc:
diff --git a/sc/qa/uitest/chart2/tdf136011.py b/sc/qa/uitest/chart2/tdf136011.py
index 557d4fdfa9e1..973d24707860 100644
--- a/sc/qa/uitest/chart2/tdf136011.py
+++ b/sc/qa/uitest/chart2/tdf136011.py
@@ -7,11 +7,11 @@
 # 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
 from uitest.uihelper.common import get_url_for_data_file
 
+from libreoffice.uno.propertyvalue import mkPropertyValues
+
+
 class tdf136011(UITestCase):
 
    def test_tdf136011(self):
diff --git a/sc/qa/uitest/conditional_format/tdf117899.py b/sc/qa/uitest/conditional_format/tdf117899.py
index 0498a05b63ef..12a9b7697df5 100644
--- a/sc/qa/uitest/conditional_format/tdf117899.py
+++ b/sc/qa/uitest/conditional_format/tdf117899.py
@@ -6,13 +6,15 @@
 # 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/.
 #
+import os.path
+from tempfile import TemporaryDirectory
+
 from uitest.framework import UITestCase
-from libreoffice.uno.propertyvalue import mkPropertyValues
 from uitest.uihelper.common import get_state_as_dict, get_url_for_data_file
-from libreoffice.calc.document import get_cell_by_position
+from libreoffice.uno.propertyvalue import mkPropertyValues
+
 from org.libreoffice.unotest import systemPathToFileUrl
-from tempfile import TemporaryDirectory
-import os.path
+
 
 class Tdf117899(UITestCase):
 
diff --git a/sc/qa/uitest/conditional_format/tdf118206.py b/sc/qa/uitest/conditional_format/tdf118206.py
index 6674925b10b2..efbebdd60462 100644
--- a/sc/qa/uitest/conditional_format/tdf118206.py
+++ b/sc/qa/uitest/conditional_format/tdf118206.py
@@ -7,13 +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 uitest.uihelper.common import get_url_for_data_file
+
 from libreoffice.calc.document import get_cell_by_position
 from libreoffice.uno.propertyvalue import mkPropertyValues
 
-#Bug 118206 - [GTK3] Calc hangs copying/cutting a conditional format column
+
+# Bug 118206 - [GTK3] Calc hangs copying/cutting a conditional format column
 class tdf118206(UITestCase):
     def test_tdf118206(self):
         with self.ui_test.load_file(get_url_for_data_file("tdf118206.xlsx")) as calc_doc:
diff --git a/sc/qa/uitest/csv_dialog/tdf39716.py b/sc/qa/uitest/csv_dialog/tdf39716.py
index a6c5035e38ff..13e7c30a61b9 100644
--- a/sc/qa/uitest/csv_dialog/tdf39716.py
+++ b/sc/qa/uitest/csv_dialog/tdf39716.py
@@ -7,10 +7,11 @@
 # 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 libreoffice.calc.csv_dialog import load_csv_file
 from libreoffice.calc.document import get_cell_by_position
 
+
 class Tdf39716(UITestCase):
 
     def test_tdf39716(self):
diff --git a/sc/qa/uitest/external_links/tdf114995.py b/sc/qa/uitest/external_links/tdf114995.py
index b19fb63f501a..f0b05ddc7962 100644
--- a/sc/qa/uitest/external_links/tdf114995.py
+++ b/sc/qa/uitest/external_links/tdf114995.py
@@ -8,12 +8,12 @@
 #
 
 from uitest.framework import UITestCase
-from uitest.uihelper.common import get_state_as_dict
-from uitest.uihelper.common import select_pos
+from uitest.uihelper.common import get_state_as_dict, get_url_for_data_file
+
 from libreoffice.uno.propertyvalue import mkPropertyValues
-from uitest.uihelper.common import get_url_for_data_file
 from libreoffice.calc.document import get_cell_by_position
 
+
 class tdf114995(UITestCase):
 
     def test_tdf114995(self):
diff --git a/sc/qa/uitest/external_links/tdf127484.py b/sc/qa/uitest/external_links/tdf127484.py
index 83233621726d..257b631b6a86 100644
--- a/sc/qa/uitest/external_links/tdf127484.py
+++ b/sc/qa/uitest/external_links/tdf127484.py
@@ -8,11 +8,11 @@
 #
 
 from uitest.framework import UITestCase
-from uitest.uihelper.common import get_state_as_dict
-from uitest.uihelper.common import select_pos
-from libreoffice.uno.propertyvalue import mkPropertyValues
-from uitest.uihelper.common import get_url_for_data_file
+from uitest.uihelper.common import get_state_as_dict, get_url_for_data_file
+
 from libreoffice.calc.document import get_cell_by_position
+from libreoffice.uno.propertyvalue import mkPropertyValues
+
 
 class tdf127484(UITestCase):
 
diff --git a/sc/qa/uitest/external_links/tdf147767.py b/sc/qa/uitest/external_links/tdf147767.py
index 4a3b3c78843c..b25816029f5a 100644
--- a/sc/qa/uitest/external_links/tdf147767.py
+++ b/sc/qa/uitest/external_links/tdf147767.py
@@ -8,11 +8,11 @@
 #
 
 from uitest.framework import UITestCase
-from uitest.uihelper.common import get_state_as_dict
-from uitest.uihelper.common import select_pos
-from libreoffice.uno.propertyvalue import mkPropertyValues
-from uitest.uihelper.common import get_url_for_data_file
+from uitest.uihelper.common import get_state_as_dict, get_url_for_data_file
+
 from libreoffice.calc.document import get_cell_by_position
+from libreoffice.uno.propertyvalue import mkPropertyValues
+
 
 class tdf147767(UITestCase):
 
diff --git a/sc/qa/uitest/external_links/tdf95217.py b/sc/qa/uitest/external_links/tdf95217.py
index 4ad36ed170f5..fb0125a995d8 100644
--- a/sc/qa/uitest/external_links/tdf95217.py
+++ b/sc/qa/uitest/external_links/tdf95217.py
@@ -8,11 +8,11 @@
 #
 
 from uitest.framework import UITestCase
-from uitest.uihelper.common import get_state_as_dict
-from uitest.uihelper.common import select_pos
-from libreoffice.uno.propertyvalue import mkPropertyValues
-from uitest.uihelper.common import get_url_for_data_file
+from uitest.uihelper.common import get_state_as_dict, get_url_for_data_file
+
 from libreoffice.calc.document import get_cell_by_position
+from libreoffice.uno.propertyvalue import mkPropertyValues
+
 
 class tdf95217(UITestCase):
 
diff --git a/sc/qa/uitest/external_links/tdf96499.py b/sc/qa/uitest/external_links/tdf96499.py
index b96225c18dc4..e6cac99eece3 100644
--- a/sc/qa/uitest/external_links/tdf96499.py
+++ b/sc/qa/uitest/external_links/tdf96499.py
@@ -8,11 +8,11 @@
 #
 
 from uitest.framework import UITestCase
-from uitest.uihelper.common import get_state_as_dict
-from uitest.uihelper.common import select_pos
-from libreoffice.uno.propertyvalue import mkPropertyValues
-from uitest.uihelper.common import get_url_for_data_file
+from uitest.uihelper.common import get_state_as_dict, get_url_for_data_file
+
 from libreoffice.calc.document import get_cell_by_position
+from libreoffice.uno.propertyvalue import mkPropertyValues
+
 
 class tdf96499(UITestCase):
 
diff --git a/sc/qa/uitest/function_wizard/function_wizard.py b/sc/qa/uitest/function_wizard/function_wizard.py
index 75ccbf137aec..5b5ff6533f54 100644
--- a/sc/qa/uitest/function_wizard/function_wizard.py
+++ b/sc/qa/uitest/function_wizard/function_wizard.py
@@ -7,10 +7,9 @@
 # file, You can obtain one at http://mozilla.org/MPL/2.0/.
 #
 
-from libreoffice.uno.propertyvalue import mkPropertyValues
-
 from uitest.framework import UITestCase
 
+
 class FunctionWizardTest(UITestCase):
     # tdf#98427
     def test_open_function_wizard(self):
diff --git a/sc/qa/uitest/goalSeek/goalSeek.py b/sc/qa/uitest/goalSeek/goalSeek.py
index 23484dc09a4e..48f3524b88c2 100644
--- a/sc/qa/uitest/goalSeek/goalSeek.py
+++ b/sc/qa/uitest/goalSeek/goalSeek.py
@@ -7,12 +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, get_url_for_data_file
-from uitest.uihelper.common import select_pos
-from uitest.uihelper.calc import enter_text_to_cell
+from uitest.uihelper.common import get_url_for_data_file
+
 from libreoffice.calc.document import get_cell_by_position
 from libreoffice.uno.propertyvalue import mkPropertyValues
 
+
 class goalSeek(UITestCase):
     def test_goalSeek(self):
         with self.ui_test.load_file(get_url_for_data_file("goalSeek.ods")) as calc_doc:
diff --git a/sc/qa/uitest/goalSeek/tdf37341.py b/sc/qa/uitest/goalSeek/tdf37341.py
index f7304d4b1d93..14f7aae15511 100644
--- a/sc/qa/uitest/goalSeek/tdf37341.py
+++ b/sc/qa/uitest/goalSeek/tdf37341.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, get_url_for_data_file
-from uitest.uihelper.common import select_pos
-from uitest.uihelper.calc import enter_text_to_cell
+from uitest.uihelper.common import get_url_for_data_file
+
 from libreoffice.calc.document import get_cell_by_position
 from libreoffice.uno.propertyvalue import mkPropertyValues
 
-#Bug 37341 - Goal Seek hangs indefinitely for too many calculation steps (Formula Cell $F$110)
 
+# Bug 37341 - Goal Seek hangs indefinitely for too many calculation steps (Formula Cell $F$110)
 class tdf37341(UITestCase):
     def test_tdf37341_goalSeek(self):
         with self.ui_test.load_file(get_url_for_data_file("tdf37341.ods")) as calc_doc:
diff --git a/sc/qa/uitest/goalSeek/tdf43693.py b/sc/qa/uitest/goalSeek/tdf43693.py
index 787b30fe9cfc..f36fd032f6b2 100644
--- a/sc/qa/uitest/goalSeek/tdf43693.py
+++ b/sc/qa/uitest/goalSeek/tdf43693.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, get_url_for_data_file
-from uitest.uihelper.common import select_pos
-from uitest.uihelper.calc import enter_text_to_cell
+from uitest.uihelper.common import get_url_for_data_file
+
 from libreoffice.calc.document import get_cell_by_position
 from libreoffice.uno.propertyvalue import mkPropertyValues
 
-#Bug 43693 - Goal Seek: reproducible crash using "target value search"
 
+# Bug 43693 - Goal Seek: reproducible crash using "target value search"
 class tdf43693(UITestCase):
     def test_tdf43693_goalSeek(self):
         with self.ui_test.load_file(get_url_for_data_file("tdf43693.ods")) as calc_doc:
diff --git a/sc/qa/uitest/key_f4/tdf102525.py b/sc/qa/uitest/key_f4/tdf102525.py
index e1e28cf1c913..24e8b0866420 100644
--- a/sc/qa/uitest/key_f4/tdf102525.py
+++ b/sc/qa/uitest/key_f4/tdf102525.py
@@ -7,12 +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 get_url_for_data_file
+
 from libreoffice.uno.propertyvalue import mkPropertyValues
 from libreoffice.calc.document import get_cell_by_position
 
-#Bug 102525 - F4 breaks array formula
 
+# Bug 102525 - F4 breaks array formula
 class tdf102525(UITestCase):
     def test_tdf102525_F4_key_array_formula(self):
         with self.ui_test.load_file(get_url_for_data_file("tdf102525.ods")) as calc_doc:
diff --git a/sc/qa/uitest/options/tdf122977.py b/sc/qa/uitest/options/tdf122977.py
index c11a524fd888..0b3327fe1624 100644
--- a/sc/qa/uitest/options/tdf122977.py
+++ b/sc/qa/uitest/options/tdf122977.py
@@ -8,13 +8,9 @@
 #
 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_cell_by_position
-from libreoffice.uno.propertyvalue import mkPropertyValues
 
-#Bug 122977 - CRASH: "Tools"->"Options" "LibreOfficeDev"->"Charts"->"Default Colors"
 
+# Bug 122977 - CRASH: "Tools"->"Options" "LibreOfficeDev"->"Charts"->"Default Colors"
 class chartDefaultColors(UITestCase):
     def test_tdf122977_crash_chart_default_colors_options(self):
         with self.ui_test.create_doc_in_start_center("calc"):
diff --git a/sc/qa/uitest/pageFormat/tdf123508.py b/sc/qa/uitest/pageFormat/tdf123508.py
index 40382a8e93c8..1f823aa63c60 100644
--- a/sc/qa/uitest/pageFormat/tdf123508.py
+++ b/sc/qa/uitest/pageFormat/tdf123508.py
@@ -7,15 +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.common import select_by_text
-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
+from uitest.uihelper.common import select_by_text, select_pos
 
-#Bug 123508 - "Fit print range(s) to width/height" value falls back to default when window closes
+from uitest.uihelper.common import get_state_as_dict, get_url_for_data_file
 
+
+# Bug 123508 - "Fit print range(s) to width/height" value falls back to default when window closes
 class tdf123508(UITestCase):
    def test_tdf123508_format_page_scale(self):
     with self.ui_test.load_file(get_url_for_data_file("tdf123508.ods")) as calc_doc:
diff --git a/sc/qa/uitest/range_name/tdf119954.py b/sc/qa/uitest/range_name/tdf119954.py
index 59bba9e77712..8bea8d6c3c6f 100644
--- a/sc/qa/uitest/range_name/tdf119954.py
+++ b/sc/qa/uitest/range_name/tdf119954.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.common import select_pos
 from uitest.uihelper.calc import enter_text_to_cell
+from uitest.uihelper.common import get_url_for_data_file, type_text
+from uitest.uihelper.keyboard import select_all
+
 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
-from uitest.uihelper.keyboard import select_all
 
-#Bug 119954 - Using a second defined database range in formula expression switches to first range.
 
+# Bug 119954 - Using a second defined database range in formula expression switches to first range.
 class tdf119954(UITestCase):
    def test_tdf119954_second_db_range(self):
         with self.ui_test.load_file(get_url_for_data_file("tdf119954.ods")) as calc_doc:
diff --git a/sc/qa/uitest/range_name/tdf86214.py b/sc/qa/uitest/range_name/tdf86214.py
index 8a14c577cedc..8cbed2f00da6 100644
--- a/sc/qa/uitest/range_name/tdf86214.py
+++ b/sc/qa/uitest/range_name/tdf86214.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 uitest.uihelper.common import type_text, get_state_as_dict
 from uitest.uihelper.keyboard import select_all
 
+
 class InvalidNames(UITestCase):
 
     def test_invalid_names(self):
diff --git a/sc/qa/uitest/search_replace/tdf35020.py b/sc/qa/uitest/search_replace/tdf35020.py
index 9b1713388f3c..b7c40cd7f784 100644
--- a/sc/qa/uitest/search_replace/tdf35020.py
+++ b/sc/qa/uitest/search_replace/tdf35020.py
@@ -7,13 +7,13 @@
 # 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, get_url_for_data_file
+
 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
 
-#Bug 35020 - Find and Replace changes case of sheet name in formulas
 
+# Bug 35020 - Find and Replace changes case of sheet name in formulas
 class tdf35020(UITestCase):
    def test_tdf39959_find_replace_all_sheets(self):
         with self.ui_test.load_file(get_url_for_data_file("tdf35020.ods")) as calc_doc:
diff --git a/sc/qa/uitest/search_replace/tdf39917.py b/sc/qa/uitest/search_replace/tdf39917.py
index c4c33563e4f9..52451a4934c1 100644
--- a/sc/qa/uitest/search_replace/tdf39917.py
+++ b/sc/qa/uitest/search_replace/tdf39917.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 get_state_as_dict
-from uitest.uihelper.common import select_pos
-from uitest.uihelper.common import select_by_text
 from uitest.uihelper.calc import enter_text_to_cell
+from uitest.uihelper.common import select_by_text
+
 from libreoffice.calc.document import get_cell_by_position
 from libreoffice.uno.propertyvalue import mkPropertyValues
-from uitest.uihelper.common import get_state_as_dict, type_text
 
-#Bug 39917 - EDITING Find/Replace modifies formula in R1C1 syntax to invalid lowercase
 
+# Bug 39917 - EDITING Find/Replace modifies formula in R1C1 syntax to invalid lowercase
 class tdf39917(UITestCase):
    def test_tdf39917_find_replace_R1C1(self):
         with self.ui_test.create_doc_in_start_center("calc") as document:
diff --git a/sc/qa/uitest/search_replace/tdf39959.py b/sc/qa/uitest/search_replace/tdf39959.py
index 7108b3e7afbd..f456e1aaaf08 100644
--- a/sc/qa/uitest/search_replace/tdf39959.py
+++ b/sc/qa/uitest/search_replace/tdf39959.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 select_pos
-from uitest.uihelper.calc import enter_text_to_cell
+from uitest.uihelper.common import get_url_for_data_file
+
 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
 
-#Bug 39959 - Find-and-replace doesn't search all tables anymore
 
+# Bug 39959 - Find-and-replace doesn't search all tables anymore
 class tdf39959(UITestCase):
    def test_tdf39959_find_replace_all_sheets(self):
         with self.ui_test.load_file(get_url_for_data_file("tdf39959.ods")) as calc_doc:
diff --git a/sc/qa/uitest/search_replace/tdf44398.py b/sc/qa/uitest/search_replace/tdf44398.py
index 8cc404bc35ce..0fe70817a082 100644
--- a/sc/qa/uitest/search_replace/tdf44398.py
+++ b/sc/qa/uitest/search_replace/tdf44398.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 uitest.uihelper.common import get_state_as_dict
+
 from libreoffice.calc.document import get_cell_by_position
 from libreoffice.uno.propertyvalue import mkPropertyValues
-from uitest.uihelper.common import get_state_as_dict, type_text
 
-#Bug 44398 - : Find, replace, regular expression bug
 
+# Bug 44398 - : Find, replace, regular expression bug
 class tdf44398(UITestCase):
    def test_tdf44398_find_replace_regexp(self):
         with self.ui_test.create_doc_in_start_center("calc") as document:
diff --git a/sc/qa/uitest/search_replace/tdf44861.py b/sc/qa/uitest/search_replace/tdf44861.py
index 9b04a3b9f0fa..f3f121b1036a 100644
--- a/sc/qa/uitest/search_replace/tdf44861.py
+++ b/sc/qa/uitest/search_replace/tdf44861.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 select_pos
-from uitest.uihelper.calc import enter_text_to_cell
+from uitest.uihelper.common import get_state_as_dict, get_url_for_data_file
+
 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
 
-#Bug 44861 - EDITING: result 'Find&Replace All' wrong for particular Regular Expression
 
+# Bug 44861 - EDITING: result 'Find&Replace All' wrong for particular Regular Expression
 class tdf44861(UITestCase):
    def test_tdf44861_find_replaceAll_regexp(self):
         with self.ui_test.load_file(get_url_for_data_file("tdf44861.ods")) as calc_doc:
diff --git a/sc/qa/uitest/signatureLine/insertSignatureLine.py b/sc/qa/uitest/signatureLine/insertSignatureLine.py
index 08323811a364..8e013a7ee799 100644
--- a/sc/qa/uitest/signatureLine/insertSignatureLine.py
+++ b/sc/qa/uitest/signatureLine/insertSignatureLine.py
@@ -8,12 +8,11 @@
 #
 
 from uitest.framework import UITestCase
-from libreoffice.uno.propertyvalue import mkPropertyValues
-from uitest.uihelper.common import get_state_as_dict, type_text
+
 from libreoffice.uno.propertyvalue import mkPropertyValues
 
-#Bug 117903 - Allow signature lines in Calc
 
+# Bug 117903 - Allow signature lines in Calc
 class insertSignatureLineCalc(UITestCase):
 
    def test_insert_signature_line_calc(self):
diff --git a/sc/qa/uitest/solver/solver.py b/sc/qa/uitest/solver/solver.py
index 0ac87200f68a..7a1ad19019a8 100644
--- a/sc/qa/uitest/solver/solver.py
+++ b/sc/qa/uitest/solver/solver.py
@@ -8,12 +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.common import select_by_text
-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 solver(UITestCase):
     def test_solver(self):
         with self.ui_test.load_file(get_url_for_data_file("solver.ods")) as calc_doc:
diff --git a/sc/qa/uitest/sort/subtotals.py b/sc/qa/uitest/sort/subtotals.py
index 40c91df05a10..ee8ab5fbbbd2 100644
--- a/sc/qa/uitest/sort/subtotals.py
+++ b/sc/qa/uitest/sort/subtotals.py
@@ -7,14 +7,14 @@
 # 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 uitest.uihelper.calc import enter_text_to_cell
+from uitest.uihelper.common import select_by_text, select_pos
+from uitest.uihelper.common import get_url_for_data_file
+
 from libreoffice.calc.document import get_cell_by_position
-from uitest.uihelper.common import select_pos
-from uitest.uihelper.common import select_by_text
-from uitest.uihelper.common import get_state_as_dict, get_url_for_data_file
+from libreoffice.uno.propertyvalue import mkPropertyValues
+
 
 class Subtotals(UITestCase):
 
diff --git a/sc/qa/uitest/sort/tdf49531.py b/sc/qa/uitest/sort/tdf49531.py
index 98d705bf8dd3..6e0498cfafd2 100644
--- a/sc/qa/uitest/sort/tdf49531.py
+++ b/sc/qa/uitest/sort/tdf49531.py
@@ -8,15 +8,14 @@
 #
 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.common import select_by_text
-from uitest.uihelper.calc import enter_text_to_cell
+from uitest.uihelper.common import select_by_text, select_pos
+
 from libreoffice.calc.document import get_cell_by_position
 from libreoffice.uno.propertyvalue import mkPropertyValues
 
-#Bug 49531 - EDITING: Sort rows for will sort columns
-#Bug 49520 - EDITING: CRASH when undo sort with chart
 
+# Bug 49531 - EDITING: Sort rows for will sort columns
+# Bug 49520 - EDITING: CRASH when undo sort with chart
 class tdf49531(UITestCase):
     def test_td49531_sort_undo_crash(self):
         with self.ui_test.load_file(get_url_for_data_file("tdf49531.ods")) as calc_doc:
diff --git a/sc/qa/uitest/sort/tdf54018.py b/sc/qa/uitest/sort/tdf54018.py
index ca7ca1058313..6629a608a5f2 100644
--- a/sc/qa/uitest/sort/tdf54018.py
+++ b/sc/qa/uitest/sort/tdf54018.py
@@ -7,15 +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.common import select_by_text
-from uitest.uihelper.calc import enter_text_to_cell
+from uitest.uihelper.common import get_url_for_data_file
+from uitest.uihelper.common import select_by_text, select_pos
+
 from libreoffice.calc.document import get_cell_by_position
-from libreoffice.uno.propertyvalue import mkPropertyValues
 
-#Bug 54018 - EDITING: CRASH sorting cells range with Comments
 
+# Bug 54018 - EDITING: CRASH sorting cells range with Comments
 class tdf54018(UITestCase):
     def test_td54018_sort_with_comments(self):
         with self.ui_test.load_file(get_url_for_data_file("tdf54018.ods")) as calc_doc:
diff --git a/sc/qa/uitest/sort/tdf95192.py b/sc/qa/uitest/sort/tdf95192.py
index 000162474cfb..1c33f56f7bf6 100644
--- a/sc/qa/uitest/sort/tdf95192.py
+++ b/sc/qa/uitest/sort/tdf95192.py
@@ -7,13 +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 uitest.uihelper.common import get_url_for_data_file, select_pos
+
 from libreoffice.calc.document import get_cell_by_position
 from libreoffice.uno.propertyvalue import mkPropertyValues
-#Bug 95192 - SORTING Natural sorting not working with non-letter,non-number content
 
+
+# Bug 95192 - SORTING Natural sorting not working with non-letter,non-number content
 class tdf95192(UITestCase):
     def test_td99627_natural_sort(self):
         with self.ui_test.load_file(get_url_for_data_file("tdf95192.ods")) as calc_doc:
diff --git a/sc/qa/uitest/sort/tdf99208.py b/sc/qa/uitest/sort/tdf99208.py
index 9e3115d51b71..e740a9c4a596 100644
--- a/sc/qa/uitest/sort/tdf99208.py
+++ b/sc/qa/uitest/sort/tdf99208.py
@@ -8,14 +8,13 @@
 #
 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.common import select_by_text
-from uitest.uihelper.calc import enter_text_to_cell
+from uitest.uihelper.common import select_by_text, select_pos
+
 from libreoffice.calc.document import get_cell_by_position
 from libreoffice.uno.propertyvalue import mkPropertyValues
 
-#Bug 99208 - Spreadsheet sort hangs
 
+# Bug 99208 - Spreadsheet sort hangs
 class tdf99208(UITestCase):
     def test_td99627_natural_sort(self):
         with self.ui_test.load_file(get_url_for_data_file("tdf99208.ods")) as calc_doc:
diff --git a/sc/qa/uitest/sort/tdf99627.py b/sc/qa/uitest/sort/tdf99627.py
index 0b5c0fc8898f..281f4340de46 100644
--- a/sc/qa/uitest/sort/tdf99627.py
+++ b/sc/qa/uitest/sort/tdf99627.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, get_url_for_data_file
-from uitest.uihelper.common import select_pos
-from uitest.uihelper.calc import enter_text_to_cell
+from uitest.uihelper.common import get_url_for_data_file, select_pos
+
 from libreoffice.calc.document import get_cell_by_position
 from libreoffice.uno.propertyvalue import mkPropertyValues
 
-#Bug 99627 - Calc freezes when applying natural sorting on text columns
 
+# Bug 99627 - Calc freezes when applying natural sorting on text columns
 class tdf99627(UITestCase):
     def test_td99627_natural_sort(self):
         with self.ui_test.load_file(get_url_for_data_file("tdf99627.ods")) as calc_doc:
diff --git a/sc/qa/uitest/statistics/regression.py b/sc/qa/uitest/statistics/regression.py
index de7163949ec1..05e03777b0c9 100644
--- a/sc/qa/uitest/statistics/regression.py
+++ b/sc/qa/uitest/statistics/regression.py
@@ -8,12 +8,11 @@
 #
 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.document import get_cell_by_position
 from libreoffice.uno.propertyvalue import mkPropertyValues
 
+
 class regression(UITestCase):
     def test_regression_row(self):
         self._regression_check(data_groupedby_column = False)
diff --git a/sc/qa/uitest/textCase/textCase.py b/sc/qa/uitest/textCase/textCase.py
index 9060be29d1a9..10abb64d0c31 100644
--- a/sc/qa/uitest/textCase/textCase.py
+++ b/sc/qa/uitest/textCase/textCase.py
@@ -7,12 +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, 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_cell_by_position
 from libreoffice.uno.propertyvalue import mkPropertyValues
 
+
 class textCase(UITestCase):
     def test_text_case_switch(self):
         with self.ui_test.create_doc_in_start_center("calc") as document:
diff --git a/sc/qa/uitest/validity/tdf138134.py b/sc/qa/uitest/validity/tdf138134.py
index 9834c561816d..604eddeede0f 100644
--- a/sc/qa/uitest/validity/tdf138134.py
+++ b/sc/qa/uitest/validity/tdf138134.py
@@ -7,13 +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.common import select_by_text
 from uitest.uihelper.calc import enter_text_to_cell
-from libreoffice.calc.document import get_cell_by_position
+from uitest.uihelper.common import select_by_text, select_pos
+
 from libreoffice.uno.propertyvalue import mkPropertyValues
 
+
 class DetectiveCircle(UITestCase):
 
     def test_delete_circle_at_formula(self):
diff --git a/sc/qa/uitest/validity/tdf53920.py b/sc/qa/uitest/validity/tdf53920.py
index 5be1195c04e6..51b46ae317a5 100644
--- a/sc/qa/uitest/validity/tdf53920.py
+++ b/sc/qa/uitest/validity/tdf53920.py
@@ -8,12 +8,13 @@
 #
 from uitest.framework import UITestCase
 from uitest.uihelper.common import get_state_as_dict
-from uitest.uihelper.common import select_pos
-from uitest.uihelper.common import select_by_text
+from uitest.uihelper.common import select_by_text, 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
-#Bug 53920 - EDITING: Data Validity Cell Range not being applied to multiple selected cells
+
+
+# Bug 53920 - EDITING: Data Validity Cell Range not being applied to multiple selected cells
 class tdf53920(UITestCase):
     def test_tdf53920_validity_multiple_cells(self):
         with self.ui_test.create_doc_in_start_center("calc"):
diff --git a/sc/qa/uitest/validity/tdf65686.py b/sc/qa/uitest/validity/tdf65686.py
index be3b3b9fd17c..bb85d113edce 100644
--- a/sc/qa/uitest/validity/tdf65686.py
+++ b/sc/qa/uitest/validity/tdf65686.py
@@ -8,12 +8,12 @@
 #
 from uitest.framework import UITestCase
 from uitest.uihelper.common import get_state_as_dict
-from uitest.uihelper.common import select_pos
-from uitest.uihelper.common import select_by_text
-from uitest.uihelper.calc import enter_text_to_cell
-from libreoffice.calc.document import get_cell_by_position
+from uitest.uihelper.common import select_by_text, select_pos
+
 from libreoffice.uno.propertyvalue import mkPropertyValues
-#Bug 65686 - EDITING Data > Validity broken (for list entries at least)
+
+
+# Bug 65686 - EDITING Data > Validity broken (for list entries at least)
 class tdf65686(UITestCase):
     def test_tdf65686_validity_list(self):
         with self.ui_test.create_doc_in_start_center("calc"):
diff --git a/sc/qa/uitest/validity/tdf96698.py b/sc/qa/uitest/validity/tdf96698.py
index 0faf57348a31..78fdb28664d5 100644
--- a/sc/qa/uitest/validity/tdf96698.py
+++ b/sc/qa/uitest/validity/tdf96698.py
@@ -8,12 +8,12 @@
 #
 from uitest.framework import UITestCase
 from uitest.uihelper.common import get_state_as_dict
-from uitest.uihelper.common import select_pos
-from uitest.uihelper.common import select_by_text
-from uitest.uihelper.calc import enter_text_to_cell
-from libreoffice.calc.document import get_cell_by_position
+from uitest.uihelper.common import select_by_text, select_pos
+
 from libreoffice.uno.propertyvalue import mkPropertyValues
-#Bug 96698 - Data => Validity => Custom (like Excel) is missing
+
+
+# Bug 96698 - Data => Validity => Custom (like Excel) is missing
 class tdf96698(UITestCase):
     def test_tdf96698_validity_custom_formula(self):
         with self.ui_test.create_doc_in_start_center("calc"):
diff --git a/sc/qa/uitest/validity/validity.py b/sc/qa/uitest/validity/validity.py
index adb5899409dd..25e691a42544 100644
--- a/sc/qa/uitest/validity/validity.py
+++ b/sc/qa/uitest/validity/validity.py
@@ -8,12 +8,11 @@
 #
 from uitest.framework import UITestCase
 from uitest.uihelper.common import get_state_as_dict
-from uitest.uihelper.common import select_pos
-from uitest.uihelper.common import select_by_text
-from uitest.uihelper.calc import enter_text_to_cell
-from libreoffice.calc.document import get_cell_by_position
+from uitest.uihelper.common import select_by_text, select_pos
+
 from libreoffice.uno.propertyvalue import mkPropertyValues
 
+
 class validity(UITestCase):
     def test_validity_tab_criteria(self):
         with self.ui_test.create_doc_in_start_center("calc"):