basic/qa/vba_tests/cdbl.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_testCdbl
  15     doUnitTest = TestUtil.GetResult()
  16 End Function
  17
  18 Sub verify_testCdbl()
  19     On Error GoTo errorHandler
  20
  21     TestUtil.AssertEqual(CDbl(0),                 0,               "CDbl(0)")
  22     TestUtil.AssertEqual(CDbl(10.1234567890123), 10.1234567890123, "CDbl(10.1234567890123)")
  23     TestUtil.AssertEqual(CDbl(0.005 * 0.01),      0.00005,         "CDbl(0.005 * 0.01)")
  24     TestUtil.AssertEqual(CDbl("20"),             20,               "CDbl(""20"")")
  25
  26
  27     ' tdf#146672 - skip spaces and tabs at the end of the scanned string
  28     TestUtil.AssertEqual(CDbl("28.8 "), 28.8, "CDbl(""28.8 "")")
  29     TestUtil.AssertEqual(CDbl("28.8     "), 28.8, "CDbl(""28.8  "")")
  30
  31     Exit Sub
  32 errorHandler:
  33     TestUtil.ReportErrorHandler("verify_testCdbl", Err, Error$, Erl)
  34 End Sub