summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorSteve Fanning <stevemfanning@yahoo.co.uk>2020-05-27 17:08:42 +0200
committerOlivier Hallot <olivier.hallot@libreoffice.org>2020-06-08 18:10:37 +0200
commite65f50a38a39945ded8e3abefde0a309ea98fb8c (patch)
tree94b81288c0c7fa24d5bc054ca4c09238122e8208
parentRestore sort for Index (diff)
downloadhelp-e65f50a38a39945ded8e3abefde0a309ea98fb8c.zip
help-e65f50a38a39945ded8e3abefde0a309ea98fb8c.tar.gz
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.hallot@libreoffice.org> (cherry picked from commit 98cb0fc30637973a7ff8d15b86ec22a34a813c5a) Reviewed-on: https://gerrit.libreoffice.org/c/help/+/95686 Reviewed-by: Ilmari Lauhakangas <ilmari.lauhakangas@libreoffice.org>
-rw-r--r--source/text/scalc/01/04060106.xhp12
1 files changed, 6 insertions, 6 deletions
diff --git a/source/text/scalc/01/04060106.xhp b/source/text/scalc/01/04060106.xhp
index a226f36..7b8658a 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>