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