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=42
{ "count": 8352, "next": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/units/?format=api&page=43", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/units/?format=api&page=41", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<bookmark_value>COLUMN function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>COLUMNA</bookmark_value>" ], "id_hash": -862982028918071288, "content_hash": -862982028918071288, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id3154818\nhelp.text", "note": "T2BJo", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2051, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99151550/?format=api", "priority": 100, "id": 100430127, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=7406126abecae008", "url": "https://translations.documentfoundation.org/api/units/100430127/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.145520Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "COLUMN" ], "previous_source": "", "target": [ "COLUMNA" ], "id_hash": 2443648171927541574, "content_hash": 2443648171927541574, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3154818\nhelp.text", "note": "sHB7C", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2052, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99151590/?format=api", "priority": 100, "id": 100430133, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=a1e99510bbc61746", "url": "https://translations.documentfoundation.org/api/units/100430133/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.147587Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_SPALTE\">Returns the column number of a cell reference.</ahelp> If the reference is a cell the column number of the cell is returned; if the parameter is a cell area, the corresponding column numbers are returned in a single-row <link href=\"text/scalc/01/04060107.xhp#wasmatrix\">array</link> if the formula is entered <link href=\"text/scalc/01/04060107.xhp#creating_array_formulas\">as an array formula</link>. If the COLUMN function with an area reference parameter is not used for an array formula, only the column number of the first cell within the area is determined." ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_SPALTE\">Devuelve el número de columna de una referencia a una celda.</ahelp> Si la referencia corresponde a una celda, se devuelve el número de columna de esta; si el parámetro es un intervalo de celdas, se devuelven los números correspondientes al área como <link href=\"text/scalc/01/04060107.xhp#wasmatrix\">matriz</link> de una fila, si la fórmula se introduce <link href=\"text/scalc/01/04060107.xhp#creating_array_formulas\">como fórmula matricial</link>. Si la función COLUMNA no se utiliza con un parámetro de referencia de intervalo para una fórmula matricial, solo se determina el número de la columna de la primera celda del intervalo." ], "id_hash": 2955182560504194790, "content_hash": 2955182560504194790, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3149711\nhelp.text", "note": "Kj3xA", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2053, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 80, "source_unit": "https://translations.documentfoundation.org/api/units/99151633/?format=api", "priority": 100, "id": 100430139, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=a902eae1ad4826e6", "url": "https://translations.documentfoundation.org/api/units/100430139/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.149507Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "COLUMN([Reference])" ], "previous_source": "", "target": [ "COLUMNA([Referencia])" ], "id_hash": -3401701009952994570, "content_hash": -3401701009952994570, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3149447\nhelp.text", "note": "poCRX", "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/99151656/?format=api", "priority": 100, "id": 100430144, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=50cabaf455aa0af6", "url": "https://translations.documentfoundation.org/api/units/100430144/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.152186Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<emph>Reference</emph> is the reference to a cell or cell area whose first column number is to be found." ], "previous_source": "", "target": [ "<emph>Referencia</emph> es la referencia a una celda o un área de celdas cuyo número de columnas se va a buscar." ], "id_hash": 2624934417222538836, "content_hash": 2624934417222538836, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3156310\nhelp.text", "note": "CAB6L", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2055, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/99151702/?format=api", "priority": 100, "id": 100430148, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=a46da3f1e93f1654", "url": "https://translations.documentfoundation.org/api/units/100430148/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.153860Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "If no reference is entered, the column number of the cell in which the formula is entered is found. <item type=\"productname\">%PRODUCTNAME</item> Calc automatically sets the reference to the current cell." ], "previous_source": "", "target": [ "Si se omite la referencia, se calcula el número de columna de la celda en la que se introduce la fórmula. <item type=\"productname\">%PRODUCTNAME</item> Calc establece automáticamente la referencia a la celda actual." ], "id_hash": 1245808751497917804, "content_hash": 1245808751497917804, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3155837\nhelp.text", "note": "RHuRB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2056, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 30, "source_unit": "https://translations.documentfoundation.org/api/units/99151737/?format=api", "priority": 100, "id": 100430152, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=914a00757b1b356c", "url": "https://translations.documentfoundation.org/api/units/100430152/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.155838Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<item type=\"input\">=COLUMN(A1)</item> equals 1. Column A is the first column in the table." ], "previous_source": "", "target": [ "<item type=\"input\">=COLUMNA(A1)</item> es igual a 1. La columna A es la primera de la tabla." ], "id_hash": -717789900446273925, "content_hash": -717789900446273925, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3147571\nhelp.text", "note": "9iffF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2057, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/99151768/?format=api", "priority": 100, "id": 100430158, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=7609e5e378896e7b", "url": "https://translations.documentfoundation.org/api/units/100430158/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.158130Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<item type=\"input\">=COLUMN(C3:E3)</item> equals 3. Column C is the third column in the table." ], "previous_source": "", "target": [ "<item type=\"input\">=COLUMNA(C3:E3)</item> es igual a 3. La columna C es la tercera de la tabla." ], "id_hash": 5843269173771338390, "content_hash": 5843269173771338390, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3147079\nhelp.text", "note": "ynF5Q", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2058, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/99151794/?format=api", "priority": 100, "id": 100430164, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=d117765ac5a18296", "url": "https://translations.documentfoundation.org/api/units/100430164/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.160267Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<item type=\"input\">=COLUMN(D3:G10)</item> returns 4 because column D is the fourth column in the table and the COLUMN function is not used as an array formula. (In this case, the first value of the array is always used as the result.)" ], "previous_source": "", "target": [ "<item type=\"input\">=COLUMNA(D3:G10)</item> devuelve 4 porque la columna D es la cuarta columna de la tabla y la función COLUMNA no se utiliza como una fórmula matricial. En este caso, el primer valor de la matriz se utiliza siempre como el resultado." ], "id_hash": 3637248509712134828, "content_hash": 3637248509712134828, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3146861\nhelp.text", "note": "eJP98", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2059, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 40, "source_unit": "https://translations.documentfoundation.org/api/units/99151827/?format=api", "priority": 100, "id": 100430168, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=b27a1a3fa535f2ac", "url": "https://translations.documentfoundation.org/api/units/100430168/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.162205Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<item type=\"input\">{=COLUMN(B2:B7)}</item> and <item type=\"input\">=COLUMN(B2:B7)</item> both return 2 because the reference only contains column B as the second column in the table. Because single-column areas have only one column number, it does not make a difference whether or not the formula is used as an array formula." ], "previous_source": "", "target": [ "<item type=\"input\">{=COLUMNA(B2:B7)}</item> y <item type=\"input\">=COLUMNA(B2:B7)</item> devuelven 2 porque la referencia solo contiene la columna B como la primera columna de la tabla. Debido a que las áreas de una sola columna solo tienen un número de columna, no hay ninguna diferencia si la fórmula se utiliza como fórmula matricial o no." ], "id_hash": -5681665261762630883, "content_hash": -5681665261762630883, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3156320\nhelp.text", "note": "7pQJY", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2060, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 47, "source_unit": "https://translations.documentfoundation.org/api/units/99151848/?format=api", "priority": 100, "id": 100430174, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=3126ab8c13f62b1d", "url": "https://translations.documentfoundation.org/api/units/100430174/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.164129Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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": 2061, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/99151869/?format=api", "priority": 100, "id": 100430180, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=35673630c7f0fab6", "url": "https://translations.documentfoundation.org/api/units/100430180/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.166202Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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": 2062, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/99151885/?format=api", "priority": 100, "id": 100430186, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=f26cdbb41ec86bb6", "url": "https://translations.documentfoundation.org/api/units/100430186/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.167464Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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": 2063, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99151919/?format=api", "priority": 100, "id": 100430190, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=bfc38c08efd07648", "url": "https://translations.documentfoundation.org/api/units/100430190/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.168875Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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": 2064, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99151932/?format=api", "priority": 100, "id": 100430194, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=bfe8c640ff05f690", "url": "https://translations.documentfoundation.org/api/units/100430194/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.169999Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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": 2065, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/99151953/?format=api", "priority": 100, "id": 100430197, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=23655644d1f56131", "url": "https://translations.documentfoundation.org/api/units/100430197/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.170917Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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": 2066, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99151967/?format=api", "priority": 100, "id": 100430202, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=905c70e2dec71bbe", "url": "https://translations.documentfoundation.org/api/units/100430202/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.171935Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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": 2067, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 25, "source_unit": "https://translations.documentfoundation.org/api/units/99151968/?format=api", "priority": 100, "id": 100430206, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=40841f807b3ac2a1", "url": "https://translations.documentfoundation.org/api/units/100430206/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.172877Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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": 2068, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/99151969/?format=api", "priority": 100, "id": 100430210, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=da502729740cfc22", "url": "https://translations.documentfoundation.org/api/units/100430210/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.174004Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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": 2069, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/99151970/?format=api", "priority": 100, "id": 100430214, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=af58b3324cfff742", "url": "https://translations.documentfoundation.org/api/units/100430214/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.174992Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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": 2070, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/99151971/?format=api", "priority": 100, "id": 100430216, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=fa5b9bfa8eee5aeb", "url": "https://translations.documentfoundation.org/api/units/100430216/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.221856Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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": 2071, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/99152008/?format=api", "priority": 100, "id": 100430219, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=799bec29a771a86f", "url": "https://translations.documentfoundation.org/api/units/100430219/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.225012Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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": 2072, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99152032/?format=api", "priority": 100, "id": 100430223, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=fe0b4d8722c1cf88", "url": "https://translations.documentfoundation.org/api/units/100430223/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.227250Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_SVERWEIS\">Vertical search with reference to adjacent cells to the right.</ahelp> This function checks if a specific value is contained in the first column of an array. The function then returns the value in the same row of the column named by <emph>Index</emph>. If the <emph>Sorted</emph> parameter is omitted or set to TRUE or one, it is assumed that the data is sorted in ascending order. In this case, if the exact <emph>Lookup</emph> is not found, the last value that is smaller than the criterion will be returned. If <emph>Sorted</emph> is set to FALSE or zero, an exact match must be found, otherwise the error <emph>Error: Value Not Available</emph> will be the result. Thus with a value of zero the data does not need to be sorted in ascending order." ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_SVERWEIS\">Búsqueda vertical con referencia a celdas adyacentes a la derecha.</ahelp> Esta función comprueba si un valor específico está contenido en la primera columna de una matriz. La función devuelve entonces el valor en la misma fila de la columna nombrada por <emph>Indice</emph>. Si el parámetro <emph>Ordenado</emph> se omite o se pone a VERDADERO o a uno, se supone que los datos están ordenados de forma ascendente. En este caso, si no se encuentra la <emph>Búsqueda</emph> exacta, se devolverá el último valor que sea menor que el criterio. Si <emph>Ordenado</emph> se establece en FALSO o en cero, se debe encontrar una coincidencia exacta, de lo contrario se producirá el error <emph>Error: Valor no disponible</emph> será el resultado. Por lo tanto, con un valor de cero no es necesario ordenar los datos en orden ascendente." ], "id_hash": 1344072553765718025, "content_hash": 1344072553765718025, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3149984\nhelp.text", "note": "qFEgu", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2073, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 130, "source_unit": "https://translations.documentfoundation.org/api/units/99152037/?format=api", "priority": 100, "id": 100430226, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=92a71addcf8ec809", "url": "https://translations.documentfoundation.org/api/units/100430226/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.229128Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "=VLOOKUP(Lookup; Array; Index [; SortedRangeLookup])" ], "previous_source": "", "target": [ "=BUSCARV(Búsqueda; Matriz; Índice [; Búsqueda por intervalos ordenados])" ], "id_hash": -1404160986737100578, "content_hash": -1404160986737100578, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3150156\nhelp.text", "note": "j8RoY", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2074, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/99152051/?format=api", "priority": 100, "id": 100430233, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=6c836b05aa12b8de", "url": "https://translations.documentfoundation.org/api/units/100430233/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.231860Z" }, { "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 looked for in the first column of the array." ], "previous_source": "", "target": [ "<emph>Buscar</emph> es el valor de cualquier tipo buscado en la primera columna de la matriz." ], "id_hash": -4100685287716172017, "content_hash": -4100685287716172017, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3149289\nhelp.text", "note": "LDrCq", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2075, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/99152072/?format=api", "priority": 100, "id": 100430236, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=471770750a01cf0f", "url": "https://translations.documentfoundation.org/api/units/100430236/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.233550Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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": 2076, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/99152101/?format=api", "priority": 100, "id": 100430240, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=b833d288661df966", "url": "https://translations.documentfoundation.org/api/units/100430240/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.235506Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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": 2077, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://translations.documentfoundation.org/api/units/99152130/?format=api", "priority": 100, "id": 100430245, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=be147e39366b089b", "url": "https://translations.documentfoundation.org/api/units/100430245/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.237670Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<emph>SortedRangeLookup</emph> is an optional parameter that indicates whether the first column in the array contains range boundaries instead of plain values. In this mode, the lookup returns the value in the row with first column having value equal to or less than <emph>Lookup</emph>. E.g., it could contain dates when some tax value had been changed, and so the values represent starting dates of a period when a specific tax value was effective. Thus, searching for a date that is absent in the first array column, but falls between some existing boundary dates, would give the lower of them, allowing to find out the data being effective to the searched date. Enter the Boolean value FALSE or zero if the first column is not a range boundary list. When this parameter is TRUE or not given, the first column in the array <emph>must be sorted in ascending order</emph>. Sorted columns can be searched much faster and the function always returns a value, even if the search value was not matched exactly, if it is greater than the lowest value of the sorted list. In unsorted lists, the search value must be matched exactly. Otherwise the function will return #N/A with message: <emph>Error: Value Not Available</emph>." ], "previous_source": "", "target": [ "<emph>Búsqueda por intervalos ordenados</emph> es un parámetro opcional que indica si la primera columna de la matriz contiene límites de intervalo en lugar de valores simples. En este modo, la búsqueda devuelve el valor de la fila cuya primera columna tiene un valor igual o menor que <emph>Búsqueda</emph>. Por ejemplo, podría contener fechas en las que se ha modificado algún valor fiscal, por lo que los valores representan fechas de inicio de un período en el que un valor fiscal específico estuvo vigente. Así, la búsqueda de una fecha ausente en la primera columna de la matriz, pero que cae entre algunas fechas límite existentes, daría la más baja de ellas, permitiendo encontrar los datos vigentes a la fecha buscada. Introduzca el valor booleano FALSO o cero si la primera columna no es una lista de límites del intervalo. Cuando este parámetro es VERDADERO o no se indica, la primera columna de la matriz <emph>debe estar ordenada de forma ascendente</emph>. Las columnas ordenadas se pueden buscar mucho más rápido y la función siempre devuelve un valor, aunque el valor de búsqueda no haya coincidido exactamente, si es mayor que el valor más bajo de la lista ordenada. En las listas no ordenadas, el valor de búsqueda debe coincidir exactamente. En caso contrario, la función devolverá #N/A con el mensaje <emph>Error: Valor no disponible</emph>." ], "id_hash": -5293601005237555600, "content_hash": -5293601005237555600, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3151208\nhelp.text", "note": "qKRbD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2078, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 204, "source_unit": "https://translations.documentfoundation.org/api/units/99152168/?format=api", "priority": 100, "id": 100430250, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=368959eeb42a2e70", "url": "https://translations.documentfoundation.org/api/units/100430250/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.239712Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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": 2079, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 80, "source_unit": "https://translations.documentfoundation.org/api/units/99152219/?format=api", "priority": 100, "id": 100430257, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=cd96d2d3b5cf7789", "url": "https://translations.documentfoundation.org/api/units/100430257/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.243077Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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": 2080, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/99152244/?format=api", "priority": 100, "id": 100430262, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=add552b6b59244c6", "url": "https://translations.documentfoundation.org/api/units/100430262/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.245564Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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": 2081, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99152301/?format=api", "priority": 100, "id": 100430267, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=4d89e74815e26707", "url": "https://translations.documentfoundation.org/api/units/100430267/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.247278Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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": 2082, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 60, "source_unit": "https://translations.documentfoundation.org/api/units/99152340/?format=api", "priority": 100, "id": 100430273, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=839b249062201f03", "url": "https://translations.documentfoundation.org/api/units/100430273/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.249906Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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": 2083, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/99152400/?format=api", "priority": 100, "id": 100430280, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=5a2eeb22d7942e9b", "url": "https://translations.documentfoundation.org/api/units/100430280/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.252860Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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": 2084, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99152430/?format=api", "priority": 100, "id": 100430286, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=f8ff43e3cc671a40", "url": "https://translations.documentfoundation.org/api/units/100430286/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.255300Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_TABELLE\">Returns the sheet number of either a reference or a string representing a sheet name.</ahelp> If you do not enter any parameters, the result is the sheet number of the spreadsheet containing the formula." ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_TABELLE\">Nos devuelve el número de hoja de una referencia o una cadena que representa el nombre de una hoja.</ahelp> Si no se ingresa ningún parámetro, el resultado es el número de hoja de la hoja de cálculo que contiene la fórmula." ], "id_hash": 5500430683439494706, "content_hash": 5500430683439494706, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3150309\nhelp.text", "note": "BRXnw", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2085, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 35, "source_unit": "https://translations.documentfoundation.org/api/units/99152459/?format=api", "priority": 100, "id": 100430291, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=cc5574906611f632", "url": "https://translations.documentfoundation.org/api/units/100430291/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.256730Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "SHEET([Reference])" ], "previous_source": "", "target": [ "HOJA([Referencia])" ], "id_hash": 7060171119697611283, "content_hash": 7060171119697611283, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3153095\nhelp.text", "note": "KRzAZ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2086, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99152497/?format=api", "priority": 100, "id": 100430296, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=e1fac43a1b0c4a13", "url": "https://translations.documentfoundation.org/api/units/100430296/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.258626Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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": 2087, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 17, "source_unit": "https://translations.documentfoundation.org/api/units/99152536/?format=api", "priority": 100, "id": 100430302, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=bec72b88730cdee8", "url": "https://translations.documentfoundation.org/api/units/100430302/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.260052Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<input>=SHEET(Sheet2.A1)</input> returns 2 if Sheet2 is the second sheet in the spreadsheet document." ], "previous_source": "", "target": [ "<input>=HOJA(Hoja2.A1)</input> devuelve 2 si la Hoja2 es la segunda hoja en el documento de hoja de cálculo." ], "id_hash": -8376814135589143232, "content_hash": -8376814135589143232, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3146988\nhelp.text", "note": "wbjCM", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2088, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/99152563/?format=api", "priority": 100, "id": 100430308, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=0bbf93ed0abcfd40", "url": "https://translations.documentfoundation.org/api/units/100430308/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.261581Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<input>=SHEET(\"Sheet3\")</input> returns 3 if Sheet3 is the third sheet in the spreadsheet document." ], "previous_source": "", "target": [ "<input>=HOJA(\"Hoja3\")</input> devuelve 3 si la Hoja3 es la tercera hoja en el documento de hoja de cálculo." ], "id_hash": -4871450135322043081, "content_hash": -4871450135322043081, "location": "04060109.xhp", "context": "04060109.xhp\npar_id491612531793751\nhelp.text", "note": "fEQws", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2089, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/99152588/?format=api", "priority": 100, "id": 100430313, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=3c6521e97719dd37", "url": "https://translations.documentfoundation.org/api/units/100430313/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.263127Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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": 2090, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/99152617/?format=api", "priority": 100, "id": 100430319, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=0d78e86a5802ce8e", "url": "https://translations.documentfoundation.org/api/units/100430319/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.264806Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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": 2091, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99152646/?format=api", "priority": 100, "id": 100430324, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=4ccfae6eac6fa3f2", "url": "https://translations.documentfoundation.org/api/units/100430324/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.266240Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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": 2092, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/99152675/?format=api", "priority": 100, "id": 100430328, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=7be87a9876f976a4", "url": "https://translations.documentfoundation.org/api/units/100430328/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.267433Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "SHEETS([Reference])" ], "previous_source": "", "target": [ "HOJAS([Referencia])" ], "id_hash": 3577486469911131972, "content_hash": 3577486469911131972, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3150777\nhelp.text", "note": "j5Aps", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2093, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99152736/?format=api", "priority": 100, "id": 100430334, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=b1a5c8fd73d1b744", "url": "https://translations.documentfoundation.org/api/units/100430334/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.269009Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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": 2094, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/99152782/?format=api", "priority": 100, "id": 100430337, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=bfb3624a01e44db5", "url": "https://translations.documentfoundation.org/api/units/100430337/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.270067Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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": 2095, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/99152822/?format=api", "priority": 100, "id": 100430342, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=bb0f403b72db927e", "url": "https://translations.documentfoundation.org/api/units/100430342/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.271345Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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": 2096, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99152859/?format=api", "priority": 100, "id": 100430347, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=66a7943fb4534407", "url": "https://translations.documentfoundation.org/api/units/100430347/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.272561Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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": 2097, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99152878/?format=api", "priority": 100, "id": 100430351, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=a32f527f4d0b6924", "url": "https://translations.documentfoundation.org/api/units/100430351/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.273708Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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": 2098, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 31, "source_unit": "https://translations.documentfoundation.org/api/units/99152920/?format=api", "priority": 100, "id": 100430354, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=5d7d694219318df1", "url": "https://translations.documentfoundation.org/api/units/100430354/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.274774Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "MATCH(Search; LookupArray [; Type])" ], "previous_source": "", "target": [ "COINCIDIR(Búsqueda; Matriz de búsqueda [; Tipo])" ], "id_hash": 3179497475035933733, "content_hash": 3179497475035933733, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3159152\nhelp.text", "note": "AKi9E", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2099, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/99152964/?format=api", "priority": 100, "id": 100430360, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=ac1fd81b9bc4ac25", "url": "https://translations.documentfoundation.org/api/units/100430360/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.276089Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<emph>Search</emph> is the value which is to be searched for in the single-row or single-column array." ], "previous_source": "", "target": [ "<emph>Búsqueda</emph> es el valor que se buscará en la matriz de una sola fila o de una sola columna." ], "id_hash": 5710919532056130791, "content_hash": 5710919532056130791, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3149336\nhelp.text", "note": "KZU4F", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2100, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/99152996/?format=api", "priority": 100, "id": 100430364, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=cf41430e810bb4e7", "url": "https://translations.documentfoundation.org/api/units/100430364/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:25:56.277123Z" } ] }