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="container_XNameReplace" 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' This Interface/Service test depends on the following GLOBAL variables, 36cdf0e10cSrcweir' which must be specified in the object creation: 37cdf0e10cSrcweir 38cdf0e10cSrcweir' Global cNameToReplace As String 'name of instance to be replased 39cdf0e10cSrcweir' Global oReplaceInstance As Variant 'instance, that will be inserted 40cdf0e10cSrcweir' instead old one 41cdf0e10cSrcweir 42cdf0e10cSrcweir'************************************************************************* 43cdf0e10cSrcweir 44cdf0e10cSrcweirSub RunTest() 45cdf0e10cSrcweir 46cdf0e10cSrcweir'************************************************************************* 47cdf0e10cSrcweir' INTERFACE: 48cdf0e10cSrcweir' com.sun.star.container.XNameReplace 49cdf0e10cSrcweir'************************************************************************* 50cdf0e10cSrcweirOn Error Goto ErrHndl 51cdf0e10cSrcweir Dim bOK As Boolean 52cdf0e10cSrcweir Dim oOldObject As Object 53cdf0e10cSrcweir Dim cOldObjName As String 54cdf0e10cSrcweir Dim oNewControl As Object 55cdf0e10cSrcweir Dim cNewObjName As String 56cdf0e10cSrcweir Dim NewAddress As Object 57cdf0e10cSrcweir Dim InstAddress As Object 58cdf0e10cSrcweir Dim cReplInstName As String 59cdf0e10cSrcweir 60cdf0e10cSrcweir Test.StartMethod("replaceByName()") 61cdf0e10cSrcweir bOK = true 62cdf0e10cSrcweir 63cdf0e10cSrcweir if (cObjectName = "sc.ScCellRangesObj") then 64cdf0e10cSrcweir oOldObject = oObj.getByName(cNameToReplace) 65cdf0e10cSrcweir InstAddress = oReplaceInstance.getRangeAddress 66cdf0e10cSrcweir 67cdf0e10cSrcweir oObj.replaceByName(cNameToReplace, oReplaceInstance) 68cdf0e10cSrcweir 69cdf0e10cSrcweir oNewControl = oObj.getByName(cNameToReplace) 70cdf0e10cSrcweir NewAddress = oNewControl.getRangeAddress 71cdf0e10cSrcweir 72cdf0e10cSrcweir bOK = bOK AND NewAddress.Sheet = InstAddress.Sheet 73cdf0e10cSrcweir bOK = bOK AND NewAddress.StartColumn = InstAddress.StartColumn 74cdf0e10cSrcweir bOK = bOK AND NewAddress.EndColumn = InstAddress.EndColumn 75cdf0e10cSrcweir bOK = bOK AND NewAddress.StartRow = InstAddress.StartRow 76cdf0e10cSrcweir bOK = bOK AND NewAddress.EndRow = InstAddress.EndRow 77cdf0e10cSrcweir 78cdf0e10cSrcweir elseif typename(oReplaceInstance) = "String" then 79cdf0e10cSrcweir Dim oNewObj as Variant 80cdf0e10cSrcweir Dim oOldObj as Variant 81cdf0e10cSrcweir oOldObj = oObj.getByName(cNameToReplace) 82cdf0e10cSrcweir oObj.replaceByName(cNameToReplace, oReplaceInstance) 83cdf0e10cSrcweir oNewObj = oObj.getByName(cNameToReplace) 84cdf0e10cSrcweir bOK = bOK and not PropertyTester.equals(oOldObj, oNewObj) 85cdf0e10cSrcweir else 86cdf0e10cSrcweir oOldObject = oObj.getByName(cNameToReplace) 87cdf0e10cSrcweir cReplInstName = oReplaceInstance.Name 88cdf0e10cSrcweir Out.Log("ReplaceInstance.name = '" & cReplInstName & "'") 89cdf0e10cSrcweir cOldObjName = oOldObject.Name 90cdf0e10cSrcweir Out.Log("OldObject.name = '" & cOldObjName & "'") 91cdf0e10cSrcweir 92cdf0e10cSrcweir oObj.replaceByName(cNameToReplace, oReplaceInstance) 93cdf0e10cSrcweir oNewControl = oObj.getByName(cNameToReplace) 94cdf0e10cSrcweir 95cdf0e10cSrcweir cReplInstName = oReplaceInstance.Name 96cdf0e10cSrcweir Out.Log("ReplaceInstance.name = '" & cReplInstName & "'") 97cdf0e10cSrcweir cNewObjName = oNewControl.Name 98cdf0e10cSrcweir Out.Log("NewObject.name = '" & cNewObjName & "'") 99cdf0e10cSrcweir 100cdf0e10cSrcweir bOK = bOK AND (oReplaceInstance.Name = cNameToReplace) 101cdf0e10cSrcweir end if 102cdf0e10cSrcweir 103cdf0e10cSrcweir Test.MethodTested("replaceByName()", bOK) 104cdf0e10cSrcweir 105cdf0e10cSrcweirExit Sub 106cdf0e10cSrcweirErrHndl: 107cdf0e10cSrcweir Test.Exception() 108cdf0e10cSrcweir bOK = false 109cdf0e10cSrcweir resume next 110cdf0e10cSrcweirEnd Sub 111cdf0e10cSrcweir</script:module> 112