AllLangHelp_scalc.mk | 6 + helpers/calc_text_func.pl | 15 +++- source/text/scalc/01/04060110.xhp | 121 +----------------------------------- source/text/scalc/01/func_exact.xhp | 37 +++++++++++ source/text/scalc/01/func_find.xhp | 38 +++++++++++ source/text/scalc/01/func_fixed.xhp | 45 +++++++++++++ source/text/scalc/01/func_left.xhp | 39 +++++++++++ source/text/scalc/01/func_len.xhp | 39 +++++++++++ source/text/scalc/01/func_lower.xhp | 38 +++++++++++ 9 files changed, 260 insertions(+), 118 deletions(-)
New commits: commit 1fd4ec9539b4403f5a87ab42da93fe2f05a5388b Author: Pierre F <[email protected]> AuthorDate: Thu Oct 31 17:36:18 2024 +0200 Commit: Olivier Hallot <[email protected]> CommitDate: Fri Nov 1 14:43:12 2024 +0100 tdf#143846 split EXACT FIND FIXED LEFT LEN LOWER Change-Id: If4635fad96157ae6b91c77aa574c1bfb3351d35c Reviewed-on: https://gerrit.libreoffice.org/c/help/+/175858 Tested-by: Jenkins Reviewed-by: Olivier Hallot <[email protected]> diff --git a/AllLangHelp_scalc.mk b/AllLangHelp_scalc.mk index 03497e25cc..3614c20275 100644 --- a/AllLangHelp_scalc.mk +++ b/AllLangHelp_scalc.mk @@ -219,6 +219,12 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,scalc,\ helpcontent2/source/text/scalc/01/func_days360 \ helpcontent2/source/text/scalc/01/func_decimal \ helpcontent2/source/text/scalc/01/func_dollar \ + helpcontent2/source/text/scalc/01/func_exact \ + helpcontent2/source/text/scalc/01/func_find \ + helpcontent2/source/text/scalc/01/func_fixed \ + helpcontent2/source/text/scalc/01/func_left \ + helpcontent2/source/text/scalc/01/func_len \ + helpcontent2/source/text/scalc/01/func_lower \ helpcontent2/source/text/scalc/01/func_eastersunday \ helpcontent2/source/text/scalc/01/func_edate \ helpcontent2/source/text/scalc/01/func_eomonth \ diff --git a/helpers/calc_text_func.pl b/helpers/calc_text_func.pl index 4fb5b72578..195c778d8a 100644 --- a/helpers/calc_text_func.pl +++ b/helpers/calc_text_func.pl @@ -7,14 +7,21 @@ $hlp0='helpers/calc_text_func0.xsl'; #replace section $source= 'source/text/scalc/01/04060110.xhp'; $tmp = $source . '.tmp'; -@todo = qw/ CHAR CLEAN CODE CONCATENATE DECIMAL DOLLAR 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/ EXACT FIND FIXED LEFT LEFTB LEN LENB LOWER MID MIDB PROPER REPLACE REPT RIGHT RIGHTB SEARCH SUBSTITUTE T TEXT TRIM UNICHAR UNICODE UPPER /; for $F ( @ARGV) { $f=lc $F; say $F - system qq( xsltproc --stringparam func $F $hlp $source > source/text/scalc/01/func_$f.xhp ); + $fOut = "source/text/scalc/01/func_$f.xhp"; + system qq( xsltproc --stringparam func $F $hlp $source > $fOut ); + + if ( -z $fOut ) { + warn "$F empty"; + unlink $fOut; + next; + } system qq( xsltproc --stringparam func $f $hlp0 $source > $tmp ); rename $tmp, $source; @@ -23,4 +30,6 @@ for $F ( @ARGV) { } say qq(TODO. add to git and AllLangHelp_scalc.mk : -$mk); +$mk) + if $mk; + diff --git a/source/text/scalc/01/04060110.xhp b/source/text/scalc/01/04060110.xhp index f80f36f8f2..57881fb3b5 100644 --- a/source/text/scalc/01/04060110.xhp +++ b/source/text/scalc/01/04060110.xhp @@ -110,93 +110,17 @@ <section id="dollar"><embed href="text/scalc/01/func_dollar.xhp#func_dollar"/></section> -<section id="exact"> -<bookmark branch="index" id="bm_id3150685"> - <bookmark_value>EXACT function</bookmark_value> -</bookmark> - -<bookmark branch="hid/SC_HID_FUNC_IDENTISCH" id="bm_id3155081" localize="false"/> +<section id="exact"><embed href="text/scalc/01/func_exact.xhp#func_exact"/></section> -<h2 id="hd_id3150685">EXACT</h2> -<paragraph id="par_id3158413" role="paragraph"><ahelp hid="HID_FUNC_IDENTISCH">Compares two text strings and returns TRUE if they are identical.</ahelp> This function is case-sensitive.</paragraph> - -<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> -<paragraph id="par_id3148594" role="code">EXACT("Text1"; "Text2")</paragraph> -<paragraph id="par_id3153224" role="paragraph"> <emph>Text1</emph> refers to the first text to compare.</paragraph> -<paragraph id="par_id3148637" role="paragraph"> <emph>Text2</emph> is the second text to compare.</paragraph> - -<embed href="text/scalc/01/common_func.xhp#sectionexample"/> -<paragraph id="par_id3156263" role="paragraph"> <item type="input">=EXACT("microsystems";"Microsystems")</item> returns FALSE.</paragraph> -</section> - -<section id="find"> -<bookmark branch="index" id="bm_id3152589"> - <bookmark_value>FIND function</bookmark_value> -</bookmark> - -<bookmark branch="hid/SC_HID_FUNC_FINDEN" id="bm_id3147482" localize="false"/> - -<h2 id="hd_id3152589">FIND</h2> -<paragraph id="par_id3146149" role="paragraph"><ahelp hid="HID_FUNC_FINDEN">Returns the position of 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> - -<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> -<paragraph id="par_id3083452" role="code">FIND("FindText"; "Text" [; Position])</paragraph> -<paragraph id="par_id3150608" role="paragraph"> <emph>FindText</emph> refers to the text to be found.</paragraph> -<paragraph id="par_id3152374" role="paragraph"> <emph>Text</emph> is the text where the search takes place.</paragraph> -<paragraph id="par_id3152475" role="paragraph"> <emph>Position</emph> (optional) is the position in the text from which the search starts.</paragraph> +<section id="find"><embed href="text/scalc/01/func_find.xhp#func_find"/></section> -<embed href="text/scalc/01/common_func.xhp#sectionexample"/> -<paragraph id="par_id3156375" role="paragraph"> <item type="input">=FIND(76;998877665544)</item> returns 6.</paragraph> -</section> - -<section id="fixed"> -<bookmark branch="index" id="bm_id3149268"> - <bookmark_value>FIXED function</bookmark_value> -</bookmark> - -<bookmark branch="hid/SC_HID_FUNC_FEST" id="bm_id3149450" localize="false"/> - -<h2 id="hd_id3149268">FIXED</h2> -<paragraph role="paragraph" id="par_id641617285271044"><ahelp hid="HID_FUNC_FEST">Returns a number as text with a specified number of decimal places and optional thousands separators.</ahelp></paragraph> - -<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> -<paragraph id="par_id3147567" role="code">FIXED(Number; [Decimals = 2 [; NoThousandsSeparators = FALSE]])</paragraph> - -<paragraph id="par_id3151272" role="paragraph"> <emph>Number</emph> is rounded to <literal>Decimals</literal> places (after the decimal separator) and the result formatted as text, using <link href="text/shared/optionen/01140000.xhp">locale-specific settings</link>.</paragraph> -<paragraph id="par_id3156322" role="paragraph"> <emph>Decimals</emph> (optional) refers to the number of decimal places to be displayed. If <literal>Decimals</literal> is negative, <literal>Number</literal> is rounded to ABS(<literal>Decimals</literal>) places to the left from the decimal point. If <literal>Decimals</literal> is a fraction, it is truncated actually ignoring what is the closest integer.</paragraph> -<paragraph id="par_id3150877" role="paragraph"> <emph>NoThousandsSeparators</emph> (optional) determines whether the thousands separator is used. If it is <literal>TRUE</literal> or non-zero, then group separators are omitted from the resulting string. 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">current locale setting</link> are displayed.</paragraph> - -<embed href="text/scalc/01/common_func.xhp#sectionexample"/> -<paragraph id="par_id3145208" role="paragraph"> <item type="input">=FIXED(1234567.89;3)</item> returns 1,234,567.890 as a text string. </paragraph> -<paragraph id="par_id5282143" role="paragraph"> <item type="input">=FIXED(123456.789;;TRUE)</item> returns 123456.79 as a text string.</paragraph> -<paragraph role="paragraph" id="par_id21617202293406"> <item type="input">=FIXED(12345.6789;-2)</item> returns 12,300 as a text string.</paragraph> -<paragraph role="paragraph" id="par_id161617202295558"> <item type="input">=FIXED(12134567.89;-3;1)</item> returns 12135000 as a text string.</paragraph> -<paragraph role="paragraph" id="par_id451617286696878"> <item type="input">=FIXED(12345.789;3/4)</item> returns 12,346 as a text string.</paragraph> -<paragraph role="paragraph" id="par_id371617286698199"> <item type="input">=FIXED(12345.789;8/5)</item> returns 12,345.8 as a text string.</paragraph> -</section> +<section id="fixed"><embed href="text/scalc/01/func_fixed.xhp#func_fixed"/></section> <section id="jis"> <embed href="text/scalc/01/func_jis.xhp#func_jis"/> </section> -<section id="left"> -<bookmark branch="index" id="bm_id3147083"> - <bookmark_value>LEFT function</bookmark_value> -</bookmark> - -<bookmark branch="hid/SC_HID_FUNC_LINKS" id="bm_id3154645" localize="false"/> - -<h2 id="hd_id3147083">LEFT</h2> -<paragraph id="par_id3153622" role="paragraph"><ahelp hid="HID_FUNC_LINKS">Returns the first character or characters of a text.</ahelp></paragraph> - -<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> -<paragraph id="par_id3146786" role="code">LEFT("Text" [; Number])</paragraph> -<paragraph id="par_id3147274" role="paragraph"> <emph>Text</emph> is the text where the initial partial words are to be determined.</paragraph> -<paragraph id="par_id3153152" role="paragraph"> <emph>Number</emph> (optional) specifies the number of characters for the start text. If this parameter is not defined, one character is returned.</paragraph> - -<embed href="text/scalc/01/common_func.xhp#sectionexample"/> -<paragraph id="par_id3149141" role="paragraph"> <item type="input">=LEFT("output";3)</item> returns “out”.</paragraph> -</section> +<section id="left"><embed href="text/scalc/01/func_left.xhp#func_left"/></section> <section id="leftb"> <bookmark branch="index" id="bm_id2947083"> @@ -221,24 +145,7 @@ <paragraph 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 branch="index" id="bm_id3156110"> - <bookmark_value>LEN function</bookmark_value> -</bookmark> - -<bookmark branch="hid/SC_HID_FUNC_LAENGE" id="bm_id3154050" localize="false"/> - -<h2 id="hd_id3156110">LEN</h2> -<paragraph id="par_id3150147" role="paragraph"><ahelp hid="HID_FUNC_LAENGE">Returns the length of a string including spaces.</ahelp></paragraph> - -<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> -<paragraph id="par_id3154063" role="code">LEN("Text")</paragraph> -<paragraph id="par_id3146894" role="paragraph"> <emph>Text</emph> is the text whose length is to be determined.</paragraph> - -<embed href="text/scalc/01/common_func.xhp#sectionexample"/> -<paragraph id="par_id3156008" role="paragraph"> <item type="input">=LEN("Good Afternoon")</item> returns 14.</paragraph> -<paragraph id="par_id3154300" role="paragraph"> <item type="input">=LEN(12345.67)</item> returns 8.</paragraph> -</section> +<section id="len"><embed href="text/scalc/01/func_len.xhp#func_len"/></section> <section id="lenb"> <bookmark branch="index" id="bm_id2956110"> @@ -262,23 +169,7 @@ <paragraph id="par_id2954300" role="paragraph"> <item type="input">=LENB(12345.67)</item> returns 8.</paragraph> </section> -<section id="lower"> -<bookmark branch="index" id="bm_id3153983"> - <bookmark_value>LOWER function</bookmark_value> -</bookmark> - -<bookmark branch="hid/SC_HID_FUNC_KLEIN" id="bm_id3151173" localize="false"/> - -<h2 id="hd_id3153983">LOWER</h2> -<paragraph id="par_id3152791" role="paragraph"><ahelp hid="HID_FUNC_KLEIN">Converts all uppercase letters in a text string to lowercase.</ahelp></paragraph> - -<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> -<paragraph id="par_id3150121" role="code">LOWER("Text")</paragraph> -<paragraph id="par_id3153910" 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_id3155329" role="paragraph"> <item type="input">=LOWER("Sun")</item> returns sun.</paragraph> -</section> +<section id="lower"><embed href="text/scalc/01/func_lower.xhp#func_lower"/></section> <section id="mid"> <bookmark branch="index" id="bm_id3154589"> diff --git a/source/text/scalc/01/func_exact.xhp b/source/text/scalc/01/func_exact.xhp new file mode 100644 index 0000000000..bc8c13d445 --- /dev/null +++ b/source/text/scalc/01/func_exact.xhp @@ -0,0 +1,37 @@ +<?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_exact" indexer="include" status="PUBLISH"> + <title id="tit">EXACT Function</title> + <filename>/text/scalc/01/func_exact.xhp</filename> + </topic> + </meta> + <body> + <bookmark branch="index" id="bm_id3150685"> + <bookmark_value>EXACT function</bookmark_value> +</bookmark> + <bookmark branch="hid/SC_HID_FUNC_IDENTISCH" id="bm_id3155081" localize="false"/> + <section id="func_exact"> + <h1 id="hd_id3150685"> + <variable id="exact_h1"> + <link href="text/scalc/01/func_exact.xhp">EXACT</link> + </variable> + </h1> + <paragraph id="par_id3158413" role="paragraph"><ahelp hid="HID_FUNC_IDENTISCH">Compares two text strings and returns TRUE if they are identical.</ahelp> This function is case-sensitive.</paragraph> + </section> + <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> + <paragraph id="par_id3148594" role="code">EXACT("Text1"; "Text2")</paragraph> + <paragraph id="par_id3153224" role="paragraph"> <emph>Text1</emph> refers to the first text to compare.</paragraph> + <paragraph id="par_id3148637" role="paragraph"> <emph>Text2</emph> is the second text to compare.</paragraph> + <embed href="text/scalc/01/common_func.xhp#sectionexample"/> + <paragraph id="par_id3156263" role="paragraph"> <item type="input">=EXACT("microsystems";"Microsystems")</item> returns FALSE.</paragraph> + </body> +</helpdocument> diff --git a/source/text/scalc/01/func_find.xhp b/source/text/scalc/01/func_find.xhp new file mode 100644 index 0000000000..48895c79e0 --- /dev/null +++ b/source/text/scalc/01/func_find.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_find" indexer="include" status="PUBLISH"> + <title id="tit">FIND Function</title> + <filename>/text/scalc/01/func_find.xhp</filename> + </topic> + </meta> + <body> + <bookmark branch="index" id="bm_id3152589"> + <bookmark_value>FIND function</bookmark_value> +</bookmark> + <bookmark branch="hid/SC_HID_FUNC_FINDEN" id="bm_id3147482" localize="false"/> + <section id="func_find"> + <h1 id="hd_id3152589"> + <variable id="find_h1"> + <link href="text/scalc/01/func_find.xhp">FIND</link> + </variable> + </h1> + <paragraph id="par_id3146149" role="paragraph"><ahelp hid="HID_FUNC_FINDEN">Returns the position of 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> + </section> + <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> + <paragraph id="par_id3083452" role="code">FIND("FindText"; "Text" [; Position])</paragraph> + <paragraph id="par_id3150608" role="paragraph"> <emph>FindText</emph> refers to the text to be found.</paragraph> + <paragraph id="par_id3152374" role="paragraph"> <emph>Text</emph> is the text where the search takes place.</paragraph> + <paragraph id="par_id3152475" role="paragraph"> <emph>Position</emph> (optional) is the position in the text from which the search starts.</paragraph> + <embed href="text/scalc/01/common_func.xhp#sectionexample"/> + <paragraph id="par_id3156375" role="paragraph"> <item type="input">=FIND(76;998877665544)</item> returns 6.</paragraph> + </body> +</helpdocument> diff --git a/source/text/scalc/01/func_fixed.xhp b/source/text/scalc/01/func_fixed.xhp new file mode 100644 index 0000000000..fa345568bc --- /dev/null +++ b/source/text/scalc/01/func_fixed.xhp @@ -0,0 +1,45 @@ +<?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_fixed" indexer="include" status="PUBLISH"> + <title id="tit">FIXED Function</title> + <filename>/text/scalc/01/func_fixed.xhp</filename> + </topic> + </meta> + <body> + <bookmark branch="index" id="bm_id3149268"> + <bookmark_value>FIXED function</bookmark_value> +</bookmark> + <bookmark branch="hid/SC_HID_FUNC_FEST" id="bm_id3149450" localize="false"/> + <section id="func_fixed"> + <h1 id="hd_id3149268"> + <variable id="fixed_h1"> + <link href="text/scalc/01/func_fixed.xhp">FIXED</link> + </variable> + </h1> + <paragraph role="paragraph" id="par_id641617285271044"> + <ahelp hid="HID_FUNC_FEST">Returns a number as text with a specified number of decimal places and optional thousands separators.</ahelp> + </paragraph> + </section> + <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> + <paragraph id="par_id3147567" role="code">FIXED(Number; [Decimals = 2 [; NoThousandsSeparators = FALSE]])</paragraph> + <paragraph id="par_id3151272" role="paragraph"> <emph>Number</emph> is rounded to <literal>Decimals</literal> places (after the decimal separator) and the result formatted as text, using <link href="text/shared/optionen/01140000.xhp">locale-specific settings</link>.</paragraph> + <paragraph id="par_id3156322" role="paragraph"> <emph>Decimals</emph> (optional) refers to the number of decimal places to be displayed. If <literal>Decimals</literal> is negative, <literal>Number</literal> is rounded to ABS(<literal>Decimals</literal>) places to the left from the decimal point. If <literal>Decimals</literal> is a fraction, it is truncated actually ignoring what is the closest integer.</paragraph> + <paragraph id="par_id3150877" role="paragraph"> <emph>NoThousandsSeparators</emph> (optional) determines whether the thousands separator is used. If it is <literal>TRUE</literal> or non-zero, then group separators are omitted from the resulting string. 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">current locale setting</link> are displayed.</paragraph> + <embed href="text/scalc/01/common_func.xhp#sectionexample"/> + <paragraph id="par_id3145208" role="paragraph"> <item type="input">=FIXED(1234567.89;3)</item> returns 1,234,567.890 as a text string. </paragraph> + <paragraph id="par_id5282143" role="paragraph"> <item type="input">=FIXED(123456.789;;TRUE)</item> returns 123456.79 as a text string.</paragraph> + <paragraph role="paragraph" id="par_id21617202293406"> <item type="input">=FIXED(12345.6789;-2)</item> returns 12,300 as a text string.</paragraph> + <paragraph role="paragraph" id="par_id161617202295558"> <item type="input">=FIXED(12134567.89;-3;1)</item> returns 12135000 as a text string.</paragraph> + <paragraph role="paragraph" id="par_id451617286696878"> <item type="input">=FIXED(12345.789;3/4)</item> returns 12,346 as a text string.</paragraph> + <paragraph role="paragraph" id="par_id371617286698199"> <item type="input">=FIXED(12345.789;8/5)</item> returns 12,345.8 as a text string.</paragraph> + </body> +</helpdocument> diff --git a/source/text/scalc/01/func_left.xhp b/source/text/scalc/01/func_left.xhp new file mode 100644 index 0000000000..4411319d00 --- /dev/null +++ b/source/text/scalc/01/func_left.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_left" indexer="include" status="PUBLISH"> + <title id="tit">LEFT Function</title> + <filename>/text/scalc/01/func_left.xhp</filename> + </topic> + </meta> + <body> + <bookmark branch="index" id="bm_id3147083"> + <bookmark_value>LEFT function</bookmark_value> +</bookmark> + <bookmark branch="hid/SC_HID_FUNC_LINKS" id="bm_id3154645" localize="false"/> + <section id="func_left"> + <h1 id="hd_id3147083"> + <variable id="left_h1"> + <link href="text/scalc/01/func_left.xhp">LEFT</link> + </variable> + </h1> + <paragraph id="par_id3153622" role="paragraph"> + <ahelp hid="HID_FUNC_LINKS">Returns the first character or characters of a text.</ahelp> + </paragraph> + </section> + <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> + <paragraph id="par_id3146786" role="code">LEFT("Text" [; Number])</paragraph> + <paragraph id="par_id3147274" role="paragraph"> <emph>Text</emph> is the text where the initial partial words are to be determined.</paragraph> + <paragraph id="par_id3153152" role="paragraph"> <emph>Number</emph> (optional) specifies the number of characters for the start text. If this parameter is not defined, one character is returned.</paragraph> + <embed href="text/scalc/01/common_func.xhp#sectionexample"/> + <paragraph id="par_id3149141" role="paragraph"> <item type="input">=LEFT("output";3)</item> returns “out”.</paragraph> + </body> +</helpdocument> diff --git a/source/text/scalc/01/func_len.xhp b/source/text/scalc/01/func_len.xhp new file mode 100644 index 0000000000..5737d0dfa8 --- /dev/null +++ b/source/text/scalc/01/func_len.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_len" indexer="include" status="PUBLISH"> + <title id="tit">LEN Function</title> + <filename>/text/scalc/01/func_len.xhp</filename> + </topic> + </meta> + <body> + <bookmark branch="index" id="bm_id3156110"> + <bookmark_value>LEN function</bookmark_value> +</bookmark> + <bookmark branch="hid/SC_HID_FUNC_LAENGE" id="bm_id3154050" localize="false"/> + <section id="func_len"> + <h1 id="hd_id3156110"> + <variable id="len_h1"> + <link href="text/scalc/01/func_len.xhp">LEN</link> + </variable> + </h1> + <paragraph id="par_id3150147" role="paragraph"> + <ahelp hid="HID_FUNC_LAENGE">Returns the length of a string including spaces.</ahelp> + </paragraph> + </section> + <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> + <paragraph id="par_id3154063" role="code">LEN("Text")</paragraph> + <paragraph id="par_id3146894" role="paragraph"> <emph>Text</emph> is the text whose length is to be determined.</paragraph> + <embed href="text/scalc/01/common_func.xhp#sectionexample"/> + <paragraph id="par_id3156008" role="paragraph"> <item type="input">=LEN("Good Afternoon")</item> returns 14.</paragraph> + <paragraph id="par_id3154300" role="paragraph"> <item type="input">=LEN(12345.67)</item> returns 8.</paragraph> + </body> +</helpdocument> diff --git a/source/text/scalc/01/func_lower.xhp b/source/text/scalc/01/func_lower.xhp new file mode 100644 index 0000000000..59974e2f28 --- /dev/null +++ b/source/text/scalc/01/func_lower.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_lower" indexer="include" status="PUBLISH"> + <title id="tit">LOWER Function</title> + <filename>/text/scalc/01/func_lower.xhp</filename> + </topic> + </meta> + <body> + <bookmark branch="index" id="bm_id3153983"> + <bookmark_value>LOWER function</bookmark_value> +</bookmark> + <bookmark branch="hid/SC_HID_FUNC_KLEIN" id="bm_id3151173" localize="false"/> + <section id="func_lower"> + <h1 id="hd_id3153983"> + <variable id="lower_h1"> + <link href="text/scalc/01/func_lower.xhp">LOWER</link> + </variable> + </h1> + <paragraph id="par_id3152791" role="paragraph"> + <ahelp hid="HID_FUNC_KLEIN">Converts all uppercase letters in a text string to lowercase.</ahelp> + </paragraph> + </section> + <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> + <paragraph id="par_id3150121" role="code">LOWER("Text")</paragraph> + <paragraph id="par_id3153910" 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_id3155329" role="paragraph"> <item type="input">=LOWER("Sun")</item> returns sun.</paragraph> + </body> +</helpdocument>
