/************************************************************************* * * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. * * Copyright 2000, 2010 Oracle and/or its affiliates. * * OpenOffice.org - a multi-platform office productivity suite * * 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 * * for a copy of the LGPLv3 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