1<?xml version="1.0" encoding="UTF-8"?>
2<!DOCTYPE script:module PUBLIC "-//OpenOffice.org//DTD OfficeDocument 1.0//EN" "module.dtd">
3<script:module xmlns:script="http://openoffice.org/2000/script" script:name="container_XNameReplace" script:language="StarBasic">
4
5
6'*************************************************************************
7'
8' DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
9'
10' Copyright 2000, 2010 Oracle and/or its affiliates.
11'
12' OpenOffice.org - a multi-platform office productivity suite
13'
14' This file is part of OpenOffice.org.
15'
16' OpenOffice.org is free software: you can redistribute it and/or modify
17' it under the terms of the GNU Lesser General Public License version 3
18' only, as published by the Free Software Foundation.
19'
20' OpenOffice.org is distributed in the hope that it will be useful,
21' but WITHOUT ANY WARRANTY; without even the implied warranty of
22' MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
23' GNU Lesser General Public License version 3 for more details
24' (a copy is included in the LICENSE file that accompanied this code).
25'
26' You should have received a copy of the GNU Lesser General Public License
27' version 3 along with OpenOffice.org.  If not, see
28' <http://www.openoffice.org/license.html>
29' for a copy of the LGPLv3 License.
30'
31'*************************************************************************
32*****
33'*************************************************************************
34
35
36
37' Be sure that all variables are dimensioned:
38option explicit
39
40'*************************************************************************
41' This Interface/Service test depends on the following GLOBAL variables,
42' which must be specified in the object creation:
43
44'      Global cNameToReplace As String 'name of instance to be replased
45'      Global oReplaceInstance As Variant 'instance, that will be inserted
46'      instead old one
47
48'*************************************************************************
49
50Sub RunTest()
51
52'*************************************************************************
53' INTERFACE:
54' com.sun.star.container.XNameReplace
55'*************************************************************************
56On Error Goto ErrHndl
57    Dim bOK As Boolean
58    Dim oOldObject As Object
59    Dim cOldObjName As String
60    Dim oNewControl As Object
61    Dim cNewObjName As String
62    Dim NewAddress As Object
63    Dim InstAddress As Object
64    Dim cReplInstName As String
65
66    Test.StartMethod("replaceByName()")
67    bOK = true
68
69    if (cObjectName = "sc.ScCellRangesObj") then
70        oOldObject = oObj.getByName(cNameToReplace)
71        InstAddress = oReplaceInstance.getRangeAddress
72
73        oObj.replaceByName(cNameToReplace, oReplaceInstance)
74
75        oNewControl = oObj.getByName(cNameToReplace)
76        NewAddress = oNewControl.getRangeAddress
77
78        bOK = bOK AND NewAddress.Sheet = InstAddress.Sheet
79        bOK = bOK AND NewAddress.StartColumn = InstAddress.StartColumn
80        bOK = bOK AND NewAddress.EndColumn = InstAddress.EndColumn
81        bOK = bOK AND NewAddress.StartRow = InstAddress.StartRow
82        bOK = bOK AND NewAddress.EndRow = InstAddress.EndRow
83
84    elseif typename(oReplaceInstance) = "String" then
85        Dim oNewObj as Variant
86        Dim oOldObj as Variant
87        oOldObj = oObj.getByName(cNameToReplace)
88        oObj.replaceByName(cNameToReplace, oReplaceInstance)
89        oNewObj = oObj.getByName(cNameToReplace)
90        bOK = bOK and not PropertyTester.equals(oOldObj, oNewObj)
91    else
92        oOldObject = oObj.getByName(cNameToReplace)
93        cReplInstName = oReplaceInstance.Name
94        Out.Log("ReplaceInstance.name = '" &amp; cReplInstName &amp; "'")
95        cOldObjName = oOldObject.Name
96        Out.Log("OldObject.name = '" &amp; cOldObjName &amp; "'")
97
98        oObj.replaceByName(cNameToReplace, oReplaceInstance)
99        oNewControl = oObj.getByName(cNameToReplace)
100
101        cReplInstName = oReplaceInstance.Name
102        Out.Log("ReplaceInstance.name = '" &amp; cReplInstName &amp; "'")
103        cNewObjName = oNewControl.Name
104        Out.Log("NewObject.name = '" &amp; cNewObjName &amp; "'")
105
106        bOK = bOK AND (oReplaceInstance.Name = cNameToReplace)
107    end if
108
109    Test.MethodTested("replaceByName()", bOK)
110
111Exit Sub
112ErrHndl:
113    Test.Exception()
114    bOK = false
115    resume next
116End Sub
117</script:module>
118