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="sheet_XScenarios" script:language="StarBasic"> 4cdf0e10cSrcweir 5cdf0e10cSrcweir 6cdf0e10cSrcweir'************************************************************************* 7cdf0e10cSrcweir' 8eebed415SAndrew Rist' Licensed to the Apache Software Foundation (ASF) under one 9eebed415SAndrew Rist' or more contributor license agreements. See the NOTICE file 10eebed415SAndrew Rist' distributed with this work for additional information 11eebed415SAndrew Rist' regarding copyright ownership. The ASF licenses this file 12eebed415SAndrew Rist' to you under the Apache License, Version 2.0 (the 13eebed415SAndrew Rist' "License"); you may not use this file except in compliance 14eebed415SAndrew Rist' with the License. You may obtain a copy of the License at 15cdf0e10cSrcweir' 16eebed415SAndrew Rist' http://www.apache.org/licenses/LICENSE-2.0 17cdf0e10cSrcweir' 18eebed415SAndrew Rist' Unless required by applicable law or agreed to in writing, 19eebed415SAndrew Rist' software distributed under the License is distributed on an 20eebed415SAndrew Rist' "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 21eebed415SAndrew Rist' KIND, either express or implied. See the License for the 22eebed415SAndrew Rist' specific language governing permissions and limitations 23eebed415SAndrew Rist' under the License. 24cdf0e10cSrcweir' 25cdf0e10cSrcweir'************************************************************************* 26eebed415SAndrew Rist 27eebed415SAndrew Rist 28cdf0e10cSrcweir 29cdf0e10cSrcweir 30cdf0e10cSrcweir 31cdf0e10cSrcweir' Be sure that all variables are dimensioned: 32cdf0e10cSrcweiroption explicit 33cdf0e10cSrcweir 34cdf0e10cSrcweir 35cdf0e10cSrcweir 36cdf0e10cSrcweirSub RunTest() 37cdf0e10cSrcweir 38cdf0e10cSrcweir'************************************************************************* 39cdf0e10cSrcweir' INTERFACE: 40cdf0e10cSrcweir' com.sun.star.sheet.XScenarios 41cdf0e10cSrcweir'************************************************************************* 42cdf0e10cSrcweirOn Error Goto ErrHndl 43cdf0e10cSrcweir Dim bOK As Boolean 44cdf0e10cSrcweir Dim nCount As Integer 45cdf0e10cSrcweir Dim aCRA(1) As New com.sun.star.table.CellRangeAddress 46cdf0e10cSrcweir 47cdf0e10cSrcweir aCRA(0).Sheet = 0 : aCRA(1).Sheet = 0 48cdf0e10cSrcweir aCRA(0).StartColumn = 3 : aCRA(1).StartColumn = 13 49cdf0e10cSrcweir aCRA(0).StartRow = 4 : aCRA(1).StartRow = 14 50cdf0e10cSrcweir aCRA(0).EndColumn = 8 : aCRA(1).EndColumn = 18 51cdf0e10cSrcweir aCRA(0).EndRow = 9 : aCRA(1).EndRow = 19 52cdf0e10cSrcweir 53cdf0e10cSrcweir Test.StartMethod("addNewByName()") 54cdf0e10cSrcweir bOK = true 55cdf0e10cSrcweir nCount = oObj.getCount() 56*38f6c756SJohn Bampton Out.Log("Initially there are " & nCount & " scenarios.") 57cdf0e10cSrcweir oObj.addNewByName("NewScenario", aCRA(), "New comment") 58cdf0e10cSrcweir Out.Log("After inserting there are " & oObj.getCount() & " scenarios.") 59cdf0e10cSrcweir bOK = bOK AND oObj.getCount() = nCount + 1 60cdf0e10cSrcweir Test.MethodTested("addNewByName()", bOK) 61cdf0e10cSrcweir 62cdf0e10cSrcweir Test.StartMethod("removeByName()") 63cdf0e10cSrcweir bOK = true 64cdf0e10cSrcweir oObj.removeByName("NewScenario") 65cdf0e10cSrcweir Out.Log("After removing there are " & oObj.getCount() & " scenarios.") 66cdf0e10cSrcweir bOK = bOK AND oObj.getCount() = nCount 67cdf0e10cSrcweir Test.MethodTested("removeByName()", bOK) 68cdf0e10cSrcweir 69cdf0e10cSrcweirExit Sub 70cdf0e10cSrcweirErrHndl: 71cdf0e10cSrcweir Test.Exception() 72cdf0e10cSrcweir bOK = false 73cdf0e10cSrcweir resume next 74cdf0e10cSrcweirEnd Sub 75cdf0e10cSrcweir</script:module> 76