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_ScDatabaseRangeObj" script:language="StarBasic"> 4cdf0e10cSrcweir 5cdf0e10cSrcweir 6cdf0e10cSrcweir'************************************************************************* 7cdf0e10cSrcweir' 85846f787SAndrew Rist' Licensed to the Apache Software Foundation (ASF) under one 95846f787SAndrew Rist' or more contributor license agreements. See the NOTICE file 105846f787SAndrew Rist' distributed with this work for additional information 115846f787SAndrew Rist' regarding copyright ownership. The ASF licenses this file 125846f787SAndrew Rist' to you under the Apache License, Version 2.0 (the 135846f787SAndrew Rist' "License"); you may not use this file except in compliance 145846f787SAndrew Rist' with the License. You may obtain a copy of the License at 15cdf0e10cSrcweir' 165846f787SAndrew Rist' http://www.apache.org/licenses/LICENSE-2.0 17cdf0e10cSrcweir' 185846f787SAndrew Rist' Unless required by applicable law or agreed to in writing, 195846f787SAndrew Rist' software distributed under the License is distributed on an 205846f787SAndrew Rist' "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 215846f787SAndrew Rist' KIND, either express or implied. See the License for the 225846f787SAndrew Rist' specific language governing permissions and limitations 235846f787SAndrew Rist' under the License. 24cdf0e10cSrcweir' 25cdf0e10cSrcweir'************************************************************************* 265846f787SAndrew Rist 275846f787SAndrew Rist 28cdf0e10cSrcweir 29cdf0e10cSrcweir 30cdf0e10cSrcweir 31cdf0e10cSrcweir' Be sure that all variables are dimensioned: 32cdf0e10cSrcweiroption explicit 33cdf0e10cSrcweir 34cdf0e10cSrcweir 35cdf0e10cSrcweir' REQUIRED VARIABLES for interface/service tests: 36cdf0e10cSrcweir 37*d4fdf834SJohn Bampton' Required for com.sun.star.container.XNamed 38cdf0e10cSrcweir Global cNameToSet As String ' "fixed" if name is fixed 39cdf0e10cSrcweir 40*d4fdf834SJohn Bampton' Required for com.sun.star.sheet.XCellRangeReferrer 41cdf0e10cSrcweir Global oReferredCells As Variant 42cdf0e10cSrcweir 43cdf0e10cSrcweir 44cdf0e10cSrcweirSub CreateObj() 45cdf0e10cSrcweir 46cdf0e10cSrcweir'************************************************************************* 47cdf0e10cSrcweir' COMPONENT: 48cdf0e10cSrcweir' sc.ScDatabaseRangeObj 49cdf0e10cSrcweir'************************************************************************* 50cdf0e10cSrcweirOn Error Goto ErrHndl 51cdf0e10cSrcweir Dim oRanges As Variant 52cdf0e10cSrcweir Dim sCellRangeAddress As New com.sun.star.table.CellRangeAddress 53cdf0e10cSrcweir 54cdf0e10cSrcweir oDoc = utils.createDocument("scalc", cObjectName) 55cdf0e10cSrcweir sCellRangeAddress.Sheet = 0 56cdf0e10cSrcweir sCellRangeAddress.StartColumn = 1 57cdf0e10cSrcweir sCellRangeAddress.StartRow = 1 58cdf0e10cSrcweir sCellRangeAddress.EndColumn = 5 59cdf0e10cSrcweir sCellRangeAddress.EndRow = 5 60cdf0e10cSrcweir 61cdf0e10cSrcweir oRanges = oDoc.getPropertyValue("DatabaseRanges") 62cdf0e10cSrcweir oRanges.addNewByName(cObjectName, sCellRangeAddress) 63cdf0e10cSrcweir oReferredCells = sCellRangeAddress 64cdf0e10cSrcweir 65cdf0e10cSrcweir oObj = oRanges.getByIndex(0) 66cdf0e10cSrcweirExit Sub 67cdf0e10cSrcweirErrHndl: 68cdf0e10cSrcweir Test.Exception() 69cdf0e10cSrcweirEnd Sub 70cdf0e10cSrcweir</script:module> 71