basic/qa/vba_tests/formatpercent.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_testFormatPercent
  15     doUnitTest = TestUtil.GetResult()
  16 End Function
  17
  18 Sub verify_testFormatPercent()
  19     On Error GoTo errorHandler
  20
  21     TestUtil.AssertEqual(FormatPercent("12.2", 2, vbFalse, vbFalse, vbFalse),                "1220.00%",            "FormatPercent(""12.2"", 2, vbFalse, vbFalse, vbFalse)")
  22     TestUtil.AssertEqual(FormatPercent("-.2", 2, vbTrue, vbFalse, vbFalse),                 "-20.00%",              "FormatPercent(""-.2"", 20, vbTrue, vbFalse, vbFalse)")
  23     TestUtil.AssertEqual(FormatPercent("-0.2", 2, vbFalse, vbFalse, vbFalse),               "-20.00%",              "FormatPercent(""-0.2"", 20, vbFalse, vbFalse, vbFalse)")
  24     TestUtil.AssertEqual(FormatPercent("-0.2", -1, vbFalse, vbTrue, vbFalse),                "(20.00)%",            "FormatPercent(""-0.2"", -1, vbFalse, vbTrue, vbFalse)")
  25     TestUtil.AssertEqual(FormatPercent("-0.2", -1, vbUseDefault, vbTrue, vbFalse),           "(20.00)%",            "FormatPercent(""-0.2"", -1, vbUseDefault, vbTrue, vbFalse)")
  26     TestUtil.AssertEqual(FormatPercent("-12345678", -1, vbUseDefault, vbUseDefault, vbTrue), "-1,234,567,800.00%",  "FormatPercent(""-12345678"", -1, vbUseDefault, vbUseDefault, vbTrue)")
  27
  28     Exit Sub
  29 errorHandler:
  30     TestUtil.ReportErrorHandler("verify_testFormatPercent", Err, Error$, Erl)
  31 End Sub