Adding upstream version 4:24.2.0.upstream/4%24.2.0

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

4 files changed, 158 insertions, 0 deletions

diff --git a/sc/qa/uitest/inputLine/tdf131326.py b/sc/qa/uitest/inputLine/tdf131326.py
new file mode 100755
index 0000000000..90809ab42c
--- /dev/null
+++ b/sc/qa/uitest/inputLine/tdf131326.py
@@ -0,0 +1,28 @@
+# -*- tab-width: 4; indent-tabs-mode: nil; py-indent-offset: 4 -*-
+#
+# 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/.
+#
+from uitest.framework import UITestCase
+from uitest.uihelper.calc import enter_text_to_cell
+from uitest.uihelper.common import get_state_as_dict
+
+# Bug 131326 - Formula to Value does not automatically change text in input line
+class tdf131326(UITestCase):
+
+    def test_tdf131326_formula_to_value_input_line(self):
+        with self.ui_test.create_doc_in_start_center("calc"):
+            xCalcDoc = self.xUITest.getTopFocusWindow()
+            gridwin = xCalcDoc.getChild("grid_window")
+
+            enter_text_to_cell(gridwin, "A1", "=1")
+            self.xUITest.executeCommand(".uno:ConvertFormulaToValue")
+            xToolkit = self.xContext.ServiceManager.createInstance('com.sun.star.awt.Toolkit')
+            xToolkit.processEventsToIdle()
+            xInputWin = xCalcDoc.getChild("sc_input_window")
+            self.assertEqual(get_state_as_dict(xInputWin)["Text"], "1")
+
+# vim: set shiftwidth=4 softtabstop=4 expandtab:
diff --git a/sc/qa/uitest/inputLine/tdf142031.py b/sc/qa/uitest/inputLine/tdf142031.py
new file mode 100755
index 0000000000..588c3cdf15
--- /dev/null
+++ b/sc/qa/uitest/inputLine/tdf142031.py
@@ -0,0 +1,41 @@
+# -*- tab-width: 4; indent-tabs-mode: nil; py-indent-offset: 4 -*-
+#
+# 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/.
+#
+from uitest.framework import UITestCase
+from uitest.uihelper.common import get_state_as_dict, type_text
+from libreoffice.calc.document import get_cell_by_position
+from libreoffice.uno.propertyvalue import mkPropertyValues
+
+class tdf142031(UITestCase):
+
+    def test_tdf142031(self):
+        with self.ui_test.create_doc_in_start_center("calc") as document:
+            xCalcDoc = self.xUITest.getTopFocusWindow()
+            gridwin = xCalcDoc.getChild("grid_window")
+            xPosWindow = xCalcDoc.getChild('pos_window')
+
+            with self.ui_test.execute_modeless_dialog_through_command(".uno:AddName", close_button="add") as xAddNameDlg:
+                xEdit = xAddNameDlg.getChild("edit")
+                type_text(xEdit, "crédit")
+
+            self.assertEqual('crédit', get_state_as_dict(xPosWindow)['Text'])
+
+            gridwin.executeAction("SELECT", mkPropertyValues({"CELL": "B1"}))
+
+            xInputWin = xCalcDoc.getChild("sc_input_window")
+            xInputWin.executeAction("TYPE", mkPropertyValues({"TEXT":"=cré"}))
+            xInputWin.executeAction("TYPE", mkPropertyValues({"KEYCODE":"RETURN"}))
+
+            # Without the fix in place, this test would have failed here
+            self.assertEqual("=crédit", get_state_as_dict(xInputWin)["Text"])
+
+            xInputWin.executeAction("TYPE", mkPropertyValues({"KEYCODE":"RETURN"}))
+
+            self.assertEqual("0", get_cell_by_position(document, 0, 1, 0).getString())
+
+# vim: set shiftwidth=4 softtabstop=4 expandtab:
diff --git a/sc/qa/uitest/inputLine/tdf54197.py b/sc/qa/uitest/inputLine/tdf54197.py
new file mode 100644
index 0000000000..a7a82d5c33
--- /dev/null
+++ b/sc/qa/uitest/inputLine/tdf54197.py
@@ -0,0 +1,38 @@
+# -*- tab-width: 4; indent-tabs-mode: nil; py-indent-offset: 4 -*-
+#
+# 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/.
+#
+from uitest.framework import UITestCase
+from uitest.uihelper.calc import enter_text_to_cell
+from uitest.uihelper.common import get_state_as_dict
+
+from libreoffice.calc.document import get_cell_by_position
+from libreoffice.uno.propertyvalue import mkPropertyValues
+
+
+# Bug 54197 - Calc single cell filling (Ctrl+D) does not change data at input line
+class tdf54197(UITestCase):
+
+    def test_tdf54197_CTRL_D_input_line_change(self):
+        with self.ui_test.create_doc_in_start_center("calc") as document:
+            xCalcDoc = self.xUITest.getTopFocusWindow()
+            gridwin = xCalcDoc.getChild("grid_window")
+            # 1. go to cell A1 enter any text
+            enter_text_to_cell(gridwin, "A1", "t")
+            # 2. go to cell A2 press Ctrl+D
+            gridwin.executeAction("SELECT", mkPropertyValues({"CELL": "A2"}))
+            self.xUITest.executeCommand(".uno:FillDown")
+            # The same text as above is displayed at cell A2, BUT input line is still blank
+            self.assertEqual(get_cell_by_position(document, 0, 0, 0).getString(), "t")
+            self.assertEqual(get_cell_by_position(document, 0, 0, 1).getString(), "t")
+            xToolkit = self.xContext.ServiceManager.createInstance('com.sun.star.awt.Toolkit')
+            xToolkit.processEventsToIdle()
+            xInputWin = xCalcDoc.getChild("sc_input_window")
+            self.assertEqual(get_state_as_dict(xInputWin)["Text"], "t")
+
+
+# vim: set shiftwidth=4 softtabstop=4 expandtab:
diff --git a/sc/qa/uitest/inputLine/tdf67346.py b/sc/qa/uitest/inputLine/tdf67346.py
new file mode 100644
index 0000000000..27764af5c3
--- /dev/null
+++ b/sc/qa/uitest/inputLine/tdf67346.py
@@ -0,0 +1,51 @@
+# -*- tab-width: 4; indent-tabs-mode: nil; py-indent-offset: 4 -*-
+#
+# 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/.
+#
+from uitest.framework import UITestCase
+from uitest.uihelper.common import get_state_as_dict
+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 67346 - EDITING: Undo broken when pasting text that has been copied from the input line
+
+class tdf67346(UITestCase):
+
+    def test_tdf67346_undo_paste_text_input_line(self):
+        with self.ui_test.create_doc_in_start_center("calc") as document:
+            xCalcDoc = self.xUITest.getTopFocusWindow()
+            gridwin = xCalcDoc.getChild("grid_window")
+
+            enter_text_to_cell(gridwin, "A1", "Apple")
+
+            # Move focus to input window and copy the text from there
+            gridwin.executeAction("TYPE", mkPropertyValues({"KEYCODE":"CTRL+SHIFT+F2"}))
+
+            xToolkit = self.xContext.ServiceManager.createInstance('com.sun.star.awt.Toolkit')
+            xToolkit.processEventsToIdle()
+            xInputWin = xCalcDoc.getChild("sc_input_window")
+            self.assertEqual('true', get_state_as_dict(xInputWin)["HasFocus"])
+
+            self.xUITest.executeCommand(".uno:SelectAll")
+            self.xUITest.executeCommand(".uno:Copy")
+
+            gridwin.executeAction("SELECT", mkPropertyValues({"CELL": "A2"}))
+
+            self.xUITest.executeCommand(".uno:Paste")
+            self.assertEqual(get_cell_by_position(document, 0, 0, 0).getString(), "Apple")
+            self.assertEqual(get_cell_by_position(document, 0, 0, 1).getString(), "Apple")
+# this test keeps failing here on jenkins
+#            self.assertEqual(get_state_as_dict(xInputWin)["Text"], "Apple")
+#
+#            self.xUITest.executeCommand(".uno:Undo")
+#            self.assertEqual(get_cell_by_position(document, 0, 0, 0).getString(), "Apple")
+#            self.assertEqual(get_cell_by_position(document, 0, 0, 1).getString(), "")
+#            self.assertEqual(get_state_as_dict(xInputWin)["Text"], "")
+
+
+# vim: set shiftwidth=4 softtabstop=4 expandtab: