source/text/scalc/01/ex_data_stat_func.xhp | 17 +++++++++++++++++
source/text/scalc/01/func_averageifs.xhp | 24 +++++++++---------------
source/text/scalc/01/func_countifs.xhp | 18 +++++++++---------
source/text/scalc/01/func_maxifs.xhp | 21 ++++++---------------
source/text/scalc/01/func_minifs.xhp | 21 ++++++---------------
source/text/scalc/01/func_sumifs.xhp | 22 ++++++----------------
source/text/shared/optionen/01060500.xhp | 2 ++
7 files changed, 55 insertions(+), 70 deletions(-)
New commits:
commit 3e5bd012ebefd160ff4d7070b6e1794e44d91ae5
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
Date: Sat Jun 2 13:11:59 2018 -0300
Better use of embed for similar contents
Save translation work for 'IFS functions
Change-Id: I7e9c9fa9d84419f4faf28622be818eb7f2fe6d2a
Reviewed-on: https://gerrit.libreoffice.org/55211
Tested-by: Jenkins <c...@libreoffice.org>
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
diff --git a/source/text/scalc/01/ex_data_stat_func.xhp
b/source/text/scalc/01/ex_data_stat_func.xhp
index bc87524d9..a0f2bc98d 100644
--- a/source/text/scalc/01/ex_data_stat_func.xhp
+++ b/source/text/scalc/01/ex_data_stat_func.xhp
@@ -119,6 +119,23 @@
</tablecell>
</tablerow>
</table>
+<paragraph id="par_id1191767622119" role="warning" xml-lang="en-US">In all
examples below, ranges for calculation contain the row #6, which is ignored
because it contains text.</paragraph>
+</section>
+<paragraph role="paragraph" id="par_id961527953004850"
xml-lang="en-US"><variable id="args">Func_Range; Range1; Criterion1 [ ; Range2;
Criterion2 [;...]])</variable></paragraph>
+<section id="note01">
+ <paragraph id="par_id94162948227556" role="note" xml-lang="en-US">The
logical relation between criteria can be defined as logical AND (conjunction).
In other words, if and only if all given criteria are met, a value from the
corresponding cell of the given <emph>Func_Range</emph> is taken into
calculation.</paragraph>
+</section>
+<section id="warning01">
+ <paragraph id="par_id14734320631377" role="warning"
xml-lang="en-US"><emph>Func_Range</emph> and <emph>Range1, Range2...</emph>
must have the same size, otherwise the function returns err:502 - Invalid
argument.</paragraph>
+</section>
+<section id="par00">
+ <paragraph id="par_id23526994221948" role="paragraph"
xml-lang="en-US"><emph>Criterion1</emph> – required argument. A string
expression representing a logical condition or a cell reference to such string
expression. The expression can contain text, numbers, regular expressions or
wildcards (<link href="text/shared/optionen/01060500.xhp#wildcards" name="Wild
cards">if enabled in calculation options</link>).</paragraph>
+ <paragraph id="par_id190621657742" role="paragraph"
xml-lang="en-US"><emph>Range2</emph> – Optional. Range2 and all the following
mean the same as Range1.</paragraph>
+ <paragraph id="par_id317001803813193" role="paragraph"
xml-lang="en-US"><emph>Criterion2</emph> – Optional. Criterion2 and all the
following mean the same as Criterion1.</paragraph>
+</section>
+<section id="par01">
+ <paragraph xml-lang="en-US" id="par_id191527781733238"
role="paragraph">The function can have up to 255 arguments, meaning that you
can specify 127 criteria ranges and criteria for them.</paragraph>
+ <paragraph id="par_id175721789527973" role="warning" xml-lang="en-US">If a
cell contains TRUE, it is treated as 1, if a cell contains FALSE – as 0
(zero).</paragraph>
</section>
</body>
</helpdocument>
diff --git a/source/text/scalc/01/func_averageifs.xhp
b/source/text/scalc/01/func_averageifs.xhp
index a0a94c292..6a38f4e4d 100644
--- a/source/text/scalc/01/func_averageifs.xhp
+++ b/source/text/scalc/01/func_averageifs.xhp
@@ -27,22 +27,16 @@
<paragraph id="par_id538405384053840" role="paragraph" xml-lang="en-US"><ahelp
hid="."><variable id="averageifs_des">Returns the arithmetic mean of all cells
in a range that satisfy given multiple criteria. The AVERAGEIFS function sums
up all the results that match the logical tests and divides this sum by the
quantity of selected values.</variable></ahelp></paragraph>
</section>
<paragraph id="hd_id538895388953889" role="heading" level="3"
xml-lang="en-US">Syntax</paragraph>
-<paragraph id="par_id21050267713178" role="code"
xml-lang="en-US">AVERAGEIFS(Average_range; Criterion_range1; Criterion1 [;
Criterion_range2; Criterion2 [; ...]])</paragraph>
-<paragraph id="par_id165832700711773" role="paragraph"
xml-lang="en-US"><emph>Average_range</emph> – required argument. It is a range
of cells, a name of a named range or a label of a column or a row containing
values for calculating the mean.</paragraph>
-<paragraph id="par_id23557225011065" role="paragraph"
xml-lang="en-US"><emph>Criterion_range1</emph> – required argument. It is a
range of cells, a name of a named range or a label of a column or a row
containing values for finding the corresponding criterion.</paragraph>
-<paragraph id="par_id115612745015792" role="paragraph"
xml-lang="en-US"><emph>Criterion1</emph> – required argument. A condition in
the form of expression or a cell reference to expression that defines what
cells should be used to calculate the mean. The expression can contain text,
numbers, regular expressions (if enabled in calculation options) or wildcards
(if enabled in calculation options). </paragraph>
-<paragraph id="par_id249477513695" role="paragraph"
xml-lang="en-US"><emph>Criterion_range2</emph> – Optional. Criterion_range2 and
all the following mean the same as Criterion_range1.</paragraph>
-<paragraph id="par_id157492744623347" role="paragraph"
xml-lang="en-US"><emph>Criterion2</emph> – Optional. Criterion2 and all the
following mean the same as Criterion1.</paragraph>
-<paragraph id="par_id262061474420658" role="note" xml-lang="en-US">The logical
relation between criteria can be defined as logical AND (conjunction). In other
words, if and only if all given criteria are met, a value from the
corresponding cell of the given Average_range is taken into calculation of the
mean.<br/>
-The <emph>Criterion</emph> needs to be a string expression, in particular, the
<emph>Criterion</emph> needs to be enclosed in quotation marks ("Criterion")
with the exception of the names of functions, cell references and the operator
of a string concatenation (&).<br />
-The operators equal to (=), not equal to (<>), greater than (>), greater
than or equal to (>=), less than (<), and less than or equal to (<=) can
be used in criterion arguments for comparison of numbers.<br />
-The function can have up to 255 arguments, meaning that you can specify 127
criteria ranges and criteria for it.</paragraph><embed
href="text/scalc/01/ODFF.xhp#odff"/>
-<paragraph id="par_id51531273215056" role="warning" xml-lang="en-US">If a cell
in a range of values for calculating the mean is empty or contains text, the
function AVERAGEIFS ignores this cell.<br/>
-If a cell contains TRUE, it is treated as 1, if a cell contains FALSE – as 0
(zero).<br/>
-If the whole range is empty, contains only text or all values of the range do
not satisfy the condition (or any combination of those), the function returns
the #DIV/0! error.<br/>
-If the range of values for calculating the mean and any range for finding
criterion have unequal sizes, the function returns err:502.</paragraph>
+<paragraph id="par_id21050267713178" role="code"
xml-lang="en-US">AVERAGEIFS(<embedvar
href="text/scalc/01/ex_data_stat_func.xhp#args" markup="ignore"/>)</paragraph>
+<paragraph id="par_id165832700711773" role="paragraph"
xml-lang="en-US"><emph>Func_range</emph> – required argument. It is a range of
cells, a name of a named range or a label of a column or a row containing
values for calculating the mean.</paragraph>
+
+<embed href="text/scalc/01/ex_data_stat_func.xhp#par00"/>
+<embed href="text/scalc/01/ex_data_stat_func.xhp#warning01"/>
+<embed href="text/scalc/01/ex_data_stat_func.xhp#note01"/>
+<embed href="text/scalc/01/ex_data_stat_func.xhp#par01"/>
+
+<embed href="text/scalc/01/ODFF.xhp#odff"/>
<embed href="text/scalc/01/ex_data_stat_func.xhp#ex_func_average"/>
-<paragraph id="par_id151201977228038" role="warning" xml-lang="en-US">In all
examples below, ranges for average calculation contain the row #6, but it is
ignored, because it contains text.</paragraph>
<paragraph id="hd_id20733192524041" role="heading" level="4"
xml-lang="en-US">Simple usage</paragraph>
<paragraph id="par_id24004653627203" role="paragraph" xml-lang="en-US"><item
type="input">=AVERAGEIFS(B2:B6;B2:B6;">=20")</item></paragraph>
<paragraph id="par_id30201168686268" role="paragraph"
xml-lang="en-US">Calculates the average for values of the range B2:B6 that are
greater than or equal to 20. Returns 25, because the fifth row does not meet
the criterion.</paragraph>
diff --git a/source/text/scalc/01/func_countifs.xhp
b/source/text/scalc/01/func_countifs.xhp
index bb0280dc4..8a46e0f59 100644
--- a/source/text/scalc/01/func_countifs.xhp
+++ b/source/text/scalc/01/func_countifs.xhp
@@ -30,16 +30,16 @@
<paragraph id="hd_id465746574657" role="heading" level="3"
xml-lang="en-US">Syntax</paragraph>
<paragraph id="par_id27421466710275" role="code"
xml-lang="en-US">COUNTIFS(Range1; Criterion1 [; Range2; Criterion2 [;
...]])</paragraph>
<paragraph id="par_id242131304318587" role="paragraph"
xml-lang="en-US"><emph>Range1</emph> – required argument. It is a range of
cells, a name of a named range or a label of a column or a row containing
values for counting and finding the corresponding criterion.</paragraph>
-<paragraph id="par_id23526994221948" role="paragraph"
xml-lang="en-US"><emph>Criterion1</emph> – required argument. A condition in
the form of expression or a cell reference to expression that defines what
cells should be used for counting. The expression can contain text, numbers,
regular expressions (if enabled in calculation options) or wildcards (if
enabled in calculation options). </paragraph>
-<paragraph id="par_id190621657742" role="paragraph"
xml-lang="en-US"><emph>Range2</emph> – Optional. Range2 and all the following
mean the same as Range1.</paragraph>
-<paragraph id="par_id317001803813193" role="paragraph"
xml-lang="en-US"><emph>Criterion2</emph> – Optional. Criterion2 and all the
following mean the same as Criterion1.</paragraph>
-<paragraph id="par_id14223137501158" role="note" xml-lang="en-US">The logical
relation between criteria can be defined as logical AND (conjunction). In other
words, if and only if all given criteria are met, a row or a column is taken
into counting.<br/>
-The <emph>Criterion</emph> needs to be a string expression, in particular, the
<emph>Criterion</emph> needs to be enclosed in quotation marks ("Criterion")
with the exception of the names of functions, cell references and the operator
of a string concatenation (&).<br />
-The operators equal to (=), not equal to (<>), greater than (>),
greater than or equal to (>=), less than (<), and less than or equal to
(<=) can be used in criterion arguments for comparison of numbers.<br />
-The function can have up to 500 arguments, meaning that you can specify 250
pairs of ranges and criteria.</paragraph>
+
+<embed href="text/scalc/01/ex_data_stat_func.xhp#par00"/>
+
+<paragraph id="par_id14734320631377" role="warning"
xml-lang="en-US"><emph>Range1, Range2, ...</emph> and <emph>Criterion1,
Criterion2, ...</emph> must have the same size, otherwise the function returns
err:502 - Invalid argument.</paragraph>
+
+<embed href="text/scalc/01/ex_data_stat_func.xhp#note01"/>
+<embed href="text/scalc/01/ex_data_stat_func.xhp#par01"/>
+
<embed href="text/scalc/01/ODFF.xhp#odff"/>
-<paragraph id="par_id16654883224356" role="warning" xml-lang="en-US">If a cell
contains TRUE, it is treated as 1, if a cell contains FALSE – as 0 (zero).<br/>
-If ranges for arguments <emph>Range</emph> and <emph>Criterion</emph> have
unequal sizes, the function returns err:502.</paragraph>
+
<embed href="text/scalc/01/ex_data_stat_func.xhp#ex_func_average"/>
<paragraph id="hd_id3861259759512" role="heading" level="4"
xml-lang="en-US">Simple usage</paragraph>
<paragraph id="par_id15856592423333" role="paragraph" xml-lang="en-US"><item
type="input">=COUNTIFS(B2:B6;">=20")</item></paragraph>
diff --git a/source/text/scalc/01/func_maxifs.xhp
b/source/text/scalc/01/func_maxifs.xhp
index 238f9cfb4..43c1ac083 100644
--- a/source/text/scalc/01/func_maxifs.xhp
+++ b/source/text/scalc/01/func_maxifs.xhp
@@ -28,25 +28,16 @@
</section>
<paragraph id="hd_id660246602466024" role="heading" level="3"
xml-lang="en-US">Syntax</paragraph>
-<paragraph id="par_id11655988824213" role="code" xml-lang="en-US">MAXIFS(
Max_Range ; Criterion_range1 ; Criterion1 [ ; Criterion_range2 ; Criterion2
[;...]])</paragraph>
+<paragraph id="par_id11655988824213" role="code"
xml-lang="en-US">MAXIFS(<embedvar
href="text/scalc/01/ex_data_stat_func.xhp#args" markup="ignore"/>)</paragraph>
-<paragraph id="par_id59901690530236" role="paragraph"
xml-lang="en-US"><emph>Max_Range</emph> – required argument. A range of cells,
a name of a named range or a label of a column or a row containing values for
calculating the maximum.</paragraph>
-<paragraph id="par_id14445505532098" role="paragraph"
xml-lang="en-US"><emph>Criterion_range1</emph> – required argument. A range of
cells, a named range or a label of a column or a row containing values for
finding the corresponding criterion.</paragraph>
-<paragraph id="par_id24470258022447" role="paragraph"
xml-lang="en-US"><emph>Criterion1</emph> – required argument. A string
expression of the conditon that defines what cells should be used to calculate
the maximum. The expression can contain text, numbers, regular expressions (if
enabled in calculation options) or wildcards (if enabled in calculation
options).</paragraph>
-<paragraph id="par_id111151356820933" role="paragraph"
xml-lang="en-US"><emph>Criterion_range2</emph> – Optional. Criterion_range2 and
all the following mean the same as Criterion_range1.</paragraph>
-<paragraph id="par_id14734320631376" role="paragraph"
xml-lang="en-US"><emph>Criterion2</emph> – Optional. Criterion2 and all the
following mean the same as Criterion1.</paragraph>
-<paragraph id="par_id14734320631377" role="warning"
xml-lang="en-US"><emph>Max_Range</emph> and <emph>Criterion_range1,
Criterion_range2...</emph> must have the same size, otherwise the function
returns err:502 - Invalid argument.</paragraph>
-
-<paragraph id="par_id94162948227556" role="note" xml-lang="en-US">The logical
relation between criteria can be defined as logical AND (conjunction). In other
words, if and only if all given criteria are met, a value from the
corresponding cell of the given <emph>Max_Range</emph> is taken into
calculation of the maximum.</paragraph>
-
-<paragraph xml-lang="en-US" id="par_id191527781733238" role="paragraph">The
function can have up to 255 arguments, meaning that you can specify 127
criteria ranges and criteria for them.</paragraph>
+<paragraph id="par_id59901690530236" role="paragraph"
xml-lang="en-US"><emph>Func_Range</emph> – required argument. A range of cells,
a name of a named range or a label of a column or a row containing values for
calculating the maximum.</paragraph>
+<embed href="text/scalc/01/ex_data_stat_func.xhp#par00"/>
+<embed href="text/scalc/01/ex_data_stat_func.xhp#warning01"/>
+<embed href="text/scalc/01/ex_data_stat_func.xhp#note01"/>
+<embed href="text/scalc/01/ex_data_stat_func.xhp#par01"/>
<embed href="text/scalc/01/ODFF.xhp#odff"/>
-
-<paragraph id="par_id175721789527973" role="warning" xml-lang="en-US">If a
cell contains TRUE, it is treated as 1, if a cell contains FALSE – as 0
(zero).</paragraph>
-
<embed href="text/scalc/01/ex_data_stat_func.xhp#ex_func_average"/>
-<paragraph id="par_id1191767622119" role="warning" xml-lang="en-US">In all
examples below, ranges for maximum calculation contain the row #6, but it is
ignored, because it contains text.</paragraph>
<paragraph id="hd_id193452436229521" role="heading" level="4"
xml-lang="en-US">Simple usage</paragraph>
<paragraph id="par_id94321051525036" role="paragraph" xml-lang="en-US"><item
type="input">=MAXIFS(B2:B6;B2:B6;"<35")</item></paragraph>
diff --git a/source/text/scalc/01/func_minifs.xhp
b/source/text/scalc/01/func_minifs.xhp
index e09ec40a4..0f5d54f55 100644
--- a/source/text/scalc/01/func_minifs.xhp
+++ b/source/text/scalc/01/func_minifs.xhp
@@ -28,25 +28,16 @@
</section>
<paragraph id="hd_id660246602466024" role="heading" level="3"
xml-lang="en-US">Syntax</paragraph>
-<paragraph id="par_id11655988824213" role="code" xml-lang="en-US">MINIFS(
Min_Range ; Criterion_range1 ; Criterion1 [ ; Criterion_range2 ; Criterion2
[;...]])</paragraph>
+<paragraph id="par_id11655988824213" role="code"
xml-lang="en-US">MINIFS(<embedvar
href="text/scalc/01/ex_data_stat_func.xhp#args" markup="ignore"/>)</paragraph>
-<paragraph id="par_id59901690530236" role="paragraph"
xml-lang="en-US"><emph>Min_Range</emph> – required argument. A range of cells,
a name of a named range or a label of a column or a row containing values for
calculating the minimum.</paragraph>
-<paragraph id="par_id14445505532098" role="paragraph"
xml-lang="en-US"><emph>Criterion_range1</emph> – required argument. A range of
cells, a named range or a label of a column or a row containing values for
finding the corresponding criterion.</paragraph>
-<paragraph id="par_id24470258022447" role="paragraph"
xml-lang="en-US"><emph>Criterion1</emph> – required argument. A string
expression of the conditon that defines what cells should be used to calculate
the minimum. The expression can contain text, numbers, regular expressions (if
enabled in calculation options) or wildcards (if enabled in calculation
options).</paragraph>
-<paragraph id="par_id111151356820933" role="paragraph"
xml-lang="en-US"><emph>Criterion_range2</emph> – Optional. Criterion_range2 and
all the following mean the same as Criterion_range1.</paragraph>
-<paragraph id="par_id14734320631376" role="paragraph"
xml-lang="en-US"><emph>Criterion2</emph> – Optional. Criterion2 and all the
following mean the same as Criterion1.</paragraph>
-<paragraph id="par_id14734320631377" role="warning"
xml-lang="en-US"><emph>Min_Range</emph> and <emph>Criterion_range1,
Criterion_range2...</emph> must have the same size, otherwise the function
returns err:502 - Invalid argument.</paragraph>
-
-<paragraph id="par_id94162948227556" role="note" xml-lang="en-US">The logical
relation between criteria can be defined as logical AND (conjunction). In other
words, if and only if all given criteria are met, a value from the
corresponding cell of the given <emph>Min_Range</emph> is taken into
calculation of the minimum.</paragraph>
-
-<paragraph xml-lang="en-US" id="par_id191527781733238" role="paragraph">The
function can have up to 255 arguments, meaning that you can specify 127
criteria ranges and criteria for them.</paragraph>
+<paragraph id="par_id59901690530236" role="paragraph"
xml-lang="en-US"><emph>Func_Range</emph> – required argument. A range of cells,
a name of a named range or a label of a column or a row containing values for
calculating the minimum.</paragraph>
+<embed href="text/scalc/01/ex_data_stat_func.xhp#par00"/>
+<embed href="text/scalc/01/ex_data_stat_func.xhp#warning01"/>
+<embed href="text/scalc/01/ex_data_stat_func.xhp#note01"/>
+<embed href="text/scalc/01/ex_data_stat_func.xhp#par01"/>
<embed href="text/scalc/01/ODFF.xhp#odff"/>
-
-<paragraph id="par_id175721789527973" role="warning" xml-lang="en-US">If a
cell contains TRUE, it is treated as 1, if a cell contains FALSE – as 0
(zero).</paragraph>
-
<embed href="text/scalc/01/ex_data_stat_func.xhp#ex_func_average"/>
-<paragraph id="par_id1191767622119" role="warning" xml-lang="en-US">In all
examples below, ranges for minimum calculation contain the row #6, but it is
ignored, because it contains text.</paragraph>
<paragraph id="hd_id193452436229521" role="heading" level="4"
xml-lang="en-US">Simple usage</paragraph>
<paragraph id="par_id94321051525036" role="paragraph" xml-lang="en-US"><item
type="input">=MINIFS(B2:B6;B2:B6;"<35")</item></paragraph>
diff --git a/source/text/scalc/01/func_sumifs.xhp
b/source/text/scalc/01/func_sumifs.xhp
index 641da1789..cf1c5503f 100644
--- a/source/text/scalc/01/func_sumifs.xhp
+++ b/source/text/scalc/01/func_sumifs.xhp
@@ -28,26 +28,16 @@
</section>
<paragraph id="hd_id660246602466024" role="heading" level="3"
xml-lang="en-US">Syntax</paragraph>
-<paragraph id="par_id11655988824213" role="code" xml-lang="en-US">SUMIFS(
Sum_Range ; Criterion_range1 ; Criterion1 [ ; Criterion_range2 ; Criterion2
[;...]])</paragraph>
+<paragraph id="par_id11655988824213" role="code"
xml-lang="en-US">SUMIFS(<embedvar
href="text/scalc/01/ex_data_stat_func.xhp#args" markup="ignore"/>)</paragraph>
-<paragraph id="par_id59901690530236" role="paragraph"
xml-lang="en-US"><emph>Sum_Range</emph> – required argument. It is a range of
cells, a name of a named range or a label of a column or a row containing
values for calculating the sum.</paragraph>
-<paragraph id="par_id14445505532098" role="paragraph"
xml-lang="en-US"><emph>Criterion_range1</emph> – required argument. It is a
range of cells, a name of a named range or a label of a column or a row
containing values for finding the corresponding criterion.</paragraph>
-<paragraph id="par_id24470258022447" role="paragraph"
xml-lang="en-US"><emph>Criterion1</emph> – required argument. A condition in
the form of expression or a cell reference to expression that defines what
cells should be used to calculate the sum. The expression can contain text,
numbers, regular expressions (if enabled in calculation options) or wildcards
(if enabled in calculation options). </paragraph>
-<paragraph id="par_id111151356820933" role="paragraph"
xml-lang="en-US"><emph>Criterion_range2</emph> – Optional. Criterion_range2 and
all the following mean the same as Criterion_range1.</paragraph>
-<paragraph id="par_id14734320631376" role="paragraph"
xml-lang="en-US"><emph>Criterion2</emph> – Optional. Criterion2 and all the
following mean the same as Criterion1.</paragraph>
-<paragraph id="par_id14734320631377" role="warning"
xml-lang="en-US"><emph>Sum_Range</emph> and <emph>Criterion_range1,
Criterion_range2...</emph> must have the same size or the function returns
err:502 - Invalid argument.</paragraph>
-
-<paragraph id="par_id94162948227556" role="note" xml-lang="en-US">The logical
relation between criteria can be defined as logical AND (conjunction). In other
words, if and only if all given criteria are met, a value from the
corresponding cell of the given <emph>Sum_Range</emph> is taken into
calculation of the sum.<br/>
-The <emph>Criterion</emph> needs to be a string expression, in particular, the
<emph>Criterion</emph> needs to be enclosed in quotation marks ("Criterion")
with the exception of the names of functions, cell references and the operator
of a string concatenation (&).<br />
-The operators equal to (=), not equal to (<>), greater than (>),
greater than or equal to (>=), less than (<), and less than or equal to
(<=) can be used in criterion arguments for comparison of numbers.<br />
-The function can have up to 255 arguments, meaning that you can specify 127
criteria ranges and criteria for them.</paragraph>
+<paragraph id="par_id59901690530236" role="paragraph"
xml-lang="en-US"><emph>Func_Range</emph> – required argument. It is a range of
cells, a name of a named range or a label of a column or a row containing
values for calculating the sum.</paragraph>
+<embed href="text/scalc/01/ex_data_stat_func.xhp#par00"/>
+<embed href="text/scalc/01/ex_data_stat_func.xhp#warning01"/>
+<embed href="text/scalc/01/ex_data_stat_func.xhp#note01"/>
+<embed href="text/scalc/01/ex_data_stat_func.xhp#par01"/>
<embed href="text/scalc/01/ODFF.xhp#odff"/>
-
-<paragraph id="par_id175721789527973" role="warning" xml-lang="en-US">If a
cell contains TRUE, it is treated as 1, if a cell contains FALSE – as 0
(zero).</paragraph>
-
<embed href="text/scalc/01/ex_data_stat_func.xhp#ex_func_average"/>
-<paragraph id="par_id1191767622119" role="warning" xml-lang="en-US">In all
examples below, ranges for sum calculation contain the row #6, but it is
ignored, because it contains text.</paragraph>
<paragraph id="hd_id193452436229521" role="heading" level="4"
xml-lang="en-US">Simple usage</paragraph>
<paragraph id="par_id94321051525036" role="paragraph" xml-lang="en-US"><item
type="input">=SUMIFS(B2:B6;B2:B6;">=20")</item></paragraph>
diff --git a/source/text/shared/optionen/01060500.xhp
b/source/text/shared/optionen/01060500.xhp
index c7e094146..3c6f348c5 100644
--- a/source/text/shared/optionen/01060500.xhp
+++ b/source/text/shared/optionen/01060500.xhp
@@ -193,6 +193,7 @@
<paragraph xml-lang="en-US" id="par_id3148814" role="paragraph">If
<emph>Search criteria = and <> must apply to whole cells </emph>is not
enabled, the "win" search pattern acts like "*win*". The search pattern can be
at any position within the cell when searching with the Calc database
functions.</paragraph>
<paragraph xml-lang="en-US" id="par_id3155096" role="warning">Enable
whole cell match for spreadsheets that need to be interoperable with Microsoft
Excel.</paragraph>
+ <section id="wildcards">
<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/optcalculatepage/formulawildcards"
id="bm_id3154420" localize="false"/>
<paragraph xml-lang="en-US" id="hd_id3156449" role="heading" level="2">Enable
wildcards in formulas</paragraph>
<paragraph xml-lang="en-US" id="par_id3155093" role="paragraph"><ahelp
hid="modules/scalc/ui/optcalculatepage/formulawildcards">Specifies that
wildcards are enabled when searching and also for character string
comparisons.</ahelp><switchinline select="appl"><caseinline select="CALC"> This
relates to the <link href="text/scalc/01/04060101.xhp" name="database
functions">database functions</link>, and to VLOOKUP, HLOOKUP, MATCH,
AVERAGEIF, AVERAGEIFS, COUNTIF, COUNTIFS, SUMIF, SUMIFS and
SEARCH.</caseinline></switchinline></paragraph>
@@ -208,6 +209,7 @@
</listitem>
</list>
<paragraph xml-lang="en-US" id="par_id3155094" role="warning">Enable
wildcards in formulas for spreadsheets that need to be interoperable with
Microsoft Excel.</paragraph>
+ </section>
<bookmark xml-lang="en-US"
branch="hid/modules/scalc/ui/optcalculatepage/formularegex" id="bm_id3154419"
localize="false"/>
<paragraph xml-lang="en-US" id="hd_id3156448" role="heading" level="2">Enable
regular expressions in formulas</paragraph>
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
