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.SOfficeFactory;
33*b1cdbd2cSJim Jagielski 
34*b1cdbd2cSJim Jagielski import com.sun.star.container.XIndexAccess;
35*b1cdbd2cSJim Jagielski import com.sun.star.lang.XComponent;
36*b1cdbd2cSJim Jagielski import com.sun.star.lang.XMultiServiceFactory;
37*b1cdbd2cSJim Jagielski import com.sun.star.sheet.XSheetAnnotation;
38*b1cdbd2cSJim Jagielski import com.sun.star.sheet.XSheetAnnotationAnchor;
39*b1cdbd2cSJim Jagielski import com.sun.star.sheet.XSpreadsheet;
40*b1cdbd2cSJim Jagielski import com.sun.star.sheet.XSpreadsheetDocument;
41*b1cdbd2cSJim Jagielski import com.sun.star.sheet.XSpreadsheets;
42*b1cdbd2cSJim Jagielski import com.sun.star.table.CellAddress;
43*b1cdbd2cSJim Jagielski import com.sun.star.table.XCell;
44*b1cdbd2cSJim Jagielski import com.sun.star.table.XCellRange;
45*b1cdbd2cSJim Jagielski import com.sun.star.uno.AnyConverter;
46*b1cdbd2cSJim Jagielski import com.sun.star.uno.Type;
47*b1cdbd2cSJim Jagielski import com.sun.star.uno.UnoRuntime;
48*b1cdbd2cSJim Jagielski import com.sun.star.uno.XInterface;
49*b1cdbd2cSJim Jagielski 
50*b1cdbd2cSJim Jagielski /**
51*b1cdbd2cSJim Jagielski * Test for object which represents some text annotation
52*b1cdbd2cSJim Jagielski * anchored to some cell in spreadsheet (implement
53*b1cdbd2cSJim Jagielski * <code>com.sun.star.sheet.CellAnnotation</code>).<p>
54*b1cdbd2cSJim Jagielski * Object implements the following interfaces :
55*b1cdbd2cSJim Jagielski * <ul>
56*b1cdbd2cSJim Jagielski *  <li> <code>com::sun::star::text::XSimpleText</code></li>
57*b1cdbd2cSJim Jagielski *  <li> <code>com::sun::star::text::XTextRange</code></li>
58*b1cdbd2cSJim Jagielski *  <li> <code>com::sun::star::sheet::XSheetAnnotation</code></li>
59*b1cdbd2cSJim Jagielski * </ul>
60*b1cdbd2cSJim Jagielski * This object test <b> is NOT </b> designed to be run in several
61*b1cdbd2cSJim Jagielski * threads concurently.
62*b1cdbd2cSJim Jagielski * @see com.sun.star.sheet.CellAnnotation
63*b1cdbd2cSJim Jagielski * @see com.sun.star.text.XSimpleText
64*b1cdbd2cSJim Jagielski * @see com.sun.star.text.XTextRange
65*b1cdbd2cSJim Jagielski * @see com.sun.star.sheet.XSheetAnnotation
66*b1cdbd2cSJim Jagielski * @see ifc.text._XSimpleText
67*b1cdbd2cSJim Jagielski * @see ifc.text._XTextRange
68*b1cdbd2cSJim Jagielski * @see ifc.sheet._XSheetAnnotation
69*b1cdbd2cSJim Jagielski */
70*b1cdbd2cSJim Jagielski public class ScAnnotationObj extends TestCase {
71*b1cdbd2cSJim Jagielski     static XSpreadsheetDocument xSheetDoc = null;
72*b1cdbd2cSJim Jagielski 
73*b1cdbd2cSJim Jagielski     /**
74*b1cdbd2cSJim Jagielski     * Creates a spreadsheet document.
75*b1cdbd2cSJim Jagielski     */
initialize( TestParameters tParam, PrintWriter log )76*b1cdbd2cSJim Jagielski     protected void initialize( TestParameters tParam, PrintWriter log ) {
77*b1cdbd2cSJim Jagielski         SOfficeFactory SOF = SOfficeFactory.getFactory( (XMultiServiceFactory)tParam.getMSF() );
78*b1cdbd2cSJim Jagielski 
79*b1cdbd2cSJim Jagielski         try {
80*b1cdbd2cSJim Jagielski             log.println( "creating a Spreadsheet document" );
81*b1cdbd2cSJim Jagielski             xSheetDoc = SOF.createCalcDoc(null);
82*b1cdbd2cSJim Jagielski         } catch ( com.sun.star.uno.Exception e ) {
83*b1cdbd2cSJim Jagielski             // Some exception occures.FAILED
84*b1cdbd2cSJim Jagielski             e.printStackTrace( log );
85*b1cdbd2cSJim Jagielski             throw new StatusException( "Couldn't create document", e );
86*b1cdbd2cSJim Jagielski         }
87*b1cdbd2cSJim Jagielski 
88*b1cdbd2cSJim Jagielski     }
89*b1cdbd2cSJim Jagielski 
90*b1cdbd2cSJim Jagielski     /**
91*b1cdbd2cSJim Jagielski     * Disposes a spreadsheet document.
92*b1cdbd2cSJim Jagielski     */
cleanup( TestParameters tParam, PrintWriter log )93*b1cdbd2cSJim Jagielski     protected void cleanup( TestParameters tParam, PrintWriter log ) {
94*b1cdbd2cSJim Jagielski         log.println( "    disposing xSheetDoc " );
95*b1cdbd2cSJim Jagielski         XComponent oComp = (XComponent) UnoRuntime.queryInterface
96*b1cdbd2cSJim Jagielski             (XComponent.class, xSheetDoc) ;
97*b1cdbd2cSJim Jagielski         util.DesktopTools.closeDoc(oComp);
98*b1cdbd2cSJim Jagielski     }
99*b1cdbd2cSJim Jagielski 
100*b1cdbd2cSJim Jagielski 
101*b1cdbd2cSJim Jagielski     /**
102*b1cdbd2cSJim Jagielski     * Creating a Testenvironment for the interfaces to be tested.
103*b1cdbd2cSJim Jagielski     * Retrieves a collection of spreadsheets from a document,
104*b1cdbd2cSJim Jagielski     * and takes one them. Then a single cell is retrieved, and
105*b1cdbd2cSJim Jagielski     * using its <code>com.sun.star.sheet.XSheetAnnotationAnchor</code>
106*b1cdbd2cSJim Jagielski     * interface an annotation is got.
107*b1cdbd2cSJim Jagielski     * Object relations created :
108*b1cdbd2cSJim Jagielski     * <ul>
109*b1cdbd2cSJim Jagielski     *  <li> <code>'CELLPOS'</code> for
110*b1cdbd2cSJim Jagielski     *      {@link ifc.sheet._XSheetAnnotation} (of <code>
111*b1cdbd2cSJim Jagielski     *       com.sun.star.table.CellAddress</code> type) which
112*b1cdbd2cSJim Jagielski     *      contains the annotation cell address.</li>
113*b1cdbd2cSJim Jagielski     * </ul>
114*b1cdbd2cSJim Jagielski     */
createTestEnvironment( TestParameters Param, PrintWriter log )115*b1cdbd2cSJim Jagielski     public synchronized TestEnvironment createTestEnvironment
116*b1cdbd2cSJim Jagielski             ( TestParameters Param, PrintWriter log )
117*b1cdbd2cSJim Jagielski             throws StatusException {
118*b1cdbd2cSJim Jagielski 
119*b1cdbd2cSJim Jagielski         XInterface oObj = null;
120*b1cdbd2cSJim Jagielski 
121*b1cdbd2cSJim Jagielski 
122*b1cdbd2cSJim Jagielski         // creation of testobject here
123*b1cdbd2cSJim Jagielski         // first we write what we are intend to do to log file
124*b1cdbd2cSJim Jagielski         log.println( "Creating a test environment" );
125*b1cdbd2cSJim Jagielski 
126*b1cdbd2cSJim Jagielski         CellAddress cellPos = new CellAddress((short)0, 1, 2);
127*b1cdbd2cSJim Jagielski 
128*b1cdbd2cSJim Jagielski         log.println("Getting test object ") ;
129*b1cdbd2cSJim Jagielski 
130*b1cdbd2cSJim Jagielski         XSpreadsheetDocument xArea = (XSpreadsheetDocument)
131*b1cdbd2cSJim Jagielski             UnoRuntime.queryInterface(XSpreadsheetDocument.class, xSheetDoc);
132*b1cdbd2cSJim Jagielski         XSpreadsheets oSheets = (XSpreadsheets) xArea.getSheets();
133*b1cdbd2cSJim Jagielski 
134*b1cdbd2cSJim Jagielski         XIndexAccess XAccess = (XIndexAccess)
135*b1cdbd2cSJim Jagielski             UnoRuntime.queryInterface(XIndexAccess.class, oSheets);
136*b1cdbd2cSJim Jagielski         XCell oCell = null;
137*b1cdbd2cSJim Jagielski         try {
138*b1cdbd2cSJim Jagielski             XSpreadsheet oSheet = (XSpreadsheet) AnyConverter.toObject(
139*b1cdbd2cSJim Jagielski                     new Type(XSpreadsheet.class),XAccess.getByIndex(cellPos.Sheet));
140*b1cdbd2cSJim Jagielski             XCellRange oCRange = (XCellRange)
141*b1cdbd2cSJim Jagielski                 UnoRuntime.queryInterface(XCellRange.class, oSheet);
142*b1cdbd2cSJim Jagielski             oCell = oCRange.getCellByPosition(cellPos.Column, cellPos.Row);
143*b1cdbd2cSJim Jagielski         } catch(com.sun.star.lang.WrappedTargetException e) {
144*b1cdbd2cSJim Jagielski             e.printStackTrace(log);
145*b1cdbd2cSJim Jagielski             throw new StatusException(
146*b1cdbd2cSJim Jagielski                 "Error getting test object from spreadsheet document",e);
147*b1cdbd2cSJim Jagielski         } catch(com.sun.star.lang.IndexOutOfBoundsException e) {
148*b1cdbd2cSJim Jagielski             e.printStackTrace(log);
149*b1cdbd2cSJim Jagielski             throw new StatusException(
150*b1cdbd2cSJim Jagielski                 "Error getting test object from spreadsheet document",e);
151*b1cdbd2cSJim Jagielski         } catch(com.sun.star.lang.IllegalArgumentException e) {
152*b1cdbd2cSJim Jagielski             e.printStackTrace(log);
153*b1cdbd2cSJim Jagielski             throw new StatusException(
154*b1cdbd2cSJim Jagielski                 "Error getting test object from spreadsheet document",e);
155*b1cdbd2cSJim Jagielski         }
156*b1cdbd2cSJim Jagielski 
157*b1cdbd2cSJim Jagielski         XSheetAnnotationAnchor oAnnoA = (XSheetAnnotationAnchor)
158*b1cdbd2cSJim Jagielski             UnoRuntime.queryInterface(XSheetAnnotationAnchor.class, oCell);
159*b1cdbd2cSJim Jagielski         XSheetAnnotation oAnno = oAnnoA.getAnnotation();
160*b1cdbd2cSJim Jagielski 
161*b1cdbd2cSJim Jagielski         oObj = oAnno;
162*b1cdbd2cSJim Jagielski 
163*b1cdbd2cSJim Jagielski         TestEnvironment tEnv = new TestEnvironment( oObj );
164*b1cdbd2cSJim Jagielski 
165*b1cdbd2cSJim Jagielski         tEnv.addObjRelation("CELLPOS", cellPos);
166*b1cdbd2cSJim Jagielski 
167*b1cdbd2cSJim Jagielski         // Other parameters required for interface tests
168*b1cdbd2cSJim Jagielski 
169*b1cdbd2cSJim Jagielski         return tEnv;
170*b1cdbd2cSJim Jagielski     }
171*b1cdbd2cSJim Jagielski 
172*b1cdbd2cSJim Jagielski }    // finish class ScAnnotationObj
173*b1cdbd2cSJim Jagielski 
174*b1cdbd2cSJim Jagielski 
175