/*************************************************************************
*
* 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: _XSheetCellRangeContainer.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 lib.StatusException;
import com.sun.star.sheet.XSheetCellRangeContainer;
import com.sun.star.table.CellRangeAddress;
/**
* Testing <code>com.sun.star.sheet.XSheetCellRangeContainer</code>
* interface methods :
* <ul>
* <li><code> addRangeAddress() </code></li>
* <li><code> removeRangeAddress() </code></li>
* <li><code> addRangeAddresses() </code></li>
* <li><code> removeRangeAddresses() </code></li>
* </ul> <p>
* Test is <b> NOT </b> multithread compilant. <p>
* @see com.sun.star.sheet.XSheetCellRangeContainer
*/
public class _XSheetCellRangeContainer extends MultiMethodTest {
public XSheetCellRangeContainer oObj = null;
public CellRangeAddress[] rAddr = new CellRangeAddress[3];
/**
* After method called, the new array of structures 'CellRangeAddress'
* is created. Then container is cleared.
*/
public void before() {
for ( short i=0; i<=2; i++ ) {
rAddr[i] = new CellRangeAddress();
rAddr[i].Sheet = i;
rAddr[i].StartColumn = i;
rAddr[i].StartRow = i;
rAddr[i].EndColumn = i + 3;
rAddr[i].EndRow = i + 3;
try {
oObj.removeRangeAddresses(oObj.getRangeAddresses());
} catch (com.sun.star.uno.Exception e) {
e.printStackTrace(log);
throw new StatusException("Error: Cannot remove "+
"range addresses." ,e);
}
}
}
/**
* The method called. Then new value is added to Container.
* Next we try to obtain back added value and check it. <p>
*
* Has <b> OK </b> status if the range just added presents among
* all ranges in the container.
*/
public void _addRangeAddress() {
boolean result = true;
log.println("Elements before adding: " + oObj.getCount());
oObj.addRangeAddress(rAddr[0], false);
log.println("Elements after adding: " + oObj.getCount());
CellRangeAddress[] addr = oObj.getRangeAddresses();
boolean exist = false ;
for (int i=0; i<=oObj.getCount()-1; i++) {
if ( addr[i].Sheet == rAddr[0].Sheet &&
addr[i].StartColumn == rAddr[0].StartColumn &&
addr[i].StartRow == rAddr[0].StartRow &&
addr[i].EndColumn == rAddr[0].EndColumn &&
addr[i].EndRow == rAddr[0].EndRow) {
exist = true;
}
}
result &= exist ;
tRes.tested("addRangeAddress()" ,result);
}
/**
* The method called. Then a value added before is removed.
* Next we check Container for existence of removed value. <p>
* Has <b> OK </b> status if the range just removed doesn't presents among
* all ranges in the container.
*/
public void _removeRangeAddress() {
boolean result = true;
log.println("Elements before removing: " + oObj.getCount());
try {
oObj.removeRangeAddress(rAddr[0]);
} catch (com.sun.star.container.NoSuchElementException e) {
e.printStackTrace(log);
result = false;
}
log.println("Elements after removing: " + oObj.getCount());
CellRangeAddress[] addr = oObj.getRangeAddresses();
for (int i=0; i<=oObj.getCount()-1; i++) {
if ( (addr[i].Sheet == rAddr[0].Sheet) &&
(addr[i].StartColumn == rAddr[0].StartColumn) &&
(addr[i].StartRow == rAddr[0].StartRow) &&
(addr[i].EndColumn == rAddr[0].EndColumn) &&
(addr[i].EndRow == rAddr[0].EndRow) ) {
result = false;
}
}
tRes.tested("removeRangeAddress()" ,result);
}
/**
* The method called. Then new values are added to Container.
* Next we try to obtain back all added values and check it. <p>
*
* Has <b> OK </b> status if the count of ranges increases by
* number of added ranges - 1 (one of ranges already exists in the
* container). And if all of ranges added exist in the container.
*/
public void _addRangeAddresses() {
executeMethod("addRangeAddress()");
boolean result = true;
int cntBefore = oObj.getCount();
log.println("Elements before adding: " + cntBefore);
oObj.addRangeAddresses(rAddr, false);
log.println("Elements after adding: " + oObj.getCount());
CellRangeAddress[] addr = oObj.getRangeAddresses();
result &= cntBefore + rAddr.length == oObj.getCount();
for (int j = 0; j < rAddr.length; j++) {
boolean exist = false ;
for (int i=0; i < oObj.getCount(); i++) {
if ( addr[i].Sheet == rAddr[j].Sheet &&
addr[i].StartColumn == rAddr[j].StartColumn &&
addr[i].StartRow == rAddr[j].StartRow &&
addr[i].EndColumn == rAddr[j].EndColumn &&
addr[i].EndRow == rAddr[j].EndRow ) {
exist = true;
break;
}
}
result &= exist;
}
tRes.tested("addRangeAddresses()" ,result);
}
/**
* All ranges are remover from contaier.
*
* Has <b> OK </b> status if there are no more ranges in the container.
*/
public void _removeRangeAddresses() {
boolean result = false;
int cnt;
log.println("Elements before removing: " + oObj.getCount());
try {
oObj.removeRangeAddresses(oObj.getRangeAddresses());
} catch (com.sun.star.container.NoSuchElementException e) {
e.printStackTrace(log);
result = false;
}
if ( (cnt = oObj.getCount()) == 0) {
result = true;
}
log.println("Elements after removing: " + cnt);
tRes.tested("removeRangeAddresses()" ,result);
}
/**
* Forces environment recreation.
*/
protected void after() {
disposeEnvironment();
}
}