1 /************************************************************************* 2 * 3 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. 4 * 5 * Copyright 2000, 2010 Oracle and/or its affiliates. 6 * 7 * OpenOffice.org - a multi-platform office productivity suite 8 * 9 * This file is part of OpenOffice.org. 10 * 11 * OpenOffice.org is free software: you can redistribute it and/or modify 12 * it under the terms of the GNU Lesser General Public License version 3 13 * only, as published by the Free Software Foundation. 14 * 15 * OpenOffice.org is distributed in the hope that it will be useful, 16 * but WITHOUT ANY WARRANTY; without even the implied warranty of 17 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the 18 * GNU Lesser General Public License version 3 for more details 19 * (a copy is included in the LICENSE file that accompanied this code). 20 * 21 * You should have received a copy of the GNU Lesser General Public License 22 * version 3 along with OpenOffice.org. If not, see 23 * <http://www.openoffice.org/license.html> 24 * for a copy of the LGPLv3 License. 25 * 26 ************************************************************************/ 27 28 package mod._sc; 29 30 import java.io.PrintWriter; 31 32 import lib.StatusException; 33 import lib.TestCase; 34 import lib.TestEnvironment; 35 import lib.TestParameters; 36 import util.SOfficeFactory; 37 38 import com.sun.star.beans.XPropertySet; 39 import com.sun.star.container.XEnumerationAccess; 40 import com.sun.star.container.XIndexAccess; 41 import com.sun.star.lang.XComponent; 42 import com.sun.star.lang.XMultiServiceFactory; 43 import com.sun.star.sheet.XSheetLinkable; 44 import com.sun.star.sheet.XSpreadsheet; 45 import com.sun.star.sheet.XSpreadsheetDocument; 46 import com.sun.star.sheet.XSpreadsheets; 47 import com.sun.star.uno.AnyConverter; 48 import com.sun.star.uno.Type; 49 import com.sun.star.uno.UnoRuntime; 50 import com.sun.star.uno.XInterface; 51 52 public class ScIndexEnumeration_SheetLinksEnumeration extends TestCase { 53 static XSpreadsheetDocument xSheetDoc = null; 54 55 /** 56 * Creates Spreadsheet document. 57 */ 58 protected void initialize( TestParameters tParam, PrintWriter log ) { 59 SOfficeFactory SOF = SOfficeFactory.getFactory( (XMultiServiceFactory)tParam.getMSF() ); 60 61 try { 62 log.println( "creating a Spreadsheet document" ); 63 xSheetDoc = SOF.createCalcDoc(null); 64 } catch ( com.sun.star.uno.Exception e ) { 65 // Some exception occures.FAILED 66 e.printStackTrace( log ); 67 throw new StatusException( "Couldn't create document", e ); 68 } 69 } 70 71 /** 72 * Disposes Spreadsheet document. 73 */ 74 protected void cleanup( TestParameters tParam, PrintWriter log ) { 75 log.println( " disposing xSheetDoc " ); 76 XComponent oComp = (XComponent) 77 UnoRuntime.queryInterface(XComponent.class, xSheetDoc) ; 78 util.DesktopTools.closeDoc(oComp); 79 } 80 81 protected synchronized TestEnvironment createTestEnvironment(TestParameters Param, PrintWriter log) { 82 83 XInterface oObj = null; 84 85 // creation of testobject here 86 // first we write what we are intend to do to log file 87 log.println( "Creating a test environment" ); 88 XSpreadsheet oSheet = null; 89 90 log.println("Getting test object ") ; 91 XSpreadsheets oSheets = xSheetDoc.getSheets() ; 92 XIndexAccess oIndexAccess = (XIndexAccess) 93 UnoRuntime.queryInterface(XIndexAccess.class, oSheets); 94 try { 95 oSheet = (XSpreadsheet) AnyConverter.toObject( 96 new Type(XSpreadsheet.class),oIndexAccess.getByIndex(0)); 97 } catch (com.sun.star.lang.WrappedTargetException e) { 98 e.printStackTrace(log); 99 throw new StatusException( "Couldn't get a spreadsheet", e); 100 } catch (com.sun.star.lang.IndexOutOfBoundsException e) { 101 e.printStackTrace(log); 102 throw new StatusException( "Couldn't get a spreadsheet", e); 103 } catch (com.sun.star.lang.IllegalArgumentException e) { 104 e.printStackTrace(log); 105 throw new StatusException( "Couldn't get a spreadsheet", e); 106 } 107 108 XSheetLinkable SL = (XSheetLinkable) 109 UnoRuntime.queryInterface(XSheetLinkable.class, oSheet); 110 111 // creating link. 112 String aSourceArea = util.utils.getFullTestURL("calcshapes.sxc"); 113 SL.link(aSourceArea, "Sheet1", "", "", 114 com.sun.star.sheet.SheetLinkMode.VALUE); 115 116 // Getting links. 117 XPropertySet docProps = (XPropertySet) 118 UnoRuntime.queryInterface(XPropertySet.class, xSheetDoc); 119 120 Object links = null; 121 try { 122 links = docProps.getPropertyValue("SheetLinks"); 123 } catch(com.sun.star.lang.WrappedTargetException e){ 124 e.printStackTrace(log); 125 throw new StatusException("Couldn't get SheetLinks", e); 126 } catch(com.sun.star.beans.UnknownPropertyException e){ 127 e.printStackTrace(log); 128 throw new StatusException("Couldn't get SheetLinks", e); 129 } 130 131 oObj = (XInterface)UnoRuntime.queryInterface(XInterface.class, links); 132 133 XEnumerationAccess ea = (XEnumerationAccess) 134 UnoRuntime.queryInterface(XEnumerationAccess.class,oObj); 135 136 oObj = ea.createEnumeration(); 137 138 log.println("ImplementationName: "+util.utils.getImplName(oObj)); 139 // creating test environment 140 TestEnvironment tEnv = new TestEnvironment( oObj ); 141 142 tEnv.addObjRelation("ENUM",ea); 143 144 return tEnv; 145 } 146 147 } 148 149