1*b1cdbd2cSJim Jagielski /************************************************************** 2*b1cdbd2cSJim Jagielski * 3*b1cdbd2cSJim Jagielski * Licensed to the Apache Software Foundation (ASF) under one 4*b1cdbd2cSJim Jagielski * or more contributor license agreements. See the NOTICE file 5*b1cdbd2cSJim Jagielski * distributed with this work for additional information 6*b1cdbd2cSJim Jagielski * regarding copyright ownership. The ASF licenses this file 7*b1cdbd2cSJim Jagielski * to you under the Apache License, Version 2.0 (the 8*b1cdbd2cSJim Jagielski * "License"); you may not use this file except in compliance 9*b1cdbd2cSJim Jagielski * with the License. You may obtain a copy of the License at 10*b1cdbd2cSJim Jagielski * 11*b1cdbd2cSJim Jagielski * http://www.apache.org/licenses/LICENSE-2.0 12*b1cdbd2cSJim Jagielski * 13*b1cdbd2cSJim Jagielski * Unless required by applicable law or agreed to in writing, 14*b1cdbd2cSJim Jagielski * software distributed under the License is distributed on an 15*b1cdbd2cSJim Jagielski * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 16*b1cdbd2cSJim Jagielski * KIND, either express or implied. See the License for the 17*b1cdbd2cSJim Jagielski * specific language governing permissions and limitations 18*b1cdbd2cSJim Jagielski * under the License. 19*b1cdbd2cSJim Jagielski * 20*b1cdbd2cSJim Jagielski *************************************************************/ 21*b1cdbd2cSJim Jagielski 22*b1cdbd2cSJim Jagielski 23*b1cdbd2cSJim Jagielski 24*b1cdbd2cSJim Jagielski package mod._sc; 25*b1cdbd2cSJim Jagielski 26*b1cdbd2cSJim Jagielski import java.io.PrintWriter; 27*b1cdbd2cSJim Jagielski import java.util.Vector; 28*b1cdbd2cSJim Jagielski 29*b1cdbd2cSJim Jagielski import lib.StatusException; 30*b1cdbd2cSJim Jagielski import lib.TestCase; 31*b1cdbd2cSJim Jagielski import lib.TestEnvironment; 32*b1cdbd2cSJim Jagielski import lib.TestParameters; 33*b1cdbd2cSJim Jagielski import util.SOfficeFactory; 34*b1cdbd2cSJim Jagielski 35*b1cdbd2cSJim Jagielski import com.sun.star.beans.Property; 36*b1cdbd2cSJim Jagielski import com.sun.star.beans.PropertyAttribute; 37*b1cdbd2cSJim Jagielski import com.sun.star.beans.XPropertySet; 38*b1cdbd2cSJim Jagielski import com.sun.star.container.XIndexAccess; 39*b1cdbd2cSJim Jagielski import com.sun.star.container.XNameAccess; 40*b1cdbd2cSJim Jagielski import com.sun.star.container.XNameContainer; 41*b1cdbd2cSJim Jagielski import com.sun.star.lang.XComponent; 42*b1cdbd2cSJim Jagielski import com.sun.star.lang.XMultiServiceFactory; 43*b1cdbd2cSJim Jagielski import com.sun.star.sheet.XSpreadsheet; 44*b1cdbd2cSJim Jagielski import com.sun.star.sheet.XSpreadsheetDocument; 45*b1cdbd2cSJim Jagielski import com.sun.star.sheet.XSpreadsheets; 46*b1cdbd2cSJim Jagielski import com.sun.star.style.XStyle; 47*b1cdbd2cSJim Jagielski import com.sun.star.style.XStyleFamiliesSupplier; 48*b1cdbd2cSJim Jagielski import com.sun.star.table.XCell; 49*b1cdbd2cSJim Jagielski import com.sun.star.uno.AnyConverter; 50*b1cdbd2cSJim Jagielski import com.sun.star.uno.Type; 51*b1cdbd2cSJim Jagielski import com.sun.star.uno.UnoRuntime; 52*b1cdbd2cSJim Jagielski import com.sun.star.uno.XInterface; 53*b1cdbd2cSJim Jagielski 54*b1cdbd2cSJim Jagielski /** 55*b1cdbd2cSJim Jagielski * Test for object which is represented by service 56*b1cdbd2cSJim Jagielski * <code>com.sun.star.style.Style</code>. <p> 57*b1cdbd2cSJim Jagielski * Object implements the following interfaces : 58*b1cdbd2cSJim Jagielski * <ul> 59*b1cdbd2cSJim Jagielski * <li> <code>com::sun::star::container::XNamed</code></li> 60*b1cdbd2cSJim Jagielski * <li> <code>com::sun::star::style::Style</code></li> 61*b1cdbd2cSJim Jagielski * <li> <code>com::sun::star::style::XStyle</code></li> 62*b1cdbd2cSJim Jagielski * </ul> 63*b1cdbd2cSJim Jagielski * @see com.sun.star.style.Style 64*b1cdbd2cSJim Jagielski * @see com.sun.star.container.XNamed 65*b1cdbd2cSJim Jagielski * @see com.sun.star.style.Style 66*b1cdbd2cSJim Jagielski * @see com.sun.star.style.XStyle 67*b1cdbd2cSJim Jagielski * @see ifc.container._XNamed 68*b1cdbd2cSJim Jagielski * @see ifc.style._Style 69*b1cdbd2cSJim Jagielski * @see ifc.style._XStyle 70*b1cdbd2cSJim Jagielski */ 71*b1cdbd2cSJim Jagielski public class ScStyleObj extends TestCase { 72*b1cdbd2cSJim Jagielski static XSpreadsheetDocument xSpreadsheetDoc = null; 73*b1cdbd2cSJim Jagielski 74*b1cdbd2cSJim Jagielski /** 75*b1cdbd2cSJim Jagielski * Creates Spreadsheet document. 76*b1cdbd2cSJim Jagielski */ initialize( TestParameters tParam, PrintWriter log )77*b1cdbd2cSJim Jagielski protected void initialize( TestParameters tParam, PrintWriter log ) { 78*b1cdbd2cSJim Jagielski SOfficeFactory SOF = SOfficeFactory.getFactory( (XMultiServiceFactory)tParam.getMSF() ); 79*b1cdbd2cSJim Jagielski 80*b1cdbd2cSJim Jagielski try { 81*b1cdbd2cSJim Jagielski log.println( "creating a Spreadsheet document" ); 82*b1cdbd2cSJim Jagielski xSpreadsheetDoc = SOF.createCalcDoc(null); 83*b1cdbd2cSJim Jagielski } catch ( com.sun.star.uno.Exception e ) { 84*b1cdbd2cSJim Jagielski // Some exception occures.FAILED 85*b1cdbd2cSJim Jagielski e.printStackTrace( log ); 86*b1cdbd2cSJim Jagielski throw new StatusException( "Couldn't create document", e ); 87*b1cdbd2cSJim Jagielski } 88*b1cdbd2cSJim Jagielski } 89*b1cdbd2cSJim Jagielski 90*b1cdbd2cSJim Jagielski /** 91*b1cdbd2cSJim Jagielski * Disposes Spreadsheet document. 92*b1cdbd2cSJim Jagielski */ cleanup( TestParameters tParam, PrintWriter log )93*b1cdbd2cSJim Jagielski protected void cleanup( TestParameters tParam, PrintWriter log ) { 94*b1cdbd2cSJim Jagielski log.println( " disposing xSheetDoc " ); 95*b1cdbd2cSJim Jagielski XComponent oComp = (XComponent) 96*b1cdbd2cSJim Jagielski UnoRuntime.queryInterface(XComponent.class, xSpreadsheetDoc); 97*b1cdbd2cSJim Jagielski util.DesktopTools.closeDoc(oComp); 98*b1cdbd2cSJim Jagielski } 99*b1cdbd2cSJim Jagielski 100*b1cdbd2cSJim Jagielski /** 101*b1cdbd2cSJim Jagielski * Creating a Testenvironment for the interfaces to be tested. 102*b1cdbd2cSJim Jagielski * Retrieves the collection of style families from the document 103*b1cdbd2cSJim Jagielski * using the interface <code>XStyleFamiliesSupplier</code>. 104*b1cdbd2cSJim Jagielski * Obtains style family with index 0 from the collection and obtains 105*b1cdbd2cSJim Jagielski * style with index 0 from this style family. Creates the instance of the 106*b1cdbd2cSJim Jagielski * service <code>com.sun.star.style.CellStyle</code>. Inserts the created 107*b1cdbd2cSJim Jagielski * style to the obtained style family. Retrieves a collection of spreadsheets 108*b1cdbd2cSJim Jagielski * from the document and takes one of them. Gets a cell from the spreadsheet 109*b1cdbd2cSJim Jagielski * and sets the value of property <code>'CellStyle'</code> to the created 110*b1cdbd2cSJim Jagielski * style. The created style is the instance of the service 111*b1cdbd2cSJim Jagielski * <code>com.sun.star.style.Style</code> also. 112*b1cdbd2cSJim Jagielski * Object relations created : 113*b1cdbd2cSJim Jagielski * <ul> 114*b1cdbd2cSJim Jagielski * <li> <code>'PoolStyle'</code> for 115*b1cdbd2cSJim Jagielski * {@link ifc.style._XStyle}(the style with index 0 that was obtained 116*b1cdbd2cSJim Jagielski * from the collection)</li> 117*b1cdbd2cSJim Jagielski * </ul> 118*b1cdbd2cSJim Jagielski * @see com.sun.star.style.CellStyle 119*b1cdbd2cSJim Jagielski * @see com.sun.star.style.Style 120*b1cdbd2cSJim Jagielski * @see com.sun.star.style.XStyleFamiliesSupplier 121*b1cdbd2cSJim Jagielski */ createTestEnvironment(TestParameters Param, PrintWriter log)122*b1cdbd2cSJim Jagielski protected TestEnvironment createTestEnvironment(TestParameters Param, PrintWriter log) { 123*b1cdbd2cSJim Jagielski 124*b1cdbd2cSJim Jagielski 125*b1cdbd2cSJim Jagielski // creation of the testobject here 126*b1cdbd2cSJim Jagielski // first we write what we are intend to do to log file 127*b1cdbd2cSJim Jagielski 128*b1cdbd2cSJim Jagielski log.println("creating a test environment"); 129*b1cdbd2cSJim Jagielski 130*b1cdbd2cSJim Jagielski log.println("getting style"); 131*b1cdbd2cSJim Jagielski XStyleFamiliesSupplier oStyleFamiliesSupplier = (XStyleFamiliesSupplier) 132*b1cdbd2cSJim Jagielski UnoRuntime.queryInterface( 133*b1cdbd2cSJim Jagielski XStyleFamiliesSupplier.class, xSpreadsheetDoc); 134*b1cdbd2cSJim Jagielski XNameAccess oStyleFamilies = oStyleFamiliesSupplier.getStyleFamilies(); 135*b1cdbd2cSJim Jagielski XIndexAccess oStyleFamiliesIndexAccess = (XIndexAccess) 136*b1cdbd2cSJim Jagielski UnoRuntime.queryInterface(XIndexAccess.class, oStyleFamilies); 137*b1cdbd2cSJim Jagielski XNameAccess oStyleFamilyNameAccess = null; 138*b1cdbd2cSJim Jagielski XStyle oStyle = null; 139*b1cdbd2cSJim Jagielski try { 140*b1cdbd2cSJim Jagielski oStyleFamilyNameAccess = (XNameAccess) AnyConverter.toObject( 141*b1cdbd2cSJim Jagielski new Type(XNameAccess.class), 142*b1cdbd2cSJim Jagielski oStyleFamiliesIndexAccess.getByIndex(0)); 143*b1cdbd2cSJim Jagielski 144*b1cdbd2cSJim Jagielski XIndexAccess oStyleFamilyIndexAccess = (XIndexAccess) 145*b1cdbd2cSJim Jagielski UnoRuntime.queryInterface(XIndexAccess.class, 146*b1cdbd2cSJim Jagielski oStyleFamilyNameAccess); 147*b1cdbd2cSJim Jagielski oStyle = (XStyle) AnyConverter.toObject( 148*b1cdbd2cSJim Jagielski new Type(XStyle.class),oStyleFamilyIndexAccess.getByIndex(0)); 149*b1cdbd2cSJim Jagielski } catch(com.sun.star.lang.WrappedTargetException e) { 150*b1cdbd2cSJim Jagielski e.printStackTrace(log); 151*b1cdbd2cSJim Jagielski throw new StatusException("Couldn't get by index", e); 152*b1cdbd2cSJim Jagielski } catch(com.sun.star.lang.IndexOutOfBoundsException e) { 153*b1cdbd2cSJim Jagielski e.printStackTrace(log); 154*b1cdbd2cSJim Jagielski throw new StatusException("Couldn't get by index", e); 155*b1cdbd2cSJim Jagielski } catch(com.sun.star.lang.IllegalArgumentException e) { 156*b1cdbd2cSJim Jagielski e.printStackTrace(log); 157*b1cdbd2cSJim Jagielski throw new StatusException("Couldn't get by index", e); 158*b1cdbd2cSJim Jagielski } 159*b1cdbd2cSJim Jagielski 160*b1cdbd2cSJim Jagielski log.println("Creating a user-defined style"); 161*b1cdbd2cSJim Jagielski XMultiServiceFactory oMSF = (XMultiServiceFactory) 162*b1cdbd2cSJim Jagielski UnoRuntime.queryInterface( 163*b1cdbd2cSJim Jagielski XMultiServiceFactory.class, xSpreadsheetDoc); 164*b1cdbd2cSJim Jagielski 165*b1cdbd2cSJim Jagielski XInterface oInt = null; 166*b1cdbd2cSJim Jagielski try { 167*b1cdbd2cSJim Jagielski oInt = (XInterface) 168*b1cdbd2cSJim Jagielski oMSF.createInstance("com.sun.star.style.CellStyle"); 169*b1cdbd2cSJim Jagielski } catch(com.sun.star.uno.Exception e) { 170*b1cdbd2cSJim Jagielski e.printStackTrace(log); 171*b1cdbd2cSJim Jagielski throw new StatusException("Couldn't create instance", e); 172*b1cdbd2cSJim Jagielski } 173*b1cdbd2cSJim Jagielski XStyle oMyStyle = (XStyle)UnoRuntime.queryInterface(XStyle.class, oInt); 174*b1cdbd2cSJim Jagielski 175*b1cdbd2cSJim Jagielski XNameContainer oStyleFamilyNameContainer = (XNameContainer)UnoRuntime. 176*b1cdbd2cSJim Jagielski queryInterface(XNameContainer.class, oStyleFamilyNameAccess); 177*b1cdbd2cSJim Jagielski 178*b1cdbd2cSJim Jagielski try { 179*b1cdbd2cSJim Jagielski if (oStyleFamilyNameContainer.hasByName("My Style")) { 180*b1cdbd2cSJim Jagielski oStyleFamilyNameContainer.removeByName("My Style"); 181*b1cdbd2cSJim Jagielski } 182*b1cdbd2cSJim Jagielski 183*b1cdbd2cSJim Jagielski oStyleFamilyNameContainer.insertByName("My Style", oMyStyle); 184*b1cdbd2cSJim Jagielski } catch(com.sun.star.lang.WrappedTargetException e) { 185*b1cdbd2cSJim Jagielski e.printStackTrace(log); 186*b1cdbd2cSJim Jagielski throw new StatusException("Couldn't create test environment", e); 187*b1cdbd2cSJim Jagielski } catch(com.sun.star.container.NoSuchElementException e) { 188*b1cdbd2cSJim Jagielski e.printStackTrace(log); 189*b1cdbd2cSJim Jagielski throw new StatusException("Couldn't create test environment", e); 190*b1cdbd2cSJim Jagielski } catch(com.sun.star.container.ElementExistException e) { 191*b1cdbd2cSJim Jagielski e.printStackTrace(log); 192*b1cdbd2cSJim Jagielski throw new StatusException("Couldn't create test environment", e); 193*b1cdbd2cSJim Jagielski } catch(com.sun.star.lang.IllegalArgumentException e) { 194*b1cdbd2cSJim Jagielski e.printStackTrace(log); 195*b1cdbd2cSJim Jagielski throw new StatusException("Couldn't create test environment", e); 196*b1cdbd2cSJim Jagielski } 197*b1cdbd2cSJim Jagielski 198*b1cdbd2cSJim Jagielski 199*b1cdbd2cSJim Jagielski //using the style 200*b1cdbd2cSJim Jagielski log.println("Getting spreadsheet") ; 201*b1cdbd2cSJim Jagielski XSpreadsheets oSheets = xSpreadsheetDoc.getSheets() ; 202*b1cdbd2cSJim Jagielski XIndexAccess oIndexSheets = (XIndexAccess) 203*b1cdbd2cSJim Jagielski UnoRuntime.queryInterface(XIndexAccess.class, oSheets); 204*b1cdbd2cSJim Jagielski 205*b1cdbd2cSJim Jagielski XCell aCell = null; 206*b1cdbd2cSJim Jagielski try { 207*b1cdbd2cSJim Jagielski XSpreadsheet oSheet = (XSpreadsheet) AnyConverter.toObject( 208*b1cdbd2cSJim Jagielski new Type(XSpreadsheet.class),oIndexSheets.getByIndex(0)); 209*b1cdbd2cSJim Jagielski log.println("Getting a cell from sheet") ; 210*b1cdbd2cSJim Jagielski aCell = oSheet.getCellByPosition(2,3) ; 211*b1cdbd2cSJim Jagielski } catch(com.sun.star.lang.WrappedTargetException e) { 212*b1cdbd2cSJim Jagielski e.printStackTrace(log); 213*b1cdbd2cSJim Jagielski throw new StatusException("Couldn't get spreadsheet by index", e); 214*b1cdbd2cSJim Jagielski } catch(com.sun.star.lang.IndexOutOfBoundsException e) { 215*b1cdbd2cSJim Jagielski e.printStackTrace(log); 216*b1cdbd2cSJim Jagielski throw new StatusException("Couldn't get spreadsheet by index", e); 217*b1cdbd2cSJim Jagielski } catch(com.sun.star.lang.IllegalArgumentException e) { 218*b1cdbd2cSJim Jagielski e.printStackTrace(log); 219*b1cdbd2cSJim Jagielski throw new StatusException("Couldn't get spreadsheet by index", e); 220*b1cdbd2cSJim Jagielski } 221*b1cdbd2cSJim Jagielski 222*b1cdbd2cSJim Jagielski XPropertySet xProp = (XPropertySet) 223*b1cdbd2cSJim Jagielski UnoRuntime.queryInterface(XPropertySet.class, aCell); 224*b1cdbd2cSJim Jagielski 225*b1cdbd2cSJim Jagielski try { 226*b1cdbd2cSJim Jagielski xProp.setPropertyValue("CellStyle", oMyStyle.getName()); 227*b1cdbd2cSJim Jagielski } catch(com.sun.star.lang.WrappedTargetException e) { 228*b1cdbd2cSJim Jagielski e.printStackTrace(log); 229*b1cdbd2cSJim Jagielski throw new StatusException("Couldn't set property CellStyle", e); 230*b1cdbd2cSJim Jagielski } catch(com.sun.star.lang.IllegalArgumentException e) { 231*b1cdbd2cSJim Jagielski e.printStackTrace(log); 232*b1cdbd2cSJim Jagielski throw new StatusException("Couldn't set property CellStyle", e); 233*b1cdbd2cSJim Jagielski } catch(com.sun.star.beans.PropertyVetoException e) { 234*b1cdbd2cSJim Jagielski e.printStackTrace(log); 235*b1cdbd2cSJim Jagielski throw new StatusException("Couldn't set property CellStyle", e); 236*b1cdbd2cSJim Jagielski } catch(com.sun.star.beans.UnknownPropertyException e) { 237*b1cdbd2cSJim Jagielski e.printStackTrace(log); 238*b1cdbd2cSJim Jagielski throw new StatusException("Couldn't set property CellStyle", e); 239*b1cdbd2cSJim Jagielski } 240*b1cdbd2cSJim Jagielski 241*b1cdbd2cSJim Jagielski log.println("creating a new environment for object"); 242*b1cdbd2cSJim Jagielski TestEnvironment tEnv = new TestEnvironment(oMyStyle); 243*b1cdbd2cSJim Jagielski 244*b1cdbd2cSJim Jagielski tEnv.addObjRelation("PoolStyle", oStyle); 245*b1cdbd2cSJim Jagielski 246*b1cdbd2cSJim Jagielski tEnv.addObjRelation("PropertyNames", getPropertyNames 247*b1cdbd2cSJim Jagielski ((XPropertySet) UnoRuntime.queryInterface 248*b1cdbd2cSJim Jagielski (XPropertySet.class, oMyStyle))); 249*b1cdbd2cSJim Jagielski 250*b1cdbd2cSJim Jagielski return tEnv; 251*b1cdbd2cSJim Jagielski } 252*b1cdbd2cSJim Jagielski getPropertyNames(XPropertySet props)253*b1cdbd2cSJim Jagielski public String[] getPropertyNames(XPropertySet props) { 254*b1cdbd2cSJim Jagielski Property[] the_props = props.getPropertySetInfo().getProperties(); 255*b1cdbd2cSJim Jagielski Vector names = new Vector() ; 256*b1cdbd2cSJim Jagielski 257*b1cdbd2cSJim Jagielski for (int i=0;i<the_props.length;i++) { 258*b1cdbd2cSJim Jagielski boolean isWritable = 259*b1cdbd2cSJim Jagielski ((the_props[i].Attributes & PropertyAttribute.READONLY) == 0); 260*b1cdbd2cSJim Jagielski if (isWritable) { 261*b1cdbd2cSJim Jagielski names.add(the_props[i].Name); 262*b1cdbd2cSJim Jagielski } 263*b1cdbd2cSJim Jagielski } 264*b1cdbd2cSJim Jagielski return (String[]) names.toArray(new String[names.size()]) ; 265*b1cdbd2cSJim Jagielski } 266*b1cdbd2cSJim Jagielski } // finish class ScStyleObj 267