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="sc_ScSubTotalDescriptorBase" script:language="StarBasic"> 4 5 6 '************************************************************************* 7 ' 8 ' Licensed to the Apache Software Foundation (ASF) under one 9 ' or more contributor license agreements. See the NOTICE file 10 ' distributed with this work for additional information 11 ' regarding copyright ownership. The ASF licenses this file 12 ' to you under the Apache License, Version 2.0 (the 13 ' "License"); you may not use this file except in compliance 14 ' with the License. You may obtain a copy of the License at 15 ' 16 ' http://www.apache.org/licenses/LICENSE-2.0 17 ' 18 ' Unless required by applicable law or agreed to in writing, 19 ' software distributed under the License is distributed on an 20 ' "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 21 ' KIND, either express or implied. See the License for the 22 ' specific language governing permissions and limitations 23 ' under the License. 24 ' 25 '************************************************************************* 26 27 28 29 30 31 ' Be sure that all variables are dimensioned: 32 option explicit 33 34 35 36 Sub CreateObj() 37 38 '************************************************************************* 39 ' COMPONENT: 40 ' sc.ScSubTotalDescriptorBase 41 '************************************************************************* 42 On Error Goto ErrHndl 43 Dim bOK As Boolean 44 Dim SubTotalDsc As Object 45 46 bOK = true 47 oDoc = utils.createDocument("scalc", cObjectName) 48 49 SubTotalDsc = oDoc.Sheets(0).createSubTotalDescriptor(true) 50 oObj = SubTotalDsc 51 52 Exit Sub 53 ErrHndl: 54 Test.Exception() 55 End Sub 56 </script:module> 57