diff options
| author | Rüdiger Timm <rt@openoffice.org> | 2004-11-26 14:13:22 +0000 |
|---|---|---|
| committer | Rüdiger Timm <rt@openoffice.org> | 2004-11-26 14:13:22 +0000 |
| commit | 61f776502b8f75b00f3c6c2d000a28e6d2415608 (patch) | |
| tree | 22b2da33adc7cd098f02bacbae9144c797a7aaeb /helpcontent2/source/text | |
| parent | de1d2458e16766976495fc8138fd5ea75a60ae72 (diff) | |
INTEGRATION: CWS helpcontentbeta (1.1.2); FILE MERGED
2004/09/16 11:45:34 fpe 1.1.2.1: Regular Update
Diffstat (limited to 'helpcontent2/source/text')
| -rw-r--r-- | helpcontent2/source/text/sbasic/shared/03090412.xhp | 103 | ||||
| -rwxr-xr-x | helpcontent2/source/text/sbasic/shared/03100100.xhp | 68 | ||||
| -rwxr-xr-x | helpcontent2/source/text/sbasic/shared/03100300.xhp | 51 | ||||
| -rwxr-xr-x | helpcontent2/source/text/sbasic/shared/03100400.xhp | 51 | ||||
| -rwxr-xr-x | helpcontent2/source/text/sbasic/shared/03100500.xhp | 53 | ||||
| -rwxr-xr-x | helpcontent2/source/text/sbasic/shared/03100600.xhp | 53 |
6 files changed, 200 insertions, 179 deletions
diff --git a/helpcontent2/source/text/sbasic/shared/03090412.xhp b/helpcontent2/source/text/sbasic/shared/03090412.xhp index 8f2552d329..f5315fb499 100644 --- a/helpcontent2/source/text/sbasic/shared/03090412.xhp +++ b/helpcontent2/source/text/sbasic/shared/03090412.xhp @@ -53,63 +53,68 @@ * * ************************************************************************--> + <helpdocument version="1.0"> <meta> <topic id="textsbasicshared03090412xml" indexer="include" status="PUBLISH"> -<title xml-lang="en-US" id="tit">Exit Statement [Runtime]</title> +<title id="tit" xml-lang="en-US">Exit Statement [Runtime]</title> <filename>/text/sbasic/shared/03090412.xhp</filename> </topic> <history> <created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> -<lastedited date="2003-10-31T00:00:00">converted from old format - fpe</lastedited> +<lastedited date="2004-08-24T11:52:47">converted from old format - fpe</lastedited> </history> </meta> <body> - - - <section id="exit"> - <bookmark xml-lang="en-US" branch="index" id="bm_id3152924"><bookmark_value>Exit;statement</bookmark_value></bookmark><paragraph id="hd_id3152924" role="heading" level="1" oldref="1" l10n="U" xml-lang="en-US"><link href="text/sbasic/shared/03090412.xhp" name="Exit Statement [Runtime]">Exit Statement [Runtime]</link></paragraph> - <paragraph xml-lang="en-US" oldref="2" role="paragraph" id="par_id3153394" l10n="U">Exits a <emph>Do...Loop</emph>, <emph>For...Next</emph>, a function, or a subroutine.</paragraph> - </section> - <paragraph role="heading" level="2" id="hd_id3149763" l10n="U" xml-lang="en-US" oldref="3">Syntax:</paragraph> - <paragraph role="paragraph" id="par_id3159157" l10n="U" xml-lang="en-US" oldref="4">see Parameters</paragraph> - <paragraph role="heading" level="2" id="hd_id3148943" l10n="U" xml-lang="en-US" oldref="5">Parameters:</paragraph> - <paragraph l10n="U" role="paragraph" id="par_id3154760" xml-lang="en-US" oldref="6"><emph>Exit Do</emph></paragraph> - <paragraph xml-lang="en-US" oldref="7" role="paragraph" id="par_id3147559" l10n="U">Only valid within a <emph>Do...Loop</emph> statement to exit the loop. Program execution continues with the statement that follows the Loop statement. If <emph>Do...Loop</emph> statements are nested, the control is transferred to the loop in the next higher level.</paragraph> - <paragraph l10n="U" role="paragraph" id="par_id3150398" xml-lang="en-US" oldref="8"><emph>Exit For</emph></paragraph> - <paragraph xml-lang="en-US" oldref="9" role="paragraph" id="par_id3148797" l10n="U">Only valid within a <emph>For...Next</emph> loop to exit the loop. Program execution continues with the first statement that follows the <emph>Next</emph> statement. In nested statements, the control is transferred to the loop in the next higher level.</paragraph> - <paragraph l10n="U" role="paragraph" id="par_id3147229" xml-lang="en-US" oldref="10"><emph>Exit Function</emph></paragraph> - <paragraph xml-lang="en-US" oldref="11" role="paragraph" id="par_id3154685" l10n="U">Exits the <emph>Function</emph> procedure immediately. Program execution continues with the statement that follows the <emph>Function</emph> call.</paragraph> - <paragraph l10n="U" role="paragraph" id="par_id3155132" xml-lang="en-US" oldref="12"><emph>Exit Sub</emph></paragraph> - <paragraph xml-lang="en-US" role="paragraph" id="par_id3149561" l10n="U" oldref="13">Exits the subroutine immediately. Program execution continues with the statement that follows the <emph>Sub</emph> call.</paragraph> - <paragraph role="note" id="par_id3153143" l10n="U" xml-lang="en-US" oldref="14">The Exit statement does not define the end of a structure, and must not be confused with the End statement.</paragraph> - <paragraph role="heading" level="2" id="hd_id3147348" l10n="U" xml-lang="en-US" oldref="15">Example:</paragraph> - <paragraph role="paragraph" id="par_id3151113" l10n="U" xml-lang="en-US" oldref="16">Sub ExampleExit</paragraph> - <paragraph role="paragraph" id="par_id3156283" l10n="U" xml-lang="en-US" oldref="17">Dim sReturn As String</paragraph> - <paragraph role="paragraph" id="par_id3147125" l10n="U" xml-lang="en-US" oldref="18">Dim sListArray(10) as String</paragraph> - <paragraph role="paragraph" id="par_id3151073" l10n="U" xml-lang="en-US" oldref="19">Dim siStep as Single</paragraph> - <paragraph role="paragraph" id="par_id3153158" l10n="U" xml-lang="en-US" oldref="20">For siStep = 0 to 10 REM Fill array with test data</paragraph> - <paragraph role="paragraph" id="par_id3148457" l10n="U" xml-lang="en-US" oldref="21">sListArray(siStep) = chr(siStep + 65)</paragraph> - <paragraph role="paragraph" id="par_id3154492" l10n="U" xml-lang="en-US" oldref="22">msgbox sListArray(siStep)</paragraph> - <paragraph role="paragraph" id="par_id3154791" l10n="U" xml-lang="en-US" oldref="23">next siStep</paragraph> - <paragraph role="paragraph" id="par_id3153510" l10n="U" xml-lang="en-US" oldref="24">sReturn = LinSearch(sListArray(), "B")</paragraph> - <paragraph role="paragraph" id="par_id3154513" l10n="U" xml-lang="en-US" oldref="25">Print sReturn</paragraph> - <paragraph role="paragraph" id="par_id3149121" l10n="U" xml-lang="en-US" oldref="26">end sub</paragraph> - - - <paragraph role="paragraph" id="par_id3152962" l10n="U" xml-lang="en-US" oldref="29">Function LinSearch( sList(), sItem As String ) as integer</paragraph> - <paragraph role="paragraph" id="par_id3154755" l10n="U" xml-lang="en-US" oldref="30">dim iCount as Integer</paragraph> - <paragraph role="paragraph" id="par_id3153764" l10n="U" xml-lang="en-US" oldref="31">REM LinSearch searches a TextArray:sList() for a TextEntry:</paragraph> - <paragraph role="paragraph" id="par_id3148995" l10n="U" xml-lang="en-US" oldref="32">REM Returns the index of the entry or 0 ( Null)</paragraph> - <paragraph role="paragraph" id="par_id3156057" l10n="U" xml-lang="en-US" oldref="33">for iCount=1 to Ubound( sList() )</paragraph> - <paragraph role="paragraph" id="par_id3159266" l10n="U" xml-lang="en-US" oldref="34">if sList( iCount ) = sItem then</paragraph> - <paragraph role="paragraph" id="par_id3149567" l10n="U" xml-lang="en-US" oldref="35">Exit for REM sItem found</paragraph> - <paragraph role="paragraph" id="par_id3147343" l10n="U" xml-lang="en-US" oldref="36">end if</paragraph> - <paragraph role="paragraph" id="par_id3155174" l10n="U" xml-lang="en-US" oldref="37">next iCount</paragraph> - <paragraph role="paragraph" id="par_id3146313" l10n="U" xml-lang="en-US" oldref="38">if iCount = Ubound( sList() ) then iCount = 0</paragraph> - <paragraph role="paragraph" id="par_id3166448" l10n="U" xml-lang="en-US" oldref="39">LinSearch = iCount</paragraph> - <paragraph role="paragraph" id="par_id3146916" l10n="U" xml-lang="en-US" oldref="40">end function</paragraph> - - - </body> +<section id="exit"> +<bookmark xml-lang="en-US" branch="index" id="bm_id3152924"><bookmark_value>Exit statement</bookmark_value> +</bookmark> +<paragraph role="heading" id="hd_id3152924" xml-lang="en-US" level="1" l10n="U" oldref="1"><link href="text/sbasic/shared/03090412.xhp" name="Exit Statement [Runtime]">Exit Statement [Runtime]</link></paragraph> +<paragraph role="paragraph" id="par_id3153394" xml-lang="en-US" l10n="U" oldref="2">Exits a <emph>Do...Loop</emph>, <emph>For...Next</emph>, a function, or a subroutine.</paragraph> +</section> +<paragraph role="heading" id="hd_id3149763" xml-lang="en-US" level="2" l10n="U" oldref="3">Syntax:</paragraph> +<paragraph role="paragraph" id="par_id3159157" xml-lang="en-US" l10n="U" oldref="4">see Parameters</paragraph> +<paragraph role="heading" id="hd_id3148943" xml-lang="en-US" level="2" l10n="U" oldref="5">Parameters:</paragraph> +<paragraph role="paragraph" id="par_id3154760" xml-lang="en-US" l10n="U" oldref="6"> +<emph>Exit Do</emph> +</paragraph> +<paragraph role="paragraph" id="par_id3147559" xml-lang="en-US" l10n="U" oldref="7">Only valid within a <emph>Do...Loop</emph> statement to exit the loop. Program execution continues with the statement that follows the Loop statement. If <emph>Do...Loop</emph> statements are nested, the control is transferred to the loop in the next higher level.</paragraph> +<paragraph role="paragraph" id="par_id3150398" xml-lang="en-US" l10n="U" oldref="8"> +<emph>Exit For</emph> +</paragraph> +<paragraph role="paragraph" id="par_id3148797" xml-lang="en-US" l10n="U" oldref="9">Only valid within a <emph>For...Next</emph> loop to exit the loop. Program execution continues with the first statement that follows the <emph>Next</emph> statement. In nested statements, the control is transferred to the loop in the next higher level.</paragraph> +<paragraph role="paragraph" id="par_id3147229" xml-lang="en-US" l10n="U" oldref="10"> +<emph>Exit Function</emph> +</paragraph> +<paragraph role="paragraph" id="par_id3154685" xml-lang="en-US" l10n="U" oldref="11">Exits the <emph>Function</emph> procedure immediately. Program execution continues with the statement that follows the <emph>Function</emph> call.</paragraph> +<paragraph role="paragraph" id="par_id3155132" xml-lang="en-US" l10n="U" oldref="12"> +<emph>Exit Sub</emph> +</paragraph> +<paragraph role="paragraph" id="par_id3149561" xml-lang="en-US" l10n="U" oldref="13">Exits the subroutine immediately. Program execution continues with the statement that follows the <emph>Sub</emph> call.</paragraph> +<paragraph role="note" id="par_id3153143" xml-lang="en-US" l10n="U" oldref="14">The Exit statement does not define the end of a structure, and must not be confused with the End statement.</paragraph> +<paragraph role="heading" id="hd_id3147348" xml-lang="en-US" level="2" l10n="U" oldref="15">Example:</paragraph> +<paragraph role="paragraph" id="par_id3151113" xml-lang="en-US" l10n="U" oldref="16">Sub ExampleExit</paragraph> +<paragraph role="paragraph" id="par_id3156283" xml-lang="en-US" l10n="U" oldref="17">Dim sReturn As String</paragraph> +<paragraph role="paragraph" id="par_id3147125" xml-lang="en-US" l10n="U" oldref="18">Dim sListArray(10) as String</paragraph> +<paragraph role="paragraph" id="par_id3151073" xml-lang="en-US" l10n="U" oldref="19">Dim siStep as Single</paragraph> +<paragraph role="paragraph" id="par_id3153158" xml-lang="en-US" l10n="U" oldref="20">For siStep = 0 to 10 REM Fill array with test data</paragraph> +<paragraph role="paragraph" id="par_id3148457" xml-lang="en-US" l10n="U" oldref="21">sListArray(siStep) = chr(siStep + 65)</paragraph> +<paragraph role="paragraph" id="par_id3154492" xml-lang="en-US" l10n="U" oldref="22">msgbox sListArray(siStep)</paragraph> +<paragraph role="paragraph" id="par_id3154791" xml-lang="en-US" l10n="U" oldref="23">next siStep</paragraph> +<paragraph role="paragraph" id="par_id3153510" xml-lang="en-US" l10n="U" oldref="24">sReturn = LinSearch(sListArray(), "B")</paragraph> +<paragraph role="paragraph" id="par_id3154513" xml-lang="en-US" l10n="U" oldref="25">Print sReturn</paragraph> +<paragraph role="paragraph" id="par_id3149121" xml-lang="en-US" l10n="U" oldref="26">end sub</paragraph> +<paragraph role="paragraph" id="par_id3152962" xml-lang="en-US" l10n="U" oldref="29">Function LinSearch( sList(), sItem As String ) as integer</paragraph> +<paragraph role="paragraph" id="par_id3154755" xml-lang="en-US" l10n="U" oldref="30">dim iCount as Integer</paragraph> +<paragraph role="paragraph" id="par_id3153764" xml-lang="en-US" l10n="U" oldref="31">REM LinSearch searches a TextArray:sList() for a TextEntry:</paragraph> +<paragraph role="paragraph" id="par_id3148995" xml-lang="en-US" l10n="U" oldref="32">REM Returns the index of the entry or 0 ( Null)</paragraph> +<paragraph role="paragraph" id="par_id3156057" xml-lang="en-US" l10n="U" oldref="33">for iCount=1 to Ubound( sList() )</paragraph> +<paragraph role="paragraph" id="par_id3159266" xml-lang="en-US" l10n="U" oldref="34">if sList( iCount ) = sItem then</paragraph> +<paragraph role="paragraph" id="par_id3149567" xml-lang="en-US" l10n="U" oldref="35">Exit for REM sItem found</paragraph> +<paragraph role="paragraph" id="par_id3147343" xml-lang="en-US" l10n="U" oldref="36">end if</paragraph> +<paragraph role="paragraph" id="par_id3155174" xml-lang="en-US" l10n="U" oldref="37">next iCount</paragraph> +<paragraph role="paragraph" id="par_id3146313" xml-lang="en-US" l10n="U" oldref="38">if iCount = Ubound( sList() ) then iCount = 0</paragraph> +<paragraph role="paragraph" id="par_id3166448" xml-lang="en-US" l10n="U" oldref="39">LinSearch = iCount</paragraph> +<paragraph role="paragraph" id="par_id3146916" xml-lang="en-US" l10n="U" oldref="40">end function</paragraph> +</body> </helpdocument> diff --git a/helpcontent2/source/text/sbasic/shared/03100100.xhp b/helpcontent2/source/text/sbasic/shared/03100100.xhp index 940f8580f7..058a6d69b9 100755 --- a/helpcontent2/source/text/sbasic/shared/03100100.xhp +++ b/helpcontent2/source/text/sbasic/shared/03100100.xhp @@ -52,45 +52,49 @@ * Contributor(s): _______________________________________ * * - ************************************************************************--><helpdocument version="1.0"> + ************************************************************************--> + +<helpdocument version="1.0"> <meta> <topic id="textsbasicshared03100100xml" indexer="include" status="PUBLISH"> -<title xml-lang="en-US" id="tit">CBool Function [Runtime]</title> +<title id="tit" xml-lang="en-US">CBool Function [Runtime]</title> <filename>/text/sbasic/shared/03100100.xhp</filename> </topic> <history> <created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> -<lastedited date="2003-10-31T00:00:00">converted from old format - fpe</lastedited> +<lastedited date="2004-08-24T09:51:33">converted from old format - fpe</lastedited> </history> </meta> <body> - - - <section id="cbool"> - <bookmark xml-lang="en-US" branch="index" id="bm_id3150616"><bookmark_value>CBool;function</bookmark_value></bookmark><paragraph id="hd_id3150616" role="heading" level="1" oldref="1" l10n="U" xml-lang="en-US"><link href="text/sbasic/shared/03100100.xhp" name="CBool Function [Runtime]">CBool Function [Runtime]</link></paragraph> - <paragraph role="paragraph" id="par_id3145136" l10n="U" xml-lang="en-US" oldref="2">Converts a string comparison or numeric comparison to a Boolean expression, or converts a single numeric expression to a Boolean expression.</paragraph> - </section> - <paragraph role="heading" level="2" id="hd_id3153345" l10n="U" xml-lang="en-US" oldref="3">Syntax:</paragraph> - <paragraph role="paragraph" id="par_id3149514" l10n="U" xml-lang="en-US" oldref="4">CBool (Expression1 {= | <> | < | > | <= | >=} Expression2) or CBool (Number)</paragraph> - <paragraph role="heading" level="2" id="hd_id3156152" l10n="U" xml-lang="en-US" oldref="5">Return value:</paragraph> - <paragraph role="paragraph" id="par_id3155419" l10n="U" xml-lang="en-US" oldref="6">Bool</paragraph> - <paragraph role="heading" level="2" id="hd_id3147530" l10n="U" xml-lang="en-US" oldref="7">Parameters:</paragraph> - <paragraph l10n="U" xml-lang="en-US" oldref="8" role="paragraph" id="par_id3156344"><emph>Expression1, Expression2:</emph> Any string or numeric expressions that you want to compare. If the expressions match, the <emph>CBool</emph> function returns <emph>True</emph>, otherwise <emph>False</emph> is returned.</paragraph> - <paragraph l10n="U" xml-lang="en-US" oldref="9" role="paragraph" id="par_id3149655"><emph>Number:</emph> Any numeric expression that you want to convert. If the expression equals 0, <emph>False</emph> is returned, otherwise <emph>True</emph> is returned.</paragraph> - <paragraph xml-lang="en-US" oldref="10" role="paragraph" id="par_id3145171" l10n="U">The following example uses the <emph>CBool</emph> function to evaluate the value that is returned by the <emph>Instr</emph> function. The function checks if the word "and" is found in the sentence that was entered by the user.</paragraph> - <embed href="text/sbasic/shared/00000003.xhp#errorcode"/> - <embed href="text/sbasic/shared/00000003.xhp#err5"/> - <paragraph role="heading" level="2" id="hd_id3156212" l10n="U" xml-lang="en-US" oldref="11">Example:</paragraph> - <paragraph role="paragraph" id="par_id3147288" l10n="U" xml-lang="en-US" oldref="12">Sub ExampleCBool</paragraph> - <paragraph role="paragraph" id="par_id3153768" l10n="U" xml-lang="en-US" oldref="13">Dim sText As String</paragraph> - <paragraph role="paragraph" id="par_id3155132" l10n="U" xml-lang="en-US" oldref="14">sText = InputBox("Please enter a short sentence:")</paragraph> - <paragraph role="paragraph" id="par_id3155855" l10n="U" xml-lang="en-US" oldref="15">REM Proof if the word »and« appears in the sentence.</paragraph> - <paragraph role="paragraph" id="par_id3146984" l10n="U" xml-lang="en-US" oldref="16">REM Instead of the command line</paragraph> - <paragraph role="paragraph" id="par_id3148576" l10n="U" xml-lang="en-US" oldref="17">REM If Instr(Input, "and")<>0 Then...</paragraph> - <paragraph role="paragraph" id="par_id3154014" l10n="U" xml-lang="en-US" oldref="18">REM the CBool function is applied as follows:</paragraph> - <paragraph role="paragraph" id="par_id3155413" l10n="U" xml-lang="en-US" oldref="19">If CBool(Instr(sText, "and")) Then</paragraph> - <paragraph role="paragraph" id="par_id3152940" l10n="U" xml-lang="en-US" oldref="20">MsgBox "The word »and« appears in the sentence you entered!"</paragraph> - <paragraph role="paragraph" id="par_id3153954" l10n="U" xml-lang="en-US" oldref="21">EndIf</paragraph> - <paragraph role="paragraph" id="par_id3152886" l10n="U" xml-lang="en-US" oldref="22">End Sub</paragraph> - </body> +<section id="cbool"> +<bookmark xml-lang="en-US" branch="index" id="bm_id3150616"><bookmark_value>CBool function</bookmark_value> +</bookmark> +<paragraph role="heading" id="hd_id3150616" xml-lang="en-US" level="1" l10n="U" oldref="1"><link href="text/sbasic/shared/03100100.xhp" name="CBool Function [Runtime]">CBool Function [Runtime]</link></paragraph> +<paragraph role="paragraph" id="par_id3145136" xml-lang="en-US" l10n="U" oldref="2">Converts a string comparison or numeric comparison to a Boolean expression, or converts a single numeric expression to a Boolean expression.</paragraph> +</section> +<paragraph role="heading" id="hd_id3153345" xml-lang="en-US" level="2" l10n="U" oldref="3">Syntax:</paragraph> +<paragraph role="paragraph" id="par_id3149514" xml-lang="en-US" l10n="U" oldref="4">CBool (Expression1 {= | <> | < | > | <= | >=} Expression2) or CBool (Number)</paragraph> +<paragraph role="heading" id="hd_id3156152" xml-lang="en-US" level="2" l10n="U" oldref="5">Return value:</paragraph> +<paragraph role="paragraph" id="par_id3155419" xml-lang="en-US" l10n="U" oldref="6">Bool</paragraph> +<paragraph role="heading" id="hd_id3147530" xml-lang="en-US" level="2" l10n="U" oldref="7">Parameters:</paragraph> +<paragraph role="paragraph" id="par_id3156344" xml-lang="en-US" l10n="U" oldref="8"> +<emph>Expression1, Expression2:</emph> Any string or numeric expressions that you want to compare. If the expressions match, the <emph>CBool</emph> function returns <emph>True</emph>, otherwise <emph>False</emph> is returned.</paragraph> +<paragraph role="paragraph" id="par_id3149655" xml-lang="en-US" l10n="U" oldref="9"> +<emph>Number:</emph> Any numeric expression that you want to convert. If the expression equals 0, <emph>False</emph> is returned, otherwise <emph>True</emph> is returned.</paragraph> +<paragraph role="paragraph" id="par_id3145171" xml-lang="en-US" l10n="U" oldref="10">The following example uses the <emph>CBool</emph> function to evaluate the value that is returned by the <emph>Instr</emph> function. The function checks if the word "and" is found in the sentence that was entered by the user.</paragraph> +<embed href="text/sbasic/shared/00000003.xhp#errorcode"/> +<embed href="text/sbasic/shared/00000003.xhp#err5"/> +<paragraph role="heading" id="hd_id3156212" xml-lang="en-US" level="2" l10n="U" oldref="11">Example:</paragraph> +<paragraph role="paragraph" id="par_id3147288" xml-lang="en-US" l10n="U" oldref="12">Sub ExampleCBool</paragraph> +<paragraph role="paragraph" id="par_id3153768" xml-lang="en-US" l10n="U" oldref="13">Dim sText As String</paragraph> +<paragraph role="paragraph" id="par_id3155132" xml-lang="en-US" l10n="U" oldref="14">sText = InputBox("Please enter a short sentence:")</paragraph> +<paragraph role="paragraph" id="par_id3155855" xml-lang="en-US" l10n="U" oldref="15">REM Proof if the word »and« appears in the sentence.</paragraph> +<paragraph role="paragraph" id="par_id3146984" xml-lang="en-US" l10n="U" oldref="16">REM Instead of the command line</paragraph> +<paragraph role="paragraph" id="par_id3148576" xml-lang="en-US" l10n="U" oldref="17">REM If Instr(Input, "and")<>0 Then...</paragraph> +<paragraph role="paragraph" id="par_id3154014" xml-lang="en-US" l10n="U" oldref="18">REM the CBool function is applied as follows:</paragraph> +<paragraph role="paragraph" id="par_id3155413" xml-lang="en-US" l10n="U" oldref="19">If CBool(Instr(sText, "and")) Then</paragraph> +<paragraph role="paragraph" id="par_id3152940" xml-lang="en-US" l10n="U" oldref="20">MsgBox "The word »and« appears in the sentence you entered!"</paragraph> +<paragraph role="paragraph" id="par_id3153954" xml-lang="en-US" l10n="U" oldref="21">EndIf</paragraph> +<paragraph role="paragraph" id="par_id3152886" xml-lang="en-US" l10n="U" oldref="22">End Sub</paragraph> +</body> </helpdocument> diff --git a/helpcontent2/source/text/sbasic/shared/03100300.xhp b/helpcontent2/source/text/sbasic/shared/03100300.xhp index 8bc23a374f..529aa0a44a 100755 --- a/helpcontent2/source/text/sbasic/shared/03100300.xhp +++ b/helpcontent2/source/text/sbasic/shared/03100300.xhp @@ -52,37 +52,40 @@ * Contributor(s): _______________________________________ * * - ************************************************************************--><helpdocument version="1.0"> + ************************************************************************--> + +<helpdocument version="1.0"> <meta> <topic id="textsbasicshared03100300xml" indexer="include" status="PUBLISH"> -<title xml-lang="en-US" id="tit">CDate Function [Runtime]</title> +<title id="tit" xml-lang="en-US">CDate Function [Runtime]</title> <filename>/text/sbasic/shared/03100300.xhp</filename> </topic> <history> <created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> -<lastedited date="2003-10-31T00:00:00">converted from old format - fpe</lastedited> +<lastedited date="2004-08-24T09:52:33">converted from old format - fpe</lastedited> </history> </meta> <body> - - - <section id="cdate"> - <bookmark xml-lang="en-US" branch="index" id="bm_id3150772"><bookmark_value>CDate;function</bookmark_value></bookmark><paragraph id="hd_id3150772" role="heading" level="1" oldref="1" l10n="U" xml-lang="en-US"><link href="text/sbasic/shared/03100300.xhp" name="CDate Function [Runtime]">CDate Function [Runtime]</link></paragraph> - <paragraph role="paragraph" id="par_id3150986" l10n="U" xml-lang="en-US" oldref="2">Converts any string or numeric expression expression to a date value.</paragraph> - </section> - <paragraph role="heading" level="2" id="hd_id3148944" l10n="U" xml-lang="en-US" oldref="3">Syntax:</paragraph> - <paragraph role="paragraph" id="par_id3148947" l10n="U" xml-lang="en-US" oldref="4">CDate (Expression)</paragraph> - <paragraph role="heading" level="2" id="hd_id3148552" l10n="U" xml-lang="en-US" oldref="5">Return value:</paragraph> - <paragraph role="paragraph" id="par_id3159414" l10n="U" xml-lang="en-US" oldref="6">Date</paragraph> - <paragraph role="heading" level="2" id="hd_id3153525" l10n="U" xml-lang="en-US" oldref="7">Parameters:</paragraph> - <paragraph l10n="U" role="paragraph" id="par_id3150359" xml-lang="en-US" oldref="8"><emph>Expression:</emph> Any string or numeric expression that you want to convert.</paragraph> - <paragraph xml-lang="en-US" oldref="9" role="paragraph" id="par_id3125864" l10n="U">When you convert a string expression, the date and time must be entered in the format MM.DD.YYYY HH.MM.SS, as defined by the <emph>DateValue</emph> and <emph>TimeValue</emph> function conventions. In numeric expressions, values to the left of the decimal represent the date, beginning from December 31, 1899. Values to the right of the decimal represent the time.</paragraph> - <embed href="text/sbasic/shared/00000003.xhp#errorcode"/> - <embed href="text/sbasic/shared/00000003.xhp#err5"/> - <paragraph role="heading" level="2" id="hd_id3156422" l10n="U" xml-lang="en-US" oldref="10">Example:</paragraph> - <paragraph role="paragraph" id="par_id3153969" l10n="U" xml-lang="en-US" oldref="11">sub ExampleCDate</paragraph> - <paragraph role="paragraph" id="par_id3159254" l10n="U" xml-lang="en-US" oldref="12">MsgBox cDate(1000.25) REM 09.26.1902 06:00:00</paragraph> - <paragraph role="paragraph" id="par_id3155133" l10n="U" xml-lang="en-US" oldref="13">MsgBox cDate(1001.26) REM 09.27.1902 06:14:24</paragraph> - <paragraph role="paragraph" id="par_id3153140" l10n="U" xml-lang="en-US" oldref="14">end sub</paragraph> - </body> +<section id="cdate"> +<bookmark xml-lang="en-US" branch="index" id="bm_id3150772"><bookmark_value>CDate function</bookmark_value> +</bookmark> +<paragraph role="heading" id="hd_id3150772" xml-lang="en-US" level="1" l10n="U" oldref="1"><link href="text/sbasic/shared/03100300.xhp" name="CDate Function [Runtime]">CDate Function [Runtime]</link></paragraph> +<paragraph role="paragraph" id="par_id3150986" xml-lang="en-US" l10n="U" oldref="2">Converts any string or numeric expression expression to a date value.</paragraph> +</section> +<paragraph role="heading" id="hd_id3148944" xml-lang="en-US" level="2" l10n="U" oldref="3">Syntax:</paragraph> +<paragraph role="paragraph" id="par_id3148947" xml-lang="en-US" l10n="U" oldref="4">CDate (Expression)</paragraph> +<paragraph role="heading" id="hd_id3148552" xml-lang="en-US" level="2" l10n="U" oldref="5">Return value:</paragraph> +<paragraph role="paragraph" id="par_id3159414" xml-lang="en-US" l10n="U" oldref="6">Date</paragraph> +<paragraph role="heading" id="hd_id3153525" xml-lang="en-US" level="2" l10n="U" oldref="7">Parameters:</paragraph> +<paragraph role="paragraph" id="par_id3150359" xml-lang="en-US" l10n="U" oldref="8"> +<emph>Expression:</emph> Any string or numeric expression that you want to convert.</paragraph> +<paragraph role="paragraph" id="par_id3125864" xml-lang="en-US" l10n="U" oldref="9">When you convert a string expression, the date and time must be entered in the format MM.DD.YYYY HH.MM.SS, as defined by the <emph>DateValue</emph> and <emph>TimeValue</emph> function conventions. In numeric expressions, values to the left of the decimal represent the date, beginning from December 31, 1899. Values to the right of the decimal represent the time.</paragraph> +<embed href="text/sbasic/shared/00000003.xhp#errorcode"/> +<embed href="text/sbasic/shared/00000003.xhp#err5"/> +<paragraph role="heading" id="hd_id3156422" xml-lang="en-US" level="2" l10n="U" oldref="10">Example:</paragraph> +<paragraph role="paragraph" id="par_id3153969" xml-lang="en-US" l10n="U" oldref="11">sub ExampleCDate</paragraph> +<paragraph role="paragraph" id="par_id3159254" xml-lang="en-US" l10n="U" oldref="12">MsgBox cDate(1000.25) REM 09.26.1902 06:00:00</paragraph> +<paragraph role="paragraph" id="par_id3155133" xml-lang="en-US" l10n="U" oldref="13">MsgBox cDate(1001.26) REM 09.27.1902 06:14:24</paragraph> +<paragraph role="paragraph" id="par_id3153140" xml-lang="en-US" l10n="U" oldref="14">end sub</paragraph> +</body> </helpdocument> diff --git a/helpcontent2/source/text/sbasic/shared/03100400.xhp b/helpcontent2/source/text/sbasic/shared/03100400.xhp index c6fc884250..8f97f67bb4 100755 --- a/helpcontent2/source/text/sbasic/shared/03100400.xhp +++ b/helpcontent2/source/text/sbasic/shared/03100400.xhp @@ -52,37 +52,40 @@ * Contributor(s): _______________________________________ * * - ************************************************************************--><helpdocument version="1.0"> + ************************************************************************--> + +<helpdocument version="1.0"> <meta> <topic id="textsbasicshared03100400xml" indexer="include" status="PUBLISH"> -<title xml-lang="en-US" id="tit">CDbl Function [Runtime]</title> +<title id="tit" xml-lang="en-US">CDbl Function [Runtime]</title> <filename>/text/sbasic/shared/03100400.xhp</filename> </topic> <history> <created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> -<lastedited date="2003-10-31T00:00:00">converted from old format - fpe</lastedited> +<lastedited date="2004-08-24T09:54:03">converted from old format - fpe</lastedited> </history> </meta> <body> - - - <section id="cdbl"> - <bookmark xml-lang="en-US" branch="index" id="bm_id3153750"><bookmark_value>CDbl;function</bookmark_value></bookmark><paragraph id="hd_id3153750" role="heading" level="1" oldref="1" l10n="U" xml-lang="en-US"><link href="text/sbasic/shared/03100400.xhp" name="CDbl Function [Runtime]">CDbl Function [Runtime]</link></paragraph> - <paragraph role="paragraph" id="par_id3149233" l10n="U" xml-lang="en-US" oldref="2">Converts any numerical expression or string expression to a double type.</paragraph> - </section> - <paragraph role="heading" level="2" id="hd_id3149516" l10n="U" xml-lang="en-US" oldref="3">Syntax</paragraph> - <paragraph role="paragraph" id="par_id3156152" l10n="U" xml-lang="en-US" oldref="4">CDbl (Expression)</paragraph> - <paragraph role="heading" level="2" id="hd_id3153061" l10n="U" xml-lang="en-US" oldref="5">Return value</paragraph> - <paragraph role="paragraph" id="par_id3145068" l10n="U" xml-lang="en-US" oldref="6">Double</paragraph> - <paragraph role="heading" level="2" id="hd_id3154760" l10n="U" xml-lang="en-US" oldref="7">Parameters:</paragraph> - <paragraph l10n="U" role="paragraph" id="par_id3153897" xml-lang="en-US" oldref="8"><emph>Expression:</emph> Any string or numeric expression that you want to convert. To convert a string expression, the number must be entered as normal text ("123.5") using the default number format of your operating system.</paragraph> - <embed href="text/sbasic/shared/00000003.xhp#errorcode"/> - <embed href="text/sbasic/shared/00000003.xhp#err5"/> - <paragraph role="heading" level="2" id="hd_id3148797" l10n="U" xml-lang="en-US" oldref="9">Example:</paragraph> - <paragraph role="paragraph" id="par_id3154217" l10n="U" xml-lang="en-US" oldref="10">Sub ExampleCountryConvert</paragraph> - <paragraph role="paragraph" id="par_id3147229" l10n="U" xml-lang="en-US" oldref="11">Msgbox CDbl(1234.5678)</paragraph> - <paragraph role="paragraph" id="par_id3151042" l10n="U" xml-lang="en-US" oldref="12">Msgbox CInt(1234.5678)</paragraph> - <paragraph role="paragraph" id="par_id3150616" l10n="U" xml-lang="en-US" oldref="13">Msgbox CLng(1234.5678)</paragraph> - <paragraph role="paragraph" id="par_id3153969" l10n="U" xml-lang="en-US" oldref="14">end sub</paragraph> - </body> +<section id="cdbl"> +<bookmark xml-lang="en-US" branch="index" id="bm_id3153750"><bookmark_value>CDbl function</bookmark_value> +</bookmark> +<paragraph role="heading" id="hd_id3153750" xml-lang="en-US" level="1" l10n="U" oldref="1"><link href="text/sbasic/shared/03100400.xhp" name="CDbl Function [Runtime]">CDbl Function [Runtime]</link></paragraph> +<paragraph role="paragraph" id="par_id3149233" xml-lang="en-US" l10n="U" oldref="2">Converts any numerical expression or string expression to a double type.</paragraph> +</section> +<paragraph role="heading" id="hd_id3149516" xml-lang="en-US" level="2" l10n="U" oldref="3">Syntax</paragraph> +<paragraph role="paragraph" id="par_id3156152" xml-lang="en-US" l10n="U" oldref="4">CDbl (Expression)</paragraph> +<paragraph role="heading" id="hd_id3153061" xml-lang="en-US" level="2" l10n="U" oldref="5">Return value</paragraph> +<paragraph role="paragraph" id="par_id3145068" xml-lang="en-US" l10n="U" oldref="6">Double</paragraph> +<paragraph role="heading" id="hd_id3154760" xml-lang="en-US" level="2" l10n="U" oldref="7">Parameters:</paragraph> +<paragraph role="paragraph" id="par_id3153897" xml-lang="en-US" l10n="U" oldref="8"> +<emph>Expression:</emph> Any string or numeric expression that you want to convert. To convert a string expression, the number must be entered as normal text ("123.5") using the default number format of your operating system.</paragraph> +<embed href="text/sbasic/shared/00000003.xhp#errorcode"/> +<embed href="text/sbasic/shared/00000003.xhp#err5"/> +<paragraph role="heading" id="hd_id3148797" xml-lang="en-US" level="2" l10n="U" oldref="9">Example:</paragraph> +<paragraph role="paragraph" id="par_id3154217" xml-lang="en-US" l10n="U" oldref="10">Sub ExampleCountryConvert</paragraph> +<paragraph role="paragraph" id="par_id3147229" xml-lang="en-US" l10n="U" oldref="11">Msgbox CDbl(1234.5678)</paragraph> +<paragraph role="paragraph" id="par_id3151042" xml-lang="en-US" l10n="U" oldref="12">Msgbox CInt(1234.5678)</paragraph> +<paragraph role="paragraph" id="par_id3150616" xml-lang="en-US" l10n="U" oldref="13">Msgbox CLng(1234.5678)</paragraph> +<paragraph role="paragraph" id="par_id3153969" xml-lang="en-US" l10n="U" oldref="14">end sub</paragraph> +</body> </helpdocument> diff --git a/helpcontent2/source/text/sbasic/shared/03100500.xhp b/helpcontent2/source/text/sbasic/shared/03100500.xhp index be8a514709..8e49a0ecda 100755 --- a/helpcontent2/source/text/sbasic/shared/03100500.xhp +++ b/helpcontent2/source/text/sbasic/shared/03100500.xhp @@ -52,38 +52,41 @@ * Contributor(s): _______________________________________ * * - ************************************************************************--><helpdocument version="1.0"> + ************************************************************************--> + +<helpdocument version="1.0"> <meta> <topic id="textsbasicshared03100500xml" indexer="include" status="PUBLISH"> -<title xml-lang="en-US" id="tit">CInt Function [Runtime]</title> +<title id="tit" xml-lang="en-US">CInt Function [Runtime]</title> <filename>/text/sbasic/shared/03100500.xhp</filename> </topic> <history> <created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> -<lastedited date="2003-10-31T00:00:00">converted from old format - fpe</lastedited> +<lastedited date="2004-08-24T10:29:21">converted from old format - fpe</lastedited> </history> </meta> <body> - - - <section id="cint"> - <bookmark xml-lang="en-US" branch="index" id="bm_id3149346"><bookmark_value>CInt;function</bookmark_value></bookmark><paragraph id="hd_id3149346" role="heading" level="1" oldref="1" l10n="U" xml-lang="en-US"><link href="text/sbasic/shared/03100500.xhp" name="CInt Function [Runtime]">CInt Function [Runtime]</link></paragraph> - <paragraph role="paragraph" id="par_id3155419" l10n="U" xml-lang="en-US" oldref="2">Converts any string or numeric expression to an integer.</paragraph> - </section> - <paragraph role="heading" level="2" id="hd_id3147573" l10n="U" xml-lang="en-US" oldref="3">Syntax:</paragraph> - <paragraph role="paragraph" id="par_id3154142" l10n="U" xml-lang="en-US" oldref="4">CInt (Expression)</paragraph> - <paragraph role="heading" level="2" id="hd_id3147531" l10n="U" xml-lang="en-US" oldref="5">Return value:</paragraph> - <paragraph role="paragraph" id="par_id3147560" l10n="U" xml-lang="en-US" oldref="6">Integer</paragraph> - <paragraph role="heading" level="2" id="hd_id3145069" l10n="U" xml-lang="en-US" oldref="7">Parameters:</paragraph> - <paragraph l10n="U" xml-lang="en-US" role="paragraph" id="par_id3159414" oldref="8"><emph>Expression:</emph> Any numeric expression that you want to convert. If the <emph>Expression</emph> exceeds the value range between -32768 and 32767, $[officename] Basic reports an overflow error. To convert a string expression, the number must be entered as normal text ("123.5") using the default number format of your operating system.</paragraph> - <paragraph role="paragraph" id="par_id3150358" l10n="U" xml-lang="en-US" oldref="9">This function always rounds the fractional part of a number to the nearest integer.</paragraph> - <embed href="text/sbasic/shared/00000003.xhp#errorcode"/> - <embed href="text/sbasic/shared/00000003.xhp#err5"/> - <paragraph role="heading" level="2" id="hd_id3145419" l10n="U" xml-lang="en-US" oldref="10">Example:</paragraph> - <paragraph role="paragraph" id="par_id3150448" l10n="U" xml-lang="en-US" oldref="11">Sub ExampleCountryConvert</paragraph> - <paragraph role="paragraph" id="par_id3156423" l10n="U" xml-lang="en-US" oldref="12">Msgbox CDbl(1234.5678)</paragraph> - <paragraph role="paragraph" id="par_id3150869" l10n="U" xml-lang="en-US" oldref="13">Msgbox CInt(1234.5678)</paragraph> - <paragraph role="paragraph" id="par_id3153768" l10n="U" xml-lang="en-US" oldref="14">Msgbox CLng(1234.5678)</paragraph> - <paragraph role="paragraph" id="par_id3145786" l10n="U" xml-lang="en-US" oldref="15">end sub</paragraph> - </body> +<section id="cint"> +<bookmark xml-lang="en-US" branch="index" id="bm_id3149346"><bookmark_value>CInt function</bookmark_value> +</bookmark> +<paragraph role="heading" id="hd_id3149346" xml-lang="en-US" level="1" l10n="U" oldref="1"><link href="text/sbasic/shared/03100500.xhp" name="CInt Function [Runtime]">CInt Function [Runtime]</link></paragraph> +<paragraph role="paragraph" id="par_id3155419" xml-lang="en-US" l10n="U" oldref="2">Converts any string or numeric expression to an integer.</paragraph> +</section> +<paragraph role="heading" id="hd_id3147573" xml-lang="en-US" level="2" l10n="U" oldref="3">Syntax:</paragraph> +<paragraph role="paragraph" id="par_id3154142" xml-lang="en-US" l10n="U" oldref="4">CInt (Expression)</paragraph> +<paragraph role="heading" id="hd_id3147531" xml-lang="en-US" level="2" l10n="U" oldref="5">Return value:</paragraph> +<paragraph role="paragraph" id="par_id3147560" xml-lang="en-US" l10n="U" oldref="6">Integer</paragraph> +<paragraph role="heading" id="hd_id3145069" xml-lang="en-US" level="2" l10n="U" oldref="7">Parameters:</paragraph> +<paragraph role="paragraph" id="par_id3159414" xml-lang="en-US" l10n="U" oldref="8"> +<emph>Expression:</emph> Any numeric expression that you want to convert. If the <emph>Expression</emph> exceeds the value range between -32768 and 32767, $[officename] Basic reports an overflow error. To convert a string expression, the number must be entered as normal text ("123.5") using the default number format of your operating system.</paragraph> +<paragraph role="paragraph" id="par_id3150358" xml-lang="en-US" l10n="U" oldref="9">This function always rounds the fractional part of a number to the nearest integer.</paragraph> +<embed href="text/sbasic/shared/00000003.xhp#errorcode"/> +<embed href="text/sbasic/shared/00000003.xhp#err5"/> +<paragraph role="heading" id="hd_id3145419" xml-lang="en-US" level="2" l10n="U" oldref="10">Example:</paragraph> +<paragraph role="paragraph" id="par_id3150448" xml-lang="en-US" l10n="U" oldref="11">Sub ExampleCountryConvert</paragraph> +<paragraph role="paragraph" id="par_id3156423" xml-lang="en-US" l10n="U" oldref="12">Msgbox CDbl(1234.5678)</paragraph> +<paragraph role="paragraph" id="par_id3150869" xml-lang="en-US" l10n="U" oldref="13">Msgbox CInt(1234.5678)</paragraph> +<paragraph role="paragraph" id="par_id3153768" xml-lang="en-US" l10n="U" oldref="14">Msgbox CLng(1234.5678)</paragraph> +<paragraph role="paragraph" id="par_id3145786" xml-lang="en-US" l10n="U" oldref="15">end sub</paragraph> +</body> </helpdocument> diff --git a/helpcontent2/source/text/sbasic/shared/03100600.xhp b/helpcontent2/source/text/sbasic/shared/03100600.xhp index 1ba707df07..d90c1898b3 100755 --- a/helpcontent2/source/text/sbasic/shared/03100600.xhp +++ b/helpcontent2/source/text/sbasic/shared/03100600.xhp @@ -52,38 +52,41 @@ * Contributor(s): _______________________________________ * * - ************************************************************************--><helpdocument version="1.0"> + ************************************************************************--> + +<helpdocument version="1.0"> <meta> <topic id="textsbasicshared03100600xml" indexer="include" status="PUBLISH"> -<title xml-lang="en-US" id="tit">CLng Function [Runtime]</title> +<title id="tit" xml-lang="en-US">CLng Function [Runtime]</title> <filename>/text/sbasic/shared/03100600.xhp</filename> </topic> <history> <created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> -<lastedited date="2003-10-31T00:00:00">converted from old format - fpe</lastedited> +<lastedited date="2004-08-24T10:30:03">converted from old format - fpe</lastedited> </history> </meta> <body> - - - <section id="clng"> - <bookmark xml-lang="en-US" branch="index" id="bm_id3153311"><bookmark_value>CLng;function</bookmark_value></bookmark><paragraph id="hd_id3153311" role="heading" level="1" oldref="1" l10n="U" xml-lang="en-US"><link href="text/sbasic/shared/03100600.xhp" name="CLng Function [Runtime]">CLng Function [Runtime]</link></paragraph> - <paragraph role="paragraph" id="par_id3148686" l10n="U" xml-lang="en-US" oldref="2">Converts any string or numeric expression to a long integer.</paragraph> - </section> - <paragraph role="heading" level="2" id="hd_id3145315" l10n="U" xml-lang="en-US" oldref="3">Syntax:</paragraph> - <paragraph role="paragraph" id="par_id3147573" l10n="U" xml-lang="en-US" oldref="4">CLng (Expression)</paragraph> - <paragraph role="heading" level="2" id="hd_id3145610" l10n="U" xml-lang="en-US" oldref="5">Return value:</paragraph> - <paragraph role="paragraph" id="par_id3153897" l10n="U" xml-lang="en-US" oldref="6">Long</paragraph> - <paragraph role="heading" level="2" id="hd_id3154760" l10n="U" xml-lang="en-US" oldref="7">Parameters:</paragraph> - <paragraph l10n="U" xml-lang="en-US" role="paragraph" id="par_id3159414" oldref="8"><emph>Expression:</emph> Any numerical expression that you want to convert. If the <emph>Expression</emph> lies outside the valid long integer range between -2.147.483.648 and 2.147.483.647, $[officename] Basic returns an overflow error. To convert a string expression, the number must be entered as normal text ("123.5") using the default number format of your operating system.</paragraph> - <paragraph role="paragraph" id="par_id3150358" l10n="U" xml-lang="en-US" oldref="9">This function always rounds the fractional part of a number to the nearest integer.</paragraph> - <embed href="text/sbasic/shared/00000003.xhp#errorcode"/> - <embed href="text/sbasic/shared/00000003.xhp#err5"/> - <paragraph role="heading" level="2" id="hd_id3154216" l10n="U" xml-lang="en-US" oldref="10">Example:</paragraph> - <paragraph role="paragraph" id="par_id3147229" l10n="U" xml-lang="en-US" oldref="11">Sub ExampleCountryConvert</paragraph> - <paragraph role="paragraph" id="par_id3156281" l10n="U" xml-lang="en-US" oldref="12">Msgbox CDbl(1234.5678)</paragraph> - <paragraph role="paragraph" id="par_id3153969" l10n="U" xml-lang="en-US" oldref="13">Msgbox CInt(1234.5678)</paragraph> - <paragraph role="paragraph" id="par_id3154909" l10n="U" xml-lang="en-US" oldref="14">Msgbox CLng(1234.5678)</paragraph> - <paragraph role="paragraph" id="par_id3153770" l10n="U" xml-lang="en-US" oldref="15">end sub</paragraph> - </body> +<section id="clng"> +<bookmark xml-lang="en-US" branch="index" id="bm_id3153311"><bookmark_value>CLng function</bookmark_value> +</bookmark> +<paragraph role="heading" id="hd_id3153311" xml-lang="en-US" level="1" l10n="U" oldref="1"><link href="text/sbasic/shared/03100600.xhp" name="CLng Function [Runtime]">CLng Function [Runtime]</link></paragraph> +<paragraph role="paragraph" id="par_id3148686" xml-lang="en-US" l10n="U" oldref="2">Converts any string or numeric expression to a long integer.</paragraph> +</section> +<paragraph role="heading" id="hd_id3145315" xml-lang="en-US" level="2" l10n="U" oldref="3">Syntax:</paragraph> +<paragraph role="paragraph" id="par_id3147573" xml-lang="en-US" l10n="U" oldref="4">CLng (Expression)</paragraph> +<paragraph role="heading" id="hd_id3145610" xml-lang="en-US" level="2" l10n="U" oldref="5">Return value:</paragraph> +<paragraph role="paragraph" id="par_id3153897" xml-lang="en-US" l10n="U" oldref="6">Long</paragraph> +<paragraph role="heading" id="hd_id3154760" xml-lang="en-US" level="2" l10n="U" oldref="7">Parameters:</paragraph> +<paragraph role="paragraph" id="par_id3159414" xml-lang="en-US" l10n="U" oldref="8"> +<emph>Expression:</emph> Any numerical expression that you want to convert. If the <emph>Expression</emph> lies outside the valid long integer range between -2.147.483.648 and 2.147.483.647, $[officename] Basic returns an overflow error. To convert a string expression, the number must be entered as normal text ("123.5") using the default number format of your operating system.</paragraph> +<paragraph role="paragraph" id="par_id3150358" xml-lang="en-US" l10n="U" oldref="9">This function always rounds the fractional part of a number to the nearest integer.</paragraph> +<embed href="text/sbasic/shared/00000003.xhp#errorcode"/> +<embed href="text/sbasic/shared/00000003.xhp#err5"/> +<paragraph role="heading" id="hd_id3154216" xml-lang="en-US" level="2" l10n="U" oldref="10">Example:</paragraph> +<paragraph role="paragraph" id="par_id3147229" xml-lang="en-US" l10n="U" oldref="11">Sub ExampleCountryConvert</paragraph> +<paragraph role="paragraph" id="par_id3156281" xml-lang="en-US" l10n="U" oldref="12">Msgbox CDbl(1234.5678)</paragraph> +<paragraph role="paragraph" id="par_id3153969" xml-lang="en-US" l10n="U" oldref="13">Msgbox CInt(1234.5678)</paragraph> +<paragraph role="paragraph" id="par_id3154909" xml-lang="en-US" l10n="U" oldref="14">Msgbox CLng(1234.5678)</paragraph> +<paragraph role="paragraph" id="par_id3153770" xml-lang="en-US" l10n="U" oldref="15">end sub</paragraph> +</body> </helpdocument> |