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_ScIndexEnumeration_CellAnnotationsEnumeration" script:language="StarBasic"> 4cdf0e10cSrcweir 5cdf0e10cSrcweir'************************************************************************* 6cdf0e10cSrcweir' 7*5846f787SAndrew Rist' Licensed to the Apache Software Foundation (ASF) under one 8*5846f787SAndrew Rist' or more contributor license agreements. See the NOTICE file 9*5846f787SAndrew Rist' distributed with this work for additional information 10*5846f787SAndrew Rist' regarding copyright ownership. The ASF licenses this file 11*5846f787SAndrew Rist' to you under the Apache License, Version 2.0 (the 12*5846f787SAndrew Rist' "License"); you may not use this file except in compliance 13*5846f787SAndrew Rist' with the License. You may obtain a copy of the License at 14*5846f787SAndrew Rist' 15*5846f787SAndrew Rist' http://www.apache.org/licenses/LICENSE-2.0 16*5846f787SAndrew Rist' 17*5846f787SAndrew Rist' Unless required by applicable law or agreed to in writing, 18*5846f787SAndrew Rist' software distributed under the License is distributed on an 19*5846f787SAndrew Rist' "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 20*5846f787SAndrew Rist' KIND, either express or implied. See the License for the 21*5846f787SAndrew Rist' specific language governing permissions and limitations 22*5846f787SAndrew Rist' under the License. 23cdf0e10cSrcweir' 24cdf0e10cSrcweir'************************************************************************* 25cdf0e10cSrcweir 26cdf0e10cSrcweir 27cdf0e10cSrcweir 28*5846f787SAndrew Rist 29*5846f787SAndrew Rist 30cdf0e10cSrcweir' Be sure that all variables are dimensioned: 31cdf0e10cSrcweiroption explicit 32cdf0e10cSrcweir 33cdf0e10cSrcweir 34cdf0e10cSrcweir' REQUIRED VARIABLES for interface/service tests: 35cdf0e10cSrcweir 36cdf0e10cSrcweir 37cdf0e10cSrcweirSub CreateObj() 38cdf0e10cSrcweir 39cdf0e10cSrcweir'************************************************************************* 40cdf0e10cSrcweir' COMPONENT: 41cdf0e10cSrcweir' sc.ScIndexEnumeration_CellAnnotationsEnumeration 42cdf0e10cSrcweir'************************************************************************* 43cdf0e10cSrcweirOn Error Goto ErrHndl 44cdf0e10cSrcweir 45cdf0e10cSrcweir Dim oSheets as Object, oSheet as Object 46cdf0e10cSrcweir Dim oAnnotations as Object 47cdf0e10cSrcweir Dim oCell1 as Object, oCell2 as Object 48cdf0e10cSrcweir Dim oAnno1 as Object, oAnno2 As Object 49cdf0e10cSrcweir 50cdf0e10cSrcweir oDoc = utils.createDocument("scalc", cObjectName) 51cdf0e10cSrcweir 52cdf0e10cSrcweir ' get a sheet 53cdf0e10cSrcweir oSheets = oDoc.getSheets() 54cdf0e10cSrcweir oSheet = oSheets.getByIndex(0) 55cdf0e10cSrcweir 56cdf0e10cSrcweir ' filling cells with values... 57cdf0e10cSrcweir oSheet.getCellByPosition(5, 5).setValue(15) 58cdf0e10cSrcweir oSheet.getCellByPosition(1, 4).setValue(10) 59cdf0e10cSrcweir oSheet.getCellByPosition(2, 0).setValue(-5.15) 60cdf0e10cSrcweir 61cdf0e10cSrcweir Out.Log("Creating two annotations...") 62cdf0e10cSrcweir 63cdf0e10cSrcweir oCell1 = oSheet.getCellByPosition(3, 5) 64cdf0e10cSrcweir oAnno1 = oCell1.Annotation 65cdf0e10cSrcweir oAnno1.setString("ScAnnotationsObj Anno 1") 66cdf0e10cSrcweir 67cdf0e10cSrcweir oCell2 = oSheet.getCellByPosition(3, 6) 68cdf0e10cSrcweir oAnno2 = oCell2.Annotation 69cdf0e10cSrcweir oAnno2.setString("ScAnnotationsObj Anno 2") 70cdf0e10cSrcweir 71cdf0e10cSrcweir ' get annotations 72cdf0e10cSrcweir oAnnotations = oSheet.getAnnotations() 73cdf0e10cSrcweir 74cdf0e10cSrcweir oObj = oAnnotations.createEnumeration() 75cdf0e10cSrcweir 76cdf0e10cSrcweirExit Sub 77cdf0e10cSrcweirErrHndl: 78cdf0e10cSrcweir Test.Exception() 79cdf0e10cSrcweirEnd Sub 80cdf0e10cSrcweir</script:module> 81