1*ef39d40dSAndrew Rist /**************************************************************
2cdf0e10cSrcweir  *
3*ef39d40dSAndrew Rist  * Licensed to the Apache Software Foundation (ASF) under one
4*ef39d40dSAndrew Rist  * or more contributor license agreements.  See the NOTICE file
5*ef39d40dSAndrew Rist  * distributed with this work for additional information
6*ef39d40dSAndrew Rist  * regarding copyright ownership.  The ASF licenses this file
7*ef39d40dSAndrew Rist  * to you under the Apache License, Version 2.0 (the
8*ef39d40dSAndrew Rist  * "License"); you may not use this file except in compliance
9*ef39d40dSAndrew Rist  * with the License.  You may obtain a copy of the License at
10*ef39d40dSAndrew Rist  *
11*ef39d40dSAndrew Rist  *   http://www.apache.org/licenses/LICENSE-2.0
12*ef39d40dSAndrew Rist  *
13*ef39d40dSAndrew Rist  * Unless required by applicable law or agreed to in writing,
14*ef39d40dSAndrew Rist  * software distributed under the License is distributed on an
15*ef39d40dSAndrew Rist  * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
16*ef39d40dSAndrew Rist  * KIND, either express or implied.  See the License for the
17*ef39d40dSAndrew Rist  * specific language governing permissions and limitations
18*ef39d40dSAndrew Rist  * under the License.
19*ef39d40dSAndrew Rist  *
20*ef39d40dSAndrew Rist  *************************************************************/
21*ef39d40dSAndrew Rist 
22*ef39d40dSAndrew Rist 
23cdf0e10cSrcweir 
24cdf0e10cSrcweir package mod._sc;
25cdf0e10cSrcweir 
26cdf0e10cSrcweir import java.io.PrintWriter;
27cdf0e10cSrcweir 
28cdf0e10cSrcweir import lib.StatusException;
29cdf0e10cSrcweir import lib.TestCase;
30cdf0e10cSrcweir import lib.TestEnvironment;
31cdf0e10cSrcweir import lib.TestParameters;
32cdf0e10cSrcweir import util.AccessibilityTools;
33cdf0e10cSrcweir import util.SOfficeFactory;
34cdf0e10cSrcweir import util.utils;
35cdf0e10cSrcweir 
36cdf0e10cSrcweir import com.sun.star.accessibility.AccessibleRole;
37cdf0e10cSrcweir import com.sun.star.accessibility.XAccessible;
38cdf0e10cSrcweir import com.sun.star.awt.XWindow;
39cdf0e10cSrcweir import com.sun.star.beans.XPropertySet;
40cdf0e10cSrcweir import com.sun.star.container.XIndexAccess;
41cdf0e10cSrcweir import com.sun.star.frame.XModel;
42cdf0e10cSrcweir import com.sun.star.lang.XComponent;
43cdf0e10cSrcweir import com.sun.star.lang.XMultiServiceFactory;
44cdf0e10cSrcweir import com.sun.star.sheet.XSpreadsheet;
45cdf0e10cSrcweir import com.sun.star.sheet.XSpreadsheetDocument;
46cdf0e10cSrcweir import com.sun.star.sheet.XSpreadsheets;
47cdf0e10cSrcweir import com.sun.star.table.XCell;
48cdf0e10cSrcweir import com.sun.star.table.XColumnRowRange;
49cdf0e10cSrcweir import com.sun.star.table.XTableColumns;
50cdf0e10cSrcweir import com.sun.star.uno.AnyConverter;
51cdf0e10cSrcweir import com.sun.star.uno.Type;
52cdf0e10cSrcweir import com.sun.star.uno.UnoRuntime;
53cdf0e10cSrcweir import com.sun.star.uno.XInterface;
54cdf0e10cSrcweir 
55cdf0e10cSrcweir /**
56cdf0e10cSrcweir  * Test for object which is represented by accessible component of
57cdf0e10cSrcweir  * a cell in the spreadsheet. <p>
58cdf0e10cSrcweir  * Object implements the following interfaces :
59cdf0e10cSrcweir  * <ul>
60cdf0e10cSrcweir  *  <li> <code>::com::sun::star::accessibility::XAccessibleSelection</code></li>
61cdf0e10cSrcweir  *  <li> <code>::com::sun::star::accessibility::XAccessibleEventBroadcaster</code></li>
62cdf0e10cSrcweir  *  <li> <code>::com::sun::star::accessibility::XAccessibleComponent</code></li>
63cdf0e10cSrcweir  *  <li> <code>::com::sun::star::accessibility::XAccessibleTable</code></li>
64cdf0e10cSrcweir  *  <li> <code>::com::sun::star::accessibility::XAccessibleContext</code></li>
65cdf0e10cSrcweir  * </ul> <p>
66cdf0e10cSrcweir  *
67cdf0e10cSrcweir  * @see com.sun.star.accessibility.XAccessibleSelection
68cdf0e10cSrcweir  * @see com.sun.star.accessibility.XAccessibleEventBroadcaster
69cdf0e10cSrcweir  * @see com.sun.star.accessibility.XAccessibleComponent
70cdf0e10cSrcweir  * @see com.sun.star.accessibility.XAccessibleTable
71cdf0e10cSrcweir  * @see com.sun.star.accessibility.XAccessibleContext
72cdf0e10cSrcweir  * @see ifc.n.star.accessibility._XAccessibleSelection
73cdf0e10cSrcweir  * @see ifc.n.star.accessibility._XAccessibleEventBroadcaster
74cdf0e10cSrcweir  * @see ifc.n.star.accessibility._XAccessibleComponent
75cdf0e10cSrcweir  * @see ifc.n.star.accessibility._XAccessibleTable
76cdf0e10cSrcweir  * @see ifc.n.star.accessibility._XAccessibleContext
77cdf0e10cSrcweir  */
78cdf0e10cSrcweir public class ScAccessibleCell extends TestCase {
79cdf0e10cSrcweir 
80cdf0e10cSrcweir     static XSpreadsheetDocument xSpreadsheetDoc = null;
81cdf0e10cSrcweir 
82cdf0e10cSrcweir     /**
83cdf0e10cSrcweir     * Called to create an instance of <code>TestEnvironment</code>
84cdf0e10cSrcweir     * with an object to test and related objects.
85cdf0e10cSrcweir     * Switchs the document to Print Preview mode.
86cdf0e10cSrcweir     * Obtains accissible object for the page view.
87cdf0e10cSrcweir     *
88cdf0e10cSrcweir     * @param tParam test parameters
89cdf0e10cSrcweir     * @param log writer to log information while testing
90cdf0e10cSrcweir     *
91cdf0e10cSrcweir     * @see TestEnvironment
92cdf0e10cSrcweir     * @see #getTestEnvironment()
93cdf0e10cSrcweir     */
94cdf0e10cSrcweir     protected TestEnvironment createTestEnvironment(
95cdf0e10cSrcweir         TestParameters Param, PrintWriter log) {
96cdf0e10cSrcweir 
97cdf0e10cSrcweir         // get a soffice factory object
98cdf0e10cSrcweir         SOfficeFactory SOF = SOfficeFactory.getFactory(  (XMultiServiceFactory) Param.getMSF());
99cdf0e10cSrcweir 
100cdf0e10cSrcweir         try {
101cdf0e10cSrcweir             log.println("creating a spreadsheetdocument");
102cdf0e10cSrcweir             xSpreadsheetDoc = SOF.createCalcDoc(null);
103cdf0e10cSrcweir         } catch (com.sun.star.uno.Exception e) {
104cdf0e10cSrcweir             e.printStackTrace( log );
105cdf0e10cSrcweir             throw new StatusException( "Couldn't create document ", e );
106cdf0e10cSrcweir         }
107cdf0e10cSrcweir 
108cdf0e10cSrcweir         XInterface oObj = null;
109cdf0e10cSrcweir 
110cdf0e10cSrcweir         XModel aModel = (XModel)
111cdf0e10cSrcweir             UnoRuntime.queryInterface(XModel.class, xSpreadsheetDoc);
112cdf0e10cSrcweir 
113cdf0e10cSrcweir         XWindow xWindow = AccessibilityTools.getCurrentWindow( (XMultiServiceFactory) Param.getMSF(), aModel);
114cdf0e10cSrcweir         XAccessible xRoot = AccessibilityTools.getAccessibleObject(xWindow);
115cdf0e10cSrcweir 
116cdf0e10cSrcweir         oObj = AccessibilityTools.getAccessibleObjectForRole
117cdf0e10cSrcweir             (xRoot, AccessibleRole.TABLE_CELL, "B1");
118cdf0e10cSrcweir 
119cdf0e10cSrcweir         log.println("ImplementationName " + utils.getImplName(oObj));
120cdf0e10cSrcweir 
121cdf0e10cSrcweir         TestEnvironment tEnv = new TestEnvironment(oObj);
122cdf0e10cSrcweir 
123cdf0e10cSrcweir         // relation for XAccessibleEventBroadcaster
124cdf0e10cSrcweir         XCell xCell = null;
125cdf0e10cSrcweir         final String text = "XAccessibleText";
126cdf0e10cSrcweir         try {
127cdf0e10cSrcweir             XSpreadsheets oSheets = xSpreadsheetDoc.getSheets() ;
128cdf0e10cSrcweir             XIndexAccess oIndexSheets = (XIndexAccess)
129cdf0e10cSrcweir                 UnoRuntime.queryInterface(XIndexAccess.class, oSheets);
130cdf0e10cSrcweir             XSpreadsheet oSheet = null;
131cdf0e10cSrcweir             try {
132cdf0e10cSrcweir                 oSheet = (XSpreadsheet) AnyConverter.toObject(
133cdf0e10cSrcweir                         new Type(XSpreadsheet.class),oIndexSheets.getByIndex(0));
134cdf0e10cSrcweir             } catch (com.sun.star.lang.IllegalArgumentException iae) {
135cdf0e10cSrcweir                 throw new StatusException("couldn't get sheet",iae);
136cdf0e10cSrcweir             }
137cdf0e10cSrcweir             xCell = oSheet.getCellByPosition(1, 0) ;
138cdf0e10cSrcweir             xCell.setFormula(text);
139cdf0e10cSrcweir             XColumnRowRange oColumnRowRange = (XColumnRowRange)
140cdf0e10cSrcweir                 UnoRuntime.queryInterface(XColumnRowRange.class, oSheet);
141cdf0e10cSrcweir             XTableColumns oColumns = (XTableColumns) oColumnRowRange.getColumns();
142cdf0e10cSrcweir             XIndexAccess oIndexAccess = (XIndexAccess)
143cdf0e10cSrcweir                 UnoRuntime.queryInterface(XIndexAccess.class, oColumns);
144cdf0e10cSrcweir             XPropertySet column = (XPropertySet) UnoRuntime.queryInterface(
145cdf0e10cSrcweir                                 XPropertySet.class,oIndexAccess.getByIndex(1));
146cdf0e10cSrcweir             column.setPropertyValue("OptimalWidth", new Boolean(true));
147cdf0e10cSrcweir         } catch(com.sun.star.lang.WrappedTargetException e) {
148cdf0e10cSrcweir             log.println("Exception ceating relation :");
149cdf0e10cSrcweir             e.printStackTrace(log);
150cdf0e10cSrcweir         } catch(com.sun.star.lang.IndexOutOfBoundsException e) {
151cdf0e10cSrcweir             log.println("Exception ceating relation :");
152cdf0e10cSrcweir             e.printStackTrace(log);
153cdf0e10cSrcweir         } catch(com.sun.star.beans.UnknownPropertyException e) {
154cdf0e10cSrcweir             log.println("Exception ceating relation :");
155cdf0e10cSrcweir             e.printStackTrace(log);
156cdf0e10cSrcweir         } catch(com.sun.star.beans.PropertyVetoException e) {
157cdf0e10cSrcweir             log.println("Exception ceating relation :");
158cdf0e10cSrcweir             e.printStackTrace(log);
159cdf0e10cSrcweir         } catch(com.sun.star.lang.IllegalArgumentException e) {
160cdf0e10cSrcweir             log.println("Exception ceating relation :");
161cdf0e10cSrcweir             e.printStackTrace(log);
162cdf0e10cSrcweir         }
163cdf0e10cSrcweir 
164cdf0e10cSrcweir         tEnv.addObjRelation("EditOnly",
165cdf0e10cSrcweir                     "This method is only supported if the Cell is in edit mode");
166cdf0e10cSrcweir 
167cdf0e10cSrcweir         final XCell fCell = xCell ;
168cdf0e10cSrcweir 
169cdf0e10cSrcweir         tEnv.addObjRelation("EventProducer",
170cdf0e10cSrcweir             new ifc.accessibility._XAccessibleEventBroadcaster.EventProducer(){
171cdf0e10cSrcweir                 public void fireEvent() {
172cdf0e10cSrcweir                     fCell.setFormula("firing event");
173cdf0e10cSrcweir                     fCell.setFormula(text);
174cdf0e10cSrcweir                 }
175cdf0e10cSrcweir             });
176cdf0e10cSrcweir 
177cdf0e10cSrcweir         tEnv.addObjRelation("XAccessibleText.Text", text);
178cdf0e10cSrcweir 
179cdf0e10cSrcweir         return tEnv;
180cdf0e10cSrcweir 
181cdf0e10cSrcweir     }
182cdf0e10cSrcweir 
183cdf0e10cSrcweir     /**
184cdf0e10cSrcweir     * Called while disposing a <code>TestEnvironment</code>.
185cdf0e10cSrcweir     * Disposes calc document.
186cdf0e10cSrcweir     * @param tParam test parameters
187cdf0e10cSrcweir     * @param tEnv the environment to cleanup
188cdf0e10cSrcweir     * @param log writer to log information while testing
189cdf0e10cSrcweir     */
190cdf0e10cSrcweir     protected void cleanup( TestParameters Param, PrintWriter log) {
191cdf0e10cSrcweir         log.println( "    disposing xSheetDoc " );
192cdf0e10cSrcweir         XComponent oComp = (XComponent)
193cdf0e10cSrcweir             UnoRuntime.queryInterface (XComponent.class, xSpreadsheetDoc) ;
194cdf0e10cSrcweir         util.DesktopTools.closeDoc(oComp);
195cdf0e10cSrcweir     }
196cdf0e10cSrcweir }