diff options
author | RĂ¼diger Timm <rt@openoffice.org> | 2006-12-01 15:50:58 +0000 |
---|---|---|
committer | RĂ¼diger Timm <rt@openoffice.org> | 2006-12-01 15:50:58 +0000 |
commit | 931aa7b95d6a66c2f00952aedebbcbc503b33d0a (patch) | |
tree | 2cd15c447021c59c8b75ed3c12f92fc4fea51f7a /helpcontent2/source/text/scalc/01/04060110.xhp | |
parent | INTEGRATION: CWS hcshared06 (1.6.56); FILE MERGED (diff) | |
download | help-931aa7b95d6a66c2f00952aedebbcbc503b33d0a.tar.gz help-931aa7b95d6a66c2f00952aedebbcbc503b33d0a.zip |
INTEGRATION: CWS hcshared06 (1.10.14); FILE MERGED
2006/11/07 12:17:09 ufi 1.10.14.2: calc enhancements
2006/11/03 07:47:18 ufi 1.10.14.1: saving
Diffstat (limited to 'helpcontent2/source/text/scalc/01/04060110.xhp')
-rw-r--r-- | helpcontent2/source/text/scalc/01/04060110.xhp | 27 |
1 files changed, 14 insertions, 13 deletions
diff --git a/helpcontent2/source/text/scalc/01/04060110.xhp b/helpcontent2/source/text/scalc/01/04060110.xhp index 3b9ba40869..3939f137c1 100644 --- a/helpcontent2/source/text/scalc/01/04060110.xhp +++ b/helpcontent2/source/text/scalc/01/04060110.xhp @@ -6,9 +6,9 @@ * * $RCSfile: 04060110.xhp,v $ * - * $Revision: 1.10 $ + * $Revision: 1.11 $ * - * last change: $Author: kz $ $Date: 2006-10-05 12:59:19 $ + * last change: $Author: rt $ $Date: 2006-12-01 16:50:58 $ * * The Contents of this file are made available subject to * the terms of GNU Lesser General Public License Version 2.1. @@ -44,12 +44,12 @@ </topic> <history> <created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> -<lastedited date="2006-07-26T14:30:26">converted from old format - fpe</lastedited> +<lastedited date="2006-11-07T11:44:52">converted from old format - fpe</lastedited> </history> </meta> <body> <bookmark xml-lang="en-US" branch="index" id="bm_id3145389"><bookmark_value>text in cells; functions</bookmark_value> -<bookmark_value>functions; text</bookmark_value> +<bookmark_value>functions; text functions</bookmark_value> <bookmark_value>Function Wizard;text</bookmark_value> </bookmark> <paragraph role="heading" id="hd_id3145389" xml-lang="en-US" level="1" l10n="U" oldref="1">Text Functions</paragraph> @@ -232,7 +232,7 @@ </bookmark> <bookmark xml-lang="en-US" branch="hid/HID_FUNC_FEST" id="bm_id3149450" localize="false"/> <paragraph role="heading" id="hd_id3149268" xml-lang="en-US" level="2" l10n="U" oldref="34">FIXED</paragraph> -<paragraph role="paragraph" id="par_id3155833" xml-lang="en-US" l10n="U" oldref="35"><ahelp hid="HID_FUNC_FEST">Specifies that a number be displayed with a fixed number of decimal places and with or without a thousands separator. This function can be used to apply a uniform format to a column of numbers.</ahelp></paragraph> +<paragraph role="paragraph" id="par_id3155833" xml-lang="en-US" l10n="CHG" oldref="35"><ahelp hid="HID_FUNC_FEST">Returns a number as text with a specified number of decimal places and optional thousands separators.</ahelp></paragraph> <paragraph role="heading" id="hd_id3152470" xml-lang="en-US" level="3" l10n="U" oldref="36">Syntax</paragraph> <paragraph role="code" id="par_id3147567" xml-lang="en-US" l10n="U" oldref="37">FIXED(Number; decimals; no thousands separators)</paragraph> <paragraph role="paragraph" id="par_id3151272" xml-lang="en-US" l10n="U" oldref="38"> @@ -242,14 +242,15 @@ <paragraph role="paragraph" id="par_id3150877" xml-lang="en-US" l10n="U" oldref="40"> <emph>No thousands separators</emph> (optional) determines whether the thousands separator is used. If the parameter is a number not equal to 0, the thousands separator is suppressed. If the parameter is equal to 0 or if it is missing altogether, the thousands separators of your <link href="text/shared/optionen/01140000.xhp" name="current locale setting">current locale setting</link> are displayed.</paragraph> <paragraph role="heading" id="hd_id3149040" xml-lang="en-US" level="3" l10n="U" oldref="41">Example</paragraph> -<paragraph role="paragraph" id="par_id3145208" xml-lang="en-US" l10n="U" oldref="42">FIXED(1234567.89;3) returns 1,234,567.890. FIXED(1234567.89;3;1) returns 1234567.890.</paragraph> +<paragraph role="paragraph" id="par_id3145208" xml-lang="en-US" l10n="CHG" oldref="42">FIXED(1234567.89;3) returns 1,234,567.890 as a text string. </paragraph> +<paragraph role="paragraph" id="par_id5282143" xml-lang="en-US" l10n="NEW">FIXED(1234567.89;3;1) returns 1234567.890 as a text string.</paragraph> </section> <section id="left"> <bookmark xml-lang="en-US" branch="index" id="bm_id3147083"><bookmark_value>LEFT function</bookmark_value> </bookmark> <bookmark xml-lang="en-US" branch="hid/HID_FUNC_LINKS" id="bm_id3154645" localize="false"/> <paragraph role="heading" id="hd_id3147083" xml-lang="en-US" level="2" l10n="U" oldref="95">LEFT</paragraph> -<paragraph role="paragraph" id="par_id3153622" xml-lang="en-US" l10n="U" oldref="96"><ahelp hid="HID_FUNC_LINKS">Returns the first character or characters in a text string.</ahelp></paragraph> +<paragraph role="paragraph" id="par_id3153622" xml-lang="en-US" l10n="CHG" oldref="96"><ahelp hid="HID_FUNC_LINKS">Returns the first character or characters of a text.</ahelp></paragraph> <paragraph role="heading" id="hd_id3156116" xml-lang="en-US" level="3" l10n="U" oldref="97">Syntax</paragraph> <paragraph role="code" id="par_id3146786" xml-lang="en-US" l10n="U" oldref="98">LEFT(text; number)</paragraph> <paragraph role="paragraph" id="par_id3147274" xml-lang="en-US" l10n="U" oldref="99"> @@ -291,7 +292,7 @@ </bookmark> <bookmark xml-lang="en-US" branch="hid/HID_FUNC_TEIL" id="bm_id3155392" localize="false"/> <paragraph role="heading" id="hd_id3154589" xml-lang="en-US" level="2" l10n="U" oldref="148">MID</paragraph> -<paragraph role="paragraph" id="par_id3154938" xml-lang="en-US" l10n="U" oldref="149"><ahelp hid="HID_FUNC_TEIL">Returns a text segment of a character string. The parameters specify the starting position and the number of characters.</ahelp></paragraph> +<paragraph role="paragraph" id="par_id3154938" xml-lang="en-US" l10n="CHG" oldref="149"><ahelp hid="HID_FUNC_TEIL">Returns a text string of a text. The parameters specify the starting position and the number of characters.</ahelp></paragraph> <paragraph role="heading" id="hd_id3148829" xml-lang="en-US" level="3" l10n="U" oldref="150">Syntax</paragraph> <paragraph role="code" id="par_id3150526" xml-lang="en-US" l10n="U" oldref="151">MID(text; start; number)</paragraph> <paragraph role="paragraph" id="par_id3148820" xml-lang="en-US" l10n="U" oldref="152"> @@ -357,7 +358,7 @@ </bookmark> <bookmark xml-lang="en-US" branch="hid/HID_FUNC_RECHTS" id="bm_id3154602" localize="false"/> <paragraph role="heading" id="hd_id3149805" xml-lang="en-US" level="2" l10n="U" oldref="113">RIGHT</paragraph> -<paragraph role="paragraph" id="par_id3145375" xml-lang="en-US" l10n="U" oldref="114"><ahelp hid="HID_FUNC_RECHTS">Defines the last character or characters in a text string.</ahelp></paragraph> +<paragraph role="paragraph" id="par_id3145375" xml-lang="en-US" l10n="CHG" oldref="114"><ahelp hid="HID_FUNC_RECHTS">Returns the last character or characters of a text.</ahelp></paragraph> <paragraph role="heading" id="hd_id3150837" xml-lang="en-US" level="3" l10n="U" oldref="115">Syntax</paragraph> <paragraph role="code" id="par_id3154344" xml-lang="en-US" l10n="U" oldref="116">RIGHT(text; number)</paragraph> <paragraph role="paragraph" id="par_id3149426" xml-lang="en-US" l10n="U" oldref="117"> @@ -430,13 +431,13 @@ </bookmark> <bookmark xml-lang="en-US" branch="hid/HID_FUNC_T" id="bm_id3156051" localize="false"/> <paragraph role="heading" id="hd_id3148977" xml-lang="en-US" level="2" l10n="U" oldref="140">T</paragraph> -<paragraph role="paragraph" id="par_id3154359" xml-lang="en-US" l10n="U" oldref="141"><ahelp hid="HID_FUNC_T">This function converts a number to a blank text string.</ahelp></paragraph> +<paragraph role="paragraph" id="par_id3154359" xml-lang="en-US" l10n="CHG" oldref="141"><ahelp hid="HID_FUNC_T">This function returns the target text, or a blank text string if the target is not text.</ahelp></paragraph> <paragraph role="heading" id="hd_id3155858" xml-lang="en-US" level="3" l10n="U" oldref="142">Syntax</paragraph> <paragraph role="code" id="par_id3155871" xml-lang="en-US" l10n="U" oldref="143">T(value)</paragraph> -<paragraph role="paragraph" id="par_id3154726" xml-lang="en-US" l10n="U" oldref="144"> -<emph>value</emph> is the value to be converted. Also, a reference can be used as a parameter. If the referenced cell includes a number or a formula containing a numerical result, the result will be an empty string.</paragraph> +<paragraph role="paragraph" id="par_id3154726" xml-lang="en-US" l10n="CHG" oldref="144">If <emph>value</emph> is a text string or refers to a text string, T returns that text string; otherwise it returns a blank text string.</paragraph> <paragraph role="heading" id="hd_id3155544" xml-lang="en-US" level="3" l10n="U" oldref="145">Example</paragraph> -<paragraph role="paragraph" id="par_id3151062" xml-lang="en-US" l10n="U" oldref="146">T(12345) becomes an empty string "", if 12345 is formatted as a number. T("12345") returns 12345.</paragraph> +<paragraph role="paragraph" id="par_id3151062" xml-lang="en-US" l10n="CHG" oldref="146">T(12345) returns an empty string "". </paragraph> +<paragraph role="paragraph" id="par_id4650105" xml-lang="en-US" l10n="NEW">T("12345") returns the string 12345.</paragraph> </section> <section id="text"> <bookmark xml-lang="en-US" branch="index" id="bm_id3147132"><bookmark_value>TEXT function</bookmark_value> |