Adding upstream version 1:7.0.4.upstream/1%7.0.4upstream

Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>

18 files changed, 1823 insertions, 0 deletions

diff --git a/sc/qa/uitest/calc_tests2/consolidate.py b/sc/qa/uitest/calc_tests2/consolidate.py
new file mode 100644
index 000000000..b52e3be8f
--- /dev/null
+++ b/sc/qa/uitest/calc_tests2/consolidate.py
@@ -0,0 +1,130 @@
+# -*- tab-width: 4; indent-tabs-mode: nil; py-indent-offset: 4 -*-
+#
+# This Source Code Form is subject to the terms of the Mozilla Public
+# 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/.
+#
+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
+import org.libreoffice.unotest
+import pathlib
+
+def get_url_for_data_file(file_name):
+    return pathlib.Path(org.libreoffice.unotest.makeCopyFromTDOC(file_name)).as_uri()
+
+#consolidatedialog.ui
+class consolidate(UITestCase):
+    def test_consolidate(self):
+        calc_doc = self.ui_test.load_file(get_url_for_data_file("consolidate.ods"))
+        xCalcDoc = self.xUITest.getTopFocusWindow()
+        gridwin = xCalcDoc.getChild("grid_window")
+        document = self.ui_test.get_component()
+
+        self.ui_test.execute_modeless_dialog_through_command(".uno:DataConsolidate")
+        xDialog = self.xUITest.getTopFocusWindow()
+        xfunc = xDialog.getChild("func")
+        xlbdataarea = xDialog.getChild("lbdataarea")
+        xadd = xDialog.getChild("add")
+        xbyrow = xDialog.getChild("byrow")
+        xbycol = xDialog.getChild("bycol")
+        xeddestarea = xDialog.getChild("eddestarea")
+
+        props = {"TEXT": "Sum"}
+        actionProps = mkPropertyValues(props)
+        xfunc.executeAction("SELECT", actionProps)
+
+        propsA = {"TEXT": "range1"}
+        actionPropsA = mkPropertyValues(propsA)
+        xlbdataarea.executeAction("SELECT", actionPropsA)
+        xadd.executeAction("CLICK", tuple())
+        propsB = {"TEXT": "range2"}
+        actionPropsB = mkPropertyValues(propsB)
+        xlbdataarea.executeAction("SELECT", actionPropsB)
+        xadd.executeAction("CLICK", tuple())
+        propsC = {"TEXT": "range3"}
+        actionPropsC = mkPropertyValues(propsC)
+        xlbdataarea.executeAction("SELECT", actionPropsC)
+        xadd.executeAction("CLICK", tuple())
+        xbyrow.executeAction("CLICK", tuple())
+        xbycol.executeAction("CLICK", tuple())
+        xeddestarea.executeAction("TYPE", mkPropertyValues({"KEYCODE":"CTRL+A"}))
+        xeddestarea.executeAction("TYPE", mkPropertyValues({"KEYCODE":"BACKSPACE"}))
+        xeddestarea.executeAction("TYPE", mkPropertyValues({"TEXT":"$Total.$A$2"}))
+        xOKBtn = xDialog.getChild("ok")
+        self.ui_test.close_dialog_through_button(xOKBtn)
+        #verify
+        self.assertEqual(get_cell_by_position(document, 0, 1, 2).getValue(), 300)
+        self.assertEqual(get_cell_by_position(document, 0, 1, 3).getValue(), 303)
+        self.assertEqual(get_cell_by_position(document, 0, 1, 4).getValue(), 306)
+        self.assertEqual(get_cell_by_position(document, 0, 1, 5).getValue(), 309)
+
+        self.assertEqual(get_cell_by_position(document, 0, 2, 2).getValue(), 303)
+        self.assertEqual(get_cell_by_position(document, 0, 2, 3).getValue(), 306)
+        self.assertEqual(get_cell_by_position(document, 0, 2, 4).getValue(), 309)
+        self.assertEqual(get_cell_by_position(document, 0, 2, 5).getValue(), 312)
+
+        self.assertEqual(get_cell_by_position(document, 0, 3, 2).getValue(), 306)
+        self.assertEqual(get_cell_by_position(document, 0, 3, 3).getValue(), 309)
+        self.assertEqual(get_cell_by_position(document, 0, 3, 4).getValue(), 312)
+        self.assertEqual(get_cell_by_position(document, 0, 3, 5).getValue(), 315)
+
+        self.assertEqual(get_cell_by_position(document, 0, 4, 2).getValue(), 309)
+        self.assertEqual(get_cell_by_position(document, 0, 4, 3).getValue(), 312)
+        self.assertEqual(get_cell_by_position(document, 0, 4, 4).getValue(), 315)
+        self.assertEqual(get_cell_by_position(document, 0, 4, 5).getValue(), 318)
+        #verify dialog
+        self.ui_test.execute_modeless_dialog_through_command(".uno:DataConsolidate")
+        xDialog = self.xUITest.getTopFocusWindow()
+        xfunc = xDialog.getChild("func")
+        xlbdataarea = xDialog.getChild("lbdataarea")
+        xdelete = xDialog.getChild("delete")
+        xbyrow = xDialog.getChild("byrow")
+        xbycol = xDialog.getChild("bycol")
+        xeddestarea = xDialog.getChild("eddestarea")
+        xconsareas = xDialog.getChild("consareas")
+        self.assertEqual(get_state_as_dict(xfunc)["SelectEntryText"], "Sum")
+        self.assertEqual(get_state_as_dict(xconsareas)["Children"], "3")
+        self.assertEqual(get_state_as_dict(xeddestarea)["Text"], "$Total.$A$2")
+        self.assertEqual(get_state_as_dict(xbyrow)["Selected"], "true")
+        self.assertEqual(get_state_as_dict(xbycol)["Selected"], "true")
+        #delete first range
+        xFirstEntry = xconsareas.getChild("0")
+        xFirstEntry.executeAction("SELECT", tuple())
+        xdelete.executeAction("CLICK", tuple())
+        self.assertEqual(get_state_as_dict(xconsareas)["Children"], "2")
+        xOKBtn = xDialog.getChild("ok")
+        self.ui_test.close_dialog_through_button(xOKBtn)
+
+        self.assertEqual(get_cell_by_position(document, 0, 1, 2).getValue(), 200)
+        self.assertEqual(get_cell_by_position(document, 0, 1, 3).getValue(), 202)
+        self.assertEqual(get_cell_by_position(document, 0, 1, 4).getValue(), 204)
+        self.assertEqual(get_cell_by_position(document, 0, 1, 5).getValue(), 206)
+
+        self.assertEqual(get_cell_by_position(document, 0, 2, 2).getValue(), 202)
+        self.assertEqual(get_cell_by_position(document, 0, 2, 3).getValue(), 204)
+        self.assertEqual(get_cell_by_position(document, 0, 2, 4).getValue(), 206)
+        self.assertEqual(get_cell_by_position(document, 0, 2, 5).getValue(), 208)
+
+        self.assertEqual(get_cell_by_position(document, 0, 3, 2).getValue(), 204)
+        self.assertEqual(get_cell_by_position(document, 0, 3, 3).getValue(), 206)
+        self.assertEqual(get_cell_by_position(document, 0, 3, 4).getValue(), 208)
+        self.assertEqual(get_cell_by_position(document, 0, 3, 5).getValue(), 210)
+
+        self.assertEqual(get_cell_by_position(document, 0, 4, 2).getValue(), 206)
+        self.assertEqual(get_cell_by_position(document, 0, 4, 3).getValue(), 208)
+        self.assertEqual(get_cell_by_position(document, 0, 4, 4).getValue(), 210)
+        self.assertEqual(get_cell_by_position(document, 0, 4, 5).getValue(), 212)
+
+        # test cancel button
+        self.ui_test.execute_modeless_dialog_through_command(".uno:DataConsolidate")
+        xDialog = self.xUITest.getTopFocusWindow()
+        xCancelBtn = xDialog.getChild("cancel")
+        self.ui_test.close_dialog_through_button(xCancelBtn)
+
+        self.ui_test.close_doc()
+
+# vim: set shiftwidth=4 softtabstop=4 expandtab:
diff --git a/sc/qa/uitest/calc_tests2/dataform.py b/sc/qa/uitest/calc_tests2/dataform.py
new file mode 100644
index 000000000..0ffe0e70d
--- /dev/null
+++ b/sc/qa/uitest/calc_tests2/dataform.py
@@ -0,0 +1,27 @@
+# -*- tab-width: 4; indent-tabs-mode: nil; py-indent-offset: 4 -*-
+#
+# This Source Code Form is subject to the terms of the Mozilla Public
+# 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/.
+#
+from uitest.framework import UITestCase
+from libreoffice.uno.propertyvalue import mkPropertyValues
+import org.libreoffice.unotest
+
+#dataformdialog.ui
+class dataform(UITestCase):
+    def test_dataform(self):
+        calc_doc = self.ui_test.create_doc_in_start_center("calc")
+
+        xCalcDoc = self.xUITest.getTopFocusWindow()
+        gridwin = xCalcDoc.getChild("grid_window")
+        gridwin.executeAction("SELECT", mkPropertyValues({"RANGE": "A1:A10"}))
+
+        self.ui_test.execute_dialog_through_command(".uno:DataForm")
+        xDialog = self.xUITest.getTopFocusWindow()
+
+        xCloseBtn = xDialog.getChild("close")
+        self.ui_test.close_dialog_through_button(xCloseBtn)
+        self.ui_test.close_doc()
+
+# vim: set shiftwidth=4 softtabstop=4 expandtab:
diff --git a/sc/qa/uitest/calc_tests2/stableSorting.py b/sc/qa/uitest/calc_tests2/stableSorting.py
new file mode 100644
index 000000000..986c7cc3d
--- /dev/null
+++ b/sc/qa/uitest/calc_tests2/stableSorting.py
@@ -0,0 +1,104 @@
+# -*- tab-width: 4; indent-tabs-mode: nil; py-indent-offset: 4 -*-
+#
+# This Source Code Form is subject to the terms of the Mozilla Public
+# 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 org.libreoffice.unotest
+import pathlib
+from uitest.framework import UITestCase
+from uitest.uihelper.common import get_state_as_dict
+from uitest.uihelper.common import select_pos
+from uitest.uihelper.calc import enter_text_to_cell
+from libreoffice.calc.document import get_sheet_from_doc
+from libreoffice.calc.conditional_format import get_conditional_format_from_sheet
+from uitest.debug import sleep
+from libreoffice.calc.document import get_cell_by_position
+from libreoffice.uno.propertyvalue import mkPropertyValues
+#Testcases Sorting TCS_Sorting Stable sorting
+def get_url_for_data_file(file_name):
+    return pathlib.Path(org.libreoffice.unotest.makeCopyFromTDOC(file_name)).as_uri()
+
+class CalcStableSorting(UITestCase):
+
+    def test_Must_keep_sort_order_previous_sorting_toolbar_button_Ascending(self):
+        calc_doc = self.ui_test.load_file(get_url_for_data_file("stableSorting.ods"))
+        xCalcDoc = self.xUITest.getTopFocusWindow()
+        gridwin = xCalcDoc.getChild("grid_window")
+        document = self.ui_test.get_component()
+        #Select cell E1 ("Sales") and press toolbar button for ascending sorting.
+        gridwin.executeAction("SELECT", mkPropertyValues({"CELL": "E1"}))
+        self.xUITest.executeCommand(".uno:SortAscending")
+        #Select cell D1 ("Product") and press toolbar button for ascending sorting.
+        gridwin.executeAction("SELECT", mkPropertyValues({"CELL": "D1"}))
+        self.xUITest.executeCommand(".uno:SortAscending")
+        #Select cell C1 ("Salesman") and press toolbar button for ascending sorting.
+        gridwin.executeAction("SELECT", mkPropertyValues({"CELL": "C1"}))
+        self.xUITest.executeCommand(".uno:SortAscending")
+        # Select cell B1 ("Region") and press toolbar button for ascending sorting.
+        gridwin.executeAction("SELECT", mkPropertyValues({"CELL": "B1"}))
+        self.xUITest.executeCommand(".uno:SortAscending")
+        #Verify that the numbers in column "CheckOrder" are ascending
+        for i in range(1, 501):
+            self.assertEqual(get_cell_by_position(document, 0, 5, i).getValue(), i)
+        self.ui_test.close_doc()
+
+    def test_Must_keep_sort_order_previous_sorting_toolbar_button_Descending(self):
+        calc_doc = self.ui_test.load_file(get_url_for_data_file("stableSorting.ods"))
+        xCalcDoc = self.xUITest.getTopFocusWindow()
+        gridwin = xCalcDoc.getChild("grid_window")
+        document = self.ui_test.get_component()
+        #Select cell E1 ("Sales") and press toolbar button for descending sorting.
+        gridwin.executeAction("SELECT", mkPropertyValues({"CELL": "E1"}))
+        self.xUITest.executeCommand(".uno:SortDescending")
+        #Select cell D1 ("Product") and press toolbar button for descending sorting.
+        gridwin.executeAction("SELECT", mkPropertyValues({"CELL": "D1"}))
+        self.xUITest.executeCommand(".uno:SortDescending")
+        #Select cell C1 ("Salesman") and press toolbar button for descending sorting.
+        gridwin.executeAction("SELECT", mkPropertyValues({"CELL": "C1"}))
+        self.xUITest.executeCommand(".uno:SortDescending")
+        # Select cell B1 ("Region") and press toolbar button for descending sorting.
+        gridwin.executeAction("SELECT", mkPropertyValues({"CELL": "B1"}))
+        self.xUITest.executeCommand(".uno:SortDescending")
+        #Verify that the numbers in column "CheckOrder" are ascending
+        for i in range(1, 501):
+            j = 501 - i
+            self.assertEqual(get_cell_by_position(document, 0, 5, i).getValue(), j)
+        self.ui_test.close_doc()
+
+    # def test_Must_keep_sort_order_previous_sorting_using_sort_dialog(self):
+#   cannot test for now - criteria names are identical - Markus https://gerrit.libreoffice.org/#/c/52534/
+        # calc_doc = self.ui_test.load_file(get_url_for_data_file("stableSorting.ods"))
+        # xCalcDoc = self.xUITest.getTopFocusWindow()
+        # gridwin = xCalcDoc.getChild("grid_window")
+        # document = self.ui_test.get_component()
+#        Select cell A1 and open sort dialog by DATA - SORT
+        # gridwin.executeAction("SELECT", mkPropertyValues({"CELL": "A1"}))
+#        Open sort dialog by DATA - SORT /Switch to tabpage Options
+        # self.ui_test.execute_dialog_through_command(".uno:DataSort")
+        # xDialog = self.xUITest.getTopFocusWindow()
+        # xTabs = xDialog.getChild("tabcontrol")
+        # select_pos(xTabs, "1")
+#        Check option "Range contains column labels"
+        # xHeader = xDialog.getChild("header")
+        # self.assertEqual(get_state_as_dict(xHeader)["Selected"], "true")
+#        Switch to tabpage "Sort Criteria"
+        # select_pos(xTabs, "0")
+#        Choose "Salesman(ascending)" as first criteria
+        # xSortKey1 = xDialog.getChild("sortlb")
+        # xAsc = xDialog.getChild("up")
+        # props = {"TEXT": "Salesman"}
+        # actionProps = mkPropertyValues(props)
+        # xSortKey1.executeAction("SELECT", actionProps)
+        # self.assertEqual(get_state_as_dict(xAsc)["Checked"], "true")
+        #Choose "Product (ascending)" as second criteria
+        # xSortKey2 = xDialog.getChild("sortuserlb")
+        # xAsc = xDialog.getChild("up")
+        # props = {"TEXT": "Salesman"}
+        # actionProps = mkPropertyValues(props)
+        # xSortKey1.executeAction("SELECT", actionProps)
+        # self.assertEqual(get_state_as_dict(xAsc)["Checked"], "true")
+        # self.ui_test.close_doc()
+
+# vim: set shiftwidth=4 softtabstop=4 expandtab:
diff --git a/sc/qa/uitest/calc_tests2/standardFilter.py b/sc/qa/uitest/calc_tests2/standardFilter.py
new file mode 100644
index 000000000..6519fe6af
--- /dev/null
+++ b/sc/qa/uitest/calc_tests2/standardFilter.py
@@ -0,0 +1,743 @@
+# -*- tab-width: 4; indent-tabs-mode: nil; py-indent-offset: 4 -*-
+#
+# This Source Code Form is subject to the terms of the Mozilla Public
+# 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/.
+#
+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
+import org.libreoffice.unotest
+import pathlib
+#Bug 113979 - Paste unformatted text does not ignore empty cells
+def get_url_for_data_file(file_name):
+    return pathlib.Path(org.libreoffice.unotest.makeCopyFromTDOC(file_name)).as_uri()
+
+class standardFilter(UITestCase):
+    def test_standard_filter(self):
+        calc_doc = self.ui_test.load_file(get_url_for_data_file("standardFilter.ods"))
+        xCalcDoc = self.xUITest.getTopFocusWindow()
+        gridwin = xCalcDoc.getChild("grid_window")
+        document = self.ui_test.get_component()
+        gridwin.executeAction("SELECT", mkPropertyValues({"RANGE": "A1:C8"}))
+
+        self.ui_test.execute_modeless_dialog_through_command(".uno:DataFilterStandardFilter")
+        xDialog = self.xUITest.getTopFocusWindow()
+        xfield1 = xDialog.getChild("field1")
+        xval1 = xDialog.getChild("val1")
+        xconnect2 = xDialog.getChild("connect2")
+        xfield2 = xDialog.getChild("field2")
+        xval2 = xDialog.getChild("val2")
+
+        props = {"TEXT": "a"}
+        actionProps = mkPropertyValues(props)
+        xfield1.executeAction("SELECT", actionProps)
+        xval1.executeAction("TYPE", mkPropertyValues({"TEXT":"1"}))
+        propsA = {"TEXT": "OR"}
+        actionPropsA = mkPropertyValues(propsA)
+        xconnect2.executeAction("SELECT", actionPropsA)
+        props2 = {"TEXT": "b"}
+        actionProps2 = mkPropertyValues(props2)
+        xfield2.executeAction("SELECT", actionProps2)
+        xval2.executeAction("TYPE", mkPropertyValues({"TEXT":"3"}))
+        xOKBtn = xDialog.getChild("ok")
+        self.ui_test.close_dialog_through_button(xOKBtn)
+        #3x down - should be on row 9
+        gridwin.executeAction("SELECT", mkPropertyValues({"CELL": "A1"}))
+        gridwin.executeAction("TYPE", mkPropertyValues({"KEYCODE": "DOWN"}))
+        gridwin.executeAction("TYPE", mkPropertyValues({"KEYCODE": "DOWN"}))
+        gridwin.executeAction("TYPE", mkPropertyValues({"KEYCODE": "DOWN"}))
+        gridWinState = get_state_as_dict(gridwin)
+        self.assertEqual(gridWinState["CurrentRow"], "8")
+        #reopen filter and verify
+        gridwin.executeAction("TYPE", mkPropertyValues({"KEYCODE": "UP"}))
+        gridwin.executeAction("TYPE", mkPropertyValues({"KEYCODE": "UP"}))
+        gridwin.executeAction("TYPE", mkPropertyValues({"KEYCODE": "UP"}))
+        self.ui_test.execute_modeless_dialog_through_command(".uno:DataFilterStandardFilter")
+        xDialog = self.xUITest.getTopFocusWindow()
+        xfield1 = xDialog.getChild("field1")
+        xval1 = xDialog.getChild("val1")
+        xconnect2 = xDialog.getChild("connect2")
+        xfield2 = xDialog.getChild("field2")
+        xval2 = xDialog.getChild("val2")
+
+        self.assertEqual(get_state_as_dict(xfield1)["SelectEntryText"], "a")
+        self.assertEqual(get_state_as_dict(xfield2)["SelectEntryText"], "b")
+        self.assertEqual(get_state_as_dict(xconnect2)["SelectEntryText"], "OR")
+        self.assertEqual(get_state_as_dict(xval1)["Text"], "1")
+        self.assertEqual(get_state_as_dict(xval2)["Text"], "3")
+        xOKBtn = xDialog.getChild("ok")
+        self.ui_test.close_dialog_through_button(xOKBtn)
+        self.ui_test.close_doc()
+
+    def test_standard_filter_copy_result(self):
+        calc_doc = self.ui_test.load_file(get_url_for_data_file("standardFilter.ods"))
+        xCalcDoc = self.xUITest.getTopFocusWindow()
+        gridwin = xCalcDoc.getChild("grid_window")
+        document = self.ui_test.get_component()
+        gridwin.executeAction("SELECT", mkPropertyValues({"RANGE": "A1:C8"}))
+
+        self.ui_test.execute_modeless_dialog_through_command(".uno:DataFilterStandardFilter")
+        xDialog = self.xUITest.getTopFocusWindow()
+        xfield1 = xDialog.getChild("field1")
+        xval1 = xDialog.getChild("val1")
+        xconnect2 = xDialog.getChild("connect2")
+        xfield2 = xDialog.getChild("field2")
+        xval2 = xDialog.getChild("val2")
+        xcopyresult = xDialog.getChild("copyresult")
+        xedcopyarea = xDialog.getChild("edcopyarea")
+        props = {"TEXT": "a"}
+        actionProps = mkPropertyValues(props)
+        xfield1.executeAction("SELECT", actionProps)
+        xval1.executeAction("TYPE", mkPropertyValues({"TEXT":"1"}))
+        propsA = {"TEXT": "OR"}
+        actionPropsA = mkPropertyValues(propsA)
+        xconnect2.executeAction("SELECT", actionPropsA)
+        props2 = {"TEXT": "b"}
+        actionProps2 = mkPropertyValues(props2)
+        xfield2.executeAction("SELECT", actionProps2)
+        xval2.executeAction("TYPE", mkPropertyValues({"TEXT":"3"}))
+        xcopyresult.executeAction("CLICK", tuple())
+        xedcopyarea.executeAction("TYPE", mkPropertyValues({"TEXT":"F1"}))
+        xOKBtn = xDialog.getChild("ok")
+        self.ui_test.close_dialog_through_button(xOKBtn)
+        #verify
+        self.assertEqual(get_cell_by_position(document, 0, 5, 0).getString(), "a")
+        self.assertEqual(get_cell_by_position(document, 0, 6, 0).getString(), "b")
+        self.assertEqual(get_cell_by_position(document, 0, 7, 0).getString(), "c")
+        self.assertEqual(get_cell_by_position(document, 0, 5, 1).getValue(), 1)
+        self.assertEqual(get_cell_by_position(document, 0, 6, 1).getValue(), 2)
+        self.assertEqual(get_cell_by_position(document, 0, 7, 1).getValue(), 3)
+        self.assertEqual(get_cell_by_position(document, 0, 5, 2).getValue(), 2)
+        self.assertEqual(get_cell_by_position(document, 0, 6, 2).getValue(), 3)
+        self.assertEqual(get_cell_by_position(document, 0, 7, 2).getValue(), 4)
+        self.ui_test.close_doc()
+
+    def test_standard_filter_copy_result_next_sheet(self):
+        calc_doc = self.ui_test.load_file(get_url_for_data_file("standardFilter.ods"))
+        xCalcDoc = self.xUITest.getTopFocusWindow()
+        gridwin = xCalcDoc.getChild("grid_window")
+        document = self.ui_test.get_component()
+        gridwin.executeAction("SELECT", mkPropertyValues({"RANGE": "A1:C8"}))
+
+        self.ui_test.execute_modeless_dialog_through_command(".uno:DataFilterStandardFilter")
+        xDialog = self.xUITest.getTopFocusWindow()
+        xfield1 = xDialog.getChild("field1")
+        xval1 = xDialog.getChild("val1")
+        xconnect2 = xDialog.getChild("connect2")
+        xfield2 = xDialog.getChild("field2")
+        xval2 = xDialog.getChild("val2")
+        xcopyresult = xDialog.getChild("copyresult")
+        xedcopyarea = xDialog.getChild("edcopyarea")
+        props = {"TEXT": "a"}
+        actionProps = mkPropertyValues(props)
+        xfield1.executeAction("SELECT", actionProps)
+        xval1.executeAction("TYPE", mkPropertyValues({"TEXT":"1"}))
+        propsA = {"TEXT": "OR"}
+        actionPropsA = mkPropertyValues(propsA)
+        xconnect2.executeAction("SELECT", actionPropsA)
+        props2 = {"TEXT": "b"}
+        actionProps2 = mkPropertyValues(props2)
+        xfield2.executeAction("SELECT", actionProps2)
+        xval2.executeAction("TYPE", mkPropertyValues({"TEXT":"3"}))
+        xcopyresult.executeAction("CLICK", tuple())
+        xedcopyarea.executeAction("TYPE", mkPropertyValues({"TEXT":"$Sheet2.$F$1"}))
+        xOKBtn = xDialog.getChild("ok")
+        self.ui_test.close_dialog_through_button(xOKBtn)
+        #verify
+        self.assertEqual(get_cell_by_position(document, 1, 5, 0).getString(), "a")
+        self.assertEqual(get_cell_by_position(document, 1, 6, 0).getString(), "b")
+        self.assertEqual(get_cell_by_position(document, 1, 7, 0).getString(), "c")
+        self.assertEqual(get_cell_by_position(document, 1, 5, 1).getValue(), 1)
+        self.assertEqual(get_cell_by_position(document, 1, 6, 1).getValue(), 2)
+        self.assertEqual(get_cell_by_position(document, 1, 7, 1).getValue(), 3)
+        self.assertEqual(get_cell_by_position(document, 1, 5, 2).getValue(), 2)
+        self.assertEqual(get_cell_by_position(document, 1, 6, 2).getValue(), 3)
+        self.assertEqual(get_cell_by_position(document, 1, 7, 2).getValue(), 4)
+        self.ui_test.close_doc()
+
+    def test_standard_filter_case_sensitive(self):
+        calc_doc = self.ui_test.create_doc_in_start_center("calc")
+        xCalcDoc = self.xUITest.getTopFocusWindow()
+        gridwin = xCalcDoc.getChild("grid_window")
+        document = self.ui_test.get_component()
+
+        enter_text_to_cell(gridwin, "A1", "first")
+        enter_text_to_cell(gridwin, "B1", "second")
+        enter_text_to_cell(gridwin, "A2", "a1")
+        enter_text_to_cell(gridwin, "A3", "A1")
+        enter_text_to_cell(gridwin, "A4", "A1")
+        enter_text_to_cell(gridwin, "B2", "4")
+        enter_text_to_cell(gridwin, "B3", "5")
+        enter_text_to_cell(gridwin, "B4", "6")
+        gridwin.executeAction("SELECT", mkPropertyValues({"RANGE": "A1:B4"}))
+        self.ui_test.execute_modeless_dialog_through_command(".uno:DataFilterStandardFilter")
+        xDialog = self.xUITest.getTopFocusWindow()
+        xfield1 = xDialog.getChild("field1")
+        xval1 = xDialog.getChild("val1")
+        xcase = xDialog.getChild("case")
+
+        props = {"TEXT": "first"}
+        actionProps = mkPropertyValues(props)
+        xfield1.executeAction("SELECT", actionProps)
+        xval1.executeAction("TYPE", mkPropertyValues({"TEXT":"a1"}))
+        xcase.executeAction("CLICK", tuple())
+        xOKBtn = xDialog.getChild("ok")
+        self.ui_test.close_dialog_through_button(xOKBtn)
+        #2x down - should be on row 5
+        gridwin.executeAction("SELECT", mkPropertyValues({"CELL": "A1"}))
+        gridwin.executeAction("TYPE", mkPropertyValues({"KEYCODE": "DOWN"}))
+        gridwin.executeAction("TYPE", mkPropertyValues({"KEYCODE": "DOWN"}))
+        gridWinState = get_state_as_dict(gridwin)
+        self.assertEqual(gridWinState["CurrentRow"], "4")
+        #reopen filter and verify
+        gridwin.executeAction("TYPE", mkPropertyValues({"KEYCODE": "UP"}))
+        gridwin.executeAction("TYPE", mkPropertyValues({"KEYCODE": "UP"}))
+        self.ui_test.execute_modeless_dialog_through_command(".uno:DataFilterStandardFilter")
+        xDialog = self.xUITest.getTopFocusWindow()
+        xfield1 = xDialog.getChild("field1")
+        xval1 = xDialog.getChild("val1")
+        xcase = xDialog.getChild("case")
+
+        self.assertEqual(get_state_as_dict(xfield1)["SelectEntryText"], "first")
+        self.assertEqual(get_state_as_dict(xval1)["Text"], "a1")
+        self.assertEqual(get_state_as_dict(xcase)["Selected"], "true")
+        xOKBtn = xDialog.getChild("ok")
+        self.ui_test.close_dialog_through_button(xOKBtn)
+        self.ui_test.close_doc()
+
+    def test_standard_filter_regular_expression(self):
+        calc_doc = self.ui_test.create_doc_in_start_center("calc")
+        xCalcDoc = self.xUITest.getTopFocusWindow()
+        gridwin = xCalcDoc.getChild("grid_window")
+        document = self.ui_test.get_component()
+
+        enter_text_to_cell(gridwin, "A1", "first")
+        enter_text_to_cell(gridwin, "B1", "second")
+        enter_text_to_cell(gridwin, "A2", "aa")
+        enter_text_to_cell(gridwin, "A3", "aaa")
+        enter_text_to_cell(gridwin, "A4", "abbb")
+        enter_text_to_cell(gridwin, "A5", "accc")
+        enter_text_to_cell(gridwin, "A6", "a*")
+        enter_text_to_cell(gridwin, "B2", "1")
+        enter_text_to_cell(gridwin, "B3", "2")
+        enter_text_to_cell(gridwin, "B4", "3")
+        enter_text_to_cell(gridwin, "B5", "4")
+        enter_text_to_cell(gridwin, "B6", "5")
+        gridwin.executeAction("SELECT", mkPropertyValues({"RANGE": "A1:B6"}))
+        self.ui_test.execute_modeless_dialog_through_command(".uno:DataFilterStandardFilter")
+        xDialog = self.xUITest.getTopFocusWindow()
+        xfield1 = xDialog.getChild("field1")
+        xval1 = xDialog.getChild("val1")
+        xregexp = xDialog.getChild("regexp")
+
+        props = {"TEXT": "first"}
+        actionProps = mkPropertyValues(props)
+        xfield1.executeAction("SELECT", actionProps)
+        xval1.executeAction("TYPE", mkPropertyValues({"TEXT":"a*"}))
+        xregexp.executeAction("CLICK", tuple())
+        xOKBtn = xDialog.getChild("ok")
+        self.ui_test.close_dialog_through_button(xOKBtn)
+        #3x down - should be on row 7
+        gridwin.executeAction("SELECT", mkPropertyValues({"CELL": "A1"}))
+        gridwin.executeAction("TYPE", mkPropertyValues({"KEYCODE": "DOWN"}))
+        gridwin.executeAction("TYPE", mkPropertyValues({"KEYCODE": "DOWN"}))
+        gridwin.executeAction("TYPE", mkPropertyValues({"KEYCODE": "DOWN"}))
+        gridWinState = get_state_as_dict(gridwin)
+        self.assertEqual(gridWinState["CurrentRow"], "6")
+        #reopen filter and verify
+        gridwin.executeAction("TYPE", mkPropertyValues({"KEYCODE": "UP"}))
+        gridwin.executeAction("TYPE", mkPropertyValues({"KEYCODE": "UP"}))
+        gridwin.executeAction("TYPE", mkPropertyValues({"KEYCODE": "UP"}))
+        self.ui_test.execute_modeless_dialog_through_command(".uno:DataFilterStandardFilter")
+        xDialog = self.xUITest.getTopFocusWindow()
+        xfield1 = xDialog.getChild("field1")
+        xval1 = xDialog.getChild("val1")
+        xregexp = xDialog.getChild("regexp")
+
+        self.assertEqual(get_state_as_dict(xfield1)["SelectEntryText"], "first")
+        self.assertEqual(get_state_as_dict(xval1)["Text"], "a*")
+        self.assertEqual(get_state_as_dict(xregexp)["Selected"], "true")
+        xOKBtn = xDialog.getChild("ok")
+        self.ui_test.close_dialog_through_button(xOKBtn)
+        self.ui_test.close_doc()
+
+    def test_standard_filter_condition_contains(self):
+        calc_doc = self.ui_test.create_doc_in_start_center("calc")
+        xCalcDoc = self.xUITest.getTopFocusWindow()
+        gridwin = xCalcDoc.getChild("grid_window")
+        document = self.ui_test.get_component()
+
+        enter_text_to_cell(gridwin, "A1", "first")
+        enter_text_to_cell(gridwin, "B1", "second")
+        enter_text_to_cell(gridwin, "A2", "aa")
+        enter_text_to_cell(gridwin, "A3", "aaa")
+        enter_text_to_cell(gridwin, "A4", "abbb")
+        enter_text_to_cell(gridwin, "A5", "accc")
+        enter_text_to_cell(gridwin, "A6", "a*")
+        enter_text_to_cell(gridwin, "B2", "1")
+        enter_text_to_cell(gridwin, "B3", "2")
+        enter_text_to_cell(gridwin, "B4", "3")
+        enter_text_to_cell(gridwin, "B5", "4")
+        enter_text_to_cell(gridwin, "B6", "5")
+        gridwin.executeAction("SELECT", mkPropertyValues({"RANGE": "A1:B6"}))
+        self.ui_test.execute_modeless_dialog_through_command(".uno:DataFilterStandardFilter")
+        xDialog = self.xUITest.getTopFocusWindow()
+        xfield1 = xDialog.getChild("field1")
+        xval1 = xDialog.getChild("val1")
+        xregexp = xDialog.getChild("regexp")
+
+        props = {"TEXT": "first"}
+        actionProps = mkPropertyValues(props)
+        xfield1.executeAction("SELECT", actionProps)
+        xval1.executeAction("TYPE", mkPropertyValues({"TEXT":"a*"}))
+        xregexp.executeAction("CLICK", tuple())
+        xOKBtn = xDialog.getChild("ok")
+        self.ui_test.close_dialog_through_button(xOKBtn)
+        #3x down - should be on row 7
+        gridwin.executeAction("SELECT", mkPropertyValues({"CELL": "A1"}))
+        gridwin.executeAction("TYPE", mkPropertyValues({"KEYCODE": "DOWN"}))
+        gridwin.executeAction("TYPE", mkPropertyValues({"KEYCODE": "DOWN"}))
+        gridwin.executeAction("TYPE", mkPropertyValues({"KEYCODE": "DOWN"}))
+        gridWinState = get_state_as_dict(gridwin)
+        self.assertEqual(gridWinState["CurrentRow"], "6")
+        #reopen filter and verify
+        gridwin.executeAction("TYPE", mkPropertyValues({"KEYCODE": "UP"}))
+        gridwin.executeAction("TYPE", mkPropertyValues({"KEYCODE": "UP"}))
+        gridwin.executeAction("TYPE", mkPropertyValues({"KEYCODE": "UP"}))
+        self.ui_test.execute_modeless_dialog_through_command(".uno:DataFilterStandardFilter")
+        xDialog = self.xUITest.getTopFocusWindow()
+        xfield1 = xDialog.getChild("field1")
+        xval1 = xDialog.getChild("val1")
+        xregexp = xDialog.getChild("regexp")
+
+        self.assertEqual(get_state_as_dict(xfield1)["SelectEntryText"], "first")
+        self.assertEqual(get_state_as_dict(xval1)["Text"], "a*")
+        self.assertEqual(get_state_as_dict(xregexp)["Selected"], "true")
+        xOKBtn = xDialog.getChild("ok")
+        self.ui_test.close_dialog_through_button(xOKBtn)
+        self.ui_test.close_doc()
+
+        #from testcasespecification OOo
+    def test_standard_filter_condition_contains2(self):
+        calc_doc = self.ui_test.create_doc_in_start_center("calc")
+        xCalcDoc = self.xUITest.getTopFocusWindow()
+        gridwin = xCalcDoc.getChild("grid_window")
+        document = self.ui_test.get_component()
+
+        enter_text_to_cell(gridwin, "A1", "A")
+        enter_text_to_cell(gridwin, "B1", "B")
+        enter_text_to_cell(gridwin, "C1", "C")
+        enter_text_to_cell(gridwin, "D1", "D")
+        enter_text_to_cell(gridwin, "A2", "economics")
+        enter_text_to_cell(gridwin, "B2", "34")
+        enter_text_to_cell(gridwin, "C2", "67")
+        enter_text_to_cell(gridwin, "D2", "122")
+        enter_text_to_cell(gridwin, "A3", "socioeconomic")
+        enter_text_to_cell(gridwin, "B3", "45")
+        enter_text_to_cell(gridwin, "C3", "77")
+        enter_text_to_cell(gridwin, "D3", "333")
+        enter_text_to_cell(gridwin, "A4", "sociology")
+        enter_text_to_cell(gridwin, "B4", "78")
+        enter_text_to_cell(gridwin, "C4", "89")
+        enter_text_to_cell(gridwin, "D4", "56")
+        enter_text_to_cell(gridwin, "A5", "humanities")
+        enter_text_to_cell(gridwin, "B5", "45")
+        enter_text_to_cell(gridwin, "C5", "67")
+        enter_text_to_cell(gridwin, "D5", "89")
+        #Select
+        gridwin.executeAction("SELECT", mkPropertyValues({"RANGE": "A1:D5"}))
+        #Choose DATA-FILTER-STANDARDFILTER
+        #Choose field name "A"/ Choose condition "Contains"/Enter value "cio"/Press OK button
+        self.ui_test.execute_modeless_dialog_through_command(".uno:DataFilterStandardFilter")
+        xDialog = self.xUITest.getTopFocusWindow()
+        xfield1 = xDialog.getChild("field1")
+        xval1 = xDialog.getChild("val1")
+        xcond1 = xDialog.getChild("cond1")
+
+        props = {"TEXT": "A"}
+        actionProps = mkPropertyValues(props)
+        xfield1.executeAction("SELECT", actionProps)
+        props2 = {"TEXT": "Contains"}
+        actionProps2 = mkPropertyValues(props2)
+        xcond1.executeAction("SELECT", actionProps2)
+        xval1.executeAction("TYPE", mkPropertyValues({"TEXT":"cio"}))
+        xOKBtn = xDialog.getChild("ok")
+        self.ui_test.close_dialog_through_button(xOKBtn)
+
+        #Verify that row 1,3, 4 are visible (2 and 5 are hidden)
+        gridwin.executeAction("SELECT", mkPropertyValues({"CELL": "A1"}))
+        gridwin.executeAction("TYPE", mkPropertyValues({"KEYCODE": "DOWN"}))
+        gridWinState = get_state_as_dict(gridwin)
+        self.assertEqual(gridWinState["CurrentRow"], "2")
+        gridwin.executeAction("TYPE", mkPropertyValues({"KEYCODE": "DOWN"}))
+        gridWinState = get_state_as_dict(gridwin)
+        self.assertEqual(gridWinState["CurrentRow"], "3")
+        #reopen filter and verify
+        gridwin.executeAction("TYPE", mkPropertyValues({"KEYCODE": "UP"}))
+        gridwin.executeAction("TYPE", mkPropertyValues({"KEYCODE": "UP"}))
+        self.ui_test.execute_modeless_dialog_through_command(".uno:DataFilterStandardFilter")
+        xDialog = self.xUITest.getTopFocusWindow()
+        xfield1 = xDialog.getChild("field1")
+        xval1 = xDialog.getChild("val1")
+        xcond1 = xDialog.getChild("cond1")
+        self.assertEqual(get_state_as_dict(xfield1)["SelectEntryText"], "A")
+        self.assertEqual(get_state_as_dict(xval1)["Text"], "cio")
+        self.assertEqual(get_state_as_dict(xcond1)["SelectEntryText"], "Contains")
+        xCancelBtn = xDialog.getChild("cancel")
+        self.ui_test.close_dialog_through_button(xCancelBtn)
+        self.ui_test.close_doc()
+
+    def test_standard_filter_condition_does_not_contains(self):
+        calc_doc = self.ui_test.create_doc_in_start_center("calc")
+        xCalcDoc = self.xUITest.getTopFocusWindow()
+        gridwin = xCalcDoc.getChild("grid_window")
+        document = self.ui_test.get_component()
+
+        enter_text_to_cell(gridwin, "A1", "A")
+        enter_text_to_cell(gridwin, "B1", "B")
+        enter_text_to_cell(gridwin, "C1", "C")
+        enter_text_to_cell(gridwin, "D1", "D")
+        enter_text_to_cell(gridwin, "A2", "economics")
+        enter_text_to_cell(gridwin, "B2", "34")
+        enter_text_to_cell(gridwin, "C2", "67")
+        enter_text_to_cell(gridwin, "D2", "122")
+        enter_text_to_cell(gridwin, "A3", "socioeconomic")
+        enter_text_to_cell(gridwin, "B3", "45")
+        enter_text_to_cell(gridwin, "C3", "77")
+        enter_text_to_cell(gridwin, "D3", "333")
+        enter_text_to_cell(gridwin, "A4", "sociology")
+        enter_text_to_cell(gridwin, "B4", "78")
+        enter_text_to_cell(gridwin, "C4", "89")
+        enter_text_to_cell(gridwin, "D4", "56")
+        enter_text_to_cell(gridwin, "A5", "humanities")
+        enter_text_to_cell(gridwin, "B5", "45")
+        enter_text_to_cell(gridwin, "C5", "67")
+        enter_text_to_cell(gridwin, "D5", "89")
+        #Select
+        gridwin.executeAction("SELECT", mkPropertyValues({"RANGE": "A1:D5"}))
+        #Choose DATA-FILTER-STANDARDFILTER
+        #Choose field name "A"/ Choose condition "Does not contain"/Enter value "cio"/Press OK button
+        self.ui_test.execute_modeless_dialog_through_command(".uno:DataFilterStandardFilter")
+        xDialog = self.xUITest.getTopFocusWindow()
+        xfield1 = xDialog.getChild("field1")
+        xval1 = xDialog.getChild("val1")
+        xcond1 = xDialog.getChild("cond1")
+
+        props = {"TEXT": "A"}
+        actionProps = mkPropertyValues(props)
+        xfield1.executeAction("SELECT", actionProps)
+        props2 = {"TEXT": "Does not contain"}
+        actionProps2 = mkPropertyValues(props2)
+        xcond1.executeAction("SELECT", actionProps2)
+        xval1.executeAction("TYPE", mkPropertyValues({"TEXT":"cio"}))
+        xOKBtn = xDialog.getChild("ok")
+        self.ui_test.close_dialog_through_button(xOKBtn)
+
+        #Verify that row 1,2, 5 are visible (3 and 4 are hidden)
+        gridwin.executeAction("SELECT", mkPropertyValues({"CELL": "A1"}))
+        gridwin.executeAction("TYPE", mkPropertyValues({"KEYCODE": "DOWN"}))
+        gridWinState = get_state_as_dict(gridwin)
+        self.assertEqual(gridWinState["CurrentRow"], "1")
+        gridwin.executeAction("TYPE", mkPropertyValues({"KEYCODE": "DOWN"}))
+        gridWinState = get_state_as_dict(gridwin)
+        self.assertEqual(gridWinState["CurrentRow"], "4")
+        #reopen filter and verify
+        gridwin.executeAction("TYPE", mkPropertyValues({"KEYCODE": "UP"}))
+        gridwin.executeAction("TYPE", mkPropertyValues({"KEYCODE": "UP"}))
+        self.ui_test.execute_modeless_dialog_through_command(".uno:DataFilterStandardFilter")
+        xDialog = self.xUITest.getTopFocusWindow()
+        xfield1 = xDialog.getChild("field1")
+        xval1 = xDialog.getChild("val1")
+        xcond1 = xDialog.getChild("cond1")
+        self.assertEqual(get_state_as_dict(xfield1)["SelectEntryText"], "A")
+        self.assertEqual(get_state_as_dict(xval1)["Text"], "cio")
+        self.assertEqual(get_state_as_dict(xcond1)["SelectEntryText"], "Does not contain")
+        xCancelBtn = xDialog.getChild("cancel")
+        self.ui_test.close_dialog_through_button(xCancelBtn)
+
+        self.ui_test.close_doc()
+
+    def test_standard_filter_condition_Begins_with(self):
+        calc_doc = self.ui_test.create_doc_in_start_center("calc")
+        xCalcDoc = self.xUITest.getTopFocusWindow()
+        gridwin = xCalcDoc.getChild("grid_window")
+        document = self.ui_test.get_component()
+
+        enter_text_to_cell(gridwin, "A1", "A")
+        enter_text_to_cell(gridwin, "B1", "B")
+        enter_text_to_cell(gridwin, "C1", "C")
+        enter_text_to_cell(gridwin, "D1", "D")
+        enter_text_to_cell(gridwin, "A2", "economics")
+        enter_text_to_cell(gridwin, "B2", "34")
+        enter_text_to_cell(gridwin, "C2", "67")
+        enter_text_to_cell(gridwin, "D2", "122")
+        enter_text_to_cell(gridwin, "A3", "socioeconomic")
+        enter_text_to_cell(gridwin, "B3", "45")
+        enter_text_to_cell(gridwin, "C3", "77")
+        enter_text_to_cell(gridwin, "D3", "333")
+        enter_text_to_cell(gridwin, "A4", "sociology")
+        enter_text_to_cell(gridwin, "B4", "78")
+        enter_text_to_cell(gridwin, "C4", "89")
+        enter_text_to_cell(gridwin, "D4", "56")
+        enter_text_to_cell(gridwin, "A5", "humanities")
+        enter_text_to_cell(gridwin, "B5", "45")
+        enter_text_to_cell(gridwin, "C5", "67")
+        enter_text_to_cell(gridwin, "D5", "89")
+        #Select
+        gridwin.executeAction("SELECT", mkPropertyValues({"RANGE": "A1:D5"}))
+        #Choose DATA-FILTER-STANDARDFILTER
+        #Choose field name "A"/ Choose condition "Begins with"/Enter value "si"/Press OK button
+        self.ui_test.execute_modeless_dialog_through_command(".uno:DataFilterStandardFilter")
+        xDialog = self.xUITest.getTopFocusWindow()
+        xfield1 = xDialog.getChild("field1")
+        xval1 = xDialog.getChild("val1")
+        xcond1 = xDialog.getChild("cond1")
+
+        props = {"TEXT": "A"}
+        actionProps = mkPropertyValues(props)
+        xfield1.executeAction("SELECT", actionProps)
+        props2 = {"TEXT": "Begins with"}
+        actionProps2 = mkPropertyValues(props2)
+        xcond1.executeAction("SELECT", actionProps2)
+        xval1.executeAction("TYPE", mkPropertyValues({"TEXT":"so"}))
+        xOKBtn = xDialog.getChild("ok")
+        self.ui_test.close_dialog_through_button(xOKBtn)
+
+        #Verify that row 1,3, 4 are visible (2 and 5 are hidden)
+        gridwin.executeAction("SELECT", mkPropertyValues({"CELL": "A1"}))
+        gridwin.executeAction("TYPE", mkPropertyValues({"KEYCODE": "DOWN"}))
+        gridWinState = get_state_as_dict(gridwin)
+        self.assertEqual(gridWinState["CurrentRow"], "2")
+        gridwin.executeAction("TYPE", mkPropertyValues({"KEYCODE": "DOWN"}))
+        gridWinState = get_state_as_dict(gridwin)
+        self.assertEqual(gridWinState["CurrentRow"], "3")
+        #reopen filter and verify
+        gridwin.executeAction("TYPE", mkPropertyValues({"KEYCODE": "UP"}))
+        gridwin.executeAction("TYPE", mkPropertyValues({"KEYCODE": "UP"}))
+        self.ui_test.execute_modeless_dialog_through_command(".uno:DataFilterStandardFilter")
+        xDialog = self.xUITest.getTopFocusWindow()
+        xfield1 = xDialog.getChild("field1")
+        xval1 = xDialog.getChild("val1")
+        xcond1 = xDialog.getChild("cond1")
+        self.assertEqual(get_state_as_dict(xfield1)["SelectEntryText"], "A")
+        self.assertEqual(get_state_as_dict(xval1)["Text"], "so")
+        self.assertEqual(get_state_as_dict(xcond1)["SelectEntryText"], "Begins with")
+        xCancelBtn = xDialog.getChild("cancel")
+        self.ui_test.close_dialog_through_button(xCancelBtn)
+
+        self.ui_test.close_doc()
+
+    def test_standard_filter_condition_Does_not_begin_with(self):
+        calc_doc = self.ui_test.create_doc_in_start_center("calc")
+        xCalcDoc = self.xUITest.getTopFocusWindow()
+        gridwin = xCalcDoc.getChild("grid_window")
+        document = self.ui_test.get_component()
+
+        enter_text_to_cell(gridwin, "A1", "A")
+        enter_text_to_cell(gridwin, "B1", "B")
+        enter_text_to_cell(gridwin, "C1", "C")
+        enter_text_to_cell(gridwin, "D1", "D")
+        enter_text_to_cell(gridwin, "A2", "economics")
+        enter_text_to_cell(gridwin, "B2", "34")
+        enter_text_to_cell(gridwin, "C2", "67")
+        enter_text_to_cell(gridwin, "D2", "122")
+        enter_text_to_cell(gridwin, "A3", "socioeconomic")
+        enter_text_to_cell(gridwin, "B3", "45")
+        enter_text_to_cell(gridwin, "C3", "77")
+        enter_text_to_cell(gridwin, "D3", "333")
+        enter_text_to_cell(gridwin, "A4", "sociology")
+        enter_text_to_cell(gridwin, "B4", "78")
+        enter_text_to_cell(gridwin, "C4", "89")
+        enter_text_to_cell(gridwin, "D4", "56")
+        enter_text_to_cell(gridwin, "A5", "humanities")
+        enter_text_to_cell(gridwin, "B5", "45")
+        enter_text_to_cell(gridwin, "C5", "67")
+        enter_text_to_cell(gridwin, "D5", "89")
+        #Select
+        gridwin.executeAction("SELECT", mkPropertyValues({"RANGE": "A1:D5"}))
+        #Choose DATA-FILTER-STANDARDFILTER
+        #Choose field name "A"/ Choose condition "Does not contain"/Enter value "cio"/Press OK button
+        self.ui_test.execute_modeless_dialog_through_command(".uno:DataFilterStandardFilter")
+        xDialog = self.xUITest.getTopFocusWindow()
+        xfield1 = xDialog.getChild("field1")
+        xval1 = xDialog.getChild("val1")
+        xcond1 = xDialog.getChild("cond1")
+
+        props = {"TEXT": "A"}
+        actionProps = mkPropertyValues(props)
+        xfield1.executeAction("SELECT", actionProps)
+        props2 = {"TEXT": "Does not begin with"}
+        actionProps2 = mkPropertyValues(props2)
+        xcond1.executeAction("SELECT", actionProps2)
+        xval1.executeAction("TYPE", mkPropertyValues({"TEXT":"so"}))
+        xOKBtn = xDialog.getChild("ok")
+        self.ui_test.close_dialog_through_button(xOKBtn)
+
+        #Verify that row 1,2, 5 are visible (3 and 4 are hidden)
+        gridwin.executeAction("SELECT", mkPropertyValues({"CELL": "A1"}))
+        gridwin.executeAction("TYPE", mkPropertyValues({"KEYCODE": "DOWN"}))
+        gridWinState = get_state_as_dict(gridwin)
+        self.assertEqual(gridWinState["CurrentRow"], "1")
+        gridwin.executeAction("TYPE", mkPropertyValues({"KEYCODE": "DOWN"}))
+        gridWinState = get_state_as_dict(gridwin)
+        self.assertEqual(gridWinState["CurrentRow"], "4")
+        #reopen filter and verify
+        gridwin.executeAction("TYPE", mkPropertyValues({"KEYCODE": "UP"}))
+        gridwin.executeAction("TYPE", mkPropertyValues({"KEYCODE": "UP"}))
+        self.ui_test.execute_modeless_dialog_through_command(".uno:DataFilterStandardFilter")
+        xDialog = self.xUITest.getTopFocusWindow()
+        xfield1 = xDialog.getChild("field1")
+        xval1 = xDialog.getChild("val1")
+        xcond1 = xDialog.getChild("cond1")
+        self.assertEqual(get_state_as_dict(xfield1)["SelectEntryText"], "A")
+        self.assertEqual(get_state_as_dict(xval1)["Text"], "so")
+        self.assertEqual(get_state_as_dict(xcond1)["SelectEntryText"], "Does not begin with")
+        xCancelBtn = xDialog.getChild("cancel")
+        self.ui_test.close_dialog_through_button(xCancelBtn)
+
+        self.ui_test.close_doc()
+
+    def test_standard_filter_condition_Ends_with(self):
+        calc_doc = self.ui_test.create_doc_in_start_center("calc")
+        xCalcDoc = self.xUITest.getTopFocusWindow()
+        gridwin = xCalcDoc.getChild("grid_window")
+        document = self.ui_test.get_component()
+
+        enter_text_to_cell(gridwin, "A1", "A")
+        enter_text_to_cell(gridwin, "B1", "B")
+        enter_text_to_cell(gridwin, "C1", "C")
+        enter_text_to_cell(gridwin, "D1", "D")
+        enter_text_to_cell(gridwin, "A2", "economics")
+        enter_text_to_cell(gridwin, "B2", "34")
+        enter_text_to_cell(gridwin, "C2", "67")
+        enter_text_to_cell(gridwin, "D2", "122")
+        enter_text_to_cell(gridwin, "A3", "socioeconomic")
+        enter_text_to_cell(gridwin, "B3", "45")
+        enter_text_to_cell(gridwin, "C3", "77")
+        enter_text_to_cell(gridwin, "D3", "333")
+        enter_text_to_cell(gridwin, "A4", "sociology")
+        enter_text_to_cell(gridwin, "B4", "78")
+        enter_text_to_cell(gridwin, "C4", "89")
+        enter_text_to_cell(gridwin, "D4", "56")
+        enter_text_to_cell(gridwin, "A5", "humanities")
+        enter_text_to_cell(gridwin, "B5", "45")
+        enter_text_to_cell(gridwin, "C5", "67")
+        enter_text_to_cell(gridwin, "D5", "89")
+        #Select
+        gridwin.executeAction("SELECT", mkPropertyValues({"RANGE": "A1:D5"}))
+        #Choose DATA-FILTER-STANDARDFILTER
+        #Choose field name "A"/ Choose condition "Does not contain"/Enter value "cio"/Press OK button
+        self.ui_test.execute_modeless_dialog_through_command(".uno:DataFilterStandardFilter")
+        xDialog = self.xUITest.getTopFocusWindow()
+        xfield1 = xDialog.getChild("field1")
+        xval1 = xDialog.getChild("val1")
+        xcond1 = xDialog.getChild("cond1")
+
+        props = {"TEXT": "A"}
+        actionProps = mkPropertyValues(props)
+        xfield1.executeAction("SELECT", actionProps)
+        props2 = {"TEXT": "Ends with"}
+        actionProps2 = mkPropertyValues(props2)
+        xcond1.executeAction("SELECT", actionProps2)
+        xval1.executeAction("TYPE", mkPropertyValues({"TEXT":"s"}))
+        xOKBtn = xDialog.getChild("ok")
+        self.ui_test.close_dialog_through_button(xOKBtn)
+
+        #Verify that row 1,2, 5 are visible (3 and 4 are hidden)
+        gridwin.executeAction("SELECT", mkPropertyValues({"CELL": "A1"}))
+        gridwin.executeAction("TYPE", mkPropertyValues({"KEYCODE": "DOWN"}))
+        gridWinState = get_state_as_dict(gridwin)
+        self.assertEqual(gridWinState["CurrentRow"], "1")
+        gridwin.executeAction("TYPE", mkPropertyValues({"KEYCODE": "DOWN"}))
+        gridWinState = get_state_as_dict(gridwin)
+        self.assertEqual(gridWinState["CurrentRow"], "4")
+        #reopen filter and verify
+        gridwin.executeAction("TYPE", mkPropertyValues({"KEYCODE": "UP"}))
+        gridwin.executeAction("TYPE", mkPropertyValues({"KEYCODE": "UP"}))
+        self.ui_test.execute_modeless_dialog_through_command(".uno:DataFilterStandardFilter")
+        xDialog = self.xUITest.getTopFocusWindow()
+        xfield1 = xDialog.getChild("field1")
+        xval1 = xDialog.getChild("val1")
+        xcond1 = xDialog.getChild("cond1")
+        self.assertEqual(get_state_as_dict(xfield1)["SelectEntryText"], "A")
+        self.assertEqual(get_state_as_dict(xval1)["Text"], "s")
+        self.assertEqual(get_state_as_dict(xcond1)["SelectEntryText"], "Ends with")
+        xCancelBtn = xDialog.getChild("cancel")
+        self.ui_test.close_dialog_through_button(xCancelBtn)
+
+        self.ui_test.close_doc()
+
+    def test_standard_filter_condition_Does_not_end_with(self):
+        calc_doc = self.ui_test.create_doc_in_start_center("calc")
+        xCalcDoc = self.xUITest.getTopFocusWindow()
+        gridwin = xCalcDoc.getChild("grid_window")
+        document = self.ui_test.get_component()
+
+        enter_text_to_cell(gridwin, "A1", "A")
+        enter_text_to_cell(gridwin, "B1", "B")
+        enter_text_to_cell(gridwin, "C1", "C")
+        enter_text_to_cell(gridwin, "D1", "D")
+        enter_text_to_cell(gridwin, "A2", "economics")
+        enter_text_to_cell(gridwin, "B2", "34")
+        enter_text_to_cell(gridwin, "C2", "67")
+        enter_text_to_cell(gridwin, "D2", "122")
+        enter_text_to_cell(gridwin, "A3", "socioeconomic")
+        enter_text_to_cell(gridwin, "B3", "45")
+        enter_text_to_cell(gridwin, "C3", "77")
+        enter_text_to_cell(gridwin, "D3", "333")
+        enter_text_to_cell(gridwin, "A4", "sociology")
+        enter_text_to_cell(gridwin, "B4", "78")
+        enter_text_to_cell(gridwin, "C4", "89")
+        enter_text_to_cell(gridwin, "D4", "56")
+        enter_text_to_cell(gridwin, "A5", "humanities")
+        enter_text_to_cell(gridwin, "B5", "45")
+        enter_text_to_cell(gridwin, "C5", "67")
+        enter_text_to_cell(gridwin, "D5", "89")
+        #Select
+        gridwin.executeAction("SELECT", mkPropertyValues({"RANGE": "A1:D5"}))
+        #Choose DATA-FILTER-STANDARDFILTER
+        #Choose field name "A"/ Choose condition "Begins with"/Enter value "si"/Press OK button
+        self.ui_test.execute_modeless_dialog_through_command(".uno:DataFilterStandardFilter")
+        xDialog = self.xUITest.getTopFocusWindow()
+        xfield1 = xDialog.getChild("field1")
+        xval1 = xDialog.getChild("val1")
+        xcond1 = xDialog.getChild("cond1")
+
+        props = {"TEXT": "A"}
+        actionProps = mkPropertyValues(props)
+        xfield1.executeAction("SELECT", actionProps)
+        props2 = {"TEXT": "Does not end with"}
+        actionProps2 = mkPropertyValues(props2)
+        xcond1.executeAction("SELECT", actionProps2)
+        xval1.executeAction("TYPE", mkPropertyValues({"TEXT":"s"}))
+        xOKBtn = xDialog.getChild("ok")
+        self.ui_test.close_dialog_through_button(xOKBtn)
+
+        #Verify that row 1,3, 4 are visible (2 and 5 are hidden)
+        gridwin.executeAction("SELECT", mkPropertyValues({"CELL": "A1"}))
+        gridwin.executeAction("TYPE", mkPropertyValues({"KEYCODE": "DOWN"}))
+        gridWinState = get_state_as_dict(gridwin)
+        self.assertEqual(gridWinState["CurrentRow"], "2")
+        gridwin.executeAction("TYPE", mkPropertyValues({"KEYCODE": "DOWN"}))
+        gridWinState = get_state_as_dict(gridwin)
+        self.assertEqual(gridWinState["CurrentRow"], "3")
+        #reopen filter and verify
+        gridwin.executeAction("TYPE", mkPropertyValues({"KEYCODE": "UP"}))
+        gridwin.executeAction("TYPE", mkPropertyValues({"KEYCODE": "UP"}))
+        self.ui_test.execute_modeless_dialog_through_command(".uno:DataFilterStandardFilter")
+        xDialog = self.xUITest.getTopFocusWindow()
+        xfield1 = xDialog.getChild("field1")
+        xval1 = xDialog.getChild("val1")
+        xcond1 = xDialog.getChild("cond1")
+        self.assertEqual(get_state_as_dict(xfield1)["SelectEntryText"], "A")
+        self.assertEqual(get_state_as_dict(xval1)["Text"], "s")
+        self.assertEqual(get_state_as_dict(xcond1)["SelectEntryText"], "Does not end with")
+        xCancelBtn = xDialog.getChild("cancel")
+        self.ui_test.close_dialog_through_button(xCancelBtn)
+
+        self.ui_test.close_doc()
+# vim: set shiftwidth=4 softtabstop=4 expandtab:
diff --git a/sc/qa/uitest/calc_tests2/subtotals.py b/sc/qa/uitest/calc_tests2/subtotals.py
new file mode 100644
index 000000000..31e87d9ac
--- /dev/null
+++ b/sc/qa/uitest/calc_tests2/subtotals.py
@@ -0,0 +1,196 @@
+# -*- tab-width: 4; indent-tabs-mode: nil; py-indent-offset: 4 -*-
+#
+# This Source Code Form is subject to the terms of the Mozilla Public
+# 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/.
+#
+
+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 libreoffice.calc.document import get_cell_by_position
+from uitest.uihelper.common import select_pos
+from uitest.uihelper.common import get_state_as_dict
+import org.libreoffice.unotest
+import pathlib
+import time
+from uitest.debug import sleep
+
+def get_url_for_data_file(file_name):
+    return pathlib.Path(org.libreoffice.unotest.makeCopyFromTDOC(file_name)).as_uri()
+
+class Subtotals(UITestCase):
+
+    def test_tdf114720(self):
+        calc_doc = self.ui_test.create_doc_in_start_center("calc")
+        XcalcDoc = self.xUITest.getTopFocusWindow()
+        document = self.ui_test.get_component()
+        gridwin = XcalcDoc.getChild("grid_window")
+
+        enter_text_to_cell(gridwin, "A1", "1")
+        enter_text_to_cell(gridwin, "A2", "1")
+        enter_text_to_cell(gridwin, "A3", "1")
+        enter_text_to_cell(gridwin, "A4", "1")
+        enter_text_to_cell(gridwin, "A5", "1")
+        enter_text_to_cell(gridwin, "A6", "1")
+        enter_text_to_cell(gridwin, "A7", "1")
+        enter_text_to_cell(gridwin, "A8", "1")
+        gridwin.executeAction("SELECT", mkPropertyValues({"CELL": "A9"}))
+
+        self.ui_test.execute_dialog_through_command(".uno:DataSubTotals")
+        xDialog = self.xUITest.getTopFocusWindow()
+
+        xOKBtn = xDialog.getChild("ok")
+        self.ui_test.close_dialog_through_button(xOKBtn)
+        self.assertEqual(get_cell_by_position(document, 0, 0, 7).getValue(), 1)
+        self.assertEqual(get_cell_by_position(document, 0, 0, 8).getString(), "")
+
+        # check cancel button
+        self.ui_test.execute_dialog_through_command(".uno:DataSubTotals")
+        xDialog = self.xUITest.getTopFocusWindow()
+        xCancelBtn = xDialog.getChild("cancel")
+        self.ui_test.close_dialog_through_button(xCancelBtn)
+
+        self.ui_test.close_doc()
+
+    def test_tdf88792(self):
+        calc_doc = self.ui_test.load_file(get_url_for_data_file("tdf88792.ods"))
+        XcalcDoc = self.xUITest.getTopFocusWindow()
+        document = self.ui_test.get_component()
+        gridwin = XcalcDoc.getChild("grid_window")
+
+        # go to cell A1
+        gridwin.executeAction("SELECT", mkPropertyValues({"CELL": "A1"}))
+        # Select from the menu bar Data
+        # Select option subtotal
+        # Subtotal dialog displays
+        self.ui_test.execute_dialog_through_command(".uno:DataSubTotals")
+        xDialog = self.xUITest.getTopFocusWindow()
+        # Select group by: Category
+        xGroupBy = xDialog.getChild("group_by")
+        props = {"TEXT": "Category"}
+        actionProps = mkPropertyValues(props)
+        xGroupBy.executeAction("SELECT", actionProps)
+        # Select calculate subtotals for the months -  selected by default
+        # Select tab options
+        xTabs = xDialog.getChild("tabcontrol")
+        select_pos(xTabs, "3")
+        # select option include formats
+        xformats = xDialog.getChild("formats")
+        xformats.executeAction("CLICK", tuple())
+        # apply with OK
+        xOKBtn = xDialog.getChild("ok")
+        self.ui_test.close_dialog_through_button(xOKBtn)
+
+        self.assertEqual(get_cell_by_position(document, 0, 3, 5).getValue(), 28000)
+        self.ui_test.close_doc()
+
+    def test_tdf88735(self):
+        calc_doc = self.ui_test.load_file(get_url_for_data_file("tdf88735.ods"))
+        XcalcDoc = self.xUITest.getTopFocusWindow()
+        document = self.ui_test.get_component()
+        gridwin = XcalcDoc.getChild("grid_window")
+        # 1 select all cells
+        self.xUITest.executeCommand(".uno:SelectAll")#use uno command Menu Edit->Select All
+        # 2 invoke sub-total menu and select none
+        self.ui_test.execute_dialog_through_command(".uno:DataSubTotals")
+        xDialog = self.xUITest.getTopFocusWindow()
+        xGroupBy = xDialog.getChild("group_by")
+        props = {"TEXT": "- none -"}
+        actionProps = mkPropertyValues(props)
+        xGroupBy.executeAction("SELECT", actionProps)
+        xOKBtn = xDialog.getChild("ok")
+        self.ui_test.close_dialog_through_button(xOKBtn)
+        # 2 invoke sort menu and... crash
+        self.ui_test.execute_dialog_through_command(".uno:DataSort")
+        xDialog = self.xUITest.getTopFocusWindow()
+        xCancelBtn = xDialog.getChild("cancel")
+        self.ui_test.close_dialog_through_button(xCancelBtn)
+
+        self.assertEqual(get_cell_by_position(document, 0, 0, 8).getString(), "z")
+        self.assertEqual(get_cell_by_position(document, 0, 1, 8).getValue(), 8)
+        self.ui_test.close_doc()
+
+    def test_tdf56958(self):
+        calc_doc = self.ui_test.load_file(get_url_for_data_file("tdf56958.ods"))
+        XcalcDoc = self.xUITest.getTopFocusWindow()
+        document = self.ui_test.get_component()
+        gridwin = XcalcDoc.getChild("grid_window")
+        # 1. Open the test file
+        # 2. Data->Subtotals
+        self.ui_test.execute_dialog_through_command(".uno:DataSubTotals")
+        xDialog = self.xUITest.getTopFocusWindow()
+        # 3. Group by->Trans date
+        xGroupBy = xDialog.getChild("group_by")
+        props = {"TEXT": "Trans Date"}
+        actionProps = mkPropertyValues(props)
+        xGroupBy.executeAction("SELECT", actionProps)
+        # 4. Tick 'Calculate subtotals for' -> Amount  (grid1)
+        xCheckListMenu = xDialog.getChild("grid1")
+        xTreeList = xCheckListMenu.getChild("columns")
+        xFirstEntry = xTreeList.getChild("2")
+        xFirstEntry.executeAction("CLICK", tuple())
+        # 5. Click OK
+        xOKBtn = xDialog.getChild("ok")
+        self.ui_test.close_dialog_through_button(xOKBtn)
+        # 6. Data->Subtotals
+        self.ui_test.execute_dialog_through_command(".uno:DataSubTotals")
+        xDialog = self.xUITest.getTopFocusWindow()
+        # 7. Group by->-none-
+        xGroupBy = xDialog.getChild("group_by")
+        props = {"TEXT": "- none -"}
+        actionProps = mkPropertyValues(props)
+        xGroupBy.executeAction("SELECT", actionProps)
+        # 8. Untick 'Calculate subtotals for' -> Amount
+        xCheckListMenu = xDialog.getChild("grid1")
+        xTreeList = xCheckListMenu.getChild("columns")
+        xFirstEntry = xTreeList.getChild("2")
+        xFirstEntry.executeAction("CLICK", tuple())
+        # 9. Click OK
+        xOKBtn = xDialog.getChild("ok")
+        self.ui_test.close_dialog_through_button(xOKBtn)
+        # 10. Data->Sort
+        self.ui_test.execute_dialog_through_command(".uno:DataSort")
+        xDialog = self.xUITest.getTopFocusWindow()
+        # 11. Sort key 1->Post Date.
+        sortkey1 = xDialog.getChild("sortlb")
+        props = {"TEXT": "Post Date"}
+        actionProps = mkPropertyValues(props)
+        sortkey1.executeAction("SELECT", actionProps)
+        # 12. Sort key 2->-undefined-
+        sortkey2 = xDialog.getChild("sortuserlb")
+        props = {"TEXT": "- undefined -"}
+        actionProps = mkPropertyValues(props)
+        sortkey2.executeAction("SELECT", actionProps)
+        # 13. Click OK
+        xOKBtn = xDialog.getChild("ok")
+        self.ui_test.close_dialog_through_button(xOKBtn)
+        self.assertEqual(get_cell_by_position(document, 0, 2, 1).getValue(), -0.25)
+        self.ui_test.close_doc()
+
+    def test_tdf55734(self):
+        calc_doc = self.ui_test.load_file(get_url_for_data_file("tdf55734.ods"))
+        XcalcDoc = self.xUITest.getTopFocusWindow()
+        document = self.ui_test.get_component()
+        gridwin = XcalcDoc.getChild("grid_window")
+        # 1. Open attached document
+        # 2. Place cursor in cell outside of subtotals range (e.g. B7)
+        gridwin.executeAction("SELECT", mkPropertyValues({"CELL": "B7"}))
+        # 3. Data → Subtotals
+        self.ui_test.execute_dialog_through_command(".uno:DataSubTotals")
+        xDialog = self.xUITest.getTopFocusWindow()
+        # 4. Group by: "- none -"
+        xGroupBy = xDialog.getChild("group_by")
+        props = {"TEXT": "- none -"}
+        actionProps = mkPropertyValues(props)
+        xGroupBy.executeAction("SELECT", actionProps)
+        # 5. Press "OK" and watch LibreOffice crash.
+        xOKBtn = xDialog.getChild("ok")
+        self.ui_test.close_dialog_through_button(xOKBtn)
+
+        self.assertEqual(get_cell_by_position(document, 0, 0, 1).getValue(), 1)
+        self.assertEqual(get_cell_by_position(document, 0, 1, 1).getValue(), 2)
+        self.ui_test.close_doc()
+
+# vim: set shiftwidth=4 softtabstop=4 expandtab:
diff --git a/sc/qa/uitest/calc_tests2/tdf104117.py b/sc/qa/uitest/calc_tests2/tdf104117.py
new file mode 100644
index 000000000..84ab28580
--- /dev/null
+++ b/sc/qa/uitest/calc_tests2/tdf104117.py
@@ -0,0 +1,54 @@
+# -*- tab-width: 4; indent-tabs-mode: nil; py-indent-offset: 4 -*-
+#
+# This Source Code Form is subject to the terms of the Mozilla Public
+# 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/.
+#
+from uitest.framework import UITestCase
+from uitest.uihelper.common import get_state_as_dict
+from uitest.uihelper.common import select_pos
+from uitest.uihelper.calc import enter_text_to_cell
+from libreoffice.calc.document import get_sheet_from_doc
+from libreoffice.calc.conditional_format import get_conditional_format_from_sheet
+from uitest.debug import sleep
+from libreoffice.calc.document import get_cell_by_position
+from libreoffice.uno.propertyvalue import mkPropertyValues
+
+#Bug 104117 - Crash in Calc when selecting "Uniform Integer" with an max value "100000000000000" in "Random Number Generator
+class tdf104117(UITestCase):
+    def test_tdf104117(self):
+        calc_doc = self.ui_test.create_doc_in_start_center("calc")
+        xCalcDoc = self.xUITest.getTopFocusWindow()
+        gridwin = xCalcDoc.getChild("grid_window")
+        document = self.ui_test.get_component()
+        gridwin.executeAction("SELECT", mkPropertyValues({"RANGE": "A1:A2"}))
+        self.ui_test.execute_modeless_dialog_through_command(".uno:RandomNumberGeneratorDialog")
+        xDialog = self.xUITest.getTopFocusWindow()
+        xcellrangeedit = xDialog.getChild("cell-range-edit")
+        xdistributioncombo = xDialog.getChild("distribution-combo")
+        xparameter1spin = xDialog.getChild("parameter1-spin")
+        xparameter2spin = xDialog.getChild("parameter2-spin")
+        xenableseedcheck = xDialog.getChild("enable-seed-check")
+        xseedspin = xDialog.getChild("seed-spin")
+        xenableroundingcheck = xDialog.getChild("enable-rounding-check")
+        xdecimalplacesspin = xDialog.getChild("decimal-places-spin")
+
+        xcellrangeedit.executeAction("TYPE", mkPropertyValues({"TEXT":"$Sheet1.$A$1:$A$2"}))
+        props = {"TEXT": "Uniform Integer"}
+        actionProps = mkPropertyValues(props)
+        xdistributioncombo.executeAction("SELECT", actionProps)
+        xparameter2spin.executeAction("TYPE", mkPropertyValues({"KEYCODE":"CTRL+A"}))
+        xparameter2spin.executeAction("TYPE", mkPropertyValues({"KEYCODE":"BACKSPACE"}))
+        xparameter2spin.executeAction("TYPE", mkPropertyValues({"TEXT":"1000000000000000000000000000000000000000000000"}))
+
+        xOKBtn = xDialog.getChild("ok")
+        self.ui_test.close_dialog_through_button(xOKBtn)
+        #Verify
+        self.assertEqual(bool(get_cell_by_position(document, 0, 0, 0).getString() ), True)
+        self.assertEqual(bool(get_cell_by_position(document, 0, 0, 1).getString() ), True)
+        #undo
+        self.xUITest.executeCommand(".uno:Undo")
+        self.assertEqual(bool(get_cell_by_position(document, 0, 0, 0).getString() ), False)
+        self.assertEqual(bool(get_cell_by_position(document, 0, 0, 1).getString() ), False)
+        self.ui_test.close_doc()
+# vim: set shiftwidth=4 softtabstop=4 expandtab:
\ No newline at end of file
diff --git a/sc/qa/uitest/calc_tests2/tdf105268.py b/sc/qa/uitest/calc_tests2/tdf105268.py
new file mode 100644
index 000000000..f501e3511
--- /dev/null
+++ b/sc/qa/uitest/calc_tests2/tdf105268.py
@@ -0,0 +1,35 @@
+# -*- tab-width: 4; indent-tabs-mode: nil; py-indent-offset: 4 -*-
+#
+# This Source Code Form is subject to the terms of the Mozilla Public
+# 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/.
+#
+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 105268 - Auto Fill: The Next Value for "001-001-001" is "001-001-002" Rather than "001-001000"
+
+class tdf105268(UITestCase):
+    def test_tdf105268(self):
+        calc_doc = self.ui_test.create_doc_in_start_center("calc")
+        xCalcDoc = self.xUITest.getTopFocusWindow()
+        gridwin = xCalcDoc.getChild("grid_window")
+        document = self.ui_test.get_component()
+        enter_text_to_cell(gridwin, "A1", "001-001-001")
+        gridwin.executeAction("SELECT", mkPropertyValues({"RANGE": "A1:A3"}))
+        self.ui_test.execute_dialog_through_command(".uno:FillSeries")
+        xDialog = self.xUITest.getTopFocusWindow()
+        xautofill = xDialog.getChild("autofill")
+        xautofill.executeAction("CLICK", tuple())
+        xOK = xDialog.getChild("ok")
+        self.ui_test.close_dialog_through_button(xOK)
+        self.assertEqual(get_cell_by_position(document, 0, 0, 0).getString(), "001-001-001")
+        self.assertEqual(get_cell_by_position(document, 0, 0, 1).getString(), "001-001-002")
+        self.assertEqual(get_cell_by_position(document, 0, 0, 2).getString(), "001-001-003")
+
+        self.ui_test.close_doc()
+
+# vim: set shiftwidth=4 softtabstop=4 expandtab:
\ No newline at end of file
diff --git a/sc/qa/uitest/calc_tests2/tdf114992.py b/sc/qa/uitest/calc_tests2/tdf114992.py
new file mode 100644
index 000000000..0e4b30c2a
--- /dev/null
+++ b/sc/qa/uitest/calc_tests2/tdf114992.py
@@ -0,0 +1,32 @@
+# -*- tab-width: 4; indent-tabs-mode: nil; py-indent-offset: 4 -*-
+#
+# This Source Code Form is subject to the terms of the Mozilla Public
+# 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/.
+#
+from uitest.framework import UITestCase
+import org.libreoffice.unotest
+import pathlib
+#Bug:  Delete a sheet in a calc document and LO crashes
+def get_url_for_data_file(file_name):
+    return pathlib.Path(org.libreoffice.unotest.makeCopyFromTDOC(file_name)).as_uri()
+
+class tdf114992(UITestCase):
+    def test_tdf114992_delete_sheet_crash(self):
+        calc_doc = self.ui_test.load_file(get_url_for_data_file("tdf114992.ods"))
+        xCalcDoc = self.xUITest.getTopFocusWindow()
+        gridwin = xCalcDoc.getChild("grid_window")
+        document = self.ui_test.get_component()
+
+        self.ui_test.execute_dialog_through_command(".uno:Remove")  #delete sheet
+        xDialog = self.xUITest.getTopFocusWindow()
+        xOKButton = xDialog.getChild("yes")
+        xOKButton.executeAction("CLICK", tuple())
+
+        self.assertEqual(document.Sheets.getCount(), 1)
+        self.xUITest.executeCommand(".uno:Undo")
+        self.assertEqual(document.Sheets.getCount(), 2)
+
+        self.ui_test.close_doc()
+
+# vim: set shiftwidth=4 softtabstop=4 expandtab:
\ No newline at end of file
diff --git a/sc/qa/uitest/calc_tests2/tdf116215.py b/sc/qa/uitest/calc_tests2/tdf116215.py
new file mode 100644
index 000000000..958546077
--- /dev/null
+++ b/sc/qa/uitest/calc_tests2/tdf116215.py
@@ -0,0 +1,42 @@
+# -*- tab-width: 4; indent-tabs-mode: nil; py-indent-offset: 4 -*-
+#
+# This Source Code Form is subject to the terms of the Mozilla Public
+# 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/.
+#
+from uitest.framework import UITestCase
+import os
+from uitest.uihelper.common import get_state_as_dict
+from uitest.uihelper.calc import enter_text_to_cell
+from libreoffice.calc.document import get_sheet_from_doc
+from libreoffice.calc.conditional_format import get_conditional_format_from_sheet
+from uitest.debug import sleep
+from libreoffice.calc.document import get_cell_by_position
+from libreoffice.uno.propertyvalue import mkPropertyValues
+#Bug: Sum button: Calc adds wrong sum formulas if you select more than one row or column
+
+class tdf116215(UITestCase):
+
+    def test_tdf116215_autosum_wrong_more_rows_columns(self):
+        calc_doc = self.ui_test.create_doc_in_start_center("calc")
+        xCalcDoc = self.xUITest.getTopFocusWindow()
+        gridwin = xCalcDoc.getChild("grid_window")
+        document = self.ui_test.get_component()
+        enter_text_to_cell(gridwin, "A1", "1")
+        enter_text_to_cell(gridwin, "A2", "1")
+        enter_text_to_cell(gridwin, "B1", "1")
+        enter_text_to_cell(gridwin, "B2", "1")
+        gridwin.executeAction("SELECT", mkPropertyValues({"RANGE": "A1:C3"}))
+        self.xUITest.executeCommand(".uno:AutoSum")
+
+        self.assertEqual(get_cell_by_position(document, 0, 0, 2).getValue(), 2)
+        self.assertEqual(get_cell_by_position(document, 0, 0, 2).getFormula(), "=SUM(A1:A2)")
+        self.assertEqual(get_cell_by_position(document, 0, 1, 2).getValue(), 2)
+        self.assertEqual(get_cell_by_position(document, 0, 1, 2).getFormula(), "=SUM(B1:B2)")
+        self.assertEqual(get_cell_by_position(document, 0, 2, 0).getValue(), 2)
+        self.assertEqual(get_cell_by_position(document, 0, 2, 0).getFormula(), "=SUM(A1:B1)")
+        self.assertEqual(get_cell_by_position(document, 0, 2, 1).getValue(), 2)
+        self.assertEqual(get_cell_by_position(document, 0, 2, 1).getFormula(), "=SUM(A2:B2)")
+        self.ui_test.close_doc()
+
+# vim: set shiftwidth=4 softtabstop=4 expandtab:
diff --git a/sc/qa/uitest/calc_tests2/tdf116421.py b/sc/qa/uitest/calc_tests2/tdf116421.py
new file mode 100644
index 000000000..c6d86f164
--- /dev/null
+++ b/sc/qa/uitest/calc_tests2/tdf116421.py
@@ -0,0 +1,36 @@
+# -*- tab-width: 4; indent-tabs-mode: nil; py-indent-offset: 4 -*-
+#
+# This Source Code Form is subject to the terms of the Mozilla Public
+# 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/.
+#
+from uitest.framework import UITestCase
+import os
+from uitest.uihelper.common import get_state_as_dict
+from uitest.uihelper.calc import enter_text_to_cell
+from libreoffice.calc.document import get_sheet_from_doc
+from libreoffice.calc.conditional_format import get_conditional_format_from_sheet
+from uitest.debug import sleep
+from libreoffice.calc.document import get_cell_by_position
+from libreoffice.uno.propertyvalue import mkPropertyValues
+#Bug: autosum is not working
+
+class tdf116421(UITestCase):
+
+    def test_tdf116421_autosum_not_working(self):
+        calc_doc = self.ui_test.create_doc_in_start_center("calc")
+        xCalcDoc = self.xUITest.getTopFocusWindow()
+        gridwin = xCalcDoc.getChild("grid_window")
+        document = self.ui_test.get_component()
+        enter_text_to_cell(gridwin, "A1", "1")
+        enter_text_to_cell(gridwin, "A2", "1")
+        enter_text_to_cell(gridwin, "A3", "1")
+        gridwin.executeAction("SELECT", mkPropertyValues({"CELL": "A4"}))
+        self.xUITest.executeCommand(".uno:AutoSum")
+
+        self.assertEqual(get_cell_by_position(document, 0, 0, 3).getValue(), 3)
+        self.assertEqual(get_cell_by_position(document, 0, 0, 3).getFormula(), "=SUM(A1:A3)")
+
+        self.ui_test.close_doc()
+
+# vim: set shiftwidth=4 softtabstop=4 expandtab:
\ No newline at end of file
diff --git a/sc/qa/uitest/calc_tests2/tdf117367.py b/sc/qa/uitest/calc_tests2/tdf117367.py
new file mode 100644
index 000000000..36f3e2580
--- /dev/null
+++ b/sc/qa/uitest/calc_tests2/tdf117367.py
@@ -0,0 +1,55 @@
+# -*- tab-width: 4; indent-tabs-mode: nil; py-indent-offset: 4 -*-
+#
+# This Source Code Form is subject to the terms of the Mozilla Public
+# 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/.
+#
+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
+from uitest.debug import sleep
+#Bug 117367 - FORMATTING Merge cells dialog radio buttons cannot be unselected
+
+class tdf117367(UITestCase):
+    def test_tdf117367_merge_cells_radio_buttons(self):
+        calc_doc = self.ui_test.create_doc_in_start_center("calc")
+        xCalcDoc = self.xUITest.getTopFocusWindow()
+        gridwin = xCalcDoc.getChild("grid_window")
+        document = self.ui_test.get_component()
+
+        enter_text_to_cell(gridwin, "A1", "AAA")
+        enter_text_to_cell(gridwin, "A2", "BBB")
+        gridwin.executeAction("SELECT", mkPropertyValues({"RANGE": "A1:B4"}))
+
+        #Right-click - Merge cells  /Select all three options
+        self.ui_test.execute_dialog_through_command(".uno:MergeCells")
+        xDialog = self.xUITest.getTopFocusWindow()
+        xmoveCellsRadio = xDialog.getChild("move-cells-radio")
+        xemptyCellsRadio = xDialog.getChild("empty-cells-radio")
+        xkeepContentRadio = xDialog.getChild("keep-content-radio")
+        xmoveCellsRadio.executeAction("CLICK", tuple())
+        xmoveCellsRadio.executeAction("CLICK", tuple())
+        #Issue: I think these should be exclusive, not possible to select more than one. It is also impossible to uncheck any of the buttons.
+        self.assertEqual(get_state_as_dict(xmoveCellsRadio)["Checked"], "true")
+        self.assertEqual(get_state_as_dict(xemptyCellsRadio)["Checked"], "false")
+        self.assertEqual(get_state_as_dict(xkeepContentRadio)["Checked"], "false")
+
+        xemptyCellsRadio.executeAction("CLICK", tuple())
+        self.assertEqual(get_state_as_dict(xmoveCellsRadio)["Checked"], "false")
+        self.assertEqual(get_state_as_dict(xemptyCellsRadio)["Checked"], "true")
+        self.assertEqual(get_state_as_dict(xkeepContentRadio)["Checked"], "false")
+
+        xkeepContentRadio.executeAction("CLICK", tuple())
+        self.assertEqual(get_state_as_dict(xmoveCellsRadio)["Checked"], "false")
+        self.assertEqual(get_state_as_dict(xemptyCellsRadio)["Checked"], "false")
+        self.assertEqual(get_state_as_dict(xkeepContentRadio)["Checked"], "true")
+
+        xOK = xDialog.getChild("ok")
+        self.ui_test.close_dialog_through_button(xOK)
+
+        self.ui_test.close_doc()
+
+# vim: set shiftwidth=4 softtabstop=4 expandtab:
diff --git a/sc/qa/uitest/calc_tests2/tdf118189.py b/sc/qa/uitest/calc_tests2/tdf118189.py
new file mode 100644
index 000000000..e49a471fd
--- /dev/null
+++ b/sc/qa/uitest/calc_tests2/tdf118189.py
@@ -0,0 +1,53 @@
+# -*- tab-width: 4; indent-tabs-mode: nil; py-indent-offset: 4 -*-
+#
+# This Source Code Form is subject to the terms of the Mozilla Public
+# 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/.
+#
+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.debug import sleep
+from libreoffice.calc.document import get_cell_by_position
+from libreoffice.uno.propertyvalue import mkPropertyValues
+import org.libreoffice.unotest
+import pathlib
+
+def get_url_for_data_file(file_name):
+    return pathlib.Path(org.libreoffice.unotest.makeCopyFromTDOC(file_name)).as_uri()
+
+#Bug 118189 - EDITING Crashes on Undo after Cut conditional formatting data
+
+class tdf118189(UITestCase):
+    def test_tdf118189(self):
+        calc_doc = self.ui_test.load_file(get_url_for_data_file("tdf118189.xlsx"))
+        xCalcDoc = self.xUITest.getTopFocusWindow()
+        gridwin = xCalcDoc.getChild("grid_window")
+        document = self.ui_test.get_component()
+        #1. Open attached document
+        #2. Copy Column A
+        gridwin.executeAction("SELECT", mkPropertyValues({"CELL": "A1"}))
+        self.xUITest.executeCommand(".uno:SelectColumn")
+        self.xUITest.executeCommand(".uno:Copy")
+        #3. New Spreadsheet
+        calc_doc2 = self.ui_test.load_file(get_url_for_data_file("emptyFile.ods"))
+        gridwin2 = xCalcDoc.getChild("grid_window")
+        document2 = self.ui_test.get_component()
+
+        frames = self.ui_test.get_frames()
+        frames[1].activate()
+        #4. Paste it
+        gridwin2.executeAction("SELECT", mkPropertyValues({"CELL": "A1"}))
+        self.xUITest.executeCommand(".uno:Paste")
+        #5. Cut it
+        self.xUITest.executeCommand(".uno:Cut")
+        #6. Undo
+        self.xUITest.executeCommand(".uno:Undo")
+
+        #-> CRASH
+        self.assertEqual(get_cell_by_position(document2, 0, 0, 0).getString(), "On Back Order")
+
+        self.ui_test.close_doc()
+
+# vim: set shiftwidth=4 softtabstop=4 expandtab:
\ No newline at end of file
diff --git a/sc/qa/uitest/calc_tests2/tdf120174.py b/sc/qa/uitest/calc_tests2/tdf120174.py
new file mode 100644
index 000000000..e078147a9
--- /dev/null
+++ b/sc/qa/uitest/calc_tests2/tdf120174.py
@@ -0,0 +1,35 @@
+# -*- tab-width: 4; indent-tabs-mode: nil; py-indent-offset: 4 -*-
+#
+# This Source Code Form is subject to the terms of the Mozilla Public
+# 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/.
+#
+from uitest.framework import UITestCase
+from libreoffice.calc.document import get_cell_by_position
+from libreoffice.uno.propertyvalue import mkPropertyValues
+from uitest.uihelper.calc import enter_text_to_cell
+import org.libreoffice.unotest
+import pathlib
+
+def get_url_for_data_file(file_name):
+    return pathlib.Path(org.libreoffice.unotest.makeCopyFromTDOC(file_name)).as_uri()
+
+class tdf120174(UITestCase):
+    def test_tdf120174(self):
+        calc_doc = self.ui_test.create_doc_in_start_center("calc")
+        xCalcDoc = self.xUITest.getTopFocusWindow()
+        gridwin = xCalcDoc.getChild("grid_window")
+        document = self.ui_test.get_component()
+        enter_text_to_cell(gridwin, "A1", "121")
+        enter_text_to_cell(gridwin, "B1", "=A1")
+        self.assertEqual(get_cell_by_position(document, 0, 1, 0).getValue(), 121) # B1
+        gridwin.executeAction("SELECT", mkPropertyValues({"CELL": "A1"}))
+        # Delete contents of A1
+        gridwin.executeAction("TYPE", mkPropertyValues({"KEYCODE": "DELETE"}))
+        # Before the fix the result would be still 121.
+        self.assertEqual(get_cell_by_position(document, 0, 1, 0).getValue(), 0) # B1
+        self.xUITest.executeCommand(".uno:Undo")
+        self.assertEqual(get_cell_by_position(document, 0, 1, 0).getValue(), 121) # B1
+        self.ui_test.close_doc()
+
+# vim: set shiftwidth=4 softtabstop=4 expandtab:
diff --git a/sc/qa/uitest/calc_tests2/tdf37623.py b/sc/qa/uitest/calc_tests2/tdf37623.py
new file mode 100644
index 000000000..cd976269c
--- /dev/null
+++ b/sc/qa/uitest/calc_tests2/tdf37623.py
@@ -0,0 +1,40 @@
+# -*- tab-width: 4; indent-tabs-mode: nil; py-indent-offset: 4 -*-
+#
+# This Source Code Form is subject to the terms of the Mozilla Public
+# 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/.
+#
+from uitest.framework import UITestCase
+from uitest.uihelper.common import get_state_as_dict
+from libreoffice.calc.document import get_cell_by_position
+from uitest.path import get_srcdir_url
+from libreoffice.uno.propertyvalue import mkPropertyValues
+import org.libreoffice.unotest
+import pathlib
+
+def get_url_for_data_file(file_name):
+    return pathlib.Path(org.libreoffice.unotest.makeCopyFromTDOC(file_name)).as_uri()
+
+class tdf37623(UITestCase):
+
+    def test_tdf37623_autofill_rows_hidden(self):
+        calc_doc = self.ui_test.load_file(get_url_for_data_file("tdf37623.ods"))
+        xCalcDoc = self.xUITest.getTopFocusWindow()
+        gridwin = xCalcDoc.getChild("grid_window")
+        document = self.ui_test.get_component()
+        gridwin.executeAction("SELECT", mkPropertyValues({"RANGE": "A2:A6"}))
+        self.ui_test.execute_dialog_through_command(".uno:FillSeries")
+        xDialog = self.xUITest.getTopFocusWindow()
+        xautofill = xDialog.getChild("autofill")
+        xautofill.executeAction("CLICK", tuple())
+        xOK = xDialog.getChild("ok")
+        self.ui_test.close_dialog_through_button(xOK)
+
+        self.assertEqual(get_cell_by_position(document, 0, 0, 1).getValue(), 1)
+        self.assertEqual(get_cell_by_position(document, 0, 0, 2).getValue(), 0)
+        self.assertEqual(get_cell_by_position(document, 0, 0, 3).getValue(), 0)
+        self.assertEqual(get_cell_by_position(document, 0, 0, 4).getValue(), 2)
+        self.assertEqual(get_cell_by_position(document, 0, 0, 5).getValue(), 3)
+        self.ui_test.close_doc()
+
+# vim: set shiftwidth=4 softtabstop=4 expandtab:
\ No newline at end of file
diff --git a/sc/qa/uitest/calc_tests2/tdf46138.py b/sc/qa/uitest/calc_tests2/tdf46138.py
new file mode 100644
index 000000000..7aadac6e1
--- /dev/null
+++ b/sc/qa/uitest/calc_tests2/tdf46138.py
@@ -0,0 +1,37 @@
+# -*- tab-width: 4; indent-tabs-mode: nil; py-indent-offset: 4 -*-
+#
+# This Source Code Form is subject to the terms of the Mozilla Public
+# 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/.
+#
+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 46138 - Calc Frozen after "undo" "Filling Series Number in a Column"
+
+class tdf46138(UITestCase):
+    def test_tdf46138(self):
+        calc_doc = self.ui_test.create_doc_in_start_center("calc")
+        xCalcDoc = self.xUITest.getTopFocusWindow()
+        gridwin = xCalcDoc.getChild("grid_window")
+        document = self.ui_test.get_component()
+        #Choose a column,
+        gridwin.executeAction("SELECT", mkPropertyValues({"CELL": "A1"}))
+        self.xUITest.executeCommand(".uno:SelectColumn")
+        #select 'edit'>'fill'>'series'>Starting Value '1' then "OK",
+        self.ui_test.execute_dialog_through_command(".uno:FillSeries")
+        xDialog = self.xUITest.getTopFocusWindow()
+        xStart = xDialog.getChild("startValue")
+        xStart.executeAction("TYPE", mkPropertyValues({"TEXT":"1"}))
+        xOK = xDialog.getChild("ok")
+        self.ui_test.close_dialog_through_button(xOK)
+        self.assertEqual(get_cell_by_position(document, 0, 0, 0).getString(), "1")
+        #then "Ctrl+Z"/ undo
+        self.xUITest.executeCommand(".uno:Undo")
+        self.assertEqual(get_cell_by_position(document, 0, 0, 0).getString(), "")
+        self.ui_test.close_doc()
+
+# vim: set shiftwidth=4 softtabstop=4 expandtab:
\ No newline at end of file
diff --git a/sc/qa/uitest/calc_tests2/tdf51700.py b/sc/qa/uitest/calc_tests2/tdf51700.py
new file mode 100644
index 000000000..ed0cb934d
--- /dev/null
+++ b/sc/qa/uitest/calc_tests2/tdf51700.py
@@ -0,0 +1,55 @@
+# -*- tab-width: 4; indent-tabs-mode: nil; py-indent-offset: 4 -*-
+#
+# This Source Code Form is subject to the terms of the Mozilla Public
+# 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/.
+#
+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 51700 - Text to columns puts result into first line if whole column is selected
+
+class tdf51700(UITestCase):
+    def test_tdf51700_text_to_columns(self):
+        calc_doc = self.ui_test.create_doc_in_start_center("calc")
+        xCalcDoc = self.xUITest.getTopFocusWindow()
+        gridwin = xCalcDoc.getChild("grid_window")
+        document = self.ui_test.get_component()
+
+        #Add data
+        enter_text_to_cell(gridwin, "A2", "3242,43242,3242,2342")
+        enter_text_to_cell(gridwin, "A3", "fdsfa,afsdfa,adfdas,fsad")
+        enter_text_to_cell(gridwin, "A4", "21312,1111,1111,111")
+        #select column A
+        gridwin.executeAction("SELECT", mkPropertyValues({"CELL": "A1"}))
+        self.xUITest.executeCommand(".uno:SelectColumn")
+        # Data - Text to Columns
+        self.ui_test.execute_dialog_through_command(".uno:TextToColumns")
+        xDialog = self.xUITest.getTopFocusWindow()
+        xcomma = xDialog.getChild("comma")
+        if (get_state_as_dict(xcomma)["Selected"]) == "false":
+            xcomma.executeAction("CLICK", tuple())
+        # Click Ok
+        xOK = xDialog.getChild("ok")
+        self.ui_test.close_dialog_through_button(xOK)
+
+        #Verify
+        self.assertEqual(get_cell_by_position(document, 0, 0, 1).getValue(), 3242)
+        self.assertEqual(get_cell_by_position(document, 0, 0, 2).getString(), "fdsfa")
+        self.assertEqual(get_cell_by_position(document, 0, 0, 3).getValue(), 21312)
+        self.assertEqual(get_cell_by_position(document, 0, 1, 1).getValue(), 43242)
+        self.assertEqual(get_cell_by_position(document, 0, 1, 2).getString(), "afsdfa")
+        self.assertEqual(get_cell_by_position(document, 0, 1, 3).getValue(), 1111)
+        self.assertEqual(get_cell_by_position(document, 0, 2, 1).getValue(), 3242)
+        self.assertEqual(get_cell_by_position(document, 0, 2, 2).getString(), "adfdas")
+        self.assertEqual(get_cell_by_position(document, 0, 2, 3).getValue(), 1111)
+        self.assertEqual(get_cell_by_position(document, 0, 3, 1).getValue(), 2342)
+        self.assertEqual(get_cell_by_position(document, 0, 3, 2).getString(), "fsad")
+        self.assertEqual(get_cell_by_position(document, 0, 3, 3).getValue(), 111)
+
+        self.ui_test.close_doc()
+
+# vim: set shiftwidth=4 softtabstop=4 expandtab:
\ No newline at end of file
diff --git a/sc/qa/uitest/calc_tests2/tdf53482.py b/sc/qa/uitest/calc_tests2/tdf53482.py
new file mode 100644
index 000000000..33ffa71d6
--- /dev/null
+++ b/sc/qa/uitest/calc_tests2/tdf53482.py
@@ -0,0 +1,96 @@
+# -*- tab-width: 4; indent-tabs-mode: nil; py-indent-offset: 4 -*-
+#
+# This Source Code Form is subject to the terms of the Mozilla Public
+# 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/.
+#
+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
+import org.libreoffice.unotest
+import pathlib
+#Bug 53482 - UI: Option 'Range contains column headings' ignored
+
+def get_url_for_data_file(file_name):
+    return pathlib.Path(org.libreoffice.unotest.makeCopyFromTDOC(file_name)).as_uri()
+
+class tdf53482(UITestCase):
+
+    def test_tdf53482_Range_contains_column_headings_file(self):
+        calc_doc = self.ui_test.load_file(get_url_for_data_file("tdf53482.ods"))
+        xCalcDoc = self.xUITest.getTopFocusWindow()
+        gridwin = xCalcDoc.getChild("grid_window")
+        document = self.ui_test.get_component()
+        #1. Highlight cells to be sorted A8:J124
+        gridwin.executeAction("SELECT", mkPropertyValues({"RANGE": "A8:J124"}))
+        #2. Click Data menu, Sort
+        self.ui_test.execute_dialog_through_command(".uno:DataSort")
+        xDialog = self.xUITest.getTopFocusWindow()
+        xTabs = xDialog.getChild("tabcontrol")
+        select_pos(xTabs, "1")
+        #3. On Options tab, tick 'Range contains column labels'
+        xHeader = xDialog.getChild("header")
+        xHeader.executeAction("CLICK", tuple())
+        if (get_state_as_dict(xHeader)["Selected"]) == "false":
+            xHeader.executeAction("CLICK", tuple())
+        #4. On Sort Criteria tab, set appropriate criteria
+        select_pos(xTabs, "0")
+        xDown = xDialog.getChild("down")
+        xDown.executeAction("CLICK", tuple())
+        xSortKey1 = xDialog.getChild("sortlb")
+        props = {"TEXT": "Occupation"}
+        actionProps = mkPropertyValues(props)
+        xSortKey1.executeAction("SELECT", actionProps)
+        #5. Click Ok
+        xOK = xDialog.getChild("ok")
+        self.ui_test.close_dialog_through_button(xOK)
+        #6. Expected behavior:  Ignore column labels when sorting
+        self.assertEqual(get_cell_by_position(document, 0, 6, 7).getString(), "Occupation")
+        self.assertEqual(get_cell_by_position(document, 0, 6, 8).getString(), "Travel Industry")
+        self.assertEqual(get_cell_by_position(document, 0, 6, 123).getString(), "13")
+
+        self.ui_test.close_doc()
+
+    def test_tdf53482_Range_contains_column_headings(self):
+        calc_doc = self.ui_test.create_doc_in_start_center("calc")
+        xCalcDoc = self.xUITest.getTopFocusWindow()
+        gridwin = xCalcDoc.getChild("grid_window")
+        document = self.ui_test.get_component()
+        #In column A enter: Misc; s; d; f; g
+        enter_text_to_cell(gridwin, "A1", "Misc")
+        enter_text_to_cell(gridwin, "A2", "s")
+        enter_text_to_cell(gridwin, "A3", "d")
+        enter_text_to_cell(gridwin, "A4", "f")
+        enter_text_to_cell(gridwin, "A5", "g")
+        #1. Highlight cells to be sorted
+        gridwin.executeAction("SELECT", mkPropertyValues({"RANGE": "A1:A5"}))
+        #2. Click Data menu, Sort
+        self.ui_test.execute_dialog_through_command(".uno:DataSort")
+        xDialog = self.xUITest.getTopFocusWindow()
+        xTabs = xDialog.getChild("tabcontrol")
+        select_pos(xTabs, "1")
+        #3. On Options tab, tick 'Range contains column labels'
+        xHeader = xDialog.getChild("header")
+        xHeader.executeAction("CLICK", tuple())
+        if (get_state_as_dict(xHeader)["Selected"]) == "false":
+            xHeader.executeAction("CLICK", tuple())
+        #4. On Sort Criteria tab, set appropriate criteria
+        select_pos(xTabs, "0")
+        xDown = xDialog.getChild("down")
+        xDown.executeAction("CLICK", tuple())
+        #5. Click Ok
+        xOK = xDialog.getChild("ok")
+        self.ui_test.close_dialog_through_button(xOK)
+        #6. Expected behavior:  Ignore column labels when sorting
+        self.assertEqual(get_cell_by_position(document, 0, 0, 0).getString(), "Misc")
+        self.assertEqual(get_cell_by_position(document, 0, 0, 1).getString(), "s")
+        self.assertEqual(get_cell_by_position(document, 0, 0, 2).getString(), "g")
+        self.assertEqual(get_cell_by_position(document, 0, 0, 3).getString(), "f")
+        self.assertEqual(get_cell_by_position(document, 0, 0, 4).getString(), "d")
+
+        self.ui_test.close_doc()
+
+# vim: set shiftwidth=4 softtabstop=4 expandtab:
\ No newline at end of file
diff --git a/sc/qa/uitest/calc_tests2/tdf54018.py b/sc/qa/uitest/calc_tests2/tdf54018.py
new file mode 100644
index 000000000..b1d31e751
--- /dev/null
+++ b/sc/qa/uitest/calc_tests2/tdf54018.py
@@ -0,0 +1,53 @@
+# -*- tab-width: 4; indent-tabs-mode: nil; py-indent-offset: 4 -*-
+#
+# This Source Code Form is subject to the terms of the Mozilla Public
+# 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/.
+#
+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
+import org.libreoffice.unotest
+import pathlib
+#Bug 54018 - EDITING: CRASH sorting cells range with Comments
+def get_url_for_data_file(file_name):
+    return pathlib.Path(org.libreoffice.unotest.makeCopyFromTDOC(file_name)).as_uri()
+
+class tdf54018(UITestCase):
+    def test_td54018_sort_with_comments(self):
+        calc_doc = self.ui_test.load_file(get_url_for_data_file("tdf54018.ods"))
+        xCalcDoc = self.xUITest.getTopFocusWindow()
+        gridwin = xCalcDoc.getChild("grid_window")
+        document = self.ui_test.get_component()
+
+        #click top left columns / rows heading field to select all cells
+        self.xUITest.executeCommand(".uno:SelectAll")
+        #Menu 'Data -> Sort -> Column D -> Descending' <ok>
+        self.ui_test.execute_dialog_through_command(".uno:DataSort")
+        xDialog = self.xUITest.getTopFocusWindow()
+        xTabs = xDialog.getChild("tabcontrol")
+        select_pos(xTabs, "0")
+        xSortKey1 = xDialog.getChild("sortlb")
+        xdown = xDialog.getChild("down")
+        props = {"TEXT": "Column B"}
+        actionProps = mkPropertyValues(props)
+        xSortKey1.executeAction("SELECT", actionProps)
+        xdown.executeAction("CLICK", tuple())
+        xOKBtn = xDialog.getChild("ok")
+        self.ui_test.close_dialog_through_button(xOKBtn)
+        #Bug: When progress bar reaches 40% LibO Stops responding
+        #Verify
+        self.assertEqual(get_cell_by_position(document, 0, 1, 0).getString(), "7")
+        self.assertEqual(get_cell_by_position(document, 0, 1, 1).getString(), "6")
+        self.assertEqual(get_cell_by_position(document, 0, 1, 2).getString(), "5")
+        self.assertEqual(get_cell_by_position(document, 0, 1, 3).getString(), "4")
+        self.assertEqual(get_cell_by_position(document, 0, 1, 4).getString(), "3")
+        self.assertEqual(get_cell_by_position(document, 0, 1, 5).getString(), "2")
+        self.assertEqual(get_cell_by_position(document, 0, 1, 6).getString(), "1")
+
+        self.ui_test.close_doc()
+
+# vim: set shiftwidth=4 softtabstop=4 expandtab:
\ No newline at end of file