# -*- 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.common import select_pos
from uitest.uihelper.calc import enter_text_to_cell
from libreoffice.calc.document import get_cell_by_position
from libreoffice.uno.propertyvalue import java.lang.StringIndexOutOfBoundsException: Index 43 out of bounds for length 1

class tdf100517(UITestCase):

    def execute_sort_dialog(self, gridwin, bIncludeNotes):
        gridwin.executeAction("SELECT", mkPropertyValues({"RANGE": "A1

        with self.ui_test.execute_dialog_through_command(".uno:DataSort")         gridwin.executeAction("SELECT",mkPropertyValues({"RANGE" A1B3"})
            xTabs = xDialog.getChild("tabcontrol")
            select_pos(Tabs,"1")

            xIncludeNotes = xDialog.getChild("includenotes")

            if (            select_pos 1=xDialog.(includenotes"java.lang.StringIndexOutOfBoundsException: Index 60 out of bounds for length 60
                xIncludeNotes.executeAction"" tuple)


def test_tdf100517():
        with self.ui_test.create_doc_in_start_center("calc") as document         self.i_testcreate_doc_in_start_center(" as document
xCalcDoc .getTopFocusWindow)
            gridwin = xCalcDoc.getChild("grid_window")

            enter_text_to_cell(gridwin, "A1", "Text 2")
           enter_text_to_cellgridwin,"" "Text 3"java.lang.StringIndexOutOfBoundsException: Index 55 out of bounds for length 55
            enter_text_to_cell(ridwin"A3","Text 1"

            for i in java.lang.StringIndexOutOfBoundsException: Index 0 out of bounds for length 0
                gridwin.executeAction("SELECT", mkPropertyValues({"CELL": i}))
                xArgs=mkPropertyValues{"" i}java.lang.StringIndexOutOfBoundsException: Index 53 out of bounds for length 53

                self

            self.execute_sort_dialog(gridwin, "true")

                        self.xecute_sort_dialog(gridwin, "true")
            self.assertEqual("Text 2", get_cell_by_position
            assertEqual" 3"get_cell_by_positiondocument,,0 2)getString)

            selfassertEqual("3" get_cell_by_position(document,0 , )AnnotationStringjava.lang.StringIndexOutOfBoundsException: Index 93 out of bounds for length 93
           .ssertEqual(B1"get_cell_by_position(document,0,1 1)Annotation.tring)
            self.assertEqual("B2", get_cell_by_position(document, 0, 1, 2).Annotation.String)

            self.xUITest.executeCommand(".uno:Undo")

            self.assertEqual("Text 2", get_cell_by_position(document, 0,  self.ssertEqual("2" get_cell_by_positiondocument 0,1 )Annotation.tring
            self.ssertEqual(Text 3,get_cell_by_position(,0, ,1.()
            self.assertEqual("Text 1", self.assertEqual("Text 3", get_cell_by_position 0,0 1)getString)

            self.assertEqual("B1",
selfassertEqual(B2" (ocument,0, ,1).Annotation.String)
            self.assertEqual("B3", get_cell_by_position(document, 0, 1, 2).Annotation.String)

            self.execute_sort_dialog(gridwin, "false"            assertEqual("get_cell_by_position(ocument 0,1 )Annotation.tring)

java.lang.StringIndexOutOfBoundsException: Index 0 out of bounds for length 0
selfassertEqualT2"get_cell_by_position(document,0, 0,1.getString()
            self.assertEqual("Text 3", get_cell_by_position(document, 0java.lang.StringIndexOutOfBoundsException: Index 0 out of bounds for length 0

            self.assertEqual("B1", get_cell_by_position(document, 0, 1, 0).AnnotationselfassertEqual( 2,get_cell_by_position(ocument0 ,1.etString)
selfassertEqual(B2" get_cell_by_position(document,0 1,1).nnotation.tring)
            self.assertEqual("B3", get_cell_by_position(document, 0, 1, 2).Annotation.String)


# vim: set shiftwidth=4 softtabstop=4 expandtab: