basic/qa/vba_tests/isnumeric.vb

   1 '
   2 ' This file is part of the LibreOffice project.
   3 '
   4 ' This Source Code Form is subject to the terms of the Mozilla Public
   5 ' License, v. 2.0. If a copy of the MPL was not distributed with this
   6 ' file, You can obtain one at http://mozilla.org/MPL/2.0/.
   7 '
   8
   9 Option VBASupport 1
  10 Option Explicit
  11
  12 Function doUnitTest() As String
  13     TestUtil.TestInit
  14     verify_testIsNumeric
  15     doUnitTest = TestUtil.GetResult()
  16 End Function
  17
  18 Sub verify_testIsNumeric()
  19     On Error GoTo errorHandler
  20
  21     TestUtil.Assert(IsNumeric(123),     "IsNumeric(123)")
  22     TestUtil.Assert(IsNumeric(-123),    "IsNumeric(-123)")
  23     TestUtil.Assert(IsNumeric(123.8),   "IsNumeric(123.8)")
  24     TestUtil.Assert(Not IsNumeric("a"), "Not IsNumeric(""a"")")
  25     TestUtil.Assert(IsNumeric(True), "IsNumeric(True)")
  26     TestUtil.Assert(IsNumeric("123"),   "IsNumeric(""123"")")
  27     TestUtil.Assert(IsNumeric("+123"),  "IsNumeric(""+123"")")
  28
  29     TestUtil.Assert(Not IsNumeric(""), "Not IsNumeric("""")")
  30     TestUtil.Assert(Not IsNumeric(" "), "Not IsNumeric("" "")")
  31     TestUtil.Assert(Not IsNumeric(" + "), "Not IsNumeric("" + "")")
  32     TestUtil.Assert(Not IsNumeric(" - "), "Not IsNumeric("" - "")")
  33
  34     TestUtil.Assert(IsNumeric(" + 0 "), "IsNumeric("" + 0 "")")
  35     TestUtil.Assert(IsNumeric(" - 0 "), "IsNumeric("" - 0 "")")
  36
  37     Exit Sub
  38 errorHandler:
  39     TestUtil.ReportErrorHandler("verify_testIsNumeric", Err, Error$, Erl)
  40 End Sub