1 *b1cdbd2cSJim Jagielski<?xml version="1.0" encoding="UTF-8"?>
2 *b1cdbd2cSJim Jagielski<!DOCTYPE script:module PUBLIC "-//OpenOffice.org//DTD OfficeDocument 1.0//EN" "module.dtd">
3 *b1cdbd2cSJim Jagielski<script:module xmlns:script="http://openoffice.org/2000/script" script:name="sc_ScScenariosObj" script:language="StarBasic">
4 *b1cdbd2cSJim Jagielski
5 *b1cdbd2cSJim Jagielski
6 *b1cdbd2cSJim Jagielski'*************************************************************************
7 *b1cdbd2cSJim Jagielski'
8 *b1cdbd2cSJim Jagielski'  Licensed to the Apache Software Foundation (ASF) under one
9 *b1cdbd2cSJim Jagielski'  or more contributor license agreements.  See the NOTICE file
10 *b1cdbd2cSJim Jagielski'  distributed with this work for additional information
11 *b1cdbd2cSJim Jagielski'  regarding copyright ownership.  The ASF licenses this file
12 *b1cdbd2cSJim Jagielski'  to you under the Apache License, Version 2.0 (the
13 *b1cdbd2cSJim Jagielski'  "License"); you may not use this file except in compliance
14 *b1cdbd2cSJim Jagielski'  with the License.  You may obtain a copy of the License at
15 *b1cdbd2cSJim Jagielski'
16 *b1cdbd2cSJim Jagielski'    http://www.apache.org/licenses/LICENSE-2.0
17 *b1cdbd2cSJim Jagielski'
18 *b1cdbd2cSJim Jagielski'  Unless required by applicable law or agreed to in writing,
19 *b1cdbd2cSJim Jagielski'  software distributed under the License is distributed on an
20 *b1cdbd2cSJim Jagielski'  "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
21 *b1cdbd2cSJim Jagielski'  KIND, either express or implied.  See the License for the
22 *b1cdbd2cSJim Jagielski'  specific language governing permissions and limitations
23 *b1cdbd2cSJim Jagielski'  under the License.
24 *b1cdbd2cSJim Jagielski'
25 *b1cdbd2cSJim Jagielski'*************************************************************************
26 *b1cdbd2cSJim Jagielski
27 *b1cdbd2cSJim Jagielski
28 *b1cdbd2cSJim Jagielski
29 *b1cdbd2cSJim Jagielski
30 *b1cdbd2cSJim Jagielski
31 *b1cdbd2cSJim Jagielski' Be sure that all variables are dimensioned:
32 *b1cdbd2cSJim Jagielskioption explicit
33 *b1cdbd2cSJim Jagielski
34 *b1cdbd2cSJim Jagielski
35 *b1cdbd2cSJim Jagielski
36 *b1cdbd2cSJim JagielskiSub CreateObj()
37 *b1cdbd2cSJim Jagielski
38 *b1cdbd2cSJim Jagielski'*************************************************************************
39 *b1cdbd2cSJim Jagielski' COMPONENT:
40 *b1cdbd2cSJim Jagielski' sc.ScScenariosObj
41 *b1cdbd2cSJim Jagielski'*************************************************************************
42 *b1cdbd2cSJim JagielskiOn Error Goto ErrHndl
43 *b1cdbd2cSJim Jagielski    Dim bOK As Boolean
44 *b1cdbd2cSJim Jagielski    Dim aCRA(0) As New com.sun.star.table.CellRangeAddress
45 *b1cdbd2cSJim Jagielski    Dim oSheet As Object
46 *b1cdbd2cSJim Jagielski
47 *b1cdbd2cSJim Jagielski    bOK = true
48 *b1cdbd2cSJim Jagielski    oDoc = utils.createDocument("scalc", cObjectName)
49 *b1cdbd2cSJim Jagielski
50 *b1cdbd2cSJim Jagielski    oSheet = oDoc.Sheets(0)
51 *b1cdbd2cSJim Jagielski    oSheet.getCellByPosition(0, 1).Value = 1
52 *b1cdbd2cSJim Jagielski    oSheet.getCellByPosition(3, 2).Value = 0
53 *b1cdbd2cSJim Jagielski    oSheet.getCellByPosition(4, 5).Value = -1
54 *b1cdbd2cSJim Jagielski
55 *b1cdbd2cSJim Jagielski    oObj = oSheet.getScenarios()
56 *b1cdbd2cSJim Jagielski
57 *b1cdbd2cSJim Jagielski    aCRA(0).Sheet = 0
58 *b1cdbd2cSJim Jagielski    aCRA(0).StartColumn = 0
59 *b1cdbd2cSJim Jagielski    aCRA(0).StartRow = 0
60 *b1cdbd2cSJim Jagielski    aCRA(0).EndColumn = 5
61 *b1cdbd2cSJim Jagielski    aCRA(0).EndRow = 5
62 *b1cdbd2cSJim Jagielski
63 *b1cdbd2cSJim Jagielski    oObj.addNewByName("Scenario1", aCRA(), "Comment1")
64 *b1cdbd2cSJim Jagielski    oObj.addNewByName("Scenario2", aCRA(), "Comment2")
65 *b1cdbd2cSJim Jagielski
66 *b1cdbd2cSJim JagielskiExit Sub
67 *b1cdbd2cSJim JagielskiErrHndl:
68 *b1cdbd2cSJim Jagielski    Test.Exception()
69 *b1cdbd2cSJim JagielskiEnd Sub
70 *b1cdbd2cSJim Jagielski</script:module>
71