diff options
| -rw-r--r-- | sc/Module_sc.mk | 1 | ||||
| -rw-r--r-- | sc/UITest_calc_tests6.mk | 20 | ||||
| -rw-r--r-- | sc/qa/uitest/calc_tests/data/tdf107267.ods | bin | 0 -> 16060 bytes | |||
| -rw-r--r-- | sc/qa/uitest/calc_tests6/tdf107267.py | 104 |
4 files changed, 125 insertions, 0 deletions
diff --git a/sc/Module_sc.mk b/sc/Module_sc.mk index b27abde64ed2..9109cc730b64 100644 --- a/sc/Module_sc.mk +++ b/sc/Module_sc.mk @@ -188,6 +188,7 @@ $(eval $(call gb_Module_add_uicheck_targets,sc,\ UITest_calc_tests2 \ UITest_calc_tests3 \ UITest_calc_tests4 \ + UITest_calc_tests6 \ UITest_statistics \ UITest_solver \ UITest_goalSeek \ diff --git a/sc/UITest_calc_tests6.mk b/sc/UITest_calc_tests6.mk new file mode 100644 index 000000000000..9350d460783a --- /dev/null +++ b/sc/UITest_calc_tests6.mk @@ -0,0 +1,20 @@ +# -*- Mode: makefile-gmake; tab-width: 4; indent-tabs-mode: t -*- +# +# This file is part of the LibreOffice project. +# +# 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/. +# + +$(eval $(call gb_UITest_UITest,calc_tests6)) + +$(eval $(call gb_UITest_add_modules,calc_tests6,$(SRCDIR)/sc/qa/uitest,\ + calc_tests6/ \ +)) + +$(eval $(call gb_UITest_set_defs,calc_tests6, \ + TDOC="$(SRCDIR)/sc/qa/uitest/calc_tests/data" \ +)) + +# vim: set noet sw=4 ts=4: diff --git a/sc/qa/uitest/calc_tests/data/tdf107267.ods b/sc/qa/uitest/calc_tests/data/tdf107267.ods Binary files differnew file mode 100644 index 000000000000..c0eb39fd1616 --- /dev/null +++ b/sc/qa/uitest/calc_tests/data/tdf107267.ods diff --git a/sc/qa/uitest/calc_tests6/tdf107267.py b/sc/qa/uitest/calc_tests6/tdf107267.py new file mode 100644 index 000000000000..34a9a4fa0015 --- /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: |