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_ScDDELinkObj" 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
37cdf0e10cSrcweir' Requiered for  com.sun.star.container.XNamed
38cdf0e10cSrcweirGlobal cNameToSet As String ' "fixed" if name is fixed
39cdf0e10cSrcweirGlobal DDEItem As String
40cdf0e10cSrcweirGlobal DDETopic As String
41cdf0e10cSrcweirGlobal DDEApplication As String
42cdf0e10cSrcweir
43cdf0e10cSrcweirGlobal oTestDoc As Object
44cdf0e10cSrcweir
45cdf0e10cSrcweir
46cdf0e10cSrcweirSub CreateObj()
47cdf0e10cSrcweir
48cdf0e10cSrcweir'*************************************************************************
49cdf0e10cSrcweir' COMPONENT:
50cdf0e10cSrcweir' sc.ScDDELinkObj
51cdf0e10cSrcweir'*************************************************************************
52cdf0e10cSrcweirOn Error Goto ErrHndl
53cdf0e10cSrcweir    Dim oSheet As Object
54cdf0e10cSrcweir    Dim oF As String
55cdf0e10cSrcweir
56cdf0e10cSrcweir    oDoc = utils.createDocument("scalc", cObjectName)
57cdf0e10cSrcweir    oSheet = oDoc.Sheets(0)
58cdf0e10cSrcweir
59cdf0e10cSrcweir    oTestDoc = utils.loadTestDocument("ScDDELinksObj.sdc")
60cdf0e10cSrcweir
61cdf0e10cSrcweir    DDEItem = "Sheet1.A1"
62cdf0e10cSrcweir
63cdf0e10cSrcweir    ' This construction of 2-way convertion of testdocs location
64cdf0e10cSrcweir    ' should take place here, because there is unnecessary slash at the end of
65cdf0e10cSrcweir    ' cTestDocsDir.
66cdf0e10cSrcweir    DDETopic = utils.URL2Path(utils.Path2URL(cTestDocsDir &amp; "ScDDELinksObj.sdc"))
67cdf0e10cSrcweir
68cdf0e10cSrcweir    DDEApplication = "soffice"
69cdf0e10cSrcweir
70cdf0e10cSrcweir    oF = "=DDE(""" + DDEApplication + """;""" + DDETopic + """;""" + DDEItem + """)"
71cdf0e10cSrcweir
72cdf0e10cSrcweir    oSheet.getCellByPosition(1, 2).Formula = oF
73cdf0e10cSrcweir    oSheet.getCellByPosition(3, 4).Formula = oF
74cdf0e10cSrcweir    oSheet.getCellByPosition(5, 6).Formula = oF
75cdf0e10cSrcweir
76cdf0e10cSrcweir    oObj = oDoc.getPropertyValue("DDELinks").getByIndex(0)
77cdf0e10cSrcweir    cNameToSet = "fixed"
78cdf0e10cSrcweirExit Sub
79cdf0e10cSrcweirErrHndl:
80cdf0e10cSrcweir    Test.Exception()
81cdf0e10cSrcweirEnd Sub
82cdf0e10cSrcweir
83cdf0e10cSrcweirSub DisposeObj()
84cdf0e10cSrcweir    oTestDoc.dispose()
85cdf0e10cSrcweirEnd Sub
86cdf0e10cSrcweir</script:module>
87