source/text/scalc/01/04060101.xhp | 2 ++
1 file changed, 2 insertions(+)
New commits:
commit 849d86762b4db20bbe7ce00ee3603a081f4872ff
Author: Steve Fanning <stevemfann...@yahoo.co.uk>
AuthorDate: Sun Apr 19 19:38:45 2020 +0100
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Mon Apr 20 23:45:03 2020 +0200
Update syntax section of Help for Calc's DCOUNT and DCOUNTA functions to
indicate how to omit middle parameter (see bug 131362).
Change-Id: Ib1fd850371c1876f16c10905994a92ac83a5a351
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/92443
Tested-by: Olivier Hallot <olivier.hal...@libreoffice.org>
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
diff --git a/source/text/scalc/01/04060101.xhp
b/source/text/scalc/01/04060101.xhp
index 503f97d8d..76e83be24 100644
--- a/source/text/scalc/01/04060101.xhp
+++ b/source/text/scalc/01/04060101.xhp
@@ -421,6 +421,7 @@
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id3153218"
role="code">DCOUNT(Database; [DatabaseField]; SearchCriteria)</paragraph>
<paragraph xml-lang="en-US" id="par_id3153273" role="paragraph">If
the DatabaseField argument is omitted, DCOUNT returns the count of all records
that satisfy Criteria. <embedvar
href="text/scalc/01/04060101.xhp#quotes"/></paragraph>
+ <paragraph xml-lang="en-US" role="paragraph"
id="par_id301587321851330">If you choose to omit the DatabaseField argument,
your formula should be of the form =DCOUNT(Database; ;
SearchCriteria).</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id3153623" role="paragraph">In
the example above (scroll up, please), we want to know how many children have
to travel more than 600 meters to school. The result is to be stored in cell
B16. Set the cursor in cell B16. Enter the formula <item
type="input">=DCOUNT(A1:E10;D1;A13:E14)</item> in B16. The <emph>Function
Wizard</emph> helps you to input ranges.</paragraph>
<paragraph xml-lang="en-US" id="par_id3149142" role="paragraph">
@@ -439,6 +440,7 @@
<embed href="text/scalc/01/common_func.xhp#sectionsyntax"/>
<paragraph xml-lang="en-US" id="par_id3146893"
role="code">DCOUNTA(Database; [DatabaseField]; SearchCriteria)</paragraph>
<paragraph xml-lang="en-US" id="par_id3153274" role="paragraph">If
the DatabaseField argument is omitted, DCOUNTA returns the count of all records
that satisfy Criteria. <embedvar
href="text/scalc/01/04060101.xhp#quotes"/></paragraph>
+ <paragraph xml-lang="en-US" role="paragraph"
id="par_id31587322048553">If you choose to omit the DatabaseField argument,
your formula should be of the form =DCOUNTA(Database; ;
SearchCriteria).</paragraph>
<embed href="text/scalc/01/common_func.xhp#sectionexample"/>
<paragraph xml-lang="en-US" id="par_id3153982" role="paragraph">In
the example above (scroll up, please), you can search for the number of
children whose name starts with an E or a subsequent letter. Edit the formula
in B16 to read <item type="input">=DCOUNTA(A1:E10;"Name";A13:E14)</item>.
Delete the old search criteria and enter <item type="input">>=E</item> under
Name in field A14. The result is 5. If you now delete all number values for
Greta in row 8, the result changes to 4. Row 8 is no longer included in the
count because it does not contain any values. The name Greta is text, not a
value. Note that the DatabaseField parameter must point to a column that can
contain values.<comment>see i25407</comment></paragraph>
</section>
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
