/************************************************************** * * 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 : *

* 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