1 <?xml version=
"1.0" encoding=
"UTF-8"?>
4 <!--***********************************************************************
6 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
8 * Copyright 2008 by Sun Microsystems, Inc.
10 * OpenOffice.org - a multi-platform office productivity suite
12 * $RCSfile: 03102700.xhp,v $
15 * This file is part of OpenOffice.org.
17 * OpenOffice.org is free software: you can redistribute it and/or modify
18 * it under the terms of the GNU Lesser General Public License version 3
19 * only, as published by the Free Software Foundation.
21 * OpenOffice.org is distributed in the hope that it will be useful,
22 * but WITHOUT ANY WARRANTY; without even the implied warranty of
23 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
24 * GNU Lesser General Public License version 3 for more details
25 * (a copy is included in the LICENSE file that accompanied this code).
27 * You should have received a copy of the GNU Lesser General Public License
28 * version 3 along with OpenOffice.org. If not, see
29 * <http://www.openoffice.org/license.html>
30 * for a copy of the LGPLv3 License.
32 ************************************************************************-->
34 <helpdocument version=
"1.0">
36 <topic id=
"textsbasicshared03102700xml" indexer=
"include" status=
"PUBLISH">
37 <title id=
"tit" xml-lang=
"en-US">IsNumeric Function [Runtime]
</title>
38 <filename>/text/sbasic/shared/
03102700.xhp
</filename>
41 <created date=
"2003-10-31T00:00:00">Sun Microsystems, Inc.
</created>
42 <lastedited date=
"2004-12-17T10:45:34">converted from old format - fpe
</lastedited>
46 <section id=
"isnumeric">
47 <bookmark xml-lang=
"en-US" branch=
"index" id=
"bm_id3145136"><bookmark_value>IsNumeric function
</bookmark_value>
49 <paragraph role=
"heading" id=
"hd_id3145136" xml-lang=
"en-US" level=
"1" l10n=
"U" oldref=
"1"><link href=
"text/sbasic/shared/03102700.xhp" name=
"IsNumeric Function [Runtime]">IsNumeric Function [Runtime]
</link></paragraph>
50 <paragraph role=
"paragraph" id=
"par_id3149177" xml-lang=
"en-US" l10n=
"U" oldref=
"2">Tests if an expression is a number. If the expression is a
<link href=
"text/sbasic/shared/00000002.xhp#dezimal" name=
"number">number
</link>, the function returns True, otherwise the function returns False.
</paragraph>
52 <paragraph role=
"heading" id=
"hd_id3149415" xml-lang=
"en-US" level=
"2" l10n=
"U" oldref=
"3">Syntax:
</paragraph>
53 <paragraph role=
"paragraph" id=
"par_id3150771" xml-lang=
"en-US" l10n=
"U" oldref=
"4">IsNumeric (Var)
</paragraph>
54 <paragraph role=
"heading" id=
"hd_id3148685" xml-lang=
"en-US" level=
"2" l10n=
"U" oldref=
"5">Return value:
</paragraph>
55 <paragraph role=
"paragraph" id=
"par_id3148944" xml-lang=
"en-US" l10n=
"U" oldref=
"6">Bool
</paragraph>
56 <paragraph role=
"heading" id=
"hd_id3148947" xml-lang=
"en-US" level=
"2" l10n=
"U" oldref=
"7">Parameters:
</paragraph>
57 <paragraph role=
"paragraph" id=
"par_id3154760" xml-lang=
"en-US" l10n=
"U" oldref=
"8">
58 <emph>Var:
</emph> Any expression that you want to test.
</paragraph>
59 <embed href=
"text/sbasic/shared/00000003.xhp#errorcode"/>
60 <embed href=
"text/sbasic/shared/00000003.xhp#err5"/>
61 <paragraph role=
"heading" id=
"hd_id3149656" xml-lang=
"en-US" level=
"2" l10n=
"U" oldref=
"9">Example:
</paragraph>
62 <paragraph role=
"paragraph" id=
"par_id3154367" xml-lang=
"en-US" l10n=
"U" oldref=
"10">Sub ExampleIsNumeric
</paragraph>
63 <paragraph role=
"paragraph" id=
"par_id3156423" xml-lang=
"en-US" l10n=
"U" oldref=
"11">Dim vVar as variant
</paragraph>
64 <paragraph role=
"paragraph" id=
"par_id3154125" xml-lang=
"en-US" l10n=
"U" oldref=
"12">vVar =
"ABC"</paragraph>
65 <paragraph role=
"paragraph" id=
"par_id3147230" xml-lang=
"en-US" l10n=
"CHG" oldref=
"13">Print IsNumeric(vVar) REM Returns False
</paragraph>
66 <paragraph role=
"paragraph" id=
"par_id3156214" xml-lang=
"en-US" l10n=
"U" oldref=
"14">vVar =
"123"</paragraph>
67 <paragraph role=
"paragraph" id=
"par_id3154910" xml-lang=
"en-US" l10n=
"CHG" oldref=
"15">Print IsNumeric(vVar) REM Returns True
</paragraph>
68 <paragraph role=
"paragraph" id=
"par_id3147289" xml-lang=
"en-US" l10n=
"U" oldref=
"16">end sub
</paragraph>