/************************************************************************* * * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. * * Copyright 2000, 2010 Oracle and/or its affiliates. * * OpenOffice.org - a multi-platform office productivity suite * * This file is part of OpenOffice.org. * * OpenOffice.org is free software: you can redistribute it and/or modify * it under the terms of the GNU Lesser General Public License version 3 * only, as published by the Free Software Foundation. * * OpenOffice.org is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU Lesser General Public License version 3 for more details * (a copy is included in the LICENSE file that accompanied this code). * * You should have received a copy of the GNU Lesser General Public License * version 3 along with OpenOffice.org. If not, see * * for a copy of the LGPLv3 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); } }