source/text/scalc/01/04060101.xhp | 6 +++---
1 file changed, 3 insertions(+), 3 deletions(-)
New commits:
commit 86e43e1b40c3fdbdd6edd93c2b717e891e17cedb
Author: Mike Kaganski <mike.kagan...@collabora.com>
AuthorDate: Thu Mar 5 09:56:49 2020 +0100
Commit: Olivier Hallot <olivier.hal...@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.hal...@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">
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
