Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-7-6/textscalc01/es/units/?format=api&page=151
{ "count": 8352, "next": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/units/?format=api&page=152", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/units/?format=api&page=150", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<item type=\"input\">=SUMIFS(B2:B6;B2:B6;\">=20\")</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=SUMAR.SI.CONJUNTO(B2:B6;B2:B6;\">=20\")</item>" ], "id_hash": -3980841953204373942, "content_hash": -3980841953204373942, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\npar_id94321051525036\nhelp.text", "note": "tqgKL", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7501, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99335904/?format=api", "priority": 100, "id": 100448307, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=48c13555c047f64a", "url": "https://translations.documentfoundation.org/api/units/100448307/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:26:25.833509Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "Calculates the sum of values of the range B2:B6 that are greater than or equal to 20. Returns 75, because the fifth row does not meet the criterion." ], "previous_source": "", "target": [ "Calcula la suma de los valores del intervalo B2:B6 que son mayores o iguales que 20. Devuelve 75 porque la quinta fila no cumple con el criterio." ], "id_hash": -8584625317315816146, "content_hash": -8584625317315816146, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\npar_id28647227259438\nhelp.text", "note": "NK7QS", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7502, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 28, "source_unit": "https://translations.documentfoundation.org/api/units/99335965/?format=api", "priority": 100, "id": 100448309, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=08dd48c1d790d52e", "url": "https://translations.documentfoundation.org/api/units/100448309/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:26:25.834729Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<item type=\"input\">=SUMIFS(C2:C6;B2:B6;\">=20\";C2:C6;\">70\")</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=SUMAR.SI.CONJUNTO(C2:C6;B2:B6;\">=20\";C2:C6;\">70\")</item>" ], "id_hash": -9075336950328213574, "content_hash": -9075336950328213574, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\npar_id36952767622741\nhelp.text", "note": "TzCFB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7503, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99336000/?format=api", "priority": 100, "id": 100448311, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=020ded207ab5bfba", "url": "https://translations.documentfoundation.org/api/units/100448311/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:26:25.836159Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "Calculates the sum of values of the range C2:C6 that are greater than 70 and correspond to cells of the B2:B6 range with values greater than or equal to 20. Returns 275, because the second and the fifth rows do not meet at least one criterion." ], "previous_source": "", "target": [ "Calcula la suma de los valores en el intervalo C2:C6 que son mayores que 70 y que se corresponden con las celdas del intervalo B2:B6 con valores mayores o iguales que 20. Devuelve 275 porque las filas segunda y quinta no cumplen con por lo menos un criterio." ], "id_hash": 5531634363620764760, "content_hash": 5531634363620764760, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\npar_id189772445525114\nhelp.text", "note": "or3BG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7504, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 46, "source_unit": "https://translations.documentfoundation.org/api/units/99336066/?format=api", "priority": 100, "id": 100448313, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=ccc4502556f5ac58", "url": "https://translations.documentfoundation.org/api/units/100448313/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:26:25.837967Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "Using regular expressions and nested functions" ], "previous_source": "", "target": [ "Uso de expresiones regulares y funciones anidadas" ], "id_hash": -7905416432563865011, "content_hash": -7905416432563865011, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\nhd_id30455222431067\nhelp.text", "note": "YHh9T", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7505, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/99336087/?format=api", "priority": 100, "id": 100448315, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=124a51a3a77eba4d", "url": "https://translations.documentfoundation.org/api/units/100448315/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:26:25.839764Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<item type=\"input\">=SUMIFS(C2:C6;B2:B6;\">\"&MIN(B2:B6);B2:B6;\"<\"&MAX(B2:B6))</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=SUMAR.SI.CONJUNTO(C2:C6;B2:B6;\">\"&MIN(B2:B6);B2:B6;\"<\"&MAX(B2:B6))</item>" ], "id_hash": -7100679125014514541, "content_hash": -7100679125014514541, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\npar_id307691022525348\nhelp.text", "note": "Ust3n", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7506, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99336111/?format=api", "priority": 100, "id": 100448318, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=1d7551f4f17a7493", "url": "https://translations.documentfoundation.org/api/units/100448318/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:26:27.848474Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "Calculates the sum of values of the range C2:C6 that correspond to all values of the range B2:B6 except its minimum and maximum. Returns 255, because the third and the fifth rows do not meet at least one criterion." ], "previous_source": "", "target": [ "Calcula la suma de los valores en el intervalo C2:C6 que se corresponden con todos los valores del intervalo B2:B6, exceptuando su mínimo y su máximo. Devuelve 255 porque las filas tercera y quinta no cumplen con por lo menos un criterio." ], "id_hash": -3296253579067716392, "content_hash": -3296253579067716392, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\npar_id27619246864839\nhelp.text", "note": "wCeGS", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7507, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 39, "source_unit": "https://translations.documentfoundation.org/api/units/99336194/?format=api", "priority": 100, "id": 100448421, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=52415ad58a0f0cd8", "url": "https://translations.documentfoundation.org/api/units/100448421/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:26:28.079265Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<item type=\"input\">=SUMIFS(C2:C6;A2:A6;\"pen.*\";B2:B6;\"<\"&MAX(B2:B6))</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=SUMAR.SI.CONJUNTO(C2:C6;A2:A6;\"pan.*\";B2:B6;\"<\"&MAX(B2:B6))</item>" ], "id_hash": 993849274358828000, "content_hash": 993849274358828000, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\npar_id220502883332563\nhelp.text", "note": "tETJF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7508, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99336255/?format=api", "priority": 100, "id": 100448423, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=8dcadca63e700be0", "url": "https://translations.documentfoundation.org/api/units/100448423/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:26:28.080946Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "Calculates the sum of 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 la suma de los valores del intervalo C2:C6 que se corresponden con todas las celdas del intervalo A2:A6 que comienzan por «pan» y con 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": -3162333369531084074, "content_hash": -3162333369531084074, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\npar_id15342189586295\nhelp.text", "note": "u7CDd", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7509, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 41, "source_unit": "https://translations.documentfoundation.org/api/units/99336282/?format=api", "priority": 100, "id": 100448425, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=541d228e1fbc52d6", "url": "https://translations.documentfoundation.org/api/units/100448425/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:26:28.082313Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "Reference to a cell as a criterion" ], "previous_source": "", "target": [ "Referencia a una celda como criterio" ], "id_hash": 3615373838218159194, "content_hash": 3615373838218159194, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\nhd_id8168283329426\nhelp.text", "note": "dKeLC", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7510, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/99336382/?format=api", "priority": 100, "id": 100448427, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=b22c6359cd3be45a", "url": "https://translations.documentfoundation.org/api/units/100448427/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:26:28.083556Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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 SUMIFS function. For example, the above function can be rewritten as follows:" ], "previous_source": "", "target": [ "Si se necesita cambiar un criterio fácilmente, puede especificarlo en ena celda separada y usar una referencia a esa celda en la condición de la función SUMAR.SI.CONJUNTO. Por ejemplo, la función anterios puede reescribirse así:" ], "id_hash": 2034425885526726680, "content_hash": 2034425885526726680, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\npar_id50762995519951\nhelp.text", "note": "NzNhA", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7511, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 42, "source_unit": "https://translations.documentfoundation.org/api/units/99336431/?format=api", "priority": 100, "id": 100448430, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=9c3bbb9064ae1818", "url": "https://translations.documentfoundation.org/api/units/100448430/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:26:28.084550Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<item type=\"input\">=SUMIFS(C2:C6;A2:A6;E2&\".*\";B2:B6;\"<\"&MAX(B2:B6))</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=SUMAR.SI.CONJUNTO(C2:C6;A2:A6;E2&\".*\";B2:B6;\"<\"&MAX(B2:B6))</item>" ], "id_hash": 3624176247368206676, "content_hash": 3624176247368206676, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\npar_id135761606425300\nhelp.text", "note": "U2wwM", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7512, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99336473/?format=api", "priority": 100, "id": 100448432, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=b24ba91863ca4954", "url": "https://translations.documentfoundation.org/api/units/100448432/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:26:28.085862Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/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 = pen, la función devuelve 65 porque el link a la celda se sustituye por su contenido." ], "id_hash": 814313685569042024, "content_hash": 814313685569042024, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\npar_id30574750215839\nhelp.text", "note": "wGhZA", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7513, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/99336510/?format=api", "priority": 100, "id": 100448434, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=8b4d05fb8c14f668", "url": "https://translations.documentfoundation.org/api/units/100448434/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:26:28.087330Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/SUMIFS\">SUMIFS wiki page</link>." ], "previous_source": "", "target": [ "" ], "id_hash": 7190414165576488981, "content_hash": 7190414165576488981, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\npar_id971677014512029\nhelp.text", "note": "FEg3K", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7514, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/99336551/?format=api", "priority": 100, "id": 100448436, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=e3c97b964f1f9815", "url": "https://translations.documentfoundation.org/api/units/100448436/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:26:28.088497Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "SWITCH function" ], "previous_source": "", "target": [ "Función CAMBIAR" ], "id_hash": 5686056986956170649, "content_hash": 5686056986956170649, "location": "func_switch.xhp", "context": "func_switch.xhp\ntit\nhelp.text", "note": "UUeQC", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7515, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99336597/?format=api", "priority": 100, "id": 100448437, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=cee8eeb420268599", "url": "https://translations.documentfoundation.org/api/units/100448437/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:26:28.089515Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<bookmark_value>SWITCH function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>función CAMBIAR</bookmark_value>" ], "id_hash": -2260707101919447878, "content_hash": -2260707101919447878, "location": "func_switch.xhp", "context": "func_switch.xhp\nbm_id571556244875552\nhelp.text", "note": "5ALMt", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7516, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99336629/?format=api", "priority": 100, "id": 100448439, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=60a05ade58e374ba", "url": "https://translations.documentfoundation.org/api/units/100448439/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:26:28.090495Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<variable id=\"switchfunct\"><link href=\"text/scalc/01/func_switch.xhp\">SWITCH</link></variable>" ], "previous_source": "", "target": [ "<variable id=\"switchfunct\"><link href=\"text/scalc/01/func_switch.xhp\">CAMBIAR</link></variable>" ], "id_hash": -477269484934871315, "content_hash": -477269484934871315, "location": "func_switch.xhp", "context": "func_switch.xhp\nhd_id21556242313791\nhelp.text", "note": "F6kQd", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7517, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99336671/?format=api", "priority": 100, "id": 100448441, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=796065eea052c6ed", "url": "https://translations.documentfoundation.org/api/units/100448441/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:26:28.091791Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<variable id=\"functionswitch\"><ahelp hid=\".\">SWITCH compares <emph>expression</emph> with <emph>value1</emph> to <emph>valuen</emph> and returns the result belonging to the first value that equals expression. If there is no match and default_result is given, that will be returned.</ahelp></variable>" ], "previous_source": "", "target": [ "<variable id=\"functionswitch\"><ahelp hid=\".\"> CAMBIAR Compara<emph>expresión</emph>con<emph>valor</emph>Para<emph>valor</emph>y devuelve el resultado que pertenece al primer valor que es igual a la expresión. Si no hay coincidencia y se da default_result, se devolverá</ahelp></variable>" ], "id_hash": 3196169826997080294, "content_hash": 3196169826997080294, "location": "func_switch.xhp", "context": "func_switch.xhp\npar_id361556242313793\nhelp.text", "note": "vaCEi", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7518, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 34, "source_unit": "https://translations.documentfoundation.org/api/units/99336686/?format=api", "priority": 100, "id": 100448443, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=ac5b13860bfb90e6", "url": "https://translations.documentfoundation.org/api/units/100448443/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:26:28.093249Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "SWITCH(expression; value1; result1[; value2; result2][; ... ; [value127; result127][; default_result]])" ], "previous_source": "", "target": [ "CAMBIAR((expresión; valor1; resultado1[; valor2; resultado2][; ... ; [valor127; resultado127][; predeterminado_resultado]])" ], "id_hash": -1442936473756366974, "content_hash": -1442936473756366974, "location": "func_switch.xhp", "context": "func_switch.xhp\npar_id521556242803283\nhelp.text", "note": "tFvZx", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7519, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/99336718/?format=api", "priority": 100, "id": 100448445, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=6bf9a8ec104c0782", "url": "https://translations.documentfoundation.org/api/units/100448445/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:26:28.094750Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "If you choose not to specify a default result, 127 value / result pairs may be entered as parameters. If you choose to include a default result at the end of the list of parameters, then only 126 value / result pairs may be entered." ], "previous_source": "", "target": [ "Si elige no especificar un resultado predeterminado, se pueden introducir 127 pares de valor / resultado como parámetros. Si elige incluir un resultado predeterminado al final de la lista de parámetros, solo 126 valores/ se pueden introducir pares de resultados." ], "id_hash": -5786508699232931422, "content_hash": -5786508699232931422, "location": "func_switch.xhp", "context": "func_switch.xhp\npar_id111585520651521\nhelp.text", "note": "p8fL8", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7520, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 45, "source_unit": "https://translations.documentfoundation.org/api/units/99336736/?format=api", "priority": 100, "id": 100448447, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=2fb230ff0c8371a2", "url": "https://translations.documentfoundation.org/api/units/100448447/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:26:28.095817Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<emph>expression</emph> is a text, numeric, logical or date input or reference to a cell." ], "previous_source": "", "target": [ "<emph>expresión</emph> es una entrada de texto, numérica, lógica o de fecha, o bien, una referencia a otra celda." ], "id_hash": 9117707988652973551, "content_hash": 9117707988652973551, "location": "func_switch.xhp", "context": "func_switch.xhp\npar_id341556242996378\nhelp.text", "note": "nnW4D", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7521, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/99336749/?format=api", "priority": 100, "id": 100448449, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=fe889b1ba566ddef", "url": "https://translations.documentfoundation.org/api/units/100448449/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:26:28.096962Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<emph>value1, value2, ...</emph> is any value or reference to a cell. Each value must have a result given." ], "previous_source": "", "target": [ "<emph>valor1, valor2, ...</emph> es cualquier valor o referencia a una celda. Cada valor debe tener un resultado dado." ], "id_hash": 2789162408943903381, "content_hash": 2789162408943903381, "location": "func_switch.xhp", "context": "func_switch.xhp\npar_id321556243790332\nhelp.text", "note": "Z7xiA", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7522, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/99336775/?format=api", "priority": 100, "id": 100448451, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=a6b5186eedf96295", "url": "https://translations.documentfoundation.org/api/units/100448451/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:26:28.098085Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<emph>result1, result2, ...</emph> is any value or reference to a cell." ], "previous_source": "", "target": [ "<emph>resultado1, resultado2, ...</emph> es cualquier valor o referencia a una celda." ], "id_hash": -4984656508639212289, "content_hash": -4984656508639212289, "location": "func_switch.xhp", "context": "func_switch.xhp\npar_id171556243796068\nhelp.text", "note": "ADDqw", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7523, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/99336795/?format=api", "priority": 100, "id": 100448453, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=3ad2f150b3388cff", "url": "https://translations.documentfoundation.org/api/units/100448453/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:26:28.099313Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<emph>default_result</emph>: any value or reference to a cell that is returned when there is no match." ], "previous_source": "", "target": [ "<emph>resultado_predeterminado</emph>: cualquier valor o referencia a una celda que se devuelve cuando no hay coincidencia." ], "id_hash": 234638763577069450, "content_hash": 234638763577069450, "location": "func_switch.xhp", "context": "func_switch.xhp\npar_id331556245422283\nhelp.text", "note": "9SKCB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7524, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/99336806/?format=api", "priority": 100, "id": 100448456, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=83419ab6598c4f8a", "url": "https://translations.documentfoundation.org/api/units/100448456/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:26:28.100720Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "If no <emph>value</emph> equals <emph>expression</emph> and no default result is given, a #N/A error is returned." ], "previous_source": "", "target": [ "SI no<emph>valor</emph>Igual<emph>expresión</emph>y si no se da ningún resultado predeterminado, se devuelve un error #N/A." ], "id_hash": -8316543607897106418, "content_hash": -8316543607897106418, "location": "func_switch.xhp", "context": "func_switch.xhp\npar_id871556243022881\nhelp.text", "note": "mLsyo", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7525, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/99336815/?format=api", "priority": 100, "id": 100448458, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=0c95b3a6cc3f580e", "url": "https://translations.documentfoundation.org/api/units/100448458/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:26:28.102218Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<input>=SWITCH(MONTH(A3),1,\"January\",2,\"February\",3,\"March\",\"No match\")</input> returns \"January\" when A3 contains a date in January, \"February\" when A3 contains a date in February , etc..." ], "previous_source": "", "target": [ "<input>= CAMBIAR(MES(A3),1,\"Enero\",2,\"Febrero\",3,\"Marzo\",\"Sin coincidir\")</input> devuelve \"enero\" cuando A3 contiene una fecha en enero, \"febrero\" cuando A3 contiene una fecha en febrero, etc..." ], "id_hash": 6015697845071984843, "content_hash": 6015697845071984843, "location": "func_switch.xhp", "context": "func_switch.xhp\npar_id851556243961783\nhelp.text", "note": "YQYUn", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7526, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://translations.documentfoundation.org/api/units/99336823/?format=api", "priority": 100, "id": 100448461, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=d37c0d514b9938cb", "url": "https://translations.documentfoundation.org/api/units/100448461/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:26:28.103998Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/SWITCH\">SWITCH wiki page</link>." ], "previous_source": "", "target": [ "" ], "id_hash": 5417782521746421278, "content_hash": 5417782521746421278, "location": "func_switch.xhp", "context": "func_switch.xhp\npar_id171677014475983\nhelp.text", "note": "EErFd", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7527, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/99336828/?format=api", "priority": 100, "id": 100448464, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=cb2fd47fb703f61e", "url": "https://translations.documentfoundation.org/api/units/100448464/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:26:28.105742Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<link href=\"text/scalc/01/04060105.xhp#Section4\">IF</link>" ], "previous_source": "", "target": [ "<link href=\"text/scalc/01/04060105.xhp#Section4\">SI</link>" ], "id_hash": 6151941570154682293, "content_hash": 6151941570154682293, "location": "func_switch.xhp", "context": "func_switch.xhp\npar_id781556244709752\nhelp.text", "note": "XELDQ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7528, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99336835/?format=api", "priority": 100, "id": 100448465, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=d5601643800757b5", "url": "https://translations.documentfoundation.org/api/units/100448465/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:26:28.106993Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "TEXTJOIN function" ], "previous_source": "", "target": [ "Función UNIRCADENAS" ], "id_hash": 5014332865741421532, "content_hash": 5014332865741421532, "location": "func_textjoin.xhp", "context": "func_textjoin.xhp\ntit\nhelp.text", "note": "BCAZr", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7529, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99336884/?format=api", "priority": 100, "id": 100448468, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=c5967d2ca0157bdc", "url": "https://translations.documentfoundation.org/api/units/100448468/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:26:28.108478Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<bookmark_value>TEXTJOIN function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>Función UNIRCADENAS</bookmark_value>" ], "id_hash": 5470940963563861170, "content_hash": 5470940963563861170, "location": "func_textjoin.xhp", "context": "func_textjoin.xhp\nbm_id581556228060864\nhelp.text", "note": "EFTkc", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7530, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99336900/?format=api", "priority": 100, "id": 100448470, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=cbecafd1f05b74b2", "url": "https://translations.documentfoundation.org/api/units/100448470/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:26:28.109785Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<variable id=\"textjoinfunct\"><link href=\"text/scalc/01/func_textjoin.xhp\">TEXTJOIN</link></variable>" ], "previous_source": "", "target": [ "<variable id=\"textjoinfunct\"><link href=\"text/scalc/01/func_textjoin.xhp\"> UNIRCADENAS</link></variable>" ], "id_hash": 8635050145270677307, "content_hash": 8635050145270677307, "location": "func_textjoin.xhp", "context": "func_textjoin.xhp\nhd_id551556227727946\nhelp.text", "note": "FoNni", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7531, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99336929/?format=api", "priority": 100, "id": 100448474, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=f7d5dc5b4e8b3f3b", "url": "https://translations.documentfoundation.org/api/units/100448474/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:26:28.112648Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<variable id=\"textjoinfunction\"><ahelp hid=\".\">Concatenates one or more strings, and uses delimiters between them.</ahelp></variable>" ], "previous_source": "", "target": [ "<variable id=\"textjoinfunction\"><ahelp hid=\".\">Concatena una o más cadenas y utiliza delimitadores entre estas.</ahelp></variable>" ], "id_hash": -2429086807858466496, "content_hash": -2429086807858466496, "location": "func_textjoin.xhp", "context": "func_textjoin.xhp\npar_id121556227727948\nhelp.text", "note": "oLfX2", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7532, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/99336945/?format=api", "priority": 100, "id": 100448477, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=5e4a266b09023140", "url": "https://translations.documentfoundation.org/api/units/100448477/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:26:28.114386Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "TEXTJOIN( delimiter, skip_empty, String 1[; String 2][; … ;[String 253]] )" ], "previous_source": "", "target": [ "UNIRCADENAS( delimitador, saltar_ vacío, Cadena 1[; Cadena 2][; ... ; [Cadena 253]] )" ], "id_hash": -7520234788946676437, "content_hash": -7520234788946676437, "location": "func_textjoin.xhp", "context": "func_textjoin.xhp\npar_id541556228253979\nhelp.text", "note": "q72j4", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7533, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/99336954/?format=api", "priority": 100, "id": 100448479, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=17a2c24da94c752b", "url": "https://translations.documentfoundation.org/api/units/100448479/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:26:28.116124Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<emph>delimiter</emph> is a text string and can be a range." ], "previous_source": "", "target": [ "<emph>delimitador</emph> es una cadena de texto y puede ser un intervalo." ], "id_hash": 1521290930246971019, "content_hash": 1521290930246971019, "location": "func_textjoin.xhp", "context": "func_textjoin.xhp\npar_id741556228390897\nhelp.text", "note": "WaME6", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7534, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/99336995/?format=api", "priority": 100, "id": 100448482, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=951cb60a7964ee8b", "url": "https://translations.documentfoundation.org/api/units/100448482/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:26:28.117466Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<emph>skip_empty</emph> is a logical argument. When set to FALSE or 0, empty strings will be taken into account and this may lead to adjacent delimiters in the returned string. When set to any other value (e.g. TRUE or 1), empty strings will be ignored." ], "previous_source": "", "target": [ "<emph>saltar_ vacío</emph> es un argumento lógico. Cuando se establece en FALSO o 0, se tendrán en cuenta las cadenas vacías y esto puede conducir a delimitadores adyacentes en la cadena devuelta. Cuando se establece en cualquier otro valor (por ejemplo, VERDAD o 1), se omitirán las cadenas vacías." ], "id_hash": 4823896443427704570, "content_hash": 4823896443427704570, "location": "func_textjoin.xhp", "context": "func_textjoin.xhp\npar_id621556228397269\nhelp.text", "note": "6vMaP", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7535, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 44, "source_unit": "https://translations.documentfoundation.org/api/units/99337016/?format=api", "priority": 100, "id": 100448484, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=c2f1ec41d7c74efa", "url": "https://translations.documentfoundation.org/api/units/100448484/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:26:28.119017Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<emph>String 1[; String 2][; … ;[String 253]]</emph> are strings, references to cells or to cell ranges of strings." ], "previous_source": "", "target": [ "<emph>Cadena1[; Cadena 2][; … ;[Cadena 253]</emph> son cadenas, referencias a celdas o a rangos de celdas de cadenas." ], "id_hash": -5802007732716678904, "content_hash": -5802007732716678904, "location": "func_textjoin.xhp", "context": "func_textjoin.xhp\npar_id631556228516997\nhelp.text", "note": "JoYks", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7536, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/99337029/?format=api", "priority": 100, "id": 100448487, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=2f7b20b51b5a5108", "url": "https://translations.documentfoundation.org/api/units/100448487/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:26:28.120720Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "Ranges are traversed row by row (from top to bottom)." ], "previous_source": "", "target": [ "Los intervalos se recorren fila por fila (de arriba abajo)." ], "id_hash": -6710759265093006865, "content_hash": -6710759265093006865, "location": "func_textjoin.xhp", "context": "func_textjoin.xhp\npar_id1001556228523394\nhelp.text", "note": "PDbCp", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7537, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/99337043/?format=api", "priority": 100, "id": 100448489, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=22de9800e6f849ef", "url": "https://translations.documentfoundation.org/api/units/100448489/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:26:28.122053Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "If <emph>delimiter</emph> is a range, the range need not be of the same size as the number of strings to be joined." ], "previous_source": "", "target": [ "Si <emph>delimitador</emph> es un intervalo, este no necesariamente debe ser del mismo tamaño que el número de cadenas que se unirán." ], "id_hash": -464577815567250230, "content_hash": -464577815567250230, "location": "func_textjoin.xhp", "context": "func_textjoin.xhp\npar_id81556228530082\nhelp.text", "note": "PEkb2", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7538, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 22, "source_unit": "https://translations.documentfoundation.org/api/units/99337071/?format=api", "priority": 100, "id": 100448491, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=798d7cf02c964cca", "url": "https://translations.documentfoundation.org/api/units/100448491/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:26:28.123220Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "If there are more delimiters than strings to be joined, not all delimiters will be used." ], "previous_source": "", "target": [ "Si existen más delimitadores que cadenas por unir, no se emplearán todos los delimitadores." ], "id_hash": -5405159692517217896, "content_hash": -5405159692517217896, "location": "func_textjoin.xhp", "context": "func_textjoin.xhp\npar_id831556228543099\nhelp.text", "note": "VcQjG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7539, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/99337096/?format=api", "priority": 100, "id": 100448494, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=34fd03e5bd406998", "url": "https://translations.documentfoundation.org/api/units/100448494/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:26:28.124517Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "If there are less delimiters than strings to be joined, the delimiters will be used again from the start." ], "previous_source": "", "target": [ "Si, por el contrario, hubiere menos delimitadores que cadenas por unir, los delimitadores se utilizarán de nuevo desde el principio." ], "id_hash": -9199494206885749308, "content_hash": -9199494206885749308, "location": "func_textjoin.xhp", "context": "func_textjoin.xhp\npar_id321556228557611\nhelp.text", "note": "ByVAF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7540, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/99337124/?format=api", "priority": 100, "id": 100448496, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=0054d4c2854f9dc4", "url": "https://translations.documentfoundation.org/api/units/100448496/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:26:28.125719Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<input>=TEXTJOIN(\" \"; 1; \"Here\"; \"comes\"; \"the\"; \"sun\")</input> returns \"Here comes the sun\" with space character as delimiter and empty strings are ignored." ], "previous_source": "", "target": [ "<input>=UNIRCADENAS(\" \"; 1; \"Ya\"; \"viene\"; \"el\"; \"sol\")</input> devuelve «Ya viene el sol» con el carácter de espacio como delimitador e ignorando las cadenas vacías." ], "id_hash": 18671159055134695, "content_hash": 18671159055134695, "location": "func_textjoin.xhp", "context": "func_textjoin.xhp\npar_id441556229012536\nhelp.text", "note": "QaJCw", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7541, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 22, "source_unit": "https://translations.documentfoundation.org/api/units/99337139/?format=api", "priority": 100, "id": 100448499, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=80425551fb06afe7", "url": "https://translations.documentfoundation.org/api/units/100448499/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:26:28.127086Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "if A1:B2 contains \"Here\", \"comes\", \"the\", \"sun\" respectively, <input>=TEXTJOIN(\"-\";1;A1:B2)</input> returns \"Here-comes-the-sun\" with dash character as delimiter and empty strings are ignored." ], "previous_source": "", "target": [ "si A1:B2 contiene «Ya», «viene», «el» y «sol» respectivamente, <input>=UNIRCADENAS(\"-\";1;A1:B2)</input> devuelve «Ya-viene-el-sol» con el carácter de guion como delimitador e ignorando las cadenas vacías." ], "id_hash": -8803580722366995579, "content_hash": -8803580722366995579, "location": "func_textjoin.xhp", "context": "func_textjoin.xhp\npar_id441556239012536\nhelp.text", "note": "39FPP", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7542, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://translations.documentfoundation.org/api/units/99337162/?format=api", "priority": 100, "id": 100448501, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=05d365f9f3d6a385", "url": "https://translations.documentfoundation.org/api/units/100448501/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:26:28.128492Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/TEXTJOIN\">TEXTJOIN wiki page</link>." ], "previous_source": "", "target": [ "" ], "id_hash": -7316996333984528027, "content_hash": -7316996333984528027, "location": "func_textjoin.xhp", "context": "func_textjoin.xhp\npar_id761677014445916\nhelp.text", "note": "AcYv7", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7543, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/99337175/?format=api", "priority": 100, "id": 100448504, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=1a74ce99f2044965", "url": "https://translations.documentfoundation.org/api/units/100448504/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:26:28.129913Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<link href=\"text/scalc/01/04060110.xhp#concatenate\">CONCATENATE</link>" ], "previous_source": "", "target": [ "<link href=\"text/scalc/01/04060110.xhp#concatenate\">CONCATENAR</link>" ], "id_hash": -3616637871001590612, "content_hash": -3616637871001590612, "location": "func_textjoin.xhp", "context": "func_textjoin.xhp\npar_id781556244709752\nhelp.text", "note": "CdeS7", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7544, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99337196/?format=api", "priority": 100, "id": 100448506, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=4dcf1f04a1b9a4ac", "url": "https://translations.documentfoundation.org/api/units/100448506/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:26:28.130977Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "TIME" ], "previous_source": "", "target": [ "NSHORA" ], "id_hash": 7480879569668866292, "content_hash": 7480879569668866292, "location": "func_time.xhp", "context": "func_time.xhp\ntit\nhelp.text", "note": "pLSAn", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7545, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/99337220/?format=api", "priority": 100, "id": 100448509, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=e7d16c554d9700f4", "url": "https://translations.documentfoundation.org/api/units/100448509/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:26:28.132332Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<bookmark_value>TIME function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>función NSHORA</bookmark_value>" ], "id_hash": 4172947222353702937, "content_hash": 4172947222353702937, "location": "func_time.xhp", "context": "func_time.xhp\nbm_id3154073\nhelp.text", "note": "Y7P2x", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7546, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99337247/?format=api", "priority": 100, "id": 100448512, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=b9e94963b6d87019", "url": "https://translations.documentfoundation.org/api/units/100448512/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:26:28.133974Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<variable id=\"time\"><link href=\"text/scalc/01/func_time.xhp\">TIME</link></variable>" ], "previous_source": "", "target": [ "<variable id=\"time\"><link href=\"text/scalc/01/func_time.xhp\">NSHORA</link></variable>" ], "id_hash": 8993612891238497739, "content_hash": 8993612891238497739, "location": "func_time.xhp", "context": "func_time.xhp\nhd_id3154073\nhelp.text", "note": "ivxiA", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7547, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99337281/?format=api", "priority": 100, "id": 100448515, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=fccfbb463da4fdcb", "url": "https://translations.documentfoundation.org/api/units/100448515/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:26:28.135731Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_ZEIT\">TIME returns the current time value from values for hours, minutes and seconds.</ahelp> This function can be used to convert a time based on these three elements to a decimal time value." ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_ZEIT\">NSHORA devuelve el valor de hora actual a partir de los valores de horas, minutos y segundos.</ahelp> Esta función se puede utilizar para convertir una hora en un valor de tiempo decimal basándose en estos tres elementos." ], "id_hash": 6125222743429293744, "content_hash": 6125222743429293744, "location": "func_time.xhp", "context": "func_time.xhp\npar_id3145762\nhelp.text", "note": "VozL8", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7548, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 33, "source_unit": "https://translations.documentfoundation.org/api/units/99337304/?format=api", "priority": 100, "id": 100448517, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=d50129a1e03f26b0", "url": "https://translations.documentfoundation.org/api/units/100448517/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:26:28.137133Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "TIME(Hour; Minute; Second)" ], "previous_source": "", "target": [ "NSHORA(Hora; Minuto; Segundo)" ], "id_hash": 2669504036956577606, "content_hash": 2669504036956577606, "location": "func_time.xhp", "context": "func_time.xhp\npar_id3154584\nhelp.text", "note": "fzPmm", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7549, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99337323/?format=api", "priority": 100, "id": 100448519, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=a50bfbc729449f46", "url": "https://translations.documentfoundation.org/api/units/100448519/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:26:28.138454Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/es/?format=api", "source": [ "Use an integer to set the <emph>Hour</emph>." ], "previous_source": "", "target": [ "Utilice un entero para configurar la <emph>Hora</emph>." ], "id_hash": 7930864504490749317, "content_hash": 7930864504490749317, "location": "func_time.xhp", "context": "func_time.xhp\npar_id3152904\nhelp.text", "note": "3DWFB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7550, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/99337346/?format=api", "priority": 100, "id": 100448521, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/es/?checksum=ee10173f4feced85", "url": "https://translations.documentfoundation.org/api/units/100448521/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:26:28.139517Z" } ] }