Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-master/textscalc01/bo/units/?format=api&page=34
{ "count": 8573, "next": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/units/?format=api&page=35", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/units/?format=api&page=33", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?format=api", "source": [ "LOOKUP" ], "previous_source": "", "target": [ "LOOKUP" ], "id_hash": 8655066154759884947, "content_hash": 8655066154759884947, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3159273\nhelp.text", "note": "MPjM8", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2113, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24942715/?format=api", "priority": 100, "id": 1423694, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=f81cf8cfadf81093", "url": "https://translations.documentfoundation.org/api/units/1423694/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.775888Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?format=api", "source": [ "If LOOKUP cannot find the search criterion, it matches the largest value in the search vector that is less than or equal to the search criterion." ], "previous_source": "", "target": [ "" ], "id_hash": -3061392892454013596, "content_hash": -3061392892454013596, "location": "04060109.xhp", "context": "04060109.xhp\npar_id4484084\nhelp.text", "note": "3jevg", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2115, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/24942717/?format=api", "priority": 100, "id": 1423696, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=5583bf625f5f7564", "url": "https://translations.documentfoundation.org/api/units/1423696/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:09.802943Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/bo/?format=api", "source": [ "<emph>SearchVector</emph> is the single-row or single-column area to be searched." ], "previous_source": "", "target": [ "<emph>lookup_vector</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": 1423699, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=8012ca9a19314c3a", "url": "https://translations.documentfoundation.org/api/units/1423699/?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/bo/?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": 1423700, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=491291e2442add85", "url": "https://translations.documentfoundation.org/api/units/1423700/?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/bo/?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": 1423701, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=43b879cf913d563a", "url": "https://translations.documentfoundation.org/api/units/1423701/?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/bo/?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": 1423713, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=6eb36d29b09b4a9a", "url": "https://translations.documentfoundation.org/api/units/1423713/?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/bo/?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": 1423714, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=e9ab65b503bda458", "url": "https://translations.documentfoundation.org/api/units/1423714/?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/bo/?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\">བཤེར་འདྲེན་སྤྱད་ནས་གྲངས་ཐང་ 30 ལྷག་ཡོད་པའི་རེའུ་འགོད་ནང་གྲངས་ཐང་ཞིག་ཏུ་ཕྱིར་ལོག་པ།</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": 1423715, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=c564f821e0dfc01f", "url": "https://translations.documentfoundation.org/api/units/1423715/?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/bo/?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 = 2 ཡིན་ན་དྲ་མིག་ B2 གི་ནང་དོན་ལ་ཕྱིར་ལོག་པ་དང་། གལ་སྲིད་ A1 = 4 ཡིན་ན་ཡི་གེ་\"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": 1423719, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=903ba89bee22e929", "url": "https://translations.documentfoundation.org/api/units/1423719/?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/bo/?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": 1423720, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=8ba020aee48e7648", "url": "https://translations.documentfoundation.org/api/units/1423720/?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/bo/?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": 1423721, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=8e07f85936d0566e", "url": "https://translations.documentfoundation.org/api/units/1423721/?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/bo/?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>Index</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": 1423722, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=f54dc1c647767ec4", "url": "https://translations.documentfoundation.org/api/units/1423722/?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/bo/?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": 1423725, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=5f3b9f0968b8650c", "url": "https://translations.documentfoundation.org/api/units/1423725/?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/bo/?format=api", "source": [ "ROW" ], "previous_source": "", "target": [ "ROW" ], "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": 1423726, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=7b35ad3934112114", "url": "https://translations.documentfoundation.org/api/units/1423726/?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/bo/?format=api", "source": [ "<emph>Reference</emph> is a cell, an area, or the name of an area." ], "previous_source": "", "target": [ "<emph>reference</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": 1423729, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=c81798f42e44c3df", "url": "https://translations.documentfoundation.org/api/units/1423729/?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/bo/?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": [ "གལ་སྲིད་འདྲེན་སྤྱོད་ཐང་མེད་ན་$[officename] གློག་རྡུལ་རེའུ་མིག་གིས་སྤྱོ་བགྲོས་གནས་སའི་དྲ་མིག་གི་ཡིག་ཕྲེང་ཨང་རིམ་ཟློག་སྐྱེལ་བྱེད།" ], "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": true, "num_words": 33, "source_unit": "https://translations.documentfoundation.org/api/units/24942749/?format=api", "priority": 100, "id": 1423730, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=b3a2c7a2326aa06d", "url": "https://translations.documentfoundation.org/api/units/1423730/?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/bo/?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) རྩིས་རྒྱག་འབྲས་བུ་ནི་3ཡིན་ རྒྱུ་མཚན་ནི་འདྲེན་སྤྱོད་ཀྱི་དམིགས་ཡུལ་ནི་རེའུ་མིག་དྲ་མིག་གི་ཡིག་ཕྲེང་གསུམ་པ་ཡིན།" ], "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": 1423731, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=61c85ef5fff4b798", "url": "https://translations.documentfoundation.org/api/units/1423731/?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/bo/?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)} རྩིས་རྒྱག་པ་ལས་སྟར་པ་རྐྱང་པའི་ལིང་ཚེ་(5, 6, 7, 8)ཐོབ་ རྒྱུ་མཚན་ནི་ནང་འཇུག་བྱས་པའི་འདྲེན་སྤྱོད་ཐང་ལ་ཨང་རིམ་5ནས་8བར་དྲ་མིག་ཕྲེང་ཚུད་ཡོད།" ], "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": 1423732, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=63a5ed6999a1ac03", "url": "https://translations.documentfoundation.org/api/units/1423732/?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/bo/?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) 5ཕྱིར་ལོག་པ། རྒྱུ་མཚན་ནི་རྟེན་གྲངས་ 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": 1423733, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=51ae539f4b59a081", "url": "https://translations.documentfoundation.org/api/units/1423733/?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/bo/?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) གི་འགྲུབ་འབྲས་ཚང་མ་1ཡིན་ རྒྱུ་མཚན་ནི་འདྲེན་སྤྱོད་བྱས་པའི་རེའུ་མིག་ནང་སྟར་པ་དང་པོའི་ཕྲེང་རྟགས་དང་པོ་ནི་ 1ཡིན། ཕྲེང་རྐྱང་པའི་ས་ཁོངས་ལ་ཕྲེང་རྟགས་གཅིག་ལས་མེད་པའི་དབང་གི་གྲངས་ཚོའི་སྤྱི་བགྲོས་སུ་བརྩིས་ནས་བེད་སྤྱོད་དགོས་མིན་གྱིས་འབྲས་བུར་ཞུགས་རྐྱེན་ཅིག་ཡང་མེད།" ], "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": 1423734, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=61d6a85d76dbd49d", "url": "https://translations.documentfoundation.org/api/units/1423734/?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/bo/?format=api", "source": [ "<item type=\"input\">=ROW()</item> returns 3 if the formula was entered in row 3." ], "previous_source": "", "target": [ "=ROW()རྩིས་རྒྱག་འབྲས་བུ་ནི་3ཡིན་ གལ་སྲིད་དྲ་མིག་གི་ཡིག་ཕྲེང་3སྤྱོ་བགྲོས་འདི་བླུགས་ན།" ], "id_hash": -1963376887368523013, "content_hash": -1963376887368523013, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3153671\nhelp.text", "note": "ABQhH", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2155, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/24942754/?format=api", "priority": 100, "id": 1423735, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=64c0af1f942fe2fb", "url": "https://translations.documentfoundation.org/api/units/1423735/?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/bo/?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": [ "གལ་སྲིད་\"Rabbit\"ནི་མིང་བཏགས་ཟིན་པའི་ས་ཁོངས་ (C1:D3)ཡིན་ན་ {=ROW(Rabbit)} སྟར་པ་རྐྱང་པའི་གྲངས་ཚོ་ (1, 2, 3)ཕྱིར་ལོག" ], "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": 1423736, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=ae61e34ae9f09144", "url": "https://translations.documentfoundation.org/api/units/1423736/?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/bo/?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": 1423737, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=b47df0ee95c54da5", "url": "https://translations.documentfoundation.org/api/units/1423737/?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/bo/?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": 1423738, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=9aeb6baf2dc6680b", "url": "https://translations.documentfoundation.org/api/units/1423738/?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/bo/?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": 1423739, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=9b7526c579a9f85f", "url": "https://translations.documentfoundation.org/api/units/1423739/?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/bo/?format=api", "source": [ "ROWS(Array)" ], "previous_source": "", "target": [ "ROWS(array)" ], "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": 1423740, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=bb8c60d12cd11048", "url": "https://translations.documentfoundation.org/api/units/1423740/?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/bo/?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>array</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": 1423741, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=0eaa4bdb93567312", "url": "https://translations.documentfoundation.org/api/units/1423741/?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/bo/?format=api", "source": [ "<item type=\"input\">=Rows(B5)</item> returns 1 because a cell only contains one row." ], "previous_source": "", "target": [ "=ROWS(B5) སྡོམས་1ཡིན་ རྒྱུ་མཚན་ནི་དྲ་མིག་གཅིག་ནང་ཕྲེང་གཅིག་རང་ཚུད།" ], "id_hash": 3179259141443047493, "content_hash": 3179259141443047493, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3154725\nhelp.text", "note": "vLpxF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2162, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/24942761/?format=api", "priority": 100, "id": 1423742, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=ac1eff583ea05045", "url": "https://translations.documentfoundation.org/api/units/1423742/?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/bo/?format=api", "source": [ "<item type=\"input\">=ROWS(A10:B12)</item> returns 3." ], "previous_source": "", "target": [ "=ROWS(A10:B12)སྡོམས་ 3ཡིན།" ], "id_hash": 8726325246435246997, "content_hash": 8726325246435246997, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3150102\nhelp.text", "note": "j27bq", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2163, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/24942762/?format=api", "priority": 100, "id": 1423743, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=f91a2293dc4bc395", "url": "https://translations.documentfoundation.org/api/units/1423743/?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/bo/?format=api", "source": [ "<item type=\"input\">=ROWS(Rabbit)</item> returns 3 if \"Rabbit\" is the named area (C1:D3)." ], "previous_source": "", "target": [ "གལ་སྲིད་ \"Rabbit\" ནི་མིང་བཏགས་པའི་ས་ཁོངས་ (C1:D3) ཡིན་ན་ =ROWS(Rabbit) ཕྱིར་ལོག་ 3ཡིན།" ], "id_hash": -1013333620181692939, "content_hash": -1013333620181692939, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3155143\nhelp.text", "note": "4AmXS", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2164, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/24942763/?format=api", "priority": 100, "id": 1423744, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=71efea70fa1c0df5", "url": "https://translations.documentfoundation.org/api/units/1423744/?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/bo/?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": 1423745, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=a1909998c66c1b12", "url": "https://translations.documentfoundation.org/api/units/1423745/?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/bo/?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": 1423746, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=75471fd9eb7c40c8", "url": "https://translations.documentfoundation.org/api/units/1423746/?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/bo/?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\"> 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": 1423747, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=beec9661f95f3c61", "url": "https://translations.documentfoundation.org/api/units/1423747/?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/bo/?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 མནན་ནས་\"རྩོམ་སྒྲིག\"མ་ཚུལ་དུ་འཛུལ་ ཆེས་ཐག་སྦྲེལ་མདུན་དུ་འོད་རྟགས་སྤོ་འགུལ་དང་ Shift+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": 1423749, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=d65499d3f495272f", "url": "https://translations.documentfoundation.org/api/units/1423749/?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/bo/?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": 1423752, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=ff72603aefa09b46", "url": "https://translations.documentfoundation.org/api/units/1423752/?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/bo/?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": 1423760, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=72de9861ca23e7eb", "url": "https://translations.documentfoundation.org/api/units/1423760/?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/bo/?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": 1423761, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=c8b9488613555f69", "url": "https://translations.documentfoundation.org/api/units/1423761/?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/bo/?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": 1423762, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=c7fcfaf19755c67b", "url": "https://translations.documentfoundation.org/api/units/1423762/?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/bo/?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": 1423763, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=28d992e8985a8b9d", "url": "https://translations.documentfoundation.org/api/units/1423763/?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/bo/?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": 1423765, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=7782630b6802327e", "url": "https://translations.documentfoundation.org/api/units/1423765/?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/bo/?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": 1423766, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=c8144a7fa3c50c0e", "url": "https://translations.documentfoundation.org/api/units/1423766/?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/bo/?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": 1423767, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=1b88fc3b9fa7fa96", "url": "https://translations.documentfoundation.org/api/units/1423767/?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/bo/?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": 1423768, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=b9598b557d0c3837", "url": "https://translations.documentfoundation.org/api/units/1423768/?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/bo/?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": 1423769, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=6b37af66b89d9ef4", "url": "https://translations.documentfoundation.org/api/units/1423769/?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/bo/?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": 1423770, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=a126aa7875e1b8b5", "url": "https://translations.documentfoundation.org/api/units/1423770/?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/bo/?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": 1423771, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=161dd25d5ea73f0c", "url": "https://translations.documentfoundation.org/api/units/1423771/?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/bo/?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": 1423773, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=6488092f93773faf", "url": "https://translations.documentfoundation.org/api/units/1423773/?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/bo/?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": 1423774, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=4544db61b5a39de0", "url": "https://translations.documentfoundation.org/api/units/1423774/?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/bo/?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": 1423775, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=c6ff18b0f01baf7a", "url": "https://translations.documentfoundation.org/api/units/1423775/?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/bo/?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": 1423776, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/bo/?checksum=b201722efb6582b6", "url": "https://translations.documentfoundation.org/api/units/1423776/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:52:10.901121Z" } ] }