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=128
https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/units/?format=api&page=129", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/units/?format=api&page=127", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<item type=\"input\">=MINIFS(C2:C6;A2:A6;\".*book\";B2:B6;\">\"&MIN(B2:B6))</item>" ], "previous_source": "", "target": [ "" ], "id_hash": 2524283094541941754, "content_hash": 2524283094541941754, "location": "func_minifs.xhp", "context": "func_minifs.xhp\npar_id220502883332563\nhelp.text", "note": "7S443", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7328, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/45224580/?format=api", "priority": 100, "id": 45224953, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=a3080e19aab23bfa", "url": "https://translations.documentfoundation.org/api/units/45224953/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-02-01T17:14:12.316185Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "Calculates the minimum of values of the range C2:C6 that correspond to all cells of the A2:A6 range ending with \"book\" and to all cells of the B2:B6 range except its minimum. Returns 190." ], "previous_source": "", "target": [ "" ], "id_hash": 1511293224466033220, "content_hash": 1511293224466033220, "location": "func_minifs.xhp", "context": "func_minifs.xhp\npar_id15342189586295\nhelp.text", "note": "gNhzJ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7329, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 34, "source_unit": "https://translations.documentfoundation.org/api/units/45224581/?format=api", "priority": 100, "id": 45224954, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=94f9312e33c0aa44", "url": "https://translations.documentfoundation.org/api/units/45224954/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-02-01T17:14:12.317351Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "An asset was acquired on 2020-02-01 at a cost of 2000 currency units. The end date of the first settlement period was 2020-12-31. The salvage value of the asset at the end of its depreciable life will be 10 currency units. The rate of depreciation is 0.1 (10%) and the year is calculated using the US method (Basis 0). Assuming degressive depreciation, what is the amount of depreciation in the fourth depreciation period?" ], "previous_source": "", "target": [ "" ], "id_hash": -5228245508784641828, "content_hash": -5228245508784641828, "location": "04060103.xhp", "context": "04060103.xhp\npar_id421612299085248\nhelp.text", "note": "TzEBm", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 684, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 73, "source_unit": "https://translations.documentfoundation.org/api/units/45246920/?format=api", "priority": 100, "id": 45248304, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=37718a69025c28dc", "url": "https://translations.documentfoundation.org/api/units/45248304/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-02-05T18:44:13.282173Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<input>=AMORDEGRC(2000; \"2020-02-01\"; \"2020-12-31\"; 10; 4; 0.1; 0)</input> returns a depreciation amount of 163 currency units." ], "previous_source": "", "target": [ "" ], "id_hash": 245963434773617104, "content_hash": 245963434773617104, "location": "04060103.xhp", "context": "04060103.xhp\npar_id901612299089478\nhelp.text", "note": "qyD4t", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 685, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/45246921/?format=api", "priority": 100, "id": 45248305, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=8369d670d56a99d0", "url": "https://translations.documentfoundation.org/api/units/45248305/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-02-05T18:44:13.283970Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "An asset was acquired on 2020-02-01 at a cost of 2000 currency units. The end date of the first settlement period was 2020-12-31. The salvage value of the asset at the end of its depreciable life will be 10 currency units. The rate of depreciation is 0.1 (10%) and the year is calculated using the US method (Basis 0). Assuming linear depreciation, what is the amount of depreciation in the fourth depreciation period?" ], "previous_source": "", "target": [ "" ], "id_hash": 345143527192589021, "content_hash": 345143527192589021, "location": "04060103.xhp", "context": "04060103.xhp\npar_id641612299092454\nhelp.text", "note": "vJKVs", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 697, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 73, "source_unit": "https://translations.documentfoundation.org/api/units/45246922/?format=api", "priority": 100, "id": 45248306, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=84ca323596d6f2dd", "url": "https://translations.documentfoundation.org/api/units/45248306/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-02-05T18:44:13.304151Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<input>=AMORLINC(2000; \"2020-02-01\"; \"2020-12-31\"; 10; 4; 0.1; 0)</input> returns a depreciation amount of 200 currency units." ], "previous_source": "", "target": [ "" ], "id_hash": -3770883857476057422, "content_hash": -3770883857476057422, "location": "04060103.xhp", "context": "04060103.xhp\npar_id391612299096511\nhelp.text", "note": "zcGNo", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 698, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/45246923/?format=api", "priority": 100, "id": 45248307, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=4bab211c51e286b2", "url": "https://translations.documentfoundation.org/api/units/45248307/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-02-05T18:44:13.306599Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<emph>Par</emph> (optional) is the par value of the security. If omitted, a default value of 1000 is used." ], "previous_source": "", "target": [ "" ], "id_hash": 5263516810654517299, "content_hash": 5263516810654517299, "location": "04060103.xhp", "context": "04060103.xhp\npar_id3159204\nhelp.text", "note": "GPEHn", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 720, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/45246924/?format=api", "priority": 100, "id": 45248308, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=c90bc4a6e85c0833", "url": "https://translations.documentfoundation.org/api/units/45248308/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-02-05T18:44:13.345173Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "We recommend that you always specify the value that you require for ACCRINTM’s <emph>Par</emph> argument, rather than allowing Calc to apply an arbitrary default. This will make your formula easier to understand and easier to maintain." ], "previous_source": "", "target": [ "" ], "id_hash": -7636179999259246668, "content_hash": -7636179999259246668, "location": "04060103.xhp", "context": "04060103.xhp\npar_id481612296978513\nhelp.text", "note": "EJaKm", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 721, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 36, "source_unit": "https://translations.documentfoundation.org/api/units/45246925/?format=api", "priority": 100, "id": 45248309, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=1606d6bfb735bfb4", "url": "https://translations.documentfoundation.org/api/units/45248309/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-02-05T18:44:13.346373Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "A computer system with an initial cost of 25,000 currency units is to be depreciated over a three-year period. The salvage value is to be 1,000 currency units. The first period of depreciation comprises 6 months. What is the fixed-declining balance depreciation of the computer system in the second period, which is a full year starting from the end of the first six-month period?" ], "previous_source": "", "target": [ "" ], "id_hash": 1211813644399136157, "content_hash": 1211813644399136157, "location": "04060103.xhp", "context": "04060103.xhp\npar_id3156147\nhelp.text", "note": "D2krK", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 872, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 64, "source_unit": "https://translations.documentfoundation.org/api/units/45246926/?format=api", "priority": 100, "id": 45248310, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=90d13a16d061cd9d", "url": "https://translations.documentfoundation.org/api/units/45248310/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-02-05T18:44:13.974177Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<input>=DB(25000; 1000; 3; 2; 6)</input> returns 11,037.95 currency units." ], "previous_source": "", "target": [ "" ], "id_hash": 6453887500395967157, "content_hash": 6453887500395967157, "location": "04060103.xhp", "context": "04060103.xhp\npar_id3149513\nhelp.text", "note": "4CQGc", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 873, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/45246927/?format=api", "priority": 100, "id": 45248311, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=d990d07cc96f72b5", "url": "https://translations.documentfoundation.org/api/units/45248311/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-02-05T18:44:13.975832Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_TABELLE\">Returns the sheet number of either a reference or a string representing a sheet name.</ahelp> If you do not enter any parameters, the result is the sheet number of the spreadsheet containing the formula." ], "previous_source": "", "target": [ "" ], "id_hash": 5500430683439494706, "content_hash": 5500430683439494706, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3150309\nhelp.text", "note": "BRXnw", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2073, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 35, "source_unit": "https://translations.documentfoundation.org/api/units/45246940/?format=api", "priority": 100, "id": 45248312, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=cc5574906611f632", "url": "https://translations.documentfoundation.org/api/units/45248312/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-02-05T18:44:15.777364Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<input>=SHEET(Sheet2.A1)</input> returns 2 if Sheet2 is the second sheet in the spreadsheet document." ], "previous_source": "", "target": [ "" ], "id_hash": -8376814135589143232, "content_hash": -8376814135589143232, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3146988\nhelp.text", "note": "wbjCM", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2076, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/45246941/?format=api", "priority": 100, "id": 45248313, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=0bbf93ed0abcfd40", "url": "https://translations.documentfoundation.org/api/units/45248313/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-02-05T18:44:15.781449Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<input>=SHEET(\"Sheet3\")</input> returns 3 if Sheet3 is the third sheet in the spreadsheet document." ], "previous_source": "", "target": [ "" ], "id_hash": -4871450135322043081, "content_hash": -4871450135322043081, "location": "04060109.xhp", "context": "04060109.xhp\npar_id491612531793751\nhelp.text", "note": "fEQws", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2077, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/45246942/?format=api", "priority": 100, "id": 45248314, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=3c6521e97719dd37", "url": "https://translations.documentfoundation.org/api/units/45248314/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-02-05T18:44:15.782760Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "Suppose we have built a small database table occupying the cell range A1:DO4 and containing basic information about 118 chemical elements. The first column contains the row headings “Element”, “Symbol”, “Atomic Number”, and “Relative Atomic Mass”. Subsequent columns contain the relevant information for each of the elements, ordered left to right by atomic number. For example, cells B1:B4 contain “Hydrogen”, “H”, “1” and “1.008”, while cells DO1:DO4 contain “Oganesson”, “Og”, “118”, and “294”." ], "previous_source": "", "target": [ "" ], "id_hash": 4634706998389279706, "content_hash": 4634706998389279706, "location": "04060109.xhp", "context": "04060109.xhp\npar_id141612447324913\nhelp.text", "note": "vwqHz", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2133, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 73, "source_unit": "https://translations.documentfoundation.org/api/units/45246943/?format=api", "priority": 100, "id": 45248315, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=c051c97595028bda", "url": "https://translations.documentfoundation.org/api/units/45248315/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-02-05T18:44:15.881443Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "Hydrogen" ], "previous_source": "", "target": [ "" ], "id_hash": -2956641131870373628, "content_hash": -2956641131870373628, "location": "04060109.xhp", "context": "04060109.xhp\npar_id711612450364379\nhelp.text", "note": "BcKD5", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2135, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/45246944/?format=api", "priority": 100, "id": 45248316, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=56f7e68e368eb904", "url": "https://translations.documentfoundation.org/api/units/45248316/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-02-05T18:44:15.883069Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "Helium" ], "previous_source": "", "target": [ "" ], "id_hash": -3753674292092525244, "content_hash": -3753674292092525244, "location": "04060109.xhp", "context": "04060109.xhp\npar_id681612450364379\nhelp.text", "note": "ACHPj", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2136, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/45246945/?format=api", "priority": 100, "id": 45248317, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=4be8451e814f2544", "url": "https://translations.documentfoundation.org/api/units/45248317/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-02-05T18:44:15.884480Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "Lithium" ], "previous_source": "", "target": [ "" ], "id_hash": 6395355888623892843, "content_hash": 6395355888623892843, "location": "04060109.xhp", "context": "04060109.xhp\npar_id531612453345232\nhelp.text", "note": "7YEmL", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2137, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/45246946/?format=api", "priority": 100, "id": 45248318, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=d8c0de4bf1a1396b", "url": "https://translations.documentfoundation.org/api/units/45248318/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-02-05T18:44:15.885555Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "Oganesson" ], "previous_source": "", "target": [ "" ], "id_hash": -6406307038623048080, "content_hash": -6406307038623048080, "location": "04060109.xhp", "context": "04060109.xhp\npar_id571612453039430\nhelp.text", "note": "Y3c6z", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2138, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/45246947/?format=api", "priority": 100, "id": 45248319, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=271839b0c0c9de70", "url": "https://translations.documentfoundation.org/api/units/45248319/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-02-05T18:44:15.886578Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<input>=HLOOKUP(\"Lead\"; $A$1:$DO$4; 2; 0)</input> returns “Pb”, the symbol for lead." ], "previous_source": "", "target": [ "" ], "id_hash": 6194904089656399110, "content_hash": 6194904089656399110, "location": "04060109.xhp", "context": "04060109.xhp\npar_id51612447346319\nhelp.text", "note": "Cb3HA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2142, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/45246948/?format=api", "priority": 100, "id": 45248320, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=d5f8b87291959506", "url": "https://translations.documentfoundation.org/api/units/45248320/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-02-05T18:44:15.887651Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<input>=HLOOKUP(\"Gold\"; $A$1:$DO$4; 3; 0)</input> returns 79, the atomic number for gold." ], "previous_source": "", "target": [ "" ], "id_hash": -6964637376951726322, "content_hash": -6964637376951726322, "location": "04060109.xhp", "context": "04060109.xhp\npar_id291612447349416\nhelp.text", "note": "Fa8kD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2143, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/45246955/?format=api", "priority": 100, "id": 45248321, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=1f58a334b5624f0e", "url": "https://translations.documentfoundation.org/api/units/45248321/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-02-05T18:44:15.888891Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<input>=HLOOKUP(\"Carbon\"; $A$1:$DO$4; 4; 0)</input> returns 12.011, the relative atomic mass of carbon." ], "previous_source": "", "target": [ "" ], "id_hash": -4588238262470200363, "content_hash": -4588238262470200363, "location": "04060109.xhp", "context": "04060109.xhp\npar_id971612447352912\nhelp.text", "note": "LbWuo", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2144, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/45246956/?format=api", "priority": 100, "id": 45248322, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=40534d9c1c9bb3d5", "url": "https://translations.documentfoundation.org/api/units/45248322/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-02-05T18:44:15.889985Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "Calculation of the internal rate of return for the following five payments (dates are in ISO 8601 format):" ], "previous_source": "", "target": [ "" ], "id_hash": -4118064062964380717, "content_hash": -4118064062964380717, "location": "04060118.xhp", "context": "04060118.xhp\npar_id3149273\nhelp.text", "note": "dZESY", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 3072, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/45246963/?format=api", "priority": 100, "id": 45248323, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=46d9b28d9cb4cbd3", "url": "https://translations.documentfoundation.org/api/units/45248323/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-02-05T18:44:18.260444Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "Received" ], "previous_source": "", "target": [ "" ], "id_hash": -2418361340157148658, "content_hash": -2418361340157148658, "location": "04060118.xhp", "context": "04060118.xhp\npar_id3146856\nhelp.text", "note": "6JTLA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 3073, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/45246964/?format=api", "priority": 100, "id": 45248324, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=5e70412c9565420e", "url": "https://translations.documentfoundation.org/api/units/45248324/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-02-05T18:44:18.262064Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "Deposited" ], "previous_source": "", "target": [ "" ], "id_hash": -420779838081458730, "content_hash": -420779838081458730, "location": "04060118.xhp", "context": "04060118.xhp\npar_id3149985\nhelp.text", "note": "N2RNr", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 3074, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/45246965/?format=api", "priority": 100, "id": 45248325, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=7a2916f776821dd6", "url": "https://translations.documentfoundation.org/api/units/45248325/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-02-05T18:44:18.263637Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<input>=XIRR(B1:B5; A1:A5; 0.1)</input> returns 0.1828 or 18.28%." ], "previous_source": "", "target": [ "" ], "id_hash": 5585357029465792238, "content_hash": 5585357029465792238, "location": "04060118.xhp", "context": "04060118.xhp\npar_id3152793\nhelp.text", "note": "FLNWb", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 3075, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/45246966/?format=api", "priority": 100, "id": 45248326, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=cd832ca0350a1eee", "url": "https://translations.documentfoundation.org/api/units/45248326/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-02-05T18:44:18.265191Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "Freeze Cells" ], "previous_source": "", "target": [ "" ], "id_hash": 2874300371277646268, "content_hash": 2874300371277646268, "location": "07090100.xhp", "context": "07090100.xhp\ntit\nhelp.text", "note": "mBdCG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 5246, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/45246987/?format=api", "priority": 100, "id": 45248330, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=a7e390f57fc709bc", "url": "https://translations.documentfoundation.org/api/units/45248330/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-02-05T18:44:21.602412Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "Freezes the first column or the first row of the current spreadsheet." ], "previous_source": "", "target": [ "" ], "id_hash": -3717969937650444606, "content_hash": -3717969937650444606, "location": "07090100.xhp", "context": "07090100.xhp\npar_id481612313262514\nhelp.text", "note": "sWGWB", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 5249, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/45246990/?format=api", "priority": 100, "id": 45248333, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=4c671e0a54c396c2", "url": "https://translations.documentfoundation.org/api/units/45248333/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-02-05T18:44:21.606334Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<input>SKEWP(2;3;1;6;8;5)</input> returns 0.2329985562" ], "previous_source": "", "target": [ "" ], "id_hash": 6128495633331739541, "content_hash": 6128495633331739541, "location": "func_skewp.xhp", "context": "func_skewp.xhp\npar_id1102201617001888\nhelp.text", "note": "Q2i35", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7617, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/45247009/?format=api", "priority": 100, "id": 45248343, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=d50cca4ef0455b95", "url": "https://translations.documentfoundation.org/api/units/45248343/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-02-05T18:44:24.795575Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<input>SKEWP(A1:A6)</input> returns 0.2329985562, when the range A1:A6 contains {2;3;1;6;8;5}" ], "previous_source": "", "target": [ "" ], "id_hash": -7529646341830377513, "content_hash": -7529646341830377513, "location": "func_skewp.xhp", "context": "func_skewp.xhp\npar_id1102201618185378\nhelp.text", "note": "TAGzC", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7618, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/45247010/?format=api", "priority": 100, "id": 45248344, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=1781528bbee17fd7", "url": "https://translations.documentfoundation.org/api/units/45248344/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-02-05T18:44:24.796791Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "Element" ], "previous_source": "", "target": [ "" ], "id_hash": 2569298458541281685, "content_hash": 2569298458541281685, "location": "04060109.xhp", "context": "04060109.xhp\npar_id151612978320063\nhelp.text", "note": "eAMVa", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2134, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/45315350/?format=api", "priority": 100, "id": 45315510, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=a3a7fb55d74fd195", "url": "https://translations.documentfoundation.org/api/units/45315510/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-02-17T16:05:31.085505Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "Symbol" ], "previous_source": "", "target": [ "" ], "id_hash": -2741696328488591392, "content_hash": -2741696328488591392, "location": "04060109.xhp", "context": "04060109.xhp\npar_id341612978329327\nhelp.text", "note": "4H4fa", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2139, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/45315351/?format=api", "priority": 100, "id": 45315511, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=59f389b72271dfe0", "url": "https://translations.documentfoundation.org/api/units/45315511/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-02-17T16:05:31.092706Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "Atomic Number" ], "previous_source": "", "target": [ "" ], "id_hash": 8197228261284471071, "content_hash": 8197228261284471071, "location": "04060109.xhp", "context": "04060109.xhp\npar_id601612978601591\nhelp.text", "note": "jVBoy", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2140, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/45315352/?format=api", "priority": 100, "id": 45315512, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=f1c267ac40a7611f", "url": "https://translations.documentfoundation.org/api/units/45315512/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-02-17T16:05:31.094000Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "Relative Atomic Mass" ], "previous_source": "", "target": [ "" ], "id_hash": -3629097185374679292, "content_hash": -3629097185374679292, "location": "04060109.xhp", "context": "04060109.xhp\npar_id751612978603374\nhelp.text", "note": "WjrrE", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2141, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/45315353/?format=api", "priority": 100, "id": 45315513, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=4da2db56725f4f04", "url": "https://translations.documentfoundation.org/api/units/45315513/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-02-17T16:05:31.095340Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "Calc does not provide multiple hierarchies for a single field and so this option is normally grayed. If you use a pivot table data source extension, that extension could define multiple hierarchies for some fields and then the option could become available. See the documentation supplied with that extension for more details." ], "previous_source": "", "target": [ "" ], "id_hash": 7213805661603614145, "content_hash": 7213805661603614145, "location": "12090106.xhp", "context": "12090106.xhp\npar_id681598453957935\nhelp.text", "note": "FMiU9", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 5740, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 52, "source_unit": "https://translations.documentfoundation.org/api/units/45315354/?format=api", "priority": 100, "id": 45315514, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=e41c96076295cdc1", "url": "https://translations.documentfoundation.org/api/units/45315514/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-02-17T16:05:38.708695Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<input>=HYPERLINK(\"http://www.example.org\")</input> displays the text \"http://www.example.org\" in the cell and executes the hyperlink http://www.example.org when clicked." ], "previous_source": "", "target": [ "" ], "id_hash": -6685719284871824382, "content_hash": -6685719284871824382, "location": "04060109.xhp", "context": "04060109.xhp\npar_idN11827\nhelp.text", "note": "frvbX", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2173, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/45493583/?format=api", "priority": 100, "id": 45493859, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=23378dbb9d3c7c02", "url": "https://translations.documentfoundation.org/api/units/45493859/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-19T17:53:36.758961Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<input>=HYPERLINK(\"http://www.example.org\";\"Click here\")</input> displays the text \"Click here\" in the cell and executes the hyperlink http://www.example.org when clicked." ], "previous_source": "", "target": [ "" ], "id_hash": 1277222501774768595, "content_hash": 1277222501774768595, "location": "04060109.xhp", "context": "04060109.xhp\npar_idN1182A\nhelp.text", "note": "wHG7A", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2174, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 17, "source_unit": "https://translations.documentfoundation.org/api/units/45493584/?format=api", "priority": 100, "id": 45493860, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=91b99b192d6bb9d3", "url": "https://translations.documentfoundation.org/api/units/45493860/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-19T17:53:36.760538Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<input>=HYPERLINK(\"http://www.example.org\";12345)</input> displays the number 12345 and executes the hyperlink http://www.example.org when clicked." ], "previous_source": "", "target": [ "" ], "id_hash": -2085945883601083680, "content_hash": -2085945883601083680, "location": "04060109.xhp", "context": "04060109.xhp\npar_id0907200912224534\nhelp.text", "note": "jamR2", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2175, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/45493585/?format=api", "priority": 100, "id": 45493861, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=630d3b454b44e2e0", "url": "https://translations.documentfoundation.org/api/units/45493861/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-19T17:53:36.761833Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<input>=HYPERLINK($B4)</input> where cell B4 contains <literal>http://www.example.org</literal>. The function adds http://www.example.org to the URL of the hyperlink cell and returns the same text which is used as formula result." ], "previous_source": "", "target": [ "" ], "id_hash": -45593686545329457, "content_hash": -45593686545329457, "location": "04060109.xhp", "context": "04060109.xhp\npar_idN1182D\nhelp.text", "note": "qLdBN", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2176, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 28, "source_unit": "https://translations.documentfoundation.org/api/units/45493586/?format=api", "priority": 100, "id": 45493862, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=7f5e04c89d7712cf", "url": "https://translations.documentfoundation.org/api/units/45493862/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-19T17:53:36.763065Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<input>=HYPERLINK(\"http://www.\";\"Click \") & \"example.org\"</input> displays the text Click example.org in the cell and executes the hyperlink http://www.example.org when clicked." ], "previous_source": "", "target": [ "" ], "id_hash": 2830691007777424645, "content_hash": 2830691007777424645, "location": "04060109.xhp", "context": "04060109.xhp\npar_idN11830\nhelp.text", "note": "cWDrv", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2177, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/45493587/?format=api", "priority": 100, "id": 45493863, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=a748a27953774505", "url": "https://translations.documentfoundation.org/api/units/45493863/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-19T17:53:36.764522Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<input>=HYPERLINK(\"#Sheet1.A1\";\"Go to top\")</input> displays the text Go to top and jumps to cell Sheet1.A1 in this document." ], "previous_source": "", "target": [ "" ], "id_hash": 1869041006723579226, "content_hash": 1869041006723579226, "location": "04060109.xhp", "context": "04060109.xhp\npar_id8859523\nhelp.text", "note": "DDEtK", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2178, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 17, "source_unit": "https://translations.documentfoundation.org/api/units/45493588/?format=api", "priority": 100, "id": 45493864, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=99f02ae49c65bd5a", "url": "https://translations.documentfoundation.org/api/units/45493864/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-19T17:53:36.766159Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<input>=HYPERLINK(\"file:///C:/writer.odt#Specification\";\"Go to Writer bookmark\")</input> displays the text \"Go to Writer bookmark\", loads the specified text document and jumps to bookmark \"Specification\"." ], "previous_source": "", "target": [ "" ], "id_hash": 2843765593580861418, "content_hash": 2843765593580861418, "location": "04060109.xhp", "context": "04060109.xhp\npar_id2958769\nhelp.text", "note": "CoMEq", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2179, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://translations.documentfoundation.org/api/units/45493589/?format=api", "priority": 100, "id": 45493865, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=a77715bd8ddd77ea", "url": "https://translations.documentfoundation.org/api/units/45493865/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-19T17:53:36.767840Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<input>=HYPERLINK(\"file:///C:/Documents/\";\"Open Documents folder\")</input> displays the text \"Open Documents folder\" and shows the folder contents using the standard file manager in your operating system." ], "previous_source": "", "target": [ "" ], "id_hash": 1287100061349521092, "content_hash": 1287100061349521092, "location": "04060109.xhp", "context": "04060109.xhp\npar_id321615667588042\nhelp.text", "note": "Ky2xV", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2180, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 23, "source_unit": "https://translations.documentfoundation.org/api/units/45493590/?format=api", "priority": 100, "id": 45493866, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=91dcb2afbb1f26c4", "url": "https://translations.documentfoundation.org/api/units/45493866/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-19T17:53:36.769328Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?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": 7764, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 22, "source_unit": "https://translations.documentfoundation.org/api/units/45512082/?format=api", "priority": 100, "id": 45512114, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=80425551fb06afe7", "url": "https://translations.documentfoundation.org/api/units/45512114/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-23T11:41:11.653716Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?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": 7765, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://translations.documentfoundation.org/api/units/45512083/?format=api", "priority": 100, "id": 45512115, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=05d365f9f3d6a385", "url": "https://translations.documentfoundation.org/api/units/45512115/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-23T11:41:11.655319Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<bookmark_value>Function Wizard; databases</bookmark_value> <bookmark_value>functions; database functions</bookmark_value> <bookmark_value>databases; functions in $[officename] Calc</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": -4675263538054526505, "content_hash": -4675263538054526505, "location": "04060101.xhp", "context": "04060101.xhp\nbm_id3148946\nhelp.text", "note": "ASfzE", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 479, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/45527418/?format=api", "priority": 100, "id": 45529902, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=3f1e20952eec89d7", "url": "https://translations.documentfoundation.org/api/units/45529902/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:38:51.290237Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "Overview" ], "previous_source": "", "target": [ "" ], "id_hash": -1957506965020947932, "content_hash": -1957506965020947932, "location": "04060101.xhp", "context": "04060101.xhp\nhd_id721616440441374\nhelp.text", "note": "v9KEM", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 481, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/45527419/?format=api", "priority": 100, "id": 45529903, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=64d589c96092ca24", "url": "https://translations.documentfoundation.org/api/units/45529903/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:38:51.388664Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<variable id=\"datenbanktext\">The twelve functions in the Database category help you to analyze a simple database that occupies a rectangular spreadsheet area comprising columns and rows, with the data organized as one row for each record.</variable> The header cell of each column displays the name of the column and that name usually reflects the contents of each cell in that column." ], "previous_source": "", "target": [ "" ], "id_hash": 7858397836453741158, "content_hash": 7858397836453741158, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3145173\nhelp.text", "note": "RGkxy", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 482, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 60, "source_unit": "https://translations.documentfoundation.org/api/units/45527420/?format=api", "priority": 100, "id": 45529904, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=ed0ea33259860266", "url": "https://translations.documentfoundation.org/api/units/45529904/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:38:51.390547Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "The functions in the Database category take three arguments as follows:" ], "previous_source": "", "target": [ "" ], "id_hash": -3153047564112727307, "content_hash": -3153047564112727307, "location": "04060101.xhp", "context": "04060101.xhp\npar_id631615842419413\nhelp.text", "note": "8NQZ9", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 483, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/45527421/?format=api", "priority": 100, "id": 45529905, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=543e1ff22d2672f5", "url": "https://translations.documentfoundation.org/api/units/45529905/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:38:51.392606Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<emph>Database</emph>. The cell range of the database." ], "previous_source": "", "target": [ "" ], "id_hash": -277843361464821272, "content_hash": -277843361464821272, "location": "04060101.xhp", "context": "04060101.xhp\npar_id761615842549780\nhelp.text", "note": "pmE4Y", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 484, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/45527422/?format=api", "priority": 100, "id": 45529906, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=7c24e6ef50b059e8", "url": "https://translations.documentfoundation.org/api/units/45529906/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:38:51.394410Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<emph>DatabaseField</emph>. The column containing the data to be used in the function’s calculations." ], "previous_source": "", "target": [ "" ], "id_hash": 7732379606245571435, "content_hash": 7732379606245571435, "location": "04060101.xhp", "context": "04060101.xhp\npar_id601615842657372\nhelp.text", "note": "nw3ya", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 485, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/45527423/?format=api", "priority": 100, "id": 45529907, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=eb4eee48b2bdfb6b", "url": "https://translations.documentfoundation.org/api/units/45529907/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:38:51.396041Z" } ] }{ "count": 8628, "next": "