Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-7-6/textscalc01/ast/units/?format=api&page=41
https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/units/?format=api&page=42", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/units/?format=api&page=40", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "DDE" ], "previous_source": "", "target": [ "DDE" ], "id_hash": -6084178397908938716, "content_hash": -6084178397908938716, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3148727\nhelp.text", "note": "AMXUq", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2001, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99149626/?format=api", "priority": 100, "id": 99496078, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=2b90a7fb82885024", "url": "https://translations.documentfoundation.org/api/units/99496078/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:41.087803Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_DDE\">Returns the result of a DDE-based link.</ahelp> If the contents of the linked range or section changes, the returned value will also change. You must reload the spreadsheet or choose <emph>Edit - Links</emph> to see the updated links. Cross-platform links, for example from a <item type=\"productname\">%PRODUCTNAME</item> installation running on a Windows machine to a document created on a Linux machine, are not allowed." ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_DDE\">Devuelve la resultancia d'un enllaz basáu en DDE.</ahelp> Si'l conteníu del área o seición enllazada modifícase, el valor devueltu tamién va camudar. Pa ver los enllaces anovaos tien de volvese a cargar la fueya de cálculu o escoyer <emph>Editar - Enllaces</emph>. Nun se dexa definir enllaces ente plataformes distintes, por exemplu enllazar dende una instalación de <item type=\"productname\">%PRODUCTNAME</item> nuna máquina Windows un documentu creáu nuna máquina Linux." ], "id_hash": -3672875923859036273, "content_hash": -3672875923859036273, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3149434\nhelp.text", "note": "2FAG7", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2002, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 64, "source_unit": "https://translations.documentfoundation.org/api/units/99149677/?format=api", "priority": 100, "id": 99496079, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=4d0752ce964c278f", "url": "https://translations.documentfoundation.org/api/units/99496079/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:41.089439Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "DDE(\"Server\"; \"File\"; \"Range\" [; Mode])" ], "previous_source": "", "target": [ "" ], "id_hash": 6958039810471576071, "content_hash": 6958039810471576071, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3148886\nhelp.text", "note": "JBRdm", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2003, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/99149696/?format=api", "priority": 100, "id": 99496082, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=e08fec57a42f4207", "url": "https://translations.documentfoundation.org/api/units/99496082/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:41.091908Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<emph>Server</emph> is the name of a server application. <item type=\"productname\">%PRODUCTNAME</item> applications have the server name \"soffice\"." ], "previous_source": "", "target": [ "" ], "id_hash": -5937338882859885522, "content_hash": -5937338882859885522, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3154842\nhelp.text", "note": "qAN6x", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2004, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/99149775/?format=api", "priority": 100, "id": 99496085, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=2d9a55be50059c2e", "url": "https://translations.documentfoundation.org/api/units/99496085/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:41.093484Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<emph>File</emph> is the complete file name, including path specification." ], "previous_source": "", "target": [ "<emph>Ficheru</emph> ye'l nome completu de ficheru, incluyida la especificación de la ruta." ], "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": 2005, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/99149811/?format=api", "priority": 100, "id": 99496087, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=e586736262bdbfa7", "url": "https://translations.documentfoundation.org/api/units/99496087/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:41.094907Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<emph>Range</emph> is the area containing the data to be evaluated." ], "previous_source": "", "target": [ "<emph>Rangu</emph> ye l'área que contién los datos que se van a evaluar." ], "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": 2006, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/99149923/?format=api", "priority": 100, "id": 99496093, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=05ea554ba1b83341", "url": "https://translations.documentfoundation.org/api/units/99496093/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:41.098632Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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>Mou</emph> ye un parámetru opcional que controla'l métodu pol que'l sirvidor DDE convierte los sos datos en númberos." ], "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": 2007, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/99150017/?format=api", "priority": 100, "id": 99496096, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=bbf3e7aa25a3a39d", "url": "https://translations.documentfoundation.org/api/units/99496096/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:41.101291Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Mode" ], "previous_source": "", "target": [ "Mou" ], "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": 2008, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99150092/?format=api", "priority": 100, "id": 99496101, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=92f64510ca7c489d", "url": "https://translations.documentfoundation.org/api/units/99496101/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:41.109713Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Effect" ], "previous_source": "", "target": [ "Efeutu" ], "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": 2009, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99150129/?format=api", "priority": 100, "id": 99496105, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=98acca2b6e553a2f", "url": "https://translations.documentfoundation.org/api/units/99496105/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:41.111550Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "0 or missing" ], "previous_source": "", "target": [ "0 ó nengunu" ], "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": 2010, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99150173/?format=api", "priority": 100, "id": 99496108, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=5dfd081feecc563b", "url": "https://translations.documentfoundation.org/api/units/99496108/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:41.460628Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Number format from the \"Default\" cell style" ], "previous_source": "", "target": [ "Formatu numbéricu procedente del estilu de caxella \"predetermináu\"" ], "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": 2011, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/99150199/?format=api", "priority": 100, "id": 99496112, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=a2c839a7a3926180", "url": "https://translations.documentfoundation.org/api/units/99496112/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:41.463221Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Data are always interpreted in the standard format for US English" ], "previous_source": "", "target": [ "Los datos interprétense siempres col formatu predetermináu pa inglés d'EE.XX." ], "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": 2012, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/99150226/?format=api", "priority": 100, "id": 99496116, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=2c296c15d33cf526", "url": "https://translations.documentfoundation.org/api/units/99496116/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:41.465950Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Data are retrieved as text; no conversion to numbers" ], "previous_source": "", "target": [ "Los datos acéptense como testu; nun se tresformen en númberos" ], "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": 2013, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/99150249/?format=api", "priority": 100, "id": 99496120, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=7a146be63dbc1806", "url": "https://translations.documentfoundation.org/api/units/99496120/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:41.468437Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": [ "" ], "id_hash": 4335012515870683916, "content_hash": 4335012515870683916, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3148734\nhelp.text", "note": "Ae8L2", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2014, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 17, "source_unit": "https://translations.documentfoundation.org/api/units/99150276/?format=api", "priority": 100, "id": 99496124, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=bc290eea5158330c", "url": "https://translations.documentfoundation.org/api/units/99496124/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:41.470210Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": [ "" ], "id_hash": -3384527376398056909, "content_hash": -3384527376398056909, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3153081\nhelp.text", "note": "96FU5", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2015, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 78, "source_unit": "https://translations.documentfoundation.org/api/units/99150303/?format=api", "priority": 100, "id": 99496128, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=5107be487d358233", "url": "https://translations.documentfoundation.org/api/units/99496128/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:41.471724Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<bookmark_value>ERRORTYPE function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>Función TIPO.DE.ERRU</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": 2016, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99150352/?format=api", "priority": 100, "id": 99496132, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=9a9f556a18145d8c", "url": "https://translations.documentfoundation.org/api/units/99496132/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:41.473207Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "ERRORTYPE" ], "previous_source": "", "target": [ "TIPU.DE.ERRU" ], "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": 2017, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99150384/?format=api", "priority": 100, "id": 99496135, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=d505abebc4da25ba", "url": "https://translations.documentfoundation.org/api/units/99496135/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:41.474982Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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\">Devuelve'l númberu correspondiente a un <link href=\"text/scalc/05/02140000.xhp\">valor de fallu</link> que se produz nuna caxella distinta.</ahelp> Cola ayuda d'esti númberu, pue xenerar un testu de mensaxe de fallu." ], "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": 2018, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 28, "source_unit": "https://translations.documentfoundation.org/api/units/99150407/?format=api", "priority": 100, "id": 99496140, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=312c03dd81d55b54", "url": "https://translations.documentfoundation.org/api/units/99496140/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:41.476606Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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'estáu amuesa'l códigu de fallu predetermináu de <item type=\"productname\">%PRODUCTNAME</item> al calcar na caxella que contién l'erru." ], "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": 2019, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/99150445/?format=api", "priority": 100, "id": 99496144, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=669d4b7b3e20faed", "url": "https://translations.documentfoundation.org/api/units/99496144/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:41.478746Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "ERRORTYPE(Reference)" ], "previous_source": "", "target": [ "TIPU.DE.ERRU(referencia)" ], "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": 2020, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99150502/?format=api", "priority": 100, "id": 99496148, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=22d322eb8ca3d34b", "url": "https://translations.documentfoundation.org/api/units/99496148/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:41.480827Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<emph>Reference</emph> contains the address of the cell in which the error occurs." ], "previous_source": "", "target": [ "<emph>Referencia</emph> contién la direición de la caxella na que se produz l'erru." ], "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": 2021, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/99150546/?format=api", "priority": 100, "id": 99496151, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=2508f5530598ac40", "url": "https://translations.documentfoundation.org/api/units/99496151/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:41.482750Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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 caxella A1 amuesa l'Fallu:518, la función <item type=\"input\">=TIPU.DE.ERRU(A1)</item> devuelve'l númberu 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": 2022, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/99150583/?format=api", "priority": 100, "id": 99496155, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=9af355d3ca0d256d", "url": "https://translations.documentfoundation.org/api/units/99496155/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:41.484533Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<bookmark_value>INDEX function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>Función ÍNDICE</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": 2023, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99150619/?format=api", "priority": 100, "id": 99496159, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=4f47c89364230401", "url": "https://translations.documentfoundation.org/api/units/99496159/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:41.485862Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "INDEX" ], "previous_source": "", "target": [ "ÍNDIZ" ], "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": 2024, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99150637/?format=api", "priority": 100, "id": 99496162, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=29e166c2997532a3", "url": "https://translations.documentfoundation.org/api/units/99496162/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:41.487471Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 2025, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 38, "source_unit": "https://translations.documentfoundation.org/api/units/99150661/?format=api", "priority": 100, "id": 99496166, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=0b75bc62f47b735e", "url": "https://translations.documentfoundation.org/api/units/99496166/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:41.488977Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 2026, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 67, "source_unit": "https://translations.documentfoundation.org/api/units/99150697/?format=api", "priority": 100, "id": 99496170, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=209aa64af56056c8", "url": "https://translations.documentfoundation.org/api/units/99496170/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:41.490529Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 2027, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/99150723/?format=api", "priority": 100, "id": 99496174, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=ae3399e147821881", "url": "https://translations.documentfoundation.org/api/units/99496174/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:41.492061Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 2028, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 50, "source_unit": "https://translations.documentfoundation.org/api/units/99150747/?format=api", "priority": 100, "id": 99496177, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=c21a2ebc17acef1d", "url": "https://translations.documentfoundation.org/api/units/99496177/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:41.493469Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 2029, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 35, "source_unit": "https://translations.documentfoundation.org/api/units/99150775/?format=api", "priority": 100, "id": 99496180, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=f89a66c986326b85", "url": "https://translations.documentfoundation.org/api/units/99496180/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:41.494886Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 2030, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 34, "source_unit": "https://translations.documentfoundation.org/api/units/99150803/?format=api", "priority": 100, "id": 99496184, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=ad091dcec989af8a", "url": "https://translations.documentfoundation.org/api/units/99496184/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:41.496689Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 2031, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://translations.documentfoundation.org/api/units/99150815/?format=api", "priority": 100, "id": 99496192, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=ef9e389ef3c4aaba", "url": "https://translations.documentfoundation.org/api/units/99496192/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:41.501895Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 2032, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 17, "source_unit": "https://translations.documentfoundation.org/api/units/99150816/?format=api", "priority": 100, "id": 99496195, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=0f3fe4cbadbb2c08", "url": "https://translations.documentfoundation.org/api/units/99496195/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:41.503397Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 2033, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 28, "source_unit": "https://translations.documentfoundation.org/api/units/99150833/?format=api", "priority": 100, "id": 99496198, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=5a15cc7bc538ca72", "url": "https://translations.documentfoundation.org/api/units/99496198/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:41.504895Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 2034, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 43, "source_unit": "https://translations.documentfoundation.org/api/units/99150870/?format=api", "priority": 100, "id": 99496200, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=a38d4646bfd9e176", "url": "https://translations.documentfoundation.org/api/units/99496200/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:41.506382Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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\">=ÍNDIZ(Precios;4;1)</item> devuelve'l valor de la filera 4 y la columna 1 l'área de base de datos definíu en <emph>Datos - Definir</emph> como <emph>Precios</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": 2035, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 22, "source_unit": "https://translations.documentfoundation.org/api/units/99150912/?format=api", "priority": 100, "id": 99496203, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=f7c9af306ff3cced", "url": "https://translations.documentfoundation.org/api/units/99496203/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:41.507932Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": [ "" ], "id_hash": -3275555322380811905, "content_hash": -3275555322380811905, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3150691\nhelp.text", "note": "UFxmm", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2036, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/99150936/?format=api", "priority": 100, "id": 99496208, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=528ae3c9f75a017f", "url": "https://translations.documentfoundation.org/api/units/99496208/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:41.510970Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 2037, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/99151001/?format=api", "priority": 100, "id": 99496212, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=aed24154c29ffc06", "url": "https://translations.documentfoundation.org/api/units/99496212/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:41.513432Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 2038, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/99151060/?format=api", "priority": 100, "id": 99496219, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=cffa5417d21720cc", "url": "https://translations.documentfoundation.org/api/units/99496219/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:41.517154Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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\">=ÍNDIZ(A1:B6;1;1)</item> indica'l valor na parte cimera esquierda del área 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": 2039, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/99151086/?format=api", "priority": 100, "id": 99496222, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=4071f8661689c00d", "url": "https://translations.documentfoundation.org/api/units/99496222/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:41.562342Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 2040, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://translations.documentfoundation.org/api/units/99151115/?format=api", "priority": 100, "id": 99496225, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=6114f70caa274230", "url": "https://translations.documentfoundation.org/api/units/99496225/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:41.565045Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 2041, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/99151140/?format=api", "priority": 100, "id": 99496232, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=5523a197fa8cbaf7", "url": "https://translations.documentfoundation.org/api/units/99496232/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:41.568640Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<bookmark_value>INDIRECT function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>Función INDIRECTU</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": 2042, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99151173/?format=api", "priority": 100, "id": 99496233, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=70558a54d4557cab", "url": "https://translations.documentfoundation.org/api/units/99496233/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:41.571396Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "INDIRECT" ], "previous_source": "", "target": [ "INDIRECTU" ], "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": 2043, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99151194/?format=api", "priority": 100, "id": 99496236, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=d42bb896f3a59afd", "url": "https://translations.documentfoundation.org/api/units/99496236/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:41.573177Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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\">Devuelve la <emph>referencia</emph> especificada por una cadena de testu.</ahelp> Esta función tamién pue utilizase pa calcular l'área de la cadena correspondiente." ], "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": 2044, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 23, "source_unit": "https://translations.documentfoundation.org/api/units/99151255/?format=api", "priority": 100, "id": 99496237, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=2cec0aded9bf88a6", "url": "https://translations.documentfoundation.org/api/units/99496237/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:41.575017Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "INDIRECT(Ref [; A1])" ], "previous_source": "", "target": [ "" ], "id_hash": 2695684104847913136, "content_hash": 2695684104847913136, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3149824\nhelp.text", "note": "hDCWQ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2045, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99151285/?format=api", "priority": 100, "id": 99496239, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=a568fe69382070b0", "url": "https://translations.documentfoundation.org/api/units/99496239/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:41.576999Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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 referencia a una caxella o a una área (con formatu de testu) pa la que se devuelve'l conteníu." ], "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": 2046, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/99151320/?format=api", "priority": 100, "id": 99496243, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=f10cdcdb2dc4ca7a", "url": "https://translations.documentfoundation.org/api/units/99496243/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:41.580385Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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 definir en 0, utilízase la notación R1C1. Si falta esti parámetru o se define n'otru valor distintu a 0, utilízase la notación 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": 2047, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/99151381/?format=api", "priority": 100, "id": 99496245, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=ec5f9c610d52d1f8", "url": "https://translations.documentfoundation.org/api/units/99496245/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:41.582231Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": [ "" ], "id_hash": -9025562161285509845, "content_hash": -9025562161285509845, "location": "04060109.xhp", "context": "04060109.xhp\npar_idN10CAE\nhelp.text", "note": "5adA4", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2048, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 38, "source_unit": "https://translations.documentfoundation.org/api/units/99151423/?format=api", "priority": 100, "id": 99496256, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=02bec308a65ecd2b", "url": "https://translations.documentfoundation.org/api/units/99496256/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:41.588149Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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\">=INDIRECTA(A1)</item> ye igual a 100 si A1 contién C108 como referencia y la caxella C108 contién 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": 2049, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/99151463/?format=api", "priority": 100, "id": 99496259, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=ab044104c15c8e41", "url": "https://translations.documentfoundation.org/api/units/99496259/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:41.594492Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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(INDIRECTA(\"a1:\" & DIRECCIÓN(1;3)))</item> suma les caxelles nel área d'A1 hasta la caxella cola direición definida pola filera 1 y columna 3. Esto significa que se suma 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": 2050, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 33, "source_unit": "https://translations.documentfoundation.org/api/units/99151507/?format=api", "priority": 100, "id": 99496264, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=67bd62616f928bef", "url": "https://translations.documentfoundation.org/api/units/99496264/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:56:41.598061Z" } ] }{ "count": 8352, "next": "