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=40
{ "count": 8439, "next": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/units/?format=api&page=41", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/units/?format=api&page=39", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "Statistics Functions" ], "previous_source": "", "target": [ "Funcions estadístiques" ], "id_hash": -5897051907943278782, "content_hash": -5897051907943278782, "location": "04060108.xhp", "context": "04060108.xhp\ntit\nhelp.text", "note": "p4YTh", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1951, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/110974474/?format=api", "priority": 100, "id": 111760200, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=2e2976889d005742", "url": "https://translations.documentfoundation.org/api/units/111760200/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.606871Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<bookmark_value>statistics functions</bookmark_value><bookmark_value>Function Wizard; statistics</bookmark_value><bookmark_value>functions; statistics functions</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>funcions estadístiques</bookmark_value><bookmark_value>Auxiliar de funcions; estadístiques</bookmark_value><bookmark_value>funcions; funcions estadístiques</bookmark_value>" ], "id_hash": 5755265143273233381, "content_hash": 5755265143273233381, "location": "04060108.xhp", "context": "04060108.xhp\nbm_id3153018\nhelp.text", "note": "xJyMy", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1952, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/110974508/?format=api", "priority": 100, "id": 111760205, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=cfdecf27b4fd1be5", "url": "https://translations.documentfoundation.org/api/units/111760205/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.609395Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<variable id=\"head_statistic\"><link href=\"text/scalc/01/04060108.xhp\">Statistics Functions</link></variable>" ], "previous_source": "", "target": [ "<variable id=\"head_statistic\"><link href=\"text/scalc/01/04060108.xhp\">Funcions estadístiques</link></variable>" ], "id_hash": -3653679829312444946, "content_hash": -3653679829312444946, "location": "04060108.xhp", "context": "04060108.xhp\nhd_id3153018\nhelp.text", "note": "EcgjZ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1953, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/110974546/?format=api", "priority": 100, "id": 111760210, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=4d4b858da2d265ee", "url": "https://translations.documentfoundation.org/api/units/111760210/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.614599Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<variable id=\"statistiktext\">This category contains the <emph>Statistics</emph> functions.</variable>" ], "previous_source": "", "target": [ "<unk>GA Aquesta categoria conté les funcions <emph>Statistics</emph>.</variable>" ], "id_hash": -5309534091528974620, "content_hash": -5309534091528974620, "location": "04060108.xhp", "context": "04060108.xhp\npar_id3157874\nhelp.text", "note": "M7Z6D", "flags": "", "labels": [], "state": 10, "fuzzy": true, "translated": false, "approved": false, "position": 1954, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/110974599/?format=api", "priority": 100, "id": 111760215, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=3650bedff796cee4", "url": "https://translations.documentfoundation.org/api/units/111760215/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.618204Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "Some of the examples use the following data table:" ], "previous_source": "", "target": [ "Alguns dels exemples utilitzen la taula de dades següent:" ], "id_hash": 3110882082655944344, "content_hash": 3110882082655944344, "location": "04060108.xhp", "context": "04060108.xhp\npar_id3149001\nhelp.text", "note": "HiTED", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1955, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/110974650/?format=api", "priority": 100, "id": 111760219, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=ab2c12c5a2d5be98", "url": "https://translations.documentfoundation.org/api/units/111760219/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.622767Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "x value" ], "previous_source": "", "target": [ "valor x" ], "id_hash": 267449268429799975, "content_hash": 267449268429799975, "location": "04060108.xhp", "context": "04060108.xhp\npar_id3153551\nhelp.text", "note": "PeXDp", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1956, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/110974681/?format=api", "priority": 100, "id": 111760221, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=83b62bb150324227", "url": "https://translations.documentfoundation.org/api/units/111760221/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.625045Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "y value" ], "previous_source": "", "target": [ "valor y" ], "id_hash": -3967827592908545360, "content_hash": -3967827592908545360, "location": "04060108.xhp", "context": "04060108.xhp\npar_id3147536\nhelp.text", "note": "b9ACz", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1957, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/110974709/?format=api", "priority": 100, "id": 111760226, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=48ef71d3a2b162b0", "url": "https://translations.documentfoundation.org/api/units/111760226/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.627017Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "The statistical functions are described in the following subsections." ], "previous_source": "", "target": [ "Les funcions estadístiques es descriuen en les subseccions següents:" ], "id_hash": 7708999778292664413, "content_hash": 7708999778292664413, "location": "04060108.xhp", "context": "04060108.xhp\npar_id3156324\nhelp.text", "note": "BbE8F", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1958, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/110974741/?format=api", "priority": 100, "id": 111760230, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=eafbde744eb3085d", "url": "https://translations.documentfoundation.org/api/units/111760230/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.628782Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "Spreadsheet Functions" ], "previous_source": "", "target": [ "Funcions del full de càlcul" ], "id_hash": -2966132965479816684, "content_hash": -2966132965479816684, "location": "04060109.xhp", "context": "04060109.xhp\ntit\nhelp.text", "note": "gREzE", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1959, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/110974784/?format=api", "priority": 100, "id": 111760235, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=56d62dc87bffe214", "url": "https://translations.documentfoundation.org/api/units/111760235/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.630831Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<bookmark_value>spreadsheets; functions</bookmark_value> <bookmark_value>Function Wizard; spreadsheets</bookmark_value> <bookmark_value>functions; spreadsheets</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>fulls de càlcul; funcions</bookmark_value><bookmark_value>Auxiliar de funcions; fulls de càlcul</bookmark_value><bookmark_value>funcions; fulls de càlcul</bookmark_value>" ], "id_hash": -2889756523113244871, "content_hash": -2889756523113244871, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id3148522\nhelp.text", "note": "WoHfE", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1960, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/110974812/?format=api", "priority": 100, "id": 111760240, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=57e585c0b8779739", "url": "https://translations.documentfoundation.org/api/units/111760240/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.633227Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "Spreadsheet Functions" ], "previous_source": "", "target": [ "Funcions del full de càlcul" ], "id_hash": 7024016505950538733, "content_hash": 7024016505950538733, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3148522\nhelp.text", "note": "qcCTY", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1961, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/110974856/?format=api", "priority": 100, "id": 111760246, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=e17a51cc1da98bed", "url": "https://translations.documentfoundation.org/api/units/111760246/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.635038Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<variable id=\"tabelletext\">This section contains descriptions of the <emph>Spreadsheet</emph> functions together with an example.</variable>" ], "previous_source": "", "target": [ "<variable id=\"tabelletext\">Aquesta secció conté descripcions de les funcions del <emph>full de càlcul</emph> i en mostra exemples.</variable>" ], "id_hash": 2783587935049714885, "content_hash": 2783587935049714885, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3144508\nhelp.text", "note": "BceQk", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1962, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/110974880/?format=api", "priority": 100, "id": 111760255, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=a6a14a7a95b38cc5", "url": "https://translations.documentfoundation.org/api/units/111760255/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.639537Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<bookmark_value>ADDRESS function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>funció ADREÇA</bookmark_value>" ], "id_hash": -4598909094892086070, "content_hash": -4598909094892086070, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id3146968\nhelp.text", "note": "aoGD9", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1963, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/110974915/?format=api", "priority": 100, "id": 111760261, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=402d648b54a4dcca", "url": "https://translations.documentfoundation.org/api/units/111760261/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.642719Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "ADDRESS" ], "previous_source": "", "target": [ "ADREÇA" ], "id_hash": 2684530464677923973, "content_hash": 2684530464677923973, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3146968\nhelp.text", "note": "YWzqF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1964, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110974962/?format=api", "priority": 100, "id": 111760267, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=a5415e3bffd78c85", "url": "https://translations.documentfoundation.org/api/units/111760267/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.645246Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_ADRESSE\">Returns a cell address (reference) as text, according to the specified row and column numbers.</ahelp> You can determine whether the address is interpreted as an absolute address (for example, $A$1) or as a relative address (as A1) or in a mixed form (A$1 or $A1). You can also specify the name of the sheet." ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_ADRESSE\">Retorna una adreça de cel·la (referència) en forma de text en funció dels nombres de fila i de columna especificats.</ahelp> Podeu determinar si l'adreça s'ha d'interpretar com a adreça absoluta (per exemple, $A$1), com a adreça relativa (per exemple, A1) o en forma mixta (A$1 o $A1). També podeu indicar el nom del full." ], "id_hash": -6346032754747434559, "content_hash": -6346032754747434559, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3155762\nhelp.text", "note": "EDZCM", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1965, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 55, "source_unit": "https://translations.documentfoundation.org/api/units/110974979/?format=api", "priority": 100, "id": 111760270, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=27ee5cd5104919c1", "url": "https://translations.documentfoundation.org/api/units/111760270/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.647282Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "For interoperability the ADDRESS and INDIRECT functions support an optional parameter to specify whether the R1C1 address notation instead of the usual A1 notation should be used." ], "previous_source": "", "target": [ "Per motius d'interoperativitat, les funcions ADREÇA i INDIRECTE admeten un paràmetre opcional per a indicar si s'ha d'utilitzar la notació d'adreça R1C1 en lloc de la notació A1 habitual." ], "id_hash": 6500763140005585231, "content_hash": 6500763140005585231, "location": "04060109.xhp", "context": "04060109.xhp\npar_id1027200802301348\nhelp.text", "note": "hrEcs", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1966, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 27, "source_unit": "https://translations.documentfoundation.org/api/units/110975004/?format=api", "priority": 100, "id": 111760275, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=da3759a220fc614f", "url": "https://translations.documentfoundation.org/api/units/111760275/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.649386Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "In ADDRESS, the parameter is inserted as the fourth parameter, shifting the optional sheet name parameter to the fifth position." ], "previous_source": "", "target": [ "A ADREÇA, el paràmetre s'insereix com a quart paràmetre, de manera que el paràmetre de nom de full opcional es desplaça a la cinquena posició." ], "id_hash": -911371874454514455, "content_hash": -911371874454514455, "location": "04060109.xhp", "context": "04060109.xhp\npar_id1027200802301445\nhelp.text", "note": "JJpSk", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1967, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/110975033/?format=api", "priority": 100, "id": 111760281, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=735a281bdcdb54e9", "url": "https://translations.documentfoundation.org/api/units/111760281/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.652066Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "In INDIRECT, the parameter is appended as the second parameter." ], "previous_source": "", "target": [ "A INDIRECTE, el paràmetre s'afegeix com a segon paràmetre." ], "id_hash": -4950075489879108756, "content_hash": -4950075489879108756, "location": "04060109.xhp", "context": "04060109.xhp\npar_id102720080230153\nhelp.text", "note": "qFesv", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1968, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/110975059/?format=api", "priority": 100, "id": 111760285, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=3b4dcc918e63536c", "url": "https://translations.documentfoundation.org/api/units/111760285/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.654027Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "In both functions, if the argument is inserted with the value 0, then the R1C1 notation is used. If the argument is not given or has a value other than 0, then the A1 notation is used." ], "previous_source": "", "target": [ "En totes dues funcions, si l'argument s'insereix amb el valor 0 s'utilitza la notació R1C1. Si no es dona l'argument o si aquest té un valor que no sigui 0, s'utilitza la notació A1." ], "id_hash": -2075736064795905404, "content_hash": -2075736064795905404, "location": "04060109.xhp", "context": "04060109.xhp\npar_id102720080230151\nhelp.text", "note": "gvGjb", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1969, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 37, "source_unit": "https://translations.documentfoundation.org/api/units/110975079/?format=api", "priority": 100, "id": 111760289, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=6331810bfa5f7284", "url": "https://translations.documentfoundation.org/api/units/111760289/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.655845Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "In case of R1C1 notation, ADDRESS returns address strings using the exclamation mark '!' as the sheet name separator, and INDIRECT expects the exclamation mark as sheet name separator. Both functions still use the dot '.' sheet name separator with A1 notation." ], "previous_source": "", "target": [ "En el cas de la notació R1C1, ADREÇA retorna cadenes d'adreça amb el signe d'exclamació '!' com a separador per als noms del full, i INDIRECTE espera el signe d'exclamació com a separador per als noms del full. Totes dues funcions utilitzen el punt '.' com a separador per als noms del full amb la notació A1." ], "id_hash": 1709027029175537816, "content_hash": 1709027029175537816, "location": "04060109.xhp", "context": "04060109.xhp\npar_id1027200802301556\nhelp.text", "note": "S5Du7", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1970, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 42, "source_unit": "https://translations.documentfoundation.org/api/units/110975105/?format=api", "priority": 100, "id": 111760294, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=97b7af07398c9098", "url": "https://translations.documentfoundation.org/api/units/111760294/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.657926Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "When opening documents from ODF 1.0/1.1 format, the ADDRESS functions that show a sheet name as the fourth parameter will shift that sheet name to become the fifth parameter. A new fourth parameter with the value 1 will be inserted." ], "previous_source": "", "target": [ "Si obriu documents amb format ODF 1.0/1.1, les funcions ADREÇA que mostren un nom de full com a quart paràmetre desplaçaran aquest nom de full per tal que esdevingui el cinquè paràmetre, i inseriran un nou quart paràmetre amb el valor 1." ], "id_hash": -1059518466302375336, "content_hash": -1059518466302375336, "location": "04060109.xhp", "context": "04060109.xhp\npar_id1027200802301521\nhelp.text", "note": "tBvLY", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1971, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 40, "source_unit": "https://translations.documentfoundation.org/api/units/110975132/?format=api", "priority": 100, "id": 111760299, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=714bd59187148a58", "url": "https://translations.documentfoundation.org/api/units/111760299/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.660199Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "When storing a document in ODF 1.0/1.1 format, if ADDRESS functions have a fourth parameter, that parameter will be removed." ], "previous_source": "", "target": [ "Si deseu un document en format ODF 1.0/1.1, en cas que les funcions ADREÇA tinguin un quart paràmetre, el suprimiran." ], "id_hash": -8055874548874886449, "content_hash": -8055874548874886449, "location": "04060109.xhp", "context": "04060109.xhp\npar_id1027200802301650\nhelp.text", "note": "NGGAw", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1972, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/110975154/?format=api", "priority": 100, "id": 111760307, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=1033c8c79733c2cf", "url": "https://translations.documentfoundation.org/api/units/111760307/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.662867Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "Do not save a spreadsheet in the old ODF 1.0/1.1 format if the ADDRESS function's new fourth parameter was used with a value of 0." ], "previous_source": "", "target": [ "No deseu el full de càlcul en l'antic format ODF 1.0/1.1 si el nou quart paràmetre de la funció ADREÇA s'ha utilitzat amb valor 0." ], "id_hash": 8115260084259178319, "content_hash": 8115260084259178319, "location": "04060109.xhp", "context": "04060109.xhp\npar_id102720080230162\nhelp.text", "note": "Ag8KD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1973, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 25, "source_unit": "https://translations.documentfoundation.org/api/units/110975178/?format=api", "priority": 100, "id": 111760316, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=f09f320cd62cc74f", "url": "https://translations.documentfoundation.org/api/units/111760316/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.667055Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "The INDIRECT function is saved without conversion to ODF 1.0/1.1 format. If the second parameter was present, an older version of Calc will return an error for that function." ], "previous_source": "", "target": [ "La funció INDIRECTE es desa sense fer la conversió al format ODF 1.0/1.1. Si hi ha un segon paràmetre, les versions antigues del Calc retornaran un error per a aquesta funció." ], "id_hash": 3590831610914499776, "content_hash": 3590831610914499776, "location": "04060109.xhp", "context": "04060109.xhp\npar_id1027200802301756\nhelp.text", "note": "d2kpf", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1974, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/110975212/?format=api", "priority": 100, "id": 111760320, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=b1d5325338cd6cc0", "url": "https://translations.documentfoundation.org/api/units/111760320/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.669184Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "ADDRESS(Row; Column [; Abs [; A1 [; \"Sheet\"]]])" ], "previous_source": "", "target": [ "ADREÇA(Fila; Columna [; Abs [; A1 [; \"Full\"]]])" ], "id_hash": 987991828813510454, "content_hash": 987991828813510454, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3154707\nhelp.text", "note": "TgFFT", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1975, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/110975710/?format=api", "priority": 100, "id": 111760326, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=8db60d556d6af736", "url": "https://translations.documentfoundation.org/api/units/111760326/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.673956Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<emph>Row</emph> represents the row number for the cell reference" ], "previous_source": "", "target": [ "<emph>Fila</emph> representa el número de fila de la referència de cel·la." ], "id_hash": 5088181695370283547, "content_hash": 5088181695370283547, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3147505\nhelp.text", "note": "FyoLc", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1976, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/110975749/?format=api", "priority": 100, "id": 111760330, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=c69cda4b2930ca1b", "url": "https://translations.documentfoundation.org/api/units/111760330/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.676221Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<emph>Column</emph> represents the column number for the cell reference (the number, not the letter)" ], "previous_source": "", "target": [ "<emph>Columna</emph> representa el número de columna de la referència de cel·la (el número, no la lletra)." ], "id_hash": -6237596525700379609, "content_hash": -6237596525700379609, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3145323\nhelp.text", "note": "AEorU", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1977, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/110975788/?format=api", "priority": 100, "id": 111760335, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=296f9b02116b0c27", "url": "https://translations.documentfoundation.org/api/units/111760335/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.678797Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<emph>Abs</emph> determines the type of reference:" ], "previous_source": "", "target": [ "<emph>Abs</emph> determina el tipus de referència:" ], "id_hash": 8889697732632519959, "content_hash": 8889697732632519959, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3153074\nhelp.text", "note": "8VYFW", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1978, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/110975832/?format=api", "priority": 100, "id": 111760340, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=fb5e8cfcfa282517", "url": "https://translations.documentfoundation.org/api/units/111760340/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.681508Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "1: absolute ($A$1)" ], "previous_source": "", "target": [ "1: absoluta ($A$1)" ], "id_hash": 4950740850650695570, "content_hash": 4950740850650695570, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3153298\nhelp.text", "note": "EEfQf", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1979, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/110975881/?format=api", "priority": 100, "id": 111760344, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=c4b49092d20cc792", "url": "https://translations.documentfoundation.org/api/units/111760344/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.684154Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "2: row reference type is absolute; column reference is relative (A$1)" ], "previous_source": "", "target": [ "2: el tipus de referència de la fila és absolut; la referència de la columna és relativa (A$1)" ], "id_hash": -8926242809178159723, "content_hash": -8926242809178159723, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3150431\nhelp.text", "note": "jNcJG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1980, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/110975882/?format=api", "priority": 100, "id": 111760350, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=041f9d75540d0595", "url": "https://translations.documentfoundation.org/api/units/111760350/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.686754Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "3: row (relative); column (absolute) ($A1)" ], "previous_source": "", "target": [ "3: fila (relativa); columna (absoluta) ($A1)" ], "id_hash": 9140721639584882894, "content_hash": 9140721639584882894, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3146096\nhelp.text", "note": "KXVHa", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1981, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/110975883/?format=api", "priority": 100, "id": 111760355, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=feda5de6ce2ee0ce", "url": "https://translations.documentfoundation.org/api/units/111760355/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.689059Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "4: relative (A1)" ], "previous_source": "", "target": [ "4: relativa (A1)" ], "id_hash": -8521629544004173645, "content_hash": -8521629544004173645, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3153334\nhelp.text", "note": "AeGMD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1982, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/110975936/?format=api", "priority": 100, "id": 111760358, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=09bd17144a2840b3", "url": "https://translations.documentfoundation.org/api/units/111760358/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.691129Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<emph>A1</emph> (optional) - if set to 0, the R1C1 notation is used. If this parameter is absent or set to another value than 0, the A1 notation is used." ], "previous_source": "", "target": [ "<emph>A1</emph> (opcional): si s'estableix a 0, s'utilitzarà la notació R1C1. Si el paràmetre no existeix o si s'ha establert a un valor que no sigui 0, s'utilitzarà la notació A1." ], "id_hash": -7379494026329237918, "content_hash": -7379494026329237918, "location": "04060109.xhp", "context": "04060109.xhp\npar_id1027200802465915\nhelp.text", "note": "3BFnh", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1983, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/110975977/?format=api", "priority": 100, "id": 111760362, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=1996c54802875662", "url": "https://translations.documentfoundation.org/api/units/111760362/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.693136Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<emph>Sheet</emph> represents the name of the sheet. It must be placed in double quotes." ], "previous_source": "", "target": [ "<emph>Full</emph> representa el nom del full. Cal col·locar-lo entre cometes dobles." ], "id_hash": -8090009019137561493, "content_hash": -8090009019137561493, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3153962\nhelp.text", "note": "R2QXf", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1984, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/110976059/?format=api", "priority": 100, "id": 111760368, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=0fba83a8e8996c6b", "url": "https://translations.documentfoundation.org/api/units/111760368/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.695450Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "Example:" ], "previous_source": "", "target": [ "Exemple:" ], "id_hash": 6158664688613790099, "content_hash": 6158664688613790099, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3147299\nhelp.text", "note": "3eSyo", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1985, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110976065/?format=api", "priority": 100, "id": 111760372, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=d577f8e77f911193", "url": "https://translations.documentfoundation.org/api/units/111760372/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.697771Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<item type=\"input\">=ADDRESS(1;1;2;;\"Sheet2\")</item> returns the following: Sheet2.A$1" ], "previous_source": "", "target": [ "<item type=\"input\">=ADREÇA(1;1;2;\"Full2\")</item> retorna: Full2.A$1" ], "id_hash": 8915481783737849529, "content_hash": 8915481783737849529, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3148744\nhelp.text", "note": "oCjxy", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1986, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/110976091/?format=api", "priority": 100, "id": 111760376, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=fbba2772312916b9", "url": "https://translations.documentfoundation.org/api/units/111760376/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.699751Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "If the formula above is in cell B2 of current sheet, and the cell A1 in sheet 2 contains the value <item type=\"input\">-6</item>, you can refer indirectly to the referenced cell using a function in B2 by entering <item type=\"input\">=ABS(INDIRECT(B2))</item>. The result is the absolute value of the cell reference specified in B2, which in this case is 6." ], "previous_source": "", "target": [ "Si la fórmula anterior és a la cel·la B2 del full actual i la cel·la A1 del full 2 conté el valor <item type=\"input\">-6</item> podeu referir-vos indirectament a la cel·la referenciada utilitzant una funció a B2 introduint <item type=\"input\">=ABS(INDIRECT(B2))</item>. El resultat és el valor absolut de la referència de la cel·la especificada a B2 que en aquest cas és 6." ], "id_hash": -6990483334965291855, "content_hash": -6990483334965291855, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3159260\nhelp.text", "note": "zEj2o", "flags": "", "labels": [], "state": 10, "fuzzy": true, "translated": false, "approved": false, "position": 1987, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 59, "source_unit": "https://translations.documentfoundation.org/api/units/110976146/?format=api", "priority": 100, "id": 111760382, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=1efcd071ab1b14b1", "url": "https://translations.documentfoundation.org/api/units/111760382/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.702363Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<bookmark_value>AREAS function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>funció AREES</bookmark_value>" ], "id_hash": 7072070132031450786, "content_hash": 7072070132031450786, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id3150372\nhelp.text", "note": "n7RGj", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1988, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/110976236/?format=api", "priority": 100, "id": 111760391, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=e2250a50ce626ea2", "url": "https://translations.documentfoundation.org/api/units/111760391/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.705502Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "AREAS" ], "previous_source": "", "target": [ "AREES" ], "id_hash": -2873436012796235041, "content_hash": -2873436012796235041, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3150372\nhelp.text", "note": "BmNK5", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1989, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110976263/?format=api", "priority": 100, "id": 111760395, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=581f812ba47732df", "url": "https://translations.documentfoundation.org/api/units/111760395/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.707551Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_BEREICHE\">Returns the number of individual ranges that belong to a multiple range.</ahelp> A range can consist of contiguous cells or a single cell." ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_BEREICHE\">Retorna el nombre d'intervals individuals que pertanyen a un interval múltiple.</ahelp> Un interval pot estar format per cel·les contigües o per una sola cel·la." ], "id_hash": -2296054605787946059, "content_hash": -2296054605787946059, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3150036\nhelp.text", "note": "Bi6yp", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1990, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://translations.documentfoundation.org/api/units/110976314/?format=api", "priority": 100, "id": 111760397, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=6022c680451c23b5", "url": "https://translations.documentfoundation.org/api/units/111760397/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.709431Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "The function expects a single argument. If you state multiple ranges, you must enclose them into additional parentheses. Multiple ranges can be entered using the semicolon (;) as divider, but this gets automatically converted to the tilde (~) operator. The tilde is used to join ranges." ], "previous_source": "", "target": [ "La funció espera un sol argument. Si definiu diversos intervals, els heu de posar entre parèntesis addicionals. Es poden introduir diversos intervals utilitzant el punt i coma (;) com a divisor, però es converteix automàticament en l'operador de titlla (~). La titlla s'utilitza per unir intervals." ], "id_hash": 8788259985831439169, "content_hash": 8788259985831439169, "location": "04060109.xhp", "context": "04060109.xhp\npar_id061020090307073\nhelp.text", "note": "cvDFN", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1991, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 46, "source_unit": "https://translations.documentfoundation.org/api/units/110976366/?format=api", "priority": 100, "id": 111760401, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=f9f62be519432b41", "url": "https://translations.documentfoundation.org/api/units/111760401/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.711470Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "AREAS(Reference)" ], "previous_source": "", "target": [ "AREES(Referència)" ], "id_hash": -4011799632394081583, "content_hash": -4011799632394081583, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3155907\nhelp.text", "note": "Tg8WA", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1992, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110976401/?format=api", "priority": 100, "id": 111760407, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=4853397d611baad1", "url": "https://translations.documentfoundation.org/api/units/111760407/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.714560Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "Reference represents the reference to a cell or cell range." ], "previous_source": "", "target": [ "Referència representa la referència a la cel·la o a un interval de cel·les." ], "id_hash": -8385337005647716684, "content_hash": -8385337005647716684, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3153118\nhelp.text", "note": "fJLtE", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1993, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/110976416/?format=api", "priority": 100, "id": 111760412, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=0ba14c6bb86e1eb4", "url": "https://translations.documentfoundation.org/api/units/111760412/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.716923Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<item type=\"input\">=AREAS((A1:B3;F2;G1))</item> returns 3, as it is a reference to three cells and/or areas. After entry this gets converted to =AREAS((A1:B3~F2~G1))." ], "previous_source": "", "target": [ "<item type=\"input\">=AREES((A1:B3;F2;G1))</item> retorna 3, ja que és una referència a tres cel·les i/o àrees. Després de l'entrada, es converteix en =AREES((A1:B3~F2~G1))." ], "id_hash": -1615880179506973561, "content_hash": -1615880179506973561, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3149946\nhelp.text", "note": "K5zS8", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1994, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://translations.documentfoundation.org/api/units/110976435/?format=api", "priority": 100, "id": 111760417, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=69933d89bce47487", "url": "https://translations.documentfoundation.org/api/units/111760417/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.718837Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<item type=\"input\">=AREAS(All)</item> returns 1 if you have defined an area named All under <emph>Data - Define Range</emph>." ], "previous_source": "", "target": [ "<item type=\"input\">=AREES(Totes)</item> retorna 1 si heu definit una àrea anomenada Totes a <emph>Dades ▸ Defineix l'interval</emph>." ], "id_hash": 1472854209275403689, "content_hash": 1472854209275403689, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3146820\nhelp.text", "note": "sh5wD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1995, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 17, "source_unit": "https://translations.documentfoundation.org/api/units/110976510/?format=api", "priority": 100, "id": 111760423, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=9470a1198dcc9da9", "url": "https://translations.documentfoundation.org/api/units/111760423/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.721070Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<bookmark_value>DDE function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>funció DDE</bookmark_value>" ], "id_hash": 7941482527970087483, "content_hash": 7941482527970087483, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id3148727\nhelp.text", "note": "mUP2a", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1996, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/110976609/?format=api", "priority": 100, "id": 111760430, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=ee35d0488da0d23b", "url": "https://translations.documentfoundation.org/api/units/111760430/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.723860Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "DDE" ], "previous_source": "", "target": [ "DDE" ], "id_hash": -6084178397908938716, "content_hash": -6084178397908938716, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3148727\nhelp.text", "note": "AMXUq", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1997, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110976651/?format=api", "priority": 100, "id": 111760437, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=2b90a7fb82885024", "url": "https://translations.documentfoundation.org/api/units/111760437/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.725963Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_DDE\">Returns the result of a DDE-based link.</ahelp> If the contents of the linked range or section changes, the returned value will also change. You must reload the spreadsheet or choose <emph>Edit - Links</emph> to see the updated links. Cross-platform links, for example from a <item type=\"productname\">%PRODUCTNAME</item> installation running on a Windows machine to a document created on a Linux machine, are not allowed." ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_DDE\">Retorna el resultat d'un enllaç basat en DDE.</ahelp> Si els continguts de la secció o de l'interval enllaçat canvien, el valor retornat també canviarà. Per veure els enllaços actualitzats, actualitzeu el full de càlcul o trieu <emph>Edita ▸ Enllaços</emph>. No es permeten els enllaços multiplataforma (per exemple, des d'una instal·lació del <item type=\"productname\">%PRODUCTNAME</item> que s'executi en un ordinador amb el Windows a un document creat en un ordinador amb el Linux)." ], "id_hash": -3672875923859036273, "content_hash": -3672875923859036273, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3149434\nhelp.text", "note": "2FAG7", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1998, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 64, "source_unit": "https://translations.documentfoundation.org/api/units/110976679/?format=api", "priority": 100, "id": 111760440, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=4d0752ce964c278f", "url": "https://translations.documentfoundation.org/api/units/111760440/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.727978Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "DDE(\"Server\"; \"File\"; \"Range\" [; Mode])" ], "previous_source": "", "target": [ "DDE(\"Server\"; \"File\"; \"Range\" [; Mode])" ], "id_hash": 6958039810471576071, "content_hash": 6958039810471576071, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3148886\nhelp.text", "note": "JBRdm", "flags": "", "labels": [], "state": 10, "fuzzy": true, "translated": false, "approved": false, "position": 1999, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/110976716/?format=api", "priority": 100, "id": 111760445, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=e08fec57a42f4207", "url": "https://translations.documentfoundation.org/api/units/111760445/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.730766Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<emph>Server</emph> is the name of a server application. <item type=\"productname\">%PRODUCTNAME</item> applications have the server name \"soffice\"." ], "previous_source": "", "target": [ "<emph>Servidor</emph> és el nom d'una aplicació de servidor. En el cas de les aplicacions del <item type=\"productname\">%PRODUCTNAME</item>, el nom de servidor és «soffice»." ], "id_hash": -5937338882859885522, "content_hash": -5937338882859885522, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3154842\nhelp.text", "note": "qAN6x", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2000, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/110976744/?format=api", "priority": 100, "id": 111760447, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=2d9a55be50059c2e", "url": "https://translations.documentfoundation.org/api/units/111760447/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.732650Z" } ] }