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 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.frame.XModel; 42*b1cdbd2cSJim Jagielski import com.sun.star.lang.XComponent; 43*b1cdbd2cSJim Jagielski import com.sun.star.lang.XMultiServiceFactory; 44*b1cdbd2cSJim Jagielski import com.sun.star.sheet.XSpreadsheet; 45*b1cdbd2cSJim Jagielski import com.sun.star.sheet.XSpreadsheetDocument; 46*b1cdbd2cSJim Jagielski import com.sun.star.sheet.XSpreadsheets; 47*b1cdbd2cSJim Jagielski import com.sun.star.table.XCell; 48*b1cdbd2cSJim Jagielski import com.sun.star.table.XColumnRowRange; 49*b1cdbd2cSJim Jagielski import com.sun.star.table.XTableColumns; 50*b1cdbd2cSJim Jagielski import com.sun.star.uno.AnyConverter; 51*b1cdbd2cSJim Jagielski import com.sun.star.uno.Type; 52*b1cdbd2cSJim Jagielski import com.sun.star.uno.UnoRuntime; 53*b1cdbd2cSJim Jagielski import com.sun.star.uno.XInterface; 54*b1cdbd2cSJim Jagielski 55*b1cdbd2cSJim Jagielski /** 56*b1cdbd2cSJim Jagielski * Test for object which is represented by accessible component of 57*b1cdbd2cSJim Jagielski * a cell in the spreadsheet. <p> 58*b1cdbd2cSJim Jagielski * Object implements the following interfaces : 59*b1cdbd2cSJim Jagielski * <ul> 60*b1cdbd2cSJim Jagielski * <li> <code>::com::sun::star::accessibility::XAccessibleSelection</code></li> 61*b1cdbd2cSJim Jagielski * <li> <code>::com::sun::star::accessibility::XAccessibleEventBroadcaster</code></li> 62*b1cdbd2cSJim Jagielski * <li> <code>::com::sun::star::accessibility::XAccessibleComponent</code></li> 63*b1cdbd2cSJim Jagielski * <li> <code>::com::sun::star::accessibility::XAccessibleTable</code></li> 64*b1cdbd2cSJim Jagielski * <li> <code>::com::sun::star::accessibility::XAccessibleContext</code></li> 65*b1cdbd2cSJim Jagielski * </ul> <p> 66*b1cdbd2cSJim Jagielski * 67*b1cdbd2cSJim Jagielski * @see com.sun.star.accessibility.XAccessibleSelection 68*b1cdbd2cSJim Jagielski * @see com.sun.star.accessibility.XAccessibleEventBroadcaster 69*b1cdbd2cSJim Jagielski * @see com.sun.star.accessibility.XAccessibleComponent 70*b1cdbd2cSJim Jagielski * @see com.sun.star.accessibility.XAccessibleTable 71*b1cdbd2cSJim Jagielski * @see com.sun.star.accessibility.XAccessibleContext 72*b1cdbd2cSJim Jagielski * @see ifc.accessibility._XAccessibleSelection 73*b1cdbd2cSJim Jagielski * @see ifc.accessibility._XAccessibleEventBroadcaster 74*b1cdbd2cSJim Jagielski * @see ifc.accessibility._XAccessibleComponent 75*b1cdbd2cSJim Jagielski * @see ifc.accessibility._XAccessibleTable 76*b1cdbd2cSJim Jagielski * @see ifc.accessibility._XAccessibleContext 77*b1cdbd2cSJim Jagielski */ 78*b1cdbd2cSJim Jagielski public class ScAccessibleCell extends TestCase { 79*b1cdbd2cSJim Jagielski 80*b1cdbd2cSJim Jagielski static XSpreadsheetDocument xSpreadsheetDoc = null; 81*b1cdbd2cSJim Jagielski 82*b1cdbd2cSJim Jagielski /** 83*b1cdbd2cSJim Jagielski * Called to create an instance of <code>TestEnvironment</code> 84*b1cdbd2cSJim Jagielski * with an object to test and related objects. 85*b1cdbd2cSJim Jagielski * Switches the document to Print Preview mode. 86*b1cdbd2cSJim Jagielski * Obtains accessible object for the page view. 87*b1cdbd2cSJim Jagielski * 88*b1cdbd2cSJim Jagielski * @param Param test parameters 89*b1cdbd2cSJim Jagielski * @param log writer to log information while testing 90*b1cdbd2cSJim Jagielski * 91*b1cdbd2cSJim Jagielski * @see TestEnvironment 92*b1cdbd2cSJim Jagielski * @see #getTestEnvironment 93*b1cdbd2cSJim Jagielski */ createTestEnvironment( TestParameters Param, PrintWriter log)94*b1cdbd2cSJim Jagielski protected TestEnvironment createTestEnvironment( 95*b1cdbd2cSJim Jagielski TestParameters Param, PrintWriter log) { 96*b1cdbd2cSJim Jagielski 97*b1cdbd2cSJim Jagielski // get a soffice factory object 98*b1cdbd2cSJim Jagielski SOfficeFactory SOF = SOfficeFactory.getFactory( (XMultiServiceFactory) Param.getMSF()); 99*b1cdbd2cSJim Jagielski 100*b1cdbd2cSJim Jagielski try { 101*b1cdbd2cSJim Jagielski log.println("creating a spreadsheetdocument"); 102*b1cdbd2cSJim Jagielski xSpreadsheetDoc = SOF.createCalcDoc(null); 103*b1cdbd2cSJim Jagielski } catch (com.sun.star.uno.Exception e) { 104*b1cdbd2cSJim Jagielski e.printStackTrace( log ); 105*b1cdbd2cSJim Jagielski throw new StatusException( "Couldn't create document ", e ); 106*b1cdbd2cSJim Jagielski } 107*b1cdbd2cSJim Jagielski 108*b1cdbd2cSJim Jagielski XInterface oObj = null; 109*b1cdbd2cSJim Jagielski 110*b1cdbd2cSJim Jagielski XModel aModel = (XModel) 111*b1cdbd2cSJim Jagielski UnoRuntime.queryInterface(XModel.class, xSpreadsheetDoc); 112*b1cdbd2cSJim Jagielski 113*b1cdbd2cSJim Jagielski XWindow xWindow = AccessibilityTools.getCurrentWindow( (XMultiServiceFactory) Param.getMSF(), aModel); 114*b1cdbd2cSJim Jagielski XAccessible xRoot = AccessibilityTools.getAccessibleObject(xWindow); 115*b1cdbd2cSJim Jagielski 116*b1cdbd2cSJim Jagielski oObj = AccessibilityTools.getAccessibleObjectForRole 117*b1cdbd2cSJim Jagielski (xRoot, AccessibleRole.TABLE_CELL, "B1"); 118*b1cdbd2cSJim Jagielski 119*b1cdbd2cSJim Jagielski log.println("ImplementationName " + utils.getImplName(oObj)); 120*b1cdbd2cSJim Jagielski 121*b1cdbd2cSJim Jagielski TestEnvironment tEnv = new TestEnvironment(oObj); 122*b1cdbd2cSJim Jagielski 123*b1cdbd2cSJim Jagielski // relation for XAccessibleEventBroadcaster 124*b1cdbd2cSJim Jagielski XCell xCell = null; 125*b1cdbd2cSJim Jagielski final String text = "XAccessibleText"; 126*b1cdbd2cSJim Jagielski try { 127*b1cdbd2cSJim Jagielski XSpreadsheets oSheets = xSpreadsheetDoc.getSheets() ; 128*b1cdbd2cSJim Jagielski XIndexAccess oIndexSheets = (XIndexAccess) 129*b1cdbd2cSJim Jagielski UnoRuntime.queryInterface(XIndexAccess.class, oSheets); 130*b1cdbd2cSJim Jagielski XSpreadsheet oSheet = null; 131*b1cdbd2cSJim Jagielski try { 132*b1cdbd2cSJim Jagielski oSheet = (XSpreadsheet) AnyConverter.toObject( 133*b1cdbd2cSJim Jagielski new Type(XSpreadsheet.class),oIndexSheets.getByIndex(0)); 134*b1cdbd2cSJim Jagielski } catch (com.sun.star.lang.IllegalArgumentException iae) { 135*b1cdbd2cSJim Jagielski throw new StatusException("couldn't get sheet",iae); 136*b1cdbd2cSJim Jagielski } 137*b1cdbd2cSJim Jagielski xCell = oSheet.getCellByPosition(1, 0) ; 138*b1cdbd2cSJim Jagielski xCell.setFormula(text); 139*b1cdbd2cSJim Jagielski XColumnRowRange oColumnRowRange = (XColumnRowRange) 140*b1cdbd2cSJim Jagielski UnoRuntime.queryInterface(XColumnRowRange.class, oSheet); 141*b1cdbd2cSJim Jagielski XTableColumns oColumns = (XTableColumns) oColumnRowRange.getColumns(); 142*b1cdbd2cSJim Jagielski XIndexAccess oIndexAccess = (XIndexAccess) 143*b1cdbd2cSJim Jagielski UnoRuntime.queryInterface(XIndexAccess.class, oColumns); 144*b1cdbd2cSJim Jagielski XPropertySet column = (XPropertySet) UnoRuntime.queryInterface( 145*b1cdbd2cSJim Jagielski XPropertySet.class,oIndexAccess.getByIndex(1)); 146*b1cdbd2cSJim Jagielski column.setPropertyValue("OptimalWidth", new Boolean(true)); 147*b1cdbd2cSJim Jagielski } catch(com.sun.star.lang.WrappedTargetException e) { 148*b1cdbd2cSJim Jagielski log.println("Exception ceating relation :"); 149*b1cdbd2cSJim Jagielski e.printStackTrace(log); 150*b1cdbd2cSJim Jagielski } catch(com.sun.star.lang.IndexOutOfBoundsException e) { 151*b1cdbd2cSJim Jagielski log.println("Exception ceating relation :"); 152*b1cdbd2cSJim Jagielski e.printStackTrace(log); 153*b1cdbd2cSJim Jagielski } catch(com.sun.star.beans.UnknownPropertyException e) { 154*b1cdbd2cSJim Jagielski log.println("Exception ceating relation :"); 155*b1cdbd2cSJim Jagielski e.printStackTrace(log); 156*b1cdbd2cSJim Jagielski } catch(com.sun.star.beans.PropertyVetoException e) { 157*b1cdbd2cSJim Jagielski log.println("Exception ceating relation :"); 158*b1cdbd2cSJim Jagielski e.printStackTrace(log); 159*b1cdbd2cSJim Jagielski } catch(com.sun.star.lang.IllegalArgumentException e) { 160*b1cdbd2cSJim Jagielski log.println("Exception ceating relation :"); 161*b1cdbd2cSJim Jagielski e.printStackTrace(log); 162*b1cdbd2cSJim Jagielski } 163*b1cdbd2cSJim Jagielski 164*b1cdbd2cSJim Jagielski tEnv.addObjRelation("EditOnly", 165*b1cdbd2cSJim Jagielski "This method is only supported if the Cell is in edit mode"); 166*b1cdbd2cSJim Jagielski 167*b1cdbd2cSJim Jagielski final XCell fCell = xCell ; 168*b1cdbd2cSJim Jagielski 169*b1cdbd2cSJim Jagielski tEnv.addObjRelation("EventProducer", 170*b1cdbd2cSJim Jagielski new ifc.accessibility._XAccessibleEventBroadcaster.EventProducer(){ 171*b1cdbd2cSJim Jagielski public void fireEvent() { 172*b1cdbd2cSJim Jagielski fCell.setFormula("firing event"); 173*b1cdbd2cSJim Jagielski fCell.setFormula(text); 174*b1cdbd2cSJim Jagielski } 175*b1cdbd2cSJim Jagielski }); 176*b1cdbd2cSJim Jagielski 177*b1cdbd2cSJim Jagielski tEnv.addObjRelation("XAccessibleText.Text", text); 178*b1cdbd2cSJim Jagielski 179*b1cdbd2cSJim Jagielski return tEnv; 180*b1cdbd2cSJim Jagielski 181*b1cdbd2cSJim Jagielski } 182*b1cdbd2cSJim Jagielski 183*b1cdbd2cSJim Jagielski /** 184*b1cdbd2cSJim Jagielski * Called while disposing a <code>TestEnvironment</code>. 185*b1cdbd2cSJim Jagielski * Disposes calc document. 186*b1cdbd2cSJim Jagielski * @param Param test parameters 187*b1cdbd2cSJim Jagielski * @param log writer to log information while testing 188*b1cdbd2cSJim Jagielski */ cleanup( TestParameters Param, PrintWriter log)189*b1cdbd2cSJim Jagielski protected void cleanup( TestParameters Param, PrintWriter log) { 190*b1cdbd2cSJim Jagielski log.println( " disposing xSheetDoc " ); 191*b1cdbd2cSJim Jagielski XComponent oComp = (XComponent) 192*b1cdbd2cSJim Jagielski UnoRuntime.queryInterface (XComponent.class, xSpreadsheetDoc) ; 193*b1cdbd2cSJim Jagielski util.DesktopTools.closeDoc(oComp); 194*b1cdbd2cSJim Jagielski } 195*b1cdbd2cSJim Jagielski } 196