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=43
{ "count": 8439, "next": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/units/?format=api&page=44", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/units/?format=api&page=42", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<item type=\"input\">=MATCH(200;D1:D100)</item> searches the area D1:D100, which is sorted by column D, for the value 200. As soon as this value is reached, the number of the row in which it was found is returned. If a higher value is found during the search in the column, the number of the previous row is returned." ], "previous_source": "", "target": [ "<item type=\"input\">=COINCIDEIX(200;D1:D100)</item> cerca el valor 200 en l'àrea D1:D100, que s'ha ordenat per la columna D. Tan bon punt es troba aquest valor, es retorna el nombre de la fila on s'ha trobat. Si es troba un valor més gran durant la cerca a la columna, es retorna el nombre de la fila anterior." ], "id_hash": -8348883544228323497, "content_hash": -8348883544228323497, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3155343\nhelp.text", "note": "eFMjk", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2101, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 55, "source_unit": "https://translations.documentfoundation.org/api/units/110981025/?format=api", "priority": 100, "id": 111760941, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=0c22cea69b2a9f57", "url": "https://translations.documentfoundation.org/api/units/111760941/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:17.000908Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<bookmark_value>OFFSET function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>funció DESPLAÇAMENT</bookmark_value>" ], "id_hash": -3038312647783775519, "content_hash": -3038312647783775519, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id3158430\nhelp.text", "note": "JqPAK", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2102, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/110981086/?format=api", "priority": 100, "id": 111760946, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=55d5bebe984582e1", "url": "https://translations.documentfoundation.org/api/units/111760946/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:17.003589Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "OFFSET" ], "previous_source": "", "target": [ "DESPLAÇAMENT" ], "id_hash": 4884207378341721603, "content_hash": 4884207378341721603, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3158430\nhelp.text", "note": "MwiPA", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2103, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110981127/?format=api", "priority": 100, "id": 111760949, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=c3c830bba3667603", "url": "https://translations.documentfoundation.org/api/units/111760949/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:17.007649Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_VERSCHIEBUNG\">Returns the value of a cell offset by a certain number of rows and columns from a given reference point.</ahelp>" ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_VERSCHIEBUNG\">Retorna el valor d'un desplaçament de cel·la d'un nombre determinat de files i columnes a partir d'un punt de referència indicat.</ahelp>" ], "id_hash": -7919841624111631330, "content_hash": -7919841624111631330, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3149167\nhelp.text", "note": "tSGCC", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2104, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://translations.documentfoundation.org/api/units/110981145/?format=api", "priority": 100, "id": 111760952, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=121712010579341e", "url": "https://translations.documentfoundation.org/api/units/111760952/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:17.009272Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "OFFSET(Reference; Rows; Columns [; Height [; Width]])" ], "previous_source": "", "target": [ "DESPLAÇAMENT(Referència; Files; Columnes [; Alçada [; Amplada]])" ], "id_hash": -6274711237888482790, "content_hash": -6274711237888482790, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3159194\nhelp.text", "note": "nED4F", "flags": "", "labels": [], "state": 10, "fuzzy": true, "translated": false, "approved": false, "position": 2105, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/110981162/?format=api", "priority": 100, "id": 111760958, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=28ebbf5fbd81621a", "url": "https://translations.documentfoundation.org/api/units/111760958/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:17.012079Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<emph>Reference</emph> is the reference from which the function searches for the new reference." ], "previous_source": "", "target": [ "<emph>Referència</emph> és la referència a partir de la qual la funció cerca la referència nova." ], "id_hash": -3109094795117095836, "content_hash": -3109094795117095836, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3152360\nhelp.text", "note": "3Q5gL", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2106, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/110981168/?format=api", "priority": 100, "id": 111760964, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=54da46c1ac079464", "url": "https://translations.documentfoundation.org/api/units/111760964/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:17.014815Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<emph>Rows</emph> is the number of rows by which the reference was corrected up (negative value) or down. Use 0 to stay in the same row." ], "previous_source": "", "target": [ "<emph>Files</emph> és el nombre de files amb què s'ha corregit la referència cap amunt (valor negatiu) o cap avall." ], "id_hash": -7759693311848095052, "content_hash": -7759693311848095052, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3156032\nhelp.text", "note": "Q5SeM", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2107, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 25, "source_unit": "https://translations.documentfoundation.org/api/units/110981169/?format=api", "priority": 100, "id": 111760970, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=1450080ba551e2b4", "url": "https://translations.documentfoundation.org/api/units/111760970/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:17.017405Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<emph>Columns</emph> is the number of columns by which the reference was corrected to the left (negative value) or to the right. Use 0 to stay in the same column" ], "previous_source": "", "target": [ "<emph>Files</emph> és el nombre de files amb què s'ha corregit la referència cap amunt (valor negatiu) o cap avall." ], "id_hash": -2855369498407954685, "content_hash": -2855369498407954685, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3166458\nhelp.text", "note": "CEqaQ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2108, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/110981207/?format=api", "priority": 100, "id": 111760975, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=585fb091d0e89703", "url": "https://translations.documentfoundation.org/api/units/111760975/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:17.019809Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<emph>Height</emph> (optional) is the vertical height for an area that starts at the new reference position." ], "previous_source": "", "target": [ "<emph>Alçada</emph> (opcional) és l'alçada vertical d'una àrea que comença en la posició de referència nova." ], "id_hash": -6370777246515822578, "content_hash": -6370777246515822578, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3150708\nhelp.text", "note": "K2dos", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2109, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/110981252/?format=api", "priority": 100, "id": 111760980, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=279673d91e48800e", "url": "https://translations.documentfoundation.org/api/units/111760980/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:17.128618Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<emph>Width</emph> (optional) is the horizontal width for an area that starts at the new reference position." ], "previous_source": "", "target": [ "<emph>Amplada</emph> (opcional) és l'amplada horitzontal d'una àrea que comença en la nova posició de referència." ], "id_hash": 6677511436333980503, "content_hash": 6677511436333980503, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3147278\nhelp.text", "note": "NEDfS", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2110, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/110981270/?format=api", "priority": 100, "id": 111760986, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=dcab4945ba4b9b57", "url": "https://translations.documentfoundation.org/api/units/111760986/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:17.133315Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "Arguments <emph>Rows</emph> and <emph>Columns</emph> must not lead to zero or negative start row or column." ], "previous_source": "", "target": [ "Els arguments <emph>Files</emph> i <emph>Columnes</emph> no han de conduir a zero o a un inici negatiu de fila o de columna." ], "id_hash": 3258256735597929644, "content_hash": 3258256735597929644, "location": "04060109.xhp", "context": "04060109.xhp\npar_id8662373\nhelp.text", "note": "uQEQG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2111, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/110981348/?format=api", "priority": 100, "id": 111761004, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=ad37a73cf056a4ac", "url": "https://translations.documentfoundation.org/api/units/111761004/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:17.146281Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "Arguments <emph>Height</emph> and <emph>Width</emph> must not lead to zero or negative count of rows or columns." ], "previous_source": "", "target": [ "Els arguments <emph>Alçada</emph> i <emph>Amplada</emph> no han de conduir a zero o a un comptatge negatiu de files o de columnes." ], "id_hash": 4191163419148031225, "content_hash": 4191163419148031225, "location": "04060109.xhp", "context": "04060109.xhp\npar_id9051484\nhelp.text", "note": "cuFvq", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2112, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/110981374/?format=api", "priority": 100, "id": 111761012, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=ba2a00ec89ee14f9", "url": "https://translations.documentfoundation.org/api/units/111761012/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:17.152708Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<item type=\"input\">=OFFSET(A1;2;2)</item> returns the value in cell C3 (A1 moved by two rows and two columns down). If C3 contains the value <item type=\"input\">100</item> this function returns the value 100." ], "previous_source": "", "target": [ "<item type=\"input\">=DESPLAÇAMENT(A1;2;2)</item> retorna el valor de la cel·la C3 (A1 desplaçada dues files i dues columnes cap avall). Si C3 conté el valor <item type=\"input\">100</item>, la funció retorna el valor 100." ], "id_hash": -2369817467347873031, "content_hash": -2369817467347873031, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3149744\nhelp.text", "note": "cUGMh", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2113, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 30, "source_unit": "https://translations.documentfoundation.org/api/units/110981416/?format=api", "priority": 100, "id": 111761016, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=5f1cb791bc36d2f9", "url": "https://translations.documentfoundation.org/api/units/111761016/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:17.155839Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<item type=\"input\">=OFFSET(B2:C3;1;1)</item> returns a reference to B2:C3 moved down by 1 row and one column to the right (C3:D4)." ], "previous_source": "", "target": [ "<item type=\"input\">=DESPLAÇAMENT(B2:C3;1;1)</item> retorna una referència a B2:C3 desplaçada 1 fila i 1 columna cap a la dreta (C3:D4)." ], "id_hash": -742657699281128448, "content_hash": -742657699281128448, "location": "04060109.xhp", "context": "04060109.xhp\npar_id7439802\nhelp.text", "note": "pZtbS", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2114, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/110981448/?format=api", "priority": 100, "id": 111761023, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=75b18cc1dca3b400", "url": "https://translations.documentfoundation.org/api/units/111761023/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:17.158937Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<item type=\"input\">=OFFSET(B2:C3;-1;-1)</item> returns a reference to B2:C3 moved up by 1 row and one column to the left (A1:B2)." ], "previous_source": "", "target": [ "<item type=\"input\">=DESPLAÇAMENT(B2:C3;-1;-1)</item> retorna una referència a B2:C3 desplaçada una fila cap amunt i una columna cap a l'esquerra (A1:B2)." ], "id_hash": 3535053803764573335, "content_hash": 3535053803764573335, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3009430\nhelp.text", "note": "QQGzq", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2115, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/110981463/?format=api", "priority": 100, "id": 111761031, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=b10f08b47b47e497", "url": "https://translations.documentfoundation.org/api/units/111761031/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:17.163186Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<item type=\"input\">=OFFSET(B2:C3;0;0;3;4)</item> returns a reference to B2:C3 resized to 3 rows and 4 columns (B2:E4)." ], "previous_source": "", "target": [ "<item type=\"input\">=DESPLAÇAMENT(B2:C3;0;0;3;4)</item> retorna una referència cap a l'interval B2:C3 redimensionada a 3 files i 4 columnes (B2:E4)." ], "id_hash": 5510456478988959992, "content_hash": 5510456478988959992, "location": "04060109.xhp", "context": "04060109.xhp\npar_id2629169\nhelp.text", "note": "ZngJG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2116, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/110981473/?format=api", "priority": 100, "id": 111761037, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=cc7912f8d46300f8", "url": "https://translations.documentfoundation.org/api/units/111761037/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:17.166001Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<item type=\"input\">=OFFSET(B2:C3;1;0;3;4)</item> returns a reference to B2:C3 moved down by one row resized to 3 rows and 4 columns (B3:E5)." ], "previous_source": "", "target": [ "<item type=\"input\">=DESPLAÇAMENT(B2:C3;1;0;3;4)</item> retorna una referència a B2:C3 desplaçada una fila redimensionada en 3 files i 4 columnes (B3:E5)." ], "id_hash": 1923255265426347232, "content_hash": 1923255265426347232, "location": "04060109.xhp", "context": "04060109.xhp\npar_id6668599\nhelp.text", "note": "4XD3D", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2117, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/110981488/?format=api", "priority": 100, "id": 111761041, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=9ab0c6795c2314e0", "url": "https://translations.documentfoundation.org/api/units/111761041/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:17.168435Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<item type=\"input\">=SUM(OFFSET(A1;2;2;5;6))</item> determines the total of the area that starts in cell C3 and has a height of 5 rows and a width of 6 columns (area=C3:H7)." ], "previous_source": "", "target": [ "<item type=\"input\">=SUMA(DESPLAÇAMENT(A1;2;2;5;6))</item> determina el total de l'àrea que comença a la cel·la C3, i que té una alçada de 5 files i una amplada de 6 columnes (àrea=C3:H7)." ], "id_hash": -7553978692711600114, "content_hash": -7553978692711600114, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3153739\nhelp.text", "note": "jpz9q", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2118, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 27, "source_unit": "https://translations.documentfoundation.org/api/units/110981511/?format=api", "priority": 100, "id": 111761047, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=172ae066d40e300e", "url": "https://translations.documentfoundation.org/api/units/111761047/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:17.170917Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "If <emph>Width</emph> or <emph>Height</emph> are given, the OFFSET function returns a cell range reference. If <emph>Reference</emph> is a single cell reference and both <emph>Width</emph> and <emph>Height</emph> are omitted, a single cell reference is returned." ], "previous_source": "", "target": [ "Si s'hi especifiquen l'<emph>Amplada</emph> o l'<emph>Alçada</emph>, la funció DESPLAÇAMENT retorna una referència a un interval de cel·les. Si <emph>Referència</emph> és una referència a una única cel·la y s'ometen tant <emph>Amplada</emph> com <emph>Alçada</emph>, es retorna una referència a una única cel·la." ], "id_hash": -7194728458143845642, "content_hash": -7194728458143845642, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3153740\nhelp.text", "note": "VCAvt", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2119, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 34, "source_unit": "https://translations.documentfoundation.org/api/units/110981542/?format=api", "priority": 100, "id": 111761056, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=1c2730962cf132f6", "url": "https://translations.documentfoundation.org/api/units/111761056/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:17.175941Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<bookmark_value>LOOKUP function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>funció CONSULTA</bookmark_value>" ], "id_hash": 7361603316006066001, "content_hash": 7361603316006066001, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id3159273\nhelp.text", "note": "AFMxC", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2120, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/110981612/?format=api", "priority": 100, "id": 111761076, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=e629ab3663e11751", "url": "https://translations.documentfoundation.org/api/units/111761076/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:17.179178Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "LOOKUP" ], "previous_source": "", "target": [ "CONSULTA" ], "id_hash": 8655066154759884947, "content_hash": 8655066154759884947, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3159273\nhelp.text", "note": "MPjM8", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2121, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110981646/?format=api", "priority": 100, "id": 111761082, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=f81cf8cfadf81093", "url": "https://translations.documentfoundation.org/api/units/111761082/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:17.190297Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_VERWEIS\">Returns the contents of a cell either from a one-row or one-column range.</ahelp> Optionally, the assigned value (of the same index) is returned in a different column and row. As opposed to <link href=\"text/scalc/01/04060109.xhp#Section9\">VLOOKUP</link> and <link href=\"text/scalc/01/04060109.xhp#Section17\">HLOOKUP</link>, search and result vector may be at different positions; they do not have to be adjacent. Additionally, the search vector for the LOOKUP must be sorted ascending, otherwise the search will not return any usable results." ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_VERWEIS\">Retorna els continguts d'una cel·la, ja sigui d'un interval d'una fila o d'una columna.</ahelp> Opcionalment, es retorna el valor assignat (del mateix índex) en una columna i una fila diferent. Contràriament a <link href=\"text/scalc/01/04060109.xhp#Section9\">CONSULTAV</link> i a <link href=\"text/scalc/01/04060109.xhp#Section17\">CONSULTAH</link>, el vector de cerca i el resultant es poden trobar en posicions diferents; no cal que siguin adjacents. A més, el vector de cerca de la funció CONSULTA ha d'estar ordenat de manera ascendent; si no ho està, la cerca no retornarà cap resultat utilitzable." ], "id_hash": 1649568430919950969, "content_hash": 1649568430919950969, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3153389\nhelp.text", "note": "WYT2e", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2122, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 74, "source_unit": "https://translations.documentfoundation.org/api/units/110981689/?format=api", "priority": 100, "id": 111761088, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=96e471bf85aea279", "url": "https://translations.documentfoundation.org/api/units/111761088/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:17.192577Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "If LOOKUP cannot find the search criterion, it matches the largest value in the search vector that is less than or equal to the search criterion." ], "previous_source": "", "target": [ "Si CONSULTA no pot trobar el criteri de cerca, coincideix amb el valor més gran del vector de cerca que sigui més petit o igual que el criteri de cerca." ], "id_hash": -3061392892454013596, "content_hash": -3061392892454013596, "location": "04060109.xhp", "context": "04060109.xhp\npar_id4484084\nhelp.text", "note": "3jevg", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2123, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/110981714/?format=api", "priority": 100, "id": 111761097, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=5583bf625f5f7564", "url": "https://translations.documentfoundation.org/api/units/111761097/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:17.198610Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "LOOKUP(Lookup; SearchVector [; ResultVector])" ], "previous_source": "", "target": [ "" ], "id_hash": -8386330871162544930, "content_hash": -8386330871162544930, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3154104\nhelp.text", "note": "sLcHB", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2124, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/110981741/?format=api", "priority": 100, "id": 111761102, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=0b9dc4815f76dcde", "url": "https://translations.documentfoundation.org/api/units/111761102/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:17.200424Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<emph>Lookup</emph> is the value of any type to be looked for; entered either directly or as a reference." ], "previous_source": "", "target": [ "" ], "id_hash": 7237691220109810230, "content_hash": 7237691220109810230, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3150646\nhelp.text", "note": "yGLLE", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2125, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/110981783/?format=api", "priority": 100, "id": 111761106, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=e47171d1589bda36", "url": "https://translations.documentfoundation.org/api/units/111761106/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:17.201833Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<emph>SearchVector</emph> is the single-row or single-column area to be searched." ], "previous_source": "", "target": [ "<emph>VectorDeCerca</emph> és l'àrea d'una fila o d'una columna que s'ha de cercar." ], "id_hash": 5289312777227322, "content_hash": 5289312777227322, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3154854\nhelp.text", "note": "tFDBC", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2126, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/110981836/?format=api", "priority": 100, "id": 111761108, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=8012ca9a19314c3a", "url": "https://translations.documentfoundation.org/api/units/111761108/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:17.203481Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<emph>ResultVector</emph> is another single-row or single-column range from which the result of the function is taken. The result is the cell of the result vector with the same index as the instance found in the search vector." ], "previous_source": "", "target": [ "<emph>VectorResultant</emph> és un altre interval d'una sola fila o d'una sola columna d'on s'extreu el resultat de la funció. El resultat és la cel·la del vector resultant amb el mateix índex que la instància trobada en el vector de cerca." ], "id_hash": -3957940721512948347, "content_hash": -3957940721512948347, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3149925\nhelp.text", "note": "zdXML", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2127, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 37, "source_unit": "https://translations.documentfoundation.org/api/units/110981862/?format=api", "priority": 100, "id": 111761113, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=491291e2442add85", "url": "https://translations.documentfoundation.org/api/units/111761113/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:17.205578Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<item type=\"input\">=LOOKUP(A1;D1:D100;F1:F100)</item> searches the corresponding cell in range D1:D100 for the number you entered in A1. For the instance found, the index is determined, for example, the 12th cell in this range. Then, the contents of the 12th cell are returned as the value of the function (in the result vector)." ], "previous_source": "", "target": [ "<item type=\"input\">=CONSULTA(A1;D1:D100;F1:F100)</item> cerca la cel·la corresponent de l'interval D1:D100 per al nombre que heu introduït a A1. Es determina l'índex de la instància que s'ha trobat; per exemple, la 12a cel·la de l'interval. Tot seguit, es retornen els continguts de la 12a cel·la com el valor de la funció (en el vector resultant)." ], "id_hash": -4343587908196936134, "content_hash": -4343587908196936134, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3149809\nhelp.text", "note": "36TJv", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2128, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 51, "source_unit": "https://translations.documentfoundation.org/api/units/110981886/?format=api", "priority": 100, "id": 111761117, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=43b879cf913d563a", "url": "https://translations.documentfoundation.org/api/units/111761117/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:17.208281Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<bookmark_value>CHOOSE function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>funció TRIA</bookmark_value>" ], "id_hash": -1246532646027441510, "content_hash": -1246532646027441510, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id3150430\nhelp.text", "note": "XYxM4", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2129, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/110981902/?format=api", "priority": 100, "id": 111761122, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=6eb36d29b09b4a9a", "url": "https://translations.documentfoundation.org/api/units/111761122/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:17.210993Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "CHOOSE" ], "previous_source": "", "target": [ "TRIA" ], "id_hash": 7614291423126201432, "content_hash": 7614291423126201432, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3150430\nhelp.text", "note": "eygie", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2130, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110981915/?format=api", "priority": 100, "id": 111761128, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=e9ab65b503bda458", "url": "https://translations.documentfoundation.org/api/units/111761128/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:17.213427Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_WAHL\">Uses an index to return a value from a list of up to 30 values.</ahelp>" ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_WAHL\">Utilitza un índex per retornar un valor d'una llista de fins a 30 valors.</ahelp>" ], "id_hash": 5000394310678462495, "content_hash": 5000394310678462495, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3143270\nhelp.text", "note": "ynNz9", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2131, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/110981924/?format=api", "priority": 100, "id": 111761131, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=c564f821e0dfc01f", "url": "https://translations.documentfoundation.org/api/units/111761131/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:17.215540Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "CHOOSE(Index; Value 1 [; Value 2 [; ... [; Value 30]]])" ], "previous_source": "", "target": [ "CHOOSE(Index; Valor 1 [; Valor 2 [; [; Valor 30<unk>)" ], "id_hash": -4068678915336599423, "content_hash": -4068678915336599423, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3155425\nhelp.text", "note": "V8cAu", "flags": "", "labels": [], "state": 10, "fuzzy": true, "translated": false, "approved": false, "position": 2132, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/110981934/?format=api", "priority": 100, "id": 111761137, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=47892615523d8881", "url": "https://translations.documentfoundation.org/api/units/111761137/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:17.217968Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<emph>Index</emph> is a reference or number between 1 and 30 indicating which value is to be taken from the list." ], "previous_source": "", "target": [ "<emph>Índex</emph> és una referència o un nombre entre 1 i 30 que indica quin valor s'ha d'extreure de la llista." ], "id_hash": 2029050507715629929, "content_hash": 2029050507715629929, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3144755\nhelp.text", "note": "CNK7e", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2133, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/110981942/?format=api", "priority": 100, "id": 111761142, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=9c28a2afb7b75369", "url": "https://translations.documentfoundation.org/api/units/111761142/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:17.220162Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<emph>Value 1, Value 2, ..., Value 30</emph> is the list of values entered as a reference to a cell or as individual values." ], "previous_source": "", "target": [ "<unk>GA Valor 1 Valor 2 Valor 30</emph> és la llista de valors introduïts com a referència a una cel·la o com a valors individuals." ], "id_hash": 7994380975018243295, "content_hash": 7994380975018243295, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3149939\nhelp.text", "note": "GGWDt", "flags": "", "labels": [], "state": 10, "fuzzy": true, "translated": false, "approved": false, "position": 2134, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 23, "source_unit": "https://translations.documentfoundation.org/api/units/110981951/?format=api", "priority": 100, "id": 111761147, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=eef1bf24071a74df", "url": "https://translations.documentfoundation.org/api/units/111761147/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:17.222677Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<item type=\"input\">=CHOOSE(A1;B1;B2;B3;\"Today\";\"Yesterday\";\"Tomorrow\")</item>, for example, returns the contents of cell B2 for A1 = 2; for A1 = 4, the function returns the text \"Today\"." ], "previous_source": "", "target": [ "<item type=\"input\">=TRIA(A1;B1;B2;B3;\"Avui\";\"Ahir\";\"Demà\")</item>, per exemple, retorna el contingut de la cel·la B2 per a A1 = 2; per a A1 = 4, la funció retorna el text \"Avui\"." ], "id_hash": 1169713915901438249, "content_hash": 1169713915901438249, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3150625\nhelp.text", "note": "s64Du", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2135, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://translations.documentfoundation.org/api/units/110981962/?format=api", "priority": 100, "id": 111761153, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=903ba89bee22e929", "url": "https://translations.documentfoundation.org/api/units/111761153/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:17.225782Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<bookmark_value>HLOOKUP function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>funció CONSULTAH</bookmark_value>" ], "id_hash": 837705466221852232, "content_hash": 837705466221852232, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id3151001\nhelp.text", "note": "pyC7b", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2136, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/110981964/?format=api", "priority": 100, "id": 111761158, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=8ba020aee48e7648", "url": "https://translations.documentfoundation.org/api/units/111761158/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:17.228314Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "HLOOKUP" ], "previous_source": "", "target": [ "CONSULTAH" ], "id_hash": 1011049703423366766, "content_hash": 1011049703423366766, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3151001\nhelp.text", "note": "LPUU2", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2137, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110982007/?format=api", "priority": 100, "id": 111761163, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=8e07f85936d0566e", "url": "https://translations.documentfoundation.org/api/units/111761163/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:17.231022Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_WVERWEIS\">Searches for a value and reference to the cells below the selected area.</ahelp> This function verifies if the first row of an array contains a certain value. The function returns then the value in a row of the array, named in the <emph>Index</emph>, in the same column." ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_WVERWEIS\">Cerca un valor i una referència en les cel·les situades sota l'àrea seleccionada.</ahelp> Aquesta funció verifica si la primera fila d'una matriu conté un valor determinat. Tot seguit, la funció retorna el valor en una fila de la matriu, anomenada en l'<emph>Índex</emph>, en la mateixa columna." ], "id_hash": 8452625132990922436, "content_hash": 8452625132990922436, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3148688\nhelp.text", "note": "XtZrs", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2138, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 48, "source_unit": "https://translations.documentfoundation.org/api/units/110982054/?format=api", "priority": 100, "id": 111761166, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=f54dc1c647767ec4", "url": "https://translations.documentfoundation.org/api/units/111761166/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:17.233497Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "HLOOKUP(Lookup; Array; Index [; SortedRangeLookup])" ], "previous_source": "", "target": [ "" ], "id_hash": -7751377004937243571, "content_hash": -7751377004937243571, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3146070\nhelp.text", "note": "NWzFA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2139, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/110982069/?format=api", "priority": 100, "id": 111761171, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=146d93aebc95944d", "url": "https://translations.documentfoundation.org/api/units/111761171/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:17.235806Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "For an explanation on the parameters, see: <link href=\"text/scalc/01/04060109.xhp#Section9\">VLOOKUP</link> (columns and rows are exchanged)" ], "previous_source": "", "target": [ "Per obtenir una explicació sobre els paràmetres vegeu <link href=\"text/scalc/01/04060109.xhp#Section9\">VLOOKUP</link> (es canvien columnes i files)" ], "id_hash": -1478624749447993405, "content_hash": -1478624749447993405, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3148672\nhelp.text", "note": "SQxFe", "flags": "", "labels": [], "state": 10, "fuzzy": true, "translated": false, "approved": false, "position": 2140, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/110982099/?format=api", "priority": 100, "id": 111761173, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=6b7ade9fdd0d27c3", "url": "https://translations.documentfoundation.org/api/units/111761173/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:17.237318Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "Suppose we have built a small database table occupying the cell range A1:DO4 and containing basic information about 118 chemical elements. The first column contains the row headings “Element”, “Symbol”, “Atomic Number”, and “Relative Atomic Mass”. Subsequent columns contain the relevant information for each of the elements, ordered left to right by atomic number. For example, cells B1:B4 contain “Hydrogen”, “H”, “1” and “1.008”, while cells DO1:DO4 contain “Oganesson”, “Og”, “118”, and “294”." ], "previous_source": "", "target": [ "" ], "id_hash": 4634706998389279706, "content_hash": 4634706998389279706, "location": "04060109.xhp", "context": "04060109.xhp\npar_id141612447324913\nhelp.text", "note": "vwqHz", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2141, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 73, "source_unit": "https://translations.documentfoundation.org/api/units/110982176/?format=api", "priority": 100, "id": 111761180, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=c051c97595028bda", "url": "https://translations.documentfoundation.org/api/units/111761180/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:17.239902Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "Element" ], "previous_source": "", "target": [ "Element" ], "id_hash": 2569298458541281685, "content_hash": 2569298458541281685, "location": "04060109.xhp", "context": "04060109.xhp\npar_id151612978320063\nhelp.text", "note": "eAMVa", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2142, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110982241/?format=api", "priority": 100, "id": 111761185, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=a3a7fb55d74fd195", "url": "https://translations.documentfoundation.org/api/units/111761185/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:17.242036Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "Hydrogen" ], "previous_source": "", "target": [ "Hidrogen" ], "id_hash": -2956641131870373628, "content_hash": -2956641131870373628, "location": "04060109.xhp", "context": "04060109.xhp\npar_id711612450364379\nhelp.text", "note": "BcKD5", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2143, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110982294/?format=api", "priority": 100, "id": 111761189, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=56f7e68e368eb904", "url": "https://translations.documentfoundation.org/api/units/111761189/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:17.244654Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "Helium" ], "previous_source": "", "target": [ "Heli" ], "id_hash": -3753674292092525244, "content_hash": -3753674292092525244, "location": "04060109.xhp", "context": "04060109.xhp\npar_id681612450364379\nhelp.text", "note": "ACHPj", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2144, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110982339/?format=api", "priority": 100, "id": 111761194, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=4be8451e814f2544", "url": "https://translations.documentfoundation.org/api/units/111761194/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:17.246929Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "Lithium" ], "previous_source": "", "target": [ "Liti" ], "id_hash": 6395355888623892843, "content_hash": 6395355888623892843, "location": "04060109.xhp", "context": "04060109.xhp\npar_id531612453345232\nhelp.text", "note": "7YEmL", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2145, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110982506/?format=api", "priority": 100, "id": 111761198, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=d8c0de4bf1a1396b", "url": "https://translations.documentfoundation.org/api/units/111761198/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:17.249051Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "Oganesson" ], "previous_source": "", "target": [ "Oganessó" ], "id_hash": -6406307038623048080, "content_hash": -6406307038623048080, "location": "04060109.xhp", "context": "04060109.xhp\npar_id571612453039430\nhelp.text", "note": "Y3c6z", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2146, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110982547/?format=api", "priority": 100, "id": 111761201, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=271839b0c0c9de70", "url": "https://translations.documentfoundation.org/api/units/111761201/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:17.250973Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "Symbol" ], "previous_source": "", "target": [ "Símbol" ], "id_hash": -2741696328488591392, "content_hash": -2741696328488591392, "location": "04060109.xhp", "context": "04060109.xhp\npar_id341612978329327\nhelp.text", "note": "4H4fa", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2147, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110982607/?format=api", "priority": 100, "id": 111761203, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=59f389b72271dfe0", "url": "https://translations.documentfoundation.org/api/units/111761203/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:17.252945Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "Atomic Number" ], "previous_source": "", "target": [ "Nombre atòmic" ], "id_hash": 8197228261284471071, "content_hash": 8197228261284471071, "location": "04060109.xhp", "context": "04060109.xhp\npar_id601612978601591\nhelp.text", "note": "jVBoy", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2148, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/110982628/?format=api", "priority": 100, "id": 111761207, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=f1c267ac40a7611f", "url": "https://translations.documentfoundation.org/api/units/111761207/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:17.255114Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "Relative Atomic Mass" ], "previous_source": "", "target": [ "Massa atòmica relativa" ], "id_hash": -3629097185374679292, "content_hash": -3629097185374679292, "location": "04060109.xhp", "context": "04060109.xhp\npar_id751612978603374\nhelp.text", "note": "WjrrE", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2149, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/110982700/?format=api", "priority": 100, "id": 111761211, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=4da2db56725f4f04", "url": "https://translations.documentfoundation.org/api/units/111761211/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:17.257050Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<input>=HLOOKUP(\"Lead\"; $A$1:$DO$4; 2; 0)</input> returns “Pb”, the symbol for lead." ], "previous_source": "", "target": [ "" ], "id_hash": 6194904089656399110, "content_hash": 6194904089656399110, "location": "04060109.xhp", "context": "04060109.xhp\npar_id51612447346319\nhelp.text", "note": "Cb3HA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2150, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/110982771/?format=api", "priority": 100, "id": 111761215, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=d5f8b87291959506", "url": "https://translations.documentfoundation.org/api/units/111761215/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:17.259239Z" } ] }