/************************************************************** * * Licensed to the Apache Software Foundation (ASF) under one * or more contributor license agreements. See the NOTICE file * distributed with this work for additional information * regarding copyright ownership. The ASF licenses this file * to you under the Apache License, Version 2.0 (the * "License"); you may not use this file except in compliance * with the License. You may obtain a copy of the License at * * http://www.apache.org/licenses/LICENSE-2.0 * * Unless required by applicable law or agreed to in writing, * software distributed under the License is distributed on an * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY * KIND, either express or implied. See the License for the * specific language governing permissions and limitations * under the License. * *************************************************************/ package mod._sc; import java.io.PrintWriter; import lib.StatusException; import lib.TestCase; import lib.TestEnvironment; import lib.TestParameters; import util.AccessibilityTools; import util.SOfficeFactory; import util.utils; import com.sun.star.accessibility.AccessibleRole; import com.sun.star.accessibility.XAccessible; import com.sun.star.awt.XWindow; import com.sun.star.beans.XPropertySet; import com.sun.star.container.XIndexAccess; import com.sun.star.frame.XModel; import com.sun.star.lang.XComponent; import com.sun.star.lang.XMultiServiceFactory; import com.sun.star.sheet.XSpreadsheet; import com.sun.star.sheet.XSpreadsheetDocument; import com.sun.star.sheet.XSpreadsheets; import com.sun.star.table.XCell; import com.sun.star.table.XColumnRowRange; import com.sun.star.table.XTableColumns; import com.sun.star.uno.AnyConverter; import com.sun.star.uno.Type; import com.sun.star.uno.UnoRuntime; import com.sun.star.uno.XInterface; /** * Test for object which is represented by accessible component of * a cell in the spreadsheet.

* Object implements the following interfaces : *

* * @see com.sun.star.accessibility.XAccessibleSelection * @see com.sun.star.accessibility.XAccessibleEventBroadcaster * @see com.sun.star.accessibility.XAccessibleComponent * @see com.sun.star.accessibility.XAccessibleTable * @see com.sun.star.accessibility.XAccessibleContext * @see ifc.n.star.accessibility._XAccessibleSelection * @see ifc.n.star.accessibility._XAccessibleEventBroadcaster * @see ifc.n.star.accessibility._XAccessibleComponent * @see ifc.n.star.accessibility._XAccessibleTable * @see ifc.n.star.accessibility._XAccessibleContext */ public class ScAccessibleCell extends TestCase { static XSpreadsheetDocument xSpreadsheetDoc = null; /** * Called to create an instance of TestEnvironment * with an object to test and related objects. * Switchs the document to Print Preview mode. * Obtains accissible object for the page view. * * @param tParam test parameters * @param log writer to log information while testing * * @see TestEnvironment * @see #getTestEnvironment() */ protected TestEnvironment createTestEnvironment( TestParameters Param, PrintWriter log) { // get a soffice factory object SOfficeFactory SOF = SOfficeFactory.getFactory( (XMultiServiceFactory) Param.getMSF()); try { log.println("creating a spreadsheetdocument"); xSpreadsheetDoc = SOF.createCalcDoc(null); } catch (com.sun.star.uno.Exception e) { e.printStackTrace( log ); throw new StatusException( "Couldn't create document ", e ); } XInterface oObj = null; XModel aModel = (XModel) UnoRuntime.queryInterface(XModel.class, xSpreadsheetDoc); XWindow xWindow = AccessibilityTools.getCurrentWindow( (XMultiServiceFactory) Param.getMSF(), aModel); XAccessible xRoot = AccessibilityTools.getAccessibleObject(xWindow); oObj = AccessibilityTools.getAccessibleObjectForRole (xRoot, AccessibleRole.TABLE_CELL, "B1"); log.println("ImplementationName " + utils.getImplName(oObj)); TestEnvironment tEnv = new TestEnvironment(oObj); // relation for XAccessibleEventBroadcaster XCell xCell = null; final String text = "XAccessibleText"; try { XSpreadsheets oSheets = xSpreadsheetDoc.getSheets() ; XIndexAccess oIndexSheets = (XIndexAccess) UnoRuntime.queryInterface(XIndexAccess.class, oSheets); XSpreadsheet oSheet = null; try { oSheet = (XSpreadsheet) AnyConverter.toObject( new Type(XSpreadsheet.class),oIndexSheets.getByIndex(0)); } catch (com.sun.star.lang.IllegalArgumentException iae) { throw new StatusException("couldn't get sheet",iae); } xCell = oSheet.getCellByPosition(1, 0) ; xCell.setFormula(text); XColumnRowRange oColumnRowRange = (XColumnRowRange) UnoRuntime.queryInterface(XColumnRowRange.class, oSheet); XTableColumns oColumns = (XTableColumns) oColumnRowRange.getColumns(); XIndexAccess oIndexAccess = (XIndexAccess) UnoRuntime.queryInterface(XIndexAccess.class, oColumns); XPropertySet column = (XPropertySet) UnoRuntime.queryInterface( XPropertySet.class,oIndexAccess.getByIndex(1)); column.setPropertyValue("OptimalWidth", new Boolean(true)); } catch(com.sun.star.lang.WrappedTargetException e) { log.println("Exception ceating relation :"); e.printStackTrace(log); } catch(com.sun.star.lang.IndexOutOfBoundsException e) { log.println("Exception ceating relation :"); e.printStackTrace(log); } catch(com.sun.star.beans.UnknownPropertyException e) { log.println("Exception ceating relation :"); e.printStackTrace(log); } catch(com.sun.star.beans.PropertyVetoException e) { log.println("Exception ceating relation :"); e.printStackTrace(log); } catch(com.sun.star.lang.IllegalArgumentException e) { log.println("Exception ceating relation :"); e.printStackTrace(log); } tEnv.addObjRelation("EditOnly", "This method is only supported if the Cell is in edit mode"); final XCell fCell = xCell ; tEnv.addObjRelation("EventProducer", new ifc.accessibility._XAccessibleEventBroadcaster.EventProducer(){ public void fireEvent() { fCell.setFormula("firing event"); fCell.setFormula(text); } }); tEnv.addObjRelation("XAccessibleText.Text", text); return tEnv; } /** * Called while disposing a TestEnvironment. * Disposes calc document. * @param tParam test parameters * @param tEnv the environment to cleanup * @param log writer to log information while testing */ protected void cleanup( TestParameters Param, PrintWriter log) { log.println( " disposing xSheetDoc " ); XComponent oComp = (XComponent) UnoRuntime.queryInterface (XComponent.class, xSpreadsheetDoc) ; util.DesktopTools.closeDoc(oComp); } }