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.CellContentType; 29*b1cdbd2cSJim Jagielski import com.sun.star.table.XCell; 30*b1cdbd2cSJim Jagielski 31*b1cdbd2cSJim Jagielski 32*b1cdbd2cSJim Jagielski /** 33*b1cdbd2cSJim Jagielski * Testing <code>com.sun.star.table.XCell</code> 34*b1cdbd2cSJim Jagielski * interface methods : 35*b1cdbd2cSJim Jagielski * <ul> 36*b1cdbd2cSJim Jagielski * <li><code> getFormula()</code></li> 37*b1cdbd2cSJim Jagielski * <li><code> setFormula()</code></li> 38*b1cdbd2cSJim Jagielski * <li><code> getValue()</code></li> 39*b1cdbd2cSJim Jagielski * <li><code> setValue()</code></li> 40*b1cdbd2cSJim Jagielski * <li><code> getType()</code></li> 41*b1cdbd2cSJim Jagielski * <li><code> getError()</code></li> 42*b1cdbd2cSJim Jagielski * </ul> <p> 43*b1cdbd2cSJim Jagielski * Test is <b> NOT </b> multithread compilant. <p> 44*b1cdbd2cSJim Jagielski * @see com.sun.star.table.XCell 45*b1cdbd2cSJim Jagielski */ 46*b1cdbd2cSJim Jagielski public class _XCell extends MultiMethodTest { 47*b1cdbd2cSJim Jagielski public XCell oObj = null; 48*b1cdbd2cSJim Jagielski 49*b1cdbd2cSJim Jagielski /** 50*b1cdbd2cSJim Jagielski * First time errors checked when a proper formula is entered. 51*b1cdbd2cSJim Jagielski * Second time an incorrect formula entered and errors are checked.<p> 52*b1cdbd2cSJim Jagielski * Has <b> OK </b> status if in the first case error code 0 returned, 53*b1cdbd2cSJim Jagielski * and in the second case none-zerro code returned. <p> 54*b1cdbd2cSJim Jagielski * The following method tests are to be completed successfully before : 55*b1cdbd2cSJim Jagielski * <ul> 56*b1cdbd2cSJim Jagielski * <li> <code> setFormula() </code> : the method must set proper 57*b1cdbd2cSJim Jagielski * formula into cell, so there must be no errors </li> 58*b1cdbd2cSJim Jagielski * </ul> 59*b1cdbd2cSJim Jagielski */ _getError()60*b1cdbd2cSJim Jagielski public void _getError() { 61*b1cdbd2cSJim Jagielski requiredMethod("setFormula()") ; 62*b1cdbd2cSJim Jagielski 63*b1cdbd2cSJim Jagielski boolean result = true; 64*b1cdbd2cSJim Jagielski 65*b1cdbd2cSJim Jagielski if (oObj.getError() != 0) { 66*b1cdbd2cSJim Jagielski result = false ; 67*b1cdbd2cSJim Jagielski log.println("getError(): Expected error code is 0, but returned " + 68*b1cdbd2cSJim Jagielski oObj.getError()) ; 69*b1cdbd2cSJim Jagielski } 70*b1cdbd2cSJim Jagielski oObj.setFormula("=sqrt(-2)") ; // incorrect formula 71*b1cdbd2cSJim Jagielski if (oObj.getError() == 0) { 72*b1cdbd2cSJim Jagielski result = false ; 73*b1cdbd2cSJim Jagielski log.println("getError(): # Non zero error code expected,"+ 74*b1cdbd2cSJim Jagielski " but 0 returned") ; 75*b1cdbd2cSJim Jagielski } 76*b1cdbd2cSJim Jagielski 77*b1cdbd2cSJim Jagielski tRes.tested("getError()", result); 78*b1cdbd2cSJim Jagielski } // end getError() 79*b1cdbd2cSJim Jagielski 80*b1cdbd2cSJim Jagielski /** 81*b1cdbd2cSJim Jagielski * Sets a formula and then gets it. <p> 82*b1cdbd2cSJim Jagielski * Has <b> OK </b> status if the formula set are the same as get. <p> 83*b1cdbd2cSJim Jagielski */ _getFormula()84*b1cdbd2cSJim Jagielski public void _getFormula() { 85*b1cdbd2cSJim Jagielski boolean result = true; 86*b1cdbd2cSJim Jagielski 87*b1cdbd2cSJim Jagielski String formula = ""; 88*b1cdbd2cSJim Jagielski log.println("getFormula()"); 89*b1cdbd2cSJim Jagielski oObj.setFormula("=2+2"); 90*b1cdbd2cSJim Jagielski 91*b1cdbd2cSJim Jagielski formula = (String) oObj.getFormula(); 92*b1cdbd2cSJim Jagielski 93*b1cdbd2cSJim Jagielski result &= formula.endsWith("2+2"); 94*b1cdbd2cSJim Jagielski tRes.tested("getFormula()", result); 95*b1cdbd2cSJim Jagielski } // end getFormula() 96*b1cdbd2cSJim Jagielski 97*b1cdbd2cSJim Jagielski /** 98*b1cdbd2cSJim Jagielski * Gets the type and check it. <p> 99*b1cdbd2cSJim Jagielski * Has <b> OK </b> status if the type is one of valid values. <p> 100*b1cdbd2cSJim Jagielski */ _getType()101*b1cdbd2cSJim Jagielski public void _getType() { 102*b1cdbd2cSJim Jagielski boolean result = true; 103*b1cdbd2cSJim Jagielski result = true ; 104*b1cdbd2cSJim Jagielski log.println("getType() ..."); 105*b1cdbd2cSJim Jagielski 106*b1cdbd2cSJim Jagielski if(oObj.getType() == CellContentType.EMPTY) result &= true ; 107*b1cdbd2cSJim Jagielski else if (oObj.getType() == CellContentType.VALUE) result &= true ; 108*b1cdbd2cSJim Jagielski else if (oObj.getType() == CellContentType.TEXT) result &= true ; 109*b1cdbd2cSJim Jagielski else if (oObj.getType() == CellContentType.FORMULA) result &= true ; 110*b1cdbd2cSJim Jagielski else result = false; 111*b1cdbd2cSJim Jagielski 112*b1cdbd2cSJim Jagielski tRes.tested ("getType()", result) ; 113*b1cdbd2cSJim Jagielski } // end getType() 114*b1cdbd2cSJim Jagielski 115*b1cdbd2cSJim Jagielski /** 116*b1cdbd2cSJim Jagielski * Test calls the method. <p> 117*b1cdbd2cSJim Jagielski * Has <b> OK </b> status if the method successfully returns 118*b1cdbd2cSJim Jagielski * and no exceptions were thrown. <p> 119*b1cdbd2cSJim Jagielski */ _getValue()120*b1cdbd2cSJim Jagielski public void _getValue() { 121*b1cdbd2cSJim Jagielski boolean result = true; 122*b1cdbd2cSJim Jagielski double value = 0; 123*b1cdbd2cSJim Jagielski log.println("getValue() ..."); 124*b1cdbd2cSJim Jagielski 125*b1cdbd2cSJim Jagielski value = (double) oObj.getValue(); 126*b1cdbd2cSJim Jagielski 127*b1cdbd2cSJim Jagielski tRes.tested("getValue()",result); 128*b1cdbd2cSJim Jagielski } // end getValue() 129*b1cdbd2cSJim Jagielski 130*b1cdbd2cSJim Jagielski /** 131*b1cdbd2cSJim Jagielski * Sets a formula and then gets it. <p> 132*b1cdbd2cSJim Jagielski * Has <b> OK </b> status if the formula set are the same as get. <p> 133*b1cdbd2cSJim Jagielski */ _setFormula()134*b1cdbd2cSJim Jagielski public void _setFormula() { 135*b1cdbd2cSJim Jagielski boolean result = true; 136*b1cdbd2cSJim Jagielski String formula = ""; 137*b1cdbd2cSJim Jagielski log.println("setFormula() ..."); 138*b1cdbd2cSJim Jagielski 139*b1cdbd2cSJim Jagielski oObj.setFormula("=2/6") ; 140*b1cdbd2cSJim Jagielski 141*b1cdbd2cSJim Jagielski formula = (String) oObj.getFormula(); 142*b1cdbd2cSJim Jagielski 143*b1cdbd2cSJim Jagielski result &= formula.endsWith("2/6"); 144*b1cdbd2cSJim Jagielski tRes.tested ("setFormula()", result) ; 145*b1cdbd2cSJim Jagielski } // end setFormula 146*b1cdbd2cSJim Jagielski 147*b1cdbd2cSJim Jagielski /** 148*b1cdbd2cSJim Jagielski * Sets a value and then gets it. <p> 149*b1cdbd2cSJim Jagielski * Has <b> OK </b> status if the value set is equal to value get. <p> 150*b1cdbd2cSJim Jagielski */ _setValue()151*b1cdbd2cSJim Jagielski public void _setValue() { 152*b1cdbd2cSJim Jagielski boolean result = true; 153*b1cdbd2cSJim Jagielski double cellValue = 0; 154*b1cdbd2cSJim Jagielski log.println("setValue() ..."); 155*b1cdbd2cSJim Jagielski 156*b1cdbd2cSJim Jagielski oObj.setValue(222.333) ; 157*b1cdbd2cSJim Jagielski cellValue = (double) oObj.getValue() ; 158*b1cdbd2cSJim Jagielski 159*b1cdbd2cSJim Jagielski result &= (cellValue == 222.333); 160*b1cdbd2cSJim Jagielski tRes.tested("setValue()", result); 161*b1cdbd2cSJim Jagielski } // end setValue() 162*b1cdbd2cSJim Jagielski } 163*b1cdbd2cSJim Jagielski 164