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=7
https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/units/?format=api&page=8", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/units/?format=api&page=6", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "Under <switchinline select=\"sys\"><caseinline select=\"MAC\">%PRODUCTNAME - Preferences</caseinline><defaultinline>Tools - Options</defaultinline></switchinline> - <link href=\"text/shared/optionen/01040900.xhp\"><item type=\"menuitem\">%PRODUCTNAME Calc - General</item></link> you can choose to have the update, when opened, automatically carried out either always, upon request or never. The update can be started manually in the dialog under <item type=\"menuitem\">Edit - Links</item>." ], "previous_source": "", "target": [ "" ], "id_hash": -3243156950039999989, "content_hash": -3243156950039999989, "location": "cellreferences_url.xhp", "context": "cellreferences_url.xhp\npar_id3159204\nhelp.text", "note": "tapEk", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 301, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 47, "source_unit": "https://translations.documentfoundation.org/api/units/110800389/?format=api", "priority": 100, "id": 110927409, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=52fdfdefda06ca0b", "url": "https://translations.documentfoundation.org/api/units/110927409/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:32.679570Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "Assigning Formats by Formula" ], "previous_source": "", "target": [ "སྤྱི་འགྲོས་ལ་གཞིགས་ནས་གཏན་འཁེལ་བྱས་པའི་རྣམ་གཞག" ], "id_hash": -3609957716354299150, "content_hash": -3609957716354299150, "location": "cellstyle_by_formula.xhp", "context": "cellstyle_by_formula.xhp\ntit\nhelp.text", "note": "4DFzJ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 302, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/110800427/?format=api", "priority": 100, "id": 110927415, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=4de6da9556858af2", "url": "https://translations.documentfoundation.org/api/units/110927415/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:32.681506Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "<bookmark_value>formats; assigning by formulas</bookmark_value> <bookmark_value>cell formats; assigning by formulas</bookmark_value> <bookmark_value>STYLE function example</bookmark_value> <bookmark_value>cell styles;assigning by formulas</bookmark_value> <bookmark_value>formulas;assigning cell formats</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>རྣམ་གཞག སྤྱི་འགྲོས་ཀྱི་གཏན་འཁེལ་བྱེད།</bookmark_value><bookmark_value>དྲ་མིག་རྣམ་གཞག སྤྱི་འགྲོས་ཀྱི་གཏན་འཁེལ་བྱེད།</bookmark_value><bookmark_value>STYLE རྟེན་གྲངས་དཔེ་གཞི།</bookmark_value>" ], "id_hash": 164411229929034979, "content_hash": 164411229929034979, "location": "cellstyle_by_formula.xhp", "context": "cellstyle_by_formula.xhp\nbm_id3145673\nhelp.text", "note": "ewC9e", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 303, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/110800429/?format=api", "priority": 100, "id": 110927419, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=82481b247d0154e3", "url": "https://translations.documentfoundation.org/api/units/110927419/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:32.683364Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "<variable id=\"cellstyle_by_formula\"><link href=\"text/scalc/guide/cellstyle_by_formula.xhp\">Assigning Formats by Formula</link></variable>" ], "previous_source": "", "target": [ "<variable id=\"cellstyle_by_formula\"><link href=\"text/scalc/guide/cellstyle_by_formula.xhp\">སྤྱི་འགྲོས་ལ་གཞིགས་ནས་གཏན་འཁེལ་བྱས་པའི་རྣམ་གཞག</link></variable>" ], "id_hash": 7449992543712776327, "content_hash": 7449992543712776327, "location": "cellstyle_by_formula.xhp", "context": "cellstyle_by_formula.xhp\nhd_id3145673\nhelp.text", "note": "x3HG2", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 304, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/110800430/?format=api", "priority": 100, "id": 110927430, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=e763b0bf2b4f1087", "url": "https://translations.documentfoundation.org/api/units/110927430/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:32.686412Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "The STYLE() function can be added to an existing formula in a cell. For example, together with the CURRENT function, you can color a cell depending on its value. The formula =...+STYLE(IF(CURRENT()>3; \"Red\"; \"Green\")) applies the cell style \"Red\" to cells if the value is greater than 3, otherwise the cell style \"Green\" is applied." ], "previous_source": "", "target": [ "རྟེན་གྲངས་ STYLE() ད་ཡོད་སྤྱི་འགྲོས་བརྒྱུད་ནས་དྲ་མིག་ལ་གསབ་སྣོན་བྱ། རྟེན་གྲངས་ CURRENT བརྒྱུད་ནས་ཁྱེད་ཀྱིས་གྲངས་ཐང་ལ་གཞིགས་ནས་དྲ་མིག་ལ་མདོག་སྣོན་ དཔེར་ན་ =...+STYLE(IF(ACTUAL()>3;\"Red\";\"Green\")) དྲ་མིག་ནི་\"དམར་པོའི་\"བཟོ་ལྟ་མཚོན། གྲངས་ཐང་ 3 ལས་ཆེ་བའི་སྐབས་དྲ་མིག་ནི་\"ལྗང་གུའི་\"བཟོ་ལྟ་ཡིན།" ], "id_hash": 3545701820741360435, "content_hash": 3545701820741360435, "location": "cellstyle_by_formula.xhp", "context": "cellstyle_by_formula.xhp\npar_id3150275\nhelp.text", "note": "EzSnh", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 305, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 55, "source_unit": "https://translations.documentfoundation.org/api/units/110800431/?format=api", "priority": 100, "id": 110927437, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=b134dd0520be9b33", "url": "https://translations.documentfoundation.org/api/units/110927437/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:32.689396Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "If you would like to apply a formula to all cells in a selected area, you can use the <item type=\"menuitem\">Find & Replace</item> dialog." ], "previous_source": "", "target": [ "གལ་ཏེ་རེ་བར་བདམས་པའི་ས་ཁོངས་ནང་དྲ་མིག་ཡོད་ཚད་ལ་སྤྱི་འགྲོས་ཤིག་སྤྱོད་འདོད་ན་ <emph>བཤེར་འཚོལ་དང་ཚབ་བརྗེ།</emph>གླེང་སྒྲོམ་བེད་སྤྱོད་ཆོག" ], "id_hash": 4662496989831300287, "content_hash": 4662496989831300287, "location": "cellstyle_by_formula.xhp", "context": "cellstyle_by_formula.xhp\npar_id3151385\nhelp.text", "note": "bMcgv", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 306, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://translations.documentfoundation.org/api/units/110800432/?format=api", "priority": 100, "id": 110927444, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=c0b4844f2d3904bf", "url": "https://translations.documentfoundation.org/api/units/110927444/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:32.692115Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "Select all the desired cells." ], "previous_source": "", "target": [ "ཁྱེད་ལ་དགོས་པའི་དྲ་མིག་ཡོད་ཚད་འདེམས་དགོས།" ], "id_hash": -7915414649820688558, "content_hash": -7915414649820688558, "location": "cellstyle_by_formula.xhp", "context": "cellstyle_by_formula.xhp\npar_id3149456\nhelp.text", "note": "qAH7F", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 307, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/110800433/?format=api", "priority": 100, "id": 110927450, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=1226cc504b83cf52", "url": "https://translations.documentfoundation.org/api/units/110927450/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:32.694510Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "Select the menu command <emph>Edit - Find & Replace</emph>." ], "previous_source": "", "target": [ "ཚལ་ཐོའི་<emph>རྩོམ་སྒྲིག་ - འཚོལ་བ་དང་ཚབ་བརྗེ་</emph>འདེམས་པ།" ], "id_hash": -3871256957612398730, "content_hash": -3871256957612398730, "location": "cellstyle_by_formula.xhp", "context": "cellstyle_by_formula.xhp\npar_id3148797\nhelp.text", "note": "FyUDd", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 308, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/110800434/?format=api", "priority": 100, "id": 110927464, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=4a46884ecf40e776", "url": "https://translations.documentfoundation.org/api/units/110927464/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:32.722720Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "For the <item type=\"menuitem\">Find</item> term, enter: .<item type=\"literal\">*</item>" ], "previous_source": "", "target": [ "" ], "id_hash": -3542223392916196599, "content_hash": -3542223392916196599, "location": "cellstyle_by_formula.xhp", "context": "cellstyle_by_formula.xhp\npar_id3150767\nhelp.text", "note": "STxmA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 309, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/110800456/?format=api", "priority": 100, "id": 110927472, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=4ed77e977626b309", "url": "https://translations.documentfoundation.org/api/units/110927472/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:32.726791Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "\".*\" is a regular expression that designates the contents of the current cell." ], "previous_source": "", "target": [ "\".*\" ནི་རྒྱུན་སྲོལ་མཚོན་ཚུལ་ཞིག་ཡིན་ མིག་སྔའི་དྲ་མིག་ནང་གི་ནང་དོན་ཚབ་འཛུགས་བྱེད།" ], "id_hash": 2250458990697445731, "content_hash": 2250458990697445731, "location": "cellstyle_by_formula.xhp", "context": "cellstyle_by_formula.xhp\npar_id3153770\nhelp.text", "note": "EN8wF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 310, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/110800475/?format=api", "priority": 100, "id": 110927485, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=9f3b3c87521af963", "url": "https://translations.documentfoundation.org/api/units/110927485/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:32.819182Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "Enter the following formula in the <item type=\"menuitem\">Replace</item> field: <item type=\"literal\">=&+STYLE(IF(CURRENT()>3;\"Red\";\"Green\"))</item>" ], "previous_source": "", "target": [ "" ], "id_hash": 7564866201628513913, "content_hash": 7564866201628513913, "location": "cellstyle_by_formula.xhp", "context": "cellstyle_by_formula.xhp\npar_id3153143\nhelp.text", "note": "r8m3j", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 311, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/110800499/?format=api", "priority": 100, "id": 110927490, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=e8fbcdbae16d1679", "url": "https://translations.documentfoundation.org/api/units/110927490/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:32.822873Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "The \"&\" symbol designates the current contents of the <emph>Find</emph> field. The line must begin with an equal sign, since it is a formula. It is assumed that the cell styles \"Red\" and \"Green\" already exist." ], "previous_source": "", "target": [ "" ], "id_hash": 2301038259609661742, "content_hash": 2301038259609661742, "location": "cellstyle_by_formula.xhp", "context": "cellstyle_by_formula.xhp\npar_id3146975\nhelp.text", "note": "prHDb", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 312, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 36, "source_unit": "https://translations.documentfoundation.org/api/units/110800538/?format=api", "priority": 100, "id": 110927491, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=9feeee1b0e9df12e", "url": "https://translations.documentfoundation.org/api/units/110927491/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:32.824929Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "Mark the fields <link href=\"text/shared/01/02100000.xhp\"><emph>Regular expressions</emph></link> and <emph>Current selection only</emph>. Click <emph>Find All</emph>." ], "previous_source": "", "target": [ "<link href=\"text/shared/01/02100000.xhp\"><emph>ཚད་མཐུན་མཚོན་པའི་ཚུལ།</emph></link>དང་<emph>མིག་སྔའི་བདམས་པའི་ས་ཁོངས་འབའ་ཞིག་ལ་གནས།</emph>ཡིག་དུམ་བདམས་པ། <emph>ཡོངས་རྫོགས་བཤེར་འཚོལ།</emph>ལ་རྐྱང་རྡེབ་བྱ།" ], "id_hash": 8731978487739033615, "content_hash": 8731978487739033615, "location": "cellstyle_by_formula.xhp", "context": "cellstyle_by_formula.xhp\npar_id3149262\nhelp.text", "note": "iF62Y", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 313, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/110800597/?format=api", "priority": 100, "id": 110927495, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=f92e382bac09a80f", "url": "https://translations.documentfoundation.org/api/units/110927495/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:32.826821Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "All cells with contents that were included in the selection are now highlighted." ], "previous_source": "", "target": [ "འདེམས་པའི་ནང་ནང་དོན་ལྡན་པའི་དྲ་མིག་ཡོད་ཚད་འབུར་ཐོན་གྱིས་མངོན་པར་བྱེད།" ], "id_hash": 8123534687943202457, "content_hash": 8123534687943202457, "location": "cellstyle_by_formula.xhp", "context": "cellstyle_by_formula.xhp\npar_id3144767\nhelp.text", "note": "A3CBV", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 314, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/110800631/?format=api", "priority": 100, "id": 110927498, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=f0bc97c2236b1699", "url": "https://translations.documentfoundation.org/api/units/110927498/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:32.829396Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "Click <item type=\"menuitem\">Replace all</item>." ], "previous_source": "", "target": [ "<item type=\"menuitem\">གཞི་གྲངས་ - རིམ་སྒྲིག་</item>འདེམས་པ།" ], "id_hash": 6497422687296759040, "content_hash": 6497422687296759040, "location": "cellstyle_by_formula.xhp", "context": "cellstyle_by_formula.xhp\npar_id3147127\nhelp.text", "note": "CxKWs", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 315, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/110800640/?format=api", "priority": 100, "id": 110927502, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=da2b7b825fe32500", "url": "https://translations.documentfoundation.org/api/units/110927502/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:32.831752Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "Applying Conditional Formatting" ], "previous_source": "", "target": [ "ཉེར་སྤྱོད་ཆ་རྐྱེན་རྣམ་གཞག" ], "id_hash": 4878667856389839357, "content_hash": 4878667856389839357, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\ntit\nhelp.text", "note": "smBjq", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 316, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/110800686/?format=api", "priority": 100, "id": 110927508, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=c3b482912d3b99fd", "url": "https://translations.documentfoundation.org/api/units/110927508/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:32.834223Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "<bookmark_value>conditional formatting; cells</bookmark_value> <bookmark_value>cells; conditional formatting</bookmark_value> <bookmark_value>formatting; conditional formatting</bookmark_value> <bookmark_value>styles;conditional styles</bookmark_value> <bookmark_value>cell formats; conditional</bookmark_value> <bookmark_value>random numbers;examples</bookmark_value> <bookmark_value>cell styles; copying</bookmark_value> <bookmark_value>copying; cell styles</bookmark_value> <bookmark_value>tables; copying cell styles</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><bookmark_value> དྲ་མིག་བཟོ་ལྟ། འདྲ་ཕབ།</bookmark_value><bookmark_value>འདྲ་ཕབ། དྲ་མིག་བཟོ་ལྟ།</bookmark_value><bookmark_value>འདྲ་ཕབ། དྲ་མིག་བཟོ་ལྟ་འདྲ་ཕབ། </bookmark_value>" ], "id_hash": -279766961116655222, "content_hash": -279766961116655222, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\nbm_id3149263\nhelp.text", "note": "3TV3y", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 317, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/110800718/?format=api", "priority": 100, "id": 110927513, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=7c1e116e5ec0518a", "url": "https://translations.documentfoundation.org/api/units/110927513/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:32.836366Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "<variable id=\"cellstyle_conditional\"><link href=\"text/scalc/guide/cellstyle_conditional.xhp\">Applying Conditional Formatting</link></variable>" ], "previous_source": "", "target": [ "<variable id=\"cellstyle_conditional\"><link href=\"text/scalc/guide/cellstyle_conditional.xhp\">ཉེར་སྤྱོད་ཆ་རྐྱེན་རྣམ་གཞག</link></variable>" ], "id_hash": 2343396187597534365, "content_hash": 2343396187597534365, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\nhd_id3149263\nhelp.text", "note": "WX8sY", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 318, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/110800747/?format=api", "priority": 100, "id": 110927520, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=a0856a6ab1c1749d", "url": "https://translations.documentfoundation.org/api/units/110927520/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:32.840223Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "Using the menu command <emph>Format - Conditional - Condition</emph>, the dialog allows you to define conditions per cell, which must be met in order for the selected cells to have a particular format." ], "previous_source": "", "target": [ "" ], "id_hash": 3745596194465971682, "content_hash": 3745596194465971682, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3159156\nhelp.text", "note": "3Feon", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 319, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 33, "source_unit": "https://translations.documentfoundation.org/api/units/110800786/?format=api", "priority": 100, "id": 110927555, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=b3fb07e4d332fde2", "url": "https://translations.documentfoundation.org/api/units/110927555/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:32.857491Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "To apply conditional formatting, AutoCalculate must be enabled. Choose <emph>Data - Calculate - AutoCalculate</emph> (you see a check mark next to the command when AutoCalculate is enabled)." ], "previous_source": "", "target": [ "" ], "id_hash": -7605701934056524265, "content_hash": -7605701934056524265, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id8039796\nhelp.text", "note": "SbhJy", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 320, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 27, "source_unit": "https://translations.documentfoundation.org/api/units/110800834/?format=api", "priority": 100, "id": 110927564, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=16731e63410f3617", "url": "https://translations.documentfoundation.org/api/units/110927564/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:32.861616Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "With conditional formatting, you can, for example, highlight the totals that exceed the average value of all totals. If the totals change, the formatting changes correspondingly, without having to apply other styles manually." ], "previous_source": "", "target": [ "ཆ་རྐྱེན་རྣམ་གཞག་སྤྱོད་པས་སྤྱི་སྡོམས་ཆ་སྙོམས་ཐང་ལས་བརྒལ་བའི་སྤྱི་སྡོམས་འབུར་དུ་མངོན་ཐུབ། གལ་ཏེ་སྤྱི་སྡོམས་འགྱུར་ན་རྣམ་གཞག་ཀྱང་ལྟོས་བཅས་སུ་འགྱུར་ ལག་སྒུལ་གྱིས་བཟོ་ལྟ་གཞན་དག་ཉེར་སྤྱོད་བྱ་མི་དགོས།" ], "id_hash": 3980182931444228703, "content_hash": 3980182931444228703, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3154944\nhelp.text", "note": "Yy9Z2", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 321, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 33, "source_unit": "https://translations.documentfoundation.org/api/units/110800883/?format=api", "priority": 100, "id": 110927569, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=b73c7349c9ce625f", "url": "https://translations.documentfoundation.org/api/units/110927569/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:32.863714Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "To Define the Conditions" ], "previous_source": "", "target": [ "" ], "id_hash": 4295185402721551039, "content_hash": 4295185402721551039, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\nhd_id4480727\nhelp.text", "note": "Zn2cD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 322, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/110800919/?format=api", "priority": 100, "id": 110927579, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=bb9b905deda942bf", "url": "https://translations.documentfoundation.org/api/units/110927579/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:32.866655Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "Select the cells to which you want to apply a conditional style." ], "previous_source": "", "target": [ "བཟོ་ལྟའི་རྣམ་གཞག་ལ་སྤྱོད་དགོས་པའི་དྲ་མིག་འདེམས་པ།" ], "id_hash": 7282045265121163783, "content_hash": 7282045265121163783, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3154490\nhelp.text", "note": "GbyDp", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 323, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/110800943/?format=api", "priority": 100, "id": 110927586, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=e50f059631dcba07", "url": "https://translations.documentfoundation.org/api/units/110927586/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:32.868625Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "Choose <emph>Format - Conditional - Condition</emph>." ], "previous_source": "", "target": [ "" ], "id_hash": 1963779157907618221, "content_hash": 1963779157907618221, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3155603\nhelp.text", "note": "oEDHp", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 324, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/110800958/?format=api", "priority": 100, "id": 110927592, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=9b40bebd546639ad", "url": "https://translations.documentfoundation.org/api/units/110927592/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:32.871364Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "Enter the condition(s) into the dialog box. The dialog is described in detail in <link href=\"text/scalc/01/05120000.xhp\">$[officename] Help</link>, and an example is provided below:" ], "previous_source": "", "target": [ "གླེང་སྒྲོམ་ནང་ཆ་རྐྱེན་ནང་འཇུག་བྱ། གླེང་སྒྲོམ་དེ་ <link href=\"text/scalc/01/05120000.xhp\">$[officename] རོགས་རམ།</link>ནང་ཞིབ་པར་གསལ་བཤད་བྱས་ཡོད་ གཤམ་གསལ་ནི་དཔེ་གཞི་ཞིག་ཡིན།" ], "id_hash": -8619950715441449712, "content_hash": -8619950715441449712, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3146969\nhelp.text", "note": "AnNxD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 325, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 23, "source_unit": "https://translations.documentfoundation.org/api/units/110801000/?format=api", "priority": 100, "id": 110927599, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=085fc87ea8bcf510", "url": "https://translations.documentfoundation.org/api/units/110927599/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:32.873847Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "Example of Conditional Formatting: Highlighting Totals Above/Under the Average Value" ], "previous_source": "", "target": [ "" ], "id_hash": -4283724277435255355, "content_hash": -4283724277435255355, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\nhd_id3155766\nhelp.text", "note": "xDZ66", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 326, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/110801051/?format=api", "priority": 100, "id": 110927606, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=448d27773fc135c5", "url": "https://translations.documentfoundation.org/api/units/110927606/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:32.877130Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "Step1: Generate Number Values" ], "previous_source": "", "target": [ "" ], "id_hash": 3632842679307342258, "content_hash": 3632842679307342258, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\nhd_id4341868\nhelp.text", "note": "U3jUP", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 327, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/110801080/?format=api", "priority": 100, "id": 110927611, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=b26a732b50fe11b2", "url": "https://translations.documentfoundation.org/api/units/110927611/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:32.879299Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "You want to give certain values in your tables particular emphasis. For example, in a table of turnovers, you can show all the values above the average in green and all those below the average in red. This is possible with conditional formatting." ], "previous_source": "", "target": [ "ཁྱེད་ཀྱིས་ཁྱེད་ཀྱི་ལས་ཁྲའི་ནང་དམིགས་གསལ་དུ་དམིགས་འཛུགས་ཐང་ནན་བཤད་བྱེད་འདོད་ན། དཔེར་ན་ རེའུ་མིག་ནང་ཆ་སྙོམས་ཐང་ཡོད་ཚད་ཡན་ཆད་ལྗང་གུ་ཡིན་པ་གཏན་འབེབས་བྱ་བ་དང་ཆ་སྙོམས་ཐང་ཡོད་ཚད་མན་གྱི་གྲངས་ཐང་དམར་པོར་གཏན་འབེབས་བྱ་བ། དེ་ནི་ཆ་རྐྱེན་རྣམ་གཞག་ཅན་བརྒྱུད་ནས་མངོན་འགྱུར་བྱེད།" ], "id_hash": -4753521984506958934, "content_hash": -4753521984506958934, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3150043\nhelp.text", "note": "5TVr9", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 328, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 43, "source_unit": "https://translations.documentfoundation.org/api/units/110801095/?format=api", "priority": 100, "id": 110927618, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=3e0818f0b973ebaa", "url": "https://translations.documentfoundation.org/api/units/110927618/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:32.882037Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "First of all, create a table in which a few different values occur. For your test you can create tables with any random numbers:" ], "previous_source": "", "target": [ "" ], "id_hash": -4525029402094565778, "content_hash": -4525029402094565778, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3155337\nhelp.text", "note": "9zJa4", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 329, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://translations.documentfoundation.org/api/units/110801126/?format=api", "priority": 100, "id": 110927621, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=4133ddbbc1f4866e", "url": "https://translations.documentfoundation.org/api/units/110927621/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:32.886017Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "In one of the cells enter the formula =RAND(), and you will obtain a random number between 0 and 1. If you want integers of between 0 and 50, enter the formula =INT(RAND()*50)." ], "previous_source": "", "target": [ "དྲ་མིག་གཅིག་ནང་སྤྱི་འགྲོས་ནང་འཇུག་བྱ་ =RAND()ཁྱེད་ལ་ 0 དང་ 1 བར་གྱི་སྐབས་བསྟུན་གྲངས་ཐང་ཤོག་ཐོབ་ཐུབ། གལ་ཏེ་ཁྱེད་ཀྱིས་གྲངས་ཐང་ཡོད་ཚད་ 0 དང་ 50 དུ་གནས་འདོད་ན་སྤྱི་གྲོས་དེ་ནང་འཇུག་བྱ་ =INT(RAND()*50)" ], "id_hash": 7837711463613136779, "content_hash": 7837711463613136779, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3149565\nhelp.text", "note": "A66qh", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 330, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 33, "source_unit": "https://translations.documentfoundation.org/api/units/110801149/?format=api", "priority": 100, "id": 110927625, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=ecc5250cd8aaff8b", "url": "https://translations.documentfoundation.org/api/units/110927625/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:32.890217Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "Copy the formula to create a row of random numbers. Click the bottom right corner of the selected cell, and drag to the right until the desired cell range is selected." ], "previous_source": "", "target": [ "སྤྱི་གྲོས་འདྲ་ཕབ་ཀྱིས་སྐབས་བསྟུན་གྲངས་ཡིག་ཕྲེང་གསར་འཛུགས་བྱེད། བདམས་པའི་དྲ་མིག་གི་གཡོན་གཤམ་ཟུར་ལ་རྐྱང་རྡེབ་དང་སྦྲགས་གཡས་ལ་དྲུད་སྐྱེལ་བྱ་ དགོས་ངེས་ཀྱི་དྲ་མིག་ས་ཁོངས་བདམས་ཟིན་པའི་བར་དུ་དེ་ལྟར་བྱ།" ], "id_hash": 6892568724043407820, "content_hash": 6892568724043407820, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3149258\nhelp.text", "note": "rCrEf", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 331, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 31, "source_unit": "https://translations.documentfoundation.org/api/units/110801186/?format=api", "priority": 100, "id": 110927637, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=dfa752bc729321cc", "url": "https://translations.documentfoundation.org/api/units/110927637/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:32.897877Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "In the same way as described above, drag down the corner of the rightmost cell in order to create more rows of random numbers." ], "previous_source": "", "target": [ "གོང་དུ་བཤད་པ་དང་ཆ་འདྲ་བར་གཡས་གཤམ་ཟུར་གྱི་དྲ་མིག་འོག་ལ་དྲུད་སྒུལ་བྱས་ཏེ་ཕྲེང་མང་སྐབས་བསྟུན་གྲངས་གསར་འཛུགས་བྱེད།" ], "id_hash": -2947348419295557648, "content_hash": -2947348419295557648, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3159236\nhelp.text", "note": "Tm6MA", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 332, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://translations.documentfoundation.org/api/units/110801222/?format=api", "priority": 100, "id": 110927644, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=5718ea3a769447f0", "url": "https://translations.documentfoundation.org/api/units/110927644/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:32.900992Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "Step 2: Define Cell Styles" ], "previous_source": "", "target": [ "" ], "id_hash": 1860090573670708058, "content_hash": 1860090573670708058, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\nhd_id3149211\nhelp.text", "note": "i3CTm", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 333, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/110801240/?format=api", "priority": 100, "id": 110927650, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=99d05e8585b1f35a", "url": "https://translations.documentfoundation.org/api/units/110927650/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:32.903374Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "The next step is to apply a cell style to all values that represent above-average turnover, and one to those that are below the average. Ensure that the Styles window is visible before proceeding." ], "previous_source": "", "target": [ "" ], "id_hash": 2515053443613502634, "content_hash": 2515053443613502634, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3154659\nhelp.text", "note": "sr6WY", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 334, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 34, "source_unit": "https://translations.documentfoundation.org/api/units/110801310/?format=api", "priority": 100, "id": 110927656, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=a2e743c819b4acaa", "url": "https://translations.documentfoundation.org/api/units/110927656/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:32.905345Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "Click in a blank cell and select the command <emph>Format Cells</emph> in the context menu." ], "previous_source": "", "target": [ "དྲ་མིག་སྟོང་པར་རྐྱང་རྡེབ་བྱ་ གཡས་མཐེབ་ཚལ་ཐོ་བཀོལ་སྤྱོད་བྱ་ <emph>དྲ་མིག་རྣམ་གཞག</emph>འདེམས་པ།" ], "id_hash": -6456560012199126547, "content_hash": -6456560012199126547, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3150883\nhelp.text", "note": "CVM3G", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 335, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/110801312/?format=api", "priority": 100, "id": 110927663, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=2665b0e091e119ed", "url": "https://translations.documentfoundation.org/api/units/110927663/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:32.907364Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "In the <emph>Format Cells</emph> dialog on the <emph>Background</emph> tab, click the <emph>Color</emph> button and then select a background color. Click <emph>OK</emph>." ], "previous_source": "", "target": [ "" ], "id_hash": 2960784818159105589, "content_hash": 2960784818159105589, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3155529\nhelp.text", "note": "JZ7gV", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 336, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://translations.documentfoundation.org/api/units/110801362/?format=api", "priority": 100, "id": 110927679, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=a916d21aeebe3635", "url": "https://translations.documentfoundation.org/api/units/110927679/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:32.914196Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "In the Styles deck of the Sidebar, click the <emph>New Style from Selection</emph> icon. Enter the name of the new style. For this example, name the style \"Above\"." ], "previous_source": "", "target": [ "" ], "id_hash": 1194734886532448986, "content_hash": 1194734886532448986, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3154484\nhelp.text", "note": "AwUDA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 337, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 28, "source_unit": "https://translations.documentfoundation.org/api/units/110801378/?format=api", "priority": 100, "id": 110927683, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=90948d0ca08882da", "url": "https://translations.documentfoundation.org/api/units/110927683/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:32.916308Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "To define a second style, click again in a blank cell and proceed as described above. Assign a different background color for the cell and assign a name (for this example, \"Below\")." ], "previous_source": "", "target": [ "བཟོ་ལྟ་གཞན་དག་མཚན་འཇོག་བྱ་དགོས་ན་དྲ་མིག་སྟོང་པ་ལ་བསྐྱར་དུ་རྐྱང་རྡེབ་བྱ་རོགས་ དེ་རྗེས་གོང་གི་བཀོལ་སྤྱོད་བསྐྱར་ཟློས་བྱ། དྲ་མིག་ལ་མི་གཅིག་པའི་རྒྱབ་ལྗོངས་ཚོས་གཞི་དང་མིང་གཏན་འཁེལ་བྱེད་(དཔེ་གཞི་དེའི་ནང་ \"Below\"ལ་གཏན་འཁེལ་བྱ་)" ], "id_hash": 2559261581071111980, "content_hash": 2559261581071111980, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3152889\nhelp.text", "note": "4bRZa", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 338, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 32, "source_unit": "https://translations.documentfoundation.org/api/units/110801395/?format=api", "priority": 100, "id": 110927687, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=a38452d9330c572c", "url": "https://translations.documentfoundation.org/api/units/110927687/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:32.918276Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "Step 3: Calculate Average" ], "previous_source": "", "target": [ "" ], "id_hash": 7675455618679043080, "content_hash": 7675455618679043080, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\nhd_id3148704\nhelp.text", "note": "x3rxG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 339, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/110801420/?format=api", "priority": 100, "id": 110927691, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=ea84b23808a3f408", "url": "https://translations.documentfoundation.org/api/units/110927691/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:32.920658Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "In our particular example, we are calculating the average of the random values. The result is placed in a cell:" ], "previous_source": "", "target": [ "གཤམ་གསལ་གྱི་དམིགས་བསལ་དཔེ་གཞིའི་ནང་སྐབས་བསྟུན་གྲངས་ཐང་གི་ཆ་སྙོམས་ཐང་རྩིས་རྒྱག་བྱེད་པར་འགྱུར་ མ་ཟད་འབྲས་བུ་དེ་དྲ་མིག་ཚིག་ནང་མངོན་པར་འགྱུར།" ], "id_hash": 4578609383930617086, "content_hash": 4578609383930617086, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3148837\nhelp.text", "note": "f5sxG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 340, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/110801430/?format=api", "priority": 100, "id": 110927694, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=bf8a7cf9e6745cfe", "url": "https://translations.documentfoundation.org/api/units/110927694/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:32.922560Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "Set the cursor in a blank cell, for example, J14, and choose <emph>Insert - Function</emph>." ], "previous_source": "", "target": [ "དྲ་མིག་སྟོང་པ་ཞིག་(དཔེར་ན་ J14)ནང་འོད་རྟགས་གནས་ངེས་བྱ་ དེ་རྗེས་<emph>བསྒར་འཛུད་ - རྟེན་གྲངས་</emph>འདེམས་དགོས།" ], "id_hash": -1641327560713127346, "content_hash": -1641327560713127346, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3144768\nhelp.text", "note": "GhHpd", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 341, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/110801474/?format=api", "priority": 100, "id": 110927699, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=6938d54797a2ba4e", "url": "https://translations.documentfoundation.org/api/units/110927699/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:32.924804Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "Select the AVERAGE function. Use the mouse to select all your random numbers. If you cannot see the entire range, because the Function Wizard is obscuring it, you can temporarily shrink the dialog using the <link href=\"text/shared/00/00000001.xhp#shrink_maximize\"><item type=\"menuitem\">Shrink</item></link> icon." ], "previous_source": "", "target": [ "" ], "id_hash": -278745050073292683, "content_hash": -278745050073292683, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3156016\nhelp.text", "note": "xCigs", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 342, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 39, "source_unit": "https://translations.documentfoundation.org/api/units/110801505/?format=api", "priority": 100, "id": 110927723, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=7c21b2da937ba075", "url": "https://translations.documentfoundation.org/api/units/110927723/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:32.934342Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "Close the Function Wizard with <item type=\"menuitem\">OK</item>." ], "previous_source": "", "target": [ "" ], "id_hash": -5015363106791229593, "content_hash": -5015363106791229593, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3153246\nhelp.text", "note": "YEqsh", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 343, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/110801533/?format=api", "priority": 100, "id": 110927727, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=3a65d9d3b01bf767", "url": "https://translations.documentfoundation.org/api/units/110927727/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:32.936083Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "Step 4: Apply Cell Styles" ], "previous_source": "", "target": [ "" ], "id_hash": -6453200130585452393, "content_hash": -6453200130585452393, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\nhd_id3149898\nhelp.text", "note": "75WFf", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 344, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/110801575/?format=api", "priority": 100, "id": 110927730, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=2671a0abf7f32097", "url": "https://translations.documentfoundation.org/api/units/110927730/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:32.937683Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "Now you can apply the conditional formatting to the sheet:" ], "previous_source": "", "target": [ "ད་ཆ་ཆ་རྐྱེན་རྣམ་གཞག་དེ་ཁྱེད་ཀྱི་ལས་ཁྲའི་ནང་སྤྱད་ཆོག" ], "id_hash": 7382243818509673232, "content_hash": 7382243818509673232, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3149126\nhelp.text", "note": "AA6JP", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 345, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/110801602/?format=api", "priority": 100, "id": 110927734, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=e672ffa3df97a310", "url": "https://translations.documentfoundation.org/api/units/110927734/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:32.938861Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "Select all cells with the random numbers." ], "previous_source": "", "target": [ "སྐབས་བསྟུན་གྲངས་ཐང་ལྡན་པའི་དྲ་མིག་ཡོད་ཚད་འདེམས་པ།" ], "id_hash": 7136521799982947324, "content_hash": 7136521799982947324, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3150049\nhelp.text", "note": "7YuzB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 346, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/110801617/?format=api", "priority": 100, "id": 110927737, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=e30a04c423d09bfc", "url": "https://translations.documentfoundation.org/api/units/110927737/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:32.940063Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "Choose the <emph>Format - Conditional - Condition</emph> command to open the corresponding dialog." ], "previous_source": "", "target": [ "" ], "id_hash": -8237515074579478129, "content_hash": -8237515074579478129, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3153801\nhelp.text", "note": "p7dEG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 347, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/110801660/?format=api", "priority": 100, "id": 110927740, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=0dae77af13c3c98f", "url": "https://translations.documentfoundation.org/api/units/110927740/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:32.941250Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "Define the condition as follows: If cell value is less than J14, format with cell style \"Below\", and if cell value is greater than or equal to J14, format with cell style \"Above\"." ], "previous_source": "", "target": [ "གཤམ་གསལ་མཚན་འཇོག་ཆ་རྐྱེན་གཞིར་བཟུང་ དྲ་མིག་གྲངས་ཐང་ J14 ལས་ཆུང་བའི་སྐབས་\"དེ་འོག་\"དྲ་མིག་བཟོ་ལྟ་རྣམ་གཞག་ཅན་སྤྱོད། དྲ་མིག་གྲངས་ཐང་ J14 ལས་ཆེ་བའམ་མཚུངས་པའི་སྐབས་\"དེ་སྟེང་\" དྲ་མིག་བཟོ་ལྟ་རྣམ་གཞག་ཅན་སྤྱོད།" ], "id_hash": -3867351834357650696, "content_hash": -3867351834357650696, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3153013\nhelp.text", "note": "oaUQo", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 348, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 33, "source_unit": "https://translations.documentfoundation.org/api/units/110801685/?format=api", "priority": 100, "id": 110927746, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=4a5467ff2ba82af8", "url": "https://translations.documentfoundation.org/api/units/110927746/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:32.942503Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "Step 5: Copy Cell Style" ], "previous_source": "", "target": [ "" ], "id_hash": 6888277942235367290, "content_hash": 6888277942235367290, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\nhd_id3155761\nhelp.text", "note": "p9FR7", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 349, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/110801727/?format=api", "priority": 100, "id": 110927752, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=df98144af519077a", "url": "https://translations.documentfoundation.org/api/units/110927752/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:32.944269Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/bo/?format=api", "source": [ "To apply the conditional formatting to other cells later:" ], "previous_source": "", "target": [ "ཆ་རྐྱེན་རྣམ་གཞག་དེ་དྲ་མིག་གཞན་ཞིག་ལ་སྤྱོད་པར་འགྱུར།" ], "id_hash": -7215413165649662082, "content_hash": -7215413165649662082, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3145320\nhelp.text", "note": "GBgrB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 350, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/110801777/?format=api", "priority": 100, "id": 110927756, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/bo/?checksum=1bddb3f469c66f7e", "url": "https://translations.documentfoundation.org/api/units/110927756/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:28:32.945927Z" } ] }{ "count": 1558, "next": "