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.sheet; 25*b1cdbd2cSJim Jagielski 26*b1cdbd2cSJim Jagielski import lib.MultiMethodTest; 27*b1cdbd2cSJim Jagielski import util.ValueChanger; 28*b1cdbd2cSJim Jagielski 29*b1cdbd2cSJim Jagielski import com.sun.star.sheet.ConditionOperator; 30*b1cdbd2cSJim Jagielski import com.sun.star.sheet.XSheetCondition; 31*b1cdbd2cSJim Jagielski import com.sun.star.table.CellAddress; 32*b1cdbd2cSJim Jagielski 33*b1cdbd2cSJim Jagielski /** 34*b1cdbd2cSJim Jagielski * Testing <code>com.sun.star.sheet.XSheetCondition</code> 35*b1cdbd2cSJim Jagielski * interface methods : 36*b1cdbd2cSJim Jagielski * <ul> 37*b1cdbd2cSJim Jagielski * <li><code> getOperator()</code></li> 38*b1cdbd2cSJim Jagielski * <li><code> setOperator()</code></li> 39*b1cdbd2cSJim Jagielski * <li><code> getFormula1()</code></li> 40*b1cdbd2cSJim Jagielski * <li><code> setFormula1()</code></li> 41*b1cdbd2cSJim Jagielski * <li><code> getFormula2()</code></li> 42*b1cdbd2cSJim Jagielski * <li><code> setFormula2()</code></li> 43*b1cdbd2cSJim Jagielski * <li><code> getSourcePosition()</code></li> 44*b1cdbd2cSJim Jagielski * <li><code> setSourcePosition()</code></li> 45*b1cdbd2cSJim Jagielski * </ul> <p> 46*b1cdbd2cSJim Jagielski * @see com.sun.star.sheet.XSheetCondition 47*b1cdbd2cSJim Jagielski */ 48*b1cdbd2cSJim Jagielski public class _XSheetCondition extends MultiMethodTest { 49*b1cdbd2cSJim Jagielski public XSheetCondition oObj = null; 50*b1cdbd2cSJim Jagielski public String Formula1 = null; 51*b1cdbd2cSJim Jagielski public String Formula2 = null; 52*b1cdbd2cSJim Jagielski public ConditionOperator Operator = null; 53*b1cdbd2cSJim Jagielski public CellAddress SourcePosition = null; 54*b1cdbd2cSJim Jagielski 55*b1cdbd2cSJim Jagielski /** 56*b1cdbd2cSJim Jagielski * Test calls the method, checks and stores returned value. <p> 57*b1cdbd2cSJim Jagielski * Has <b> OK </b> status if returned vakue isn't null. <p> 58*b1cdbd2cSJim Jagielski */ _getFormula1()59*b1cdbd2cSJim Jagielski public void _getFormula1() { 60*b1cdbd2cSJim Jagielski Formula1 = oObj.getFormula1(); 61*b1cdbd2cSJim Jagielski tRes.tested("getFormula1()", Formula1 != null); 62*b1cdbd2cSJim Jagielski } 63*b1cdbd2cSJim Jagielski 64*b1cdbd2cSJim Jagielski /** 65*b1cdbd2cSJim Jagielski * Test calls the method, checks and stores returned value. <p> 66*b1cdbd2cSJim Jagielski * Has <b> OK </b> status if returned vakue isn't null. <p> 67*b1cdbd2cSJim Jagielski */ _getFormula2()68*b1cdbd2cSJim Jagielski public void _getFormula2() { 69*b1cdbd2cSJim Jagielski Formula2 = oObj.getFormula2(); 70*b1cdbd2cSJim Jagielski tRes.tested("getFormula2()", Formula2 != null); 71*b1cdbd2cSJim Jagielski } 72*b1cdbd2cSJim Jagielski 73*b1cdbd2cSJim Jagielski /** 74*b1cdbd2cSJim Jagielski * Test calls the method, checks and stores returned value. <p> 75*b1cdbd2cSJim Jagielski * Has <b> OK </b> status if returned vakue isn't null. <p> 76*b1cdbd2cSJim Jagielski */ _getOperator()77*b1cdbd2cSJim Jagielski public void _getOperator() { 78*b1cdbd2cSJim Jagielski Operator = oObj.getOperator(); 79*b1cdbd2cSJim Jagielski tRes.tested("getOperator()", Operator != null); 80*b1cdbd2cSJim Jagielski } 81*b1cdbd2cSJim Jagielski 82*b1cdbd2cSJim Jagielski /** 83*b1cdbd2cSJim Jagielski * Test calls the method, checks and stores returned value. <p> 84*b1cdbd2cSJim Jagielski * Has <b> OK </b> status if returned vakue isn't null. <p> 85*b1cdbd2cSJim Jagielski */ _getSourcePosition()86*b1cdbd2cSJim Jagielski public void _getSourcePosition() { 87*b1cdbd2cSJim Jagielski SourcePosition = oObj.getSourcePosition(); 88*b1cdbd2cSJim Jagielski tRes.tested("getSourcePosition()", SourcePosition != null); 89*b1cdbd2cSJim Jagielski } 90*b1cdbd2cSJim Jagielski 91*b1cdbd2cSJim Jagielski /** 92*b1cdbd2cSJim Jagielski * Test sets new value of formula1, gets formula1 again and compares 93*b1cdbd2cSJim Jagielski * returned value with value that was stored by method 94*b1cdbd2cSJim Jagielski * <code>getFormula1()</code>. <p> 95*b1cdbd2cSJim Jagielski * Has <b> OK </b> status if values aren't equal. <p> 96*b1cdbd2cSJim Jagielski * The following method tests are to be completed successfully before : 97*b1cdbd2cSJim Jagielski * <ul> 98*b1cdbd2cSJim Jagielski * <li> <code> getFormula1() </code> : to have value of 'Formula1' </li> 99*b1cdbd2cSJim Jagielski * </ul> 100*b1cdbd2cSJim Jagielski */ _setFormula1()101*b1cdbd2cSJim Jagielski public void _setFormula1() { 102*b1cdbd2cSJim Jagielski requiredMethod("getFormula1()"); 103*b1cdbd2cSJim Jagielski oObj.setFormula1("$Sheet1.$C$" + Thread.activeCount()); 104*b1cdbd2cSJim Jagielski tRes.tested("setFormula1()", !Formula1.equals( oObj.getFormula1() ) ); 105*b1cdbd2cSJim Jagielski } 106*b1cdbd2cSJim Jagielski 107*b1cdbd2cSJim Jagielski /** 108*b1cdbd2cSJim Jagielski * Test sets new value of formula2, gets formula2 again and compares 109*b1cdbd2cSJim Jagielski * returned value with value that was stored by method 110*b1cdbd2cSJim Jagielski * <code>getFormula2()</code>. <p> 111*b1cdbd2cSJim Jagielski * Has <b> OK </b> status if values aren't equal. <p> 112*b1cdbd2cSJim Jagielski * The following method tests are to be completed successfully before : 113*b1cdbd2cSJim Jagielski * <ul> 114*b1cdbd2cSJim Jagielski * <li> <code> getFormula2() </code> : to have value of 'Formula2' </li> 115*b1cdbd2cSJim Jagielski * </ul> 116*b1cdbd2cSJim Jagielski */ _setFormula2()117*b1cdbd2cSJim Jagielski public void _setFormula2() { 118*b1cdbd2cSJim Jagielski requiredMethod("getFormula2()"); 119*b1cdbd2cSJim Jagielski oObj.setFormula2("$Sheet1.$A$" + Thread.activeCount()); 120*b1cdbd2cSJim Jagielski tRes.tested("setFormula2()", !Formula2.equals( oObj.getFormula2() ) ); 121*b1cdbd2cSJim Jagielski } 122*b1cdbd2cSJim Jagielski 123*b1cdbd2cSJim Jagielski /** 124*b1cdbd2cSJim Jagielski * Test sets new value of operator, gets operator and compares 125*b1cdbd2cSJim Jagielski * returned value with value that was set. <p> 126*b1cdbd2cSJim Jagielski * Has <b> OK </b> status if values aren't equal. <p> 127*b1cdbd2cSJim Jagielski */ _setOperator()128*b1cdbd2cSJim Jagielski public void _setOperator() { 129*b1cdbd2cSJim Jagielski oObj.setOperator(ConditionOperator.BETWEEN); 130*b1cdbd2cSJim Jagielski tRes.tested("setOperator()", !Operator.equals( oObj.getOperator() ) ); 131*b1cdbd2cSJim Jagielski } 132*b1cdbd2cSJim Jagielski 133*b1cdbd2cSJim Jagielski /** 134*b1cdbd2cSJim Jagielski * Test change value that was stored by method 135*b1cdbd2cSJim Jagielski * <code>getSourcePosition()</code>, sets this new value, gets source 136*b1cdbd2cSJim Jagielski * position again and compares returned value with value that was set. <p> 137*b1cdbd2cSJim Jagielski * Has <b> OK </b> status if values aren't equal. <p> 138*b1cdbd2cSJim Jagielski * The following method tests are to be completed successfully before : 139*b1cdbd2cSJim Jagielski * <ul> 140*b1cdbd2cSJim Jagielski * <li> <code> getSourcePosition() </code> : to have value of source 141*b1cdbd2cSJim Jagielski * position </li> 142*b1cdbd2cSJim Jagielski * </ul> 143*b1cdbd2cSJim Jagielski */ _setSourcePosition()144*b1cdbd2cSJim Jagielski public void _setSourcePosition() { 145*b1cdbd2cSJim Jagielski requiredMethod("getSourcePosition()"); 146*b1cdbd2cSJim Jagielski oObj.setSourcePosition( 147*b1cdbd2cSJim Jagielski (CellAddress)ValueChanger.changePValue(SourcePosition)); 148*b1cdbd2cSJim Jagielski tRes.tested( 149*b1cdbd2cSJim Jagielski "setSourcePosition()", 150*b1cdbd2cSJim Jagielski !SourcePosition.equals( oObj.getSourcePosition() ) ); 151*b1cdbd2cSJim Jagielski } 152*b1cdbd2cSJim Jagielski 153*b1cdbd2cSJim Jagielski } // finish class _XSheetCondition 154*b1cdbd2cSJim Jagielski 155