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

[Steve Fanning (via logerrit)]

 source/text/scalc/01/04060101.xhp |    2 ++
 1 file changed, 2 insertions(+)

New commits:
commit 849d86762b4db20bbe7ce00ee3603a081f4872ff
Author:     Steve Fanning <stevemfanning at yahoo.co.uk>
AuthorDate: Sun Apr 19 19:38:45 2020 +0100
Commit:     Olivier Hallot <olivier.hallot at 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.hallot at libreoffice.org>
    Tested-by: Jenkins
    Reviewed-by: Olivier Hallot <olivier.hallot at 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>