[Libreoffice-commits] help.git: source/text

[Olivier Hallot]

 source/text/scalc/01/func_sumifs.xhp |    4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

New commits:
commit e22230a873bf0cd2e10746557f6d0003ee7a9859
Author: Olivier Hallot <ohallot at collabora.co.uk>
Date:   Tue Apr 5 16:59:09 2016 -0300

    tdf#97824 improve description of SUMIFS conditions
    
    Change-Id: I5f81ef8381536aeca8eac8d409c75f20d47212dc
    Reviewed-on: https://gerrit.libreoffice.org/23846
    Reviewed-by: David Tardon <dtardon at redhat.com>
    Tested-by: David Tardon <dtardon at redhat.com>

diff --git a/source/text/scalc/01/func_sumifs.xhp b/source/text/scalc/01/func_sumifs.xhp
index 23fc8bc..14e4ee3 100644
--- a/source/text/scalc/01/func_sumifs.xhp
+++ b/source/text/scalc/01/func_sumifs.xhp
@@ -35,6 +35,7 @@
 <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 />
@@ -43,8 +44,7 @@ The function can have up to 255 arguments, meaning that you can specify 127 crit
 
 <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).<br/>
-If the range of values for calculating the sum and any range for finding criterion have unequal sizes, the function returns err:502.</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>
 
 <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>