Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-24-2/textscalc01/hsb/units/?format=api&page=11
https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/units/?format=api&page=12", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/units/?format=api&page=10", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<emph>Database</emph> specifies the range of cells occupied by the database table. The first row of the range contains the field names, and subsequent rows are records with corresponding field values." ], "previous_source": "", "target": [ "" ], "id_hash": 3070758380286137900, "content_hash": 3070758380286137900, "location": "04060101.xhp", "context": "04060101.xhp\npar_id31615889105463\nhelp.text", "note": "fxMgf", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 501, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 30, "source_unit": "https://translations.documentfoundation.org/api/units/110925484/?format=api", "priority": 100, "id": 112352857, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=aa9d867a3002562c", "url": "https://translations.documentfoundation.org/api/units/112352857/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.117467Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "One way of defining the range of cells is to enter the cell reference for the upper left-hand cell, followed by a colon (:), and then the lower right-hand cell reference. An example might be A1:E10." ], "previous_source": "", "target": [ "" ], "id_hash": 2971570413341076938, "content_hash": 2971570413341076938, "location": "04060101.xhp", "context": "04060101.xhp\npar_id521615889152497\nhelp.text", "note": "zpzi9", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 502, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 36, "source_unit": "https://translations.documentfoundation.org/api/units/110925496/?format=api", "priority": 100, "id": 112352858, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=a93d238c00416dca", "url": "https://translations.documentfoundation.org/api/units/112352858/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.118616Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "The <emph>Database</emph> argument may also be specified by passing the name of a named range or database range. Using a meaningful name to define the cell range can enhance formula readability and document maintenance. If the name does not match the name of a defined range, Calc reports a #NAME? error." ], "previous_source": "", "target": [ "" ], "id_hash": 3380758416767590307, "content_hash": 3380758416767590307, "location": "04060101.xhp", "context": "04060101.xhp\npar_id761615889163416\nhelp.text", "note": "WD55p", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 503, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 51, "source_unit": "https://translations.documentfoundation.org/api/units/110925510/?format=api", "priority": 100, "id": 112352859, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=aeeaddde36d81fa3", "url": "https://translations.documentfoundation.org/api/units/112352859/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.119771Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "Other errors that might be reported as a result of an invalid <emph>Database</emph> argument are #VALUE! and Err:504 (error in parameter list)." ], "previous_source": "", "target": [ "" ], "id_hash": 1142464629432627618, "content_hash": 1142464629432627618, "location": "04060101.xhp", "context": "04060101.xhp\npar_id601615889176137\nhelp.text", "note": "7L4XM", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 504, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 22, "source_unit": "https://translations.documentfoundation.org/api/units/110925517/?format=api", "priority": 100, "id": 112352860, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=8fdad98705c7b1a2", "url": "https://translations.documentfoundation.org/api/units/112352860/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.120964Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<emph>DatabaseField argument</emph>" ], "previous_source": "", "target": [ "" ], "id_hash": -1242531801510591990, "content_hash": -1242531801510591990, "location": "04060101.xhp", "context": "04060101.xhp\npar_id201615889390777\nhelp.text", "note": "rsj3e", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 505, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/110925559/?format=api", "priority": 100, "id": 112352861, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=6ec1a3e8e4d5c20a", "url": "https://translations.documentfoundation.org/api/units/112352861/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.122098Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<emph>DatabaseField</emph> specifies the column which the function will use for its calculations after the search criteria have been applied and the data rows have been selected. It is not related to the search criteria." ], "previous_source": "", "target": [ "" ], "id_hash": -725583538232430489, "content_hash": -725583538232430489, "location": "04060101.xhp", "context": "04060101.xhp\npar_id431615889426480\nhelp.text", "note": "7Eorp", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 506, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 34, "source_unit": "https://translations.documentfoundation.org/api/units/110925576/?format=api", "priority": 100, "id": 112352862, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=75ee359dc4c8f067", "url": "https://translations.documentfoundation.org/api/units/112352862/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.123195Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "Specify the <emph>DatabaseField</emph> argument in any of the following ways:" ], "previous_source": "", "target": [ "" ], "id_hash": 1408688388918389759, "content_hash": 1408688388918389759, "location": "04060101.xhp", "context": "04060101.xhp\npar_id661615889458032\nhelp.text", "note": "Z9Qfp", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 507, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/110925577/?format=api", "priority": 100, "id": 112352863, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=938caaa04cb2abff", "url": "https://translations.documentfoundation.org/api/units/112352863/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.124370Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "By entering a reference to a header cell within the <emph>Database</emph> area. Alternatively, if the cell has been given a meaningful name as a named range or database range, enter that name. If the name does not match the name of a defined range, Calc reports a #NAME? error. If the name is valid but does not correspond to one cell only, Calc reports Err:504 (error in parameter list)." ], "previous_source": "", "target": [ "" ], "id_hash": 5919490496530924238, "content_hash": 5919490496530924238, "location": "04060101.xhp", "context": "04060101.xhp\npar_id981615889517841\nhelp.text", "note": "RMwzE", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 508, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 69, "source_unit": "https://translations.documentfoundation.org/api/units/110925606/?format=api", "priority": 100, "id": 112352864, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=d226413e6906c2ce", "url": "https://translations.documentfoundation.org/api/units/112352864/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.125705Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "By entering a number to specify the column within the <emph>Database</emph> area, starting with 1. For example, if a <emph>Database</emph> occupied the cell range D6:H123, then enter 3 to indicate the header cell at F6. Calc expects an integer value that lies between 1 and the number of columns defined within <emph>Database</emph> and ignores any digits after a decimal point. If the value is less than 1, Calc reports Err:504 (error in parameter list). If the value is greater than the number of columns in <emph>Database</emph>, Calc reports a #VALUE! error." ], "previous_source": "", "target": [ "" ], "id_hash": 6301850524598392620, "content_hash": 6301850524598392620, "location": "04060101.xhp", "context": "04060101.xhp\npar_id551615889661457\nhelp.text", "note": "6EGoq", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 509, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 91, "source_unit": "https://translations.documentfoundation.org/api/units/110925637/?format=api", "priority": 100, "id": 112352865, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=d774aba9da4bd72c", "url": "https://translations.documentfoundation.org/api/units/112352865/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.127275Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "By entering the literal column header name from the first row of the <emph>Database</emph> range, placing quotation marks around the header name. For example, “Distance to School”. If the string does not match one of the <emph>Database</emph> area’s column headings, Calc reports Err:504 (error in parameter list). You can also provide a reference to an arbitrary cell (not within the <emph>Database</emph> and <emph>SearchCriteria</emph> areas) that contains the required string." ], "previous_source": "", "target": [ "" ], "id_hash": -6611146221033473048, "content_hash": -6611146221033473048, "location": "04060101.xhp", "context": "04060101.xhp\npar_id561615889738472\nhelp.text", "note": "qSkvo", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 510, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 69, "source_unit": "https://translations.documentfoundation.org/api/units/110925685/?format=api", "priority": 100, "id": 112352866, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=24407d8a11223be8", "url": "https://translations.documentfoundation.org/api/units/112352866/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.128957Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "The <emph>DatabaseField</emph> argument is optional for the DCOUNT and DCOUNTA functions but it is required for the other ten Database functions." ], "previous_source": "", "target": [ "" ], "id_hash": 3916181623576523120, "content_hash": 3916181623576523120, "location": "04060101.xhp", "context": "04060101.xhp\npar_id181615889841279\nhelp.text", "note": "AUEy6", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 511, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://translations.documentfoundation.org/api/units/110925733/?format=api", "priority": 100, "id": 112352867, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=b65912701530f170", "url": "https://translations.documentfoundation.org/api/units/112352867/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.130554Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<emph>SearchCriteria argument</emph>" ], "previous_source": "", "target": [ "" ], "id_hash": -6712446939540357011, "content_hash": -6712446939540357011, "location": "04060101.xhp", "context": "04060101.xhp\npar_id841615891322513\nhelp.text", "note": "Af4va", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 512, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/110925761/?format=api", "priority": 100, "id": 112352868, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=22d89912930a006d", "url": "https://translations.documentfoundation.org/api/units/112352868/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.131931Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<emph>SearchCriteria</emph> specifies the range of cells containing search criteria. Like <emph>Database</emph>, its first row is also field names, and subsequent rows are conditions for related fields. The <emph>Database</emph> and <emph>SearchCriteria</emph> areas need not be adjacent, or even on the same sheet." ], "previous_source": "", "target": [ "" ], "id_hash": 4907926215799424979, "content_hash": 4907926215799424979, "location": "04060101.xhp", "context": "04060101.xhp\npar_id351615891337585\nhelp.text", "note": "9eBBv", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 513, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 41, "source_unit": "https://translations.documentfoundation.org/api/units/110925775/?format=api", "priority": 100, "id": 112352869, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=c41c74e3d48d47d3", "url": "https://translations.documentfoundation.org/api/units/112352869/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.133372Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "One way of defining the range of cells is to enter the cell reference for the upper left-hand cell, followed by a colon (:), and then the lower right-hand cell reference. For example, A13:B14. The cell range may also be specified by passing the name of a defined named range or database range. If the name does not match the name of a defined range, Calc reports a #NAME? error." ], "previous_source": "", "target": [ "" ], "id_hash": -4850323850409429821, "content_hash": -4850323850409429821, "location": "04060101.xhp", "context": "04060101.xhp\npar_id401615891342289\nhelp.text", "note": "iuFJF", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 514, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 70, "source_unit": "https://translations.documentfoundation.org/api/units/110925792/?format=api", "priority": 100, "id": 112352870, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=3cb03027fabdb4c3", "url": "https://translations.documentfoundation.org/api/units/112352870/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.134965Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "Err:504 (error in parameter list) may also be reported as a result of an invalid <emph>SearchCriteria</emph> argument." ], "previous_source": "", "target": [ "" ], "id_hash": 2877331431087781332, "content_hash": 2877331431087781332, "location": "04060101.xhp", "context": "04060101.xhp\npar_id861615891345281\nhelp.text", "note": "2BE4W", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 515, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 17, "source_unit": "https://translations.documentfoundation.org/api/units/110925805/?format=api", "priority": 100, "id": 112352871, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=a7ee55b11b0db5d4", "url": "https://translations.documentfoundation.org/api/units/112352871/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.136388Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "The contents of the <emph>SearchCriteria</emph> area are described in more detail in the next section." ], "previous_source": "", "target": [ "" ], "id_hash": -7207744305524884627, "content_hash": -7207744305524884627, "location": "04060101.xhp", "context": "04060101.xhp\npar_id901615891349688\nhelp.text", "note": "D6TBP", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 516, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/110925968/?format=api", "priority": 100, "id": 112352872, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=1bf8f2be0d583b6d", "url": "https://translations.documentfoundation.org/api/units/112352872/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.138166Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "Defining Search Criteria" ], "previous_source": "", "target": [ "" ], "id_hash": -2034915429092646211, "content_hash": -2034915429092646211, "location": "04060101.xhp", "context": "04060101.xhp\nhd_id481615892281210\nhelp.text", "note": "vj96q", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 517, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/110926158/?format=api", "priority": 100, "id": 112352873, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=63c28732dcf8a2bd", "url": "https://translations.documentfoundation.org/api/units/112352873/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.140117Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "The number of columns occupied by the <emph>SearchCriteria</emph> area need not be the same as the width of the <emph>Database</emph> area. All headings that appear in the first row of <emph>SearchCriteria</emph> must be identical to headings in the first row of <emph>Database</emph>. However, not all headings in <emph>Database</emph> need appear in the first row of <emph>SearchCriteria</emph>, while a heading in <emph>Database</emph> can appear multiple times in the first row of <emph>SearchCriteria</emph>." ], "previous_source": "", "target": [ "" ], "id_hash": 1961310625488083016, "content_hash": 1961310625488083016, "location": "04060101.xhp", "context": "04060101.xhp\npar_id691615892329680\nhelp.text", "note": "zTQX5", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 518, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 71, "source_unit": "https://translations.documentfoundation.org/api/units/110926159/?format=api", "priority": 100, "id": 112352874, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=9b37f99f566a9848", "url": "https://translations.documentfoundation.org/api/units/112352874/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.141754Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "Search criteria are entered into the cells of the second and subsequent rows of the <emph>SearchCriteria</emph> area, below the row containing headings. Blank cells within the <emph>SearchCriteria</emph> area are ignored." ], "previous_source": "", "target": [ "" ], "id_hash": 1891804170936273536, "content_hash": 1891804170936273536, "location": "04060101.xhp", "context": "04060101.xhp\npar_id541615892358897\nhelp.text", "note": "AeGHn", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 519, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 30, "source_unit": "https://translations.documentfoundation.org/api/units/110926160/?format=api", "priority": 100, "id": 112352875, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=9a4109dec9424a80", "url": "https://translations.documentfoundation.org/api/units/112352875/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.143468Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "Create criteria in the cells of the <emph>SearchCriteria</emph> area using the comparison operators <, <=, =, <>, >=, and >. = is assumed if a cell is not empty but does not start with a comparison operator." ], "previous_source": "", "target": [ "" ], "id_hash": -7933197297307004627, "content_hash": -7933197297307004627, "location": "04060101.xhp", "context": "04060101.xhp\npar_id151615892882441\nhelp.text", "note": "MddCQ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 520, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 37, "source_unit": "https://translations.documentfoundation.org/api/units/110926161/?format=api", "priority": 100, "id": 112352876, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=11e79f1708ed512d", "url": "https://translations.documentfoundation.org/api/units/112352876/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.144992Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "If you write several criteria in one row, they are connected by AND. If you write several criteria in different rows, they are connected by OR." ], "previous_source": "", "target": [ "" ], "id_hash": -495884645594427569, "content_hash": -495884645594427569, "location": "04060101.xhp", "context": "04060101.xhp\npar_id561615893059337\nhelp.text", "note": "4NDMd", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 521, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/110926162/?format=api", "priority": 100, "id": 112352877, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=791e438ac9c60f4f", "url": "https://translations.documentfoundation.org/api/units/112352877/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.146591Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "Criteria can be created using wildcards, providing that wildcards have been enabled via the <menuitem>Enable wildcards in formulas</menuitem> option on the <link href=\"text/shared/optionen/01060500.xhp\"><switchinline select=\"sys\"><caseinline select=\"MAC\"><menuitem>%PRODUCTNAME - Preferences</menuitem></caseinline><defaultinline><menuitem>Tools - Options</menuitem></defaultinline></switchinline><menuitem> - %PRODUCTNAME Calc - Calculate</menuitem></link> dialog. When interoperability with Microsoft Excel is important for your spreadsheet, this option should be enabled." ], "previous_source": "", "target": [ "" ], "id_hash": -1471934783837846393, "content_hash": -1471934783837846393, "location": "04060101.xhp", "context": "04060101.xhp\npar_id401615893095178\nhelp.text", "note": "7p3hk", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 522, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 50, "source_unit": "https://translations.documentfoundation.org/api/units/110926163/?format=api", "priority": 100, "id": 112352878, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=6b92a31cdccdc487", "url": "https://translations.documentfoundation.org/api/units/112352878/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.148196Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "Even more powerful criteria can be created using regular expressions, providing that regular expressions have been enabled via the <menuitem>Enable regular expressions in formulas</menuitem> option on the <link href=\"text/shared/optionen/01060500.xhp\"><switchinline select=\"sys\"><caseinline select=\"MAC\"><menuitem>%PRODUCTNAME - Preferences</menuitem></caseinline><defaultinline><menuitem>Tools - Options</menuitem></defaultinline></switchinline><menuitem> - %PRODUCTNAME Calc - Calculate</menuitem></link> dialog." ], "previous_source": "", "target": [ "" ], "id_hash": -3960201583785547978, "content_hash": -3960201583785547978, "location": "04060101.xhp", "context": "04060101.xhp\npar_id921615893158111\nhelp.text", "note": "HnAyF", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 523, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 41, "source_unit": "https://translations.documentfoundation.org/api/units/110926372/?format=api", "priority": 100, "id": 112352879, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=490a89a43f85e736", "url": "https://translations.documentfoundation.org/api/units/112352879/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.149903Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "Another setting that affects how the search criteria are handled is the <menuitem>Search criteria = and <> must apply to whole cells</menuitem> option on the <link href=\"text/shared/optionen/01060500.xhp\"><switchinline select=\"sys\"><caseinline select=\"MAC\"><menuitem>%PRODUCTNAME - Preferences</menuitem></caseinline><defaultinline><menuitem>Tools - Options</menuitem></defaultinline></switchinline><menuitem> - %PRODUCTNAME Calc - Calculate</menuitem></link> dialog. This option controls whether the search criteria you set for the Database functions must match the whole cell exactly. When interoperability with Microsoft Excel is important for your spreadsheet, this option should be enabled." ], "previous_source": "", "target": [ "" ], "id_hash": -2781338395168835063, "content_hash": -2781338395168835063, "location": "04060101.xhp", "context": "04060101.xhp\npar_id881615893236930\nhelp.text", "note": "8WGaA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 524, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 73, "source_unit": "https://translations.documentfoundation.org/api/units/110926373/?format=api", "priority": 100, "id": 112352880, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=5966b3773bce7a09", "url": "https://translations.documentfoundation.org/api/units/112352880/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.151464Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "Examples of Database Function Use" ], "previous_source": "", "target": [ "" ], "id_hash": 82263698742247016, "content_hash": 82263698742247016, "location": "04060101.xhp", "context": "04060101.xhp\nhd_id3150329\nhelp.text", "note": "4sbmh", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 525, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/110926374/?format=api", "priority": 100, "id": 112352881, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=81244265ed70fe68", "url": "https://translations.documentfoundation.org/api/units/112352881/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.152959Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "The following table provides an example database table that is utilized to demonstrate how to use the functions in the Database category. The cell range A1:E10 contains fictitious information about the guests invited to Joe's birthday party. The following information is given for each guest - name, school grade, age in years, distance to school in meters, and weight in kilograms." ], "previous_source": "", "target": [ "" ], "id_hash": -3706208478196243706, "content_hash": -3706208478196243706, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3153713\nhelp.text", "note": "hyFuY", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 526, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 61, "source_unit": "https://translations.documentfoundation.org/api/units/110926383/?format=api", "priority": 100, "id": 112352882, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=4c90e70681926306", "url": "https://translations.documentfoundation.org/api/units/112352882/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.154534Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<emph>Name</emph>" ], "previous_source": "", "target": [ "" ], "id_hash": 2489576286236621176, "content_hash": 2489576286236621176, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3152992\nhelp.text", "note": "Y2HFt", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 527, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110926431/?format=api", "priority": 100, "id": 112352883, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=a28cc071265eb978", "url": "https://translations.documentfoundation.org/api/units/112352883/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.156013Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<emph>Grade</emph>" ], "previous_source": "", "target": [ "" ], "id_hash": -6820550023249619522, "content_hash": -6820550023249619522, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3155532\nhelp.text", "note": "ChBDv", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 528, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110926477/?format=api", "priority": 100, "id": 112352884, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=215889e4036c95be", "url": "https://translations.documentfoundation.org/api/units/112352884/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.157303Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<emph>Age</emph>" ], "previous_source": "", "target": [ "" ], "id_hash": -7493683945518605092, "content_hash": -7493683945518605092, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3156448\nhelp.text", "note": "mt5xM", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 529, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110926525/?format=api", "priority": 100, "id": 112352885, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=18011627a050dcdc", "url": "https://translations.documentfoundation.org/api/units/112352885/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.158649Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<emph>Distance</emph>" ], "previous_source": "", "target": [ "" ], "id_hash": -5376794179463292024, "content_hash": -5376794179463292024, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3154486\nhelp.text", "note": "Svp8Q", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 530, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110926566/?format=api", "priority": 100, "id": 112352886, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=3561ca2e66b3db88", "url": "https://translations.documentfoundation.org/api/units/112352886/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.160019Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<emph>Weight</emph>" ], "previous_source": "", "target": [ "" ], "id_hash": -7607628693707007851, "content_hash": -7607628693707007851, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3152899\nhelp.text", "note": "BShmH", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 531, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110926599/?format=api", "priority": 100, "id": 112352887, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=166c460290865895", "url": "https://translations.documentfoundation.org/api/units/112352887/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.161375Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "Andy" ], "previous_source": "", "target": [ "" ], "id_hash": -4697024058665766079, "content_hash": -4697024058665766079, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3151240\nhelp.text", "note": "FUGeA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 532, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110926607/?format=api", "priority": 100, "id": 112352888, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=3ed0d18129c37341", "url": "https://translations.documentfoundation.org/api/units/112352888/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.162574Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "Betty" ], "previous_source": "", "target": [ "" ], "id_hash": 8183219921110613641, "content_hash": 8183219921110613641, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3152870\nhelp.text", "note": "eQx2T", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 533, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110926622/?format=api", "priority": 100, "id": 112352889, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=f190a32964b2be89", "url": "https://translations.documentfoundation.org/api/units/112352889/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.163591Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "Charles" ], "previous_source": "", "target": [ "" ], "id_hash": 5675380127604653403, "content_hash": 5675380127604653403, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3155596\nhelp.text", "note": "HKBAA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 534, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110926651/?format=api", "priority": 100, "id": 112352890, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=cec30028172fbd5b", "url": "https://translations.documentfoundation.org/api/units/112352890/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.165928Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "Daniel" ], "previous_source": "", "target": [ "" ], "id_hash": 5353091138760302245, "content_hash": 5353091138760302245, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3147296\nhelp.text", "note": "WCaYH", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 535, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110926687/?format=api", "priority": 100, "id": 112352891, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=ca4a000760195ea5", "url": "https://translations.documentfoundation.org/api/units/112352891/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.167945Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "Eva" ], "previous_source": "", "target": [ "" ], "id_hash": -1326974050413721994, "content_hash": -1326974050413721994, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3150456\nhelp.text", "note": "L3gMx", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 536, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110926719/?format=api", "priority": 100, "id": 112352892, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=6d95a421baedc676", "url": "https://translations.documentfoundation.org/api/units/112352892/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.169716Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "Frank" ], "previous_source": "", "target": [ "" ], "id_hash": 3392015103864033513, "content_hash": 3392015103864033513, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3145826\nhelp.text", "note": "bwR2v", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 537, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110926750/?format=api", "priority": 100, "id": 112352893, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=af12dbc3ea9350e9", "url": "https://translations.documentfoundation.org/api/units/112352893/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.172492Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "Greta" ], "previous_source": "", "target": [ "" ], "id_hash": 2173543735952262568, "content_hash": 2173543735952262568, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3146137\nhelp.text", "note": "TwrgJ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 538, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110926787/?format=api", "priority": 100, "id": 112352894, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=9e29fa830d35c5a8", "url": "https://translations.documentfoundation.org/api/units/112352894/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.174717Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "Harry" ], "previous_source": "", "target": [ "" ], "id_hash": -2523458783643405867, "content_hash": -2523458783643405867, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3153078\nhelp.text", "note": "TmomQ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 539, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110926835/?format=api", "priority": 100, "id": 112352895, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=5cfadf9b2b9871d5", "url": "https://translations.documentfoundation.org/api/units/112352895/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.176753Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "Irene" ], "previous_source": "", "target": [ "" ], "id_hash": 4014037926274463887, "content_hash": 4014037926274463887, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3148761\nhelp.text", "note": "qBHps", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 540, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110926872/?format=api", "priority": 100, "id": 112352896, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=b7b4ba3a0688f88f", "url": "https://translations.documentfoundation.org/api/units/112352896/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.178686Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "The following six examples use the database table above, combined with different search criteria areas." ], "previous_source": "", "target": [ "" ], "id_hash": 2015398111079279618, "content_hash": 2015398111079279618, "location": "04060101.xhp", "context": "04060101.xhp\npar_id221616245476190\nhelp.text", "note": "UDuZW", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 541, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/110926905/?format=api", "priority": 100, "id": 112352897, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=9bf821e76bdfac02", "url": "https://translations.documentfoundation.org/api/units/112352897/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.180941Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "Example 1" ], "previous_source": "", "target": [ "" ], "id_hash": -5234726468480303057, "content_hash": -5234726468480303057, "location": "04060101.xhp", "context": "04060101.xhp\nhd_id861616245631924\nhelp.text", "note": "sPtvb", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 542, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/110926938/?format=api", "priority": 100, "id": 112352898, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=375a8402fde5802f", "url": "https://translations.documentfoundation.org/api/units/112352898/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.182977Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<emph>Name</emph>" ], "previous_source": "", "target": [ "" ], "id_hash": -6059999396084010207, "content_hash": -6059999396084010207, "location": "04060101.xhp", "context": "04060101.xhp\npar_id891616245640933\nhelp.text", "note": "cEWAG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 543, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110926983/?format=api", "priority": 100, "id": 112352899, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=2be68ea81154b321", "url": "https://translations.documentfoundation.org/api/units/112352899/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.184478Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<emph>Grade</emph>" ], "previous_source": "", "target": [ "" ], "id_hash": 3052647018479648550, "content_hash": 3052647018479648550, "location": "04060101.xhp", "context": "04060101.xhp\npar_id451616245640933\nhelp.text", "note": "AsoFd", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 544, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110927021/?format=api", "priority": 100, "id": 112352900, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=aa5d2e4a29227f26", "url": "https://translations.documentfoundation.org/api/units/112352900/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.185693Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<emph>Age</emph>" ], "previous_source": "", "target": [ "" ], "id_hash": -6154905933995018010, "content_hash": -6154905933995018010, "location": "04060101.xhp", "context": "04060101.xhp\npar_id151616245818988\nhelp.text", "note": "Dw3a2", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 545, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110927056/?format=api", "priority": 100, "id": 112352901, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=2a9561a9c24878e6", "url": "https://translations.documentfoundation.org/api/units/112352901/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.187206Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<emph>Distance</emph>" ], "previous_source": "", "target": [ "" ], "id_hash": 7894089805651260093, "content_hash": 7894089805651260093, "location": "04060101.xhp", "context": "04060101.xhp\npar_id481616245878460\nhelp.text", "note": "TdY66", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 546, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110927091/?format=api", "priority": 100, "id": 112352902, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=ed8d70da82e032bd", "url": "https://translations.documentfoundation.org/api/units/112352902/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.188635Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<emph>Weight</emph>" ], "previous_source": "", "target": [ "" ], "id_hash": -6395470323821589166, "content_hash": -6395470323821589166, "location": "04060101.xhp", "context": "04060101.xhp\npar_id741616245891772\nhelp.text", "note": "ggUUj", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 547, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110927128/?format=api", "priority": 100, "id": 112352903, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=273eb9a0090fcd52", "url": "https://translations.documentfoundation.org/api/units/112352903/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.189769Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "As in this simple example, it is sometimes desirable (but not essential) to place the search criteria area directly under the database table, with the columns of the two areas vertically aligned. Blank entries in the search criteria area are ignored. With the above example database table and this search criteria area, insert the formula <item type=\"input\">=DCOUNT(A1:E10;;A12:E14)</item> into an empty cell elsewhere in the sheet to count how many of Joe’s guests travel further than 600 meters to school. The value 5 is returned (counting Betty, Daniel, Eva, Harry, and Irene)." ], "previous_source": "", "target": [ "" ], "id_hash": -2265215871166592434, "content_hash": -2265215871166592434, "location": "04060101.xhp", "context": "04060101.xhp\npar_id451616246535763\nhelp.text", "note": "4SkNQ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 548, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 91, "source_unit": "https://translations.documentfoundation.org/api/units/110927165/?format=api", "priority": 100, "id": 112352904, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=6090562ab389ca4e", "url": "https://translations.documentfoundation.org/api/units/112352904/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.190875Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "Note also that the formula <item type=\"input\">=DCOUNT(A1:E10;;D12:D13)</item> returns exactly the same value, demonstrating that it is only necessary for the search criteria area to contain relevant column headings." ], "previous_source": "", "target": [ "" ], "id_hash": -502229047337922985, "content_hash": -502229047337922985, "location": "04060101.xhp", "context": "04060101.xhp\npar_id731616246561901\nhelp.text", "note": "bBHFr", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 549, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 28, "source_unit": "https://translations.documentfoundation.org/api/units/110927219/?format=api", "priority": 100, "id": 112352905, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=7907b957a58a4e57", "url": "https://translations.documentfoundation.org/api/units/112352905/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.192551Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "Example 2" ], "previous_source": "", "target": [ "" ], "id_hash": 8586984018776430693, "content_hash": 8586984018776430693, "location": "04060101.xhp", "context": "04060101.xhp\nhd_id191616246773750\nhelp.text", "note": "VyrBb", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 550, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/110927262/?format=api", "priority": 100, "id": 112352906, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=f72b187823201865", "url": "https://translations.documentfoundation.org/api/units/112352906/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:17.194201Z" } ] }{ "count": 8439, "next": "