qadevOOo/tests/basic/ifc/sheet/XDatabaseRanges/sheet_XDatabaseRanges.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_XDatabaseRanges" 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_XDatabaseRanges.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.XDatabaseRanges
  50 '*************************************************************************
  51 On Error Goto ErrHndl
  52     Dim bOK As Boolean
  53     Dim nCount As Integer
  54     Dim aRange As New com.sun.star.table.CellRangeAddress
  55
  56     Test.StartMethod("addNewByName()")
  57     bOK = true
  58     nCount = oObj.Count
  59     aRange.Sheet = 0
  60     aRange.StartRow = 3
  61     aRange.StartColumn = 4
  62     aRange.EndRow = 10
  63     aRange.EndColumn = 7
  64     oObj.addNewByName(cIfcShortName, aRange)
  65     bOK = bOK AND oObj.Count = nCount + 1
  66     Test.MethodTested("addNewByName()", bOK)
  67
  68     Test.StartMethod("removeByName()")
  69     bOK = true
  70     oObj.removeByName(cIfcShortName)
  71     bOK = bOK AND oObj.Count = nCount
  72     Test.MethodTested("removeByName()", bOK)
  73
  74 Exit Sub
  75 ErrHndl:
  76     Test.Exception()
  77     bOK = false
  78     resume next
  79 End Sub
  80 </script:module>