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/ca/units/?format=api&page=11
{ "count": 8439, "next": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/units/?format=api&page=12", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/units/?format=api&page=10", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?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": 111752758, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=aa9d867a3002562c", "url": "https://translations.documentfoundation.org/api/units/111752758/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:10.482694Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?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": [ "Una manera de definir un interval de cel·les, és introduir la referència de la cel·la superior esquerra seguida de dos punts (:) i, a continuació, la referència de cel·la inferior dreta. Un exemple podria ser A1: E10." ], "id_hash": 2971570413341076938, "content_hash": 2971570413341076938, "location": "04060101.xhp", "context": "04060101.xhp\npar_id521615889152497\nhelp.text", "note": "zpzi9", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "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": 111752763, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=a93d238c00416dca", "url": "https://translations.documentfoundation.org/api/units/111752763/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:10.484804Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?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": [ "L'argument <emph>Base de dades</emph> també es pot especificar passant el nom d'un interval amb nom o el rang d'una base de dades. L’ús d’un nom significatiu per definir un interval de cel·les pot millorar la llegibilitat de les fórmules i el manteniment dels documents. Si el nom no coincideix amb el nom d'un interval definit, Calc informa d'un error #NOM?." ], "id_hash": 3380758416767590307, "content_hash": 3380758416767590307, "location": "04060101.xhp", "context": "04060101.xhp\npar_id761615889163416\nhelp.text", "note": "WD55p", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "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": 111752770, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=aeeaddde36d81fa3", "url": "https://translations.documentfoundation.org/api/units/111752770/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:10.487164Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?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": [ "Altres errors que es podrien reportar a conseqüència d’un argument invàlid per a una <emph>Base de dades</emph> són #VALUE! i Err:504 (error a la llista de paràmetres)." ], "id_hash": 1142464629432627618, "content_hash": 1142464629432627618, "location": "04060101.xhp", "context": "04060101.xhp\npar_id601615889176137\nhelp.text", "note": "7L4XM", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "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": 111752777, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=8fdad98705c7b1a2", "url": "https://translations.documentfoundation.org/api/units/111752777/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:10.489723Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<emph>DatabaseField argument</emph>" ], "previous_source": "", "target": [ "<emph>argument DatabaseField</emph>" ], "id_hash": -1242531801510591990, "content_hash": -1242531801510591990, "location": "04060101.xhp", "context": "04060101.xhp\npar_id201615889390777\nhelp.text", "note": "rsj3e", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "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": 111752781, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=6ec1a3e8e4d5c20a", "url": "https://translations.documentfoundation.org/api/units/111752781/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:10.491770Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?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": [ "<emph>DatabaseField</emph> especifica la columna que utilitzarà la funció per als seus càlculs un cop aplicats els criteris de cerca i seleccionades les files de dades. No està relacionat amb els criteris de cerca." ], "id_hash": -725583538232430489, "content_hash": -725583538232430489, "location": "04060101.xhp", "context": "04060101.xhp\npar_id431615889426480\nhelp.text", "note": "7Eorp", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "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": 111752786, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=75ee359dc4c8f067", "url": "https://translations.documentfoundation.org/api/units/111752786/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:10.493664Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "Specify the <emph>DatabaseField</emph> argument in any of the following ways:" ], "previous_source": "", "target": [ "Especifica l'argument <emph>DatabaseField</emph> en qualsevol de les següents maneres:" ], "id_hash": 1408688388918389759, "content_hash": 1408688388918389759, "location": "04060101.xhp", "context": "04060101.xhp\npar_id661615889458032\nhelp.text", "note": "Z9Qfp", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "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": 111752791, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=938caaa04cb2abff", "url": "https://translations.documentfoundation.org/api/units/111752791/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:10.495884Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?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": [ "Introduint la referència a una cel·la de capçalera dins una àrea de <emph>Base de dades</emph>. Com a alternativa, si a la cel·la se li ha donat un nom significatiu com a interval amb nom o interval de base de dades, introduïu-lo. Si el nom no coincideix amb el nom d'un interval definit, Calc informa d'un error #NOM?. Si el nom és vàlid, però no correspon a una sola cel·la, Calc informa amb Err: 504 (error a la llista de paràmetres)." ], "id_hash": 5919490496530924238, "content_hash": 5919490496530924238, "location": "04060101.xhp", "context": "04060101.xhp\npar_id981615889517841\nhelp.text", "note": "RMwzE", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "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": 111752796, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=d226413e6906c2ce", "url": "https://translations.documentfoundation.org/api/units/111752796/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:10.498222Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?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": [ "Introduint un número per especificar la columna dins de l'àrea d'una <emph>Base de dades</emph>, començant amb 1. Per exemple, si una <emph>Base de dades</emph> ocupa el rang de cel·les D6:H123, aleshores poseu 3 per indicar la cel·la de capçalera F6. Calc espera un valor enter entre 1 i el nombre de columnes definit dins de la <emph>Base de dades</emph> i ignora els dígits després del punt decimal. Si el valor és menor que 1, Calc informa amb l'error Err:504 (error a la llista de paràmetres). Si el valor és superior al nombre de columnesa la <emph>Base de dades</emph>, Calc informa amb l'error #VALU.." ], "id_hash": 6301850524598392620, "content_hash": 6301850524598392620, "location": "04060101.xhp", "context": "04060101.xhp\npar_id551615889661457\nhelp.text", "note": "6EGoq", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "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": 111752805, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=d774aba9da4bd72c", "url": "https://translations.documentfoundation.org/api/units/111752805/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:10.502367Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?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": 111752811, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=24407d8a11223be8", "url": "https://translations.documentfoundation.org/api/units/111752811/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:10.505496Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?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": 111752817, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=b65912701530f170", "url": "https://translations.documentfoundation.org/api/units/111752817/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:10.507840Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?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": 111752824, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=22d89912930a006d", "url": "https://translations.documentfoundation.org/api/units/111752824/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:10.512968Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?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": 111752828, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=c41c74e3d48d47d3", "url": "https://translations.documentfoundation.org/api/units/111752828/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:10.514995Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?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": 111752832, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=3cb03027fabdb4c3", "url": "https://translations.documentfoundation.org/api/units/111752832/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:10.516731Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?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": 111752837, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=a7ee55b11b0db5d4", "url": "https://translations.documentfoundation.org/api/units/111752837/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:10.518295Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?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": 111752841, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=1bf8f2be0d583b6d", "url": "https://translations.documentfoundation.org/api/units/111752841/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:10.519742Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "Defining Search Criteria" ], "previous_source": "", "target": [ "Definició de criteris per a cercar" ], "id_hash": -2034915429092646211, "content_hash": -2034915429092646211, "location": "04060101.xhp", "context": "04060101.xhp\nhd_id481615892281210\nhelp.text", "note": "vj96q", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "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": 111752844, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=63c28732dcf8a2bd", "url": "https://translations.documentfoundation.org/api/units/111752844/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:10.521137Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?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": [ "El nombre de columnes ocupades per l'àrea <emph>SearchCriteria</emph> no ha de ser el mateix que l'amplada de l'àrea de la <emph>Base de dades</emph>. Tots els encapçalaments que apareixen a la primera fila de <emph>SearchCriteria</emph> han de ser idèntics als encapçalaments de la primera fila de la <emph>Base de dades</emph>. Tot i això, no tots els encapçalaments de la <emph>Base de dades</emph> necessiten aparèixer a la primera fila de la <emph> SearchCriteria </emph>, mentre que un encapçalament de <emph> Base de dades </emph> pot aparèixer diverses vegades a la primera fila del <emph>SearchCriteria</emph>." ], "id_hash": 1961310625488083016, "content_hash": 1961310625488083016, "location": "04060101.xhp", "context": "04060101.xhp\npar_id691615892329680\nhelp.text", "note": "zTQX5", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "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": 111752849, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=9b37f99f566a9848", "url": "https://translations.documentfoundation.org/api/units/111752849/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:10.522619Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?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": [ "Els criteris de cerca s'introdueixen a les cel·les de la segona i posteriors files de l'àrea <emph>SearchCriteria</emph>, a sota de la fila que conté els encapçalaments. Les cel·les en blanc de l'àrea <emph>SearchCriteria</emph> s'ignoren." ], "id_hash": 1891804170936273536, "content_hash": 1891804170936273536, "location": "04060101.xhp", "context": "04060101.xhp\npar_id541615892358897\nhelp.text", "note": "AeGHn", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "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": 111752854, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=9a4109dec9424a80", "url": "https://translations.documentfoundation.org/api/units/111752854/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:10.524516Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?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": 111752859, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=11e79f1708ed512d", "url": "https://translations.documentfoundation.org/api/units/111752859/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:10.526163Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?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": 111752864, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=791e438ac9c60f4f", "url": "https://translations.documentfoundation.org/api/units/111752864/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:10.527554Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?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": 111752868, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=6b92a31cdccdc487", "url": "https://translations.documentfoundation.org/api/units/111752868/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:10.529264Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?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": 111752873, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=490a89a43f85e736", "url": "https://translations.documentfoundation.org/api/units/111752873/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:10.531132Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?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": 111752877, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=5966b3773bce7a09", "url": "https://translations.documentfoundation.org/api/units/111752877/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:10.532991Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "Examples of Database Function Use" ], "previous_source": "", "target": [ "Exemples d'ús de les funcions de base de dades" ], "id_hash": 82263698742247016, "content_hash": 82263698742247016, "location": "04060101.xhp", "context": "04060101.xhp\nhd_id3150329\nhelp.text", "note": "4sbmh", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "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": 111752880, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=81244265ed70fe68", "url": "https://translations.documentfoundation.org/api/units/111752880/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:10.534982Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?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": 111752890, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=4c90e70681926306", "url": "https://translations.documentfoundation.org/api/units/111752890/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:10.553321Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<emph>Name</emph>" ], "previous_source": "", "target": [ "<emph>Nom</emph>" ], "id_hash": 2489576286236621176, "content_hash": 2489576286236621176, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3152992\nhelp.text", "note": "Y2HFt", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "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": 111752895, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=a28cc071265eb978", "url": "https://translations.documentfoundation.org/api/units/111752895/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:10.555685Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<emph>Grade</emph>" ], "previous_source": "", "target": [ "<emph>Grau</emph>" ], "id_hash": -6820550023249619522, "content_hash": -6820550023249619522, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3155532\nhelp.text", "note": "ChBDv", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "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": 111752908, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=215889e4036c95be", "url": "https://translations.documentfoundation.org/api/units/111752908/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:10.564874Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<emph>Age</emph>" ], "previous_source": "", "target": [ "<emph>Edat</emph>" ], "id_hash": -7493683945518605092, "content_hash": -7493683945518605092, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3156448\nhelp.text", "note": "mt5xM", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "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": 111752912, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=18011627a050dcdc", "url": "https://translations.documentfoundation.org/api/units/111752912/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:10.569814Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<emph>Distance</emph>" ], "previous_source": "", "target": [ "<emph>Distància</emph>" ], "id_hash": -5376794179463292024, "content_hash": -5376794179463292024, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3154486\nhelp.text", "note": "Svp8Q", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "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": 111752916, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=3561ca2e66b3db88", "url": "https://translations.documentfoundation.org/api/units/111752916/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:10.572232Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<emph>Weight</emph>" ], "previous_source": "", "target": [ "<emph>Pes</emph>" ], "id_hash": -7607628693707007851, "content_hash": -7607628693707007851, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3152899\nhelp.text", "note": "BShmH", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "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": 111752925, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=166c460290865895", "url": "https://translations.documentfoundation.org/api/units/111752925/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:10.579276Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "Andy" ], "previous_source": "", "target": [ "Abel" ], "id_hash": -4697024058665766079, "content_hash": -4697024058665766079, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3151240\nhelp.text", "note": "FUGeA", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "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": 111752930, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=3ed0d18129c37341", "url": "https://translations.documentfoundation.org/api/units/111752930/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:10.582246Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "Betty" ], "previous_source": "", "target": [ "Bàrbara" ], "id_hash": 8183219921110613641, "content_hash": 8183219921110613641, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3152870\nhelp.text", "note": "eQx2T", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "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": 111752940, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=f190a32964b2be89", "url": "https://translations.documentfoundation.org/api/units/111752940/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:10.589747Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "Charles" ], "previous_source": "", "target": [ "Cebrià" ], "id_hash": 5675380127604653403, "content_hash": 5675380127604653403, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3155596\nhelp.text", "note": "HKBAA", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "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": 111752950, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=cec30028172fbd5b", "url": "https://translations.documentfoundation.org/api/units/111752950/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:10.598690Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "Daniel" ], "previous_source": "", "target": [ "Damià" ], "id_hash": 5353091138760302245, "content_hash": 5353091138760302245, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3147296\nhelp.text", "note": "WCaYH", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "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": 111752953, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=ca4a000760195ea5", "url": "https://translations.documentfoundation.org/api/units/111752953/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:10.602658Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "Eva" ], "previous_source": "", "target": [ "Elisabet" ], "id_hash": -1326974050413721994, "content_hash": -1326974050413721994, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3150456\nhelp.text", "note": "L3gMx", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "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": 111752956, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=6d95a421baedc676", "url": "https://translations.documentfoundation.org/api/units/111752956/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:10.604882Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "Frank" ], "previous_source": "", "target": [ "Ferran" ], "id_hash": 3392015103864033513, "content_hash": 3392015103864033513, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3145826\nhelp.text", "note": "bwR2v", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "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": 111752959, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=af12dbc3ea9350e9", "url": "https://translations.documentfoundation.org/api/units/111752959/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:10.607114Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "Greta" ], "previous_source": "", "target": [ "Gemma" ], "id_hash": 2173543735952262568, "content_hash": 2173543735952262568, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3146137\nhelp.text", "note": "TwrgJ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "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": 111752961, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=9e29fa830d35c5a8", "url": "https://translations.documentfoundation.org/api/units/111752961/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:10.609247Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "Harry" ], "previous_source": "", "target": [ "Hel·ladi" ], "id_hash": -2523458783643405867, "content_hash": -2523458783643405867, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3153078\nhelp.text", "note": "TmomQ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "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": 111752972, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=5cfadf9b2b9871d5", "url": "https://translations.documentfoundation.org/api/units/111752972/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:10.614790Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "Irene" ], "previous_source": "", "target": [ "Imma" ], "id_hash": 4014037926274463887, "content_hash": 4014037926274463887, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3148761\nhelp.text", "note": "qBHps", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "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": 111752978, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=b7b4ba3a0688f88f", "url": "https://translations.documentfoundation.org/api/units/111752978/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:10.618346Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "The following six examples use the database table above, combined with different search criteria areas." ], "previous_source": "", "target": [ "Els sis exemples següents utilitzen la taula de base de dades anterior, en combinació amb diferents àrees de criteris de cerca." ], "id_hash": 2015398111079279618, "content_hash": 2015398111079279618, "location": "04060101.xhp", "context": "04060101.xhp\npar_id221616245476190\nhelp.text", "note": "UDuZW", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "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": 111752986, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=9bf821e76bdfac02", "url": "https://translations.documentfoundation.org/api/units/111752986/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:10.622473Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "Example 1" ], "previous_source": "", "target": [ "Exemple 1" ], "id_hash": -5234726468480303057, "content_hash": -5234726468480303057, "location": "04060101.xhp", "context": "04060101.xhp\nhd_id861616245631924\nhelp.text", "note": "sPtvb", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "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": 111752991, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=375a8402fde5802f", "url": "https://translations.documentfoundation.org/api/units/111752991/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:10.625603Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<emph>Name</emph>" ], "previous_source": "", "target": [ "<emph>Nom</emph>" ], "id_hash": -6059999396084010207, "content_hash": -6059999396084010207, "location": "04060101.xhp", "context": "04060101.xhp\npar_id891616245640933\nhelp.text", "note": "cEWAG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "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": 111752997, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=2be68ea81154b321", "url": "https://translations.documentfoundation.org/api/units/111752997/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:10.629095Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<emph>Grade</emph>" ], "previous_source": "", "target": [ "<emph>Grau</emph>" ], "id_hash": 3052647018479648550, "content_hash": 3052647018479648550, "location": "04060101.xhp", "context": "04060101.xhp\npar_id451616245640933\nhelp.text", "note": "AsoFd", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "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": 111753002, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=aa5d2e4a29227f26", "url": "https://translations.documentfoundation.org/api/units/111753002/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:10.634645Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<emph>Age</emph>" ], "previous_source": "", "target": [ "<emph>Edat</emph>" ], "id_hash": -6154905933995018010, "content_hash": -6154905933995018010, "location": "04060101.xhp", "context": "04060101.xhp\npar_id151616245818988\nhelp.text", "note": "Dw3a2", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "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": 111753004, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=2a9561a9c24878e6", "url": "https://translations.documentfoundation.org/api/units/111753004/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:10.636923Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<emph>Distance</emph>" ], "previous_source": "", "target": [ "<emph>Distància</emph>" ], "id_hash": 7894089805651260093, "content_hash": 7894089805651260093, "location": "04060101.xhp", "context": "04060101.xhp\npar_id481616245878460\nhelp.text", "note": "TdY66", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "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": 111753007, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=ed8d70da82e032bd", "url": "https://translations.documentfoundation.org/api/units/111753007/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:10.640882Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<emph>Weight</emph>" ], "previous_source": "", "target": [ "<emph>Pes</emph>" ], "id_hash": -6395470323821589166, "content_hash": -6395470323821589166, "location": "04060101.xhp", "context": "04060101.xhp\npar_id741616245891772\nhelp.text", "note": "ggUUj", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "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": 111753013, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=273eb9a0090fcd52", "url": "https://translations.documentfoundation.org/api/units/111753013/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:10.645942Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?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": 111753018, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=6090562ab389ca4e", "url": "https://translations.documentfoundation.org/api/units/111753018/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:10.648407Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?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": 111753024, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=7907b957a58a4e57", "url": "https://translations.documentfoundation.org/api/units/111753024/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:10.652055Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "Example 2" ], "previous_source": "", "target": [ "Exemple 2" ], "id_hash": 8586984018776430693, "content_hash": 8586984018776430693, "location": "04060101.xhp", "context": "04060101.xhp\nhd_id191616246773750\nhelp.text", "note": "VyrBb", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "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": 111753026, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=f72b187823201865", "url": "https://translations.documentfoundation.org/api/units/111753026/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:10.654038Z" } ] }