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