/**************************************************************
*
* 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 com.sun.star.sheet.XSpreadsheets;
import lib.MultiMethodTest;
/**
* Testing com.sun.star.sheet.XSpreadsheets
* interface methods :
*
insertNewByName()
moveByName()
copyByName()
* Test is multithread compilant.
* @see com.sun.star.sheet.XSpreadsheets
*/
public class _XSpreadsheets extends MultiMethodTest {
protected static int uniqCount = 0;
public XSpreadsheets oObj = null;
protected int uniqNumber = 0;
/**
* Sets the unique number for the current test.
*/
protected synchronized void before() {
uniqNumber = uniqCount++;
}
/**
* Test inserts new sheet using the name returned by the method
* newName
, copies inserted sheet with the new name,
* checks existence of the sheet with this name in collection and removes
* the both sheets from the collection.
* Has OK status if the sheet with the name of the copy exists * in the collection and no exceptions were thrown.
*/
public void _copyByName() {
boolean result = true;
//first insert one that should be copied
String iS = newName("copyFrom");
log.println("Inserting sheet '" + iS + "'");
oObj.insertNewByName(iS, (short) 0);
String[] eNames = oObj.getElementNames();
String NewSheet = newName("copyTo");
log.println("Try to copy " + eNames[0] + " to " + NewSheet);
oObj.copyByName(eNames[0], NewSheet, (short) 0);
result = oObj.hasByName(NewSheet);
//remove all inserted sheets
try {
oObj.removeByName(NewSheet);
oObj.removeByName(iS);
} catch (com.sun.star.lang.WrappedTargetException e) {
log.print("Can't remove sheet by name");
e.printStackTrace(log);
result = false;
} catch (com.sun.star.container.NoSuchElementException e) {
log.print("Can't remove sheet by name");
e.printStackTrace(log);
result = false;
}
tRes.tested("copyByName()", result);
} // finished _copyByName
/**
* Test inserts new sheet using the name returned by the method
* newName
, moves the inserted sheet to the new position
* in collection, gets all element names in collection and checks the name
* of the sheet in the new position.
* Has OK status if the sheet name in the new position is equal to * the name of the sheet that was moved.
*/
public void _moveByName() {
//first insert one that should be moved
String iS = newName("move");
oObj.insertNewByName(iS, (short) 0);
String[] eNames = oObj.getElementNames();
String sheetToMove = eNames[0];
log.println("Try to move " + sheetToMove);
oObj.moveByName(sheetToMove, (short) 2);
eNames = oObj.getElementNames();
tRes.tested("moveByName()", sheetToMove.equals(eNames[1]));
} // finished _moveByName
/**
* Test inserts new sheet using the name returned by the method
* newName
, checks the existence of the inserted sheet in
* the collection, removes the sheet, tries to insert the sheet with the
* bad name returned by method badName()
.
* Has OK status if the inserted sheet exists in the collection * after first method call and if exception occured during the second call.
*/ public void _insertNewByName() { boolean result = false; String NewSheet = newName("insert"); log.println("Try to insert " + NewSheet); oObj.insertNewByName(NewSheet, (short) 0); result = oObj.hasByName(NewSheet); try { oObj.removeByName(NewSheet); } catch (com.sun.star.lang.WrappedTargetException e) { log.print("Can't remove sheet '" + NewSheet + "':"); e.printStackTrace(log); result = false; } catch (com.sun.star.container.NoSuchElementException e) { log.print("Can't remove sheet '" + NewSheet + "':"); e.printStackTrace(log); result = false; } try { NewSheet = badName(); log.println("Try to insert " + NewSheet); oObj.insertNewByName(NewSheet, (short) 0); log.println( "No Exception thrown while inserting sheet with invalid name"); result &= false; oObj.removeByName(NewSheet); } catch (com.sun.star.uno.RuntimeException e) { log.println( "Expected exception occured during testing 'insertNewByName'"); result &= true; } catch (com.sun.star.lang.WrappedTargetException e) { log.print("Can't remove sheet '" + NewSheet + "':"); e.printStackTrace(log); result = false; } catch (com.sun.star.container.NoSuchElementException e) { log.print("Can't remove sheet '" + NewSheet + "':"); e.printStackTrace(log); result = false; } tRes.tested("insertNewByName()", result); } // finished _insertByName /** * Method returns unique new name using passed prefix and unique number * of the current test. */ public String newName(String prefix) { return prefix + uniqNumber; } // finished newName /** * Method return bad name for a sheet using the name of the current thread. */ public String badName() { return "$%#/?\\"; } // finished badName } //finish class _XSpreadsheets