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_ScCellRangesObj" 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' REQUIRED VARIABLES for interface/service tests: 36cdf0e10cSrcweir 37cdf0e10cSrcweirGlobal oInstance As Object 38cdf0e10cSrcweir 39cdf0e10cSrcweir' Requiered for com.sun.star.container.XNameReplace 40cdf0e10cSrcweirGlobal cNameToReplace As String 'name of instance to be replased 41cdf0e10cSrcweirGlobal oReplaceInstance As Object 'instance, that will be inserted 42cdf0e10cSrcweir 'instead old one 43cdf0e10cSrcweir 44cdf0e10cSrcweir 45cdf0e10cSrcweirSub CreateObj() 46cdf0e10cSrcweir 47cdf0e10cSrcweir'************************************************************************* 48cdf0e10cSrcweir' COMPONENT: 49cdf0e10cSrcweir' sc.ScCellRangesObj 50cdf0e10cSrcweir'************************************************************************* 51cdf0e10cSrcweirOn Error Goto ErrHndl 52cdf0e10cSrcweir Dim oSheet As Object 53cdf0e10cSrcweir 54cdf0e10cSrcweir oDoc = utils.createDocument("scalc", cObjectName) 55cdf0e10cSrcweir oObj = oDoc.createInstance("com.sun.star.sheet.SheetCellRanges") 56cdf0e10cSrcweir oSheet = oDoc.Sheets(1) 57cdf0e10cSrcweir 58cdf0e10cSrcweir oInstance=oSheet.getCellRangeByName("A1:C5") 59cdf0e10cSrcweir oObj.insertByName("CellRange1", oInstance) 60cdf0e10cSrcweir oInstance=oSheet.getCellRangeByName("A7:D9") 61cdf0e10cSrcweir oObj.insertByName("CellRange2", oInstance) 62cdf0e10cSrcweir oInstance=oSheet.getCellRangeByName("E1:E42") 63cdf0e10cSrcweir oObj.insertByName("CellRange3", oInstance) 64cdf0e10cSrcweir oInstance=oSheet.getCellRangeByName("A10:B10") 65cdf0e10cSrcweir oObj.insertByName("CellRange4", oInstance) 66cdf0e10cSrcweir 67cdf0e10cSrcweir oReplaceInstance = oSheet.getCellRangeByName("A6:H16") 68cdf0e10cSrcweir cNameToReplace = "CellRange4" 69cdf0e10cSrcweirExit Sub 70cdf0e10cSrcweirErrHndl: 71cdf0e10cSrcweir Test.Exception() 72cdf0e10cSrcweirEnd Sub 73cdf0e10cSrcweir</script:module> 74