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

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

13 files changed, 967 insertions, 0 deletions

diff --git a/sc/qa/uitest/calc_tests6/autoFormat.py b/sc/qa/uitest/calc_tests6/autoFormat.py
new file mode 100644
index 000000000..c38165f36
--- /dev/null
+++ b/sc/qa/uitest/calc_tests6/autoFormat.py
@@ -0,0 +1,78 @@
+# -*- 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
+#uitest sc / AutoFormat Styles
+
+class autoFormat(UITestCase):
+    def test_autoformat_styles(self):
+        writer_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()
+        #select A1:C5
+        gridwin.executeAction("SELECT", mkPropertyValues({"RANGE": "A1:C5"}))
+        #AutoFormat Styles
+        self.ui_test.execute_dialog_through_command(".uno:AutoFormat")
+        xDialog = self.xUITest.getTopFocusWindow()
+
+        formatlb = xDialog.getChild("formatlb")
+        numformatcb = xDialog.getChild("numformatcb")
+        bordercb = xDialog.getChild("bordercb")
+        fontcb = xDialog.getChild("fontcb")
+        patterncb = xDialog.getChild("patterncb")
+        alignmentcb = xDialog.getChild("alignmentcb")
+        autofitcb = xDialog.getChild("autofitcb")
+
+        entry = formatlb.getChild("7") #Financial
+        entry.executeAction("SELECT", tuple())
+        numformatcb.executeAction("CLICK", tuple())
+        bordercb.executeAction("CLICK", tuple())
+        fontcb.executeAction("CLICK", tuple())
+        patterncb.executeAction("CLICK", tuple())
+        alignmentcb.executeAction("CLICK", tuple())
+        autofitcb.executeAction("CLICK", tuple())
+
+        xOKBtn = xDialog.getChild("ok")
+        self.ui_test.close_dialog_through_button(xOKBtn)
+
+        #verify
+        self.ui_test.execute_dialog_through_command(".uno:AutoFormat")
+        xDialog = self.xUITest.getTopFocusWindow()
+
+        formatlb = xDialog.getChild("formatlb")
+        numformatcb = xDialog.getChild("numformatcb")
+        bordercb = xDialog.getChild("bordercb")
+        fontcb = xDialog.getChild("fontcb")
+        patterncb = xDialog.getChild("patterncb")
+        alignmentcb = xDialog.getChild("alignmentcb")
+        autofitcb = xDialog.getChild("autofitcb")
+
+        entry = formatlb.getChild("7") #Financial
+        entry.executeAction("SELECT", tuple())
+        self.assertEqual(get_state_as_dict(numformatcb)["Selected"], "false")
+        self.assertEqual(get_state_as_dict(bordercb)["Selected"], "false")
+        self.assertEqual(get_state_as_dict(fontcb)["Selected"], "false")
+        self.assertEqual(get_state_as_dict(patterncb)["Selected"], "false")
+        self.assertEqual(get_state_as_dict(alignmentcb)["Selected"], "false")
+        self.assertEqual(get_state_as_dict(autofitcb)["Selected"], "false")
+        numformatcb.executeAction("CLICK", tuple())
+        bordercb.executeAction("CLICK", tuple())
+        fontcb.executeAction("CLICK", tuple())
+        patterncb.executeAction("CLICK", tuple())
+        alignmentcb.executeAction("CLICK", tuple())
+        autofitcb.executeAction("CLICK", tuple())
+        xOKBtn = xDialog.getChild("ok")
+        self.ui_test.close_dialog_through_button(xOKBtn)
+
+        self.ui_test.close_doc()
+
+# vim: set shiftwidth=4 softtabstop=4 expandtab:
diff --git a/sc/qa/uitest/calc_tests6/autocorrectOptions.py b/sc/qa/uitest/calc_tests6/autocorrectOptions.py
new file mode 100644
index 000000000..146e3300f
--- /dev/null
+++ b/sc/qa/uitest/calc_tests6/autocorrectOptions.py
@@ -0,0 +1,95 @@
+# -*- 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
+from uitest.uihelper.common import get_state_as_dict
+import time
+from uitest.debug import sleep
+from uitest.uihelper.common import select_pos
+
+class autocorrectOptions(UITestCase):
+
+   def test_autocorrect_options_calc(self):
+        self.ui_test.create_doc_in_start_center("calc")
+        xCalcDoc = self.xUITest.getTopFocusWindow()
+        gridwin = xCalcDoc.getChild("grid_window")
+        document = self.ui_test.get_component()
+
+        self.ui_test.execute_dialog_through_command(".uno:AutoCorrectDlg")
+        xDialog = self.xUITest.getTopFocusWindow()
+        xTabs = xDialog.getChild("tabcontrol")
+        select_pos(xTabs, "0")       #tab replace
+        origtext = xDialog.getChild("origtext")
+        newtext = xDialog.getChild("newtext")
+        xnew = xDialog.getChild("new")
+        xdelete = xDialog.getChild("delete")
+        xtabview = xDialog.getChild("tabview")
+        xreset = xDialog.getChild("reset")
+        nrRows = get_state_as_dict(xtabview)["VisibleCount"]
+
+        #add new rule
+        origtext.executeAction("TYPE", mkPropertyValues({"KEYCODE":"CTRL+A"}))
+        origtext.executeAction("TYPE", mkPropertyValues({"KEYCODE":"BACKSPACE"}))
+        origtext.executeAction("TYPE", mkPropertyValues({"TEXT":"::::"}))
+        newtext.executeAction("TYPE", mkPropertyValues({"KEYCODE":"CTRL+A"}))
+        newtext.executeAction("TYPE", mkPropertyValues({"KEYCODE":"BACKSPACE"}))
+        newtext.executeAction("TYPE", mkPropertyValues({"TEXT":"dvojtecky"}))
+        xnew.executeAction("CLICK", tuple())
+        nrRowsNew = get_state_as_dict(xtabview)["VisibleCount"]
+        nrRowsDiff = int(nrRowsNew) - int(nrRows)
+        self.assertEqual(nrRowsDiff, 1)  #we have +1 rule
+        #delete rule
+        origtext.executeAction("TYPE", mkPropertyValues({"KEYCODE":"CTRL+A"}))
+        origtext.executeAction("TYPE", mkPropertyValues({"KEYCODE":"BACKSPACE"}))
+        origtext.executeAction("TYPE", mkPropertyValues({"TEXT":"::::"}))
+        newtext.executeAction("TYPE", mkPropertyValues({"KEYCODE":"CTRL+A"}))
+        newtext.executeAction("TYPE", mkPropertyValues({"KEYCODE":"BACKSPACE"}))
+        newtext.executeAction("TYPE", mkPropertyValues({"TEXT":"dvojtecky"}))
+        xdelete.executeAction("CLICK", tuple())
+        self.assertEqual(get_state_as_dict(xtabview)["VisibleCount"], nrRows)   #we have default nr of rules
+
+        select_pos(xTabs, "1")     #tab Exceptions
+        #abbreviations
+        abbrev = xDialog.getChild("abbrev")
+        newabbrev = xDialog.getChild("newabbrev")
+        delabbrev = xDialog.getChild("delabbrev")
+        abbrevlist = xDialog.getChild("abbrevlist")
+
+        nrRowsAbb = get_state_as_dict(abbrevlist)["Children"]
+        abbrev.executeAction("TYPE", mkPropertyValues({"KEYCODE":"CTRL+A"}))
+        abbrev.executeAction("TYPE", mkPropertyValues({"KEYCODE":"BACKSPACE"}))
+        abbrev.executeAction("TYPE", mkPropertyValues({"TEXT":"qqqqq"}))
+        newabbrev.executeAction("CLICK", tuple())
+        nrRowsAbbNew = get_state_as_dict(abbrevlist)["Children"]
+        nrRowsAbbDiff = int(nrRowsAbbNew) - int(nrRowsAbb)
+        self.assertEqual(nrRowsAbbDiff, 1)  #we have +1 rule
+        delabbrev.executeAction("CLICK", tuple())
+        self.assertEqual(get_state_as_dict(abbrevlist)["Children"], nrRowsAbb)   #we have default nr of rules
+
+        #words with two initial capitals
+        double = xDialog.getChild("double")
+        newdouble = xDialog.getChild("newdouble")
+        deldouble = xDialog.getChild("deldouble")
+        doublelist = xDialog.getChild("doublelist")
+
+        nrRowsDouble = get_state_as_dict(doublelist)["Children"]
+        double.executeAction("TYPE", mkPropertyValues({"KEYCODE":"CTRL+A"}))
+        double.executeAction("TYPE", mkPropertyValues({"KEYCODE":"BACKSPACE"}))
+        double.executeAction("TYPE", mkPropertyValues({"TEXT":"QQqqq"}))
+        newdouble.executeAction("CLICK", tuple())
+        nrRowsDoubleNew = get_state_as_dict(doublelist)["Children"]
+        nrRowsDoubleDiff = int(nrRowsDoubleNew) - int(nrRowsDouble) #convert string and
+        self.assertEqual(nrRowsDoubleDiff, 1)  #we have +1 rule
+        deldouble.executeAction("CLICK", tuple())
+        self.assertEqual(get_state_as_dict(doublelist)["Children"], nrRowsDouble)   #we have default nr of rules
+
+        xCancelButton = xDialog.getChild("cancel")
+        xCancelButton.executeAction("CLICK", tuple())
+
+        self.ui_test.close_doc()
+
+# vim: set shiftwidth=4 softtabstop=4 expandtab:
diff --git a/sc/qa/uitest/calc_tests6/moveCopySheet.py b/sc/qa/uitest/calc_tests6/moveCopySheet.py
new file mode 100644
index 000000000..16370451e
--- /dev/null
+++ b/sc/qa/uitest/calc_tests6/moveCopySheet.py
@@ -0,0 +1,84 @@
+# -*- 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.debug import sleep
+from uitest.uihelper.calc import enter_text_to_cell
+from libreoffice.calc.document import get_cell_by_position
+from libreoffice.uno.propertyvalue import mkPropertyValues
+#uitest sc - move/copy sheet dialog
+
+class moveCopySheet(UITestCase):
+    def test_copy_move_sheet(self):
+        writer_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()
+        #default - 1 sheet; select the sheet (is selected), dialog move/copy sheet
+        self.ui_test.execute_dialog_through_command(".uno:Move")
+        xDialog = self.xUITest.getTopFocusWindow()
+        #new name = newName
+        newName = xDialog.getChild("newName")
+        newName.executeAction("TYPE", mkPropertyValues({"KEYCODE":"CTRL+A"}))
+        newName.executeAction("TYPE", mkPropertyValues({"KEYCODE":"BACKSPACE"}))
+        newName.executeAction("TYPE", mkPropertyValues({"TEXT":"newName"}))
+        xOKBtn = xDialog.getChild("ok")
+        self.ui_test.close_dialog_through_button(xOKBtn)
+        #verify, the file has 2 sheets; first one "newName" is selected
+        self.assertEqual(document.Sheets.getCount(), 2)
+        # dialog move/copy sheet ; Move is selected; select -move to end position - ; New Name = moveName
+        self.ui_test.execute_dialog_through_command(".uno:Move")
+        xDialog = self.xUITest.getTopFocusWindow()
+        insertBefore = xDialog.getChild("insertBefore")
+
+        xTreeEntry = insertBefore.getChild('2')
+        xTreeEntry.executeAction("SELECT", tuple())
+
+        newName = xDialog.getChild("newName")
+        self.assertEqual(get_state_as_dict(newName)["Text"], "newName")
+        newName.executeAction("TYPE", mkPropertyValues({"KEYCODE":"CTRL+A"}))
+        newName.executeAction("TYPE", mkPropertyValues({"KEYCODE":"BACKSPACE"}))
+        newName.executeAction("TYPE", mkPropertyValues({"TEXT":"moveName"}))
+        xOKBtn = xDialog.getChild("ok")
+        self.ui_test.close_dialog_through_button(xOKBtn)
+        # Verify, the file has 2 sheets; first one is "Sheet1" ; second one is "moveName"
+        self.assertEqual(document.Sheets.getCount(), 2)
+
+        self.assertEqual(document.Sheets[0].Name, "Sheet1")
+        self.assertEqual(document.Sheets[1].Name, "moveName")
+
+        # Verify that the cancel button does not do anything
+        self.ui_test.execute_dialog_through_command(".uno:Move")
+        xDialog = self.xUITest.getTopFocusWindow()
+        xCancelBtn = xDialog.getChild("cancel")
+        self.ui_test.close_dialog_through_button(xCancelBtn)
+
+        self.assertEqual(document.Sheets.getCount(), 2)
+        self.assertEqual(document.Sheets[0].Name, "Sheet1")
+        self.assertEqual(document.Sheets[1].Name, "moveName")
+
+        #Check copy option
+        self.ui_test.execute_dialog_through_command(".uno:Move")
+        xDialog = self.xUITest.getTopFocusWindow()
+        xCopy = xDialog.getChild("copy")
+        xCopy.executeAction("CLICK", tuple())
+        sheetName = "moveName_2"
+        newName = xDialog.getChild("newName")
+        self.assertEqual(get_state_as_dict(newName)["Text"], sheetName)
+
+        xOKBtn = xDialog.getChild("ok")
+        self.ui_test.close_dialog_through_button(xOKBtn)
+
+        self.assertEqual(document.Sheets.getCount(), 3)
+        self.assertEqual(document.Sheets[0].Name, sheetName)
+        self.assertEqual(document.Sheets[1].Name, "Sheet1")
+        self.assertEqual(document.Sheets[2].Name, "moveName")
+
+        self.ui_test.close_doc()
+
+# vim: set shiftwidth=4 softtabstop=4 expandtab:
diff --git a/sc/qa/uitest/calc_tests6/multipleOperations.py b/sc/qa/uitest/calc_tests6/multipleOperations.py
new file mode 100644
index 000000000..34fc4691d
--- /dev/null
+++ b/sc/qa/uitest/calc_tests6/multipleOperations.py
@@ -0,0 +1,129 @@
+# -*- 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
+from uitest.uihelper.common import get_state_as_dict
+import time
+from libreoffice.calc.document import get_cell_by_position
+from uitest.uihelper.calc import enter_text_to_cell
+from uitest.debug import sleep
+from uitest.uihelper.common import select_pos
+
+#https://www.linuxtopia.org/online_books/office_guides/openoffice_3_calc_user_guide/openoffice_calc_Multiple_operations_Multiple_operations_in_columns_or_rows.html
+
+class multipleOperations(UITestCase):
+
+   def test_multiple_operations_one_variable(self):
+        self.ui_test.create_doc_in_start_center("calc")
+        xCalcDoc = self.xUITest.getTopFocusWindow()
+        xGridWindow = xCalcDoc.getChild("grid_window")
+        document = self.ui_test.get_component()
+
+        #enter data
+        enter_text_to_cell(xGridWindow, "B1", "10")
+        enter_text_to_cell(xGridWindow, "B2", "2")
+        enter_text_to_cell(xGridWindow, "B3", "10000")
+        enter_text_to_cell(xGridWindow, "B4", "2000")
+        enter_text_to_cell(xGridWindow, "B5", "=B4*(B1-B2)-B3")
+
+        enter_text_to_cell(xGridWindow, "D2", "500")
+        enter_text_to_cell(xGridWindow, "D3", "1000")
+        enter_text_to_cell(xGridWindow, "D4", "1500")
+        enter_text_to_cell(xGridWindow, "D5", "2000")
+        enter_text_to_cell(xGridWindow, "D6", "2500")
+        enter_text_to_cell(xGridWindow, "D7", "3000")
+        enter_text_to_cell(xGridWindow, "D8", "3500")
+        enter_text_to_cell(xGridWindow, "D9", "4000")
+        enter_text_to_cell(xGridWindow, "D10", "4500")
+        enter_text_to_cell(xGridWindow, "D11", "5000")
+        #Select the range D2:E11
+        xGridWindow.executeAction("SELECT", mkPropertyValues({"RANGE": "D2:E11"}))
+        #Choose Data > Multiple Operations.
+        self.ui_test.execute_modeless_dialog_through_command(".uno:TableOperationDialog")
+        xDialog = self.xUITest.getTopFocusWindow()
+        #Formulas = B5 ; Column input cell = B4
+        formulas = xDialog.getChild("formulas")
+        col = xDialog.getChild("col")
+        formulas.executeAction("TYPE", mkPropertyValues({"TEXT":"$B$5"}))
+        col.executeAction("TYPE", mkPropertyValues({"TEXT":"$B$4"}))
+        xOKBtn = xDialog.getChild("ok")
+        self.ui_test.close_dialog_through_button(xOKBtn)
+        #verify
+        self.assertEqual(get_cell_by_position(document, 0, 4, 1).getValue(), -6000)
+        self.assertEqual(get_cell_by_position(document, 0, 4, 2).getValue(), -2000)
+        self.assertEqual(get_cell_by_position(document, 0, 4, 3).getValue(), 2000)
+        self.assertEqual(get_cell_by_position(document, 0, 4, 4).getValue(), 6000)
+        self.assertEqual(get_cell_by_position(document, 0, 4, 5).getValue(), 10000)
+        self.assertEqual(get_cell_by_position(document, 0, 4, 6).getValue(), 14000)
+        self.assertEqual(get_cell_by_position(document, 0, 4, 7).getValue(), 18000)
+        self.assertEqual(get_cell_by_position(document, 0, 4, 8).getValue(), 22000)
+        self.assertEqual(get_cell_by_position(document, 0, 4, 9).getValue(), 26000)
+        self.assertEqual(get_cell_by_position(document, 0, 4, 10).getValue(), 30000)
+
+        self.ui_test.close_doc()
+   def test_multiple_operations_several_formulas(self):
+        self.ui_test.create_doc_in_start_center("calc")
+        xCalcDoc = self.xUITest.getTopFocusWindow()
+        xGridWindow = xCalcDoc.getChild("grid_window")
+        document = self.ui_test.get_component()
+
+        #enter data
+        enter_text_to_cell(xGridWindow, "B1", "10")
+        enter_text_to_cell(xGridWindow, "B2", "2")
+        enter_text_to_cell(xGridWindow, "B3", "10000")
+        enter_text_to_cell(xGridWindow, "B4", "2000")
+        enter_text_to_cell(xGridWindow, "B5", "=B4*(B1-B2)-B3")
+        enter_text_to_cell(xGridWindow, "C5", "=B5/B4")
+
+        enter_text_to_cell(xGridWindow, "D2", "500")
+        enter_text_to_cell(xGridWindow, "D3", "1000")
+        enter_text_to_cell(xGridWindow, "D4", "1500")
+        enter_text_to_cell(xGridWindow, "D5", "2000")
+        enter_text_to_cell(xGridWindow, "D6", "2500")
+        enter_text_to_cell(xGridWindow, "D7", "3000")
+        enter_text_to_cell(xGridWindow, "D8", "3500")
+        enter_text_to_cell(xGridWindow, "D9", "4000")
+        enter_text_to_cell(xGridWindow, "D10", "4500")
+        enter_text_to_cell(xGridWindow, "D11", "5000")
+        #Select the range D2:F11
+        xGridWindow.executeAction("SELECT", mkPropertyValues({"RANGE": "D2:F11"}))
+        #Choose Data > Multiple Operations.
+        self.ui_test.execute_modeless_dialog_through_command(".uno:TableOperationDialog")
+        xDialog = self.xUITest.getTopFocusWindow()
+        #Formulas = B5 ; Column input cell = B4
+        formulas = xDialog.getChild("formulas")
+        col = xDialog.getChild("col")
+        formulas.executeAction("TYPE", mkPropertyValues({"TEXT":"$B$5:$C$5"}))
+        col.executeAction("TYPE", mkPropertyValues({"TEXT":"$B$4"}))
+        xOKBtn = xDialog.getChild("ok")
+        self.ui_test.close_dialog_through_button(xOKBtn)
+        #verify
+        self.assertEqual(get_cell_by_position(document, 0, 4, 1).getValue(), -6000)
+        self.assertEqual(get_cell_by_position(document, 0, 4, 2).getValue(), -2000)
+        self.assertEqual(get_cell_by_position(document, 0, 4, 3).getValue(), 2000)
+        self.assertEqual(get_cell_by_position(document, 0, 4, 4).getValue(), 6000)
+        self.assertEqual(get_cell_by_position(document, 0, 4, 5).getValue(), 10000)
+        self.assertEqual(get_cell_by_position(document, 0, 4, 6).getValue(), 14000)
+        self.assertEqual(get_cell_by_position(document, 0, 4, 7).getValue(), 18000)
+        self.assertEqual(get_cell_by_position(document, 0, 4, 8).getValue(), 22000)
+        self.assertEqual(get_cell_by_position(document, 0, 4, 9).getValue(), 26000)
+        self.assertEqual(get_cell_by_position(document, 0, 4, 10).getValue(), 30000)
+
+        self.assertEqual(get_cell_by_position(document, 0, 5, 1).getValue(), -12)
+        self.assertEqual(get_cell_by_position(document, 0, 5, 2).getValue(), -2)
+        self.assertEqual(round(get_cell_by_position(document, 0, 5, 3).getValue(),2), 1.33)
+        self.assertEqual(get_cell_by_position(document, 0, 5, 4).getValue(), 3)
+        self.assertEqual(get_cell_by_position(document, 0, 5, 5).getValue(), 4)
+        self.assertEqual(round(get_cell_by_position(document, 0, 5, 6).getValue(),2), 4.67)
+        self.assertEqual(round(get_cell_by_position(document, 0, 5, 7).getValue(),2), 5.14)
+        self.assertEqual(get_cell_by_position(document, 0, 5, 8).getValue(), 5.5)
+        self.assertEqual(round(get_cell_by_position(document, 0, 5, 9).getValue(),2), 5.78)
+        self.assertEqual(get_cell_by_position(document, 0, 5, 10).getValue(), 6)
+
+        self.ui_test.close_doc()
+
+# vim: set shiftwidth=4 softtabstop=4 expandtab:
diff --git a/sc/qa/uitest/calc_tests6/scenarios.py b/sc/qa/uitest/calc_tests6/scenarios.py
new file mode 100644
index 000000000..67f7952ae
--- /dev/null
+++ b/sc/qa/uitest/calc_tests6/scenarios.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 libreoffice.uno.propertyvalue import mkPropertyValues
+from uitest.uihelper.common import get_state_as_dict
+import time
+from libreoffice.calc.document import get_cell_by_position
+from uitest.uihelper.calc import enter_text_to_cell
+from uitest.debug import sleep
+from uitest.uihelper.common import select_pos
+
+# uitest Tools - Scenarios
+
+class scenarios(UITestCase):
+
+   def test_scenarios(self):
+        self.ui_test.create_doc_in_start_center("calc")
+        xCalcDoc = self.xUITest.getTopFocusWindow()
+        xGridWindow = xCalcDoc.getChild("grid_window")
+        document = self.ui_test.get_component()
+
+        #fill B1:B4  with 1, select B1:B4;
+        enter_text_to_cell(xGridWindow, "B1", "1")
+        enter_text_to_cell(xGridWindow, "B2", "1")
+        enter_text_to_cell(xGridWindow, "B3", "1")
+        enter_text_to_cell(xGridWindow, "B4", "1")
+        xGridWindow.executeAction("SELECT", mkPropertyValues({"RANGE": "B1:B4"}))
+        #scenarios - scenario A1
+        self.ui_test.execute_dialog_through_command(".uno:ScenarioManager")
+        xDialog = self.xUITest.getTopFocusWindow()
+
+        name = xDialog.getChild("name")
+        name.executeAction("TYPE", mkPropertyValues({"KEYCODE":"CTRL+A"}))
+        name.executeAction("TYPE", mkPropertyValues({"KEYCODE":"BACKSPACE"}))
+        name.executeAction("TYPE", mkPropertyValues({"TEXT":"A1"}))
+        xOKBtn = xDialog.getChild("ok")
+        self.ui_test.close_dialog_through_button(xOKBtn)
+
+        #next scenarios - scenario B1
+        self.ui_test.execute_dialog_through_command(".uno:ScenarioManager")
+        xDialog = self.xUITest.getTopFocusWindow()
+
+        name = xDialog.getChild("name")
+        name.executeAction("TYPE", mkPropertyValues({"KEYCODE":"CTRL+A"}))
+        name.executeAction("TYPE", mkPropertyValues({"KEYCODE":"BACKSPACE"}))
+        name.executeAction("TYPE", mkPropertyValues({"TEXT":"B1"}))
+        xOKBtn = xDialog.getChild("ok")
+        self.ui_test.close_dialog_through_button(xOKBtn)
+
+        self.ui_test.close_doc()
+# vim: set shiftwidth=4 softtabstop=4 expandtab:
diff --git a/sc/qa/uitest/calc_tests6/shareSpreadsheet.py b/sc/qa/uitest/calc_tests6/shareSpreadsheet.py
new file mode 100644
index 000000000..a2f5be555
--- /dev/null
+++ b/sc/qa/uitest/calc_tests6/shareSpreadsheet.py
@@ -0,0 +1,38 @@
+# -*- 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
+from uitest.uihelper.common import get_state_as_dict
+import time
+from libreoffice.calc.document import get_cell_by_position
+from uitest.uihelper.calc import enter_text_to_cell
+from uitest.debug import sleep
+from uitest.uihelper.common import select_pos
+
+#just open dialog, select Share, check name and cancel [save not allowed in uitest]
+
+class shareSpreadsheet(UITestCase):
+
+   def test_share_spreadsheet(self):
+        self.ui_test.create_doc_in_start_center("calc")
+        xCalcDoc = self.xUITest.getTopFocusWindow()
+        xGridWindow = xCalcDoc.getChild("grid_window")
+        document = self.ui_test.get_component()
+
+        #dialog shareSpreadsheet
+        self.ui_test.execute_dialog_through_command(".uno:ShareDocument")
+        xDialog = self.xUITest.getTopFocusWindow()
+
+        share = xDialog.getChild("share")
+        share.executeAction("CLICK", tuple())
+        users = xDialog.getChild("users")
+        self.assertEqual(get_state_as_dict(users)["Children"], "1")
+        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_tests6/tdf107267.py b/sc/qa/uitest/calc_tests6/tdf107267.py
new file mode 100644
index 000000000..34a9a4fa0
--- /dev/null
+++ b/sc/qa/uitest/calc_tests6/tdf107267.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/.
+#
+
+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 time
+from uitest.debug import sleep
+
+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 107267 - During a sub-total calculation or sum, the data set is not computed well.
+class Subtotals(UITestCase):
+
+
+    def test_tdf107267(self):
+        calc_doc = self.ui_test.load_file(get_url_for_data_file("tdf107267.ods"))
+        XcalcDoc = self.xUITest.getTopFocusWindow()
+        document = self.ui_test.get_component()
+        gridwin = XcalcDoc.getChild("grid_window")
+        # 1. Open the test file
+        gridwin.executeAction("SELECT", mkPropertyValues({"RANGE": "A1:F123"}))
+        # 2. Data->Subtotals
+        self.ui_test.execute_dialog_through_command(".uno:DataSubTotals")
+        xDialog = self.xUITest.getTopFocusWindow()
+        xTabs = xDialog.getChild("tabcontrol")
+        select_pos(xTabs, "0")
+        # = 1st group = 3. Group by "Person Number", select "shipping time" and use the Max function.
+        xGroupBy = xDialog.getChild("group_by")
+        props = {"TEXT": "Person Number"}
+        actionProps = mkPropertyValues(props)
+        xGroupBy.executeAction("SELECT", actionProps)
+        # 4. Tick 'Calculate subtotals for' -> "shipping time" - already selected
+#        xCheckListMenu = xDialog.getChild("grid1")
+#        xTreeList = xCheckListMenu.getChild("columns")
+#        x6Entry = xTreeList.getChild("5")
+#        xFirstEntry.executeAction("CLICK", tuple())
+        #use the Max function
+        xfunctions = xDialog.getChild("functions")
+        propsF = {"TEXT": "Max"}
+        actionPropsF = mkPropertyValues(propsF)
+        xfunctions.executeAction("SELECT", actionPropsF)
+
+        #= 2nd group =5. Group by "Person Number", select "shipping time" and use the Min function.
+        select_pos(xTabs, "1")
+        xGroupBy = xDialog.getChild("group_by")
+        props = {"TEXT": "Person Number"}
+        actionProps = mkPropertyValues(props)
+        xGroupBy.executeAction("SELECT", actionProps)
+        # 4. Tick 'Calculate subtotals for' -> "shipping time" - already selected
+#        xCheckListMenu = xDialog.getChild("grid1")
+#        xTreeList = xCheckListMenu.getChild("columns")
+#        x6Entry = xTreeList.getChild("5")
+#        xFirstEntry.executeAction("CLICK", tuple())
+        #use the Min function
+        xfunctions = xDialog.getChild("functions")
+        propsF2 = {"TEXT": "Min"}
+        actionPropsF2 = mkPropertyValues(propsF2)
+        xfunctions.executeAction("SELECT", actionPropsF2)
+
+        #= 3rd group = Group by "Person Number", select "shipping time" and use the Average function.
+        select_pos(xTabs, "2")
+        xGroupBy = xDialog.getChild("group_by")
+        props = {"TEXT": "Person Number"}
+        actionProps = mkPropertyValues(props)
+        xGroupBy.executeAction("SELECT", actionProps)
+        # 4. Tick 'Calculate subtotals for' -> "shipping time" - already selected
+#        xCheckListMenu = xDialog.getChild("grid1")
+#        xTreeList = xCheckListMenu.getChild("columns")
+#        x6Entry = xTreeList.getChild("5")
+#        xFirstEntry.executeAction("CLICK", tuple())
+        #use the Average function
+        xfunctions = xDialog.getChild("functions")
+        propsF3 = {"TEXT": "Average"}
+        actionPropsF3 = mkPropertyValues(propsF3)
+        xfunctions.executeAction("SELECT", actionPropsF3)
+
+        # 5. Click OK
+        xOKBtn = xDialog.getChild("ok")
+        self.ui_test.close_dialog_through_button(xOKBtn)
+
+        #verify
+        self.assertEqual(get_cell_by_position(document, 0, 0, 141).getString(), "Grand Average")
+        self.assertEqual(get_cell_by_position(document, 0, 0, 142).getString(), "Grand Min")
+        self.assertEqual(get_cell_by_position(document, 0, 0, 143).getString(), "Grand Max")
+
+        self.assertEqual(round(get_cell_by_position(document, 0, 5, 141).getValue(), 13), 3.3852459016393)
+        self.assertEqual(get_cell_by_position(document, 0, 5, 142).getValue(), 0)
+        self.assertEqual(get_cell_by_position(document, 0, 5, 143).getValue(), 26)
+
+        self.ui_test.close_doc()
+
+# vim: set shiftwidth=4 softtabstop=4 expandtab:
diff --git a/sc/qa/uitest/calc_tests6/tdf107869.py b/sc/qa/uitest/calc_tests6/tdf107869.py
new file mode 100644
index 000000000..d38861043
--- /dev/null
+++ b/sc/qa/uitest/calc_tests6/tdf107869.py
@@ -0,0 +1,93 @@
+# -*- 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
+
+#https://bugs.documentfoundation.org/show_bug.cgi?id=107869
+def get_url_for_data_file(file_name):
+    return pathlib.Path(org.libreoffice.unotest.makeCopyFromTDOC(file_name)).as_uri()
+
+class tdf107869(UITestCase):
+    def test_tdf107869_undo_redo_delete_row_with_comment(self):
+        calc_doc = self.ui_test.load_file(get_url_for_data_file("comments.ods"))
+        xCalcDoc = self.xUITest.getTopFocusWindow()
+        gridwin = xCalcDoc.getChild("grid_window")
+        document = self.ui_test.get_component()
+        #- Delete the row with comment.
+        #select row 1
+        gridwin.executeAction("SELECT", mkPropertyValues({"CELL": "A1"}))
+        self.xUITest.executeCommand(".uno:SelectRow")
+        #delete row 1
+        self.xUITest.executeCommand(".uno:DeleteRows")
+        #A1 should be "B"
+        self.assertEqual(get_cell_by_position(document, 0, 0, 0).getString(), "B")
+        #- Undo-redo deletion a few times.
+        self.xUITest.executeCommand(".uno:Undo")
+        self.assertEqual(get_cell_by_position(document, 0, 0, 0).getString(), "A")
+        self.xUITest.executeCommand(".uno:Redo")
+        self.assertEqual(get_cell_by_position(document, 0, 0, 0).getString(), "B")
+        self.xUITest.executeCommand(".uno:Undo")
+        self.assertEqual(get_cell_by_position(document, 0, 0, 0).getString(), "A")
+        self.xUITest.executeCommand(".uno:Redo")
+        self.assertEqual(get_cell_by_position(document, 0, 0, 0).getString(), "B")
+        self.xUITest.executeCommand(".uno:Undo")
+        self.assertEqual(get_cell_by_position(document, 0, 0, 0).getString(), "A")
+        self.xUITest.executeCommand(".uno:Redo")
+        self.assertEqual(get_cell_by_position(document, 0, 0, 0).getString(), "B")
+        self.xUITest.executeCommand(".uno:Undo")
+        self.assertEqual(get_cell_by_position(document, 0, 0, 0).getString(), "A")
+        self.xUITest.executeCommand(".uno:Redo")
+        self.assertEqual(get_cell_by_position(document, 0, 0, 0).getString(), "B")
+        self.xUITest.executeCommand(".uno:Undo")
+        self.assertEqual(get_cell_by_position(document, 0, 0, 0).getString(), "A")
+        self.xUITest.executeCommand(".uno:Redo")
+        self.assertEqual(get_cell_by_position(document, 0, 0, 0).getString(), "B")
+        self.xUITest.executeCommand(".uno:Undo")
+        self.assertEqual(get_cell_by_position(document, 0, 0, 0).getString(), "A")
+        self.xUITest.executeCommand(".uno:Redo")
+        self.assertEqual(get_cell_by_position(document, 0, 0, 0).getString(), "B")
+        self.xUITest.executeCommand(".uno:Undo")
+        self.assertEqual(get_cell_by_position(document, 0, 0, 0).getString(), "A")
+
+        #select row 1 and 2
+        gridwin.executeAction("SELECT", mkPropertyValues({"RANGE": "A1:A2"}))
+        self.xUITest.executeCommand(".uno:SelectRow")
+        #delete row 1
+        self.xUITest.executeCommand(".uno:DeleteRows")
+        #A1 should be ""
+        self.assertEqual(get_cell_by_position(document, 0, 0, 0).getString(), "")
+        #- Undo-redo deletion a few times.
+        self.xUITest.executeCommand(".uno:Undo")
+        self.assertEqual(get_cell_by_position(document, 0, 0, 0).getString(), "A")
+        self.xUITest.executeCommand(".uno:Redo")
+        self.assertEqual(get_cell_by_position(document, 0, 0, 0).getString(), "")
+        self.xUITest.executeCommand(".uno:Undo")
+        self.assertEqual(get_cell_by_position(document, 0, 0, 0).getString(), "A")
+        self.xUITest.executeCommand(".uno:Redo")
+        self.assertEqual(get_cell_by_position(document, 0, 0, 0).getString(), "")
+        self.xUITest.executeCommand(".uno:Undo")
+        self.assertEqual(get_cell_by_position(document, 0, 0, 0).getString(), "A")
+        self.xUITest.executeCommand(".uno:Redo")
+        self.assertEqual(get_cell_by_position(document, 0, 0, 0).getString(), "")
+        self.xUITest.executeCommand(".uno:Undo")
+        self.assertEqual(get_cell_by_position(document, 0, 0, 0).getString(), "A")
+        self.xUITest.executeCommand(".uno:Redo")
+        self.assertEqual(get_cell_by_position(document, 0, 0, 0).getString(), "")
+        self.xUITest.executeCommand(".uno:Undo")
+        self.assertEqual(get_cell_by_position(document, 0, 0, 0).getString(), "A")
+        self.xUITest.executeCommand(".uno:Redo")
+        self.assertEqual(get_cell_by_position(document, 0, 0, 0).getString(), "")
+
+        self.ui_test.close_doc()
+
+# vim: set shiftwidth=4 softtabstop=4 expandtab:
diff --git a/sc/qa/uitest/calc_tests6/tdf108654.py b/sc/qa/uitest/calc_tests6/tdf108654.py
new file mode 100644
index 000000000..93576fe41
--- /dev/null
+++ b/sc/qa/uitest/calc_tests6/tdf108654.py
@@ -0,0 +1,48 @@
+# -*- 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()
+
+#Bug 108654 - CRASH while undoing paste on a new sheet
+class tdf108654(UITestCase):
+    def test_tdf108654_Undo_paste_crash(self):
+        calc_doc = self.ui_test.load_file(get_url_for_data_file("tdf108654.ods"))
+        xCalcDoc = self.xUITest.getTopFocusWindow()
+        gridwin = xCalcDoc.getChild("grid_window")
+        document = self.ui_test.get_component()
+        #Sheet3 - CTRL+A & CTRL+C
+        gridwin.executeAction("SELECT", mkPropertyValues({"CELL": "A1"}))
+        self.xUITest.executeCommand(".uno:SelectAll")
+        self.xUITest.executeCommand(".uno:Copy")
+        #Create a new sheet & paste (CTRL-V)
+        self.ui_test.execute_dialog_through_command(".uno:Insert")  #insert sheet
+        xDialog = self.xUITest.getTopFocusWindow()
+        xOKButton = xDialog.getChild("ok")
+        self.ui_test.close_dialog_through_button(xOKButton)
+
+        self.assertEqual(document.Sheets.getCount(), 4)
+
+        self.xUITest.executeCommand(".uno:Paste")
+        #Undo the action twice
+        self.xUITest.executeCommand(".uno:Undo")
+        self.xUITest.executeCommand(".uno:Undo")
+
+        #-> CRASH
+        self.assertEqual(document.Sheets.getCount(), 3)
+
+        self.ui_test.close_doc()
+
+# vim: set shiftwidth=4 softtabstop=4 expandtab:
diff --git a/sc/qa/uitest/calc_tests6/tdf116996.py b/sc/qa/uitest/calc_tests6/tdf116996.py
new file mode 100644
index 000000000..77647d1f5
--- /dev/null
+++ b/sc/qa/uitest/calc_tests6/tdf116996.py
@@ -0,0 +1,65 @@
+# -*- 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 116996 - Crash recover on selecting Tools -> Options -> Advanced: Enable experimental features
+
+class tdf116996(UITestCase):
+    def test_tdf116996_enable_experimental_feature(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()
+
+        self.ui_test.execute_dialog_through_command(".uno:OptionsTreeDialog")  #optionsdialog
+        xDialogOpt = self.xUITest.getTopFocusWindow()
+
+        xPages = xDialogOpt.getChild("pages")
+        xLOEntry = xPages.getChild('0')                 # Libreoffice
+        xLOEntry.executeAction("EXPAND", tuple())
+        xAdvancedEntry = xLOEntry.getChild('10')
+        xAdvancedEntry.executeAction("SELECT", tuple())          #Libreoffice / Advanced
+        xexperimental = xDialogOpt.getChild("experimental")
+        xexperimental.executeAction("CLICK", tuple())          #enable experimental features
+
+        xOKBtn = xDialogOpt.getChild("ok")
+
+        def handle_confirm_dlg(dialog):
+            xLaterBtn = dialog.getChild("no")
+            self.ui_test.close_dialog_through_button(xLaterBtn)
+
+        self.ui_test.execute_blocking_action(xOKBtn.executeAction, args=('CLICK', ()),
+                dialog_handler=handle_confirm_dlg)
+
+        #reopen options dialog and verify
+        self.ui_test.execute_dialog_through_command(".uno:OptionsTreeDialog")  #optionsdialog
+        xDialogOpt = self.xUITest.getTopFocusWindow()
+        xPages = xDialogOpt.getChild("pages")
+        xLOEntry = xPages.getChild('0')                 # Libreoffice
+        xLOEntry.executeAction("EXPAND", tuple())
+        xAdvancedEntry = xLOEntry.getChild('10')
+        xAdvancedEntry.executeAction("SELECT", tuple())          #Libreoffice / Advanced
+        xexperimental = xDialogOpt.getChild("experimental")
+
+        self.assertEqual(get_state_as_dict(xexperimental)["Selected"], "true")
+        xexperimental.executeAction("CLICK", tuple())       #disable experimental features
+        xOKBtn = xDialogOpt.getChild("ok")
+
+        def handle_confirm_dlg(dialog):
+            xLaterBtn = dialog.getChild("no")
+            self.ui_test.close_dialog_through_button(xLaterBtn)
+
+        self.ui_test.execute_blocking_action(xOKBtn.executeAction, args=('CLICK', ()),
+                dialog_handler=handle_confirm_dlg)
+
+        self.ui_test.close_doc()
+# vim: set shiftwidth=4 softtabstop=4 expandtab:
diff --git a/sc/qa/uitest/calc_tests6/tdf118638.py b/sc/qa/uitest/calc_tests6/tdf118638.py
new file mode 100644
index 000000000..b6e700e01
--- /dev/null
+++ b/sc/qa/uitest/calc_tests6/tdf118638.py
@@ -0,0 +1,69 @@
+# -*- 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 time
+from uitest.debug import sleep
+
+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 118638 - subtotal option loses doesn't contain existing format for column
+class Subtotals(UITestCase):
+
+
+    def test_tdf118638_subtotal_format(self):
+        calc_doc = self.ui_test.load_file(get_url_for_data_file("tdf118638.ods"))
+        XcalcDoc = self.xUITest.getTopFocusWindow()
+        document = self.ui_test.get_component()
+        gridwin = XcalcDoc.getChild("grid_window")
+        # Open the test file
+        gridwin.executeAction("SELECT", mkPropertyValues({"RANGE": "A1:B15"}))
+        #Data->Subtotals
+        self.ui_test.execute_dialog_through_command(".uno:DataSubTotals")
+        xDialog = self.xUITest.getTopFocusWindow()
+        xTabs = xDialog.getChild("tabcontrol")
+        select_pos(xTabs, "0")
+        xGroupBy = xDialog.getChild("group_by")
+        props = {"TEXT": "Store Name"}
+        actionProps = mkPropertyValues(props)
+        xGroupBy.executeAction("SELECT", actionProps)
+        xCheckListMenu = xDialog.getChild("grid1")
+        xTreeList = xCheckListMenu.getChild("columns")
+        xEntry = xTreeList.getChild("1")
+        xEntry.executeAction("CLICK", tuple())
+
+        #use the SUM function
+#        xfunctions = xDialog.getChild("functions")
+#        propsF = {"TEXT": "Sum"}
+#        actionPropsF = mkPropertyValues(propsF)
+#        xfunctions.executeAction("SELECT", actionPropsF)
+
+        xOKBtn = xDialog.getChild("ok")
+        self.ui_test.close_dialog_through_button(xOKBtn)
+
+        #verify
+        self.assertEqual(get_cell_by_position(document, 0, 0, 15).getString(), "5408 Sum")
+        self.assertEqual(get_cell_by_position(document, 0, 0, 16).getString(), "Grand Sum")
+
+        self.assertEqual(get_cell_by_position(document, 0, 1, 15).getValue(), 238.89)
+        self.assertEqual(get_cell_by_position(document, 0, 1, 16).getValue(), 238.89)
+
+        self.assertEqual(get_cell_by_position(document, 0, 1, 15).getString(), "$238.89")
+        self.assertEqual(get_cell_by_position(document, 0, 1, 16).getString(), "$238.89")
+
+        self.ui_test.close_doc()
+
+# vim: set shiftwidth=4 softtabstop=4 expandtab:
diff --git a/sc/qa/uitest/calc_tests6/tdf121263.py b/sc/qa/uitest/calc_tests6/tdf121263.py
new file mode 100644
index 000000000..cb66c5772
--- /dev/null
+++ b/sc/qa/uitest/calc_tests6/tdf121263.py
@@ -0,0 +1,51 @@
+# -*- 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.path import get_srcdir_url
+from uitest.uihelper.common import get_state_as_dict
+from libreoffice.calc.document import get_cell_by_position
+import time
+from uitest.debug import sleep
+
+class tdf121263(UITestCase):
+
+    def test_tdf121263_hide_more_sheets(self):
+        calc_doc = self.ui_test.create_doc_in_start_center("calc")
+        xTopWindow = self.xUITest.getTopFocusWindow()
+        document = self.ui_test.get_component()
+        gridwin = xTopWindow.getChild("grid_window")
+
+        self.ui_test.execute_dialog_through_command(".uno:Insert")  #insert sheet
+        xDialog = self.xUITest.getTopFocusWindow()
+        xOKButton = xDialog.getChild("ok")
+        xOKButton.executeAction("CLICK", tuple())
+        self.ui_test.execute_dialog_through_command(".uno:Insert")  #insert sheet
+        xDialog = self.xUITest.getTopFocusWindow()
+        xOKButton = xDialog.getChild("ok")
+        xOKButton.executeAction("CLICK", tuple())
+
+        gridwin.executeAction("SELECT", mkPropertyValues({"TABLE": "2"}))
+        #select previous sheet
+        self.xUITest.executeCommand(".uno:JumpToPrevTableSel")
+
+        #hide sheet
+        self.xUITest.executeCommand(".uno:Hide")
+
+        #show sheet Dialog
+        self.ui_test.execute_dialog_through_command(".uno:Show")
+        xDialog = self.xUITest.getTopFocusWindow()
+        treeview = xDialog.getChild("treeview")
+        self.assertEqual(get_state_as_dict(treeview)["Children"], "2")
+        xcancel = xDialog.getChild("cancel")
+        self.ui_test.close_dialog_through_button(xcancel)
+
+        self.ui_test.close_doc()
+# vim: set shiftwidth=4 softtabstop=4 expandtab:
diff --git a/sc/qa/uitest/calc_tests6/tdf91726.py b/sc/qa/uitest/calc_tests6/tdf91726.py
new file mode 100644
index 000000000..38703cb7e
--- /dev/null
+++ b/sc/qa/uitest/calc_tests6/tdf91726.py
@@ -0,0 +1,58 @@
+# -*- 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
+#Bug 91726 - AutoFormat: Crash when using an existing name for a new preset
+
+class tdf91726(UITestCase):
+    def test_tdf91726_new_style(self):
+        writer_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()
+        #select A1:E9
+        gridwin.executeAction("SELECT", mkPropertyValues({"RANGE": "A1:E9"}))
+        #AutoFormat Styles
+        self.ui_test.execute_dialog_through_command(".uno:AutoFormat")
+        xDialog = self.xUITest.getTopFocusWindow()
+        #add new style "Default"
+        xadd = xDialog.getChild("add")
+        def handle_name_dlg(dialog):
+            nameEntry = dialog.getChild("name_entry")
+            nameEntry.executeAction("TYPE", mkPropertyValues({"TEXT":"Default"}))
+            xOKBtn = dialog.getChild("ok")
+            def handle_error_dlg(dialog2):
+                #Error message: You have entered an invalid name.
+                #AutoFormat could not be created.
+                #Try again using a different name.
+                xOKBtn2 = dialog2.getChild("ok")
+                self.ui_test.close_dialog_through_button(xOKBtn2)
+
+            self.ui_test.execute_blocking_action(xOKBtn.executeAction, args=('CLICK', ()),
+                    dialog_handler=handle_error_dlg)
+
+            xDialog = self.xUITest.getTopFocusWindow()
+            nameEntry = xDialog.getChild("name_entry")
+            #back to name dialog, LO should not crash
+            self.assertEqual(get_state_as_dict(nameEntry)["Text"], "Default")
+            xCanceltn = xDialog.getChild("cancel")
+            self.ui_test.close_dialog_through_button(xCanceltn)
+
+        self.ui_test.execute_blocking_action(xadd.executeAction, args=('CLICK', ()),
+                dialog_handler=handle_name_dlg)
+
+        xCanceltn = xDialog.getChild("cancel")
+        self.ui_test.close_dialog_through_button(xCanceltn)
+
+        self.ui_test.close_doc()
+
+# vim: set shiftwidth=4 softtabstop=4 expandtab: