sc/qa/uitest/calc_tests4/trackedChanges.py | 76 +++++++++++++++++++++++++++++
1 file changed, 76 insertions(+)
New commits:
commit 8e4740e7a93a03ca0faab40b163a1ec7da806a72
Author: Xisco Fauli <xiscofa...@libreoffice.org>
AuthorDate: Thu Jan 19 11:15:48 2023 +0100
Commit: Xisco Fauli <xiscofa...@libreoffice.org>
CommitDate: Thu Jan 19 14:42:57 2023 +0000
tdf#153096: sc: Add UItest
Also add a test for checking the right behaviour when
changing the content of a cell
Change-Id: I33dda97a467355273d49ddbcab56886a9b1950d6
Reviewed-on: https://gerrit.libreoffice.org/c/core/+/145776
Tested-by: Jenkins
Reviewed-by: Xisco Fauli <xiscofa...@libreoffice.org>
diff --git a/sc/qa/uitest/calc_tests4/trackedChanges.py
b/sc/qa/uitest/calc_tests4/trackedChanges.py
index de42128acaaf..53306de0c88b 100644
--- a/sc/qa/uitest/calc_tests4/trackedChanges.py
+++ b/sc/qa/uitest/calc_tests4/trackedChanges.py
@@ -54,6 +54,82 @@ class CalcTrackedChanges(UITestCase):
xpass = xDialog.getChild("pass1ed")
xpass.executeAction("TYPE", mkPropertyValues({"TEXT":"a"}))
+ def test_ContentChange(self):
+
+ with self.ui_test.create_doc_in_start_center("calc") as document:
+ self.ui_test.wait_until_child_is_available("grid_window")
+ xCalcDoc = self.xUITest.getTopFocusWindow()
+ gridwin = xCalcDoc.getChild("grid_window")
+ #track changes; enter text to cell
+ self.xUITest.executeCommand(".uno:TraceChangeMode")
+ enter_text_to_cell(gridwin, "A1", "Hello")
+ enter_text_to_cell(gridwin, "A1", "There")
+
+ with
self.ui_test.execute_modeless_dialog_through_command(".uno:AcceptChanges",
close_button="close") as xTrackDlg:
+
+ xChangesList = xTrackDlg.getChild("calcchanges")
+ self.assertEqual(1, len(xChangesList.getChildren()))
+
+ textStart = "Changed contents\tSheet1.A1\t \t" +
datetime.datetime.now().strftime("%m/%d/%Y")
+
+ xChild = xChangesList.getChild('0')
+
self.assertTrue(get_state_as_dict(xChild)["Text"].startswith(textStart))
+
+ xChild.executeAction("EXPAND", tuple())
+
+ self.assertEqual(3, len(xChild.getChildren()))
+ textStartChild1 = "<empty>\tSheet1.A1\t \t" +
datetime.datetime.now().strftime("%m/%d/%Y")
+ textEndChild1 = "(Original: <empty>)"
+ textStartChild2 = "'Hello'\tSheet1.A1\t \t" +
datetime.datetime.now().strftime("%m/%d/%Y")
+ textEndChild2 = "(Changed to 'Hello')"
+ textStartChild3 = "'There'\tSheet1.A1\t \t" +
datetime.datetime.now().strftime("%m/%d/%Y")
+ textEndChild3 = "(Changed to 'There')"
+
+
self.assertTrue(get_state_as_dict(xChild.getChild('0'))["Text"].startswith(textStartChild1))
+
self.assertTrue(get_state_as_dict(xChild.getChild('0'))["Text"].endswith(textEndChild1))
+
self.assertTrue(get_state_as_dict(xChild.getChild('1'))["Text"].startswith(textStartChild2))
+
self.assertTrue(get_state_as_dict(xChild.getChild('1'))["Text"].endswith(textEndChild2))
+
self.assertTrue(get_state_as_dict(xChild.getChild('2'))["Text"].startswith(textStartChild3))
+
self.assertTrue(get_state_as_dict(xChild.getChild('2'))["Text"].endswith(textEndChild3))
+
+ self.assertEqual("There", get_cell_by_position(document, 0, 0,
0).getString())
+
+ def test_Tdf153096(self):
+
+ with self.ui_test.create_doc_in_start_center("calc") as document:
+ self.ui_test.wait_until_child_is_available("grid_window")
+ xCalcDoc = self.xUITest.getTopFocusWindow()
+ gridwin = xCalcDoc.getChild("grid_window")
+ #track changes; enter text to cell
+ self.xUITest.executeCommand(".uno:TraceChangeMode")
+ enter_text_to_cell(gridwin, "A1", "Hello")
+
+ gridwin.executeAction("SELECT", mkPropertyValues({"CELL": "A1"}))
+
+ self.xUITest.executeCommand(".uno:DeleteRows")
+
+ with
self.ui_test.execute_modeless_dialog_through_command(".uno:AcceptChanges",
close_button="close") as xTrackDlg:
+
+ xChangesList = xTrackDlg.getChild("calcchanges")
+ self.assertEqual(1, len(xChangesList.getChildren()))
+
+ textStart = "Row deleted\t(Sheet1.1:1)\t \t" +
datetime.datetime.now().strftime("%m/%d/%Y")
+ textEnd = "(Row 1:1 deleted)"
+
+ xChild = xChangesList.getChild('0')
+
+ # Without the fix in place, this test would have failed here
+
self.assertTrue(get_state_as_dict(xChild)["Text"].startswith(textStart))
+
self.assertTrue(get_state_as_dict(xChild)["Text"].endswith(textEnd))
+
+ xChild.executeAction("EXPAND", tuple())
+
+ self.assertEqual(1, len(xChild.getChildren()))
+ textStartChild1 = "Changed contents\t(Sheet1.A1)\t \t" +
datetime.datetime.now().strftime("%m/%d/%Y")
+ textEndChild1 = "(Cell (A1) changed from '<empty>' to 'Hello')"
+
+
self.assertTrue(get_state_as_dict(xChild.getChild('0'))["Text"].startswith(textStartChild1))
+
self.assertTrue(get_state_as_dict(xChild.getChild('0'))["Text"].endswith(textEndChild1))
def test_tracked_changes_accept(self):
