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=40
{ "count": 8352, "next": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/units/?format=api&page=41", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/units/?format=api&page=39", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<emph>DataX</emph> (optional) represents the X Data array." ], "previous_source": "", "target": [ "<emph>DatosX</emph> (opcional) representa la matriz de datos X." ], "id_hash": 7650661316626632940, "content_hash": 7650661316626632940, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3166411\nhelp.text", "note": "64L8f", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1951, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/99146990/?format=api", "priority": 100, "id": 100429625, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=ea2c9beeba5a50ec", "url": "https://translations.documentfoundation.org/api/units/100429625/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:54.907061Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<emph>NewDataX</emph> (optional) represents the X data array, in which the values are recalculated." ], "previous_source": "", "target": [ "<emph>NuevosDatosX</emph> (opcional) representa la matriz de datosX, en los cuales se recalculan." ], "id_hash": -2272195330068985035, "content_hash": -2272195330068985035, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3173797\nhelp.text", "note": "eabdW", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1952, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/99147028/?format=api", "priority": 100, "id": 100429629, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=60778a62caefcb35", "url": "https://translations.documentfoundation.org/api/units/100429629/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:54.908841Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<emph>FunctionType</emph> (optional). If FunctionType = 0, functions in the form y = m^x will be calculated. Otherwise, y = b*m^x functions will be calculated." ], "previous_source": "", "target": [ "<emph>TipoDeFunción</emph> (opcional). Si TipoDeFunción = 0, se calcularán las funciones de la forma y = m^x . De lo contrario, se calcularán las funciones y = b*m^x." ], "id_hash": 2968175637298422958, "content_hash": 2968175637298422958, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3173817\nhelp.text", "note": "8ojPA", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1953, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://translations.documentfoundation.org/api/units/99147052/?format=api", "priority": 100, "id": 100429635, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=a93114041c2424ae", "url": "https://translations.documentfoundation.org/api/units/100429635/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:54.910419Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "This function returns an array and is handled in the same way as the other array functions. Select a range where you want the answers to appear and select the function. Select <emph>DataY</emph>. Enter any other parameters, mark <emph>Array</emph> and click <emph>OK</emph>." ], "previous_source": "", "target": [ "Esta función devuelve una matriz y se manipula de la misma manera que otras funciones matriciales. Seleccione un intervalo donde quiera que aparezca la respuesta y seleccione la función. Seleccione <emph>DatosY</emph>. Introduzca cualquier otro parámetro, active <emph>Matriz</emph> y pulse en <emph>Aceptar</emph>." ], "id_hash": -9065211294990913229, "content_hash": -9065211294990913229, "location": "04060107.xhp", "context": "04060107.xhp\npar_id3173852\nhelp.text", "note": "unEBv", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1954, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 42, "source_unit": "https://translations.documentfoundation.org/api/units/99147072/?format=api", "priority": 100, "id": 100429639, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=0231e65b54353133", "url": "https://translations.documentfoundation.org/api/units/100429639/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:54.912035Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "Statistics Functions" ], "previous_source": "", "target": [ "Funciones estadísticas" ], "id_hash": -5897051907943278782, "content_hash": -5897051907943278782, "location": "04060108.xhp", "context": "04060108.xhp\ntit\nhelp.text", "note": "p4YTh", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1955, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99147140/?format=api", "priority": 100, "id": 100429645, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=2e2976889d005742", "url": "https://translations.documentfoundation.org/api/units/100429645/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:54.913778Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<bookmark_value>statistics functions</bookmark_value><bookmark_value>Function Wizard; statistics</bookmark_value><bookmark_value>functions; statistics functions</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>funciones estadísticas</bookmark_value><bookmark_value>Asistente para funciones;estadísticas</bookmark_value><bookmark_value>funciones;funciones estadísticas</bookmark_value>" ], "id_hash": 5755265143273233381, "content_hash": 5755265143273233381, "location": "04060108.xhp", "context": "04060108.xhp\nbm_id3153018\nhelp.text", "note": "xJyMy", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1956, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/99147171/?format=api", "priority": 100, "id": 100429651, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=cfdecf27b4fd1be5", "url": "https://translations.documentfoundation.org/api/units/100429651/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:54.915113Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<variable id=\"head_statistic\"><link href=\"text/scalc/01/04060108.xhp\">Statistics Functions</link></variable>" ], "previous_source": "", "target": [ "<variable id=\"head_statistic\"><link href=\"text/scalc/01/04060108.xhp\">Funciones estadísticas</link></variable>" ], "id_hash": -3653679829312444946, "content_hash": -3653679829312444946, "location": "04060108.xhp", "context": "04060108.xhp\nhd_id3153018\nhelp.text", "note": "EcgjZ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1957, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/99147207/?format=api", "priority": 100, "id": 100429655, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=4d4b858da2d265ee", "url": "https://translations.documentfoundation.org/api/units/100429655/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:54.916636Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<variable id=\"statistiktext\">This category contains the <emph>Statistics</emph> functions.</variable>" ], "previous_source": "", "target": [ "<variable id=\"statistiktext\">Esta categoría contiene las funciones de <emph>Estadísticas</emph>.</variable>" ], "id_hash": -5309534091528974620, "content_hash": -5309534091528974620, "location": "04060108.xhp", "context": "04060108.xhp\npar_id3157874\nhelp.text", "note": "M7Z6D", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1958, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/99147249/?format=api", "priority": 100, "id": 100429660, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=3650bedff796cee4", "url": "https://translations.documentfoundation.org/api/units/100429660/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:54.918360Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "Some of the examples use the following data table:" ], "previous_source": "", "target": [ "Algunos de los ejemplos emplean la siguiente tabla de datos:" ], "id_hash": 3110882082655944344, "content_hash": 3110882082655944344, "location": "04060108.xhp", "context": "04060108.xhp\npar_id3149001\nhelp.text", "note": "HiTED", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1959, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/99147274/?format=api", "priority": 100, "id": 100429666, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=ab2c12c5a2d5be98", "url": "https://translations.documentfoundation.org/api/units/100429666/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:54.920182Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "x value" ], "previous_source": "", "target": [ "valor x" ], "id_hash": 267449268429799975, "content_hash": 267449268429799975, "location": "04060108.xhp", "context": "04060108.xhp\npar_id3153551\nhelp.text", "note": "PeXDp", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1960, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99148018/?format=api", "priority": 100, "id": 100429672, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=83b62bb150324227", "url": "https://translations.documentfoundation.org/api/units/100429672/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:54.922228Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "y value" ], "previous_source": "", "target": [ "valor y" ], "id_hash": -3967827592908545360, "content_hash": -3967827592908545360, "location": "04060108.xhp", "context": "04060108.xhp\npar_id3147536\nhelp.text", "note": "b9ACz", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1961, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99148053/?format=api", "priority": 100, "id": 100429677, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=48ef71d3a2b162b0", "url": "https://translations.documentfoundation.org/api/units/100429677/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:54.923618Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "The statistical functions are described in the following subsections." ], "previous_source": "", "target": [ "Las funciones estadísticas se describen en las subsecciones siguientes." ], "id_hash": 7708999778292664413, "content_hash": 7708999778292664413, "location": "04060108.xhp", "context": "04060108.xhp\npar_id3156324\nhelp.text", "note": "BbE8F", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1962, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/99148078/?format=api", "priority": 100, "id": 100429683, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=eafbde744eb3085d", "url": "https://translations.documentfoundation.org/api/units/100429683/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:54.924939Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "Spreadsheet Functions" ], "previous_source": "", "target": [ "Funciones de hoja de cálculo" ], "id_hash": -2966132965479816684, "content_hash": -2966132965479816684, "location": "04060109.xhp", "context": "04060109.xhp\ntit\nhelp.text", "note": "gREzE", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1963, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99148096/?format=api", "priority": 100, "id": 100429687, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=56d62dc87bffe214", "url": "https://translations.documentfoundation.org/api/units/100429687/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:54.926015Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<bookmark_value>spreadsheets; functions</bookmark_value> <bookmark_value>Function Wizard; spreadsheets</bookmark_value> <bookmark_value>functions; spreadsheets</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>hojas de cálculo;funciones</bookmark_value> <bookmark_value>Asistente para funciones;hojas de cálculo</bookmark_value> <bookmark_value>funciones;hojas de cálculo</bookmark_value>" ], "id_hash": -2889756523113244871, "content_hash": -2889756523113244871, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id3148522\nhelp.text", "note": "WoHfE", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1964, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/99148107/?format=api", "priority": 100, "id": 100429691, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=57e585c0b8779739", "url": "https://translations.documentfoundation.org/api/units/100429691/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:54.926905Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "Spreadsheet Functions" ], "previous_source": "", "target": [ "Funciones de hoja de cálculo" ], "id_hash": 7024016505950538733, "content_hash": 7024016505950538733, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3148522\nhelp.text", "note": "qcCTY", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1965, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99148159/?format=api", "priority": 100, "id": 100429696, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=e17a51cc1da98bed", "url": "https://translations.documentfoundation.org/api/units/100429696/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:54.928034Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<variable id=\"tabelletext\">This section contains descriptions of the <emph>Spreadsheet</emph> functions together with an example.</variable>" ], "previous_source": "", "target": [ "<variable id=\"tabelletext\">Esta sección contiene descripciones de las funciones para <emph>hojas de cálculo</emph> junto con un ejemplo. </variable>" ], "id_hash": 2783587935049714885, "content_hash": 2783587935049714885, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3144508\nhelp.text", "note": "BceQk", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1966, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/99148184/?format=api", "priority": 100, "id": 100429699, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=a6a14a7a95b38cc5", "url": "https://translations.documentfoundation.org/api/units/100429699/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:54.928980Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<bookmark_value>ADDRESS function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>función DIRECCION</bookmark_value>" ], "id_hash": -4598909094892086070, "content_hash": -4598909094892086070, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id3146968\nhelp.text", "note": "aoGD9", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1967, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99148221/?format=api", "priority": 100, "id": 100429705, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=402d648b54a4dcca", "url": "https://translations.documentfoundation.org/api/units/100429705/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:54.930345Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "ADDRESS" ], "previous_source": "", "target": [ "DIRECCION" ], "id_hash": 2684530464677923973, "content_hash": 2684530464677923973, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3146968\nhelp.text", "note": "YWzqF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1968, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99148242/?format=api", "priority": 100, "id": 100429710, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=a5415e3bffd78c85", "url": "https://translations.documentfoundation.org/api/units/100429710/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:54.931654Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_ADRESSE\">Returns a cell address (reference) as text, according to the specified row and column numbers.</ahelp> You can determine whether the address is interpreted as an absolute address (for example, $A$1) or as a relative address (as A1) or in a mixed form (A$1 or $A1). You can also specify the name of the sheet." ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_ADRESSE\">Devuelve una dirección de celda (referencia) en forma de texto, según los números de fila y columna especificados.</ahelp> Se puede determinar si la dirección se interpreta como dirección absoluta (por ejemplo, $A$1), relativa (por ejemplo, A1) o mixta (A$1 o $A1). También se puede especificar el nombre de la hoja." ], "id_hash": -6346032754747434559, "content_hash": -6346032754747434559, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3155762\nhelp.text", "note": "EDZCM", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1969, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 55, "source_unit": "https://translations.documentfoundation.org/api/units/99148290/?format=api", "priority": 100, "id": 100429715, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=27ee5cd5104919c1", "url": "https://translations.documentfoundation.org/api/units/100429715/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:54.932883Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "For interoperability the ADDRESS and INDIRECT functions support an optional parameter to specify whether the R1C1 address notation instead of the usual A1 notation should be used." ], "previous_source": "", "target": [ "Por razones de interoperatividad, las funciones DIRECCION e INDIRECTO admiten un parámetro opcional para indicar si se debe utilizar la notación de dirección R1C1 en vez de la notación A1 habitual." ], "id_hash": 6500763140005585231, "content_hash": 6500763140005585231, "location": "04060109.xhp", "context": "04060109.xhp\npar_id1027200802301348\nhelp.text", "note": "hrEcs", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1970, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 27, "source_unit": "https://translations.documentfoundation.org/api/units/99148318/?format=api", "priority": 100, "id": 100429719, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=da3759a220fc614f", "url": "https://translations.documentfoundation.org/api/units/100429719/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:54.934116Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "In ADDRESS, the parameter is inserted as the fourth parameter, shifting the optional sheet name parameter to the fifth position." ], "previous_source": "", "target": [ "En DIRECCION, el parámetro se inserta como cuarto parámetro, desplazando el parámetro opcional del nombre de la hoja a la quinta posición." ], "id_hash": -911371874454514455, "content_hash": -911371874454514455, "location": "04060109.xhp", "context": "04060109.xhp\npar_id1027200802301445\nhelp.text", "note": "JJpSk", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1971, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/99148357/?format=api", "priority": 100, "id": 100429724, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=735a281bdcdb54e9", "url": "https://translations.documentfoundation.org/api/units/100429724/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:54.935276Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "In INDIRECT, the parameter is appended as the second parameter." ], "previous_source": "", "target": [ "En INDIRECTO, el parámetro se añade como el segundo parámetro." ], "id_hash": -4950075489879108756, "content_hash": -4950075489879108756, "location": "04060109.xhp", "context": "04060109.xhp\npar_id102720080230153\nhelp.text", "note": "qFesv", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1972, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/99148391/?format=api", "priority": 100, "id": 100429728, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=3b4dcc918e63536c", "url": "https://translations.documentfoundation.org/api/units/100429728/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:54.936820Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "In both functions, if the argument is inserted with the value 0, then the R1C1 notation is used. If the argument is not given or has a value other than 0, then the A1 notation is used." ], "previous_source": "", "target": [ "En ambas funciones, si se inserta el argumento con el valor 0, se utiliza la notación R1C1. Si no se da el argumento o tiene un valor que no sea el 0, entonces se usa la notación A1." ], "id_hash": -2075736064795905404, "content_hash": -2075736064795905404, "location": "04060109.xhp", "context": "04060109.xhp\npar_id102720080230151\nhelp.text", "note": "gvGjb", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1973, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 37, "source_unit": "https://translations.documentfoundation.org/api/units/99148449/?format=api", "priority": 100, "id": 100429732, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=6331810bfa5f7284", "url": "https://translations.documentfoundation.org/api/units/100429732/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:54.938179Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "In case of R1C1 notation, ADDRESS returns address strings using the exclamation mark '!' as the sheet name separator, and INDIRECT expects the exclamation mark as sheet name separator. Both functions still use the dot '.' sheet name separator with A1 notation." ], "previous_source": "", "target": [ "En el caso de la notación R1C1, DIRECCION devuelve cadenas de dirección utilizando el signo de exclamación «!» como separador de los nombres de las hojas; INDIRECTO espera este signo. Ambas funciones aún utilizan el punto «.» como separador de nombres de hojas cuando se emplea la notación A1." ], "id_hash": 1709027029175537816, "content_hash": 1709027029175537816, "location": "04060109.xhp", "context": "04060109.xhp\npar_id1027200802301556\nhelp.text", "note": "S5Du7", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1974, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 42, "source_unit": "https://translations.documentfoundation.org/api/units/99148509/?format=api", "priority": 100, "id": 100429735, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=97b7af07398c9098", "url": "https://translations.documentfoundation.org/api/units/100429735/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:54.939503Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "When opening documents from ODF 1.0/1.1 format, the ADDRESS functions that show a sheet name as the fourth parameter will shift that sheet name to become the fifth parameter. A new fourth parameter with the value 1 will be inserted." ], "previous_source": "", "target": [ "Al abrir documentos con el formato ODF 1.0/1.1, las funciones de DIRECCION que muestran un nombre de hoja como el cuarto parámetro trasladarán este nombre de hoja para convertirlo en un quinto parámetro. Se insertará un cuarto parámetro nuevo con el valor de 1." ], "id_hash": -1059518466302375336, "content_hash": -1059518466302375336, "location": "04060109.xhp", "context": "04060109.xhp\npar_id1027200802301521\nhelp.text", "note": "tBvLY", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1975, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 40, "source_unit": "https://translations.documentfoundation.org/api/units/99148545/?format=api", "priority": 100, "id": 100429738, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=714bd59187148a58", "url": "https://translations.documentfoundation.org/api/units/100429738/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:54.940910Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "When storing a document in ODF 1.0/1.1 format, if ADDRESS functions have a fourth parameter, that parameter will be removed." ], "previous_source": "", "target": [ "Cuando se almacena un documento en formato ODF 1.0/1.1, si la función DIRECCION tiene un cuarto parámetro, este parámetro se eliminará." ], "id_hash": -8055874548874886449, "content_hash": -8055874548874886449, "location": "04060109.xhp", "context": "04060109.xhp\npar_id1027200802301650\nhelp.text", "note": "NGGAw", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1976, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/99148583/?format=api", "priority": 100, "id": 100429744, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=1033c8c79733c2cf", "url": "https://translations.documentfoundation.org/api/units/100429744/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:54.942326Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "Do not save a spreadsheet in the old ODF 1.0/1.1 format if the ADDRESS function's new fourth parameter was used with a value of 0." ], "previous_source": "", "target": [ "No guarde el libro en el formato antiguo ODF 1.0/1.1 si se ha utilizado el cuarto parámetro de la función DIRECCION con un valor de 0." ], "id_hash": 8115260084259178319, "content_hash": 8115260084259178319, "location": "04060109.xhp", "context": "04060109.xhp\npar_id102720080230162\nhelp.text", "note": "Ag8KD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1977, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 25, "source_unit": "https://translations.documentfoundation.org/api/units/99148618/?format=api", "priority": 100, "id": 100429749, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=f09f320cd62cc74f", "url": "https://translations.documentfoundation.org/api/units/100429749/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:54.943748Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "The INDIRECT function is saved without conversion to ODF 1.0/1.1 format. If the second parameter was present, an older version of Calc will return an error for that function." ], "previous_source": "", "target": [ "La función INDIRECTO se guarda sin conversión al formato ODF 1.0/1.1. Si está presente el segundo parámetro, una versión antigua de Calc devolverá un error para esa función." ], "id_hash": 3590831610914499776, "content_hash": 3590831610914499776, "location": "04060109.xhp", "context": "04060109.xhp\npar_id1027200802301756\nhelp.text", "note": "d2kpf", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1978, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/99148647/?format=api", "priority": 100, "id": 100429755, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=b1d5325338cd6cc0", "url": "https://translations.documentfoundation.org/api/units/100429755/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:54.945177Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "ADDRESS(Row; Column [; Abs [; A1 [; \"Sheet\"]]])" ], "previous_source": "", "target": [ "DIRECCION(Fila; Columna [; Abs [; A1 [; \"Hoja\"]]])" ], "id_hash": 987991828813510454, "content_hash": 987991828813510454, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3154707\nhelp.text", "note": "TgFFT", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1979, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/99148700/?format=api", "priority": 100, "id": 100429760, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=8db60d556d6af736", "url": "https://translations.documentfoundation.org/api/units/100429760/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:54.946746Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<emph>Row</emph> represents the row number for the cell reference" ], "previous_source": "", "target": [ "<emph>Fila</emph> representa el número de fila de la referencia de celda." ], "id_hash": 5088181695370283547, "content_hash": 5088181695370283547, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3147505\nhelp.text", "note": "FyoLc", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1980, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/99148757/?format=api", "priority": 100, "id": 100429766, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=c69cda4b2930ca1b", "url": "https://translations.documentfoundation.org/api/units/100429766/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:54.948059Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<emph>Column</emph> represents the column number for the cell reference (the number, not the letter)" ], "previous_source": "", "target": [ "<emph>Columna</emph> representa el número de columna de la referencia de la celda (el número, no la letra)." ], "id_hash": -6237596525700379609, "content_hash": -6237596525700379609, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3145323\nhelp.text", "note": "AEorU", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1981, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/99148821/?format=api", "priority": 100, "id": 100429773, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=296f9b02116b0c27", "url": "https://translations.documentfoundation.org/api/units/100429773/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:54.949587Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<emph>Abs</emph> determines the type of reference:" ], "previous_source": "", "target": [ "<emph>Abs</emph> determina el tipo de referencia:" ], "id_hash": 8889697732632519959, "content_hash": 8889697732632519959, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3153074\nhelp.text", "note": "8VYFW", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1982, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/99148866/?format=api", "priority": 100, "id": 100429780, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=fb5e8cfcfa282517", "url": "https://translations.documentfoundation.org/api/units/100429780/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:54.951909Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "1: absolute ($A$1)" ], "previous_source": "", "target": [ "1: absoluto ($A$1)" ], "id_hash": 4950740850650695570, "content_hash": 4950740850650695570, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3153298\nhelp.text", "note": "EEfQf", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1983, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99148901/?format=api", "priority": 100, "id": 100429786, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=c4b49092d20cc792", "url": "https://translations.documentfoundation.org/api/units/100429786/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:54.953421Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "2: row reference type is absolute; column reference is relative (A$1)" ], "previous_source": "", "target": [ "2: Fila absoluta; Columna relativa (A$1)" ], "id_hash": -8926242809178159723, "content_hash": -8926242809178159723, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3150431\nhelp.text", "note": "jNcJG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1984, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/99148930/?format=api", "priority": 100, "id": 100429791, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=041f9d75540d0595", "url": "https://translations.documentfoundation.org/api/units/100429791/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:54.954677Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "3: row (relative); column (absolute) ($A1)" ], "previous_source": "", "target": [ "3: fila (relativa); columna (absoluta) ($A1)" ], "id_hash": 9140721639584882894, "content_hash": 9140721639584882894, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3146096\nhelp.text", "note": "KXVHa", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1985, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/99149028/?format=api", "priority": 100, "id": 100429795, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=feda5de6ce2ee0ce", "url": "https://translations.documentfoundation.org/api/units/100429795/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:54.955814Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "4: relative (A1)" ], "previous_source": "", "target": [ "4: Relativa (A1)" ], "id_hash": -8521629544004173645, "content_hash": -8521629544004173645, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3153334\nhelp.text", "note": "AeGMD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1986, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99149056/?format=api", "priority": 100, "id": 100429799, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=09bd17144a2840b3", "url": "https://translations.documentfoundation.org/api/units/100429799/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:54.956718Z" }, { "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": -7379494026329237918, "content_hash": -7379494026329237918, "location": "04060109.xhp", "context": "04060109.xhp\npar_id1027200802465915\nhelp.text", "note": "3BFnh", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1987, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/99149080/?format=api", "priority": 100, "id": 100429803, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=1996c54802875662", "url": "https://translations.documentfoundation.org/api/units/100429803/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:54.957571Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<emph>Sheet</emph> represents the name of the sheet. It must be placed in double quotes." ], "previous_source": "", "target": [ "<emph>Hoja</emph> representa el nombre de la hoja. Debe ir entre comillas dobles." ], "id_hash": -8090009019137561493, "content_hash": -8090009019137561493, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3153962\nhelp.text", "note": "R2QXf", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1988, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/99149104/?format=api", "priority": 100, "id": 100429808, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=0fba83a8e8996c6b", "url": "https://translations.documentfoundation.org/api/units/100429808/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:54.958666Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "Example:" ], "previous_source": "", "target": [ "Ejemplo:" ], "id_hash": 6158664688613790099, "content_hash": 6158664688613790099, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3147299\nhelp.text", "note": "3eSyo", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1989, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99149146/?format=api", "priority": 100, "id": 100429813, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=d577f8e77f911193", "url": "https://translations.documentfoundation.org/api/units/100429813/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:54.959671Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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": 1990, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/99149221/?format=api", "priority": 100, "id": 100429817, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=fbba2772312916b9", "url": "https://translations.documentfoundation.org/api/units/100429817/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:54.960595Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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": 1991, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 59, "source_unit": "https://translations.documentfoundation.org/api/units/99149264/?format=api", "priority": 100, "id": 100429821, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=1efcd071ab1b14b1", "url": "https://translations.documentfoundation.org/api/units/100429821/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:54.961623Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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": 1992, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99149298/?format=api", "priority": 100, "id": 100429827, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=e2250a50ce626ea2", "url": "https://translations.documentfoundation.org/api/units/100429827/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:54.963024Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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": 1993, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99149331/?format=api", "priority": 100, "id": 100429831, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=581f812ba47732df", "url": "https://translations.documentfoundation.org/api/units/100429831/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:54.964053Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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": 1994, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://translations.documentfoundation.org/api/units/99149368/?format=api", "priority": 100, "id": 100429835, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=6022c680451c23b5", "url": "https://translations.documentfoundation.org/api/units/100429835/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:54.965014Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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": 1995, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 46, "source_unit": "https://translations.documentfoundation.org/api/units/99149409/?format=api", "priority": 100, "id": 100429839, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=f9f62be519432b41", "url": "https://translations.documentfoundation.org/api/units/100429839/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:54.966246Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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": 1996, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99149440/?format=api", "priority": 100, "id": 100429843, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=4853397d611baad1", "url": "https://translations.documentfoundation.org/api/units/100429843/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:54.967463Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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": 1997, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/99149470/?format=api", "priority": 100, "id": 100429848, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=0ba14c6bb86e1eb4", "url": "https://translations.documentfoundation.org/api/units/100429848/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:54.968445Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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": 1998, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://translations.documentfoundation.org/api/units/99149526/?format=api", "priority": 100, "id": 100429853, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=69933d89bce47487", "url": "https://translations.documentfoundation.org/api/units/100429853/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:54.969544Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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": 1999, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 17, "source_unit": "https://translations.documentfoundation.org/api/units/99149559/?format=api", "priority": 100, "id": 100429857, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=9470a1198dcc9da9", "url": "https://translations.documentfoundation.org/api/units/100429857/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:54.970804Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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": 2000, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99149591/?format=api", "priority": 100, "id": 100429861, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=ee35d0488da0d23b", "url": "https://translations.documentfoundation.org/api/units/100429861/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:54.971923Z" } ] }