1Test run started : 10/03/2008 15:15:11 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: /data4/home/npower/Documents 10 ITEM Assertion OK : Please check manually: Library Path is: /data4/home/npower/.ooo-2.0/user/basic 11 ITEM Assertion OK : Please check manually: Template Path is: /data4/home/npower/.ooo-2.0/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 554 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 OK : Range Width is 795 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 795 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 = 256 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 : - = $IV$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 : 10/03/2008 15:15:13 281