Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-master/textscalc01/es/units/?format=api&page=33
{ "count": 8573, "next": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/units/?format=api&page=34", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/units/?format=api&page=32", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<item type=\"input\">=COLUMN()</item> returns 3 if the formula was entered in column C." ], "previous_source": "", "target": [ "<item type=\"input\">=COLUMNA()</item> devuelve 3 si la fórmula se especificó en la columna C." ], "id_hash": -5375268047102608714, "content_hash": -5375268047102608714, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3150872\nhelp.text", "note": "ED6XM", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2049, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/24942388/?format=api", "priority": 100, "id": 1507253, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=35673630c7f0fab6", "url": "https://translations.documentfoundation.org/api/units/1507253/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:08.955778Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<item type=\"input\">{=COLUMN(Rabbit)}</item> returns the single-row array (3, 4) if \"Rabbit\" is the named area (C1:D3)." ], "previous_source": "", "target": [ "<item type=\"input\">{=COLUMNA(Conejo)}</item> devuelve la matriz de una fila (3, 4) si \"Conejo\" es el área con nombre (C1:D3)." ], "id_hash": 8245206584465583030, "content_hash": 8245206584465583030, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3153277\nhelp.text", "note": "vsiPD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2050, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/24942389/?format=api", "priority": 100, "id": 1507254, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=f26cdbb41ec86bb6", "url": "https://translations.documentfoundation.org/api/units/1507254/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:08.967662Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<bookmark_value>COLUMNS function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>Función COLUMNAS</bookmark_value>" ], "id_hash": 4594670014859081288, "content_hash": 4594670014859081288, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id3154643\nhelp.text", "note": "cGRsQ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2051, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24942390/?format=api", "priority": 100, "id": 1507255, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=bfc38c08efd07648", "url": "https://translations.documentfoundation.org/api/units/1507255/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:08.981965Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "COLUMNS" ], "previous_source": "", "target": [ "COLUMNAS" ], "id_hash": 4605148601445119632, "content_hash": 4605148601445119632, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3154643\nhelp.text", "note": "VF3tg", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2052, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24942391/?format=api", "priority": 100, "id": 1507256, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=bfe8c640ff05f690", "url": "https://translations.documentfoundation.org/api/units/1507256/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:08.996295Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_SPALTEN\">Returns the number of columns in the given reference.</ahelp>" ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_SPALTEN\">Devuelve el número de columnas en la referencia especificada.</ahelp>" ], "id_hash": -6672832419299237583, "content_hash": -6672832419299237583, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3151182\nhelp.text", "note": "eydFV", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2053, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/24942392/?format=api", "priority": 100, "id": 1507257, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=23655644d1f56131", "url": "https://translations.documentfoundation.org/api/units/1507257/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.008920Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "COLUMNS(Array)" ], "previous_source": "", "target": [ "COLUMNAS(Matriz)" ], "id_hash": 1178941322166737854, "content_hash": 1178941322166737854, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3154047\nhelp.text", "note": "DDKAg", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2054, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24942393/?format=api", "priority": 100, "id": 1507258, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=905c70e2dec71bbe", "url": "https://translations.documentfoundation.org/api/units/1507258/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.022743Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<emph>Array</emph> is the reference to a cell range whose total number of columns is to be found. The argument can also be a single cell." ], "previous_source": "", "target": [ "<emph>Matriz</emph> es la referencia a un intervalo de celdas cuyo número total de columnas se va a buscar. El argumento también puede ser una única celda." ], "id_hash": -4574496684817857887, "content_hash": -4574496684817857887, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3154745\nhelp.text", "note": "YUPGz", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2055, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 25, "source_unit": "https://translations.documentfoundation.org/api/units/24942394/?format=api", "priority": 100, "id": 1507259, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=40841f807b3ac2a1", "url": "https://translations.documentfoundation.org/api/units/1507259/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.037074Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<item type=\"input\">=COLUMNS(B5)</item> returns 1 because a cell only contains one column." ], "previous_source": "", "target": [ "<item type=\"input\">=COLUMNAS(B5)</item> devuelve 1 porque una celda contiene solamente una columna." ], "id_hash": 6507744520544517154, "content_hash": 6507744520544517154, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3149577\nhelp.text", "note": "dkd2t", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2056, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/24942395/?format=api", "priority": 100, "id": 1507260, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=da502729740cfc22", "url": "https://translations.documentfoundation.org/api/units/1507260/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.048634Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<item type=\"input\">=COLUMNS(A1:C5)</item> equals 3. The reference comprises three columns." ], "previous_source": "", "target": [ "<item type=\"input\">=COLUMNAS(A1:C5)</item> es igual a 3. La referencia incluye tres columnas." ], "id_hash": 3411673746354730818, "content_hash": 3411673746354730818, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3145649\nhelp.text", "note": "AyKRA", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2057, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/24942396/?format=api", "priority": 100, "id": 1507261, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=af58b3324cfff742", "url": "https://translations.documentfoundation.org/api/units/1507261/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.060336Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<item type=\"input\">=COLUMNS(Rabbit)</item> returns 2 if <item type=\"literal\">Rabbit</item> is the named range (C1:D3)." ], "previous_source": "", "target": [ "<item type=\"input\">=COLUMNAS(Conejo)</item> devuelve 2 si <item type=\"literal\">Conejo</item> es el área con nombre (C1:D3)." ], "id_hash": 8816812195949992683, "content_hash": 8816812195949992683, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3155846\nhelp.text", "note": "F9UyA", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2058, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/24942397/?format=api", "priority": 100, "id": 1507262, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=fa5b9bfa8eee5aeb", "url": "https://translations.documentfoundation.org/api/units/1507262/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.071588Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<bookmark_value>vertical search function</bookmark_value> <bookmark_value>VLOOKUP function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>función de búsqueda vertical</bookmark_value> <bookmark_value>BUSCARV</bookmark_value>" ], "id_hash": -460514873228285841, "content_hash": -460514873228285841, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id3153152\nhelp.text", "note": "G5anB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2059, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/24942398/?format=api", "priority": 100, "id": 1507263, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=799bec29a771a86f", "url": "https://translations.documentfoundation.org/api/units/1507263/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.087237Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "VLOOKUP" ], "previous_source": "", "target": [ "BUSCARV" ], "id_hash": 9082438316321787784, "content_hash": 9082438316321787784, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3153152\nhelp.text", "note": "fZRnb", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2060, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24942399/?format=api", "priority": 100, "id": 1507264, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=fe0b4d8722c1cf88", "url": "https://translations.documentfoundation.org/api/units/1507264/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.102230Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<emph>Array</emph> is the reference, which is to comprise at least as many columns as the number passed in Index argument." ], "previous_source": "", "target": [ "<emph>Matriz</emph> es la referencia, la cual debe contener como mínimo la cantidad de columnas correspondiente al número pasado en el argumento Índice." ], "id_hash": 4049811973206833510, "content_hash": 4049811973206833510, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3153884\nhelp.text", "note": "WFj5E", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2064, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/24942402/?format=api", "priority": 100, "id": 1507268, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=b833d288661df966", "url": "https://translations.documentfoundation.org/api/units/1507268/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.168921Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<emph>Index</emph> is the number of the column in the array that contains the value to be returned. The first column has the number 1." ], "previous_source": "", "target": [ "<emph>Índice</emph> es el número de la columna en la matriz que contiene el valor que se va a devolver. La primera columna tiene el número 1." ], "id_hash": 4473339114076965019, "content_hash": 4473339114076965019, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3156005\nhelp.text", "note": "tEMvM", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2065, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://translations.documentfoundation.org/api/units/24942403/?format=api", "priority": 100, "id": 1507269, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=be147e39366b089b", "url": "https://translations.documentfoundation.org/api/units/1507269/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.180555Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "You want to enter the number of a dish on the menu in cell A1, and the name of the dish is to appear as text in the neighboring cell (B1) immediately. The Number to Name assignment is contained in the D1:E100 array. D1 contains <item type=\"input\">100</item>, E1 contains the name <item type=\"input\">Vegetable Soup</item>, and so forth, for 100 menu items. The numbers in column D are sorted in ascending order; thus, the optional <item type=\"literal\">Sorted</item> parameter is not necessary." ], "previous_source": "", "target": [ "Desea escribir el número de un plato en el menú en la celda A1, de modo que el nombre del plato aparezca como texto en la celda vecina (B1). La asignación entre números y nombres está en la matriz D1:E100. D1 contiene <item type=\"input\">100</item>, E1 contiene el nombre <item type=\"input\">Sopa de vegetales</item>, y así sucesivamente para 100 elementos del menú. Los números en la columna D son ordenados de manera ascendente; por lo tanto, el parámetro opcional <item type=\"literal\">Orden</item> no es necesario." ], "id_hash": 5590887794157254537, "content_hash": 5590887794157254537, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3154129\nhelp.text", "note": "fJQRf", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2067, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 80, "source_unit": "https://translations.documentfoundation.org/api/units/24942404/?format=api", "priority": 100, "id": 1507271, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=cd96d2d3b5cf7789", "url": "https://translations.documentfoundation.org/api/units/1507271/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.218984Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "Enter the following formula in B1:" ], "previous_source": "", "target": [ "Digite la fórmula siguiente en B1:" ], "id_hash": 3302636846429914310, "content_hash": 3302636846429914310, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3145663\nhelp.text", "note": "2pTXc", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2068, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/24942405/?format=api", "priority": 100, "id": 1507272, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=add552b6b59244c6", "url": "https://translations.documentfoundation.org/api/units/1507272/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.233344Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<item type=\"input\">=VLOOKUP(A1;D1:E100;2)</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=BUSCARV(A1;D1:E100;2)</item>" ], "id_hash": -3636120927334144249, "content_hash": -3636120927334144249, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3151172\nhelp.text", "note": "W7BCf", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2069, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24942406/?format=api", "priority": 100, "id": 1507273, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=4d89e74815e26707", "url": "https://translations.documentfoundation.org/api/units/1507273/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.247892Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "As soon as you enter a number in A1 B1 will show the corresponding text contained in the second column of reference D1:E100. Entering a nonexistent number displays the text with the next number down. To prevent this, enter FALSE as the last parameter in the formula so that an error message is generated when a nonexistent number is entered." ], "previous_source": "", "target": [ "Al introducir un número en A1, en B1 aparece rápidamente el texto contenido en la segunda columna de la referencia D1:E100. Si se introduce un número inexistente, el texto que aparece es el correspondiente al número inferior más cercano. A fin de que esto no ocurra, hay que introducir un último parámetro FALSO en la fórmula de forma que en caso de introducir un número inexistente la función produzca como resultado un mensaje de error." ], "id_hash": 259841606044098307, "content_hash": 259841606044098307, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3149200\nhelp.text", "note": "oY9FV", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2070, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 60, "source_unit": "https://translations.documentfoundation.org/api/units/24942407/?format=api", "priority": 100, "id": 1507274, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=839b249062201f03", "url": "https://translations.documentfoundation.org/api/units/1507274/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.262011Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<bookmark_value>sheet numbers; looking up</bookmark_value> <bookmark_value>SHEET function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>números de hojas;buscar</bookmark_value> <bookmark_value>HOJAS</bookmark_value>" ], "id_hash": -2724982189634343269, "content_hash": -2724982189634343269, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id3153905\nhelp.text", "note": "BPHvz", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2071, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/24942408/?format=api", "priority": 100, "id": 1507275, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=5a2eeb22d7942e9b", "url": "https://translations.documentfoundation.org/api/units/1507275/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.275950Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "SHEET" ], "previous_source": "", "target": [ "SHEET" ], "id_hash": 8718762049278515776, "content_hash": 8718762049278515776, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3153905\nhelp.text", "note": "tEpv8", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2072, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24942409/?format=api", "priority": 100, "id": 1507276, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=f8ff43e3cc671a40", "url": "https://translations.documentfoundation.org/api/units/1507276/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.291801Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<emph>Reference</emph> is optional and is the reference to a cell, an area, or a sheet name string." ], "previous_source": "", "target": [ "<emph>Referencia</emph> es opcional; es la referencia a una celda, un área o una cadena de nombre de hoja." ], "id_hash": 4523632215762722536, "content_hash": 4523632215762722536, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3154588\nhelp.text", "note": "9yCD8", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2075, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 17, "source_unit": "https://translations.documentfoundation.org/api/units/24942412/?format=api", "priority": 100, "id": 1507279, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=bec72b88730cdee8", "url": "https://translations.documentfoundation.org/api/units/1507279/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.329148Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<bookmark_value>number of sheets; function</bookmark_value> <bookmark_value>SHEETS function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>número de hojas; función</bookmark_value> <bookmark_value>HOJAS</bookmark_value>" ], "id_hash": -8252590773715677554, "content_hash": -8252590773715677554, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id3148829\nhelp.text", "note": "7ZBfD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2078, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/24942414/?format=api", "priority": 100, "id": 1507281, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=0d78e86a5802ce8e", "url": "https://translations.documentfoundation.org/api/units/1507281/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.355192Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "SHEETS" ], "previous_source": "", "target": [ "HOJAS" ], "id_hash": -3688537779430513678, "content_hash": -3688537779430513678, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3148829\nhelp.text", "note": "vGLG7", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2079, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24942415/?format=api", "priority": 100, "id": 1507282, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=4ccfae6eac6fa3f2", "url": "https://translations.documentfoundation.org/api/units/1507282/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.370788Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_TABELLEN\">Determines the number of sheets in a reference.</ahelp> If you do not enter any parameters, it returns the number of sheets in the current document." ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_TABELLEN\">Determina el número de hojas de una referencia.</ahelp> Si no especifica ningún parámetro, devuelve el número de hojas del documento actual." ], "id_hash": -294850980343089500, "content_hash": -294850980343089500, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3148820\nhelp.text", "note": "A5DpQ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2080, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/24942416/?format=api", "priority": 100, "id": 1507283, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=7be87a9876f976a4", "url": "https://translations.documentfoundation.org/api/units/1507283/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.384163Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<emph>Reference</emph> is the reference to a sheet or an area. This parameter is optional." ], "previous_source": "", "target": [ "<emph>Referencia</emph> es la referencia a una hoja o área. Este parámetro es opcional." ], "id_hash": 4590120515219508661, "content_hash": 4590120515219508661, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3153060\nhelp.text", "note": "5B3KF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2082, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/24942418/?format=api", "priority": 100, "id": 1507285, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=bfb3624a01e44db5", "url": "https://translations.documentfoundation.org/api/units/1507285/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.417246Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<item type=\"input\">=SHEETS(Sheet1.A1:Sheet3.G12)</item> returns 3 if Sheet1, Sheet2, and Sheet3 exist in the sequence indicated." ], "previous_source": "", "target": [ "<item type=\"input\">=HOJAS(Hoja1.A1:Hoja3.G12)</item> devuelve 3 si Hoja1, Hoja2 y Hoja3 existen en la secuencia indicada." ], "id_hash": 4255690796962648702, "content_hash": 4255690796962648702, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3150507\nhelp.text", "note": "95EFN", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2083, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/24942419/?format=api", "priority": 100, "id": 1507286, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=bb0f403b72db927e", "url": "https://translations.documentfoundation.org/api/units/1507286/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.430395Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<bookmark_value>MATCH function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>COINCIDIR</bookmark_value>" ], "id_hash": -1826328122546240505, "content_hash": -1826328122546240505, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id3158407\nhelp.text", "note": "JB3Ps", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2084, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24942420/?format=api", "priority": 100, "id": 1507287, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=66a7943fb4534407", "url": "https://translations.documentfoundation.org/api/units/1507287/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.441794Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "MATCH" ], "previous_source": "", "target": [ "COINCIDIR" ], "id_hash": 2535335821939796260, "content_hash": 2535335821939796260, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3158407\nhelp.text", "note": "ExoT8", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2085, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24942421/?format=api", "priority": 100, "id": 1507288, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=a32f527f4d0b6924", "url": "https://translations.documentfoundation.org/api/units/1507288/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.456692Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_VERGLEICH\">Returns the relative position of an item in an array that matches a specified value.</ahelp> The function returns the position of the value found in the lookup_array as a number." ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_VERGLEICH\">Devuelve la posición relativa de un elemento de una matriz que coincide con el valor especificado.</ahelp> La función devuelve, en forma de número, la posición del valor encontrado en Matriz de búsqueda." ], "id_hash": -2486715686627209743, "content_hash": -2486715686627209743, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3154896\nhelp.text", "note": "GPfn3", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2086, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 31, "source_unit": "https://translations.documentfoundation.org/api/units/24942422/?format=api", "priority": 100, "id": 1507289, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=5d7d694219318df1", "url": "https://translations.documentfoundation.org/api/units/1507289/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.470639Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 2089, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 23, "source_unit": "https://translations.documentfoundation.org/api/units/24942425/?format=api", "priority": 100, "id": 1507292, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=41ec15c7762919aa", "url": "https://translations.documentfoundation.org/api/units/1507292/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.506969Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 2090, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 60, "source_unit": "https://translations.documentfoundation.org/api/units/24942426/?format=api", "priority": 100, "id": 1507293, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=c039e4eca569be86", "url": "https://translations.documentfoundation.org/api/units/1507293/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.517467Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 2091, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 51, "source_unit": "https://translations.documentfoundation.org/api/units/24942427/?format=api", "priority": 100, "id": 1507294, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=d3fb196911f7be84", "url": "https://translations.documentfoundation.org/api/units/1507294/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.527987Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 2093, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 55, "source_unit": "https://translations.documentfoundation.org/api/units/24942429/?format=api", "priority": 100, "id": 1507296, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=0c22cea69b2a9f57", "url": "https://translations.documentfoundation.org/api/units/1507296/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.557330Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 2094, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24942430/?format=api", "priority": 100, "id": 1507297, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=55d5bebe984582e1", "url": "https://translations.documentfoundation.org/api/units/1507297/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.570531Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 2095, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24942431/?format=api", "priority": 100, "id": 1507298, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=c3c830bba3667603", "url": "https://translations.documentfoundation.org/api/units/1507298/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.581763Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 2096, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://translations.documentfoundation.org/api/units/24942432/?format=api", "priority": 100, "id": 1507299, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=121712010579341e", "url": "https://translations.documentfoundation.org/api/units/1507299/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.592894Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 2098, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/24942434/?format=api", "priority": 100, "id": 1507301, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=54da46c1ac079464", "url": "https://translations.documentfoundation.org/api/units/1507301/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.614818Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 2099, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 25, "source_unit": "https://translations.documentfoundation.org/api/units/24942435/?format=api", "priority": 100, "id": 1507302, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=1450080ba551e2b4", "url": "https://translations.documentfoundation.org/api/units/1507302/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.624850Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 2100, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/24942436/?format=api", "priority": 100, "id": 1507303, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=585fb091d0e89703", "url": "https://translations.documentfoundation.org/api/units/1507303/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.633542Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 2101, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/24942437/?format=api", "priority": 100, "id": 1507304, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=279673d91e48800e", "url": "https://translations.documentfoundation.org/api/units/1507304/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.643919Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 2102, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/24942438/?format=api", "priority": 100, "id": 1507305, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=dcab4945ba4b9b57", "url": "https://translations.documentfoundation.org/api/units/1507305/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.653377Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 2103, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/24942439/?format=api", "priority": 100, "id": 1507306, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=ad37a73cf056a4ac", "url": "https://translations.documentfoundation.org/api/units/1507306/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.662428Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 2104, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/24942440/?format=api", "priority": 100, "id": 1507307, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=ba2a00ec89ee14f9", "url": "https://translations.documentfoundation.org/api/units/1507307/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.674184Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 2105, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 30, "source_unit": "https://translations.documentfoundation.org/api/units/24942441/?format=api", "priority": 100, "id": 1507308, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=5f1cb791bc36d2f9", "url": "https://translations.documentfoundation.org/api/units/1507308/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.684907Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 2106, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/24942708/?format=api", "priority": 100, "id": 1507309, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=75b18cc1dca3b400", "url": "https://translations.documentfoundation.org/api/units/1507309/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.693732Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 2107, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/24942709/?format=api", "priority": 100, "id": 1507310, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=b10f08b47b47e497", "url": "https://translations.documentfoundation.org/api/units/1507310/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.702438Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 2108, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/24942710/?format=api", "priority": 100, "id": 1507311, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=cc7912f8d46300f8", "url": "https://translations.documentfoundation.org/api/units/1507311/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.711434Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 2109, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/24942711/?format=api", "priority": 100, "id": 1507312, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=9ab0c6795c2314e0", "url": "https://translations.documentfoundation.org/api/units/1507312/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.724155Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 2110, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 27, "source_unit": "https://translations.documentfoundation.org/api/units/24942712/?format=api", "priority": 100, "id": 1507313, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=172ae066d40e300e", "url": "https://translations.documentfoundation.org/api/units/1507313/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.737217Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 2112, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24942714/?format=api", "priority": 100, "id": 1507315, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=e629ab3663e11751", "url": "https://translations.documentfoundation.org/api/units/1507315/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.763489Z" } ] }