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