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.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.uno.UnoRuntime;
40cdf0e10cSrcweir import com.sun.star.uno.XInterface;
41cdf0e10cSrcweir 
42cdf0e10cSrcweir /**
43cdf0e10cSrcweir * Test for object which is represented by service
44cdf0e10cSrcweir * <code>com.sun.star.sheet.Spreadsheets</code>. <p>
45cdf0e10cSrcweir * Object implements the following interfaces :
46cdf0e10cSrcweir * <ul>
47cdf0e10cSrcweir *  <li> <code>com::sun::star::sheet::XSpreadsheets</code></li>
48cdf0e10cSrcweir *  <li> <code>com::sun::star::container::XNameAccess</code></li>
49cdf0e10cSrcweir *  <li> <code>com::sun::star::container::XIndexAccess</code></li>
50cdf0e10cSrcweir *  <li> <code>com::sun::star::container::XElementAccess</code></li>
51cdf0e10cSrcweir *  <li> <code>com::sun::star::container::XNameReplace</code></li>
52cdf0e10cSrcweir *  <li> <code>com::sun::star::container::XNameContainer</code></li>
53cdf0e10cSrcweir * </ul>
54cdf0e10cSrcweir * @see com.sun.star.sheet.Spreadsheets
55cdf0e10cSrcweir * @see com.sun.star.sheet.XSpreadsheets
56cdf0e10cSrcweir * @see com.sun.star.container.XNameAccess
57cdf0e10cSrcweir * @see com.sun.star.container.XIndexAccess
58cdf0e10cSrcweir * @see com.sun.star.container.XElementAccess
59cdf0e10cSrcweir * @see com.sun.star.container.XNameReplace
60cdf0e10cSrcweir * @see com.sun.star.container.XNameContainer
61cdf0e10cSrcweir * @see ifc.sheet._XSpreadsheets
62cdf0e10cSrcweir * @see ifc.container._XNameAccess
63cdf0e10cSrcweir * @see ifc.container._XIndexAccess
64cdf0e10cSrcweir * @see ifc.container._XElementAccess
65cdf0e10cSrcweir * @see ifc.container._XNameReplace
66cdf0e10cSrcweir * @see ifc.container._XNameContainer
67cdf0e10cSrcweir */
68cdf0e10cSrcweir public class ScTableSheetsObj extends TestCase {
69cdf0e10cSrcweir     private static XSpreadsheetDocument xSpreadsheetDoc = null;
70cdf0e10cSrcweir 
71cdf0e10cSrcweir     /**
72cdf0e10cSrcweir     * Creates Spreadsheet document.
73cdf0e10cSrcweir     */
initialize( TestParameters Param, PrintWriter log )74cdf0e10cSrcweir     public void initialize( TestParameters Param, PrintWriter log ) {
75cdf0e10cSrcweir         // get a soffice factory object
76cdf0e10cSrcweir 
77cdf0e10cSrcweir         SOfficeFactory SOF = SOfficeFactory.getFactory( (XMultiServiceFactory)Param.getMSF());
78cdf0e10cSrcweir         try {
79cdf0e10cSrcweir             log.println("creating a spreadsheetdocument");
80cdf0e10cSrcweir             xSpreadsheetDoc = SOF.createCalcDoc(null);
81cdf0e10cSrcweir         } catch (com.sun.star.uno.Exception e) {
82cdf0e10cSrcweir             e.printStackTrace( log );
83cdf0e10cSrcweir             throw new StatusException( "Couldn't create document ", e );
84cdf0e10cSrcweir         }
85cdf0e10cSrcweir     }
86cdf0e10cSrcweir 
87cdf0e10cSrcweir     /**
88cdf0e10cSrcweir     * Disposes Spreadsheet document.
89cdf0e10cSrcweir     */
cleanup( TestParameters tParam, PrintWriter log )90cdf0e10cSrcweir     protected void cleanup( TestParameters tParam, PrintWriter log ) {
91cdf0e10cSrcweir         log.println("disposing xSpreadsheetDocument");
92cdf0e10cSrcweir         XComponent oComp = (XComponent)
93cdf0e10cSrcweir             UnoRuntime.queryInterface(XComponent.class, xSpreadsheetDoc);
94cdf0e10cSrcweir         util.DesktopTools.closeDoc(oComp);
95cdf0e10cSrcweir     }
96cdf0e10cSrcweir 
97cdf0e10cSrcweir     /**
98cdf0e10cSrcweir     * Creating a Testenvironment for the interfaces to be tested.
99cdf0e10cSrcweir     * Retrieves the collection of the spreadsheets using the interface
100cdf0e10cSrcweir     * <code>XSpreadsheetDocument</code>. The retrieved collection is the
101cdf0e10cSrcweir     * instance of the service <code>com.sun.star.sheet.Spreadsheets</code>.
102cdf0e10cSrcweir     * Creates instances of the service <code>com.sun.star.sheet.Spreadsheet</code>.
103cdf0e10cSrcweir     * Object relations created :
104cdf0e10cSrcweir     * <ul>
105cdf0e10cSrcweir     *  <li> <code>'SecondInstance'</code> for
106cdf0e10cSrcweir     *      {@link ifc.container._XNameContainer} (the created instance of the
107cdf0e10cSrcweir     *       service <code>com.sun.star.sheet.Spreadsheet</code>) </li>
108cdf0e10cSrcweir     *  <li> <code>'INSTANCE1', ..., 'INSTANCEN'</code> for
109cdf0e10cSrcweir     *      {@link ifc.container._XNameContainer} (the created instances of the
110cdf0e10cSrcweir     *       service <code>com.sun.star.sheet.Spreadsheet</code>) </li>
111cdf0e10cSrcweir     * </ul>
112cdf0e10cSrcweir     * @see com.sun.star.sheet.Spreadsheets
113cdf0e10cSrcweir     * @see com.sun.star.sheet.XSpreadsheetDocument
114cdf0e10cSrcweir     * @see com.sun.star.sheet.Spreadsheet
115cdf0e10cSrcweir     */
createTestEnvironment(TestParameters Param, PrintWriter log)116cdf0e10cSrcweir     protected TestEnvironment createTestEnvironment(TestParameters Param, PrintWriter log) {
117cdf0e10cSrcweir 
118cdf0e10cSrcweir         SOfficeFactory SOF = SOfficeFactory.getFactory( (XMultiServiceFactory)Param.getMSF());
119cdf0e10cSrcweir 
120cdf0e10cSrcweir         log.println("getting sheets");
121cdf0e10cSrcweir         XSpreadsheets xSpreadsheets = (XSpreadsheets)xSpreadsheetDoc.getSheets();
122cdf0e10cSrcweir 
123cdf0e10cSrcweir         XInterface oObj = (XInterface)
124cdf0e10cSrcweir             UnoRuntime.queryInterface(XInterface.class, xSpreadsheets);
125cdf0e10cSrcweir 
126cdf0e10cSrcweir         log.println("creating a new environment for object");
127cdf0e10cSrcweir         TestEnvironment tEnv = new TestEnvironment(oObj);
128cdf0e10cSrcweir 
129cdf0e10cSrcweir         log.println("creating instance of the sheet object to use it in tests");
130cdf0e10cSrcweir         XSpreadsheet oSecondSheet = null;
131cdf0e10cSrcweir 
132cdf0e10cSrcweir         try {
133cdf0e10cSrcweir             oSecondSheet = SOF.createSpreadsheet(xSpreadsheetDoc);
134cdf0e10cSrcweir         } catch (com.sun.star.uno.Exception e) {
135cdf0e10cSrcweir             e.printStackTrace(log);
136cdf0e10cSrcweir             throw new StatusException("Couldn't create instances", e);
137cdf0e10cSrcweir         }
138cdf0e10cSrcweir 
139cdf0e10cSrcweir         //adding Instance for XNameContainer
140cdf0e10cSrcweir         tEnv.addObjRelation("SecondInstance",oSecondSheet);
141cdf0e10cSrcweir 
142cdf0e10cSrcweir         // INSTANCEn : _XNameContainer; _XNameReplace
143cdf0e10cSrcweir         log.println( "adding INSTANCEn as mod relation to environment" );
144cdf0e10cSrcweir 
145cdf0e10cSrcweir         int THRCNT = 1;
146cdf0e10cSrcweir         if ((String)Param.get("THRCNT") != null) {
147cdf0e10cSrcweir             THRCNT = Integer.parseInt((String)Param.get("THRCNT"));
148cdf0e10cSrcweir         }
149cdf0e10cSrcweir         try {
150cdf0e10cSrcweir             for (int n = 1; n < (THRCNT+1) ;n++ ) {
151cdf0e10cSrcweir                 log.println(
152cdf0e10cSrcweir                     "adding INSTANCE" + n +" as mod relation to environment" );
153cdf0e10cSrcweir                 tEnv.addObjRelation(
154cdf0e10cSrcweir                     "INSTANCE" + n,
155cdf0e10cSrcweir                     SOF.createSpreadsheet(xSpreadsheetDoc) );
156cdf0e10cSrcweir                 }
157cdf0e10cSrcweir         } catch (com.sun.star.uno.Exception e) {
158cdf0e10cSrcweir             e.printStackTrace(log);
159cdf0e10cSrcweir             throw new StatusException(
160cdf0e10cSrcweir                 "Couldn't create instances for object relations", e);
161cdf0e10cSrcweir         }
162cdf0e10cSrcweir 
163cdf0e10cSrcweir         return tEnv;
164cdf0e10cSrcweir     }
165cdf0e10cSrcweir }
166cdf0e10cSrcweir 
167cdf0e10cSrcweir 
168