diff options
Diffstat (limited to 'helpcontent2/source/text/scalc/01/04060101.xhp')
| -rw-r--r--[-rwxr-xr-x] | helpcontent2/source/text/scalc/01/04060101.xhp | 24 |
1 files changed, 12 insertions, 12 deletions
diff --git a/helpcontent2/source/text/scalc/01/04060101.xhp b/helpcontent2/source/text/scalc/01/04060101.xhp index 6caffe423d..d93663a37e 100755..100644 --- a/helpcontent2/source/text/scalc/01/04060101.xhp +++ b/helpcontent2/source/text/scalc/01/04060101.xhp @@ -507,7 +507,7 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id3150882"><bookmark_value>DCOUNT function</bookmark_value> <bookmark_value>counting rows;with numeric values</bookmark_value> </bookmark><comment>mw added "counting rows;"</comment> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_DBANZAHL" id="bm_id3152926" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_DBANZAHL" id="bm_id3152926" localize="false"/> <paragraph xml-lang="en-US" id="hd_id3150882" role="heading" level="2" l10n="U" oldref="88">DCOUNT</paragraph> <paragraph xml-lang="en-US" id="par_id3156133" role="paragraph" l10n="U" oldref="89"><ahelp hid="HID_FUNC_DBANZAHL">DCOUNT counts the number of rows (records) in a database that match the specified search criteria and contain numerical values.</ahelp></paragraph> @@ -529,7 +529,7 @@ <bookmark_value>records;counting in Calc databases</bookmark_value> <bookmark_value>counting rows;with numeric or alphanumeric values</bookmark_value> </bookmark><comment>mw added "records;" and "counting rows;"</comment> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_DBANZAHL2" id="bm_id3154055" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_DBANZAHL2" id="bm_id3154055" localize="false"/> <paragraph xml-lang="en-US" id="hd_id3156123" role="heading" level="2" l10n="U" oldref="97">DCOUNTA</paragraph> <paragraph xml-lang="en-US" id="par_id3156110" role="paragraph" l10n="U" oldref="98"><ahelp hid="HID_FUNC_DBANZAHL2">DCOUNTA counts the number of rows (records) in a database that match the specified search conditions, and contain numeric or alphanumeric values.</ahelp></paragraph> @@ -547,7 +547,7 @@ <bookmark_value>cell contents;searching in Calc databases</bookmark_value> <bookmark_value>searching;cell contents in Calc databases</bookmark_value> </bookmark><comment>mw added "cell contents;" and "searching;"</comment> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_DBAUSZUG" id="bm_id3149198" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_DBAUSZUG" id="bm_id3149198" localize="false"/> <paragraph xml-lang="en-US" id="hd_id3147256" role="heading" level="2" l10n="U" oldref="104">DGET</paragraph> <paragraph xml-lang="en-US" id="par_id3152801" role="paragraph" l10n="U" oldref="105"><ahelp hid="HID_FUNC_DBAUSZUG">DGET returns the contents of the referenced cell in a database which matches the specified search criteria.</ahelp> In case of an error, the function returns either #VALUE! for no row found, or Err502 for more than one cell found.</paragraph> @@ -574,7 +574,7 @@ <bookmark_value>maximum values in Calc databases</bookmark_value> <bookmark_value>searching;maximum values in columns</bookmark_value> </bookmark><comment>mw added "maximum..." and "searching;"</comment> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_DBMAX" id="bm_id3158401" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_DBMAX" id="bm_id3158401" localize="false"/> <paragraph xml-lang="en-US" id="hd_id3149766" role="heading" level="2" l10n="U" oldref="115">DMAX</paragraph> <paragraph xml-lang="en-US" id="par_id3154903" role="paragraph" l10n="U" oldref="116"><ahelp hid="HID_FUNC_DBMAX">DMAX returns the maximum content of a cell (field) in a database (all records) that matches the specified search conditions.</ahelp></paragraph> @@ -596,7 +596,7 @@ <bookmark_value>minimum values in Calc databases</bookmark_value> <bookmark_value>searching;minimum values in columns</bookmark_value> </bookmark><comment>mw added "minimum..." and "searching;"</comment> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_DBMIN" id="bm_id3159152" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_DBMIN" id="bm_id3159152" localize="false"/> <paragraph xml-lang="en-US" id="hd_id3159141" role="heading" level="2" l10n="U" oldref="123">DMIN</paragraph> <paragraph xml-lang="en-US" id="par_id3154261" role="paragraph" l10n="U" oldref="124"><ahelp hid="HID_FUNC_DBMIN">DMIN returns the minimum content of a cell (field) in a database that matches the specified search criteria.</ahelp></paragraph> @@ -618,7 +618,7 @@ <bookmark_value>averages; in Calc databases</bookmark_value> <bookmark_value>calculating;averages in Calc databases</bookmark_value> </bookmark><comment>mw added "averages;..." and "calculating;"</comment> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_DBMITTELWERT" id="bm_id3166435" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_DBMITTELWERT" id="bm_id3166435" localize="false"/> <paragraph xml-lang="en-US" id="hd_id3154274" role="heading" level="2" l10n="U" oldref="131">DAVERAGE</paragraph> <paragraph xml-lang="en-US" id="par_id3166453" role="paragraph" l10n="U" oldref="132"><ahelp hid="HID_FUNC_DBMITTELWERT">DAVERAGE returns the average of the values of all cells (fields) in all rows (database records) that match the specified search criteria.</ahelp></paragraph> @@ -639,7 +639,7 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id3159269"><bookmark_value>DPRODUCT function</bookmark_value> <bookmark_value>multiplying;cell contents in Calc databases</bookmark_value> </bookmark><comment>mw added "multiplying..."</comment> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_DBPRODUKT" id="bm_id3159281" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_DBPRODUKT" id="bm_id3159281" localize="false"/> <paragraph xml-lang="en-US" id="hd_id3159269" role="heading" level="2" l10n="U" oldref="139">DPRODUCT</paragraph> <paragraph xml-lang="en-US" id="par_id3152879" role="paragraph" l10n="U" oldref="140"><ahelp hid="HID_FUNC_DBPRODUKT">DPRODUCT multiplies all cells of a data range where the cell contents match the search criteria.</ahelp></paragraph> @@ -656,7 +656,7 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id3148462"><bookmark_value>DSTDEV function</bookmark_value> <bookmark_value>standard deviations in databases;based on a sample</bookmark_value> </bookmark><comment>mw added "standard deviations...;"</comment> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_DBSTDABW" id="bm_id3145370" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_DBSTDABW" id="bm_id3145370" localize="false"/> <paragraph xml-lang="en-US" id="hd_id3148462" role="heading" level="2" l10n="U" oldref="145">DSTDEV</paragraph> <paragraph xml-lang="en-US" id="par_id3154605" role="paragraph" l10n="U" oldref="146"><ahelp hid="HID_FUNC_DBSTDABW">DSTDEV calculates the standard deviation of a population based on a sample, using the numbers in a database column that match the given conditions.</ahelp> The records are treated as a sample of data. That means that the children in the example represent a cross section of all children. Note that a representative result can not be obtained from a sample of less than one thousand.</paragraph> @@ -677,7 +677,7 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id3150429"><bookmark_value>DSTDEVP function</bookmark_value> <bookmark_value>standard deviations in databases;based on populations</bookmark_value> </bookmark><comment>mw added "standard deviations...;"</comment> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_DBSTDABWN" id="bm_id3149523" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_DBSTDABWN" id="bm_id3149523" localize="false"/> <paragraph xml-lang="en-US" id="hd_id3150429" role="heading" level="2" l10n="U" oldref="153">DSTDEVP</paragraph> <paragraph xml-lang="en-US" id="par_id3145598" role="paragraph" l10n="U" oldref="154"><ahelp hid="HID_FUNC_DBSTDABWN">DSTDEVP calculates the standard deviation of a population based on all cells of a data range which match the search criteria.</ahelp> The records from the example are treated as the whole population.</paragraph> @@ -699,7 +699,7 @@ <bookmark_value>calculating;sums in Calc databases</bookmark_value> <bookmark_value>sums;cells in Calc databases</bookmark_value> </bookmark><comment>mw added "calculating;" and "sums;"</comment> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_DBSUMME" id="bm_id3148687" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_DBSUMME" id="bm_id3148687" localize="false"/> <paragraph xml-lang="en-US" id="hd_id3154794" role="heading" level="2" l10n="U" oldref="161">DSUM</paragraph> <paragraph xml-lang="en-US" id="par_id3149591" role="paragraph" l10n="U" oldref="162"><ahelp hid="HID_FUNC_DBSUMME">DSUM returns the total of all cells in a database field in all rows (records) that match the specified search criteria.</ahelp></paragraph> @@ -720,7 +720,7 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id3155614"><bookmark_value>DVAR function</bookmark_value> <bookmark_value>variances;based on samples</bookmark_value> </bookmark><comment>mw added "variances;"</comment> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_DBVARIANZ" id="bm_id3159391" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_DBVARIANZ" id="bm_id3159391" localize="false"/> <paragraph xml-lang="en-US" id="hd_id3155614" role="heading" level="2" l10n="U" oldref="170">DVAR</paragraph> <paragraph xml-lang="en-US" id="par_id3154418" role="paragraph" l10n="U" oldref="171"><ahelp hid="HID_FUNC_DBVARIANZ">DVAR returns the variance of all cells of a database field in all records that match the specified search criteria.</ahelp> The records from the example are treated as a sample of data. A representative result cannot be obtained from a sample population of less than one thousand.</paragraph> @@ -741,7 +741,7 @@ <bookmark xml-lang="en-US" branch="index" id="bm_id3153880"><bookmark_value>DVARP function</bookmark_value> <bookmark_value>variances;based on populations</bookmark_value> </bookmark><comment>mw added "variances;"</comment> -<bookmark xml-lang="en-US" branch="hid/HID_FUNC_DBVARIANZEN" id="bm_id3153891" localize="false"/> +<bookmark xml-lang="en-US" branch="hid/SC_HID_FUNC_DBVARIANZEN" id="bm_id3153891" localize="false"/> <paragraph xml-lang="en-US" id="hd_id3153880" role="heading" level="2" l10n="U" oldref="178">DVARP</paragraph> <paragraph xml-lang="en-US" id="par_id3155119" role="paragraph" l10n="U" oldref="179"><ahelp hid="HID_FUNC_DBVARIANZEN">DVARP calculates the variance of all cell values in a database field in all records that match the specified search criteria.</ahelp> The records are from the example are treated as an entire population.</paragraph> |