[Libreoffice-commits] core.git: bin/crashreportScraper.py

2022-06-02 Thread tagezi (via logerrit)
 bin/crashreportScraper.py |   17 ++---
 1 file changed, 6 insertions(+), 11 deletions(-)

New commits:
commit 3cb921dece44e3e289fc73a64399c1a6c618259c
Author: tagezi 
AuthorDate: Fri May 27 21:25:13 2022 +0300
Commit: Xisco Fauli 
CommitDate: Thu Jun 2 15:52:20 2022 +0200

crashreportScraper: Removed time parsing, now it just resets.

Change-Id: I39465cdbc14e28556760a0c1feab22d8998e4d16
Reviewed-on: https://gerrit.libreoffice.org/c/core/+/135050
Tested-by: Jenkins
Reviewed-by: Xisco Fauli 

diff --git a/bin/crashreportScraper.py b/bin/crashreportScraper.py
index 1735aa3052b5..aec3e5e9cffb 100755
--- a/bin/crashreportScraper.py
+++ b/bin/crashreportScraper.py
@@ -24,15 +24,11 @@ def convert_str_to_date(value):
 value = value.replace('June', 'Jun')
 value = value.replace('July', 'Jul')
 value = value.replace('Sept', 'Sep')
-value = value.replace('noon', '12:00 pm')
+# reset the time leaving the date
+value = ", ".join(value.split(", ")[:-1])
+dtDate = datetime.strptime(value, '%b %d, %Y')
 
-if ':' not in value:
-if 'am' in value:
-value = value.replace(' am', ':00 am')
-elif 'pm' in value:
-value = value.replace(' pm', ':00 pm')
-
-return datetime.strptime(value, '%b %d, %Y, %H:%M %p')
+return dtDate.strftime('%y/%m/%d')
 
 def parse_version_url(url):
 crashReports = {}
@@ -193,7 +189,7 @@ if __name__ == '__main__':
 f.write(line)
 f.flush()
 
-for k, v in crashes.items():
+for k, lDate in crashes.items():
 if len(k) < 254 and k not in crashesInFile and '`' not in k:
 print("Parsing " + k)
 try:
@@ -201,10 +197,9 @@ if __name__ == '__main__':
 
"https://crashreport.libreoffice.org/stats/signature/; + k)
 crashReason, crashStack, codeLine = 
parse_details_and_get_info(
 
"https://crashreport.libreoffice.org/stats/crash_details/; + crashID, gitRepo)
-line = '\t'.join([k, str(crashCount), 
v[1].strftime('%y/%m/%d'), v[2].strftime('%y/%m/%d'),
+line = '\t'.join([k, str(crashCount), lDate[1], lDate[2],
 crashID, crashVersion, crashReason, crashOS, 
crashStack, codeLine, '\n'])
 f.write(line)
 f.flush()
 except requests.exceptions.Timeout:
 continue
-


[Libreoffice-commits] core.git: sc/qa

2022-05-30 Thread tagezi (via logerrit)
 sc/qa/uitest/autofilter/autofilter.py |   14 +++---
 sc/qa/uitest/autofilter/autofilterBugs.py |   14 +++---
 sc/qa/uitest/autofilter2/tdf97340.py  |2 +-
 sc/qa/uitest/calc_tests/calcSheetDelete.py|6 --
 sc/qa/uitest/calc_tests/columns.py|1 -
 sc/qa/uitest/calc_tests/formatCells.py|3 ---
 sc/qa/uitest/calc_tests/rows.py   |1 -
 sc/qa/uitest/calc_tests/sheetRename.py|4 
 sc/qa/uitest/calc_tests2/consolidate.py   |3 ---
 sc/qa/uitest/calc_tests2/standardFilter.py|2 +-
 sc/qa/uitest/calc_tests2/tdf104117.py |5 -
 sc/qa/uitest/calc_tests2/tdf114992.py |3 ---
 sc/qa/uitest/calc_tests3/clearCells.py|9 +
 sc/qa/uitest/calc_tests3/insertQrCodeGen.py   |3 ---
 sc/qa/uitest/calc_tests3/tdf77509.py  |2 --
 sc/qa/uitest/calc_tests3/tdf80693.py  |4 
 sc/qa/uitest/calc_tests4/tdf131170.py |4 +---
 sc/qa/uitest/calc_tests4/tdf88999.py  |4 
 sc/qa/uitest/calc_tests4/tdf89958.py  |2 +-
 sc/qa/uitest/calc_tests4/trackedChanges.py|7 ++-
 sc/qa/uitest/calc_tests6/autocorrectOptions.py|4 
 sc/qa/uitest/calc_tests6/moveCopySheet.py |4 +---
 sc/qa/uitest/calc_tests6/shareSpreadsheet.py  |3 ---
 sc/qa/uitest/calc_tests6/tdf116996.py |3 ---
 sc/qa/uitest/calc_tests7/tdf106667.py |2 +-
 sc/qa/uitest/calc_tests7/tdf122509.py |6 --
 sc/qa/uitest/calc_tests7/tdf123122.py |   13 -
 sc/qa/uitest/calc_tests7/tdf124896.py |5 +
 sc/qa/uitest/calc_tests7/tdf137397.py |2 +-
 sc/qa/uitest/calc_tests8/tdf124829.py |3 ---
 sc/qa/uitest/calc_tests8/tdf125051.py |3 +--
 sc/qa/uitest/calc_tests8/tdf137726.py |5 +
 sc/qa/uitest/calc_tests9/hashIncompatible.py  |2 +-
 sc/qa/uitest/calc_tests9/tdf118938.py |3 ---
 sc/qa/uitest/calc_tests9/tdf124318.py |2 +-
 sc/qa/uitest/calc_tests9/tdf125440.py |4 ++--
 sc/qa/uitest/calc_tests9/tdf126673.py |2 +-
 sc/qa/uitest/calc_tests9/tdf130371.py |2 +-
 sc/qa/uitest/calc_tests9/tdf133629.py |3 ---
 sc/qa/uitest/calc_tests9/tdf137446.py |2 +-
 sc/qa/uitest/chart/chartAxes.py   |2 +-
 sc/qa/uitest/chart/chartDataLabels.py |   19 +--
 sc/qa/uitest/chart/chartGrid.py   |2 +-
 sc/qa/uitest/chart/chartGrids.py  |2 +-
 sc/qa/uitest/chart/chartLegend.py |7 ++-
 sc/qa/uitest/chart/chartTitles.py |2 +-
 sc/qa/uitest/chart/chartXAxis.py  |2 +-
 sc/qa/uitest/chart/chartYAxis.py  |2 +-
 sc/qa/uitest/chart/formatDataSeries.py|8 +---
 sc/qa/uitest/chart2/tdf101894.py  |4 
 sc/qa/uitest/chart2/tdf122398.py  |2 +-
 sc/qa/uitest/chart2/tdf123013.py  |2 +-
 sc/qa/uitest/chart2/tdf123231.py  |   10 +-
 sc/qa/uitest/chart2/tdf123520.py  |   13 +
 sc/qa/uitest/chart2/tdf124111.py  |   16 +---
 sc/qa/uitest/chart2/tdf136011.py  |5 +
 sc/qa/uitest/conditional_format/tdf105544.py  |2 +-
 sc/qa/uitest/conditional_format/tdf117899.py  |4 
 sc/qa/uitest/conditional_format/tdf119178.py  |2 +-
 sc/qa/uitest/conditional_format/tdf124412.py  |2 +-
 sc/qa/uitest/conditional_format/tdf81696.py   |1 -
 sc/qa/uitest/csv_dialog/tdf39716.py   |2 +-
 sc/qa/uitest/function_wizard/tdf37864.py  |2 +-
 sc/qa/uitest/goalSeek/goalSeek.py |1 -
 sc/qa/uitest/goalSeek/tdf37341.py |1 -
 sc/qa/uitest/goalSeek/tdf43693.py |1 -
 sc/qa/uitest/manual_tests/calc.py |4 ++--
 sc/qa/uitest/options/tdf122977.py |3 ---
 sc/qa/uitest/pageFormat/tdf123508.py  |4 +---
 sc/qa/uitest/pasteSpecial/tdf114710.py|2 +-
 sc/qa/uitest/pasteSpecial/tdf118308.py|2 +-
 sc/qa/uitest/pasteSpecial/tdf62267.py |4 ++--
 sc/qa/uitest/pasteSpecial/tdf74577.py |4 
 sc/qa/uitest/pasteSpecial/tdf86253.py |2 +-
 sc/qa/uitest/protect/protectSpreadsheet.py|2 --
 sc/qa/uitest/range_name/create_range_name.py  |2 +-
 sc/qa/uitest/range_name/tdf145077.py  |2 +-
 sc/qa/uitest/search_replace/replace.py|2 +-
 sc/qa/uitest/search_replace/tdf132097.py  |2 --
 

[Libreoffice-commits] core.git: sc/qa

2022-05-27 Thread tagezi (via logerrit)
 sc/qa/uitest/calc_tests8/tdf119343.py|2 +-
 sc/qa/uitest/calc_tests8/tdf124829.py|   10 ++
 sc/qa/uitest/calc_tests9/tdf142763.py|2 +-
 sc/qa/uitest/chart/chartGrids.py |2 +-
 sc/qa/uitest/chart/chartXAxis.py |2 +-
 sc/qa/uitest/chart/chartYAxis.py |3 +--
 sc/qa/uitest/chart/copyPaste.py  |5 +++--
 sc/qa/uitest/chart/tdf93506_trendline.py |3 +--
 sc/qa/uitest/conditional_format/tdf105351.py |   10 +-
 sc/qa/uitest/conditional_format/tdf81696.py  |2 +-
 sc/qa/uitest/sort/stableSorting.py   |2 +-
 sc/qa/uitest/statistics/fTest.py |6 ++
 sc/qa/uitest/statistics/tdf76731.py  |2 +-
 13 files changed, 21 insertions(+), 30 deletions(-)

New commits:
commit bd6cb0d8219b117b1a72774c26d54774c72602da
Author: tagezi 
AuthorDate: Fri May 27 11:04:25 2022 +0300
Commit: Xisco Fauli 
CommitDate: Fri May 27 11:59:12 2022 +0200

tdf#132293: Removing unused imports from uitests files.

This is the final cleanup of imports in the sc module.
'pyflakes sc' is now empty.
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: I8c4dff1007b9954c35795a7c8a940e8fcf8d7f93
Reviewed-on: https://gerrit.libreoffice.org/c/core/+/135036
Tested-by: Jenkins
Reviewed-by: Xisco Fauli 

diff --git a/sc/qa/uitest/calc_tests8/tdf119343.py 
b/sc/qa/uitest/calc_tests8/tdf119343.py
index 0debe6aea848..0d4581f18b11 100644
--- a/sc/qa/uitest/calc_tests8/tdf119343.py
+++ b/sc/qa/uitest/calc_tests8/tdf119343.py
@@ -7,7 +7,7 @@
 # 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.calc.document import get_cell_by_position
 from libreoffice.uno.propertyvalue import mkPropertyValues
diff --git a/sc/qa/uitest/calc_tests8/tdf124829.py 
b/sc/qa/uitest/calc_tests8/tdf124829.py
index ef2a0213f93b..43e90d1f818c 100644
--- a/sc/qa/uitest/calc_tests8/tdf124829.py
+++ b/sc/qa/uitest/calc_tests8/tdf124829.py
@@ -7,16 +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 uitest.uihelper.common import select_pos
-from uitest.uihelper.calc import enter_text_to_cell
-from libreoffice.calc.document import get_sheet_from_doc
-from libreoffice.calc.conditional_format import 
get_conditional_format_from_sheet
-from libreoffice.calc.document import get_cell_by_position
-from libreoffice.uno.propertyvalue import mkPropertyValues
+from uitest.uihelper.common import get_url_for_data_file
 
-#Bug 124829 - CRASH: cutting and undoing a sheet with external links
 
+# Bug 124829 - CRASH: cutting and undoing a sheet with external links
 class tdf124829(UITestCase):
 def test_tdf124829_Crash_cutting_undo_sheet_external_links(self):
 #numberingformatpage.ui
diff --git a/sc/qa/uitest/calc_tests9/tdf142763.py 
b/sc/qa/uitest/calc_tests9/tdf142763.py
index 238d30833eb1..548be27b4148 100644
--- a/sc/qa/uitest/calc_tests9/tdf142763.py
+++ b/sc/qa/uitest/calc_tests9/tdf142763.py
@@ -7,7 +7,7 @@
 # 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, 
select_pos
+from uitest.uihelper.common import get_state_as_dict, select_pos
 
 from libreoffice.uno.propertyvalue import mkPropertyValues
 
diff --git a/sc/qa/uitest/chart/chartGrids.py b/sc/qa/uitest/chart/chartGrids.py
index dda37675c4cc..ba25f1662d26 100644
--- a/sc/qa/uitest/chart/chartGrids.py
+++ b/sc/qa/uitest/chart/chartGrids.py
@@ -7,7 +7,7 @@
 # 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, 
type_text
+from uitest.uihelper.common import get_state_as_dict, get_url_for_data_file
 
 from libreoffice.uno.propertyvalue import mkPropertyValues
 
diff --git a/sc/qa/uitest/chart/chartXAxis.py b/sc/qa/uitest/chart/chartXAxis.py
index 61fb5c11b78b..eafb350862f7 100644
--- a/sc/qa/uitest/chart/chartXAxis.py
+++ b/sc/qa/uitest/chart/chartXAxis.py
@@ -7,7 +7,7 @@
 # file, You can obtain one at http://mozilla.org/MPL/2.0/.
 #
 from uitest.framework import UITestCase
-from uitest.uihelper.common import change_measurement_unit, type_text
+from uitest.uihelper.common import change_measurement_unit
 from uitest.uihelper.common import get_state_as_dict, get_url_for_data_file
 from uitest.uihelper.common import select_by_text, select_pos
 
diff --git a/sc/qa/uitest/chart/chartYAxis.py b/sc/qa/uitest/chart/chartYAxis.py
index 

[Libreoffice-commits] core.git: sc/qa

2022-05-23 Thread tagezi (via logerrit)
 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 
AuthorDate: Mon May 16 23:16:29 2022 +0300
Commit: Xisco Fauli 
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 

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
+++ 

[Libreoffice-commits] core.git: sc/qa

2022-05-23 Thread tagezi (via logerrit)
 sc/qa/uitest/calc_tests8/tdf119343.py|7 ++-
 sc/qa/uitest/calc_tests9/tdf142763.py|4 ++--
 sc/qa/uitest/chart/chartGrids.py |8 +++-
 sc/qa/uitest/chart/chartXAxis.py |   12 +---
 sc/qa/uitest/chart/chartYAxis.py |   12 +---
 sc/qa/uitest/chart/tdf93506_trendline.py |   14 ++
 sc/qa/uitest/chart2/tdf124295.py |2 --
 sc/qa/uitest/conditional_format/tdf105466.py |2 +-
 sc/qa/uitest/conditional_format/tdf105544.py |6 +++---
 sc/qa/uitest/conditional_format/tdf81696.py  |9 +++--
 sc/qa/uitest/function_wizard/tdf123479.py|8 ++--
 sc/qa/uitest/hide_cols/tdf95306.py   |5 ++---
 sc/qa/uitest/inputLine/tdf54197.py   |9 -
 sc/qa/uitest/key_f4/f4.py|6 +++---
 sc/qa/uitest/pasteSpecial/tdf74577.py|3 ++-
 sc/qa/uitest/protect/protectSheet.py |7 +++
 sc/qa/uitest/protect/protectSpreadsheet.py   |9 ++---
 sc/qa/uitest/sort/naturalSort.py |9 -
 sc/qa/uitest/sort/sorting.py |9 -
 sc/qa/uitest/sort/stableSorting.py   |7 ++-
 sc/qa/uitest/sort/tdf91305.py|8 
 sc/qa/uitest/sort/tdf99773.py|9 -
 sc/qa/uitest/statistics/anova.py |6 ++
 sc/qa/uitest/statistics/chiSquare.py |6 ++
 sc/qa/uitest/statistics/correlation.py   |6 ++
 sc/qa/uitest/statistics/covariance.py|6 ++
 sc/qa/uitest/statistics/descriptiveStatistics.py |6 ++
 sc/qa/uitest/statistics/exponentialSmoothing.py  |6 ++
 sc/qa/uitest/statistics/movingAverage.py |6 ++
 sc/qa/uitest/statistics/sampling.py  |7 +++
 sc/qa/uitest/statistics/tTest.py |6 ++
 sc/qa/uitest/statistics/tdf76731.py  |7 ++-
 sc/qa/uitest/statistics/zTest.py |6 ++
 33 files changed, 89 insertions(+), 144 deletions(-)

New commits:
commit 30a048cb895a3dcdd6048f3c525edd95a1371b91
Author: tagezi 
AuthorDate: Mon May 16 14:55:48 2022 +0300
Commit: Xisco Fauli 
CommitDate: Mon May 23 14:33:38 2022 +0200

tdf#132293: Removing unused imports from uitests files.

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

Change-Id: I8afc5debef6e758d7ad42b1a649f9556d3d7abbd
Reviewed-on: https://gerrit.libreoffice.org/c/core/+/134400
Tested-by: Jenkins
Reviewed-by: Xisco Fauli 

diff --git a/sc/qa/uitest/calc_tests8/tdf119343.py 
b/sc/qa/uitest/calc_tests8/tdf119343.py
index 51d35a99af93..0debe6aea848 100644
--- a/sc/qa/uitest/calc_tests8/tdf119343.py
+++ b/sc/qa/uitest/calc_tests8/tdf119343.py
@@ -8,15 +8,12 @@
 #
 from uitest.framework import UITestCase
 from uitest.uihelper.common import get_state_as_dict, get_url_for_data_file
-from uitest.uihelper.common import select_pos
-from uitest.uihelper.calc import enter_text_to_cell
-from libreoffice.calc.document import get_sheet_from_doc
-from libreoffice.calc.conditional_format import 
get_conditional_format_from_sheet
+
 from libreoffice.calc.document import get_cell_by_position
 from libreoffice.uno.propertyvalue import mkPropertyValues
 
-#Bug 119343 - EDITING: copied and pasted cells containing formulas are not 
recalculated (2)
 
+# Bug 119343 - EDITING: copied and pasted cells containing formulas are not 
recalculated (2)
 class tdf119343(UITestCase):
 def test_tdf119343_copy_paste_formula(self):
 #numberingformatpage.ui
diff --git a/sc/qa/uitest/calc_tests9/tdf142763.py 
b/sc/qa/uitest/calc_tests9/tdf142763.py
index e7885063a292..238d30833eb1 100644
--- a/sc/qa/uitest/calc_tests9/tdf142763.py
+++ b/sc/qa/uitest/calc_tests9/tdf142763.py
@@ -8,9 +8,9 @@
 #
 from uitest.framework import UITestCase
 from uitest.uihelper.common import get_state_as_dict, get_url_for_data_file, 
select_pos
+
 from libreoffice.uno.propertyvalue import mkPropertyValues
-from libreoffice.calc.document import get_cell_by_position
-import time
+
 
 class Tdf142763(UITestCase):
 
diff --git a/sc/qa/uitest/chart/chartGrids.py b/sc/qa/uitest/chart/chartGrids.py
index 8bff4e58296c..dda37675c4cc 100644
--- a/sc/qa/uitest/chart/chartGrids.py
+++ b/sc/qa/uitest/chart/chartGrids.py
@@ -7,14 +7,12 @@
 # file, You can obtain one at http://mozilla.org/MPL/2.0/.
 #
 from uitest.framework import UITestCase
-from uitest.uihelper.common import select_pos
-from uitest.uihelper.calc import enter_text_to_cell
-from libreoffice.calc.document import get_cell_by_position
-from libreoffice.uno.propertyvalue import mkPropertyValues
 from uitest.uihelper.common import get_state_as_dict, get_url_for_data_file,