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/he/units/?format=api&page=7
https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/units/?format=api&page=8", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/units/?format=api&page=6", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?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": 111259714, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=52fdfdefda06ca0b", "url": "https://translations.documentfoundation.org/api/units/111259714/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:38.102865Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?format=api", "source": [ "Assigning Formats by Formula" ], "previous_source": "", "target": [ "Assigning Formats by Formula" ], "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": true, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/110800427/?format=api", "priority": 100, "id": 111259715, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=4de6da9556858af2", "url": "https://translations.documentfoundation.org/api/units/111259715/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:38.104484Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?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\\>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\\>\\<bookmark_value\\>applying;cell formats\\</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": 111259716, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=82481b247d0154e3", "url": "https://translations.documentfoundation.org/api/units/111259716/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:38.106393Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?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": [ "" ], "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": 0, "fuzzy": false, "translated": false, "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": 111259717, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=e763b0bf2b4f1087", "url": "https://translations.documentfoundation.org/api/units/111259717/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:38.108676Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?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": [ "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." ], "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": true, "num_words": 55, "source_unit": "https://translations.documentfoundation.org/api/units/110800431/?format=api", "priority": 100, "id": 111259718, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=b134dd0520be9b33", "url": "https://translations.documentfoundation.org/api/units/111259718/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:38.110124Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?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": [ "If you would like to apply a formula to all cells in a selected area, you can use the\\<emph\\> Find & Replace\\</emph\\> dialog." ], "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": 111259719, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=c0b4844f2d3904bf", "url": "https://translations.documentfoundation.org/api/units/111259719/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:38.112236Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?format=api", "source": [ "Select all the desired cells." ], "previous_source": "", "target": [ "Select all the desired cells." ], "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": true, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/110800433/?format=api", "priority": 100, "id": 111259720, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=1226cc504b83cf52", "url": "https://translations.documentfoundation.org/api/units/111259720/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:38.115674Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?format=api", "source": [ "Select the menu command <emph>Edit - Find & Replace</emph>." ], "previous_source": "", "target": [ "Select the menu command \\<emph\\>Edit - Find & Replace\\</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": 111259721, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=4a46884ecf40e776", "url": "https://translations.documentfoundation.org/api/units/111259721/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:38.117984Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?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": 111259722, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=4ed77e977626b309", "url": "https://translations.documentfoundation.org/api/units/111259722/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:38.119788Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?format=api", "source": [ "\".*\" is a regular expression that designates the contents of the current cell." ], "previous_source": "", "target": [ "\".*\" is a regular expression that designates the contents of the current cell." ], "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": true, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/110800475/?format=api", "priority": 100, "id": 111259723, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=9f3b3c87521af963", "url": "https://translations.documentfoundation.org/api/units/111259723/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:38.121227Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?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": 111259724, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=e8fbcdbae16d1679", "url": "https://translations.documentfoundation.org/api/units/111259724/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:38.123193Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?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": 111259725, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=9feeee1b0e9df12e", "url": "https://translations.documentfoundation.org/api/units/111259725/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:38.124628Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?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": [ "" ], "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": 0, "fuzzy": false, "translated": false, "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": 111259726, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=f92e382bac09a80f", "url": "https://translations.documentfoundation.org/api/units/111259726/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:38.126234Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?format=api", "source": [ "All cells with contents that were included in the selection are now highlighted." ], "previous_source": "", "target": [ "All cells with contents that were included in the selection are now highlighted." ], "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": true, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/110800631/?format=api", "priority": 100, "id": 111259727, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=f0bc97c2236b1699", "url": "https://translations.documentfoundation.org/api/units/111259727/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:38.127849Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?format=api", "source": [ "Click <item type=\"menuitem\">Replace all</item>." ], "previous_source": "", "target": [ "Click \\<emph\\>Open\\</emph\\>." ], "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": true, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/110800640/?format=api", "priority": 100, "id": 111259728, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=da2b7b825fe32500", "url": "https://translations.documentfoundation.org/api/units/111259728/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:38.130018Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?format=api", "source": [ "Applying Conditional Formatting" ], "previous_source": "", "target": [ "Applying Conditional Formatting" ], "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": true, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/110800686/?format=api", "priority": 100, "id": 111259729, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=c3b482912d3b99fd", "url": "https://translations.documentfoundation.org/api/units/111259729/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:38.132431Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?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\\>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\\>formats; conditional\\</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\\>" ], "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": 111259730, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=7c1e116e5ec0518a", "url": "https://translations.documentfoundation.org/api/units/111259730/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:38.134677Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?format=api", "source": [ "<variable id=\"cellstyle_conditional\"><link href=\"text/scalc/guide/cellstyle_conditional.xhp\">Applying Conditional Formatting</link></variable>" ], "previous_source": "", "target": [ "" ], "id_hash": 2343396187597534365, "content_hash": 2343396187597534365, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\nhd_id3149263\nhelp.text", "note": "WX8sY", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 111259744, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=a0856a6ab1c1749d", "url": "https://translations.documentfoundation.org/api/units/111259744/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:38.147633Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?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": 111259750, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=b3fb07e4d332fde2", "url": "https://translations.documentfoundation.org/api/units/111259750/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:38.151373Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?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": [ "To apply conditional formatting, AutoCalculate must be enabled. Choose \\<emph\\>Tools - Cell Contents - AutoCalculate\\</emph\\> (you see a check mark next to the command when AutoCalculate is enabled)." ], "id_hash": -7605701934056524265, "content_hash": -7605701934056524265, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id8039796\nhelp.text", "note": "SbhJy", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 320, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 27, "source_unit": "https://translations.documentfoundation.org/api/units/110800834/?format=api", "priority": 100, "id": 111259755, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=16731e63410f3617", "url": "https://translations.documentfoundation.org/api/units/111259755/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:38.153401Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?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": [ "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." ], "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": true, "num_words": 33, "source_unit": "https://translations.documentfoundation.org/api/units/110800883/?format=api", "priority": 100, "id": 111259757, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=b73c7349c9ce625f", "url": "https://translations.documentfoundation.org/api/units/111259757/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:38.156458Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?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": 111259762, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=bb9b905deda942bf", "url": "https://translations.documentfoundation.org/api/units/111259762/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:38.159330Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?format=api", "source": [ "Select the cells to which you want to apply a conditional style." ], "previous_source": "", "target": [ "Select the cells to which you want to apply a conditional style." ], "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": true, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/110800943/?format=api", "priority": 100, "id": 111259765, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=e50f059631dcba07", "url": "https://translations.documentfoundation.org/api/units/111259765/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:38.161165Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?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": 111259771, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=9b40bebd546639ad", "url": "https://translations.documentfoundation.org/api/units/111259771/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:38.163694Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?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": [ "" ], "id_hash": -8619950715441449712, "content_hash": -8619950715441449712, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3146969\nhelp.text", "note": "AnNxD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 111259775, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=085fc87ea8bcf510", "url": "https://translations.documentfoundation.org/api/units/111259775/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:38.165355Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?format=api", "source": [ "Example of Conditional Formatting: Highlighting Totals Above/Under the Average Value" ], "previous_source": "", "target": [ "Example of Conditional Formatting: Generate Number Values" ], "id_hash": -4283724277435255355, "content_hash": -4283724277435255355, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\nhd_id3155766\nhelp.text", "note": "xDZ66", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "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": 111259779, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=448d27773fc135c5", "url": "https://translations.documentfoundation.org/api/units/111259779/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:38.167126Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?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": 111259783, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=b26a732b50fe11b2", "url": "https://translations.documentfoundation.org/api/units/111259783/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:38.169092Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?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": [ "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." ], "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": true, "num_words": 43, "source_unit": "https://translations.documentfoundation.org/api/units/110801095/?format=api", "priority": 100, "id": 111259785, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=3e0818f0b973ebaa", "url": "https://translations.documentfoundation.org/api/units/111259785/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:38.170883Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?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": 111259790, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=4133ddbbc1f4866e", "url": "https://translations.documentfoundation.org/api/units/111259790/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:38.173680Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?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": [ "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)." ], "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": true, "num_words": 33, "source_unit": "https://translations.documentfoundation.org/api/units/110801149/?format=api", "priority": 100, "id": 111259795, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=ecc5250cd8aaff8b", "url": "https://translations.documentfoundation.org/api/units/111259795/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:38.175469Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?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": [ "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." ], "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": true, "num_words": 31, "source_unit": "https://translations.documentfoundation.org/api/units/110801186/?format=api", "priority": 100, "id": 111259801, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=dfa752bc729321cc", "url": "https://translations.documentfoundation.org/api/units/111259801/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:38.178086Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?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": [ "In the same way as described above, drag down the corner of the rightmost cell in order to create more rows of random numbers." ], "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": true, "num_words": 24, "source_unit": "https://translations.documentfoundation.org/api/units/110801222/?format=api", "priority": 100, "id": 111259809, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=5718ea3a769447f0", "url": "https://translations.documentfoundation.org/api/units/111259809/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:38.180725Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?format=api", "source": [ "Step 2: Define Cell Styles" ], "previous_source": "", "target": [ "Example of Conditional Formatting: Define Cell Styles" ], "id_hash": 1860090573670708058, "content_hash": 1860090573670708058, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\nhd_id3149211\nhelp.text", "note": "i3CTm", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "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": 111259814, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=99d05e8585b1f35a", "url": "https://translations.documentfoundation.org/api/units/111259814/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:38.182555Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?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": 111259821, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=a2e743c819b4acaa", "url": "https://translations.documentfoundation.org/api/units/111259821/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:38.185385Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?format=api", "source": [ "Click in a blank cell and select the command <emph>Format Cells</emph> in the context menu." ], "previous_source": "", "target": [ "Click in a blank cell and select the command \\<emph\\>Format Cells\\</emph\\> in the context menu." ], "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": true, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/110801312/?format=api", "priority": 100, "id": 111259826, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=2665b0e091e119ed", "url": "https://translations.documentfoundation.org/api/units/111259826/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:38.186873Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?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": 111259831, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=a916d21aeebe3635", "url": "https://translations.documentfoundation.org/api/units/111259831/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:38.188777Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?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": 111259835, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=90948d0ca08882da", "url": "https://translations.documentfoundation.org/api/units/111259835/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:38.190118Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?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": [ "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\")." ], "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": true, "num_words": 32, "source_unit": "https://translations.documentfoundation.org/api/units/110801395/?format=api", "priority": 100, "id": 111259840, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=a38452d9330c572c", "url": "https://translations.documentfoundation.org/api/units/111259840/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:38.191537Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?format=api", "source": [ "Step 3: Calculate Average" ], "previous_source": "", "target": [ "Example of Conditional Formatting: Calculate Average" ], "id_hash": 7675455618679043080, "content_hash": 7675455618679043080, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\nhd_id3148704\nhelp.text", "note": "x3rxG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "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": 111259845, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=ea84b23808a3f408", "url": "https://translations.documentfoundation.org/api/units/111259845/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:38.193709Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?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": [ "In our particular example, we are calculating the average of the random values. The result is placed in a cell:" ], "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": true, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/110801430/?format=api", "priority": 100, "id": 111259850, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=bf8a7cf9e6745cfe", "url": "https://translations.documentfoundation.org/api/units/111259850/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:38.195219Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?format=api", "source": [ "Set the cursor in a blank cell, for example, J14, and choose <emph>Insert - Function</emph>." ], "previous_source": "", "target": [ "Set the cursor in a blank cell, for example, J14, and choose \\<emph\\>Insert - Function\\</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": true, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/110801474/?format=api", "priority": 100, "id": 111259861, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=6938d54797a2ba4e", "url": "https://translations.documentfoundation.org/api/units/111259861/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:38.325748Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?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": 111259871, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=7c21b2da937ba075", "url": "https://translations.documentfoundation.org/api/units/111259871/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:38.333858Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?format=api", "source": [ "Close the Function Wizard with <item type=\"menuitem\">OK</item>." ], "previous_source": "", "target": [ "Close Function Wizard with \\<emph\\>OK\\</emph\\>." ], "id_hash": -5015363106791229593, "content_hash": -5015363106791229593, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3153246\nhelp.text", "note": "YEqsh", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 343, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/110801533/?format=api", "priority": 100, "id": 111259874, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=3a65d9d3b01bf767", "url": "https://translations.documentfoundation.org/api/units/111259874/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:38.336091Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?format=api", "source": [ "Step 4: Apply Cell Styles" ], "previous_source": "", "target": [ "Example of Conditional Formatting: Apply Cell Style" ], "id_hash": -6453200130585452393, "content_hash": -6453200130585452393, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\nhd_id3149898\nhelp.text", "note": "75WFf", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "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": 111259879, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=2671a0abf7f32097", "url": "https://translations.documentfoundation.org/api/units/111259879/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:38.339569Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?format=api", "source": [ "Now you can apply the conditional formatting to the sheet:" ], "previous_source": "", "target": [ "Now you can apply the conditional formatting to the sheet:" ], "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": true, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/110801602/?format=api", "priority": 100, "id": 111259883, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=e672ffa3df97a310", "url": "https://translations.documentfoundation.org/api/units/111259883/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:38.341913Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?format=api", "source": [ "Select all cells with the random numbers." ], "previous_source": "", "target": [ "Select all cells with the random numbers." ], "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": true, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/110801617/?format=api", "priority": 100, "id": 111259889, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=e30a04c423d09bfc", "url": "https://translations.documentfoundation.org/api/units/111259889/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:38.344566Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?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": 111259894, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=0dae77af13c3c98f", "url": "https://translations.documentfoundation.org/api/units/111259894/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:38.346949Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?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": [ "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\"." ], "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": true, "num_words": 33, "source_unit": "https://translations.documentfoundation.org/api/units/110801685/?format=api", "priority": 100, "id": 111259899, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=4a5467ff2ba82af8", "url": "https://translations.documentfoundation.org/api/units/111259899/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:38.348425Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?format=api", "source": [ "Step 5: Copy Cell Style" ], "previous_source": "", "target": [ "Example of Conditional Formatting: Copy Cell Style" ], "id_hash": 6888277942235367290, "content_hash": 6888277942235367290, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\nhd_id3155761\nhelp.text", "note": "p9FR7", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "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": 111259906, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=df98144af519077a", "url": "https://translations.documentfoundation.org/api/units/111259906/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:38.350896Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/he/?format=api", "source": [ "To apply the conditional formatting to other cells later:" ], "previous_source": "", "target": [ "To apply the conditional formatting to other cells later:" ], "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": true, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/110801777/?format=api", "priority": 100, "id": 111259911, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/he/?checksum=1bddb3f469c66f7e", "url": "https://translations.documentfoundation.org/api/units/111259911/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:38:38.352733Z" } ] }{ "count": 1558, "next": "