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
|
/*
* 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 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 occurred 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 occurred 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
|
