1Test run started : 08/10/2008 11:30:21
2----------------------------------------------------------------
3ApplicationMethods
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: C:\Documents and Settings\vituosity\My Documents
10  ITEM Assertion OK :  Please check manually: Library Path is: C:\Documents and Settings\vituosity\Application Data\OpenOffice.org\3\user\basic
11  ITEM Assertion OK :  Please check manually: Template Path is: C:\Documents and Settings\vituosity\Application Data\OpenOffice.org\3\user\template
12  ITEM Assertion OK :  FileSeparator is \
13  ITEM Assertion OK :  Name of ActiveWorkbook is: Ranges.xls
14END 'ApplicationMethods' Symbol
15 TEST OK : ApplicationMethods
16----------------------------------------------------------------
17Insert-Issue
18 TEST START : Insert-Issue
19  ITEM Assertion OK : Insert with xlShiftToRight: 10
20END 'Insert-Issue' Symbol
21 TEST OK : Insert-Issue
22----------------------------------------------------------------
23MergeCells-Issue
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
36END 'MergeCells-Issue' Symbol
37 TEST OK : MergeCells-Issue
38----------------------------------------------------------------
39Areas-Issue
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
48END 'Areas-Issue' Symbol
49 TEST OK : Areas-Issue
50----------------------------------------------------------------
51Fill-Methods-Issue
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
57END 'Fill-Methods-Issue' Symbol
58 TEST OK : Fill-Methods-Issue
59----------------------------------------------------------------
60Range/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
71END 'Range/Item-Method-Issue' Symbol
72 TEST OK : Range/Item-Method-Issue
73----------------------------------------------------------------
74R1C1-Formulas-Issue
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"),"")
78END 'R1C1-Formulas-Issue' Symbol
79 TEST OK : R1C1-Formulas-Issue
80----------------------------------------------------------------
81Verify_Delete
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
87END 'Verify_Delete' Symbol
88 TEST OK : Verify_Delete
89----------------------------------------------------------------
90Value-Issue
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:
109END 'Value-Issue' Symbol
110 TEST OK : Value-Issue
111----------------------------------------------------------------
112AutoFit issue
113 TEST START : AutoFit issue
114  ITEM Assertion OK :  Columns.AutoFit: CurrentWidth is 680
115  ITEM Assertion OK :  Rows.AutoFit: CurrentHeight is 582
116END 'AutoFit issue' Symbol
117 TEST OK : AutoFit issue
118----------------------------------------------------------------
119Selections
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
126END 'Selections' Symbol
127 TEST OK : Selections
128----------------------------------------------------------------
129Offset-Resize
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
134END 'Offset-Resize' Symbol
135 TEST OK : Offset-Resize
136----------------------------------------------------------------
137Ranges-Address
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
147END 'Ranges-Address' Symbol
148 TEST OK : Ranges-Address
149----------------------------------------------------------------
150Range-Address
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
160END 'Range-Address' Symbol
161 TEST OK : Range-Address
162----------------------------------------------------------------
163Column-Address
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
173END 'Column-Address' Symbol
174 TEST OK : Column-Address
175----------------------------------------------------------------
176Row-Address
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
186END 'Row-Address' Symbol
187 TEST OK : Row-Address
188----------------------------------------------------------------
189SingleCell-Address
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
199END 'SingleCell-Address' Symbol
200 TEST OK : SingleCell-Address
201----------------------------------------------------------------
202Heights and Widths
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 FAIL : Range Width is 675
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 FAIL : Range Width is 675
212  ITEM Assertion OK : RowHeight is null: True
213  ITEM Assertion OK : ColumnWidth is null: True
214END 'Heights and Widths' Symbol
215 TEST OK : Heights and Widths
216----------------------------------------------------------------
217RangeRowColumn-Issue
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
223END 'RangeRowColumn-Issue' Symbol
224 TEST OK : RangeRowColumn-Issue
225----------------------------------------------------------------
226Replace-Issue
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:
235END 'Replace-Issue' Symbol
236 TEST OK : Replace-Issue
237----------------------------------------------------------------
238Hidden-Issue
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)
248END 'Hidden-Issue' Symbol
249 TEST OK : Hidden-Issue
250----------------------------------------------------------------
251End issue
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
260END 'End issue' Symbol
261 TEST OK : End issue
262----------------------------------------------------------------
263Outline issue
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
268END 'Outline issue' Symbol
269 TEST OK : Outline issue
270----------------------------------------------------------------
271Validation
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
278END 'Validation' Symbol
279 TEST OK : Validation
280Test run finished : 08/10/2008 11:30:24
281