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