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=95
{ "count": 8628, "next": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/units/?format=api&page=96", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/units/?format=api&page=94", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "Calculates the average for values of the range C2:C6 that correspond to all values of the range B2:B6 except its minimum and maximum. Returns 127.5, because the third and fifth rows do not meet at least one criterion." ], "previous_source": "", "target": [ "Calcula el promedio de los valores en el intervalo C2:C6 que se correspondan con todos los valores en el intervalo B2:B6, exceptuando el menor y el mayor. Devuelve 127,5, porque las filas tercera y quinta no cumplen con por lo menos un criterio." ], "id_hash": 5272279988237403964, "content_hash": 5272279988237403964, "location": "func_averageifs.xhp", "context": "func_averageifs.xhp\npar_id66091035229950\nhelp.text", "note": "oghLv", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6513, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 38, "source_unit": "https://translations.documentfoundation.org/api/units/24950752/?format=api", "priority": 100, "id": 1511473, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=c92ae6b72f4a873c", "url": "https://translations.documentfoundation.org/api/units/1511473/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.997162Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<item type=\"input\">=AVERAGEIFS(C2:C6;A2:A6;\"pen.*\";B2:B6;\"<\"&MAX(B2:B6))</item>" ], "previous_source": "", "target": [ "<item type=\"input\">PROMEDIO.SI.CONJUNTO(C2:C6;A2:A6;\"pan.*\";B2:B6;\"<\"&MAX(B2:B6))</item>" ], "id_hash": -39274590102270107, "content_hash": -39274590102270107, "location": "func_averageifs.xhp", "context": "func_averageifs.xhp\npar_id303162761931870\nhelp.text", "note": "C7fCW", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6514, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24950753/?format=api", "priority": 100, "id": 1511474, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=7f7477f7e8414f65", "url": "https://translations.documentfoundation.org/api/units/1511474/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.006892Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "Calculates the average for values of the range C2:C6 that correspond to all cells of the A2:A6 range starting with \"pen\" and to all cells of the B2:B6 range except its maximum. Returns 65, because only second row meets all criteria." ], "previous_source": "", "target": [ "Calcula el promedio de los valores del intervalo C2:C6 que se correspondan con todas las celdas del intervalo A2:A6 que comienzan por «pan» y a todas las celdas del intervalo B2:B6 excepto su máximo. Devuelve 65 porque solo la segunda fila cumple con todos los criterios." ], "id_hash": 2035057651168597951, "content_hash": 2035057651168597951, "location": "func_averageifs.xhp", "context": "func_averageifs.xhp\npar_id40031348913642\nhelp.text", "note": "eo7jB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6515, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 41, "source_unit": "https://translations.documentfoundation.org/api/units/24950754/?format=api", "priority": 100, "id": 1511475, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=9c3dfa26cb5857bf", "url": "https://translations.documentfoundation.org/api/units/1511475/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.017586Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "Reference to a cell as a criterion" ], "previous_source": "", "target": [ "Referencia a una celda como criterio" ], "id_hash": -3065874459700111046, "content_hash": -3065874459700111046, "location": "func_averageifs.xhp", "context": "func_averageifs.xhp\nhd_id31201205191857\nhelp.text", "note": "qyrrP", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6516, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/24950755/?format=api", "priority": 100, "id": 1511476, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=5573d36c2fa1d93a", "url": "https://translations.documentfoundation.org/api/units/1511476/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.028855Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "If you need to change a criterion easily, you may want to specify it in a separate cell and use a reference to this cell in the condition of AVERAGEIFS function. For example, the above function can be rewritten as follows:" ], "previous_source": "", "target": [ "Si se necesita cambiar un criterio fácilmente, se puede especificar en una celda separada y usar una referencia a esa celda en la condición de la función PROMEDIO.SI.CONJUNTO. Por ejemplo, la función anterior se puede reescribir asi:" ], "id_hash": -6864261810427536110, "content_hash": -6864261810427536110, "location": "func_averageifs.xhp", "context": "func_averageifs.xhp\npar_id316794795433\nhelp.text", "note": "DqjCH", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6517, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 41, "source_unit": "https://translations.documentfoundation.org/api/units/24950756/?format=api", "priority": 100, "id": 1511477, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=20bd3e40782fdd12", "url": "https://translations.documentfoundation.org/api/units/1511477/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.039198Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<item type=\"input\">=AVERAGEIFS(C2:C6;A2:A6;E2&\".*\";B2:B6;\"<\"&MAX(B2:B6))</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=PROMEDIO.SI.CONJUNTO(C2:C6;A2:A6;E2&\".*\";B2:B6;\"<\"&MAX(B2:B6))</item>" ], "id_hash": 7459219915114670295, "content_hash": 7459219915114670295, "location": "func_averageifs.xhp", "context": "func_averageifs.xhp\npar_id67531072426731\nhelp.text", "note": "B8bav", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6518, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24950757/?format=api", "priority": 100, "id": 1511478, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=e78478fdfdede8d7", "url": "https://translations.documentfoundation.org/api/units/1511478/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.049134Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "If E2 = pen, the function returns 65, because the link to the cell is substituted with its content." ], "previous_source": "", "target": [ "Si E2 = pan, la función devuelve 65 porque el enlace a la celda se sustituye por su contenido." ], "id_hash": -7828342925869082649, "content_hash": -7828342925869082649, "location": "func_averageifs.xhp", "context": "func_averageifs.xhp\npar_id65612244926745\nhelp.text", "note": "E3TZv", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6519, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/24950758/?format=api", "priority": 100, "id": 1511479, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=135c2395d3a197e7", "url": "https://translations.documentfoundation.org/api/units/1511479/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.060279Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "COLOR function" ], "previous_source": "", "target": [ "Función COLOR" ], "id_hash": -8037245958908344347, "content_hash": -8037245958908344347, "location": "func_color.xhp", "context": "func_color.xhp\ntit\nhelp.text", "note": "GuEcB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6579, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24950759/?format=api", "priority": 100, "id": 1511480, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=1075f7622ed307e5", "url": "https://translations.documentfoundation.org/api/units/1511480/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.070726Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<bookmark_value>colors;numerical values</bookmark_value> <bookmark_value>colors;calculating in spreadsheets</bookmark_value> <bookmark_value>COLOR function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>colores;valores numéricos</bookmark_value><bookmark_value>colores;calcular en libros de cálculo</bookmark_value><bookmark_value>función COLOR</bookmark_value>" ], "id_hash": -3503870829010199345, "content_hash": -3503870829010199345, "location": "func_color.xhp", "context": "func_color.xhp\nbm_id1102201617201921\nhelp.text", "note": "N8CUu", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6580, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/24950760/?format=api", "priority": 100, "id": 1511481, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=4f5fc00b99fe5ccf", "url": "https://translations.documentfoundation.org/api/units/1511481/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.080087Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<variable id=\"color_head\"><link href=\"text/scalc/01/func_color.xhp\">COLOR</link></variable>" ], "previous_source": "", "target": [ "<variable id=\"color_head\"><link href=\"text/scalc/01/func_color.xhp\">COLOR</link></variable>" ], "id_hash": -8821725746593725306, "content_hash": -8821725746593725306, "location": "func_color.xhp", "context": "func_color.xhp\nhd_id456845684568\nhelp.text", "note": "qjPSR", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6581, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/24950761/?format=api", "priority": 100, "id": 1511482, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=0592ef2c485d0486", "url": "https://translations.documentfoundation.org/api/units/1511482/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.090168Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<ahelp hid=\".\">Return a numeric value calculated by a combination of three colors (red, green and blue) and the alpha channel, in the RGBA color system.</ahelp> The result depends on the color system used by your computer." ], "previous_source": "", "target": [ "<ahelp hid=\".\">Devuelve un valor numérico calculado mediante una combinación de tres colores (rojo, verde y azul) y el canal alfa, en el sistema de colores RGBA.</ahelp> El resultado depende del sistema de colores que utilice su equipo." ], "id_hash": -1203832068311828611, "content_hash": -1203832068311828611, "location": "func_color.xhp", "context": "func_color.xhp\npar_id1102201617001848\nhelp.text", "note": "HXh5E", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6582, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 36, "source_unit": "https://translations.documentfoundation.org/api/units/24950762/?format=api", "priority": 100, "id": 1511483, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=6f4b211caf0cb77d", "url": "https://translations.documentfoundation.org/api/units/1511483/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.099733Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<emph>Red, Green and Blue</emph> – required arguments. The value for the red, green and blue components of the color. The values must be between 0 and 255. Zero means no color component and 255 means full color component." ], "previous_source": "", "target": [ "<emph>Rojo, Verde y Azul</emph> (parámetros obligatorios). El valor de los componentes rojo, verde y azul del color. Los valores deben estar comprendidos entre 0 y 255. El cero significa que el componente desaparece y 255, un componente completo." ], "id_hash": 224638577614200603, "content_hash": 224638577614200603, "location": "func_color.xhp", "context": "func_color.xhp\npar_id242131304318587\nhelp.text", "note": "ASLWJ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6584, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 38, "source_unit": "https://translations.documentfoundation.org/api/units/24950764/?format=api", "priority": 100, "id": 1511485, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=831e13989d8b1f1b", "url": "https://translations.documentfoundation.org/api/units/1511485/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.120163Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<emph>Alpha</emph> – optional argument. The value for the alpha channel or alpha composite. Alpha is a integer value between 0 and 255. The value of zero for alpha means the color is fully transparent, whereas a value of 255 in the alpha channel gives a fully opaque color." ], "previous_source": "", "target": [ "<emph>Alfa</emph> – argumento opcional. El valor para el canal alfa o alfa compuesto. Alfa es un valor entero entre 0 y 255. El valor de cero para alfa significa que el color es totalmente transparente, mientras que un valor de 255 en el canal alfa da un color completamente opaco." ], "id_hash": 8574439046245092510, "content_hash": 8574439046245092510, "location": "func_color.xhp", "context": "func_color.xhp\npar_id242131304315587\nhelp.text", "note": "GoCn2", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6585, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 48, "source_unit": "https://translations.documentfoundation.org/api/units/24950765/?format=api", "priority": 100, "id": 1511486, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=f6fe86e21bad8c9e", "url": "https://translations.documentfoundation.org/api/units/1511486/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.129792Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<item type=\"input\">COLOR(255;255;255;1)</item> returns 33554431" ], "previous_source": "", "target": [ "<item type=\"input\">COLOR(255;255;255;1)</item> devuelve 33554431" ], "id_hash": -3533301182499384046, "content_hash": -3533301182499384046, "location": "func_color.xhp", "context": "func_color.xhp\npar_id1102201617001888\nhelp.text", "note": "fb2sj", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6586, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/24950766/?format=api", "priority": 100, "id": 1511487, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=4ef7314b74a81512", "url": "https://translations.documentfoundation.org/api/units/1511487/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.143329Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<item type=\"input\">COLOR(0;0;255;0)</item> returns 255" ], "previous_source": "", "target": [ "<item type=\"input\">COLOR(0;0;255;0)</item> devuelve 255" ], "id_hash": 4921398467606995934, "content_hash": 4921398467606995934, "location": "func_color.xhp", "context": "func_color.xhp\npar_id1102201618185378\nhelp.text", "note": "gxbF2", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6587, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/24950767/?format=api", "priority": 100, "id": 1511488, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=c44c51d4e3dde3de", "url": "https://translations.documentfoundation.org/api/units/1511488/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.155698Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<item type=\"input\">COLOR(0;0;255;255)</item> returns 4278190335" ], "previous_source": "", "target": [ "<item type=\"input\">COLOR(0;0;255;255)</item> devuelve 4278190335" ], "id_hash": 8589781915333483172, "content_hash": 8589781915333483172, "location": "func_color.xhp", "context": "func_color.xhp\npar_id1102201618185326\nhelp.text", "note": "f8bh7", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6588, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/24950768/?format=api", "priority": 100, "id": 1511489, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=f73509243186daa4", "url": "https://translations.documentfoundation.org/api/units/1511489/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.165898Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<item type=\"input\">COLOR(0;0;400;0)</item> returns Err:502 (Invalid argument) because the blue value is greater than 255." ], "previous_source": "", "target": [ "<item type=\"input\">COLOR(0;0;400;0)</item> devuelve Err:502 (argumento no válido) porque el valor del azul es mayor que 255." ], "id_hash": -224256149759823711, "content_hash": -224256149759823711, "location": "func_color.xhp", "context": "func_color.xhp\npar_id1102201618188326\nhelp.text", "note": "JAYa2", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6589, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/24950769/?format=api", "priority": 100, "id": 1511490, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=7ce348384ede70a1", "url": "https://translations.documentfoundation.org/api/units/1511490/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.178033Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "CONCAT function" ], "previous_source": "", "target": [ "Función CONCAT" ], "id_hash": 8796333322820937330, "content_hash": 8796333322820937330, "location": "func_concat.xhp", "context": "func_concat.xhp\ntit\nhelp.text", "note": "cfeEJ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6591, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24950770/?format=api", "priority": 100, "id": 1511491, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=fa12da8d58ac6672", "url": "https://translations.documentfoundation.org/api/units/1511491/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.189291Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<bookmark_value>CONCAT function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>Función CONCAT</bookmark_value>" ], "id_hash": 7991029942349640886, "content_hash": 7991029942349640886, "location": "func_concat.xhp", "context": "func_concat.xhp\nbm_id741556228031712\nhelp.text", "note": "WEfAD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6592, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24950771/?format=api", "priority": 100, "id": 1511492, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=eee5d764ef42b4b6", "url": "https://translations.documentfoundation.org/api/units/1511492/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.200231Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<variable id=\"concatfunction\"><ahelp hid=\".\">Concatenates one or more strings</ahelp></variable>" ], "previous_source": "", "target": [ "<variable id=\"concatfunction\"><ahelp hid=\".\">Concatena una o más cadenas</ahelp></variable>" ], "id_hash": -5610100621238531896, "content_hash": -5610100621238531896, "location": "func_concat.xhp", "context": "func_concat.xhp\npar_id891556226436781\nhelp.text", "note": "jUBjE", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6594, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/24950773/?format=api", "priority": 100, "id": 1511494, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=3224eb3564e108c8", "url": "https://translations.documentfoundation.org/api/units/1511494/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.227118Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "CONCAT is an enhancement of CONCATENATE, as CONCAT also accepts ranges as arguments, like B2:E5, K:K or K:M." ], "previous_source": "", "target": [ "CONCAT es una mejora de CONCATENATE, ya que CONCAT también acepta rangos como argumentos, como B2:E5, K:K o K:M." ], "id_hash": -7887419252229086841, "content_hash": -7887419252229086841, "location": "func_concat.xhp", "context": "func_concat.xhp\npar_id701556226865876\nhelp.text", "note": "JPUiF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6595, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/24950774/?format=api", "priority": 100, "id": 1511495, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=128a41fabc4ee187", "url": "https://translations.documentfoundation.org/api/units/1511495/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.238774Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "When ranges are used, the cells are traversed row by row (from top to bottom) to concatenate." ], "previous_source": "", "target": [ "Cuando se utilizan intervalos, las celdas se concatenan fila por fila (de arriba abajo)." ], "id_hash": -2290829766087122999, "content_hash": -2290829766087122999, "location": "func_concat.xhp", "context": "func_concat.xhp\npar_id461556226873963\nhelp.text", "note": "Gjz3x", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6596, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 17, "source_unit": "https://translations.documentfoundation.org/api/units/24950775/?format=api", "priority": 100, "id": 1511496, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=603556770f7c5fc9", "url": "https://translations.documentfoundation.org/api/units/1511496/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.249446Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<input>=CONCAT(\"Hello \", A1:C3)</input> concatenates the string \"Hello\" with all strings in range <literal>A1:C3</literal>." ], "previous_source": "", "target": [ "<input>=CONCAT(\"Hola \", A1:C3)</input> concatena la cadena \"Hola\" con todas las cadenas en el intervalo <literal>A1:C3</literal>." ], "id_hash": -5928279230692924343, "content_hash": -5928279230692924343, "location": "func_concat.xhp", "context": "func_concat.xhp\npar_id531556227248228\nhelp.text", "note": "aTwgH", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6598, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/24950778/?format=api", "priority": 100, "id": 1511499, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=2dba8572f538e449", "url": "https://translations.documentfoundation.org/api/units/1511499/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.280065Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "COUNTIFS function" ], "previous_source": "", "target": [ "Función CONTAR.SI.CONJUNTO" ], "id_hash": -6243986017061160968, "content_hash": -6243986017061160968, "location": "func_countifs.xhp", "context": "func_countifs.xhp\ntit\nhelp.text", "note": "JEUej", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6797, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24950780/?format=api", "priority": 100, "id": 1511501, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=2958e7ccae9037f8", "url": "https://translations.documentfoundation.org/api/units/1511501/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.300771Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<bookmark_value>COUNTIFS function</bookmark_value> <bookmark_value>counting row;satisfying criteria</bookmark_value> <bookmark_value>counting column;satisfying criteria</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>CONTAR.SI</bookmark_value> <bookmark_value>contar fila;satisfacer criterio</bookmark_value> <bookmark_value>contar columna;satisfacer criterio</bookmark_value>" ], "id_hash": 7428600837714162632, "content_hash": 7428600837714162632, "location": "func_countifs.xhp", "context": "func_countifs.xhp\nbm_id452245224522\nhelp.text", "note": "Kprey", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6798, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/24950781/?format=api", "priority": 100, "id": 1511502, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=e717b11a7e1f33c8", "url": "https://translations.documentfoundation.org/api/units/1511502/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.310867Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<ahelp hid=\".\"><variable id=\"countifs_des\">Returns the count of cells that meet criteria in multiple ranges.</variable></ahelp>" ], "previous_source": "", "target": [ "<ahelp hid=\".\"><variable id=\"countifs_des\">Devuelve el recuento de celdas que cumplen los criterios en varios intervalos.</variable></ahelp>" ], "id_hash": -2781884893230868017, "content_hash": -2781884893230868017, "location": "func_countifs.xhp", "context": "func_countifs.xhp\npar_id462646264626\nhelp.text", "note": "pGTzr", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6800, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/24950783/?format=api", "priority": 100, "id": 1511504, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=5964c26dbcf2d9cf", "url": "https://translations.documentfoundation.org/api/units/1511504/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.338915Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "Simple usage" ], "previous_source": "", "target": [ "Uso simple" ], "id_hash": -659577220271956714, "content_hash": -659577220271956714, "location": "func_countifs.xhp", "context": "func_countifs.xhp\nhd_id3861259759512\nhelp.text", "note": "ZuFZj", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6803, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24950787/?format=api", "priority": 100, "id": 1511508, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=76d8b60343c01d16", "url": "https://translations.documentfoundation.org/api/units/1511508/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.397635Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<item type=\"input\">=COUNTIFS(B2:B6;\">=20\")</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=CONTAR.SI.CONJUNTO(B2:B6;\">=20\")</item>" ], "id_hash": -4670497673572942546, "content_hash": -4670497673572942546, "location": "func_countifs.xhp", "context": "func_countifs.xhp\npar_id15856592423333\nhelp.text", "note": "uDqwg", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6804, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24950788/?format=api", "priority": 100, "id": 1511509, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=3f2f0f1c7a657d2e", "url": "https://translations.documentfoundation.org/api/units/1511509/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.411602Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "Counts the amount of rows of the range B2:B6 with values greater than or equal to 20. Returns 3, because the fifth and the sixth rows do not meet the criterion." ], "previous_source": "", "target": [ "Cuenta la cantidad de filas del intervalo B2:B6 con valores mayores o iguales que 20. Devuelve 3 porque las filas quinta y sexta no cumplen con el criterio." ], "id_hash": -7561950072014493005, "content_hash": -7561950072014493005, "location": "func_countifs.xhp", "context": "func_countifs.xhp\npar_id323511393121175\nhelp.text", "note": "JCUwJ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6805, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 31, "source_unit": "https://translations.documentfoundation.org/api/units/24950789/?format=api", "priority": 100, "id": 1511510, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=170e8e7974562ab3", "url": "https://translations.documentfoundation.org/api/units/1511510/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.425619Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<item type=\"input\">=COUNTIFS(B2:B6;\">=20\";C2:C6;\">70\")</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=CONTAR.SI.CONJUNTO(B2:B6;\">=20\";C2:C6;\">70\")</item>" ], "id_hash": -2064120978503549065, "content_hash": -2064120978503549065, "location": "func_countifs.xhp", "context": "func_countifs.xhp\npar_id74301057922522\nhelp.text", "note": "4aGmq", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6806, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24950790/?format=api", "priority": 100, "id": 1511511, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=635ac4e7fedd3f77", "url": "https://translations.documentfoundation.org/api/units/1511511/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.435650Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "Counts the amount of rows that contain simultaneously values greater than 70 in the C2:C6 range and values greater than or equal to 20 in the B2:B6 range. Returns 2, because the second, the fifth and the sixth rows do not meet at least one criterion." ], "previous_source": "", "target": [ "Cuenta la cantidad de filas que contiene simultáneamente valores mayores que 70 en el intervalo C2:C6 y valores mayores o iguales que 20 en el intervalo B2:B6. Devuelve 2 porque las filas segunda, quinta y sexta no cumplen con al menos un criterio." ], "id_hash": -4863093154484712128, "content_hash": -4863093154484712128, "location": "func_countifs.xhp", "context": "func_countifs.xhp\npar_id109622995127628\nhelp.text", "note": "AyFxS", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6807, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 46, "source_unit": "https://translations.documentfoundation.org/api/units/24950791/?format=api", "priority": 100, "id": 1511512, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=3c82d28ab14e0d40", "url": "https://translations.documentfoundation.org/api/units/1511512/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.446095Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "Using regular expressions and nested functions" ], "previous_source": "", "target": [ "Uso de expresiones regulares y funciones anidadas" ], "id_hash": 7805936436593049902, "content_hash": 7805936436593049902, "location": "func_countifs.xhp", "context": "func_countifs.xhp\nhd_id298462825526166\nhelp.text", "note": "AGcGC", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6808, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/24950792/?format=api", "priority": 100, "id": 1511513, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=ec5441d4da68412e", "url": "https://translations.documentfoundation.org/api/units/1511513/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.457968Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<item type=\"input\">=COUNTIFS(B2:B6;\"[:alpha:]*\")</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=CONTAR.SI.CONJUNTO(B2:B6;\"[:alpha:]*\")</item>" ], "id_hash": 5738611906303249504, "content_hash": 5738611906303249504, "location": "func_countifs.xhp", "context": "func_countifs.xhp\npar_id22736248573471\nhelp.text", "note": "iHFsx", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6810, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24950793/?format=api", "priority": 100, "id": 1511514, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=cfa3a51fd3084c60", "url": "https://translations.documentfoundation.org/api/units/1511514/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.470021Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "Counts the amount of rows of the B2:B6 range that contain only alphabet symbols. Returns 1, because only sixth row meets the criterion." ], "previous_source": "", "target": [ "Cuenta la cantidad de filas del intervalo B2:B6 que contienen solamente símbolos alfabéticos. Devuelve 1 porque solo la sexta fila cumple con el criterio." ], "id_hash": 4173716747243937198, "content_hash": 4173716747243937198, "location": "func_countifs.xhp", "context": "func_countifs.xhp\npar_id22137303324873\nhelp.text", "note": "yiHkH", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6811, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 23, "source_unit": "https://translations.documentfoundation.org/api/units/24950794/?format=api", "priority": 100, "id": 1511515, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=b9ec0544b092ddae", "url": "https://translations.documentfoundation.org/api/units/1511515/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.480323Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<item type=\"input\">=COUNTIFS(B2:B6;\">\"&MIN(B2:B6);B2:B6;\"<\"&MAX(B2:B6))</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=CONTAR.SI.CONJUNTO(B2:B6;\">\"&MIN(B2:B6);B2:B6;\"<\"&MAX(B2:B6))</item>" ], "id_hash": 2557626990426261548, "content_hash": 2557626990426261548, "location": "func_countifs.xhp", "context": "func_countifs.xhp\npar_id82271340221411\nhelp.text", "note": "pNABF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6812, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24950795/?format=api", "priority": 100, "id": 1511516, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=a37e8432684f082c", "url": "https://translations.documentfoundation.org/api/units/1511516/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.493816Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "Counts the amount of rows of the B2:B6 range excluding rows with minimum and maximum values of this range. Returns 2, because the third, the fifth and the sixth rows do not meet at least one criterion." ], "previous_source": "", "target": [ "Contabiliza las filas en el intervalo B2:B6, excluyendo las filas con los valores mínimo y máximo de este intervalo. Devuelve 2, porque las filas tercera, quinta y sexta no cumplen con por lo menos un criterio." ], "id_hash": -4856747075060767854, "content_hash": -4856747075060767854, "location": "func_countifs.xhp", "context": "func_countifs.xhp\npar_id1105320769334\nhelp.text", "note": "72QET", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6813, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 37, "source_unit": "https://translations.documentfoundation.org/api/units/24950796/?format=api", "priority": 100, "id": 1511517, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=3c995e447315e392", "url": "https://translations.documentfoundation.org/api/units/1511517/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.507008Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<item type=\"input\">=COUNTIFS(A2:A6;\"pen.*\";B2:B6;\"<\"&MAX(B2:B6))</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=CONTAR.SI.CONJUNTO(A2:A6;\"cla.*\";B2:B6;\"<\"&MAX(B2:B6))</item>" ], "id_hash": -849600324358677609, "content_hash": -849600324358677609, "location": "func_countifs.xhp", "context": "func_countifs.xhp\npar_id267603146513224\nhelp.text", "note": "jdWB5", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6814, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24950797/?format=api", "priority": 100, "id": 1511518, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=74359d01a18b5b97", "url": "https://translations.documentfoundation.org/api/units/1511518/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.520336Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "Counts the amount of rows that correspond to all cells of the A2:A6 range starting with \"pen\" and to all cells of the B2:B6 range with exception of its maximum. Returns 1, because only second row meets all criteria." ], "previous_source": "", "target": [ "Cuenta la cantidad de filas que corresponde a todas las celdas del intervalo A2:A6 que comienzan por «cla» y a todas las celdas del intervalo B2:B6 con la excepción de su máximo. Devuelve 1 porque solo la segunda fila cumple con todos los criterios." ], "id_hash": -1581394730398256572, "content_hash": -1581394730398256572, "location": "func_countifs.xhp", "context": "func_countifs.xhp\npar_id111252614832220\nhelp.text", "note": "L6af2", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6815, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 39, "source_unit": "https://translations.documentfoundation.org/api/units/24950798/?format=api", "priority": 100, "id": 1511519, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=6a0dc1df0ceff244", "url": "https://translations.documentfoundation.org/api/units/1511519/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.533229Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "Reference to a cell as a criterion" ], "previous_source": "", "target": [ "Referencia a una celda como criterio" ], "id_hash": -8660103929084940670, "content_hash": -8660103929084940670, "location": "func_countifs.xhp", "context": "func_countifs.xhp\nhd_id212582362610399\nhelp.text", "note": "rG36d", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6816, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/24950799/?format=api", "priority": 100, "id": 1511520, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=07d1215c14ed6e82", "url": "https://translations.documentfoundation.org/api/units/1511520/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.547990Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "If you need to change a criterion easily, you may want to specify it in a separate cell and use a reference to this cell in the condition of the COUNTIFS function. For example, the above function can be rewritten as follows:" ], "previous_source": "", "target": [ "Si se necesita cambiar un criterio fácilmente, se puede especificar en una celda separada y usar la referencia a esa celda en la condición de la función CONTAR.SI.CONJUNTO. Por ejemplo, la función anterior puede reescribirse así:" ], "id_hash": -3306896990901796710, "content_hash": -3306896990901796710, "location": "func_countifs.xhp", "context": "func_countifs.xhp\npar_id3245551524846\nhelp.text", "note": "ABwGC", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6817, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 42, "source_unit": "https://translations.documentfoundation.org/api/units/24950800/?format=api", "priority": 100, "id": 1511521, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=521b8ab51c7d809a", "url": "https://translations.documentfoundation.org/api/units/1511521/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.561604Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<item type=\"input\">=COUNTIFS(A2:A6;E2&\".*\";B2:B6;\"<\"&MAX(B2:B6))</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=CONTAR.SI.CONJUNTO(A2:A6;E2&\".*\";B2:B6;\"<\"&MAX(B2:B6))</item>" ], "id_hash": 5460089609370278782, "content_hash": 5460089609370278782, "location": "func_countifs.xhp", "context": "func_countifs.xhp\npar_id109501907712434\nhelp.text", "note": "3TTwe", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6818, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24950801/?format=api", "priority": 100, "id": 1511522, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=cbc6229228511b7e", "url": "https://translations.documentfoundation.org/api/units/1511522/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.575505Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "If E2 = pen, the function returns 1, because the link to the cell is substituted with its content and it works as a function above." ], "previous_source": "", "target": [ "Si E2 = pen, la función devuelve 1, porque el enlace a la celda se sustituye por su contenido y funciona como la función anterior." ], "id_hash": 750788171635273601, "content_hash": 750788171635273601, "location": "func_countifs.xhp", "context": "func_countifs.xhp\npar_id738533068520\nhelp.text", "note": "CNQBL", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6819, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/24950802/?format=api", "priority": 100, "id": 1511523, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=8a6b55dd3fe2af81", "url": "https://translations.documentfoundation.org/api/units/1511523/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.588417Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "DATE" ], "previous_source": "", "target": [ "FECHA" ], "id_hash": 2251092497364006255, "content_hash": 2251092497364006255, "location": "func_date.xhp", "context": "func_date.xhp\ntit\nhelp.text", "note": "GW3GV", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6821, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24950803/?format=api", "priority": 100, "id": 1511524, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=9f3d7cb315edb56f", "url": "https://translations.documentfoundation.org/api/units/1511524/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.601600Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<bookmark_value>DATE function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>FECHA</bookmark_value>" ], "id_hash": -8529043966727092037, "content_hash": -8529043966727092037, "location": "func_date.xhp", "context": "func_date.xhp\nbm_id3155511\nhelp.text", "note": "xCZGR", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6822, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24950804/?format=api", "priority": 100, "id": 1511525, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=09a2bfb3798b08bb", "url": "https://translations.documentfoundation.org/api/units/1511525/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.611670Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<variable id=\"date\"><link href=\"text/scalc/01/func_date.xhp\">DATE</link></variable>" ], "previous_source": "", "target": [ "<variable id=\"date\"><link href=\"text/scalc/01/func_date.xhp\">FECHA</link></variable>" ], "id_hash": 1935387799744484713, "content_hash": 1935387799744484713, "location": "func_date.xhp", "context": "func_date.xhp\nhd_id3155511\nhelp.text", "note": "TioqL", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6823, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/24950805/?format=api", "priority": 100, "id": 1511526, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=9adbe0f322651569", "url": "https://translations.documentfoundation.org/api/units/1511526/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.623862Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_DATUM\">This function calculates a date specified by year, month, day and displays it in the cell's formatting.</ahelp> The default format of a cell containing the DATE function is the date format, but you can format the cells with any other number format." ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_DATUM\">Este función calcula una fecha, especificada por año, mes, día y lo muestra en el formato de la celda.</ahelp> El formato predeterminado de una celda que contiene la función DATE es el formato de fecha, pero puede formatearlo las celdas con cualquier otro formato numérico." ], "id_hash": -3191741950403674441, "content_hash": -3191741950403674441, "location": "func_date.xhp", "context": "func_date.xhp\npar_id3153551\nhelp.text", "note": "Wa2yU", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6824, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 43, "source_unit": "https://translations.documentfoundation.org/api/units/24950806/?format=api", "priority": 100, "id": 1511527, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=53b4a79b4f79feb7", "url": "https://translations.documentfoundation.org/api/units/1511527/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.636716Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "DATE(Year; Month; Day)" ], "previous_source": "", "target": [ "FECHA(Año; Mes; Día)" ], "id_hash": -368305019053121377, "content_hash": -368305019053121377, "location": "func_date.xhp", "context": "func_date.xhp\npar_id3150474\nhelp.text", "note": "wCGHA", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6825, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/24950807/?format=api", "priority": 100, "id": 1511528, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=7ae384895a58609f", "url": "https://translations.documentfoundation.org/api/units/1511528/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.653607Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<emph>Year</emph> is an integer between 1583 and 9957 or between 0 and 99." ], "previous_source": "", "target": [ "<emph>Año</emph> es un entero entre 1583 y 9957 o entre 0 y 99." ], "id_hash": -2694903448988203180, "content_hash": -2694903448988203180, "location": "func_date.xhp", "context": "func_date.xhp\npar_id3152815\nhelp.text", "note": "zExSG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6826, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/24950808/?format=api", "priority": 100, "id": 1511529, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=5a99c79763154754", "url": "https://translations.documentfoundation.org/api/units/1511529/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.666653Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "In <switchinline select=\"sys\"><caseinline select=\"MAC\"><item type=\"menuitem\">%PRODUCTNAME - Preferences</item></caseinline><defaultinline><item type=\"menuitem\">Tools - Options</item></defaultinline></switchinline><item type=\"menuitem\"> - $[officename] - General </item>you can set from which year a two-digit number entry is recognized as 20xx." ], "previous_source": "", "target": [ "En <switchinline select=\"sys\"><caseinline select=\"MAC\"><item type=\"menuitem\">%PRODUCTNAME ▸ Preferencias</item></caseinline><defaultinline><item type=\"menuitem\">Herramientas ▸ Opciones</item></defaultinline></switchinline><item type=\"menuitem\"> ▸ $[officename] ▸ Generales </item>puede establecer desde qué año se reconocerá la introducción de un número de dos dígitos como 20xx." ], "id_hash": -4638706367466650632, "content_hash": -4638706367466650632, "location": "func_date.xhp", "context": "func_date.xhp\npar_id3153222\nhelp.text", "note": "WVjaD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6827, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/24950809/?format=api", "priority": 100, "id": 1511530, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=3fa00122bdcec3f8", "url": "https://translations.documentfoundation.org/api/units/1511530/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.681392Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/es/?format=api", "source": [ "<emph>Month</emph> is an integer indicating the month." ], "previous_source": "", "target": [ "<emph>Mes</emph> es un entero que indica el mes." ], "id_hash": 7683876209887228883, "content_hash": 7683876209887228883, "location": "func_date.xhp", "context": "func_date.xhp\npar_id3155817\nhelp.text", "note": "uuZQH", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6828, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/24950810/?format=api", "priority": 100, "id": 1511531, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/es/?checksum=eaa29cb3b46733d3", "url": "https://translations.documentfoundation.org/api/units/1511531/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.696476Z" } ] }