horok/libreoffice
1
0
Fork 0
Code Activity
libreoffice/sc/qa/uitest/calc_tests4/trackedChanges.py
Daniel Baumann 8e63e14cf6
Adding upstream version 4:25.2.3. 
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
2025-06-22 16:20:04 +02:00

387 lines
23 KiB
Python
Raw Permalink Blame History

# -*- 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/.
#
# tests for tracked changes ; tdf912270
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
from uitest.uihelper.common import get_state_as_dict, get_url_for_data_file
import datetime
class CalcTrackedChanges(UITestCase):
def test_tdf131907(self):
with self.ui_test.load_file(get_url_for_data_file("tdf131907.ods")):
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 inserted \tSheet1.1:1\t \t"
textEnd = "(Row 1:1 inserted)"
self.assertTrue(get_state_as_dict(xChangesList.getChild('0'))["Text"].startswith(textStart))
self.assertTrue(get_state_as_dict(xChangesList.getChild('0'))["Text"].endswith(textEnd))
#it would crash here
xRejBtn = xTrackDlg.getChild("reject")
xRejBtn.executeAction("CLICK", tuple())
self.assertEqual(2, len(xChangesList.getChildren()))
self.assertEqual(get_state_as_dict(xChangesList.getChild('0'))["Text"], "Accepted")
self.assertEqual(get_state_as_dict(xChangesList.getChild('1'))["Text"], "Rejected")
def test_tdf66263_Protect_Records(self):
with self.ui_test.create_doc_in_start_center("calc"):
self.ui_test.wait_until_child_is_available("grid_window")
self.xUITest.executeCommand(".uno:TraceChangeMode")
#protect dialog
with self.ui_test.execute_dialog_through_command(".uno:ProtectTraceChangeMode") as xDialog:
xpass = xDialog.getChild("pass1ed")
xpass.executeAction("TYPE", mkPropertyValues({"TEXT":"a"}))
xconfirm = xDialog.getChild("confirm1ed")
xconfirm.executeAction("TYPE", mkPropertyValues({"TEXT":"a"}))
#verify password
with self.ui_test.execute_dialog_through_command(".uno:ProtectTraceChangeMode") as xDialog:
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\tUnknown Author\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\tUnknown Author\t" + datetime.datetime.now().strftime("%m/%d/%Y")
textEndChild1 = "(Original: <empty>)"
textStartChild2 = "'Hello'\tSheet1.A1\tUnknown Author\t" + datetime.datetime.now().strftime("%m/%d/%Y")
textEndChild2 = "(Changed to 'Hello')"
textStartChild3 = "'There'\tSheet1.A1\tUnknown Author\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"):
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)\tUnknown Author\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)\tUnknown Author\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):
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", "Test LibreOffice")
enter_text_to_cell(gridwin, "A2", "Test LibreOffice")
#accept tracked changes
with self.ui_test.execute_modeless_dialog_through_command(".uno:AcceptChanges", close_button="close") as xTrackDlg:
xChangesList = xTrackDlg.getChild("calcchanges")
self.assertEqual(2, len(xChangesList.getChildren()))
textStart = "Changed contents\tSheet1.A1\tUnknown Author\t" + datetime.datetime.now().strftime("%m/%d/%Y")
textEnd = "(Cell A1 changed from '<empty>' to 'Test LibreOffice')"
textStart2 = "Changed contents\tSheet1.A2\tUnknown Author\t" + datetime.datetime.now().strftime("%m/%d/%Y")
textEnd2 = "(Cell A2 changed from '<empty>' to 'Test LibreOffice')"
self.assertTrue(get_state_as_dict(xChangesList.getChild('0'))["Text"].startswith(textStart))
self.assertTrue(get_state_as_dict(xChangesList.getChild('0'))["Text"].endswith(textEnd))
self.assertTrue(get_state_as_dict(xChangesList.getChild('1'))["Text"].startswith(textStart2))
self.assertTrue(get_state_as_dict(xChangesList.getChild('1'))["Text"].endswith(textEnd2))
xAccBtn = xTrackDlg.getChild("accept")
xAccBtn.executeAction("CLICK", tuple())
self.assertEqual(2, len(xChangesList.getChildren()))
self.assertTrue(get_state_as_dict(xChangesList.getChild('0'))["Text"].startswith(textStart2))
self.assertTrue(get_state_as_dict(xChangesList.getChild('0'))["Text"].endswith(textEnd2))
self.assertEqual(get_state_as_dict(xChangesList.getChild('1'))["Text"], "Accepted")
xAccBtn = xTrackDlg.getChild("accept")
xAccBtn.executeAction("CLICK", tuple())
self.assertEqual(1, len(xChangesList.getChildren()))
self.assertEqual(get_state_as_dict(xChangesList.getChild('0'))["Text"], "Accepted")
xChangesList.getChild('0').executeAction("EXPAND", tuple())
self.assertEqual(2, len(xChangesList.getChild('0').getChildren()))
self.assertTrue(get_state_as_dict(xChangesList.getChild('0').getChild('0'))["Text"].startswith(textStart))
self.assertTrue(get_state_as_dict(xChangesList.getChild('0').getChild('0'))["Text"].endswith(textEnd))
self.assertTrue(get_state_as_dict(xChangesList.getChild('0').getChild('1'))["Text"].startswith(textStart2))
self.assertTrue(get_state_as_dict(xChangesList.getChild('0').getChild('1'))["Text"].endswith(textEnd2))
self.assertEqual(get_cell_by_position(document, 0, 0, 0).getString(), "Test LibreOffice")
def test_tracked_changes_acceptall(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", "Test LibreOffice")
enter_text_to_cell(gridwin, "A2", "Test LibreOffice")
#accept All tracked changes
with self.ui_test.execute_modeless_dialog_through_command(".uno:AcceptChanges", close_button="close") as xTrackDlg:
xChangesList = xTrackDlg.getChild("calcchanges")
self.assertEqual(2, len(xChangesList.getChildren()))
textStart = "Changed contents\tSheet1.A1\tUnknown Author\t" + datetime.datetime.now().strftime("%m/%d/%Y")
textEnd = "(Cell A1 changed from '<empty>' to 'Test LibreOffice')"
textStart2 = "Changed contents\tSheet1.A2\tUnknown Author\t" + datetime.datetime.now().strftime("%m/%d/%Y")
textEnd2 = "(Cell A2 changed from '<empty>' to 'Test LibreOffice')"
self.assertTrue(get_state_as_dict(xChangesList.getChild('0'))["Text"].startswith(textStart))
self.assertTrue(get_state_as_dict(xChangesList.getChild('0'))["Text"].endswith(textEnd))
self.assertTrue(get_state_as_dict(xChangesList.getChild('1'))["Text"].startswith(textStart2))
self.assertTrue(get_state_as_dict(xChangesList.getChild('1'))["Text"].endswith(textEnd2))
xAccBtn = xTrackDlg.getChild("acceptall")
xAccBtn.executeAction("CLICK", tuple())
self.assertEqual(1, len(xChangesList.getChildren()))
self.assertEqual(get_state_as_dict(xChangesList.getChild('0'))["Text"], "Accepted")
xChangesList.getChild('0').executeAction("EXPAND", tuple())
self.assertEqual(2, len(xChangesList.getChild('0').getChildren()))
self.assertTrue(get_state_as_dict(xChangesList.getChild('0').getChild('0'))["Text"].startswith(textStart))
self.assertTrue(get_state_as_dict(xChangesList.getChild('0').getChild('0'))["Text"].endswith(textEnd))
self.assertTrue(get_state_as_dict(xChangesList.getChild('0').getChild('1'))["Text"].startswith(textStart2))
self.assertTrue(get_state_as_dict(xChangesList.getChild('0').getChild('1'))["Text"].endswith(textEnd2))
self.assertEqual(get_cell_by_position(document, 0, 0, 0).getString(), "Test LibreOffice")
def test_tracked_changes_reject(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", "Test LibreOffice")
enter_text_to_cell(gridwin, "A2", "Test LibreOffice")
#accept tracked changes
with self.ui_test.execute_modeless_dialog_through_command(".uno:AcceptChanges", close_button="close") as xTrackDlg:
xChangesList = xTrackDlg.getChild("calcchanges")
self.assertEqual(2, len(xChangesList.getChildren()))
textStart = "Changed contents\tSheet1.A1\tUnknown Author\t" + datetime.datetime.now().strftime("%m/%d/%Y")
textEnd = "(Cell A1 changed from '<empty>' to 'Test LibreOffice')"
textStart2 = "Changed contents\tSheet1.A2\tUnknown Author\t" + datetime.datetime.now().strftime("%m/%d/%Y")
textEnd2 = "(Cell A2 changed from '<empty>' to 'Test LibreOffice')"
self.assertTrue(get_state_as_dict(xChangesList.getChild('0'))["Text"].startswith(textStart))
self.assertTrue(get_state_as_dict(xChangesList.getChild('0'))["Text"].endswith(textEnd))
self.assertTrue(get_state_as_dict(xChangesList.getChild('1'))["Text"].startswith(textStart2))
self.assertTrue(get_state_as_dict(xChangesList.getChild('1'))["Text"].endswith(textEnd2))
xRejBtn = xTrackDlg.getChild("reject")
xRejBtn.executeAction("CLICK", tuple())
self.assertEqual(3, len(xChangesList.getChildren()))
self.assertTrue(get_state_as_dict(xChangesList.getChild('0'))["Text"].startswith(textStart2))
self.assertTrue(get_state_as_dict(xChangesList.getChild('0'))["Text"].endswith(textEnd2))
self.assertEqual(get_state_as_dict(xChangesList.getChild('1'))["Text"], "Accepted")
self.assertEqual(get_state_as_dict(xChangesList.getChild('2'))["Text"], "Rejected")
xAccBtn = xTrackDlg.getChild("reject")
xAccBtn.executeAction("CLICK", tuple())
self.assertEqual(2, len(xChangesList.getChildren()))
self.assertEqual(get_state_as_dict(xChangesList.getChild('0'))["Text"], "Accepted")
self.assertEqual(get_state_as_dict(xChangesList.getChild('1'))["Text"], "Rejected")
xChangesList.getChild('0').executeAction("EXPAND", tuple())
self.assertEqual(2, len(xChangesList.getChild('0').getChildren()))
textEnd3 = "(Cell A1 changed from 'Test LibreOffice' to '<empty>')"
textEnd4 = "(Cell A2 changed from 'Test LibreOffice' to '<empty>')"
self.assertTrue(get_state_as_dict(xChangesList.getChild('0').getChild('0'))["Text"].startswith(textStart))
self.assertTrue(get_state_as_dict(xChangesList.getChild('0').getChild('0'))["Text"].endswith(textEnd3))
self.assertTrue(get_state_as_dict(xChangesList.getChild('0').getChild('1'))["Text"].startswith(textStart2))
self.assertTrue(get_state_as_dict(xChangesList.getChild('0').getChild('1'))["Text"].endswith(textEnd4))
xChangesList.getChild('1').executeAction("EXPAND", tuple())
self.assertEqual(2, len(xChangesList.getChild('1').getChildren()))
self.assertTrue(get_state_as_dict(xChangesList.getChild('1').getChild('0'))["Text"].startswith(textStart))
self.assertTrue(get_state_as_dict(xChangesList.getChild('1').getChild('0'))["Text"].endswith(textEnd))
self.assertTrue(get_state_as_dict(xChangesList.getChild('1').getChild('1'))["Text"].startswith(textStart2))
self.assertTrue(get_state_as_dict(xChangesList.getChild('1').getChild('1'))["Text"].endswith(textEnd2))
self.assertEqual(get_cell_by_position(document, 0, 0, 0).getString(), "")
def test_tracked_changes_rejectall(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", "Test LibreOffice")
enter_text_to_cell(gridwin, "A2", "Test LibreOffice")
#accept tracked changes
with self.ui_test.execute_modeless_dialog_through_command(".uno:AcceptChanges", close_button="close") as xTrackDlg:
xChangesList = xTrackDlg.getChild("calcchanges")
self.assertEqual(2, len(xChangesList.getChildren()))
textStart = "Changed contents\tSheet1.A1\tUnknown Author\t" + datetime.datetime.now().strftime("%m/%d/%Y")
textEnd = "(Cell A1 changed from '<empty>' to 'Test LibreOffice')"
textStart2 = "Changed contents\tSheet1.A2\tUnknown Author\t" + datetime.datetime.now().strftime("%m/%d/%Y")
textEnd2 = "(Cell A2 changed from '<empty>' to 'Test LibreOffice')"
self.assertTrue(get_state_as_dict(xChangesList.getChild('0'))["Text"].startswith(textStart))
self.assertTrue(get_state_as_dict(xChangesList.getChild('0'))["Text"].endswith(textEnd))
self.assertTrue(get_state_as_dict(xChangesList.getChild('1'))["Text"].startswith(textStart2))
self.assertTrue(get_state_as_dict(xChangesList.getChild('1'))["Text"].endswith(textEnd2))
xAccBtn = xTrackDlg.getChild("rejectall")
xAccBtn.executeAction("CLICK", tuple())
self.assertEqual(2, len(xChangesList.getChildren()))
self.assertEqual(get_state_as_dict(xChangesList.getChild('0'))["Text"], "Accepted")
self.assertEqual(get_state_as_dict(xChangesList.getChild('1'))["Text"], "Rejected")
xChangesList.getChild('0').executeAction("EXPAND", tuple())
self.assertEqual(2, len(xChangesList.getChild('0').getChildren()))
textEnd3 = "(Cell A1 changed from 'Test LibreOffice' to '<empty>')"
textEnd4 = "(Cell A2 changed from 'Test LibreOffice' to '<empty>')"
self.assertTrue(get_state_as_dict(xChangesList.getChild('0').getChild('0'))["Text"].startswith(textStart2))
self.assertTrue(get_state_as_dict(xChangesList.getChild('0').getChild('0'))["Text"].endswith(textEnd4))
self.assertTrue(get_state_as_dict(xChangesList.getChild('0').getChild('1'))["Text"].startswith(textStart))
self.assertTrue(get_state_as_dict(xChangesList.getChild('0').getChild('1'))["Text"].endswith(textEnd3))
xChangesList.getChild('1').executeAction("EXPAND", tuple())
self.assertEqual(2, len(xChangesList.getChild('1').getChildren()))
self.assertTrue(get_state_as_dict(xChangesList.getChild('1').getChild('0'))["Text"].startswith(textStart))
self.assertTrue(get_state_as_dict(xChangesList.getChild('1').getChild('0'))["Text"].endswith(textEnd))
self.assertTrue(get_state_as_dict(xChangesList.getChild('1').getChild('1'))["Text"].startswith(textStart2))
self.assertTrue(get_state_as_dict(xChangesList.getChild('1').getChild('1'))["Text"].endswith(textEnd2))
self.assertEqual(get_cell_by_position(document, 0, 0, 0).getString(), "")
def test_tdf136062(self):
with self.ui_test.load_file(get_url_for_data_file("tdf136062.ods")):
self.xUITest.getTopFocusWindow()
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()))
xRejectAllBtn = xTrackDlg.getChild("rejectall")
xRejectBtn = xTrackDlg.getChild("reject")
xAcceptAllBtn = xTrackDlg.getChild("acceptall")
xAcceptBtn = xTrackDlg.getChild("accept")
# Without the fix in place, it would have failed with
# AssertionError: 'R~eject All' != 'R~eject All/Clear formatting'
self.assertEqual('R~eject All', get_state_as_dict(xRejectAllBtn)['Text'])
self.assertEqual('~Reject', get_state_as_dict(xRejectBtn)['Text'])
self.assertEqual('A~ccept All', get_state_as_dict(xAcceptAllBtn)['Text'])
self.assertEqual('~Accept', get_state_as_dict(xAcceptBtn)['Text'])
def test_tdf85353(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", "15")
enter_text_to_cell(gridwin, "D1", "0")
enter_text_to_cell(gridwin, "E1", "0")
with self.ui_test.execute_dialog_through_command(".uno:CompareDocuments", close_button="") as xOpenDialog:
xFileName = xOpenDialog.getChild("file_name")
xFileName.executeAction("TYPE", mkPropertyValues({"TEXT": get_url_for_data_file("tdf85353.ods")}))
xOpenBtn = xOpenDialog.getChild("open")
with self.ui_test.execute_dialog_through_action(xOpenBtn, 'CLICK', close_button="close") as xTrackDlg:
changesList = xTrackDlg.getChild("calcchanges")
# Without the fix in place, this test would have failed with
# AssertionError: 1 != 0
self.assertEqual(1, len(changesList.getChildren()))
self.assertTrue(get_state_as_dict(changesList.getChild('0'))['Text'].startswith("Changed contents\tSheet1.E1"))
self.assertTrue(get_state_as_dict(changesList.getChild('0'))['Text'].endswith("(Cell E1 changed from '5' to '0')"))
# vim: set shiftwidth=4 softtabstop=4 expandtab:
View git blame Copy permalink