AllLangHelp_scalc.mk | 12 + helpers/calc_text_func.pl | 2 source/text/scalc/01/04060110.xhp | 236 +------------------------------ source/text/scalc/01/func_proper.xhp | 38 ++++ source/text/scalc/01/func_replace.xhp | 40 +++++ source/text/scalc/01/func_rept.xhp | 40 +++++ source/text/scalc/01/func_right.xhp | 39 +++++ source/text/scalc/01/func_search.xhp | 39 +++++ source/text/scalc/01/func_substitute.xhp | 42 +++++ source/text/scalc/01/func_t.xhp | 40 +++++ source/text/scalc/01/func_text.xhp | 42 +++++ source/text/scalc/01/func_trim.xhp | 38 ++++ source/text/scalc/01/func_unichar.xhp | 40 +++++ source/text/scalc/01/func_unicode.xhp | 40 +++++ source/text/scalc/01/func_upper.xhp | 38 ++++ 15 files changed, 501 insertions(+), 225 deletions(-)
New commits: commit 3b6506e4e1b6b4dd41f4e5e8fda8315426c57d9c Author: Pierre F <[email protected]> AuthorDate: Fri Nov 1 16:39:06 2024 +0200 Commit: Olivier Hallot <[email protected]> CommitDate: Sat Nov 2 17:47:51 2024 +0100 tdf#143846 split PROPER REPLACE REPT RIGHT SEARCH ... ... SUBSTITUTE T TEXT TRIM UNICHAR UNICODE UPPER Change-Id: I2ef1a659fbaf481dac1329f86178b8cd9b786ce2 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/175912 Reviewed-by: Olivier Hallot <[email protected]> Tested-by: Jenkins diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk index 3614c20275..62d82eb3f4 100644 --- a/AllLangHelp_scalc.mk +++ b/AllLangHelp_scalc.mk @@ -271,6 +271,18 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\ helpcontent2/source/text/scalc/01/func_opt_prob_hit \ helpcontent2/source/text/scalc/01/func_opt_prob_inmoney \ helpcontent2/source/text/scalc/01/func_opt_touch \ + helpcontent2/source/text/scalc/01/func_proper \ + helpcontent2/source/text/scalc/01/func_replace \ + helpcontent2/source/text/scalc/01/func_rept \ + helpcontent2/source/text/scalc/01/func_right \ + helpcontent2/source/text/scalc/01/func_search \ + helpcontent2/source/text/scalc/01/func_substitute \ + helpcontent2/source/text/scalc/01/func_t \ + helpcontent2/source/text/scalc/01/func_text \ + helpcontent2/source/text/scalc/01/func_trim \ + helpcontent2/source/text/scalc/01/func_unichar \ + helpcontent2/source/text/scalc/01/func_unicode \ + helpcontent2/source/text/scalc/01/func_upper \ helpcontent2/source/text/scalc/01/func_randarray \ helpcontent2/source/text/scalc/01/func_rawsubtract \ helpcontent2/source/text/scalc/01/func_regex \ diff --git a/helpers/calc_text_func.pl b/helpers/calc_text_func.pl index 195c778d8a..994d3d793b 100644 --- a/helpers/calc_text_func.pl +++ b/helpers/calc_text_func.pl @@ -7,7 +7,7 @@ $hlp0='helpers/calc_text_func0.xsl'; #replace section $source= 'source/text/scalc/01/04060110.xhp'; $tmp = $source . '.tmp'; -@todo = qw/ EXACT FIND FIXED LEFT LEFTB LEN LENB LOWER MID MIDB PROPER REPLACE REPT RIGHT RIGHTB SEARCH SUBSTITUTE T TEXT TRIM UNICHAR UNICODE UPPER /; +@todo = qw/ LEFTB LENB MIDB RIGHTB /; for $F ( @ARGV) { diff --git a/source/text/scalc/01/04060110.xhp b/source/text/scalc/01/04060110.xhp index 57881fb3b5..fb03ee3956 100644 --- a/source/text/scalc/01/04060110.xhp +++ b/source/text/scalc/01/04060110.xhp @@ -221,88 +221,17 @@ <paragraph 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 branch="index" id="bm_id3159143"> - <bookmark_value>PROPER function</bookmark_value> -</bookmark> - -<bookmark branch="hid/SC_HID_FUNC_GROSS2" id="bm_id3154897" localize="false"/> - -<h2 id="hd_id3159143">PROPER</h2> -<paragraph id="par_id3149768" role="paragraph"><ahelp hid="HID_FUNC_GROSS2">Capitalizes the first letter in all words of a text string.</ahelp></paragraph> - -<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> -<paragraph id="par_id3154260" role="code">PROPER("Text")</paragraph> -<paragraph id="par_id3147509" role="paragraph"> <emph>Text</emph> refers to the text to be converted.</paragraph> - -<embed href="text/scalc/01/common_func.xhp#sectionexample"/> -<paragraph id="par_id3155364" role="paragraph"> <item type="input">=PROPER("the document foundation")</item> returns The Document Foundation.</paragraph> -</section> +<section id="proper"><embed href="text/scalc/01/func_proper.xhp#func_proper"/></section> <section id="regex"> <embed href="text/scalc/01/func_regex.xhp#func_regex"/> </section> -<section id="replace"> -<bookmark branch="index" id="bm_id3149171"> - <bookmark_value>REPLACE function</bookmark_value> -</bookmark> - -<bookmark branch="hid/SC_HID_FUNC_ERSETZEN" id="bm_id3149990" localize="false"/> - -<h2 id="hd_id3149171">REPLACE</h2> -<paragraph id="par_id3148925" role="paragraph"><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">VALUE</link> function.</paragraph> -<paragraph id="par_id3158426" role="paragraph">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> - -<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> -<paragraph id="par_id3147286" role="code">REPLACE("Text"; Position; Length; "NewText")</paragraph> -<paragraph id="par_id3149797" role="paragraph"> <emph>Text</emph> refers to text of which a part will be replaced.</paragraph> -<paragraph id="par_id3166451" role="paragraph"> <emph>Position</emph> refers to the position within the text where the replacement will begin.</paragraph> -<paragraph id="par_id3156040" role="paragraph"> <emph>Length</emph> is the number of characters in <emph>Text</emph> to be replaced.</paragraph> -<paragraph id="par_id3159188" role="paragraph"> <emph>NewText</emph> refers to the text which replaces <emph>Text</emph>.</paragraph> - -<embed href="text/scalc/01/common_func.xhp#sectionexample"/> -<paragraph id="par_id3154096" role="paragraph"> <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 branch="index" id="bm_id3149741"> - <bookmark_value>REPT function</bookmark_value> -</bookmark> - -<bookmark branch="hid/SC_HID_FUNC_WIEDERHOLEN" id="bm_id3155582" localize="false"/> - -<h2 id="hd_id3149741">REPT</h2> -<paragraph id="par_id3153748" role="paragraph"><ahelp hid="HID_FUNC_WIEDERHOLEN">Repeats a character string by the given <emph>number</emph> of copies.</ahelp></paragraph> - -<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> -<paragraph id="par_id3150494" role="code">REPT("Text"; Number)</paragraph> -<paragraph id="par_id3154859" role="paragraph"> <emph>Text</emph> is the text to be repeated.</paragraph> -<paragraph id="par_id3150638" role="paragraph"> <emph>Number</emph> is the number of repetitions.</paragraph> - -<embed href="text/scalc/01/common_func.xhp#sectionexample"/> -<paragraph id="par_id3148626" role="paragraph"> <item type="input">=REPT("Good morning";2)</item> returns Good morningGood morning.</paragraph> - -<tip id="par_id381626381556310">Refer to the <link href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/REPT";>REPT</link> wiki page for more details about this function.</tip></section> - -<section id="right"> -<bookmark branch="index" id="bm_id3149805"> - <bookmark_value>RIGHT function</bookmark_value> -</bookmark> - -<bookmark branch="hid/SC_HID_FUNC_RECHTS" id="bm_id3154602" localize="false"/> - -<h2 id="hd_id3149805">RIGHT</h2> -<paragraph id="par_id3145375" role="paragraph"><ahelp hid="HID_FUNC_RECHTS">Returns the last character or characters of a text.</ahelp></paragraph> +<section id="replace"><embed href="text/scalc/01/func_replace.xhp#func_replace"/></section> -<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> -<paragraph id="par_id3154344" role="code">RIGHT("Text" [; Number])</paragraph> -<paragraph id="par_id3149426" role="paragraph"> <emph>Text</emph> is the text of which the right part is to be determined.</paragraph> -<paragraph id="par_id3153350" role="paragraph"> <emph>Number</emph> (optional) is the number of characters from the right part of the text. If this parameter is not defined, one character is returned.</paragraph> +<section id="rept"><embed href="text/scalc/01/func_rept.xhp#func_rept"/></section> -<embed href="text/scalc/01/common_func.xhp#sectionexample"/> -<paragraph id="par_id3151132" role="paragraph"> <item type="input">=RIGHT("Sun";2)</item> returns un.</paragraph> -</section> +<section id="right"><embed href="text/scalc/01/func_right.xhp#func_right"/></section> <section id="rightb"> <bookmark branch="index" id="bm_id2949805"> @@ -331,162 +260,21 @@ <embed href="text/scalc/01/func_roman.xhp#func_roman"/> </section> -<section id="search"> -<bookmark branch="index" id="bm_id3151005"> - <bookmark_value>SEARCH function</bookmark_value> -</bookmark> - -<bookmark branch="hid/SC_HID_FUNC_SUCHEN" id="bm_id3149484" localize="false"/> - -<h2 id="hd_id3151005">SEARCH</h2> -<paragraph id="par_id3148692" role="paragraph"><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. If the text is not found, returns error 519 (#VALUE).</paragraph> -<embed href="text/shared/00/00000001.xhp#regex"/> -<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> -<paragraph id="par_id3154671" role="code">SEARCH("FindText"; "Text" [; Position])</paragraph> -<paragraph id="par_id3146080" role="paragraph"> <emph>FindText</emph> is the text to be searched for.</paragraph> -<paragraph id="par_id3154111" role="paragraph"> <emph>Text</emph> is the text where the search will take place.</paragraph> -<paragraph id="par_id3149559" role="paragraph"> <emph>Position</emph> (optional) is the position in the text where the search is to start.</paragraph> - -<embed href="text/scalc/01/common_func.xhp#sectionexample"/> -<paragraph id="par_id3154564" role="paragraph"> <item type="input">=SEARCH(54;998877665544)</item> returns 10.</paragraph> -</section> - -<section id="substitute"> -<bookmark branch="index" id="bm_id3154830"> - <bookmark_value>SUBSTITUTE function</bookmark_value> -</bookmark> - -<bookmark branch="hid/SC_HID_FUNC_WECHSELN" id="bm_id3147090" localize="false"/> - -<h2 id="hd_id3154830">SUBSTITUTE</h2> -<paragraph id="par_id3153698" role="paragraph"><ahelp hid="HID_FUNC_WECHSELN">Substitutes new text for old text in a string.</ahelp></paragraph> - -<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> -<paragraph id="par_id3147582" role="code">SUBSTITUTE("Text"; "SearchText"; "NewText" [; Occurrence])</paragraph> -<paragraph id="par_id3153675" role="paragraph"> <emph>Text</emph> is the text in which text segments are to be exchanged.</paragraph> -<paragraph id="par_id3156155" role="paragraph"> <emph>SearchText </emph>is the text segment that is to be replaced (a number of times).</paragraph> -<paragraph id="par_id3145779" role="paragraph"> <emph>NewText</emph> is the text that is to replace the text segment.</paragraph> -<paragraph id="par_id3150348" role="paragraph"> <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> - -<embed href="text/scalc/01/common_func.xhp#sectionexample"/> -<paragraph id="par_id3150412" role="paragraph"> <item type="input">=SUBSTITUTE("123123123";"3";"abc")</item> returns 12abc12abc12abc.</paragraph> -<paragraph id="par_id3154915" role="paragraph"> <item type="input">=SUBSTITUTE("123123123";"3";"abc";2)</item> returns 12312abc123.</paragraph> -</section> - -<section id="t"> -<bookmark branch="index" id="bm_id3148977"> - <bookmark_value>T function</bookmark_value> -</bookmark> - -<bookmark branch="hid/SC_HID_FUNC_T" id="bm_id3156051" localize="false"/> - -<h2 id="hd_id3148977">T</h2> -<paragraph id="par_id3154359" role="paragraph"><ahelp hid="HID_FUNC_T">This function returns the target text, or a blank text string if the target is not text.</ahelp></paragraph> -<paragraph id="par_id9115573" role="paragraph">If an error occurs the function returns the error value.</paragraph> - -<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> -<paragraph id="par_id3155871" role="code">T(Value)</paragraph> -<paragraph id="par_id3154726" role="paragraph">If <emph>Value</emph> is a text string or refers to a text string, T returns that text string; otherwise it returns a blank text string.</paragraph> - -<embed href="text/scalc/01/common_func.xhp#sectionexample"/> -<paragraph id="par_id3151062" role="paragraph"> <item type="input">=T(12345)</item> returns an empty string. </paragraph> -<paragraph id="par_id4650105" role="paragraph"> <item type="input">=T("12345")</item> returns the string 12345.</paragraph> -</section> - -<section id="text"> -<bookmark branch="index" id="bm_id3147132"> - <bookmark_value>TEXT function</bookmark_value> -</bookmark> - -<bookmark branch="hid/SC_HID_FUNC_TEXT" id="bm_id3156426" localize="false"/> - -<h2 id="hd_id3147132">TEXT</h2> -<paragraph id="par_id3147213" role="paragraph"><ahelp hid="HID_FUNC_TEXT">Converts a value into text according to a given format.</ahelp></paragraph> - -<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> -<paragraph id="par_id3147377" role="code">TEXT(Value; Format)</paragraph> -<paragraph id="par_id3147389" role="paragraph"> <emph>Value</emph> is the value (numerical or textual) to be converted.</paragraph> -<paragraph id="par_id3156167" role="paragraph"> <emph>Format</emph> is the text which defines the format. Use decimal and thousands separators according to the language set in the cell format.</paragraph> - -<embed href="text/scalc/01/common_func.xhp#sectionexample"/> -<paragraph id="par_id9044770" role="paragraph"> <item type="input">=TEXT(12.34567;"###.##")</item> returns the text 12.35</paragraph> -<paragraph id="par_id3674123" role="paragraph"> <item type="input">=TEXT(12.34567;"000.00")</item> returns the text 012.35</paragraph> -<paragraph id="par_id3674124" role="paragraph"> <item type="input">=TEXT("xyz";"=== @ ===")</item> returns the text === xyz ===</paragraph> - -<tip id="par_id3145364">See also <link href="text/shared/01/05020301.xhp">Number format codes</link>: custom format codes defined by the user.</tip> -</section> - -<section id="trim"> -<bookmark branch="index" id="bm_id3151039"> - <bookmark_value>TRIM function</bookmark_value> -</bookmark> - -<bookmark branch="hid/SC_HID_FUNC_GLAETTEN" id="bm_id3150584" localize="false"/> - -<h2 id="hd_id3151039">TRIM</h2> -<paragraph id="par_id3157888" role="paragraph"><ahelp hid="HID_FUNC_GLAETTEN">Removes spaces from a string, leaving only a single space character between words.</ahelp></paragraph> - -<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> -<paragraph id="par_id3151349" role="code">TRIM("Text")</paragraph> -<paragraph id="par_id3151362" role="paragraph"> <emph>Text</emph> refers to text in which spaces are to be removed.</paragraph> - -<embed href="text/scalc/01/common_func.xhp#sectionexample"/> -<paragraph id="par_id3156074" role="paragraph"> <item type="input">=TRIM(" hello world ")</item> returns hello world without leading and trailing spaces and with single space between words.</paragraph> -</section> - -<section id="unichar"> -<bookmark branch="hid/SC_HID_FUNC_UNICHAR" id="bm_id0907200904004674" localize="false"/> -<bookmark branch="index" id="bm_id0907200904030935"> - <bookmark_value>UNICHAR function</bookmark_value> -</bookmark> - - -<h2 id="hd_id0907200904022525">UNICHAR</h2> -<paragraph id="par_id0907200904022538" role="paragraph"><ahelp hid=".">Converts a code number into a Unicode character or letter.</ahelp></paragraph> - -<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> -<paragraph id="par_id0907200904123753" role="paragraph"><item type="literal">UNICHAR(number)</item></paragraph> - -<embed href="text/scalc/01/common_func.xhp#sectionexample"/> -<paragraph id="par_id090720090412378" role="paragraph">=UNICHAR(169) returns the Copyright character <emph>©</emph>.</paragraph> -<tip id="par_id050220170755399756">See also the UNICODE() function.</tip> -</section> - -<section id="unicode"> -<bookmark branch="hid/SC_HID_FUNC_UNICODE" id="bm_id0907200904011330" localize="false"/> -<bookmark branch="index" id="bm_id0907200904033543"> - <bookmark_value>UNICODE function</bookmark_value> -</bookmark> - - -<h2 id="hd_id0907200904022588">UNICODE</h2> -<paragraph id="par_id0907200904022594" role="paragraph"><ahelp hid=".">Returns the numeric code for the first Unicode character in a text string.</ahelp></paragraph> +<section id="search"><embed href="text/scalc/01/func_search.xhp#func_search"/></section> -<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> -<paragraph id="par_id0907200904123846" role="paragraph"><item type="literal">UNICODE("Text")</item></paragraph> +<section id="substitute"><embed href="text/scalc/01/func_substitute.xhp#func_substitute"/></section> -<embed href="text/scalc/01/common_func.xhp#sectionexample"/> -<paragraph id="par_id0907200904123919" role="paragraph">=UNICODE("©") returns the Unicode number 169 for the Copyright character.</paragraph> -<tip id="par_id050220170755393174">See also the UNICHAR() function.</tip> -</section> +<section id="t"><embed href="text/scalc/01/func_t.xhp#func_t"/></section> -<section id="upper"> -<bookmark branch="index" id="bm_id3145178"> - <bookmark_value>UPPER function</bookmark_value> -</bookmark> +<section id="text"><embed href="text/scalc/01/func_text.xhp#func_text"/></section> -<bookmark branch="hid/SC_HID_FUNC_GROSS" id="bm_id3145189" localize="false"/> +<section id="trim"><embed href="text/scalc/01/func_trim.xhp#func_trim"/></section> -<h2 id="hd_id3145178">UPPER</h2> -<paragraph id="par_id3162905" role="paragraph"><ahelp hid="HID_FUNC_GROSS">Converts the string specified in the <emph>text</emph> field to uppercase.</ahelp></paragraph> +<section id="unichar"><embed href="text/scalc/01/func_unichar.xhp#func_unichar"/></section> -<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> -<paragraph id="par_id3148539" role="code">UPPER("Text")</paragraph> -<paragraph id="par_id3148496" role="paragraph"> <emph>Text</emph> refers to the lower case letters you want to convert to upper case.</paragraph> +<section id="unicode"><embed href="text/scalc/01/func_unicode.xhp#func_unicode"/></section> -<embed href="text/scalc/01/common_func.xhp#sectionexample"/> -<paragraph id="par_id3146757" role="paragraph"> <item type="input">=UPPER("Good Morning")</item> returns GOOD MORNING.</paragraph> -</section> +<section id="upper"><embed href="text/scalc/01/func_upper.xhp#func_upper"/></section> <section id="value"> <embed href="text/scalc/01/func_value.xhp#func_value"/> diff --git a/source/text/scalc/01/func_proper.xhp b/source/text/scalc/01/func_proper.xhp new file mode 100644 index 0000000000..13b5ded0c0 --- /dev/null +++ b/source/text/scalc/01/func_proper.xhp @@ -0,0 +1,38 @@ +<?xml version="1.0" encoding="UTF-8"?> +<helpdocument version="1.0"> + <!-- + * This file is part of the LibreOffice project. + * + * This Source Code Form is subject to the terms of the Mozilla Public + * License, v. 2.0. If a copy of the MPL was not distributed with this + * file, You can obtain one at http://mozilla.org/MPL/2.0/. + * + --> + <meta> + <topic id="calcfunc_proper" indexer="include" status="PUBLISH"> + <title id="tit">PROPER Function</title> + <filename>/text/scalc/01/func_proper.xhp</filename> + </topic> + </meta> + <body> + <bookmark branch="index" id="bm_id3159143"> + <bookmark_value>PROPER function</bookmark_value> +</bookmark> + <bookmark branch="hid/SC_HID_FUNC_GROSS2" id="bm_id3154897" localize="false"/> + <section id="func_proper"> + <h1 id="hd_id3159143"> + <variable id="proper_h1"> + <link href="text/scalc/01/func_proper.xhp">PROPER</link> + </variable> + </h1> + <paragraph id="par_id3149768" role="paragraph"> + <ahelp hid="HID_FUNC_GROSS2">Capitalizes the first letter in all words of a text string.</ahelp> + </paragraph> + </section> + <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> + <paragraph id="par_id3154260" role="code">PROPER("Text")</paragraph> + <paragraph id="par_id3147509" role="paragraph"> <emph>Text</emph> refers to the text to be converted.</paragraph> + <embed href="text/scalc/01/common_func.xhp#sectionexample"/> + <paragraph id="par_id3155364" role="paragraph"> <item type="input">=PROPER("the document foundation")</item> returns The Document Foundation.</paragraph> + </body> +</helpdocument> diff --git a/source/text/scalc/01/func_replace.xhp b/source/text/scalc/01/func_replace.xhp new file mode 100644 index 0000000000..bd039f80a0 --- /dev/null +++ b/source/text/scalc/01/func_replace.xhp @@ -0,0 +1,40 @@ +<?xml version="1.0" encoding="UTF-8"?> +<helpdocument version="1.0"> + <!-- + * This file is part of the LibreOffice project. + * + * This Source Code Form is subject to the terms of the Mozilla Public + * License, v. 2.0. If a copy of the MPL was not distributed with this + * file, You can obtain one at http://mozilla.org/MPL/2.0/. + * + --> + <meta> + <topic id="calcfunc_replace" indexer="include" status="PUBLISH"> + <title id="tit">REPLACE Function</title> + <filename>/text/scalc/01/func_replace.xhp</filename> + </topic> + </meta> + <body> + <bookmark branch="index" id="bm_id3149171"> + <bookmark_value>REPLACE function</bookmark_value> +</bookmark> + <bookmark branch="hid/SC_HID_FUNC_ERSETZEN" id="bm_id3149990" localize="false"/> + <section id="func_replace"> + <h1 id="hd_id3149171"> + <variable id="replace_h1"> + <link href="text/scalc/01/func_replace.xhp">REPLACE</link> + </variable> + </h1> + <paragraph id="par_id3148925" role="paragraph"><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">VALUE</link> function.</paragraph> + </section> + <paragraph id="par_id3158426" role="paragraph">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> + <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> + <paragraph id="par_id3147286" role="code">REPLACE("Text"; Position; Length; "NewText")</paragraph> + <paragraph id="par_id3149797" role="paragraph"> <emph>Text</emph> refers to text of which a part will be replaced.</paragraph> + <paragraph id="par_id3166451" role="paragraph"> <emph>Position</emph> refers to the position within the text where the replacement will begin.</paragraph> + <paragraph id="par_id3156040" role="paragraph"> <emph>Length</emph> is the number of characters in <emph>Text</emph> to be replaced.</paragraph> + <paragraph id="par_id3159188" role="paragraph"> <emph>NewText</emph> refers to the text which replaces <emph>Text</emph>.</paragraph> + <embed href="text/scalc/01/common_func.xhp#sectionexample"/> + <paragraph id="par_id3154096" role="paragraph"> <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> + </body> +</helpdocument> diff --git a/source/text/scalc/01/func_rept.xhp b/source/text/scalc/01/func_rept.xhp new file mode 100644 index 0000000000..70c220eeaa --- /dev/null +++ b/source/text/scalc/01/func_rept.xhp @@ -0,0 +1,40 @@ +<?xml version="1.0" encoding="UTF-8"?> +<helpdocument version="1.0"> + <!-- + * This file is part of the LibreOffice project. + * + * This Source Code Form is subject to the terms of the Mozilla Public + * License, v. 2.0. If a copy of the MPL was not distributed with this + * file, You can obtain one at http://mozilla.org/MPL/2.0/. + * + --> + <meta> + <topic id="calcfunc_rept" indexer="include" status="PUBLISH"> + <title id="tit">REPT Function</title> + <filename>/text/scalc/01/func_rept.xhp</filename> + </topic> + </meta> + <body> + <bookmark branch="index" id="bm_id3149741"> + <bookmark_value>REPT function</bookmark_value> +</bookmark> + <bookmark branch="hid/SC_HID_FUNC_WIEDERHOLEN" id="bm_id3155582" localize="false"/> + <section id="func_rept"> + <h1 id="hd_id3149741"> + <variable id="rept_h1"> + <link href="text/scalc/01/func_rept.xhp">REPT</link> + </variable> + </h1> + <paragraph id="par_id3153748" role="paragraph"> + <ahelp hid="HID_FUNC_WIEDERHOLEN">Repeats a character string by the given <emph>number</emph> of copies.</ahelp> + </paragraph> + </section> + <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> + <paragraph id="par_id3150494" role="code">REPT("Text"; Number)</paragraph> + <paragraph id="par_id3154859" role="paragraph"> <emph>Text</emph> is the text to be repeated.</paragraph> + <paragraph id="par_id3150638" role="paragraph"> <emph>Number</emph> is the number of repetitions.</paragraph> + <embed href="text/scalc/01/common_func.xhp#sectionexample"/> + <paragraph id="par_id3148626" role="paragraph"> <item type="input">=REPT("Good morning";2)</item> returns Good morningGood morning.</paragraph> + <tip id="par_id381626381556310">Refer to the <link href="https://wiki.documentfoundation.org/Documentation/Calc_Functions/REPT";>REPT</link> wiki page for more details about this function.</tip> + </body> +</helpdocument> diff --git a/source/text/scalc/01/func_right.xhp b/source/text/scalc/01/func_right.xhp new file mode 100644 index 0000000000..4d94225118 --- /dev/null +++ b/source/text/scalc/01/func_right.xhp @@ -0,0 +1,39 @@ +<?xml version="1.0" encoding="UTF-8"?> +<helpdocument version="1.0"> + <!-- + * This file is part of the LibreOffice project. + * + * This Source Code Form is subject to the terms of the Mozilla Public + * License, v. 2.0. If a copy of the MPL was not distributed with this + * file, You can obtain one at http://mozilla.org/MPL/2.0/. + * + --> + <meta> + <topic id="calcfunc_right" indexer="include" status="PUBLISH"> + <title id="tit">RIGHT Function</title> + <filename>/text/scalc/01/func_right.xhp</filename> + </topic> + </meta> + <body> + <bookmark branch="index" id="bm_id3149805"> + <bookmark_value>RIGHT function</bookmark_value> +</bookmark> + <bookmark branch="hid/SC_HID_FUNC_RECHTS" id="bm_id3154602" localize="false"/> + <section id="func_right"> + <h1 id="hd_id3149805"> + <variable id="right_h1"> + <link href="text/scalc/01/func_right.xhp">RIGHT</link> + </variable> + </h1> + <paragraph id="par_id3145375" role="paragraph"> + <ahelp hid="HID_FUNC_RECHTS">Returns the last character or characters of a text.</ahelp> + </paragraph> + </section> + <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> + <paragraph id="par_id3154344" role="code">RIGHT("Text" [; Number])</paragraph> + <paragraph id="par_id3149426" role="paragraph"> <emph>Text</emph> is the text of which the right part is to be determined.</paragraph> + <paragraph id="par_id3153350" role="paragraph"> <emph>Number</emph> (optional) is the number of characters from the right part of the text. If this parameter is not defined, one character is returned.</paragraph> + <embed href="text/scalc/01/common_func.xhp#sectionexample"/> + <paragraph id="par_id3151132" role="paragraph"> <item type="input">=RIGHT("Sun";2)</item> returns un.</paragraph> + </body> +</helpdocument> diff --git a/source/text/scalc/01/func_search.xhp b/source/text/scalc/01/func_search.xhp new file mode 100644 index 0000000000..4bcc4bbf38 --- /dev/null +++ b/source/text/scalc/01/func_search.xhp @@ -0,0 +1,39 @@ +<?xml version="1.0" encoding="UTF-8"?> +<helpdocument version="1.0"> + <!-- + * This file is part of the LibreOffice project. + * + * This Source Code Form is subject to the terms of the Mozilla Public + * License, v. 2.0. If a copy of the MPL was not distributed with this + * file, You can obtain one at http://mozilla.org/MPL/2.0/. + * + --> + <meta> + <topic id="calcfunc_search" indexer="include" status="PUBLISH"> + <title id="tit">SEARCH Function</title> + <filename>/text/scalc/01/func_search.xhp</filename> + </topic> + </meta> + <body> + <bookmark branch="index" id="bm_id3151005"> + <bookmark_value>SEARCH function</bookmark_value> +</bookmark> + <bookmark branch="hid/SC_HID_FUNC_SUCHEN" id="bm_id3149484" localize="false"/> + <section id="func_search"> + <h1 id="hd_id3151005"> + <variable id="search_h1"> + <link href="text/scalc/01/func_search.xhp">SEARCH</link> + </variable> + </h1> + <paragraph id="par_id3148692" role="paragraph"><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. If the text is not found, returns error 519 (#VALUE).</paragraph> + </section> + <embed href="text/shared/00/00000001.xhp#regex"/> + <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> + <paragraph id="par_id3154671" role="code">SEARCH("FindText"; "Text" [; Position])</paragraph> + <paragraph id="par_id3146080" role="paragraph"> <emph>FindText</emph> is the text to be searched for.</paragraph> + <paragraph id="par_id3154111" role="paragraph"> <emph>Text</emph> is the text where the search will take place.</paragraph> + <paragraph id="par_id3149559" role="paragraph"> <emph>Position</emph> (optional) is the position in the text where the search is to start.</paragraph> + <embed href="text/scalc/01/common_func.xhp#sectionexample"/> + <paragraph id="par_id3154564" role="paragraph"> <item type="input">=SEARCH(54;998877665544)</item> returns 10.</paragraph> + </body> +</helpdocument> diff --git a/source/text/scalc/01/func_substitute.xhp b/source/text/scalc/01/func_substitute.xhp new file mode 100644 index 0000000000..14e6a1daf3 --- /dev/null +++ b/source/text/scalc/01/func_substitute.xhp @@ -0,0 +1,42 @@ +<?xml version="1.0" encoding="UTF-8"?> +<helpdocument version="1.0"> + <!-- + * This file is part of the LibreOffice project. + * + * This Source Code Form is subject to the terms of the Mozilla Public + * License, v. 2.0. If a copy of the MPL was not distributed with this + * file, You can obtain one at http://mozilla.org/MPL/2.0/. + * + --> + <meta> + <topic id="calcfunc_substitute" indexer="include" status="PUBLISH"> + <title id="tit">SUBSTITUTE Function</title> + <filename>/text/scalc/01/func_substitute.xhp</filename> + </topic> + </meta> + <body> + <bookmark branch="index" id="bm_id3154830"> + <bookmark_value>SUBSTITUTE function</bookmark_value> +</bookmark> + <bookmark branch="hid/SC_HID_FUNC_WECHSELN" id="bm_id3147090" localize="false"/> + <section id="func_substitute"> + <h1 id="hd_id3154830"> + <variable id="substitute_h1"> + <link href="text/scalc/01/func_substitute.xhp">SUBSTITUTE</link> + </variable> + </h1> + <paragraph id="par_id3153698" role="paragraph"> + <ahelp hid="HID_FUNC_WECHSELN">Substitutes new text for old text in a string.</ahelp> + </paragraph> + </section> + <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> + <paragraph id="par_id3147582" role="code">SUBSTITUTE("Text"; "SearchText"; "NewText" [; Occurrence])</paragraph> + <paragraph id="par_id3153675" role="paragraph"> <emph>Text</emph> is the text in which text segments are to be exchanged.</paragraph> + <paragraph id="par_id3156155" role="paragraph"> <emph>SearchText </emph>is the text segment that is to be replaced (a number of times).</paragraph> + <paragraph id="par_id3145779" role="paragraph"> <emph>NewText</emph> is the text that is to replace the text segment.</paragraph> + <paragraph id="par_id3150348" role="paragraph"> <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> + <embed href="text/scalc/01/common_func.xhp#sectionexample"/> + <paragraph id="par_id3150412" role="paragraph"> <item type="input">=SUBSTITUTE("123123123";"3";"abc")</item> returns 12abc12abc12abc.</paragraph> + <paragraph id="par_id3154915" role="paragraph"> <item type="input">=SUBSTITUTE("123123123";"3";"abc";2)</item> returns 12312abc123.</paragraph> + </body> +</helpdocument> diff --git a/source/text/scalc/01/func_t.xhp b/source/text/scalc/01/func_t.xhp new file mode 100644 index 0000000000..bfd369c5d4 --- /dev/null +++ b/source/text/scalc/01/func_t.xhp @@ -0,0 +1,40 @@ +<?xml version="1.0" encoding="UTF-8"?> +<helpdocument version="1.0"> + <!-- + * This file is part of the LibreOffice project. + * + * This Source Code Form is subject to the terms of the Mozilla Public + * License, v. 2.0. If a copy of the MPL was not distributed with this + * file, You can obtain one at http://mozilla.org/MPL/2.0/. + * + --> + <meta> + <topic id="calcfunc_t" indexer="include" status="PUBLISH"> + <title id="tit">T Function</title> + <filename>/text/scalc/01/func_t.xhp</filename> + </topic> + </meta> + <body> + <bookmark branch="index" id="bm_id3148977"> + <bookmark_value>T function</bookmark_value> +</bookmark> + <bookmark branch="hid/SC_HID_FUNC_T" id="bm_id3156051" localize="false"/> + <section id="func_t"> + <h1 id="hd_id3148977"> + <variable id="t_h1"> + <link href="text/scalc/01/func_t.xhp">T</link> + </variable> + </h1> + <paragraph id="par_id3154359" role="paragraph"> + <ahelp hid="HID_FUNC_T">This function returns the target text, or a blank text string if the target is not text.</ahelp> + </paragraph> + </section> + <paragraph id="par_id9115573" role="paragraph">If an error occurs the function returns the error value.</paragraph> + <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> + <paragraph id="par_id3155871" role="code">T(Value)</paragraph> + <paragraph id="par_id3154726" role="paragraph">If <emph>Value</emph> is a text string or refers to a text string, T returns that text string; otherwise it returns a blank text string.</paragraph> + <embed href="text/scalc/01/common_func.xhp#sectionexample"/> + <paragraph id="par_id3151062" role="paragraph"> <item type="input">=T(12345)</item> returns an empty string. </paragraph> + <paragraph id="par_id4650105" role="paragraph"> <item type="input">=T("12345")</item> returns the string 12345.</paragraph> + </body> +</helpdocument> diff --git a/source/text/scalc/01/func_text.xhp b/source/text/scalc/01/func_text.xhp new file mode 100644 index 0000000000..f4d5daf969 --- /dev/null +++ b/source/text/scalc/01/func_text.xhp @@ -0,0 +1,42 @@ +<?xml version="1.0" encoding="UTF-8"?> +<helpdocument version="1.0"> + <!-- + * This file is part of the LibreOffice project. + * + * This Source Code Form is subject to the terms of the Mozilla Public + * License, v. 2.0. If a copy of the MPL was not distributed with this + * file, You can obtain one at http://mozilla.org/MPL/2.0/. + * + --> + <meta> + <topic id="calcfunc_text" indexer="include" status="PUBLISH"> + <title id="tit">TEXT Function</title> + <filename>/text/scalc/01/func_text.xhp</filename> + </topic> + </meta> + <body> + <bookmark branch="index" id="bm_id3147132"> + <bookmark_value>TEXT function</bookmark_value> +</bookmark> + <bookmark branch="hid/SC_HID_FUNC_TEXT" id="bm_id3156426" localize="false"/> + <section id="func_text"> + <h1 id="hd_id3147132"> + <variable id="text_h1"> + <link href="text/scalc/01/func_text.xhp">TEXT</link> + </variable> + </h1> + <paragraph id="par_id3147213" role="paragraph"> + <ahelp hid="HID_FUNC_TEXT">Converts a value into text according to a given format.</ahelp> + </paragraph> + </section> + <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> + <paragraph id="par_id3147377" role="code">TEXT(Value; Format)</paragraph> + <paragraph id="par_id3147389" role="paragraph"> <emph>Value</emph> is the value (numerical or textual) to be converted.</paragraph> + <paragraph id="par_id3156167" role="paragraph"> <emph>Format</emph> is the text which defines the format. Use decimal and thousands separators according to the language set in the cell format.</paragraph> + <embed href="text/scalc/01/common_func.xhp#sectionexample"/> + <paragraph id="par_id9044770" role="paragraph"> <item type="input">=TEXT(12.34567;"###.##")</item> returns the text 12.35</paragraph> + <paragraph id="par_id3674123" role="paragraph"> <item type="input">=TEXT(12.34567;"000.00")</item> returns the text 012.35</paragraph> + <paragraph id="par_id3674124" role="paragraph"> <item type="input">=TEXT("xyz";"=== @ ===")</item> returns the text === xyz ===</paragraph> + <tip id="par_id3145364">See also <link href="text/shared/01/05020301.xhp">Number format codes</link>: custom format codes defined by the user.</tip> + </body> +</helpdocument> diff --git a/source/text/scalc/01/func_trim.xhp b/source/text/scalc/01/func_trim.xhp new file mode 100644 index 0000000000..9f69efa813 --- /dev/null +++ b/source/text/scalc/01/func_trim.xhp @@ -0,0 +1,38 @@ +<?xml version="1.0" encoding="UTF-8"?> +<helpdocument version="1.0"> + <!-- + * This file is part of the LibreOffice project. + * + * This Source Code Form is subject to the terms of the Mozilla Public + * License, v. 2.0. If a copy of the MPL was not distributed with this + * file, You can obtain one at http://mozilla.org/MPL/2.0/. + * + --> + <meta> + <topic id="calcfunc_trim" indexer="include" status="PUBLISH"> + <title id="tit">TRIM Function</title> + <filename>/text/scalc/01/func_trim.xhp</filename> + </topic> + </meta> + <body> + <bookmark branch="index" id="bm_id3151039"> + <bookmark_value>TRIM function</bookmark_value> +</bookmark> + <bookmark branch="hid/SC_HID_FUNC_GLAETTEN" id="bm_id3150584" localize="false"/> + <section id="func_trim"> + <h1 id="hd_id3151039"> + <variable id="trim_h1"> + <link href="text/scalc/01/func_trim.xhp">TRIM</link> + </variable> + </h1> + <paragraph id="par_id3157888" role="paragraph"> + <ahelp hid="HID_FUNC_GLAETTEN">Removes spaces from a string, leaving only a single space character between words.</ahelp> + </paragraph> + </section> + <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> + <paragraph id="par_id3151349" role="code">TRIM("Text")</paragraph> + <paragraph id="par_id3151362" role="paragraph"> <emph>Text</emph> refers to text in which spaces are to be removed.</paragraph> + <embed href="text/scalc/01/common_func.xhp#sectionexample"/> + <paragraph id="par_id3156074" role="paragraph"> <item type="input">=TRIM(" hello world ")</item> returns hello world without leading and trailing spaces and with single space between words.</paragraph> + </body> +</helpdocument> diff --git a/source/text/scalc/01/func_unichar.xhp b/source/text/scalc/01/func_unichar.xhp new file mode 100644 index 0000000000..51893f7623 --- /dev/null +++ b/source/text/scalc/01/func_unichar.xhp @@ -0,0 +1,40 @@ +<?xml version="1.0" encoding="UTF-8"?> +<helpdocument version="1.0"> + <!-- + * This file is part of the LibreOffice project. + * + * This Source Code Form is subject to the terms of the Mozilla Public + * License, v. 2.0. If a copy of the MPL was not distributed with this + * file, You can obtain one at http://mozilla.org/MPL/2.0/. + * + --> + <meta> + <topic id="calcfunc_unichar" indexer="include" status="PUBLISH"> + <title id="tit">UNICHAR Function</title> + <filename>/text/scalc/01/func_unichar.xhp</filename> + </topic> + </meta> + <body> + <bookmark branch="hid/SC_HID_FUNC_UNICHAR" id="bm_id0907200904004674" localize="false"/> + <bookmark branch="index" id="bm_id0907200904030935"> + <bookmark_value>UNICHAR function</bookmark_value> +</bookmark> + <section id="func_unichar"> + <h1 id="hd_id0907200904022525"> + <variable id="unichar_h1"> + <link href="text/scalc/01/func_unichar.xhp">UNICHAR</link> + </variable> + </h1> + <paragraph id="par_id0907200904022538" role="paragraph"> + <ahelp hid=".">Converts a code number into a Unicode character or letter.</ahelp> + </paragraph> + </section> + <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> + <paragraph id="par_id0907200904123753" role="paragraph"> + <item type="literal">UNICHAR(number)</item> + </paragraph> + <embed href="text/scalc/01/common_func.xhp#sectionexample"/> + <paragraph id="par_id090720090412378" role="paragraph">=UNICHAR(169) returns the Copyright character <emph>©</emph>.</paragraph> + <tip id="par_id050220170755399756">See also the UNICODE() function.</tip> + </body> +</helpdocument> diff --git a/source/text/scalc/01/func_unicode.xhp b/source/text/scalc/01/func_unicode.xhp new file mode 100644 index 0000000000..b118a2637a --- /dev/null +++ b/source/text/scalc/01/func_unicode.xhp @@ -0,0 +1,40 @@ +<?xml version="1.0" encoding="UTF-8"?> +<helpdocument version="1.0"> + <!-- + * This file is part of the LibreOffice project. + * + * This Source Code Form is subject to the terms of the Mozilla Public + * License, v. 2.0. If a copy of the MPL was not distributed with this + * file, You can obtain one at http://mozilla.org/MPL/2.0/. + * + --> + <meta> + <topic id="calcfunc_unicode" indexer="include" status="PUBLISH"> + <title id="tit">UNICODE Function</title> + <filename>/text/scalc/01/func_unicode.xhp</filename> + </topic> + </meta> + <body> + <bookmark branch="hid/SC_HID_FUNC_UNICODE" id="bm_id0907200904011330" localize="false"/> + <bookmark branch="index" id="bm_id0907200904033543"> + <bookmark_value>UNICODE function</bookmark_value> +</bookmark> + <section id="func_unicode"> + <h1 id="hd_id0907200904022588"> + <variable id="unicode_h1"> + <link href="text/scalc/01/func_unicode.xhp">UNICODE</link> + </variable> + </h1> + <paragraph id="par_id0907200904022594" role="paragraph"> + <ahelp hid=".">Returns the numeric code for the first Unicode character in a text string.</ahelp> + </paragraph> + </section> + <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> + <paragraph id="par_id0907200904123846" role="paragraph"> + <item type="literal">UNICODE("Text")</item> + </paragraph> + <embed href="text/scalc/01/common_func.xhp#sectionexample"/> + <paragraph id="par_id0907200904123919" role="paragraph">=UNICODE("©") returns the Unicode number 169 for the Copyright character.</paragraph> + <tip id="par_id050220170755393174">See also the UNICHAR() function.</tip> + </body> +</helpdocument> diff --git a/source/text/scalc/01/func_upper.xhp b/source/text/scalc/01/func_upper.xhp new file mode 100644 index 0000000000..15fd132ca9 --- /dev/null +++ b/source/text/scalc/01/func_upper.xhp @@ -0,0 +1,38 @@ +<?xml version="1.0" encoding="UTF-8"?> +<helpdocument version="1.0"> + <!-- + * This file is part of the LibreOffice project. + * + * This Source Code Form is subject to the terms of the Mozilla Public + * License, v. 2.0. If a copy of the MPL was not distributed with this + * file, You can obtain one at http://mozilla.org/MPL/2.0/. + * + --> + <meta> + <topic id="calcfunc_upper" indexer="include" status="PUBLISH"> + <title id="tit">UPPER Function</title> + <filename>/text/scalc/01/func_upper.xhp</filename> + </topic> + </meta> + <body> + <bookmark branch="index" id="bm_id3145178"> + <bookmark_value>UPPER function</bookmark_value> +</bookmark> + <bookmark branch="hid/SC_HID_FUNC_GROSS" id="bm_id3145189" localize="false"/> + <section id="func_upper"> + <h1 id="hd_id3145178"> + <variable id="upper_h1"> + <link href="text/scalc/01/func_upper.xhp">UPPER</link> + </variable> + </h1> + <paragraph id="par_id3162905" role="paragraph"> + <ahelp hid="HID_FUNC_GROSS">Converts the string specified in the <emph>text</emph> field to uppercase.</ahelp> + </paragraph> + </section> + <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> + <paragraph id="par_id3148539" role="code">UPPER("Text")</paragraph> + <paragraph id="par_id3148496" role="paragraph"> <emph>Text</emph> refers to the lower case letters you want to convert to upper case.</paragraph> + <embed href="text/scalc/01/common_func.xhp#sectionexample"/> + <paragraph id="par_id3146757" role="paragraph"> <item type="input">=UPPER("Good Morning")</item> returns GOOD MORNING.</paragraph> + </body> +</helpdocument>
