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=34
{ "count": 8573, "next": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/units/?format=api&page=35", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/units/?format=api&page=33", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "LOOKUP" ], "previous_source": "", "target": [ "BUSCAR" ], "id_hash": 8655066154759884947, "content_hash": 8655066154759884947, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3159273\nhelp.text", "note": "MPjM8", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2113, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24942715/?format=api", "priority": 100, "id": 1507316, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=f81cf8cfadf81093", "url": "https://translations.documentfoundation.org/api/units/1507316/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.775888Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "If LOOKUP cannot find the search criterion, it matches the largest value in the search vector that is less than or equal to the search criterion." ], "previous_source": "", "target": [ "Si BUSCAR no puede encontrar el criterio de búsqueda, utiliza el valor más grande del vector de búsqueda que sea menor que o igual al criterio de búsqueda." ], "id_hash": -3061392892454013596, "content_hash": -3061392892454013596, "location": "04060109.xhp", "context": "04060109.xhp\npar_id4484084\nhelp.text", "note": "3jevg", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2115, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/24942717/?format=api", "priority": 100, "id": 1507318, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=5583bf625f5f7564", "url": "https://translations.documentfoundation.org/api/units/1507318/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.802943Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<emph>SearchVector</emph> is the single-row or single-column area to be searched." ], "previous_source": "", "target": [ "<emph>VectordeBúsqueda</emph> es el área de una columna o una fila que se va a buscar." ], "id_hash": 5289312777227322, "content_hash": 5289312777227322, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3154854\nhelp.text", "note": "tFDBC", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2118, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/24942720/?format=api", "priority": 100, "id": 1507321, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=8012ca9a19314c3a", "url": "https://translations.documentfoundation.org/api/units/1507321/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.840361Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<emph>ResultVector</emph> is another single-row or single-column range from which the result of the function is taken. The result is the cell of the result vector with the same index as the instance found in the search vector." ], "previous_source": "", "target": [ "<emph>VectordeResultado</emph> es otra área de una columna o una fila desde la que se toma el resultado de la función. El resultado es la celda del vector de resultado con el mismo índice que la instancia que se encontró con el vector de búsqueda." ], "id_hash": -3957940721512948347, "content_hash": -3957940721512948347, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3149925\nhelp.text", "note": "zdXML", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2119, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 37, "source_unit": "https://translations.documentfoundation.org/api/units/24942721/?format=api", "priority": 100, "id": 1507322, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=491291e2442add85", "url": "https://translations.documentfoundation.org/api/units/1507322/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.855544Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<item type=\"input\">=LOOKUP(A1;D1:D100;F1:F100)</item> searches the corresponding cell in range D1:D100 for the number you entered in A1. For the instance found, the index is determined, for example, the 12th cell in this range. Then, the contents of the 12th cell are returned as the value of the function (in the result vector)." ], "previous_source": "", "target": [ "<item type=\"input\">=BUSCAR(A1;D1:D100;F1:F100)</item> busca la celda correspondiente en el área D1:D100 del número especificado en A1. Para la instancia encontrada, se determina el índice, por ejemplo, la celda 12 de esta área. A continuación, el contenido de la celda 12 se devuelve como el valor de la función (en el vector de resultado)." ], "id_hash": -4343587908196936134, "content_hash": -4343587908196936134, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3149809\nhelp.text", "note": "36TJv", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2120, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 51, "source_unit": "https://translations.documentfoundation.org/api/units/24942722/?format=api", "priority": 100, "id": 1507323, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=43b879cf913d563a", "url": "https://translations.documentfoundation.org/api/units/1507323/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.866611Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<bookmark_value>CHOOSE function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>Función ELEGIR</bookmark_value>" ], "id_hash": -1246532646027441510, "content_hash": -1246532646027441510, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id3150430\nhelp.text", "note": "XYxM4", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2121, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24942734/?format=api", "priority": 100, "id": 1507335, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=6eb36d29b09b4a9a", "url": "https://translations.documentfoundation.org/api/units/1507335/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.013473Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "CHOOSE" ], "previous_source": "", "target": [ "ELEGIR" ], "id_hash": 7614291423126201432, "content_hash": 7614291423126201432, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3150430\nhelp.text", "note": "eygie", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2122, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24942735/?format=api", "priority": 100, "id": 1507336, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=e9ab65b503bda458", "url": "https://translations.documentfoundation.org/api/units/1507336/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.024165Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_WAHL\">Uses an index to return a value from a list of up to 30 values.</ahelp>" ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_WAHL\">Utiliza un índice para producir un valor a partir de una lista formada por hasta 30 valores.</ahelp>" ], "id_hash": 5000394310678462495, "content_hash": 5000394310678462495, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3143270\nhelp.text", "note": "ynNz9", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2123, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/24942736/?format=api", "priority": 100, "id": 1507337, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=c564f821e0dfc01f", "url": "https://translations.documentfoundation.org/api/units/1507337/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.037404Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<item type=\"input\">=CHOOSE(A1;B1;B2;B3;\"Today\";\"Yesterday\";\"Tomorrow\")</item>, for example, returns the contents of cell B2 for A1 = 2; for A1 = 4, the function returns the text \"Today\"." ], "previous_source": "", "target": [ "<item type=\"input\">=ELEGIR(A1;B1;B2;B3;\"Hoy\";\"Ayer\";\"Mañana\")</item>, por ejemplo, devuelve el contenido de la celda B2 para A1 = 2; para A1 = 4, la función devuelve el texto «Hoy»." ], "id_hash": 1169713915901438249, "content_hash": 1169713915901438249, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3150625\nhelp.text", "note": "s64Du", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2127, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://translations.documentfoundation.org/api/units/24942740/?format=api", "priority": 100, "id": 1507341, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=903ba89bee22e929", "url": "https://translations.documentfoundation.org/api/units/1507341/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.080730Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<bookmark_value>HLOOKUP function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>función BUSCARH</bookmark_value>" ], "id_hash": 837705466221852232, "content_hash": 837705466221852232, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id3151001\nhelp.text", "note": "pyC7b", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2128, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24942741/?format=api", "priority": 100, "id": 1507342, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=8ba020aee48e7648", "url": "https://translations.documentfoundation.org/api/units/1507342/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.093116Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "HLOOKUP" ], "previous_source": "", "target": [ "BUSCARH" ], "id_hash": 1011049703423366766, "content_hash": 1011049703423366766, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3151001\nhelp.text", "note": "LPUU2", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2129, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24942742/?format=api", "priority": 100, "id": 1507343, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=8e07f85936d0566e", "url": "https://translations.documentfoundation.org/api/units/1507343/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.105526Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_WVERWEIS\">Searches for a value and reference to the cells below the selected area.</ahelp> This function verifies if the first row of an array contains a certain value. The function returns then the value in a row of the array, named in the <emph>Index</emph>, in the same column." ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_WVERWEIS\">Busca un valor y una referencia a las celdas situadas por debajo del área seleccionada.</ahelp> Esta función comprueba si la primera fila de una matriz contiene un cierto valor. La función devuelve el valor situado en una fila de la matriz, indicada en <emph>Índice</emph>, en la misma columna." ], "id_hash": 8452625132990922436, "content_hash": 8452625132990922436, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3148688\nhelp.text", "note": "XtZrs", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2130, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 48, "source_unit": "https://translations.documentfoundation.org/api/units/24942743/?format=api", "priority": 100, "id": 1507344, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=f54dc1c647767ec4", "url": "https://translations.documentfoundation.org/api/units/1507344/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.116820Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<bookmark_value>ROW function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>función FILA</bookmark_value>" ], "id_hash": -2361118716865256180, "content_hash": -2361118716865256180, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id3147321\nhelp.text", "note": "B4DL3", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2145, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24942744/?format=api", "priority": 100, "id": 1507347, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=5f3b9f0968b8650c", "url": "https://translations.documentfoundation.org/api/units/1507347/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.173325Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "ROW" ], "previous_source": "", "target": [ "FILA" ], "id_hash": -345179335225695980, "content_hash": -345179335225695980, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3147321\nhelp.text", "note": "Dk854", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2146, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24942745/?format=api", "priority": 100, "id": 1507348, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=7b35ad3934112114", "url": "https://translations.documentfoundation.org/api/units/1507348/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.190400Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<emph>Reference</emph> is a cell, an area, or the name of an area." ], "previous_source": "", "target": [ "<emph>Referencia</emph> es una celda, un área o el nombre de un área." ], "id_hash": 5194788869710857183, "content_hash": 5194788869710857183, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3156336\nhelp.text", "note": "mSqrb", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2149, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/24942748/?format=api", "priority": 100, "id": 1507351, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=c81798f42e44c3df", "url": "https://translations.documentfoundation.org/api/units/1507351/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.227668Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "If you do not indicate a reference, the row number of the cell in which the formula is entered will be found. <item type=\"productname\">%PRODUCTNAME</item> Calc automatically sets the reference to the current cell." ], "previous_source": "", "target": [ "Si se omite la referencia, la función calcula el número de fila 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": 3720755741605929069, "content_hash": 3720755741605929069, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3151109\nhelp.text", "note": "eUXYG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2150, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 33, "source_unit": "https://translations.documentfoundation.org/api/units/24942749/?format=api", "priority": 100, "id": 1507352, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=b3a2c7a2326aa06d", "url": "https://translations.documentfoundation.org/api/units/1507352/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.237996Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<item type=\"input\">=ROW(B3)</item> returns 3 because the reference refers to the third row in the table." ], "previous_source": "", "target": [ "<item type=\"input\">=FILA(B3)</item> devuelve 3 porque la referencia hace mención a la tercera fila de la tabla." ], "id_hash": -2177386009179408488, "content_hash": -2177386009179408488, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3154830\nhelp.text", "note": "GwuVx", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2151, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/24942750/?format=api", "priority": 100, "id": 1507353, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=61c85ef5fff4b798", "url": "https://translations.documentfoundation.org/api/units/1507353/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.253636Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<item type=\"input\">{=ROW(D5:D8)}</item> returns the single-column array (5, 6, 7, 8) because the reference specified contains rows 5 through 8." ], "previous_source": "", "target": [ "<item type=\"input\">{=FILA(D5:D8)}</item> devuelve la matriz de una columna (5, 6, 7, 8) porque la referencia especificada contiene las filas 5 a 8." ], "id_hash": -2042965818137793533, "content_hash": -2042965818137793533, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3147094\nhelp.text", "note": "FDCdZ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2152, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/24942751/?format=api", "priority": 100, "id": 1507354, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=63a5ed6999a1ac03", "url": "https://translations.documentfoundation.org/api/units/1507354/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.265534Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<item type=\"input\">=ROW(D5:D8)</item> returns 5 because the ROW function is not used as array formula and only the number of the first row of the reference is returned." ], "previous_source": "", "target": [ "<item type=\"input\">=FILA(D5:D8)</item> devuelve 5 porque la función FILA no se utiliza como fórmula matricial y solo se devuelve el número de la primera fila de la referencia." ], "id_hash": -3337638330205888383, "content_hash": -3337638330205888383, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3153701\nhelp.text", "note": "CWNY7", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2153, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 27, "source_unit": "https://translations.documentfoundation.org/api/units/24942752/?format=api", "priority": 100, "id": 1507355, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=51ae539f4b59a081", "url": "https://translations.documentfoundation.org/api/units/1507355/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.275366Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<item type=\"input\">{=ROW(A1:E1)}</item> and <item type=\"input\">=ROW(A1:E1)</item> both return 1 because the reference only contains row 1 as the first row in the table. (Because single-row areas only have one row number it does not make any difference whether or not the formula is used as an array formula.)" ], "previous_source": "", "target": [ "<item type=\"input\">{=FILA(A1:E1)}</item> y <item type=\"input\">=FILA(A1:E1)</item> devuelven 1 porque la referencia solo contiene la fila 1 como la primera fila de la tabla. Debido a que las áreas de una sola fila solo tienen un número de fila, no hay ninguna diferencia si la fórmula se utiliza como fórmula matricial o no." ], "id_hash": -2173364650780142435, "content_hash": -2173364650780142435, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3150996\nhelp.text", "note": "LpXFL", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2154, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 47, "source_unit": "https://translations.documentfoundation.org/api/units/24942753/?format=api", "priority": 100, "id": 1507356, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=61d6a85d76dbd49d", "url": "https://translations.documentfoundation.org/api/units/1507356/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.285368Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<item type=\"input\">=ROW()</item> returns 3 if the formula was entered in row 3." ], "previous_source": "", "target": [ "<item type=\"input\">=FILA()</item> devuelve 3 si la fórmula se especificó en la fila 3." ], "id_hash": -1963376887368523013, "content_hash": -1963376887368523013, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3153671\nhelp.text", "note": "ABQhH", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2155, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/24942754/?format=api", "priority": 100, "id": 1507357, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=64c0af1f942fe2fb", "url": "https://translations.documentfoundation.org/api/units/1507357/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.297092Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<item type=\"input\">{=ROW(Rabbit)}</item> returns the single-column array (1, 2, 3) if \"Rabbit\" is the named area (C1:D3)." ], "previous_source": "", "target": [ "<item type=\"input\">{=FILA(Conejo)}</item> devuelve la matriz de una columna (1, 2, 3) si «Conejo» es el intervalo con nombre (C1:D3)." ], "id_hash": 3342202309377560900, "content_hash": 3342202309377560900, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3153790\nhelp.text", "note": "d8Kuj", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2156, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/24942755/?format=api", "priority": 100, "id": 1507358, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=ae61e34ae9f09144", "url": "https://translations.documentfoundation.org/api/units/1507358/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.308086Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<bookmark_value>ROWS function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>Función FILAS</bookmark_value>" ], "id_hash": 3782444169566703013, "content_hash": 3782444169566703013, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id3145772\nhelp.text", "note": "RF4C9", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2157, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24942756/?format=api", "priority": 100, "id": 1507359, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=b47df0ee95c54da5", "url": "https://translations.documentfoundation.org/api/units/1507359/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.320824Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "ROWS" ], "previous_source": "", "target": [ "FILAS" ], "id_hash": 1939762464644556811, "content_hash": 1939762464644556811, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3145772\nhelp.text", "note": "EURAZ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2158, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24942757/?format=api", "priority": 100, "id": 1507360, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=9aeb6baf2dc6680b", "url": "https://translations.documentfoundation.org/api/units/1507360/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.329124Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_ZEILEN\">Returns the number of rows in a reference or array.</ahelp>" ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_ZEILEN\">Devuelve el número de filas de una referencia o matriz.</ahelp>" ], "id_hash": 1978530240890796127, "content_hash": 1978530240890796127, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3148971\nhelp.text", "note": "wniFN", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2159, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/24942758/?format=api", "priority": 100, "id": 1507361, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=9b7526c579a9f85f", "url": "https://translations.documentfoundation.org/api/units/1507361/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.342193Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "ROWS(Array)" ], "previous_source": "", "target": [ "FILAS(Matriz)" ], "id_hash": 4290910996493570120, "content_hash": 4290910996493570120, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3154357\nhelp.text", "note": "UHLW7", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2160, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24942759/?format=api", "priority": 100, "id": 1507362, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=bb8c60d12cd11048", "url": "https://translations.documentfoundation.org/api/units/1507362/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.355404Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<emph>Array</emph> is the reference or named area whose total number of rows is to be determined." ], "previous_source": "", "target": [ "<emph>Matriz</emph> es la referencia o área con nombre cuyo número total de filas se va a determinar." ], "id_hash": -8166631567841135854, "content_hash": -8166631567841135854, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3155942\nhelp.text", "note": "SDyoR", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2161, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/24942760/?format=api", "priority": 100, "id": 1507363, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=0eaa4bdb93567312", "url": "https://translations.documentfoundation.org/api/units/1507363/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.366609Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<item type=\"input\">=Rows(B5)</item> returns 1 because a cell only contains one row." ], "previous_source": "", "target": [ "<item type=\"input\">=Filas(B5)</item> devuelve 1 porque una celda contiene solamente una fila." ], "id_hash": 3179259141443047493, "content_hash": 3179259141443047493, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3154725\nhelp.text", "note": "vLpxF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2162, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/24942761/?format=api", "priority": 100, "id": 1507364, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=ac1eff583ea05045", "url": "https://translations.documentfoundation.org/api/units/1507364/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.379730Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<item type=\"input\">=ROWS(A10:B12)</item> returns 3." ], "previous_source": "", "target": [ "<item type=\"input\">=FILAS(A10:B12)</item> devuelve 3." ], "id_hash": 8726325246435246997, "content_hash": 8726325246435246997, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3150102\nhelp.text", "note": "j27bq", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2163, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/24942762/?format=api", "priority": 100, "id": 1507365, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=f91a2293dc4bc395", "url": "https://translations.documentfoundation.org/api/units/1507365/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.390867Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<item type=\"input\">=ROWS(Rabbit)</item> returns 3 if \"Rabbit\" is the named area (C1:D3)." ], "previous_source": "", "target": [ "<item type=\"input\">=FILAS(Conejo)</item> devuelve 3 si «Conejo» es el intervalo con nombre (C1:D3)." ], "id_hash": -1013333620181692939, "content_hash": -1013333620181692939, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3155143\nhelp.text", "note": "4AmXS", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2164, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/24942763/?format=api", "priority": 100, "id": 1507366, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=71efea70fa1c0df5", "url": "https://translations.documentfoundation.org/api/units/1507366/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.405454Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<bookmark_value>HYPERLINK function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>función HIPERVINCULO</bookmark_value>" ], "id_hash": 2418601881341008658, "content_hash": 2418601881341008658, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id9959410\nhelp.text", "note": "Wncoz", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2165, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24942764/?format=api", "priority": 100, "id": 1507367, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=a1909998c66c1b12", "url": "https://translations.documentfoundation.org/api/units/1507367/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.423025Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "HYPERLINK" ], "previous_source": "", "target": [ "HIPERVINCULO" ], "id_hash": -772613790251597624, "content_hash": -772613790251597624, "location": "04060109.xhp", "context": "04060109.xhp\npar_idN11798\nhelp.text", "note": "CDw2x", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2166, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24942765/?format=api", "priority": 100, "id": 1507368, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=75471fd9eb7c40c8", "url": "https://translations.documentfoundation.org/api/units/1507368/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.438751Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_HYPERLINK\">When you click a cell that contains the HYPERLINK function, the hyperlink opens.</ahelp>" ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_HYPERLINK\">Al pulsar en una celda que contenga la función HIPERVINCULO, se abre el hiperenlace.</ahelp>" ], "id_hash": 4534164272395009121, "content_hash": 4534164272395009121, "location": "04060109.xhp", "context": "04060109.xhp\npar_idN117F1\nhelp.text", "note": "GAJeF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2167, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/24942766/?format=api", "priority": 100, "id": 1507369, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=beec9661f95f3c61", "url": "https://translations.documentfoundation.org/api/units/1507369/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.453791Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "To open a hyperlinked cell with the keyboard, select the cell, press F2 to enter the Edit mode, move the cursor in front of the hyperlink, press Shift+F10, and then choose <emph>Open Hyperlink</emph>." ], "previous_source": "", "target": [ "Para abrir con el teclado una celda con hiperenlace, seleccione la celda, presione F2 para acceder al modo de edición, mueva el cursor delante del hiperenlace, presione Mayús + F10 y, a continuación, seleccione <emph>Abrir hiperenlace</emph>." ], "id_hash": 6220766120926062383, "content_hash": 6220766120926062383, "location": "04060109.xhp", "context": "04060109.xhp\npar_idN11803\nhelp.text", "note": "7DGBz", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2169, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 33, "source_unit": "https://translations.documentfoundation.org/api/units/24942768/?format=api", "priority": 100, "id": 1507371, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=d65499d3f495272f", "url": "https://translations.documentfoundation.org/api/units/1507371/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.480038Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "The number 0 is returned for empty cells and matrix elements." ], "previous_source": "", "target": [ "Se devuelve el número 0 para las celdas y los elementos de matriz vacíos." ], "id_hash": 9183508396406512454, "content_hash": 9183508396406512454, "location": "04060109.xhp", "context": "04060109.xhp\npar_id0907200912224576\nhelp.text", "note": "GdBa8", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2172, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/24942771/?format=api", "priority": 100, "id": 1507374, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=ff72603aefa09b46", "url": "https://translations.documentfoundation.org/api/units/1507374/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.538613Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<bookmark_value>GETPIVOTDATA function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>función IMPORTARDATOSDINAMICOS</bookmark_value>" ], "id_hash": -946151325930625045, "content_hash": -946151325930625045, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id7682424\nhelp.text", "note": "ubKsF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2182, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24942778/?format=api", "priority": 100, "id": 1507382, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=72de9861ca23e7eb", "url": "https://translations.documentfoundation.org/api/units/1507382/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.659546Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "GETPIVOTDATA" ], "previous_source": "", "target": [ "IMPORTARDATOSDINAMICOS" ], "id_hash": 5240299382109462377, "content_hash": 5240299382109462377, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3747062\nhelp.text", "note": "3ndfJ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2183, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24942779/?format=api", "priority": 100, "id": 1507383, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=c8b9488613555f69", "url": "https://translations.documentfoundation.org/api/units/1507383/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.676571Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<ahelp hid=\".\">The GETPIVOTDATA function returns a result value from a pivot table. The value is addressed using field and item names, so it remains valid if the layout of the pivot table changes.</ahelp>" ], "previous_source": "", "target": [ "<ahelp hid=\".\">La función IMPORTARDATOSDINAMICOS devuelve un valor de resultado de una tabla dinámica. El valor se señala mediante los nombres del campo y de los elementos, de modo que siga siendo válido si cambia la disposición de la tabla dinámica.</ahelp>" ], "id_hash": 5187296786357012091, "content_hash": 5187296786357012091, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3593859\nhelp.text", "note": "MoLqJ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2184, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 33, "source_unit": "https://translations.documentfoundation.org/api/units/24942780/?format=api", "priority": 100, "id": 1507384, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=c7fcfaf19755c67b", "url": "https://translations.documentfoundation.org/api/units/1507384/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.693688Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "Two different syntax definitions can be used:" ], "previous_source": "", "target": [ "Se pueden utilizar dos definiciones sintácticas diferentes:" ], "id_hash": -6279826677705307235, "content_hash": -6279826677705307235, "location": "04060109.xhp", "context": "04060109.xhp\npar_id909451\nhelp.text", "note": "k6kQB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2185, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/24942781/?format=api", "priority": 100, "id": 1507385, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=28d992e8985a8b9d", "url": "https://translations.documentfoundation.org/api/units/1507385/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.706780Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "GETPIVOTDATA(pivot table; Constraints)" ], "previous_source": "", "target": [ "IMPORTARDATOSDINAMICOS(TablaDinámica; Limitantes)" ], "id_hash": -611817698728201602, "content_hash": -611817698728201602, "location": "04060109.xhp", "context": "04060109.xhp\npar_id4997100\nhelp.text", "note": "QnCVY", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2188, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/24942783/?format=api", "priority": 100, "id": 1507387, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=7782630b6802327e", "url": "https://translations.documentfoundation.org/api/units/1507387/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.733744Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "The second syntax is assumed if exactly two parameters are given, of which the first parameter is a cell or cell range reference. The first syntax is assumed in all other cases. The Function Wizard shows the first syntax." ], "previous_source": "", "target": [ "Se asume la segunda sintaxis si se proporcionan exactamente dos parámetros, el primero de los cuales es una celda o una referencia a un intervalo de celdas. En el resto de los casos se asume la primera sintaxis. El Asistente para funciones muestra la primera sintaxis." ], "id_hash": 5193858182333926414, "content_hash": 5193858182333926414, "location": "04060109.xhp", "context": "04060109.xhp\npar_id1672109\nhelp.text", "note": "LJFgA", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2189, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 39, "source_unit": "https://translations.documentfoundation.org/api/units/24942784/?format=api", "priority": 100, "id": 1507388, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=c8144a7fa3c50c0e", "url": "https://translations.documentfoundation.org/api/units/1507388/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.748873Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<emph>TargetField</emph> is a string that selects one of the pivot table's data fields. The string can be the name of the source column, or the data field name as shown in the table (like \"Sum - Sales\")." ], "previous_source": "", "target": [ "<emph>CampoDestino</emph> es una cadena que selecciona uno de los campos de datos de la tabla dinámica. La cadena puede ser el nombre de la columna de origen o el nombre del campo de datos como se muestra en la tabla (como «Suma - Ventas»)." ], "id_hash": -7239259067986216298, "content_hash": -7239259067986216298, "location": "04060109.xhp", "context": "04060109.xhp\npar_id9302346\nhelp.text", "note": "xTLTZ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2191, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 37, "source_unit": "https://translations.documentfoundation.org/api/units/24942785/?format=api", "priority": 100, "id": 1507389, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=1b88fc3b9fa7fa96", "url": "https://translations.documentfoundation.org/api/units/1507389/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.766516Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<emph>pivot table</emph> is a reference to a cell or cell range that is positioned within a pivot table or contains a pivot table. If the cell range contains several pivot tables, the table that was created last is used." ], "previous_source": "", "target": [ "<emph>tabla dinámica</emph> es una referencia a una celda o intervalo de celdas que se ubica dentro de una tabla dinámica o contiene una tabla dinámica. Si el intervalo de celdas contiene varias tablas dinámicas, se utiliza la última tabla que se creó." ], "id_hash": 4132487332375574583, "content_hash": 4132487332375574583, "location": "04060109.xhp", "context": "04060109.xhp\npar_id8296151\nhelp.text", "note": "yNzcp", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2192, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 39, "source_unit": "https://translations.documentfoundation.org/api/units/24942786/?format=api", "priority": 100, "id": 1507390, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=b9598b557d0c3837", "url": "https://translations.documentfoundation.org/api/units/1507390/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.781176Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "If no <emph>Field n / Item n</emph> pairs are given, the grand total is returned. Otherwise, each pair adds a constraint that the result must satisfy. <emph>Field n</emph> is the name of a field from the pivot table. <emph>Item n</emph> is the name of an item from that field." ], "previous_source": "", "target": [ "Si no hay pares ha dado <emph>Campos n / Elementos n</emph>, el gran total no devuelve nada. De cualquier forma, cada par agrega una constante que el resultado debe ser satisfecho. <emph>Campo n</emph> es el nombre del campo de la tabla de Piloto de datos. <emph>Elemento n</emph> es el nombre del elemento del campo." ], "id_hash": -1497535495358537996, "content_hash": -1497535495358537996, "location": "04060109.xhp", "context": "04060109.xhp\npar_id4809411\nhelp.text", "note": "bmrBF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2193, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 49, "source_unit": "https://translations.documentfoundation.org/api/units/24942787/?format=api", "priority": 100, "id": 1507391, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=6b37af66b89d9ef4", "url": "https://translations.documentfoundation.org/api/units/1507391/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.797219Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "If the pivot table contains only a single result value that fulfills all of the constraints, or a subtotal result that summarizes all matching values, that result is returned. If there is no matching result, or several ones without a subtotal for them, an error is returned. These conditions apply to results that are included in the pivot table." ], "previous_source": "", "target": [ "Si la tabla dinámica solamente contiene un solo valor de resultado que cumpla con todas las limitantes, o un resultado de subtotal que resume todos los valores coincidentes, se devuelve ese resultado. Si no hay un resultado coincidente, o varios que carezcan de un subtotal, se devuelve un error. Estas condiciones aplican a los resultados que se incluyen en la tabla dinámica." ], "id_hash": 2388784086717151413, "content_hash": 2388784086717151413, "location": "04060109.xhp", "context": "04060109.xhp\npar_id6454969\nhelp.text", "note": "swvQC", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2194, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 59, "source_unit": "https://translations.documentfoundation.org/api/units/24942788/?format=api", "priority": 100, "id": 1507392, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=a126aa7875e1b8b5", "url": "https://translations.documentfoundation.org/api/units/1507392/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.812302Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "If the source data contains entries that are hidden by settings of the pivot table, they are ignored. The order of the Field/Item pairs is not significant. Field and item names are not case-sensitive." ], "previous_source": "", "target": [ "Si el origen de datos contiene entradas que están ocultas por la configuración de la tabla dinámica, ellas se ignoran. No importa el orden de los pares Campo/Elemento. Los nombres de los campos y de los elementos no distinguen entre mayúsculas y minúsculas." ], "id_hash": -7629710895233941748, "content_hash": -7629710895233941748, "location": "04060109.xhp", "context": "04060109.xhp\npar_id79042\nhelp.text", "note": "vjksc", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2195, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 34, "source_unit": "https://translations.documentfoundation.org/api/units/24942789/?format=api", "priority": 100, "id": 1507393, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=161dd25d5ea73f0c", "url": "https://translations.documentfoundation.org/api/units/1507393/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.831142Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "Subtotal values from the pivot table are only used if they use the function \"auto\" (except when specified in the constraint, see <item type=\"literal\">Second Syntax</item> below)." ], "previous_source": "", "target": [ "Los valores de subtotal de la tabla dinámica se utilizan solo si estos usan la función «auto» (excepto cuando se especifican en la restricción; en este caso, consulte <item type=\"literal\">Segunda sintaxis</item> más abajo)." ], "id_hash": -1979321936287154257, "content_hash": -1979321936287154257, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3864253\nhelp.text", "note": "nARMD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2197, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/24942791/?format=api", "priority": 100, "id": 1507395, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=6488092f93773faf", "url": "https://translations.documentfoundation.org/api/units/1507395/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.849857Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<emph>pivot table</emph> has the same meaning as in the first syntax." ], "previous_source": "", "target": [ "<emph>tabla dinámica</emph> tiene el mismo significado que en la primera sintaxis." ], "id_hash": -4232016537115714080, "content_hash": -4232016537115714080, "location": "04060109.xhp", "context": "04060109.xhp\npar_id9937131\nhelp.text", "note": "KETgR", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2199, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/24942792/?format=api", "priority": 100, "id": 1507396, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=4544db61b5a39de0", "url": "https://translations.documentfoundation.org/api/units/1507396/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.865798Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<emph>Constraints</emph> is a space-separated list. Entries can be quoted (single quotes). The whole string must be enclosed in quotes (double quotes), unless you reference the string from another cell." ], "previous_source": "", "target": [ "<emph>Limitantes</emph> es una lista separada por espacios. Las entradas se pueden poner entre comillas (comillas simples). Toda la cadena se debe poner entre comillas (comillas dobles), a menos que haga referencia a la cadena desde otra celda." ], "id_hash": 5115834849937829754, "content_hash": 5115834849937829754, "location": "04060109.xhp", "context": "04060109.xhp\npar_id5616626\nhelp.text", "note": "GUofE", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2200, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/24942793/?format=api", "priority": 100, "id": 1507397, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=c6ff18b0f01baf7a", "url": "https://translations.documentfoundation.org/api/units/1507397/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.881188Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "One of the entries can be the data field name. The data field name can be left out if the pivot table contains only one data field, otherwise it must be present." ], "previous_source": "", "target": [ "Una de las entradas puede ser el nombre del campo de datos. El nombre del campo de datos puede omitirse si la tabla dinámica contiene solamente un campo de datos, pero de lo contrario debe estar presente." ], "id_hash": 3603286722984903350, "content_hash": 3603286722984903350, "location": "04060109.xhp", "context": "04060109.xhp\npar_id4076357\nhelp.text", "note": "xS3qo", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2201, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 32, "source_unit": "https://translations.documentfoundation.org/api/units/24942794/?format=api", "priority": 100, "id": 1507398, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=b201722efb6582b6", "url": "https://translations.documentfoundation.org/api/units/1507398/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.901121Z" } ] }