blob: 4ac4e48941f672ec5f30fe77e12649906dfb5298 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
|
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE script:module PUBLIC "-//OpenOffice.org//DTD OfficeDocument 1.0//EN" "module.dtd">
<script:module xmlns:script="http://openoffice.org/2000/script" script:name="sheet_XUsedAreaCursor" script:language="StarBasic">
'*************************************************************************
'
' DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
'
' Copyright 2000, 2010 Oracle and/or its affiliates.
'
' OpenOffice.org - a multi-platform office productivity suite
'
' This file is part of OpenOffice.org.
'
' OpenOffice.org is free software: you can redistribute it and/or modify
' it under the terms of the GNU Lesser General Public License version 3
' only, as published by the Free Software Foundation.
'
' OpenOffice.org is distributed in the hope that it will be useful,
' but WITHOUT ANY WARRANTY; without even the implied warranty of
' MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
' GNU Lesser General Public License version 3 for more details
' (a copy is included in the LICENSE file that accompanied this code).
'
' You should have received a copy of the GNU Lesser General Public License
' version 3 along with OpenOffice.org. If not, see
' <http://www.openoffice.org/license.html>
' for a copy of the LGPLv3 License.
'
'*************************************************************************
'*************************************************************************
' Be sure that all variables are dimensioned:
option explicit
Sub RunTest()
'*************************************************************************
' INTERFACE:
' com.sun.star.sheet.XUsedAreaCursor
'*************************************************************************
On Error Goto ErrHndl
Dim bOK As Boolean
Dim nStartSCol, nStartECol As Integer
Dim nStartSRow, nStartERow As Long
Dim nEndSCol, nEndECol As Integer
Dim nEndSRow, nEndERow As Long
Dim oAddress As Object
Test.StartMethod("gotoStartOfUsedArea()")
bOK = true
oObj.gotoStartOfUsedArea(true)
oAddress = oObj.getRangeAddress()
nStartSCol = oAddress.StartColumn
nStartECol = oAddress.EndColumn
nStartSRow = oAddress.StartRow
nStartERow = oAddress.EndRow
Test.StartMethod("gotoEndOfUsedArea()")
bOK = true
oObj.gotoEndOfUsedArea(true)
oAddress = oObj.getRangeAddress()
nEndSCol = oAddress.StartColumn
nEndECol = oAddress.EndColumn
nEndSRow = oAddress.StartRow
nEndERow = oAddress.EndRow
'get the results
bOK = bOK AND ((nStartSCol <> nEndSCol) OR (nStartECol <> nEndECol) OR _
(nStartSRow <> nEndSRow) OR (nStartERow <> nEndERow))
Test.MethodTested("gotoStartOfUsedArea()", bOK)
Test.MethodTested("gotoEndOfUsedArea()", bOK)
Exit Sub
ErrHndl:
Test.Exception()
bOK = false
resume next
End Sub
</script:module>
|