1<?xml version="1.0" encoding="UTF-8"?> 2 3 4<!--*********************************************************************** 5 * 6 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. 7 * 8 * Copyright 2000, 2010 Oracle and/or its affiliates. 9 * 10 * OpenOffice.org - a multi-platform office productivity suite 11 * 12 * This file is part of OpenOffice.org. 13 * 14 * OpenOffice.org is free software: you can redistribute it and/or modify 15 * it under the terms of the GNU Lesser General Public License version 3 16 * only, as published by the Free Software Foundation. 17 * 18 * OpenOffice.org is distributed in the hope that it will be useful, 19 * but WITHOUT ANY WARRANTY; without even the implied warranty of 20 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the 21 * GNU Lesser General Public License version 3 for more details 22 * (a copy is included in the LICENSE file that accompanied this code). 23 * 24 * You should have received a copy of the GNU Lesser General Public License 25 * version 3 along with OpenOffice.org. If not, see 26 * <http://www.openoffice.org/license.html> 27 * for a copy of the LGPLv3 License. 28 * 29 ************************************************************************--> 30 31<helpdocument version="1.0"> 32<meta> 33<topic id="textsbasicshared03101000xml" indexer="include" status="PUBLISH"> 34<title id="tit" xml-lang="en-US">CStr Function [Runtime]</title> 35<filename>/text/sbasic/shared/03101000.xhp</filename> 36</topic> 37<history> 38<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> 39<lastedited date="2004-08-24T11:14:19">converted from old format - fpe</lastedited> 40</history> 41</meta> 42<body> 43<section id="cstr"> 44<bookmark xml-lang="en-US" branch="index" id="bm_id3146958"><bookmark_value>CStr function</bookmark_value> 45</bookmark> 46<paragraph role="heading" id="hd_id3146958" xml-lang="en-US" level="1" l10n="U" oldref="1"><link href="text/sbasic/shared/03101000.xhp" name="CStr Function [Runtime]">CStr Function [Runtime]</link></paragraph> 47<paragraph role="paragraph" id="par_id3147574" xml-lang="en-US" l10n="U" oldref="2">Converts any numeric expression to a string expression.</paragraph> 48</section> 49<paragraph role="heading" id="hd_id3148473" xml-lang="en-US" level="2" l10n="U" oldref="3">Syntax:</paragraph> 50<paragraph role="paragraph" id="par_id3145315" xml-lang="en-US" l10n="U" oldref="4">CStr (Expression)</paragraph> 51<paragraph role="heading" id="hd_id3153062" xml-lang="en-US" level="2" l10n="U" oldref="5">Return value:</paragraph> 52<paragraph role="paragraph" id="par_id3153897" xml-lang="en-US" l10n="U" oldref="6">String</paragraph> 53<paragraph role="heading" id="hd_id3154760" xml-lang="en-US" level="2" l10n="U" oldref="7">Parameters:</paragraph> 54<paragraph role="paragraph" id="par_id3149457" xml-lang="en-US" l10n="U" oldref="8"> 55<emph>Expression:</emph> Any valid string or numeric expression that you want to convert.</paragraph> 56<paragraph role="heading" id="hd_id3150358" xml-lang="en-US" level="2" l10n="U" oldref="9">Expression Types and Conversion Returns</paragraph> 57<table id="tbl_id3148797"> 58<tablerow> 59<tablecell colspan="" rowspan=""> 60<paragraph role="paragraph" id="par_id3153192" xml-lang="en-US" l10n="U" oldref="10">Boolean :</paragraph> 61</tablecell> 62<tablecell colspan="" rowspan=""> 63<paragraph role="paragraph" id="par_id3156422" xml-lang="en-US" l10n="U" oldref="11">String that evaluates to either <emph>True</emph> or <emph>False</emph>.</paragraph> 64</tablecell> 65</tablerow> 66<tablerow> 67<tablecell colspan="" rowspan=""> 68<paragraph role="paragraph" id="par_id3147287" xml-lang="en-US" l10n="U" oldref="12">Date :</paragraph> 69</tablecell> 70<tablecell colspan="" rowspan=""> 71<paragraph role="paragraph" id="par_id3155411" xml-lang="en-US" l10n="U" oldref="13">String that contains the date and time.</paragraph> 72</tablecell> 73</tablerow> 74<tablerow> 75<tablecell colspan="" rowspan=""> 76<paragraph role="paragraph" id="par_id3147428" xml-lang="en-US" l10n="U" oldref="14">Null :</paragraph> 77</tablecell> 78<tablecell colspan="" rowspan=""> 79<paragraph role="paragraph" id="par_id3150486" xml-lang="en-US" l10n="U" oldref="15">Run-time error.</paragraph> 80</tablecell> 81</tablerow> 82<tablerow> 83<tablecell colspan="" rowspan=""> 84<paragraph role="paragraph" id="par_id3153953" xml-lang="en-US" l10n="U" oldref="16">Empty :</paragraph> 85</tablecell> 86<tablecell colspan="" rowspan=""> 87<paragraph role="paragraph" id="par_id3155306" xml-lang="en-US" l10n="U" oldref="17">String without any characters.</paragraph> 88</tablecell> 89</tablerow> 90<tablerow> 91<tablecell colspan="" rowspan=""> 92<paragraph role="paragraph" id="par_id3149260" xml-lang="en-US" l10n="U" oldref="18">Any :</paragraph> 93</tablecell> 94<tablecell colspan="" rowspan=""> 95<paragraph role="paragraph" id="par_id3152938" xml-lang="en-US" l10n="U" oldref="19">Corresponding number as string.</paragraph> 96</tablecell> 97</tablerow> 98</table> 99 100<paragraph role="paragraph" id="par_id3155738" xml-lang="en-US" l10n="U" oldref="20">Zeros at the end of a floating-point number are not included in the returned string.</paragraph> 101<embed href="text/sbasic/shared/00000003.xhp#errorcode"/> 102<embed href="text/sbasic/shared/00000003.xhp#err5"/> 103<paragraph role="heading" id="hd_id3154729" xml-lang="en-US" level="2" l10n="U" oldref="21">Example:</paragraph> 104<paragraph role="paragraph" id="par_id3153878" xml-lang="en-US" l10n="U" oldref="22">Sub ExampleCSTR</paragraph> 105<paragraph role="paragraph" id="par_id3154943" xml-lang="en-US" l10n="U" oldref="23">Dim sVar As String</paragraph> 106<paragraph role="paragraph" id="par_id3156283" xml-lang="en-US" l10n="U" oldref="24">Msgbox CDbl(1234.5678)</paragraph> 107<paragraph role="paragraph" id="par_id3147396" xml-lang="en-US" l10n="U" oldref="25">Msgbox CInt(1234.5678)</paragraph> 108<paragraph role="paragraph" id="par_id3155600" xml-lang="en-US" l10n="U" oldref="26">Msgbox CLng(1234.5678)</paragraph> 109<paragraph role="paragraph" id="par_id3153416" xml-lang="en-US" l10n="U" oldref="27">Msgbox CSng(1234.5678)</paragraph> 110<paragraph role="paragraph" id="par_id3156559" xml-lang="en-US" l10n="U" oldref="28">sVar = CStr(1234.5678)</paragraph> 111<paragraph role="paragraph" id="par_id3153947" xml-lang="en-US" l10n="U" oldref="29">MsgBox sVar</paragraph> 112<paragraph role="paragraph" id="par_id3150327" xml-lang="en-US" l10n="U" oldref="30">end sub</paragraph> 113</body> 114</helpdocument> 115