blob: fc631d90957972d39ad2f2c7c939c2fbaf950a05 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
|
/*
* This file is part of the LibreOffice project.
*
* This Source Code Form is subject to the terms of the Mozilla Public
* License, v. 2.0. If a copy of the MPL was not distributed with this
* file, You can obtain one at http://mozilla.org/MPL/2.0/.
*
* This file incorporates work covered by the following license notice:
*
* Licensed to the Apache Software Foundation (ASF) under one or more
* contributor license agreements. See the NOTICE file distributed
* with this work for additional information regarding copyright
* ownership. The ASF licenses this file to you under the Apache
* License, Version 2.0 (the "License"); you may not use this file
* except in compliance with the License. You may obtain a copy of
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
*/
package ifc.sheet;
import lib.MultiMethodTest;
import com.sun.star.beans.PropertyValue;
import com.sun.star.sheet.ConditionOperator;
import com.sun.star.sheet.XSheetConditionalEntries;
import com.sun.star.table.CellAddress;
/**
* Testing <code>com.sun.star.sheet.XSheetConditionalEntries</code>
* interface methods :
* <ul>
* <li><code> addNew()</code></li>
* <li><code> removeByIndex()</code></li>
* <li><code> clear()</code></li>
* </ul> <p>
* @see com.sun.star.sheet.XSheetConditionalEntries
*/
public class _XSheetConditionalEntries extends MultiMethodTest {
public XSheetConditionalEntries oObj = null;
int nNum = 0;
/**
* Test adds a conditional entry to the format. <p>
* Has <b> OK </b> status if the method successfully returns. <p>
*/
public void _addNew() {
nNum = oObj.getCount();
oObj.addNew( Conditions(4) );
boolean res = (nNum + 1) == oObj.getCount();
tRes.tested("addNew()", res);
}
/**
* Test calls the method and checks number of conditional entries in
* collection. <p>
* Has <b> OK </b> status if number of conditional entries in co0llection
* after method call is equal zero. <p>
* The following method tests are to be completed successfully before :
* <ul>
* <li> <code> addNew() </code> : to have one conditional entry in
* collection at least </li>
* </ul>
*/
public void _clear() {
requiredMethod("removeByIndex()");
oObj.clear();
int anz = oObj.getCount();
tRes.tested("clear()", anz == 0);
}
/**
* Test adds a conditional entry, removes entry with index 0
* and compares number of entries after adding to number of entries after
* removing. <p>
* Has <b> OK </b> status if number of entries after adding is greater
* than number of entries after removing. <p>
* The following method tests are to be completed successfully before :
* <ul>
* <li> <code> clear() </code> : to be sure that collection hasn't
* elements </li>
* </ul>
*/
public void _removeByIndex() {
requiredMethod("addNew()");
oObj.removeByIndex(0);
int pastNum = oObj.getCount();
tRes.tested("removeByIndex()", pastNum == nNum);
}
/**
* Method creates array of property value for conditional entry using
* passed parameter <code>nr</code>.
* @param nr number of row for conditional entry
*/
protected PropertyValue[] Conditions(int nr) {
PropertyValue[] con = new PropertyValue[5];
CellAddress ca = new CellAddress();
ca.Column = 1;
ca.Row = 5;
ca.Sheet = 0;
con[0] = new PropertyValue();
con[0].Name = "StyleName";
con[0].Value = "Result2";
con[1] = new PropertyValue();
con[1].Name = "Formula1";
con[1].Value = "$Sheet1.$B$"+nr;
con[2] = new PropertyValue();
con[2].Name = "Formula2";
con[2].Value = "";
con[3] = new PropertyValue();
con[3].Name = "Operator";
con[3].Value = ConditionOperator.EQUAL;
con[4] = new PropertyValue();
con[4].Name = "SourcePosition";
con[4].Value = ca;
return con;
}
/**
* Forces object environment recreation.
*/
@Override
protected void after() {
this.disposeEnvironment();
}
} // finish class _XSheetConditionalEntries
|