diff options
Diffstat (limited to 'qadevOOo/tests/java/ifc/table/_XCellCursor.java')
-rw-r--r-- | qadevOOo/tests/java/ifc/table/_XCellCursor.java | 247 |
1 files changed, 247 insertions, 0 deletions
diff --git a/qadevOOo/tests/java/ifc/table/_XCellCursor.java b/qadevOOo/tests/java/ifc/table/_XCellCursor.java new file mode 100644 index 000000000000..9f3aea9b4354 --- /dev/null +++ b/qadevOOo/tests/java/ifc/table/_XCellCursor.java @@ -0,0 +1,247 @@ +/************************************************************************* + * + * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. + * + * Copyright 2000, 2010 Oracle and/or its affiliates. + * + * OpenOffice.org - a multi-platform office productivity suite + * + * This file is part of OpenOffice.org. + * + * OpenOffice.org is free software: you can redistribute it and/or modify + * it under the terms of the GNU Lesser General Public License version 3 + * only, as published by the Free Software Foundation. + * + * OpenOffice.org is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the + * GNU Lesser General Public License version 3 for more details + * (a copy is included in the LICENSE file that accompanied this code). + * + * You should have received a copy of the GNU Lesser General Public License + * version 3 along with OpenOffice.org. If not, see + * <http://www.openoffice.org/license.html> + * for a copy of the LGPLv3 License. + * + ************************************************************************/ + +package ifc.table; + +import lib.MultiMethodTest; + +import com.sun.star.sheet.XCellRangeAddressable; +import com.sun.star.sheet.XSheetCellCursor; +import com.sun.star.sheet.XSheetCellRange; +import com.sun.star.sheet.XSpreadsheet; +import com.sun.star.table.CellRangeAddress; +import com.sun.star.table.XCellCursor; +import com.sun.star.table.XCellRange; +import com.sun.star.uno.UnoRuntime; + +/** +* Testing <code>com.sun.star.table.XCellCursor</code> +* interface methods : +* <ul> +* <li><code> gotoStart()</code></li> +* <li><code> gotoEnd()</code></li> +* <li><code> gotoNext()</code></li> +* <li><code> gotoPrevious()</code></li> +* <li><code> gotoOffset()</code></li> +* </ul> <p> +* This test needs the following object relations : +* <ul> +* <li> <code>'SHEET'</code> (of type <code>XSpreadsheet</code>): +* is used for creating a new cell range.</li> +* <ul> <p> +* +* The component tested <b>must implement</b> +* <code>XCellRangeAddressable</code> interface. <p> +* +* Test is <b> NOT </b> multithread compilant. <p> +* After test completion object environment has to be recreated. +* @see com.sun.star.table.XCellCursor +*/ +public class _XCellCursor extends MultiMethodTest { + + public static XCellCursor oObj = null; + public static XSpreadsheet oSheet = null; + + /** + * <code>XCellRangeAddressable</code> interface is queried + * first for getting current position of cursor. The cursor + * is moved to next cell. Address of cursor obtained before + * and after moving. <p> + * Has <b> OK </b> status if cursor column is changed after + * movement. <p> + */ + public void _gotoNext(){ + boolean bResult = false; + int startCol, endCol, startRow, endRow = 0; + int startCol2, endCol2, startRow2, endRow2 = 0; + + XCellRangeAddressable oRange = (XCellRangeAddressable) + UnoRuntime.queryInterface(XCellRangeAddressable.class, oObj); + CellRangeAddress oAddr = oRange.getRangeAddress(); + startRow = oAddr.StartRow; + startCol = oAddr.StartColumn; + endRow = oAddr.EndRow; + endCol = oAddr.EndColumn; + + oObj.gotoNext(); + + oAddr = oRange.getRangeAddress(); + startRow2 = oAddr.StartRow; + startCol2 = oAddr.StartColumn; + endRow2 = oAddr.EndRow; + endCol2 = oAddr.EndColumn; + + if (!(startCol == startCol2)){ + bResult = true; + } + tRes.tested( "gotoNext()", bResult ); + } + + /** + * <code>XCellRangeAddressable</code> interface is queried + * first for getting current position of cursor. The cursor + * is moved then. Address of cursor obtained before + * and after moving. <p> + * Has <b> OK </b> status if starting column and row of + * cursor is changed after movement. <p> + */ + public void _gotoOffset(){ + boolean bResult = false; + int startCol, endCol, startRow, endRow = 0; + int startCol2, endCol2, startRow2, endRow2 = 0; + + XCellRangeAddressable oRange = (XCellRangeAddressable) + UnoRuntime.queryInterface(XCellRangeAddressable.class, oObj); + CellRangeAddress oAddr = oRange.getRangeAddress(); + startRow = oAddr.StartRow; + startCol = oAddr.StartColumn; + endRow = oAddr.EndRow; + endCol = oAddr.EndColumn; + + oObj.gotoOffset(4,4); + + oAddr = oRange.getRangeAddress(); + startRow2 = oAddr.StartRow; + startCol2 = oAddr.StartColumn; + endRow2 = oAddr.EndRow; + endCol2 = oAddr.EndColumn; + if (!(startCol == startCol2) || (startRow == startRow2)){ + bResult = true; + } + tRes.tested( "gotoOffset()", bResult ); + } + + /** + * <code>XCellRangeAddressable</code> interface is queried + * first for getting current position of cursor. The cursor + * is moved to previous cell. Address of cursor obtained before + * and after moving. <p> + * Has <b> OK </b> status if cursor column is changed after + * movement. <p> + */ + public void _gotoPrevious(){ + boolean bResult = false; + int startCol, endCol, startRow, endRow = 0; + int startCol2, endCol2, startRow2, endRow2 = 0; + + XCellRangeAddressable oRange = (XCellRangeAddressable) + UnoRuntime.queryInterface(XCellRangeAddressable.class, oObj); + CellRangeAddress oAddr = oRange.getRangeAddress(); + startRow = oAddr.StartRow; + startCol = oAddr.StartColumn; + endRow = oAddr.EndRow; + endCol = oAddr.EndColumn; + + oObj.gotoPrevious(); + + oAddr = oRange.getRangeAddress(); + startRow2 = oAddr.StartRow; + startCol2 = oAddr.StartColumn; + endRow2 = oAddr.EndRow; + endCol2 = oAddr.EndColumn; + + if (!(startCol == startCol2)){ + bResult = true; + } + tRes.tested( "gotoPrevious()", bResult ); + } + + /** + * <code>XCellRangeAddressable</code> interface is queried + * first for getting current position of cursor. The cursor + * is moved to the start of its range . + * Address of cursor obtained before and after moving. <p> + * Has <b> OK </b> status if cursor was collapsed to a single + * cell (i.e. start column is the same as end column) after + * movement. <p> + */ + public void _gotoStart(){ + boolean bResult = false; + int startCol, endCol, startRow, endRow = 0; + + XCellRangeAddressable oRange = (XCellRangeAddressable) + UnoRuntime.queryInterface(XCellRangeAddressable.class, oObj); + oObj.gotoStart(); + CellRangeAddress oAddr = oRange.getRangeAddress(); + startRow = oAddr.StartRow; + startCol = oAddr.StartColumn; + endRow = oAddr.EndRow; + endCol = oAddr.EndColumn; + if ((startCol == endCol) && (endRow == startRow)){ + bResult = true; + } + + tRes.tested( "gotoStart()", bResult ); + } + + /** + * A new cell range is created using spreadsheet passed by relation. + * The method is tested on that range. <code>gotoEnd</code> is + * called and range address is checked.<p> + * Has <b> OK </b> status if cursor was collapsed to a single + * cell (i.e. start column is the same as end column) after + * movement. <p> + */ + public void _gotoEnd(){ + //gotoEnd gets it's own cursor to see a change + oSheet = (XSpreadsheet) tEnv.getObjRelation("SHEET"); + XCellRange testRange = oSheet.getCellRangeByName("$A$1:$g$7") ; + XSheetCellRange testSheetRange = (XSheetCellRange) + UnoRuntime.queryInterface(XSheetCellRange.class,testRange); + XSheetCellCursor oCellCursor = oSheet.createCursorByRange + (testSheetRange); + XCellCursor oCursor = (XCellCursor) + UnoRuntime.queryInterface(XCellCursor.class,oCellCursor); + + boolean bResult = false; + int startCol, endCol, startRow, endRow = 0; + + XCellRangeAddressable oRange = (XCellRangeAddressable) + UnoRuntime.queryInterface(XCellRangeAddressable.class, oCursor); + oCursor.gotoEnd(); + CellRangeAddress oAddr = oRange.getRangeAddress(); + startRow = oAddr.StartRow; + startCol = oAddr.StartColumn; + endRow = oAddr.EndRow; + endCol = oAddr.EndColumn; + if ((startCol == endCol) && (endRow == startRow)){ + bResult = true; + } + + tRes.tested( "gotoEnd()", bResult ); + } + + /** + * Forces object environment recreation. + */ + protected void after() { + disposeEnvironment(); + } + + +} //EOC _XCellCursor + |