AOO410/main/sc/source/ui/vba/testvba/TestDocuments-ooo-build/logs/excel/Ranges.log

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