qadevOOo/tests/basic/ifc/sheet/XSheetOperation/sheet_XSheetOperation.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_XSheetOperation" 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_XSheetOperation.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.XSheetOperation
  50 '*************************************************************************
  51 On Error Goto ErrHndl
  52     Dim bOK As Boolean
  53     Dim nCompute As Long
  54
  55     Test.StartMethod("computeFunction()")
  56     bOK = true
  57     nCompute = oObj.computeFunction(com.sun.star.sheet.GeneralFunction.COUNT)
  58     bOK = bOK AND (nCompute &gt;= 0)
  59     Test.MethodTested("computeFunction()", bOK)
  60
  61     Test.StartMethod("clearContents()")
  62     bOK = true
  63     oObj.clearContents(com.sun.star.sheet.CellFlags.VALUE)
  64     nCompute= oObj.computeFunction(com.sun.star.sheet.GeneralFunction.COUNT)
  65     bOK = bOK AND (nCompute = 0)
  66     Test.MethodTested("clearContents()", bOK)
  67
  68 Exit Sub
  69 ErrHndl:
  70     Test.Exception()
  71     bOK = false
  72     resume next
  73 End Sub
  74 </script:module>