diff options
| author | Mike Kaganski <mike.kaganski@collabora.com> | 2020-03-05 09:56:49 +0100 |
|---|---|---|
| committer | Olivier Hallot <olivier.hallot@libreoffice.org> | 2020-03-05 13:22:36 +0100 |
| commit | 86e43e1b40c3fdbdd6edd93c2b717e891e17cedb (patch) | |
| tree | f47268603934c7f91fb4890a847b42c1856643b4 /source/text/scalc/01 | |
| parent | Reorganise and refactor stuff in help.js for readability (diff) | |
| download | help-86e43e1b40c3fdbdd6edd93c2b717e891e17cedb.tar.gz help-86e43e1b40c3fdbdd6edd93c2b717e891e17cedb.zip | |
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@libreoffice.org>
Diffstat (limited to 'source/text/scalc/01')
| -rw-r--r-- | source/text/scalc/01/04060101.xhp | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/source/text/scalc/01/04060101.xhp b/source/text/scalc/01/04060101.xhp index 8e1e7505fa..503f97d8db 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"> |