Quelle  trackedChanges.py   Sprache: Python

# -*- 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 = "\tSheet1.A1\tUnknown Author\t" + datetime.datetime.now().strftime("%m/%d/%Y")
                textEndChild1 = "(Original: )"
                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 '' 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 '' to 'Test LibreOffice')"
                textStart2 = "Changed contents\tSheet1.A2\tUnknown Author\t" + datetime.datetime.now().strftime("%m/%d/%Y")
                textEnd2 = "(Cell A2 changed from '' 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 '' to 'Test LibreOffice')"
                textStart2 = "Changed contents\tSheet1.A2\tUnknown Author\t" + datetime.datetime.now().strftime("%m/%d/%Y")
                textEnd2 = "(Cell A2 changed from '' 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 '' to 'Test LibreOffice')"
                textStart2 = "Changed contents\tSheet1.A2\tUnknown Author\t" + datetime.datetime.now().strftime("%m/%d/%Y")
                textEnd2 = "(Cell A2 changed from '' 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 '')"
                textEnd4 = "(Cell A2 changed from 'Test LibreOffice' to '')"
                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 '' to 'Test LibreOffice')"
                textStart2 = "Changed contents\tSheet1.A2\tUnknown Author\t" + datetime.datetime.now().strftime("%m/%d/%Y")
                textEnd2 = "(Cell A2 changed from '' 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 '')"
                textEnd4 = "(Cell A2 changed from 'Test LibreOffice' to '')"
                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: