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/ast/units/?format=api&page=151
https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/units/?format=api&page=152", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/units/?format=api&page=150", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<item type=\"input\">=SUMIFS(B2:B6;B2:B6;\">=20\")</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=PROMEDIU(A1:A50)</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": 99532293, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=48c13555c047f64a", "url": "https://translations.documentfoundation.org/api/units/99532293/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:39.881584Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": [ "" ], "id_hash": -8584625317315816146, "content_hash": -8584625317315816146, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\npar_id28647227259438\nhelp.text", "note": "NK7QS", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 99532295, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=08dd48c1d790d52e", "url": "https://translations.documentfoundation.org/api/units/99532295/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:39.883255Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<item type=\"input\">=SUMIFS(C2:C6;B2:B6;\">=20\";C2:C6;\">70\")</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=PROMEDIU(A1:A50)</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": 99532298, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=020ded207ab5bfba", "url": "https://translations.documentfoundation.org/api/units/99532298/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:39.884712Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": [ "" ], "id_hash": 5531634363620764760, "content_hash": 5531634363620764760, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\npar_id189772445525114\nhelp.text", "note": "or3BG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 99532303, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=ccc4502556f5ac58", "url": "https://translations.documentfoundation.org/api/units/99532303/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:39.886456Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Using regular expressions and nested functions" ], "previous_source": "", "target": [ "" ], "id_hash": -7905416432563865011, "content_hash": -7905416432563865011, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\nhd_id30455222431067\nhelp.text", "note": "YHh9T", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 99532307, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=124a51a3a77eba4d", "url": "https://translations.documentfoundation.org/api/units/99532307/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:39.887986Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<item type=\"input\">=SUMIFS(C2:C6;B2:B6;\">\"&MIN(B2:B6);B2:B6;\"<\"&MAX(B2:B6))</item>" ], "previous_source": "", "target": [ "" ], "id_hash": -7100679125014514541, "content_hash": -7100679125014514541, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\npar_id307691022525348\nhelp.text", "note": "Ust3n", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 99532312, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=1d7551f4f17a7493", "url": "https://translations.documentfoundation.org/api/units/99532312/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:39.890176Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": [ "" ], "id_hash": -3296253579067716392, "content_hash": -3296253579067716392, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\npar_id27619246864839\nhelp.text", "note": "wCeGS", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 99532316, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=52415ad58a0f0cd8", "url": "https://translations.documentfoundation.org/api/units/99532316/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:39.891650Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<item type=\"input\">=SUMIFS(C2:C6;A2:A6;\"pen.*\";B2:B6;\"<\"&MAX(B2:B6))</item>" ], "previous_source": "", "target": [ "" ], "id_hash": 993849274358828000, "content_hash": 993849274358828000, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\npar_id220502883332563\nhelp.text", "note": "tETJF", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 99532320, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=8dcadca63e700be0", "url": "https://translations.documentfoundation.org/api/units/99532320/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:39.893213Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": [ "" ], "id_hash": -3162333369531084074, "content_hash": -3162333369531084074, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\npar_id15342189586295\nhelp.text", "note": "u7CDd", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 99532324, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=541d228e1fbc52d6", "url": "https://translations.documentfoundation.org/api/units/99532324/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:39.894555Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Reference to a cell as a criterion" ], "previous_source": "", "target": [ "" ], "id_hash": 3615373838218159194, "content_hash": 3615373838218159194, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\nhd_id8168283329426\nhelp.text", "note": "dKeLC", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 99532329, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=b22c6359cd3be45a", "url": "https://translations.documentfoundation.org/api/units/99532329/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:39.898320Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": [ "" ], "id_hash": 2034425885526726680, "content_hash": 2034425885526726680, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\npar_id50762995519951\nhelp.text", "note": "NzNhA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 99532337, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=9c3bbb9064ae1818", "url": "https://translations.documentfoundation.org/api/units/99532337/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:39.902225Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<item type=\"input\">=SUMIFS(C2:C6;A2:A6;E2&\".*\";B2:B6;\"<\"&MAX(B2:B6))</item>" ], "previous_source": "", "target": [ "" ], "id_hash": 3624176247368206676, "content_hash": 3624176247368206676, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\npar_id135761606425300\nhelp.text", "note": "U2wwM", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 99532342, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=b24ba91863ca4954", "url": "https://translations.documentfoundation.org/api/units/99532342/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:39.904468Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "If E2 = pen, the function returns 65, because the link to the cell is substituted with its content." ], "previous_source": "", "target": [ "" ], "id_hash": 814313685569042024, "content_hash": 814313685569042024, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\npar_id30574750215839\nhelp.text", "note": "wGhZA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 99532352, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=8b4d05fb8c14f668", "url": "https://translations.documentfoundation.org/api/units/99532352/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:39.908149Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 99532356, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=e3c97b964f1f9815", "url": "https://translations.documentfoundation.org/api/units/99532356/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:39.911902Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "SWITCH function" ], "previous_source": "", "target": [ "" ], "id_hash": 5686056986956170649, "content_hash": 5686056986956170649, "location": "func_switch.xhp", "context": "func_switch.xhp\ntit\nhelp.text", "note": "UUeQC", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 99532358, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=cee8eeb420268599", "url": "https://translations.documentfoundation.org/api/units/99532358/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:39.917854Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<bookmark_value>SWITCH function</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": -2260707101919447878, "content_hash": -2260707101919447878, "location": "func_switch.xhp", "context": "func_switch.xhp\nbm_id571556244875552\nhelp.text", "note": "5ALMt", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 99532362, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=60a05ade58e374ba", "url": "https://translations.documentfoundation.org/api/units/99532362/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:39.921657Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<variable id=\"switchfunct\"><link href=\"text/scalc/01/func_switch.xhp\">SWITCH</link></variable>" ], "previous_source": "", "target": [ "" ], "id_hash": -477269484934871315, "content_hash": -477269484934871315, "location": "func_switch.xhp", "context": "func_switch.xhp\nhd_id21556242313791\nhelp.text", "note": "F6kQd", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 99532365, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=796065eea052c6ed", "url": "https://translations.documentfoundation.org/api/units/99532365/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:39.924192Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": [ "" ], "id_hash": 3196169826997080294, "content_hash": 3196169826997080294, "location": "func_switch.xhp", "context": "func_switch.xhp\npar_id361556242313793\nhelp.text", "note": "vaCEi", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 99532375, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=ac5b13860bfb90e6", "url": "https://translations.documentfoundation.org/api/units/99532375/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:39.931777Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "SWITCH(expression; value1; result1[; value2; result2][; ... ; [value127; result127][; default_result]])" ], "previous_source": "", "target": [ "" ], "id_hash": -1442936473756366974, "content_hash": -1442936473756366974, "location": "func_switch.xhp", "context": "func_switch.xhp\npar_id521556242803283\nhelp.text", "note": "tFvZx", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 99532378, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=6bf9a8ec104c0782", "url": "https://translations.documentfoundation.org/api/units/99532378/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:39.933350Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": [ "" ], "id_hash": -5786508699232931422, "content_hash": -5786508699232931422, "location": "func_switch.xhp", "context": "func_switch.xhp\npar_id111585520651521\nhelp.text", "note": "p8fL8", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 99532387, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=2fb230ff0c8371a2", "url": "https://translations.documentfoundation.org/api/units/99532387/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:39.938227Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<emph>expression</emph> is a text, numeric, logical or date input or reference to a cell." ], "previous_source": "", "target": [ "" ], "id_hash": 9117707988652973551, "content_hash": 9117707988652973551, "location": "func_switch.xhp", "context": "func_switch.xhp\npar_id341556242996378\nhelp.text", "note": "nnW4D", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 99532390, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=fe889b1ba566ddef", "url": "https://translations.documentfoundation.org/api/units/99532390/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:39.939723Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": [ "" ], "id_hash": 2789162408943903381, "content_hash": 2789162408943903381, "location": "func_switch.xhp", "context": "func_switch.xhp\npar_id321556243790332\nhelp.text", "note": "Z7xiA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 99532396, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=a6b5186eedf96295", "url": "https://translations.documentfoundation.org/api/units/99532396/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:39.943073Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<emph>result1, result2, ...</emph> is any value or reference to a cell." ], "previous_source": "", "target": [ "" ], "id_hash": -4984656508639212289, "content_hash": -4984656508639212289, "location": "func_switch.xhp", "context": "func_switch.xhp\npar_id171556243796068\nhelp.text", "note": "ADDqw", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 99532399, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=3ad2f150b3388cff", "url": "https://translations.documentfoundation.org/api/units/99532399/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:39.945120Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": [ "" ], "id_hash": 234638763577069450, "content_hash": 234638763577069450, "location": "func_switch.xhp", "context": "func_switch.xhp\npar_id331556245422283\nhelp.text", "note": "9SKCB", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 99532403, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=83419ab6598c4f8a", "url": "https://translations.documentfoundation.org/api/units/99532403/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:39.946475Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": [ "" ], "id_hash": -8316543607897106418, "content_hash": -8316543607897106418, "location": "func_switch.xhp", "context": "func_switch.xhp\npar_id871556243022881\nhelp.text", "note": "mLsyo", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 99532407, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=0c95b3a6cc3f580e", "url": "https://translations.documentfoundation.org/api/units/99532407/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:39.947736Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": [ "" ], "id_hash": 6015697845071984843, "content_hash": 6015697845071984843, "location": "func_switch.xhp", "context": "func_switch.xhp\npar_id851556243961783\nhelp.text", "note": "YQYUn", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 99532410, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=d37c0d514b9938cb", "url": "https://translations.documentfoundation.org/api/units/99532410/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:39.948998Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 99532414, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=cb2fd47fb703f61e", "url": "https://translations.documentfoundation.org/api/units/99532414/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:39.950368Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<link href=\"text/scalc/01/04060105.xhp#Section4\">IF</link>" ], "previous_source": "", "target": [ "" ], "id_hash": 6151941570154682293, "content_hash": 6151941570154682293, "location": "func_switch.xhp", "context": "func_switch.xhp\npar_id781556244709752\nhelp.text", "note": "XELDQ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 99532418, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=d5601643800757b5", "url": "https://translations.documentfoundation.org/api/units/99532418/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:39.951810Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "TEXTJOIN function" ], "previous_source": "", "target": [ "" ], "id_hash": 5014332865741421532, "content_hash": 5014332865741421532, "location": "func_textjoin.xhp", "context": "func_textjoin.xhp\ntit\nhelp.text", "note": "BCAZr", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 99532421, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=c5967d2ca0157bdc", "url": "https://translations.documentfoundation.org/api/units/99532421/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:39.953133Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<bookmark_value>TEXTJOIN function</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": 5470940963563861170, "content_hash": 5470940963563861170, "location": "func_textjoin.xhp", "context": "func_textjoin.xhp\nbm_id581556228060864\nhelp.text", "note": "EFTkc", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 99532422, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=cbecafd1f05b74b2", "url": "https://translations.documentfoundation.org/api/units/99532422/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:39.954457Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<variable id=\"textjoinfunct\"><link href=\"text/scalc/01/func_textjoin.xhp\">TEXTJOIN</link></variable>" ], "previous_source": "", "target": [ "" ], "id_hash": 8635050145270677307, "content_hash": 8635050145270677307, "location": "func_textjoin.xhp", "context": "func_textjoin.xhp\nhd_id551556227727946\nhelp.text", "note": "FoNni", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 99532425, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=f7d5dc5b4e8b3f3b", "url": "https://translations.documentfoundation.org/api/units/99532425/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:39.955727Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<variable id=\"textjoinfunction\"><ahelp hid=\".\">Concatenates one or more strings, and uses delimiters between them.</ahelp></variable>" ], "previous_source": "", "target": [ "" ], "id_hash": -2429086807858466496, "content_hash": -2429086807858466496, "location": "func_textjoin.xhp", "context": "func_textjoin.xhp\npar_id121556227727948\nhelp.text", "note": "oLfX2", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 99532428, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=5e4a266b09023140", "url": "https://translations.documentfoundation.org/api/units/99532428/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:39.957010Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "TEXTJOIN( delimiter, skip_empty, String 1[; String 2][; … ;[String 253]] )" ], "previous_source": "", "target": [ "" ], "id_hash": -7520234788946676437, "content_hash": -7520234788946676437, "location": "func_textjoin.xhp", "context": "func_textjoin.xhp\npar_id541556228253979\nhelp.text", "note": "q72j4", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 99532430, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=17a2c24da94c752b", "url": "https://translations.documentfoundation.org/api/units/99532430/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:39.958367Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<emph>delimiter</emph> is a text string and can be a range." ], "previous_source": "", "target": [ "" ], "id_hash": 1521290930246971019, "content_hash": 1521290930246971019, "location": "func_textjoin.xhp", "context": "func_textjoin.xhp\npar_id741556228390897\nhelp.text", "note": "WaME6", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 99532432, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=951cb60a7964ee8b", "url": "https://translations.documentfoundation.org/api/units/99532432/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:39.959571Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": [ "" ], "id_hash": 4823896443427704570, "content_hash": 4823896443427704570, "location": "func_textjoin.xhp", "context": "func_textjoin.xhp\npar_id621556228397269\nhelp.text", "note": "6vMaP", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 99532434, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=c2f1ec41d7c74efa", "url": "https://translations.documentfoundation.org/api/units/99532434/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:39.960903Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": [ "" ], "id_hash": -5802007732716678904, "content_hash": -5802007732716678904, "location": "func_textjoin.xhp", "context": "func_textjoin.xhp\npar_id631556228516997\nhelp.text", "note": "JoYks", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 99532437, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=2f7b20b51b5a5108", "url": "https://translations.documentfoundation.org/api/units/99532437/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:39.962245Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Ranges are traversed row by row (from top to bottom)." ], "previous_source": "", "target": [ "" ], "id_hash": -6710759265093006865, "content_hash": -6710759265093006865, "location": "func_textjoin.xhp", "context": "func_textjoin.xhp\npar_id1001556228523394\nhelp.text", "note": "PDbCp", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 99532439, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=22de9800e6f849ef", "url": "https://translations.documentfoundation.org/api/units/99532439/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:39.963614Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": [ "" ], "id_hash": -464577815567250230, "content_hash": -464577815567250230, "location": "func_textjoin.xhp", "context": "func_textjoin.xhp\npar_id81556228530082\nhelp.text", "note": "PEkb2", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 99532442, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=798d7cf02c964cca", "url": "https://translations.documentfoundation.org/api/units/99532442/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:39.964898Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "If there are more delimiters than strings to be joined, not all delimiters will be used." ], "previous_source": "", "target": [ "" ], "id_hash": -5405159692517217896, "content_hash": -5405159692517217896, "location": "func_textjoin.xhp", "context": "func_textjoin.xhp\npar_id831556228543099\nhelp.text", "note": "VcQjG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 99532445, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=34fd03e5bd406998", "url": "https://translations.documentfoundation.org/api/units/99532445/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:39.966150Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": [ "" ], "id_hash": -9199494206885749308, "content_hash": -9199494206885749308, "location": "func_textjoin.xhp", "context": "func_textjoin.xhp\npar_id321556228557611\nhelp.text", "note": "ByVAF", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 99532448, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=0054d4c2854f9dc4", "url": "https://translations.documentfoundation.org/api/units/99532448/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:39.967351Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": [ "" ], "id_hash": 18671159055134695, "content_hash": 18671159055134695, "location": "func_textjoin.xhp", "context": "func_textjoin.xhp\npar_id441556229012536\nhelp.text", "note": "QaJCw", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 99532453, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=80425551fb06afe7", "url": "https://translations.documentfoundation.org/api/units/99532453/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:39.968594Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": [ "" ], "id_hash": -8803580722366995579, "content_hash": -8803580722366995579, "location": "func_textjoin.xhp", "context": "func_textjoin.xhp\npar_id441556239012536\nhelp.text", "note": "39FPP", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 99532456, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=05d365f9f3d6a385", "url": "https://translations.documentfoundation.org/api/units/99532456/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:39.972158Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 99532459, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=1a74ce99f2044965", "url": "https://translations.documentfoundation.org/api/units/99532459/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:39.973593Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<link href=\"text/scalc/01/04060110.xhp#concatenate\">CONCATENATE</link>" ], "previous_source": "", "target": [ "" ], "id_hash": -3616637871001590612, "content_hash": -3616637871001590612, "location": "func_textjoin.xhp", "context": "func_textjoin.xhp\npar_id781556244709752\nhelp.text", "note": "CdeS7", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 99532462, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=4dcf1f04a1b9a4ac", "url": "https://translations.documentfoundation.org/api/units/99532462/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:39.974829Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "TIME" ], "previous_source": "", "target": [ "HORA" ], "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": 99532464, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=e7d16c554d9700f4", "url": "https://translations.documentfoundation.org/api/units/99532464/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:39.976078Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<bookmark_value>TIME function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>HORA</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": 99532467, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=b9e94963b6d87019", "url": "https://translations.documentfoundation.org/api/units/99532467/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:39.977386Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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\">HORA</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": 99532470, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=fccfbb463da4fdcb", "url": "https://translations.documentfoundation.org/api/units/99532470/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:39.978827Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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\">HORA devuelve'l valor d'hora actual a partir de los valores d'hores, minutos y segundos.</ahelp> Esta función pue utilizase pa convertir una hora nun valor de tiempu decimal basándose nestos trés 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": 99532475, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=d50129a1e03f26b0", "url": "https://translations.documentfoundation.org/api/units/99532475/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:39.984705Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "TIME(Hour; Minute; Second)" ], "previous_source": "", "target": [ "TIEMPU(Hora; Minutu; Segundu)" ], "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": 99532479, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=a50bfbc729449f46", "url": "https://translations.documentfoundation.org/api/units/99532479/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:39.987862Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Use an integer to set the <emph>Hour</emph>." ], "previous_source": "", "target": [ "Utilice un enteru pa 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": 99532481, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=ee10173f4feced85", "url": "https://translations.documentfoundation.org/api/units/99532481/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:39.989513Z" } ] }{ "count": 8352, "next": "