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

Mike Kaganski (via logerrit) logerrit at kemper.freedesktop.org
Thu Mar 5 12:22:56 UTC 2020


 source/text/scalc/01/04060101.xhp |    6 +++---
 1 file changed, 3 insertions(+), 3 deletions(-)

New commits:
commit 86e43e1b40c3fdbdd6edd93c2b717e891e17cedb
Author:     Mike Kaganski <mike.kaganski at collabora.com>
AuthorDate: Thu Mar 5 09:56:49 2020 +0100
Commit:     Olivier Hallot <olivier.hallot at libreoffice.org>
CommitDate: Thu Mar 5 13:22:36 2020 +0100

    Clarify database functions' range structure
    
    Change-Id: Iae6eca2e0579a5a7814820f8a22144b1725bbc52
    Reviewed-on: https://gerrit.libreoffice.org/c/help/+/89924
    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 8e1e7505f..503f97d8d 100644
--- a/source/text/scalc/01/04060101.xhp
+++ b/source/text/scalc/01/04060101.xhp
@@ -401,12 +401,12 @@
       <h3 id="hd_id3150962">Database Function Parameters:</h3>
       <paragraph xml-lang="en-US" id="par_id3155837" role="paragraph">The following items are the parameter definitions for all database functions:</paragraph>
       <paragraph xml-lang="en-US" id="par_id3149453" role="paragraph">
-<emph>Database</emph> is the cell range defining the database.</paragraph>
+<emph>Database</emph> is the cell range defining the database. The first row of the range contains the field names, and following rows are records with corresponding field values.</paragraph>
       <paragraph xml-lang="en-US" id="par_id3151272" role="paragraph">
-<emph>DatabaseField</emph> specifies the column where the function operates on after the search criteria of the first parameter is applied and the data rows are selected. It is not related to the search criteria itself. <variable id="quotes">For the DatabaseField parameter you can enter a reference to a header cell or a number to specify the column within the Database area, starting with 1. To reference a column by means of the literal column header name, place quotation marks around the header name.
+<emph>DatabaseField</emph> specifies the column where the function operates on after the search criteria of the first parameter is applied and the data rows are selected. It is not related to the search criteria itself. <variable id="quotes">For the DatabaseField parameter you can enter a reference to a header cell or a number to specify the column within the Database area, starting with 1. To reference a column by means of the literal column header name (from the first row of <emph>Database</emph> range), place quotation marks around the header name.
 </variable></paragraph>
       <paragraph xml-lang="en-US" id="par_id3147083" role="paragraph">
-<emph>SearchCriteria</emph> is the cell range containing search criteria. If you write several criteria in one row they are connected by AND. If you write the criteria in different rows they are connected by OR. Empty cells in the search criteria range will be ignored.</paragraph>
+<emph>SearchCriteria</emph> is the cell range containing search criteria. Like <emph>Database</emph>, its first row is also field names, and following rows are conditions for related fields. If you write several criteria in one row they are connected by AND. If you write the criteria in different rows they are connected by OR. Empty cells in the search criteria range will be ignored.</paragraph>
 <paragraph xml-lang="en-US" id="par_id3151188" role="paragraph">Choose <link href="text/shared/optionen/01060500.xhp" name="Spreadsheet - Calculate"><switchinline select="sys"><caseinline select="MAC"><menuitem>%PRODUCTNAME - Preferences</menuitem></caseinline><defaultinline><menuitem>Tools - Options</menuitem></defaultinline></switchinline><menuitem> - %PRODUCTNAME Calc - Calculate</menuitem></link> to define how $[officename] Calc acts when searching for identical entries.</paragraph>
       <paragraph xml-lang="en-US" id="par_id3882869" role="paragraph">See also the Wiki page about <link href="https://wiki.documentfoundation.org/Documentation/How_Tos/Conditional_Counting_and_Summation" name="wiki.documentfoundation.org Documentation/HowTo/Calc/Conditional Counting and Summation">Conditional Counting and Summation</link>.</paragraph>
 <sort order="asc">


More information about the Libreoffice-commits mailing list