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
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
|
/*************************************************************************
*
* DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
*
* Copyright 2000, 2010 Oracle and/or its affiliates.
*
* OpenOffice.org - a multi-platform office productivity suite
*
* This file is part of OpenOffice.org.
*
* OpenOffice.org is free software: you can redistribute it and/or modify
* it under the terms of the GNU Lesser General Public License version 3
* only, as published by the Free Software Foundation.
*
* OpenOffice.org is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU Lesser General Public License version 3 for more details
* (a copy is included in the LICENSE file that accompanied this code).
*
* You should have received a copy of the GNU Lesser General Public License
* version 3 along with OpenOffice.org. If not, see
* <http://www.openoffice.org/license.html>
* for a copy of the LGPLv3 License.
*
************************************************************************/
package ifc.sheet;
import com.sun.star.sheet.XSpreadsheets;
import lib.MultiMethodTest;
/**
* Testing <code>com.sun.star.sheet.XSpreadsheets</code>
* interface methods :
* <ul>
* <li><code> insertNewByName()</code></li>
* <li><code> moveByName()</code></li>
* <li><code> copyByName()</code></li>
* </ul> <p>
* Test is multithread compilant. <p>
* @see com.sun.star.sheet.XSpreadsheets
*/
public class _XSpreadsheets extends MultiMethodTest {
protected static int uniqCount = 0;
public XSpreadsheets oObj = null;
protected int uniqNumber = 0;
/**
* Sets the unique number for the current test.
*/
protected synchronized void before() {
uniqNumber = uniqCount++;
}
/**
* Test inserts new sheet using the name returned by the method
* <code>newName</code>, copies inserted sheet with the new name,
* checks existence of the sheet with this name in collection and removes
* the both sheets from the collection. <p>
* Has <b> OK </b> status if the sheet with the name of the copy exists
* in the collection and no exceptions were thrown. <p>
*/
public void _copyByName() {
boolean result = true;
//first insert one that should be copied
String iS = newName("copyFrom");
log.println("Inserting sheet '" + iS + "'");
oObj.insertNewByName(iS, (short) 0);
String[] eNames = oObj.getElementNames();
String NewSheet = newName("copyTo");
log.println("Try to copy " + eNames[0] + " to " + NewSheet);
oObj.copyByName(eNames[0], NewSheet, (short) 0);
result = oObj.hasByName(NewSheet);
//remove all inserted sheets
try {
oObj.removeByName(NewSheet);
oObj.removeByName(iS);
} catch (com.sun.star.lang.WrappedTargetException e) {
log.print("Can't remove sheet by name");
e.printStackTrace(log);
result = false;
} catch (com.sun.star.container.NoSuchElementException e) {
log.print("Can't remove sheet by name");
e.printStackTrace(log);
result = false;
}
tRes.tested("copyByName()", result);
} // finished _copyByName
/**
* Test inserts new sheet using the name returned by the method
* <code>newName</code>, moves the inserted sheet to the new position
* in collection, gets all element names in collection and checks the name
* of the sheet in the new position. <p>
* Has <b> OK </b> status if the sheet name in the new position is equal to
* the name of the sheet that was moved. <p>
*/
public void _moveByName() {
//first insert one that should be moved
String iS = newName("move");
oObj.insertNewByName(iS, (short) 0);
String[] eNames = oObj.getElementNames();
String sheetToMove = eNames[0];
log.println("Try to move " + sheetToMove);
oObj.moveByName(sheetToMove, (short) 2);
eNames = oObj.getElementNames();
tRes.tested("moveByName()", sheetToMove.equals(eNames[1]));
} // finished _moveByName
/**
* Test inserts new sheet using the name returned by the method
* <code>newName</code>, checks the existence of the inserted sheet in
* the collection, removes the sheet, tries to insert the sheet with the
* bad name returned by method <code>badName()</code>. <p>
* Has <b> OK </b> status if the inserted sheet exists in the collection
* after first method call and if exception occured during the second call. <p>
*/
public void _insertNewByName() {
boolean result = false;
String NewSheet = newName("insert");
log.println("Try to insert " + NewSheet);
oObj.insertNewByName(NewSheet, (short) 0);
result = oObj.hasByName(NewSheet);
try {
oObj.removeByName(NewSheet);
} catch (com.sun.star.lang.WrappedTargetException e) {
log.print("Can't remove sheet '" + NewSheet + "':");
e.printStackTrace(log);
result = false;
} catch (com.sun.star.container.NoSuchElementException e) {
log.print("Can't remove sheet '" + NewSheet + "':");
e.printStackTrace(log);
result = false;
}
try {
NewSheet = badName();
log.println("Try to insert " + NewSheet);
oObj.insertNewByName(NewSheet, (short) 0);
log.println(
"No Exception thrown while inserting sheet with invalid name");
result &= false;
oObj.removeByName(NewSheet);
} catch (com.sun.star.uno.RuntimeException e) {
log.println(
"Expected exception occured during testing 'insertNewByName'");
result &= true;
} catch (com.sun.star.lang.WrappedTargetException e) {
log.print("Can't remove sheet '" + NewSheet + "':");
e.printStackTrace(log);
result = false;
} catch (com.sun.star.container.NoSuchElementException e) {
log.print("Can't remove sheet '" + NewSheet + "':");
e.printStackTrace(log);
result = false;
}
tRes.tested("insertNewByName()", result);
} // finished _insertByName
/**
* Method returns unique new name using passed prefix and unique number
* of the current test.
*/
public String newName(String prefix) {
return prefix + uniqNumber;
} // finished newName
/**
* Method return bad name for a sheet using the name of the current thread.
*/
public String badName() {
return "$%#/?\\";
} // finished badName
} //finish class _XSpreadsheets
|
