| 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 |