1cdf0e10cSrcweir<?xml version="1.0" encoding="UTF-8"?>
2cdf0e10cSrcweir<!DOCTYPE script:module PUBLIC "-//OpenOffice.org//DTD OfficeDocument 1.0//EN" "module.dtd">
3cdf0e10cSrcweir<script:module xmlns:script="http://openoffice.org/2000/script" script:name="sc_ScLabelRangeObj" script:language="StarBasic">
4cdf0e10cSrcweir
5cdf0e10cSrcweir
6cdf0e10cSrcweir'*************************************************************************
7cdf0e10cSrcweir'
8*5846f787SAndrew Rist'  Licensed to the Apache Software Foundation (ASF) under one
9*5846f787SAndrew Rist'  or more contributor license agreements.  See the NOTICE file
10*5846f787SAndrew Rist'  distributed with this work for additional information
11*5846f787SAndrew Rist'  regarding copyright ownership.  The ASF licenses this file
12*5846f787SAndrew Rist'  to you under the Apache License, Version 2.0 (the
13*5846f787SAndrew Rist'  "License"); you may not use this file except in compliance
14*5846f787SAndrew Rist'  with the License.  You may obtain a copy of the License at
15*5846f787SAndrew Rist'
16*5846f787SAndrew Rist'    http://www.apache.org/licenses/LICENSE-2.0
17*5846f787SAndrew Rist'
18*5846f787SAndrew Rist'  Unless required by applicable law or agreed to in writing,
19*5846f787SAndrew Rist'  software distributed under the License is distributed on an
20*5846f787SAndrew Rist'  "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
21*5846f787SAndrew Rist'  KIND, either express or implied.  See the License for the
22*5846f787SAndrew Rist'  specific language governing permissions and limitations
23*5846f787SAndrew Rist'  under the License.
24cdf0e10cSrcweir'
25cdf0e10cSrcweir'*************************************************************************
26cdf0e10cSrcweir
27cdf0e10cSrcweir
28cdf0e10cSrcweir
29*5846f787SAndrew Rist
30*5846f787SAndrew Rist
31cdf0e10cSrcweir' Be sure that all variables are dimensioned:
32cdf0e10cSrcweiroption explicit
33cdf0e10cSrcweir
34cdf0e10cSrcweir
35cdf0e10cSrcweir
36cdf0e10cSrcweirSub CreateObj()
37cdf0e10cSrcweir
38cdf0e10cSrcweir'*************************************************************************
39cdf0e10cSrcweir' COMPONENT:
40cdf0e10cSrcweir' sc.ScLabelRangeObj
41cdf0e10cSrcweir'*************************************************************************
42cdf0e10cSrcweirOn Error Goto ErrHndl
43cdf0e10cSrcweir    Dim bOK As Boolean
44cdf0e10cSrcweir    Dim RangeAddress1 As New com.sun.star.table.CellRangeAddress
45cdf0e10cSrcweir    Dim RangeAddress2 As New com.sun.star.table.CellRangeAddress
46cdf0e10cSrcweir    Dim oRanges As Object
47cdf0e10cSrcweir
48cdf0e10cSrcweir    bOK = true
49cdf0e10cSrcweir    oDoc = utils.createDocument("scalc", cObjectName)
50cdf0e10cSrcweir
51cdf0e10cSrcweir    oRanges = oDoc.getPropertyValue("ColumnLabelRanges")
52cdf0e10cSrcweir    RangeAddress1.Sheet = 0
53cdf0e10cSrcweir    RangeAddress1.StartColumn = 1
54cdf0e10cSrcweir    RangeAddress1.StartRow = 1
55cdf0e10cSrcweir    RangeAddress1.EndColumn = 2
56cdf0e10cSrcweir    RangeAddress1.EndRow = 2
57cdf0e10cSrcweir
58cdf0e10cSrcweir    RangeAddress2.Sheet = 0
59cdf0e10cSrcweir    RangeAddress2.StartColumn = 5
60cdf0e10cSrcweir    RangeAddress2.StartRow = 5
61cdf0e10cSrcweir    RangeAddress2.EndColumn = 6
62cdf0e10cSrcweir    RangeAddress2.EndRow = 7
63cdf0e10cSrcweir
64cdf0e10cSrcweir    oRanges.addNew(RangeAddress1, RangeAddress2)
65cdf0e10cSrcweir
66cdf0e10cSrcweir    oObj = oRanges(0)
67cdf0e10cSrcweir
68cdf0e10cSrcweirExit Sub
69cdf0e10cSrcweirErrHndl:
70cdf0e10cSrcweir    Test.Exception()
71cdf0e10cSrcweirEnd Sub
72cdf0e10cSrcweir</script:module>
73