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="sheet_XLabelRange" script:language="StarBasic"> 4cdf0e10cSrcweir 5cdf0e10cSrcweir 6cdf0e10cSrcweir'************************************************************************* 7cdf0e10cSrcweir' 8*eebed415SAndrew Rist' Licensed to the Apache Software Foundation (ASF) under one 9*eebed415SAndrew Rist' or more contributor license agreements. See the NOTICE file 10*eebed415SAndrew Rist' distributed with this work for additional information 11*eebed415SAndrew Rist' regarding copyright ownership. The ASF licenses this file 12*eebed415SAndrew Rist' to you under the Apache License, Version 2.0 (the 13*eebed415SAndrew Rist' "License"); you may not use this file except in compliance 14*eebed415SAndrew Rist' with the License. You may obtain a copy of the License at 15*eebed415SAndrew Rist' 16*eebed415SAndrew Rist' http://www.apache.org/licenses/LICENSE-2.0 17*eebed415SAndrew Rist' 18*eebed415SAndrew Rist' Unless required by applicable law or agreed to in writing, 19*eebed415SAndrew Rist' software distributed under the License is distributed on an 20*eebed415SAndrew Rist' "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 21*eebed415SAndrew Rist' KIND, either express or implied. See the License for the 22*eebed415SAndrew Rist' specific language governing permissions and limitations 23*eebed415SAndrew Rist' under the License. 24cdf0e10cSrcweir' 25cdf0e10cSrcweir'************************************************************************* 26cdf0e10cSrcweir 27cdf0e10cSrcweir 28cdf0e10cSrcweir 29*eebed415SAndrew Rist 30*eebed415SAndrew Rist 31cdf0e10cSrcweir' Be sure that all variables are dimensioned: 32cdf0e10cSrcweiroption explicit 33cdf0e10cSrcweir 34cdf0e10cSrcweir 35cdf0e10cSrcweir 36cdf0e10cSrcweirSub RunTest() 37cdf0e10cSrcweir 38cdf0e10cSrcweir'************************************************************************* 39cdf0e10cSrcweir' INTERFACE: 40cdf0e10cSrcweir' com.sun.star.sheet.XLabelRange 41cdf0e10cSrcweir'************************************************************************* 42cdf0e10cSrcweirOn Error Goto ErrHndl 43cdf0e10cSrcweir Dim bOK, bAllOK As Boolean 44cdf0e10cSrcweir Dim oldArea, newArea As Object 45cdf0e10cSrcweir Dim Area As New com.sun.star.table.CellRangeAddress 46cdf0e10cSrcweir 47cdf0e10cSrcweir Test.StartMethod("getLabelArea()") 48cdf0e10cSrcweir bOK = true 49cdf0e10cSrcweir bOK = bOK AND NOT isNULL(oObj.getLabelArea()) 50cdf0e10cSrcweir Test.MethodTested("getLabelArea()", bOK) 51cdf0e10cSrcweir 52cdf0e10cSrcweir bAllOK = bAllOK AND bOK 53cdf0e10cSrcweir 54cdf0e10cSrcweir Test.StartMethod("setLabelArea()") 55cdf0e10cSrcweir bOK = true 56cdf0e10cSrcweir 57cdf0e10cSrcweir Area.Sheet = 0 58cdf0e10cSrcweir Area.StartColumn = 1 59cdf0e10cSrcweir Area.StartRow = 1 60cdf0e10cSrcweir Area.EndColumn = 5 61cdf0e10cSrcweir Area.EndRow = 5 62cdf0e10cSrcweir 63cdf0e10cSrcweir oldArea = oObj.getLabelArea() 64cdf0e10cSrcweir oObj.setLabelArea(Area) 65cdf0e10cSrcweir newArea = oObj.getLabelArea() 66cdf0e10cSrcweir bOK = bOK AND NOT isNULL(newArea) 67cdf0e10cSrcweir 68cdf0e10cSrcweir bOK = bOK AND newArea.Sheet = Area.Sheet 69cdf0e10cSrcweir bOK = bOK AND newArea.StartColumn = Area.StartColumn 70cdf0e10cSrcweir bOK = bOK AND newArea.StartRow = Area.StartRow 71cdf0e10cSrcweir bOK = bOK AND newArea.EndColumn = Area.EndColumn 72cdf0e10cSrcweir bOK = bOK AND newArea.EndRow = Area.EndRow 73cdf0e10cSrcweir 74cdf0e10cSrcweir oObj.setLabelArea(oldArea) 75cdf0e10cSrcweir Test.MethodTested("setLabelArea()", bOK) 76cdf0e10cSrcweir 77cdf0e10cSrcweir Test.StartMethod("getDataArea()") 78cdf0e10cSrcweir bOK = true 79cdf0e10cSrcweir bOK = bOK AND NOT isNULL(oObj.getDataArea()) 80cdf0e10cSrcweir Test.MethodTested("getDataArea()", bOK) 81cdf0e10cSrcweir 82cdf0e10cSrcweir Test.StartMethod("setDataArea()") 83cdf0e10cSrcweir bOK = true 84cdf0e10cSrcweir 85cdf0e10cSrcweir Area.Sheet = 0 86cdf0e10cSrcweir Area.StartColumn = 1 87cdf0e10cSrcweir Area.StartRow = 1 88cdf0e10cSrcweir Area.EndColumn = 5 89cdf0e10cSrcweir Area.EndRow = 5 90cdf0e10cSrcweir 91cdf0e10cSrcweir oldArea = oObj.getDataArea() 92cdf0e10cSrcweir oObj.setDataArea(Area) 93cdf0e10cSrcweir newArea = oObj.getDataArea() 94cdf0e10cSrcweir bOK = bOK AND NOT isNULL(newArea) 95cdf0e10cSrcweir 96cdf0e10cSrcweir bOK = bOK AND newArea.Sheet = Area.Sheet 97cdf0e10cSrcweir bOK = bOK AND newArea.StartColumn = Area.StartColumn 98cdf0e10cSrcweir bOK = bOK AND newArea.StartRow = Area.StartRow 99cdf0e10cSrcweir bOK = bOK AND newArea.EndColumn = Area.EndColumn 100cdf0e10cSrcweir bOK = bOK AND newArea.EndRow = Area.EndRow 101cdf0e10cSrcweir 102cdf0e10cSrcweir oObj.setDataArea(oldArea) 103cdf0e10cSrcweir Test.MethodTested("setDataArea()", bOK) 104cdf0e10cSrcweir 105cdf0e10cSrcweirExit Sub 106cdf0e10cSrcweirErrHndl: 107cdf0e10cSrcweir Test.Exception() 108cdf0e10cSrcweir bOK = false 109cdf0e10cSrcweir resume next 110cdf0e10cSrcweirEnd Sub 111cdf0e10cSrcweir</script:module> 112