qadevOOo/tests/basic/ifc/sheet/XScenarios/sheet_XScenarios.xba

   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="sheet_XScenarios" script:language="StarBasic">
   4
   5
   6 '*************************************************************************
   7 '
   8 ' DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
   9 '
  10 ' Copyright 2008 by Sun Microsystems, Inc.
  11 '
  12 ' OpenOffice.org - a multi-platform office productivity suite
  13 '
  14 ' $RCSfile: sheet_XScenarios.xba,v $
  15 '
  16 ' $Revision: 1.3 $
  17 '
  18 ' This file is part of OpenOffice.org.
  19 '
  20 ' OpenOffice.org is free software: you can redistribute it and/or modify
  21 ' it under the terms of the GNU Lesser General Public License version 3
  22 ' only, as published by the Free Software Foundation.
  23 '
  24 ' OpenOffice.org is distributed in the hope that it will be useful,
  25 ' but WITHOUT ANY WARRANTY; without even the implied warranty of
  26 ' MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  27 ' GNU Lesser General Public License version 3 for more details
  28 ' (a copy is included in the LICENSE file that accompanied this code).
  29 '
  30 ' You should have received a copy of the GNU Lesser General Public License
  31 ' version 3 along with OpenOffice.org.  If not, see
  32 ' <http://www.openoffice.org/license.html>
  33 ' for a copy of the LGPLv3 License.
  34 '
  35 '*************************************************************************
  36 '*************************************************************************
  37
  38
  39
  40 ' Be sure that all variables are dimensioned:
  41 option explicit
  42
  43
  44
  45 Sub RunTest()
  46
  47 '*************************************************************************
  48 ' INTERFACE:
  49 ' com.sun.star.sheet.XScenarios
  50 '*************************************************************************
  51 On Error Goto ErrHndl
  52     Dim bOK As Boolean
  53     Dim nCount As Integer
  54     Dim aCRA(1) As New com.sun.star.table.CellRangeAddress
  55
  56     aCRA(0).Sheet = 0       : aCRA(1).Sheet = 0
  57     aCRA(0).StartColumn = 3 : aCRA(1).StartColumn = 13
  58     aCRA(0).StartRow = 4    : aCRA(1).StartRow = 14
  59     aCRA(0).EndColumn = 8   : aCRA(1).EndColumn = 18
  60     aCRA(0).EndRow = 9      : aCRA(1).EndRow = 19
  61
  62     Test.StartMethod("addNewByName()")
  63     bOK = true
  64     nCount = oObj.getCount()
  65     Out.Log("Initialy there are " &amp; nCount &amp; " scenarios.")
  66     oObj.addNewByName("NewScenario", aCRA(), "New comment")
  67     Out.Log("After inserting there are " &amp; oObj.getCount() &amp; " scenarios.")
  68     bOK = bOK AND oObj.getCount() = nCount + 1
  69     Test.MethodTested("addNewByName()", bOK)
  70
  71     Test.StartMethod("removeByName()")
  72     bOK = true
  73     oObj.removeByName("NewScenario")
  74     Out.Log("After removing there are " &amp; oObj.getCount() &amp; " scenarios.")
  75     bOK = bOK AND oObj.getCount() = nCount
  76     Test.MethodTested("removeByName()", bOK)
  77
  78 Exit Sub
  79 ErrHndl:
  80     Test.Exception()
  81     bOK = false
  82     resume next
  83 End Sub
  84 </script:module>