/*************************************************************************
*
* $RCSfile: ScCellsObj.java,v $
*
* $Revision: 1.1 $
*
* last change:$Date: 2003-01-27 18:16:36 $
*
* The Contents of this file are made available subject to the terms of
* either of the following licenses
*
* - GNU Lesser General Public License Version 2.1
* - Sun Industry Standards Source License Version 1.1
*
* Sun Microsystems Inc., October, 2000
*
* GNU Lesser General Public License Version 2.1
* =============================================
* Copyright 2000 by Sun Microsystems, Inc.
* 901 San Antonio Road, Palo Alto, CA 94303, USA
*
* This library is free software; you can redistribute it and/or
* modify it under the terms of the GNU Lesser General Public
* License version 2.1, as published by the Free Software Foundation.
*
* This library 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 for more details.
*
* You should have received a copy of the GNU Lesser General Public
* License along with this library; if not, write to the Free Software
* Foundation, Inc., 59 Temple Place, Suite 330, Boston,
* MA 02111-1307 USA
*
*
* Sun Industry Standards Source License Version 1.1
* =================================================
* The contents of this file are subject to the Sun Industry Standards
* Source License Version 1.1 (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.openoffice.org/license.html.
*
* Software provided under this License is provided on an "AS IS" basis,
* WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING,
* WITHOUT LIMITATION, WARRANTIES THAT THE SOFTWARE IS FREE OF DEFECTS,
* MERCHANTABLE, FIT FOR A PARTICULAR PURPOSE, OR NON-INFRINGING.
* See the License for the specific provisions governing your rights and
* obligations concerning the Software.
*
* The Initial Developer of the Original Code is: Sun Microsystems, Inc.
*
* Copyright: 2000 by Sun Microsystems, Inc.
*
* All Rights Reserved.
*
* Contributor(s): _______________________________________
*
*
************************************************************************/
package mod._sc;
import com.sun.star.container.XIndexAccess;
import com.sun.star.frame.XComponentLoader;
import com.sun.star.frame.XDesktop;
import com.sun.star.lang.XComponent;
import com.sun.star.sheet.XCellRangesQuery;
import com.sun.star.sheet.XSheetCellRanges;
import com.sun.star.sheet.XSpreadsheetDocument;
import com.sun.star.sheet.XSpreadsheets;
import com.sun.star.table.XCell;
import com.sun.star.table.XCellRange;
import com.sun.star.text.XTextRange;
import com.sun.star.uno.UnoRuntime;
import com.sun.star.uno.XInterface;
import java.io.PrintWriter;
import lib.StatusException;
import lib.TestCase;
import lib.TestEnvironment;
import lib.TestParameters;
import util.SOfficeFactory;
/**
* Test for object which is represented by service
* com.sun.star.sheet.Cells
.
* Object implements the following interfaces : *
com::sun::star::container::XEnumerationAccess
com::sun::star::container::XElementAccess
XCellRangesQuery
. Retrieves a collection of cells from
* this cell range, this collection is instance of the service
* com.sun.star.sheet.Cells
.
* @see com.sun.star.sheet.XCellRangesQuery
*/
public synchronized TestEnvironment createTestEnvironment(
TestParameters Param, PrintWriter log) throws StatusException {
XInterface oInterface = null;
XInterface oObj = null;
XComponentLoader oCLoader = null;
XDesktop oDesktop = null;
XSpreadsheetDocument oSheetDoc = null ;
Object cellArr[] = new Object[3];
// creation of testobject here
XSpreadsheets oSheets = (XSpreadsheets)xSheetDoc.getSheets();
XIndexAccess oIndexAccess = (XIndexAccess)
UnoRuntime.queryInterface(XIndexAccess.class, oSheets);
XCellRange oSheet = null;
try {
oSheet = (XCellRange)oIndexAccess.getByIndex(0);
XCell oCell_1 = (XCell)oSheet.getCellByPosition(0, 0);
XTextRange oTextRange = (XTextRange)
UnoRuntime.queryInterface(XTextRange.class, oCell_1);
oTextRange.setString("ScCellsObj test 1");
XCell oCell_2 = (XCell)oSheet.getCellByPosition(5, 1);
oCell_2.setValue(15);
XCell oCell_3 = (XCell)oSheet.getCellByPosition(3, 9);
oTextRange = (XTextRange)
UnoRuntime.queryInterface(XTextRange.class, oCell_3);
oTextRange.setString("ScCellsObj test 2");
cellArr[0] = oCell_1;
cellArr[2] = oCell_2;
cellArr[1] = oCell_3;
} catch(com.sun.star.lang.WrappedTargetException e) {
log.println ("Exception occured while creating test Object.");
e.printStackTrace(log);
throw new StatusException("Couldn't create test object", e);
} catch(com.sun.star.lang.IndexOutOfBoundsException e) {
log.println ("Exception occured while creating test Object.");
e.printStackTrace(log);
throw new StatusException("Couldn't create test object", e);
}
XCellRangesQuery oCellRangesQuery = (XCellRangesQuery)
UnoRuntime.queryInterface(XCellRangesQuery.class, oSheet);
XSheetCellRanges oSheetCellRanges = oCellRangesQuery.queryVisibleCells();
oObj = oSheetCellRanges.getCells();
TestEnvironment tEnv = new TestEnvironment(oObj) ;
log.println ("Object created.") ;
return tEnv;
}
} // finish class ScCellsObj