source/text/scalc/01/04060110.xhp | 1322 +++++++++++++++++++-------------------
1 file changed, 687 insertions(+), 635 deletions(-)
New commits:
commit f86e7a5fddca6c2079524296a287f599405ab347
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
Date: Tue May 2 20:50:23 2017 -0300
tdf#103457 link UNICODE() to UNICHAR() in Help
Change-Id: I80f7bdf22dc302b8bb8cab1cd278b06989a14f6b
Reviewed-on: https://gerrit.libreoffice.org/37181
Reviewed-by: Olivier Hallot <olivier.hal...@edx.srv.br>
Tested-by: Olivier Hallot <olivier.hal...@edx.srv.br>
diff --git a/source/text/scalc/01/04060110.xhp
b/source/text/scalc/01/04060110.xhp
index c877ba086..cdcd4a6aa 100644
--- a/source/text/scalc/01/04060110.xhp
+++ b/source/text/scalc/01/04060110.xhp
@@ -1,6 +1,5 @@
<?xml version="1.0" encoding="UTF-8"?>
<helpdocument version="1.0">
-
<!--
* This file is part of the LibreOffice project.
*
@@ -17,713 +16,766 @@
* License, Version 2.0 (the "License"); you may not use this file
* except in compliance with the License. You may obtain a copy of
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
- -->
-
+-->
<meta>
- <topic id="textscalc0104060110xml" indexer="include">
- <title xml-lang="en-US" id="tit">Text Functions</title>
- <filename>/text/scalc/01/04060110.xhp</filename>
- </topic>
- </meta>
- <body>
-<bookmark xml-lang="en-US" branch="index"
id="bm_id3145389"><bookmark_value>text in cells; functions</bookmark_value>
- <bookmark_value>functions; text functions</bookmark_value>
- <bookmark_value>Function Wizard;text</bookmark_value>
-</bookmark>
-<paragraph xml-lang="en-US" id="hd_id3145389" role="heading" level="1"
l10n="U" oldref="1"><variable id="head_text"><link
href="text/scalc/01/04060110.xhp" name="Text Functions">Text
Functions</link></variable></paragraph>
- <paragraph xml-lang="en-US" id="par_id3152986" role="paragraph"
l10n="CHG" oldref="2"><variable id="texttext">This section contains
descriptions of the <emph>Text</emph> functions.
-</variable></paragraph>
- <section id="howtoget">
- <embed href="text/scalc/00/00000404.xhp#eikatext"/>
- </section>
+ <topic id="textscalc0104060110xml" indexer="include">
+ <title id="tit" xml-lang="en-US">Text Functions</title>
+ <filename>/text/scalc/01/04060110.xhp</filename>
+ </topic>
+</meta>
+
+<body>
+
+<bookmark xml-lang="en-US" branch="index" id="bm_id3145389">
+ <bookmark_value>text in cells; functions</bookmark_value>
+ <bookmark_value>functions; text functions</bookmark_value>
+ <bookmark_value>Function Wizard;text</bookmark_value>
+</bookmark>
+
+
+<paragraph id="hd_id3145389" role="heading" level="1"
xml-lang="en-US"><variable id="head_text"><link
href="text/scalc/01/04060110.xhp" name="Text Functions">Text
Functions</link></variable></paragraph>
+<paragraph id="par_id3152986" role="paragraph" xml-lang="en-US"><variable
id="texttext">This section contains descriptions of the <emph>Text</emph>
functions. </variable></paragraph>
+
+<section id="howtoget">
+<embed href="text/scalc/00/00000404.xhp#eikatext"/>
+</section>
<sort order="asc">
+
<section id="arabic">
-<bookmark xml-lang="en-US" branch="index"
id="bm_id3149384"><bookmark_value>ARABIC function</bookmark_value>
+<bookmark xml-lang="en-US" branch="index" id="bm_id3149384">
+ <bookmark_value>ARABIC function</bookmark_value>
</bookmark>
+
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ARABISCH" id="bm_id3145359"
localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3149384" role="heading" level="2" l10n="U"
- oldref="239">ARABIC</paragraph>
- <paragraph xml-lang="en-US" id="par_id3153558" role="paragraph"
l10n="U" oldref="240"><ahelp hid="HID_FUNC_ARABISCH">Calculates the value of a
Roman number. The value range must be between 0 and 3999.</ahelp></paragraph>
- <paragraph xml-lang="en-US" id="hd_id3153011" role="heading"
level="3" l10n="U"
- oldref="241">Syntax</paragraph>
- <paragraph xml-lang="en-US" id="par_id3155523" role="code" l10n="U"
oldref="242">ARABIC("Text")</paragraph>
- <paragraph xml-lang="en-US" id="par_id3151193" role="paragraph"
l10n="U" oldref="243">
- <emph>Text</emph> is the text that represents a Roman
number.</paragraph>
- <paragraph xml-lang="en-US" id="hd_id3155758" role="heading"
level="3" l10n="U"
- oldref="244">Example</paragraph>
- <paragraph xml-lang="en-US" id="par_id3154621" role="paragraph"
l10n="U" oldref="245">
- <item type="input">=ARABIC("MXIV")</item> returns 1014</paragraph>
- <paragraph xml-lang="en-US" id="par_id3147553" role="paragraph"
l10n="U" oldref="246">
- <item type="input">=ARABIC("MMII")</item> returns 2002</paragraph>
- </section>
- <section id="asc">
-<bookmark xml-lang="en-US" branch="index"
id="bm_id8796349"><bookmark_value>ASC function</bookmark_value>
-</bookmark><comment>i79585</comment>
+
+<paragraph id="hd_id3149384" role="heading" level="2"
xml-lang="en-US">ARABIC</paragraph>
+<paragraph id="par_id3153558" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_FUNC_ARABISCH">Calculates the value of a Roman number. The value range
must be between 0 and 3999.</ahelp></paragraph>
+
+<paragraph id="hd_id3153011" role="heading" level="3"
xml-lang="en-US">Syntax</paragraph>
+<paragraph id="par_id3155523" role="code"
xml-lang="en-US">ARABIC("Text")</paragraph>
+<paragraph id="par_id3151193" role="paragraph" xml-lang="en-US">
<emph>Text</emph> is the text that represents a Roman number.</paragraph>
+
+<paragraph id="hd_id3155758" role="heading" level="3"
xml-lang="en-US">Example</paragraph>
+<paragraph id="par_id3154621" role="paragraph" xml-lang="en-US"> <item
type="input">=ARABIC("MXIV")</item> returns 1014</paragraph>
+<paragraph id="par_id3147553" role="paragraph" xml-lang="en-US"> <item
type="input">=ARABIC("MMII")</item> returns 2002</paragraph>
+</section>
+
+<section id="asc">
+<bookmark xml-lang="en-US" branch="index" id="bm_id8796349">
+ <bookmark_value>ASC function</bookmark_value>
+</bookmark>
+<comment>i79585</comment>
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ASC" id="bm_id3187353"
localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id7723929" role="heading" level="2"
l10n="NEW">ASC</paragraph>
- <paragraph xml-lang="en-US" id="par_id8455153" role="paragraph"
l10n="NEW"><ahelp hid=".">The ASC function converts full-width to half-width
ASCII and katakana characters. Returns a text string.</ahelp></paragraph>
- <paragraph xml-lang="en-US" id="par_id9912411" role="paragraph"
l10n="NEW">See <link
href="http://wiki.documentfoundation.org/Calc/Features/JIS_and_ASC_functions";>http://wiki.documentfoundation.org/Calc/Features/JIS_and_ASC_functions</link>
for a conversion table.</paragraph>
- <paragraph xml-lang="en-US" id="hd_id9204992" role="heading"
level="3" l10n="NEW">Syntax</paragraph>
- <paragraph xml-lang="en-US" id="par_id1993774" role="code"
l10n="NEW">ASC("Text")</paragraph>
- <paragraph xml-lang="en-US" id="par_id2949919" role="paragraph"
l10n="NEW">
- <emph>Text</emph> is the text that contains characters to be
converted.</paragraph>
- <paragraph xml-lang="en-US" id="par_id2355113" role="paragraph"
l10n="NEW">See also JIS function.</paragraph>
- </section>
- <section id="bahttext">
-<bookmark xml-lang="en-US" branch="index"
id="bm_id9323709"><bookmark_value>BAHTTEXT function</bookmark_value>
+
+<paragraph id="hd_id7723929" role="heading" level="2"
xml-lang="en-US">ASC</paragraph>
+<paragraph id="par_id8455153" role="paragraph" xml-lang="en-US"><ahelp
hid=".">The ASC function converts full-width to half-width ASCII and katakana
characters. Returns a text string.</ahelp></paragraph>
+<paragraph id="par_id9912411" role="paragraph" xml-lang="en-US">See <link
href="http://wiki.documentfoundation.org/Calc/Features/JIS_and_ASC_functions";>http://wiki.documentfoundation.org/Calc/Features/JIS_and_ASC_functions</link>
for a conversion table.</paragraph>
+
+<paragraph id="hd_id9204992" role="heading" level="3"
xml-lang="en-US">Syntax</paragraph>
+<paragraph id="par_id1993774" role="code"
xml-lang="en-US">ASC("Text")</paragraph>
+<paragraph id="par_id2949919" role="paragraph" xml-lang="en-US">
<emph>Text</emph> is the text that contains characters to be
converted.</paragraph>
+<paragraph id="par_id2355113" role="paragraph" xml-lang="en-US">See also JIS
function.</paragraph>
+</section>
+
+<section id="bahttext">
+<bookmark xml-lang="en-US" branch="index" id="bm_id9323709">
+ <bookmark_value>BAHTTEXT function</bookmark_value>
</bookmark>
+
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_BAHTTEXT" id="bm_id744346"
localize="false"/><comment>i66350</comment>
-<paragraph xml-lang="en-US" id="hd_id6695455" role="heading" level="2"
l10n="NEW">BAHTTEXT</paragraph>
- <paragraph xml-lang="en-US" id="par_id354014" role="paragraph"
l10n="NEW">Converts a number to Thai text, including the Thai currency
names.</paragraph>
- <paragraph xml-lang="en-US" id="hd_id9942014" role="heading"
level="3" l10n="NEW">Syntax</paragraph>
- <paragraph xml-lang="en-US" id="par_id8780785" role="code"
l10n="NEW">BAHTTEXT(Number)</paragraph>
- <paragraph xml-lang="en-US" id="par_id1539353" role="paragraph"
l10n="NEW">
- <emph>Number</emph> is any number. "Baht" is appended to the
integral part of the number, and "Satang" is appended to the decimal part of
the number.</paragraph>
- <paragraph xml-lang="en-US" id="hd_id9694814" role="heading"
level="3" l10n="NEW">Example</paragraph>
- <paragraph xml-lang="en-US" id="par_id3289284" role="paragraph"
l10n="NEW">
- <item type="input">=BAHTTEXT(12.65)</item> returns a string in
Thai characters with the meaning of "Twelve Baht and sixty five
Satang".</paragraph>
- </section>
- <section id="base">
-<bookmark xml-lang="en-US" branch="index"
id="bm_id3153072"><bookmark_value>BASE function</bookmark_value>
+
+<paragraph id="hd_id6695455" role="heading" level="2"
xml-lang="en-US">BAHTTEXT</paragraph>
+<paragraph id="par_id354014" role="paragraph" xml-lang="en-US">Converts a
number to Thai text, including the Thai currency names.</paragraph>
+
+<paragraph id="hd_id9942014" role="heading" level="3"
xml-lang="en-US">Syntax</paragraph>
+<paragraph id="par_id8780785" role="code"
xml-lang="en-US">BAHTTEXT(Number)</paragraph>
+<paragraph id="par_id1539353" role="paragraph" xml-lang="en-US">
<emph>Number</emph> is any number. "Baht" is appended to the integral part of
the number, and "Satang" is appended to the decimal part of the
number.</paragraph>
+
+<paragraph id="hd_id9694814" role="heading" level="3"
xml-lang="en-US">Example</paragraph>
+<paragraph id="par_id3289284" role="paragraph" xml-lang="en-US"> <item
type="input">=BAHTTEXT(12.65)</item> returns a string in Thai characters with
the meaning of "Twelve Baht and sixty five Satang".</paragraph>
+</section>
+
+<section id="base">
+<bookmark xml-lang="en-US" branch="index" id="bm_id3153072">
+ <bookmark_value>BASE function</bookmark_value>
</bookmark>
+
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_BASIS" id="bm_id3150957"
localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3153072" role="heading" level="2" l10n="U"
- oldref="213">BASE</paragraph>
- <paragraph xml-lang="en-US" id="par_id3153289" role="paragraph"
l10n="U" oldref="214"><ahelp hid="HID_FUNC_BASIS">Converts a positive integer
to a specified base into a text from the <link
href="text/shared/00/00000005.xhp#zahlensystem" name="numbering
system">numbering system</link>.</ahelp> The digits 0-9 and the letters A-Z are
used.</paragraph>
- <paragraph xml-lang="en-US" id="hd_id3146097" role="heading"
level="3" l10n="U"
- oldref="215">Syntax</paragraph>
- <paragraph xml-lang="en-US" id="par_id3155743" role="code" l10n="U"
oldref="216">BASE(Number; Radix; [MinimumLength])</paragraph>
- <paragraph xml-lang="en-US" id="par_id3151339" role="paragraph"
l10n="U" oldref="217">
- <emph>Number</emph> is the positive integer to be
converted.</paragraph>
- <paragraph xml-lang="en-US" id="par_id3159262" role="paragraph"
l10n="U" oldref="218">
- <emph>Radix</emph> indicates the base of the number system. It may
be any positive integer between 2 and 36.</paragraph>
- <paragraph xml-lang="en-US" id="par_id3148746" role="paragraph"
l10n="U" oldref="219">
- <emph>MinimumLength</emph> (optional) determines the minimum
length of the character sequence that has been created. If the text is shorter
than the indicated minimum length, zeros are added to the left of the
string.</paragraph>
- <paragraph xml-lang="en-US" id="hd_id3146323" role="heading"
level="3" l10n="U"
- oldref="220">Example</paragraph>
-<bookmark xml-lang="en-US" branch="index"
id="bm_id3156399"><bookmark_value>decimal system; converting to</bookmark_value>
-</bookmark>
-<paragraph xml-lang="en-US" id="par_id3156399" role="paragraph" l10n="U"
oldref="221">
- <item type="input">=BASE(17;10;4)</item> returns 0017 in the
decimal system.</paragraph>
-<bookmark xml-lang="en-US" branch="index"
id="bm_id3157871"><bookmark_value>binary system; converting to</bookmark_value>
-</bookmark>
-<paragraph xml-lang="en-US" id="par_id3157871" role="paragraph" l10n="U"
oldref="222">
- <item type="input">=BASE(17;2)</item> returns 10001 in the binary
system.</paragraph>
-<bookmark xml-lang="en-US" branch="index"
id="bm_id3145226"><bookmark_value>hexadecimal system; converting
to</bookmark_value>
-</bookmark>
-<paragraph xml-lang="en-US" id="par_id3145226" role="paragraph" l10n="U"
oldref="223">
- <item type="input">=BASE(255;16;4)</item> returns 00FF in the
hexadecimal system.</paragraph>
- </section>
- <section id="char">
-<bookmark xml-lang="en-US" branch="index"
id="bm_id3149321"><bookmark_value>CHAR function</bookmark_value>
+
+<paragraph id="hd_id3153072" role="heading" level="2"
xml-lang="en-US">BASE</paragraph>
+<paragraph id="par_id3153289" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_FUNC_BASIS">Converts a positive integer to a specified base into a
text from the <link href="text/shared/00/00000005.xhp#zahlensystem"
name="numbering system">numbering system</link>.</ahelp> The digits 0-9 and the
letters A-Z are used.</paragraph>
+
+<paragraph id="hd_id3146097" role="heading" level="3"
xml-lang="en-US">Syntax</paragraph>
+<paragraph id="par_id3155743" role="code" xml-lang="en-US">BASE(Number; Radix;
[MinimumLength])</paragraph>
+<paragraph id="par_id3151339" role="paragraph" xml-lang="en-US">
<emph>Number</emph> is the positive integer to be converted.</paragraph>
+<paragraph id="par_id3159262" role="paragraph" xml-lang="en-US">
<emph>Radix</emph> indicates the base of the number system. It may be any
positive integer between 2 and 36.</paragraph>
+<paragraph id="par_id3148746" role="paragraph" xml-lang="en-US">
<emph>MinimumLength</emph> (optional) determines the minimum length of the
character sequence that has been created. If the text is shorter than the
indicated minimum length, zeros are added to the left of the string.</paragraph>
+
+<paragraph id="hd_id3146323" role="heading" level="3"
xml-lang="en-US">Example</paragraph>
+<bookmark xml-lang="en-US" branch="index" id="bm_id3156399">
+ <bookmark_value>decimal system; converting to</bookmark_value>
+</bookmark>
+
+<paragraph id="par_id3156399" role="paragraph" xml-lang="en-US"> <item
type="input">=BASE(17;10;4)</item> returns 0017 in the decimal
system.</paragraph>
+<bookmark xml-lang="en-US" branch="index" id="bm_id3157871">
+ <bookmark_value>binary system; converting to</bookmark_value>
+</bookmark>
+
+<paragraph id="par_id3157871" role="paragraph" xml-lang="en-US"> <item
type="input">=BASE(17;2)</item> returns 10001 in the binary system.</paragraph>
+<bookmark xml-lang="en-US" branch="index" id="bm_id3145226">
+ <bookmark_value>hexadecimal system; converting to</bookmark_value>
</bookmark>
+
+<paragraph id="par_id3145226" role="paragraph" xml-lang="en-US"> <item
type="input">=BASE(255;16;4)</item> returns 00FF in the hexadecimal
system.</paragraph>
+</section>
+
+<section id="char">
+<bookmark xml-lang="en-US" branch="index" id="bm_id3149321">
+ <bookmark_value>CHAR function</bookmark_value>
+</bookmark>
+
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ZEICHEN" id="bm_id3159128"
localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3149321" role="heading" level="2" l10n="U"
- oldref="201">CHAR</paragraph>
- <paragraph xml-lang="en-US" id="par_id3149150" role="paragraph"
l10n="U" oldref="202"><ahelp hid="HID_FUNC_ZEICHEN">Converts a number into a
character according to the current code table.</ahelp> The number can be a
two-digit or three-digit integer number.</paragraph>
- <embed href="text/scalc/00/00000004.xhp#codes"/>
- <paragraph xml-lang="en-US" id="hd_id3149945" role="heading"
level="3" l10n="U"
- oldref="203">Syntax</paragraph>
- <paragraph xml-lang="en-US" id="par_id3145634" role="code" l10n="U"
oldref="204">CHAR(Number)</paragraph>
- <paragraph xml-lang="en-US" id="par_id3155906" role="paragraph"
l10n="U" oldref="205">
- <emph>Number</emph> is a number between 1 and 255 representing the
code value for the character.</paragraph>
- <paragraph xml-lang="en-US" id="hd_id3152982" role="heading"
level="3" l10n="U"
- oldref="207">Example</paragraph>
- <paragraph xml-lang="en-US" id="par_id3149890" role="paragraph"
l10n="CHG" oldref="208">
- <item type="input">=CHAR(100)</item> returns the character
d.</paragraph>
- <paragraph xml-lang="en-US" id="par_id0907200910283297"
role="paragraph" l10n="NEW">="abc" & CHAR(10) & "def" inserts a newline
character into the string.</paragraph>
- </section>
- <section id="clean">
-<bookmark xml-lang="en-US" branch="index"
id="bm_id3149009"><bookmark_value>CLEAN function</bookmark_value>
+
+<paragraph id="hd_id3149321" role="heading" level="2"
xml-lang="en-US">CHAR</paragraph>
+<paragraph id="par_id3149150" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_FUNC_ZEICHEN">Converts a number into a character according to the
current code table.</ahelp> The number can be a two-digit or three-digit
integer number.</paragraph>
+<embed href="text/scalc/00/00000004.xhp#codes"/>
+
+<paragraph id="hd_id3149945" role="heading" level="3"
xml-lang="en-US">Syntax</paragraph>
+<paragraph id="par_id3145634" role="code"
xml-lang="en-US">CHAR(Number)</paragraph>
+<paragraph id="par_id3155906" role="paragraph" xml-lang="en-US">
<emph>Number</emph> is a number between 1 and 255 representing the code value
for the character.</paragraph>
+
+<paragraph id="hd_id3152982" role="heading" level="3"
xml-lang="en-US">Example</paragraph>
+<paragraph id="par_id3149890" role="paragraph" xml-lang="en-US"> <item
type="input">=CHAR(100)</item> returns the character d.</paragraph>
+<paragraph id="par_id0907200910283297" role="paragraph"
xml-lang="en-US">="abc" & CHAR(10) & "def" inserts a newline character
into the string.</paragraph>
+</section>
+
+<section id="clean">
+<bookmark xml-lang="en-US" branch="index" id="bm_id3149009">
+ <bookmark_value>CLEAN function</bookmark_value>
</bookmark>
+
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_SAEUBERN" id="bm_id3148729"
localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3149009" role="heading" level="2" l10n="U"
- oldref="132">CLEAN</paragraph>
- <paragraph xml-lang="en-US" id="par_id3150482" role="paragraph"
l10n="U" oldref="133"><ahelp hid="HID_FUNC_SAEUBERN">All non-printing
characters are removed from the string.</ahelp></paragraph>
- <paragraph xml-lang="en-US" id="hd_id3146880" role="heading"
level="3" l10n="U"
- oldref="134">Syntax</paragraph>
- <paragraph xml-lang="en-US" id="par_id3147472" role="code" l10n="U"
oldref="135">CLEAN("Text")</paragraph>
- <paragraph xml-lang="en-US" id="par_id3150695" role="paragraph"
l10n="U" oldref="136">
- <emph>Text</emph> refers to the text from which to remove all
non-printable characters.</paragraph>
- </section>
- <section id="code">
-<bookmark xml-lang="en-US" branch="index"
id="bm_id3155498"><bookmark_value>CODE function</bookmark_value>
+
+<paragraph id="hd_id3149009" role="heading" level="2"
xml-lang="en-US">CLEAN</paragraph>
+<paragraph id="par_id3150482" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_FUNC_SAEUBERN">All non-printing characters are removed from the
string.</ahelp></paragraph>
+
+<paragraph id="hd_id3146880" role="heading" level="3"
xml-lang="en-US">Syntax</paragraph>
+<paragraph id="par_id3147472" role="code"
xml-lang="en-US">CLEAN("Text")</paragraph>
+<paragraph id="par_id3150695" role="paragraph" xml-lang="en-US">
<emph>Text</emph> refers to the text from which to remove all non-printable
characters.</paragraph>
+</section>
+
+<section id="code">
+<bookmark xml-lang="en-US" branch="index" id="bm_id3155498">
+ <bookmark_value>CODE function</bookmark_value>
</bookmark>
+
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_CODE" id="bm_id3159084"
localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3155498" role="heading" level="2"
l10n="U" oldref="3">CODE</paragraph>
- <paragraph xml-lang="en-US" id="par_id3152770" role="paragraph"
l10n="U" oldref="4"><ahelp hid="HID_FUNC_CODE">Returns a numeric code for the
first character in a text string.</ahelp></paragraph>
- <paragraph xml-lang="en-US" id="hd_id3155830" role="heading"
level="3" l10n="U" oldref="5">Syntax</paragraph>
- <paragraph xml-lang="en-US" id="par_id3149188" role="code" l10n="U"
oldref="6">CODE("Text")</paragraph>
- <paragraph xml-lang="en-US" id="par_id3154383" role="paragraph"
l10n="U" oldref="7">
- <emph>Text</emph> is the text for which the code of the first
character is to be found.</paragraph>
- <embed href="text/scalc/00/00000004.xhp#codes"/>
- <paragraph xml-lang="en-US" id="hd_id3154394" role="heading"
level="3" l10n="U" oldref="8">Example</paragraph>
- <paragraph xml-lang="en-US" id="par_id3159209" role="paragraph"
l10n="U" oldref="9">
- <item type="input">=CODE("Hieronymus")</item> returns 72, <item
type="input">=CODE("hieroglyphic")</item> returns 104.</paragraph>
- <paragraph xml-lang="en-US" id="par_id3150280" role="note" l10n="U"
oldref="211">The code used here does not refer to ASCII, but to the code table
currently loaded.</paragraph>
- </section>
- <section id="concatenate">
-<bookmark xml-lang="en-US" branch="index"
id="bm_id3149688"><bookmark_value>CONCATENATE function</bookmark_value>
+
+<paragraph id="hd_id3155498" role="heading" level="2"
xml-lang="en-US">CODE</paragraph>
+<paragraph id="par_id3152770" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_FUNC_CODE">Returns a numeric code for the first character in a text
string.</ahelp></paragraph>
+
+<paragraph id="hd_id3155830" role="heading" level="3"
xml-lang="en-US">Syntax</paragraph>
+<paragraph id="par_id3149188" role="code"
xml-lang="en-US">CODE("Text")</paragraph>
+<paragraph id="par_id3154383" role="paragraph" xml-lang="en-US">
<emph>Text</emph> is the text for which the code of the first character is to
be found.</paragraph>
+<embed href="text/scalc/00/00000004.xhp#codes"/>
+
+<paragraph id="hd_id3154394" role="heading" level="3"
xml-lang="en-US">Example</paragraph>
+<paragraph id="par_id3159209" role="paragraph" xml-lang="en-US"> <item
type="input">=CODE("Hieronymus")</item> returns 72, <item
type="input">=CODE("hieroglyphic")</item> returns 104.</paragraph>
+<paragraph id="par_id3150280" role="note" xml-lang="en-US">The code used here
does not refer to ASCII, but to the code table currently loaded.</paragraph>
+</section>
+
+<section id="concatenate">
+<bookmark xml-lang="en-US" branch="index" id="bm_id3149688">
+ <bookmark_value>CONCATENATE function</bookmark_value>
</bookmark>
+
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_VERKETTEN"
id="bm_id3153084" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3149688" role="heading" level="2" l10n="U"
- oldref="167">CONCATENATE</paragraph>
- <paragraph xml-lang="en-US" id="par_id3154524" role="paragraph"
l10n="U" oldref="168"><ahelp hid="HID_FUNC_VERKETTEN">Combines several text
strings into one string.</ahelp></paragraph>
- <paragraph xml-lang="en-US" id="hd_id3149542" role="heading"
level="3" l10n="U"
- oldref="169">Syntax</paragraph>
- <paragraph xml-lang="en-US" id="par_id3155954" role="code" l10n="U"
oldref="170">CONCATENATE("Text1"; ...; "Text30")</paragraph>
- <paragraph xml-lang="en-US" id="par_id3146847" role="paragraph"
l10n="U" oldref="171">
- <emph>Text 1; Text 2; ...</emph> represent up to 30 text passages
which are to be combined into one string.</paragraph>
- <paragraph xml-lang="en-US" id="hd_id3153110" role="heading"
level="3" l10n="U"
- oldref="172">Example</paragraph>
- <paragraph xml-lang="en-US" id="par_id3150008" role="paragraph"
l10n="U" oldref="173">
- <item type="input">=CONCATENATE("Good ";"Morning ";"Mrs.
";"Doe")</item> returns: Good Morning Mrs. Doe.</paragraph>
- </section>
- <section id="decimal">
-<bookmark xml-lang="en-US" branch="index"
id="bm_id3145166"><bookmark_value>DECIMAL function</bookmark_value>
+
+<paragraph id="hd_id3149688" role="heading" level="2"
xml-lang="en-US">CONCATENATE</paragraph>
+<paragraph id="par_id3154524" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_FUNC_VERKETTEN">Combines several text strings into one
string.</ahelp></paragraph>
+
+<paragraph id="hd_id3149542" role="heading" level="3"
xml-lang="en-US">Syntax</paragraph>
+<paragraph id="par_id3155954" role="code"
xml-lang="en-US">CONCATENATE("Text1"; ...; "Text30")</paragraph>
+<paragraph id="par_id3146847" role="paragraph" xml-lang="en-US"> <emph>Text 1;
Text 2; ...</emph> represent up to 30 text passages which are to be combined
into one string.</paragraph>
+
+<paragraph id="hd_id3153110" role="heading" level="3"
xml-lang="en-US">Example</paragraph>
+<paragraph id="par_id3150008" role="paragraph" xml-lang="en-US"> <item
type="input">=CONCATENATE("Good ";"Morning ";"Mrs. ";"Doe")</item> returns:
Good Morning Mrs. Doe.</paragraph>
+</section>
+
+<section id="decimal">
+<bookmark xml-lang="en-US" branch="index" id="bm_id3145166">
+ <bookmark_value>DECIMAL function</bookmark_value>
</bookmark>
+
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_DEZIMAL" id="bm_id3150338"
localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3145166" role="heading" level="2" l10n="U"
- oldref="225">DECIMAL</paragraph>
- <paragraph xml-lang="en-US" id="par_id3156361" role="paragraph"
l10n="U" oldref="226"><ahelp hid="HID_FUNC_DEZIMAL">Converts text with
characters from a <link href="text/shared/00/00000005.xhp#zahlensystem"
name="number system">number system</link> to a positive integer in the base
radix given.</ahelp> The radix must be in the range 2 to 36. Spaces and tabs
are ignored. The <emph>Text</emph> field is not case-sensitive.</paragraph>
- <paragraph xml-lang="en-US" id="par_id3157994" role="paragraph"
l10n="U" oldref="227">If the radix is 16, a leading x or X or 0x or 0X, and an
appended h or H, is disregarded. If the radix is 2, an appended b or B is
disregarded. Other characters that do not belong to the number system generate
an error.</paragraph>
- <paragraph xml-lang="en-US" id="hd_id3150014" role="heading"
level="3" l10n="U"
- oldref="228">Syntax</paragraph>
- <paragraph xml-lang="en-US" id="par_id3154328" role="code" l10n="U"
oldref="229">DECIMAL("Text"; Radix)</paragraph>
- <paragraph xml-lang="en-US" id="par_id3150128" role="paragraph"
l10n="U" oldref="230">
- <emph>Text</emph> is the text to be converted. To differentiate
between a hexadecimal number, such as A1 and the reference to cell A1, you must
place the number in quotation marks, for example, "A1" or "FACE".</paragraph>
- <paragraph xml-lang="en-US" id="par_id3145241" role="paragraph"
l10n="U" oldref="231">
- <emph>Radix</emph> indicates the base of the number system. It may
be any positive integer between 2 and 36.</paragraph>
- <paragraph xml-lang="en-US" id="hd_id3156062" role="heading"
level="3" l10n="U"
- oldref="232">Example</paragraph>
- <paragraph xml-lang="en-US" id="par_id3145355" role="paragraph"
l10n="U" oldref="233">
- <item type="input">=DECIMAL("17";10)</item> returns 17.</paragraph>
- <paragraph xml-lang="en-US" id="par_id3155622" role="paragraph"
l10n="U" oldref="234">
- <item type="input">=DECIMAL("FACE";16)</item> returns
64206.</paragraph>
- <paragraph xml-lang="en-US" id="par_id3151015" role="paragraph"
l10n="U" oldref="235">
- <item type="input">=DECIMAL("0101";2)</item> returns 5.</paragraph>
- </section>
- <section id="dollar">
-<bookmark xml-lang="en-US" branch="index"
id="bm_id3148402"><bookmark_value>DOLLAR function</bookmark_value>
+
+<paragraph id="hd_id3145166" role="heading" level="2"
xml-lang="en-US">DECIMAL</paragraph>
+<paragraph id="par_id3156361" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_FUNC_DEZIMAL">Converts text with characters from a <link
href="text/shared/00/00000005.xhp#zahlensystem" name="number system">number
system</link> to a positive integer in the base radix given.</ahelp> The radix
must be in the range 2 to 36. Spaces and tabs are ignored. The
<emph>Text</emph> field is not case-sensitive.</paragraph>
+<paragraph id="par_id3157994" role="paragraph" xml-lang="en-US">If the radix
is 16, a leading x or X or 0x or 0X, and an appended h or H, is disregarded. If
the radix is 2, an appended b or B is disregarded. Other characters that do not
belong to the number system generate an error.</paragraph>
+
+<paragraph id="hd_id3150014" role="heading" level="3"
xml-lang="en-US">Syntax</paragraph>
+<paragraph id="par_id3154328" role="code" xml-lang="en-US">DECIMAL("Text";
Radix)</paragraph>
+<paragraph id="par_id3150128" role="paragraph" xml-lang="en-US">
<emph>Text</emph> is the text to be converted. To differentiate between a
hexadecimal number, such as A1 and the reference to cell A1, you must place the
number in quotation marks, for example, "A1" or "FACE".</paragraph>
+<paragraph id="par_id3145241" role="paragraph" xml-lang="en-US">
<emph>Radix</emph> indicates the base of the number system. It may be any
positive integer between 2 and 36.</paragraph>
+
+<paragraph id="hd_id3156062" role="heading" level="3"
xml-lang="en-US">Example</paragraph>
+<paragraph id="par_id3145355" role="paragraph" xml-lang="en-US"> <item
type="input">=DECIMAL("17";10)</item> returns 17.</paragraph>
+<paragraph id="par_id3155622" role="paragraph" xml-lang="en-US"> <item
type="input">=DECIMAL("FACE";16)</item> returns 64206.</paragraph>
+<paragraph id="par_id3151015" role="paragraph" xml-lang="en-US"> <item
type="input">=DECIMAL("0101";2)</item> returns 5.</paragraph>
+</section>
+
+<section id="dollar">
+<bookmark xml-lang="en-US" branch="index" id="bm_id3148402">
+ <bookmark_value>DOLLAR function</bookmark_value>
</bookmark>
+
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_DM" id="bm_id3149532"
localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3148402" role="heading" level="2" l10n="U"
- oldref="11">DOLLAR</paragraph>
- <paragraph xml-lang="en-US" id="par_id3153049" role="paragraph"
l10n="U" oldref="12"><ahelp hid="HID_FUNC_DM">Converts a number to an amount in
the currency format, rounded to a specified decimal place.</ahelp> In the <item
type="literal">Value</item> field enter the number to be converted to currency.
Optionally, you may enter the number of decimal places in the <item
type="literal">Decimals</item> field. If no value is specified, all numbers in
currency format will be displayed with two decimal places. </paragraph>
- <paragraph xml-lang="en-US" id="par_id3151280" role="paragraph"
l10n="U" oldref="263">You set the currency format in your system
settings.</paragraph>
- <paragraph xml-lang="en-US" id="hd_id3150569" role="heading"
level="3" l10n="U"
- oldref="13">Syntax</paragraph>
- <paragraph xml-lang="en-US" id="par_id3154188" role="code" l10n="U"
oldref="14">DOLLAR(Value; Decimals)</paragraph>
- <paragraph xml-lang="en-US" id="par_id3145299" role="paragraph"
l10n="U" oldref="15">
- <emph>Value</emph> is a number, a reference to a cell containing a
number, or a formula which returns a number.</paragraph>
- <paragraph xml-lang="en-US" id="par_id3145629" role="paragraph"
l10n="CHG" oldref="16">
- <emph>Decimals</emph> is the optional number of decimal
places.</paragraph>
- <paragraph xml-lang="en-US" id="hd_id3149030" role="heading"
level="3" l10n="U"
- oldref="17">Example</paragraph>
- <paragraph xml-lang="en-US" id="par_id3153546" role="paragraph"
l10n="U" oldref="18">
- <item type="input">=DOLLAR(255)</item> returns $255.00.</paragraph>
- <paragraph xml-lang="en-US" id="par_id3154635" role="paragraph"
l10n="U" oldref="19">
- <item type="input">=DOLLAR(367.456;2)</item> returns $367.46. Use
the decimal separator that corresponds to the <link
href="text/shared/optionen/01140000.xhp" name="current locale setting">current
locale setting</link>.</paragraph>
- </section>
- <section id="exact">
-<bookmark xml-lang="en-US" branch="index"
id="bm_id3150685"><bookmark_value>EXACT function</bookmark_value>
+
+<paragraph id="hd_id3148402" role="heading" level="2"
xml-lang="en-US">DOLLAR</paragraph>
+<paragraph id="par_id3153049" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_FUNC_DM">Converts a number to an amount in the currency format,
rounded to a specified decimal place.</ahelp> In the <item
type="literal">Value</item> field enter the number to be converted to currency.
Optionally, you may enter the number of decimal places in the <item
type="literal">Decimals</item> field. If no value is specified, all numbers in
currency format will be displayed with two decimal places. </paragraph>
+<paragraph id="par_id3151280" role="paragraph" xml-lang="en-US">You set the
currency format in your system settings.</paragraph>
+
+<paragraph id="hd_id3150569" role="heading" level="3"
xml-lang="en-US">Syntax</paragraph>
+<paragraph id="par_id3154188" role="code" xml-lang="en-US">DOLLAR(Value;
Decimals)</paragraph>
+<paragraph id="par_id3145299" role="paragraph" xml-lang="en-US">
<emph>Value</emph> is a number, a reference to a cell containing a number, or a
formula which returns a number.</paragraph>
+<paragraph id="par_id3145629" role="paragraph" xml-lang="en-US">
<emph>Decimals</emph> is the optional number of decimal places.</paragraph>
+
+<paragraph id="hd_id3149030" role="heading" level="3"
xml-lang="en-US">Example</paragraph>
+<paragraph id="par_id3153546" role="paragraph" xml-lang="en-US"> <item
type="input">=DOLLAR(255)</item> returns $255.00.</paragraph>
+<paragraph id="par_id3154635" role="paragraph" xml-lang="en-US"> <item
type="input">=DOLLAR(367.456;2)</item> returns $367.46. Use the decimal
separator that corresponds to the <link
href="text/shared/optionen/01140000.xhp" name="current locale setting">current
locale setting</link>.</paragraph>
+</section>
+
+<section id="exact">
+<bookmark xml-lang="en-US" branch="index" id="bm_id3150685">
+ <bookmark_value>EXACT function</bookmark_value>
</bookmark>
+
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_IDENTISCH"
id="bm_id3155081" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3150685" role="heading" level="2" l10n="U"
- oldref="78">EXACT</paragraph>
- <paragraph xml-lang="en-US" id="par_id3158413" role="paragraph"
l10n="U" oldref="79"><ahelp hid="HID_FUNC_IDENTISCH">Compares two text strings
and returns TRUE if they are identical.</ahelp> This function is
case-sensitive.</paragraph>
- <paragraph xml-lang="en-US" id="hd_id3152817" role="heading"
level="3" l10n="U"
- oldref="80">Syntax</paragraph>
- <paragraph xml-lang="en-US" id="par_id3148594" role="code" l10n="U"
oldref="81">EXACT("Text1"; "Text2")</paragraph>
- <paragraph xml-lang="en-US" id="par_id3153224" role="paragraph"
l10n="U" oldref="82">
- <emph>Text1</emph> refers to the first text to compare.</paragraph>
- <paragraph xml-lang="en-US" id="par_id3148637" role="paragraph"
l10n="U" oldref="83">
- <emph>Text2</emph> is the second text to compare.</paragraph>
- <paragraph xml-lang="en-US" id="hd_id3149777" role="heading"
level="3" l10n="U"
- oldref="84">Example</paragraph>
- <paragraph xml-lang="en-US" id="par_id3156263" role="paragraph"
l10n="U" oldref="85">
- <item type="input">=EXACT("microsystems";"Microsystems")</item>
returns FALSE.</paragraph>
- </section>
- <section id="find">
-<bookmark xml-lang="en-US" branch="index"
id="bm_id3152589"><bookmark_value>FIND function</bookmark_value>
+
+<paragraph id="hd_id3150685" role="heading" level="2"
xml-lang="en-US">EXACT</paragraph>
+<paragraph id="par_id3158413" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_FUNC_IDENTISCH">Compares two text strings and returns TRUE if they are
identical.</ahelp> This function is case-sensitive.</paragraph>
+
+<paragraph id="hd_id3152817" role="heading" level="3"
xml-lang="en-US">Syntax</paragraph>
+<paragraph id="par_id3148594" role="code" xml-lang="en-US">EXACT("Text1";
"Text2")</paragraph>
+<paragraph id="par_id3153224" role="paragraph" xml-lang="en-US">
<emph>Text1</emph> refers to the first text to compare.</paragraph>
+<paragraph id="par_id3148637" role="paragraph" xml-lang="en-US">
<emph>Text2</emph> is the second text to compare.</paragraph>
+
+<paragraph id="hd_id3149777" role="heading" level="3"
xml-lang="en-US">Example</paragraph>
+<paragraph id="par_id3156263" role="paragraph" xml-lang="en-US"> <item
type="input">=EXACT("microsystems";"Microsystems")</item> returns
FALSE.</paragraph>
+</section>
+
+<section id="find">
+<bookmark xml-lang="en-US" branch="index" id="bm_id3152589">
+ <bookmark_value>FIND function</bookmark_value>
</bookmark>
+
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_FINDEN" id="bm_id3147482"
localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3152589" role="heading" level="2" l10n="U"
- oldref="44">FIND</paragraph>
- <paragraph xml-lang="en-US" id="par_id3146149" role="paragraph"
l10n="U" oldref="45"><ahelp hid="HID_FUNC_FINDEN">Looks for a string of text
within another string.</ahelp> You can also define where to begin the search.
The search term can be a number or any string of characters. The search is
case-sensitive.</paragraph>
- <paragraph xml-lang="en-US" id="hd_id3083284" role="heading"
level="3" l10n="U"
- oldref="46">Syntax</paragraph>
- <paragraph xml-lang="en-US" id="par_id3083452" role="code" l10n="U"
oldref="47">FIND("FindText"; "Text"; Position)</paragraph>
- <paragraph xml-lang="en-US" id="par_id3150608" role="paragraph"
l10n="U" oldref="48">
- <emph>FindText</emph> refers to the text to be found.</paragraph>
- <paragraph xml-lang="en-US" id="par_id3152374" role="paragraph"
l10n="U" oldref="49">
- <emph>Text</emph> is the text where the search takes
place.</paragraph>
- <paragraph xml-lang="en-US" id="par_id3152475" role="paragraph"
l10n="U" oldref="50">
- <emph>Position</emph> (optional) is the position in the text from
which the search starts.</paragraph>
- <paragraph xml-lang="en-US" id="hd_id3154812" role="heading"
level="3" l10n="U"
- oldref="51">Example</paragraph>
- <paragraph xml-lang="en-US" id="par_id3156375" role="paragraph"
l10n="U" oldref="52">
- <item type="input">=FIND(76;998877665544)</item> returns
6.</paragraph>
- </section>
- <section id="fixed">
-<bookmark xml-lang="en-US" branch="index"
id="bm_id3149268"><bookmark_value>FIXED function</bookmark_value>
+
+<paragraph id="hd_id3152589" role="heading" level="2"
xml-lang="en-US">FIND</paragraph>
+<paragraph id="par_id3146149" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_FUNC_FINDEN">Looks for a string of text within another string.</ahelp>
You can also define where to begin the search. The search term can be a number
or any string of characters. The search is case-sensitive.</paragraph>
+
+<paragraph id="hd_id3083284" role="heading" level="3"
xml-lang="en-US">Syntax</paragraph>
+<paragraph id="par_id3083452" role="code" xml-lang="en-US">FIND("FindText";
"Text"; Position)</paragraph>
+<paragraph id="par_id3150608" role="paragraph" xml-lang="en-US">
<emph>FindText</emph> refers to the text to be found.</paragraph>
+<paragraph id="par_id3152374" role="paragraph" xml-lang="en-US">
<emph>Text</emph> is the text where the search takes place.</paragraph>
+<paragraph id="par_id3152475" role="paragraph" xml-lang="en-US">
<emph>Position</emph> (optional) is the position in the text from which the
search starts.</paragraph>
+
+<paragraph id="hd_id3154812" role="heading" level="3"
xml-lang="en-US">Example</paragraph>
+<paragraph id="par_id3156375" role="paragraph" xml-lang="en-US"> <item
type="input">=FIND(76;998877665544)</item> returns 6.</paragraph>
+</section>
+
+<section id="fixed">
+<bookmark xml-lang="en-US" branch="index" id="bm_id3149268">
+ <bookmark_value>FIXED function</bookmark_value>
</bookmark>
+
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_FEST" id="bm_id3149450"
localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3149268" role="heading" level="2" l10n="U"
- oldref="34">FIXED</paragraph>
- <paragraph xml-lang="en-US" id="par_id3155833" role="paragraph"
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 xml-lang="en-US" id="hd_id3152470" role="heading"
level="3" l10n="U"
- oldref="36">Syntax</paragraph>
- <paragraph xml-lang="en-US" id="par_id3147567" role="code" l10n="U"
oldref="37">FIXED(Number; Decimals; NoThousandsSeparators)</paragraph>
- <paragraph xml-lang="en-US" id="par_id3151272" role="paragraph"
l10n="U" oldref="38">
- <emph>Number</emph> refers to the number to be
formatted.</paragraph>
- <paragraph xml-lang="en-US" id="par_id3156322" role="paragraph"
l10n="U" oldref="39">
- <emph>Decimals</emph> refers to the number of decimal places to be
displayed.</paragraph>
- <paragraph xml-lang="en-US" id="par_id3150877" role="paragraph"
l10n="U" oldref="40">
- <emph>NoThousandsSeparators</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 xml-lang="en-US" id="hd_id3149040" role="heading"
level="3" l10n="U"
- oldref="41">Example</paragraph>
- <paragraph xml-lang="en-US" id="par_id3145208" role="paragraph"
l10n="CHG" oldref="42">
- <item type="input">=FIXED(1234567.89;3)</item> returns
1,234,567.890 as a text string. </paragraph>
- <paragraph xml-lang="en-US" id="par_id5282143" role="paragraph"
l10n="NEW">
- <item type="input">=FIXED(1234567.89;3;1)</item> returns
1234567.890 as a text string.</paragraph>
- </section>
- <section id="jis">
-<bookmark xml-lang="en-US" branch="index"
id="bm_id7319864"><bookmark_value>JIS function</bookmark_value>
+
+<paragraph id="hd_id3149268" role="heading" level="2"
xml-lang="en-US">FIXED</paragraph>
+<paragraph id="par_id3155833" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_FUNC_FEST">Returns a number as text with a specified number of decimal
places and optional thousands separators.</ahelp></paragraph>
+
+<paragraph id="hd_id3152470" role="heading" level="3"
xml-lang="en-US">Syntax</paragraph>
+<paragraph id="par_id3147567" role="code" xml-lang="en-US">FIXED(Number;
Decimals; NoThousandsSeparators)</paragraph>
+<paragraph id="par_id3151272" role="paragraph" xml-lang="en-US">
<emph>Number</emph> refers to the number to be formatted.</paragraph>
+<paragraph id="par_id3156322" role="paragraph" xml-lang="en-US">
<emph>Decimals</emph> refers to the number of decimal places to be
displayed.</paragraph>
+<paragraph id="par_id3150877" role="paragraph" xml-lang="en-US">
<emph>NoThousandsSeparators</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 id="hd_id3149040" role="heading" level="3"
xml-lang="en-US">Example</paragraph>
+<paragraph id="par_id3145208" role="paragraph" xml-lang="en-US"> <item
type="input">=FIXED(1234567.89;3)</item> returns 1,234,567.890 as a text
string. </paragraph>
+<paragraph id="par_id5282143" role="paragraph" xml-lang="en-US"> <item
type="input">=FIXED(1234567.89;3;1)</item> returns 1234567.890 as a text
string.</paragraph>
+</section>
+
+<section id="jis">
+<bookmark xml-lang="en-US" branch="index" id="bm_id7319864">
+ <bookmark_value>JIS function</bookmark_value>
</bookmark>
+
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_JIS" id="bm_id3818475"
localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3666188" role="heading" level="2"
l10n="NEW">JIS</paragraph>
- <paragraph xml-lang="en-US" id="par_id964384" role="paragraph"
l10n="NEW"><ahelp hid=".">The JIS function converts half-width to full-width
ASCII and katakana characters. Returns a text string.</ahelp></paragraph>
- <paragraph xml-lang="en-US" id="par_id1551561" role="paragraph"
l10n="NEW">See <link
href="http://wiki.documentfoundation.org/Calc/Features/JIS_and_ASC_functions";>http://wiki.documentfoundation.org/Calc/Features/JIS_and_ASC_functions</link>
for a conversion table.</paragraph>
- <paragraph xml-lang="en-US" id="hd_id2212897" role="heading"
level="3" l10n="NEW">Syntax</paragraph>
- <paragraph xml-lang="en-US" id="par_id2504654" role="code"
l10n="NEW">JIS("Text")</paragraph>
- <paragraph xml-lang="en-US" id="par_id5292519" role="paragraph"
l10n="NEW">
- <emph>Text</emph> is the text that contains characters to be
converted.</paragraph>
- <paragraph xml-lang="en-US" id="par_id3984496" role="paragraph"
l10n="NEW">See also ASC function.</paragraph>
- </section>
- <section id="left">
-<bookmark xml-lang="en-US" branch="index"
id="bm_id3147083"><bookmark_value>LEFT function</bookmark_value>
+
+<paragraph id="hd_id3666188" role="heading" level="2"
xml-lang="en-US">JIS</paragraph>
+<paragraph id="par_id964384" role="paragraph" xml-lang="en-US"><ahelp
hid=".">The JIS function converts half-width to full-width ASCII and katakana
characters. Returns a text string.</ahelp></paragraph>
+<paragraph id="par_id1551561" role="paragraph" xml-lang="en-US">See <link
href="http://wiki.documentfoundation.org/Calc/Features/JIS_and_ASC_functions";>http://wiki.documentfoundation.org/Calc/Features/JIS_and_ASC_functions</link>
for a conversion table.</paragraph>
+
+<paragraph id="hd_id2212897" role="heading" level="3"
xml-lang="en-US">Syntax</paragraph>
+<paragraph id="par_id2504654" role="code"
xml-lang="en-US">JIS("Text")</paragraph>
+<paragraph id="par_id5292519" role="paragraph" xml-lang="en-US">
<emph>Text</emph> is the text that contains characters to be
converted.</paragraph>
+<paragraph id="par_id3984496" role="paragraph" xml-lang="en-US">See also ASC
function.</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/SC_HID_FUNC_LINKS" id="bm_id3154645"
localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3147083" role="heading" level="2" l10n="U"
- oldref="95">LEFT</paragraph>
- <paragraph xml-lang="en-US" id="par_id3153622" role="paragraph"
l10n="CHG" oldref="96"><ahelp hid="HID_FUNC_LINKS">Returns the first character
or characters of a text.</ahelp></paragraph>
- <paragraph xml-lang="en-US" id="hd_id3156116" role="heading"
level="3" l10n="U"
- oldref="97">Syntax</paragraph>
- <paragraph xml-lang="en-US" id="par_id3146786" role="code" l10n="U"
oldref="98">LEFT("Text"; Number)</paragraph>
- <paragraph xml-lang="en-US" id="par_id3147274" role="paragraph"
l10n="U" oldref="99">
- <emph>Text</emph> is the text where the initial partial words are
to be determined.</paragraph>
- <paragraph xml-lang="en-US" id="par_id3153152" role="paragraph"
l10n="U" oldref="100">
- <emph>Number</emph> (optional) specifies the number of characters
for the start text. If this parameter is not defined, one character is
returned.</paragraph>
- <paragraph xml-lang="en-US" id="hd_id3150260" role="heading"
level="3" l10n="U"
- oldref="101">Example</paragraph>
- <paragraph xml-lang="en-US" id="par_id3149141" role="paragraph"
l10n="U" oldref="102">
- <item type="input">=LEFT("output";3)</item> returns
âoutâ.</paragraph>
- </section>
- <section id="leftb">
-<bookmark xml-lang="en-US" branch="index"
id="bm_id2947083"><bookmark_value>LEFTB function</bookmark_value>
+
+<paragraph id="hd_id3147083" role="heading" level="2"
xml-lang="en-US">LEFT</paragraph>
+<paragraph id="par_id3153622" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_FUNC_LINKS">Returns the first character or characters of a
text.</ahelp></paragraph>
+
+<paragraph id="hd_id3156116" role="heading" level="3"
xml-lang="en-US">Syntax</paragraph>
+<paragraph id="par_id3146786" role="code" xml-lang="en-US">LEFT("Text";
Number)</paragraph>
+<paragraph id="par_id3147274" role="paragraph" xml-lang="en-US">
<emph>Text</emph> is the text where the initial partial words are to be
determined.</paragraph>
+<paragraph id="par_id3153152" role="paragraph" xml-lang="en-US">
<emph>Number</emph> (optional) specifies the number of characters for the start
text. If this parameter is not defined, one character is returned.</paragraph>
+
+<paragraph id="hd_id3150260" role="heading" level="3"
xml-lang="en-US">Example</paragraph>
+<paragraph id="par_id3149141" role="paragraph" xml-lang="en-US"> <item
type="input">=LEFT("output";3)</item> returns âoutâ.</paragraph>
+</section>
+
+<section id="leftb">
+<bookmark xml-lang="en-US" branch="index" id="bm_id2947083">
+ <bookmark_value>LEFTB function</bookmark_value>
</bookmark>
+
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_LEFTB" id="bm_id2954645"
localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id2947083" role="heading" level="2"
l10n="U" oldref="95">LEFTB</paragraph>
- <paragraph xml-lang="en-US" id="par_id2953622" role="paragraph"
l10n="CHG" oldref="96"><ahelp hid="HID_FUNC_LEFTB">Returns the first characters
of a DBCS text.</ahelp></paragraph>
- <paragraph xml-lang="en-US" id="hd_id2956116" role="heading"
level="3" l10n="U" oldref="97">Syntax</paragraph>
- <paragraph xml-lang="en-US" id="par_id2946786" role="code" l10n="U"
oldref="98">LEFTB("Text"; Number_bytes)</paragraph>
- <paragraph xml-lang="en-US" id="par_id2947274" role="paragraph"
l10n="U" oldref="99"><emph>Text</emph> is the text where the initial partial
words are to be determined.</paragraph>
- <paragraph xml-lang="en-US" id="par_id2953152" role="paragraph"
l10n="U" oldref="100"><emph>Number_bytes</emph> (optional) specifies the number
of characters you want LEFTB to extract, based on bytes. If this parameter is
not defined, one character is returned.</paragraph>
- <paragraph xml-lang="en-US" id="hd_id2950260" role="heading"
level="3">Examples</paragraph>
- <paragraph xml-lang="en-US" id="par_id2949141" role="paragraph"><item
type="input">LEFTB("ä¸å½";1)</item> returns " " (1 byte is only half a DBCS
character and a space character is returned instead).</paragraph>
- <paragraph xml-lang="en-US" id="par_id2949151" role="paragraph"><item
type="input">LEFTB("ä¸å½";2)</item> returns "ä¸" (2 bytes constitute one
complete DBCS character).</paragraph>
- <paragraph xml-lang="en-US" id="par_id2949161" role="paragraph"><item
type="input">LEFTB("ä¸å½";3)</item> returns "ä¸ " (3 bytes constitute one
DBCS character and a half; the last character returned is therefore a space
character).</paragraph>
- <paragraph xml-lang="en-US" id="par_id2949171" role="paragraph"><item
type="input">LEFTB("ä¸å½";4)</item> returns "ä¸å½" (4 bytes constitute two
complete DBCS characters).</paragraph>
- <paragraph xml-lang="en-US" id="par_id2949181" role="paragraph"><item
type="input">LEFTB("office";3)</item> returns "off" (3 non-DBCS characters each
consisting of 1 byte).</paragraph>
- </section>
- <section id="len">
-<bookmark xml-lang="en-US" branch="index"
id="bm_id3156110"><bookmark_value>LEN function</bookmark_value>
+
+<paragraph id="hd_id2947083" role="heading" level="2"
xml-lang="en-US">LEFTB</paragraph>
+<paragraph id="par_id2953622" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_FUNC_LEFTB">Returns the first characters of a DBCS
text.</ahelp></paragraph>
+
+<paragraph id="hd_id2956116" role="heading" level="3"
xml-lang="en-US">Syntax</paragraph>
+<paragraph id="par_id2946786" role="code" xml-lang="en-US">LEFTB("Text";
Number_bytes)</paragraph>
+<paragraph id="par_id2947274" role="paragraph"
xml-lang="en-US"><emph>Text</emph> is the text where the initial partial words
are to be determined.</paragraph>
+<paragraph id="par_id2953152" role="paragraph"
xml-lang="en-US"><emph>Number_bytes</emph> (optional) specifies the number of
characters you want LEFTB to extract, based on bytes. If this parameter is not
defined, one character is returned.</paragraph>
+
+<paragraph id="hd_id2950260" role="heading" level="3"
xml-lang="en-US">Examples</paragraph>
+<paragraph id="par_id2949141" role="paragraph" xml-lang="en-US"><item
type="input">LEFTB("ä¸å½";1)</item> returns " " (1 byte is only half a DBCS
character and a space character is returned instead).</paragraph>
+<paragraph id="par_id2949151" role="paragraph" xml-lang="en-US"><item
type="input">LEFTB("ä¸å½";2)</item> returns "ä¸" (2 bytes constitute one
complete DBCS character).</paragraph>
+<paragraph id="par_id2949161" role="paragraph" xml-lang="en-US"><item
type="input">LEFTB("ä¸å½";3)</item> returns "ä¸ " (3 bytes constitute one
DBCS character and a half; the last character returned is therefore a space
character).</paragraph>
+<paragraph id="par_id2949171" role="paragraph" xml-lang="en-US"><item
type="input">LEFTB("ä¸å½";4)</item> returns "ä¸å½" (4 bytes constitute two
complete DBCS characters).</paragraph>
+<paragraph id="par_id2949181" role="paragraph" xml-lang="en-US"><item
type="input">LEFTB("office";3)</item> returns "off" (3 non-DBCS characters each
consisting of 1 byte).</paragraph>
+</section>
+
+<section id="len">
+<bookmark xml-lang="en-US" branch="index" id="bm_id3156110">
+ <bookmark_value>LEN function</bookmark_value>
</bookmark>
+
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_LAENGE" id="bm_id3154050"
localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3156110" role="heading" level="2" l10n="U"
- oldref="104">LEN</paragraph>
- <paragraph xml-lang="en-US" id="par_id3150147" role="paragraph"
l10n="U" oldref="105"><ahelp hid="HID_FUNC_LAENGE">Returns the length of a
string including spaces.</ahelp></paragraph>
- <paragraph xml-lang="en-US" id="hd_id3155108" role="heading"
level="3" l10n="U"
- oldref="106">Syntax</paragraph>
- <paragraph xml-lang="en-US" id="par_id3154063" role="code" l10n="U"
oldref="107">LEN("Text")</paragraph>
- <paragraph xml-lang="en-US" id="par_id3146894" role="paragraph"
l10n="U" oldref="108">
- <emph>Text</emph> is the text whose length is to be
determined.</paragraph>
- <paragraph xml-lang="en-US" id="hd_id3153884" role="heading"
level="3" l10n="U"
- oldref="109">Example</paragraph>
- <paragraph xml-lang="en-US" id="par_id3156008" role="paragraph"
l10n="U" oldref="110">
- <item type="input">=LEN("Good Afternoon")</item> returns
14.</paragraph>
- <paragraph xml-lang="en-US" id="par_id3154300" role="paragraph"
l10n="U" oldref="111">
- <item type="input">=LEN(12345.67)</item> returns 8.</paragraph>
- </section>
- <section id="lenb">
-<bookmark xml-lang="en-US" branch="index"
id="bm_id2956110"><bookmark_value>LENB function</bookmark_value>
+
+<paragraph id="hd_id3156110" role="heading" level="2"
xml-lang="en-US">LEN</paragraph>
+<paragraph id="par_id3150147" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_FUNC_LAENGE">Returns the length of a string including
spaces.</ahelp></paragraph>
+
+<paragraph id="hd_id3155108" role="heading" level="3"
xml-lang="en-US">Syntax</paragraph>
+<paragraph id="par_id3154063" role="code"
xml-lang="en-US">LEN("Text")</paragraph>
+<paragraph id="par_id3146894" role="paragraph" xml-lang="en-US">
<emph>Text</emph> is the text whose length is to be determined.</paragraph>
+
+<paragraph id="hd_id3153884" role="heading" level="3"
xml-lang="en-US">Example</paragraph>
+<paragraph id="par_id3156008" role="paragraph" xml-lang="en-US"> <item
type="input">=LEN("Good Afternoon")</item> returns 14.</paragraph>
+<paragraph id="par_id3154300" role="paragraph" xml-lang="en-US"> <item
type="input">=LEN(12345.67)</item> returns 8.</paragraph>
+</section>
+
+<section id="lenb">
+<bookmark xml-lang="en-US" branch="index" id="bm_id2956110">
+ <bookmark_value>LENB function</bookmark_value>
</bookmark>
+
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_LENB" id="bm_id2954050"
localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id2956110" role="heading" level="2"
l10n="U" oldref="104">LENB</paragraph>
- <paragraph xml-lang="en-US" id="par_id2950147" role="paragraph"
l10n="U" oldref="105"><ahelp hid="HID_FUNC_LENB">For double-byte character set
(DBCS) languages, returns the number of bytes used to represent the characters
in a text string.</ahelp></paragraph>
- <paragraph xml-lang="en-US" id="hd_id2955108" role="heading"
level="3" l10n="U" oldref="106">Syntax</paragraph>
- <paragraph xml-lang="en-US" id="par_id2954063" role="code" l10n="U"
oldref="107">LENB("Text")</paragraph>
- <paragraph xml-lang="en-US" id="par_id2946894" role="paragraph"
l10n="U" oldref="108"><emph>Text</emph> is the text whose length is to be
determined.</paragraph>
- <paragraph xml-lang="en-US" id="hd_id2953884" role="heading"
level="3">Examples</paragraph>
- <paragraph xml-lang="en-US" id="par_id2956018" role="paragraph"><item
type="input">LENB("ä¸")</item> returns 2 (1 DBCS character consisting of 2
bytes).</paragraph>
- <paragraph xml-lang="en-US" id="par_id2956028" role="paragraph"><item
type="input">LENB("ä¸å½")</item> returns 4 (2 DBCS characters each consisting
of 2 bytes).</paragraph>
- <paragraph xml-lang="en-US" id="par_id2956038" role="paragraph"><item
type="input">LENB("office")</item> returns 6 (6 non-DBCS characters each
consisting of 1 byte).</paragraph>
- <paragraph xml-lang="en-US" id="par_id2956008" role="paragraph"
l10n="U" oldref="110">
- <item type="input">=LENB("Good Afternoon")</item> returns
14.</paragraph>
- <paragraph xml-lang="en-US" id="par_id2954300" role="paragraph"
l10n="U" oldref="111">
- <item type="input">=LENB(12345.67)</item> returns 8.</paragraph>
- </section>
- <section id="lower">
-<bookmark xml-lang="en-US" branch="index"
id="bm_id3153983"><bookmark_value>LOWER function</bookmark_value>
+
+<paragraph id="hd_id2956110" role="heading" level="2"
xml-lang="en-US">LENB</paragraph>
+<paragraph id="par_id2950147" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_FUNC_LENB">For double-byte character set (DBCS) languages, returns the
number of bytes used to represent the characters in a text
string.</ahelp></paragraph>
+
+<paragraph id="hd_id2955108" role="heading" level="3"
xml-lang="en-US">Syntax</paragraph>
+<paragraph id="par_id2954063" role="code"
xml-lang="en-US">LENB("Text")</paragraph>
+<paragraph id="par_id2946894" role="paragraph"
xml-lang="en-US"><emph>Text</emph> is the text whose length is to be
determined.</paragraph>
+
+<paragraph id="hd_id2953884" role="heading" level="3"
xml-lang="en-US">Examples</paragraph>
+<paragraph id="par_id2956018" role="paragraph" xml-lang="en-US"><item
type="input">LENB("ä¸")</item> returns 2 (1 DBCS character consisting of 2
bytes).</paragraph>
+<paragraph id="par_id2956028" role="paragraph" xml-lang="en-US"><item
type="input">LENB("ä¸å½")</item> returns 4 (2 DBCS characters each consisting
of 2 bytes).</paragraph>
+<paragraph id="par_id2956038" role="paragraph" xml-lang="en-US"><item
type="input">LENB("office")</item> returns 6 (6 non-DBCS characters each
consisting of 1 byte).</paragraph>
+<paragraph id="par_id2956008" role="paragraph" xml-lang="en-US"> <item
type="input">=LENB("Good Afternoon")</item> returns 14.</paragraph>
+<paragraph id="par_id2954300" role="paragraph" xml-lang="en-US"> <item
type="input">=LENB(12345.67)</item> returns 8.</paragraph>
+</section>
+
+<section id="lower">
+<bookmark xml-lang="en-US" branch="index" id="bm_id3153983">
+ <bookmark_value>LOWER function</bookmark_value>
</bookmark>
+
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_KLEIN" id="bm_id3151173"
localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3153983" role="heading" level="2" l10n="U"
- oldref="87">LOWER</paragraph>
- <paragraph xml-lang="en-US" id="par_id3152791" role="paragraph"
l10n="U" oldref="88"><ahelp hid="HID_FUNC_KLEIN">Converts all uppercase letters
in a text string to lowercase.</ahelp></paragraph>
- <paragraph xml-lang="en-US" id="hd_id3155902" role="heading"
level="3" l10n="U"
- oldref="89">Syntax</paragraph>
- <paragraph xml-lang="en-US" id="par_id3150121" role="code" l10n="U"
oldref="90">LOWER("Text")</paragraph>
- <paragraph xml-lang="en-US" id="par_id3153910" role="paragraph"
l10n="U" oldref="91">
- <emph>Text</emph> refers to the text to be converted.</paragraph>
- <paragraph xml-lang="en-US" id="hd_id3159343" role="heading"
level="3" l10n="U"
- oldref="92">Example</paragraph>
- <paragraph xml-lang="en-US" id="par_id3155329" role="paragraph"
l10n="U" oldref="93">
- <item type="input">=LOWER("Sun")</item> returns sun.</paragraph>
- </section>
- <section id="mid">
-<bookmark xml-lang="en-US" branch="index"
id="bm_id3154589"><bookmark_value>MID function</bookmark_value>
+
+<paragraph id="hd_id3153983" role="heading" level="2"
xml-lang="en-US">LOWER</paragraph>
+<paragraph id="par_id3152791" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_FUNC_KLEIN">Converts all uppercase letters in a text string to
lowercase.</ahelp></paragraph>
+
+<paragraph id="hd_id3155902" role="heading" level="3"
xml-lang="en-US">Syntax</paragraph>
+<paragraph id="par_id3150121" role="code"
xml-lang="en-US">LOWER("Text")</paragraph>
+<paragraph id="par_id3153910" role="paragraph" xml-lang="en-US">
<emph>Text</emph> refers to the text to be converted.</paragraph>
+
+<paragraph id="hd_id3159343" role="heading" level="3"
xml-lang="en-US">Example</paragraph>
+<paragraph id="par_id3155329" role="paragraph" xml-lang="en-US"> <item
type="input">=LOWER("Sun")</item> returns sun.</paragraph>
+</section>
+
+<section id="mid">
+<bookmark xml-lang="en-US" branch="index" id="bm_id3154589">
+ <bookmark_value>MID function</bookmark_value>
</bookmark>
+
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_TEIL" id="bm_id3155392"
localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3154589" role="heading" level="2" l10n="U"
- oldref="148">MID</paragraph>
- <paragraph xml-lang="en-US" id="par_id3154938" role="paragraph"
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 xml-lang="en-US" id="hd_id3148829" role="heading"
level="3" l10n="U"
- oldref="150">Syntax</paragraph>
- <paragraph xml-lang="en-US" id="par_id3150526" role="code" l10n="U"
oldref="151">MID("Text"; Start; Number)</paragraph>
- <paragraph xml-lang="en-US" id="par_id3148820" role="paragraph"
l10n="U" oldref="152">
- <emph>Text</emph> is the text containing the characters to
extract.</paragraph>
- <paragraph xml-lang="en-US" id="par_id3150774" role="paragraph"
l10n="U" oldref="153">
- <emph>Start</emph> is the position of the first character in the
text to extract.</paragraph>
- <paragraph xml-lang="en-US" id="par_id3153063" role="paragraph"
l10n="U" oldref="154">
- <emph>Number</emph> specifies the number of characters in the part
of the text.</paragraph>
- <paragraph xml-lang="en-US" id="hd_id3150509" role="heading"
level="3" l10n="U"
- oldref="155">Example</paragraph>
- <paragraph xml-lang="en-US" id="par_id3158407" role="paragraph"
l10n="U" oldref="156">
- <item type="input">=MID("office";2;2)</item> returns
ff.</paragraph>
- </section>
- <section id="midb">
-<bookmark xml-lang="en-US" branch="index"
id="bm_id2954589"><bookmark_value>MIDB function</bookmark_value>
+
+<paragraph id="hd_id3154589" role="heading" level="2"
xml-lang="en-US">MID</paragraph>
+<paragraph id="par_id3154938" role="paragraph" xml-lang="en-US"><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 id="hd_id3148829" role="heading" level="3"
xml-lang="en-US">Syntax</paragraph>
+<paragraph id="par_id3150526" role="code" xml-lang="en-US">MID("Text"; Start;
Number)</paragraph>
+<paragraph id="par_id3148820" role="paragraph" xml-lang="en-US">
<emph>Text</emph> is the text containing the characters to extract.</paragraph>
+<paragraph id="par_id3150774" role="paragraph" xml-lang="en-US">
<emph>Start</emph> is the position of the first character in the text to
extract.</paragraph>
+<paragraph id="par_id3153063" role="paragraph" xml-lang="en-US">
<emph>Number</emph> specifies the number of characters in the part of the
text.</paragraph>
+
+<paragraph id="hd_id3150509" role="heading" level="3"
xml-lang="en-US">Example</paragraph>
+<paragraph id="par_id3158407" role="paragraph" xml-lang="en-US"> <item
type="input">=MID("office";2;2)</item> returns ff.</paragraph>
+</section>
+
+<section id="midb">
+<bookmark xml-lang="en-US" branch="index" id="bm_id2954589">
+ <bookmark_value>MIDB function</bookmark_value>
</bookmark>
+
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MIDB" id="bm_id2955392"
localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id2954589" role="heading" level="2"
l10n="U" oldref="148">MIDB</paragraph>
- <paragraph xml-lang="en-US" id="par_id2954938" role="paragraph"
l10n="CHG" oldref="149"><ahelp hid="HID_FUNC_MIDB">Returns a text string of a
DBCS text. The parameters specify the starting position and the number of
characters.</ahelp></paragraph>
- <paragraph xml-lang="en-US" id="hd_id2948829" role="heading"
level="3" l10n="U" oldref="150">Syntax</paragraph>
- <paragraph xml-lang="en-US" id="par_id2950526" role="code" l10n="U"
oldref="151">MIDB("Text"; Start; Number_bytes)</paragraph>
- <paragraph xml-lang="en-US" id="par_id2948820" role="paragraph"
l10n="U" oldref="152"><emph>Text</emph> is the text containing the characters
to extract.</paragraph>
- <paragraph xml-lang="en-US" id="par_id2950774" role="paragraph"
l10n="U" oldref="153"><emph>Start</emph> is the position of the first character
in the text to extract.</paragraph>
- <paragraph xml-lang="en-US" id="par_id2953063" role="paragraph"
l10n="U" oldref="154"><emph>Number_bytes</emph> specifies the number of
characters MIDB will return from text, in bytes.</paragraph>
- <paragraph xml-lang="en-US" id="hd_id2950509" role="heading"
level="3">Examples</paragraph>
- <paragraph xml-lang="en-US" id="par_id2958417" role="paragraph"><item
type="input">MIDB("ä¸å½";1;0)</item> returns "" (0 bytes is always an empty
string).</paragraph>
- <paragraph xml-lang="en-US" id="par_id2958427" role="paragraph"><item
type="input">MIDB("ä¸å½";1;1)</item> returns " " (1 byte is only half a DBCS
character and therefore the result is a space character).</paragraph>
- <paragraph xml-lang="en-US" id="par_id2958437" role="paragraph"><item
type="input">MIDB("ä¸å½";1;2)</item> returns "ä¸" (2 bytes constitute one
complete DBCS character).</paragraph>
- <paragraph xml-lang="en-US" id="par_id2958447" role="paragraph"><item
type="input">MIDB("ä¸å½";1;3)</item> returns "ä¸ " (3 bytes constitute one
and a half DBCS character; the last byte results in a space
character).</paragraph>
- <paragraph xml-lang="en-US" id="par_id2958457" role="paragraph"><item
type="input">MIDB("ä¸å½";1;4)</item> returns "ä¸å½" (4 bytes constitute two
complete DBCS characters).</paragraph>
- <paragraph xml-lang="en-US" id="par_id2958467" role="paragraph"><item
type="input">MIDB("ä¸å½";2;1)</item> returns " " (byte position 2 is not at
the beginning of a character in a DBCS string; 1 space character is
returned).</paragraph>
- <paragraph xml-lang="en-US" id="par_id2958477" role="paragraph"><item
type="input">MIDB("ä¸å½";2;2)</item> returns " " (byte position 2 points to
the last half of the first character in the DBCS string; the 2 bytes asked for
therefore constitutes the last half of the first character and the first half
of the second character in the string; 2 space characters are therefore
returned).</paragraph>
- <paragraph xml-lang="en-US" id="par_id2958487" role="paragraph"><item
type="input">MIDB("ä¸å½";2;3)</item> returns " å½" (byte position 2 is not
at the beginning of a character in a DBCS string; a space character is returned
for byte position 2).</paragraph>
- <paragraph xml-lang="en-US" id="par_id2958497" role="paragraph"><item
type="input">MIDB("ä¸å½";3;1)</item> returns " " (byte position 3 is at the
beginning of a character in a DBCS string, but 1 byte is only half a DBCS
character and a space character is therefore returned instead).</paragraph>
- <paragraph xml-lang="en-US" id="par_id2958507" role="paragraph"><item
type="input">MIDB("ä¸å½";3;2)</item> returns "å½" (byte position 3 is at the
beginning of a character in a DBCS string, and 2 bytes constitute one DBCS
character).</paragraph>
- <paragraph xml-lang="en-US" id="par_id2958517" role="paragraph"><item
type="input">MIDB("office";2;3)</item> returns "ffi" (byte position 2 is at the
beginning of a character in a non-DBCS string, and 3 bytes of a non-DBCS string
constitute 3 characters).</paragraph>
- </section>
- <section id="proper">
-<bookmark xml-lang="en-US" branch="index"
id="bm_id3159143"><bookmark_value>PROPER function</bookmark_value>
+
+<paragraph id="hd_id2954589" role="heading" level="2"
xml-lang="en-US">MIDB</paragraph>
+<paragraph id="par_id2954938" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_FUNC_MIDB">Returns a text string of a DBCS text. The parameters
specify the starting position and the number of characters.</ahelp></paragraph>
+
+<paragraph id="hd_id2948829" role="heading" level="3"
xml-lang="en-US">Syntax</paragraph>
+<paragraph id="par_id2950526" role="code" xml-lang="en-US">MIDB("Text"; Start;
Number_bytes)</paragraph>
+<paragraph id="par_id2948820" role="paragraph"
xml-lang="en-US"><emph>Text</emph> is the text containing the characters to
extract.</paragraph>
+<paragraph id="par_id2950774" role="paragraph"
xml-lang="en-US"><emph>Start</emph> is the position of the first character in
the text to extract.</paragraph>
+<paragraph id="par_id2953063" role="paragraph"
xml-lang="en-US"><emph>Number_bytes</emph> specifies the number of characters
MIDB will return from text, in bytes.</paragraph>
+
+<paragraph id="hd_id2950509" role="heading" level="3"
xml-lang="en-US">Examples</paragraph>
+<paragraph id="par_id2958417" role="paragraph" xml-lang="en-US"><item
type="input">MIDB("ä¸å½";1;0)</item> returns "" (0 bytes is always an empty
string).</paragraph>
+<paragraph id="par_id2958427" role="paragraph" xml-lang="en-US"><item
type="input">MIDB("ä¸å½";1;1)</item> returns " " (1 byte is only half a DBCS
character and therefore the result is a space character).</paragraph>
+<paragraph id="par_id2958437" role="paragraph" xml-lang="en-US"><item
type="input">MIDB("ä¸å½";1;2)</item> returns "ä¸" (2 bytes constitute one
complete DBCS character).</paragraph>
+<paragraph id="par_id2958447" role="paragraph" xml-lang="en-US"><item
type="input">MIDB("ä¸å½";1;3)</item> returns "ä¸ " (3 bytes constitute one
and a half DBCS character; the last byte results in a space
character).</paragraph>
+<paragraph id="par_id2958457" role="paragraph" xml-lang="en-US"><item
type="input">MIDB("ä¸å½";1;4)</item> returns "ä¸å½" (4 bytes constitute two
complete DBCS characters).</paragraph>
+<paragraph id="par_id2958467" role="paragraph" xml-lang="en-US"><item
type="input">MIDB("ä¸å½";2;1)</item> returns " " (byte position 2 is not at
the beginning of a character in a DBCS string; 1 space character is
returned).</paragraph>
+<paragraph id="par_id2958477" role="paragraph" xml-lang="en-US"><item
type="input">MIDB("ä¸å½";2;2)</item> returns " " (byte position 2 points to
the last half of the first character in the DBCS string; the 2 bytes asked for
therefore constitutes the last half of the first character and the first half
of the second character in the string; 2 space characters are therefore
returned).</paragraph>
+<paragraph id="par_id2958487" role="paragraph" xml-lang="en-US"><item
type="input">MIDB("ä¸å½";2;3)</item> returns " å½" (byte position 2 is not
at the beginning of a character in a DBCS string; a space character is returned
for byte position 2).</paragraph>
+<paragraph id="par_id2958497" role="paragraph" xml-lang="en-US"><item
type="input">MIDB("ä¸å½";3;1)</item> returns " " (byte position 3 is at the
beginning of a character in a DBCS string, but 1 byte is only half a DBCS
character and a space character is therefore returned instead).</paragraph>
+<paragraph id="par_id2958507" role="paragraph" xml-lang="en-US"><item
type="input">MIDB("ä¸å½";3;2)</item> returns "å½" (byte position 3 is at the
beginning of a character in a DBCS string, and 2 bytes constitute one DBCS
character).</paragraph>
+<paragraph id="par_id2958517" role="paragraph" xml-lang="en-US"><item
type="input">MIDB("office";2;3)</item> returns "ffi" (byte position 2 is at the
beginning of a character in a non-DBCS string, and 3 bytes of a non-DBCS string
constitute 3 characters).</paragraph>
+</section>
+
+<section id="proper">
+<bookmark xml-lang="en-US" branch="index" id="bm_id3159143">
+ <bookmark_value>PROPER function</bookmark_value>
</bookmark>
+
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_GROSS2" id="bm_id3154897"
localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3159143" role="heading" level="2" l10n="U"
- oldref="70">PROPER</paragraph>
- <paragraph xml-lang="en-US" id="par_id3149768" role="paragraph"
l10n="U" oldref="71"><ahelp hid="HID_FUNC_GROSS2">Capitalizes the first letter
in all words of a text string.</ahelp></paragraph>
- <paragraph xml-lang="en-US" id="hd_id3153573" role="heading"
level="3" l10n="U"
- oldref="72">Syntax</paragraph>
- <paragraph xml-lang="en-US" id="par_id3154260" role="code" l10n="U"
oldref="73">PROPER("Text")</paragraph>
- <paragraph xml-lang="en-US" id="par_id3147509" role="paragraph"
l10n="U" oldref="74">
- <emph>Text</emph> refers to the text to be converted.</paragraph>
- <paragraph xml-lang="en-US" id="hd_id3147529" role="heading"
level="3" l10n="U"
- oldref="75">Example</paragraph>
- <paragraph xml-lang="en-US" id="par_id3155364" role="paragraph"
l10n="U" oldref="76">
- <item type="input">=PROPER("open office")</item> returns Open
Office.</paragraph>
- </section>
- <section id="replace">
-<bookmark xml-lang="en-US" branch="index"
id="bm_id3149171"><bookmark_value>REPLACE function</bookmark_value>
+
+<paragraph id="hd_id3159143" role="heading" level="2"
xml-lang="en-US">PROPER</paragraph>
+<paragraph id="par_id3149768" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_FUNC_GROSS2">Capitalizes the first letter in all words of a text
string.</ahelp></paragraph>
+
+<paragraph id="hd_id3153573" role="heading" level="3"
xml-lang="en-US">Syntax</paragraph>
+<paragraph id="par_id3154260" role="code"
xml-lang="en-US">PROPER("Text")</paragraph>
+<paragraph id="par_id3147509" role="paragraph" xml-lang="en-US">
<emph>Text</emph> refers to the text to be converted.</paragraph>
+
+<paragraph id="hd_id3147529" role="heading" level="3"
xml-lang="en-US">Example</paragraph>
+<paragraph id="par_id3155364" role="paragraph" xml-lang="en-US"> <item
type="input">=PROPER("open office")</item> returns Open Office.</paragraph>
+</section>
+
+<section id="replace">
+<bookmark xml-lang="en-US" branch="index" id="bm_id3149171">
+ <bookmark_value>REPLACE function</bookmark_value>
</bookmark>
+
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ERSETZEN" id="bm_id3149990"
localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3149171" role="heading" level="2" l10n="U"
- oldref="22">REPLACE</paragraph>
- <paragraph xml-lang="en-US" id="par_id3148925" role="paragraph"
l10n="U" oldref="23"><ahelp hid="HID_FUNC_ERSETZEN">Replaces part of a text
string with a different text string.</ahelp> This function can be used to
replace both characters and numbers (which are automatically converted to
text). The result of the function is always displayed as text. If you intend to
perform further calculations with a number which has been replaced by text, you
will need to convert it back to a number using the <link
href="text/scalc/01/04060110.xhp" name="VALUE">VALUE</link>
function.</paragraph>
- <paragraph xml-lang="en-US" id="par_id3158426" role="paragraph"
l10n="U" oldref="24">Any text containing numbers must be enclosed in quotation
marks if you do not want it to be interpreted as a number and automatically
converted to text.</paragraph>
- <paragraph xml-lang="en-US" id="hd_id3149159" role="heading"
level="3" l10n="U"
- oldref="25">Syntax</paragraph>
- <paragraph xml-lang="en-US" id="par_id3147286" role="code" l10n="U"
oldref="26">REPLACE("Text"; Position; Length; "NewText")</paragraph>
- <paragraph xml-lang="en-US" id="par_id3149797" role="paragraph"
l10n="U" oldref="27">
- <emph>Text</emph> refers to text of which a part will be
replaced.</paragraph>
- <paragraph xml-lang="en-US" id="par_id3166451" role="paragraph"
l10n="U" oldref="28">
- <emph>Position</emph> refers to the position within the text where
the replacement will begin.</paragraph>
- <paragraph xml-lang="en-US" id="par_id3156040" role="paragraph"
l10n="U" oldref="29">
- <emph>Length</emph> is the number of characters in
<emph>Text</emph> to be replaced.</paragraph>
- <paragraph xml-lang="en-US" id="par_id3159188" role="paragraph"
l10n="U" oldref="30">
- <emph>NewText</emph> refers to the text which replaces
<emph>Text</emph>.</paragraph>
- <paragraph xml-lang="en-US" id="hd_id3146958" role="heading"
level="3" l10n="U"
- oldref="31">Example</paragraph>
- <paragraph xml-lang="en-US" id="par_id3154096" role="paragraph"
l10n="U" oldref="32">
- <item type="input">=REPLACE("1234567";1;1;"444")</item> returns
"444234567". One character at position 1 is replaced by the complete <item
type="literal">NewText</item>.</paragraph>
- </section>
- <section id="rept">
-<bookmark xml-lang="en-US" branch="index"
id="bm_id3149741"><bookmark_value>REPT function</bookmark_value>
+
+<paragraph id="hd_id3149171" role="heading" level="2"
xml-lang="en-US">REPLACE</paragraph>
+<paragraph id="par_id3148925" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_FUNC_ERSETZEN">Replaces part of a text string with a different text
string.</ahelp> This function can be used to replace both characters and
numbers (which are automatically converted to text). The result of the function
is always displayed as text. If you intend to perform further calculations with
a number which has been replaced by text, you will need to convert it back to a
number using the <link href="text/scalc/01/04060110.xhp"
name="VALUE">VALUE</link> function.</paragraph>
+<paragraph id="par_id3158426" role="paragraph" xml-lang="en-US">Any text
containing numbers must be enclosed in quotation marks if you do not want it to
be interpreted as a number and automatically converted to text.</paragraph>
+
+<paragraph id="hd_id3149159" role="heading" level="3"
xml-lang="en-US">Syntax</paragraph>
+<paragraph id="par_id3147286" role="code" xml-lang="en-US">REPLACE("Text";
Position; Length; "NewText")</paragraph>
+<paragraph id="par_id3149797" role="paragraph" xml-lang="en-US">
<emph>Text</emph> refers to text of which a part will be replaced.</paragraph>
+<paragraph id="par_id3166451" role="paragraph" xml-lang="en-US">
<emph>Position</emph> refers to the position within the text where the
replacement will begin.</paragraph>
+<paragraph id="par_id3156040" role="paragraph" xml-lang="en-US">
<emph>Length</emph> is the number of characters in <emph>Text</emph> to be
replaced.</paragraph>
+<paragraph id="par_id3159188" role="paragraph" xml-lang="en-US">
<emph>NewText</emph> refers to the text which replaces
<emph>Text</emph>.</paragraph>
+
+<paragraph id="hd_id3146958" role="heading" level="3"
xml-lang="en-US">Example</paragraph>
+<paragraph id="par_id3154096" role="paragraph" xml-lang="en-US"> <item
type="input">=REPLACE("1234567";1;1;"444")</item> returns "444234567". One
character at position 1 is replaced by the complete <item
type="literal">NewText</item>.</paragraph>
+</section>
+
+<section id="rept">
+<bookmark xml-lang="en-US" branch="index" id="bm_id3149741">
+ <bookmark_value>REPT function</bookmark_value>
</bookmark>
+
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_WIEDERHOLEN"
id="bm_id3155582" localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3149741" role="heading" level="2" l10n="U"
- oldref="193">REPT</paragraph>
- <paragraph xml-lang="en-US" id="par_id3153748" role="paragraph"
l10n="U" oldref="194"><ahelp hid="HID_FUNC_WIEDERHOLEN">Repeats a character
string by the given <emph>number</emph> of copies.</ahelp></paragraph>
- <paragraph xml-lang="en-US" id="hd_id3152884" role="heading"
level="3" l10n="U"
- oldref="195">Syntax</paragraph>
- <paragraph xml-lang="en-US" id="par_id3150494" role="code" l10n="U"
oldref="196">REPT("Text"; Number)</paragraph>
- <paragraph xml-lang="en-US" id="par_id3154859" role="paragraph"
l10n="U" oldref="197">
- <emph>Text</emph> is the text to be repeated.</paragraph>
- <paragraph xml-lang="en-US" id="par_id3150638" role="paragraph"
l10n="U" oldref="198">
- <emph>Number</emph> is the number of repetitions.</paragraph>
- <paragraph xml-lang="en-US" id="par_id3149922" role="paragraph"
l10n="U" oldref="212">The result can be a maximum of 255 characters.</paragraph>
- <paragraph xml-lang="en-US" id="hd_id3156213" role="heading"
level="3" l10n="U"
- oldref="199">Example</paragraph>
- <paragraph xml-lang="en-US" id="par_id3148626" role="paragraph"
l10n="U" oldref="200">
- <item type="input">=REPT("Good morning";2)</item> returns Good
morningGood morning.</paragraph>
- </section>
- <section id="right">
-<bookmark xml-lang="en-US" branch="index"
id="bm_id3149805"><bookmark_value>RIGHT function</bookmark_value>
+
+<paragraph id="hd_id3149741" role="heading" level="2"
xml-lang="en-US">REPT</paragraph>
+<paragraph id="par_id3153748" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_FUNC_WIEDERHOLEN">Repeats a character string by the given
<emph>number</emph> of copies.</ahelp></paragraph>
+
+<paragraph id="hd_id3152884" role="heading" level="3"
xml-lang="en-US">Syntax</paragraph>
+<paragraph id="par_id3150494" role="code" xml-lang="en-US">REPT("Text";
Number)</paragraph>
+<paragraph id="par_id3154859" role="paragraph" xml-lang="en-US">
<emph>Text</emph> is the text to be repeated.</paragraph>
+<paragraph id="par_id3150638" role="paragraph" xml-lang="en-US">
<emph>Number</emph> is the number of repetitions.</paragraph>
+<paragraph id="par_id3149922" role="paragraph" xml-lang="en-US">The result can
be a maximum of 255 characters.</paragraph>
+
+<paragraph id="hd_id3156213" role="heading" level="3"
xml-lang="en-US">Example</paragraph>
+<paragraph id="par_id3148626" role="paragraph" xml-lang="en-US"> <item
type="input">=REPT("Good morning";2)</item> returns Good morningGood
morning.</paragraph>
+</section>
+
+<section id="right">
+<bookmark xml-lang="en-US" branch="index" id="bm_id3149805">
+ <bookmark_value>RIGHT function</bookmark_value>
</bookmark>
+
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_RECHTS" id="bm_id3154602"
localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3149805" role="heading" level="2" l10n="U"
- oldref="113">RIGHT</paragraph>
- <paragraph xml-lang="en-US" id="par_id3145375" role="paragraph"
l10n="CHG" oldref="114"><ahelp hid="HID_FUNC_RECHTS">Returns the last character
or characters of a text.</ahelp></paragraph>
- <paragraph xml-lang="en-US" id="hd_id3150837" role="heading"
level="3" l10n="U"
- oldref="115">Syntax</paragraph>
- <paragraph xml-lang="en-US" id="par_id3154344" role="code" l10n="U"
oldref="116">RIGHT("Text"; Number)</paragraph>
- <paragraph xml-lang="en-US" id="par_id3149426" role="paragraph"
l10n="U" oldref="117">
- <emph>Text</emph> is the text of which the right part is to be
determined.</paragraph>
- <paragraph xml-lang="en-US" id="par_id3153350" role="paragraph"
l10n="U" oldref="118">
- <emph>Number</emph> (optional) is the number of characters from
the right part of the text.</paragraph>
- <paragraph xml-lang="en-US" id="hd_id3148661" role="heading"
level="3" l10n="U"
- oldref="119">Example</paragraph>
- <paragraph xml-lang="en-US" id="par_id3151132" role="paragraph"
l10n="U" oldref="120">
- <item type="input">=RIGHT("Sun";2)</item> returns un.</paragraph>
- </section>
- <section id="rightb">
-<bookmark xml-lang="en-US" branch="index"
id="bm_id2949805"><bookmark_value>RIGHTB function</bookmark_value>
+
+<paragraph id="hd_id3149805" role="heading" level="2"
xml-lang="en-US">RIGHT</paragraph>
+<paragraph id="par_id3145375" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_FUNC_RECHTS">Returns the last character or characters of a
text.</ahelp></paragraph>
+
+<paragraph id="hd_id3150837" role="heading" level="3"
xml-lang="en-US">Syntax</paragraph>
+<paragraph id="par_id3154344" role="code" xml-lang="en-US">RIGHT("Text";
Number)</paragraph>
+<paragraph id="par_id3149426" role="paragraph" xml-lang="en-US">
<emph>Text</emph> is the text of which the right part is to be
determined.</paragraph>
+<paragraph id="par_id3153350" role="paragraph" xml-lang="en-US">
<emph>Number</emph> (optional) is the number of characters from the right part
of the text.</paragraph>
+
+<paragraph id="hd_id3148661" role="heading" level="3"
xml-lang="en-US">Example</paragraph>
+<paragraph id="par_id3151132" role="paragraph" xml-lang="en-US"> <item
type="input">=RIGHT("Sun";2)</item> returns un.</paragraph>
+</section>
+
+<section id="rightb">
+<bookmark xml-lang="en-US" branch="index" id="bm_id2949805">
+ <bookmark_value>RIGHTB function</bookmark_value>
</bookmark>
+
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_RIGHTB" id="bm_id2954602"
localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id2949805" role="heading" level="2"
l10n="U" oldref="113">RIGHTB</paragraph>
- <paragraph xml-lang="en-US" id="par_id2945375" role="paragraph"
l10n="CHG" oldref="114"><ahelp hid="HID_FUNC_RIGHTB">Returns the last character
or characters of a text with double bytes characters sets
(DBCS).</ahelp></paragraph>
- <paragraph xml-lang="en-US" id="hd_id2950837" role="heading"
level="3" l10n="U" oldref="115">Syntax</paragraph>
- <paragraph xml-lang="en-US" id="par_id2954344" role="code" l10n="U"
oldref="116">RIGHTB("Text"; Number_bytes)</paragraph>
- <paragraph xml-lang="en-US" id="par_id2949426" role="paragraph"
l10n="U" oldref="117"><emph>Text</emph> is the text of which the right part is
to be determined.</paragraph>
- <paragraph xml-lang="en-US" id="par_id2953350" role="paragraph"
l10n="U" oldref="118"><emph>Number_bytes</emph> (optional) specifies the number
of characters you want RIGHTB to extract, based on bytes.</paragraph>
- <paragraph xml-lang="en-US" id="hd_id2948661" role="heading"
level="3">Examples</paragraph>
- <paragraph xml-lang="en-US" id="par_id2951132" role="paragraph"><item
type="input">RIGHTB("ä¸å½";1)</item> returns " " (1 byte is only half a DBCS
character and a space character is returned instead).</paragraph>
- <paragraph xml-lang="en-US" id="par_id2951142" role="paragraph"><item
type="input">RIGHTB("ä¸å½";2)</item> returns "å½" (2 bytes constitute one
complete DBCS character).</paragraph>
- <paragraph xml-lang="en-US" id="par_id2951152" role="paragraph"><item
type="input">RIGHTB("ä¸å½";3)</item> returns " å½" (3 bytes constitute one
half DBCS character and one whole DBCS character; a space is returned for the
first half).</paragraph>
- <paragraph xml-lang="en-US" id="par_id2951162" role="paragraph"><item
type="input">RIGHTB("ä¸å½";4)</item> returns "ä¸å½" (4 bytes constitute two
complete DBCS characters).</paragraph>
- <paragraph xml-lang="en-US" id="par_id2951172" role="paragraph"><item
type="input">RIGHTB("office";3)</item> returns "ice" (3 non-DBCS characters
each consisting of 1 byte).</paragraph>
- </section>
- <section id="roman">
-<bookmark xml-lang="en-US" branch="index"
id="bm_id3153534"><bookmark_value>ROMAN function</bookmark_value>
+
+<paragraph id="hd_id2949805" role="heading" level="2"
xml-lang="en-US">RIGHTB</paragraph>
+<paragraph id="par_id2945375" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_FUNC_RIGHTB">Returns the last character or characters of a text with
double bytes characters sets (DBCS).</ahelp></paragraph>
+
+<paragraph id="hd_id2950837" role="heading" level="3"
xml-lang="en-US">Syntax</paragraph>
+<paragraph id="par_id2954344" role="code" xml-lang="en-US">RIGHTB("Text";
Number_bytes)</paragraph>
+<paragraph id="par_id2949426" role="paragraph"
xml-lang="en-US"><emph>Text</emph> is the text of which the right part is to be
determined.</paragraph>
+<paragraph id="par_id2953350" role="paragraph"
xml-lang="en-US"><emph>Number_bytes</emph> (optional) specifies the number of
characters you want RIGHTB to extract, based on bytes.</paragraph>
+
+<paragraph id="hd_id2948661" role="heading" level="3"
xml-lang="en-US">Examples</paragraph>
+<paragraph id="par_id2951132" role="paragraph" xml-lang="en-US"><item
type="input">RIGHTB("ä¸å½";1)</item> returns " " (1 byte is only half a DBCS
character and a space character is returned instead).</paragraph>
+<paragraph id="par_id2951142" role="paragraph" xml-lang="en-US"><item
type="input">RIGHTB("ä¸å½";2)</item> returns "å½" (2 bytes constitute one
complete DBCS character).</paragraph>
+<paragraph id="par_id2951152" role="paragraph" xml-lang="en-US"><item
type="input">RIGHTB("ä¸å½";3)</item> returns " å½" (3 bytes constitute one
half DBCS character and one whole DBCS character; a space is returned for the
first half).</paragraph>
+<paragraph id="par_id2951162" role="paragraph" xml-lang="en-US"><item
type="input">RIGHTB("ä¸å½";4)</item> returns "ä¸å½" (4 bytes constitute two
complete DBCS characters).</paragraph>
+<paragraph id="par_id2951172" role="paragraph" xml-lang="en-US"><item
type="input">RIGHTB("office";3)</item> returns "ice" (3 non-DBCS characters
each consisting of 1 byte).</paragraph>
+</section>
+
+<section id="roman">
+<bookmark xml-lang="en-US" branch="index" id="bm_id3153534">
+ <bookmark_value>ROMAN function</bookmark_value>
</bookmark>
+
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ROEMISCH" id="bm_id3144755"
localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3153534" role="heading" level="2" l10n="U"
- oldref="248">ROMAN</paragraph>
- <paragraph xml-lang="en-US" id="par_id3151256" role="paragraph"
l10n="U" oldref="249"><ahelp hid="HID_FUNC_ROEMISCH">Converts a number into a
Roman numeral. The value range must be between 0 and 3999, the modes can be
integers from 0 to 4.</ahelp></paragraph>
- <paragraph xml-lang="en-US" id="hd_id3149299" role="heading"
level="3" l10n="U"
- oldref="250">Syntax</paragraph>
- <paragraph xml-lang="en-US" id="par_id3150593" role="code" l10n="U"
oldref="251">ROMAN(Number; Mode)</paragraph>
- <paragraph xml-lang="en-US" id="par_id3156139" role="paragraph"
l10n="U" oldref="252">
- <emph>Number</emph> is the number that is to be converted into a
Roman numeral.</paragraph>
- <paragraph xml-lang="en-US" id="par_id3153318" role="paragraph"
l10n="U" oldref="253">
- <emph>Mode</emph> (optional) indicates the degree of
simplification. The higher the value, the greater is the simplification of the
Roman number.</paragraph>
- <paragraph xml-lang="en-US" id="hd_id3145306" role="heading"
level="3" l10n="U"
- oldref="254">Example</paragraph>
- <paragraph xml-lang="en-US" id="par_id3151371" role="paragraph"
l10n="U" oldref="255">
- <item type="input">=ROMAN(999)</item> returns CMXCIX</paragraph>
- <paragraph xml-lang="en-US" id="par_id3153938" role="paragraph"
l10n="U" oldref="256">
- <item type="input">=ROMAN(999;0)</item> returns CMXCIX</paragraph>
- <paragraph xml-lang="en-US" id="par_id3148412" role="paragraph"
l10n="U" oldref="257">
- <item type="input">=ROMAN (999;1)</item> returns LMVLIV</paragraph>
- <paragraph xml-lang="en-US" id="par_id3155421" role="paragraph"
l10n="U" oldref="258">
- <item type="input">=ROMAN(999;2)</item> returns XMIX</paragraph>
- <paragraph xml-lang="en-US" id="par_id3149235" role="paragraph"
l10n="U" oldref="259">
- <item type="input">=ROMAN(999;3)</item> returns VMIV</paragraph>
- <paragraph xml-lang="en-US" id="par_id3150624" role="paragraph"
l10n="U" oldref="260">
- <item type="input">=ROMAN(999;4)</item> returns IM</paragraph>
- </section>
- <section id="search">
-<bookmark xml-lang="en-US" branch="index"
id="bm_id3151005"><bookmark_value>SEARCH function</bookmark_value>
+
+<paragraph id="hd_id3153534" role="heading" level="2"
xml-lang="en-US">ROMAN</paragraph>
+<paragraph id="par_id3151256" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_FUNC_ROEMISCH">Converts a number into a Roman numeral. The value range
must be between 0 and 3999, the modes can be integers from 0 to
4.</ahelp></paragraph>
+
+<paragraph id="hd_id3149299" role="heading" level="3"
xml-lang="en-US">Syntax</paragraph>
+<paragraph id="par_id3150593" role="code" xml-lang="en-US">ROMAN(Number;
Mode)</paragraph>
+<paragraph id="par_id3156139" role="paragraph" xml-lang="en-US">
<emph>Number</emph> is the number that is to be converted into a Roman
numeral.</paragraph>
+<paragraph id="par_id3153318" role="paragraph" xml-lang="en-US">
<emph>Mode</emph> (optional) indicates the degree of simplification. The higher
the value, the greater is the simplification of the Roman number.</paragraph>
+
+<paragraph id="hd_id3145306" role="heading" level="3"
xml-lang="en-US">Example</paragraph>
+<paragraph id="par_id3151371" role="paragraph" xml-lang="en-US"> <item
type="input">=ROMAN(999)</item> returns CMXCIX</paragraph>
+<paragraph id="par_id3153938" role="paragraph" xml-lang="en-US"> <item
type="input">=ROMAN(999;0)</item> returns CMXCIX</paragraph>
+<paragraph id="par_id3148412" role="paragraph" xml-lang="en-US"> <item
type="input">=ROMAN (999;1)</item> returns LMVLIV</paragraph>
+<paragraph id="par_id3155421" role="paragraph" xml-lang="en-US"> <item
type="input">=ROMAN(999;2)</item> returns XMIX</paragraph>
+<paragraph id="par_id3149235" role="paragraph" xml-lang="en-US"> <item
type="input">=ROMAN(999;3)</item> returns VMIV</paragraph>
+<paragraph id="par_id3150624" role="paragraph" xml-lang="en-US"> <item
type="input">=ROMAN(999;4)</item> returns IM</paragraph>
+</section>
+
+<section id="search">
+<bookmark xml-lang="en-US" branch="index" id="bm_id3151005">
+ <bookmark_value>SEARCH function</bookmark_value>
</bookmark>
+
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_SUCHEN" id="bm_id3149484"
localize="false"/>
-<paragraph xml-lang="en-US" id="hd_id3151005" role="heading" level="2" l10n="U"
- oldref="122">SEARCH</paragraph>
- <paragraph xml-lang="en-US" id="par_id3148692" role="paragraph"
l10n="U" oldref="123"><ahelp hid="HID_FUNC_SUCHEN">Returns the position of a
text segment within a character string.</ahelp> You can set the start of the
search as an option. The search text can be a number or any sequence of
characters. The search is not case-sensitive.</paragraph>
- <embed href="text/shared/00/00000001.xhp#regulaer"/>
- <paragraph xml-lang="en-US" id="hd_id3152964" role="heading"
level="3" l10n="U"
- oldref="124">Syntax</paragraph>
- <paragraph xml-lang="en-US" id="par_id3154671" role="code" l10n="U"
oldref="125">SEARCH("FindText"; "Text"; Position)</paragraph>
- <paragraph xml-lang="en-US" id="par_id3146080" role="paragraph"
l10n="U" oldref="126">
- <emph>FindText</emph> is the text to be searched for.</paragraph>
- <paragraph xml-lang="en-US" id="par_id3154111" role="paragraph"
l10n="U" oldref="127">
- <emph>Text</emph> is the text where the search will take
place.</paragraph>
- <paragraph xml-lang="en-US" id="par_id3149559" role="paragraph"
l10n="U" oldref="128">
- <emph>Position</emph> (optional) is the position in the text where
the search is to start.</paragraph>
- <paragraph xml-lang="en-US" id="hd_id3147322" role="heading"
level="3" l10n="U"
... etc. - the rest is truncated
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
