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=34
{ "count": 8628, "next": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/units/?format=api&page=35", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/units/?format=api&page=33", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<emph>SearchVector</emph> is the single-row or single-column area to be searched." ], "previous_source": "", "target": [ "<emph>འཚོལ་ཞིབ་མཉམ་ཐིག་</emph>འདི་ འཚོལ་ཞིབ་འབད་དགོ་པའི་ གྲལ་ཐིག་རྐྱང་པ་ཡང་ན་ ཀེར་ཐིག་རྐྱང་པ་འདི་ཨིན།" ], "id_hash": 5289312777227322, "content_hash": 5289312777227322, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3154854\nhelp.text", "note": "tFDBC", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2118, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/24942720/?format=api", "priority": 100, "id": 1469364, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=8012ca9a19314c3a", "url": "https://translations.documentfoundation.org/api/units/1469364/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.840361Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<emph>ResultVector</emph> is another single-row or single-column range from which the result of the function is taken. The result is the cell of the result vector with the same index as the instance found in the search vector." ], "previous_source": "", "target": [ "<emph>result_vector</emph> དེ་ ལས་འགན་གྱི་གྲུབ་འབྲས་འབག་ཡོད་པའི་ གྲལ་ཐིག་རྐྱང་པའམ་ ཀེར་ཐིག་རྐྱང་པ་ཁྱབ་ཚད་གཞན་མི་ཨིན། གྲུབ་འབྲས་དེ་ དཔེར་ན་འཚོལ་ཞིབ་མཉམ་ཐིག་ནང་ཐོབ་མི་བཟུམ་སྦེ་ ཟུར་ཐོ་གཅིག་པ་དང་བཅས་པའི་གྲུབ་འབྲས་མཉམ་ཐིག་གི་ནང་ཐིག་ཨིན།" ], "id_hash": -3957940721512948347, "content_hash": -3957940721512948347, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3149925\nhelp.text", "note": "zdXML", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2119, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 37, "source_unit": "https://translations.documentfoundation.org/api/units/24942721/?format=api", "priority": 100, "id": 1469365, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=491291e2442add85", "url": "https://translations.documentfoundation.org/api/units/1469365/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.855544Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<item type=\"input\">=LOOKUP(A1;D1:D100;F1:F100)</item> searches the corresponding cell in range D1:D100 for the number you entered in A1. For the instance found, the index is determined, for example, the 12th cell in this range. Then, the contents of the 12th cell are returned as the value of the function (in the result vector)." ], "previous_source": "", "target": [ "=LOOKUP(A1; D1:D100;F1:F100) གིས་ ཁྱོད་ཀྱིས་ A1 ནང་ བཙུགས་ཡོད་པའི་ཨང་གྲངས་དོན་ལུ་ ཁྱབ་ཚད་ D1:D100 ནང་མཚུངས་པའི་ནང་ཐིག་འཚོལ་ཞིབ་འབདཝ་ཨིན། དཔེ་འབད་བ་ཅིན་ ཐོབ་ཡོད་པའི་དོན་ལུ་ ཟུར་ཐོ་དེ་གཏན་འབེབས་བཟོ་ཡོདཔ་ཨིན། དཔེ་འབད་བ་ཅིན་ འ་ནི་ཁྱབ་ཚད་ནང་ ནང་ཐིག་བཅུ་གཉིས་པ། དེ་ལས་ ནང་ཐིག་བཅུ་གཉིས་པའི་ནང་དོན་ཚུ་ ལས་འགན་གྱི་གནས་གོང་སྦེ་སླར་ལོག་འབད་ཡོདཔ་ཨིན་(གྲུབ་འབྲས་མཉམ་ཐིག་ནང་)།" ], "id_hash": -4343587908196936134, "content_hash": -4343587908196936134, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3149809\nhelp.text", "note": "36TJv", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2120, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 51, "source_unit": "https://translations.documentfoundation.org/api/units/24942722/?format=api", "priority": 100, "id": 1469366, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=43b879cf913d563a", "url": "https://translations.documentfoundation.org/api/units/1469366/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.866611Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<bookmark_value>CHOOSE function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>CHOOSE ལས་འགན།</bookmark_value>" ], "id_hash": -1246532646027441510, "content_hash": -1246532646027441510, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id3150430\nhelp.text", "note": "XYxM4", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2121, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24942734/?format=api", "priority": 100, "id": 1469378, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=6eb36d29b09b4a9a", "url": "https://translations.documentfoundation.org/api/units/1469378/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.013473Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "CHOOSE" ], "previous_source": "", "target": [ "CHOOSE" ], "id_hash": 7614291423126201432, "content_hash": 7614291423126201432, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3150430\nhelp.text", "note": "eygie", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2122, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24942735/?format=api", "priority": 100, "id": 1469379, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=e9ab65b503bda458", "url": "https://translations.documentfoundation.org/api/units/1469379/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.024165Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_WAHL\">Uses an index to return a value from a list of up to 30 values.</ahelp>" ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_WAHL\"> གནས་གོང་ ༣༠ ཚུན་ གྱི་ ཐོ་ཡིག་ལས་ གནས་གོང་གཅིག་སླར་ལོག་འབད་ནིའི་དོན་ལུ་ ཟུར་ཐོ་གཅིག་ལག་ལེན་འཐབ་ཨིན། </ahelp>" ], "id_hash": 5000394310678462495, "content_hash": 5000394310678462495, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3143270\nhelp.text", "note": "ynNz9", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2123, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/24942736/?format=api", "priority": 100, "id": 1469380, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=c564f821e0dfc01f", "url": "https://translations.documentfoundation.org/api/units/1469380/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.037404Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<item type=\"input\">=CHOOSE(A1;B1;B2;B3;\"Today\";\"Yesterday\";\"Tomorrow\")</item>, for example, returns the contents of cell B2 for A1 = 2; for A1 = 4, the function returns the text \"Today\"." ], "previous_source": "", "target": [ "=CHOOSE(A1; B1; B2; B3; \"Today\"; \"Yesterday\"; \"Tomorrow\") གིས་ དཔེ་འབད་བ་ཅིན་ A1 = ༢ དོན་ལུ་ ནང་ཐིག་ B2 གི་ནང་དོན་ཚུ་སླར་ལོག་འབདཝ་ཨིན་ A1 = ༤ དོན་ལུ་ ལས་འགན་གྱིས་ \"Today\" ཚིག་ཡིག་སླར་ལོག་འབདཝ་ཨིན།" ], "id_hash": 1169713915901438249, "content_hash": 1169713915901438249, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3150625\nhelp.text", "note": "s64Du", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2127, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 24, "source_unit": "https://translations.documentfoundation.org/api/units/24942740/?format=api", "priority": 100, "id": 1469384, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=903ba89bee22e929", "url": "https://translations.documentfoundation.org/api/units/1469384/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.080730Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<bookmark_value>HLOOKUP function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>HLOOKUP ལས་འགན།</bookmark_value>" ], "id_hash": 837705466221852232, "content_hash": 837705466221852232, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id3151001\nhelp.text", "note": "pyC7b", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2128, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24942741/?format=api", "priority": 100, "id": 1469385, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=8ba020aee48e7648", "url": "https://translations.documentfoundation.org/api/units/1469385/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.093116Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "HLOOKUP" ], "previous_source": "", "target": [ "HLOOKUP" ], "id_hash": 1011049703423366766, "content_hash": 1011049703423366766, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3151001\nhelp.text", "note": "LPUU2", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2129, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24942742/?format=api", "priority": 100, "id": 1469386, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=8e07f85936d0566e", "url": "https://translations.documentfoundation.org/api/units/1469386/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.105526Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_WVERWEIS\">Searches for a value and reference to the cells below the selected area.</ahelp> This function verifies if the first row of an array contains a certain value. The function returns then the value in a row of the array, named in the <emph>Index</emph>, in the same column." ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_WVERWEIS\"> སེལ་འཐུ་གྲུབ་ཡོད་པའི་མངའ་ཁོངས་ཀྱི་འོག་གི་ནང་ཐིག་ཚུའི་དོན་ལུ་ གནས་གོང་དང་གཞི་བསྟུན་འཚོལ་ཞིབ་འབདཝ་ཨིན། </ahelp> འ་ནི་ལས་འགན་གྱིས་ ཨེ་རེ་གི་གྲལ་ཐིག་དང་པམ་ནང་ན་གན་གོང་ལ་ལོ་ཤོམ་ཏེ་ཡོད་མེད་བདེན་སྦྱོར་འབདཝ་ཨིན། ལས་འགན་གྱིས་ ཀེར་ཐིག་གཅིག་པ་ནང་ <emph> ཟུར་ཐོ་ </emph> ནང་ལུ་ མིང་བཏགས་ཡོད་པའི་ཨེ་རེ་གི་གྲལ་ཐིག་ནང་གནས་གོང་སླར་ལོག་འབདཝ་ཨིན།" ], "id_hash": 8452625132990922436, "content_hash": 8452625132990922436, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3148688\nhelp.text", "note": "XtZrs", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2130, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 48, "source_unit": "https://translations.documentfoundation.org/api/units/24942743/?format=api", "priority": 100, "id": 1469387, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=f54dc1c647767ec4", "url": "https://translations.documentfoundation.org/api/units/1469387/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.116820Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<bookmark_value>ROW function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>ROW ལས་འགན།</bookmark_value>" ], "id_hash": -2361118716865256180, "content_hash": -2361118716865256180, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id3147321\nhelp.text", "note": "B4DL3", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2145, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24942744/?format=api", "priority": 100, "id": 1469390, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=5f3b9f0968b8650c", "url": "https://translations.documentfoundation.org/api/units/1469390/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.173325Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "ROW" ], "previous_source": "", "target": [ "གྲལ་ཐིག" ], "id_hash": -345179335225695980, "content_hash": -345179335225695980, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3147321\nhelp.text", "note": "Dk854", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2146, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24942745/?format=api", "priority": 100, "id": 1469391, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=7b35ad3934112114", "url": "https://translations.documentfoundation.org/api/units/1469391/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.190400Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<emph>Reference</emph> is a cell, an area, or the name of an area." ], "previous_source": "", "target": [ "<emph> གཞི་བསྟུན་དེ་ </emph> ནང་ཐིག་ མངའ་ཁོངས་ ཡང་ན་ མངའ་ཁོངས་ཀྱི་མིང་ཨིན།" ], "id_hash": 5194788869710857183, "content_hash": 5194788869710857183, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3156336\nhelp.text", "note": "mSqrb", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2149, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/24942748/?format=api", "priority": 100, "id": 1469394, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=c81798f42e44c3df", "url": "https://translations.documentfoundation.org/api/units/1469394/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.227668Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "If you do not indicate a reference, the row number of the cell in which the formula is entered will be found. <item type=\"productname\">%PRODUCTNAME</item> Calc automatically sets the reference to the current cell." ], "previous_source": "", "target": [ "ཁྱོད་ཀྱིས་ གཞི་བསྟུན་བརྡ་མ་སྟོན་པ་ཅིན་ མན་ངག་བཙུགས་ཡོད་པའི་ནང་ཐིག་གི་གྲལ་ཐིག་གྱངས་ཁ་དེ་འཐོབ་ནི་ཨིན། <item type=\"productname\">%PRODUCTNAME</item> ཀེལ་སི་གིས་ ད་ལྟོའི་ནང་ཐིག་ལུ་ རང་བཞིན་གྱིས་ གཞི་བསྟུན་གཅིག་གཞི་སྒྲིག་འབདཝ་ཨིན།" ], "id_hash": 3720755741605929069, "content_hash": 3720755741605929069, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3151109\nhelp.text", "note": "eUXYG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2150, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 33, "source_unit": "https://translations.documentfoundation.org/api/units/24942749/?format=api", "priority": 100, "id": 1469395, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=b3a2c7a2326aa06d", "url": "https://translations.documentfoundation.org/api/units/1469395/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.237996Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<item type=\"input\">=ROW(B3)</item> returns 3 because the reference refers to the third row in the table." ], "previous_source": "", "target": [ "=ROW(B3) གིས་ ༣ སླར་ལོག་འབདཝ་ཨིན་ ག་ཅི་སྦེ་ཟེར་བ་ཅིན་ གཞི་བསྟུན་གྱིས་ ཐིག་ཁྲམ་ནང་གི་གྲལ་ཐིག་གསུམ་པམ་ལུ་ གཞི་བསྟུན་འབདཝ་ཨིན།" ], "id_hash": -2177386009179408488, "content_hash": -2177386009179408488, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3154830\nhelp.text", "note": "GwuVx", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2151, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/24942750/?format=api", "priority": 100, "id": 1469396, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=61c85ef5fff4b798", "url": "https://translations.documentfoundation.org/api/units/1469396/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.253636Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<item type=\"input\">{=ROW(D5:D8)}</item> returns the single-column array (5, 6, 7, 8) because the reference specified contains rows 5 through 8." ], "previous_source": "", "target": [ "{=ROW(D5:D8)} གིས་ ཀེར་ཐིག་ཨེ་རེ་རྐྱང་པ་ སླར་ལོག་འབདཝ་ཨིན་ ག་ཅི་སྦེ་ཟེར་བ་ཅིན་ (༥ ༦ ༧ ༨) གསལ་བཀོད་འབད་ཡོད་པའི་གཞི་བསྟུན་ནང་ན་ ༨ བརྒྱུད་དེ་ གྲལ་ཐིག་ ༥་ཚུ་ཤོམ་ཏེ་ཡོདཔ་ཨིན།(-c)" ], "id_hash": -2042965818137793533, "content_hash": -2042965818137793533, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3147094\nhelp.text", "note": "FDCdZ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2152, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/24942751/?format=api", "priority": 100, "id": 1469397, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=63a5ed6999a1ac03", "url": "https://translations.documentfoundation.org/api/units/1469397/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.265534Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<item type=\"input\">=ROW(D5:D8)</item> returns 5 because the ROW function is not used as array formula and only the number of the first row of the reference is returned." ], "previous_source": "", "target": [ "=ROW(D5:D8) གིས་ ༥ སླར་ལོག་འབདཝ་ཨིན་ ག་ཅི་སྦེ་ཟེར་་ཅིན་ ROW ལས་འགན་དེ་ཨེ་རེ་མན་ངག་སྦེ་ལག་ལེན་འཐབ་མེདཔ་ད་ གཞི་བསྟུན་གྱི་གྲལ་ཐིག་དང་པའི་ཨང་གྲངས་རྐྱངམ་ཅིག་སླར་ལོག་འབད་ཡོདཔ་ཨིན།" ], "id_hash": -3337638330205888383, "content_hash": -3337638330205888383, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3153701\nhelp.text", "note": "CWNY7", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2153, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 27, "source_unit": "https://translations.documentfoundation.org/api/units/24942752/?format=api", "priority": 100, "id": 1469398, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=51ae539f4b59a081", "url": "https://translations.documentfoundation.org/api/units/1469398/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.275366Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<item type=\"input\">{=ROW(A1:E1)}</item> and <item type=\"input\">=ROW(A1:E1)</item> both return 1 because the reference only contains row 1 as the first row in the table. (Because single-row areas only have one row number it does not make any difference whether or not the formula is used as an array formula.)" ], "previous_source": "", "target": [ "{=ROW(A1:E1)} དང་ =ROW(A1:E1) གཉིས་ཆ་ར་གིས་ ༡ སླར་ལོག་འབདཝ་ཨིན་ ག་ཅི་སྦེ་ཟེར་བ་ཅིན་ གཞི་བསྟུན་ནང་ན་ ཐིག་ཁྲམ་ནང་གི་ཀེར་ཐིག་དང་པ་སྦེ་གྲལ་ཐིག་ ༡ རྐྱངམ་ཅིག་ཤོམ་ཏེ་ཡོདཔ་ཨིན། (ག་ཅི་སྦེ་ཟེར་བ་ཅིན་ གྲལ་ཐིག་མངའ་ཁོངས་རྐྱང་པ་ལུ་གྲལ་ཐིག་གྱངས་ཁ་གཅིག་རྐྱངམ་ཅིག་ཡོདཔ་ལས་ དེ་གིས་ མན་ངག་དེ་ ཨེ་རེ་མན་ངག་སྦེ་ལག་ལེན་འཐབ་སྟེ་ཡོད་རུང་མེད་རུང་ཁྱད་པར་ག་ནི་ཡང་མི་བཟོ་ནི་ཨིན།)(-r)" ], "id_hash": -2173364650780142435, "content_hash": -2173364650780142435, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3150996\nhelp.text", "note": "LpXFL", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2154, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 47, "source_unit": "https://translations.documentfoundation.org/api/units/24942753/?format=api", "priority": 100, "id": 1469399, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=61d6a85d76dbd49d", "url": "https://translations.documentfoundation.org/api/units/1469399/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.285368Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<item type=\"input\">=ROW()</item> returns 3 if the formula was entered in row 3." ], "previous_source": "", "target": [ "" ], "id_hash": -1963376887368523013, "content_hash": -1963376887368523013, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3153671\nhelp.text", "note": "ABQhH", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2155, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/24942754/?format=api", "priority": 100, "id": 1469400, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=64c0af1f942fe2fb", "url": "https://translations.documentfoundation.org/api/units/1469400/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.297092Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<item type=\"input\">{=ROW(Rabbit)}</item> returns the single-column array (1, 2, 3) if \"Rabbit\" is the named area (C1:D3)." ], "previous_source": "", "target": [ "{=ROW(Rabbit)} གིས་ (༡ ༢ ༣) \"Rabbit\" དེ་མིང་བཏགས་ཡོད་པའི་མངའ་ཁོངས་ཨིན་པ་ཅིན་ ཀེར་ཐིག་ཨེ་རེ་རྐྱང་པ་སླར་ལོག་འབདཝ་ཨིན། (C1:D3) (-c)" ], "id_hash": 3342202309377560900, "content_hash": 3342202309377560900, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3153790\nhelp.text", "note": "d8Kuj", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2156, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/24942755/?format=api", "priority": 100, "id": 1469401, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=ae61e34ae9f09144", "url": "https://translations.documentfoundation.org/api/units/1469401/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.308086Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<bookmark_value>ROWS function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>ROWS ལས་འགན།</bookmark_value>" ], "id_hash": 3782444169566703013, "content_hash": 3782444169566703013, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id3145772\nhelp.text", "note": "RF4C9", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2157, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24942756/?format=api", "priority": 100, "id": 1469402, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=b47df0ee95c54da5", "url": "https://translations.documentfoundation.org/api/units/1469402/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.320824Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "ROWS" ], "previous_source": "", "target": [ "ROWS" ], "id_hash": 1939762464644556811, "content_hash": 1939762464644556811, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3145772\nhelp.text", "note": "EURAZ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2158, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24942757/?format=api", "priority": 100, "id": 1469403, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=9aeb6baf2dc6680b", "url": "https://translations.documentfoundation.org/api/units/1469403/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.329124Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_ZEILEN\">Returns the number of rows in a reference or array.</ahelp>" ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_ZEILEN\"> གཞི་བསྟུན་ཡང་ན་ ཨེ་རེ་ནང་ གྲལ་ཐིག་ཚུའི་གྱངས་ཁ་སླར་ལོག་འབདཝ་ཨིན། </ahelp>" ], "id_hash": 1978530240890796127, "content_hash": 1978530240890796127, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3148971\nhelp.text", "note": "wniFN", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2159, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/24942758/?format=api", "priority": 100, "id": 1469404, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=9b7526c579a9f85f", "url": "https://translations.documentfoundation.org/api/units/1469404/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.342193Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "ROWS(Array)" ], "previous_source": "", "target": [ "ROWS(ཨེ་རེ།)" ], "id_hash": 4290910996493570120, "content_hash": 4290910996493570120, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3154357\nhelp.text", "note": "UHLW7", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2160, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24942759/?format=api", "priority": 100, "id": 1469405, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=bb8c60d12cd11048", "url": "https://translations.documentfoundation.org/api/units/1469405/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.355404Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<emph>Array</emph> is the reference or named area whose total number of rows is to be determined." ], "previous_source": "", "target": [ "<emph>ཨེ་རེ་</emph> འདི་ གྲལ་ཐིག་ཚུ་གི་ཨང་གྲངས་འདི་གཏན་འབེབས་བཟོ་ནི་ཨིན་པའི་ མིང་གི་ས་ཁོངས་ཡང་ན་ གཞི་བསྟུན་འདི་ཨིན།" ], "id_hash": -8166631567841135854, "content_hash": -8166631567841135854, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3155942\nhelp.text", "note": "SDyoR", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2161, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/24942760/?format=api", "priority": 100, "id": 1469406, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=0eaa4bdb93567312", "url": "https://translations.documentfoundation.org/api/units/1469406/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.366609Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<item type=\"input\">=Rows(B5)</item> returns 1 because a cell only contains one row." ], "previous_source": "", "target": [ "" ], "id_hash": 3179259141443047493, "content_hash": 3179259141443047493, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3154725\nhelp.text", "note": "vLpxF", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2162, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/24942761/?format=api", "priority": 100, "id": 1469407, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=ac1eff583ea05045", "url": "https://translations.documentfoundation.org/api/units/1469407/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.379730Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<item type=\"input\">=ROWS(A10:B12)</item> returns 3." ], "previous_source": "", "target": [ "" ], "id_hash": 8726325246435246997, "content_hash": 8726325246435246997, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3150102\nhelp.text", "note": "j27bq", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2163, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/24942762/?format=api", "priority": 100, "id": 1469408, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=f91a2293dc4bc395", "url": "https://translations.documentfoundation.org/api/units/1469408/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.390867Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<item type=\"input\">=ROWS(Rabbit)</item> returns 3 if \"Rabbit\" is the named area (C1:D3)." ], "previous_source": "", "target": [ "" ], "id_hash": -1013333620181692939, "content_hash": -1013333620181692939, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3155143\nhelp.text", "note": "4AmXS", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2164, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/24942763/?format=api", "priority": 100, "id": 1469409, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=71efea70fa1c0df5", "url": "https://translations.documentfoundation.org/api/units/1469409/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.405454Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<bookmark_value>HYPERLINK function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>HYPERLINK ལས་འགན།</bookmark_value>" ], "id_hash": 2418601881341008658, "content_hash": 2418601881341008658, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id9959410\nhelp.text", "note": "Wncoz", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2165, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24942764/?format=api", "priority": 100, "id": 1469410, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=a1909998c66c1b12", "url": "https://translations.documentfoundation.org/api/units/1469410/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.423025Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "HYPERLINK" ], "previous_source": "", "target": [ "HYPERLINK" ], "id_hash": -772613790251597624, "content_hash": -772613790251597624, "location": "04060109.xhp", "context": "04060109.xhp\npar_idN11798\nhelp.text", "note": "CDw2x", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2166, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24942765/?format=api", "priority": 100, "id": 1469411, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=75471fd9eb7c40c8", "url": "https://translations.documentfoundation.org/api/units/1469411/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.438751Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_HYPERLINK\">When you click a cell that contains the HYPERLINK function, the hyperlink opens.</ahelp>" ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_HYPERLINK\">ཧའི་པར་ལིངཀི་ལས་འགན་གནས་དེ་ཡོད་པའི་ ནང་ཐིག་འདི་གུ་ཁྱོད་ཀྱྀས་ཨེབ་གཏང་འབདཝ་ད་ ཧའི་པར་ལིངཀི་འདི་ཁ་ཕྱེཝ་ཨིན།</ahelp>" ], "id_hash": 4534164272395009121, "content_hash": 4534164272395009121, "location": "04060109.xhp", "context": "04060109.xhp\npar_idN117F1\nhelp.text", "note": "GAJeF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2167, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/24942766/?format=api", "priority": 100, "id": 1469412, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=beec9661f95f3c61", "url": "https://translations.documentfoundation.org/api/units/1469412/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.453791Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "To open a hyperlinked cell with the keyboard, select the cell, press F2 to enter the Edit mode, move the cursor in front of the hyperlink, press Shift+F10, and then choose <emph>Open Hyperlink</emph>." ], "previous_source": "", "target": [ "ལྡེ་སྒྲོམ་དང་གཅིག་ཁར་ཚད་བརྒལ་འབྲེལ་མཐུད་འབད་ཡོད་པའི་ནང་ཐིག་ཁ་ཕྱེ་ནིའི་དོན་ལུ་ ནང་ཐིག་སེལ་འཐུ་འབད་ ཞུན་དག་ཐབས་ལམ་བཙུགས་ནིའི་དོན་ལུ་ F2 ཨེབ་ ཚད་བརྒལ་འབྲེལ་མཐུད་ཀྱི་གདོང་ཁར་འོག་རྟགས་སྤོ་ སོར་ལྡེ་+F10 ཨེབ་བཞིནམ་ལས་ <emph> ཚད་བརྒལ་འབྲེལ་མཐུད་ཁ་ཕྱེ་ </emph> གདམ།" ], "id_hash": 6220766120926062383, "content_hash": 6220766120926062383, "location": "04060109.xhp", "context": "04060109.xhp\npar_idN11803\nhelp.text", "note": "7DGBz", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2169, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 33, "source_unit": "https://translations.documentfoundation.org/api/units/24942768/?format=api", "priority": 100, "id": 1469414, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=d65499d3f495272f", "url": "https://translations.documentfoundation.org/api/units/1469414/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.480038Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "The number 0 is returned for empty cells and matrix elements." ], "previous_source": "", "target": [ "" ], "id_hash": 9183508396406512454, "content_hash": 9183508396406512454, "location": "04060109.xhp", "context": "04060109.xhp\npar_id0907200912224576\nhelp.text", "note": "GdBa8", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2172, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/24942771/?format=api", "priority": 100, "id": 1469417, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=ff72603aefa09b46", "url": "https://translations.documentfoundation.org/api/units/1469417/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.538613Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<bookmark_value>GETPIVOTDATA function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>EDATE ལས་འགན།</bookmark_value>" ], "id_hash": -946151325930625045, "content_hash": -946151325930625045, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id7682424\nhelp.text", "note": "ubKsF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2182, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24942778/?format=api", "priority": 100, "id": 1469425, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=72de9861ca23e7eb", "url": "https://translations.documentfoundation.org/api/units/1469425/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.659546Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "GETPIVOTDATA" ], "previous_source": "", "target": [ "" ], "id_hash": 5240299382109462377, "content_hash": 5240299382109462377, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3747062\nhelp.text", "note": "3ndfJ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2183, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24942779/?format=api", "priority": 100, "id": 1469426, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=c8b9488613555f69", "url": "https://translations.documentfoundation.org/api/units/1469426/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.676571Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<ahelp hid=\".\">The GETPIVOTDATA function returns a result value from a pivot table. The value is addressed using field and item names, so it remains valid if the layout of the pivot table changes.</ahelp>" ], "previous_source": "", "target": [ "" ], "id_hash": 5187296786357012091, "content_hash": 5187296786357012091, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3593859\nhelp.text", "note": "MoLqJ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2184, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 33, "source_unit": "https://translations.documentfoundation.org/api/units/24942780/?format=api", "priority": 100, "id": 1469427, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=c7fcfaf19755c67b", "url": "https://translations.documentfoundation.org/api/units/1469427/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.693688Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "Two different syntax definitions can be used:" ], "previous_source": "", "target": [ "" ], "id_hash": -6279826677705307235, "content_hash": -6279826677705307235, "location": "04060109.xhp", "context": "04060109.xhp\npar_id909451\nhelp.text", "note": "k6kQB", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2185, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/24942781/?format=api", "priority": 100, "id": 1469429, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=28d992e8985a8b9d", "url": "https://translations.documentfoundation.org/api/units/1469429/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.706780Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "GETPIVOTDATA(pivot table; Constraints)" ], "previous_source": "", "target": [ "" ], "id_hash": -611817698728201602, "content_hash": -611817698728201602, "location": "04060109.xhp", "context": "04060109.xhp\npar_id4997100\nhelp.text", "note": "QnCVY", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2188, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/24942783/?format=api", "priority": 100, "id": 1469431, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=7782630b6802327e", "url": "https://translations.documentfoundation.org/api/units/1469431/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.733744Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "The second syntax is assumed if exactly two parameters are given, of which the first parameter is a cell or cell range reference. The first syntax is assumed in all other cases. The Function Wizard shows the first syntax." ], "previous_source": "", "target": [ "" ], "id_hash": 5193858182333926414, "content_hash": 5193858182333926414, "location": "04060109.xhp", "context": "04060109.xhp\npar_id1672109\nhelp.text", "note": "LJFgA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2189, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 39, "source_unit": "https://translations.documentfoundation.org/api/units/24942784/?format=api", "priority": 100, "id": 1469432, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=c8144a7fa3c50c0e", "url": "https://translations.documentfoundation.org/api/units/1469432/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.748873Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<emph>TargetField</emph> is a string that selects one of the pivot table's data fields. The string can be the name of the source column, or the data field name as shown in the table (like \"Sum - Sales\")." ], "previous_source": "", "target": [ "" ], "id_hash": -7239259067986216298, "content_hash": -7239259067986216298, "location": "04060109.xhp", "context": "04060109.xhp\npar_id9302346\nhelp.text", "note": "xTLTZ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2191, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 37, "source_unit": "https://translations.documentfoundation.org/api/units/24942785/?format=api", "priority": 100, "id": 1469433, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=1b88fc3b9fa7fa96", "url": "https://translations.documentfoundation.org/api/units/1469433/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.766516Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<emph>pivot table</emph> is a reference to a cell or cell range that is positioned within a pivot table or contains a pivot table. If the cell range contains several pivot tables, the table that was created last is used." ], "previous_source": "", "target": [ "" ], "id_hash": 4132487332375574583, "content_hash": 4132487332375574583, "location": "04060109.xhp", "context": "04060109.xhp\npar_id8296151\nhelp.text", "note": "yNzcp", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2192, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 39, "source_unit": "https://translations.documentfoundation.org/api/units/24942786/?format=api", "priority": 100, "id": 1469434, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=b9598b557d0c3837", "url": "https://translations.documentfoundation.org/api/units/1469434/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.781176Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "If no <emph>Field n / Item n</emph> pairs are given, the grand total is returned. Otherwise, each pair adds a constraint that the result must satisfy. <emph>Field n</emph> is the name of a field from the pivot table. <emph>Item n</emph> is the name of an item from that field." ], "previous_source": "", "target": [ "" ], "id_hash": -1497535495358537996, "content_hash": -1497535495358537996, "location": "04060109.xhp", "context": "04060109.xhp\npar_id4809411\nhelp.text", "note": "bmrBF", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2193, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 49, "source_unit": "https://translations.documentfoundation.org/api/units/24942787/?format=api", "priority": 100, "id": 1469435, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=6b37af66b89d9ef4", "url": "https://translations.documentfoundation.org/api/units/1469435/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.797219Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "If the pivot table contains only a single result value that fulfills all of the constraints, or a subtotal result that summarizes all matching values, that result is returned. If there is no matching result, or several ones without a subtotal for them, an error is returned. These conditions apply to results that are included in the pivot table." ], "previous_source": "", "target": [ "" ], "id_hash": 2388784086717151413, "content_hash": 2388784086717151413, "location": "04060109.xhp", "context": "04060109.xhp\npar_id6454969\nhelp.text", "note": "swvQC", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2194, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 59, "source_unit": "https://translations.documentfoundation.org/api/units/24942788/?format=api", "priority": 100, "id": 1469436, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=a126aa7875e1b8b5", "url": "https://translations.documentfoundation.org/api/units/1469436/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.812302Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "If the source data contains entries that are hidden by settings of the pivot table, they are ignored. The order of the Field/Item pairs is not significant. Field and item names are not case-sensitive." ], "previous_source": "", "target": [ "" ], "id_hash": -7629710895233941748, "content_hash": -7629710895233941748, "location": "04060109.xhp", "context": "04060109.xhp\npar_id79042\nhelp.text", "note": "vjksc", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2195, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 34, "source_unit": "https://translations.documentfoundation.org/api/units/24942789/?format=api", "priority": 100, "id": 1469437, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=161dd25d5ea73f0c", "url": "https://translations.documentfoundation.org/api/units/1469437/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.831142Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "Subtotal values from the pivot table are only used if they use the function \"auto\" (except when specified in the constraint, see <item type=\"literal\">Second Syntax</item> below)." ], "previous_source": "", "target": [ "" ], "id_hash": -1979321936287154257, "content_hash": -1979321936287154257, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3864253\nhelp.text", "note": "nARMD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2197, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/24942791/?format=api", "priority": 100, "id": 1469439, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=6488092f93773faf", "url": "https://translations.documentfoundation.org/api/units/1469439/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.849857Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<emph>pivot table</emph> has the same meaning as in the first syntax." ], "previous_source": "", "target": [ "<emph>NOM</emph> འདི་སྐྱེད་ཆུང་བ་ཨིན།" ], "id_hash": -4232016537115714080, "content_hash": -4232016537115714080, "location": "04060109.xhp", "context": "04060109.xhp\npar_id9937131\nhelp.text", "note": "KETgR", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2199, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/24942792/?format=api", "priority": 100, "id": 1469440, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=4544db61b5a39de0", "url": "https://translations.documentfoundation.org/api/units/1469440/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.865798Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "<emph>Constraints</emph> is a space-separated list. Entries can be quoted (single quotes). The whole string must be enclosed in quotes (double quotes), unless you reference the string from another cell." ], "previous_source": "", "target": [ "" ], "id_hash": 5115834849937829754, "content_hash": 5115834849937829754, "location": "04060109.xhp", "context": "04060109.xhp\npar_id5616626\nhelp.text", "note": "GUofE", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2200, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/24942793/?format=api", "priority": 100, "id": 1469441, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=c6ff18b0f01baf7a", "url": "https://translations.documentfoundation.org/api/units/1469441/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.881188Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "One of the entries can be the data field name. The data field name can be left out if the pivot table contains only one data field, otherwise it must be present." ], "previous_source": "", "target": [ "" ], "id_hash": 3603286722984903350, "content_hash": 3603286722984903350, "location": "04060109.xhp", "context": "04060109.xhp\npar_id4076357\nhelp.text", "note": "xS3qo", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2201, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 32, "source_unit": "https://translations.documentfoundation.org/api/units/24942794/?format=api", "priority": 100, "id": 1469442, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=b201722efb6582b6", "url": "https://translations.documentfoundation.org/api/units/1469442/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.901121Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "Each of the other entries specifies a constraint in the form <item type=\"literal\">Field[Item]</item> (with literal characters [ and ]), or only <item type=\"literal\">Item</item> if the item name is unique within all fields that are used in the pivot table." ], "previous_source": "", "target": [ "" ], "id_hash": -4546692663667297643, "content_hash": -4546692663667297643, "location": "04060109.xhp", "context": "04060109.xhp\npar_id8231757\nhelp.text", "note": "TFWzU", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2202, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 39, "source_unit": "https://translations.documentfoundation.org/api/units/24942795/?format=api", "priority": 100, "id": 1469443, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=40e6e71c9f3c7295", "url": "https://translations.documentfoundation.org/api/units/1469443/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.913535Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/dz/?format=api", "source": [ "A function name can be added in the form <emph>Field[Item;Function]</emph>, which will cause the constraint to match only subtotal values which use that function. The possible function names are Sum, Count, Average, Max, Min, Product, Count (Numbers only), StDev (Sample), StDevP (Population), Var (Sample), and VarP (Population), case-insensitive." ], "previous_source": "", "target": [ "" ], "id_hash": -4629497150021799111, "content_hash": -4629497150021799111, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3168736\nhelp.text", "note": "Haoyc", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2203, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 48, "source_unit": "https://translations.documentfoundation.org/api/units/24942796/?format=api", "priority": 100, "id": 1469444, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/dz/?checksum=3fc0b8dec4447339", "url": "https://translations.documentfoundation.org/api/units/1469444/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.923672Z" } ] }