sc/qa/uitest/calc_tests3/tdf139974.py | 3 ++-
sc/qa/uitest/calc_tests4/exportToPDF.py | 8 +++++---
sc/qa/uitest/calc_tests4/saveToCSV.py | 9 +++++----
sc/qa/uitest/calc_tests8/tdf125051.py | 5 ++---
sc/qa/uitest/calc_tests9/tdf126673.py | 8 +++-----
sc/qa/uitest/calc_tests9/tdf141244.py | 4 ++--
sc/qa/uitest/calc_tests9/tdf144996.py | 3 ++-
sc/qa/uitest/chart/chartArea.py | 10 ++++------
sc/qa/uitest/chart/chartAxes.py | 8 +++-----
sc/qa/uitest/chart/chartDataLabels.py | 10 ++++------
sc/qa/uitest/chart/chartGrid.py | 11 ++++-------
sc/qa/uitest/chart/chartLegend.py | 8 +++-----
sc/qa/uitest/chart/chartWall.py | 10 ++++------
sc/qa/uitest/chart/formatDataSeries.py | 10 ++++------
sc/qa/uitest/chart/tdf122011.py | 5 +++--
sc/qa/uitest/chart/tdf46885.py | 5 ++---
sc/qa/uitest/chart/tdf62349.py | 7 +++----
sc/qa/uitest/chart/tdf99069.py | 6 +++---
sc/qa/uitest/chart2/tdf101894.py | 6 +++---
sc/qa/uitest/chart2/tdf120348.py | 5 +++--
sc/qa/uitest/chart2/tdf122398.py | 7 +++----
sc/qa/uitest/chart2/tdf123013.py | 7 +++----
sc/qa/uitest/chart2/tdf123231.py | 7 +++----
sc/qa/uitest/chart2/tdf123520.py | 10 ++++------
sc/qa/uitest/chart2/tdf124111.py | 7 +++----
sc/qa/uitest/chart2/tdf136011.py | 6 +++---
sc/qa/uitest/conditional_format/tdf117899.py | 10 ++++++----
sc/qa/uitest/conditional_format/tdf118206.py | 8 ++++----
sc/qa/uitest/csv_dialog/tdf39716.py | 3 ++-
sc/qa/uitest/external_links/tdf114995.py | 6 +++---
sc/qa/uitest/external_links/tdf127484.py | 8 ++++----
sc/qa/uitest/external_links/tdf147767.py | 8 ++++----
sc/qa/uitest/external_links/tdf95217.py | 8 ++++----
sc/qa/uitest/external_links/tdf96499.py | 8 ++++----
sc/qa/uitest/function_wizard/function_wizard.py | 3 +--
sc/qa/uitest/goalSeek/goalSeek.py | 6 +++---
sc/qa/uitest/goalSeek/tdf37341.py | 7 +++----
sc/qa/uitest/goalSeek/tdf43693.py | 7 +++----
sc/qa/uitest/key_f4/tdf102525.py | 5 +++--
sc/qa/uitest/options/tdf122977.py | 6 +-----
sc/qa/uitest/pageFormat/tdf123508.py | 11 ++++-------
sc/qa/uitest/range_name/tdf119954.py | 8 ++++----
sc/qa/uitest/range_name/tdf86214.py | 3 +--
sc/qa/uitest/search_replace/tdf35020.py | 6 +++---
sc/qa/uitest/search_replace/tdf39917.py | 8 +++-----
sc/qa/uitest/search_replace/tdf39959.py | 7 +++----
sc/qa/uitest/search_replace/tdf44398.py | 7 +++----
sc/qa/uitest/search_replace/tdf44861.py | 7 +++----
sc/qa/uitest/signatureLine/insertSignatureLine.py | 5 ++---
sc/qa/uitest/solver/solver.py | 4 ++--
sc/qa/uitest/sort/subtotals.py | 10 +++++-----
sc/qa/uitest/sort/tdf49531.py | 9 ++++-----
sc/qa/uitest/sort/tdf54018.py | 10 ++++------
sc/qa/uitest/sort/tdf95192.py | 8 ++++----
sc/qa/uitest/sort/tdf99208.py | 7 +++----
sc/qa/uitest/sort/tdf99627.py | 7 +++----
sc/qa/uitest/statistics/regression.py | 5 ++---
sc/qa/uitest/textCase/textCase.py | 4 ++--
sc/qa/uitest/validity/tdf138134.py | 7 +++----
sc/qa/uitest/validity/tdf53920.py | 9 +++++----
sc/qa/uitest/validity/tdf65686.py | 10 +++++-----
sc/qa/uitest/validity/tdf96698.py | 10 +++++-----
sc/qa/uitest/validity/validity.py | 7 +++----
63 files changed, 204 insertions(+), 243 deletions(-)
New commits:
commit 69a103b57a39798473ebc48fdad0f696cbd606a6
Author: tagezi <lera.goncha...@gmail.com>
AuthorDate: Mon May 16 23:16:29 2022 +0300
Commit: Xisco Fauli <xiscofa...@libreoffice.org>
CommitDate: Mon May 23 14:35:38 2022 +0200
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 <xiscofa...@libreoffice.org>
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"):
