Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-7-6/textscalcguide/ast/units/?format=api&page=7
{ "count": 1558, "next": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/units/?format=api&page=8", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/units/?format=api&page=6", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?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": [ "En <switchinline select=\"sys\"><caseinline select=\"MAC\">%PRODUCTNAME - Preferencies</caseinline><defaultinline>Ferramientes - Opciones</defaultinline></switchinline> - <link href=\"text/shared/optionen/01040900.xhp\"><item type=\"menuitem\">%PRODUCTNAME Calc - Xeneral</item></link> pue escoyer realizar l'anovación al abrir el documentu en forma automática, bien siempres, a pidimientu o nunca. L'anovación pue empecipiase de forma manual nel diálogu accesible en <item type=\"menuitem\">Editar - Enllaces</item>." ], "id_hash": -3243156950039999989, "content_hash": -3243156950039999989, "location": "cellreferences_url.xhp", "context": "cellreferences_url.xhp\npar_id3159204\nhelp.text", "note": "tapEk", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "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/99014589/?format=api", "priority": 100, "id": 99082324, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=52fdfdefda06ca0b", "url": "https://translations.documentfoundation.org/api/units/99082324/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:02.621360Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?format=api", "source": [ "Assigning Formats by Formula" ], "previous_source": "", "target": [ "Asignar formatu por aciu fórmules" ], "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/99014615/?format=api", "priority": 100, "id": 99082330, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=4de6da9556858af2", "url": "https://translations.documentfoundation.org/api/units/99082330/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:02.623824Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?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>formatos; asignar por aciu fórmules</bookmark_value> <bookmark_value>formatos de caxella; asignar por aciu fórmules</bookmark_value> <bookmark_value>exemplu de función ESTILO</bookmark_value> <bookmark_value>estilos de caxella;asignar por aciu fórmules</bookmark_value> <bookmark_value>fórmules;asignar formatos de caxella</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": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/99014652/?format=api", "priority": 100, "id": 99082335, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=82481b247d0154e3", "url": "https://translations.documentfoundation.org/api/units/99082335/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:02.625594Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?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\">Asignar Formatos por aciu Formula</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/99014678/?format=api", "priority": 100, "id": 99082341, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=e763b0bf2b4f1087", "url": "https://translations.documentfoundation.org/api/units/99082341/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:02.627823Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?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": [ "La función ESTILU() pue amestase a una fórmula d'una caxella. Por exemplu, en combinación cola función ACTUAL, pue asignase'l color a una caxella según el so valor. La fórmula =... + ESTILU(SI(ACTUAL()>3;\"Coloráu\";\"Verde\")) aplica l'estilu \"Coloráu\" a la caxella si'l valor ye mayor que 3; si ye menor, aplícase l'estilu \"Verde\"." ], "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/99014695/?format=api", "priority": 100, "id": 99082349, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=b134dd0520be9b33", "url": "https://translations.documentfoundation.org/api/units/99082349/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:02.629986Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?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": [ "Si desea aplicar una fórmula a toles caxelles d'un área escoyida, pue usar el cuadru de diálogu <item type=\"menuitem\">Guetar y trocar</item>." ], "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/99014713/?format=api", "priority": 100, "id": 99082357, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=c0b4844f2d3904bf", "url": "https://translations.documentfoundation.org/api/units/99082357/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:02.632145Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?format=api", "source": [ "Select all the desired cells." ], "previous_source": "", "target": [ "Escueya toles caxelles deseyaes." ], "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/99014759/?format=api", "priority": 100, "id": 99082364, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=1226cc504b83cf52", "url": "https://translations.documentfoundation.org/api/units/99082364/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:02.634428Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?format=api", "source": [ "Select the menu command <emph>Edit - Find & Replace</emph>." ], "previous_source": "", "target": [ "Escueya la orde de menú <emph>Editar - Guetar y trocar</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/99014767/?format=api", "priority": 100, "id": 99082371, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=4a46884ecf40e776", "url": "https://translations.documentfoundation.org/api/units/99082371/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:02.636240Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?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/99014783/?format=api", "priority": 100, "id": 99082380, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=4ed77e977626b309", "url": "https://translations.documentfoundation.org/api/units/99082380/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:02.638313Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?format=api", "source": [ "\".*\" is a regular expression that designates the contents of the current cell." ], "previous_source": "", "target": [ "«.*» ye una espresión regular que designa'l conteníu de la caxella actual." ], "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/99014794/?format=api", "priority": 100, "id": 99082387, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=9f3b3c87521af963", "url": "https://translations.documentfoundation.org/api/units/99082387/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:02.639955Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?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/99014812/?format=api", "priority": 100, "id": 99082395, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=e8fbcdbae16d1679", "url": "https://translations.documentfoundation.org/api/units/99082395/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:02.641789Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?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/99014842/?format=api", "priority": 100, "id": 99082401, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=9feeee1b0e9df12e", "url": "https://translations.documentfoundation.org/api/units/99082401/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:02.643400Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?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": [ "Escueya les opciones <link href=\"text/shared/01/02100000.xhp\"><emph>Espresión regular</emph></link> y <emph>Namái na seleición</emph>. Calque <emph>Guetar too</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/99014854/?format=api", "priority": 100, "id": 99082408, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=f92e382bac09a80f", "url": "https://translations.documentfoundation.org/api/units/99082408/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:02.645127Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?format=api", "source": [ "All cells with contents that were included in the selection are now highlighted." ], "previous_source": "", "target": [ "Toles caxelles con conteníu que s'atopaben na seleición van apaecer agora destacaes." ], "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/99014868/?format=api", "priority": 100, "id": 99082418, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=f0bc97c2236b1699", "url": "https://translations.documentfoundation.org/api/units/99082418/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:02.647311Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?format=api", "source": [ "Click <item type=\"menuitem\">Replace all</item>." ], "previous_source": "", "target": [ "Calca <item type=\"menuitem\">Trocalo too</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/99014885/?format=api", "priority": 100, "id": 99082425, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=da2b7b825fe32500", "url": "https://translations.documentfoundation.org/api/units/99082425/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:02.649355Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?format=api", "source": [ "Applying Conditional Formatting" ], "previous_source": "", "target": [ "Aplicar formatu condicionáu" ], "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/99014903/?format=api", "priority": 100, "id": 99082432, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=c3b482912d3b99fd", "url": "https://translations.documentfoundation.org/api/units/99082432/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:02.651554Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?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>formatu condicional; caxelles</bookmark_value> <bookmark_value>caxelles; formatu condicional</bookmark_value> <bookmark_value>formatu; formatu condicional</bookmark_value> <bookmark_value>estilos;estilos condicionales</bookmark_value> <bookmark_value>formatos; condicionales</bookmark_value> <bookmark_value>númberos aleatorios;exemplos</bookmark_value> <bookmark_value>estilos de caxella; copiar</bookmark_value> <bookmark_value>copiar; estilos de caxella</bookmark_value> <bookmark_value>tables; copiar estilos de caxella</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": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/99014929/?format=api", "priority": 100, "id": 99082445, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=7c1e116e5ec0518a", "url": "https://translations.documentfoundation.org/api/units/99082445/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:02.655096Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?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\">Aplicar formatu condicionáu</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/99014949/?format=api", "priority": 100, "id": 99082454, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=a0856a6ab1c1749d", "url": "https://translations.documentfoundation.org/api/units/99082454/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:02.657514Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?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/99014971/?format=api", "priority": 100, "id": 99082459, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=b3fb07e4d332fde2", "url": "https://translations.documentfoundation.org/api/units/99082459/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:02.659094Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?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": [ "P'aplicar formatu condicionáu, tien d'habilitar la función Cálculu automáticu. Escueya <emph>Ferramientes - Conteníu de les caxelles - Calcular automáticamente</emph> (apaez una marca de verificación xuntu al comandu cuando la función de cálculu automáticu ta activada)." ], "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": false, "num_words": 27, "source_unit": "https://translations.documentfoundation.org/api/units/99015010/?format=api", "priority": 100, "id": 99082465, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=16731e63410f3617", "url": "https://translations.documentfoundation.org/api/units/99082465/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:02.660289Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?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": [ "El formatu condicionáu dexa, por exemplu, destacar los totales que tán percima del permediu de tolos totales. Si los totales camuden, el formatu camuda según correspuenda, ensin necesidá d'aplicar otros estilos de forma manual." ], "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/99015025/?format=api", "priority": 100, "id": 99082472, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=b73c7349c9ce625f", "url": "https://translations.documentfoundation.org/api/units/99082472/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:02.662135Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?format=api", "source": [ "To Define the Conditions" ], "previous_source": "", "target": [ "Pa definir les condiciones" ], "id_hash": 4295185402721551039, "content_hash": 4295185402721551039, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\nhd_id4480727\nhelp.text", "note": "Zn2cD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "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/99015034/?format=api", "priority": 100, "id": 99082479, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=bb9b905deda942bf", "url": "https://translations.documentfoundation.org/api/units/99082479/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:02.663875Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?format=api", "source": [ "Select the cells to which you want to apply a conditional style." ], "previous_source": "", "target": [ "Esbilla les caxelles que tengan de tener un formatu condicionáu." ], "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/99015043/?format=api", "priority": 100, "id": 99082486, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=e50f059631dcba07", "url": "https://translations.documentfoundation.org/api/units/99082486/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:02.665315Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?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/99015052/?format=api", "priority": 100, "id": 99082492, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=9b40bebd546639ad", "url": "https://translations.documentfoundation.org/api/units/99082492/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:02.667128Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?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": [ "Escriba les condiciones nel diálogu. Pue ver una descripción detallada del diálogu na <link href=\"text/scalc/01/05120000.xhp\">Ayuda de $[officename]</link>; de siguío amuésase un exemplu:" ], "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/99015062/?format=api", "priority": 100, "id": 99082499, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=085fc87ea8bcf510", "url": "https://translations.documentfoundation.org/api/units/99082499/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:02.668663Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?format=api", "source": [ "Example of Conditional Formatting: Highlighting Totals Above/Under the Average Value" ], "previous_source": "", "target": [ "Exemplu de formatu condicional: Resaltar los totales percima/debaxo del valor permediu" ], "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/99015066/?format=api", "priority": 100, "id": 99082506, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=448d27773fc135c5", "url": "https://translations.documentfoundation.org/api/units/99082506/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:02.670724Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?format=api", "source": [ "Step1: Generate Number Values" ], "previous_source": "", "target": [ "Pasu 1: Xenerar valores numbéricos" ], "id_hash": 3632842679307342258, "content_hash": 3632842679307342258, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\nhd_id4341868\nhelp.text", "note": "U3jUP", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "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/99015113/?format=api", "priority": 100, "id": 99082517, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=b26a732b50fe11b2", "url": "https://translations.documentfoundation.org/api/units/99082517/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:02.745433Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?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": [ "Quiciabes deseye destacar de forma especial determinaos valores de la fueya, por exemplu, nuna fueya de cifres de vientes, los valores que tean sobre la media en verde y en colloráu los que tean per debaxo. Col formateáu condicionáu nun va haber problema." ], "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/99015121/?format=api", "priority": 100, "id": 99082525, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=3e0818f0b973ebaa", "url": "https://translations.documentfoundation.org/api/units/99082525/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:02.748897Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?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/99015146/?format=api", "priority": 100, "id": 99082534, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=4133ddbbc1f4866e", "url": "https://translations.documentfoundation.org/api/units/99082534/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:02.751572Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?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": [ "Introduza nuna caxella la fórmula ALEATORIU() pa tener un númberu ente 0 y 1. Si deseya númberos enteros ente 0 y 50, introduza como fórmula =ENTERU(ALEATORIU()*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/99015172/?format=api", "priority": 100, "id": 99082541, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=ecc5250cd8aaff8b", "url": "https://translations.documentfoundation.org/api/units/99082541/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:02.753452Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?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": [ "Copie la fórmula pa crear una filera de númberos aleatorios. Faiga clic na esquina inferior derecha de la caxella escoyida y arrastre escontra la derecha hasta escoyer l'área deseyada." ], "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/99015189/?format=api", "priority": 100, "id": 99082550, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=dfa752bc729321cc", "url": "https://translations.documentfoundation.org/api/units/99082550/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:02.755328Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?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": [ "De forma similar, arrastre la esquina de la caxella hasta la parte inferior derecha pa crear más files de númberos aleatorios." ], "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/99015208/?format=api", "priority": 100, "id": 99082557, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=5718ea3a769447f0", "url": "https://translations.documentfoundation.org/api/units/99082557/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:02.756916Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?format=api", "source": [ "Step 2: Define Cell Styles" ], "previous_source": "", "target": [ "Pasu 2: Definir estilos de caxella" ], "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/99015231/?format=api", "priority": 100, "id": 99082563, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=99d05e8585b1f35a", "url": "https://translations.documentfoundation.org/api/units/99082563/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:02.758344Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?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/99015250/?format=api", "priority": 100, "id": 99082570, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=a2e743c819b4acaa", "url": "https://translations.documentfoundation.org/api/units/99082570/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:02.759870Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?format=api", "source": [ "Click in a blank cell and select the command <emph>Format Cells</emph> in the context menu." ], "previous_source": "", "target": [ "Faiga clic nuna caxella balera, active'l menú contestual y escueya <emph>Formatear caxelles</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/99015273/?format=api", "priority": 100, "id": 99082576, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=2665b0e091e119ed", "url": "https://translations.documentfoundation.org/api/units/99082576/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:02.761346Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?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/99015295/?format=api", "priority": 100, "id": 99082585, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=a916d21aeebe3635", "url": "https://translations.documentfoundation.org/api/units/99082585/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:02.763083Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?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/99015307/?format=api", "priority": 100, "id": 99082591, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=90948d0ca08882da", "url": "https://translations.documentfoundation.org/api/units/99082591/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:02.764470Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?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": [ "Pa definir otru estilu vuelva calcar na caxella balera y siga de nuevu'l procesu descritu. Asigne un color de fondu distintu a la caxella y asigne un nome (nesti exemplu, \"Menor que\")." ], "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/99015310/?format=api", "priority": 100, "id": 99082594, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=a38452d9330c572c", "url": "https://translations.documentfoundation.org/api/units/99082594/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:02.765804Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?format=api", "source": [ "Step 3: Calculate Average" ], "previous_source": "", "target": [ "Pasu 3: calcular el permediu" ], "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/99015348/?format=api", "priority": 100, "id": 99082603, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=ea84b23808a3f408", "url": "https://translations.documentfoundation.org/api/units/99082603/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:02.767587Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?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": [ "Nel nuesu exemplu tenemos de calcular el permediu de los valores aleatorios. El resultáu asítiase nuna caxella:" ], "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/99015365/?format=api", "priority": 100, "id": 99082610, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=bf8a7cf9e6745cfe", "url": "https://translations.documentfoundation.org/api/units/99082610/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:02.769239Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?format=api", "source": [ "Set the cursor in a blank cell, for example, J14, and choose <emph>Insert - Function</emph>." ], "previous_source": "", "target": [ "Asitie'l cursor nuna caxella balera, por exemplu, J14, y escueya <emph>Inxertar - Función</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/99015390/?format=api", "priority": 100, "id": 99082617, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=6938d54797a2ba4e", "url": "https://translations.documentfoundation.org/api/units/99082617/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:02.770756Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?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/99015407/?format=api", "priority": 100, "id": 99082626, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=7c21b2da937ba075", "url": "https://translations.documentfoundation.org/api/units/99082626/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:02.772965Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?format=api", "source": [ "Close the Function Wizard with <item type=\"menuitem\">OK</item>." ], "previous_source": "", "target": [ "Faiga clic en <item type=\"menuitem\">Aceutar</item> pa zarrar l'Asistente pa funciones." ], "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": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/99015437/?format=api", "priority": 100, "id": 99082635, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=3a65d9d3b01bf767", "url": "https://translations.documentfoundation.org/api/units/99082635/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:02.774602Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?format=api", "source": [ "Step 4: Apply Cell Styles" ], "previous_source": "", "target": [ "Pasu 4: Aplicar estilos de caxella" ], "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/99015450/?format=api", "priority": 100, "id": 99082642, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=2671a0abf7f32097", "url": "https://translations.documentfoundation.org/api/units/99082642/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:02.776541Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?format=api", "source": [ "Now you can apply the conditional formatting to the sheet:" ], "previous_source": "", "target": [ "Agora namá-y queda aplicar el formateáu condicionáu a la fueya:" ], "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/99015496/?format=api", "priority": 100, "id": 99082650, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=e672ffa3df97a310", "url": "https://translations.documentfoundation.org/api/units/99082650/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:02.778165Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?format=api", "source": [ "Select all cells with the random numbers." ], "previous_source": "", "target": [ "Marque toles caxelles que contengan valores aleatorios." ], "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/99015533/?format=api", "priority": 100, "id": 99082656, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=e30a04c423d09bfc", "url": "https://translations.documentfoundation.org/api/units/99082656/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:02.779590Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?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/99015577/?format=api", "priority": 100, "id": 99082664, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=0dae77af13c3c98f", "url": "https://translations.documentfoundation.org/api/units/99082664/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:02.781120Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?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": [ "Escueya agora como condiciones: Si'l valor de la caxella ye menor que J14, aplicar el formatu \"Embaxo\", y si ye mayor o igual, el formatu \"Enriba\"." ], "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/99015608/?format=api", "priority": 100, "id": 99082670, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=4a5467ff2ba82af8", "url": "https://translations.documentfoundation.org/api/units/99082670/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:02.782597Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?format=api", "source": [ "Step 5: Copy Cell Style" ], "previous_source": "", "target": [ "Pasu 5: Copiar estilu de caxella" ], "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/99015642/?format=api", "priority": 100, "id": 99082678, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=df98144af519077a", "url": "https://translations.documentfoundation.org/api/units/99082678/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:02.784456Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/ast/?format=api", "source": [ "To apply the conditional formatting to other cells later:" ], "previous_source": "", "target": [ "Aplicar darréu'l formateáu condicionáu a otres caxelles:" ], "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/99015664/?format=api", "priority": 100, "id": 99082683, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/ast/?checksum=1bddb3f469c66f7e", "url": "https://translations.documentfoundation.org/api/units/99082683/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:02.786283Z" } ] }