1*cdf0e10cSrcweir /************************************************************************* 2*cdf0e10cSrcweir * 3*cdf0e10cSrcweir * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. 4*cdf0e10cSrcweir * 5*cdf0e10cSrcweir * Copyright 2000, 2010 Oracle and/or its affiliates. 6*cdf0e10cSrcweir * 7*cdf0e10cSrcweir * OpenOffice.org - a multi-platform office productivity suite 8*cdf0e10cSrcweir * 9*cdf0e10cSrcweir * This file is part of OpenOffice.org. 10*cdf0e10cSrcweir * 11*cdf0e10cSrcweir * OpenOffice.org is free software: you can redistribute it and/or modify 12*cdf0e10cSrcweir * it under the terms of the GNU Lesser General Public License version 3 13*cdf0e10cSrcweir * only, as published by the Free Software Foundation. 14*cdf0e10cSrcweir * 15*cdf0e10cSrcweir * OpenOffice.org is distributed in the hope that it will be useful, 16*cdf0e10cSrcweir * but WITHOUT ANY WARRANTY; without even the implied warranty of 17*cdf0e10cSrcweir * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the 18*cdf0e10cSrcweir * GNU Lesser General Public License version 3 for more details 19*cdf0e10cSrcweir * (a copy is included in the LICENSE file that accompanied this code). 20*cdf0e10cSrcweir * 21*cdf0e10cSrcweir * You should have received a copy of the GNU Lesser General Public License 22*cdf0e10cSrcweir * version 3 along with OpenOffice.org. If not, see 23*cdf0e10cSrcweir * <http://www.openoffice.org/license.html> 24*cdf0e10cSrcweir * for a copy of the LGPLv3 License. 25*cdf0e10cSrcweir * 26*cdf0e10cSrcweir ************************************************************************/ 27*cdf0e10cSrcweir package mod._sc; 28*cdf0e10cSrcweir 29*cdf0e10cSrcweir import java.io.PrintWriter; 30*cdf0e10cSrcweir 31*cdf0e10cSrcweir import lib.StatusException; 32*cdf0e10cSrcweir import lib.TestCase; 33*cdf0e10cSrcweir import lib.TestEnvironment; 34*cdf0e10cSrcweir import lib.TestParameters; 35*cdf0e10cSrcweir import util.SOfficeFactory; 36*cdf0e10cSrcweir 37*cdf0e10cSrcweir import com.sun.star.beans.XPropertySet; 38*cdf0e10cSrcweir import com.sun.star.container.XIndexAccess; 39*cdf0e10cSrcweir import com.sun.star.container.XNameAccess; 40*cdf0e10cSrcweir import com.sun.star.lang.XComponent; 41*cdf0e10cSrcweir import com.sun.star.lang.XMultiServiceFactory; 42*cdf0e10cSrcweir import com.sun.star.sheet.XSpreadsheet; 43*cdf0e10cSrcweir import com.sun.star.sheet.XSpreadsheetDocument; 44*cdf0e10cSrcweir import com.sun.star.sheet.XSpreadsheets; 45*cdf0e10cSrcweir import com.sun.star.uno.AnyConverter; 46*cdf0e10cSrcweir import com.sun.star.uno.Type; 47*cdf0e10cSrcweir import com.sun.star.uno.UnoRuntime; 48*cdf0e10cSrcweir import com.sun.star.uno.XInterface; 49*cdf0e10cSrcweir 50*cdf0e10cSrcweir /** 51*cdf0e10cSrcweir * Test for object which is represented by service 52*cdf0e10cSrcweir * <code>com.sun.star.sheet.DDELink</code>. <p> 53*cdf0e10cSrcweir * Object implements the following interfaces : 54*cdf0e10cSrcweir * <ul> 55*cdf0e10cSrcweir * <li> <code>com::sun::star::container::XNamed</code></li> 56*cdf0e10cSrcweir * <li> <code>com::sun::star::util::XRefreshable</code></li> 57*cdf0e10cSrcweir * <li> <code>com::sun::star::sheet::XDDELink</code></li> 58*cdf0e10cSrcweir * </ul> 59*cdf0e10cSrcweir * The following files used by this test : 60*cdf0e10cSrcweir * <ul> 61*cdf0e10cSrcweir * <li><b> ScDDELinksObj.sdc </b> : the predefined testdocument </li> 62*cdf0e10cSrcweir * </ul> <p> 63*cdf0e10cSrcweir * @see com.sun.star.sheet.DDELink 64*cdf0e10cSrcweir * @see com.sun.star.container.XNamed 65*cdf0e10cSrcweir * @see com.sun.star.util.XRefreshable 66*cdf0e10cSrcweir * @see com.sun.star.sheet.XDDELink 67*cdf0e10cSrcweir * @see ifc.container._XNamed 68*cdf0e10cSrcweir * @see ifc.util._XRefreshable 69*cdf0e10cSrcweir * @see ifc.sheet._XDDELink 70*cdf0e10cSrcweir */ 71*cdf0e10cSrcweir public class ScDDELinkObj extends TestCase { 72*cdf0e10cSrcweir static XSpreadsheetDocument xSheetDoc = null; 73*cdf0e10cSrcweir static XComponent oDoc = null; 74*cdf0e10cSrcweir 75*cdf0e10cSrcweir /** 76*cdf0e10cSrcweir * Creates Spreadsheet document. 77*cdf0e10cSrcweir */ 78*cdf0e10cSrcweir protected void initialize( TestParameters tParam, PrintWriter log ) { 79*cdf0e10cSrcweir SOfficeFactory SOF = SOfficeFactory.getFactory( (XMultiServiceFactory)tParam.getMSF() ); 80*cdf0e10cSrcweir 81*cdf0e10cSrcweir try { 82*cdf0e10cSrcweir log.println( "creating a Spreadsheet document" ); 83*cdf0e10cSrcweir xSheetDoc = SOF.createCalcDoc(null); 84*cdf0e10cSrcweir } catch ( com.sun.star.uno.Exception e ) { 85*cdf0e10cSrcweir // Some exception occures.FAILED 86*cdf0e10cSrcweir e.printStackTrace( log ); 87*cdf0e10cSrcweir throw new StatusException( "Couldn't create document", e ); 88*cdf0e10cSrcweir } 89*cdf0e10cSrcweir 90*cdf0e10cSrcweir } 91*cdf0e10cSrcweir 92*cdf0e10cSrcweir /** 93*cdf0e10cSrcweir * Disposes Spreadsheet document and testdocument if it was loaded already. 94*cdf0e10cSrcweir */ 95*cdf0e10cSrcweir protected void cleanup( TestParameters tParam, PrintWriter log ) { 96*cdf0e10cSrcweir log.println( " disposing xSheetDoc " ); 97*cdf0e10cSrcweir XComponent oComp = (XComponent) 98*cdf0e10cSrcweir UnoRuntime.queryInterface(XComponent.class, xSheetDoc) ; 99*cdf0e10cSrcweir util.DesktopTools.closeDoc(oComp); 100*cdf0e10cSrcweir if (oDoc != null) { 101*cdf0e10cSrcweir util.DesktopTools.closeDoc(oDoc); 102*cdf0e10cSrcweir } 103*cdf0e10cSrcweir } 104*cdf0e10cSrcweir 105*cdf0e10cSrcweir /** 106*cdf0e10cSrcweir * Creating a Testenvironment for the interfaces to be tested. 107*cdf0e10cSrcweir * Disposes the testdocument if it was loaded already. 108*cdf0e10cSrcweir * Creates an instance of the <code>com.sun.star.frame.Desktop</code> 109*cdf0e10cSrcweir * and loads the predefined testdocument. Retrieves a collection of 110*cdf0e10cSrcweir * spreadsheets from a document and takes one of them. Sets specific formula 111*cdf0e10cSrcweir * to some cells in the spreadsheet(the formula specify DDE links to the 112*cdf0e10cSrcweir * testdocument). Retrieves the collection of DDE links in the document and 113*cdf0e10cSrcweir * retrives first DDE link from the collection. 114*cdf0e10cSrcweir * The retrived DDE link is the instance of the service 115*cdf0e10cSrcweir * <code>com.sun.star.sheet.DDELink</code>. 116*cdf0e10cSrcweir * Object relations created : 117*cdf0e10cSrcweir * <ul> 118*cdf0e10cSrcweir * <li> <code>'setName'</code> for 119*cdf0e10cSrcweir * {@link ifc.container._XNamed}(specify that the method 120*cdf0e10cSrcweir * <code>setName</code> must not be tested)</li> 121*cdf0e10cSrcweir * <li> <code>'APPLICATION'</code> for 122*cdf0e10cSrcweir * {@link ifc.sheet._XDDELink}(the name of the current application)</li> 123*cdf0e10cSrcweir * <li> <code>'ITEM'</code> for 124*cdf0e10cSrcweir * {@link ifc.sheet._XDDELink}(the DDE item that was set in the formula)</li> 125*cdf0e10cSrcweir * <li> <code>'TOPIC'</code> for 126*cdf0e10cSrcweir * {@link ifc.sheet._XDDELink}(the full testdocument name)</li> 127*cdf0e10cSrcweir * </ul> 128*cdf0e10cSrcweir * @see com.sun.star.frame.Desktop 129*cdf0e10cSrcweir * @see com.sun.star.sheet.DDELink 130*cdf0e10cSrcweir */ 131*cdf0e10cSrcweir protected synchronized TestEnvironment createTestEnvironment(TestParameters Param, PrintWriter log) { 132*cdf0e10cSrcweir 133*cdf0e10cSrcweir XInterface oObj = null; 134*cdf0e10cSrcweir 135*cdf0e10cSrcweir if (oDoc != null) { 136*cdf0e10cSrcweir util.DesktopTools.closeDoc(oDoc); 137*cdf0e10cSrcweir } 138*cdf0e10cSrcweir 139*cdf0e10cSrcweir // creation of testobject here 140*cdf0e10cSrcweir // first we write what we are intend to do to log file 141*cdf0e10cSrcweir log.println( "Creating a test environment" ); 142*cdf0e10cSrcweir 143*cdf0e10cSrcweir // create testobject here 144*cdf0e10cSrcweir 145*cdf0e10cSrcweir XMultiServiceFactory oMSF = (XMultiServiceFactory)Param.getMSF(); 146*cdf0e10cSrcweir 147*cdf0e10cSrcweir // load the predefined testdocument 148*cdf0e10cSrcweir String testdoc = util.utils.getFullTestURL("ScDDELinksObj.sdc"); 149*cdf0e10cSrcweir try { 150*cdf0e10cSrcweir oDoc = SOfficeFactory.getFactory(oMSF).loadDocument(testdoc); 151*cdf0e10cSrcweir } catch (com.sun.star.lang.IllegalArgumentException e) { 152*cdf0e10cSrcweir e.printStackTrace(log); 153*cdf0e10cSrcweir throw new StatusException("Can't load test document", e); 154*cdf0e10cSrcweir } catch (com.sun.star.io.IOException e) { 155*cdf0e10cSrcweir e.printStackTrace(log); 156*cdf0e10cSrcweir throw new StatusException("Can't load test document", e); 157*cdf0e10cSrcweir } catch (com.sun.star.uno.Exception e) { 158*cdf0e10cSrcweir e.printStackTrace(log); 159*cdf0e10cSrcweir throw new StatusException("Can't load test document", e); 160*cdf0e10cSrcweir } 161*cdf0e10cSrcweir 162*cdf0e10cSrcweir log.println("getting sheets"); 163*cdf0e10cSrcweir XSpreadsheets xSpreadsheets = (XSpreadsheets)xSheetDoc.getSheets(); 164*cdf0e10cSrcweir 165*cdf0e10cSrcweir log.println("getting a sheet"); 166*cdf0e10cSrcweir XSpreadsheet oSheet = null; 167*cdf0e10cSrcweir XIndexAccess oIndexAccess = (XIndexAccess) 168*cdf0e10cSrcweir UnoRuntime.queryInterface(XIndexAccess.class, xSpreadsheets); 169*cdf0e10cSrcweir try { 170*cdf0e10cSrcweir oSheet = (XSpreadsheet) AnyConverter.toObject( 171*cdf0e10cSrcweir new Type(XSpreadsheet.class),oIndexAccess.getByIndex(0)); 172*cdf0e10cSrcweir } catch (com.sun.star.lang.WrappedTargetException e) { 173*cdf0e10cSrcweir e.printStackTrace(log); 174*cdf0e10cSrcweir throw new StatusException("Couldn't get a spreadsheet", e); 175*cdf0e10cSrcweir } catch (com.sun.star.lang.IndexOutOfBoundsException e) { 176*cdf0e10cSrcweir e.printStackTrace(log); 177*cdf0e10cSrcweir throw new StatusException("Couldn't get a spreadsheet", e); 178*cdf0e10cSrcweir } catch (com.sun.star.lang.IllegalArgumentException e) { 179*cdf0e10cSrcweir e.printStackTrace(log); 180*cdf0e10cSrcweir throw new StatusException("Couldn't get a spreadsheet", e); 181*cdf0e10cSrcweir } 182*cdf0e10cSrcweir 183*cdf0e10cSrcweir log.println("filling some cells"); 184*cdf0e10cSrcweir String sAppl = "soffice"; 185*cdf0e10cSrcweir String sItem = "Sheet1.A1"; 186*cdf0e10cSrcweir testdoc = util.utils.getFullTestDocName("ScDDELinksObj.sdc"); 187*cdf0e10cSrcweir try { 188*cdf0e10cSrcweir oSheet.getCellByPosition(5, 5).setFormula( 189*cdf0e10cSrcweir "=DDE(\""+ sAppl +"\";\""+testdoc+"\";\""+ sItem +"\""); 190*cdf0e10cSrcweir oSheet.getCellByPosition(1, 4).setFormula( 191*cdf0e10cSrcweir "=DDE(\""+ sAppl +"\";\""+testdoc+"\";\""+ sItem +"\""); 192*cdf0e10cSrcweir } catch (com.sun.star.lang.IndexOutOfBoundsException e) { 193*cdf0e10cSrcweir e.printStackTrace(log); 194*cdf0e10cSrcweir throw new StatusException( 195*cdf0e10cSrcweir "Exception occurred while filling cells", e); 196*cdf0e10cSrcweir } 197*cdf0e10cSrcweir 198*cdf0e10cSrcweir try { 199*cdf0e10cSrcweir log.println("Getting test object ") ; 200*cdf0e10cSrcweir 201*cdf0e10cSrcweir // Getting named ranges. 202*cdf0e10cSrcweir XPropertySet docProps = (XPropertySet) 203*cdf0e10cSrcweir UnoRuntime.queryInterface(XPropertySet.class, xSheetDoc); 204*cdf0e10cSrcweir XNameAccess links = (XNameAccess) AnyConverter.toObject( 205*cdf0e10cSrcweir new Type(XNameAccess.class), UnoRuntime.queryInterface( 206*cdf0e10cSrcweir XNameAccess.class, docProps.getPropertyValue("DDELinks"))); 207*cdf0e10cSrcweir 208*cdf0e10cSrcweir String[] linkNames = links.getElementNames(); 209*cdf0e10cSrcweir 210*cdf0e10cSrcweir oObj = (XInterface) AnyConverter.toObject( 211*cdf0e10cSrcweir new Type(XInterface.class),links.getByName(linkNames[0])); 212*cdf0e10cSrcweir log.println("Creating object - " + 213*cdf0e10cSrcweir ((oObj == null) ? "FAILED" : "OK")); 214*cdf0e10cSrcweir } catch (com.sun.star.lang.WrappedTargetException e) { 215*cdf0e10cSrcweir e.printStackTrace(log) ; 216*cdf0e10cSrcweir throw new StatusException( 217*cdf0e10cSrcweir "Error getting test object from spreadsheet document", e) ; 218*cdf0e10cSrcweir } catch (com.sun.star.beans.UnknownPropertyException e) { 219*cdf0e10cSrcweir e.printStackTrace(log) ; 220*cdf0e10cSrcweir throw new StatusException( 221*cdf0e10cSrcweir "Error getting test object from spreadsheet document", e) ; 222*cdf0e10cSrcweir } catch (com.sun.star.container.NoSuchElementException e) { 223*cdf0e10cSrcweir e.printStackTrace(log) ; 224*cdf0e10cSrcweir throw new StatusException( 225*cdf0e10cSrcweir "Error getting test object from spreadsheet document", e) ; 226*cdf0e10cSrcweir } catch (com.sun.star.lang.IllegalArgumentException e) { 227*cdf0e10cSrcweir e.printStackTrace(log) ; 228*cdf0e10cSrcweir throw new StatusException( 229*cdf0e10cSrcweir "Error getting test object from spreadsheet document", e) ; 230*cdf0e10cSrcweir } 231*cdf0e10cSrcweir 232*cdf0e10cSrcweir TestEnvironment tEnv = new TestEnvironment( oObj ); 233*cdf0e10cSrcweir 234*cdf0e10cSrcweir // Other parameters required for interface tests 235*cdf0e10cSrcweir tEnv.addObjRelation("APPLICATION", sAppl); 236*cdf0e10cSrcweir tEnv.addObjRelation("ITEM", sItem); 237*cdf0e10cSrcweir tEnv.addObjRelation("TOPIC", testdoc); 238*cdf0e10cSrcweir tEnv.addObjRelation("setName", new Boolean(true)); 239*cdf0e10cSrcweir 240*cdf0e10cSrcweir return tEnv; 241*cdf0e10cSrcweir } 242*cdf0e10cSrcweir 243*cdf0e10cSrcweir } 244*cdf0e10cSrcweir 245*cdf0e10cSrcweir 246