Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-24-2/textscalc01/hsb/units/?format=api&page=153
{ "count": 8439, "next": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/units/?format=api&page=154", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/units/?format=api&page=152", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 7601, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/111184022/?format=api", "priority": 100, "id": 112359957, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=e3c97b964f1f9815", "url": "https://translations.documentfoundation.org/api/units/112359957/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:26.994587Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 7602, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111184054/?format=api", "priority": 100, "id": 112359958, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=cee8eeb420268599", "url": "https://translations.documentfoundation.org/api/units/112359958/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:26.995575Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 7603, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111184094/?format=api", "priority": 100, "id": 112359959, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=60a05ade58e374ba", "url": "https://translations.documentfoundation.org/api/units/112359959/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:26.996516Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 7604, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111184139/?format=api", "priority": 100, "id": 112359960, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=796065eea052c6ed", "url": "https://translations.documentfoundation.org/api/units/112359960/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:26.997467Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 7605, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 34, "source_unit": "https://translations.documentfoundation.org/api/units/111184193/?format=api", "priority": 100, "id": 112359961, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=ac5b13860bfb90e6", "url": "https://translations.documentfoundation.org/api/units/112359961/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:26.998463Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 7606, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/111184206/?format=api", "priority": 100, "id": 112359962, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=6bf9a8ec104c0782", "url": "https://translations.documentfoundation.org/api/units/112359962/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:26.999503Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 7607, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 45, "source_unit": "https://translations.documentfoundation.org/api/units/111184252/?format=api", "priority": 100, "id": 112359963, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=2fb230ff0c8371a2", "url": "https://translations.documentfoundation.org/api/units/112359963/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:27.000463Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 7608, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/111184308/?format=api", "priority": 100, "id": 112359964, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=fe889b1ba566ddef", "url": "https://translations.documentfoundation.org/api/units/112359964/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:27.001449Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 7609, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/111184347/?format=api", "priority": 100, "id": 112359965, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=a6b5186eedf96295", "url": "https://translations.documentfoundation.org/api/units/112359965/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:27.002421Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 7610, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/111184421/?format=api", "priority": 100, "id": 112359966, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=3ad2f150b3388cff", "url": "https://translations.documentfoundation.org/api/units/112359966/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:27.003401Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 7611, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/111184464/?format=api", "priority": 100, "id": 112359967, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=83419ab6598c4f8a", "url": "https://translations.documentfoundation.org/api/units/112359967/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:27.004383Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 7612, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/111184499/?format=api", "priority": 100, "id": 112359968, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=0c95b3a6cc3f580e", "url": "https://translations.documentfoundation.org/api/units/112359968/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:27.005336Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 7613, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://translations.documentfoundation.org/api/units/111184546/?format=api", "priority": 100, "id": 112359969, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=d37c0d514b9938cb", "url": "https://translations.documentfoundation.org/api/units/112359969/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:27.006310Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 7614, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/111184593/?format=api", "priority": 100, "id": 112359970, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=cb2fd47fb703f61e", "url": "https://translations.documentfoundation.org/api/units/112359970/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:27.007310Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 7615, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111184811/?format=api", "priority": 100, "id": 112359971, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=d5601643800757b5", "url": "https://translations.documentfoundation.org/api/units/112359971/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:27.008299Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 7616, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111184857/?format=api", "priority": 100, "id": 112359972, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=c5967d2ca0157bdc", "url": "https://translations.documentfoundation.org/api/units/112359972/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:27.009253Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 7617, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111184924/?format=api", "priority": 100, "id": 112359973, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=cbecafd1f05b74b2", "url": "https://translations.documentfoundation.org/api/units/112359973/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:27.010185Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 7618, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111184977/?format=api", "priority": 100, "id": 112359974, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=f7d5dc5b4e8b3f3b", "url": "https://translations.documentfoundation.org/api/units/112359974/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:27.011144Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 7619, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/111185030/?format=api", "priority": 100, "id": 112359975, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=5e4a266b09023140", "url": "https://translations.documentfoundation.org/api/units/112359975/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:27.012122Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 7620, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/111185095/?format=api", "priority": 100, "id": 112359976, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=17a2c24da94c752b", "url": "https://translations.documentfoundation.org/api/units/112359976/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:27.013138Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 7621, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/111185128/?format=api", "priority": 100, "id": 112359977, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=951cb60a7964ee8b", "url": "https://translations.documentfoundation.org/api/units/112359977/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:27.014086Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 7622, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 44, "source_unit": "https://translations.documentfoundation.org/api/units/111185161/?format=api", "priority": 100, "id": 112359978, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=c2f1ec41d7c74efa", "url": "https://translations.documentfoundation.org/api/units/112359978/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:27.015043Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 7623, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/111185181/?format=api", "priority": 100, "id": 112359979, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=2f7b20b51b5a5108", "url": "https://translations.documentfoundation.org/api/units/112359979/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:27.016041Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 7624, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/111185270/?format=api", "priority": 100, "id": 112359980, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=22de9800e6f849ef", "url": "https://translations.documentfoundation.org/api/units/112359980/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:27.016996Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 7625, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 22, "source_unit": "https://translations.documentfoundation.org/api/units/111185309/?format=api", "priority": 100, "id": 112359981, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=798d7cf02c964cca", "url": "https://translations.documentfoundation.org/api/units/112359981/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:27.017940Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 7626, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/111185362/?format=api", "priority": 100, "id": 112359982, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=34fd03e5bd406998", "url": "https://translations.documentfoundation.org/api/units/112359982/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:27.018938Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 7627, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/111185409/?format=api", "priority": 100, "id": 112359983, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=0054d4c2854f9dc4", "url": "https://translations.documentfoundation.org/api/units/112359983/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:27.019895Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 7628, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 22, "source_unit": "https://translations.documentfoundation.org/api/units/111185461/?format=api", "priority": 100, "id": 112359984, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=80425551fb06afe7", "url": "https://translations.documentfoundation.org/api/units/112359984/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:27.020893Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 7629, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://translations.documentfoundation.org/api/units/111185507/?format=api", "priority": 100, "id": 112359985, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=05d365f9f3d6a385", "url": "https://translations.documentfoundation.org/api/units/112359985/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:27.021874Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 7630, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/111185575/?format=api", "priority": 100, "id": 112359986, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=1a74ce99f2044965", "url": "https://translations.documentfoundation.org/api/units/112359986/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:27.022867Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 7631, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111185626/?format=api", "priority": 100, "id": 112359987, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=4dcf1f04a1b9a4ac", "url": "https://translations.documentfoundation.org/api/units/112359987/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:27.023833Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "TIME" ], "previous_source": "", "target": [ "" ], "id_hash": 7480879569668866292, "content_hash": 7480879569668866292, "location": "func_time.xhp", "context": "func_time.xhp\ntit\nhelp.text", "note": "pLSAn", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7632, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/111185675/?format=api", "priority": 100, "id": 112359988, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=e7d16c554d9700f4", "url": "https://translations.documentfoundation.org/api/units/112359988/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:27.024785Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<bookmark_value>TIME function</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": 4172947222353702937, "content_hash": 4172947222353702937, "location": "func_time.xhp", "context": "func_time.xhp\nbm_id3154073\nhelp.text", "note": "Y7P2x", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7633, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111185712/?format=api", "priority": 100, "id": 112359989, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=b9e94963b6d87019", "url": "https://translations.documentfoundation.org/api/units/112359989/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:27.025702Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<variable id=\"time\"><link href=\"text/scalc/01/func_time.xhp\">TIME</link></variable>" ], "previous_source": "", "target": [ "" ], "id_hash": 8993612891238497739, "content_hash": 8993612891238497739, "location": "func_time.xhp", "context": "func_time.xhp\nhd_id3154073\nhelp.text", "note": "ivxiA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7634, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111185730/?format=api", "priority": 100, "id": 112359990, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=fccfbb463da4fdcb", "url": "https://translations.documentfoundation.org/api/units/112359990/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:27.026635Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": [ "" ], "id_hash": 6125222743429293744, "content_hash": 6125222743429293744, "location": "func_time.xhp", "context": "func_time.xhp\npar_id3145762\nhelp.text", "note": "VozL8", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7635, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 33, "source_unit": "https://translations.documentfoundation.org/api/units/111185794/?format=api", "priority": 100, "id": 112359991, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=d50129a1e03f26b0", "url": "https://translations.documentfoundation.org/api/units/112359991/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:27.027623Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "TIME(Hour; Minute; Second)" ], "previous_source": "", "target": [ "" ], "id_hash": 2669504036956577606, "content_hash": 2669504036956577606, "location": "func_time.xhp", "context": "func_time.xhp\npar_id3154584\nhelp.text", "note": "fzPmm", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7636, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111185860/?format=api", "priority": 100, "id": 112359992, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=a50bfbc729449f46", "url": "https://translations.documentfoundation.org/api/units/112359992/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:27.028619Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "Use an integer to set the <emph>Hour</emph>." ], "previous_source": "", "target": [ "" ], "id_hash": 7930864504490749317, "content_hash": 7930864504490749317, "location": "func_time.xhp", "context": "func_time.xhp\npar_id3152904\nhelp.text", "note": "3DWFB", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7637, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/111185903/?format=api", "priority": 100, "id": 112359993, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=ee10173f4feced85", "url": "https://translations.documentfoundation.org/api/units/112359993/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:27.029555Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "Use an integer to set the <emph>Minute</emph>." ], "previous_source": "", "target": [ "" ], "id_hash": -2675562994472174896, "content_hash": -2675562994472174896, "location": "func_time.xhp", "context": "func_time.xhp\npar_id3151346\nhelp.text", "note": "QKjXC", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7638, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/111185930/?format=api", "priority": 100, "id": 112359994, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=5ade7da1dc4e3ad0", "url": "https://translations.documentfoundation.org/api/units/112359994/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:27.030479Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "Use an integer to set the <emph>Second</emph>." ], "previous_source": "", "target": [ "" ], "id_hash": -3553809433982322803, "content_hash": -3553809433982322803, "location": "func_time.xhp", "context": "func_time.xhp\npar_id3151366\nhelp.text", "note": "ALcZt", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7639, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/111185953/?format=api", "priority": 100, "id": 112359995, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=4eae5526100d378d", "url": "https://translations.documentfoundation.org/api/units/112359995/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:27.031420Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<item type=\"input\">=TIME(0;0;0)</item> returns 00:00:00" ], "previous_source": "", "target": [ "" ], "id_hash": 6539266649019735547, "content_hash": 6539266649019735547, "location": "func_time.xhp", "context": "func_time.xhp\npar_id3156076\nhelp.text", "note": "qGpQS", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7640, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/111185961/?format=api", "priority": 100, "id": 112359996, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=dac0245eea615dfb", "url": "https://translations.documentfoundation.org/api/units/112359996/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:27.032353Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<item type=\"input\">=TIME(4;20;4)</item> returns 04:20:04" ], "previous_source": "", "target": [ "" ], "id_hash": -3559860102422370447, "content_hash": -3559860102422370447, "location": "func_time.xhp", "context": "func_time.xhp\npar_id3156090\nhelp.text", "note": "DKovu", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7641, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/111185995/?format=api", "priority": 100, "id": 112359997, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=4e98d61909076771", "url": "https://translations.documentfoundation.org/api/units/112359997/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:27.033295Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/TIME\">TIME wiki page</link>." ], "previous_source": "", "target": [ "" ], "id_hash": 8111343512747448022, "content_hash": 8111343512747448022, "location": "func_time.xhp", "context": "func_time.xhp\npar_id741677014416564\nhelp.text", "note": "BRwAF", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7642, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/111186012/?format=api", "priority": 100, "id": 112359998, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=f09147f2f87b16d6", "url": "https://translations.documentfoundation.org/api/units/112359998/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:27.034227Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "TIMEVALUE" ], "previous_source": "", "target": [ "" ], "id_hash": -6178507178536032326, "content_hash": -6178507178536032326, "location": "func_timevalue.xhp", "context": "func_timevalue.xhp\ntit\nhelp.text", "note": "eUYTq", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7643, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/111186039/?format=api", "priority": 100, "id": 112359999, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=2a418874cd28a7ba", "url": "https://translations.documentfoundation.org/api/units/112359999/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:27.035200Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<bookmark_value>TIMEVALUE function</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": 4748393686218248557, "content_hash": 4748393686218248557, "location": "func_timevalue.xhp", "context": "func_timevalue.xhp\nbm_id3146755\nhelp.text", "note": "jt9C2", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7644, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111186069/?format=api", "priority": 100, "id": 112360000, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=c1e5aee648bf116d", "url": "https://translations.documentfoundation.org/api/units/112360000/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:27.036124Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<variable id=\"timevalue\"><link href=\"text/scalc/01/func_timevalue.xhp\">TIMEVALUE</link></variable>" ], "previous_source": "", "target": [ "" ], "id_hash": -2722036974227023672, "content_hash": -2722036974227023672, "location": "func_timevalue.xhp", "context": "func_timevalue.xhp\nhd_id3146755\nhelp.text", "note": "KvCZT", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7645, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111186094/?format=api", "priority": 100, "id": 112360001, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=5a3961cb3db818c8", "url": "https://translations.documentfoundation.org/api/units/112360001/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:27.037062Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_ZEITWERT\">TIMEVALUE returns the internal time number from a text enclosed by quotes and which may show a possible time entry format.</ahelp>" ], "previous_source": "", "target": [ "" ], "id_hash": 2121152379039421732, "content_hash": 2121152379039421732, "location": "func_timevalue.xhp", "context": "func_timevalue.xhp\npar_id3148502\nhelp.text", "note": "BKBh2", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7646, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 22, "source_unit": "https://translations.documentfoundation.org/api/units/111186124/?format=api", "priority": 100, "id": 112360002, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=9d6fd8d9b31e9524", "url": "https://translations.documentfoundation.org/api/units/112360002/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:27.038081Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "The internal number indicated as a decimal is the result of the date system used under $[officename] to calculate date entries." ], "previous_source": "", "target": [ "" ], "id_hash": 8771374573804999141, "content_hash": 8771374573804999141, "location": "func_timevalue.xhp", "context": "func_timevalue.xhp\npar_id3150794\nhelp.text", "note": "Awj4V", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7647, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://translations.documentfoundation.org/api/units/111186168/?format=api", "priority": 100, "id": 112360003, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=f9ba2eb3bf8a51e5", "url": "https://translations.documentfoundation.org/api/units/112360003/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:27.039062Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "If the text string also includes a year, month, or day, TIMEVALUE only returns the fractional part of the conversion." ], "previous_source": "", "target": [ "" ], "id_hash": -2307898283231138571, "content_hash": -2307898283231138571, "location": "func_timevalue.xhp", "context": "func_timevalue.xhp\npar_id011920090347118\nhelp.text", "note": "nGfAL", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7648, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/111186220/?format=api", "priority": 100, "id": 112360004, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=5ff8b2bd3a462cf5", "url": "https://translations.documentfoundation.org/api/units/112360004/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:27.040417Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "TIMEVALUE(\"Text\")" ], "previous_source": "", "target": [ "" ], "id_hash": 2970460473714148986, "content_hash": 2970460473714148986, "location": "func_timevalue.xhp", "context": "func_timevalue.xhp\npar_id3150823\nhelp.text", "note": "FQKX4", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7649, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/111186259/?format=api", "priority": 100, "id": 112360005, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=a93932100b12067a", "url": "https://translations.documentfoundation.org/api/units/112360005/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:27.041879Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<emph>Text</emph> is a valid time expression and must be entered in quotation marks." ], "previous_source": "", "target": [ "" ], "id_hash": 2974985658681355248, "content_hash": 2974985658681355248, "location": "func_timevalue.xhp", "context": "func_timevalue.xhp\npar_id3152556\nhelp.text", "note": "wHKdJ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7650, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/111186300/?format=api", "priority": 100, "id": 112360006, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=a94945b1c5956bf0", "url": "https://translations.documentfoundation.org/api/units/112360006/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:27.043298Z" } ] }