source/text/scalc/01/04060110.xhp | 24 ++++++++++++------------
1 file changed, 12 insertions(+), 12 deletions(-)
New commits:
commit 55fb7f4908d0c2f8eeb4d6df54a070cd27fa1a38
Author: Steve Fanning <stevemfann...@yahoo.co.uk>
AuthorDate: Sat May 30 15:41:45 2020 +0200
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Mon Jun 8 18:26:40 2020 +0200
(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.hal...@libreoffice.org>
(cherry picked from commit 4bafa9e1d40f614b8d23637ce7fe49c0460f6553)
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95716
Reviewed-by: Ilmari Lauhakangas <ilmari.lauhakan...@libreoffice.org>
diff --git a/source/text/scalc/01/04060110.xhp
b/source/text/scalc/01/04060110.xhp
index 5f0bbc9c5..0c8859a61 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>
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
