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 package mod._sc;
24cdf0e10cSrcweir 
25cdf0e10cSrcweir import java.io.PrintWriter;
26cdf0e10cSrcweir 
27cdf0e10cSrcweir import lib.StatusException;
28cdf0e10cSrcweir import lib.TestCase;
29cdf0e10cSrcweir import lib.TestEnvironment;
30cdf0e10cSrcweir import lib.TestParameters;
31cdf0e10cSrcweir import util.SOfficeFactory;
32cdf0e10cSrcweir 
33cdf0e10cSrcweir import com.sun.star.container.XIndexAccess;
34cdf0e10cSrcweir import com.sun.star.lang.XComponent;
35cdf0e10cSrcweir import com.sun.star.lang.XMultiServiceFactory;
36cdf0e10cSrcweir import com.sun.star.sheet.XSpreadsheet;
37cdf0e10cSrcweir import com.sun.star.sheet.XSpreadsheetDocument;
38cdf0e10cSrcweir import com.sun.star.sheet.XSpreadsheets;
39cdf0e10cSrcweir import com.sun.star.table.XCell;
40cdf0e10cSrcweir import com.sun.star.text.XText;
41cdf0e10cSrcweir import com.sun.star.text.XTextContent;
42cdf0e10cSrcweir import com.sun.star.text.XTextFieldsSupplier;
43cdf0e10cSrcweir import com.sun.star.uno.AnyConverter;
44cdf0e10cSrcweir import com.sun.star.uno.Type;
45cdf0e10cSrcweir import com.sun.star.uno.UnoRuntime;
46cdf0e10cSrcweir import com.sun.star.uno.XInterface;
47cdf0e10cSrcweir 
48cdf0e10cSrcweir /**
49cdf0e10cSrcweir  * Test for object that represents a colection of text fields
50cdf0e10cSrcweir  * in a cell of a spreadsheet. <p>
51cdf0e10cSrcweir  *
52cdf0e10cSrcweir  * Object implements the following interfaces :
53cdf0e10cSrcweir  * <ul>
54cdf0e10cSrcweir  *  <li> <code>com::sun::star::container::XEnumerationAccess</code></li>
55cdf0e10cSrcweir  *  <li> <code>com::sun::star::util::XRefreshable</code></li>
56cdf0e10cSrcweir  *  <li> <code>com::sun::star::container::XElementAccess</code></li>
57cdf0e10cSrcweir  * </ul> <p>
58cdf0e10cSrcweir  *
59cdf0e10cSrcweir  * @see com.sun.star.container.XEnumerationAccess
60cdf0e10cSrcweir  * @see com.sun.star.util.XRefreshable
61cdf0e10cSrcweir  * @see com.sun.star.container.XElementAccess
62cdf0e10cSrcweir  * @see ifc.container._XEnumerationAccess
63cdf0e10cSrcweir  * @see ifc.util._XRefreshable
64cdf0e10cSrcweir  * @see ifc.container._XElementAccess
65cdf0e10cSrcweir  */
66cdf0e10cSrcweir public class ScCellFieldsObj extends TestCase {
67cdf0e10cSrcweir     static XSpreadsheetDocument xSheetDoc = null;
68cdf0e10cSrcweir 
69cdf0e10cSrcweir     /**
70cdf0e10cSrcweir     * Creates Spreadsheet document.
71cdf0e10cSrcweir     */
initialize( TestParameters tParam, PrintWriter log )72cdf0e10cSrcweir     protected void initialize( TestParameters tParam, PrintWriter log ) {
73cdf0e10cSrcweir         SOfficeFactory SOF = SOfficeFactory.getFactory( (XMultiServiceFactory)tParam.getMSF() );
74cdf0e10cSrcweir 
75cdf0e10cSrcweir         try {
76cdf0e10cSrcweir             log.println( "creating a Spreadsheet document" );
77cdf0e10cSrcweir             xSheetDoc = SOF.createCalcDoc(null);
78cdf0e10cSrcweir         } catch ( com.sun.star.uno.Exception e ) {
79cdf0e10cSrcweir             // Some exception occures.FAILED
80cdf0e10cSrcweir             e.printStackTrace( log );
81cdf0e10cSrcweir             throw new StatusException( "Couldn't create document", e );
82cdf0e10cSrcweir         }
83cdf0e10cSrcweir 
84cdf0e10cSrcweir     }
85cdf0e10cSrcweir 
86cdf0e10cSrcweir     /**
87cdf0e10cSrcweir     * Disposes Spreadsheet document.
88cdf0e10cSrcweir     */
cleanup( TestParameters tParam, PrintWriter log )89cdf0e10cSrcweir     protected void cleanup( TestParameters tParam, PrintWriter log ) {
90cdf0e10cSrcweir         log.println( "    disposing xSheetDoc " );
91cdf0e10cSrcweir         XComponent oComp = (XComponent)
92cdf0e10cSrcweir             UnoRuntime.queryInterface (XComponent.class, xSheetDoc);
93cdf0e10cSrcweir         util.DesktopTools.closeDoc(oComp);
94cdf0e10cSrcweir     }
95cdf0e10cSrcweir 
96cdf0e10cSrcweir     /**
97cdf0e10cSrcweir     * Creating a Testenvironment for the interfaces to be tested.
98cdf0e10cSrcweir     * Creates an instance of the service
99cdf0e10cSrcweir     * <code>com.sun.star.text.TextField.URL</code>, inserts it to the content
100cdf0e10cSrcweir     * of the cell in the spreadsheet. Then the component is obtained
101cdf0e10cSrcweir     * by <code>XTextFieldsSupplier</code> interface  of a cell.<p>
102cdf0e10cSrcweir     */
createTestEnvironment( TestParameters Param, PrintWriter log)103cdf0e10cSrcweir     protected synchronized TestEnvironment createTestEnvironment(
104cdf0e10cSrcweir         TestParameters Param, PrintWriter log) {
105cdf0e10cSrcweir 
106cdf0e10cSrcweir         XInterface oObj = null;
107cdf0e10cSrcweir         XText oText = null;
108cdf0e10cSrcweir         XTextContent oContent = null;
109cdf0e10cSrcweir         XInterface aField = null;
110cdf0e10cSrcweir 
111cdf0e10cSrcweir         try {
112cdf0e10cSrcweir             // we want to create an instance of ScCellFieldObj.
113cdf0e10cSrcweir             // to do this we must get an MultiServiceFactory.
114cdf0e10cSrcweir 
115cdf0e10cSrcweir             XMultiServiceFactory _oMSF = (XMultiServiceFactory)
116cdf0e10cSrcweir                 UnoRuntime.queryInterface(XMultiServiceFactory.class, xSheetDoc);
117cdf0e10cSrcweir 
118cdf0e10cSrcweir             aField = (XInterface)
119cdf0e10cSrcweir                 _oMSF.createInstance("com.sun.star.text.TextField.URL");
120cdf0e10cSrcweir             oContent = (XTextContent)
121cdf0e10cSrcweir                 UnoRuntime.queryInterface(XTextContent.class, aField);
122cdf0e10cSrcweir 
123cdf0e10cSrcweir             XSpreadsheets oSheets = xSheetDoc.getSheets() ;
124cdf0e10cSrcweir             XIndexAccess oIndexSheets = (XIndexAccess)
125cdf0e10cSrcweir                 UnoRuntime.queryInterface(XIndexAccess.class, oSheets);
126cdf0e10cSrcweir             XSpreadsheet oSheet = (XSpreadsheet) AnyConverter.toObject(
127cdf0e10cSrcweir                         new Type(XSpreadsheet.class),oIndexSheets.getByIndex(0));
128cdf0e10cSrcweir 
129cdf0e10cSrcweir             XCell oCell = oSheet.getCellByPosition(2,3);
130cdf0e10cSrcweir             oText = (XText)UnoRuntime.queryInterface(XText.class, oCell);
131cdf0e10cSrcweir 
132cdf0e10cSrcweir             oText.insertTextContent(
133cdf0e10cSrcweir                 oText.createTextCursor(), oContent, true);
134cdf0e10cSrcweir 
135cdf0e10cSrcweir             XTextFieldsSupplier xTextFieldsSupp = (XTextFieldsSupplier)
136cdf0e10cSrcweir                 UnoRuntime.queryInterface(XTextFieldsSupplier.class, oCell);
137cdf0e10cSrcweir 
138cdf0e10cSrcweir             oObj = xTextFieldsSupp.getTextFields();
139cdf0e10cSrcweir         } catch (com.sun.star.lang.WrappedTargetException e) {
140cdf0e10cSrcweir             log.println("Exception occured while creating test Object.");
141cdf0e10cSrcweir             e.printStackTrace(log);
142cdf0e10cSrcweir             throw new StatusException("Couldn't create test object", e);
143cdf0e10cSrcweir         } catch (com.sun.star.lang.IndexOutOfBoundsException e) {
144cdf0e10cSrcweir             log.println("Exception occured while creating test Object.");
145cdf0e10cSrcweir             e.printStackTrace(log);
146cdf0e10cSrcweir             throw new StatusException("Couldn't create test object", e);
147cdf0e10cSrcweir         } catch (com.sun.star.lang.IllegalArgumentException e) {
148cdf0e10cSrcweir             log.println("Exception occured while creating test Object.");
149cdf0e10cSrcweir             e.printStackTrace(log);
150cdf0e10cSrcweir             throw new StatusException("Couldn't create test object", e);
151cdf0e10cSrcweir         } catch (com.sun.star.uno.Exception e) {
152cdf0e10cSrcweir             log.println("Exception occured while creating test Object.");
153cdf0e10cSrcweir             e.printStackTrace(log);
154cdf0e10cSrcweir             throw new StatusException("Couldn't create test object", e);
155cdf0e10cSrcweir         }
156cdf0e10cSrcweir 
157cdf0e10cSrcweir         TestEnvironment tEnv = new TestEnvironment(oObj) ;
158cdf0e10cSrcweir 
159cdf0e10cSrcweir         return tEnv;
160cdf0e10cSrcweir     }
161cdf0e10cSrcweir 
162cdf0e10cSrcweir }
163cdf0e10cSrcweir 
164