1*ef39d40dSAndrew Rist /************************************************************** 2cdf0e10cSrcweir * 3*ef39d40dSAndrew Rist * Licensed to the Apache Software Foundation (ASF) under one 4*ef39d40dSAndrew Rist * or more contributor license agreements. See the NOTICE file 5*ef39d40dSAndrew Rist * distributed with this work for additional information 6*ef39d40dSAndrew Rist * regarding copyright ownership. The ASF licenses this file 7*ef39d40dSAndrew Rist * to you under the Apache License, Version 2.0 (the 8*ef39d40dSAndrew Rist * "License"); you may not use this file except in compliance 9*ef39d40dSAndrew Rist * with the License. You may obtain a copy of the License at 10*ef39d40dSAndrew Rist * 11*ef39d40dSAndrew Rist * http://www.apache.org/licenses/LICENSE-2.0 12*ef39d40dSAndrew Rist * 13*ef39d40dSAndrew Rist * Unless required by applicable law or agreed to in writing, 14*ef39d40dSAndrew Rist * software distributed under the License is distributed on an 15*ef39d40dSAndrew Rist * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 16*ef39d40dSAndrew Rist * KIND, either express or implied. See the License for the 17*ef39d40dSAndrew Rist * specific language governing permissions and limitations 18*ef39d40dSAndrew Rist * under the License. 19*ef39d40dSAndrew Rist * 20*ef39d40dSAndrew Rist *************************************************************/ 21*ef39d40dSAndrew Rist 22*ef39d40dSAndrew Rist 23cdf0e10cSrcweir package mod._sc; 24cdf0e10cSrcweir 25cdf0e10cSrcweir import java.io.PrintWriter; 26cdf0e10cSrcweir 27cdf0e10cSrcweir import lib.StatusException; 28cdf0e10cSrcweir import lib.TestCase; 29cdf0e10cSrcweir import lib.TestEnvironment; 30cdf0e10cSrcweir import lib.TestParameters; 31cdf0e10cSrcweir import util.SOfficeFactory; 32cdf0e10cSrcweir 33cdf0e10cSrcweir import com.sun.star.container.XEnumerationAccess; 34cdf0e10cSrcweir import com.sun.star.container.XIndexAccess; 35cdf0e10cSrcweir import com.sun.star.lang.XComponent; 36cdf0e10cSrcweir import com.sun.star.lang.XMultiServiceFactory; 37cdf0e10cSrcweir import com.sun.star.sheet.XCellRangesQuery; 38cdf0e10cSrcweir import com.sun.star.sheet.XSheetCellRanges; 39cdf0e10cSrcweir import com.sun.star.sheet.XSpreadsheetDocument; 40cdf0e10cSrcweir import com.sun.star.sheet.XSpreadsheets; 41cdf0e10cSrcweir import com.sun.star.table.XCell; 42cdf0e10cSrcweir import com.sun.star.table.XCellRange; 43cdf0e10cSrcweir import com.sun.star.text.XTextRange; 44cdf0e10cSrcweir import com.sun.star.uno.AnyConverter; 45cdf0e10cSrcweir import com.sun.star.uno.Type; 46cdf0e10cSrcweir import com.sun.star.uno.UnoRuntime; 47cdf0e10cSrcweir import com.sun.star.uno.XInterface; 48cdf0e10cSrcweir 49cdf0e10cSrcweir /** 50cdf0e10cSrcweir * Test for object which is represented by service 51cdf0e10cSrcweir * <code>com.sun.star.sheet.CellsEnumeration</code>. <p> 52cdf0e10cSrcweir * Object implements the following interfaces : 53cdf0e10cSrcweir * <ul> 54cdf0e10cSrcweir * <li> <code>com::sun::star::container::XEnumeration</code></li> 55cdf0e10cSrcweir * </ul> 56cdf0e10cSrcweir * @see com.sun.star.sheet.CellsEnumeration 57cdf0e10cSrcweir * @see com.sun.star.container.XEnumeration 58cdf0e10cSrcweir * @see ifc.container._XEnumeration 59cdf0e10cSrcweir */ 60cdf0e10cSrcweir public class ScCellsEnumeration extends TestCase { 61cdf0e10cSrcweir static XSpreadsheetDocument xSheetDoc = null; 62cdf0e10cSrcweir 63cdf0e10cSrcweir /** 64cdf0e10cSrcweir * Creates Spreadsheet document. 65cdf0e10cSrcweir */ initialize( TestParameters tParam, PrintWriter log )66cdf0e10cSrcweir protected void initialize( TestParameters tParam, PrintWriter log ) { 67cdf0e10cSrcweir 68cdf0e10cSrcweir SOfficeFactory SOF = SOfficeFactory.getFactory( (XMultiServiceFactory)tParam.getMSF() ); 69cdf0e10cSrcweir 70cdf0e10cSrcweir try { 71cdf0e10cSrcweir log.println( "creating a Spreadsheet document" ); 72cdf0e10cSrcweir xSheetDoc = SOF.createCalcDoc(null); 73cdf0e10cSrcweir } catch ( com.sun.star.uno.Exception e ) { 74cdf0e10cSrcweir // Some exception occures.FAILED 75cdf0e10cSrcweir e.printStackTrace( log ); 76cdf0e10cSrcweir throw new StatusException( "Couldn't create document", e ); 77cdf0e10cSrcweir } 78cdf0e10cSrcweir } 79cdf0e10cSrcweir 80cdf0e10cSrcweir /** 81cdf0e10cSrcweir * Disposes Spreadsheet document. 82cdf0e10cSrcweir */ cleanup( TestParameters tParam, PrintWriter log )83cdf0e10cSrcweir protected void cleanup( TestParameters tParam, PrintWriter log ) { 84cdf0e10cSrcweir log.println( " disposing xSheetDoc " ); 85cdf0e10cSrcweir XComponent oComp = (XComponent) 86cdf0e10cSrcweir UnoRuntime.queryInterface (XComponent.class, xSheetDoc) ; 87cdf0e10cSrcweir util.DesktopTools.closeDoc(oComp); 88cdf0e10cSrcweir } 89cdf0e10cSrcweir 90cdf0e10cSrcweir /** 91cdf0e10cSrcweir * Creating a Testenvironment for the interfaces to be tested. 92cdf0e10cSrcweir * Retrieves a collection of spreadsheets from a document 93cdf0e10cSrcweir * and takes one of them. Replaces text of some cells. 94cdf0e10cSrcweir * Retrives a cell range of the visible cells using the interface 95cdf0e10cSrcweir * <code>XCellRangesQuery</code>. Retrieves a collection of cells from 96cdf0e10cSrcweir * this cell range and creates it's enumeration using the interface 97cdf0e10cSrcweir * <code>XEnumerationAccess</code>.The created enumeration is the instance 98cdf0e10cSrcweir * of the service <code>com.sun.star.sheet.CellsEnumeration</code>. 99cdf0e10cSrcweir * Object relations created : 100cdf0e10cSrcweir * <ul> 101cdf0e10cSrcweir * <li> <code>'ENUM'</code> for 102cdf0e10cSrcweir * {@link ifc.container._XEnumeration} (type of 103cdf0e10cSrcweir * <code>XEnumerationAccess</code> that was retrieved from the 104cdf0e10cSrcweir * collection of visible cells)</li> 105cdf0e10cSrcweir * </ul> 106cdf0e10cSrcweir * @see com.sun.star.sheet.XCellRangesQuery 107cdf0e10cSrcweir * @see com.sun.star.container.XEnumerationAccess 108cdf0e10cSrcweir */ createTestEnvironment(TestParameters Param, PrintWriter log)109cdf0e10cSrcweir protected synchronized TestEnvironment createTestEnvironment(TestParameters Param, PrintWriter log) { 110cdf0e10cSrcweir 111cdf0e10cSrcweir XInterface oObj = null; 112cdf0e10cSrcweir Object cellArr[] = new Object[3] ; 113cdf0e10cSrcweir XEnumerationAccess oEnum = null; 114cdf0e10cSrcweir 115cdf0e10cSrcweir // creation of testobject here 116cdf0e10cSrcweir XSpreadsheets oSheets = (XSpreadsheets)xSheetDoc.getSheets(); 117cdf0e10cSrcweir XIndexAccess oIndexAccess = (XIndexAccess) 118cdf0e10cSrcweir UnoRuntime.queryInterface(XIndexAccess.class, oSheets); 119cdf0e10cSrcweir XCellRange oSheet = null; 120cdf0e10cSrcweir try { 121cdf0e10cSrcweir oSheet = (XCellRange) AnyConverter.toObject( 122cdf0e10cSrcweir new Type(XCellRange.class),oIndexAccess.getByIndex(0)); 123cdf0e10cSrcweir 124cdf0e10cSrcweir XCell oCell_1 = (XCell)oSheet.getCellByPosition(0, 0); 125cdf0e10cSrcweir XTextRange oTextRange = (XTextRange) 126cdf0e10cSrcweir UnoRuntime.queryInterface(XTextRange.class, oCell_1); 127cdf0e10cSrcweir oTextRange.setString("Test string 1"); 128cdf0e10cSrcweir 129cdf0e10cSrcweir XCell oCell_2 = (XCell)oSheet.getCellByPosition(5, 1); 130cdf0e10cSrcweir oCell_2.setValue(15); 131cdf0e10cSrcweir 132cdf0e10cSrcweir XCell oCell_3 = (XCell)oSheet.getCellByPosition(3, 9); 133cdf0e10cSrcweir oTextRange = (XTextRange) 134cdf0e10cSrcweir UnoRuntime.queryInterface(XTextRange.class, oCell_3); 135cdf0e10cSrcweir oTextRange.setString("test 2"); 136cdf0e10cSrcweir cellArr[0] = oCell_1; 137cdf0e10cSrcweir cellArr[1] = oCell_2; 138cdf0e10cSrcweir cellArr[2] = oCell_3; 139cdf0e10cSrcweir } catch(com.sun.star.lang.WrappedTargetException e) { 140cdf0e10cSrcweir log.println ("Exception occured while creating test Object."); 141cdf0e10cSrcweir e.printStackTrace(log); 142cdf0e10cSrcweir throw new StatusException("Couldn't create test object", e); 143cdf0e10cSrcweir } catch(com.sun.star.lang.IndexOutOfBoundsException e) { 144cdf0e10cSrcweir log.println ("Exception occured while creating test Object."); 145cdf0e10cSrcweir e.printStackTrace(log); 146cdf0e10cSrcweir throw new StatusException("Couldn't create test object", e); 147cdf0e10cSrcweir } catch(com.sun.star.lang.IllegalArgumentException e) { 148cdf0e10cSrcweir log.println ("Exception occured while creating test Object."); 149cdf0e10cSrcweir e.printStackTrace(log); 150cdf0e10cSrcweir throw new StatusException("Couldn't create test object", e); 151cdf0e10cSrcweir } 152cdf0e10cSrcweir 153cdf0e10cSrcweir XCellRangesQuery oCellRangesQuery = (XCellRangesQuery) 154cdf0e10cSrcweir UnoRuntime.queryInterface(XCellRangesQuery.class, oSheet); 155cdf0e10cSrcweir XSheetCellRanges oSheetCellRanges = oCellRangesQuery.queryVisibleCells(); 156cdf0e10cSrcweir oEnum = (XEnumerationAccess) oSheetCellRanges.getCells(); 157cdf0e10cSrcweir oObj = oSheetCellRanges.getCells().createEnumeration(); 158cdf0e10cSrcweir 159cdf0e10cSrcweir TestEnvironment tEnv = new TestEnvironment(oObj); 160cdf0e10cSrcweir 161cdf0e10cSrcweir // ENUM: XEnumeration 162cdf0e10cSrcweir tEnv.addObjRelation("ENUM", oEnum); 163cdf0e10cSrcweir 164cdf0e10cSrcweir return tEnv; 165cdf0e10cSrcweir } 166cdf0e10cSrcweir 167cdf0e10cSrcweir } // finish class ScCellsEnumeration 168cdf0e10cSrcweir 169