LibreOffice Help – 7.6/text/scalc/01 — Chinese (Traditional) @ TDF Weblate - LibreOffice: DGET(Database; DatabaseField; SearchCriteria)

Translation

Context 04060101.xhp par_id3154696 help.text

English oFi8J

Chinese (Traditional)

Needs editing

Insufficient privileges for saving translations.

Skip

Context	English	Chinese (Traditional)
04060101.xhp par_id3153218 help.text	DCOUNT(Database; [DatabaseField]; SearchCriteria)	DCOUNT(Database; DatabaseField; SearchCriteria)
04060101.xhp par_id3153623 help.text	The example database table giving information about the guests invited to Joe’s birthday party (described above) should occupy cells A1:E10. The content of cells A12:E12 should be identical to the header labels for the database table in cells A1:E1. Make sure that cells A13:E13 are blank, except for cell D13 which should contain ">600" (this search criterion will match records in the database table that have a value greater than 600 in the Distance column).
04060101.xhp par_id441616368480646 help.text	Insert the formula <input>=DCOUNT(A1:E10;; A12:E13)</input> into an empty cell elsewhere in the sheet to calculate how many of Joe’s party guests travel further than 600 meters to school. The value 5 is returned.
04060101.xhp par_id361616368488119 help.text	The same result is obtained if you use the formula <input>=DCOUNT(A1:E10; "Distance"; A12:E13)</input>, because all entries in the Distance column are numeric. However, if you use the formula <input>=DCOUNT(A1:E10; "Name"; A12:E13)</input>, the value 0 is returned because all entries in the Name column are non-numeric.
04060101.xhp bm_id3156123 help.text	<bookmark_value>DCOUNTA function</bookmark_value><bookmark_value>records;counting in Calc databases</bookmark_value><bookmark_value>counting rows;with numeric or alphanumeric values</bookmark_value>
04060101.xhp hd_id3156123 help.text	DCOUNTA	DCOUNTA
04060101.xhp par_id3156110 help.text	<ahelp hid="HID_FUNC_DBANZAHL2">DCOUNTA counts the number of cells (fields) of the specified column that are not blank, for all rows (database records) that match the specified search criteria.</ahelp> Blank cells of the specified column are not counted. However, if no column is specified, DCOUNTA returns the count of all records that match the specified search criteria irrespective of their contents.
04060101.xhp par_id3146893 help.text	DCOUNTA(Database; [DatabaseField]; SearchCriteria)	DCOUNTA(Database; DatabaseField; SearchCriteria)
04060101.xhp par_id3153982 help.text	The example database table giving information about the guests invited to Joe’s birthday party (described above) should occupy cells A1:E10. The content of cells A12:E12 should be identical to the header labels for the database table in cells A1:E1. Make sure that cells A13:E13 are blank, except for cell D13 which should contain ">600" (this search criterion will match records in the database table that have a value greater than 600 in the Distance column).
04060101.xhp par_id61616368616093 help.text	Insert the formula <input>=DCOUNTA(A1:E10;; A12:E13)</input> into an empty cell elsewhere in the sheet to calculate how many of Joe’s party guests travel further than 600 meters to school. The value 5 is returned.
04060101.xhp par_id841616368623207 help.text	The same result is obtained if you use the formula <input>=DCOUNTA(A1:E10; "Distance"; A12:E13)</input> or the formula <input>=DCOUNTA(A1:E10; "Name"; A12:E13)</input>. The latter case reflects that in contrast to DCOUNT, DCOUNTA counts both numeric and alphanumeric values in the column indicated by the <emph>DatabaseField</emph> argument.
04060101.xhp bm_id3147256 help.text	<bookmark_value>DGET function</bookmark_value><bookmark_value>cell contents;searching in Calc databases</bookmark_value><bookmark_value>searching;cell contents in Calc databases</bookmark_value>
04060101.xhp hd_id3147256 help.text	DGET	DGET
04060101.xhp par_id3152801 help.text	<ahelp hid="HID_FUNC_DBAUSZUG">DGET returns the contents of the cell (field) of the specified column, for the single row (database record) that matches the specified search criteria.</ahelp>
04060101.xhp par_id171616180137385 help.text	Calc reports Err:502 (invalid argument) if multiple matches are found, or a #VALUE! error (wrong data type) if no matches are found. A #VALUE! error is also reported if a single match is found but the relevant cell is empty.
04060101.xhp par_id3154696 help.text	DGET(Database; DatabaseField; SearchCriteria)	DGET(Database; DatabaseField; SearchCriteria)
04060101.xhp par_id3155388 help.text	The example database table giving information about the guests invited to Joe’s birthday party (described above) should occupy cells A1:E10. The content of cells A12:E12 should be identical to the header labels for the database table in cells A1:E1. Make sure that cells A13:E13 are blank, except for cell C13 which should contain "11" (this search criterion will match records in the database table that have a value of 11 in the Age column).
04060101.xhp par_id3153096 help.text	Insert the formula <input>=DGET(A1:E10; "Name"; A12:E13)</input> into an empty cell elsewhere in the sheet to find the name of Joe’s party guest who is age 11. The name Daniel is returned.
04060101.xhp par_id3150524 help.text	If you change the value in cell C13 to “10”, then the formula <input>=DGET(A1:E10; "Name"; A12:E13)</input> returns an invalid argument error (Err:502). The reflects that multiple records match the specified criterion (both Betty and Charles are age 10).
04060101.xhp bm_id3149766 help.text	<bookmark_value>DMAX function</bookmark_value><bookmark_value>maximum values in Calc databases</bookmark_value><bookmark_value>searching;maximum values in columns</bookmark_value>
04060101.xhp hd_id3149766 help.text	DMAX	DMAX
04060101.xhp par_id3154903 help.text	<ahelp hid="HID_FUNC_DBMAX">DMAX calculates the maximum value across the cells (fields) of the specified column that contain numeric values, for all rows (database records) that match the specified search criteria.</ahelp> Blank cells or cells containing non-numeric characters are not included.
04060101.xhp par_id51616180409281 help.text	Returns 0 if no matches are found, or if there are no non-zero numeric values in the cells of the specified column for the matching records.
04060101.xhp par_id3159157 help.text	DMAX(Database; DatabaseField; SearchCriteria)	DMAX(Database; DatabaseField; SearchCriteria)
04060101.xhp par_id3148442 help.text	The example database table giving information about the guests invited to Joe’s birthday party (described above) should occupy cells A1:E10. The content of cells A12:E12 should be identical to the header labels for the database table in cells A1:E1. Make sure that cells A13:E13 are blank, except for cell D13 which should contain ">0" (this search criterion is intended to match all records in the database table).
04060101.xhp par_id3148804 help.text	Insert the formula <input>=DMAX(A1:E10; "Distance"; A12:E13)</input> into an empty cell elsewhere in the sheet to find the maximum distance in meters that any of Joe’s party guests travel to school. The value 1200 is returned.
04060101.xhp bm_id3159141 help.text	<bookmark_value>DMIN function</bookmark_value><bookmark_value>minimum values in Calc databases</bookmark_value><bookmark_value>searching;minimum values in columns</bookmark_value>
04060101.xhp hd_id3159141 help.text	DMIN	DMIN
04060101.xhp par_id3154261 help.text	<ahelp hid="HID_FUNC_DBMIN">DMIN calculates the minimum value across the cells (fields) of the specified column that contain numeric values, for all rows (database records) that match the specified search criteria.</ahelp> Blank cells or cells containing non-numeric characters are not included.
04060101.xhp par_id901616180605426 help.text	Returns 0 if no matches are found, or if there are no non-zero numeric values in the cells of the specified column for the matching records.
04060101.xhp par_id3148479 help.text	DMIN(Database; DatabaseField; SearchCriteria)	DMIN(Database; DatabaseField; SearchCriteria)

Loading…

None

String updated in the repository

English

Chinese (Traditional) 45 characters edited Current translation Translated

8 months ago

Browse all string changes

Things to check

Unchanged translation

Source and translation are identical

Reset

Glossary

English	Chinese (Traditional)
No related strings found in the glossary.

String information

Context

04060101.xhp
par_id3154696
help.text

Source string description

oFi8J

Source string location

04060101.xhp

String age

8 months ago

Last updated

8 months ago

Source string age

8 months ago

Translation file

zh-TW/helpcontent2/source/text/scalc/01.po, string 589