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_XConsolidationDescriptor" 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.XConsolidationDescriptor 41cdf0e10cSrcweir'************************************************************************* 42cdf0e10cSrcweirOn Error Goto ErrHndl 43cdf0e10cSrcweir Dim bOK As Boolean 44cdf0e10cSrcweir Dim mStartPos, objpos As Variant 45cdf0e10cSrcweir Dim bUseCols, bUseRows, bUsed, bLinks As Boolean 46cdf0e10cSrcweir Dim src(0) As New com.sun.star.table.CellRangeAddress 47cdf0e10cSrcweir Dim outpos As New com.sun.star.table.CellAddress 48cdf0e10cSrcweir Dim objSrc() As Variant 49cdf0e10cSrcweir 50cdf0e10cSrcweir Test.StartMethod("getFunction()") 51cdf0e10cSrcweir bOK = true 52cdf0e10cSrcweir bOK = bOK AND NOT IsNULL(oObj.Function) 53cdf0e10cSrcweir Test.MethodTested("getFunction()", bOK) 54cdf0e10cSrcweir 55cdf0e10cSrcweir Test.StartMethod("getSources()") 56cdf0e10cSrcweir bOK = true 57cdf0e10cSrcweir bOK = bOK AND NOT isNULL(oObj.getSources()) 58cdf0e10cSrcweir Test.MethodTested("getSources()", bOK) 59cdf0e10cSrcweir 60cdf0e10cSrcweir Test.StartMethod("getStartOutputPosition()") 61cdf0e10cSrcweir bOK = true 62cdf0e10cSrcweir mStartPos = oObj.getStartOutputPosition() 63cdf0e10cSrcweir bOK = mStartPos.Row >= 0 ' Checking that returned type is correct 64cdf0e10cSrcweir ' (if Object has such field) 65cdf0e10cSrcweir Test.MethodTested("getStartOutputPosition()", bOK) 66cdf0e10cSrcweir 67cdf0e10cSrcweir Test.StartMethod("getUseRowHeaders()") 68cdf0e10cSrcweir Test.StartMethod("setUseRowHeaders()") 69cdf0e10cSrcweir bOK = true 70cdf0e10cSrcweir bUsed = oObj.getUseRowHeaders 71cdf0e10cSrcweir oObj.setUseRowHeaders(NOT bUsed) 72cdf0e10cSrcweir bOK = bOK AND (oObj.getUseRowHeaders <> bUsed) 73cdf0e10cSrcweir Test.MethodTested("getUseRowHeaders()", bOK) 74cdf0e10cSrcweir Test.MethodTested("setUseRowHeaders()", bOK) 75cdf0e10cSrcweir 76cdf0e10cSrcweir Test.StartMethod("setFunction()") 77cdf0e10cSrcweir bOK = true 78cdf0e10cSrcweir oObj.setFunction(com.sun.star.sheet.GeneralFunction.MAX) 79cdf0e10cSrcweir bOK = bOK AND (oObj.getFunction = com.sun.star.sheet.GeneralFunction.MAX) 80cdf0e10cSrcweir Test.MethodTested("setFunction()", bOK) 81cdf0e10cSrcweir 82cdf0e10cSrcweir Test.StartMethod("getInsertLinks()") 83cdf0e10cSrcweir Test.StartMethod("setInsertLinks()") 84cdf0e10cSrcweir bOK = true 85cdf0e10cSrcweir bLinks = oObj.getInsertLinks 86cdf0e10cSrcweir oObj.setInsertLinks(NOT bLinks) 87cdf0e10cSrcweir bOK = bOK AND (oObj.getInsertLinks <> bLinks) 88cdf0e10cSrcweir Test.MethodTested("getInsertLinks()", bOK) 89cdf0e10cSrcweir Test.MethodTested("setInsertLinks()", bOK) 90cdf0e10cSrcweir 91cdf0e10cSrcweir Test.StartMethod("setSources()") 92cdf0e10cSrcweir bOK = true 93cdf0e10cSrcweir src(0).Sheet = 0 94cdf0e10cSrcweir src(0).StartRow = 5 95cdf0e10cSrcweir src(0).StartColumn = 5 96cdf0e10cSrcweir src(0).EndRow = 10 97cdf0e10cSrcweir src(0).EndColumn = 10 98cdf0e10cSrcweir oObj.setSources(src()) 99cdf0e10cSrcweir objSrc() = oObj.getSources 100cdf0e10cSrcweir bOK = bOK AND ((objSrc(0).Sheet = src(0).Sheet) AND _ 101cdf0e10cSrcweir (objSrc(0).StartRow = src(0).StartRow) AND _ 102cdf0e10cSrcweir (objSrc(0).EndRow = src(0).EndRow) AND _ 103cdf0e10cSrcweir (objSrc(0).StartColumn = src(0).StartColumn) AND _ 104cdf0e10cSrcweir (objSrc(0).EndColumn = src(0).EndColumn)) 105cdf0e10cSrcweir Test.MethodTested("setSources()", bOK) 106cdf0e10cSrcweir 107cdf0e10cSrcweir Test.StartMethod("setStartOutputPosition()") 108cdf0e10cSrcweir bOK = true 109cdf0e10cSrcweir outpos.Sheet = 0 110cdf0e10cSrcweir outpos.Row = 2 111cdf0e10cSrcweir outpos.Column = 2 112cdf0e10cSrcweir oObj.setStartOutputPosition(outpos) 113cdf0e10cSrcweir objpos = oObj.getStartOutputPosition 114cdf0e10cSrcweir bOK = bOK AND ((objpos(0).Sheet = outpos(0).Sheet) AND _ 115cdf0e10cSrcweir (objpos(0).Row = outpos(0).Row) AND _ 116cdf0e10cSrcweir (objpos(0).Column = outpos(0).Column)) 117cdf0e10cSrcweir Test.MethodTested("setStartOutputPosition()", bOK) 118cdf0e10cSrcweir 119cdf0e10cSrcweir Test.StartMethod("getUseColumnHeaders()") 120cdf0e10cSrcweir bOK = true 121cdf0e10cSrcweir bUseCols = oObj.getUseColumnHeaders() 122cdf0e10cSrcweir oObj.setUseColumnHeaders(NOT bUseCols) 123cdf0e10cSrcweir bOK = bOK AND (oObj.getUseColumnHeaders() <> bUseCols) 124cdf0e10cSrcweir Test.MethodTested("getUseColumnHeaders()", bOK) 125cdf0e10cSrcweir 126cdf0e10cSrcweir Test.StartMethod("setUseColumnHeaders()") 127cdf0e10cSrcweir bOK = true 128cdf0e10cSrcweir bUseRows = oObj.getUseRowHeaders 129cdf0e10cSrcweir oObj.setUseRowHeaders(NOT bUseRows) 130cdf0e10cSrcweir bOK = bOK AND (oObj.getUseRowHeaders <> bUseRows) 131cdf0e10cSrcweir Test.MethodTested("setUseColumnHeaders()", bOK) 132cdf0e10cSrcweir 133cdf0e10cSrcweirExit Sub 134cdf0e10cSrcweirErrHndl: 135cdf0e10cSrcweir Test.Exception() 136cdf0e10cSrcweir bOK = false 137cdf0e10cSrcweir resume next 138cdf0e10cSrcweirEnd Sub 139cdf0e10cSrcweir</script:module> 140