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=41
{ "count": 8439, "next": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/units/?format=api&page=42", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/units/?format=api&page=40", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<emph>File</emph> is the complete file name, including path specification." ], "previous_source": "", "target": [ "<emph>Fitxer</emph> és el nom de fitxer complet, inclosa l'especificació del camí." ], "id_hash": 7315661511110541223, "content_hash": 7315661511110541223, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3153034\nhelp.text", "note": "vsezP", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2001, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/110976768/?format=api", "priority": 100, "id": 111760451, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=e586736262bdbfa7", "url": "https://translations.documentfoundation.org/api/units/111760451/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.734892Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<emph>Range</emph> is the area containing the data to be evaluated." ], "previous_source": "", "target": [ "<emph>Interval</emph> és l'àrea que conté les dades que s'han d'avaluar." ], "id_hash": -8797125138790730943, "content_hash": -8797125138790730943, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3147472\nhelp.text", "note": "kU4Vp", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2002, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/110976790/?format=api", "priority": 100, "id": 111760453, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=05ea554ba1b83341", "url": "https://translations.documentfoundation.org/api/units/111760453/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.737075Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<emph>Mode</emph> is an optional parameter that controls the method by which the DDE server converts its data into numbers." ], "previous_source": "", "target": [ "<emph>Mode</emph> és un paràmetre opcional que controla el mètode pel qual el servidor DDE converteix les dades en nombres." ], "id_hash": 4320051185540375453, "content_hash": 4320051185540375453, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3152773\nhelp.text", "note": "9zEYF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2003, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/110976817/?format=api", "priority": 100, "id": 111760455, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=bbf3e7aa25a3a39d", "url": "https://translations.documentfoundation.org/api/units/111760455/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.738895Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "Mode" ], "previous_source": "", "target": [ "Mode" ], "id_hash": 1366355475372460189, "content_hash": 1366355475372460189, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3154383\nhelp.text", "note": "kTM5K", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2004, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110976862/?format=api", "priority": 100, "id": 111760459, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=92f64510ca7c489d", "url": "https://translations.documentfoundation.org/api/units/111760459/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.741201Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "Effect" ], "previous_source": "", "target": [ "Efecte" ], "id_hash": 1778018240787986991, "content_hash": 1778018240787986991, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3145146\nhelp.text", "note": "hAUG9", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2005, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110976888/?format=api", "priority": 100, "id": 111760461, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=98acca2b6e553a2f", "url": "https://translations.documentfoundation.org/api/units/111760461/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.742383Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "0 or missing" ], "previous_source": "", "target": [ "0 o hi manca" ], "id_hash": -2450793688976304581, "content_hash": -2450793688976304581, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3154558\nhelp.text", "note": "GLZVP", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2006, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/110976918/?format=api", "priority": 100, "id": 111760464, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=5dfd081feecc563b", "url": "https://translations.documentfoundation.org/api/units/111760464/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.743649Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "Number format from the \"Default\" cell style" ], "previous_source": "", "target": [ "Format numèric de l'estil de cel·la «Per defecte»" ], "id_hash": 2506316584798282112, "content_hash": 2506316584798282112, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3145596\nhelp.text", "note": "qgE6C", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2007, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/110976929/?format=api", "priority": 100, "id": 111760467, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=a2c839a7a3926180", "url": "https://translations.documentfoundation.org/api/units/111760467/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.745172Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "Data are always interpreted in the standard format for US English" ], "previous_source": "", "target": [ "Les dades sempre s'interpreten en el format estàndard de l'anglès americà." ], "id_hash": -6041178584146709210, "content_hash": -6041178584146709210, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3154380\nhelp.text", "note": "547CV", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2008, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/110976965/?format=api", "priority": 100, "id": 111760471, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=2c296c15d33cf526", "url": "https://translations.documentfoundation.org/api/units/111760471/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.746799Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "Data are retrieved as text; no conversion to numbers" ], "previous_source": "", "target": [ "Les dades es recuperen com a text; no hi ha conversió a nombres" ], "id_hash": -426597428070967290, "content_hash": -426597428070967290, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3153775\nhelp.text", "note": "PEbpW", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2009, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/110976983/?format=api", "priority": 100, "id": 111760475, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=7a146be63dbc1806", "url": "https://translations.documentfoundation.org/api/units/111760475/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.749047Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<item type=\"input\">=DDE(\"soffice\";\"c:\\office\\document\\data1.ods\";\"sheet1.A1\")</item> reads the contents of cell A1 in sheet1 of the <item type=\"productname\">%PRODUCTNAME</item> Calc spreadsheet data1.ods." ], "previous_source": "", "target": [ "<unk>GA =DDE(\"soffice\";\"c\\office\\document\\data1.ods\";\"full1.A1\")</item> llegeix el contingut de la cel·la A1 al full1 del full de càlcul <item type=\"productname\">%PRODUCTNAME</item> Calc." ], "id_hash": 4335012515870683916, "content_hash": 4335012515870683916, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3148734\nhelp.text", "note": "Ae8L2", "flags": "", "labels": [], "state": 10, "fuzzy": true, "translated": false, "approved": false, "position": 2010, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 17, "source_unit": "https://translations.documentfoundation.org/api/units/110977021/?format=api", "priority": 100, "id": 111760478, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=bc290eea5158330c", "url": "https://translations.documentfoundation.org/api/units/111760478/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.751005Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<item type=\"input\">=DDE(\"soffice\";\"c:\\office\\document\\motto.odt\";\"Today's motto\")</item> returns a motto in the cell containing this formula. First, you must enter a line in the motto.odt document containing the motto text and define it as the first line of a section named <item type=\"literal\">Today's Motto</item> (in <item type=\"productname\">%PRODUCTNAME</item> Writer under <emph>Insert - Section</emph>). If the motto is modified (and saved) in the <item type=\"productname\">%PRODUCTNAME</item> Writer document, the motto is updated in all <item type=\"productname\">%PRODUCTNAME</item> Calc cells in which this DDE link is defined." ], "previous_source": "", "target": [ "<unk>GA =DDE(\"soffice\";\"c\\office\\document\\motto.odt\";\"Lema d'avui\")</item> retorna un lema a la cel·la que conté aquesta fórmula. Primer heu d'introduir una línia en el document leme.odt que conté el text del lema i definir-lo com la primera línia d'una secció anomenada Motto <item type=\"literal\">d'avui sota <emph>Insereix - Secció</emph>). Si el lema es modifica (i es desa) en el document <item type=\"productname\">%PRODUCTNAME</item> Writer el lema s'actualitza en totes les cel·les del <item type=\"productname\"> %PRODUCTNAME</item> Calc en les quals es defineix aquest enllaç." ], "id_hash": -3384527376398056909, "content_hash": -3384527376398056909, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3153081\nhelp.text", "note": "96FU5", "flags": "", "labels": [], "state": 10, "fuzzy": true, "translated": false, "approved": false, "position": 2011, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 78, "source_unit": "https://translations.documentfoundation.org/api/units/110977046/?format=api", "priority": 100, "id": 111760486, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=5107be487d358233", "url": "https://translations.documentfoundation.org/api/units/111760486/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.754159Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<bookmark_value>ERRORTYPE function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>funció TIPUSERROR</bookmark_value>" ], "id_hash": 1918345880442002828, "content_hash": 1918345880442002828, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id3153114\nhelp.text", "note": "DmwaH", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2012, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/110977102/?format=api", "priority": 100, "id": 111760491, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=9a9f556a18145d8c", "url": "https://translations.documentfoundation.org/api/units/111760491/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.757592Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "ERRORTYPE" ], "previous_source": "", "target": [ "TIPUSERROR" ], "id_hash": 6126491897215722938, "content_hash": 6126491897215722938, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3153114\nhelp.text", "note": "Lp8zY", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2013, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110977141/?format=api", "priority": 100, "id": 111760496, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=d505abebc4da25ba", "url": "https://translations.documentfoundation.org/api/units/111760496/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.760072Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_FEHLERTYP\">Returns the number corresponding to an <link href=\"text/scalc/05/02140000.xhp\">error value</link> occurring in a different cell.</ahelp> With the aid of this number, you can generate an error message text." ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_FEHLERTYP\">Retorna el nombre corresponent a un <link href=\"text/scalc/05/02140000.xhp\">valor d'error</link> que aparegui en una cel·la diferent.</ahelp> Amb l'ajuda d'aquest nombre, podeu generar un missatge d'error en forma de text." ], "id_hash": -5680160780120138924, "content_hash": -5680160780120138924, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3148568\nhelp.text", "note": "hEDCC", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2014, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 28, "source_unit": "https://translations.documentfoundation.org/api/units/110977181/?format=api", "priority": 100, "id": 111760502, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=312c03dd81d55b54", "url": "https://translations.documentfoundation.org/api/units/111760502/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.762410Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "The Status Bar displays the predefined error code from <item type=\"productname\">%PRODUCTNAME</item> if you click the cell containing the error." ], "previous_source": "", "target": [ "La barra d'estat mostra el codi d'error predefinit del <item type=\"productname\">%PRODUCTNAME</item> si feu clic a la cel·la que conté l'error." ], "id_hash": -1829222880947143955, "content_hash": -1829222880947143955, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3149877\nhelp.text", "note": "G7W2S", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2015, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/110977205/?format=api", "priority": 100, "id": 111760507, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=669d4b7b3e20faed", "url": "https://translations.documentfoundation.org/api/units/111760507/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.764851Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "ERRORTYPE(Reference)" ], "previous_source": "", "target": [ "TIPUSERROR(Referència)" ], "id_hash": -6713984224407071925, "content_hash": -6713984224407071925, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3151322\nhelp.text", "note": "KKLCk", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2016, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110977220/?format=api", "priority": 100, "id": 111760518, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=22d322eb8ca3d34b", "url": "https://translations.documentfoundation.org/api/units/111760518/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.767274Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<emph>Reference</emph> contains the address of the cell in which the error occurs." ], "previous_source": "", "target": [ "<emph>Referència</emph> conté l'adreça de la cel·la on es produeix l'error." ], "id_hash": -6554719520712774592, "content_hash": -6554719520712774592, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3150132\nhelp.text", "note": "DkKtR", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2017, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/110977255/?format=api", "priority": 100, "id": 111760525, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=2508f5530598ac40", "url": "https://translations.documentfoundation.org/api/units/111760525/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.772323Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "If cell A1 displays Err:518, the function <item type=\"input\">=ERRORTYPE(A1)</item> returns the number 518." ], "previous_source": "", "target": [ "Si la cel·la A1 mostra Err:518, la funció <item type=\"input\">=TIPUSERROR(A1)</item> retorna el nombre 518." ], "id_hash": 1941990232443135341, "content_hash": 1941990232443135341, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3146904\nhelp.text", "note": "QgTxS", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2018, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/110977289/?format=api", "priority": 100, "id": 111760531, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=9af355d3ca0d256d", "url": "https://translations.documentfoundation.org/api/units/111760531/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.775257Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<bookmark_value>INDEX function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>funció INDEX</bookmark_value>" ], "id_hash": -3510616849146248191, "content_hash": -3510616849146248191, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id3151221\nhelp.text", "note": "mtLKD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2019, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/110977309/?format=api", "priority": 100, "id": 111760536, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=4f47c89364230401", "url": "https://translations.documentfoundation.org/api/units/111760536/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.778164Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "INDEX" ], "previous_source": "", "target": [ "INDEX" ], "id_hash": -6205565825555549533, "content_hash": -6205565825555549533, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3151221\nhelp.text", "note": "8DKwz", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2020, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110978149/?format=api", "priority": 100, "id": 111760542, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=29e166c2997532a3", "url": "https://translations.documentfoundation.org/api/units/111760542/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.780622Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_INDEX\">INDEX returns a reference, a value or an array of values from a reference range, specified by row and column index number or array of row and array of columns index numbers, and an optional range index.</ahelp>" ], "previous_source": "", "target": [ "" ], "id_hash": -8397598796967873698, "content_hash": -8397598796967873698, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3150268\nhelp.text", "note": "TgAJs", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2021, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 38, "source_unit": "https://translations.documentfoundation.org/api/units/110978166/?format=api", "priority": 100, "id": 111760546, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=0b75bc62f47b735e", "url": "https://translations.documentfoundation.org/api/units/111760546/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.782776Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "INDEX() returns a reference if the argument is one or more references. When used in a cell in the form =INDEX(), the reference is resolved and the values displayed. When INDEX() is used in arguments of other functions, =FUNCTION(INDEX()...), the function gets the reference passed that was returned by INDEX(). Returning a reference is different from returning an array of values for functions that handles them differently." ], "previous_source": "", "target": [ "" ], "id_hash": -6873999040353118520, "content_hash": -6873999040353118520, "location": "04060109.xhp", "context": "04060109.xhp\npar_id901682701069280\nhelp.text", "note": "GwG9e", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2022, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 67, "source_unit": "https://translations.documentfoundation.org/api/units/110978222/?format=api", "priority": 100, "id": 111760553, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=209aa64af56056c8", "url": "https://translations.documentfoundation.org/api/units/111760553/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.784924Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "INDEX(Reference [; [Row] [; [Column] [; Range]]])" ], "previous_source": "", "target": [ "" ], "id_hash": 3329173742403328129, "content_hash": 3329173742403328129, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3149007\nhelp.text", "note": "dr8Bi", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2023, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/110978247/?format=api", "priority": 100, "id": 111760556, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=ae3399e147821881", "url": "https://translations.documentfoundation.org/api/units/111760556/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.786917Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<emph>Reference</emph> is a reference, entered either directly or by specifying a range name. If the reference consists of multiple ranges, you must enclose the list of references or range names in parentheses, or either use the tilde (~) <link href=\"text/scalc/01/04060199.xhp#referenceoperators\">range concatenation operator</link> or define a named range with multiple areas." ], "previous_source": "", "target": [ "" ], "id_hash": 4763170941283659549, "content_hash": 4763170941283659549, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3153260\nhelp.text", "note": "AMnwW", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2024, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 50, "source_unit": "https://translations.documentfoundation.org/api/units/110978271/?format=api", "priority": 100, "id": 111760561, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=c21a2ebc17acef1d", "url": "https://translations.documentfoundation.org/api/units/111760561/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.788762Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<emph>Row</emph> (optional) represents the row or the array of row indexes of the reference range, for which to return a value. In case of zero or omitted (no specific row) all referenced rows are returned." ], "previous_source": "", "target": [ "" ], "id_hash": 8690371446690704261, "content_hash": 8690371446690704261, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3145302\nhelp.text", "note": "MKdnE", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2025, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 35, "source_unit": "https://translations.documentfoundation.org/api/units/110978303/?format=api", "priority": 100, "id": 111760567, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=f89a66c986326b85", "url": "https://translations.documentfoundation.org/api/units/111760567/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.790525Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<emph>Column</emph> (optional) represents the column or array of column indexes of the reference range, for which to return a value. In case of zero or omitted (no specific column) all referenced columns are returned." ], "previous_source": "", "target": [ "" ], "id_hash": 3245157780478865290, "content_hash": 3245157780478865290, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3154628\nhelp.text", "note": "usFXV", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2026, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 34, "source_unit": "https://translations.documentfoundation.org/api/units/110978333/?format=api", "priority": 100, "id": 111760571, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=ad091dcec989af8a", "url": "https://translations.documentfoundation.org/api/units/111760571/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.792196Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "If <emph>Row</emph>, <emph>Column</emph> or both are omitted or defined as arrays of indexes, the INDEX function must be entered as an <link href=\"text/scalc/01/04060107.xhp\">array function</link>." ], "previous_source": "", "target": [ "" ], "id_hash": 8042928239876025018, "content_hash": 8042928239876025018, "location": "04060109.xhp", "context": "04060109.xhp\npar_id621679327293280\nhelp.text", "note": "FBj7m", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2027, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://translations.documentfoundation.org/api/units/110978353/?format=api", "priority": 100, "id": 111760575, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=ef9e389ef3c4aaba", "url": "https://translations.documentfoundation.org/api/units/111760575/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.793909Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<emph>Range</emph> (optional) represents the index of the subrange if referring to a multiple range, default is 1." ], "previous_source": "", "target": [ "" ], "id_hash": -8124523639308866552, "content_hash": -8124523639308866552, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3155514\nhelp.text", "note": "BmioJ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2028, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 17, "source_unit": "https://translations.documentfoundation.org/api/units/110978404/?format=api", "priority": 100, "id": 111760581, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=0f3fe4cbadbb2c08", "url": "https://translations.documentfoundation.org/api/units/111760581/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.797080Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<input>{=INDEX({1,3,5;7,9,10},{2;1},1)}</input> return a 2 row array containing 7 and 1. The row index {2;1} pick row 2 then row 1. The columns index 1 picks the first column." ], "previous_source": "", "target": [ "" ], "id_hash": -2732052766968460686, "content_hash": -2732052766968460686, "location": "04060109.xhp", "context": "04060109.xhp\npar_id541679331443608\nhelp.text", "note": "BMeAR", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2029, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 28, "source_unit": "https://translations.documentfoundation.org/api/units/110978423/?format=api", "priority": 100, "id": 111760585, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=5a15cc7bc538ca72", "url": "https://translations.documentfoundation.org/api/units/111760585/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.799109Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<input>{=INDEX(D3:G12,{1;2;3;4},{3,1})}</input> return a 4 rows by 2 columns array. The row index array {1;2;3;4} picks rows 3 to 6 and {3;1} picks the third (F) and first column (D). Columns 1 and 3 of the source reference are swapped in the resulting array." ], "previous_source": "", "target": [ "" ], "id_hash": 2561781032724062582, "content_hash": 2561781032724062582, "location": "04060109.xhp", "context": "04060109.xhp\npar_id511679333116273\nhelp.text", "note": "RGnNr", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2030, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 43, "source_unit": "https://translations.documentfoundation.org/api/units/110978452/?format=api", "priority": 100, "id": 111760590, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=a38d4646bfd9e176", "url": "https://translations.documentfoundation.org/api/units/111760590/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.801266Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<item type=\"input\">=INDEX(Prices;4;1)</item> returns the value from row 4 and column 1 of the database range defined in <emph>Data - Define</emph> as <emph>Prices</emph>." ], "previous_source": "", "target": [ "<item type=\"input\">=INDEX(Preus;4;1)</item> retorna el valor de la fila 4 i de la columna 1 de l'interval de base de dades que heu definit a <emph>Dades ▸ Defineix</emph> com a <emph>Preus</emph>." ], "id_hash": 8631622783403805933, "content_hash": 8631622783403805933, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3159112\nhelp.text", "note": "7pFH2", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2031, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 22, "source_unit": "https://translations.documentfoundation.org/api/units/110978481/?format=api", "priority": 100, "id": 111760600, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=f7c9af306ff3cced", "url": "https://translations.documentfoundation.org/api/units/111760600/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.806220Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<item type=\"input\">=INDEX(SumX;4;1)</item> returns the value from the range <emph>SumX</emph> in row 4 and column 1 as defined in <emph>Sheet - Named Ranges and Expressions - Define</emph>." ], "previous_source": "", "target": [ "<item type=\"input\">=INDEX(SumaX;4;1)</item> retorna el valor de l'interval <emph>SumaX</emph> de la fila 4 i la columna 1 tal com s'ha definit a <emph>Full ▸ Intervals i expressions amb nom ▸ Defineix</emph>." ], "id_hash": -3275555322380811905, "content_hash": -3275555322380811905, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3150691\nhelp.text", "note": "UFxmm", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2032, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/110978504/?format=api", "priority": 100, "id": 111760606, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=528ae3c9f75a017f", "url": "https://translations.documentfoundation.org/api/units/111760606/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.808787Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<input>{=INDEX(A1:B6;1)}</input> returns the values of the first row of A1:B6. Enter the formula as an <link href=\"text/scalc/01/04060107.xhp\">array formula</link>." ], "previous_source": "", "target": [ "" ], "id_hash": 3373830903152245766, "content_hash": 3373830903152245766, "location": "04060109.xhp", "context": "04060109.xhp\npar_id4109012\nhelp.text", "note": "mfFAA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2033, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/110978596/?format=api", "priority": 100, "id": 111760612, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=aed24154c29ffc06", "url": "https://translations.documentfoundation.org/api/units/111760612/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.811061Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<input>{=INDEX(A1:B6;0;1)}</input> returns the values of the first column of A1:B6. Enter the formula as an <link href=\"text/scalc/01/04060107.xhp\">array formula</link>." ], "previous_source": "", "target": [ "" ], "id_hash": 5763011134459683020, "content_hash": 5763011134459683020, "location": "04060109.xhp", "context": "04060109.xhp\npar_id9272133\nhelp.text", "note": "jLKKJ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2034, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/110978621/?format=api", "priority": 100, "id": 111760617, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=cffa5417d21720cc", "url": "https://translations.documentfoundation.org/api/units/111760617/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.813093Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<item type=\"input\">=INDEX(A1:B6;1;1)</item> indicates the value in the upper-left of the A1:B6 range." ], "previous_source": "", "target": [ "<item type=\"input\">=INDEX(A1:B6;1;1)</item> indica el valor de la part superior esquerra de l'interval A1:B6." ], "id_hash": -4579606228710604787, "content_hash": -4579606228710604787, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3148595\nhelp.text", "note": "igC59", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2035, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/110978630/?format=api", "priority": 100, "id": 111760623, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=4071f8661689c00d", "url": "https://translations.documentfoundation.org/api/units/111760623/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.815005Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<input>{=INDEX((A1:B6;C1:D6);0;0;2)}</input> returns the values of the second range C1:D6 of the multiple range. Enter the formula as an <link href=\"text/scalc/01/04060107.xhp\">array formula</link>." ], "previous_source": "", "target": [ "" ], "id_hash": -2227884281875185104, "content_hash": -2227884281875185104, "location": "04060109.xhp", "context": "04060109.xhp\npar_id9960020\nhelp.text", "note": "GQjbB", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2036, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://translations.documentfoundation.org/api/units/110978643/?format=api", "priority": 100, "id": 111760629, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=6114f70caa274230", "url": "https://translations.documentfoundation.org/api/units/111760629/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.817128Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/INDEX\">INDEX wiki page</link>." ], "previous_source": "", "target": [ "" ], "id_hash": -3088447245330367753, "content_hash": -3088447245330367753, "location": "04060109.xhp", "context": "04060109.xhp\npar_id701677016751508\nhelp.text", "note": "HSbEt", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2037, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/110978663/?format=api", "priority": 100, "id": 111760634, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=5523a197fa8cbaf7", "url": "https://translations.documentfoundation.org/api/units/111760634/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.819033Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<bookmark_value>INDIRECT function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>funció INDIRECTE</bookmark_value>" ], "id_hash": -1128844034642182997, "content_hash": -1128844034642182997, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id3153181\nhelp.text", "note": "LCBWC", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2038, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/110978722/?format=api", "priority": 100, "id": 111760636, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=70558a54d4557cab", "url": "https://translations.documentfoundation.org/api/units/111760636/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.820412Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "INDIRECT" ], "previous_source": "", "target": [ "INDIRECTE" ], "id_hash": 6065144281656826621, "content_hash": 6065144281656826621, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3153181\nhelp.text", "note": "VXKFM", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2039, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110978768/?format=api", "priority": 100, "id": 111760640, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=d42bb896f3a59afd", "url": "https://translations.documentfoundation.org/api/units/111760640/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.822515Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_INDIREKT\">Returns the <emph>reference</emph> specified by a text string.</ahelp> This function can also be used to return the area of a corresponding string." ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_INDIREKT\">Retorna la <emph>referència</emph> especificada per una cadena de text.</ahelp> Aquesta funció també pot utilitzar-se per retornar l'àrea d'una cadena corresponent." ], "id_hash": -5986397852430006106, "content_hash": -5986397852430006106, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3147169\nhelp.text", "note": "5Pxmv", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2040, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 23, "source_unit": "https://translations.documentfoundation.org/api/units/110978805/?format=api", "priority": 100, "id": 111760643, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=2cec0aded9bf88a6", "url": "https://translations.documentfoundation.org/api/units/111760643/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.824933Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "INDIRECT(Ref [; A1])" ], "previous_source": "", "target": [ "INDIRECTE(Ref [; A1])" ], "id_hash": 2695684104847913136, "content_hash": 2695684104847913136, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3149824\nhelp.text", "note": "hDCWQ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2041, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/110978867/?format=api", "priority": 100, "id": 111760648, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=a568fe69382070b0", "url": "https://translations.documentfoundation.org/api/units/111760648/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.827539Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<emph>Ref</emph> represents a reference to a cell or an area (in text form) for which to return the contents." ], "previous_source": "", "target": [ "<emph>Ref</emph> representa una referència a una cel·la o a una àrea (en un formulari de text) per a la qual es retornen els continguts." ], "id_hash": 8146128659930204794, "content_hash": 8146128659930204794, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3154317\nhelp.text", "note": "cZG9F", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2042, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/110978885/?format=api", "priority": 100, "id": 111760653, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=f10cdcdb2dc4ca7a", "url": "https://translations.documentfoundation.org/api/units/111760653/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.829729Z" }, { "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": 7809132219533021688, "content_hash": 7809132219533021688, "location": "04060109.xhp", "context": "04060109.xhp\npar_id1027200802470312\nhelp.text", "note": "6xBcm", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2043, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/110978910/?format=api", "priority": 100, "id": 111760655, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=ec5f9c610d52d1f8", "url": "https://translations.documentfoundation.org/api/units/111760655/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.832021Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "If you open an Excel spreadsheet that uses indirect addresses calculated from string functions, the sheet addresses will not be translated automatically. For example, the Excel address in INDIRECT(\"[filename]sheetname!\"&B1) is not converted into the Calc address in INDIRECT(\"filename#sheetname.\"&B1)." ], "previous_source": "", "target": [ "Si obriu un full de càlcul de l'Excel que utilitza adreces indirectes que s'han calculat a partir de funcions de cadena, les adreces del full no es traduiran automàticament. Per exemple, l'adreça de l'Excel a INDIRECTE(\"[nomdelfitxer]nomdelfull!\"&B1) no es converteix en l'adreça del Calc a INDIRECTE(\"nomdelfitxer#nomdelfull.\"&B1)." ], "id_hash": -9025562161285509845, "content_hash": -9025562161285509845, "location": "04060109.xhp", "context": "04060109.xhp\npar_idN10CAE\nhelp.text", "note": "5adA4", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2044, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 38, "source_unit": "https://translations.documentfoundation.org/api/units/110978946/?format=api", "priority": 100, "id": 111760662, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=02bec308a65ecd2b", "url": "https://translations.documentfoundation.org/api/units/111760662/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.834649Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<item type=\"input\">=INDIRECT(A1)</item> equals 100 if A1 contains C108 as a reference and cell C108 contains a value of <item type=\"input\">100</item>." ], "previous_source": "", "target": [ "<item type=\"input\">=INDIRECTE(A1)</item> és igual a 100 si A1 conté C108 com a referència i la cel·la C108 conté un valor de <item type=\"input\">100</item>." ], "id_hash": 3099673932217486913, "content_hash": 3099673932217486913, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3150608\nhelp.text", "note": "mJRg8", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2045, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/110978978/?format=api", "priority": 100, "id": 111760666, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=ab044104c15c8e41", "url": "https://translations.documentfoundation.org/api/units/111760666/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.836475Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<item type=\"input\">=SUM(INDIRECT(\"a1:\" & ADDRESS(1;3)))</item> totals the cells in the area of A1 up to the cell with the address defined by row 1 and column 3. This means that area A1:C1 is totaled." ], "previous_source": "", "target": [ "<item type=\"input\">=SUMA(INDIRECTE(\"a1:\" & ADREÇA(1;3)))</item> totalitza les cel·les de l'àrea A1 fins a la cel·la de la qual s'ha definit l'adreça amb la fila 1 i la columna 3. Això vol dir que es calcula el total de l'àrea A1:C1." ], "id_hash": -1748132909726659601, "content_hash": -1748132909726659601, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3083286\nhelp.text", "note": "UbprA", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2046, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 33, "source_unit": "https://translations.documentfoundation.org/api/units/110979014/?format=api", "priority": 100, "id": 111760671, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=67bd62616f928bef", "url": "https://translations.documentfoundation.org/api/units/111760671/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.838366Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<bookmark_value>COLUMN function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>funció COLUMNA</bookmark_value>" ], "id_hash": -862982028918071288, "content_hash": -862982028918071288, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id3154818\nhelp.text", "note": "T2BJo", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2047, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/110979063/?format=api", "priority": 100, "id": 111760675, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=7406126abecae008", "url": "https://translations.documentfoundation.org/api/units/111760675/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.840471Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "COLUMN" ], "previous_source": "", "target": [ "COLUMNA" ], "id_hash": 2443648171927541574, "content_hash": 2443648171927541574, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3154818\nhelp.text", "note": "sHB7C", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2048, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110979115/?format=api", "priority": 100, "id": 111760681, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=a1e99510bbc61746", "url": "https://translations.documentfoundation.org/api/units/111760681/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.842321Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_SPALTE\">Returns the column number of a cell reference.</ahelp> If the reference is a cell the column number of the cell is returned; if the parameter is a cell area, the corresponding column numbers are returned in a single-row <link href=\"text/scalc/01/04060107.xhp#wasmatrix\">array</link> if the formula is entered <link href=\"text/scalc/01/04060107.xhp#creating_array_formulas\">as an array formula</link>. If the COLUMN function with an area reference parameter is not used for an array formula, only the column number of the first cell within the area is determined." ], "previous_source": "", "target": [ "" ], "id_hash": 2955182560504194790, "content_hash": 2955182560504194790, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3149711\nhelp.text", "note": "Kj3xA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2049, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 80, "source_unit": "https://translations.documentfoundation.org/api/units/110979151/?format=api", "priority": 100, "id": 111760685, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=a902eae1ad4826e6", "url": "https://translations.documentfoundation.org/api/units/111760685/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.843999Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/ca/?format=api", "source": [ "COLUMN([Reference])" ], "previous_source": "", "target": [ "COLUMNA([Referència])" ], "id_hash": -3401701009952994570, "content_hash": -3401701009952994570, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3149447\nhelp.text", "note": "poCRX", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2050, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110979228/?format=api", "priority": 100, "id": 111760691, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/ca/?checksum=50cabaf455aa0af6", "url": "https://translations.documentfoundation.org/api/units/111760691/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:55:16.846396Z" } ] }