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
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
|
Test run started : 10/03/2008 15:15:11
----------------------------------------------------------------
ApplicationMethods
TEST START : ApplicationMethods
ITEM Assertion OK : Name of Workbook is: Ranges.xls
ITEM Assertion OK : Address of Application.Columns is: $A:$A
ITEM Assertion OK : Address of Application.Rows is: $1:$1
ITEM Assertion OK : Address of Application.Range is: $1:$1,$5:$7
ITEM Assertion OK : Please check manually: DefaultFilePath is: /data4/home/npower/Documents
ITEM Assertion OK : Please check manually: Library Path is: /data4/home/npower/.ooo-2.0/user/basic
ITEM Assertion OK : Please check manually: Template Path is: /data4/home/npower/.ooo-2.0/user/template
ITEM Assertion OK : FileSeparator is /
ITEM Assertion OK : Name of ActiveWorkbook is: Ranges.xls
END 'ApplicationMethods' Symbol
TEST OK : ApplicationMethods
----------------------------------------------------------------
Insert-Issue
TEST START : Insert-Issue
ITEM Assertion OK : Insert with xlShiftToRight: 10
END 'Insert-Issue' Symbol
TEST OK : Insert-Issue
----------------------------------------------------------------
MergeCells-Issue
TEST START : MergeCells-Issue
ITEM Assertion OK : Range.MergeCells is True
ITEM Assertion FAIL : MergeCells is null: False
ITEM Assertion OK : RowCount after Merge: 13
ITEM Assertion OK : Range.MergeCells is False
ITEM Assertion OK : MergeCells is null: False
ITEM Assertion FAIL : MergeCells of Second Area is null : False
ITEM Assertion FAIL : MergeCells of Ranges is Null: False
ITEM Assertion OK : RowCount after Merge: 7
ITEM Assertion OK : Range.MergeCells is False
ITEM Assertion OK : MergeCells is null: False
ITEM Assertion OK : RowCount after Merge: 7
END 'MergeCells-Issue' Symbol
TEST OK : MergeCells-Issue
----------------------------------------------------------------
Areas-Issue
TEST START : Areas-Issue
ITEM Assertion OK : Range Areas Count is2
ITEM Assertion OK : First Range Address is: $E$8:$G$13
ITEM Assertion OK : First Row is: 8
ITEM Assertion OK : First Column is: 5
ITEM Assertion OK : EntireRow Address is: $8:$13,$13:$19
ITEM Assertion OK : EntireColumn Address is: $E:$G,$G:$K
ITEM Assertion OK : Range Count:53
END 'Areas-Issue' Symbol
TEST OK : Areas-Issue
----------------------------------------------------------------
Fill-Methods-Issue
TEST START : Fill-Methods-Issue
ITEM Assertion OK : Range Value after FillDown: MyFillValue
ITEM Assertion OK : Range Value after FillDown: MyFillValue
ITEM Assertion OK : Range Value after FillDown: MyRightFillValue
ITEM Assertion OK : Range Value after FillDown: MyBottomFillValue
END 'Fill-Methods-Issue' Symbol
TEST OK : Fill-Methods-Issue
----------------------------------------------------------------
Range/Item-Method-Issue
TEST START : Range/Item-Method-Issue
ITEM Assertion OK : Range of multiple columns is: $A:$A,$C:$C
ITEM Assertion OK : Range of multiple rows is: $1:$1,$5:$7
ITEM Assertion OK : Range of several columns is: $C:$E,$D:$D
ITEM Assertion OK : Range of several rows is: $5:$8,$6:$10
ITEM Assertion OK : Range of several single cells is: $C$5,$E$8
ITEM Assertion OK : Range of several named ranges is: $L$1:$M$6,$E$8:$G$13,$G$13:$K$19
ITEM Assertion OK : Range of a single Item Cell is: $E$21
ITEM Assertion OK : Range of a single Item Cell is: $F$21
ITEM Assertion OK : Range of a single Item Cell is: $F$10
END 'Range/Item-Method-Issue' Symbol
TEST OK : Range/Item-Method-Issue
----------------------------------------------------------------
R1C1-Formulas-Issue
TEST START : R1C1-Formulas-Issue
ITEM Assertion OK : R1C1 Range.Formula is: =IF(OR(R[-2]C[1]=0,RC[2]="YES"),"")
ITEM Assertion OK : Range.Formula is: =IF(OR(J8=0,K10="YES"),"")
END 'R1C1-Formulas-Issue' Symbol
TEST OK : R1C1-Formulas-Issue
----------------------------------------------------------------
Verify_Delete
TEST START : Verify_Delete
ITEM Assertion OK : Ranges are intersecting: $G$13
ITEM Assertion OK : Delete with Default: $AJ$4
ITEM Assertion OK : Delete with ShifttoLeft: $AJ$4
ITEM Assertion OK : Delete with ShiftUp: $M$22
END 'Verify_Delete' Symbol
TEST OK : Verify_Delete
----------------------------------------------------------------
Value-Issue
TEST START : Value-Issue
ITEM Assertion OK : Value of Range is: 12.3
ITEM Assertion OK : Text of Range is: 12.3
ITEM Assertion OK : Range has Formula: False
ITEM Assertion OK : Cell has Formula: False
ITEM Assertion FAIL : Text of Range is null: False
ITEM Assertion OK : Range has Formula: True
ITEM Assertion OK : Cell has Formula: True
ITEM Assertion OK : Value of Cell is: 12
ITEM Assertion OK : Application.Calculation is : -4135
ITEM Assertion OK : Calculation is automated: True
ITEM Assertion OK : Range has Formula: True
ITEM Assertion OK : Value of Cell is: 16
ITEM Assertion OK : Text of Cell is: 16
ITEM Assertion OK : Text of Cell is: 16
ITEM Assertion OK : Range has Formula after 'ClearContents: False
ITEM Assertion OK : Text of Cell is:
ITEM Assertion OK : Text of Cell is:
END 'Value-Issue' Symbol
TEST OK : Value-Issue
----------------------------------------------------------------
AutoFit issue
TEST START : AutoFit issue
ITEM Assertion OK : Columns.AutoFit: CurrentWidth is 680
ITEM Assertion OK : Rows.AutoFit: CurrentHeight is 554
END 'AutoFit issue' Symbol
TEST OK : AutoFit issue
----------------------------------------------------------------
Selections
TEST START : Selections
ITEM Assertion OK : ActiveCell is : $E$8
ITEM Assertion OK : Active Cell is : $E$8
ITEM Assertion OK : Number of Cells in Range: 52
ITEM Assertion OK : Number of Cells in Range: 52
ITEM Assertion OK : Number of Cells in Range: 52
END 'Selections' Symbol
TEST OK : Selections
----------------------------------------------------------------
Offset-Resize
TEST START : Offset-Resize
ITEM Assertion OK : Offset is : $G$10:$I$15,$I$15:$M$21
ITEM Assertion OK : Offset is : $G$7:$I$12,$I$12:$M$18
ITEM Assertion OK : Resized Range is : $A$20:$D$23
END 'Offset-Resize' Symbol
TEST OK : Offset-Resize
----------------------------------------------------------------
Ranges-Address
TEST START : Ranges-Address
ITEM Assertion OK : Range Address is: $E$8:$G$13,$G$13:$K$19
ITEM Assertion OK : Range Address is: $E8:$G13,$G13:$K19
ITEM Assertion OK : Range Address is: E$8:G$13,G$13:K$19
ITEM Assertion OK : Range Address is: R8C5:R13C7,R13C7:R19C11
ITEM Assertion FAIL : Range Address is: R8C5:R13C7,R13C7:R19C11
ITEM Assertion OK : Range Address is: R8C5:R13C7,R13C7:R19C11
ITEM Assertion OK : Range Address is: R[6]C[3]:R[11]C[5],R[11]C[5]:R[17]C[9]
ITEM Assertion OK : RangeAddress is [Ranges.xls]Sheet1!$E$8:$G$13,$G$13:$K$19
END 'Ranges-Address' Symbol
TEST OK : Ranges-Address
----------------------------------------------------------------
Range-Address
TEST START : Range-Address
ITEM Assertion OK : Range Address is: $E$8:$G$13
ITEM Assertion OK : Range Address is: $E8:$G13
ITEM Assertion OK : Range Address is: E$8:G$13
ITEM Assertion OK : Range Address is: R8C5:R13C7
ITEM Assertion FAIL : Range Address is: R8C5:R13C7
ITEM Assertion OK : Range Address is: R8C5:R13C7
ITEM Assertion OK : Range Address is: R[6]C[3]:R[11]C[5]
ITEM Assertion OK : RangeAddress is [Ranges.xls]Sheet1!$E$8:$G$13
END 'Range-Address' Symbol
TEST OK : Range-Address
----------------------------------------------------------------
Column-Address
TEST START : Column-Address
ITEM Assertion OK : Range Address is: $F$8:$F$13
ITEM Assertion OK : Range Address is: $F8:$F13
ITEM Assertion OK : Range Address is: F$8:F$13
ITEM Assertion OK : Range Address is: R8C6:R13C6
ITEM Assertion FAIL : Range Address is: R8C6:R13C6
ITEM Assertion OK : Range Address is: R8C6:R13C6
ITEM Assertion OK : Range Address is: R[6]C[4]:R[11]C[4]
ITEM Assertion OK : RangeAddress is [Ranges.xls]Sheet1!$F$8:$F$13
END 'Column-Address' Symbol
TEST OK : Column-Address
----------------------------------------------------------------
Row-Address
TEST START : Row-Address
ITEM Assertion OK : Range Address is: $E$9:$G$9
ITEM Assertion OK : Range Address is: $E9:$G9
ITEM Assertion OK : Range Address is: E$9:G$9
ITEM Assertion OK : Range Address is: R9C5:R9C7
ITEM Assertion FAIL : Range Address is: R9C5:R9C7
ITEM Assertion OK : Range Address is: R9C5:R9C7
ITEM Assertion OK : Range Address is: R[7]C[3]:R[7]C[5]
ITEM Assertion OK : RangeAddress is [Ranges.xls]Sheet1!$E$9:$G$9
END 'Row-Address' Symbol
TEST OK : Row-Address
----------------------------------------------------------------
SingleCell-Address
TEST START : SingleCell-Address
ITEM Assertion OK : Range Address is: $F$9
ITEM Assertion OK : Range Address is: $F9
ITEM Assertion OK : Range Address is: F$9
ITEM Assertion OK : Range Address is: R9C6
ITEM Assertion FAIL : Range Address is: R9C6
ITEM Assertion OK : Range Address is: R9C6
ITEM Assertion OK : Range Address is: R[7]C[4]
ITEM Assertion OK : RangeAddress is [Ranges.xls]Sheet1!$F$9
END 'SingleCell-Address' Symbol
TEST OK : SingleCell-Address
----------------------------------------------------------------
Heights and Widths
TEST START : Heights and Widths
ITEM Assertion OK : Range RowHeight is 40
ITEM Assertion OK : Range ColumnWidth is 50
ITEM Assertion OK : Range Height is 240
ITEM Assertion OK : Range Width is 795
ITEM Assertion OK : Range RowHeight is 50
ITEM Assertion OK : Range ColumnWidth is 50
ITEM Assertion OK : Range Height is 300
ITEM Assertion OK : Range Width is 795
ITEM Assertion OK : RowHeight is null: True
ITEM Assertion OK : ColumnWidth is null: True
END 'Heights and Widths' Symbol
TEST OK : Heights and Widths
----------------------------------------------------------------
RangeRowColumn-Issue
TEST START : RangeRowColumn-Issue
ITEM Assertion OK : Row is: 8
ITEM Assertion OK : Column is: 5
ITEM Assertion OK : EntireRow.Columns.Count = 256
ITEM Assertion OK : EntireColumn.Rows.Count = 131072
END 'RangeRowColumn-Issue' Symbol
TEST OK : RangeRowColumn-Issue
----------------------------------------------------------------
Replace-Issue
TEST START : Replace-Issue
ITEM Assertion OK : Value after Replace: YourValue
ITEM Assertion OK : Value after Replace: YourValue
ITEM Assertion OK : Value after Replace: ReplaceValue
ITEM Assertion OK : Value after Replace: New ReplaceValue
ITEM Assertion OK : Value after Replace: New ReplaceValue
ITEM Assertion OK : Value after Replace: New Replace
ITEM Assertion OK : Value after Replace:
END 'Replace-Issue' Symbol
TEST OK : Replace-Issue
----------------------------------------------------------------
Hidden-Issue
TEST START : Hidden-Issue
ITEM Assertion OK : - Range.Rows.Hidden (set)
ITEM Assertion OK : - Range.Rows.Hidden (get)
ITEM Assertion OK : - Range.Rows.Item(1).Hidden (set)
ITEM Assertion OK : - Range.Rows.Item(1).Hidden (get)
ITEM Assertion OK : - Range.Columns.Hidden (set)
ITEM Assertion OK : - Range.Columns.Hidden (get)
ITEM Assertion OK : - Range.Columns.Item(1).Hidden (set)
ITEM Assertion OK : - Range.Columns.Item(1).Hidden (get)
END 'Hidden-Issue' Symbol
TEST OK : Hidden-Issue
----------------------------------------------------------------
End issue
TEST START : End issue
ITEM Assertion OK : - = $E$48
ITEM Assertion OK : - = $E$1
ITEM Assertion OK : - = $E$3
ITEM Assertion OK : - = $A$8
ITEM Assertion OK : - = $B$8
ITEM Assertion OK : - = $IV$8
ITEM Assertion OK : - = $Z$8
END 'End issue' Symbol
TEST OK : End issue
----------------------------------------------------------------
Outline issue
TEST START : Outline issue
ITEM Assertion OK : - Range.clearOutline - please check visually
ITEM Assertion OK : - Range.AutoOutline - please check visually
ITEM Assertion OK : - Range.AutoOutline - please check visually
END 'Outline issue' Symbol
TEST OK : Outline issue
----------------------------------------------------------------
Validation
TEST START : Validation
ITEM Assertion OK : Validation Input Message is : Attention!
ITEM Assertion OK : Validation Input Message is : Enter an integer from five to ten
ITEM Assertion OK : Validation Error Title is : You must enter a number from five to ten
ITEM Assertion OK : Validation Error Message is : An Error occured
ITEM Assertion OK : Validation Error Title is : Microsoft Excel
END 'Validation' Symbol
TEST OK : Validation
Test run finished : 10/03/2008 15:15:13
|