1<?xml version="1.0" encoding="UTF-8"?>
2<!DOCTYPE script:module PUBLIC "-//OpenOffice.org//DTD OfficeDocument 1.0//EN" "module.dtd">
3<script:module xmlns:script="http://openoffice.org/2000/script" script:name="sheet_XNamedRange" script:language="StarBasic">
4
5
6'*************************************************************************
7'
8' DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
9'
10' Copyright 2000, 2010 Oracle and/or its affiliates.
11'
12' OpenOffice.org - a multi-platform office productivity suite
13'
14' This file is part of OpenOffice.org.
15'
16' OpenOffice.org is free software: you can redistribute it and/or modify
17' it under the terms of the GNU Lesser General Public License version 3
18' only, as published by the Free Software Foundation.
19'
20' OpenOffice.org is distributed in the hope that it will be useful,
21' but WITHOUT ANY WARRANTY; without even the implied warranty of
22' MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
23' GNU Lesser General Public License version 3 for more details
24' (a copy is included in the LICENSE file that accompanied this code).
25'
26' You should have received a copy of the GNU Lesser General Public License
27' version 3 along with OpenOffice.org.  If not, see
28' <http://www.openoffice.org/license.html>
29' for a copy of the LGPLv3 License.
30'
31'*************************************************************************
32*****
33'*************************************************************************
34
35
36
37' Be sure that all variables are dimensioned:
38option explicit
39
40
41
42Sub RunTest()
43
44'*************************************************************************
45' INTERFACE:
46' com.sun.star.sheet.XNamedRange
47'*************************************************************************
48On Error Goto ErrHndl
49    Dim bOK As Boolean
50    Dim oldContent, newContent As String
51    Dim position, oldPosition As Object
52    Dim newPosition As New com.sun.star.table.CellAddress
53    Dim oldType, newType As Long
54
55    Test.StartMethod("getContent()")
56    bOK = true
57    bOK = bOK AND NOT isNULL(oObj.getContent())
58    Test.MethodTested("getContent()", bOK)
59
60    Test.StartMethod("setContent()")
61    bOK = true
62    oldContent = oObj.getContent
63    newContent = cIfcShortName
64    oObj.setContent(newContent)
65    bOK = bOK AND (oldContent &lt;&gt; oObj.getContent)
66    oObj.setContent(oldContent)
67    Test.MethodTested("setContent()", bOK)
68
69    Test.StartMethod("getReferencePosition()")
70    bOK = true
71    bOK = bOK AND NOT isNULL(oObj.getReferencePosition())
72    Test.MethodTested("getReferencePosition()", bOK)
73
74    Test.StartMethod("setReferencePosition()")
75    bOK = true
76    oldPosition = oObj.getReferencePosition()
77
78    newPosition.sheet = oldPosition.sheet
79    newPosition.row = oldPosition.row + 1
80    newPosition.column = oldPosition.column + 1
81    oObj.setReferencePosition(newPosition)
82    position = oObj.getReferencePosition()
83
84    bOK = bOK AND NOT isNULL(position)
85    bOK = bOK AND position.Row &lt;&gt; oldPosition.row
86    bOK = bOK AND position.Column &lt;&gt; oldPosition.Column
87
88    oObj.setReferencePosition(oldPosition)
89    Test.MethodTested("setReferencePosition()", bOK)
90
91    Test.StartMethod("getType()")
92    bOK = true
93    bOK = bOK AND NOT isNULL(oObj.getType)
94    Test.MethodTested("getType()", bOK)
95
96    Test.StartMethod("setType()")
97    bOK = true
98    oldType = oObj.getType()
99    newType = oldType XOR com.sun.star.sheet.NamedRangeFlag.PRINT_AREA
100    oObj.setType(newType)
101    bOK = bOK AND (oldType &lt;&gt; oObj.getType())
102    oObj.setType(oldType)
103    Test.MethodTested("setType()", bOK)
104
105Exit Sub
106ErrHndl:
107    Test.Exception()
108    bOK = false
109    resume next
110End Sub
111</script:module>
112