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 package mod._sc; 24*b1cdbd2cSJim Jagielski 25*b1cdbd2cSJim Jagielski import java.io.PrintWriter; 26*b1cdbd2cSJim Jagielski 27*b1cdbd2cSJim Jagielski import lib.Status; 28*b1cdbd2cSJim Jagielski import lib.StatusException; 29*b1cdbd2cSJim Jagielski import lib.TestCase; 30*b1cdbd2cSJim Jagielski import lib.TestEnvironment; 31*b1cdbd2cSJim Jagielski import lib.TestParameters; 32*b1cdbd2cSJim Jagielski import util.AccessibilityTools; 33*b1cdbd2cSJim Jagielski import util.SOfficeFactory; 34*b1cdbd2cSJim Jagielski import util.utils; 35*b1cdbd2cSJim Jagielski 36*b1cdbd2cSJim Jagielski import com.sun.star.accessibility.AccessibleRole; 37*b1cdbd2cSJim Jagielski import com.sun.star.accessibility.XAccessible; 38*b1cdbd2cSJim Jagielski import com.sun.star.awt.XWindow; 39*b1cdbd2cSJim Jagielski import com.sun.star.beans.XPropertySet; 40*b1cdbd2cSJim Jagielski import com.sun.star.container.XIndexAccess; 41*b1cdbd2cSJim Jagielski import com.sun.star.container.XNameAccess; 42*b1cdbd2cSJim Jagielski import com.sun.star.frame.XController; 43*b1cdbd2cSJim Jagielski import com.sun.star.frame.XDispatch; 44*b1cdbd2cSJim Jagielski import com.sun.star.frame.XDispatchProvider; 45*b1cdbd2cSJim Jagielski import com.sun.star.frame.XModel; 46*b1cdbd2cSJim Jagielski import com.sun.star.lang.XComponent; 47*b1cdbd2cSJim Jagielski import com.sun.star.lang.XMultiServiceFactory; 48*b1cdbd2cSJim Jagielski import com.sun.star.sheet.XSpreadsheet; 49*b1cdbd2cSJim Jagielski import com.sun.star.sheet.XSpreadsheetDocument; 50*b1cdbd2cSJim Jagielski import com.sun.star.sheet.XSpreadsheets; 51*b1cdbd2cSJim Jagielski import com.sun.star.style.XStyleFamiliesSupplier; 52*b1cdbd2cSJim Jagielski import com.sun.star.table.XCell; 53*b1cdbd2cSJim Jagielski import com.sun.star.uno.AnyConverter; 54*b1cdbd2cSJim Jagielski import com.sun.star.uno.Type; 55*b1cdbd2cSJim Jagielski import com.sun.star.uno.UnoRuntime; 56*b1cdbd2cSJim Jagielski import com.sun.star.uno.XInterface; 57*b1cdbd2cSJim Jagielski import com.sun.star.util.URL; 58*b1cdbd2cSJim Jagielski import com.sun.star.util.XCloseable; 59*b1cdbd2cSJim Jagielski import com.sun.star.util.XURLTransformer; 60*b1cdbd2cSJim Jagielski 61*b1cdbd2cSJim Jagielski 62*b1cdbd2cSJim Jagielski /** 63*b1cdbd2cSJim Jagielski * Object implements the following interfaces: 64*b1cdbd2cSJim Jagielski * <ul> 65*b1cdbd2cSJim Jagielski * <li> <code>::com::sun::star::accessibility::XAccessibleComponent</code> 66*b1cdbd2cSJim Jagielski * </li> 67*b1cdbd2cSJim Jagielski * <li> <code>::com::sun::star::accessibility::XAccessibleContext</code> 68*b1cdbd2cSJim Jagielski * </li> 69*b1cdbd2cSJim Jagielski * <li> <code>::com::sun::star::accessibility::XAccessibleSelection 70*b1cdbd2cSJim Jagielski * </code></li> 71*b1cdbd2cSJim Jagielski * <li><code>::com::sun::star::accessibility::XAccessibleValue</code> 72*b1cdbd2cSJim Jagielski * </li> 73*b1cdbd2cSJim Jagielski * <li><code>::com::sun::star::accessibility::XAccessibleEventBroadcaster 74*b1cdbd2cSJim Jagielski * </code></li> 75*b1cdbd2cSJim Jagielski * </ul> 76*b1cdbd2cSJim Jagielski * @see com.sun.star.accessibility.XAccessibleComponent 77*b1cdbd2cSJim Jagielski * @see com.sun.star.accessibility.XAccessibleContext 78*b1cdbd2cSJim Jagielski * @see com.sun.star.accessibility.XAccessibleSelection 79*b1cdbd2cSJim Jagielski * @see com.sun.star.accessibility.XAccessibleValue 80*b1cdbd2cSJim Jagielski * @see com.sun.star.accessibility.XAccessibleEventBroadcaster 81*b1cdbd2cSJim Jagielski * @see ifc.accessibility._XAccessibleEventBroadcaster 82*b1cdbd2cSJim Jagielski * @see ifc.accessibility._XAccessibleComponent 83*b1cdbd2cSJim Jagielski * @see ifc.accessibility._XAccessibleContext 84*b1cdbd2cSJim Jagielski * @see ifc.accessibility._XAccessibleSelection 85*b1cdbd2cSJim Jagielski * @see ifc.accessibility._XAccessibleTable 86*b1cdbd2cSJim Jagielski */ 87*b1cdbd2cSJim Jagielski public class ScAccessiblePreviewHeaderCell extends TestCase { 88*b1cdbd2cSJim Jagielski static XSpreadsheetDocument xSheetDoc = null; 89*b1cdbd2cSJim Jagielski 90*b1cdbd2cSJim Jagielski /** 91*b1cdbd2cSJim Jagielski * Creates a spreadsheet document. 92*b1cdbd2cSJim Jagielski */ initialize(TestParameters tParam, PrintWriter log)93*b1cdbd2cSJim Jagielski protected void initialize(TestParameters tParam, PrintWriter log) { 94*b1cdbd2cSJim Jagielski } 95*b1cdbd2cSJim Jagielski 96*b1cdbd2cSJim Jagielski /** 97*b1cdbd2cSJim Jagielski * Disposes a spreadsheet document. 98*b1cdbd2cSJim Jagielski */ cleanup(TestParameters tParam, PrintWriter log)99*b1cdbd2cSJim Jagielski protected void cleanup(TestParameters tParam, PrintWriter log) { 100*b1cdbd2cSJim Jagielski log.println(" disposing xSheetDoc "); 101*b1cdbd2cSJim Jagielski 102*b1cdbd2cSJim Jagielski if (xSheetDoc != null) { 103*b1cdbd2cSJim Jagielski try { 104*b1cdbd2cSJim Jagielski XCloseable oComp = (XCloseable) UnoRuntime.queryInterface( 105*b1cdbd2cSJim Jagielski XCloseable.class, xSheetDoc); 106*b1cdbd2cSJim Jagielski oComp.close(true); 107*b1cdbd2cSJim Jagielski xSheetDoc = null; 108*b1cdbd2cSJim Jagielski } catch (com.sun.star.util.CloseVetoException e) { 109*b1cdbd2cSJim Jagielski e.printStackTrace(log); 110*b1cdbd2cSJim Jagielski } catch (com.sun.star.lang.DisposedException e) { 111*b1cdbd2cSJim Jagielski log.println("document already disposed"); 112*b1cdbd2cSJim Jagielski xSheetDoc = null; 113*b1cdbd2cSJim Jagielski } 114*b1cdbd2cSJim Jagielski } 115*b1cdbd2cSJim Jagielski } 116*b1cdbd2cSJim Jagielski 117*b1cdbd2cSJim Jagielski /** 118*b1cdbd2cSJim Jagielski * Creating a Testenvironment for the interfaces to be tested. 119*b1cdbd2cSJim Jagielski * Sets a value of the cell 'A1'. Sets the property 'PrintHeaders' 120*b1cdbd2cSJim Jagielski * of the style 'Default' of the family 'PageStyles' to true. 121*b1cdbd2cSJim Jagielski * Switchs the document to preview mode and then obtains the 122*b1cdbd2cSJim Jagielski * accessible object for the header cell. 123*b1cdbd2cSJim Jagielski */ createTestEnvironment(TestParameters Param, PrintWriter log)124*b1cdbd2cSJim Jagielski protected synchronized TestEnvironment createTestEnvironment(TestParameters Param, 125*b1cdbd2cSJim Jagielski PrintWriter log) { 126*b1cdbd2cSJim Jagielski XInterface oObj = null; 127*b1cdbd2cSJim Jagielski 128*b1cdbd2cSJim Jagielski if (xSheetDoc != null) { 129*b1cdbd2cSJim Jagielski XComponent oComp = (XComponent) UnoRuntime.queryInterface( 130*b1cdbd2cSJim Jagielski XComponent.class, xSheetDoc); 131*b1cdbd2cSJim Jagielski util.DesktopTools.closeDoc(oComp); 132*b1cdbd2cSJim Jagielski } 133*b1cdbd2cSJim Jagielski 134*b1cdbd2cSJim Jagielski SOfficeFactory SOF = SOfficeFactory.getFactory( (XMultiServiceFactory) Param.getMSF()); 135*b1cdbd2cSJim Jagielski 136*b1cdbd2cSJim Jagielski try { 137*b1cdbd2cSJim Jagielski log.println("creating a Spreadsheet document"); 138*b1cdbd2cSJim Jagielski xSheetDoc = SOF.createCalcDoc(null); 139*b1cdbd2cSJim Jagielski } catch (com.sun.star.uno.Exception e) { 140*b1cdbd2cSJim Jagielski // Some exception occures.FAILED 141*b1cdbd2cSJim Jagielski e.printStackTrace(log); 142*b1cdbd2cSJim Jagielski throw new StatusException("Couldn't create document", e); 143*b1cdbd2cSJim Jagielski } 144*b1cdbd2cSJim Jagielski 145*b1cdbd2cSJim Jagielski XModel xModel = (XModel) UnoRuntime.queryInterface(XModel.class, 146*b1cdbd2cSJim Jagielski xSheetDoc); 147*b1cdbd2cSJim Jagielski 148*b1cdbd2cSJim Jagielski XController xController = xModel.getCurrentController(); 149*b1cdbd2cSJim Jagielski 150*b1cdbd2cSJim Jagielski //setting value of cell A1 151*b1cdbd2cSJim Jagielski XCell xCell = null; 152*b1cdbd2cSJim Jagielski 153*b1cdbd2cSJim Jagielski try { 154*b1cdbd2cSJim Jagielski log.println("Getting spreadsheet"); 155*b1cdbd2cSJim Jagielski 156*b1cdbd2cSJim Jagielski XSpreadsheets oSheets = xSheetDoc.getSheets(); 157*b1cdbd2cSJim Jagielski XIndexAccess oIndexSheets = (XIndexAccess) UnoRuntime.queryInterface( 158*b1cdbd2cSJim Jagielski XIndexAccess.class, oSheets); 159*b1cdbd2cSJim Jagielski XSpreadsheet oSheet = (XSpreadsheet) AnyConverter.toObject( 160*b1cdbd2cSJim Jagielski new Type(XSpreadsheet.class), 161*b1cdbd2cSJim Jagielski oIndexSheets.getByIndex(0)); 162*b1cdbd2cSJim Jagielski 163*b1cdbd2cSJim Jagielski log.println("Getting a cell from sheet"); 164*b1cdbd2cSJim Jagielski xCell = oSheet.getCellByPosition(0, 0); 165*b1cdbd2cSJim Jagielski } catch (com.sun.star.lang.WrappedTargetException e) { 166*b1cdbd2cSJim Jagielski e.printStackTrace(log); 167*b1cdbd2cSJim Jagielski throw new StatusException( 168*b1cdbd2cSJim Jagielski "Error getting cell object from spreadsheet document", e); 169*b1cdbd2cSJim Jagielski } catch (com.sun.star.lang.IndexOutOfBoundsException e) { 170*b1cdbd2cSJim Jagielski e.printStackTrace(log); 171*b1cdbd2cSJim Jagielski throw new StatusException( 172*b1cdbd2cSJim Jagielski "Error getting cell object from spreadsheet document", e); 173*b1cdbd2cSJim Jagielski } catch (com.sun.star.lang.IllegalArgumentException e) { 174*b1cdbd2cSJim Jagielski e.printStackTrace(log); 175*b1cdbd2cSJim Jagielski throw new StatusException( 176*b1cdbd2cSJim Jagielski "Error getting cell object from spreadsheet document", e); 177*b1cdbd2cSJim Jagielski } 178*b1cdbd2cSJim Jagielski 179*b1cdbd2cSJim Jagielski xCell.setFormula("Value"); 180*b1cdbd2cSJim Jagielski 181*b1cdbd2cSJim Jagielski //setting property 'PrintHeaders' of the style 'Default' 182*b1cdbd2cSJim Jagielski XStyleFamiliesSupplier xSFS = (XStyleFamiliesSupplier) UnoRuntime.queryInterface( 183*b1cdbd2cSJim Jagielski XStyleFamiliesSupplier.class, 184*b1cdbd2cSJim Jagielski xSheetDoc); 185*b1cdbd2cSJim Jagielski XNameAccess xNA = xSFS.getStyleFamilies(); 186*b1cdbd2cSJim Jagielski XPropertySet xPropSet = null; 187*b1cdbd2cSJim Jagielski 188*b1cdbd2cSJim Jagielski try { 189*b1cdbd2cSJim Jagielski Object oPageStyles = xNA.getByName("PageStyles"); 190*b1cdbd2cSJim Jagielski xNA = (XNameAccess) UnoRuntime.queryInterface(XNameAccess.class, 191*b1cdbd2cSJim Jagielski oPageStyles); 192*b1cdbd2cSJim Jagielski 193*b1cdbd2cSJim Jagielski Object oDefStyle = xNA.getByName("Default"); 194*b1cdbd2cSJim Jagielski xPropSet = (XPropertySet) UnoRuntime.queryInterface( 195*b1cdbd2cSJim Jagielski XPropertySet.class, oDefStyle); 196*b1cdbd2cSJim Jagielski } catch (com.sun.star.lang.WrappedTargetException e) { 197*b1cdbd2cSJim Jagielski e.printStackTrace(log); 198*b1cdbd2cSJim Jagielski throw new StatusException(Status.failed("Couldn't get element")); 199*b1cdbd2cSJim Jagielski } catch (com.sun.star.container.NoSuchElementException e) { 200*b1cdbd2cSJim Jagielski e.printStackTrace(log); 201*b1cdbd2cSJim Jagielski throw new StatusException(Status.failed("Couldn't get element")); 202*b1cdbd2cSJim Jagielski } 203*b1cdbd2cSJim Jagielski 204*b1cdbd2cSJim Jagielski try { 205*b1cdbd2cSJim Jagielski xPropSet.setPropertyValue("PrintHeaders", new Boolean(true)); 206*b1cdbd2cSJim Jagielski } catch (com.sun.star.lang.WrappedTargetException e) { 207*b1cdbd2cSJim Jagielski e.printStackTrace(log); 208*b1cdbd2cSJim Jagielski throw new StatusException(Status.failed( 209*b1cdbd2cSJim Jagielski "Couldn't set property 'PrintHeaders'")); 210*b1cdbd2cSJim Jagielski } catch (com.sun.star.lang.IllegalArgumentException e) { 211*b1cdbd2cSJim Jagielski e.printStackTrace(log); 212*b1cdbd2cSJim Jagielski throw new StatusException(Status.failed( 213*b1cdbd2cSJim Jagielski "Couldn't set property 'PrintHeaders'")); 214*b1cdbd2cSJim Jagielski } catch (com.sun.star.beans.PropertyVetoException e) { 215*b1cdbd2cSJim Jagielski e.printStackTrace(log); 216*b1cdbd2cSJim Jagielski throw new StatusException(Status.failed( 217*b1cdbd2cSJim Jagielski "Couldn't set property 'PrintHeaders'")); 218*b1cdbd2cSJim Jagielski } catch (com.sun.star.beans.UnknownPropertyException e) { 219*b1cdbd2cSJim Jagielski e.printStackTrace(log); 220*b1cdbd2cSJim Jagielski throw new StatusException(Status.failed( 221*b1cdbd2cSJim Jagielski "Couldn't set property 'PrintHeaders'")); 222*b1cdbd2cSJim Jagielski } 223*b1cdbd2cSJim Jagielski 224*b1cdbd2cSJim Jagielski //switching to 'Print Preview' mode 225*b1cdbd2cSJim Jagielski try { 226*b1cdbd2cSJim Jagielski XDispatchProvider xDispProv = (XDispatchProvider) UnoRuntime.queryInterface( 227*b1cdbd2cSJim Jagielski XDispatchProvider.class, 228*b1cdbd2cSJim Jagielski xController); 229*b1cdbd2cSJim Jagielski XURLTransformer xParser = (com.sun.star.util.XURLTransformer) UnoRuntime.queryInterface( 230*b1cdbd2cSJim Jagielski XURLTransformer.class, 231*b1cdbd2cSJim Jagielski ( (XMultiServiceFactory) Param.getMSF()) 232*b1cdbd2cSJim Jagielski .createInstance("com.sun.star.util.URLTransformer")); 233*b1cdbd2cSJim Jagielski URL[] aParseURL = new URL[1]; 234*b1cdbd2cSJim Jagielski aParseURL[0] = new URL(); 235*b1cdbd2cSJim Jagielski aParseURL[0].Complete = ".uno:PrintPreview"; 236*b1cdbd2cSJim Jagielski xParser.parseStrict(aParseURL); 237*b1cdbd2cSJim Jagielski 238*b1cdbd2cSJim Jagielski URL aURL = aParseURL[0]; 239*b1cdbd2cSJim Jagielski XDispatch xDispatcher = xDispProv.queryDispatch(aURL, "", 0); 240*b1cdbd2cSJim Jagielski 241*b1cdbd2cSJim Jagielski if (xDispatcher != null) { 242*b1cdbd2cSJim Jagielski xDispatcher.dispatch(aURL, null); 243*b1cdbd2cSJim Jagielski } 244*b1cdbd2cSJim Jagielski } catch (com.sun.star.uno.Exception e) { 245*b1cdbd2cSJim Jagielski log.println("Couldn't change mode"); 246*b1cdbd2cSJim Jagielski throw new StatusException(Status.failed("Couldn't change mode")); 247*b1cdbd2cSJim Jagielski } 248*b1cdbd2cSJim Jagielski 249*b1cdbd2cSJim Jagielski shortWait(); 250*b1cdbd2cSJim Jagielski 251*b1cdbd2cSJim Jagielski AccessibilityTools at = new AccessibilityTools(); 252*b1cdbd2cSJim Jagielski 253*b1cdbd2cSJim Jagielski XWindow xWindow = at.getCurrentWindow( (XMultiServiceFactory) Param.getMSF(), xModel); 254*b1cdbd2cSJim Jagielski XAccessible xRoot = at.getAccessibleObject(xWindow); 255*b1cdbd2cSJim Jagielski 256*b1cdbd2cSJim Jagielski oObj = at.getAccessibleObjectForRole(xRoot, AccessibleRole.TABLE, "A"); 257*b1cdbd2cSJim Jagielski 258*b1cdbd2cSJim Jagielski if (oObj == null) { 259*b1cdbd2cSJim Jagielski log.println("Version with a fixed #103863#"); 260*b1cdbd2cSJim Jagielski oObj = at.getAccessibleObjectForRole(xRoot, 261*b1cdbd2cSJim Jagielski AccessibleRole.TABLE_CELL, 262*b1cdbd2cSJim Jagielski true); 263*b1cdbd2cSJim Jagielski } 264*b1cdbd2cSJim Jagielski 265*b1cdbd2cSJim Jagielski log.println("ImplementationName " + utils.getImplName(oObj)); 266*b1cdbd2cSJim Jagielski 267*b1cdbd2cSJim Jagielski TestEnvironment tEnv = new TestEnvironment(oObj); 268*b1cdbd2cSJim Jagielski 269*b1cdbd2cSJim Jagielski tEnv.addObjRelation("EventProducer", 270*b1cdbd2cSJim Jagielski new ifc.accessibility._XAccessibleEventBroadcaster.EventProducer() { 271*b1cdbd2cSJim Jagielski public void fireEvent() { 272*b1cdbd2cSJim Jagielski } 273*b1cdbd2cSJim Jagielski }); 274*b1cdbd2cSJim Jagielski 275*b1cdbd2cSJim Jagielski return tEnv; 276*b1cdbd2cSJim Jagielski } 277*b1cdbd2cSJim Jagielski 278*b1cdbd2cSJim Jagielski /** 279*b1cdbd2cSJim Jagielski * Sleeps for 0.5 sec. to allow StarOffice to react on <code> 280*b1cdbd2cSJim Jagielski * reset</code> call. 281*b1cdbd2cSJim Jagielski */ shortWait()282*b1cdbd2cSJim Jagielski private void shortWait() { 283*b1cdbd2cSJim Jagielski try { 284*b1cdbd2cSJim Jagielski Thread.currentThread().sleep(500); 285*b1cdbd2cSJim Jagielski } catch (InterruptedException e) { 286*b1cdbd2cSJim Jagielski System.out.println("While waiting :" + e); 287*b1cdbd2cSJim Jagielski } 288*b1cdbd2cSJim Jagielski } 289*b1cdbd2cSJim Jagielski }