summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorSteve Fanning <stevemfanning@yahoo.co.uk>2020-05-30 15:41:45 +0200
committerOlivier Hallot <olivier.hallot@libreoffice.org>2020-06-08 18:26:40 +0200
commit55fb7f4908d0c2f8eeb4d6df54a070cd27fa1a38 (patch)
tree9ccdf253978a52f14ea46e55abe8296f23d32b54
parent(04060109.xhp) Changes to syntax statements to readily identify optional para... (diff)
downloadhelp-55fb7f4908d0c2f8eeb4d6df54a070cd27fa1a38.zip
help-55fb7f4908d0c2f8eeb4d6df54a070cd27fa1a38.tar.gz
(04060110.xhp) General updates to function syntax statements in Help file, to include square brackets indicating optional parameters.
Also updated example for PROPER() function to reflect more appropriate sample string! Change-Id: I42f485f3e312c2d870059b60b3dcdc7d8921a0d8 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95195 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org> (cherry picked from commit 4bafa9e1d40f614b8d23637ce7fe49c0460f6553) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95716 Reviewed-by: Ilmari Lauhakangas <ilmari.lauhakangas@libreoffice.org>
-rw-r--r--source/text/scalc/01/04060110.xhp24
1 files changed, 12 insertions, 12 deletions
diff --git a/source/text/scalc/01/04060110.xhp b/source/text/scalc/01/04060110.xhp
index 5f0bbc9..0c8859a 100644
--- a/source/text/scalc/01/04060110.xhp
+++ b/source/text/scalc/01/04060110.xhp
@@ -107,7 +107,7 @@
<paragraph id="par_id3153289" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_BASIS">Converts a positive integer to a specified base into a text from the <link href="text/shared/00/00000005.xhp#zahlensystem" name="numbering system">numbering system</link>.</ahelp> The digits 0-9 and the letters A-Z are used.</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
-<paragraph id="par_id3155743" role="code" xml-lang="en-US">BASE(Number; Radix; [MinimumLength])</paragraph>
+<paragraph id="par_id3155743" role="code" xml-lang="en-US">BASE(Number; Radix [; MinimumLength])</paragraph>
<paragraph id="par_id3151339" role="paragraph" xml-lang="en-US"> <emph>Number</emph> is the positive integer to be converted.</paragraph>
<paragraph id="par_id3159262" role="paragraph" xml-lang="en-US"> <emph>Radix</emph> indicates the base of the number system. It may be any positive integer between 2 and 36.</paragraph>
<paragraph id="par_id3148746" role="paragraph" xml-lang="en-US"> <emph>MinimumLength</emph> (optional) determines the minimum length of the character sequence that has been created. If the text is shorter than the indicated minimum length, zeros are added to the left of the string.</paragraph>
@@ -233,7 +233,7 @@
<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"/>
-<paragraph id="par_id3154188" role="code" xml-lang="en-US">DOLLAR(Value; Decimals)</paragraph>
+<paragraph id="par_id3154188" role="code" xml-lang="en-US">DOLLAR(Value [; Decimals])</paragraph>
<paragraph id="par_id3145299" role="paragraph" xml-lang="en-US"> <emph>Value</emph> is a number, a reference to a cell containing a number, or a formula which returns a number.</paragraph>
<paragraph id="par_id3145629" role="paragraph" xml-lang="en-US"> <emph>Decimals</emph> is the optional number of decimal places.</paragraph>
@@ -272,7 +272,7 @@
<paragraph id="par_id3146149" role="paragraph" xml-lang="en-US"><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" xml-lang="en-US">FIND("FindText"; "Text"; Position)</paragraph>
+<paragraph id="par_id3083452" role="code" xml-lang="en-US">FIND("FindText"; "Text" [; Position])</paragraph>
<paragraph id="par_id3150608" role="paragraph" xml-lang="en-US"> <emph>FindText</emph> refers to the text to be found.</paragraph>
<paragraph id="par_id3152374" role="paragraph" xml-lang="en-US"> <emph>Text</emph> is the text where the search takes place.</paragraph>
<paragraph id="par_id3152475" role="paragraph" xml-lang="en-US"> <emph>Position</emph> (optional) is the position in the text from which the search starts.</paragraph>
@@ -292,7 +292,7 @@
<paragraph id="par_id3155833" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_FEST">Returns a number as text with a specified number of decimal places and optional thousands separators.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
-<paragraph id="par_id3147567" role="code" xml-lang="en-US">FIXED(Number; Decimals; NoThousandsSeparators)</paragraph>
+<paragraph id="par_id3147567" role="code" xml-lang="en-US">FIXED(Number; Decimals [; NoThousandsSeparators])</paragraph>
<paragraph id="par_id3151272" role="paragraph" xml-lang="en-US"> <emph>Number</emph> refers to the number to be formatted.</paragraph>
<paragraph id="par_id3156322" role="paragraph" xml-lang="en-US"> <emph>Decimals</emph> refers to the number of decimal places to be displayed.</paragraph>
<paragraph id="par_id3150877" role="paragraph" xml-lang="en-US"> <emph>NoThousandsSeparators</emph> (optional) determines whether the thousands separator is used. If the parameter is a number not equal to 0, the thousands separator is suppressed. If the parameter is equal to 0 or if it is missing altogether, the thousands separators of your <link href="text/shared/optionen/01140000.xhp" name="current locale setting">current locale setting</link> are displayed.</paragraph>
@@ -330,7 +330,7 @@
<paragraph id="par_id3153622" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_LINKS">Returns the first character or characters of a text.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
-<paragraph id="par_id3146786" role="code" xml-lang="en-US">LEFT("Text"; Number)</paragraph>
+<paragraph id="par_id3146786" role="code" xml-lang="en-US">LEFT("Text" [; Number])</paragraph>
<paragraph id="par_id3147274" role="paragraph" xml-lang="en-US"> <emph>Text</emph> is the text where the initial partial words are to be determined.</paragraph>
<paragraph id="par_id3153152" role="paragraph" xml-lang="en-US"> <emph>Number</emph> (optional) specifies the number of characters for the start text. If this parameter is not defined, one character is returned.</paragraph>
@@ -349,7 +349,7 @@
<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"/>
-<paragraph id="par_id2946786" role="code" xml-lang="en-US">LEFTB("Text"; Number_bytes)</paragraph>
+<paragraph id="par_id2946786" role="code" xml-lang="en-US">LEFTB("Text" [; Number_bytes])</paragraph>
<paragraph id="par_id2947274" role="paragraph" xml-lang="en-US"><emph>Text</emph> is the text where the initial partial words are to be determined.</paragraph>
<paragraph id="par_id2953152" role="paragraph" xml-lang="en-US"><emph>Number_bytes</emph> (optional) specifies the number of characters you want LEFTB to extract, based on bytes. If this parameter is not defined, one character is returned.</paragraph>
@@ -485,7 +485,7 @@
<paragraph id="par_id3147509" role="paragraph" xml-lang="en-US"> <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" xml-lang="en-US"> <item type="input">=PROPER("open office")</item> returns Open Office.</paragraph>
+<paragraph id="par_id3155364" role="paragraph" xml-lang="en-US"> <item type="input">=PROPER("the document foundation")</item> returns The Document Foundation.</paragraph>
</section>
<section id="regex">
@@ -545,7 +545,7 @@
<paragraph id="par_id3145375" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_RECHTS">Returns the last character or characters of a text.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
-<paragraph id="par_id3154344" role="code" xml-lang="en-US">RIGHT("Text"; Number)</paragraph>
+<paragraph id="par_id3154344" role="code" xml-lang="en-US">RIGHT("Text" [; Number])</paragraph>
<paragraph id="par_id3149426" role="paragraph" xml-lang="en-US"> <emph>Text</emph> is the text of which the right part is to be determined.</paragraph>
<paragraph id="par_id3153350" role="paragraph" xml-lang="en-US"> <emph>Number</emph> (optional) is the number of characters from the right part of the text.</paragraph>
@@ -564,7 +564,7 @@
<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"/>
-<paragraph id="par_id2954344" role="code" xml-lang="en-US">RIGHTB("Text"; Number_bytes)</paragraph>
+<paragraph id="par_id2954344" role="code" xml-lang="en-US">RIGHTB("Text" [; Number_bytes])</paragraph>
<paragraph id="par_id2949426" role="paragraph" xml-lang="en-US"><emph>Text</emph> is the text of which the right part is to be determined.</paragraph>
<paragraph id="par_id2953350" role="paragraph" xml-lang="en-US"><emph>Number_bytes</emph> (optional) specifies the number of characters you want RIGHTB to extract, based on bytes.</paragraph>
@@ -587,7 +587,7 @@
<paragraph id="par_id3151256" role="paragraph" xml-lang="en-US"><ahelp hid="HID_FUNC_ROEMISCH">Converts a number into a Roman numeral. The value range must be between 0 and 3999, the modes can be integers from 0 to 4.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
-<paragraph id="par_id3150593" role="code" xml-lang="en-US">ROMAN(Number; Mode)</paragraph>
+<paragraph id="par_id3150593" role="code" xml-lang="en-US">ROMAN(Number [; Mode])</paragraph>
<paragraph id="par_id3156139" role="paragraph" xml-lang="en-US"> <emph>Number</emph> is the number that is to be converted into a Roman numeral.</paragraph>
<paragraph id="par_id3153318" role="paragraph" xml-lang="en-US"> <emph>Mode</emph> (optional) indicates the degree of simplification. The higher the value, the greater is the simplification of the Roman number.</paragraph>
@@ -611,7 +611,7 @@
<paragraph id="par_id3148692" role="paragraph" xml-lang="en-US"><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#regulaer"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
-<paragraph id="par_id3154671" role="code" xml-lang="en-US">SEARCH("FindText"; "Text"; Position)</paragraph>
+<paragraph id="par_id3154671" role="code" xml-lang="en-US">SEARCH("FindText"; "Text" [; Position])</paragraph>
<paragraph id="par_id3146080" role="paragraph" xml-lang="en-US"> <emph>FindText</emph> is the text to be searched for.</paragraph>
<paragraph id="par_id3154111" role="paragraph" xml-lang="en-US"> <emph>Text</emph> is the text where the search will take place.</paragraph>
<paragraph id="par_id3149559" role="paragraph" xml-lang="en-US"> <emph>Position</emph> (optional) is the position in the text where the search is to start.</paragraph>
@@ -631,7 +631,7 @@
<paragraph id="par_id3153698" role="paragraph" xml-lang="en-US"><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" xml-lang="en-US">SUBSTITUTE("Text"; "SearchText"; "NewText"; Occurrence)</paragraph>
+<paragraph id="par_id3147582" role="code" xml-lang="en-US">SUBSTITUTE("Text"; "SearchText"; "NewText" [; Occurrence])</paragraph>
<paragraph id="par_id3153675" role="paragraph" xml-lang="en-US"> <emph>Text</emph> is the text in which text segments are to be exchanged.</paragraph>
<paragraph id="par_id3156155" role="paragraph" xml-lang="en-US"> <emph>SearchText </emph>is the text segment that is to be replaced (a number of times).</paragraph>
<paragraph id="par_id3145779" role="paragraph" xml-lang="en-US"> <emph>NewText</emph> is the text that is to replace the text segment.</paragraph>