Test run started : 01/06/2007 11:28:58 | |
---------------------------------------------------------------- | |
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: C:\Documents and Settings\vituosity\My Documents | |
ITEM Assertion OK : Please check manually: Library Path is: C:\Program Files\Microsoft Office\OFFICE11\LIBRARY | |
ITEM Assertion OK : Please check manually: Template Path is: C:\Documents and Settings\vituosity\Application Data\Microsoft\Templates\ | |
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 OK : MergeCells is null: True | |
ITEM Assertion OK : RowCount after Merge: 6 | |
ITEM Assertion OK : Range.MergeCells is False | |
ITEM Assertion OK : MergeCells is null: False | |
ITEM Assertion OK : MergeCells of Second Area is null : True | |
ITEM Assertion OK : MergeCells of Ranges is Null: True | |
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 OK : Text of Range is null: True | |
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 673 | |
ITEM Assertion OK : Rows.AutoFit: CurrentHeight is 612 | |
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: 53 | |
ITEM Assertion OK : Number of Cells in Range: 53 | |
ITEM Assertion OK : Number of Cells in Range: 53 | |
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 OK : Range Address is: $E$8:$G$13,$G$13:$K$19 | |
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 OK : Range Address is: $E$8:$G$13 | |
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 OK : Range Address is: $F$8:$F$13 | |
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 OK : Range Address is: $E$9:$G$9 | |
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 OK : Range Address is: $F$9 | |
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 238 | |
ITEM Assertion OK : Range Width is 798.75 | |
ITEM Assertion OK : Range RowHeight is 50 | |
ITEM Assertion OK : Range ColumnWidth is 50 | |
ITEM Assertion OK : Range Height is 297 | |
ITEM Assertion OK : Range Width is 798.75 | |
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 = 65536 | |
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 : 01/06/2007 11:29:00 |