Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-master/textscalc01/es/units/?format=api&page=32
{ "count": 8573, "next": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/units/?format=api&page=33", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/units/?format=api&page=31", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<item type=\"input\">=ADDRESS(1;1;2;;\"Sheet2\")</item> returns the following: Sheet2.A$1" ], "previous_source": "", "target": [ "<item type=\"input\">=DIRECCION(1;1;2;;\"Hoja2\")</item> devuelve lo siguiente: Hoja2.A$1" ], "id_hash": 8915481783737849529, "content_hash": 8915481783737849529, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3148744\nhelp.text", "note": "oCjxy", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1977, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/24942014/?format=api", "priority": 100, "id": 1507184, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=fbba2772312916b9", "url": "https://translations.documentfoundation.org/api/units/1507184/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:08.081261Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "If the formula above is in cell B2 of current sheet, and the cell A1 in sheet 2 contains the value <item type=\"input\">-6</item>, you can refer indirectly to the referenced cell using a function in B2 by entering <item type=\"input\">=ABS(INDIRECT(B2))</item>. The result is the absolute value of the cell reference specified in B2, which in this case is 6." ], "previous_source": "", "target": [ "Si la fórmula anterior está en la celda B2 de la hoja actual, y la celda A1 de la hoja 2 contiene el valor <item type=\"input\">-6</item>, puede hacer referencia indirectamente a la celda de referencia utilizando una función en B2 introduciendo <item type=\"input\">=ABS(INDIRECTO(B2))</item>. El resultado es el valor absoluto de la referencia de celda especificada en B2, que en este caso es 6." ], "id_hash": -6990483334965291855, "content_hash": -6990483334965291855, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3159260\nhelp.text", "note": "zEj2o", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1978, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 59, "source_unit": "https://translations.documentfoundation.org/api/units/24942015/?format=api", "priority": 100, "id": 1507185, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=1efcd071ab1b14b1", "url": "https://translations.documentfoundation.org/api/units/1507185/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:08.093366Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<bookmark_value>AREAS function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>función AREAS</bookmark_value>" ], "id_hash": 7072070132031450786, "content_hash": 7072070132031450786, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id3150372\nhelp.text", "note": "n7RGj", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1979, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24942016/?format=api", "priority": 100, "id": 1507186, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=e2250a50ce626ea2", "url": "https://translations.documentfoundation.org/api/units/1507186/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:08.103781Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "AREAS" ], "previous_source": "", "target": [ "AREAS" ], "id_hash": -2873436012796235041, "content_hash": -2873436012796235041, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3150372\nhelp.text", "note": "BmNK5", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1980, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24942017/?format=api", "priority": 100, "id": 1507187, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=581f812ba47732df", "url": "https://translations.documentfoundation.org/api/units/1507187/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:08.115882Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_BEREICHE\">Returns the number of individual ranges that belong to a multiple range.</ahelp> A range can consist of contiguous cells or a single cell." ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_BEREICHE\">Devuelve el número de áreas individuales que pertenecen a un área múltiple.</ahelp> Un área se puede componer de celdas adyacentes o de una única celda." ], "id_hash": -2296054605787946059, "content_hash": -2296054605787946059, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3150036\nhelp.text", "note": "Bi6yp", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1981, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://translations.documentfoundation.org/api/units/24942018/?format=api", "priority": 100, "id": 1507188, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=6022c680451c23b5", "url": "https://translations.documentfoundation.org/api/units/1507188/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:08.126805Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "The function expects a single argument. If you state multiple ranges, you must enclose them into additional parentheses. Multiple ranges can be entered using the semicolon (;) as divider, but this gets automatically converted to the tilde (~) operator. The tilde is used to join ranges." ], "previous_source": "", "target": [ "La función espera un único argumento. Si define varios intervalos, debe incluirlos entre paréntesis adicionales. Se pueden especificar varios intervalos mediante un punto y coma (;), pero este se convertirá automáticamente en el operador virgulilla (~). La virgulilla se utiliza para unir intervalos." ], "id_hash": 8788259985831439169, "content_hash": 8788259985831439169, "location": "04060109.xhp", "context": "04060109.xhp\npar_id061020090307073\nhelp.text", "note": "cvDFN", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1982, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 46, "source_unit": "https://translations.documentfoundation.org/api/units/24942019/?format=api", "priority": 100, "id": 1507189, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=f9f62be519432b41", "url": "https://translations.documentfoundation.org/api/units/1507189/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:08.138661Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "AREAS(Reference)" ], "previous_source": "", "target": [ "AREAS(Referencia)" ], "id_hash": -4011799632394081583, "content_hash": -4011799632394081583, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3155907\nhelp.text", "note": "Tg8WA", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1983, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24942020/?format=api", "priority": 100, "id": 1507190, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=4853397d611baad1", "url": "https://translations.documentfoundation.org/api/units/1507190/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:08.151463Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "Reference represents the reference to a cell or cell range." ], "previous_source": "", "target": [ "La referencia es la referencia a una celda o a un área de celdas." ], "id_hash": -8385337005647716684, "content_hash": -8385337005647716684, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3153118\nhelp.text", "note": "fJLtE", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1984, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/24942021/?format=api", "priority": 100, "id": 1507191, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=0ba14c6bb86e1eb4", "url": "https://translations.documentfoundation.org/api/units/1507191/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:08.162361Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<item type=\"input\">=AREAS((A1:B3;F2;G1))</item> returns 3, as it is a reference to three cells and/or areas. After entry this gets converted to =AREAS((A1:B3~F2~G1))." ], "previous_source": "", "target": [ "<item type=\"input\">=AREAS((A1:B3;F2;G1))</item> devuelve 3, ya que es una referencia a tres celdas y/o áreas. Tras la entrada se convierte en =AREAS((A1:B3~F2~G1))." ], "id_hash": -1615880179506973561, "content_hash": -1615880179506973561, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3149946\nhelp.text", "note": "K5zS8", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1985, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://translations.documentfoundation.org/api/units/24942022/?format=api", "priority": 100, "id": 1507192, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=69933d89bce47487", "url": "https://translations.documentfoundation.org/api/units/1507192/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:08.171558Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<item type=\"input\">=AREAS(All)</item> returns 1 if you have defined an area named All under <emph>Data - Define Range</emph>." ], "previous_source": "", "target": [ "<item type=\"input\">=AREAS(Todas)</item> devuelve 1 si ha definido un área llamada «Todas» en <emph>Datos ▸ Definir intervalo</emph>." ], "id_hash": 1472854209275403689, "content_hash": 1472854209275403689, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3146820\nhelp.text", "note": "sh5wD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1986, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 17, "source_unit": "https://translations.documentfoundation.org/api/units/24942023/?format=api", "priority": 100, "id": 1507193, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=9470a1198dcc9da9", "url": "https://translations.documentfoundation.org/api/units/1507193/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:08.183206Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<bookmark_value>DDE function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>DDE</bookmark_value>" ], "id_hash": 7941482527970087483, "content_hash": 7941482527970087483, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id3148727\nhelp.text", "note": "mUP2a", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1987, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24942024/?format=api", "priority": 100, "id": 1507194, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=ee35d0488da0d23b", "url": "https://translations.documentfoundation.org/api/units/1507194/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:08.195699Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 1988, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24942025/?format=api", "priority": 100, "id": 1507195, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=2b90a7fb82885024", "url": "https://translations.documentfoundation.org/api/units/1507195/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:08.208520Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 1989, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 64, "source_unit": "https://translations.documentfoundation.org/api/units/24942026/?format=api", "priority": 100, "id": 1507196, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=4d0752ce964c278f", "url": "https://translations.documentfoundation.org/api/units/1507196/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:08.222755Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 1991, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/24942028/?format=api", "priority": 100, "id": 1507198, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=2d9a55be50059c2e", "url": "https://translations.documentfoundation.org/api/units/1507198/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:08.250912Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 1992, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/24942029/?format=api", "priority": 100, "id": 1507199, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=e586736262bdbfa7", "url": "https://translations.documentfoundation.org/api/units/1507199/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:08.263350Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 1993, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/24942030/?format=api", "priority": 100, "id": 1507200, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=05ea554ba1b83341", "url": "https://translations.documentfoundation.org/api/units/1507200/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:08.275775Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 1994, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/24942031/?format=api", "priority": 100, "id": 1507201, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=bbf3e7aa25a3a39d", "url": "https://translations.documentfoundation.org/api/units/1507201/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:08.288153Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 1997, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/24942339/?format=api", "priority": 100, "id": 1507204, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=5dfd081feecc563b", "url": "https://translations.documentfoundation.org/api/units/1507204/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:08.327344Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 1998, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/24942340/?format=api", "priority": 100, "id": 1507205, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=a2c839a7a3926180", "url": "https://translations.documentfoundation.org/api/units/1507205/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:08.342537Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 1999, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/24942342/?format=api", "priority": 100, "id": 1507207, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=2c296c15d33cf526", "url": "https://translations.documentfoundation.org/api/units/1507207/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:08.369460Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 2000, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/24942344/?format=api", "priority": 100, "id": 1507209, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=7a146be63dbc1806", "url": "https://translations.documentfoundation.org/api/units/1507209/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:08.400822Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 2001, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 17, "source_unit": "https://translations.documentfoundation.org/api/units/24942345/?format=api", "priority": 100, "id": 1507210, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=bc290eea5158330c", "url": "https://translations.documentfoundation.org/api/units/1507210/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:08.414248Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 2002, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 78, "source_unit": "https://translations.documentfoundation.org/api/units/24942346/?format=api", "priority": 100, "id": 1507211, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=5107be487d358233", "url": "https://translations.documentfoundation.org/api/units/1507211/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:08.428100Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 2003, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24942347/?format=api", "priority": 100, "id": 1507212, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=9a9f556a18145d8c", "url": "https://translations.documentfoundation.org/api/units/1507212/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:08.442002Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 2004, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24942348/?format=api", "priority": 100, "id": 1507213, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=d505abebc4da25ba", "url": "https://translations.documentfoundation.org/api/units/1507213/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:08.453716Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 2006, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/24942350/?format=api", "priority": 100, "id": 1507215, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=669d4b7b3e20faed", "url": "https://translations.documentfoundation.org/api/units/1507215/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:08.476378Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 2007, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24942351/?format=api", "priority": 100, "id": 1507216, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=22d322eb8ca3d34b", "url": "https://translations.documentfoundation.org/api/units/1507216/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:08.489596Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 2008, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/24942352/?format=api", "priority": 100, "id": 1507217, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=2508f5530598ac40", "url": "https://translations.documentfoundation.org/api/units/1507217/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:08.504291Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 2009, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/24942353/?format=api", "priority": 100, "id": 1507218, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=9af355d3ca0d256d", "url": "https://translations.documentfoundation.org/api/units/1507218/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:08.519664Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 2010, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24942354/?format=api", "priority": 100, "id": 1507219, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=4f47c89364230401", "url": "https://translations.documentfoundation.org/api/units/1507219/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:08.531712Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 2011, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24942355/?format=api", "priority": 100, "id": 1507220, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=29e166c2997532a3", "url": "https://translations.documentfoundation.org/api/units/1507220/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:08.541760Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 2022, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 22, "source_unit": "https://translations.documentfoundation.org/api/units/24942362/?format=api", "priority": 100, "id": 1507227, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=f7c9af306ff3cced", "url": "https://translations.documentfoundation.org/api/units/1507227/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:08.628334Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 2023, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/24942363/?format=api", "priority": 100, "id": 1507228, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=528ae3c9f75a017f", "url": "https://translations.documentfoundation.org/api/units/1507228/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:08.638403Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 2026, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/24942367/?format=api", "priority": 100, "id": 1507232, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=4071f8661689c00d", "url": "https://translations.documentfoundation.org/api/units/1507232/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:08.691396Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 2029, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24942369/?format=api", "priority": 100, "id": 1507234, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=70558a54d4557cab", "url": "https://translations.documentfoundation.org/api/units/1507234/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:08.716498Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 2030, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24942370/?format=api", "priority": 100, "id": 1507235, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=d42bb896f3a59afd", "url": "https://translations.documentfoundation.org/api/units/1507235/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:08.728606Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 2031, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 23, "source_unit": "https://translations.documentfoundation.org/api/units/24942371/?format=api", "priority": 100, "id": 1507236, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=2cec0aded9bf88a6", "url": "https://translations.documentfoundation.org/api/units/1507236/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:08.741093Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 2033, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/24942373/?format=api", "priority": 100, "id": 1507238, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=f10cdcdb2dc4ca7a", "url": "https://translations.documentfoundation.org/api/units/1507238/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:08.767362Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 2034, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/24942374/?format=api", "priority": 100, "id": 1507239, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=ec5f9c610d52d1f8", "url": "https://translations.documentfoundation.org/api/units/1507239/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:08.781985Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 2035, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 38, "source_unit": "https://translations.documentfoundation.org/api/units/24942375/?format=api", "priority": 100, "id": 1507240, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=02bec308a65ecd2b", "url": "https://translations.documentfoundation.org/api/units/1507240/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:08.793974Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 2036, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/24942376/?format=api", "priority": 100, "id": 1507241, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=ab044104c15c8e41", "url": "https://translations.documentfoundation.org/api/units/1507241/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:08.807244Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 2037, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 33, "source_unit": "https://translations.documentfoundation.org/api/units/24942377/?format=api", "priority": 100, "id": 1507242, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=67bd62616f928bef", "url": "https://translations.documentfoundation.org/api/units/1507242/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:08.822986Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<bookmark_value>COLUMN function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>COLUMNA</bookmark_value>" ], "id_hash": -862982028918071288, "content_hash": -862982028918071288, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id3154818\nhelp.text", "note": "T2BJo", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2039, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24942378/?format=api", "priority": 100, "id": 1507243, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=7406126abecae008", "url": "https://translations.documentfoundation.org/api/units/1507243/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:08.836064Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "COLUMN" ], "previous_source": "", "target": [ "COLUMNA" ], "id_hash": 2443648171927541574, "content_hash": 2443648171927541574, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3154818\nhelp.text", "note": "sHB7C", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2040, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24942379/?format=api", "priority": 100, "id": 1507244, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=a1e99510bbc61746", "url": "https://translations.documentfoundation.org/api/units/1507244/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:08.847962Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<emph>Reference</emph> is the reference to a cell or cell area whose first column number is to be found." ], "previous_source": "", "target": [ "<emph>Referencia</emph> es la referencia a una celda o un área de celdas cuyo número de columnas se va a buscar." ], "id_hash": 2624934417222538836, "content_hash": 2624934417222538836, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3156310\nhelp.text", "note": "CAB6L", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2043, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/24942382/?format=api", "priority": 100, "id": 1507247, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=a46da3f1e93f1654", "url": "https://translations.documentfoundation.org/api/units/1507247/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:08.884476Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "If no reference is entered, the column number of the cell in which the formula is entered is found. <item type=\"productname\">%PRODUCTNAME</item> Calc automatically sets the reference to the current cell." ], "previous_source": "", "target": [ "Si se omite la referencia, se calcula el número de columna de la celda en la que se introduce la fórmula. <item type=\"productname\">%PRODUCTNAME</item> Calc establece automáticamente la referencia a la celda actual." ], "id_hash": 1245808751497917804, "content_hash": 1245808751497917804, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3155837\nhelp.text", "note": "RHuRB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2044, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 30, "source_unit": "https://translations.documentfoundation.org/api/units/24942383/?format=api", "priority": 100, "id": 1507248, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=914a00757b1b356c", "url": "https://translations.documentfoundation.org/api/units/1507248/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:08.894155Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<item type=\"input\">=COLUMN(A1)</item> equals 1. Column A is the first column in the table." ], "previous_source": "", "target": [ "<item type=\"input\">=COLUMNA(A1)</item> es igual a 1. La columna A es la primera de la tabla." ], "id_hash": -717789900446273925, "content_hash": -717789900446273925, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3147571\nhelp.text", "note": "9iffF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2045, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/24942384/?format=api", "priority": 100, "id": 1507249, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=7609e5e378896e7b", "url": "https://translations.documentfoundation.org/api/units/1507249/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:08.905273Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<item type=\"input\">=COLUMN(C3:E3)</item> equals 3. Column C is the third column in the table." ], "previous_source": "", "target": [ "<item type=\"input\">=COLUMNA(C3:E3)</item> es igual a 3. La columna C es la tercera de la tabla." ], "id_hash": 5843269173771338390, "content_hash": 5843269173771338390, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3147079\nhelp.text", "note": "ynF5Q", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2046, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/24942385/?format=api", "priority": 100, "id": 1507250, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=d117765ac5a18296", "url": "https://translations.documentfoundation.org/api/units/1507250/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:08.918379Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<item type=\"input\">=COLUMN(D3:G10)</item> returns 4 because column D is the fourth column in the table and the COLUMN function is not used as an array formula. (In this case, the first value of the array is always used as the result.)" ], "previous_source": "", "target": [ "<item type=\"input\">=COLUMNA(D3:G10)</item> devuelve 4 porque la columna D es la cuarta columna de la tabla y la función COLUMNA no se utiliza como una fórmula matricial. En este caso, el primer valor de la matriz se utiliza siempre como el resultado." ], "id_hash": 3637248509712134828, "content_hash": 3637248509712134828, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3146861\nhelp.text", "note": "eJP98", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2047, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 40, "source_unit": "https://translations.documentfoundation.org/api/units/24942386/?format=api", "priority": 100, "id": 1507251, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=b27a1a3fa535f2ac", "url": "https://translations.documentfoundation.org/api/units/1507251/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:08.929571Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<item type=\"input\">{=COLUMN(B2:B7)}</item> and <item type=\"input\">=COLUMN(B2:B7)</item> both return 2 because the reference only contains column B as the second column in the table. Because single-column areas have only one column number, it does not make a difference whether or not the formula is used as an array formula." ], "previous_source": "", "target": [ "<item type=\"input\">{=COLUMNA(B2:B7)}</item> y <item type=\"input\">=COLUMNA(B2:B7)</item> devuelven 2 porque la referencia solo contiene la columna B como la primera columna de la tabla. Debido a que las áreas de una sola columna solo tienen un número de columna, no hay ninguna diferencia si la fórmula se utiliza como fórmula matricial o no." ], "id_hash": -5681665261762630883, "content_hash": -5681665261762630883, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3156320\nhelp.text", "note": "7pQJY", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2048, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 47, "source_unit": "https://translations.documentfoundation.org/api/units/24942387/?format=api", "priority": 100, "id": 1507252, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=3126ab8c13f62b1d", "url": "https://translations.documentfoundation.org/api/units/1507252/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:08.944013Z" } ] }