1 Test run started : 17/09/2009 12:17:26
2 ----------------------------------------------------------------
4 TEST START : ApplicationMethods
5 ITEM Assertion OK : Name of Workbook is: Ranges.xls
6 ITEM Assertion OK : Address of Application.Columns is: $A:$A
7 ITEM Assertion OK : Address of Application.Rows is: $1:$1
8 ITEM Assertion OK : Address of Application.Range is: $1:$1,$5:$7
9 ITEM Assertion OK : Please check manually: DefaultFilePath is: /data4/home/npower/Documents
10 ITEM Assertion OK : Please check manually: Library Path is: /media/disk/Openoffice-BUILDS/UBERCWS/IBM_NOVELL_TESTBUILD/opt/UserInstallation/user/basic
11 ITEM Assertion OK : Please check manually: Template Path is: /media/disk/Openoffice-BUILDS/UBERCWS/IBM_NOVELL_TESTBUILD/opt/UserInstallation/user/template
12 ITEM Assertion OK : FileSeparator is /
13 ITEM Assertion OK : Name of ActiveWorkbook is: Ranges.xls
14 END 'ApplicationMethods' Symbol
15 TEST OK : ApplicationMethods
16 ----------------------------------------------------------------
18 TEST START : Insert-Issue
19 ITEM Assertion OK : Insert with xlShiftToRight: 10
20 END 'Insert-Issue' Symbol
21 TEST OK : Insert-Issue
22 ----------------------------------------------------------------
24 TEST START : MergeCells-Issue
25 ITEM Assertion OK : Range.MergeCells is True
26 ITEM Assertion FAIL : MergeCells is null: False
27 ITEM Assertion OK : RowCount after Merge: 13
28 ITEM Assertion OK : Range.MergeCells is False
29 ITEM Assertion OK : MergeCells is null: False
30 ITEM Assertion FAIL : MergeCells of Second Area is null : False
31 ITEM Assertion FAIL : MergeCells of Ranges is Null: False
32 ITEM Assertion OK : RowCount after Merge: 7
33 ITEM Assertion OK : Range.MergeCells is False
34 ITEM Assertion OK : MergeCells is null: False
35 ITEM Assertion OK : RowCount after Merge: 7
36 END 'MergeCells-Issue' Symbol
37 TEST OK : MergeCells-Issue
38 ----------------------------------------------------------------
40 TEST START : Areas-Issue
41 ITEM Assertion OK : Range Areas Count is2
42 ITEM Assertion OK : First Range Address is: $E$8:$G$13
43 ITEM Assertion OK : First Row is: 8
44 ITEM Assertion OK : First Column is: 5
45 ITEM Assertion OK : EntireRow Address is: $8:$13,$13:$19
46 ITEM Assertion OK : EntireColumn Address is: $E:$G,$G:$K
47 ITEM Assertion OK : Range Count:53
48 END 'Areas-Issue' Symbol
50 ----------------------------------------------------------------
52 TEST START : Fill-Methods-Issue
53 ITEM Assertion OK : Range Value after FillDown: MyFillValue
54 ITEM Assertion OK : Range Value after FillDown: MyFillValue
55 ITEM Assertion OK : Range Value after FillDown: MyRightFillValue
56 ITEM Assertion OK : Range Value after FillDown: MyBottomFillValue
57 END 'Fill-Methods-Issue' Symbol
58 TEST OK : Fill-Methods-Issue
59 ----------------------------------------------------------------
60 Range/Item-Method-Issue
61 TEST START : Range/Item-Method-Issue
62 ITEM Assertion OK : Range of multiple columns is: $A:$A,$C:$C
63 ITEM Assertion OK : Range of multiple rows is: $1:$1,$5:$7
64 ITEM Assertion OK : Range of several columns is: $C:$E,$D:$D
65 ITEM Assertion OK : Range of several rows is: $5:$8,$6:$10
66 ITEM Assertion OK : Range of several single cells is: $C$5,$E$8
67 ITEM Assertion OK : Range of several named ranges is: $L$1:$M$6,$E$8:$G$13,$G$13:$K$19
68 ITEM Assertion OK : Range of a single Item Cell is: $E$21
69 ITEM Assertion OK : Range of a single Item Cell is: $F$21
70 ITEM Assertion OK : Range of a single Item Cell is: $F$10
71 END 'Range/Item-Method-Issue' Symbol
72 TEST OK : Range/Item-Method-Issue
73 ----------------------------------------------------------------
75 TEST START : R1C1-Formulas-Issue
76 ITEM Assertion OK : R1C1 Range.Formula is: =IF(OR(R[-2]C[1]=0,RC[2]="YES"),"")
77 ITEM Assertion OK : Range.Formula is: =IF(OR(J8=0,K10="YES"),"")
78 END 'R1C1-Formulas-Issue' Symbol
79 TEST OK : R1C1-Formulas-Issue
80 ----------------------------------------------------------------
82 TEST START : Verify_Delete
83 ITEM Assertion OK : Ranges are intersecting: $G$13
84 ITEM Assertion OK : Delete with Default: $AJ$4
85 ITEM Assertion OK : Delete with ShifttoLeft: $AJ$4
86 ITEM Assertion OK : Delete with ShiftUp: $M$22
87 END 'Verify_Delete' Symbol
88 TEST OK : Verify_Delete
89 ----------------------------------------------------------------
91 TEST START : Value-Issue
92 ITEM Assertion OK : Value of Range is: 12.3
93 ITEM Assertion OK : Text of Range is: 12.3
94 ITEM Assertion OK : Range has Formula: False
95 ITEM Assertion OK : Cell has Formula: False
96 ITEM Assertion FAIL : Text of Range is null: False
97 ITEM Assertion OK : Range has Formula: True
98 ITEM Assertion OK : Cell has Formula: True
99 ITEM Assertion OK : Value of Cell is: 12
100 ITEM Assertion OK : Application.Calculation is : -4135
101 ITEM Assertion OK : Calculation is automated: True
102 ITEM Assertion OK : Range has Formula: True
103 ITEM Assertion OK : Value of Cell is: 16
104 ITEM Assertion OK : Text of Cell is: 16
105 ITEM Assertion OK : Text of Cell is: 16
106 ITEM Assertion OK : Range has Formula after 'ClearContents: False
107 ITEM Assertion OK : Text of Cell is:
108 ITEM Assertion OK : Text of Cell is:
109 END 'Value-Issue' Symbol
110 TEST OK : Value-Issue
111 ----------------------------------------------------------------
113 TEST START : AutoFit issue
114 ITEM Assertion OK : Columns.AutoFit: CurrentWidth is 679
115 ITEM Assertion OK : Rows.AutoFit: CurrentHeight is 546
116 END 'AutoFit issue' Symbol
117 TEST OK : AutoFit issue
118 ----------------------------------------------------------------
120 TEST START : Selections
121 ITEM Assertion OK : ActiveCell is : $E$8
122 ITEM Assertion OK : Active Cell is : $E$8
123 ITEM Assertion OK : Number of Cells in Range: 52
124 ITEM Assertion OK : Number of Cells in Range: 52
125 ITEM Assertion OK : Number of Cells in Range: 52
126 END 'Selections' Symbol
128 ----------------------------------------------------------------
130 TEST START : Offset-Resize
131 ITEM Assertion OK : Offset is : $G$10:$I$15,$I$15:$M$21
132 ITEM Assertion OK : Offset is : $G$7:$I$12,$I$12:$M$18
133 ITEM Assertion OK : Resized Range is : $A$20:$D$23
134 END 'Offset-Resize' Symbol
135 TEST OK : Offset-Resize
136 ----------------------------------------------------------------
138 TEST START : Ranges-Address
139 ITEM Assertion OK : Range Address is: $E$8:$G$13,$G$13:$K$19
140 ITEM Assertion OK : Range Address is: $E8:$G13,$G13:$K19
141 ITEM Assertion OK : Range Address is: E$8:G$13,G$13:K$19
142 ITEM Assertion OK : Range Address is: R8C5:R13C7,R13C7:R19C11
143 ITEM Assertion FAIL : Range Address is: R8C5:R13C7,R13C7:R19C11
144 ITEM Assertion OK : Range Address is: R8C5:R13C7,R13C7:R19C11
145 ITEM Assertion OK : Range Address is: R[6]C[3]:R[11]C[5],R[11]C[5]:R[17]C[9]
146 ITEM Assertion OK : RangeAddress is [Ranges.xls]Sheet1!$E$8:$G$13,$G$13:$K$19
147 END 'Ranges-Address' Symbol
148 TEST OK : Ranges-Address
149 ----------------------------------------------------------------
151 TEST START : Range-Address
152 ITEM Assertion OK : Range Address is: $E$8:$G$13
153 ITEM Assertion OK : Range Address is: $E8:$G13
154 ITEM Assertion OK : Range Address is: E$8:G$13
155 ITEM Assertion OK : Range Address is: R8C5:R13C7
156 ITEM Assertion FAIL : Range Address is: R8C5:R13C7
157 ITEM Assertion OK : Range Address is: R8C5:R13C7
158 ITEM Assertion OK : Range Address is: R[6]C[3]:R[11]C[5]
159 ITEM Assertion OK : RangeAddress is [Ranges.xls]Sheet1!$E$8:$G$13
160 END 'Range-Address' Symbol
161 TEST OK : Range-Address
162 ----------------------------------------------------------------
164 TEST START : Column-Address
165 ITEM Assertion OK : Range Address is: $F$8:$F$13
166 ITEM Assertion OK : Range Address is: $F8:$F13
167 ITEM Assertion OK : Range Address is: F$8:F$13
168 ITEM Assertion OK : Range Address is: R8C6:R13C6
169 ITEM Assertion FAIL : Range Address is: R8C6:R13C6
170 ITEM Assertion OK : Range Address is: R8C6:R13C6
171 ITEM Assertion OK : Range Address is: R[6]C[4]:R[11]C[4]
172 ITEM Assertion OK : RangeAddress is [Ranges.xls]Sheet1!$F$8:$F$13
173 END 'Column-Address' Symbol
174 TEST OK : Column-Address
175 ----------------------------------------------------------------
177 TEST START : Row-Address
178 ITEM Assertion OK : Range Address is: $E$9:$G$9
179 ITEM Assertion OK : Range Address is: $E9:$G9
180 ITEM Assertion OK : Range Address is: E$9:G$9
181 ITEM Assertion OK : Range Address is: R9C5:R9C7
182 ITEM Assertion FAIL : Range Address is: R9C5:R9C7
183 ITEM Assertion OK : Range Address is: R9C5:R9C7
184 ITEM Assertion OK : Range Address is: R[7]C[3]:R[7]C[5]
185 ITEM Assertion OK : RangeAddress is [Ranges.xls]Sheet1!$E$9:$G$9
186 END 'Row-Address' Symbol
187 TEST OK : Row-Address
188 ----------------------------------------------------------------
190 TEST START : SingleCell-Address
191 ITEM Assertion OK : Range Address is: $F$9
192 ITEM Assertion OK : Range Address is: $F9
193 ITEM Assertion OK : Range Address is: F$9
194 ITEM Assertion OK : Range Address is: R9C6
195 ITEM Assertion FAIL : Range Address is: R9C6
196 ITEM Assertion OK : Range Address is: R9C6
197 ITEM Assertion OK : Range Address is: R[7]C[4]
198 ITEM Assertion OK : RangeAddress is [Ranges.xls]Sheet1!$F$9
199 END 'SingleCell-Address' Symbol
200 TEST OK : SingleCell-Address
201 ----------------------------------------------------------------
203 TEST START : Heights and Widths
204 ITEM Assertion OK : Range RowHeight is 40
205 ITEM Assertion OK : Range ColumnWidth is 50
206 ITEM Assertion OK : Range Height is 240
207 ITEM Assertion OK : Range Width is 787.5
208 ITEM Assertion OK : Range RowHeight is 50
209 ITEM Assertion OK : Range ColumnWidth is 50
210 ITEM Assertion OK : Range Height is 300
211 ITEM Assertion OK : Range Width is 787.5
212 ITEM Assertion OK : RowHeight is null: True
213 ITEM Assertion OK : ColumnWidth is null: True
214 END 'Heights and Widths' Symbol
215 TEST OK : Heights and Widths
216 ----------------------------------------------------------------
218 TEST START : RangeRowColumn-Issue
219 ITEM Assertion OK : Row is: 8
220 ITEM Assertion OK : Column is: 5
221 ITEM Assertion OK : EntireRow.Columns.Count = 1024
222 ITEM Assertion OK : EntireColumn.Rows.Count = 131072
223 END 'RangeRowColumn-Issue' Symbol
224 TEST OK : RangeRowColumn-Issue
225 ----------------------------------------------------------------
227 TEST START : Replace-Issue
228 ITEM Assertion OK : Value after Replace: YourValue
229 ITEM Assertion OK : Value after Replace: YourValue
230 ITEM Assertion OK : Value after Replace: ReplaceValue
231 ITEM Assertion OK : Value after Replace: New ReplaceValue
232 ITEM Assertion OK : Value after Replace: New ReplaceValue
233 ITEM Assertion OK : Value after Replace: New Replace
234 ITEM Assertion OK : Value after Replace:
235 END 'Replace-Issue' Symbol
236 TEST OK : Replace-Issue
237 ----------------------------------------------------------------
239 TEST START : Hidden-Issue
240 ITEM Assertion OK : - Range.Rows.Hidden (set)
241 ITEM Assertion OK : - Range.Rows.Hidden (get)
242 ITEM Assertion OK : - Range.Rows.Item(1).Hidden (set)
243 ITEM Assertion OK : - Range.Rows.Item(1).Hidden (get)
244 ITEM Assertion OK : - Range.Columns.Hidden (set)
245 ITEM Assertion OK : - Range.Columns.Hidden (get)
246 ITEM Assertion OK : - Range.Columns.Item(1).Hidden (set)
247 ITEM Assertion OK : - Range.Columns.Item(1).Hidden (get)
248 END 'Hidden-Issue' Symbol
249 TEST OK : Hidden-Issue
250 ----------------------------------------------------------------
252 TEST START : End issue
253 ITEM Assertion OK : - = $E$48
254 ITEM Assertion OK : - = $E$1
255 ITEM Assertion OK : - = $E$3
256 ITEM Assertion OK : - = $A$8
257 ITEM Assertion OK : - = $B$8
258 ITEM Assertion OK : - = $AMJ$8
259 ITEM Assertion OK : - = $Z$8
260 END 'End issue' Symbol
262 ----------------------------------------------------------------
264 TEST START : Outline issue
265 ITEM Assertion OK : - Range.clearOutline - please check visually
266 ITEM Assertion OK : - Range.AutoOutline - please check visually
267 ITEM Assertion OK : - Range.AutoOutline - please check visually
268 END 'Outline issue' Symbol
269 TEST OK : Outline issue
270 ----------------------------------------------------------------
272 TEST START : Validation
273 ITEM Assertion OK : Validation Input Message is : Attention!
274 ITEM Assertion OK : Validation Input Message is : Enter an integer from five to ten
275 ITEM Assertion OK : Validation Error Title is : You must enter a number from five to ten
276 ITEM Assertion OK : Validation Error Message is : An Error occured
277 ITEM Assertion OK : Validation Error Title is : Microsoft Excel
278 END 'Validation' Symbol
280 Test run finished : 17/09/2009 12:17:34