summaryrefslogtreecommitdiff
path: root/source/text/scalc/01/04060110.xhp
diff options
context:
space:
mode:
authorIlmari Lauhakangas <ilmari.lauhakangas@libreoffice.org>2022-12-06 14:05:20 +0200
committerChristian Lohmaier <lohmaier+LibreOffice@googlemail.com>2022-12-07 17:39:02 +0000
commit7e42394ecbf921ee53160b495aa12c1cba158604 (patch)
tree9f0b4dcbbf31112c0260a6a6831cbddf86d82c6d /source/text/scalc/01/04060110.xhp
parent490d42493e8dbec31ad58978df5084b080a36fcb (diff)
tdf#152323 drop name attribute from <link> elements
Replacement done with find . -name \*.xhp -print0 |xargs -0 -P 0 perl -CS -pi -e \ 's#(<link[^>]*?) +name *="[^"]*" *( [^>]+|) *>#$1$2>#g' (note some inconsistencies with space between name and = and also having empty value, and some more complicated expression to also clear up double space before/after the attribute) translation files will be prepped with: find */helpcontent2 -name \*.po -print0 |xargs -0 -P 0 perl -CS -pi -e \ $'s#(<link[^>]*?) +name=(?:\\\\"[^"]*\\\\"|\'[^\']*\') *( [^>]+|) *(/?>)#$1$2$3#g unless /^#/' (note that not all languages use the " as quote character for the attributes, but that also single quotes appera in the po file. Hence the use of the shell $'string' syntax to be able to quote ' as \' It also requires to quote the backslash, so that it needs to be escaped once for the shell, then another time for perl. Also don't work on obsolete strings (those are prefixed with #~ in the po files) Also note that <link..></link> gets turned into <link ../> during translation extraction (along with removal of the space between the attribute name and the value), so the pattern needs to be slightly different here) Change-Id: I95e53a08e6b0095cd894109ea0de154cc4859d8f Reviewed-on: https://gerrit.libreoffice.org/c/help/+/143713 Tested-by: Jenkins Reviewed-by: Christian Lohmaier <lohmaier+LibreOffice@googlemail.com>
Diffstat (limited to 'source/text/scalc/01/04060110.xhp')
-rw-r--r--source/text/scalc/01/04060110.xhp30
1 files changed, 15 insertions, 15 deletions
diff --git a/source/text/scalc/01/04060110.xhp b/source/text/scalc/01/04060110.xhp
index 1d63e12398..20bff1be7c 100644
--- a/source/text/scalc/01/04060110.xhp
+++ b/source/text/scalc/01/04060110.xhp
@@ -34,7 +34,7 @@
</bookmark>
-<h1 id="hd_id3145389"><variable id="head_text"><link href="text/scalc/01/04060110.xhp" name="Text Functions">Text Functions</link></variable></h1>
+<h1 id="hd_id3145389"><variable id="head_text"><link href="text/scalc/01/04060110.xhp">Text Functions</link></variable></h1>
<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">
@@ -107,7 +107,7 @@
<bookmark_value>decimal system; converting to</bookmark_value>
</bookmark>
<h2 id="hd_id3153072">BASE</h2>
-<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#number_system" name="numbering system">numbering system</link>.</ahelp> The digits 0-9 and the letters A-Z are used.</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#number_system">numbering system</link>.</ahelp> The digits 0-9 and the letters A-Z are used.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph id="par_id3155743" role="code" xml-lang="en-US">BASE(Number; Radix [; MinimumLength])</paragraph>
@@ -129,7 +129,7 @@
<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>
<embed href="text/scalc/01/common_func.xhp#sectionseealso"/>
-<paragraph role="paragraph" id="par_id991655560817321"><link href="text/scalc/01/04060110.xhp#decimal" name="decimal">DECIMAL</link></paragraph>
+<paragraph role="paragraph" id="par_id991655560817321"><link href="text/scalc/01/04060110.xhp#decimal">DECIMAL</link></paragraph>
</section>
<section id="char">
@@ -213,7 +213,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_DEZIMAL" id="bm_id3150338" localize="false"/>
<h2 id="hd_id3145166">DECIMAL</h2>
-<paragraph id="par_id3156361" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_DEZIMAL">Converts text that represents a number in a <link href="text/shared/00/00000005.xhp#number_system" name="numeral system">numeral system</link> with the given base radix to a positive integer.</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_id3156361" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_DEZIMAL">Converts text that represents a number in a <link href="text/shared/00/00000005.xhp#number_system">numeral system</link> with the given base radix to a positive integer.</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, are disregarded. If the radix is 2, an appended b or B is disregarded. Other characters that do not belong to the numeral system generate an error.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -226,7 +226,7 @@
<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>
<embed href="text/scalc/01/common_func.xhp#sectionseealso"/>
-<paragraph role="paragraph" id="par_id421655560837244"><link href="text/scalc/01/04060110.xhp#base" name="base">BASE</link></paragraph>
+<paragraph role="paragraph" id="par_id421655560837244"><link href="text/scalc/01/04060110.xhp#base">BASE</link></paragraph>
</section>
<section id="dollar">
@@ -237,7 +237,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_DM" id="bm_id3149532" localize="false"/>
<h2 id="hd_id3148402">DOLLAR</h2>
-<paragraph id="par_id3153049" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_DM">Converts a number to a string representing the amount in the currency format, rounded to a specified decimal places, using the decimal separator that corresponds to the <link href="text/shared/optionen/01140000.xhp" name="current locale setting">current locale setting</link>.</ahelp> In the <item type="literal">Value</item> field enter the number to be converted. 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_id3153049" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_DM">Converts a number to a string representing the amount in the currency format, rounded to a specified decimal places, using the decimal separator that corresponds to the <link href="text/shared/optionen/01140000.xhp">current locale setting</link>.</ahelp> In the <item type="literal">Value</item> field enter the number to be converted. 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>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -302,9 +302,9 @@
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph id="par_id3147567" role="code" xml-lang="en-US">FIXED(Number; [Decimals = 2 [; NoThousandsSeparators = FALSE]])</paragraph>
-<paragraph id="par_id3151272" role="paragraph" xml-lang="en-US"> <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" name="current locale setting">locale-specific settings</link>.</paragraph>
+<paragraph id="par_id3151272" role="paragraph" xml-lang="en-US"> <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" xml-lang="en-US"> <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" xml-lang="en-US"> <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" name="current locale setting">current locale setting</link> are displayed.</paragraph>
+<paragraph id="par_id3150877" role="paragraph" xml-lang="en-US"> <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" xml-lang="en-US"> <item type="input">=FIXED(1234567.89;3)</item> returns 1,234,567.890 as a text string. </paragraph>
@@ -345,7 +345,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_LEFTB" id="bm_id2954645" localize="false"/>
-<h2 id="hd_id2947083"><variable id="leftbvar"><link href="text/scalc/01/04060110.xhp#leftb" name="LEFTB">LEFTB</link></variable></h2>
+<h2 id="hd_id2947083"><variable id="leftbvar"><link href="text/scalc/01/04060110.xhp#leftb">LEFTB</link></variable></h2>
<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>
<embed href="text/scalc/00/avail_release.xhp#4.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -387,7 +387,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_LENB" id="bm_id2954050" localize="false"/>
-<h2 id="hd_id2956110"><variable id="lenbvar"><link href="text/scalc/01/04060110.xhp#lenb" name="LENB">LENB</link></variable></h2>
+<h2 id="hd_id2956110"><variable id="lenbvar"><link href="text/scalc/01/04060110.xhp#lenb">LENB</link></variable></h2>
<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>
<embed href="text/scalc/00/avail_release.xhp#4.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -447,7 +447,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_MIDB" id="bm_id2955392" localize="false"/>
-<h2 id="hd_id2954589"><variable id="midbvar"><link href="text/scalc/01/04060110.xhp#midb" name="MIDB">MIDB</link></variable></h2>
+<h2 id="hd_id2954589"><variable id="midbvar"><link href="text/scalc/01/04060110.xhp#midb">MIDB</link></variable></h2>
<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>
<embed href="text/scalc/00/avail_release.xhp#4.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -500,7 +500,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_ERSETZEN" id="bm_id3149990" localize="false"/>
<h2 id="hd_id3149171">REPLACE</h2>
-<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_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">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>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -532,7 +532,7 @@
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph id="par_id3148626" role="paragraph" xml-lang="en-US"> <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" name="REPT_Wiki">REPT</link> wiki page for more details about this function.</tip></section>
+<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 xml-lang="en-US" branch="index" id="bm_id3149805">
@@ -560,7 +560,7 @@
<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_RIGHTB" id="bm_id2954602" localize="false"/>
-<h2 id="hd_id2949805"><variable id="rightbvar"><link href="text/scalc/01/04060110.xhp#rightb" name="RIGHTB">RIGHTB</link></variable></h2>
+<h2 id="hd_id2949805"><variable id="rightbvar"><link href="text/scalc/01/04060110.xhp#rightb">RIGHTB</link></variable></h2>
<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>
<embed href="text/scalc/00/avail_release.xhp#4.2"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
@@ -661,7 +661,7 @@
<paragraph id="par_id3674123" role="paragraph" xml-lang="en-US"> <item type="input">=TEXT(12.34567;"000.00")</item> returns the text 012.35</paragraph>
<paragraph id="par_id3674124" role="paragraph" xml-lang="en-US"> <item type="input">=TEXT("xyz";"=== @ ===")</item> returns the text === xyz ===</paragraph>
-<tip id="par_id3145364">See also <link href="text/shared/01/05020301.xhp" name="Number format codes">Number format codes</link>: custom format codes defined by the user.</tip>
+<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">