summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorOlivier Hallot <olivier.hallot@libreoffice.org>2018-06-02 13:11:59 -0300
committerOlivier Hallot <olivier.hallot@libreoffice.org>2018-06-07 22:25:54 +0200
commitdc25f00e499d4ece26fab2e17427583e99e45adf (patch)
tree46438a94fa0ad03b32bf649f8b595c49c7ccf75a
parent8ae83bb638d652d80fef5b449c43cc6f577cfa24 (diff)
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 <ci@libreoffice.org> Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org> (cherry picked from commit 3e5bd012ebefd160ff4d7070b6e1794e44d91ae5) Reviewed-on: https://gerrit.libreoffice.org/55448 Tested-by: Olivier Hallot <olivier.hallot@libreoffice.org>
-rw-r--r--source/text/scalc/01/ex_data_stat_func.xhp17
-rw-r--r--source/text/scalc/01/func_averageifs.xhp24
-rw-r--r--source/text/scalc/01/func_countifs.xhp18
-rw-r--r--source/text/scalc/01/func_maxifs.xhp21
-rw-r--r--source/text/scalc/01/func_minifs.xhp21
-rw-r--r--source/text/scalc/01/func_sumifs.xhp22
-rw-r--r--source/text/shared/optionen/01060500.xhp2
7 files changed, 55 insertions, 70 deletions
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 (&amp;).<br />
-The operators equal to (=), not equal to (&lt;>), greater than (>), greater than or equal to (>=), less than (&lt;), and less than or equal to (&lt;=) 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 (&amp;).<br />
-The operators equal to (=), not equal to (&lt;&gt;), greater than (&gt;), greater than or equal to (&gt;=), less than (&lt;), and less than or equal to (&lt;=) 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;"&lt;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;"&lt;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 (&amp;).<br />
-The operators equal to (=), not equal to (&lt;&gt;), greater than (&gt;), greater than or equal to (&gt;=), less than (&lt;), and less than or equal to (&lt;=) 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 &lt;&gt; 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>