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_ScScenariosObj" 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
36cdf0e10cSrcweirSub CreateObj()
37cdf0e10cSrcweir
38cdf0e10cSrcweir'*************************************************************************
39cdf0e10cSrcweir' COMPONENT:
40cdf0e10cSrcweir' sc.ScScenariosObj
41cdf0e10cSrcweir'*************************************************************************
42cdf0e10cSrcweirOn Error Goto ErrHndl
43cdf0e10cSrcweir    Dim bOK As Boolean
44cdf0e10cSrcweir    Dim aCRA(0) As New com.sun.star.table.CellRangeAddress
45cdf0e10cSrcweir    Dim oSheet As Object
46cdf0e10cSrcweir
47cdf0e10cSrcweir    bOK = true
48cdf0e10cSrcweir    oDoc = utils.createDocument("scalc", cObjectName)
49cdf0e10cSrcweir
50cdf0e10cSrcweir    oSheet = oDoc.Sheets(0)
51cdf0e10cSrcweir    oSheet.getCellByPosition(0, 1).Value = 1
52cdf0e10cSrcweir    oSheet.getCellByPosition(3, 2).Value = 0
53cdf0e10cSrcweir    oSheet.getCellByPosition(4, 5).Value = -1
54cdf0e10cSrcweir
55cdf0e10cSrcweir    oObj = oSheet.getScenarios()
56cdf0e10cSrcweir
57cdf0e10cSrcweir    aCRA(0).Sheet = 0
58cdf0e10cSrcweir    aCRA(0).StartColumn = 0
59cdf0e10cSrcweir    aCRA(0).StartRow = 0
60cdf0e10cSrcweir    aCRA(0).EndColumn = 5
61cdf0e10cSrcweir    aCRA(0).EndRow = 5
62cdf0e10cSrcweir
63cdf0e10cSrcweir    oObj.addNewByName("Scenario1", aCRA(), "Comment1")
64cdf0e10cSrcweir    oObj.addNewByName("Scenario2", aCRA(), "Comment2")
65cdf0e10cSrcweir
66cdf0e10cSrcweirExit Sub
67cdf0e10cSrcweirErrHndl:
68cdf0e10cSrcweir    Test.Exception()
69cdf0e10cSrcweirEnd Sub
70cdf0e10cSrcweir</script:module>
71