Adding upstream version 4:24.2.0.upstream/4%24.2.0

Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>

1 files changed, 32 insertions, 0 deletions

diff --git a/basic/qa/vba_tests/isnumeric.vb b/basic/qa/vba_tests/isnumeric.vb
new file mode 100644
index 0000000000..ead7e83e14
--- /dev/null
+++ b/basic/qa/vba_tests/isnumeric.vb
@@ -0,0 +1,32 @@
+'
+' This file is part of the LibreOffice project.
+'
+' This Source Code Form is subject to the terms of the Mozilla Public
+' License, v. 2.0. If a copy of the MPL was not distributed with this
+' file, You can obtain one at http://mozilla.org/MPL/2.0/.
+'
+
+Option VBASupport 1
+Option Explicit
+
+Function doUnitTest() As String
+    TestUtil.TestInit
+    verify_testIsNumeric
+    doUnitTest = TestUtil.GetResult()
+End Function
+
+Sub verify_testIsNumeric()
+    On Error GoTo errorHandler
+
+    TestUtil.Assert(IsNumeric(123),     "IsNumeric(123)")
+    TestUtil.Assert(IsNumeric(-123),    "IsNumeric(-123)")
+    TestUtil.Assert(IsNumeric(123.8),   "IsNumeric(123.8)")
+    TestUtil.Assert(Not IsNumeric("a"), "Not IsNumeric(""a"")")
+rem    TestUtil.Assert(IsNumeric(True), "IsNumeric(True)")
+    TestUtil.Assert(IsNumeric("123"),   "IsNumeric(""123"")")
+    TestUtil.Assert(IsNumeric("+123"),  "IsNumeric(""+123"")")
+
+    Exit Sub
+errorHandler:
+    TestUtil.ReportErrorHandler("verify_testIsNumeric", Err, Error$, Erl)
+End Sub