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 ifc.table;
25*b1cdbd2cSJim Jagielski 
26*b1cdbd2cSJim Jagielski import lib.MultiMethodTest;
27*b1cdbd2cSJim Jagielski 
28*b1cdbd2cSJim Jagielski import com.sun.star.table.XCell;
29*b1cdbd2cSJim Jagielski import com.sun.star.table.XCellRange;
30*b1cdbd2cSJim Jagielski 
31*b1cdbd2cSJim Jagielski /**
32*b1cdbd2cSJim Jagielski * Testing <code>com.sun.star.table.XCellRange</code>
33*b1cdbd2cSJim Jagielski * interface methods :
34*b1cdbd2cSJim Jagielski * <ul>
35*b1cdbd2cSJim Jagielski *  <li><code> getCellByPosition()</code></li>
36*b1cdbd2cSJim Jagielski *  <li><code> getCellRangeByPosition()</code></li>
37*b1cdbd2cSJim Jagielski *  <li><code> getCellRangeByName()</code></li>
38*b1cdbd2cSJim Jagielski * </ul> <p>
39*b1cdbd2cSJim Jagielski * This test needs the following object relations :
40*b1cdbd2cSJim Jagielski * <ul>
41*b1cdbd2cSJim Jagielski *  <li> <code>'ValidRange'</code> (of type <code>String</code>):
42*b1cdbd2cSJim Jagielski *   cell range that can be defined by the object test instead of
43*b1cdbd2cSJim Jagielski *   definition at this test ("<code>A1:A1</code>")</li>
44*b1cdbd2cSJim Jagielski * </ul> <p>
45*b1cdbd2cSJim Jagielski * Test is <b> NOT </b> multithread compilant. <p>
46*b1cdbd2cSJim Jagielski * @see com.sun.star.table.XCellRange
47*b1cdbd2cSJim Jagielski */
48*b1cdbd2cSJim Jagielski public class _XCellRange extends MultiMethodTest {
49*b1cdbd2cSJim Jagielski     public XCellRange oObj = null;
50*b1cdbd2cSJim Jagielski 
51*b1cdbd2cSJim Jagielski     /**
52*b1cdbd2cSJim Jagielski      * First a cell get from valid position, second - from invalid. <p>
53*b1cdbd2cSJim Jagielski      * Has <b> OK </b> status if in the first case not null value is
54*b1cdbd2cSJim Jagielski      * returned and no exceptions are thrown, and in the second
55*b1cdbd2cSJim Jagielski      * case <code>IndexOutOfBoundsException</code> is thrown. <p>
56*b1cdbd2cSJim Jagielski      */
_getCellByPosition()57*b1cdbd2cSJim Jagielski     public void _getCellByPosition() {
58*b1cdbd2cSJim Jagielski 
59*b1cdbd2cSJim Jagielski         boolean result = false;
60*b1cdbd2cSJim Jagielski 
61*b1cdbd2cSJim Jagielski         try {
62*b1cdbd2cSJim Jagielski             XCell cell = oObj.getCellByPosition(0,0);
63*b1cdbd2cSJim Jagielski             result = cell != null ;
64*b1cdbd2cSJim Jagielski             log.println("Getting cell by position with a valid position ... OK");
65*b1cdbd2cSJim Jagielski         } catch (com.sun.star.lang.IndexOutOfBoundsException e) {
66*b1cdbd2cSJim Jagielski             log.println("Exception occurred while getting cell by position with a valid position");
67*b1cdbd2cSJim Jagielski             e.printStackTrace(log);
68*b1cdbd2cSJim Jagielski             result = false;
69*b1cdbd2cSJim Jagielski         }
70*b1cdbd2cSJim Jagielski 
71*b1cdbd2cSJim Jagielski         try {
72*b1cdbd2cSJim Jagielski             oObj.getCellByPosition(-1,1);
73*b1cdbd2cSJim Jagielski             log.println("No Exception occurred while getting cell by position with invalid position");
74*b1cdbd2cSJim Jagielski             result &= false;
75*b1cdbd2cSJim Jagielski         } catch (com.sun.star.lang.IndexOutOfBoundsException e) {
76*b1cdbd2cSJim Jagielski             log.println("Getting cell by position with a invalid position ... OK");
77*b1cdbd2cSJim Jagielski             result &= true;
78*b1cdbd2cSJim Jagielski         }
79*b1cdbd2cSJim Jagielski 
80*b1cdbd2cSJim Jagielski         tRes.tested( "getCellByPosition()", result );
81*b1cdbd2cSJim Jagielski 
82*b1cdbd2cSJim Jagielski     } // end getCellByPosition()
83*b1cdbd2cSJim Jagielski 
84*b1cdbd2cSJim Jagielski     /**
85*b1cdbd2cSJim Jagielski      * A range is tried to obtain with valid name. <p>
86*b1cdbd2cSJim Jagielski      * Has <b> OK </b> status if not null range is
87*b1cdbd2cSJim Jagielski      * returned. <p>
88*b1cdbd2cSJim Jagielski      */
_getCellRangeByName()89*b1cdbd2cSJim Jagielski     public void _getCellRangeByName() {
90*b1cdbd2cSJim Jagielski 
91*b1cdbd2cSJim Jagielski         boolean result = false;
92*b1cdbd2cSJim Jagielski 
93*b1cdbd2cSJim Jagielski         String valid = (String) tEnv.getObjRelation("ValidRange");
94*b1cdbd2cSJim Jagielski         if (valid == null ) valid = "A1:A1";
95*b1cdbd2cSJim Jagielski         XCellRange range = oObj.getCellRangeByName(valid);
96*b1cdbd2cSJim Jagielski         result = range != null ;
97*b1cdbd2cSJim Jagielski         log.println("Getting cellrange by name with a valid name ... OK");
98*b1cdbd2cSJim Jagielski 
99*b1cdbd2cSJim Jagielski         tRes.tested( "getCellRangeByName()", result );
100*b1cdbd2cSJim Jagielski 
101*b1cdbd2cSJim Jagielski 
102*b1cdbd2cSJim Jagielski     } // end getCellRangeByName()
103*b1cdbd2cSJim Jagielski 
104*b1cdbd2cSJim Jagielski     /**
105*b1cdbd2cSJim Jagielski      * First a range is tried to obtain with valid bounds,
106*b1cdbd2cSJim Jagielski      * second - with invalid. <p>
107*b1cdbd2cSJim Jagielski      * Has <b> OK </b> status if in the first case not null range is
108*b1cdbd2cSJim Jagielski      * returned and no exceptions are thrown, and in the second
109*b1cdbd2cSJim Jagielski      * case <code>IndexOutOfBoundsException</code> is thrown. <p>
110*b1cdbd2cSJim Jagielski      */
_getCellRangeByPosition()111*b1cdbd2cSJim Jagielski     public void _getCellRangeByPosition() {
112*b1cdbd2cSJim Jagielski 
113*b1cdbd2cSJim Jagielski         boolean result = false;
114*b1cdbd2cSJim Jagielski 
115*b1cdbd2cSJim Jagielski         try {
116*b1cdbd2cSJim Jagielski             XCellRange range = oObj.getCellRangeByPosition(0,0,0,0);
117*b1cdbd2cSJim Jagielski             result = range != null;
118*b1cdbd2cSJim Jagielski             log.println("Getting cellrange by Position with a valid position ... OK");
119*b1cdbd2cSJim Jagielski         } catch (com.sun.star.lang.IndexOutOfBoundsException e) {
120*b1cdbd2cSJim Jagielski             log.println("Exception occurred while getting cellrange by position with a valid position");
121*b1cdbd2cSJim Jagielski             e.printStackTrace(log);
122*b1cdbd2cSJim Jagielski             result = false;
123*b1cdbd2cSJim Jagielski         }
124*b1cdbd2cSJim Jagielski 
125*b1cdbd2cSJim Jagielski         try {
126*b1cdbd2cSJim Jagielski             oObj.getCellRangeByPosition(-1,0,-1,1);
127*b1cdbd2cSJim Jagielski             log.println("No Exception occurred while getting cellrange by position with invalid position");
128*b1cdbd2cSJim Jagielski             result &= false;
129*b1cdbd2cSJim Jagielski         } catch (com.sun.star.lang.IndexOutOfBoundsException e) {
130*b1cdbd2cSJim Jagielski             log.println("Getting cellrange by position with a invalid position ... OK");
131*b1cdbd2cSJim Jagielski             result &= true;
132*b1cdbd2cSJim Jagielski         }
133*b1cdbd2cSJim Jagielski 
134*b1cdbd2cSJim Jagielski         tRes.tested( "getCellRangeByPosition()", result );
135*b1cdbd2cSJim Jagielski 
136*b1cdbd2cSJim Jagielski 
137*b1cdbd2cSJim Jagielski     } // end getCellRangeByPosition()
138*b1cdbd2cSJim Jagielski 
139*b1cdbd2cSJim Jagielski     /**
140*b1cdbd2cSJim Jagielski     * Forces environment recreation.
141*b1cdbd2cSJim Jagielski     */
after()142*b1cdbd2cSJim Jagielski     protected void after() {
143*b1cdbd2cSJim Jagielski         disposeEnvironment();
144*b1cdbd2cSJim Jagielski     }
145*b1cdbd2cSJim Jagielski 
146*b1cdbd2cSJim Jagielski } // finish class _XCellRange
147*b1cdbd2cSJim Jagielski 
148