/*************************************************************************
*
* DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
*
* Copyright 2008 by Sun Microsystems, Inc.
*
* OpenOffice.org - a multi-platform office productivity suite
*
* $RCSfile: _XCellRangeMovement.java,v $
* $Revision: 1.4 $
*
* 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.sheet;
import lib.MultiMethodTest;
import com.sun.star.sheet.CellDeleteMode;
import com.sun.star.sheet.CellInsertMode;
import com.sun.star.sheet.XCellRangeAddressable;
import com.sun.star.sheet.XCellRangeMovement;
import com.sun.star.sheet.XSpreadsheet;
import com.sun.star.table.CellAddress;
import com.sun.star.table.CellRangeAddress;
import com.sun.star.table.XColumnRowRange;
import com.sun.star.table.XTableRows;
import com.sun.star.uno.UnoRuntime;
/**
* Testing <code>com.sun.star.sheet.XCellRangeMovement</code>
* interface methods :
* <ul>
* <li><code> insertCells()</code></li>
* <li><code> removeRange()</code></li>
* <li><code> moveRange()</code></li>
* <li><code> copyRange()</code></li>
* </ul> <p>
* Test object must implements interfaces <code>XCellRangeAddressable</code>
* and <code>XSpreadsheet</code> also. <p>
* @see com.sun.star.sheet.XCellRangeMovement
* @see com.sun.star.sheet.XSpreadsheet
* @see com.sun.star.sheet.XCellRangeAddressable
*/
public class _XCellRangeMovement extends MultiMethodTest {
public XCellRangeMovement oObj = null;
/**
* Test sets specific values to cells in the range, copies this cell range
* to another position in document and checks cell's values in new position.<p>
* Has <b> OK </b> status if cell's values in source range are equal to
* cell's values in destination range and no exceptions were thrown. <p>
*/
public void _copyRange(){
log.println("Prepare cells before test methods.");
XSpreadsheet oSheet = (XSpreadsheet)
UnoRuntime.queryInterface(XSpreadsheet.class, oObj);
try {
oSheet.getCellByPosition(1,1).setValue(100);
oSheet.getCellByPosition(1,2).setValue(200);
oSheet.getCellByPosition(2,1).setValue(300);
oSheet.getCellByPosition(2,2).setValue(400);
} catch (com.sun.star.lang.IndexOutOfBoundsException e) {
e.printStackTrace(log);
tRes.tested("copyRange()", false);
}
XCellRangeAddressable oAddr =
(XCellRangeAddressable)
UnoRuntime.queryInterface (XCellRangeAddressable.class, oObj);
short iSheet = oAddr.getRangeAddress().Sheet;
CellAddress sDest;
CellRangeAddress sSrc;
sSrc = new CellRangeAddress(iSheet, 1, 1, 2, 2);
sDest = new CellAddress(iSheet, 1, 10);
boolean result = true;
boolean loc_result = true;
oObj.copyRange(sDest, sSrc);
try {
loc_result = (oSheet.getCellByPosition(1, 10).getValue() == 100);
loc_result &= (oSheet.getCellByPosition(1, 11).getValue() == 200);
loc_result &= (oSheet.getCellByPosition(2, 10).getValue() == 300);
loc_result &= (oSheet.getCellByPosition(2, 11).getValue() == 400);
} catch (com.sun.star.lang.IndexOutOfBoundsException e) {
e.printStackTrace(log);
tRes.tested("copyRange()", false);
}
result &= loc_result;
tRes.tested("copyRange()", result);
}
/**
* Test sets specific values to cells in the two contiguous rows, inserts
* new empty row between them and checks value in
* one cell of the inserted row. <p>
* Has <b> OK </b> status if value of cell in the inserted row is zero
* and no exceptions were thrown. <p>
*/
public void _insertCells(){
boolean result = false;
XSpreadsheet oSheet = (XSpreadsheet)
UnoRuntime.queryInterface(XSpreadsheet.class, oObj);
XCellRangeAddressable oAddr = (XCellRangeAddressable)
UnoRuntime.queryInterface (XCellRangeAddressable.class, oObj);
short iSheet = oAddr.getRangeAddress().Sheet;
try {
oSheet.getCellByPosition(0,20).setValue(100);
oSheet.getCellByPosition(1,20).setValue(100);
oSheet.getCellByPosition(2,20).setValue(100);
oSheet.getCellByPosition(3,20).setValue(100);
oSheet.getCellByPosition(0,21).setValue(200);
oSheet.getCellByPosition(1,21).setValue(200);
oSheet.getCellByPosition(2,21).setValue(200);
oSheet.getCellByPosition(3,21).setValue(200);
// catch some sleight of hand threads
if (oSheet.getCellByPosition(1,21).getValue() == 200){
//log.println("Rows closed.");
}
else{
log.println("Cells were already inserted. "+
"Delete old cells now");
XColumnRowRange oColumnRowRange = (XColumnRowRange)
UnoRuntime.queryInterface(XColumnRowRange.class, oSheet);
XTableRows oRows = (XTableRows) oColumnRowRange.getRows();
oRows.removeByIndex(21,1);
}
CellRangeAddress sSrc = new CellRangeAddress(iSheet, 0, 21, 5, 21);
oObj.insertCells (sSrc, CellInsertMode.DOWN) ;
// check the result
double res = oSheet.getCellByPosition(1, 21).getValue();
if (res == 0.0) {
result = true;
}
} catch (com.sun.star.lang.IndexOutOfBoundsException e) {
e.printStackTrace(log);
result = false;
}
tRes.tested("insertCells()", result);
}
/**
* Test sets specific values to cells in the range, moves this cell range
* to another position in document and checks cell's values in new position.
* <p>Has <b>OK</b> status if sum of values in source range is equal to sum
* of values in destination range and no exceptions were thrown. <p>
*/
public void _moveRange(){
boolean result = false;
XSpreadsheet oSheet = (XSpreadsheet)
UnoRuntime.queryInterface(XSpreadsheet.class, oObj);
XCellRangeAddressable oAddr = (XCellRangeAddressable)
UnoRuntime.queryInterface (XCellRangeAddressable.class, oObj);
short iSheet = oAddr.getRangeAddress().Sheet;
//prepare source range
try {
oSheet.getCellByPosition(4,0).setValue(111);
oSheet.getCellByPosition(4,1).setValue(222);
CellRangeAddress sSrc = new CellRangeAddress(iSheet, 4, 0, 4, 1);
CellAddress sDest = new CellAddress(iSheet, 4, 4);
oObj.moveRange(sDest, sSrc);
double cntA = 0;
double cntB = 0;
cntA = oSheet.getCellByPosition(4, 4).getValue();
cntB = oSheet.getCellByPosition(4, 5).getValue();
if (cntA + cntB == 333.0){ result = true; }
//clean up
oSheet.getCellByPosition(4,4).setValue(0);
oSheet.getCellByPosition(4,5).setValue(0);
} catch (com.sun.star.lang.IndexOutOfBoundsException e) {
e.printStackTrace(log);
result = false;
}
tRes.tested("moveRange()", result);
}
/**
* Test sets specific values to cells in the range, deletes this cell range
* from document and checks values of cells in position
* of the deleted range.
* <p>Has <b>OK</b> status if sum of cell values in position of the deleted
* range is equal to zero and no exceptions were thrown. <p>
*/
public void _removeRange(){
boolean result = false;
XSpreadsheet oSheet = (XSpreadsheet)
UnoRuntime.queryInterface(XSpreadsheet.class, oObj);
XCellRangeAddressable oAddr = (XCellRangeAddressable)
UnoRuntime.queryInterface (XCellRangeAddressable.class, oObj);
short iSheet = oAddr.getRangeAddress().Sheet;
try {
//prepare source range
oSheet.getCellByPosition(5, 0).setValue(333);
oSheet.getCellByPosition(5, 1).setValue(444);
CellRangeAddress sSrc = new CellRangeAddress(iSheet, 5, 0, 5, 1);
oObj.removeRange(sSrc, CellDeleteMode.UP);
double cntA = 0;
double cntB = 0;
cntA = oSheet.getCellByPosition(5, 0).getValue();
cntB = oSheet.getCellByPosition(5, 1).getValue();
if (cntA + cntB == 0.0){ result = true; }
//clean up
oSheet.getCellByPosition(5, 0).setValue(0);
oSheet.getCellByPosition(5, 1).setValue(0);
} catch (com.sun.star.lang.IndexOutOfBoundsException e) {
e.printStackTrace(log);
result = false;
}
tRes.tested("removeRange()", result);
}
} // EOC _XCellRangeMovement