Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-24-2/textscalcguide/bo/units/?format=api&page=27
{ "count": 1558, "next": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/units/?format=api&page=28", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/units/?format=api&page=26", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "<link href=\"text/scalc/01/06050000.xhp\">Creating Scenarios</link>" ], "previous_source": "", "target": [ "<link href=\"text/scalc/01/06050000.xhp\">འཆར་འགོད་གསར་འཛུགས།་</link>" ], "id_hash": 2250133394351343223, "content_hash": 2250133394351343223, "location": "scenario.xhp", "context": "scenario.xhp\npar_id3154484\nhelp.text", "note": "tZ3Es", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1301, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/110834071/?format=api", "priority": 100, "id": 110934072, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=9f3a1466838e4677", "url": "https://translations.documentfoundation.org/api/units/110934072/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:43.357182Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "Applying Sort Lists" ], "previous_source": "", "target": [ "ཉེར་སྤྱོད་རིམ་སྒྲིག་རེའུ་འགོད།" ], "id_hash": 2782619448798829863, "content_hash": 2782619448798829863, "location": "sorted_list.xhp", "context": "sorted_list.xhp\ntit\nhelp.text", "note": "AG6Vf", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1302, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/110834098/?format=api", "priority": 100, "id": 110934076, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=a69dd9a54ebf5d27", "url": "https://translations.documentfoundation.org/api/units/110934076/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:43.359560Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "<bookmark_value>filling;customized lists</bookmark_value><bookmark_value>sort lists;applying</bookmark_value><bookmark_value>defining;sort lists</bookmark_value><bookmark_value>geometric lists</bookmark_value><bookmark_value>arithmetic lists</bookmark_value><bookmark_value>series;sort lists</bookmark_value><bookmark_value>lists; user-defined</bookmark_value><bookmark_value>customized lists</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>སྐོང་གསབ། རེའུ་འགོད།</bookmark_value><bookmark_value>རིམ་སྒྲིག་རེའུ་འགོད། ཉེར་སྤྱོད།</bookmark_value><bookmark_value>དྲ་མིག རང་འགུལ་སྐོང་གསབ་བྱེད་ནུས།</bookmark_value><bookmark_value>དབྱིབས་རྩིས་རེའུ་འགོད།</bookmark_value><bookmark_value>ཨང་རྩིས་རེའུ་འགོད།</bookmark_value><bookmark_value>རིམ་སྟར། རིམ་སྒྲིག་རེའུ་འགོད།</bookmark_value><bookmark_value> རེའུ་འགོད། སྤྱོད་པོས་མཚན་འཇོག</bookmark_value>" ], "id_hash": -4842831399431973213, "content_hash": -4842831399431973213, "location": "sorted_list.xhp", "context": "sorted_list.xhp\nbm_id3150870\nhelp.text", "note": "tWAqX", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1303, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/110834136/?format=api", "priority": 100, "id": 110934083, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=3ccace8029bfd6a3", "url": "https://translations.documentfoundation.org/api/units/110934083/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:43.361311Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "<variable id=\"sorted_list\"><link href=\"text/scalc/guide/sorted_list.xhp\">Applying Sort Lists</link> </variable>" ], "previous_source": "", "target": [ "<variable id=\"sorted_list\"><link href=\"text/scalc/guide/sorted_list.xhp\">ཉེར་སྤྱོད་རིམ་སྒྲིག་རེའུ་འགོད།</link></variable>" ], "id_hash": -8678436004188644317, "content_hash": -8678436004188644317, "location": "sorted_list.xhp", "context": "sorted_list.xhp\nhd_id3150870\nhelp.text", "note": "486Qk", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1304, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/110834152/?format=api", "priority": 100, "id": 110934091, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=0790006f3c601c23", "url": "https://translations.documentfoundation.org/api/units/110934091/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:43.363640Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "Sort lists allow you to type one piece of information in a cell, then drag it to fill in a consecutive list of items." ], "previous_source": "", "target": [ "རིམ་སྒྲིག་རེའུ་འགོད་བྱེད་ནུས་སྤྱད་རྗེས་དྲ་མིག་ཞིག་ནང་ཆ་འཕྲིན་གཅིག་མཐེབ་འཇུག་བྱས་ཞིང་ཆ་འཕྲིན་དེ་འདྲུད་སྒུལ་བྱས་ན་འབྲེད་མཐུད་ཀྱི་དྲ་མིག་ཚོ་གཅིག་སྐོང་གསབ་ཐུབ།" ], "id_hash": -6846691957918148021, "content_hash": -6846691957918148021, "location": "sorted_list.xhp", "context": "sorted_list.xhp\npar_id3159154\nhelp.text", "note": "oMwuD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1305, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://translations.documentfoundation.org/api/units/110834201/?format=api", "priority": 100, "id": 110934097, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=20fba9f089c3da4b", "url": "https://translations.documentfoundation.org/api/units/110934097/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:43.365709Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "For example, enter the text \"Jan\" or \"January\" in an empty cell. Select the cell and click the mouse on the lower right corner of the cell border. Then drag the selected cell a few cells to the right or downwards. When you release the mouse button, the highlighted cells will be filled with the names of the months." ], "previous_source": "", "target": [ "དཔེར་ན་ དྲ་མིག་སྟོང་པའི་ནང་\"དང་པོ།\"འམ་\"ཟླ་དང་པོ།\"འཇུག་པ། དྲ་མིག་དེ་འདེམས་ཞིང་དེའི་མཐའ་སྒྲོམ་གཡས་གཤམ་དུ་ཙིག་རྟགས་རྐྱང་རྡེབ་བྱེད། དེ་རྗེས་གཤམ་ལའམ་གཡས་ལ་བདམས་ཟིན་པའི་དྲ་མིག་འདྲུད་སྒུལ་བྱེད། ཙིག་རྟགས་གློད་སྐབས་འབུར་དུ་མངོན་པའི་དྲ་མིག་རྣམས་སྒྲིག་པའི་ཟླ་མིང་གིས་ཁ་སྐོང་།" ], "id_hash": 2065353311408610424, "content_hash": 2065353311408610424, "location": "sorted_list.xhp", "context": "sorted_list.xhp\npar_id3148645\nhelp.text", "note": "BEsCh", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1306, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 59, "source_unit": "https://translations.documentfoundation.org/api/units/110834252/?format=api", "priority": 100, "id": 110934104, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=9ca99be4de2fdc78", "url": "https://translations.documentfoundation.org/api/units/110934104/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:43.367750Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "Hold down <switchinline select=\"sys\"><caseinline select=\"MAC\">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline> if you do not want to fill the cells with different values." ], "previous_source": "", "target": [ "" ], "id_hash": 1162809071561114065, "content_hash": 1162809071561114065, "location": "sorted_list.xhp", "context": "sorted_list.xhp\npar_id2367931\nhelp.text", "note": "Eay9F", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1307, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 17, "source_unit": "https://translations.documentfoundation.org/api/units/110834330/?format=api", "priority": 100, "id": 110934109, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=902320b0940081d1", "url": "https://translations.documentfoundation.org/api/units/110934109/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:43.369749Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "The predefined series can be found under <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>%PRODUCTNAME - Preferences</emph></caseinline><defaultinline><emph>Tools - Options</emph></defaultinline></switchinline><emph> - %PRODUCTNAME Calc - Sort Lists</emph>. You can also create your own lists of text strings tailored to your needs, such as a list of your company's branch offices. When you use the information in these lists later (for example, as headings), just enter the first name in the list and expand the entry by dragging it with your mouse." ], "previous_source": "", "target": [ "" ], "id_hash": 4586192166671034918, "content_hash": 4586192166671034918, "location": "sorted_list.xhp", "context": "sorted_list.xhp\npar_id3152577\nhelp.text", "note": "YPryW", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1308, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 74, "source_unit": "https://translations.documentfoundation.org/api/units/110834461/?format=api", "priority": 100, "id": 110934114, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=bfa56d7a161b2a26", "url": "https://translations.documentfoundation.org/api/units/110934114/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:43.371526Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "<link href=\"text/shared/optionen/01060400.xhp\">Sort lists</link>" ], "previous_source": "", "target": [ "<link href=\"text/shared/optionen/01060400.xhp\">རིམ་སྒྲིག་ཤོག་ཚན།</link>" ], "id_hash": -2070885226499949407, "content_hash": -2070885226499949407, "location": "sorted_list.xhp", "context": "sorted_list.xhp\npar_id3147434\nhelp.text", "note": "vnpQt", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1309, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/110834518/?format=api", "priority": 100, "id": 110934122, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=6342bcdbc7ddbca1", "url": "https://translations.documentfoundation.org/api/units/110934122/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:43.374231Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "Applying Advanced Filters" ], "previous_source": "", "target": [ "" ], "id_hash": -3660555054599967222, "content_hash": -3660555054599967222, "location": "specialfilter.xhp", "context": "specialfilter.xhp\ntit\nhelp.text", "note": "6GdiT", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1310, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/110834591/?format=api", "priority": 100, "id": 110934129, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=4d33189281ceee0a", "url": "https://translations.documentfoundation.org/api/units/110934129/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:43.377338Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "<bookmark_value>filters;defining advanced filters </bookmark_value><bookmark_value>advanced filters</bookmark_value><bookmark_value>defining; advanced filters</bookmark_value><bookmark_value>database ranges; advanced filters</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>འཚག་འདེམས། མཐོ་རིམ་འཚག་འདེམས་མཚན་འཇོག</bookmark_value><bookmark_value>མཚན་འཇོག མཐོ་རིམ་འཚག་འདེམས།</bookmark_value><bookmark_value>གཞི་གྲངས་མཛོད་ཁྱབ་ཁོངས། མཐོ་རིམ་འཚག་འདེམས།</bookmark_value>" ], "id_hash": 7117808451965716241, "content_hash": 7117808451965716241, "location": "specialfilter.xhp", "context": "specialfilter.xhp\nbm_id3148798\nhelp.text", "note": "Gy5TZ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1311, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/110834635/?format=api", "priority": 100, "id": 110934132, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=e2c7891346b08711", "url": "https://translations.documentfoundation.org/api/units/110934132/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:43.379343Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "<variable id=\"specialfilter\"><link href=\"text/scalc/guide/specialfilter.xhp\">Applying Advanced Filters</link></variable>" ], "previous_source": "", "target": [ "" ], "id_hash": -4981866055637895193, "content_hash": -4981866055637895193, "location": "specialfilter.xhp", "context": "specialfilter.xhp\nhd_id3148798\nhelp.text", "note": "nzLyA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1312, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/110834691/?format=api", "priority": 100, "id": 110934137, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=3adcdb37ab2077e7", "url": "https://translations.documentfoundation.org/api/units/110934137/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:43.382618Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "Copy the column headers of the sheet ranges to be filtered into an empty area of the sheet, and then enter the criteria for the filter in a row beneath the headers. Horizontally arranged data in a row will always be logically connected with AND, and vertically arranged data in a column will always be logically connected with OR." ], "previous_source": "", "target": [ "འཚག་འདེམས་བྱ་རྒྱུའི་ལས་ཁྲའི་ཁོངས་ཀྱི་སྟར་ཁ་བྱང་དེ་ལས་ཁྲའི་ནང་གི་ཁོངས་སྟོང་པར་འདྲ་ཕབ་རྗེས་ སྟར་ཁ་བྱང་འོག་གི་ཕྲེང་ནང་འཚག་འདེམས་ཆ་རྐྱེན་འཇུག ཕྲེང་ནང་ཆུ་སྙོམས་སྒྲིག་གི་གཞི་གྲངས་རྟག་ཏུ་གཏན་ཚིགས་རྟགས་\"དང་\"གིས་སྦྲེལ་ སྟར་ནང་དྲང་འཕྱང་རིམ་སྒྲིག་གི་གཞི་གྲངས་རྟག་ཏུ་\"འམ་\"ཡིས་སྦྲེལ།" ], "id_hash": 2387400062211336893, "content_hash": 2387400062211336893, "location": "specialfilter.xhp", "context": "specialfilter.xhp\npar_id3145785\nhelp.text", "note": "tYuAi", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1313, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 59, "source_unit": "https://translations.documentfoundation.org/api/units/110834753/?format=api", "priority": 100, "id": 110934146, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=a121bfb524da2abd", "url": "https://translations.documentfoundation.org/api/units/110934146/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:43.385916Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "Once you have created a filter matrix, select the sheet ranges to be filtered. Open the <emph>Advanced Filter</emph> dialog by choosing <menuitem>Data - More Filters - Advanced Filter</menuitem>, and define the filter conditions." ], "previous_source": "", "target": [ "" ], "id_hash": -6844686386953263484, "content_hash": -6844686386953263484, "location": "specialfilter.xhp", "context": "specialfilter.xhp\npar_id3153142\nhelp.text", "note": "73DhZ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1314, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 33, "source_unit": "https://translations.documentfoundation.org/api/units/110834819/?format=api", "priority": 100, "id": 110934157, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=2102c9feeab2e684", "url": "https://translations.documentfoundation.org/api/units/110934157/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:43.391202Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "Then click OK, and you will see that only the rows from the original sheet whose contents have met the search criteria are still visible. All other rows are temporarily hidden and can be made to reappear with the <menuitem>Format - Rows - Show</menuitem> command." ], "previous_source": "", "target": [ "" ], "id_hash": -5620549649644658119, "content_hash": -5620549649644658119, "location": "specialfilter.xhp", "context": "specialfilter.xhp\npar_id3153726\nhelp.text", "note": "2F7wd", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1315, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 45, "source_unit": "https://translations.documentfoundation.org/api/units/110834858/?format=api", "priority": 100, "id": 110934162, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=31ffcbdf627be239", "url": "https://translations.documentfoundation.org/api/units/110934162/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:43.393043Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "Example" ], "previous_source": "", "target": [ "" ], "id_hash": -112470937908647374, "content_hash": -112470937908647374, "location": "specialfilter.xhp", "context": "specialfilter.xhp\npar_id3149664\nhelp.text", "note": "Sn4mJ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1316, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110834951/?format=api", "priority": 100, "id": 110934167, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=7e706c4722666a32", "url": "https://translations.documentfoundation.org/api/units/110934167/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:43.394418Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "Load a spreadsheet with a large number of records. We are using a fictional <emph>Turnover</emph> document, but you can just as easily use any other document. The document has the following layout:" ], "previous_source": "", "target": [ "གཞི་གྲངས་ཟིན་ཐོ་མང་དག་ཚུད་པའི་གློག་རྡུལ་རེའུ་མིག་ཁུར་སྣོན། ང་ཚོས་སྤྱོད་པ་ནི་<emph>འཁོར་རྒྱུགས།</emph>ཡིག་ཚགས་གཅིག་ཡིན་ འོན་ཀྱང་ཁྱེད་ཀྱིས་ཡིག་ཚགས་གཞན་གང་རུང་སྤྱད་ཀྱང་དེ་ལྟར་སྟབས་བདེ་ཡོད། ཡིག་ཚགས་དེར་གཤམ་གྱི་པར་དབྱིབས་ཡོད།" ], "id_hash": -3998392825886884412, "content_hash": -3998392825886884412, "location": "specialfilter.xhp", "context": "specialfilter.xhp\npar_id3147427\nhelp.text", "note": "UFqRd", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1317, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 32, "source_unit": "https://translations.documentfoundation.org/api/units/110834995/?format=api", "priority": 100, "id": 110934171, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=4882dae8c48abdc4", "url": "https://translations.documentfoundation.org/api/units/110934171/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:43.395778Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "Month" ], "previous_source": "", "target": [ "ཟླ་བ།" ], "id_hash": 2891455976044999883, "content_hash": 2891455976044999883, "location": "specialfilter.xhp", "context": "specialfilter.xhp\npar_id3159239\nhelp.text", "note": "KiEAY", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1318, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110835034/?format=api", "priority": 100, "id": 110934178, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=a82083e3ffd7b4cb", "url": "https://translations.documentfoundation.org/api/units/110934178/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:43.397902Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "Standard" ], "previous_source": "", "target": [ "ཚད་ལྡན།" ], "id_hash": -5842489461672849589, "content_hash": -5842489461672849589, "location": "specialfilter.xhp", "context": "specialfilter.xhp\npar_id3150086\nhelp.text", "note": "zvwPF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1319, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110835085/?format=api", "priority": 100, "id": 110934183, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=2eeb4eca1906cf4b", "url": "https://translations.documentfoundation.org/api/units/110934183/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:43.399606Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "Business" ], "previous_source": "", "target": [ "ཚོང་དོན།" ], "id_hash": -2616753681549536744, "content_hash": -2616753681549536744, "location": "specialfilter.xhp", "context": "specialfilter.xhp\npar_id3150202\nhelp.text", "note": "FgLfE", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1320, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110835098/?format=api", "priority": 100, "id": 110934188, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=5baf6c640a8b5218", "url": "https://translations.documentfoundation.org/api/units/110934188/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:43.400930Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "Luxury" ], "previous_source": "", "target": [ "རྒྱས་སྤྲོད་བཟོ་ལྟ།" ], "id_hash": 11081334254114949, "content_hash": 11081334254114949, "location": "specialfilter.xhp", "context": "specialfilter.xhp\npar_id3150883\nhelp.text", "note": "v3Dfi", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1321, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110835126/?format=api", "priority": 100, "id": 110934195, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=80275e6a2fda9885", "url": "https://translations.documentfoundation.org/api/units/110934195/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:43.409198Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "Suite" ], "previous_source": "", "target": [ "ཚང་ཆས།" ], "id_hash": -1449357622872119712, "content_hash": -1449357622872119712, "location": "specialfilter.xhp", "context": "specialfilter.xhp\npar_id3152987\nhelp.text", "note": "4BrQp", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1322, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110835152/?format=api", "priority": 100, "id": 110934199, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=6be2d8ebc833e660", "url": "https://translations.documentfoundation.org/api/units/110934199/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:43.411857Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "January" ], "previous_source": "", "target": [ "ཟླ་དང་པོ།" ], "id_hash": 5533564376090591052, "content_hash": 5533564376090591052, "location": "specialfilter.xhp", "context": "specialfilter.xhp\npar_id3148839\nhelp.text", "note": "KT7sj", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1323, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110835184/?format=api", "priority": 100, "id": 110934205, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=cccb2b7b62a2bf4c", "url": "https://translations.documentfoundation.org/api/units/110934205/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:43.416607Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "February" ], "previous_source": "", "target": [ "ཟླ་གཉིས་པ།" ], "id_hash": 5329516219354473778, "content_hash": 5329516219354473778, "location": "specialfilter.xhp", "context": "specialfilter.xhp\npar_id3149900\nhelp.text", "note": "USDDe", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1324, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110835399/?format=api", "priority": 100, "id": 110934207, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=c9f63ec3b74e6532", "url": "https://translations.documentfoundation.org/api/units/110934207/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:43.421755Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "March" ], "previous_source": "", "target": [ "ཟླ་བ་གསུམ་པ།" ], "id_hash": 1605806199289126873, "content_hash": 1605806199289126873, "location": "specialfilter.xhp", "context": "specialfilter.xhp\npar_id3147250\nhelp.text", "note": "88qLX", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1325, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110835444/?format=api", "priority": 100, "id": 110934215, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=9648f83af6bf9fd9", "url": "https://translations.documentfoundation.org/api/units/110934215/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:43.424009Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "and so on..." ], "previous_source": "", "target": [ "སྒུག་པ།..." ], "id_hash": -1548848217751534148, "content_hash": -1548848217751534148, "location": "specialfilter.xhp", "context": "specialfilter.xhp\npar_id3151391\nhelp.text", "note": "sbbpY", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1326, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/110835493/?format=api", "priority": 100, "id": 110934221, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=6a8162c089ec45bc", "url": "https://translations.documentfoundation.org/api/units/110934221/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:43.426004Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "Copy row 1 with the row headers (field names), to row 20, for example. Enter the filter conditions linked with OR in rows 21, 22, and so on." ], "previous_source": "", "target": [ "ཕྲེང་ 1 དེ་ཕྲེང་ཁ་བྱང་(ཡིག་དུམ་མིང་)དང་མཉམ་དུ་ཕྲེང་ 20 ལ་འདྲ་ཕབ་བྱེད། ཕྲེང་ 21དང་22 སོགས་སོ་སོའི་ནང་ OR ཐག་སྦྲེལ་གྱི་འཚག་འདེམས་ཆ་རྐྱེན་འཇུག" ], "id_hash": -2378213447471280303, "content_hash": -2378213447471280303, "location": "specialfilter.xhp", "context": "specialfilter.xhp\npar_id3147300\nhelp.text", "note": "e5jJ9", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1327, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 28, "source_unit": "https://translations.documentfoundation.org/api/units/110835514/?format=api", "priority": 100, "id": 110934228, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=5efee378476acf51", "url": "https://translations.documentfoundation.org/api/units/110934228/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:43.428037Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "Month" ], "previous_source": "", "target": [ "ཟླ་བ།" ], "id_hash": -1033504986130264121, "content_hash": -1033504986130264121, "location": "specialfilter.xhp", "context": "specialfilter.xhp\npar_id3150693\nhelp.text", "note": "VHUHq", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1328, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110835556/?format=api", "priority": 100, "id": 110934233, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=71a840b0dc1c4fc7", "url": "https://translations.documentfoundation.org/api/units/110934233/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:43.430298Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "Standard" ], "previous_source": "", "target": [ "ཚད་ལྡན།" ], "id_hash": -5010097898375563567, "content_hash": -5010097898375563567, "location": "specialfilter.xhp", "context": "specialfilter.xhp\npar_id3147475\nhelp.text", "note": "fX6Uo", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1329, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110835613/?format=api", "priority": 100, "id": 110934238, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=3a788e818d64b6d1", "url": "https://translations.documentfoundation.org/api/units/110934238/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:43.432568Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "Business" ], "previous_source": "", "target": [ "ཚོང་དོན།" ], "id_hash": 6915852544870314165, "content_hash": 6915852544870314165, "location": "specialfilter.xhp", "context": "specialfilter.xhp\npar_id3154846\nhelp.text", "note": "kQ8ZZ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1330, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110835685/?format=api", "priority": 100, "id": 110934243, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=dffa0b3f6ff9f0b5", "url": "https://translations.documentfoundation.org/api/units/110934243/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:43.434672Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "Luxury" ], "previous_source": "", "target": [ "རྒྱས་སྤྲོད་བཟོ་ལྟ།" ], "id_hash": 2602737318262423109, "content_hash": 2602737318262423109, "location": "specialfilter.xhp", "context": "specialfilter.xhp\npar_id3153082\nhelp.text", "note": "cZBpH", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1331, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110835697/?format=api", "priority": 100, "id": 110934248, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=a41ec7cd12af3e45", "url": "https://translations.documentfoundation.org/api/units/110934248/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:43.436759Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "Suite" ], "previous_source": "", "target": [ "ཚང་ཆས།" ], "id_hash": 3115261982357523362, "content_hash": 3115261982357523362, "location": "specialfilter.xhp", "context": "specialfilter.xhp\npar_id3149506\nhelp.text", "note": "eo2EN", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1332, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110835919/?format=api", "priority": 100, "id": 110934253, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=ab3ba24480b30ba2", "url": "https://translations.documentfoundation.org/api/units/110934253/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:43.438916Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "January" ], "previous_source": "", "target": [ "ཟླ་དང་པོ།" ], "id_hash": -6161606621156287619, "content_hash": -6161606621156287619, "location": "specialfilter.xhp", "context": "specialfilter.xhp\npar_id3149956\nhelp.text", "note": "CAjJZ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 1333, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110835969/?format=api", "priority": 100, "id": 110934260, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=2a7d936c7448db7d", "url": "https://translations.documentfoundation.org/api/units/110934260/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:43.441003Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "Specify that only rows which either have the value <literal>January</literal> in the <emph>Month</emph> cells OR a value of under 160000 in the <emph>Standard</emph> cells will be displayed." ], "previous_source": "", "target": [ "" ], "id_hash": 4300422702191999635, "content_hash": 4300422702191999635, "location": "specialfilter.xhp", "context": "specialfilter.xhp\npar_id3153566\nhelp.text", "note": "GTvgG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1334, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 27, "source_unit": "https://translations.documentfoundation.org/api/units/110836032/?format=api", "priority": 100, "id": 110934265, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=bbae2ba9bc2dfa93", "url": "https://translations.documentfoundation.org/api/units/110934265/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:43.443086Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "Choose <menuitem>Data - More Filters - Advanced Filter</menuitem>, and then select the range A20:E22. After you click OK, only the filtered rows will be displayed. The other rows will be hidden from view." ], "previous_source": "", "target": [ "" ], "id_hash": 5334272711115131498, "content_hash": 5334272711115131498, "location": "specialfilter.xhp", "context": "specialfilter.xhp\npar_id3147372\nhelp.text", "note": "ApUpg", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1335, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 33, "source_unit": "https://translations.documentfoundation.org/api/units/110836105/?format=api", "priority": 100, "id": 110934271, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=ca0724c4c113ca6a", "url": "https://translations.documentfoundation.org/api/units/110934271/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:43.445041Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "Using Subtotals Tool" ], "previous_source": "", "target": [ "" ], "id_hash": 7533233722582203021, "content_hash": 7533233722582203021, "location": "subtotaltool.xhp", "context": "subtotaltool.xhp\ntit\nhelp.text", "note": "jQ6bn", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1336, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/110836142/?format=api", "priority": 100, "id": 110934277, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=e88b6c286c817a8d", "url": "https://translations.documentfoundation.org/api/units/110934277/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:43.446822Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "<bookmark_value>subtotals;using subtotals tool</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": 3949916786312185341, "content_hash": 3949916786312185341, "location": "subtotaltool.xhp", "context": "subtotaltool.xhp\nbm_id521585182060496\nhelp.text", "note": "aKjYH", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1337, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/110836161/?format=api", "priority": 100, "id": 110934282, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=b6d0ec63bc7d85fd", "url": "https://translations.documentfoundation.org/api/units/110934282/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:43.448554Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "<variable id=\"subtotaltoolh1\"><link href=\"text/scalc/guide/subtotaltool.xhp\">Using Subtotal Tool</link></variable>" ], "previous_source": "", "target": [ "" ], "id_hash": 82873423559425778, "content_hash": 82873423559425778, "location": "subtotaltool.xhp", "context": "subtotaltool.xhp\nhd_id631585177069332\nhelp.text", "note": "e7TMf", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1338, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/110836211/?format=api", "priority": 100, "id": 110934286, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=81266cf08c947ef2", "url": "https://translations.documentfoundation.org/api/units/110934286/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:43.450251Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "Calc offers the Subtotals tool as a more comprehensive alternative to the <link href=\"text/scalc/01/04060106.xhp#Section12\">SUBTOTAL function</link>. In contrast to SUBTOTAL, which only works on a single array, the Subtotals tool can create subtotals for up to three arrays arranged in labeled columns. It also groups subtotals by category and sorts them automatically, thereby eliminating the need to apply AutoFilters and filter categories by hand." ], "previous_source": "", "target": [ "" ], "id_hash": -1797926882289676209, "content_hash": -1797926882289676209, "location": "subtotaltool.xhp", "context": "subtotaltool.xhp\npar_id301585177069332\nhelp.text", "note": "FEwcj", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1339, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 63, "source_unit": "https://translations.documentfoundation.org/api/units/110836256/?format=api", "priority": 100, "id": 110934293, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=670c7b06c0ff904f", "url": "https://translations.documentfoundation.org/api/units/110934293/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:43.452053Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "Using the Subtotals tool" ], "previous_source": "", "target": [ "" ], "id_hash": 3708895243280421151, "content_hash": 3708895243280421151, "location": "subtotaltool.xhp", "context": "subtotaltool.xhp\nhd_id891585177511329\nhelp.text", "note": "NEkbi", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1340, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/110836284/?format=api", "priority": 100, "id": 110934299, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=b378a492bcdd911f", "url": "https://translations.documentfoundation.org/api/units/110934299/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:43.453935Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "To insert subtotal values into a worksheet:" ], "previous_source": "", "target": [ "" ], "id_hash": -6503939318800028129, "content_hash": -6503939318800028129, "location": "subtotaltool.xhp", "context": "subtotaltool.xhp\npar_id91585177517697\nhelp.text", "note": "kwLkR", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1341, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/110836354/?format=api", "priority": 100, "id": 110934305, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=25bd5da61e3a6e1f", "url": "https://translations.documentfoundation.org/api/units/110934305/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:43.456072Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "Select the cell range for the subtotals that you want to calculate, and remember to include the column heading labels. Alternatively, click on a single cell within your data to allow Calc to automatically identify the range." ], "previous_source": "", "target": [ "" ], "id_hash": 1676165077590547897, "content_hash": 1676165077590547897, "location": "subtotaltool.xhp", "context": "subtotaltool.xhp\npar_id241585177550504\nhelp.text", "note": "DKZ3o", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1342, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 37, "source_unit": "https://translations.documentfoundation.org/api/units/110836408/?format=api", "priority": 100, "id": 110934309, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=9742ef41e2b31db9", "url": "https://translations.documentfoundation.org/api/units/110934309/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:43.458198Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "Choose <menuitem>Data - Subtotals</menuitem> to open the Subtotals dialog." ], "previous_source": "", "target": [ "" ], "id_hash": -6297832789348154293, "content_hash": -6297832789348154293, "location": "subtotaltool.xhp", "context": "subtotaltool.xhp\npar_id421585177574387\nhelp.text", "note": "QiBqE", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1343, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/110836461/?format=api", "priority": 100, "id": 110934312, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=28999a720818844b", "url": "https://translations.documentfoundation.org/api/units/110934312/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:43.460733Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "In the <emph>Group by</emph> drop-down list on the <emph>First Group</emph> page, select a column by its label. Entries in the cell range from step 1 will be grouped and sorted by matching values in this column." ], "previous_source": "", "target": [ "" ], "id_hash": -6353680389445522381, "content_hash": -6353680389445522381, "location": "subtotaltool.xhp", "context": "subtotaltool.xhp\npar_id41585177608508\nhelp.text", "note": "BwAst", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1344, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 36, "source_unit": "https://translations.documentfoundation.org/api/units/110836494/?format=api", "priority": 100, "id": 110934315, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=27d331595abbec33", "url": "https://translations.documentfoundation.org/api/units/110934315/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:43.463143Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "In the <emph>Calculate subtotals for</emph> box on the <emph>First Group</emph> page, select a column containing values to be subtotaled. If you later change values in this column, Calc will automatically recalculate the subtotals." ], "previous_source": "", "target": [ "" ], "id_hash": 5461938802686026943, "content_hash": 5461938802686026943, "location": "subtotaltool.xhp", "context": "subtotaltool.xhp\npar_id451585177625978\nhelp.text", "note": "QmNL9", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1345, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 33, "source_unit": "https://translations.documentfoundation.org/api/units/110836532/?format=api", "priority": 100, "id": 110934320, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=cbccb4670705e4bf", "url": "https://translations.documentfoundation.org/api/units/110934320/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:43.465608Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "In the <emph>Use function</emph> box on the <emph>First Group</emph> page, select a function to calculate the subtotals for the column selected in step 4." ], "previous_source": "", "target": [ "" ], "id_hash": 3549048077078569758, "content_hash": 3549048077078569758, "location": "subtotaltool.xhp", "context": "subtotaltool.xhp\npar_id661585177644535\nhelp.text", "note": "CQ9km", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1346, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://translations.documentfoundation.org/api/units/110836587/?format=api", "priority": 100, "id": 110934325, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=b140c06c250d231e", "url": "https://translations.documentfoundation.org/api/units/110934325/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:43.467540Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "Repeat steps 4 and 5 to create subtotals for other columns on the <emph>First Group</emph> page." ], "previous_source": "", "target": [ "" ], "id_hash": 2291410142773376334, "content_hash": 2291410142773376334, "location": "subtotaltool.xhp", "context": "subtotaltool.xhp\npar_id351585177661529\nhelp.text", "note": "3eTTE", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1347, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/110836639/?format=api", "priority": 100, "id": 110934330, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=9fccb9626abbf54e", "url": "https://translations.documentfoundation.org/api/units/110934330/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:43.469512Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "You can create two more subtotal categories by using the <emph>Second Group</emph> and <emph>Third Group</emph> pages and repeating steps 3 to 6. If you do not want to add more groups, then leave the Group by list for each page set to “- none -”." ], "previous_source": "", "target": [ "" ], "id_hash": 2159292982110408392, "content_hash": 2159292982110408392, "location": "subtotaltool.xhp", "context": "subtotaltool.xhp\npar_id511585177679372\nhelp.text", "note": "6GLDr", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1348, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 45, "source_unit": "https://translations.documentfoundation.org/api/units/110836708/?format=api", "priority": 100, "id": 110934335, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=9df75986dcaf4ec8", "url": "https://translations.documentfoundation.org/api/units/110934335/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:43.471432Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "Click <emph>OK</emph>. Calc will add subtotal and grand total rows to your cell range." ], "previous_source": "", "target": [ "" ], "id_hash": 3137595891275628965, "content_hash": 3137595891275628965, "location": "subtotaltool.xhp", "context": "subtotaltool.xhp\npar_id301585177698777\nhelp.text", "note": "HDB52", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1349, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/110836768/?format=api", "priority": 100, "id": 110934340, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=ab8afad6e43581a5", "url": "https://translations.documentfoundation.org/api/units/110934340/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:43.473603Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "Subtotal outline" ], "previous_source": "", "target": [ "" ], "id_hash": 6090414715338233155, "content_hash": 6090414715338233155, "location": "subtotaltool.xhp", "context": "subtotaltool.xhp\nhd_id211585178799496\nhelp.text", "note": "iMTer", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1350, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/110836817/?format=api", "priority": 100, "id": 110934346, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=d4857fea4a8c1543", "url": "https://translations.documentfoundation.org/api/units/110934346/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:43.475746Z" } ] }