INTEGRATION: CWS hcshared04 (1.9.2); FILE MERGED

2006/07/31 12:58:20 ufi 1.9.2.2: mal wieder
2006/07/05 08:39:16 ufi 1.9.2.1: copied_files_from_hcshared03

1 files changed, 55 insertions, 88 deletions

diff --git a/helpcontent2/source/text/scalc/01/04060110.xhp b/helpcontent2/source/text/scalc/01/04060110.xhp
index d5ddb969a3..3b9ba40869 100644
--- a/helpcontent2/source/text/scalc/01/04060110.xhp
+++ b/helpcontent2/source/text/scalc/01/04060110.xhp
@@ -2,56 +2,36 @@
 <!--
  ***********************************************************************
  *
- *  The Contents of this file are made available subject to the terms of
- *  either of the following licenses
+ *  OpenOffice.org - a multi-platform office productivity suite
  *
- *         - GNU Lesser General Public License Version 2.1
- *         - Sun Industry Standards Source License Version 1.1
+ *  $RCSfile: 04060110.xhp,v $
  *
- *  Sun Microsystems Inc., October, 2000
+ *  $Revision: 1.10 $
  *
- *  GNU Lesser General Public License Version 2.1
- *  =============================================
- *  Copyright 2000 by Sun Microsystems, Inc.
- *  901 San Antonio Road, Palo Alto, CA 94303, USA
+ *  last change: $Author: kz $ $Date: 2006-10-05 12:59:19 $
  *
- *  This library is free software; you can redistribute it and/or
- *  modify it under the terms of the GNU Lesser General Public
- *  License version 2.1, as published by the Free Software Foundation.
+ *  The Contents of this file are made available subject to
+ *  the terms of GNU Lesser General Public License Version 2.1.
  *
- *  This library is distributed in the hope that it will be useful,
- *  but WITHOUT ANY WARRANTY; without even the implied warranty of
- *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
- *  Lesser General Public License for more details.
  *
- *  You should have received a copy of the GNU Lesser General Public
- *  License along with this library; if not, write to the Free Software
- *  Foundation, Inc., 59 Temple Place, Suite 330, Boston,
- *  MA  02111-1307  USA
+ *    GNU Lesser General Public License Version 2.1
+ *    =============================================
+ *    Copyright 2005 by Sun Microsystems, Inc.
+ *    901 San Antonio Road, Palo Alto, CA 94303, USA
  *
+ *    This library is free software; you can redistribute it and/or
+ *    modify it under the terms of the GNU Lesser General Public
+ *    License version 2.1, as published by the Free Software Foundation.
  *
- *  Sun Industry Standards Source License Version 1.1
- *  =================================================
- *  The contents of this file are subject to the Sun Industry Standards
- *  Source License Version 1.1 (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.openoffice.org/license.html.
- *
- *  Software provided under this License is provided on an "AS IS" basis,
- *  WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING,
- *  WITHOUT LIMITATION, WARRANTIES THAT THE SOFTWARE IS FREE OF DEFECTS,
- *  MERCHANTABLE, FIT FOR A PARTICULAR PURPOSE, OR NON-INFRINGING.
- *  See the License for the specific provisions governing your rights and
- *  obligations concerning the Software.
- *
- *  The Initial Developer of the Original Code is: Sun Microsystems, Inc..
- *
- *  Copyright: 2000 by Sun Microsystems, Inc.
- *
- *  All Rights Reserved.
- *
- *  Contributor(s): _______________________________________
+ *    This library is distributed in the hope that it will be useful,
+ *    but WITHOUT ANY WARRANTY; without even the implied warranty of
+ *    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
+ *    Lesser General Public License for more details.
  *
+ *    You should have received a copy of the GNU Lesser General Public
+ *    License along with this library; if not, write to the Free Software
+ *    Foundation, Inc., 59 Temple Place, Suite 330, Boston,
+ *    MA  02111-1307  USA
  *
  ************************************************************************
  -->
@@ -64,7 +44,7 @@
 </topic>
 <history>
 <created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created>
-<lastedited date="2006-05-08T15:41:45">converted from old format - fpe</lastedited>
+<lastedited date="2006-07-26T14:30:26">converted from old format - fpe</lastedited>
 </history>
 </meta>
 <body>
@@ -79,9 +59,7 @@
 <sort order="asc">
 <section id="arabic">
 <bookmark xml-lang="en-US" branch="index" id="bm_id3149384"><bookmark_value>ARABIC function</bookmark_value>
-<bookmark_value>Arabic;converting roman numbers to</bookmark_value>
-<bookmark_value>converting;roman numbers, into arabic</bookmark_value>
-</bookmark><comment>mw added two entries</comment>
+</bookmark>
 <bookmark xml-lang="en-US" branch="hid/HID_FUNC_ARABISCH" id="bm_id3145359" localize="false"/>
 <paragraph role="heading" id="hd_id3149384" xml-lang="en-US" level="2" l10n="U" oldref="239">ARABIC</paragraph>
 <paragraph role="paragraph" id="par_id3153558" xml-lang="en-US" 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>
@@ -90,13 +68,25 @@
 <paragraph role="paragraph" id="par_id3151193" xml-lang="en-US" l10n="U" oldref="243">
 <emph>Text</emph> is the text that represents a Roman number.</paragraph>
 <paragraph role="heading" id="hd_id3155758" xml-lang="en-US" level="3" l10n="U" oldref="244">Example</paragraph>
-<paragraph role="paragraph" id="par_id3154621" xml-lang="en-US" l10n="U" oldref="245">Arabic("MXIV") returns 1014</paragraph>
-<paragraph role="paragraph" id="par_id3147553" xml-lang="en-US" l10n="U" oldref="246">Arabic("MMII") returns 2002</paragraph>
+<paragraph role="paragraph" id="par_id3154621" xml-lang="en-US" l10n="U" oldref="245">ARABIC("MXIV") returns 1014</paragraph>
+<paragraph role="paragraph" id="par_id3147553" xml-lang="en-US" l10n="U" oldref="246">ARABIC("MMII") returns 2002</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/HID_FUNC_BAHTTEXT" id="bm_id744346" localize="false"/><comment>i66350</comment>
+<paragraph role="heading" id="hd_id6695455" xml-lang="en-US" level="2" l10n="NEW">BAHTTEXT</paragraph>
+<paragraph role="paragraph" id="par_id354014" xml-lang="en-US" l10n="NEW">Converts a number to Thai text, including the Thai currency names.</paragraph>
+<paragraph role="heading" id="hd_id9942014" xml-lang="en-US" level="3" l10n="NEW">Syntax</paragraph>
+<paragraph role="code" id="par_id8780785" xml-lang="en-US" l10n="NEW">BAHTTEXT(Number)</paragraph>
+<paragraph role="paragraph" id="par_id1539353" xml-lang="en-US" 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 role="heading" id="hd_id9694814" xml-lang="en-US" level="3" l10n="NEW">Example</paragraph>
+<paragraph role="paragraph" id="par_id3289284" xml-lang="en-US" l10n="NEW">BAHTTEXT(12.65) 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_value>converting;integers, to other numbering systems</bookmark_value>
-</bookmark><comment>mw added one entry</comment>
+</bookmark>
 <bookmark xml-lang="en-US" branch="hid/HID_FUNC_BASIS" id="bm_id3150957" localize="false"/>
 <paragraph role="heading" id="hd_id3153072" xml-lang="en-US" level="2" l10n="U" oldref="213">BASE</paragraph>
 <paragraph role="paragraph" id="par_id3153289" xml-lang="en-US" 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>
@@ -121,7 +111,6 @@
 </section>
 <section id="char">
 <bookmark xml-lang="en-US" branch="index" id="bm_id3149321"><bookmark_value>CHAR function</bookmark_value>
-<bookmark_value>converting;codes, into characters</bookmark_value>
 </bookmark>
 <bookmark xml-lang="en-US" branch="hid/HID_FUNC_ZEICHEN" id="bm_id3159128" localize="false"/>
 <paragraph role="heading" id="hd_id3149321" xml-lang="en-US" level="2" l10n="U" oldref="201">CHAR</paragraph>
@@ -135,8 +124,7 @@
 </section>
 <section id="clean">
 <bookmark xml-lang="en-US" branch="index" id="bm_id3149009"><bookmark_value>CLEAN function</bookmark_value>
-<bookmark_value>deleting;non-printing characters</bookmark_value>
-</bookmark><comment>mw added "deleting;"</comment>
+</bookmark>
 <bookmark xml-lang="en-US" branch="hid/HID_FUNC_SAEUBERN" id="bm_id3148729" localize="false"/>
 <paragraph role="heading" id="hd_id3149009" xml-lang="en-US" level="2" l10n="U" oldref="132">CLEAN</paragraph>
 <paragraph role="paragraph" id="par_id3150482" xml-lang="en-US" l10n="U" oldref="133"><ahelp hid="HID_FUNC_SAEUBERN">All non-printing characters are removed from the string.</ahelp></paragraph>
@@ -161,8 +149,7 @@
 </section>
 <section id="concatenate">
 <bookmark xml-lang="en-US" branch="index" id="bm_id3149688"><bookmark_value>CONCATENATE function</bookmark_value>
-<bookmark_value>combining;text strings</bookmark_value>
-</bookmark><comment>mw added one entry</comment>
+</bookmark>
 <bookmark xml-lang="en-US" branch="hid/HID_FUNC_VERKETTEN" id="bm_id3153084" localize="false"/>
 <paragraph role="heading" id="hd_id3149688" xml-lang="en-US" level="2" l10n="U" oldref="167">CONCATENATE</paragraph>
 <paragraph role="paragraph" id="par_id3154524" xml-lang="en-US" l10n="U" oldref="168"><ahelp hid="HID_FUNC_VERKETTEN">Combines several text strings into one string.</ahelp></paragraph>
@@ -193,8 +180,7 @@
 </section>
 <section id="dollar">
 <bookmark xml-lang="en-US" branch="index" id="bm_id3148402"><bookmark_value>DOLLAR function</bookmark_value>
-<bookmark_value>converting;numbers, into currency format</bookmark_value>
-</bookmark><comment>mw added "converting;"</comment>
+</bookmark>
 <bookmark xml-lang="en-US" branch="hid/HID_FUNC_DM" id="bm_id3149532" localize="false"/>
 <paragraph role="heading" id="hd_id3148402" xml-lang="en-US" level="2" l10n="U" oldref="11">DOLLAR</paragraph>
 <paragraph role="paragraph" id="par_id3153049" xml-lang="en-US" 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 <emph>value</emph> field enter the number to be converted to currency. Optionally, you may enter the number of decimal places in the <emph>decimals</emph> field. If no value is specified, all numbers in currency format will be displayed with two decimal places. </paragraph>
@@ -211,8 +197,7 @@
 </section>
 <section id="exact">
 <bookmark xml-lang="en-US" branch="index" id="bm_id3150685"><bookmark_value>EXACT function</bookmark_value>
-<bookmark_value>comparing text strings</bookmark_value>
-</bookmark><comment>mw added one entry</comment>
+</bookmark>
 <bookmark xml-lang="en-US" branch="hid/HID_FUNC_IDENTISCH" id="bm_id3155081" localize="false"/>
 <paragraph role="heading" id="hd_id3150685" xml-lang="en-US" level="2" l10n="U" oldref="78">EXACT</paragraph>
 <paragraph role="paragraph" id="par_id3158413" xml-lang="en-US" 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>
@@ -244,8 +229,7 @@
 </section>
 <section id="fixed">
 <bookmark xml-lang="en-US" branch="index" id="bm_id3149268"><bookmark_value>FIXED function</bookmark_value>
-<bookmark_value>number formats;applying to number columns</bookmark_value>
-</bookmark><comment>mw added one entry</comment>
+</bookmark>
 <bookmark xml-lang="en-US" branch="hid/HID_FUNC_FEST" id="bm_id3149450" localize="false"/>
 <paragraph role="heading" id="hd_id3149268" xml-lang="en-US" level="2" l10n="U" oldref="34">FIXED</paragraph>
 <paragraph role="paragraph" id="par_id3155833" xml-lang="en-US" l10n="U" oldref="35"><ahelp hid="HID_FUNC_FEST">Specifies that a number be displayed with a fixed number of decimal places and with or without a thousands separator. This function can be used to apply a uniform format to a column of numbers.</ahelp></paragraph>
@@ -277,9 +261,7 @@
 </section>
 <section id="len">
 <bookmark xml-lang="en-US" branch="index" id="bm_id3156110"><bookmark_value>LEN function</bookmark_value>
-<bookmark_value>length of text strings</bookmark_value>
-<bookmark_value>counting;characters in text strings</bookmark_value>
-</bookmark><comment>mw added two entries</comment>
+</bookmark>
 <bookmark xml-lang="en-US" branch="hid/HID_FUNC_LAENGE" id="bm_id3154050" localize="false"/>
 <paragraph role="heading" id="hd_id3156110" xml-lang="en-US" level="2" l10n="U" oldref="104">LEN</paragraph>
 <paragraph role="paragraph" id="par_id3150147" xml-lang="en-US" l10n="U" oldref="105"><ahelp hid="HID_FUNC_LAENGE">Returns the length of a string including spaces.</ahelp></paragraph>
@@ -293,9 +275,7 @@
 </section>
 <section id="lower">
 <bookmark xml-lang="en-US" branch="index" id="bm_id3153983"><bookmark_value>LOWER function</bookmark_value>
-<bookmark_value>converting;uppercase, into lowercase</bookmark_value>
-<bookmark_value>lowercase letters;converting uppercase letters</bookmark_value>
-</bookmark><comment>mw added two entries</comment>
+</bookmark>
 <bookmark xml-lang="en-US" branch="hid/HID_FUNC_KLEIN" id="bm_id3151173" localize="false"/>
 <paragraph role="heading" id="hd_id3153983" xml-lang="en-US" level="2" l10n="U" oldref="87">LOWER</paragraph>
 <paragraph role="paragraph" id="par_id3152791" xml-lang="en-US" l10n="U" oldref="88"><ahelp hid="HID_FUNC_KLEIN">Converts all uppercase letters in a text string to lowercase.</ahelp></paragraph>
@@ -325,9 +305,7 @@
 </section>
 <section id="proper">
 <bookmark xml-lang="en-US" branch="index" id="bm_id3159143"><bookmark_value>PROPER function</bookmark_value>
-<bookmark_value>capitalizing first letters in words</bookmark_value>
-<bookmark_value>words;capitalizing first letters</bookmark_value>
-</bookmark><comment>mw added two entries</comment>
+</bookmark>
 <bookmark xml-lang="en-US" branch="hid/HID_FUNC_GROSS2" id="bm_id3154897" localize="false"/>
 <paragraph role="heading" id="hd_id3159143" xml-lang="en-US" level="2" l10n="U" oldref="70">PROPER</paragraph>
 <paragraph role="paragraph" id="par_id3149768" xml-lang="en-US" l10n="U" oldref="71"><ahelp hid="HID_FUNC_GROSS2">Capitalizes the first letter in all words of a text string.</ahelp></paragraph>
@@ -360,8 +338,7 @@
 </section>
 <section id="rept">
 <bookmark xml-lang="en-US" branch="index" id="bm_id3149741"><bookmark_value>REPT function</bookmark_value>
-<bookmark_value>repeating;text strings</bookmark_value>
-</bookmark><comment>mw added one entry</comment>
+</bookmark>
 <bookmark xml-lang="en-US" branch="hid/HID_FUNC_WIEDERHOLEN" id="bm_id3155582" localize="false"/>
 <paragraph role="heading" id="hd_id3149741" xml-lang="en-US" level="2" l10n="U" oldref="193">REPT</paragraph>
 <paragraph role="paragraph" id="par_id3153748" xml-lang="en-US" l10n="U" oldref="194"><ahelp hid="HID_FUNC_WIEDERHOLEN">Repeats a character string by the given <emph>number</emph> of copies.</ahelp></paragraph>
@@ -392,8 +369,7 @@
 </section>
 <section id="roman">
 <bookmark xml-lang="en-US" branch="index" id="bm_id3153534"><bookmark_value>ROMAN function</bookmark_value>
-<bookmark_value>converting;arabic numbers, into roman</bookmark_value>
-</bookmark><comment>mw added one entry</comment>
+</bookmark>
 <bookmark xml-lang="en-US" branch="hid/HID_FUNC_ROEMISCH" id="bm_id3144755" localize="false"/>
 <paragraph role="heading" id="hd_id3153534" xml-lang="en-US" level="2" l10n="U" oldref="248">ROMAN</paragraph>
 <paragraph role="paragraph" id="par_id3151256" xml-lang="en-US" 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>
@@ -443,17 +419,15 @@
 <emph>search_text </emph>is the text segment that is to be replaced (a number of times).</paragraph>
 <paragraph role="paragraph" id="par_id3145779" xml-lang="en-US" l10n="U" oldref="180">
 <emph>new text</emph> is the text that is to replace the text segment.</paragraph>
-<paragraph role="paragraph" id="par_id3150348" xml-lang="en-US" l10n="U" oldref="181">
-<emph>occurrence</emph> (optional) indicates how many occurrences of the search text are to be replaced. If this parameter is missing the search text is replaced throughout.</paragraph>
+<paragraph role="paragraph" id="par_id3150348" xml-lang="en-US" l10n="CHG" oldref="181">
+<emph>occurrence</emph> (optional) indicates which occurrence of the search text is to be replaced. If this parameter is missing the search text is replaced throughout.</paragraph>
 <paragraph role="heading" id="hd_id3150946" xml-lang="en-US" level="3" l10n="U" oldref="182">Example</paragraph>
 <paragraph role="paragraph" id="par_id3150412" xml-lang="en-US" l10n="U" oldref="183">SUBSTITUTE("123123123"; "3"; "abc") returns <emph>12abc12abc12abc</emph>.</paragraph>
 <paragraph role="paragraph" id="par_id3154915" xml-lang="en-US" l10n="U" oldref="238">SUBSTITUTE("123123123"; "3"; "abc"; 2) returns <emph>12312abc123</emph>.</paragraph>
 </section>
 <section id="t">
 <bookmark xml-lang="en-US" branch="index" id="bm_id3148977"><bookmark_value>T function</bookmark_value>
-<bookmark_value>converting;numbers, into blank text</bookmark_value>
-<bookmark_value>numbers;converting into blank text</bookmark_value>
-</bookmark><comment>mw added two entries</comment>
+</bookmark>
 <bookmark xml-lang="en-US" branch="hid/HID_FUNC_T" id="bm_id3156051" localize="false"/>
 <paragraph role="heading" id="hd_id3148977" xml-lang="en-US" level="2" l10n="U" oldref="140">T</paragraph>
 <paragraph role="paragraph" id="par_id3154359" xml-lang="en-US" l10n="U" oldref="141"><ahelp hid="HID_FUNC_T">This function converts a number to a blank text string.</ahelp></paragraph>
@@ -466,8 +440,7 @@
 </section>
 <section id="text">
 <bookmark xml-lang="en-US" branch="index" id="bm_id3147132"><bookmark_value>TEXT function</bookmark_value>
-<bookmark_value>numbers;converting into text</bookmark_value>
-</bookmark><comment>mw added one entry</comment>
+</bookmark>
 <bookmark xml-lang="en-US" branch="hid/HID_FUNC_TEXT" id="bm_id3156426" localize="false"/>
 <paragraph role="heading" id="hd_id3147132" xml-lang="en-US" level="2" l10n="U" oldref="158">TEXT</paragraph>
 <paragraph role="paragraph" id="par_id3147213" xml-lang="en-US" l10n="U" oldref="159"><ahelp hid="HID_FUNC_TEXT">Converts a number into text according to a given format.</ahelp></paragraph>
@@ -480,9 +453,7 @@
 </section>
 <section id="trim">
 <bookmark xml-lang="en-US" branch="index" id="bm_id3151039"><bookmark_value>TRIM function</bookmark_value>
-<bookmark_value>deleting;spaces in front of text</bookmark_value>
-<bookmark_value>aligning;text in cells</bookmark_value>
-</bookmark><comment>mw added two entries</comment>
+</bookmark>
 <bookmark xml-lang="en-US" branch="hid/HID_FUNC_GLAETTEN" id="bm_id3150584" localize="false"/>
 <paragraph role="heading" id="hd_id3151039" xml-lang="en-US" level="2" l10n="U" oldref="54">TRIM</paragraph>
 <paragraph role="paragraph" id="par_id3157888" xml-lang="en-US" l10n="CHG" oldref="55"><ahelp hid="HID_FUNC_GLAETTEN">Removes spaces from a string, leaving only a single space character between words.</ahelp></paragraph>
@@ -495,9 +466,7 @@
 </section>
 <section id="upper">
 <bookmark xml-lang="en-US" branch="index" id="bm_id3145178"><bookmark_value>UPPER function</bookmark_value>
-<bookmark_value>converting;lowercase, into uppercase</bookmark_value>
-<bookmark_value>lowercase letters;converting to uppercase</bookmark_value>
-</bookmark><comment>mw added two entries</comment>
+</bookmark>
 <bookmark xml-lang="en-US" branch="hid/HID_FUNC_GROSS" id="bm_id3145189" localize="false"/>
 <paragraph role="heading" id="hd_id3145178" xml-lang="en-US" level="2" l10n="U" oldref="62">UPPER</paragraph>
 <paragraph role="paragraph" id="par_id3162905" xml-lang="en-US" l10n="U" oldref="63"><ahelp hid="HID_FUNC_GROSS">Converts the string specified in the <emph>text</emph> field to uppercase.</ahelp></paragraph>
@@ -510,8 +479,6 @@
 </section>
 <section id="value">
 <bookmark xml-lang="en-US" branch="index" id="bm_id3150802"><bookmark_value>VALUE function</bookmark_value>
-<bookmark_value>numbers;converting text into</bookmark_value>
-<bookmark_value>converting;text, into numbers</bookmark_value>
 </bookmark>
 <bookmark xml-lang="en-US" branch="hid/HID_FUNC_WERT" id="bm_id3150814" localize="false"/>
 <paragraph role="heading" id="hd_id3150802" xml-lang="en-US" level="2" l10n="U" oldref="185">VALUE</paragraph>