Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-master/textscalc01/dz/units/?format=api&page=103
https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/units/?format=api&page=104", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/units/?format=api&page=102", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<item type=\"input\">=MONTH(NOW())</item> returns the current month." ], "previous_source": "", "target": [ "" ], "id_hash": -7592377325733978034, "content_hash": -7592377325733978034, "location": "func_month.xhp", "context": "func_month.xhp\npar_id3149244\nhelp.text", "note": "LuUhY", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7353, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/24951468/?format=api", "priority": 100, "id": 1473945, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=16a2750c62e5604e", "url": "https://translations.documentfoundation.org/api/units/1473945/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:08.706725Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<item type=\"input\">=MONTH(C4)</item> returns 7 if you enter 2000-07-07 to cell C4 (that date value might get formatted differently after you press Enter)." ], "previous_source": "", "target": [ "" ], "id_hash": -8491534444649262145, "content_hash": -8491534444649262145, "location": "func_month.xhp", "context": "func_month.xhp\npar_id3154790\nhelp.text", "note": "BD2Ww", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7354, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 22, "source_unit": "https://translations.documentfoundation.org/api/units/24951469/?format=api", "priority": 100, "id": 1473946, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=0a280269a4afd3bf", "url": "https://translations.documentfoundation.org/api/units/1473946/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:08.718581Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "NETWORKDAYS.INTL" ], "previous_source": "", "target": [ "" ], "id_hash": -4839283120033532648, "content_hash": -4839283120033532648, "location": "func_networkdays.intl.xhp", "context": "func_networkdays.intl.xhp\ntit\nhelp.text", "note": "kbyFK", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7356, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24951470/?format=api", "priority": 100, "id": 1473947, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=3cd769a456db7518", "url": "https://translations.documentfoundation.org/api/units/1473947/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:08.733107Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<bookmark_value>NETWORKDAYS.INTL function</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": 7463221094156719831, "content_hash": 7463221094156719831, "location": "func_networkdays.intl.xhp", "context": "func_networkdays.intl.xhp\nbm_id231020162321219565\nhelp.text", "note": "H92rh", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7357, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24951471/?format=api", "priority": 100, "id": 1473948, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=e792b00b1569d6d7", "url": "https://translations.documentfoundation.org/api/units/1473948/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:08.745843Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<variable id=\"networkdaysintl\"><link href=\"text/scalc/01/func_networkdays.intl.xhp\">NETWORKDAYS.INTL</link></variable>" ], "previous_source": "", "target": [ "" ], "id_hash": -6812576298881804812, "content_hash": -6812576298881804812, "location": "func_networkdays.intl.xhp", "context": "func_networkdays.intl.xhp\nhd_id231020162211573602\nhelp.text", "note": "54nta", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7358, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/24951472/?format=api", "priority": 100, "id": 1473949, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=2174ddf363e795f4", "url": "https://translations.documentfoundation.org/api/units/1473949/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:08.759476Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<ahelp hid=\".\">Returns the number of workdays between a start date and an end date. There are options to define weekend days and holidays. The optional weekend parameter (or a string) can be used to define the weekend days (or the non-working days in each week). Also, optionally, the user can define a holiday list. The weekend days and user-defined holidays are not counted as working days.</ahelp>" ], "previous_source": "", "target": [ "" ], "id_hash": 8234703453306549382, "content_hash": 8234703453306549382, "location": "func_networkdays.intl.xhp", "context": "func_networkdays.intl.xhp\npar_id231020162213393086\nhelp.text", "note": "kDcRW", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7359, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 66, "source_unit": "https://translations.documentfoundation.org/api/units/24951473/?format=api", "priority": 100, "id": 1473950, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=f2478b295504f486", "url": "https://translations.documentfoundation.org/api/units/1473950/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:08.773600Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<emph>StartDate</emph> is the date from when the calculation is carried out. If the start date is a workday, the day is included in the calculation." ], "previous_source": "", "target": [ "" ], "id_hash": 4847327864803132175, "content_hash": 4847327864803132175, "location": "func_networkdays.intl.xhp", "context": "func_networkdays.intl.xhp\npar_id231020162249533010\nhelp.text", "note": "D8jig", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7361, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 25, "source_unit": "https://translations.documentfoundation.org/api/units/24951475/?format=api", "priority": 100, "id": 1473953, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=c3452b02c371830f", "url": "https://translations.documentfoundation.org/api/units/1473953/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:08.800533Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<emph>EndDate</emph> is the date up until when the calculation is carried out. If the end date is a workday, the day is included in the calculation." ], "previous_source": "", "target": [ "" ], "id_hash": -6632844920074557198, "content_hash": -6632844920074557198, "location": "func_networkdays.intl.xhp", "context": "func_networkdays.intl.xhp\npar_id231020162249536398\nhelp.text", "note": "DU9WK", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7362, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/24951476/?format=api", "priority": 100, "id": 1473954, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=23f366b000b3a8f2", "url": "https://translations.documentfoundation.org/api/units/1473954/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:08.812473Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "How many workdays fall between December 15, 2016 and January 14, 2017? Let the start date be located in C3 and the end date in D3. Cells F3 to J3 contain five (5) holidays for Christmas and New Year in date format: December 24, 2016; December 25, 2016; December 26, 2016; December 31, 2016; and January 1, 2017." ], "previous_source": "", "target": [ "" ], "id_hash": 864578906826754154, "content_hash": 864578906826754154, "location": "func_networkdays.intl.xhp", "context": "func_networkdays.intl.xhp\npar_id231020162249554032\nhelp.text", "note": "Yhepz", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7363, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 58, "source_unit": "https://translations.documentfoundation.org/api/units/24951477/?format=api", "priority": 100, "id": 1473955, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=8bff99ef5db4486a", "url": "https://translations.documentfoundation.org/api/units/1473955/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:08.829410Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<item type=\"input\">=NETWORKDAYS.INTL(C3;D3;;F3:J3)</item> returns 21 workdays with default for weekend days." ], "previous_source": "", "target": [ "" ], "id_hash": -1198226530928746079, "content_hash": -1198226530928746079, "location": "func_networkdays.intl.xhp", "context": "func_networkdays.intl.xhp\npar_id231020162249551234\nhelp.text", "note": "YtSPd", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7364, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/24951478/?format=api", "priority": 100, "id": 1473956, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=6f5f0b518f8b21a1", "url": "https://translations.documentfoundation.org/api/units/1473956/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:08.843194Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<item type=\"input\">=NETWORKDAYS.INTL(C3;D3;11;F3:J3)</item> returns 24 workdays with Sunday only weekends." ], "previous_source": "", "target": [ "" ], "id_hash": 9100411151027385989, "content_hash": 9100411151027385989, "location": "func_networkdays.intl.xhp", "context": "func_networkdays.intl.xhp\npar_id231020162249553109\nhelp.text", "note": "Q4DCf", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7365, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/24951479/?format=api", "priority": 100, "id": 1473957, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=fe4b27b9cefdb685", "url": "https://translations.documentfoundation.org/api/units/1473957/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:08.856178Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "Alternatively, use the weekend string “0000001” to define Sunday as the non-working day of every week." ], "previous_source": "", "target": [ "" ], "id_hash": 4448288852589302287, "content_hash": 4448288852589302287, "location": "func_networkdays.intl.xhp", "context": "func_networkdays.intl.xhp\npar_id231020162249557786\nhelp.text", "note": "3AN56", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7366, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/24951480/?format=api", "priority": 100, "id": 1473958, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=bdbb7f24b4ea520f", "url": "https://translations.documentfoundation.org/api/units/1473958/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:08.868856Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<item type=\"input\">=NETWORKDAYS.INTL(C3;D3;“0000001”;F3:J3)</item> returns 24 workdays with Sunday only weekend." ], "previous_source": "", "target": [ "" ], "id_hash": -3166290266284883321, "content_hash": -3166290266284883321, "location": "func_networkdays.intl.xhp", "context": "func_networkdays.intl.xhp\npar_id231020162249553409\nhelp.text", "note": "2E4Jz", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7367, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/24951481/?format=api", "priority": 100, "id": 1473959, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=540f13c74e500287", "url": "https://translations.documentfoundation.org/api/units/1473959/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:08.883701Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "The function can be used without the two optional parameters – weekday and holidays – by leaving them out:" ], "previous_source": "", "target": [ "" ], "id_hash": 3523748255882764074, "content_hash": 3523748255882764074, "location": "func_networkdays.intl.xhp", "context": "func_networkdays.intl.xhp\npar_id231020162249556946\nhelp.text", "note": "spLva", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7368, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/24951482/?format=api", "priority": 100, "id": 1473960, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=b0e6de5e7dcb5f2a", "url": "https://translations.documentfoundation.org/api/units/1473960/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:08.896532Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<item type=\"input\">=NETWORKDAYS.INTL(C3;D3)</item> gives 22 working days." ], "previous_source": "", "target": [ "" ], "id_hash": -6078042120183448005, "content_hash": -6078042120183448005, "location": "func_networkdays.intl.xhp", "context": "func_networkdays.intl.xhp\npar_id23102016224955931\nhelp.text", "note": "7pyBD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7369, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/24951483/?format=api", "priority": 100, "id": 1473961, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=2ba674e5009a7e3b", "url": "https://translations.documentfoundation.org/api/units/1473961/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:08.909475Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "NETWORKDAYS" ], "previous_source": "", "target": [ "NETWORKDAYS" ], "id_hash": 6561889438946436823, "content_hash": 6561889438946436823, "location": "func_networkdays.xhp", "context": "func_networkdays.xhp\ntit\nhelp.text", "note": "winzV", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7371, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24951484/?format=api", "priority": 100, "id": 1473966, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=db1083ada7ca26d7", "url": "https://translations.documentfoundation.org/api/units/1473966/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:08.967995Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<variable id=\"networkdays\"><link href=\"text/scalc/01/func_networkdays.xhp\">NETWORKDAYS</link></variable>" ], "previous_source": "", "target": [ "" ], "id_hash": 3573564113777338718, "content_hash": 3573564113777338718, "location": "func_networkdays.xhp", "context": "func_networkdays.xhp\nhd_id3151254\nhelp.text", "note": "HzF8v", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7373, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/24951485/?format=api", "priority": 100, "id": 1473968, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=b197d9a0bfc8295e", "url": "https://translations.documentfoundation.org/api/units/1473968/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:08.990343Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<emph>StartDate</emph> is the date from when the calculation is carried out. If the start date is a workday, the day is included in the calculation." ], "previous_source": "", "target": [ "" ], "id_hash": -178825624272293591, "content_hash": -178825624272293591, "location": "func_networkdays.xhp", "context": "func_networkdays.xhp\npar_id3153885\nhelp.text", "note": "BEtbU", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7376, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 25, "source_unit": "https://translations.documentfoundation.org/api/units/24951487/?format=api", "priority": 100, "id": 1473971, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=7d84af0acc833129", "url": "https://translations.documentfoundation.org/api/units/1473971/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:09.021851Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<emph>EndDate</emph> is the date up until when the calculation is carried out. If the end date is a workday, the day is included in the calculation." ], "previous_source": "", "target": [ "" ], "id_hash": -1814355179217094544, "content_hash": -1814355179217094544, "location": "func_networkdays.xhp", "context": "func_networkdays.xhp\npar_id3151110\nhelp.text", "note": "N9CAv", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7377, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/24951488/?format=api", "priority": 100, "id": 1473972, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=66d21d93ce5ff870", "url": "https://translations.documentfoundation.org/api/units/1473972/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:09.033123Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<emph>Holidays</emph> is an optional list of holidays. These are non-working days. Enter a cell range in which the holidays are listed individually." ], "previous_source": "", "target": [ "" ], "id_hash": -2701915441202722087, "content_hash": -2701915441202722087, "location": "func_networkdays.xhp", "context": "func_networkdays.xhp\npar_id3154115\nhelp.text", "note": "Zxfr2", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7378, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 22, "source_unit": "https://translations.documentfoundation.org/api/units/24951489/?format=api", "priority": 100, "id": 1473973, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=5a80de38b9f80ad9", "url": "https://translations.documentfoundation.org/api/units/1473973/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:09.048855Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<emph>Workdays</emph> is an optional list of number values defining standard work week. This list starts by Sunday, workdays are indicated by zero and non-working days by non-zero value." ], "previous_source": "", "target": [ "" ], "id_hash": 4468315047788247129, "content_hash": 4468315047788247129, "location": "func_networkdays.xhp", "context": "func_networkdays.xhp\npar_id160920161749585013\nhelp.text", "note": "UTwRH", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7379, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 28, "source_unit": "https://translations.documentfoundation.org/api/units/24951490/?format=api", "priority": 100, "id": 1473974, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=be02a4dc9ff37859", "url": "https://translations.documentfoundation.org/api/units/1473974/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:09.061945Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "How many workdays fall between 2001-12-15 and 2002-01-15? The start date is located in C3 and the end date in D3. Cells F3 to J3 contain the following Christmas and New Year holidays: \"2001-12-24\", \"2001-12-25\", \"2001-12-26\", \"2001-12-31\", \"2002-01-01\"." ], "previous_source": "", "target": [ "" ], "id_hash": -1982293131885698049, "content_hash": -1982293131885698049, "location": "func_networkdays.xhp", "context": "func_networkdays.xhp\npar_id3154661\nhelp.text", "note": "yTEUA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7380, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 38, "source_unit": "https://translations.documentfoundation.org/api/units/24951491/?format=api", "priority": 100, "id": 1473975, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=647d7ae63141a3ff", "url": "https://translations.documentfoundation.org/api/units/1473975/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:09.074109Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<item type=\"input\">=NETWORKDAYS(C3;D3;F3:J3)</item> returns 17 workdays." ], "previous_source": "", "target": [ "" ], "id_hash": 2935738812314091017, "content_hash": 2935738812314091017, "location": "func_networkdays.xhp", "context": "func_networkdays.xhp\npar_id3147328\nhelp.text", "note": "FWMFn", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7381, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/24951492/?format=api", "priority": 100, "id": 1473976, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=a8bdd6e5454efe09", "url": "https://translations.documentfoundation.org/api/units/1473976/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:09.086413Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "How many workdays fall between September 12nd and 25th in 2016 if only Mondays, Tuesdays and Wednesdays are considered as workdays?" ], "previous_source": "", "target": [ "" ], "id_hash": -1466287873485381398, "content_hash": -1466287873485381398, "location": "func_networkdays.xhp", "context": "func_networkdays.xhp\npar_id160920161751233621\nhelp.text", "note": "DxQVm", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7382, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://translations.documentfoundation.org/api/units/24951493/?format=api", "priority": 100, "id": 1473977, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=6ba6b2f2a270e0ea", "url": "https://translations.documentfoundation.org/api/units/1473977/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:09.100326Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<item type=\"input\">=NETWORKDAYS(DATE(2016;9;12); DATE(2016;9;25); ; {1;0;0;0;1;1;1})</item> returns 6 workdays." ], "previous_source": "", "target": [ "" ], "id_hash": 5717208620301641003, "content_hash": 5717208620301641003, "location": "func_networkdays.xhp", "context": "func_networkdays.xhp\npar_id160920161751235483\nhelp.text", "note": "fELgW", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7383, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/24951601/?format=api", "priority": 100, "id": 1473978, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=cf579af2f7e1652b", "url": "https://translations.documentfoundation.org/api/units/1473978/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:09.112484Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "NOW" ], "previous_source": "", "target": [ "ད་ལྟོ།" ], "id_hash": 7672545122372848302, "content_hash": 7672545122372848302, "location": "func_now.xhp", "context": "func_now.xhp\ntit\nhelp.text", "note": "HCN8H", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7385, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24951602/?format=api", "priority": 100, "id": 1473983, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=ea7a5b234e308aae", "url": "https://translations.documentfoundation.org/api/units/1473983/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:09.177535Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<bookmark_value>NOW function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value> ད་ལྟོའི་ལས་འགན། </bookmark_value>" ], "id_hash": 4319039634089526508, "content_hash": 4319039634089526508, "location": "func_now.xhp", "context": "func_now.xhp\nbm_id3150521\nhelp.text", "note": "bUAGA", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7386, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24951603/?format=api", "priority": 100, "id": 1473984, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=bbf04fa9f8bd44ec", "url": "https://translations.documentfoundation.org/api/units/1473984/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:09.190356Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<variable id=\"now\"><link href=\"text/scalc/01/func_now.xhp\">NOW</link></variable>" ], "previous_source": "", "target": [ "<variable id=\"now\"><link href=\"text/scalc/01/func_now.xhp\"> ད་ལྟོ། </link></variable>" ], "id_hash": 8724488582914162175, "content_hash": 8724488582914162175, "location": "func_now.xhp", "context": "func_now.xhp\nhd_id3150521\nhelp.text", "note": "n4jYR", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7387, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/24951604/?format=api", "priority": 100, "id": 1473985, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=f9139c244f8cbdff", "url": "https://translations.documentfoundation.org/api/units/1473985/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:09.203146Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_JETZT\">Returns the computer system date and time.</ahelp> The value is updated when you recalculate the document or each time a cell value is modified." ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_JETZT\"> གློག་རིག་རིམ་ལུགས་ཚེས་དང་དུས་ཚོད་ སླར་ལོག་འབདཝ་ཨིན། </ahelp> གནས་གོང་འདི་ཁྱོད་ཀྱིས་ཡིག་ཆ་འདི་ཡང་བསྐྱར་རྩིས་སྟོནམ་ད་དང་ཡང་ན་ ནང་ཐིག་གནས་གོང་ཚར་རེ་རེ་ལེགས་བཅོས་འབདཝ་དང་གནས་གོང་འདི་དུས་མཐུནམ་བཟོ་ཡོདཔ་ཨིན།" ], "id_hash": 4908476510420007667, "content_hash": 4908476510420007667, "location": "func_now.xhp", "context": "func_now.xhp\npar_id3148829\nhelp.text", "note": "o7Wxp", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7388, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 25, "source_unit": "https://translations.documentfoundation.org/api/units/24951605/?format=api", "priority": 100, "id": 1473986, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=c41e696147eefaf3", "url": "https://translations.documentfoundation.org/api/units/1473986/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:09.216411Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "NOW()" ], "previous_source": "", "target": [ "ད་ལྟོ།()" ], "id_hash": 3319766644813171290, "content_hash": 3319766644813171290, "location": "func_now.xhp", "context": "func_now.xhp\npar_id3154897\nhelp.text", "note": "4wCVv", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7389, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24951606/?format=api", "priority": 100, "id": 1473987, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=ae122e2cb1478a5a", "url": "https://translations.documentfoundation.org/api/units/1473987/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:09.229935Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "NOW is a function without arguments." ], "previous_source": "", "target": [ "" ], "id_hash": -4095934625277828030, "content_hash": -4095934625277828030, "location": "func_now.xhp", "context": "func_now.xhp\npar_id4598529\nhelp.text", "note": "j8sKU", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7390, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/24951607/?format=api", "priority": 100, "id": 1473988, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=47285128d517a442", "url": "https://translations.documentfoundation.org/api/units/1473988/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:09.244403Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<item type=\"input\">=NOW()-A1</item> returns the difference between the date in A1 and now. Format the result as a number." ], "previous_source": "", "target": [ "=NOW()-ཨེ་ ༡ གིས་ཨེ་ ༡ དང་ད་ལྟོའི་ཚེས་ཀྱི་བར་གྱི་ཁྱད་པར་སླར་ལོག་འབདཝ་ཨིན། གྲུབ་འབྲས་འདི་ཨང་སྦེ་རྩ་སྒྲིག་འབད།" ], "id_hash": -2769973158782386336, "content_hash": -2769973158782386336, "location": "func_now.xhp", "context": "func_now.xhp\npar_id3150774\nhelp.text", "note": "DXy7U", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7391, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/24951608/?format=api", "priority": 100, "id": 1473989, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=598f14168968bf60", "url": "https://translations.documentfoundation.org/api/units/1473989/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:09.256907Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "NUMBERVALUE" ], "previous_source": "", "target": [ "" ], "id_hash": -1807660715623394968, "content_hash": -1807660715623394968, "location": "func_numbervalue.xhp", "context": "func_numbervalue.xhp\ntit\nhelp.text", "note": "G3PMG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7393, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24951609/?format=api", "priority": 100, "id": 1473990, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=66e9e62812d6d168", "url": "https://translations.documentfoundation.org/api/units/1473990/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:09.268720Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<bookmark_value>NUMBERVALUE function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>TIMEVALUE ལས་འགན།</bookmark_value>" ], "id_hash": -3577443060746469869, "content_hash": -3577443060746469869, "location": "func_numbervalue.xhp", "context": "func_numbervalue.xhp\nbm_id3145621\nhelp.text", "note": "ExLmD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7394, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24951610/?format=api", "priority": 100, "id": 1473991, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=4e5a5e7d88053e13", "url": "https://translations.documentfoundation.org/api/units/1473991/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:09.281486Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "RAWSUBTRACT function" ], "previous_source": "", "target": [ "" ], "id_hash": 2087472311868244366, "content_hash": 2087472311868244366, "location": "func_rawsubtract.xhp", "context": "func_rawsubtract.xhp\ntit\nhelp.text", "note": "zr5G3", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7492, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24951619/?format=api", "priority": 100, "id": 1474000, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=9cf83101fb5ec18e", "url": "https://translations.documentfoundation.org/api/units/1474000/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:09.404309Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<bookmark_value>rawsubtract;subtraction</bookmark_value> <bookmark_value>RAWSUBTRACT function</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": -1935622469359717930, "content_hash": -1935622469359717930, "location": "func_rawsubtract.xhp", "context": "func_rawsubtract.xhp\nbm_2016112109230\nhelp.text", "note": "JTmpK", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7493, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/24951620/?format=api", "priority": 100, "id": 1474001, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=6523499e968cb1d6", "url": "https://translations.documentfoundation.org/api/units/1474001/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:09.417672Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<ahelp hid=\".\">Subtracts a set of numbers and gives the result without eliminating small roundoff errors.</ahelp>" ], "previous_source": "", "target": [ "" ], "id_hash": 4964628386028205536, "content_hash": 4964628386028205536, "location": "func_rawsubtract.xhp", "context": "func_rawsubtract.xhp\npar_2016112109232\nhelp.text", "note": "CoCx7", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7495, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/24951622/?format=api", "priority": 100, "id": 1474003, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=c4e5e7369f0835e0", "url": "https://translations.documentfoundation.org/api/units/1474003/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:09.446467Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "REGEX Function" ], "previous_source": "", "target": [ "" ], "id_hash": 8741176359522132787, "content_hash": 8741176359522132787, "location": "func_regex.xhp", "context": "func_regex.xhp\ntit\nhelp.text", "note": "d9DP3", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7504, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24951627/?format=api", "priority": 100, "id": 1474008, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=f94ee596145be333", "url": "https://translations.documentfoundation.org/api/units/1474008/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:09.526005Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<bookmark_value>REGEX function</bookmark_value> <bookmark_value>regular expressions;extracting in spreadsheets</bookmark_value> <bookmark_value>regular expressions;REGEX function</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": -2788790445375112205, "content_hash": -2788790445375112205, "location": "func_regex.xhp", "context": "func_regex.xhp\nbm_id831542233029549\nhelp.text", "note": "yZJB8", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7505, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/24951628/?format=api", "priority": 100, "id": 1474009, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=594c39dd9669bbf3", "url": "https://translations.documentfoundation.org/api/units/1474009/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:09.540367Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<variable id=\"func_regex_desc\"><ahelp hid=\".\">Matches and extracts or optionally replaces text using regular expressions.</ahelp></variable>" ], "previous_source": "", "target": [ "" ], "id_hash": 8223913445329152686, "content_hash": 8223913445329152686, "location": "func_regex.xhp", "context": "func_regex.xhp\npar_id541542230672101\nhelp.text", "note": "uTy7w", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7507, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/24951630/?format=api", "priority": 100, "id": 1474011, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=f22135b4d4672aae", "url": "https://translations.documentfoundation.org/api/units/1474011/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:09.570519Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "REGEX( Text ; Expression [ ; [ Replacement ] [ ; Flags|Occurrence ] ] )" ], "previous_source": "", "target": [ "" ], "id_hash": 3023438637390777590, "content_hash": 3023438637390777590, "location": "func_regex.xhp", "context": "func_regex.xhp\npar_id701542231253817\nhelp.text", "note": "k7Cxh", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7508, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/24951631/?format=api", "priority": 100, "id": 1474012, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=a9f5696bfdde4cf6", "url": "https://translations.documentfoundation.org/api/units/1474012/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:09.587867Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<emph>Text</emph>: A text or reference to a cell where the regular expression is to be applied." ], "previous_source": "", "target": [ "" ], "id_hash": -4578302995079490394, "content_hash": -4578302995079490394, "location": "func_regex.xhp", "context": "func_regex.xhp\npar_id621542232197446\nhelp.text", "note": "VbMmQ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7509, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/24951632/?format=api", "priority": 100, "id": 1474013, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=407699aed02e14a6", "url": "https://translations.documentfoundation.org/api/units/1474013/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:09.604304Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<emph>Replacement</emph>: Optional. The replacement text and references to capture groups. If there is no match, <emph>Text</emph> is returned unmodified." ], "previous_source": "", "target": [ "" ], "id_hash": 2013192488906082466, "content_hash": 2013192488906082466, "location": "func_regex.xhp", "context": "func_regex.xhp\npar_id581542232755604\nhelp.text", "note": "ZBTYi", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7511, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/24951634/?format=api", "priority": 100, "id": 1474015, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=9bf04be6fdbb48a2", "url": "https://translations.documentfoundation.org/api/units/1474015/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:09.636525Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<emph>Flags</emph>: Optional. \"g\" replaces all matches of <emph>Expression</emph> in <emph>Text</emph>, not extracted. If there is no match, <emph>Text</emph> is returned unmodified." ], "previous_source": "", "target": [ "" ], "id_hash": -5297474542465519083, "content_hash": -5297474542465519083, "location": "func_regex.xhp", "context": "func_regex.xhp\npar_id421542232246840\nhelp.text", "note": "V55JH", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7512, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://translations.documentfoundation.org/api/units/24951635/?format=api", "priority": 100, "id": 1474016, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=367b96f889aaf215", "url": "https://translations.documentfoundation.org/api/units/1474016/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:09.650205Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<emph>Occurrence</emph>: Optional. Number to indicate which match of <emph>Expression</emph> in <emph>Text</emph> is to be extracted or replaced. If there is no match and <emph>Replacement</emph> is not given, #N/A is returned. If there is no match and <emph>Replacement</emph> is given, <emph>Text</emph> is returned unmodified. If <emph>Occurrence</emph> is 0, <emph>Text</emph> is returned unmodified." ], "previous_source": "", "target": [ "" ], "id_hash": 1854650481244622242, "content_hash": 1854650481244622242, "location": "func_regex.xhp", "context": "func_regex.xhp\npar_id421542232246841\nhelp.text", "note": "GPGFT", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7513, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 51, "source_unit": "https://translations.documentfoundation.org/api/units/24951636/?format=api", "priority": 100, "id": 1474017, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=99bd0ac94d17cda2", "url": "https://translations.documentfoundation.org/api/units/1474017/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:09.664574Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<item type=\"input\">=REGEX(\"123456ABCDEF\";\"[:digit:]\";\"Z\")</item> returns \"Z23456ABCDEF\", where the first match of a digit is replaced by \"Z\"." ], "previous_source": "", "target": [ "" ], "id_hash": -5952686738672314907, "content_hash": -5952686738672314907, "location": "func_regex.xhp", "context": "func_regex.xhp\npar_id371542291684176\nhelp.text", "note": "AFjHj", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7514, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/24951637/?format=api", "priority": 100, "id": 1474018, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=2d63cef32a4215e5", "url": "https://translations.documentfoundation.org/api/units/1474018/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:09.678261Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<item type=\"input\">=REGEX(\"123456ABCDEF\";\"[:digit:]\";\"Z\";\"g\")</item> returns \"ZZZZZZABCDEF\", where all digits were replaced by \"Z\"." ], "previous_source": "", "target": [ "" ], "id_hash": 695247817321250266, "content_hash": 695247817321250266, "location": "func_regex.xhp", "context": "func_regex.xhp\npar_id891542291697194\nhelp.text", "note": "aDqow", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7515, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/24951638/?format=api", "priority": 100, "id": 1474019, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=89a60434ce4c7dda", "url": "https://translations.documentfoundation.org/api/units/1474019/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:09.692667Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<item type=\"input\">=REGEX(\"123456ABCDEF\";\"[126]\";\"\";\"g\")</item> returns \"345ABCDEF\", where any occurrence of \"1\", \"2\" or \"6\" is replaced by the empty string, thus deleted." ], "previous_source": "", "target": [ "" ], "id_hash": -4993602398315757719, "content_hash": -4993602398315757719, "location": "func_regex.xhp", "context": "func_regex.xhp\npar_id21542291705695\nhelp.text", "note": "gP9wd", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7516, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/24951639/?format=api", "priority": 100, "id": 1474020, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=3ab3291372d9bf69", "url": "https://translations.documentfoundation.org/api/units/1474020/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:09.710862Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<item type=\"input\">=REGEX(\"axbxcxd\";\".x\";;2)</item> returns \"bx\", the second match of \".x\"." ], "previous_source": "", "target": [ "" ], "id_hash": 3963237180189337487, "content_hash": 3963237180189337487, "location": "func_regex.xhp", "context": "func_regex.xhp\npar_id371542291684177\nhelp.text", "note": "ZjpCF", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7517, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/24951640/?format=api", "priority": 100, "id": 1474021, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=b7003f379dce678f", "url": "https://translations.documentfoundation.org/api/units/1474021/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:09.723684Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<item type=\"input\">=REGEX(\"axbxcxd\";\"(.)x\";\"$1y\";2)</item> returns \"axbycxd\", the second match of \"(.)x\" (i.e. \"bx\") replaced with the captured group of one character (i.e. \"b\") followed by \"y\"." ], "previous_source": "", "target": [ "" ], "id_hash": 726030167247616408, "content_hash": 726030167247616408, "location": "func_regex.xhp", "context": "func_regex.xhp\npar_id371542291684178\nhelp.text", "note": "UBU7G", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7518, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://translations.documentfoundation.org/api/units/24951641/?format=api", "priority": 100, "id": 1474022, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=8a1360972702f998", "url": "https://translations.documentfoundation.org/api/units/1474022/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:09.735661Z" } ] }{ "count": 8628, "next": "