source/text/scalc/01/04060106.xhp | 12 ++++++------
1 file changed, 6 insertions(+), 6 deletions(-)
New commits:
commit e65f50a38a39945ded8e3abefde0a309ea98fb8c
Author: Steve Fanning <stevemfann...@yahoo.co.uk>
AuthorDate: Wed May 27 17:08:42 2020 +0200
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Mon Jun 8 18:10:37 2020 +0200
Update syntax section for six functions to include square brackets,
indicating optional parameters.
Change-Id: I27d069e76e448b2f019bd8678a1769b82f2f5c20
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/94952
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
(cherry picked from commit 98cb0fc30637973a7ff8d15b86ec22a34a813c5a)
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95686
Reviewed-by: Ilmari Lauhakangas <ilmari.lauhakan...@libreoffice.org>
diff --git a/source/text/scalc/01/04060106.xhp
b/source/text/scalc/01/04060106.xhp
index a226f3637..7b8658a38 100644
--- a/source/text/scalc/01/04060106.xhp
+++ b/source/text/scalc/01/04060106.xhp
@@ -660,7 +660,7 @@
<paragraph id="par_id3109841" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_FUNC_LOG">Returns the logarithm of a number to the specified
base.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
-<paragraph id="par_id3144732" role="code" xml-lang="en-US">LOG(Number;
Base)</paragraph>
+<paragraph id="par_id3144732" role="code" xml-lang="en-US">LOG(Number[;
Base])</paragraph>
<paragraph id="par_id3144746" role="paragraph"
xml-lang="en-US"><emph>Number</emph> is the value whose logarithm is to be
calculated.</paragraph>
<paragraph id="par_id3152840" role="paragraph"
xml-lang="en-US"><emph>Base</emph> (optional) is the base for the logarithm
calculation. If omitted, Base 10 is assumed.</paragraph>
@@ -872,7 +872,7 @@
<paragraph id="par_id3158150" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_FUNC_RUNDEN">Rounds a number to a certain number of decimal
places.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
-<paragraph id="par_id3158182" role="code" xml-lang="en-US">ROUND(Number;
Count)</paragraph>
+<paragraph id="par_id3158182" role="code" xml-lang="en-US">ROUND(Number[;
Count])</paragraph>
<paragraph id="par_id3158196" role="paragraph" xml-lang="en-US">Returns
<emph>Number</emph> rounded to <emph>Count</emph> decimal places. If Count is
omitted or zero, the function rounds to the nearest integer. If Count is
negative, the function rounds to the nearest 10, 100, 1000, etc.</paragraph>
<paragraph id="par_id599688" role="paragraph" xml-lang="en-US">This function
rounds to the nearest number. See ROUNDDOWN and ROUNDUP for
alternatives.</paragraph>
@@ -895,7 +895,7 @@
<paragraph id="par_id3146020" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_FUNC_ABRUNDEN">Rounds a number down, toward zero, to a certain
precision.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
-<paragraph id="par_id3146051" role="code" xml-lang="en-US">ROUNDDOWN(Number;
Count)</paragraph>
+<paragraph id="par_id3146051" role="code" xml-lang="en-US">ROUNDDOWN(Number[;
Count])</paragraph>
<paragraph id="par_id3146064" role="paragraph" xml-lang="en-US">Returns
<emph>Number</emph> rounded down (towards zero) to <emph>Count</emph> decimal
places. If Count is omitted or zero, the function rounds down to an integer. If
Count is negative, the function rounds down to the next 10, 100, 1000,
etc.</paragraph>
<paragraph id="par_id2188787" role="paragraph" xml-lang="en-US">This function
rounds towards zero. See ROUNDUP and ROUND for alternatives.</paragraph>
@@ -917,7 +917,7 @@
<paragraph id="par_id3163297" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_FUNC_AUFRUNDEN">Rounds a number up, away from zero, to a certain
precision.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
-<paragraph id="par_id3163328" role="code" xml-lang="en-US">ROUNDUP(Number;
Count)</paragraph>
+<paragraph id="par_id3163328" role="code" xml-lang="en-US">ROUNDUP(Number[;
Count])</paragraph>
<paragraph id="par_id3163342" role="paragraph" xml-lang="en-US">Returns
<emph>Number</emph> rounded up (away from zero) to <emph>Count</emph> decimal
places. If Count is omitted or zero, the function rounds up to an integer. If
Count is negative, the function rounds up to the next 10, 100, 1000,
etc.</paragraph>
<paragraph id="par_id9573961" role="paragraph" xml-lang="en-US">This function
rounds away from zero. See ROUNDDOWN and ROUND for alternatives.</paragraph>
@@ -1049,7 +1049,7 @@
<paragraph id="par_id3151986" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_FUNC_SUMMEWENN">Adds the cells specified by a given criteria.</ahelp>
This function is used to browse a range when you search for a certain
value.</paragraph>
<embed href="text/shared/00/00000001.xhp#regulaer"/>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
-<paragraph id="par_id3152028" role="code" xml-lang="en-US">SUMIF(Range;
Criteria; SumRange)</paragraph>
+<paragraph id="par_id3152028" role="code" xml-lang="en-US">SUMIF(Range;
Criteria[; SumRange])</paragraph>
<paragraph id="par_id3152043" role="paragraph"
xml-lang="en-US"><emph>Range</emph> is the range to which the criteria are to
be applied.</paragraph>
<paragraph id="par_id3152062" role="paragraph"
xml-lang="en-US"><emph>Criteria</emph> is the cell in which the search
criterion is shown, or the search criterion itself. If the criteria is written
into the formula, it has to be surrounded by double quotes.</paragraph>
<paragraph id="par_id3152083" role="paragraph"
xml-lang="en-US"><emph>SumRange</emph> is the range from which values are
summed. If this parameter has not been indicated, the values found in the Range
are summed.</paragraph>
@@ -1368,7 +1368,7 @@
<paragraph id="par_id3143708" role="paragraph" xml-lang="en-US"><ahelp
hid="HID_FUNC_UMRECHNEN">Converts between old European national currency and to
and from Euros.</ahelp></paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
-<paragraph id="par_id3143748" role="code" xml-lang="en-US">EUROCONVERT(Value;
"From_currency"; "To_currency", full_precision,
triangulation_precision)</paragraph>
+<paragraph id="par_id3143748" role="code" xml-lang="en-US">EUROCONVERT(Value;
"From_currency"; "To_currency"[; full_precision][;
triangulation_precision])</paragraph>
<paragraph id="par_id3143763" role="paragraph"
xml-lang="en-US"><emph>Value</emph> is the amount of the currency to be
converted.</paragraph>
<paragraph id="par_id3143782" role="paragraph"
xml-lang="en-US"><emph>From_currency</emph> and <emph>To_currency</emph> are
the currency units to convert from and to respectively. These must be text, the
official abbreviation for the currency (for example, "EUR"). The rates (shown
per Euro) were set by the European Commission.</paragraph>
<paragraph id="par_id0119200904301810" role="paragraph"
xml-lang="en-US"><emph>Full_precision</emph> is optional. If omitted or False,
the result is rounded according to the decimals of the To currency. If
Full_precision is True, the result is not rounded.</paragraph>
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
