diff options
Diffstat (limited to 'sc/source/ui/vba/testvba/TestDocuments')
73 files changed, 0 insertions, 2504 deletions
diff --git a/sc/source/ui/vba/testvba/TestDocuments/ApplicationRunTest.xls b/sc/source/ui/vba/testvba/TestDocuments/ApplicationRunTest.xls Binary files differdeleted file mode 100644 index a5a591c1f..000000000 --- a/sc/source/ui/vba/testvba/TestDocuments/ApplicationRunTest.xls +++ /dev/null diff --git a/sc/source/ui/vba/testvba/TestDocuments/AutoFilter.xls b/sc/source/ui/vba/testvba/TestDocuments/AutoFilter.xls Binary files differdeleted file mode 100644 index 9b3a1043c..000000000 --- a/sc/source/ui/vba/testvba/TestDocuments/AutoFilter.xls +++ /dev/null diff --git a/sc/source/ui/vba/testvba/TestDocuments/CalcFont.xls b/sc/source/ui/vba/testvba/TestDocuments/CalcFont.xls Binary files differdeleted file mode 100644 index 9ddb69600..000000000 --- a/sc/source/ui/vba/testvba/TestDocuments/CalcFont.xls +++ /dev/null diff --git a/sc/source/ui/vba/testvba/TestDocuments/FinancialFuncs.xls b/sc/source/ui/vba/testvba/TestDocuments/FinancialFuncs.xls Binary files differdeleted file mode 100644 index bb8941809..000000000 --- a/sc/source/ui/vba/testvba/TestDocuments/FinancialFuncs.xls +++ /dev/null diff --git a/sc/source/ui/vba/testvba/TestDocuments/MiscRangeTests.xls b/sc/source/ui/vba/testvba/TestDocuments/MiscRangeTests.xls Binary files differdeleted file mode 100644 index ebd9e91b5..000000000 --- a/sc/source/ui/vba/testvba/TestDocuments/MiscRangeTests.xls +++ /dev/null diff --git a/sc/source/ui/vba/testvba/TestDocuments/PageBreaks.xls b/sc/source/ui/vba/testvba/TestDocuments/PageBreaks.xls Binary files differdeleted file mode 100644 index b6651fa5d..000000000 --- a/sc/source/ui/vba/testvba/TestDocuments/PageBreaks.xls +++ /dev/null diff --git a/sc/source/ui/vba/testvba/TestDocuments/Ranges-2.xls b/sc/source/ui/vba/testvba/TestDocuments/Ranges-2.xls Binary files differdeleted file mode 100644 index f6e81cf93..000000000 --- a/sc/source/ui/vba/testvba/TestDocuments/Ranges-2.xls +++ /dev/null diff --git a/sc/source/ui/vba/testvba/TestDocuments/Ranges-3.xls b/sc/source/ui/vba/testvba/TestDocuments/Ranges-3.xls Binary files differdeleted file mode 100644 index 8722f6d30..000000000 --- a/sc/source/ui/vba/testvba/TestDocuments/Ranges-3.xls +++ /dev/null diff --git a/sc/source/ui/vba/testvba/TestDocuments/Ranges.xls b/sc/source/ui/vba/testvba/TestDocuments/Ranges.xls Binary files differdeleted file mode 100644 index 1c1d74d37..000000000 --- a/sc/source/ui/vba/testvba/TestDocuments/Ranges.xls +++ /dev/null diff --git a/sc/source/ui/vba/testvba/TestDocuments/Shapes.xls b/sc/source/ui/vba/testvba/TestDocuments/Shapes.xls Binary files differdeleted file mode 100644 index 254f3c977..000000000 --- a/sc/source/ui/vba/testvba/TestDocuments/Shapes.xls +++ /dev/null diff --git a/sc/source/ui/vba/testvba/TestDocuments/StrConv-test.xls b/sc/source/ui/vba/testvba/TestDocuments/StrConv-test.xls Binary files differdeleted file mode 100755 index 198abbec5..000000000 --- a/sc/source/ui/vba/testvba/TestDocuments/StrConv-test.xls +++ /dev/null diff --git a/sc/source/ui/vba/testvba/TestDocuments/Template.xls b/sc/source/ui/vba/testvba/TestDocuments/Template.xls Binary files differdeleted file mode 100755 index 4387231fe..000000000 --- a/sc/source/ui/vba/testvba/TestDocuments/Template.xls +++ /dev/null diff --git a/sc/source/ui/vba/testvba/TestDocuments/TestAddress.xls b/sc/source/ui/vba/testvba/TestDocuments/TestAddress.xls Binary files differdeleted file mode 100644 index 48d30cbe2..000000000 --- a/sc/source/ui/vba/testvba/TestDocuments/TestAddress.xls +++ /dev/null diff --git a/sc/source/ui/vba/testvba/TestDocuments/TestCalc_Rangetest.xls b/sc/source/ui/vba/testvba/TestDocuments/TestCalc_Rangetest.xls Binary files differdeleted file mode 100644 index a497d4f10..000000000 --- a/sc/source/ui/vba/testvba/TestDocuments/TestCalc_Rangetest.xls +++ /dev/null diff --git a/sc/source/ui/vba/testvba/TestDocuments/TestCalc_Rangetest2.xls b/sc/source/ui/vba/testvba/TestDocuments/TestCalc_Rangetest2.xls Binary files differdeleted file mode 100644 index 34c606fc2..000000000 --- a/sc/source/ui/vba/testvba/TestDocuments/TestCalc_Rangetest2.xls +++ /dev/null diff --git a/sc/source/ui/vba/testvba/TestDocuments/TestIntersection.xls b/sc/source/ui/vba/testvba/TestDocuments/TestIntersection.xls Binary files differdeleted file mode 100644 index 24f88db87..000000000 --- a/sc/source/ui/vba/testvba/TestDocuments/TestIntersection.xls +++ /dev/null diff --git a/sc/source/ui/vba/testvba/TestDocuments/TestUnion.xls b/sc/source/ui/vba/testvba/TestDocuments/TestUnion.xls Binary files differdeleted file mode 100644 index 5b8f0968c..000000000 --- a/sc/source/ui/vba/testvba/TestDocuments/TestUnion.xls +++ /dev/null diff --git a/sc/source/ui/vba/testvba/TestDocuments/Window.xls b/sc/source/ui/vba/testvba/TestDocuments/Window.xls Binary files differdeleted file mode 100644 index 6fb6963c2..000000000 --- a/sc/source/ui/vba/testvba/TestDocuments/Window.xls +++ /dev/null diff --git a/sc/source/ui/vba/testvba/TestDocuments/bytearraystring.xls b/sc/source/ui/vba/testvba/TestDocuments/bytearraystring.xls Binary files differdeleted file mode 100755 index 471bbc349..000000000 --- a/sc/source/ui/vba/testvba/TestDocuments/bytearraystring.xls +++ /dev/null diff --git a/sc/source/ui/vba/testvba/TestDocuments/dateserial.xls b/sc/source/ui/vba/testvba/TestDocuments/dateserial.xls Binary files differdeleted file mode 100755 index 768fb513e..000000000 --- a/sc/source/ui/vba/testvba/TestDocuments/dateserial.xls +++ /dev/null diff --git a/sc/source/ui/vba/testvba/TestDocuments/datevalue.xls b/sc/source/ui/vba/testvba/TestDocuments/datevalue.xls Binary files differdeleted file mode 100755 index 852a51d10..000000000 --- a/sc/source/ui/vba/testvba/TestDocuments/datevalue.xls +++ /dev/null diff --git a/sc/source/ui/vba/testvba/TestDocuments/format.xls b/sc/source/ui/vba/testvba/TestDocuments/format.xls Binary files differdeleted file mode 100644 index 99ed64d38..000000000 --- a/sc/source/ui/vba/testvba/TestDocuments/format.xls +++ /dev/null diff --git a/sc/source/ui/vba/testvba/TestDocuments/logs/excel/AutoFilter.log b/sc/source/ui/vba/testvba/TestDocuments/logs/excel/AutoFilter.log deleted file mode 100644 index 1fe0cbd01..000000000 --- a/sc/source/ui/vba/testvba/TestDocuments/logs/excel/AutoFilter.log +++ /dev/null @@ -1,20 +0,0 @@ -Test run started : 17/07/2007 17:36:22
-----------------------------------------------------------------
-TestAddress
- TEST START : TestAddress
- ITEM Assertion OK : test1 'starts with' string criteria
- ITEM Assertion OK : test2 'not equal to' string criteria
- ITEM Assertion OK : test3 'ends with' string criteria
- ITEM Assertion OK : test4 field 'all'
- ITEM Assertion OK : test5 numeric '<15'
- ITEM Assertion OK : test6 numeric '>=15'
- ITEM Assertion OK : test7 numeric '<=12'
-Test Results -============ - -Tests passed: 7 -Tests failed: 0 -
-END 'TestAddress
- TEST OK : TestAddress
-Test run finished : 17/07/2007 17:36:23
diff --git a/sc/source/ui/vba/testvba/TestDocuments/logs/excel/MiscRangeTests.log b/sc/source/ui/vba/testvba/TestDocuments/logs/excel/MiscRangeTests.log deleted file mode 100644 index 260465386..000000000 --- a/sc/source/ui/vba/testvba/TestDocuments/logs/excel/MiscRangeTests.log +++ /dev/null @@ -1,45 +0,0 @@ -Test run started : 17/07/2007 15:01:37
-----------------------------------------------------------------
-MiscRangeTests
- TEST START : MiscRangeTests
- ITEM Assertion OK : test 1
- ITEM Assertion OK : test 2
- ITEM Assertion OK : test 3
- ITEM Assertion OK : test 4
- ITEM Assertion OK : test 5
- ITEM Assertion OK : test 6
- ITEM Assertion OK : test 7
- ITEM Assertion OK : test 8
- ITEM Assertion OK : test 9
- ITEM Assertion OK : test 10
- ITEM Assertion OK : test 11
- ITEM Assertion OK : test 12
- ITEM Assertion OK : test 13
- ITEM Assertion OK : test 14
- ITEM Assertion OK : test 15
- ITEM Assertion OK : test 16
- ITEM Assertion OK : test 17
- ITEM Assertion OK : test 18
- ITEM Assertion OK : test 19
- ITEM Assertion OK : test 20
- ITEM Assertion OK : test 21
- ITEM Assertion OK : test 22
- ITEM Assertion OK : test 23
- ITEM Assertion OK : test 24
- ITEM Assertion OK : test 25
- ITEM Assertion OK : test 26
- ITEM Assertion OK : test 27
- ITEM Assertion OK : test 28
- ITEM Assertion OK : test 29
- ITEM Assertion OK : test 30
- ITEM Assertion OK : test 31
-No. tests: 31 -Summary -======= -Run: 31 -Passed: 31 -Failed: 0 -
-END 'MiscRangeTests
- TEST OK : MiscRangeTests
-Test run finished : 17/07/2007 15:01:39
diff --git a/sc/source/ui/vba/testvba/TestDocuments/logs/excel/Ranges-2.log b/sc/source/ui/vba/testvba/TestDocuments/logs/excel/Ranges-2.log deleted file mode 100644 index 736d5bbc4..000000000 --- a/sc/source/ui/vba/testvba/TestDocuments/logs/excel/Ranges-2.log +++ /dev/null @@ -1,68 +0,0 @@ -Test run started : 18/06/2007 17:50:04
-----------------------------------------------------------------
-ClearFormtsIssue
- TEST START : ClearFormtsIssue
- ITEM Assertion OK : Range.Font.Bold is: True
- ITEM Assertion OK : Range.Font.Bold is: False
-END 'ClearFormtsIssue' Symbol
- TEST OK : ClearFormtsIssue
-----------------------------------------------------------------
-VerticalAlignment-Issue
- TEST START : VerticalAlignment-Issue
- ITEM Assertion OK : - Range.VerticalAlignment (get)
- ITEM Assertion OK : - Range.VerticalAlignment (set)
- ITEM Assertion OK : - Range.VerticalAlignment (get)
- ITEM Assertion OK : - Range.VerticalAlignment (get)
- ITEM Assertion OK : - Range.VerticalAlignment (set)
- ITEM Assertion OK : - Range.VerticalAlignment (get)
- ITEM Assertion OK : - Range.VerticalAlignment (set)
- ITEM Assertion OK : Range.VeritcalAlignment is Null
-END 'VerticalAlignment-Issue' Symbol
- TEST OK : VerticalAlignment-Issue
-----------------------------------------------------------------
-HorizontalAlignment-Issue
- TEST START : HorizontalAlignment-Issue
- ITEM Assertion OK : - Range.HorizontalAlignment (get)
- ITEM Assertion OK : - Range.HorizontalAlignment (set)
- ITEM Assertion OK : - Range.HorizontalAlignment (get)
- ITEM Assertion OK : - Range.HorizontalAlignment (set)
- ITEM Assertion OK : - Range.HorizontalAlignment (get)
- ITEM Assertion OK : - Range.HorizontalAlignment (set)
- ITEM Assertion OK : - Range.HorizontalAlignment (get)
- ITEM Assertion OK : - Range.HorizontalAlignment (set)
- ITEM Assertion OK : Range.HorizontalAlignment is Null
-END 'HorizontalAlignment-Issue' Symbol
- TEST OK : HorizontalAlignment-Issue
-----------------------------------------------------------------
-WrapText-Issue
- TEST START : WrapText-Issue
- ITEM Assertion OK : - Range.WrapText (get)
- ITEM Assertion OK : - Range.WrapText (get)
- ITEM Assertion OK : Range.WrapText is Null
-END 'WrapText-Issue' Symbol
- TEST OK : WrapText-Issue
-----------------------------------------------------------------
-FontBorderIssues
- TEST START : FontBorderIssues
- ITEM Assertion OK : - = Borders.Color (getColor)
- ITEM Assertion OK : - = Font.Color (getColor)
-END 'FontBorderIssues' Symbol
- TEST OK : FontBorderIssues
-----------------------------------------------------------------
-RangeSizeIssues
- TEST START : RangeSizeIssues
- ITEM Assertion OK : Range.Left is: 114
- ITEM Assertion OK : Range.Top is: 95.25
- ITEM Assertion OK : Range.Width is: 216
- ITEM Assertion OK : Range.Height is: 271.5
-END 'RangeSizeIssues' Symbol
- TEST OK : RangeSizeIssues
-----------------------------------------------------------------
-ApplicationIssues
- TEST START : ApplicationIssues
- ITEM Assertion OK : Range.Address is: $E$8:$G$13,$G$13:$K$19
- ITEM Assertion OK : Range.Address is: $E$8:$G$13,$G$13:$K$19
- ITEM Assertion OK : Application.ActiveSheet.Name: Sheet1
-END 'ApplicationIssues' Symbol
- TEST OK : ApplicationIssues
-Test run finished : 18/06/2007 17:50:04
diff --git a/sc/source/ui/vba/testvba/TestDocuments/logs/excel/Ranges-3.log b/sc/source/ui/vba/testvba/TestDocuments/logs/excel/Ranges-3.log deleted file mode 100644 index a7de979d5..000000000 --- a/sc/source/ui/vba/testvba/TestDocuments/logs/excel/Ranges-3.log +++ /dev/null @@ -1,8 +0,0 @@ -Test run started : 19/06/2007 11:21:42
-----------------------------------------------------------------
-MyGoalseek-Issue
- TEST START : MyGoalseek-Issue
- ITEM Assertion OK : Variable Range value: 15
-END 'MyGoalseek-Issue' Symbol
- TEST OK : MyGoalseek-Issue
-Test run finished : 19/06/2007 11:21:42
diff --git a/sc/source/ui/vba/testvba/TestDocuments/logs/excel/Ranges.log b/sc/source/ui/vba/testvba/TestDocuments/logs/excel/Ranges.log deleted file mode 100644 index 8c9644aac..000000000 --- a/sc/source/ui/vba/testvba/TestDocuments/logs/excel/Ranges.log +++ /dev/null @@ -1,280 +0,0 @@ -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
diff --git a/sc/source/ui/vba/testvba/TestDocuments/logs/excel/TestAddress.log b/sc/source/ui/vba/testvba/TestDocuments/logs/excel/TestAddress.log deleted file mode 100644 index 01e5503a7..000000000 --- a/sc/source/ui/vba/testvba/TestDocuments/logs/excel/TestAddress.log +++ /dev/null @@ -1,62 +0,0 @@ -Test run started : 17/07/2007 15:25:17
-----------------------------------------------------------------
-TestAddress
- TEST START : TestAddress
- ITEM Assertion OK : test1 Range('e3:f3') A1 style addressing
- ITEM Assertion OK : test2 Range('e3:f3') R1C1 style addressing
- ITEM Assertion OK : test3 Range ('e:f') A1 style addressing
- ITEM Assertion OK : test4 Range ('e:f') R1C1 style addressing
- ITEM Assertion OK : test5 Columns A1 style addressing
- ITEM Assertion OK : test6 Columns R1C1 style addressing
- ITEM Assertion OK : test7 Columns(3) A1 style addressing
- ITEM Assertion OK : test8 Columns(3) R1C1 style addressing
- ITEM Assertion OK : test9 Columns('e') A1 style addressing
- ITEM Assertion OK : test10 Columns('e') R1C1 style addressing
- ITEM Assertion OK : test11 Columns('b:d') A1 style addressing
- ITEM Assertion OK : test12 Columns('b:d') R1C1 style addressing
- ITEM Assertion OK : test13 Range('c1:g10').Columns A1 style addressing
- ITEM Assertion OK : test14 Range('c1:g10').Columns R1C1 style addressing
- ITEM Assertion OK : test15 Range('c1:g10').Columns(1) A1 style addressing
- ITEM Assertion OK : test16 Range('c1:g10').Columns(1) R1C1 style addressing
- ITEM Assertion OK : test17 Range('c1:g10').Columns('a') A1 style addressing
- ITEM Assertion OK : test18 Range('c1:g10').Columns('a') R1C1 style addressing
- ITEM Assertion OK : test19 Range('c1:g10').Columns('c') A1 style addressing
- ITEM Assertion OK : test20 Range('c1:g10').Columns('c') R1C1 style addressing
- ITEM Assertion OK : test21 Range('c1:g10').Columns('x:z') A1 style addressing
- ITEM Assertion OK : test22 Range('c1:g10').Columns('x:z') R1C1 style addressing
- ITEM Assertion OK : test23 Range('c1:g10').Columns(30) A1 style addressing
- ITEM Assertion OK : test24 Range('c1:g10').Columns(30) R1C1 style addressing
- ITEM Assertion OK : test25 Worksheets('Sheet2').Cells(1, 1) A1 style addressing
- ITEM Assertion OK : test26 Worksheets('Sheet2').Cells(1, 1) A1 style addressing, RowAddressAbsolute is false
- ITEM Assertion OK : test27 Worksheets('Sheet2').Cells(1, 1) A1 style addressing, ColAddressAbsolute is false
- ITEM Assertion OK : test28 Worksheets('Sheet2').Cells(1, 1) R1C1 style addressing
- ITEM Assertion OK : test29 Worksheets('Sheet2').Range('A1:E5').EntireColumn A1 style addressing
- ITEM Assertion OK : test30 Worksheets('Sheet2').Range('A1').EntireColumn A1 style addressing
- ITEM Assertion OK : test31 Worksheets('Sheet2').Range('A1:E5').EntireRow A1 style addressing
- ITEM Assertion OK : test32 Worksheets('Sheet2').Range('A1') A1 style addressing
- ITEM Assertion OK : test33 Worksheets('Sheet2').Range('IV65536').EntireRow A1 style addressing
- ITEM Assertion OK : test34 Worksheets('Sheet2').Range('IU2:IV65536') A1 style addressing
- ITEM Assertion OK : test35 Range('c1:g10').Columns('x:z') R1C1 style addressing
- ITEM Assertion OK : test36 Worksheets('Sheet2').Range('A1') A1 style addressing
- ITEM Assertion OK : test37 Worksheets('Sheet2').Range('A1:E5').EntireColumn A1 style addressing
- ITEM Assertion OK : test38 Worksheets('Sheet2').Range('10:12') A1 style addressing
- ITEM Assertion OK : test39 Worksheets('Sheet2').Range('10:12') R1C1 style addressing
- ITEM Assertion OK : test40 Range('Sheet3!A1:B4') A1 style addressing
- ITEM Assertion OK : test41 Range('Sheet3!A1,B1,D4:F20') A1 style addressing
- ITEM Assertion OK : test42 Range('g20:h40').Columns('c:c')
- ITEM Assertion OK : test43 Range('g20:h40').Columns('c:f')
- ITEM Assertion OK : test44 Range('g20:h40').Columns(-1)
- ITEM Assertion OK : test45 Range('c4:g10').Rows(-1)
- ITEM Assertion OK : test46 Range('a2:b4').Rows('1:1')
- ITEM Assertion OK : test47 Range('a2:b4').Rows('1:2')
- ITEM Assertion OK : test48 Range('a2:b4').Rows('2:2')
- ITEM Assertion OK : test49 Range('a2:b4').Rows('2:3')
-Test Results -============ - -Tests passed: 49 -Tests failed: 0 -
-END 'TestAddress
- TEST OK : TestAddress
-Test run finished : 17/07/2007 15:25:19
diff --git a/sc/source/ui/vba/testvba/TestDocuments/logs/excel/TestCalc_Rangetest.log b/sc/source/ui/vba/testvba/TestDocuments/logs/excel/TestCalc_Rangetest.log deleted file mode 100644 index f055279ec..000000000 --- a/sc/source/ui/vba/testvba/TestDocuments/logs/excel/TestCalc_Rangetest.log +++ /dev/null @@ -1,60 +0,0 @@ -Test run started : 30/05/2007 11:33:13
-BEGIN TestCalc
- TEST START : RangeTest2
- ITEM Assertion OK : - Range("D15").Row
- ITEM Assertion OK : - WorkSheet("D15").Range.Row
- ITEM Assertion OK : - Range("D15").Column
- ITEM Assertion OK : - Worksheet.Range("D15").Column
- ITEM Assertion OK : - Range("D1").EntireRow.Valuer
- ITEM Assertion OK : - Range("D1").EntireRow.Valuer
- ITEM Assertion OK : - Range("D1").EntireRow.Columns.Count
- ITEM Assertion OK : - Range("D1").EntireColumn.Rows.Count
- ITEM Assertion OK : - Range("D15").ClearContent
- ITEM Assertion OK : - Range("M1:N2").Rows.Hidden (set)
- ITEM Assertion OK : - Range("M1:N2").Rows.Hidden (get)
- ITEM Assertion OK : - Range("M1:N2").Rows(1).Hidden (set)
- ITEM Assertion OK : - Range("M1:N2").Rows(1).Hidden (get)
- ITEM Assertion OK : - Range("M1:N2").Columns.Hidden (set)
- ITEM Assertion OK : - Range("M1:N2").Columns.Hidden (get)
- ITEM Assertion OK : - Range("M1:N2").Columns(1).Hidden (set)
- ITEM Assertion OK : - Range("M1:N2").Columns(1).Hidden (get)
- ITEM Assertion OK : - Range("B38").Orientation (get)
- ITEM Assertion OK : - Range("B38").Orientation (set)
- ITEM Assertion OK : - Range("B38").Orientation (set = xlDownward)
- ITEM Assertion OK : - Range("B38").Orientation (set)
- ITEM Assertion OK : - Range("B38").Orientation (set = xlUpward)
- ITEM Assertion OK : - Range("B38").Orientation (set)
- ITEM Assertion OK : - Range("B38").Orientation (set = xlVertical)
- ITEM Assertion OK : - Range("B38").Orientation (set)
- ITEM Assertion OK : - Range("B38").Orientation (set = xlVertical)
- ITEM Assertion OK : - Range("B39").WrapText (get)
- ITEM Assertion OK : - Range("B39").WrapText (set)
- ITEM Assertion OK : - Range("B39").WrapText (set)
- ITEM Assertion OK : - Range("E39").MergeCells (get)
- ITEM Assertion OK : - Range("F39").MergeCells (get)
- ITEM Assertion OK : - Range("E39").MergeCells (set)
- ITEM Assertion OK : - Range("F39").MergeCells (set)
- ITEM Assertion OK : - Range("E39").MergeCells (set)
- ITEM Assertion OK : - Range("F39").MergeCells (set)
- ITEM Assertion OK : - Range("C41:C42").Replace MatchCase:=True
- ITEM Assertion OK : - Range("C41:C42").Replace MatchCase:=True
- ITEM Assertion OK : - Range("D41:D42").Replace MatchCase:=False
- ITEM Assertion OK : - Range("B39").VerticalAlignment (get)
- ITEM Assertion OK : - Range("B39").VerticalAlignment (set)
- ITEM Assertion OK : - Range("B39").VerticalAlignment (get)
- ITEM Assertion OK : - Range("B39").VerticalAlignment (get)
- ITEM Assertion OK : - Range("B39").VerticalAlignment (set)
- ITEM Assertion OK : - Range("B39").VerticalAlignment (get)
- ITEM Assertion OK : - Range("B39").VerticalAlignment (set)
- ITEM Assertion OK : - Range("B39").HorizontalAlignment (get)
- ITEM Assertion OK : - Range("B39").HorizontalAlignment (set)
- ITEM Assertion OK : - Range("B39").HorizontalAlignment (get)
- ITEM Assertion OK : - Range("B39").HorizontalAlignment (set)
- ITEM Assertion OK : - Range("B39").HorizontalAlignment (get)
- ITEM Assertion OK : - Range("B39").HorizontalAlignment (set)
- ITEM Assertion OK : - Range("B39").HorizontalAlignment (get)
- ITEM Assertion OK : - Range("B39").HorizontalAlignment (set)
- ITEM OK (RangeTest2)
- TEST succesfully completed : RangeTest2
-END TestCalc
-Test run finished : 30/05/2007 11:33:14
diff --git a/sc/source/ui/vba/testvba/TestDocuments/logs/excel/TestCalc_Rangetest2.log b/sc/source/ui/vba/testvba/TestDocuments/logs/excel/TestCalc_Rangetest2.log deleted file mode 100644 index 19a5ba96b..000000000 --- a/sc/source/ui/vba/testvba/TestDocuments/logs/excel/TestCalc_Rangetest2.log +++ /dev/null @@ -1,64 +0,0 @@ -Test run started : 31/05/2007 11:02:10
-BEGIN TestCalc
- TEST START : RangeTest3
- ITEM Assertion OK : - setFormulaR1C1
- ITEM Assertion OK : - getFormulaR1C1
- ITEM Assertion OK : - Range.Copy() and Range.PasteSpecial()
- ITEM Assertion OK : - Range.Copy(Range("I10"))
- ITEM Assertion OK : PasteSpecial Paste:=xlPasteValues
- ITEM Assertion OK : PasteSpecial Paste:=xlPasteFormulas
- ITEM Assertion OK : PasteSpecial Paste:=xlPasteFormats
- ITEM Assertion OK : PasteSpecial
- ITEM Assertion OK : PasteSpecial SkipBlanks:=True
- ITEM Assertion OK : PasteSpecial Operation:=xlPasteSpecialOperationAdd
- ITEM Assertion OK : PasteSpecial Operation:=xlPasteSpecialOperationSubtract
- ITEM Assertion OK : PasteSpecial Operation:=xlPasteSpecialOperationMultiply
- ITEM Assertion OK : PasteSpecial Operation:=xlPasteSpecialOperationDivide
- ITEM Assertion OK : PasteSpecial Transpose:=True
- ITEM Assertion OK : ActiveWorkbook.Name
- ITEM Assertion OK : ActiveWorkbook.FullName und ActiveWorkbook.Path
- ITEM Assertion OK : - = Range("K22").End (xlDown)
- ITEM Assertion OK : - = Range("K22").End (xlUo)
- ITEM Assertion OK : - = Range("K22").End (xlToLeft)
- ITEM Assertion OK : - = Range("K22").End (xlRight)
- ITEM Assertion OK : - ActiveSpreadsheet.Next
- ITEM Assertion OK : - ActiveSpreadsheet.Next
- ITEM Assertion OK : - ActiveSpreadsheet.Previous
- ITEM Assertion OK : - ActiveSpreadsheet.Previous
- ITEM Assertion OK : - Range("J4:J11").AutoFilter field:=1, Criteria1:="x"
- ITEM Assertion OK : - Range("J4:J11").AutoFilter field:=1, Criteria1:="<>"
- ITEM Assertion OK : - Range("J4:J11").AutoFilter field:=1, Criteria1:="="
- ITEM Assertion OK : - Range("J4:J11").AutoFilter
- ITEM Assertion OK : - ActiveSheet.Resize.Select
- ITEM Assertion OK : - Application.GoTo Reference:="R8C2"
- ITEM Assertion OK : - Application.GoTo Reference:="R[8]C[2]"
- ITEM Assertion OK : - Application.GoTo Reference:="R8C2"
- ITEM Assertion OK : - Range.Group - please check visually
- ITEM Assertion OK : - Range.Group - please check visually
- ITEM Assertion OK : - Range.Ungroup- please check visually
- ITEM Assertion OK : - Range.Ungroup - please check visually
- ITEM Assertion OK : - Range.Group - please check visually
- ITEM Assertion OK : - Range.Group - please check visually
- ITEM Assertion OK : - Range.clearOutline - please check visually
- ITEM Assertion OK : - Range.AutoOutline - please check visually
- ITEM Assertion OK : - Range.AutoOutline - please check visually
- ITEM Assertion OK : - ActiveSheet.UsedRange.Select
- ITEM Assertion FAIL : - Range("A13").AddIndent
- ITEM Assertion OK : - Range("A13").IndentLevel set
- ITEM Assertion OK : - Range("A13").IndentLevel get
- ITEM Assertion OK : - Range("A13").IndentLevel get
- ITEM Assertion OK : - Range.Copy() and Range.PasteSpecial()
- ITEM Assertion OK : - Range.Copy() and Range.PasteSpecial()
- ITEM Assertion OK : - Range.Copy() and Range.PasteSpecial()
- ITEM Assertion OK : - Range.Calculate
- ITEM Assertion OK : Worksheet.Calculate
- ITEM Assertion OK : - Application.Calculate
- ITEM Assertion OK : Global.Calculate
- ITEM Assertion OK : Calculation set
- ITEM Assertion OK : - = ActiveWorkbook.Colors(3) set
- ITEM Assertion OK : - = ActiveWorkbook.ResetColors
- ITEM Assertion OK : - = ActiveWorkbook.Colors(3) get
- ITEM FAIL (RangeTest3)
- TEST Not succesfully completed : RangeTest3
-END TestCalc
-Test run finished : 31/05/2007 11:02:12
diff --git a/sc/source/ui/vba/testvba/TestDocuments/logs/unix/AutoFilter.log b/sc/source/ui/vba/testvba/TestDocuments/logs/unix/AutoFilter.log deleted file mode 100644 index 55f5d9526..000000000 --- a/sc/source/ui/vba/testvba/TestDocuments/logs/unix/AutoFilter.log +++ /dev/null @@ -1,20 +0,0 @@ -Test run started : 18/07/2007 10:56:38 ----------------------------------------------------------------- -TestAddress - TEST START : TestAddress - ITEM Assertion OK : test1 'starts with' string criteria - ITEM Assertion OK : test2 'not equal to' string criteria - ITEM Assertion OK : test3 'ends with' string criteria - ITEM Assertion OK : test4 field 'all' - ITEM Assertion OK : test5 numeric '<15' - ITEM Assertion OK : test6 numeric '>=15' - ITEM Assertion OK : test7 numeric '<=12' -Test Results -============ - -Tests passed: 7 -Tests failed: 0 - -END 'TestAddress - TEST OK : TestAddress -Test run finished : 18/07/2007 10:56:44 diff --git a/sc/source/ui/vba/testvba/TestDocuments/logs/unix/CalcFont.log b/sc/source/ui/vba/testvba/TestDocuments/logs/unix/CalcFont.log deleted file mode 100644 index f3583e4cb..000000000 --- a/sc/source/ui/vba/testvba/TestDocuments/logs/unix/CalcFont.log +++ /dev/null @@ -1,17 +0,0 @@ -Test run started : 10/09/2008 02:40:17 PM -CalcFont_Format - TEST START : Font_Format - ITEM Assertion OK : correctly set font to Bold - ITEM Assertion OK : correctly set font to Italic - ITEM Assertion OK : correctly read FontStyle - ITEM Assertion OK : correctly set font to Shadow - ITEM Assertion OK : correctly set font color - ITEM Assertion OK : correctly set font color index - ITEM Assertion OK : correctly set font name - ITEM Assertion OK : correctly set font outline - ITEM Assertion OK : correctly set font size - ITEM Assertion OK : correctly set font strikethrough - ITEM Assertion OK : correctly set font underline - TEST Success. : Font_Format -CalcFont_Format -Test run finished : 10/09/2008 02:40:17 PM diff --git a/sc/source/ui/vba/testvba/TestDocuments/logs/unix/MiscRangeTests.log b/sc/source/ui/vba/testvba/TestDocuments/logs/unix/MiscRangeTests.log deleted file mode 100644 index 215842f9a..000000000 --- a/sc/source/ui/vba/testvba/TestDocuments/logs/unix/MiscRangeTests.log +++ /dev/null @@ -1,45 +0,0 @@ -Test run started : 17/07/2007 20:54:56 ----------------------------------------------------------------- -MiscRangeTests - TEST START : MiscRangeTests - ITEM Assertion OK : test 1 - ITEM Assertion OK : test 2 - ITEM Assertion OK : test 3 - ITEM Assertion OK : test 4 - ITEM Assertion OK : test 5 - ITEM Assertion OK : test 6 - ITEM Assertion OK : test 7 - ITEM Assertion OK : test 8 - ITEM Assertion OK : test 9 - ITEM Assertion OK : test 10 - ITEM Assertion OK : test 11 - ITEM Assertion OK : test 12 - ITEM Assertion OK : test 13 - ITEM Assertion OK : test 14 - ITEM Assertion OK : test 15 - ITEM Assertion OK : test 16 - ITEM Assertion OK : test 17 - ITEM Assertion OK : test 18 - ITEM Assertion OK : test 19 - ITEM Assertion OK : test 20 - ITEM Assertion OK : test 21 - ITEM Assertion OK : test 22 - ITEM Assertion OK : test 23 - ITEM Assertion OK : test 24 - ITEM Assertion OK : test 25 - ITEM Assertion OK : test 26 - ITEM Assertion OK : test 27 - ITEM Assertion OK : test 28 - ITEM Assertion OK : test 29 - ITEM Assertion OK : test 30 - ITEM Assertion OK : test 31 -No. tests: 31 -Summary -======= -Run: 31 -Passed: 31 -Failed: 0 - -END 'MiscRangeTests - TEST OK : MiscRangeTests -Test run finished : 17/07/2007 20:55:03 diff --git a/sc/source/ui/vba/testvba/TestDocuments/logs/unix/PageBreaks.log b/sc/source/ui/vba/testvba/TestDocuments/logs/unix/PageBreaks.log deleted file mode 100644 index 0ff400d49..000000000 --- a/sc/source/ui/vba/testvba/TestDocuments/logs/unix/PageBreaks.log +++ /dev/null @@ -1,10 +0,0 @@ -Test run started : 07/24/2008 05:06:12 PM ----------------------------------------------------------------- - TEST START : PageBreaks-Issue - ITEM Assertion OK : HPageBreaks.Count is 3 - ITEM Assertion OK : HPageBreak.Type is -4135 - ITEM Assertion OK : HPageBreak.Location: Range.Row is 5 - ITEM Assertion OK : HPageBreak.Delete: HPageBreaks.Count is 2 -END 'PageBreaks-Issue' Symbol - TEST OK : PageBreaks-Issue -Test run finished : 07/24/2008 05:06:13 PM diff --git a/sc/source/ui/vba/testvba/TestDocuments/logs/unix/Ranges-2.log b/sc/source/ui/vba/testvba/TestDocuments/logs/unix/Ranges-2.log deleted file mode 100644 index 8b7076efa..000000000 --- a/sc/source/ui/vba/testvba/TestDocuments/logs/unix/Ranges-2.log +++ /dev/null @@ -1,68 +0,0 @@ -Test run started : 19/06/2007 11:14:01 ----------------------------------------------------------------- -ClearFormtsIssue - TEST START : ClearFormtsIssue - ITEM Assertion OK : Range.Font.Bold is: True - ITEM Assertion OK : Range.Font.Bold is: False -END 'ClearFormtsIssue' Symbol - TEST OK : ClearFormtsIssue ----------------------------------------------------------------- -VerticalAlignment-Issue - TEST START : VerticalAlignment-Issue - ITEM Assertion OK : - Range.VerticalAlignment (get) - ITEM Assertion OK : - Range.VerticalAlignment (set) - ITEM Assertion OK : - Range.VerticalAlignment (get) - ITEM Assertion OK : - Range.VerticalAlignment (get) - ITEM Assertion OK : - Range.VerticalAlignment (set) - ITEM Assertion OK : - Range.VerticalAlignment (get) - ITEM Assertion OK : - Range.VerticalAlignment (set) - ITEM Assertion OK : Range.VeritcalAlignment is Null -END 'VerticalAlignment-Issue' Symbol - TEST OK : VerticalAlignment-Issue ----------------------------------------------------------------- -HorizontalAlignment-Issue - TEST START : HorizontalAlignment-Issue - ITEM Assertion OK : - Range.HorizontalAlignment (get) - ITEM Assertion OK : - Range.HorizontalAlignment (set) - ITEM Assertion OK : - Range.HorizontalAlignment (get) - ITEM Assertion OK : - Range.HorizontalAlignment (set) - ITEM Assertion OK : - Range.HorizontalAlignment (get) - ITEM Assertion OK : - Range.HorizontalAlignment (set) - ITEM Assertion OK : - Range.HorizontalAlignment (get) - ITEM Assertion OK : - Range.HorizontalAlignment (set) - ITEM Assertion OK : Range.HorizontalAlignment is Null -END 'HorizontalAlignment-Issue' Symbol - TEST OK : HorizontalAlignment-Issue ----------------------------------------------------------------- -WrapText-Issue - TEST START : WrapText-Issue - ITEM Assertion OK : - Range.WrapText (get) - ITEM Assertion OK : - Range.WrapText (get) - ITEM Assertion OK : Range.WrapText is Null -END 'WrapText-Issue' Symbol - TEST OK : WrapText-Issue ----------------------------------------------------------------- -FontBorderIssues - TEST START : FontBorderIssues - ITEM Assertion OK : - = Borders.Color (getColor) - ITEM Assertion OK : - = Font.Color (getColor) -END 'FontBorderIssues' Symbol - TEST OK : FontBorderIssues ----------------------------------------------------------------- -RangeSizeIssues - TEST START : RangeSizeIssues - ITEM Assertion OK : Range.Left is: 118.8432 - ITEM Assertion OK : Range.Top is: 92.16585 - ITEM Assertion OK : Range.Width is: 226.2 - ITEM Assertion OK : Range.Height is: 271.5 -END 'RangeSizeIssues' Symbol - TEST OK : RangeSizeIssues ----------------------------------------------------------------- -ApplicationIssues - TEST START : ApplicationIssues - ITEM Assertion OK : Range.Address is: $E$8:$G$13,$G$13:$K$19 - ITEM Assertion OK : Range.Address is: $E$8:$G$13,$G$13:$K$19 - ITEM Assertion OK : Application.ActiveSheet.Name: Sheet1 -END 'ApplicationIssues' Symbol - TEST OK : ApplicationIssues -Test run finished : 19/06/2007 11:14:02 diff --git a/sc/source/ui/vba/testvba/TestDocuments/logs/unix/Ranges-3.log b/sc/source/ui/vba/testvba/TestDocuments/logs/unix/Ranges-3.log deleted file mode 100644 index a130737ce..000000000 --- a/sc/source/ui/vba/testvba/TestDocuments/logs/unix/Ranges-3.log +++ /dev/null @@ -1,8 +0,0 @@ -Test run started : 19/06/2007 11:26:09 ----------------------------------------------------------------- -MyGoalseek-Issue - TEST START : MyGoalseek-Issue - ITEM Assertion OK : Variable Range value: 15 -END 'MyGoalseek-Issue' Symbol - TEST OK : MyGoalseek-Issue -Test run finished : 19/06/2007 11:26:10 diff --git a/sc/source/ui/vba/testvba/TestDocuments/logs/unix/Ranges.log b/sc/source/ui/vba/testvba/TestDocuments/logs/unix/Ranges.log deleted file mode 100644 index cdd18685e..000000000 --- a/sc/source/ui/vba/testvba/TestDocuments/logs/unix/Ranges.log +++ /dev/null @@ -1,280 +0,0 @@ -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 diff --git a/sc/source/ui/vba/testvba/TestDocuments/logs/unix/Shapes.log b/sc/source/ui/vba/testvba/TestDocuments/logs/unix/Shapes.log deleted file mode 100644 index 3193a0b10..000000000 --- a/sc/source/ui/vba/testvba/TestDocuments/logs/unix/Shapes.log +++ /dev/null @@ -1,77 +0,0 @@ -Test run started : 10/16/2007 05:25:21 PM -BEGIN Shapes_Collection_Behaviour - TEST START : Shapes_Collection_Behaviour - ITEM Assertion OK : Name of indexed shape should be 'Sheet2Shape1' - ITEM Assertion OK : Name of indexed shape should be 'Sheet2Shape2' - TEST Success. : Shapes_Collection_Behaviour -END Shapes_Collection_Behaviour -BEGIN Shapes_Select_Item - TEST START : Shapes_Select_Item - ITEM Assertion OK : Correctly selected shape through Range - ITEM Assertion OK : Correctly selected shape through Item - ITEM Assertion OK : Needs to be visually checked. Is there a line on the document? - ITEM Assertion OK : Needs to be visually checked. Are All Shapes Selected? - TEST Success. : Shapes_Select_Item -END Shapes_Select_Item -BEGIN Shapes_Fill - TEST START : Shapes_Fill - ITEM Assertion OK : correctly set visibility of shape fill - ITEM Assertion OK : correctly set transparency of shape line - ITEM Assertion OK : correctly set forecolor of shape fill - ITEM Assertion FAIL : correctly set backcolor of shape fill - ITEM Assertion OK : the success of the TwoColorGradient method needs to be verified visually! - ITEM Assertion OK : correctly set forecolor of shape fill - ITEM Assertion FAIL : correctly set forecolor of shape fill - TEST Success. : Shapes_Fill -END Shapes_Fill -BEGIN Shapes_Line - TEST START : Shapes_Line - ITEM Assertion FAIL : correctly set weight of shape line - ITEM Assertion OK : correctly set visibility of shape line - ITEM Assertion OK : correctly set transparency of shape line - ITEM Assertion OK : correctly set dash style of shape line - ITEM Assertion OK : correctly set dash style of shape line - ITEM Assertion OK : correctly set forecolor of shape line - ITEM Assertion FAIL : correctly set backcolor of shape line - TEST Success. : Shapes_Line -END Shapes_Line -BEGIN Shapes_TextFrame - TEST START : Shapes_TextFrame - ITEM Assertion OK : correctly set Autosize of Shape TextFrame - TEST Success. : Shapes_TextFrame -END Shapes_TextFrame -BEGIN Shapes_SimpleGeometry - TEST START : Shapes_SimpleGeometery - ITEM Assertion OK : shape height should be 47.0425168477155 and got 46.9984222363199 - ITEM Assertion OK : shape width should be 101.467710269751 and got 101.423615658355 - ITEM Assertion OK : shape left should be 68.5574761223637 and got 68.5417279658754 - ITEM Assertion OK : shape top should be 42.0251943291216 and got 42.0094461726333 - ITEM Assertion OK : shape rotation should be 0 and got 0 - ITEM Assertion OK : shape rotation should be 25 and got 25 - ITEM Assertion OK : shape incrementrotation should be 50 and got 50 - ITEM Assertion OK : shape incrementleft should be 70.6834602404119 and got 70.6677120839236 - ITEM Assertion OK : shape incrementtop should be 91.262986503119 and got 91.2472383466307 - TEST Success. : Shapes_SimpleGeometery -END Shapes_SimpleGeometry -BEGIN Shapes_Range - TEST START : Shapes_Range - ITEM Assertion OK : expected Sheets(2).Shapes.Range(1) to contain 1 element, it contains 1 - ITEM Assertion OK : expected Sheets(2).Shapes.Range(1) to return Sheet2Shape1 got Sheet2Shape1 - ITEM Assertion OK : expected Sheets(2).Shapes.Range(Sheet2Shape3) to contain 1 element, it contains 1 - ITEM Assertion OK : expected Sheets(2).Shapes.Range(Sheet2Shape3) to return Sheet2Shape3 got Sheet2Shape3 - ITEM Assertion OK : expected Sheets(2).Shapes.Range(Array(3, 1) to contain 2 elements, it contains 2 - ITEM Assertion OK : expected Sheets(2).Shapes.Range(Array(3, 1) to return concated element/shape names Sheet2Shape3Sheet2Shape1 and got Sheet2Shape3Sheet2Shape1 - ITEM Assertion OK : expected Sheets(2).Shapes.Range(Array('Sheet2Shape3', 1, 'Sheet2Shape2')) to contain 3 elements, it contains 3 - ITEM Assertion OK : expected Sheets(2).Shapes.Range(Array('Sheet2Shape3', 1, 'Sheet2Shape2')) to return concated element/shape names Sheet2Shape3Sheet2Shape1Sheet2Shape2 and got Sheet2Shape3Sheet2Shape1Sheet2Shape2 - TEST Success. : Shapes_Range -END Shapes_Range -BEGIN Shapes_ShapeRange - TEST START : Shapes_ShapeRange - ITEM Assertion OK : ShapeRange.IncrementLeft shp1.left should be 90.6677120839236 and got 90.6519627935771 - ITEM Assertion OK : ShapeRange.IncrementLeft shp2.left should be 240.02518299054 and got 240.009433700193 - ITEM Assertion OK : ShapeRange.IncrementTop shp1.Top should be 111.247238346631 and got 111.231489056284 - ITEM Assertion OK : ShapeRange.IncrementTop shp2.Top should be 65.0708633026228 and got 65.0551140122763 - ITEM Assertion OK : ShapeRange.IncrementRotation shp1.Rotation should be 70 and got 70 - ITEM Assertion OK : ShapeRange.IncrementRotation shp2.Rotation should be 20 and got 20 -END Shapes_ShapeRange -Test run finished : 10/16/2007 05:25:22 PM diff --git a/sc/source/ui/vba/testvba/TestDocuments/logs/unix/StrConv-test.log b/sc/source/ui/vba/testvba/TestDocuments/logs/unix/StrConv-test.log deleted file mode 100644 index c7a7d8750..000000000 --- a/sc/source/ui/vba/testvba/TestDocuments/logs/unix/StrConv-test.log +++ /dev/null @@ -1,9 +0,0 @@ -Test run started : 05/29/2008 02:51:03 PM -BEGIN StrConv - TEST START : Test StrConv function - ITEM Assertion OK : Converts the string to uppercase characters:ABC EFG HIJ - ITEM Assertion OK : Converts the string to lowercase characters:abc efg hij - ITEM Assertion OK : Converts the first letter of every word in string to uppercase:Abc Efg Hij - TEST OK : Test StrConv function -END StrConv -Test run finished : 05/29/2008 02:51:03 PM diff --git a/sc/source/ui/vba/testvba/TestDocuments/logs/unix/Template.log b/sc/source/ui/vba/testvba/TestDocuments/logs/unix/Template.log deleted file mode 100644 index c6376c5b3..000000000 --- a/sc/source/ui/vba/testvba/TestDocuments/logs/unix/Template.log +++ /dev/null @@ -1,14 +0,0 @@ -Test run started : 2008／07／10 11:57:05 ----------------------------------------------------------------- -TestCaseName - TEST START : TestCaseName - ITEM Assertion OK : Something has been done. -Test Results -============ - -Tests passed: 1 -Tests failed: 0 - -END 'TestCaseName - TEST OK : TestCaseName -Test run finished : 2008／07／10 11:57:05 diff --git a/sc/source/ui/vba/testvba/TestDocuments/logs/unix/TestAddress.log b/sc/source/ui/vba/testvba/TestDocuments/logs/unix/TestAddress.log deleted file mode 100644 index 4fa4bc820..000000000 --- a/sc/source/ui/vba/testvba/TestDocuments/logs/unix/TestAddress.log +++ /dev/null @@ -1,67 +0,0 @@ -Test run started : 12/05/2009 11:23:35 ----------------------------------------------------------------- -TestAddress - TEST START : TestAddress - ITEM Assertion OK : test1 Range('e3:f3') A1 style addressing - ITEM Assertion OK : test2 Range('e3:f3') R1C1 style addressing - ITEM Assertion OK : test3 Range ('e:f') A1 style addressing - ITEM Assertion OK : test4 Range ('e:f') R1C1 style addressing - ITEM Assertion OK : test5 Columns A1 style addressing - ITEM Assertion OK : test6 Columns R1C1 style addressing - ITEM Assertion OK : test7 Columns(3) A1 style addressing - ITEM Assertion OK : test8 Columns(3) R1C1 style addressing - ITEM Assertion OK : test9 Columns('e') A1 style addressing - ITEM Assertion OK : test10 Columns('e') R1C1 style addressing - ITEM Assertion OK : test11 Columns('b:d') A1 style addressing - ITEM Assertion OK : test12 Columns('b:d') R1C1 style addressing - ITEM Assertion OK : test13 Range('c1:g10').Columns A1 style addressing - ITEM Assertion OK : test14 Range('c1:g10').Columns R1C1 style addressing - ITEM Assertion OK : test15 Range('c1:g10').Columns(1) A1 style addressing - ITEM Assertion OK : test16 Range('c1:g10').Columns(1) R1C1 style addressing - ITEM Assertion OK : test17 Range('c1:g10').Columns('a') A1 style addressing - ITEM Assertion OK : test18 Range('c1:g10').Columns('a') R1C1 style addressing - ITEM Assertion OK : test19 Range('c1:g10').Columns('c') A1 style addressing - ITEM Assertion OK : test20 Range('c1:g10').Columns('c') R1C1 style addressing - ITEM Assertion OK : test21 Range('c1:g10').Columns('x:z') A1 style addressing - ITEM Assertion OK : test22 Range('c1:g10').Columns('x:z') R1C1 style addressing - ITEM Assertion OK : test23 Range('c1:g10').Columns(30) A1 style addressing - ITEM Assertion OK : test24 Range('c1:g10').Columns(30) R1C1 style addressing - ITEM Assertion OK : test25 Worksheets('Sheet2').Cells(1, 1) A1 style addressing - ITEM Assertion OK : test26 Worksheets('Sheet2').Cells(1, 1) A1 style addressing, RowAddressAbsolute is false - ITEM Assertion OK : test27 Worksheets('Sheet2').Cells(1, 1) A1 style addressing, ColAddressAbsolute is false - ITEM Assertion OK : test28 Worksheets('Sheet2').Cells(1, 1) R1C1 style addressing - ITEM Assertion OK : test29 Worksheets('Sheet2').Range('A1:E5').EntireColumn A1 style addressing - ITEM Assertion OK : test30 Worksheets('Sheet2').Range('A1').EntireColumn A1 style addressing - ITEM Assertion OK : test31 Worksheets('Sheet2').Range('A1:E5').EntireRow A1 style addressing - ITEM Assertion OK : test32 Worksheets('Sheet2').Range('A1') A1 style addressing - ITEM Assertion OK : test33 Worksheets('Sheet2').Range('IV65536').EntireRow A1 style addressing - ITEM Assertion OK : test34 Worksheets('Sheet2').Range('IU2:IV65536') A1 style addressing - ITEM Assertion OK : test35 Range('c1:g10').Columns('x:z') R1C1 style addressing - ITEM Assertion OK : test36 Worksheets('Sheet2').Range('A1') A1 style addressing - ITEM Assertion OK : test37 Worksheets('Sheet2').Range('A1:E5').EntireColumn A1 style addressing - ITEM Assertion OK : test38 Worksheets('Sheet2').Range('10:12') A1 style addressing - ITEM Assertion OK : test39 Worksheets('Sheet2').Range('10:12') R1C1 style addressing - ITEM Assertion OK : test40 Range('Sheet3!A1:B4') A1 style addressing - ITEM Assertion OK : test41 Range('Sheet3!A1,B1,D4:F20') A1 style addressing - ITEM Assertion OK : test42 Range('g20:h40').Columns('c:c') - ITEM Assertion OK : test43 Range('g20:h40').Columns('c:f') - ITEM Assertion OK : test44 Range('g20:h40').Columns(-1) - ITEM Assertion OK : test45 Range('c4:g10').Rows(-1) - ITEM Assertion OK : test46 Range('a2:b4').Rows('1:1') - ITEM Assertion OK : test47 Range('a2:b4').Rows('1:2') - ITEM Assertion OK : test48 Range('a2:b4').Rows('2:2') - ITEM Assertion OK : test49 Range('a2:b4').Rows('2:3') - ITEM Assertion OK : test50 Range(' A2:B4 ') - ITEM Assertion OK : test51 Range('A 2:B 4') - ITEM Assertion OK : test52 Range('A2 : B4 ') - ITEM Assertion OK : test53 Range('Sheet1 !A2 : B4 ') - ITEM Assertion OK : test54 Range('Sheet1! A2 : B4 ') -Test Results -============ - -Tests passed: 54 -Tests failed: 0 - -END 'TestAddress - TEST OK : TestAddress -Test run finished : 12/05/2009 11:23:35 diff --git a/sc/source/ui/vba/testvba/TestDocuments/logs/unix/TestCalc_Rangetest.log b/sc/source/ui/vba/testvba/TestDocuments/logs/unix/TestCalc_Rangetest.log deleted file mode 100644 index 083819d4b..000000000 --- a/sc/source/ui/vba/testvba/TestDocuments/logs/unix/TestCalc_Rangetest.log +++ /dev/null @@ -1,60 +0,0 @@ -Test run started : 30/05/2007 15:59:40 -BEGIN TestCalc - TEST START : RangeTest2 - ITEM Assertion OK : - Range("D15").Row - ITEM Assertion OK : - WorkSheet("D15").Range.Row - ITEM Assertion OK : - Range("D15").Column - ITEM Assertion OK : - Worksheet.Range("D15").Column - ITEM Assertion OK : - Range("D1").EntireRow.Valuer - ITEM Assertion OK : - Range("D1").EntireRow.Valuer - ITEM Assertion OK : - Range("D1").EntireRow.Columns.Count - ITEM Assertion OK : - Range("D1").EntireColumn.Rows.Count - ITEM Assertion OK : - Range("D15").ClearContent - ITEM Assertion OK : - Range("M1:N2").Rows.Hidden (set) - ITEM Assertion OK : - Range("M1:N2").Rows.Hidden (get) - ITEM Assertion OK : - Range("M1:N2").Rows(1).Hidden (set) - ITEM Assertion OK : - Range("M1:N2").Rows(1).Hidden (get) - ITEM Assertion OK : - Range("M1:N2").Columns.Hidden (set) - ITEM Assertion OK : - Range("M1:N2").Columns.Hidden (get) - ITEM Assertion OK : - Range("M1:N2").Columns(1).Hidden (set) - ITEM Assertion OK : - Range("M1:N2").Columns(1).Hidden (get) - ITEM Assertion OK : - Range("B38").Orientation (get) - ITEM Assertion OK : - Range("B38").Orientation (set) - ITEM Assertion OK : - Range("B38").Orientation (set = xlDownward) - ITEM Assertion OK : - Range("B38").Orientation (set) - ITEM Assertion OK : - Range("B38").Orientation (set = xlUpward) - ITEM Assertion OK : - Range("B38").Orientation (set) - ITEM Assertion OK : - Range("B38").Orientation (set = xlVertical) - ITEM Assertion OK : - Range("B38").Orientation (set) - ITEM Assertion OK : - Range("B38").Orientation (set = xlVertical) - ITEM Assertion OK : - Range("B39").WrapText (get) - ITEM Assertion OK : - Range("B39").WrapText (set) - ITEM Assertion OK : - Range("B39").WrapText (set) - ITEM Assertion OK : - Range("E39").MergeCells (get) - ITEM Assertion OK : - Range("F39").MergeCells (get) - ITEM Assertion OK : - Range("E39").MergeCells (set) - ITEM Assertion FAIL : - Range("F39").MergeCells (set) - ITEM Assertion OK : - Range("E39").MergeCells (set) - ITEM Assertion OK : - Range("F39").MergeCells (set) - ITEM Assertion OK : - Range("C41:C42").Replace MatchCase:=True - ITEM Assertion OK : - Range("C41:C42").Replace MatchCase:=True - ITEM Assertion OK : - Range("D41:D42").Replace MatchCase:=False - ITEM Assertion OK : - Range("B39").VerticalAlignment (get) - ITEM Assertion OK : - Range("B39").VerticalAlignment (set) - ITEM Assertion OK : - Range("B39").VerticalAlignment (get) - ITEM Assertion OK : - Range("B39").VerticalAlignment (get) - ITEM Assertion OK : - Range("B39").VerticalAlignment (set) - ITEM Assertion OK : - Range("B39").VerticalAlignment (get) - ITEM Assertion OK : - Range("B39").VerticalAlignment (set) - ITEM Assertion OK : - Range("B39").HorizontalAlignment (get) - ITEM Assertion OK : - Range("B39").HorizontalAlignment (set) - ITEM Assertion OK : - Range("B39").HorizontalAlignment (get) - ITEM Assertion OK : - Range("B39").HorizontalAlignment (set) - ITEM Assertion OK : - Range("B39").HorizontalAlignment (get) - ITEM Assertion OK : - Range("B39").HorizontalAlignment (set) - ITEM Assertion OK : - Range("B39").HorizontalAlignment (get) - ITEM Assertion OK : - Range("B39").HorizontalAlignment (set) - ITEM FAIL (RangeTest2) - TEST Not succesfully completed : RangeTest2 -END TestCalc -Test run finished : 30/05/2007 15:59:42 diff --git a/sc/source/ui/vba/testvba/TestDocuments/logs/unix/TestCalc_Rangetest2.log b/sc/source/ui/vba/testvba/TestDocuments/logs/unix/TestCalc_Rangetest2.log deleted file mode 100644 index b1573c06d..000000000 --- a/sc/source/ui/vba/testvba/TestDocuments/logs/unix/TestCalc_Rangetest2.log +++ /dev/null @@ -1,65 +0,0 @@ -Test run started : 10/03/2008 15:15:19 -BEGIN TestCalc - TEST START : RangeTest3 - ITEM Assertion OK : - setFormulaR1C1 - ITEM Assertion OK : - getFormulaR1C1 - ITEM Assertion OK : - Range.Copy() and Range.PasteSpecial() - ITEM Assertion OK : - Range.Copy(Range("I10")) - ITEM Assertion OK : PasteSpecial Paste:=xlPasteValues - ITEM Assertion OK : PasteSpecial Paste:=xlPasteFormulas - ITEM Assertion OK : PasteSpecial Paste:=xlPasteFormats - ITEM Assertion OK : PasteSpecial - ITEM Assertion OK : PasteSpecial SkipBlanks:=True - ITEM Assertion OK : PasteSpecial Operation:=xlPasteSpecialOperationAdd - ITEM Assertion OK : PasteSpecial Operation:=xlPasteSpecialOperationSubtract - ITEM Assertion OK : PasteSpecial Operation:=xlPasteSpecialOperationMultiply - ITEM Assertion OK : PasteSpecial Operation:=xlPasteSpecialOperationDivide - ITEM Assertion OK : PasteSpecial Transpose:=True - ITEM Assertion FAIL : ActiveWorkbook.FileFormat - ITEM Assertion OK : ActiveWorkbook.Name - ITEM Assertion OK : ActiveWorkbook.FullName und ActiveWorkbook.Path - ITEM Assertion FAIL : - = ActiveWorkbook.Colors(3) set - ITEM Assertion OK : - = ActiveWorkbook.ResetColors - ITEM Assertion OK : - = ActiveWorkbook.Colors(3) get - ITEM Assertion OK : - = Range("K22").End (xlDown) - ITEM Assertion OK : - = Range("K22").End (xlUo) - ITEM Assertion OK : - = Range("K22").End (xlToLeft) - ITEM Assertion OK : - = Range("K22").End (xlRight) - ITEM Assertion OK : - ActiveSpreadsheet.Next - ITEM Assertion OK : - ActiveSpreadsheet.Next - ITEM Assertion OK : - ActiveSpreadsheet.Previous - ITEM Assertion OK : - ActiveSpreadsheet.Previous - ITEM Assertion OK : - Range("J4:J11").AutoFilter field:=1, Criteria1:="x" - ITEM Assertion OK : - Range("J4:J11").AutoFilter field:=1, Criteria1:="<>" - ITEM Assertion OK : - Range("J4:J11").AutoFilter field:=1, Criteria1:="=" - ITEM Assertion OK : - Range("J4:J11").AutoFilter - ITEM Assertion OK : - ActiveSheet.Resize.Select - ITEM Assertion OK : - Application.GoTo Reference:="R8C2" - ITEM Assertion FAIL : - Application.GoTo Reference:="R[8]C[2]" - ITEM Assertion OK : - Application.GoTo Reference:="R8C2" - ITEM Assertion OK : - Range.Group - please check visually - ITEM Assertion OK : - Range.Group - please check visually - ITEM Assertion OK : - Range.Ungroup- please check visually - ITEM Assertion OK : - Range.Ungroup - please check visually - ITEM Assertion OK : - Range.Group - please check visually - ITEM Assertion OK : - Range.Group - please check visually - ITEM Assertion OK : - Range.clearOutline - please check visually - ITEM Assertion OK : - Range.AutoOutline - please check visually - ITEM Assertion OK : - Range.AutoOutline - please check visually - ITEM Assertion OK : - ActiveSheet.UsedRange.Select - ITEM Assertion OK : - Range("A13").AddIndent - ITEM Assertion OK : - Range("A13").IndentLevel set - ITEM Assertion OK : - Range("A13").IndentLevel get - ITEM Assertion OK : - Range("A13").IndentLevel get - ITEM Assertion OK : - Range.Copy() and Range.PasteSpecial() - ITEM Assertion OK : - Range.Copy() and Range.PasteSpecial() - ITEM Assertion OK : - Range.Copy() and Range.PasteSpecial() - ITEM Assertion OK : - Range.Calculate - ITEM Assertion OK : Worksheet.Calculate - ITEM Assertion OK : - Application.Calculate - ITEM Assertion OK : Global.Calculate - ITEM Assertion OK : Calculation set - ITEM FAIL (RangeTest3) - TEST Not succesfully completed : RangeTest3 -END TestCalc -Test run finished : 10/03/2008 15:15:21 diff --git a/sc/source/ui/vba/testvba/TestDocuments/logs/unix/TestIntersection.log b/sc/source/ui/vba/testvba/TestDocuments/logs/unix/TestIntersection.log deleted file mode 100644 index ea686a830..000000000 --- a/sc/source/ui/vba/testvba/TestDocuments/logs/unix/TestIntersection.log +++ /dev/null @@ -1,26 +0,0 @@ -Test run started : 13/01/2009 14:31:43 ----------------------------------------------------------------- -TestIntersection - TEST START : TestIntersection - ITEM Assertion OK : test1 Application.Intersect( Range('A2:D10'), Range('C4:E6')) - ITEM Assertion OK : test2 Application.Intersect( Range('A2:D10'), Range('A4:G10')) - ITEM Assertion OK : test3 Application.Intersect( Range('A2:c8,d2:f8,g2:i8'), Range('A4:G10')) - ITEM Assertion OK : test4 Application.Intersect( Range('A4:G10'), Range('A2:c8,d2:f8,g2:i8')) - ITEM Assertion OK : test5 Application.Intersect( Range('A2:c8,d2:f8,g2:i8'), Range('g4:i10,A4:G10')) - ITEM Assertion OK : test6 Application.Intersect( Range('g4:i10,A4:G10'), Range('A2:c8,d2:f8,g2:i8')) - ITEM Assertion OK : test7 Application.Intersect( Range('a2:d10,b5:e10'), Range('a5:i10')) - ITEM Assertion OK : test8 Application.Intersect( Range('a2:c8,d2:f8'), Range('b6:e9,a6:f9')) - ITEM Assertion OK : test9 Application.Intersect( Range('a2:c8,e2:f8'), Range('b6:e9,a6:f9')) - ITEM Assertion OK : test10 Application.Intersect( Range('a1:a3,c1:c3'), Range('a2:c3')) - ITEM Assertion OK : test11 Application.Intersect( Range('a1:a3,b1:b3'), Range('a2:c3')) - ITEM Assertion OK : test12 Application.Intersect( Range('a2:d5,b3:f7,c1:g4'), Range('b2:e6')) - ITEM Assertion OK : test13 Range(" a2:d10,b5:e10,g13:j32 "), Range(" a5:i10,b6:e9 "), Range("b2:r5,f10:h19") -Test Results -============ - -Tests passed: 13 -Tests failed: 0 - -END 'TestIntersection - TEST OK : TestIntersection -Test run finished : 13/01/2009 14:31:43 diff --git a/sc/source/ui/vba/testvba/TestDocuments/logs/unix/TestUnion.log b/sc/source/ui/vba/testvba/TestDocuments/logs/unix/TestUnion.log deleted file mode 100644 index da3cb35de..000000000 --- a/sc/source/ui/vba/testvba/TestDocuments/logs/unix/TestUnion.log +++ /dev/null @@ -1,17 +0,0 @@ -Test run started : 13/01/2009 14:32:16 ----------------------------------------------------------------- -TestUnion - TEST START : TestUnion - ITEM Assertion OK : test1Application.Range('A2:D10'), Range('C4:E6') - ITEM Assertion OK : test2Application.Range('A2:D5,a3:d4'), Range('A4:G10') - ITEM Assertion OK : test3Application.Range('A4:G10,A1:B6'), Range('A2:D5,A3:D4') - ITEM Assertion OK : test4Application.Range('A5:D10'), Range('B5:E10') -Test Results -============ - -Tests passed: 4 -Tests failed: 0 - -END 'TestUnion - TEST OK : TestUnion -Test run finished : 13/01/2009 14:32:16 diff --git a/sc/source/ui/vba/testvba/TestDocuments/logs/unix/Window.log b/sc/source/ui/vba/testvba/TestDocuments/logs/unix/Window.log deleted file mode 100644 index ec9a66561..000000000 --- a/sc/source/ui/vba/testvba/TestDocuments/logs/unix/Window.log +++ /dev/null @@ -1,46 +0,0 @@ -Test run started : 05/29/2008 02:55:00 PM ----------------------------------------------------------------- - TEST START : Window-Issue - ITEM Assertion OK : Window.Left is: 0 (Test only applies to maximized Window) - ITEM Assertion OK : Window.Top is: 21 (Test only applies to maximized Window) - ITEM Assertion OK : Window.Width is: 1280 (Test only applies to maximized Window) - ITEM Assertion OK : Window.Height is: 752 (Test only applies to maximized Window) - ITEM Assertion OK : Window.ScrollColumn is: 100 - ITEM Assertion OK : Window.ScrollColumn is: 1 - ITEM Assertion OK : Window.ScrollRow is: 100 - ITEM Assertion OK : Window.ScrollRow is: 1 - ITEM Assertion OK : Window.LargeScroll(Down): ScrollRow is: 94 (Test may only apply to maximized Window) - ITEM Assertion OK : Window.LargeScroll(Up): ScrollRow is: 1 - ITEM Assertion OK : Window.LargeScroll(ToRight): ScrollColumn is: 58 (Test may only apply to maximized Window) - ITEM Assertion OK : Window.LargeScroll(ToLeft): ScrollColumn is: 1 - ITEM Assertion OK : Window.SmallScroll(ToRight): ScrollColumn is: 4 (Test may only apply to maximized Window) - ITEM Assertion OK : Window.SmallScroll(ToLeft): ScrollColumn is: 1 - ITEM Assertion OK : Window.DisplayWorkBookTabs is: False - ITEM Assertion OK : Window.DisplayWorkBookTabs is: True - ITEM Assertion OK : Window.DisplayVerticalScrollBar is: True - ITEM Assertion OK : Window.DisplayVerticalScrollBar is: False - ITEM Assertion OK : Window.DisplayHorizontalScrollBar is: False - ITEM Assertion OK : Window.DisplayHorizontalScrollBar is: True - ITEM Assertion OK : Window.DisplayHeadings is: False - ITEM Assertion OK : Window.DisplayHeadings is: True - ITEM Assertion OK : Window.DisplayOutline is: False - ITEM Assertion OK : Window.DisplayOutline is: True - ITEM Assertion OK : Window.Visible is: False - ITEM Assertion OK : Window.Visible is: True - ITEM Assertion OK : Window.Caption is: MyCaption - ITEM Assertion OK : Pane.ScrollColumn is: 100 - ITEM Assertion OK : Pane.ScrollColumn is: 1 - ITEM Assertion OK : Pane.ScrollRow is: 100 - ITEM Assertion OK : Pane.ScrollRow is: 1 - ITEM Assertion OK : Pane.LargeScroll(Down): ScrollRow is: 94 (Test may only apply to maximized Window) - ITEM Assertion OK : Pane.LargeScroll(Up): ScrollRow is: 1 - ITEM Assertion OK : Pane.LargeScroll(ToRight): ScrollColumn is: 58 (Test may only apply to maximized Window) - ITEM Assertion OK : Pane.LargeScroll(ToLeft): ScrollColumn is: 1 - ITEM Assertion OK : Pane.SmallScroll(ToRight): ScrollColumn is: 4 (Test may only apply to maximized Window) - ITEM Assertion OK : Pane.SmallScroll(ToLeft): ScrollColumn is: 1 - ITEM Assertion OK : Window Selection: $A$2:$D$5 - ITEM Assertion OK : ActiveSheet name of Window: Sheet1 - ITEM Assertion OK : Window ActiveCell: $A$1 -END 'Window-Issue' Symbol - TEST OK : Window-Issue -Test run finished : 05/29/2008 02:55:01 PM diff --git a/sc/source/ui/vba/testvba/TestDocuments/logs/unix/bytearraystring.log b/sc/source/ui/vba/testvba/TestDocuments/logs/unix/bytearraystring.log deleted file mode 100644 index bd243283d..000000000 --- a/sc/source/ui/vba/testvba/TestDocuments/logs/unix/bytearraystring.log +++ /dev/null @@ -1,8 +0,0 @@ -Test run started : 05/29/2008 02:25:58 PM -BEGIN Bytearray To String - TEST START : Test the conversion between bytearray and string - ITEM Assertion OK : The number of byte is:6 - ITEM Assertion OK : the return string is: abc - TEST OK : Test the conversion between bytearray and string -END Bytearray To String -Test run finished : 05/29/2008 02:25:58 PM diff --git a/sc/source/ui/vba/testvba/TestDocuments/logs/unix/dateserial.log b/sc/source/ui/vba/testvba/TestDocuments/logs/unix/dateserial.log deleted file mode 100644 index 4dd5f5316..000000000 --- a/sc/source/ui/vba/testvba/TestDocuments/logs/unix/dateserial.log +++ /dev/null @@ -1,9 +0,0 @@ -Test run started : 01/24/2008 01:24:50 PM -BEGIN DateSerial - TEST START : Test DateSerial function - ITEM Assertion OK : the return date is: 06/15/1999 - ITEM Assertion OK : the return date is: 06/15/1999 - ITEM Assertion OK : the return date is: 06/15/1999 - TEST OK : Test DateSerial function -END DateSerial -Test run finished : 01/24/2008 01:24:50 PM diff --git a/sc/source/ui/vba/testvba/TestDocuments/logs/unix/datevalue.log b/sc/source/ui/vba/testvba/TestDocuments/logs/unix/datevalue.log deleted file mode 100644 index 830d5e7b6..000000000 --- a/sc/source/ui/vba/testvba/TestDocuments/logs/unix/datevalue.log +++ /dev/null @@ -1,8 +0,0 @@ -Test run started : 01/24/2008 01:24:41 PM -BEGIN DateValue - TEST START : Test DateValue function - ITEM Assertion OK : the return date is: 02/12/1969 - ITEM Assertion OK : the return date is: 01/21/2008 - TEST OK : Test DateValue function -END DateValue -Test run finished : 01/24/2008 01:24:41 PM diff --git a/sc/source/ui/vba/testvba/TestDocuments/logs/unix/format.log b/sc/source/ui/vba/testvba/TestDocuments/logs/unix/format.log deleted file mode 100644 index 96725bf7d..000000000 --- a/sc/source/ui/vba/testvba/TestDocuments/logs/unix/format.log +++ /dev/null @@ -1,36 +0,0 @@ -Test run started : 2008／09／18 11:35:34 -BEGIN Format - TEST START : Test Predefined_Number_Format_Sample function - ITEM Assertion OK : General Number: 562486.2356 - ITEM Assertion OK : Fixed: 0.20 - ITEM Assertion OK : Standard: 562,486.24 - ITEM Assertion OK : Percent: 75.21% - ITEM Assertion OK : Scientific: 5.62E+05 - ITEM Assertion OK : Scientific: -3.46E+03 - ITEM Assertion OK : Yes/No: No - ITEM Assertion OK : Yes/No: Yes - ITEM Assertion OK : True/False: False - ITEM Assertion OK : True/False: True - ITEM Assertion OK : On/Off: Off - ITEM Assertion OK : On/Off: On - TEST OK : Test Predefined_Number_Format_Sample function - TEST START : Test Custom_Number_Format_Sample function - ITEM Assertion OK : 00.0000: 23.6750 - ITEM Assertion OK : 00.00: 23.68 - ITEM Assertion OK : 00000: 02658 - ITEM Assertion OK : 00.00: 2658.00 - ITEM Assertion OK : ##.####: 23.675 - ITEM Assertion OK : ##.##: 23.68 - ITEM Assertion OK : #,###.##: 12,345.25 - ITEM Assertion OK : ##.00%: 25.00% - ITEM Assertion OK : #,###: 1,000,000 - ITEM Assertion OK : ######E-###: 109838E-5 - ITEM Assertion OK : $#,###.##: $2,345.25 - ITEM Assertion OK : ##.###\%: .25% - TEST OK : Test Custom_Number_Format_Sample function - TEST START : Test Custom_Text_Format_Sample function - ITEM Assertion OK : <: vba - ITEM Assertion OK : >: VBA - TEST OK : Test Custom_Text_Format_Sample function -END Format -Test run finished : 2008／09／18 11:35:34 diff --git a/sc/source/ui/vba/testvba/TestDocuments/logs/unix/pagesetup.log b/sc/source/ui/vba/testvba/TestDocuments/logs/unix/pagesetup.log deleted file mode 100644 index f04585c3f..000000000 --- a/sc/source/ui/vba/testvba/TestDocuments/logs/unix/pagesetup.log +++ /dev/null @@ -1,77 +0,0 @@ -Test run started : 07/21/2008 02:00:06 PM -BEGIN PageSetup - TEST START : Sheet_PrintArea - ITEM Assertion OK : PrintArea has changed as expected - TEST OK : Sheet_PrintArea - TEST START : Test margins (no headers) - ITEM Assertion OK : PageSetup.LeftMargin set/get - ITEM Assertion OK : PageSetup.RightMargin set/get - ITEM Assertion OK : PageSetup.TopMargin set/get - ITEM Assertion OK : PageSetup.BottomMargin set/get -Verify that page margins on sheet 1 are all 0.5inch - TEST OK : Test margins (no headers) - TEST START : Test margins (headers) - ITEM Assertion OK : PageSetup.HeaderMargin set/get - ITEM Assertion OK : PageSetup.FooterMargin set/get - ITEM Assertion OK : PageSetup.LeftMargin set/get - ITEM Assertion OK : PageSetup.LeftMargin set/get -Verify that top/bottom/header/footer page margins on sheet 2 are all 0.5inch - TEST OK : Test margins (headers) - TEST START : Test header/footer text - ITEM Assertion OK : PageSetup.LeftHeader set - ITEM Assertion OK : PageSetup.LeftHeader set/get - ITEM Assertion OK : PageSetup.CenterHeader set - ITEM Assertion OK : PageSetup.CenterHeader set/get - ITEM Assertion OK : PageSetup.RightHeader set - ITEM Assertion OK : PageSetup.RightHeader set/get - ITEM Assertion OK : PageSetup.LeftFooter set - ITEM Assertion OK : PageSetup.LeftFooter set/get - ITEM Assertion OK : PageSetup.CenterFooter set - ITEM Assertion OK : PageSetup.CenterFooter set/get - ITEM Assertion OK : PageSetup.RightFooter set - ITEM Assertion OK : PageSetup.RightFooter set/get -Verify that headers on sheet 2 are Ready,to,go -Verify that footers on sheet 2 are This,now,Works - TEST OK : Test header/footer text - TEST START : Test zoom - ITEM Assertion OK : PageSetup.Zoom set - ITEM Assertion OK : PageSetup.Zoom set/get -Verify that sheet 1 zoom is 10% - TEST OK : Test zoom - TEST START : Test orientation - ITEM Assertion OK : PageSetup.Zoom set - ITEM Assertion OK : PageSetup.Orientation set/get -Verify that sheet 1 orientation is now landscape - TEST OK : Test orientation - TEST START : Test order - ITEM Assertion OK : PageSetup.Order get - ITEM Assertion OK : PageSetup.Order set/get -Verify that order on sheet 1 is now over, then down. - TEST OK : Test order - TEST START : Test first page number - ITEM Assertion OK : PageSetup.FirstPageNumber get - ITEM Assertion OK : PageSetup.FirstPageNumber set/get -Verify that first page number on sheet 1 is now 2. - TEST OK : Test first page number - TEST START : Test center vertically - ITEM Assertion OK : PageSetup.CenterVertically get - ITEM Assertion OK : PageSetup.CenterVertically set/get -Verify that CenterVertically on sheet 1 is now true. - TEST OK : Test center vertically - TEST START : Test center horizontally - ITEM Assertion OK : PageSetup.CenterHorizontally get - ITEM Assertion OK : PageSetup.CenterHorizontally set/get -Verify that CenterHorizontally on sheet 1 is now true. - TEST OK : Test center horizontally - TEST START : Test FitToPagesTall - ITEM Assertion OK : PageSetup.FitToPagesTall set/get - TEST OK : Test FitToPagesTall - TEST START : Test FitToPagesWide - ITEM Assertion OK : PageSetup.FitToPagesWide set/get - TEST OK : Test FitToPagesWide - TEST START : Test PrintHeadings - ITEM Assertion OK : PageSetup.PrintHeadings set/get - ITEM Assertion OK : PageSetup.PrintHeadings set/get - TEST OK : Test PrintHeadings -END PageSetup -Test run finished : 07/21/2008 02:00:07 PM diff --git a/sc/source/ui/vba/testvba/TestDocuments/logs/unix/partition.log b/sc/source/ui/vba/testvba/TestDocuments/logs/unix/partition.log deleted file mode 100644 index 7b4f2a01b..000000000 --- a/sc/source/ui/vba/testvba/TestDocuments/logs/unix/partition.log +++ /dev/null @@ -1,11 +0,0 @@ -Test run started : 12/10/2007 11:26:43 AM -BEGIN Partition - TEST START : Test Partition function - ITEM Assertion OK : the number 20 occurs in the range:20:24 - ITEM Assertion OK : the number 20 occurs in the range: 20: 20 - ITEM Assertion OK : the number 120 occurs in the range:100: - ITEM Assertion OK : the number -5 occurs in the range: : -1 - ITEM Assertion OK : the number 2 occurs in the range: 2: 3 - TEST OK : Test Partition function -END Partition -Test run finished : 12/10/2007 11:26:43 AM diff --git a/sc/source/ui/vba/testvba/TestDocuments/logs/unix/range-4.log b/sc/source/ui/vba/testvba/TestDocuments/logs/unix/range-4.log deleted file mode 100644 index fb37b6ff2..000000000 --- a/sc/source/ui/vba/testvba/TestDocuments/logs/unix/range-4.log +++ /dev/null @@ -1,16 +0,0 @@ -Test run started : 2008／06／19 17:14:57 ----------------------------------------------------------------- -ShowDetail-Issue - TEST START : ShowDetail-Issue - ITEM Assertion OK : Range.ShowDetail is True - ITEM Assertion OK : Range.ShowDetail is False -END 'ShowDetail-Issue' Symbol - TEST OK : ShowDetail-Issue ----------------------------------------------------------------- -RangeMerged-Issue - TEST START : RangeMerged-Issue - ITEM Assertion OK : Range.RangeMerged is $F$2:$H$5 - ITEM Assertion OK : The first address of Range.RangeMerged is $F$2 -END 'RangeMerged-Issue' Symbol - TEST OK : RangeMerged-Issue -Test run finished : 2008／06／19 17:14:57 diff --git a/sc/source/ui/vba/testvba/TestDocuments/logs/unix/replace.log b/sc/source/ui/vba/testvba/TestDocuments/logs/unix/replace.log deleted file mode 100644 index 8f600faaa..000000000 --- a/sc/source/ui/vba/testvba/TestDocuments/logs/unix/replace.log +++ /dev/null @@ -1,14 +0,0 @@ -Test run started : 09/05/2008 10:21:46 AM -BEGIN Replace - TEST START : Test Replace function - ITEM Assertion OK : common string:aefefdBc - ITEM Assertion OK : expression string:aefefdef - ITEM Assertion OK : binanary compare:aefefdBc - ITEM Assertion OK : text compare:aefefdef - ITEM Assertion OK : text compare:aefefdef - ITEM Assertion OK : start = 3:cefdBc - ITEM Assertion OK : count = 2: aefefdBc - ITEM Assertion OK : start = 1, count = 0, not support in Unix: abcbcdBc - TEST OK : Test Replace function -END Replace -Test run finished : 09/05/2008 10:21:47 AM diff --git a/sc/source/ui/vba/testvba/TestDocuments/logs/unix/stringplusdouble.log b/sc/source/ui/vba/testvba/TestDocuments/logs/unix/stringplusdouble.log deleted file mode 100644 index 6e8b8d994..000000000 --- a/sc/source/ui/vba/testvba/TestDocuments/logs/unix/stringplusdouble.log +++ /dev/null @@ -1,62 +0,0 @@ -Test run started : 05/29/2008 02:51:22 PM -BEGIN String Plus Double - TEST START : double = string + double -The next compute raises error: s = null, d = null, r = s + d - ITEM Assertion OK : s = null, d = null, r = s + d .The result is: -1 - ITEM Assertion OK : s = null, d = null, r = s & d .The result is: 0 -The next compute raises error: s = null, d = 20, r = s + d - ITEM Assertion OK : s = null, d = 20, r = s + d .The result is: -1 - ITEM Assertion OK : s = null, d = 20, r = s & d .The result is: 20 - ITEM Assertion OK : s = '10', d = null, r = s + d .The result is: 10 - ITEM Assertion OK : s = '10', d = null, r = s & d .The result is: 100 - ITEM Assertion OK : s = '10', d = 20, r = s + d .The result is: 30 - ITEM Assertion OK : s = '10', d = 20, r = s & d .The result is: 1020 -The next compute raises error: s = 'abc', d = null, r = s + d - ITEM Assertion OK : s = 'abc', d = null, r = s + d .The result is: -1 -The next compute raises error: s = 'abc', d = null, r = s & d - ITEM Assertion OK : s = 'abc', d = null, r = s & d .The result is: -1 -The next compute raises error: s = 'abc', d = 20, r = s + d - ITEM Assertion OK : s = 'abc', d = 20, r = s + d .The result is: -1 -The next compute raises error: s = 'abc', d = 20, r = s & d - ITEM Assertion OK : s = 'abc', d = 20, r = s & d .The result is: -1 - TEST OK : double = string + double - TEST START : string = string + double -The next compute raises error: s = null, d = null, r = s + d - ITEM Assertion OK : s = null, d = null, r = s + d .The result is: -1 - ITEM Assertion OK : s = null, d = null, r = s & d .The result is: 0 -The next compute raises error: s = null, d = 20, r = s + d - ITEM Assertion OK : s = null, d = 20, r = s + d .The result is: -1 - ITEM Assertion OK : s = null, d = 20, r = s & d .The result is: 20 - ITEM Assertion OK : s = '10', d = null, r = s + d .The result is: 10 - ITEM Assertion OK : s = '10', d = null, r = s & d .The result is: 100 - ITEM Assertion OK : s = '10', d = 20, r = s + d .The result is: 30 - ITEM Assertion OK : s = '10', d = 20, r = s & d .The result is: 1020 -The next compute raises error: s = 'abc', d = null, r = s + d - ITEM Assertion OK : s = 'abc', d = null, r = s + d .The result is: -1 - ITEM Assertion OK : s = 'abc', d = null, r = s & d .The result is: abc0 -The next compute raises error: s = 'abc', d = 20, r = s + d - ITEM Assertion OK : s = 'abc', d = 20, r = s + d .The result is: -1 - ITEM Assertion OK : s = 'abc', d = 20, r = s & d .The result is: abc20 - TEST OK : string = string + double - TEST START : double = string + string -The next compute raises error: s = null, d = null, r = s + d - ITEM Assertion OK : s = null, d = null, r = s + d .The result is: -1 -The next compute raises error: s = null, d = null, r = s & d - ITEM Assertion OK : s = null, d = null, r = s & d .The result is: -1 - ITEM Assertion OK : s = null, d = 20, r = s + d .The result is: 20 - ITEM Assertion OK : s = null, d = 20, r = s & d .The result is: 20 - ITEM Assertion OK : s = '10', d = null, r = s + d .The result is: 10 - ITEM Assertion OK : s = '10', d = null, r = s & d .The result is: 10 - ITEM Assertion OK : s = '10', d = 20, r = s + d .The result is: 1020 - ITEM Assertion OK : s = '10', d = 20, r = s & d .The result is: 1020 -The next compute raises error: s = 'abc', d = null, r = s + d - ITEM Assertion OK : s = 'abc', d = null, r = s + d .The result is: -1 -The next compute raises error: s = 'abc', d = null, r = s & d - ITEM Assertion OK : s = 'abc', d = null, r = s & d .The result is: -1 -The next compute raises error: s = 'abc', d = 20, r = s + d - ITEM Assertion OK : s = 'abc', d = 20, r = s + d .The result is: -1 -The next compute raises error: s = 'abc', d = 20, r = s & d - ITEM Assertion OK : s = 'abc', d = 20, r = s & d .The result is: -1 - TEST OK : double = string + string -END String Plus Double -Test run finished : 05/29/2008 02:51:22 PM diff --git a/sc/source/ui/vba/testvba/TestDocuments/logs/unix/window2.log b/sc/source/ui/vba/testvba/TestDocuments/logs/unix/window2.log deleted file mode 100644 index 8e26d0580..000000000 --- a/sc/source/ui/vba/testvba/TestDocuments/logs/unix/window2.log +++ /dev/null @@ -1,41 +0,0 @@ -Test run started : 2008／09／22 11:18:57 -BEGIN Window2 - TEST START : Test Window.SplitRow - ITEM Assertion OK : Test SplitColumn: 2 (Test only applies to maximized Window and at least has 800*600 solotion) - ITEM Assertion OK : Test SplitRow: 2 (Test only applies to maximized Window and at least has 800*600 solotion) - ITEM Assertion OK : Test SplitVertical: 242.465788476212 - ITEM Assertion OK : Test SplitHorizontal: 242.465788476212 - ITEM Assertion OK : Test SplitRow: 4 (Test only applies to maximized Window and at least has 800*600 solotion) - ITEM Assertion OK : Test SplitColumn: 3 (Test only applies to maximized Window and at least has 800*600 solotion) - ITEM Assertion OK : Test SplitColumn: 0 - ITEM Assertion OK : Test SplitRow: 0 - TEST OK : Test Window.SplitRow - TEST START : Test Window.DisplayGridlines - ITEM Assertion OK : Test gridlines are on - ITEM Assertion OK : Test gridlines are off - TEST OK : Test Window.DisplayGridlines - TEST START : Test Window.DisplayHeadings - ITEM Assertion OK : Test Headings are on - ITEM Assertion OK : Test Headings are off - TEST OK : Test Window.DisplayHeadings - TEST START : Test Window.Visibility - ITEM Assertion OK : Window is visible - ITEM Assertion OK : Window is not visible - TEST OK : Test Window.Visibility - TEST START : Test Window.FreezePanes - ITEM Assertion OK : Test no panes frozen - ITEM Assertion OK : Test panes frozen at center - ITEM Assertion OK : Test panes frozen at split - TEST OK : Test Window.FreezePanes - TEST START : Test Window.View - TEST OK : Test Window.View - TEST START : Test Window.Zoom - ITEM Assertion OK : Test zoom=100% - ITEM Assertion OK : Test zoom=150% - TEST OK : Test Window.Zoom - TEST START : Test Windows.Count - ITEM Assertion OK : Windows Count: 1 - ITEM Assertion OK : Application.Windows Count: 1 - TEST OK : Test Windows.Count -END Window2 -Test run finished : 2008／09／22 11:18:58 diff --git a/sc/source/ui/vba/testvba/TestDocuments/logs/win/AutoFilter.log b/sc/source/ui/vba/testvba/TestDocuments/logs/win/AutoFilter.log deleted file mode 100644 index b8d0b85a8..000000000 --- a/sc/source/ui/vba/testvba/TestDocuments/logs/win/AutoFilter.log +++ /dev/null @@ -1,20 +0,0 @@ -Test run started : 16/10/2007 17:42:01
-----------------------------------------------------------------
-TestAddress
- TEST START : TestAddress
- ITEM Assertion OK : test1 'starts with' string criteria
- ITEM Assertion OK : test2 'not equal to' string criteria
- ITEM Assertion OK : test3 'ends with' string criteria
- ITEM Assertion OK : test4 field 'all'
- ITEM Assertion OK : test5 numeric '<15'
- ITEM Assertion OK : test6 numeric '>=15'
- ITEM Assertion OK : test7 numeric '<=12'
-Test Results
-============
-
-Tests passed: 7
-Tests failed: 0
-
-END 'TestAddress
- TEST OK : TestAddress
-Test run finished : 16/10/2007 17:42:02
diff --git a/sc/source/ui/vba/testvba/TestDocuments/logs/win/MiscRangeTests.log b/sc/source/ui/vba/testvba/TestDocuments/logs/win/MiscRangeTests.log deleted file mode 100644 index d190abb5f..000000000 --- a/sc/source/ui/vba/testvba/TestDocuments/logs/win/MiscRangeTests.log +++ /dev/null @@ -1,45 +0,0 @@ -Test run started : 17/07/2007 15:08:56
-----------------------------------------------------------------
-MiscRangeTests
- TEST START : MiscRangeTests
- ITEM Assertion OK : test 1
- ITEM Assertion OK : test 2
- ITEM Assertion OK : test 3
- ITEM Assertion OK : test 4
- ITEM Assertion OK : test 5
- ITEM Assertion OK : test 6
- ITEM Assertion OK : test 7
- ITEM Assertion OK : test 8
- ITEM Assertion OK : test 9
- ITEM Assertion OK : test 10
- ITEM Assertion OK : test 11
- ITEM Assertion OK : test 12
- ITEM Assertion OK : test 13
- ITEM Assertion OK : test 14
- ITEM Assertion OK : test 15
- ITEM Assertion OK : test 16
- ITEM Assertion OK : test 17
- ITEM Assertion OK : test 18
- ITEM Assertion OK : test 19
- ITEM Assertion OK : test 20
- ITEM Assertion OK : test 21
- ITEM Assertion OK : test 22
- ITEM Assertion OK : test 23
- ITEM Assertion OK : test 24
- ITEM Assertion OK : test 25
- ITEM Assertion OK : test 26
- ITEM Assertion OK : test 27
- ITEM Assertion OK : test 28
- ITEM Assertion OK : test 29
- ITEM Assertion OK : test 30
- ITEM Assertion OK : test 31
-No. tests: 31
-Summary
-=======
-Run: 31
-Passed: 31
-Failed: 0
-
-END 'MiscRangeTests
- TEST OK : MiscRangeTests
-Test run finished : 17/07/2007 15:08:59
diff --git a/sc/source/ui/vba/testvba/TestDocuments/logs/win/Ranges-2.log b/sc/source/ui/vba/testvba/TestDocuments/logs/win/Ranges-2.log deleted file mode 100644 index b80d996e3..000000000 --- a/sc/source/ui/vba/testvba/TestDocuments/logs/win/Ranges-2.log +++ /dev/null @@ -1,68 +0,0 @@ -Test run started : 10/07/2007 01:55:47
-----------------------------------------------------------------
-ClearFormtsIssue
- TEST START : ClearFormtsIssue
- ITEM Assertion OK : Range.Font.Bold is: True
- ITEM Assertion OK : Range.Font.Bold is: False
-END 'ClearFormtsIssue' Symbol
- TEST OK : ClearFormtsIssue
-----------------------------------------------------------------
-VerticalAlignment-Issue
- TEST START : VerticalAlignment-Issue
- ITEM Assertion OK : - Range.VerticalAlignment (get)
- ITEM Assertion OK : - Range.VerticalAlignment (set)
- ITEM Assertion OK : - Range.VerticalAlignment (get)
- ITEM Assertion OK : - Range.VerticalAlignment (get)
- ITEM Assertion OK : - Range.VerticalAlignment (set)
- ITEM Assertion OK : - Range.VerticalAlignment (get)
- ITEM Assertion OK : - Range.VerticalAlignment (set)
- ITEM Assertion OK : Range.VeritcalAlignment is Null
-END 'VerticalAlignment-Issue' Symbol
- TEST OK : VerticalAlignment-Issue
-----------------------------------------------------------------
-HorizontalAlignment-Issue
- TEST START : HorizontalAlignment-Issue
- ITEM Assertion OK : - Range.HorizontalAlignment (get)
- ITEM Assertion OK : - Range.HorizontalAlignment (set)
- ITEM Assertion OK : - Range.HorizontalAlignment (get)
- ITEM Assertion OK : - Range.HorizontalAlignment (set)
- ITEM Assertion OK : - Range.HorizontalAlignment (get)
- ITEM Assertion OK : - Range.HorizontalAlignment (set)
- ITEM Assertion OK : - Range.HorizontalAlignment (get)
- ITEM Assertion OK : - Range.HorizontalAlignment (set)
- ITEM Assertion OK : Range.HorizontalAlignment is Null
-END 'HorizontalAlignment-Issue' Symbol
- TEST OK : HorizontalAlignment-Issue
-----------------------------------------------------------------
-WrapText-Issue
- TEST START : WrapText-Issue
- ITEM Assertion OK : - Range.WrapText (get)
- ITEM Assertion OK : - Range.WrapText (get)
- ITEM Assertion OK : Range.WrapText is Null
-END 'WrapText-Issue' Symbol
- TEST OK : WrapText-Issue
-----------------------------------------------------------------
-FontBorderIssues
- TEST START : FontBorderIssues
- ITEM Assertion OK : - = Borders.Color (getColor)
- ITEM Assertion OK : - = Font.Color (getColor)
-END 'FontBorderIssues' Symbol
- TEST OK : FontBorderIssues
-----------------------------------------------------------------
-RangeSizeIssues
- TEST START : RangeSizeIssues
- ITEM Assertion OK : Range.Left is: 100.5291
- ITEM Assertion OK : Range.Top is: 95.39775
- ITEM Assertion OK : Range.Width is: 191.25
- ITEM Assertion OK : Range.Height is: 271.5
-END 'RangeSizeIssues' Symbol
- TEST OK : RangeSizeIssues
-----------------------------------------------------------------
-ApplicationIssues
- TEST START : ApplicationIssues
- ITEM Assertion OK : Range.Address is: $E$8:$G$13,$G$13:$K$19
- ITEM Assertion OK : Range.Address is: $E$8:$G$13,$G$13:$K$19
- ITEM Assertion OK : Application.ActiveSheet.Name: Sheet1
-END 'ApplicationIssues' Symbol
- TEST OK : ApplicationIssues
-Test run finished : 10/07/2007 01:55:48
diff --git a/sc/source/ui/vba/testvba/TestDocuments/logs/win/Ranges-3.log b/sc/source/ui/vba/testvba/TestDocuments/logs/win/Ranges-3.log deleted file mode 100644 index 365d126a7..000000000 --- a/sc/source/ui/vba/testvba/TestDocuments/logs/win/Ranges-3.log +++ /dev/null @@ -1,8 +0,0 @@ -Test run started : 10/07/2007 01:55:51
-----------------------------------------------------------------
-MyGoalseek-Issue
- TEST START : MyGoalseek-Issue
- ITEM Assertion OK : Variable Range value: 15
-END 'MyGoalseek-Issue' Symbol
- TEST OK : MyGoalseek-Issue
-Test run finished : 10/07/2007 01:55:51
diff --git a/sc/source/ui/vba/testvba/TestDocuments/logs/win/Ranges.log b/sc/source/ui/vba/testvba/TestDocuments/logs/win/Ranges.log deleted file mode 100644 index fe77d7a9d..000000000 --- a/sc/source/ui/vba/testvba/TestDocuments/logs/win/Ranges.log +++ /dev/null @@ -1,280 +0,0 @@ -Test run started : 10/07/2007 01:55:56
-----------------------------------------------------------------
-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:\Documents and Settings\vituosity\Application Data\OpenOffice.org2\user\basic
- ITEM Assertion OK : Please check manually: Template Path is: C:\Documents and Settings\vituosity\Application Data\OpenOffice.org2\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 FAIL : Range.Formula is: =IF(OR(J8=0,RC[2]="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 467
- ITEM Assertion FAIL : Rows.AutoFit: CurrentHeight is 78
-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 FAIL : Range Width is 675
- ITEM Assertion OK : Range RowHeight is 50
- ITEM Assertion OK : Range ColumnWidth is 50
- ITEM Assertion OK : Range Height is 300
- ITEM Assertion FAIL : Range Width is 675
- ITEM Assertion FAIL : RowHeight is null: False
- 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/07/2007 01:56:04
diff --git a/sc/source/ui/vba/testvba/TestDocuments/logs/win/Shapes.log b/sc/source/ui/vba/testvba/TestDocuments/logs/win/Shapes.log deleted file mode 100644 index fe62ab03d..000000000 --- a/sc/source/ui/vba/testvba/TestDocuments/logs/win/Shapes.log +++ /dev/null @@ -1,77 +0,0 @@ -Test run started : 16/10/2007 17:46:03
-BEGIN Shapes_Collection_Behaviour
- TEST START : Shapes_Collection_Behaviour
- ITEM Assertion OK : Name of indexed shape should be 'Sheet2Shape1'
- ITEM Assertion OK : Name of indexed shape should be 'Sheet2Shape2'
- TEST Success. : Shapes_Collection_Behaviour
-END Shapes_Collection_Behaviour
-BEGIN Shapes_Select_Item
- TEST START : Shapes_Select_Item
- ITEM Assertion OK : Correctly selected shape through Range
- ITEM Assertion OK : Correctly selected shape through Item
- ITEM Assertion OK : Needs to be visually checked. Is there a line on the document?
- ITEM Assertion OK : Needs to be visually checked. Are All Shapes Selected?
- TEST Success. : Shapes_Select_Item
-END Shapes_Select_Item
-BEGIN Shapes_Fill
- TEST START : Shapes_Fill
- ITEM Assertion OK : correctly set visibility of shape fill
- ITEM Assertion OK : correctly set transparency of shape line
- ITEM Assertion OK : correctly set forecolor of shape fill
- ITEM Assertion FAIL : correctly set backcolor of shape fill
- ITEM Assertion OK : the success of the TwoColorGradient method needs to be verified visually!
- ITEM Assertion OK : correctly set forecolor of shape fill
- ITEM Assertion FAIL : correctly set forecolor of shape fill
- TEST Success. : Shapes_Fill
-END Shapes_Fill
-BEGIN Shapes_Line
- TEST START : Shapes_Line
- ITEM Assertion FAIL : correctly set weight of shape line
- ITEM Assertion OK : correctly set visibility of shape line
- ITEM Assertion OK : correctly set transparency of shape line
- ITEM Assertion OK : correctly set dash style of shape line
- ITEM Assertion OK : correctly set dash style of shape line
- ITEM Assertion OK : correctly set forecolor of shape line
- ITEM Assertion FAIL : correctly set backcolor of shape line
- TEST Success. : Shapes_Line
-END Shapes_Line
-BEGIN Shapes_TextFrame
- TEST START : Shapes_TextFrame
- ITEM Assertion OK : correctly set Autosize of Shape TextFrame
- TEST Success. : Shapes_TextFrame
-END Shapes_TextFrame
-BEGIN Shapes_SimpleGeometry
- TEST START : Shapes_SimpleGeometery
- ITEM Assertion OK : shape height should be 49.4519655148368 and got 49.4078709034412
- ITEM Assertion OK : shape width should be 101.467710269751 and got 101.423615658355
- ITEM Assertion OK : shape left should be 68.5574761223637 and got 68.5417279658754
- ITEM Assertion OK : shape top should be 44.1511784471699 and got 44.1354302906816
- ITEM Assertion OK : shape rotation should be 0 and got 0
- ITEM Assertion OK : shape rotation should be 25 and got 25
- ITEM Assertion OK : shape incrementrotation should be 50 and got 50
- ITEM Assertion OK : shape incrementleft should be 69.7480272284707 and got 69.7322790719824
- ITEM Assertion OK : shape incrementtop should be 93.8141674447769 and got 93.7984192882885
- TEST Success. : Shapes_SimpleGeometery
-END Shapes_SimpleGeometry
-BEGIN Shapes_Range
- TEST START : Shapes_Range
- ITEM Assertion OK : expected Sheets(2).Shapes.Range(1) to contain 1 element, it contains 1
- ITEM Assertion OK : expected Sheets(2).Shapes.Range(1) to return Sheet2Shape1 got Sheet2Shape1
- ITEM Assertion OK : expected Sheets(2).Shapes.Range(Sheet2Shape3) to contain 1 element, it contains 1
- ITEM Assertion OK : expected Sheets(2).Shapes.Range(Sheet2Shape3) to return Sheet2Shape3 got Sheet2Shape3
- ITEM Assertion OK : expected Sheets(2).Shapes.Range(Array(3, 1) to contain 2 elements, it contains 2
- ITEM Assertion OK : expected Sheets(2).Shapes.Range(Array(3, 1) to return concated element/shape names Sheet2Shape3Sheet2Shape1 and got Sheet2Shape3Sheet2Shape1
- ITEM Assertion OK : expected Sheets(2).Shapes.Range(Array('Sheet2Shape3', 1, 'Sheet2Shape2')) to contain 3 elements, it contains 3
- ITEM Assertion OK : expected Sheets(2).Shapes.Range(Array('Sheet2Shape3', 1, 'Sheet2Shape2')) to return concated element/shape names Sheet2Shape3Sheet2Shape1Sheet2Shape2 and got Sheet2Shape3Sheet2Shape1Sheet2Shape2
- TEST Success. : Shapes_Range
-END Shapes_Range
-BEGIN Shapes_ShapeRange
- TEST START : Shapes_ShapeRange
- ITEM Assertion OK : ShapeRange.IncrementLeft shp1.left should be 89.7322790719824 and got 89.7165297816359
- ITEM Assertion OK : ShapeRange.IncrementLeft shp2.left should be 240.02518299054 and got 240.009433700193
- ITEM Assertion OK : ShapeRange.IncrementTop shp1.Top should be 113.798419288289 and got 113.782669997942
- ITEM Assertion OK : ShapeRange.IncrementTop shp2.Top should be 67.4519655148368 and got 67.4362162244903
- ITEM Assertion OK : ShapeRange.IncrementRotation shp1.Rotation should be 70 and got 70
- ITEM Assertion OK : ShapeRange.IncrementRotation shp2.Rotation should be 20 and got 20
-END Shapes_ShapeRange
-Test run finished : 16/10/2007 17:46:04
diff --git a/sc/source/ui/vba/testvba/TestDocuments/logs/win/TestAddress.log b/sc/source/ui/vba/testvba/TestDocuments/logs/win/TestAddress.log deleted file mode 100644 index cc51e378f..000000000 --- a/sc/source/ui/vba/testvba/TestDocuments/logs/win/TestAddress.log +++ /dev/null @@ -1,62 +0,0 @@ -Test run started : 17/07/2007 15:26:54
-----------------------------------------------------------------
-TestAddress
- TEST START : TestAddress
- ITEM Assertion OK : test1 Range('e3:f3') A1 style addressing
- ITEM Assertion OK : test2 Range('e3:f3') R1C1 style addressing
- ITEM Assertion OK : test3 Range ('e:f') A1 style addressing
- ITEM Assertion OK : test4 Range ('e:f') R1C1 style addressing
- ITEM Assertion OK : test5 Columns A1 style addressing
- ITEM Assertion OK : test6 Columns R1C1 style addressing
- ITEM Assertion OK : test7 Columns(3) A1 style addressing
- ITEM Assertion OK : test8 Columns(3) R1C1 style addressing
- ITEM Assertion OK : test9 Columns('e') A1 style addressing
- ITEM Assertion OK : test10 Columns('e') R1C1 style addressing
- ITEM Assertion OK : test11 Columns('b:d') A1 style addressing
- ITEM Assertion OK : test12 Columns('b:d') R1C1 style addressing
- ITEM Assertion OK : test13 Range('c1:g10').Columns A1 style addressing
- ITEM Assertion OK : test14 Range('c1:g10').Columns R1C1 style addressing
- ITEM Assertion OK : test15 Range('c1:g10').Columns(1) A1 style addressing
- ITEM Assertion OK : test16 Range('c1:g10').Columns(1) R1C1 style addressing
- ITEM Assertion OK : test17 Range('c1:g10').Columns('a') A1 style addressing
- ITEM Assertion OK : test18 Range('c1:g10').Columns('a') R1C1 style addressing
- ITEM Assertion OK : test19 Range('c1:g10').Columns('c') A1 style addressing
- ITEM Assertion OK : test20 Range('c1:g10').Columns('c') R1C1 style addressing
- ITEM Assertion OK : test21 Range('c1:g10').Columns('x:z') A1 style addressing
- ITEM Assertion OK : test22 Range('c1:g10').Columns('x:z') R1C1 style addressing
- ITEM Assertion OK : test23 Range('c1:g10').Columns(30) A1 style addressing
- ITEM Assertion OK : test24 Range('c1:g10').Columns(30) R1C1 style addressing
- ITEM Assertion OK : test25 Worksheets('Sheet2').Cells(1, 1) A1 style addressing
- ITEM Assertion OK : test26 Worksheets('Sheet2').Cells(1, 1) A1 style addressing, RowAddressAbsolute is false
- ITEM Assertion OK : test27 Worksheets('Sheet2').Cells(1, 1) A1 style addressing, ColAddressAbsolute is false
- ITEM Assertion OK : test28 Worksheets('Sheet2').Cells(1, 1) R1C1 style addressing
- ITEM Assertion OK : test29 Worksheets('Sheet2').Range('A1:E5').EntireColumn A1 style addressing
- ITEM Assertion OK : test30 Worksheets('Sheet2').Range('A1').EntireColumn A1 style addressing
- ITEM Assertion OK : test31 Worksheets('Sheet2').Range('A1:E5').EntireRow A1 style addressing
- ITEM Assertion OK : test32 Worksheets('Sheet2').Range('A1') A1 style addressing
- ITEM Assertion OK : test33 Worksheets('Sheet2').Range('IV65536').EntireRow A1 style addressing
- ITEM Assertion OK : test34 Worksheets('Sheet2').Range('IU2:IV65536') A1 style addressing
- ITEM Assertion OK : test35 Range('c1:g10').Columns('x:z') R1C1 style addressing
- ITEM Assertion OK : test36 Worksheets('Sheet2').Range('A1') A1 style addressing
- ITEM Assertion OK : test37 Worksheets('Sheet2').Range('A1:E5').EntireColumn A1 style addressing
- ITEM Assertion OK : test38 Worksheets('Sheet2').Range('10:12') A1 style addressing
- ITEM Assertion OK : test39 Worksheets('Sheet2').Range('10:12') R1C1 style addressing
- ITEM Assertion OK : test40 Range('Sheet3!A1:B4') A1 style addressing
- ITEM Assertion OK : test41 Range('Sheet3!A1,B1,D4:F20') A1 style addressing
- ITEM Assertion OK : test42 Range('g20:h40').Columns('c:c')
- ITEM Assertion OK : test43 Range('g20:h40').Columns('c:f')
- ITEM Assertion OK : test44 Range('g20:h40').Columns(-1)
- ITEM Assertion OK : test45 Range('c4:g10').Rows(-1)
- ITEM Assertion OK : test46 Range('a2:b4').Rows('1:1')
- ITEM Assertion OK : test47 Range('a2:b4').Rows('1:2')
- ITEM Assertion OK : test48 Range('a2:b4').Rows('2:2')
- ITEM Assertion OK : test49 Range('a2:b4').Rows('2:3')
-Test Results
-============
-
-Tests passed: 49
-Tests failed: 0
-
-END 'TestAddress
- TEST OK : TestAddress
-Test run finished : 17/07/2007 15:26:56
diff --git a/sc/source/ui/vba/testvba/TestDocuments/logs/win/TestCalc_Rangetest.log b/sc/source/ui/vba/testvba/TestDocuments/logs/win/TestCalc_Rangetest.log deleted file mode 100644 index 492c24bc0..000000000 --- a/sc/source/ui/vba/testvba/TestDocuments/logs/win/TestCalc_Rangetest.log +++ /dev/null @@ -1,60 +0,0 @@ -Test run started : 10/07/2007 01:56:07
-BEGIN TestCalc
- TEST START : RangeTest2
- ITEM Assertion OK : - Range("D15").Row
- ITEM Assertion OK : - WorkSheet("D15").Range.Row
- ITEM Assertion OK : - Range("D15").Column
- ITEM Assertion OK : - Worksheet.Range("D15").Column
- ITEM Assertion OK : - Range("D1").EntireRow.Valuer
- ITEM Assertion OK : - Range("D1").EntireRow.Valuer
- ITEM Assertion OK : - Range("D1").EntireRow.Columns.Count
- ITEM Assertion OK : - Range("D1").EntireColumn.Rows.Count
- ITEM Assertion OK : - Range("D15").ClearContent
- ITEM Assertion OK : - Range("M1:N2").Rows.Hidden (set)
- ITEM Assertion OK : - Range("M1:N2").Rows.Hidden (get)
- ITEM Assertion OK : - Range("M1:N2").Rows(1).Hidden (set)
- ITEM Assertion OK : - Range("M1:N2").Rows(1).Hidden (get)
- ITEM Assertion OK : - Range("M1:N2").Columns.Hidden (set)
- ITEM Assertion OK : - Range("M1:N2").Columns.Hidden (get)
- ITEM Assertion OK : - Range("M1:N2").Columns(1).Hidden (set)
- ITEM Assertion OK : - Range("M1:N2").Columns(1).Hidden (get)
- ITEM Assertion OK : - Range("B38").Orientation (get)
- ITEM Assertion OK : - Range("B38").Orientation (set)
- ITEM Assertion OK : - Range("B38").Orientation (set = xlDownward)
- ITEM Assertion OK : - Range("B38").Orientation (set)
- ITEM Assertion OK : - Range("B38").Orientation (set = xlUpward)
- ITEM Assertion OK : - Range("B38").Orientation (set)
- ITEM Assertion OK : - Range("B38").Orientation (set = xlVertical)
- ITEM Assertion OK : - Range("B38").Orientation (set)
- ITEM Assertion OK : - Range("B38").Orientation (set = xlVertical)
- ITEM Assertion OK : - Range("B39").WrapText (get)
- ITEM Assertion OK : - Range("B39").WrapText (set)
- ITEM Assertion OK : - Range("B39").WrapText (set)
- ITEM Assertion OK : - Range("E39").MergeCells (get)
- ITEM Assertion OK : - Range("F39").MergeCells (get)
- ITEM Assertion OK : - Range("E39").MergeCells (set)
- ITEM Assertion FAIL : - Range("F39").MergeCells (set)
- ITEM Assertion OK : - Range("E39").MergeCells (set)
- ITEM Assertion OK : - Range("F39").MergeCells (set)
- ITEM Assertion OK : - Range("C41:C42").Replace MatchCase:=True
- ITEM Assertion OK : - Range("C41:C42").Replace MatchCase:=True
- ITEM Assertion OK : - Range("D41:D42").Replace MatchCase:=False
- ITEM Assertion OK : - Range("B39").VerticalAlignment (get)
- ITEM Assertion OK : - Range("B39").VerticalAlignment (set)
- ITEM Assertion OK : - Range("B39").VerticalAlignment (get)
- ITEM Assertion OK : - Range("B39").VerticalAlignment (get)
- ITEM Assertion OK : - Range("B39").VerticalAlignment (set)
- ITEM Assertion OK : - Range("B39").VerticalAlignment (get)
- ITEM Assertion OK : - Range("B39").VerticalAlignment (set)
- ITEM Assertion OK : - Range("B39").HorizontalAlignment (get)
- ITEM Assertion OK : - Range("B39").HorizontalAlignment (set)
- ITEM Assertion OK : - Range("B39").HorizontalAlignment (get)
- ITEM Assertion OK : - Range("B39").HorizontalAlignment (set)
- ITEM Assertion OK : - Range("B39").HorizontalAlignment (get)
- ITEM Assertion OK : - Range("B39").HorizontalAlignment (set)
- ITEM Assertion OK : - Range("B39").HorizontalAlignment (get)
- ITEM Assertion OK : - Range("B39").HorizontalAlignment (set)
- ITEM FAIL (RangeTest2)
- TEST Not succesfully completed : RangeTest2
-END TestCalc
-Test run finished : 10/07/2007 01:56:12
diff --git a/sc/source/ui/vba/testvba/TestDocuments/logs/win/TestCalc_Rangetest2.log b/sc/source/ui/vba/testvba/TestDocuments/logs/win/TestCalc_Rangetest2.log deleted file mode 100644 index 2532289bb..000000000 --- a/sc/source/ui/vba/testvba/TestDocuments/logs/win/TestCalc_Rangetest2.log +++ /dev/null @@ -1,65 +0,0 @@ -Test run started : 10/07/2007 01:56:15
-BEGIN TestCalc
- TEST START : RangeTest3
- ITEM Assertion FAIL : - setFormulaR1C1
- ITEM Assertion OK : - getFormulaR1C1
- ITEM Assertion OK : - Range.Copy() and Range.PasteSpecial()
- ITEM Assertion OK : - Range.Copy(Range("I10"))
- ITEM Assertion OK : PasteSpecial Paste:=xlPasteValues
- ITEM Assertion OK : PasteSpecial Paste:=xlPasteFormulas
- ITEM Assertion OK : PasteSpecial Paste:=xlPasteFormats
- ITEM Assertion OK : PasteSpecial
- ITEM Assertion OK : PasteSpecial SkipBlanks:=True
- ITEM Assertion OK : PasteSpecial Operation:=xlPasteSpecialOperationAdd
- ITEM Assertion OK : PasteSpecial Operation:=xlPasteSpecialOperationSubtract
- ITEM Assertion OK : PasteSpecial Operation:=xlPasteSpecialOperationMultiply
- ITEM Assertion OK : PasteSpecial Operation:=xlPasteSpecialOperationDivide
- ITEM Assertion OK : PasteSpecial Transpose:=True
- ITEM Assertion FAIL : ActiveWorkbook.FileFormat
- ITEM Assertion OK : ActiveWorkbook.Name
- ITEM Assertion OK : ActiveWorkbook.FullName und ActiveWorkbook.Path
- ITEM Assertion FAIL : - = ActiveWorkbook.Colors(3) set
- ITEM Assertion OK : - = ActiveWorkbook.ResetColors
- ITEM Assertion OK : - = ActiveWorkbook.Colors(3) get
- ITEM Assertion OK : - = Range("K22").End (xlDown)
- ITEM Assertion OK : - = Range("K22").End (xlUo)
- ITEM Assertion OK : - = Range("K22").End (xlToLeft)
- ITEM Assertion OK : - = Range("K22").End (xlRight)
- ITEM Assertion OK : - ActiveSpreadsheet.Next
- ITEM Assertion OK : - ActiveSpreadsheet.Next
- ITEM Assertion OK : - ActiveSpreadsheet.Previous
- ITEM Assertion OK : - ActiveSpreadsheet.Previous
- ITEM Assertion OK : - Range("J4:J11").AutoFilter field:=1, Criteria1:="x"
- ITEM Assertion OK : - Range("J4:J11").AutoFilter field:=1, Criteria1:="<>"
- ITEM Assertion OK : - Range("J4:J11").AutoFilter field:=1, Criteria1:="="
- ITEM Assertion OK : - Range("J4:J11").AutoFilter
- ITEM Assertion OK : - ActiveSheet.Resize.Select
- ITEM Assertion OK : - Application.GoTo Reference:="R8C2"
- ITEM Assertion FAIL : - Application.GoTo Reference:="R[8]C[2]"
- ITEM Assertion OK : - Application.GoTo Reference:="R8C2"
- ITEM Assertion OK : - Range.Group - please check visually
- ITEM Assertion OK : - Range.Group - please check visually
- ITEM Assertion OK : - Range.Ungroup- please check visually
- ITEM Assertion OK : - Range.Ungroup - please check visually
- ITEM Assertion OK : - Range.Group - please check visually
- ITEM Assertion OK : - Range.Group - please check visually
- ITEM Assertion OK : - Range.clearOutline - please check visually
- ITEM Assertion OK : - Range.AutoOutline - please check visually
- ITEM Assertion OK : - Range.AutoOutline - please check visually
- ITEM Assertion OK : - ActiveSheet.UsedRange.Select
- ITEM Assertion OK : - Range("A13").AddIndent
- ITEM Assertion OK : - Range("A13").IndentLevel set
- ITEM Assertion OK : - Range("A13").IndentLevel get
- ITEM Assertion OK : - Range("A13").IndentLevel get
- ITEM Assertion OK : - Range.Copy() and Range.PasteSpecial()
- ITEM Assertion OK : - Range.Copy() and Range.PasteSpecial()
- ITEM Assertion OK : - Range.Copy() and Range.PasteSpecial()
- ITEM Assertion OK : - Range.Calculate
- ITEM Assertion OK : Worksheet.Calculate
- ITEM Assertion OK : - Application.Calculate
- ITEM Assertion OK : Global.Calculate
- ITEM Assertion OK : Calculation set
- ITEM FAIL (RangeTest3)
- TEST Not succesfully completed : RangeTest3
-END TestCalc
-Test run finished : 10/07/2007 01:56:23
diff --git a/sc/source/ui/vba/testvba/TestDocuments/logs/win/pagesetup.log b/sc/source/ui/vba/testvba/TestDocuments/logs/win/pagesetup.log deleted file mode 100644 index a1c90473c..000000000 --- a/sc/source/ui/vba/testvba/TestDocuments/logs/win/pagesetup.log +++ /dev/null @@ -1,87 +0,0 @@ -Test run started : 7/21/2008 10:37:24 AM
-BEGIN PageSetup
- TEST START : Sheet_PrintArea
- ITEM Assertion OK : PrintArea has changed as expected
- TEST OK : Sheet_PrintArea
- TEST START : Test margins (no headers)
- ITEM Assertion OK : PageSetup.LeftMargin set/get
- ITEM Assertion OK : PageSetup.RightMargin set/get
- ITEM Assertion OK : PageSetup.TopMargin set/get
- ITEM Assertion OK : PageSetup.BottomMargin set/get
-Verify that page margins on sheet 1 are all 0.5inch
- TEST OK : Test margins (no headers)
- TEST START : Test margins (headers)
- ITEM Assertion OK : PageSetup.HeaderMargin set/get
- ITEM Assertion OK : PageSetup.FooterMargin set/get
- ITEM Assertion OK : PageSetup.LeftMargin set/get
- ITEM Assertion OK : PageSetup.LeftMargin set/get
-Verify that top/bottom/header/footer page margins on sheet 2 are all 0.5inch
- TEST OK : Test margins (headers)
- TEST START : Test header/footer text
- ITEM Assertion OK : PageSetup.LeftHeader set
- ITEM Assertion OK : PageSetup.LeftHeader set/get
- ITEM Assertion OK : PageSetup.CenterHeader set
- ITEM Assertion OK : PageSetup.CenterHeader set/get
- ITEM Assertion OK : PageSetup.RightHeader set
- ITEM Assertion OK : PageSetup.RightHeader set/get
- ITEM Assertion OK : PageSetup.LeftFooter set
- ITEM Assertion OK : PageSetup.LeftFooter set/get
- ITEM Assertion OK : PageSetup.CenterFooter set
- ITEM Assertion OK : PageSetup.CenterFooter set/get
- ITEM Assertion OK : PageSetup.RightFooter set
- ITEM Assertion OK : PageSetup.RightFooter set/get
-Verify that headers on sheet 2 are Ready,to,go
-Verify that footers on sheet 2 are This,now,Works
- TEST OK : Test header/footer text
- TEST START : Test zoom
- ITEM Assertion OK : PageSetup.Zoom set
- ITEM Assertion OK : PageSetup.Zoom set/get
-Verify that sheet 1 zoom is 10%
- TEST OK : Test zoom
- TEST START : Test orientation
- ITEM Assertion OK : PageSetup.Zoom set
- ITEM Assertion OK : PageSetup.Orientation set/get
-Verify that sheet 1 orientation is now landscape
- TEST OK : Test orientation
- TEST START : Test paper size
- ITEM Assertion OK : PageSetup.PaperSize get
- ITEM Assertion OK : PageSetup.PaperSize set/get
-Verify that paper size on sheet 1 is now Letter
- TEST OK : Test paper size
- TEST START : Test order
- ITEM Assertion OK : PageSetup.Order get
- ITEM Assertion OK : PageSetup.Order set/get
-Verify that order on sheet 1 is now over, then down.
- TEST OK : Test order
- TEST START : Test first page number
- ITEM Assertion OK : PageSetup.FirstPageNumber get
- ITEM Assertion OK : PageSetup.FirstPageNumber set/get
-Verify that first page number on sheet 1 is now 2.
- TEST OK : Test first page number
- TEST START : Test center vertically
- ITEM Assertion OK : PageSetup.CenterVertically get
- ITEM Assertion OK : PageSetup.CenterVertically set/get
-Verify that CenterVertically on sheet 1 is now true.
- TEST OK : Test center vertically
- TEST START : Test center horizontally
- ITEM Assertion OK : PageSetup.CenterHorizontally get
- ITEM Assertion OK : PageSetup.CenterHorizontally set/get
-Verify that CenterHorizontally on sheet 1 is now true.
- TEST OK : Test center horizontally
- TEST START : Test FitToPagesTall
- ITEM Assertion OK : PageSetup.FitToPagesTall set/get
- TEST OK : Test FitToPagesTall
- TEST START : Test FitToPagesWide
- ITEM Assertion OK : PageSetup.FitToPagesWide set/get
- TEST OK : Test FitToPagesWide
- TEST START : Test PrintHeadings
- ITEM Assertion OK : PageSetup.PrintHeadings set/get
- ITEM Assertion OK : PageSetup.PrintHeadings set/get
- TEST OK : Test PrintHeadings
- TEST START : Test PrintTitleRows
- ITEM Assertion OK : PageSetup.PrintTitleRows get
- ITEM Assertion OK : PageSetup.PrintTitleRows set range/get
- ITEM Assertion OK : PageSetup.PrintTitleRows set false/get
- TEST OK : Test PrintTitleRows
-END PageSetup
-Test run finished : 7/21/2008 10:37:32 AM
diff --git a/sc/source/ui/vba/testvba/TestDocuments/logs/win/replace.log b/sc/source/ui/vba/testvba/TestDocuments/logs/win/replace.log deleted file mode 100644 index e96004e4d..000000000 --- a/sc/source/ui/vba/testvba/TestDocuments/logs/win/replace.log +++ /dev/null @@ -1,14 +0,0 @@ -Test run started : 2007-11-21 11:24:04
-BEGIN Replace
- TEST START : Test Replace function
- ITEM Assertion OK : common string:aefefdBc
- ITEM Assertion OK : expression string:aefefdef
- ITEM Assertion OK : binanary compare:aefefdBc
- ITEM Assertion OK : text compare:aefefdef
- ITEM Assertion OK : text compare:aefefdef
- ITEM Assertion OK : start = 3:cefdBc
- ITEM Assertion OK : count = 2: aefefdBc
- ITEM Assertion OK : start = 1, count = 0, not support in Unix: abcbcdBc
- TEST OK : Test Replace function
-END Replace
-Test run finished : 2007-11-21 11:24:04
diff --git a/sc/source/ui/vba/testvba/TestDocuments/pagesetup.xls b/sc/source/ui/vba/testvba/TestDocuments/pagesetup.xls Binary files differdeleted file mode 100755 index dfa1b2a8b..000000000 --- a/sc/source/ui/vba/testvba/TestDocuments/pagesetup.xls +++ /dev/null diff --git a/sc/source/ui/vba/testvba/TestDocuments/partition.xls b/sc/source/ui/vba/testvba/TestDocuments/partition.xls Binary files differdeleted file mode 100644 index 5c8d12b1d..000000000 --- a/sc/source/ui/vba/testvba/TestDocuments/partition.xls +++ /dev/null diff --git a/sc/source/ui/vba/testvba/TestDocuments/range-4.xls b/sc/source/ui/vba/testvba/TestDocuments/range-4.xls Binary files differdeleted file mode 100755 index 524523694..000000000 --- a/sc/source/ui/vba/testvba/TestDocuments/range-4.xls +++ /dev/null diff --git a/sc/source/ui/vba/testvba/TestDocuments/replace.xls b/sc/source/ui/vba/testvba/TestDocuments/replace.xls Binary files differdeleted file mode 100644 index dcf3c6e8e..000000000 --- a/sc/source/ui/vba/testvba/TestDocuments/replace.xls +++ /dev/null diff --git a/sc/source/ui/vba/testvba/TestDocuments/stringplusdouble.xls b/sc/source/ui/vba/testvba/TestDocuments/stringplusdouble.xls Binary files differdeleted file mode 100644 index 596be7f6b..000000000 --- a/sc/source/ui/vba/testvba/TestDocuments/stringplusdouble.xls +++ /dev/null diff --git a/sc/source/ui/vba/testvba/TestDocuments/window2.xls b/sc/source/ui/vba/testvba/TestDocuments/window2.xls Binary files differdeleted file mode 100755 index 4d5e1cbfe..000000000 --- a/sc/source/ui/vba/testvba/TestDocuments/window2.xls +++ /dev/null |