AOO410/main/qadevOOo/tests/java/ifc/sheet/_XSheetCellCursor.java - openoffice - Git at Google

 /**************************************************************
  *
  * Licensed to the Apache Software Foundation (ASF) under one
  * or more contributor license agreements.  See the NOTICE file
  * distributed with this work for additional information
  * regarding copyright ownership.  The ASF licenses this file
  * to you under the Apache License, Version 2.0 (the
  * "License"); you may not use this file except in compliance
  * with the License.  You may obtain a copy of the License at
  *
  *   http://www.apache.org/licenses/LICENSE-2.0
  *
  * Unless required by applicable law or agreed to in writing,
  * software distributed under the License is distributed on an
  * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
  * KIND, either express or implied.  See the License for the
  * specific language governing permissions and limitations
  * under the License.
  *
  *************************************************************/


 package ifc.sheet;

 import lib.MultiMethodTest;

 import com.sun.star.sheet.CellFlags;
 import com.sun.star.sheet.XArrayFormulaRange;
 import com.sun.star.sheet.XCellRangeAddressable;
 import com.sun.star.sheet.XSheetCellCursor;
 import com.sun.star.sheet.XSheetOperation;
 import com.sun.star.sheet.XSpreadsheet;
 import com.sun.star.table.CellRangeAddress;
 import com.sun.star.table.XCellRange;
 import com.sun.star.table.XColumnRowRange;
 import com.sun.star.uno.UnoRuntime;
 import com.sun.star.util.XMergeable;

 /**
 * Testing <code>com.sun.star.sheet.XSheetCellCursor</code>
 * interface methods :
 * <ul>
 *  <li><code> collapseToCurrentRegion()</code></li>
 *  <li><code> collapseToCurrentArray()</code></li>
 *  <li><code> collapseToMergedArea()</code></li>
 *  <li><code> expandToEntireColumns()</code></li>
 *  <li><code> expandToEntireRows()</code></li>
 *  <li><code> collapseToSize()</code></li>
 * </ul> <p>
 * Component must also implement the following interfaces :
 * <ul>
 *  <li> <code> com.sun.star.sheet.XCellRangeAddressable </code> :
 *  to get range address </li>
 * <ul> <p>
 * Range of cursor must be of size 4 x 4. <p>
 * @see com.sun.star.sheet.XSheetCellCursor
 */
 public class _XSheetCellCursor extends MultiMethodTest {

     public XSheetCellCursor oObj = null;

     /**
     * Test creates the array formula, assigns this array to another array,
     * collapses cursor into one cell, applies method, checks the size of the
     * result range, erases array formula, checks that array formula has been
     * cleared. <p>
     * Has <b>OK</b> status if no exceptions were thrown, if size of the result
     * range is equal to size of the range where the array formula was set and
     * if array formula was successfully cleared. <p>
     */
     public void _collapseToCurrentArray() {
         boolean bResult = false;

         XCellRangeAddressable crAddr = (XCellRangeAddressable)
             UnoRuntime.queryInterface(XCellRangeAddressable.class, oObj);
         CellRangeAddress addr = crAddr.getRangeAddress() ;
         int leftCol = addr.StartColumn ;
         int topRow = addr.StartRow ;
         int width = addr.EndColumn - addr.StartColumn + 1 ;
         int height = addr.EndRow - addr.StartRow + 1 ;

         log.println( "Object area is ((" + leftCol + "," + topRow + "),(" +
             (leftCol + width - 1) + "," + (topRow + height - 1) + ")" );

         XCellRange new_range = null;
         try {
             // first we need to create an array formula
             new_range =
                 oObj.getCellRangeByPosition(0, 0, 0, height - 1);
         } catch (com.sun.star.lang.IndexOutOfBoundsException e) {
             log.print("Get cell range by position failed: ");
             e.printStackTrace(log);
             tRes.tested("collapseToCurrentArray()", false);
         }

         log.println("DB: Successfully new range created");
         XArrayFormulaRange arrFormulaRange = (XArrayFormulaRange)
             UnoRuntime.queryInterface (XArrayFormulaRange.class, new_range);
         // write a simple formula (this array assigns another array)
         arrFormulaRange.setArrayFormula("A1:A" + height) ;

         // collapse cursor into one cell and then try to apply the method
         oObj.collapseToSize (1, 1) ;
         oObj.collapseToCurrentArray() ;

         // check the size of result range
         int cols = ( (XColumnRowRange)UnoRuntime.queryInterface(
                   XColumnRowRange.class, oObj) ).getColumns().getCount();
         int rows = ( (XColumnRowRange)UnoRuntime.queryInterface(
                   XColumnRowRange.class, oObj) ).getRows().getCount();

         if (cols == 1 && rows == height) {
             bResult = true;
         } else {
             bResult = false;
             log.println("The size of cell range must be 1x" + height +
                 ", but after method call it was " + cols + "x" + rows);
         }

         // erase array formula
         arrFormulaRange.setArrayFormula("");

         // check if array formula has been cleared with last statement
         try {
             // if array formula isn't cleared exception is thrown
             new_range.getCellByPosition(0,0).setValue(111) ;
         } catch (com.sun.star.lang.IndexOutOfBoundsException e) {
             bResult = false ;
             log.println(
                 "Array formula hasn't been cleared with setArrayFormula(\"\")");
             XSheetOperation clearRange = (XSheetOperation)
                 UnoRuntime.queryInterface (XSheetOperation.class, new_range);
             int allFlags =
                 CellFlags.ANNOTATION | CellFlags.DATETIME | CellFlags.EDITATTR;
             allFlags = allFlags
                 | CellFlags.HARDATTR | CellFlags.OBJECTS | CellFlags.STRING;
             allFlags = allFlags
                 | CellFlags.VALUE | CellFlags.FORMULA | CellFlags.STYLES;
             clearRange.clearContents(allFlags) ;
         }

         tRes.tested("collapseToCurrentArray()", bResult );
     }

     /**
     * Test clears contents of spreadsheet, collapses cursor to current range,
     * checks size of cursor range, fills a cell that is close to
     * cursor range, collapses cursor to current range, checks size of cursor
     * range again and restores original size. <p>
     * Has <b> OK </b> status if after clearing of content and collapsing cursor
     * range size remains 4 x 4, if after filling of cell and collapsing cursor
     * range extends by one in both dimensions and no exceptions were thrown.<p>
     */
     public void _collapseToCurrentRegion(){
         boolean bResult = true;
         int width = 4, height = 4;
         int leftCol = -1, topRow = -1;

         XSpreadsheet oSheet = oObj.getSpreadsheet();
         ((XSheetOperation) UnoRuntime.queryInterface(
             XSheetOperation.class, oSheet) ).clearContents(65535);
         oObj.collapseToCurrentRegion();
         int cols = ((XColumnRowRange)
             UnoRuntime.queryInterface(
                 XColumnRowRange.class, oObj) ).getColumns().getCount();
         int rows = ((XColumnRowRange)
             UnoRuntime.queryInterface(
                 XColumnRowRange.class, oObj) ).getRows().getCount();

         if (cols != width || rows != height) {
             bResult = false ;
             log.println("After collapseToCurrentRegion()"
                  + " call Region must have size " + width + "x" + height
                  + " but it is " + cols + "x" + rows);
         }

         // if previous test was successful try more complicated case
         if (bResult) {
             if (leftCol != -1 && topRow != -1) {
                 try {
                     oSheet.getCellByPosition(
                         leftCol + width, topRow + height).setValue(1);
                 } catch (com.sun.star.lang.IndexOutOfBoundsException e) {
                     log.print("Can't get cell by position:");
                     e.printStackTrace(log);
                     bResult = false;
                 }

                 oObj.collapseToCurrentRegion() ;

                 // checking results
                 cols = ((XColumnRowRange)
                     UnoRuntime.queryInterface(
                         XColumnRowRange.class, oObj)).getColumns().getCount();
                 rows = ((XColumnRowRange)
                     UnoRuntime.queryInterface(
                         XColumnRowRange.class, oObj)).getRows().getCount();

                 if (cols == width + 1 && rows == height + 1) {
                     bResult &= true;
                 } else {
                     bResult = false;
                     log.println("After collapseToCurrentRegion() call [2]"
                          + " region must have size " + (width+1) + "x"
                          + (height + 1) + " but it is " + cols + "x" + rows );
                 }
             }
         }

         tRes.tested("collapseToCurrentRegion()", bResult);

         // restore original size
         oObj.collapseToSize(width, height);
     }

     /**
     * Test merges a cells of range that has a greater size, collapses cursor to
     * merged area, checks size of cursor range and restores original size
     * of cursor range. <p>
     * Has <b> OK </b> status if after merging of cells and collapsing cursor
     * range extends by one in both dimensions and no exceptions were thrown.<p>
     */
     public void _collapseToMergedArea(){
         int width = 1, height = 1 ;
         int leftCol = 0, topRow = 0 ;

         boolean bResult = true ;

         log.println("DB: Starting collapseToMergedArea() method test ...") ;
         XSpreadsheet oSheet = oObj.getSpreadsheet() ;
         log.println ("DB: got Spreadsheet.") ;

         XCellRange newRange = null;
         try {
             newRange = oSheet.getCellRangeByPosition (
                 leftCol + width - 1, topRow + height - 1,
                 leftCol + width, topRow + height );
         } catch (com.sun.star.lang.IndexOutOfBoundsException e) {
             log.println("Can't get cell range by position");
             e.printStackTrace(log);
             bResult = false;
         }

         XMergeable mergeRange = (XMergeable)
             UnoRuntime.queryInterface (XMergeable.class, newRange);
         if (mergeRange == null) {
             log.println("DB: newRange doesn't implement XMergeable interface");
         } else {
             log.println("DB: XMergeable interface successfully queried.");
         }

         mergeRange.merge(true);
         log.println("DB: Successfuly merged.") ;

         oObj.collapseToMergedArea() ;
         log.println("DB: Succesfully collapseToMergedArea() method called");

         // unmerge area to restore SpreadSheet
         mergeRange.merge(false);
         log.println("DB: Successfully unmerged.") ;

         // checking results
         int cols = ((XColumnRowRange)
             UnoRuntime.queryInterface(
                 XColumnRowRange.class, oObj) ).getColumns().getCount();
         int rows = ((XColumnRowRange)
             UnoRuntime.queryInterface(
                 XColumnRowRange.class, oObj) ).getRows().getCount();
         log.println("DB: Column and row numbers succesfully get") ;

         if (cols == width + 1  && rows == height + 3) {
             bResult &= true;
         } else {
             bResult = false;
             log.println(
                 "After collapseToMergedArea() call region must have size "
                 + (width + 1) + "x" + (height + 1) + " but it is " + cols
                 + "x" + rows );
         }

         tRes.tested("collapseToMergedArea()", bResult) ;

         // restore original size
         oObj.collapseToSize(width, height);
     }

     /**
     * Test collapses cursor to the new size, checks size
     * of cursor range and restores original size of cursor range. <p>
     * Has <b> OK </b> status if after collapsing cursor
     * range extends by three in both dimensions. <p>
     */
     public void _collapseToSize(){
         boolean bResult = false;
         int width = 1, height = 1;

         // collapseToSize() method test
         oObj.collapseToSize (width + 3, height + 3);

         // checking results
         int cols = ((XColumnRowRange)
             UnoRuntime.queryInterface(
                 XColumnRowRange.class, oObj) ).getColumns().getCount();
         int rows = ((XColumnRowRange)
             UnoRuntime.queryInterface(
                 XColumnRowRange.class, oObj) ).getRows().getCount();

         if (cols == width + 3  && rows == height + 3) {
             bResult = true ;
         } else {
             bResult = false ;
             log.println( "After collapseToSize() call region must have size "
                 + (width + 3) + "x" + (height + 3) + " but it is "
                 + cols + "x" +rows);
         }

         tRes.tested("collapseToSize()", bResult) ;

         // restore original size
         oObj.collapseToSize(width, height) ;
     }

     /**
     * Test expands cursor to entire columns, checks size
     * of cursor range and restores original size of cursor range. <p>
     * Has <b> OK </b> status if after expanding cursor
     * range extends to all rows in the columns (number of rows is greater than
     * 32000 and number of columns remains the same). <p>
     */
     public void _expandToEntireColumns(){
         boolean bResult = false;
         int width = 1, height = 1 ;

         // expandToEntireColumns() method test
         oObj.expandToEntireColumns () ;

         // checking results
         int cols = ((XColumnRowRange)
             UnoRuntime.queryInterface(
                 XColumnRowRange.class, oObj) ).getColumns().getCount();
         int rows = ((XColumnRowRange)
             UnoRuntime.queryInterface(
                 XColumnRowRange.class, oObj) ).getRows().getCount();

         if (cols == width && rows >= 32000) {
             bResult = true ;
         } else {
             bResult = false ;
             log.println(
                 "After expandToEntireColumns() call region must have size "+
                 width + "x(>=32000) but it is " + cols + "x" + rows);
         }

         tRes.tested("expandToEntireColumns()", bResult) ;

         // restore original size
         oObj.collapseToSize(width, height) ;
     }

     /**
     * Test expands cursor to entire rows, checks size
     * of cursor range and restores original size of cursor range. <p>
     * Has <b> OK </b> status if after expanding cursor
     * range extends to all columns in the rows (number of columns is greater
     * than 256 and number of rows remains the same). <p>
     */
     public void _expandToEntireRows(){
         boolean bResult = false;
         int width = 1, height = 1 ;

         // expandToEntireRows() method test
         oObj.expandToEntireRows () ;

         // checking results
         int cols = ((XColumnRowRange)
             UnoRuntime.queryInterface(
                 XColumnRowRange.class, oObj) ).getColumns().getCount();
         int rows = ((XColumnRowRange)
             UnoRuntime.queryInterface(
                 XColumnRowRange.class, oObj) ).getRows().getCount();

         if (cols >= 256 && rows == height) {
             bResult = true;
         } else {
             bResult = false ;
             log.println("After expandToEntireRows() call region " +
                 "must have size (>=256)x" + height + " but it is " +
                 cols + "x" + rows );
         }

         tRes.tested("expandToEntireRows()", bResult) ;

         // restore original size
         oObj.collapseToSize(width, height) ;
     }

 } // EOC _XSheetCellCursor
	/**************************************************************
	*
	* Licensed to the Apache Software Foundation (ASF) under one
	* or more contributor license agreements. See the NOTICE file
	* distributed with this work for additional information
	* regarding copyright ownership. The ASF licenses this file
	* to you under the Apache License, Version 2.0 (the
	* "License"); you may not use this file except in compliance
	* with the License. You may obtain a copy of the License at
	*
	* http://www.apache.org/licenses/LICENSE-2.0
	*
	* Unless required by applicable law or agreed to in writing,
	* software distributed under the License is distributed on an
	* "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
	* KIND, either express or implied. See the License for the
	* specific language governing permissions and limitations
	* under the License.
	*
	*************************************************************/



	package ifc.sheet;

	import lib.MultiMethodTest;

	import com.sun.star.sheet.CellFlags;
	import com.sun.star.sheet.XArrayFormulaRange;
	import com.sun.star.sheet.XCellRangeAddressable;
	import com.sun.star.sheet.XSheetCellCursor;
	import com.sun.star.sheet.XSheetOperation;
	import com.sun.star.sheet.XSpreadsheet;
	import com.sun.star.table.CellRangeAddress;
	import com.sun.star.table.XCellRange;
	import com.sun.star.table.XColumnRowRange;
	import com.sun.star.uno.UnoRuntime;
	import com.sun.star.util.XMergeable;

	/**
	* Testing <code>com.sun.star.sheet.XSheetCellCursor</code>
	* interface methods :
	* <ul>
	* <li><code> collapseToCurrentRegion()</code></li>
	* <li><code> collapseToCurrentArray()</code></li>
	* <li><code> collapseToMergedArea()</code></li>
	* <li><code> expandToEntireColumns()</code></li>
	* <li><code> expandToEntireRows()</code></li>
	* <li><code> collapseToSize()</code></li>
	* </ul> <p>
	* Component must also implement the following interfaces :
	* <ul>
	* <li> <code> com.sun.star.sheet.XCellRangeAddressable </code> :
	* to get range address </li>
	* <ul> <p>
	* Range of cursor must be of size 4 x 4. <p>
	* @see com.sun.star.sheet.XSheetCellCursor
	*/
	public class _XSheetCellCursor extends MultiMethodTest {

	public XSheetCellCursor oObj = null;

	/**
	* Test creates the array formula, assigns this array to another array,
	* collapses cursor into one cell, applies method, checks the size of the
	* result range, erases array formula, checks that array formula has been
	* cleared. <p>
	* Has <b>OK</b> status if no exceptions were thrown, if size of the result
	* range is equal to size of the range where the array formula was set and
	* if array formula was successfully cleared. <p>
	*/
	public void _collapseToCurrentArray() {
	boolean bResult = false;

	XCellRangeAddressable crAddr = (XCellRangeAddressable)
	UnoRuntime.queryInterface(XCellRangeAddressable.class, oObj);
	CellRangeAddress addr = crAddr.getRangeAddress() ;
	int leftCol = addr.StartColumn ;
	int topRow = addr.StartRow ;
	int width = addr.EndColumn - addr.StartColumn + 1 ;
	int height = addr.EndRow - addr.StartRow + 1 ;

	log.println( "Object area is ((" + leftCol + "," + topRow + "),(" +
	(leftCol + width - 1) + "," + (topRow + height - 1) + ")" );

	XCellRange new_range = null;
	try {
	// first we need to create an array formula
	new_range =
	oObj.getCellRangeByPosition(0, 0, 0, height - 1);
	} catch (com.sun.star.lang.IndexOutOfBoundsException e) {
	log.print("Get cell range by position failed: ");
	e.printStackTrace(log);
	tRes.tested("collapseToCurrentArray()", false);
	}

	log.println("DB: Successfully new range created");
	XArrayFormulaRange arrFormulaRange = (XArrayFormulaRange)
	UnoRuntime.queryInterface (XArrayFormulaRange.class, new_range);
	// write a simple formula (this array assigns another array)
	arrFormulaRange.setArrayFormula("A1:A" + height) ;

	// collapse cursor into one cell and then try to apply the method
	oObj.collapseToSize (1, 1) ;
	oObj.collapseToCurrentArray() ;

	// check the size of result range
	int cols = ( (XColumnRowRange)UnoRuntime.queryInterface(
	XColumnRowRange.class, oObj) ).getColumns().getCount();
	int rows = ( (XColumnRowRange)UnoRuntime.queryInterface(
	XColumnRowRange.class, oObj) ).getRows().getCount();

	if (cols == 1 && rows == height) {
	bResult = true;
	} else {
	bResult = false;
	log.println("The size of cell range must be 1x" + height +
	", but after method call it was " + cols + "x" + rows);
	}

	// erase array formula
	arrFormulaRange.setArrayFormula("");

	// check if array formula has been cleared with last statement
	try {
	// if array formula isn't cleared exception is thrown
	new_range.getCellByPosition(0,0).setValue(111) ;
	} catch (com.sun.star.lang.IndexOutOfBoundsException e) {
	bResult = false ;
	log.println(
	"Array formula hasn't been cleared with setArrayFormula(\"\")");
	XSheetOperation clearRange = (XSheetOperation)
	UnoRuntime.queryInterface (XSheetOperation.class, new_range);
	int allFlags =
	CellFlags.ANNOTATION \| CellFlags.DATETIME \| CellFlags.EDITATTR;
	allFlags = allFlags
	\| CellFlags.HARDATTR \| CellFlags.OBJECTS \| CellFlags.STRING;
	allFlags = allFlags
	\| CellFlags.VALUE \| CellFlags.FORMULA \| CellFlags.STYLES;
	clearRange.clearContents(allFlags) ;
	}

	tRes.tested("collapseToCurrentArray()", bResult );
	}

	/**
	* Test clears contents of spreadsheet, collapses cursor to current range,
	* checks size of cursor range, fills a cell that is close to
	* cursor range, collapses cursor to current range, checks size of cursor
	* range again and restores original size. <p>
	* Has <b> OK </b> status if after clearing of content and collapsing cursor
	* range size remains 4 x 4, if after filling of cell and collapsing cursor
	* range extends by one in both dimensions and no exceptions were thrown.<p>
	*/
	public void _collapseToCurrentRegion(){
	boolean bResult = true;
	int width = 4, height = 4;
	int leftCol = -1, topRow = -1;

	XSpreadsheet oSheet = oObj.getSpreadsheet();
	((XSheetOperation) UnoRuntime.queryInterface(
	XSheetOperation.class, oSheet) ).clearContents(65535);
	oObj.collapseToCurrentRegion();
	int cols = ((XColumnRowRange)
	UnoRuntime.queryInterface(
	XColumnRowRange.class, oObj) ).getColumns().getCount();
	int rows = ((XColumnRowRange)
	UnoRuntime.queryInterface(
	XColumnRowRange.class, oObj) ).getRows().getCount();

	if (cols != width \|\| rows != height) {
	bResult = false ;
	log.println("After collapseToCurrentRegion()"
	+ " call Region must have size " + width + "x" + height
	+ " but it is " + cols + "x" + rows);
	}

	// if previous test was successful try more complicated case
	if (bResult) {
	if (leftCol != -1 && topRow != -1) {
	try {
	oSheet.getCellByPosition(
	leftCol + width, topRow + height).setValue(1);
	} catch (com.sun.star.lang.IndexOutOfBoundsException e) {
	log.print("Can't get cell by position:");
	e.printStackTrace(log);
	bResult = false;
	}

	oObj.collapseToCurrentRegion() ;

	// checking results
	cols = ((XColumnRowRange)
	UnoRuntime.queryInterface(
	XColumnRowRange.class, oObj)).getColumns().getCount();
	rows = ((XColumnRowRange)
	UnoRuntime.queryInterface(
	XColumnRowRange.class, oObj)).getRows().getCount();

	if (cols == width + 1 && rows == height + 1) {
	bResult &= true;
	} else {
	bResult = false;
	log.println("After collapseToCurrentRegion() call [2]"
	+ " region must have size " + (width+1) + "x"
	+ (height + 1) + " but it is " + cols + "x" + rows );
	}
	}
	}

	tRes.tested("collapseToCurrentRegion()", bResult);

	// restore original size
	oObj.collapseToSize(width, height);
	}

	/**
	* Test merges a cells of range that has a greater size, collapses cursor to
	* merged area, checks size of cursor range and restores original size
	* of cursor range. <p>
	* Has <b> OK </b> status if after merging of cells and collapsing cursor
	* range extends by one in both dimensions and no exceptions were thrown.<p>
	*/
	public void _collapseToMergedArea(){
	int width = 1, height = 1 ;
	int leftCol = 0, topRow = 0 ;

	boolean bResult = true ;

	log.println("DB: Starting collapseToMergedArea() method test ...") ;
	XSpreadsheet oSheet = oObj.getSpreadsheet() ;
	log.println ("DB: got Spreadsheet.") ;

	XCellRange newRange = null;
	try {
	newRange = oSheet.getCellRangeByPosition (
	leftCol + width - 1, topRow + height - 1,
	leftCol + width, topRow + height );
	} catch (com.sun.star.lang.IndexOutOfBoundsException e) {
	log.println("Can't get cell range by position");
	e.printStackTrace(log);
	bResult = false;
	}

	XMergeable mergeRange = (XMergeable)
	UnoRuntime.queryInterface (XMergeable.class, newRange);
	if (mergeRange == null) {
	log.println("DB: newRange doesn't implement XMergeable interface");
	} else {
	log.println("DB: XMergeable interface successfully queried.");
	}

	mergeRange.merge(true);
	log.println("DB: Successfuly merged.") ;

	oObj.collapseToMergedArea() ;
	log.println("DB: Succesfully collapseToMergedArea() method called");

	// unmerge area to restore SpreadSheet
	mergeRange.merge(false);
	log.println("DB: Successfully unmerged.") ;

	// checking results
	int cols = ((XColumnRowRange)
	UnoRuntime.queryInterface(
	XColumnRowRange.class, oObj) ).getColumns().getCount();
	int rows = ((XColumnRowRange)
	UnoRuntime.queryInterface(
	XColumnRowRange.class, oObj) ).getRows().getCount();
	log.println("DB: Column and row numbers succesfully get") ;

	if (cols == width + 1 && rows == height + 3) {
	bResult &= true;
	} else {
	bResult = false;
	log.println(
	"After collapseToMergedArea() call region must have size "
	+ (width + 1) + "x" + (height + 1) + " but it is " + cols
	+ "x" + rows );
	}

	tRes.tested("collapseToMergedArea()", bResult) ;

	// restore original size
	oObj.collapseToSize(width, height);
	}

	/**
	* Test collapses cursor to the new size, checks size
	* of cursor range and restores original size of cursor range. <p>
	* Has <b> OK </b> status if after collapsing cursor
	* range extends by three in both dimensions. <p>
	*/
	public void _collapseToSize(){
	boolean bResult = false;
	int width = 1, height = 1;

	// collapseToSize() method test
	oObj.collapseToSize (width + 3, height + 3);

	// checking results
	int cols = ((XColumnRowRange)
	UnoRuntime.queryInterface(
	XColumnRowRange.class, oObj) ).getColumns().getCount();
	int rows = ((XColumnRowRange)
	UnoRuntime.queryInterface(
	XColumnRowRange.class, oObj) ).getRows().getCount();

	if (cols == width + 3 && rows == height + 3) {
	bResult = true ;
	} else {
	bResult = false ;
	log.println( "After collapseToSize() call region must have size "
	+ (width + 3) + "x" + (height + 3) + " but it is "
	+ cols + "x" +rows);
	}

	tRes.tested("collapseToSize()", bResult) ;

	// restore original size
	oObj.collapseToSize(width, height) ;
	}

	/**
	* Test expands cursor to entire columns, checks size
	* of cursor range and restores original size of cursor range. <p>
	* Has <b> OK </b> status if after expanding cursor
	* range extends to all rows in the columns (number of rows is greater than
	* 32000 and number of columns remains the same). <p>
	*/
	public void _expandToEntireColumns(){
	boolean bResult = false;
	int width = 1, height = 1 ;

	// expandToEntireColumns() method test
	oObj.expandToEntireColumns () ;

	// checking results
	int cols = ((XColumnRowRange)
	UnoRuntime.queryInterface(
	XColumnRowRange.class, oObj) ).getColumns().getCount();
	int rows = ((XColumnRowRange)
	UnoRuntime.queryInterface(
	XColumnRowRange.class, oObj) ).getRows().getCount();

	if (cols == width && rows >= 32000) {
	bResult = true ;
	} else {
	bResult = false ;
	log.println(
	"After expandToEntireColumns() call region must have size "+
	width + "x(>=32000) but it is " + cols + "x" + rows);
	}

	tRes.tested("expandToEntireColumns()", bResult) ;

	// restore original size
	oObj.collapseToSize(width, height) ;
	}

	/**
	* Test expands cursor to entire rows, checks size
	* of cursor range and restores original size of cursor range. <p>
	* Has <b> OK </b> status if after expanding cursor
	* range extends to all columns in the rows (number of columns is greater
	* than 256 and number of rows remains the same). <p>
	*/
	public void _expandToEntireRows(){
	boolean bResult = false;
	int width = 1, height = 1 ;

	// expandToEntireRows() method test
	oObj.expandToEntireRows () ;

	// checking results
	int cols = ((XColumnRowRange)
	UnoRuntime.queryInterface(
	XColumnRowRange.class, oObj) ).getColumns().getCount();
	int rows = ((XColumnRowRange)
	UnoRuntime.queryInterface(
	XColumnRowRange.class, oObj) ).getRows().getCount();

	if (cols >= 256 && rows == height) {
	bResult = true;
	} else {
	bResult = false ;
	log.println("After expandToEntireRows() call region " +
	"must have size (>=256)x" + height + " but it is " +
	cols + "x" + rows );
	}

	tRes.tested("expandToEntireRows()", bResult) ;

	// restore original size
	oObj.collapseToSize(width, height) ;
	}

	} // EOC _XSheetCellCursor