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/es/units/?format=api&page=41
https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/units/?format=api&page=42", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/units/?format=api&page=40", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?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": 100429866, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=2b90a7fb82885024", "url": "https://translations.documentfoundation.org/api/units/100429866/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.064590Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?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 el resultado de un enlace basado en DDE.</ahelp> Si el contenido del área o sección enlazada se modifica, el valor devuelto también cambiará. Para ver los enlaces actualizados se debe volver a cargar la hoja de cálculo o elegir <emph>Editar ▸ Enlaces</emph>. No se permite definir enlaces entre plataformas distintas, por ejemplo enlazar desde una instalación de <item type=\"productname\">%PRODUCTNAME</item> en una máquina con Windows un documento creado en una máquina con 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": 100429871, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=4d0752ce964c278f", "url": "https://translations.documentfoundation.org/api/units/100429871/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.067324Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "DDE(\"Server\"; \"File\"; \"Range\" [; Mode])" ], "previous_source": "", "target": [ "DDE(\"Servidor\"; \"Archivo\"; \"Intervalo\" [; Modo])" ], "id_hash": 6958039810471576071, "content_hash": 6958039810471576071, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3148886\nhelp.text", "note": "JBRdm", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "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": 100429877, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=e08fec57a42f4207", "url": "https://translations.documentfoundation.org/api/units/100429877/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.070587Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<emph>Server</emph> is the name of a server application. <item type=\"productname\">%PRODUCTNAME</item> applications have the server name \"soffice\"." ], "previous_source": "", "target": [ "<emph>Servidor</emph> es el nombre de una aplicación de servidor. Las aplicaciones de <item type=\"productname\">%PRODUCTNAME</item> tienen el nombre en servidor «soffice»." ], "id_hash": -5937338882859885522, "content_hash": -5937338882859885522, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3154842\nhelp.text", "note": "qAN6x", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 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": 100429882, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=2d9a55be50059c2e", "url": "https://translations.documentfoundation.org/api/units/100429882/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.072021Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<emph>File</emph> is the complete file name, including path specification." ], "previous_source": "", "target": [ "<emph>Archivo</emph> es el nombre completo de archivo, incluida 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": 100429888, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=e586736262bdbfa7", "url": "https://translations.documentfoundation.org/api/units/100429888/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.073809Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<emph>Range</emph> is the area containing the data to be evaluated." ], "previous_source": "", "target": [ "<emph>Intervalo</emph> es el área que contiene 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": 100429893, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=05ea554ba1b83341", "url": "https://translations.documentfoundation.org/api/units/100429893/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.075229Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?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>Modo</emph> es un parámetro opcional que controla el método por el que el servidor DDE convierte sus datos en números." ], "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": 100429899, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=bbf3e7aa25a3a39d", "url": "https://translations.documentfoundation.org/api/units/100429899/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.076525Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "Mode" ], "previous_source": "", "target": [ "Modo" ], "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": 100429903, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=92f64510ca7c489d", "url": "https://translations.documentfoundation.org/api/units/100429903/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.077864Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "Effect" ], "previous_source": "", "target": [ "Efecto" ], "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": 100429907, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=98acca2b6e553a2f", "url": "https://translations.documentfoundation.org/api/units/100429907/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.078950Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "0 or missing" ], "previous_source": "", "target": [ "0 u omitido" ], "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": 100429913, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=5dfd081feecc563b", "url": "https://translations.documentfoundation.org/api/units/100429913/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.080332Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "Number format from the \"Default\" cell style" ], "previous_source": "", "target": [ "Formato numérico procedente del estilo de celda «Predeterminado»" ], "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": 100429917, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=a2c839a7a3926180", "url": "https://translations.documentfoundation.org/api/units/100429917/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.081574Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "Data are always interpreted in the standard format for US English" ], "previous_source": "", "target": [ "Los datos se interpretan siempre con el formato predeterminado para inglés de EE.UU." ], "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": 100429921, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=2c296c15d33cf526", "url": "https://translations.documentfoundation.org/api/units/100429921/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.082710Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "Data are retrieved as text; no conversion to numbers" ], "previous_source": "", "target": [ "Los datos se aceptan como texto; no se transforman en números" ], "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": 100429927, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=7a146be63dbc1806", "url": "https://translations.documentfoundation.org/api/units/100429927/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.084088Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?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": [ "<item type=\"input\">=DDE(\"soffice\";\"c:\\office\\document\\datos1.ods\";\"hoja1.A1\")</item> lee el contenido de la celda A1 de la hoja1 del libro de <item type=\"productname\">%PRODUCTNAME</item> Calc «datos1.ods»." ], "id_hash": 4335012515870683916, "content_hash": 4335012515870683916, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3148734\nhelp.text", "note": "Ae8L2", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "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": 100429931, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=bc290eea5158330c", "url": "https://translations.documentfoundation.org/api/units/100429931/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.085481Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?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": [ "<item type=\"input\">=DDE(\"soffice\";\"c:\\office\\document\\máxima.odt\";\"Máxima del día\")</item> devuelve una máxima en la celda que contiene la fórmula. Primero, debe introducir un renglón en el documento «máxima.odt» que contenga el texto de la máxima y definirlo como el primer renglón de una sección que se llame <item type=\"literal\">Máxima del día</item> (en <item type=\"productname\">%PRODUCTNAME</item> Writer vaya a <emph>Insertar ▸ Sección</emph>). Si se modifica la máxima (y se guarda) en el documento de <item type=\"productname\">%PRODUCTNAME</item> Writer, la máxima se actualiza en todas las celdas de <item type=\"productname\">%PRODUCTNAME</item> Calc en las que se defina este enlace DDE." ], "id_hash": -3384527376398056909, "content_hash": -3384527376398056909, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3153081\nhelp.text", "note": "96FU5", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "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": 100429936, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=5107be487d358233", "url": "https://translations.documentfoundation.org/api/units/100429936/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.086907Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<bookmark_value>ERRORTYPE function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>Función TIPO.DE.ERROR.OOO</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": 100429942, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=9a9f556a18145d8c", "url": "https://translations.documentfoundation.org/api/units/100429942/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.088499Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "ERRORTYPE" ], "previous_source": "", "target": [ "TIPO.DE.ERROR.OOO" ], "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": 100429947, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=d505abebc4da25ba", "url": "https://translations.documentfoundation.org/api/units/100429947/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.089602Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?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 el número correspondiente a un <link href=\"text/scalc/05/02140000.xhp\">valor de error</link> que se produce en una celda distinta.</ahelp> Con la ayuda de este número, puede generar un texto de mensaje de error." ], "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": 100429950, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=312c03dd81d55b54", "url": "https://translations.documentfoundation.org/api/units/100429950/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.090660Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?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": [ "En la barra de estado se muestra el código de error predefinido de <item type=\"productname\">%PRODUCTNAME</item> si pulsa en la celda que contiene el 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": 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": 100429954, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=669d4b7b3e20faed", "url": "https://translations.documentfoundation.org/api/units/100429954/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.092060Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "ERRORTYPE(Reference)" ], "previous_source": "", "target": [ "TIPO.DE.ERROR.OOO(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": 100429960, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=22d322eb8ca3d34b", "url": "https://translations.documentfoundation.org/api/units/100429960/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.093787Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<emph>Reference</emph> contains the address of the cell in which the error occurs." ], "previous_source": "", "target": [ "<emph>Referencia</emph> contiene la dirección de la celda en la que se produce el 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": 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": 100429965, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=2508f5530598ac40", "url": "https://translations.documentfoundation.org/api/units/100429965/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.095369Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?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 celda A1 muestra el Error:518, la función <item type=\"input\">=TIPO.DE.ERROR.OOO(A1)</item> devuelve el número 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": 100429970, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=9af355d3ca0d256d", "url": "https://translations.documentfoundation.org/api/units/100429970/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.096951Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<bookmark_value>INDEX function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>función INDICE</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": 100429976, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=4f47c89364230401", "url": "https://translations.documentfoundation.org/api/units/100429976/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.098428Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "INDEX" ], "previous_source": "", "target": [ "INDICE" ], "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": 100429980, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=29e166c2997532a3", "url": "https://translations.documentfoundation.org/api/units/100429980/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.099952Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?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": 100429986, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=0b75bc62f47b735e", "url": "https://translations.documentfoundation.org/api/units/100429986/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.101159Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?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": 100429990, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=209aa64af56056c8", "url": "https://translations.documentfoundation.org/api/units/100429990/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.102305Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?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": 100429994, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=ae3399e147821881", "url": "https://translations.documentfoundation.org/api/units/100429994/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.103401Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?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": 100429998, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=c21a2ebc17acef1d", "url": "https://translations.documentfoundation.org/api/units/100429998/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.104521Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?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": 100430002, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=f89a66c986326b85", "url": "https://translations.documentfoundation.org/api/units/100430002/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.105651Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?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": 100430006, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=ad091dcec989af8a", "url": "https://translations.documentfoundation.org/api/units/100430006/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.106701Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?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": 100430011, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=ef9e389ef3c4aaba", "url": "https://translations.documentfoundation.org/api/units/100430011/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.107832Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?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": 100430015, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=0f3fe4cbadbb2c08", "url": "https://translations.documentfoundation.org/api/units/100430015/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.108959Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?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": 100430020, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=5a15cc7bc538ca72", "url": "https://translations.documentfoundation.org/api/units/100430020/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.110535Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?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": 100430026, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=a38d4646bfd9e176", "url": "https://translations.documentfoundation.org/api/units/100430026/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.111863Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?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\">=INDICE(Precios;4;1)</item> devuelve el valor de la fila 4 y la columna 1 del intervalo de base de datos definido como <emph>Precios</emph> en <emph>Datos ▸ Definir intervalo</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": 100430030, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=f7c9af306ff3cced", "url": "https://translations.documentfoundation.org/api/units/100430030/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.113271Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?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\">=ÍNDICE(SumaX;4;1)</item> devuelve el valor del intervalo <emph>SumaX</emph> entre la fila 4 y la columna 1 como se define en <emph>Hoja ▸ Intervalos y expresiones con nombre ▸Definir</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": 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": 100430036, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=528ae3c9f75a017f", "url": "https://translations.documentfoundation.org/api/units/100430036/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.115039Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?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": 100430042, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=aed24154c29ffc06", "url": "https://translations.documentfoundation.org/api/units/100430042/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.116658Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?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": 100430046, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=cffa5417d21720cc", "url": "https://translations.documentfoundation.org/api/units/100430046/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.117901Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?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\">=INDICE(A1:B6;1;1)</item> indica el valor en la parte superior izquierda del intervalo 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": 100430052, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=4071f8661689c00d", "url": "https://translations.documentfoundation.org/api/units/100430052/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.119257Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?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": 100430058, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=6114f70caa274230", "url": "https://translations.documentfoundation.org/api/units/100430058/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.120856Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?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": 100430063, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=5523a197fa8cbaf7", "url": "https://translations.documentfoundation.org/api/units/100430063/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.122004Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<bookmark_value>INDIRECT function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>Función INDIRECTO</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": 100430068, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=70558a54d4557cab", "url": "https://translations.documentfoundation.org/api/units/100430068/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.123094Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "INDIRECT" ], "previous_source": "", "target": [ "INDIRECTO" ], "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": 100430073, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=d42bb896f3a59afd", "url": "https://translations.documentfoundation.org/api/units/100430073/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.124481Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?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 texto.</ahelp> Esta función también se puede utilizar para calcular el á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": 100430078, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=2cec0aded9bf88a6", "url": "https://translations.documentfoundation.org/api/units/100430078/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.125738Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "INDIRECT(Ref [; A1])" ], "previous_source": "", "target": [ "INDIRECTO(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": 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": 100430085, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=a568fe69382070b0", "url": "https://translations.documentfoundation.org/api/units/100430085/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.127460Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?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 celda o a un área (con formato de texto) para la que se devuelve el contenido." ], "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": 100430090, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=f10cdcdb2dc4ca7a", "url": "https://translations.documentfoundation.org/api/units/100430090/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.128737Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?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 se define en 0, se utiliza la notación R1C1. Si falta este parámetro o se define en otro valor distinto de 0, se utiliza 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": 100430095, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=ec5f9c610d52d1f8", "url": "https://translations.documentfoundation.org/api/units/100430095/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.130269Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?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 abre un libro de Excel que utiliza direcciones indirectas calculadas a partir de funciones de cadena, las direcciones de la hoja no se traducirán automáticamente. Por ejemplo, la dirección de Excel en INDIRECTO(\"[nombredearchivo]nombredehoja!\"&B1) no se convierte en la dirección de Calc en INDIRECTO(\"nombredearchivo#nombredehoja.\"&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": 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": 100430113, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=02bec308a65ecd2b", "url": "https://translations.documentfoundation.org/api/units/100430113/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.132997Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?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> es igual a 100 si A1 contiene C108 como referencia y la celda C108 contiene 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": 100430118, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=ab044104c15c8e41", "url": "https://translations.documentfoundation.org/api/units/100430118/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.140972Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?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:\" & DIRECCION(1;3)))</item> suma las celdas en el área entre A1 y la celda con la dirección definida por la fila 1 y columna 3, o, en otras palabras, se suma el intervalo 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": 100430122, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=67bd62616f928bef", "url": "https://translations.documentfoundation.org/api/units/100430122/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.143129Z" } ] }{ "count": 8352, "next": "