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=43
{ "count": 8352, "next": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/units/?format=api&page=44", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/units/?format=api&page=42", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<emph>LookupArray</emph> is the reference searched. A lookup array can be a single row or column, or part of a single row or column." ], "previous_source": "", "target": [ "<emph>Matriz de búsqueda</emph> es la referencia buscada. Una matriz de búsqueda puede ser una sola fila o columna, o parte de una sola fila o columna." ], "id_hash": -4473176383460664918, "content_hash": -4473176383460664918, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3159167\nhelp.text", "note": "9j4xw", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2101, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 23, "source_unit": "https://translations.documentfoundation.org/api/units/99153029/?format=api", "priority": 100, "id": 100430369, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=41ec15c7762919aa", "url": "https://translations.documentfoundation.org/api/units/100430369/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.278371Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<emph>Type</emph> may take the values 1, 0, or -1. If Type = 1 or if this optional parameter is missing, it is assumed that the first column of the search array is sorted in ascending order. If Type = -1 it is assumed that the column in sorted in descending order. This corresponds to the same function in Microsoft Excel." ], "previous_source": "", "target": [ "<emph>Tipo</emph> puede tomar los valores 1, 0 o -1. Si Tipo = 1 o si falta este parámetro opcional, se asume que la primera columna de la matriz de búsqueda se ordena en orden ascendente. Si Tipo = -1, se asume que la columna se ordena en orden descendente. Esto se corresponde con la misma función en Microsoft Excel." ], "id_hash": 4627981797138480774, "content_hash": 4627981797138480774, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3147239\nhelp.text", "note": "Z4dMn", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2102, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 60, "source_unit": "https://translations.documentfoundation.org/api/units/99153060/?format=api", "priority": 100, "id": 100430375, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=c039e4eca569be86", "url": "https://translations.documentfoundation.org/api/units/100430375/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.279607Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "If Type = 0, only exact matches are found. If the search criterion is found more than once, the function returns the index of the first matching value. Only if Type = 0 can you search for regular expressions (if enabled in calculation options) or wildcards (if enabled in calculation options)." ], "previous_source": "", "target": [ "Si el Tipo equivale a 0, solo se encuentran resultados exactos. Si el criterio de búsqueda se encuentra más de una vez, la función devuelve el índice del primer valor encontrado. Solo si Tipo = 0 es posible buscar expresiones regulares (si están activadas en las opciones de cálculo) o comodines (si están activados en las opciones de cálculo)." ], "id_hash": 6051458463366102660, "content_hash": 6051458463366102660, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3154265\nhelp.text", "note": "8cpYu", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2103, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 51, "source_unit": "https://translations.documentfoundation.org/api/units/99153071/?format=api", "priority": 100, "id": 100430380, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=d3fb196911f7be84", "url": "https://translations.documentfoundation.org/api/units/100430380/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.281134Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "If Type = 1 or the third parameter is missing, the index of the last value that is smaller or equal to the search criterion is returned. For Type = -1, the index of the last value that is larger or equal is returned." ], "previous_source": "", "target": [ "Si Tipo = 1 o falta el tercer parámetro, nos devuelve el índice del último valor que sea menor o igual al criterio de búsqueda. Para Tipo = -1, nos devuelve el índice del último valor que sea mayor o igual." ], "id_hash": -270661938800531536, "content_hash": -270661938800531536, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3147528\nhelp.text", "note": "vCFkE", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2104, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 44, "source_unit": "https://translations.documentfoundation.org/api/units/99153081/?format=api", "priority": 100, "id": 100430384, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=7c3e6a66939367b0", "url": "https://translations.documentfoundation.org/api/units/100430384/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.282536Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<item type=\"input\">=MATCH(200;D1:D100)</item> searches the area D1:D100, which is sorted by column D, for the value 200. As soon as this value is reached, the number of the row in which it was found is returned. If a higher value is found during the search in the column, the number of the previous row is returned." ], "previous_source": "", "target": [ "<item type=\"input\">=COINCIDIR(200;D1:D100)</item> busca el área D1:D100, que se ordena por la columna D, para el valor 200. Tan pronto como se alcanza este valor, el devuelve el número de la fila en que se encontró. Si se encuentra un valor mayor durante la búsqueda en la columna, se devuelve el número de la fila anterior." ], "id_hash": -8348883544228323497, "content_hash": -8348883544228323497, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3155343\nhelp.text", "note": "eFMjk", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2105, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 55, "source_unit": "https://translations.documentfoundation.org/api/units/99153090/?format=api", "priority": 100, "id": 100430388, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=0c22cea69b2a9f57", "url": "https://translations.documentfoundation.org/api/units/100430388/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.283935Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<bookmark_value>OFFSET function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>DESREF</bookmark_value>" ], "id_hash": -3038312647783775519, "content_hash": -3038312647783775519, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id3158430\nhelp.text", "note": "JqPAK", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2106, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99153094/?format=api", "priority": 100, "id": 100430393, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=55d5bebe984582e1", "url": "https://translations.documentfoundation.org/api/units/100430393/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.285692Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "OFFSET" ], "previous_source": "", "target": [ "DESREF" ], "id_hash": 4884207378341721603, "content_hash": 4884207378341721603, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3158430\nhelp.text", "note": "MwiPA", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2107, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99153117/?format=api", "priority": 100, "id": 100430396, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=c3c830bba3667603", "url": "https://translations.documentfoundation.org/api/units/100430396/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.287100Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_VERSCHIEBUNG\">Returns the value of a cell offset by a certain number of rows and columns from a given reference point.</ahelp>" ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_VERSCHIEBUNG\">Devuelve el valor de una celda desplazada una determinada cantidad de filas y columnas de un punto de referencia concreto.</ahelp>" ], "id_hash": -7919841624111631330, "content_hash": -7919841624111631330, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3149167\nhelp.text", "note": "tSGCC", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2108, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://translations.documentfoundation.org/api/units/99153133/?format=api", "priority": 100, "id": 100430400, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=121712010579341e", "url": "https://translations.documentfoundation.org/api/units/100430400/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.288329Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "OFFSET(Reference; Rows; Columns [; Height [; Width]])" ], "previous_source": "", "target": [ "DESREF (Referencia; Filas; Columnas [; Altura [; Anchura]])" ], "id_hash": -6274711237888482790, "content_hash": -6274711237888482790, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3159194\nhelp.text", "note": "nED4F", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2109, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/99153164/?format=api", "priority": 100, "id": 100430406, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=28ebbf5fbd81621a", "url": "https://translations.documentfoundation.org/api/units/100430406/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.289864Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<emph>Reference</emph> is the reference from which the function searches for the new reference." ], "previous_source": "", "target": [ "<emph>Referencia</emph> es la referencia desde la que la función busca una nueva referencia." ], "id_hash": -3109094795117095836, "content_hash": -3109094795117095836, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3152360\nhelp.text", "note": "3Q5gL", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2110, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/99153191/?format=api", "priority": 100, "id": 100430410, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=54da46c1ac079464", "url": "https://translations.documentfoundation.org/api/units/100430410/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.291285Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<emph>Rows</emph> is the number of rows by which the reference was corrected up (negative value) or down. Use 0 to stay in the same row." ], "previous_source": "", "target": [ "<emph>Filas</emph> es el número de filas en que se corrigió la referencia hacia arriba (valor negativo) o hacia abajo. Se usa 0 para permanecer en la misma fila." ], "id_hash": -7759693311848095052, "content_hash": -7759693311848095052, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3156032\nhelp.text", "note": "Q5SeM", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2111, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 25, "source_unit": "https://translations.documentfoundation.org/api/units/99153218/?format=api", "priority": 100, "id": 100430414, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=1450080ba551e2b4", "url": "https://translations.documentfoundation.org/api/units/100430414/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.292868Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<emph>Columns</emph> is the number of columns by which the reference was corrected to the left (negative value) or to the right. Use 0 to stay in the same column" ], "previous_source": "", "target": [ "<emph>Columnas</emph> es el número de columnas por el cual se corrigió la referencia hacia la izquierda (valor negativo) o la derecha. Utilice 0 para quedarse en la misma columna" ], "id_hash": -2855369498407954685, "content_hash": -2855369498407954685, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3166458\nhelp.text", "note": "CEqaQ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2112, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/99153237/?format=api", "priority": 100, "id": 100430421, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=585fb091d0e89703", "url": "https://translations.documentfoundation.org/api/units/100430421/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.294550Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<emph>Height</emph> (optional) is the vertical height for an area that starts at the new reference position." ], "previous_source": "", "target": [ "<emph>Altura</emph> (opcional) es la altura vertical de un área que comienza en la nueva posición de referencia." ], "id_hash": -6370777246515822578, "content_hash": -6370777246515822578, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3150708\nhelp.text", "note": "K2dos", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2113, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/99153259/?format=api", "priority": 100, "id": 100430425, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=279673d91e48800e", "url": "https://translations.documentfoundation.org/api/units/100430425/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.296333Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<emph>Width</emph> (optional) is the horizontal width for an area that starts at the new reference position." ], "previous_source": "", "target": [ "<emph>Anchura</emph> (opcional) es la anchura horizontal de un área que comienza en la posición de referencia nueva." ], "id_hash": 6677511436333980503, "content_hash": 6677511436333980503, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3147278\nhelp.text", "note": "NEDfS", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2114, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/99153284/?format=api", "priority": 100, "id": 100430430, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=dcab4945ba4b9b57", "url": "https://translations.documentfoundation.org/api/units/100430430/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.297852Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "Arguments <emph>Rows</emph> and <emph>Columns</emph> must not lead to zero or negative start row or column." ], "previous_source": "", "target": [ "Los argumentos <emph>Filas</emph> y <emph>Columnas</emph> no deben resultar en una fila o columna inicial que dé cero o un valor negativo." ], "id_hash": 3258256735597929644, "content_hash": 3258256735597929644, "location": "04060109.xhp", "context": "04060109.xhp\npar_id8662373\nhelp.text", "note": "uQEQG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2115, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/99153308/?format=api", "priority": 100, "id": 100430434, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=ad37a73cf056a4ac", "url": "https://translations.documentfoundation.org/api/units/100430434/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.299378Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "Arguments <emph>Height</emph> and <emph>Width</emph> must not lead to zero or negative count of rows or columns." ], "previous_source": "", "target": [ "Argumentos <emph>Filas</emph> y <emph>Columnas</emph> no debe llevar a cero o un comienzo negativo de fila o columna." ], "id_hash": 4191163419148031225, "content_hash": 4191163419148031225, "location": "04060109.xhp", "context": "04060109.xhp\npar_id9051484\nhelp.text", "note": "cuFvq", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2116, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/99153340/?format=api", "priority": 100, "id": 100430439, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=ba2a00ec89ee14f9", "url": "https://translations.documentfoundation.org/api/units/100430439/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.301148Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<item type=\"input\">=OFFSET(A1;2;2)</item> returns the value in cell C3 (A1 moved by two rows and two columns down). If C3 contains the value <item type=\"input\">100</item> this function returns the value 100." ], "previous_source": "", "target": [ "<item type=\"input\">=DESREF(A1;2;2)</item> devuelve el valor en la celda C3 (A1 movida por dos filas y dos columnas hacia abajo). Si C3 contiene el valor <item type=\"input\">100</item>, esta función devuelve el valor 100." ], "id_hash": -2369817467347873031, "content_hash": -2369817467347873031, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3149744\nhelp.text", "note": "cUGMh", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2117, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 30, "source_unit": "https://translations.documentfoundation.org/api/units/99153371/?format=api", "priority": 100, "id": 100430445, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=5f1cb791bc36d2f9", "url": "https://translations.documentfoundation.org/api/units/100430445/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.302918Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<item type=\"input\">=OFFSET(B2:C3;1;1)</item> returns a reference to B2:C3 moved down by 1 row and one column to the right (C3:D4)." ], "previous_source": "", "target": [ "<item type=\"input\">=DESREF(B2:C3;1;1)</item> devuelve una referencia a B2:C3 movida abajo 1 fila y una columna a la derecha (C3:D4)." ], "id_hash": -742657699281128448, "content_hash": -742657699281128448, "location": "04060109.xhp", "context": "04060109.xhp\npar_id7439802\nhelp.text", "note": "pZtbS", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2118, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/99153428/?format=api", "priority": 100, "id": 100430450, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=75b18cc1dca3b400", "url": "https://translations.documentfoundation.org/api/units/100430450/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.304689Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<item type=\"input\">=OFFSET(B2:C3;-1;-1)</item> returns a reference to B2:C3 moved up by 1 row and one column to the left (A1:B2)." ], "previous_source": "", "target": [ "<item type=\"input\">=DESREF(B2:C3;-1;-1)</item> devuelve una referencia a B2:C3 movida arriba 1 fila y una columna a la izquierda (A1:B2)." ], "id_hash": 3535053803764573335, "content_hash": 3535053803764573335, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3009430\nhelp.text", "note": "QQGzq", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2119, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/99153500/?format=api", "priority": 100, "id": 100430457, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=b10f08b47b47e497", "url": "https://translations.documentfoundation.org/api/units/100430457/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.306469Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<item type=\"input\">=OFFSET(B2:C3;0;0;3;4)</item> returns a reference to B2:C3 resized to 3 rows and 4 columns (B2:E4)." ], "previous_source": "", "target": [ "<item type=\"input\">=DESREF(B2:C3;0;0;3;4)</item> devuelve una referencia a B2:C3 con cambio de tamaño a 3 filas y 4 columnas (B2:E4)." ], "id_hash": 5510456478988959992, "content_hash": 5510456478988959992, "location": "04060109.xhp", "context": "04060109.xhp\npar_id2629169\nhelp.text", "note": "ZngJG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2120, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/99153534/?format=api", "priority": 100, "id": 100430461, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=cc7912f8d46300f8", "url": "https://translations.documentfoundation.org/api/units/100430461/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.308083Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<item type=\"input\">=OFFSET(B2:C3;1;0;3;4)</item> returns a reference to B2:C3 moved down by one row resized to 3 rows and 4 columns (B3:E5)." ], "previous_source": "", "target": [ "<item type=\"input\">=DESREF(B2:C3;1;0;3;4)</item> devuelve una referencia a B2:C3 movida abajo una fila y con cambio de tamaño a 3 filas y 4 columnas (B3:E5)." ], "id_hash": 1923255265426347232, "content_hash": 1923255265426347232, "location": "04060109.xhp", "context": "04060109.xhp\npar_id6668599\nhelp.text", "note": "4XD3D", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2121, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/99153555/?format=api", "priority": 100, "id": 100430468, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=9ab0c6795c2314e0", "url": "https://translations.documentfoundation.org/api/units/100430468/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.309840Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<item type=\"input\">=SUM(OFFSET(A1;2;2;5;6))</item> determines the total of the area that starts in cell C3 and has a height of 5 rows and a width of 6 columns (area=C3:H7)." ], "previous_source": "", "target": [ "<item type=\"input\">=SUMA(DESREF(A1;2;2;5;6))</item> determina el total del área que comienza en la celda C3 y tiene una altura de 5 filas y una anchura de 6 columnas (área=C3:H7)." ], "id_hash": -7553978692711600114, "content_hash": -7553978692711600114, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3153739\nhelp.text", "note": "jpz9q", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2122, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 27, "source_unit": "https://translations.documentfoundation.org/api/units/99153585/?format=api", "priority": 100, "id": 100430473, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=172ae066d40e300e", "url": "https://translations.documentfoundation.org/api/units/100430473/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.313994Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "If <emph>Width</emph> or <emph>Height</emph> are given, the OFFSET function returns a cell range reference. If <emph>Reference</emph> is a single cell reference and both <emph>Width</emph> and <emph>Height</emph> are omitted, a single cell reference is returned." ], "previous_source": "", "target": [ "Si se especifican <emph>Anchura</emph> o <emph>Altura</emph>, la función DESREF devuelve una referencia a un intervalo de celdas. Si <emph>Referencia</emph> es una referencia a una única celda y se omiten tanto <emph>Anchura</emph> como <emph>Altura</emph>, se devuelve una referencia a una única celda." ], "id_hash": -7194728458143845642, "content_hash": -7194728458143845642, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3153740\nhelp.text", "note": "VCAvt", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2123, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 34, "source_unit": "https://translations.documentfoundation.org/api/units/99153634/?format=api", "priority": 100, "id": 100430476, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=1c2730962cf132f6", "url": "https://translations.documentfoundation.org/api/units/100430476/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.316124Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<bookmark_value>LOOKUP function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>BUSCAR</bookmark_value>" ], "id_hash": 7361603316006066001, "content_hash": 7361603316006066001, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id3159273\nhelp.text", "note": "AFMxC", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2124, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99153660/?format=api", "priority": 100, "id": 100430482, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=e629ab3663e11751", "url": "https://translations.documentfoundation.org/api/units/100430482/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.318428Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "LOOKUP" ], "previous_source": "", "target": [ "BUSCAR" ], "id_hash": 8655066154759884947, "content_hash": 8655066154759884947, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3159273\nhelp.text", "note": "MPjM8", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2125, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99153663/?format=api", "priority": 100, "id": 100430485, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=f81cf8cfadf81093", "url": "https://translations.documentfoundation.org/api/units/100430485/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.320218Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_VERWEIS\">Returns the contents of a cell either from a one-row or one-column range.</ahelp> Optionally, the assigned value (of the same index) is returned in a different column and row. As opposed to <link href=\"text/scalc/01/04060109.xhp#Section9\">VLOOKUP</link> and <link href=\"text/scalc/01/04060109.xhp#Section17\">HLOOKUP</link>, search and result vector may be at different positions; they do not have to be adjacent. Additionally, the search vector for the LOOKUP must be sorted ascending, otherwise the search will not return any usable results." ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_VERWEIS\">Devuelve el contenido de una celda proveniente bien de un intervalo de una sola columna o bien de uno de una sola fila.</ahelp> Facultativamente, el valor asignado (del mismo índice) se puede devolver en una columna o una fila distinta. A diferencia de <link href=\"text/scalc/01/04060109.xhp#Section9\">BUSCARV</link> y <link href=\"text/scalc/01/04060109.xhp#Section17\">BUSCARH</link>, el vector de búsqueda y de resultados puede situarse en posiciones desiguales; no tienen que ser adyacentes. Asimismo, el vector de búsquedas de BUSCAR ha de ordenarse ascendentemente, o de lo contrario la búsqueda no producirá resultados aprovechables." ], "id_hash": 1649568430919950969, "content_hash": 1649568430919950969, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3153389\nhelp.text", "note": "WYT2e", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2126, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 74, "source_unit": "https://translations.documentfoundation.org/api/units/99153698/?format=api", "priority": 100, "id": 100430489, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=96e471bf85aea279", "url": "https://translations.documentfoundation.org/api/units/100430489/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.321872Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "If LOOKUP cannot find the search criterion, it matches the largest value in the search vector that is less than or equal to the search criterion." ], "previous_source": "", "target": [ "Si BUSCAR no puede encontrar el criterio de búsqueda, utiliza el valor más grande del vector de búsqueda que sea menor que o igual al criterio de búsqueda." ], "id_hash": -3061392892454013596, "content_hash": -3061392892454013596, "location": "04060109.xhp", "context": "04060109.xhp\npar_id4484084\nhelp.text", "note": "3jevg", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2127, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/99153722/?format=api", "priority": 100, "id": 100430495, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=5583bf625f5f7564", "url": "https://translations.documentfoundation.org/api/units/100430495/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.324307Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "LOOKUP(Lookup; SearchVector [; ResultVector])" ], "previous_source": "", "target": [ "BUSCAR(CriteriodeBúsqueda; VectordeBúsqueda [; VectordeResultado])" ], "id_hash": -8386330871162544930, "content_hash": -8386330871162544930, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3154104\nhelp.text", "note": "sLcHB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2128, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/99153779/?format=api", "priority": 100, "id": 100430499, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=0b9dc4815f76dcde", "url": "https://translations.documentfoundation.org/api/units/100430499/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.326081Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<emph>Lookup</emph> is the value of any type to be looked for; entered either directly or as a reference." ], "previous_source": "", "target": [ "<emph>CriteriodeBúsqueda</emph> es el valor de cualquier tipo a buscar; introducido directamente o como referencia." ], "id_hash": 7237691220109810230, "content_hash": 7237691220109810230, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3150646\nhelp.text", "note": "yGLLE", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2129, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/99153796/?format=api", "priority": 100, "id": 100430503, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=e47171d1589bda36", "url": "https://translations.documentfoundation.org/api/units/100430503/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.327766Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<emph>SearchVector</emph> is the single-row or single-column area to be searched." ], "previous_source": "", "target": [ "<emph>VectordeBúsqueda</emph> es el área de una columna o una fila que se va a buscar." ], "id_hash": 5289312777227322, "content_hash": 5289312777227322, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3154854\nhelp.text", "note": "tFDBC", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2130, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/99153815/?format=api", "priority": 100, "id": 100430507, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=8012ca9a19314c3a", "url": "https://translations.documentfoundation.org/api/units/100430507/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.329755Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<emph>ResultVector</emph> is another single-row or single-column range from which the result of the function is taken. The result is the cell of the result vector with the same index as the instance found in the search vector." ], "previous_source": "", "target": [ "<emph>VectordeResultado</emph> es otra área de una columna o una fila desde la que se toma el resultado de la función. El resultado es la celda del vector de resultado con el mismo índice que la instancia que se encontró con el vector de búsqueda." ], "id_hash": -3957940721512948347, "content_hash": -3957940721512948347, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3149925\nhelp.text", "note": "zdXML", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2131, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 37, "source_unit": "https://translations.documentfoundation.org/api/units/99153836/?format=api", "priority": 100, "id": 100430513, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=491291e2442add85", "url": "https://translations.documentfoundation.org/api/units/100430513/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.332110Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<item type=\"input\">=LOOKUP(A1;D1:D100;F1:F100)</item> searches the corresponding cell in range D1:D100 for the number you entered in A1. For the instance found, the index is determined, for example, the 12th cell in this range. Then, the contents of the 12th cell are returned as the value of the function (in the result vector)." ], "previous_source": "", "target": [ "<item type=\"input\">=BUSCAR(A1;D1:D100;F1:F100)</item> busca la celda correspondiente en el área D1:D100 del número especificado en A1. Para la instancia encontrada, se determina el índice, por ejemplo, la celda 12 de esta área. A continuación, el contenido de la celda 12 se devuelve como el valor de la función (en el vector de resultado)." ], "id_hash": -4343587908196936134, "content_hash": -4343587908196936134, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3149809\nhelp.text", "note": "36TJv", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2132, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 51, "source_unit": "https://translations.documentfoundation.org/api/units/99153847/?format=api", "priority": 100, "id": 100430518, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=43b879cf913d563a", "url": "https://translations.documentfoundation.org/api/units/100430518/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.334349Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<bookmark_value>CHOOSE function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>Función ELEGIR</bookmark_value>" ], "id_hash": -1246532646027441510, "content_hash": -1246532646027441510, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id3150430\nhelp.text", "note": "XYxM4", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2133, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99153870/?format=api", "priority": 100, "id": 100430524, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=6eb36d29b09b4a9a", "url": "https://translations.documentfoundation.org/api/units/100430524/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.336667Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "CHOOSE" ], "previous_source": "", "target": [ "ELEGIR" ], "id_hash": 7614291423126201432, "content_hash": 7614291423126201432, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3150430\nhelp.text", "note": "eygie", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2134, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99153895/?format=api", "priority": 100, "id": 100430528, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=e9ab65b503bda458", "url": "https://translations.documentfoundation.org/api/units/100430528/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.338398Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_WAHL\">Uses an index to return a value from a list of up to 30 values.</ahelp>" ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_WAHL\">Utiliza un índice para producir un valor a partir de una lista formada por hasta 30 valores.</ahelp>" ], "id_hash": 5000394310678462495, "content_hash": 5000394310678462495, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3143270\nhelp.text", "note": "ynNz9", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2135, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/99153919/?format=api", "priority": 100, "id": 100430533, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=c564f821e0dfc01f", "url": "https://translations.documentfoundation.org/api/units/100430533/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.340112Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "CHOOSE(Index; Value 1 [; Value 2 [; ... [; Value 30]]])" ], "previous_source": "", "target": [ "ELEGIR(Índice; Valor 1 [; Valor 2 [; ... [; Valor 30]]])" ], "id_hash": -4068678915336599423, "content_hash": -4068678915336599423, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3155425\nhelp.text", "note": "V8cAu", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2136, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/99153945/?format=api", "priority": 100, "id": 100430538, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=47892615523d8881", "url": "https://translations.documentfoundation.org/api/units/100430538/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.342085Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<emph>Index</emph> is a reference or number between 1 and 30 indicating which value is to be taken from the list." ], "previous_source": "", "target": [ "<emph>Índice</emph> es una referencia o número entre 1 y 30 que indica el valor que se va a tomar de la lista." ], "id_hash": 2029050507715629929, "content_hash": 2029050507715629929, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3144755\nhelp.text", "note": "CNK7e", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2137, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/99153962/?format=api", "priority": 100, "id": 100430541, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=9c28a2afb7b75369", "url": "https://translations.documentfoundation.org/api/units/100430541/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.343593Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<emph>Value 1, Value 2, ..., Value 30</emph> is the list of values entered as a reference to a cell or as individual values." ], "previous_source": "", "target": [ "<emph>Valor 1, Valor 2, ..., Valor 30</emph> esta es la lista de valores introducidos como referencia a una celda o como valores individuales." ], "id_hash": 7994380975018243295, "content_hash": 7994380975018243295, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3149939\nhelp.text", "note": "GGWDt", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2138, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 23, "source_unit": "https://translations.documentfoundation.org/api/units/99153998/?format=api", "priority": 100, "id": 100430545, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=eef1bf24071a74df", "url": "https://translations.documentfoundation.org/api/units/100430545/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.345427Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<item type=\"input\">=CHOOSE(A1;B1;B2;B3;\"Today\";\"Yesterday\";\"Tomorrow\")</item>, for example, returns the contents of cell B2 for A1 = 2; for A1 = 4, the function returns the text \"Today\"." ], "previous_source": "", "target": [ "<item type=\"input\">=ELEGIR(A1;B1;B2;B3;\"Hoy\";\"Ayer\";\"Mañana\")</item>, por ejemplo, devuelve el contenido de la celda B2 para A1 = 2; para A1 = 4, la función devuelve el texto «Hoy»." ], "id_hash": 1169713915901438249, "content_hash": 1169713915901438249, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3150625\nhelp.text", "note": "s64Du", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2139, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://translations.documentfoundation.org/api/units/99154053/?format=api", "priority": 100, "id": 100430552, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=903ba89bee22e929", "url": "https://translations.documentfoundation.org/api/units/100430552/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.347496Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<bookmark_value>HLOOKUP function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>función BUSCARH</bookmark_value>" ], "id_hash": 837705466221852232, "content_hash": 837705466221852232, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id3151001\nhelp.text", "note": "pyC7b", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2140, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99154092/?format=api", "priority": 100, "id": 100430556, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=8ba020aee48e7648", "url": "https://translations.documentfoundation.org/api/units/100430556/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.349582Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "HLOOKUP" ], "previous_source": "", "target": [ "BUSCARH" ], "id_hash": 1011049703423366766, "content_hash": 1011049703423366766, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3151001\nhelp.text", "note": "LPUU2", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2141, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99154126/?format=api", "priority": 100, "id": 100430561, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=8e07f85936d0566e", "url": "https://translations.documentfoundation.org/api/units/100430561/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.351446Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_WVERWEIS\">Searches for a value and reference to the cells below the selected area.</ahelp> This function verifies if the first row of an array contains a certain value. The function returns then the value in a row of the array, named in the <emph>Index</emph>, in the same column." ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_WVERWEIS\">Busca un valor y una referencia a las celdas situadas por debajo del área seleccionada.</ahelp> Esta función comprueba si la primera fila de una matriz contiene un cierto valor. La función devuelve el valor situado en una fila de la matriz, indicada en <emph>Índice</emph>, en la misma columna." ], "id_hash": 8452625132990922436, "content_hash": 8452625132990922436, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3148688\nhelp.text", "note": "XtZrs", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2142, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 48, "source_unit": "https://translations.documentfoundation.org/api/units/99154164/?format=api", "priority": 100, "id": 100430565, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=f54dc1c647767ec4", "url": "https://translations.documentfoundation.org/api/units/100430565/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.352903Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "HLOOKUP(Lookup; Array; Index [; SortedRangeLookup])" ], "previous_source": "", "target": [ "BUSCARH(Búsqueda; Intervalo; Índice [; Búsqueda por intervalos ordenados])" ], "id_hash": -7751377004937243571, "content_hash": -7751377004937243571, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3146070\nhelp.text", "note": "NWzFA", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2143, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/99154201/?format=api", "priority": 100, "id": 100430570, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=146d93aebc95944d", "url": "https://translations.documentfoundation.org/api/units/100430570/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.354992Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "For an explanation on the parameters, see: <link href=\"text/scalc/01/04060109.xhp#Section9\">VLOOKUP</link> (columns and rows are exchanged)" ], "previous_source": "", "target": [ "Para una explicación de los parámetros, vea: <link href=\"text/scalc/01/04060109.xhp#Section9\">BUSCARV</link> (donde se lee filas, lea columnas y viceversa)" ], "id_hash": -1478624749447993405, "content_hash": -1478624749447993405, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3148672\nhelp.text", "note": "SQxFe", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2144, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/99154232/?format=api", "priority": 100, "id": 100430574, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=6b7ade9fdd0d27c3", "url": "https://translations.documentfoundation.org/api/units/100430574/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.356603Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "Suppose we have built a small database table occupying the cell range A1:DO4 and containing basic information about 118 chemical elements. The first column contains the row headings “Element”, “Symbol”, “Atomic Number”, and “Relative Atomic Mass”. Subsequent columns contain the relevant information for each of the elements, ordered left to right by atomic number. For example, cells B1:B4 contain “Hydrogen”, “H”, “1” and “1.008”, while cells DO1:DO4 contain “Oganesson”, “Og”, “118”, and “294”." ], "previous_source": "", "target": [ "Se tiene una pequeña tabla de base de datos en el intervalo de celdas A1:DO4, que contiene información básica sobre 118 elementos químicos. La primera columna contiene los títulos de las filas «Elemento», «Símbolo», «Número atómico» y «Masa atómica relativa». Las columnas subsecuentes contienen la información relativa a cada uno de los elementos, ordenada de izquierda a derecha por número atómico. Por ejemplo, las celdas B1:B4 contienen «Hidrógeno», «H», «1» y «1,008», en tanto que las celdas DO1:DO4 contienen «Oganesón», «Og», «118» y «294»." ], "id_hash": 4634706998389279706, "content_hash": 4634706998389279706, "location": "04060109.xhp", "context": "04060109.xhp\npar_id141612447324913\nhelp.text", "note": "vwqHz", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2145, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 73, "source_unit": "https://translations.documentfoundation.org/api/units/99154244/?format=api", "priority": 100, "id": 100430579, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=c051c97595028bda", "url": "https://translations.documentfoundation.org/api/units/100430579/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.358321Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "Element" ], "previous_source": "", "target": [ "Elemento" ], "id_hash": 2569298458541281685, "content_hash": 2569298458541281685, "location": "04060109.xhp", "context": "04060109.xhp\npar_id151612978320063\nhelp.text", "note": "eAMVa", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2146, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99154294/?format=api", "priority": 100, "id": 100430584, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=a3a7fb55d74fd195", "url": "https://translations.documentfoundation.org/api/units/100430584/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.360255Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "Hydrogen" ], "previous_source": "", "target": [ "Hidrógeno" ], "id_hash": -2956641131870373628, "content_hash": -2956641131870373628, "location": "04060109.xhp", "context": "04060109.xhp\npar_id711612450364379\nhelp.text", "note": "BcKD5", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2147, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99154318/?format=api", "priority": 100, "id": 100430588, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=56f7e68e368eb904", "url": "https://translations.documentfoundation.org/api/units/100430588/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.361474Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "Helium" ], "previous_source": "", "target": [ "Helio" ], "id_hash": -3753674292092525244, "content_hash": -3753674292092525244, "location": "04060109.xhp", "context": "04060109.xhp\npar_id681612450364379\nhelp.text", "note": "ACHPj", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2148, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99154344/?format=api", "priority": 100, "id": 100430592, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=4be8451e814f2544", "url": "https://translations.documentfoundation.org/api/units/100430592/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.362668Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "Lithium" ], "previous_source": "", "target": [ "Litio" ], "id_hash": 6395355888623892843, "content_hash": 6395355888623892843, "location": "04060109.xhp", "context": "04060109.xhp\npar_id531612453345232\nhelp.text", "note": "7YEmL", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2149, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99154391/?format=api", "priority": 100, "id": 100430596, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=d8c0de4bf1a1396b", "url": "https://translations.documentfoundation.org/api/units/100430596/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.363921Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "Oganesson" ], "previous_source": "", "target": [ "Oganesón" ], "id_hash": -6406307038623048080, "content_hash": -6406307038623048080, "location": "04060109.xhp", "context": "04060109.xhp\npar_id571612453039430\nhelp.text", "note": "Y3c6z", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2150, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99154434/?format=api", "priority": 100, "id": 100430600, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=271839b0c0c9de70", "url": "https://translations.documentfoundation.org/api/units/100430600/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.365021Z" } ] }