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/ca/units/?format=api&page=7
{ "count": 1558, "next": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/units/?format=api&page=8", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/units/?format=api&page=6", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?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": [ "A <switchinline select=\"sys\"><caseinline select=\"MAC\">%PRODUCTNAME ▸ Preferències</caseinline><defaultinline>Eines ▸ Opcions</defaultinline></switchinline> ▸ <link href=\"text/shared/optionen/01040900.xhp\"><item type=\"menuitem\">%PRODUCTNAME Calc ▸ General</item></link> podeu triar que l'actualització es dugui a terme sempre, a petició o mai. L'actualització es pot iniciar manualment en el diàleg <item type=\"menuitem\">Edita ▸ Enllaços</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/110800389/?format=api", "priority": 100, "id": 110966274, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=52fdfdefda06ca0b", "url": "https://translations.documentfoundation.org/api/units/110966274/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:40.661026Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?format=api", "source": [ "Assigning Formats by Formula" ], "previous_source": "", "target": [ "Assignació de formats per fórmula" ], "id_hash": -3609957716354299150, "content_hash": -3609957716354299150, "location": "cellstyle_by_formula.xhp", "context": "cellstyle_by_formula.xhp\ntit\nhelp.text", "note": "4DFzJ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 302, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/110800427/?format=api", "priority": 100, "id": 110966277, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=4de6da9556858af2", "url": "https://translations.documentfoundation.org/api/units/110966277/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:40.662727Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?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; assignació per fórmules</bookmark_value><bookmark_value>formats de cel·la; assignació per fórmules</bookmark_value><bookmark_value>exemple de la funció ESTIL</bookmark_value><bookmark_value>estils de cel·la;assignació per fórmules</bookmark_value><bookmark_value>fórmules;assignació de formats de cel·la</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/110800429/?format=api", "priority": 100, "id": 110966280, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=82481b247d0154e3", "url": "https://translations.documentfoundation.org/api/units/110966280/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:40.664115Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?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\">Assignació de formats per fórmula</link></variable>" ], "id_hash": 7449992543712776327, "content_hash": 7449992543712776327, "location": "cellstyle_by_formula.xhp", "context": "cellstyle_by_formula.xhp\nhd_id3145673\nhelp.text", "note": "x3HG2", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 304, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/110800430/?format=api", "priority": 100, "id": 110966284, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=e763b0bf2b4f1087", "url": "https://translations.documentfoundation.org/api/units/110966284/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:40.665905Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?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": [ "Podeu afegir la funció ESTIL() a una fórmula que ja existeix en una cel·la. Per exemple, juntament amb la funció ACTUAL, podeu acolorir una cel·la en funció del seu valor. La fórmula =...+ESTIL(SI(ACTUAL()>3; \"Vermell\"; \"Verd\")) aplica l'estil de cel·la \"vermell\" a les cel·les si el valor és més gran que 3, i en cas contrari aplica l'estil de cel·la \"verd\"." ], "id_hash": 3545701820741360435, "content_hash": 3545701820741360435, "location": "cellstyle_by_formula.xhp", "context": "cellstyle_by_formula.xhp\npar_id3150275\nhelp.text", "note": "EzSnh", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 305, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 55, "source_unit": "https://translations.documentfoundation.org/api/units/110800431/?format=api", "priority": 100, "id": 110966286, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=b134dd0520be9b33", "url": "https://translations.documentfoundation.org/api/units/110966286/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:40.667334Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?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 voleu aplicar una fórmula a totes les cel·les d'una àrea seleccionada, podeu utilitzar el diàleg <item type=\"menuitem\">Cerca i reemplaça</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/110800432/?format=api", "priority": 100, "id": 110966289, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=c0b4844f2d3904bf", "url": "https://translations.documentfoundation.org/api/units/110966289/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:40.668781Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?format=api", "source": [ "Select all the desired cells." ], "previous_source": "", "target": [ "Seleccioneu totes les cel·les desitjades." ], "id_hash": -7915414649820688558, "content_hash": -7915414649820688558, "location": "cellstyle_by_formula.xhp", "context": "cellstyle_by_formula.xhp\npar_id3149456\nhelp.text", "note": "qAH7F", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 307, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/110800433/?format=api", "priority": 100, "id": 110966293, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=1226cc504b83cf52", "url": "https://translations.documentfoundation.org/api/units/110966293/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:40.670372Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?format=api", "source": [ "Select the menu command <emph>Edit - Find & Replace</emph>." ], "previous_source": "", "target": [ "Seleccioneu l'ordre de menú <emph>Edita ▸ Cerca i reemplaça</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": 110966296, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=4a46884ecf40e776", "url": "https://translations.documentfoundation.org/api/units/110966296/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:40.671968Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?format=api", "source": [ "For the <item type=\"menuitem\">Find</item> term, enter: .<item type=\"literal\">*</item>" ], "previous_source": "", "target": [ "Per al terme de <item type=\"menuitem\">Cerca</item>, introduïu: .<item type=\"literal\">*</item>" ], "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": 20, "fuzzy": false, "translated": true, "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": 110966301, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=4ed77e977626b309", "url": "https://translations.documentfoundation.org/api/units/110966301/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:40.673466Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?format=api", "source": [ "\".*\" is a regular expression that designates the contents of the current cell." ], "previous_source": "", "target": [ "«.*» és una expressió regular que designa el contingut de la cel·la 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/110800475/?format=api", "priority": 100, "id": 110966305, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=9f3b3c87521af963", "url": "https://translations.documentfoundation.org/api/units/110966305/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:40.675007Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?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": [ "Introduïu la fórmula següent al camp <item type=\"menuitem\">Reemplaça</item>: <item type=\"literal\">=&+ESTIL(SI(ACTUAL()>3;\"Vermell\";\"Verd\"))</item>" ], "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": 20, "fuzzy": false, "translated": true, "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": 110966309, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=e8fbcdbae16d1679", "url": "https://translations.documentfoundation.org/api/units/110966309/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:40.676545Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?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": [ "El símbol «&» designa el contingut actual del camp <emph>Cerca</emph>. La línia ha de començar amb un signe d'igual, ja que es tracta d'una fórmula. S'assumeix que els estils de cel·la «Vermell» i «Verd» ja existeixen." ], "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": 20, "fuzzy": false, "translated": true, "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": 110966317, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=9feeee1b0e9df12e", "url": "https://translations.documentfoundation.org/api/units/110966317/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:40.679352Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?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": [ "Activeu les caselles <link href=\"text/shared/01/02100000.xhp\"><emph>Expressions regulars</emph></link> i <emph>Només en la selecció</emph>. Feu clic a <emph>Cerca-ho tot</emph>." ], "id_hash": 8731978487739033615, "content_hash": 8731978487739033615, "location": "cellstyle_by_formula.xhp", "context": "cellstyle_by_formula.xhp\npar_id3149262\nhelp.text", "note": "iF62Y", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 313, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/110800597/?format=api", "priority": 100, "id": 110967090, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=f92e382bac09a80f", "url": "https://translations.documentfoundation.org/api/units/110967090/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:42.531341Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?format=api", "source": [ "All cells with contents that were included in the selection are now highlighted." ], "previous_source": "", "target": [ "Ara totes les cel·les amb continguts inclosos a la selecció estan realçades." ], "id_hash": 8123534687943202457, "content_hash": 8123534687943202457, "location": "cellstyle_by_formula.xhp", "context": "cellstyle_by_formula.xhp\npar_id3144767\nhelp.text", "note": "A3CBV", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 314, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/110800631/?format=api", "priority": 100, "id": 110967102, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=f0bc97c2236b1699", "url": "https://translations.documentfoundation.org/api/units/110967102/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:42.533887Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?format=api", "source": [ "Click <item type=\"menuitem\">Replace all</item>." ], "previous_source": "", "target": [ "Feu clic a <item type=\"menuitem\">Reemplaça-ho tot</item>." ], "id_hash": 6497422687296759040, "content_hash": 6497422687296759040, "location": "cellstyle_by_formula.xhp", "context": "cellstyle_by_formula.xhp\npar_id3147127\nhelp.text", "note": "CxKWs", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 315, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/110800640/?format=api", "priority": 100, "id": 110967106, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=da2b7b825fe32500", "url": "https://translations.documentfoundation.org/api/units/110967106/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:42.545139Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?format=api", "source": [ "Applying Conditional Formatting" ], "previous_source": "", "target": [ "Aplicació de la formatació condicional" ], "id_hash": 4878667856389839357, "content_hash": 4878667856389839357, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\ntit\nhelp.text", "note": "smBjq", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 316, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/110800686/?format=api", "priority": 100, "id": 110967110, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=c3b482912d3b99fd", "url": "https://translations.documentfoundation.org/api/units/110967110/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:42.547568Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?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>formatació condicional; cel·les</bookmark_value><bookmark_value>cel·les; formatació condicional</bookmark_value><bookmark_value>formatació; formatació condicional</bookmark_value><bookmark_value>estils;estils condicionals</bookmark_value><bookmark_value>formats de cel·la; condicionals</bookmark_value><bookmark_value>nombres aleatoris;exemples</bookmark_value><bookmark_value>estils de cel·la; còpia</bookmark_value><bookmark_value>còpia; estils de cel·la</bookmark_value><bookmark_value>taules; còpia d'estils de cel·la</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/110800718/?format=api", "priority": 100, "id": 110967114, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=7c1e116e5ec0518a", "url": "https://translations.documentfoundation.org/api/units/110967114/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:42.549709Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?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\">Aplicació de la formatació condicional</link></variable>" ], "id_hash": 2343396187597534365, "content_hash": 2343396187597534365, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\nhd_id3149263\nhelp.text", "note": "WX8sY", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 318, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/110800747/?format=api", "priority": 100, "id": 110967121, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=a0856a6ab1c1749d", "url": "https://translations.documentfoundation.org/api/units/110967121/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:42.552460Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?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": 110967126, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=b3fb07e4d332fde2", "url": "https://translations.documentfoundation.org/api/units/110967126/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:42.554928Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?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": [ "Per a aplicar la formatació condicional, la funció de càlcul automàtic ha d'estar habilitada. Trieu <emph>Eines ▸ Continguts de la cel·la ▸ Calcula automàticament</emph> (si el càlcul automàtic està habilitat veureu una marca de selecció al costat de l'ordre)." ], "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/110800834/?format=api", "priority": 100, "id": 110967127, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=16731e63410f3617", "url": "https://translations.documentfoundation.org/api/units/110967127/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:42.557008Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?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": [ "Amb la formatació condicional, podeu realçar els totals que sobrepassen el valor mitjà de tots els totals, per exemple. Si els totals canvien, la formatació canvia de manera corresponent, sense haver d'aplicar altres estils de manera 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/110800883/?format=api", "priority": 100, "id": 110967133, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=b73c7349c9ce625f", "url": "https://translations.documentfoundation.org/api/units/110967133/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:42.559761Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?format=api", "source": [ "To Define the Conditions" ], "previous_source": "", "target": [ "Definició de les condicions" ], "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/110800919/?format=api", "priority": 100, "id": 110967136, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=bb9b905deda942bf", "url": "https://translations.documentfoundation.org/api/units/110967136/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:42.562105Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?format=api", "source": [ "Select the cells to which you want to apply a conditional style." ], "previous_source": "", "target": [ "Seleccioneu les cel·les a les quals voleu aplicar un estil condicional." ], "id_hash": 7282045265121163783, "content_hash": 7282045265121163783, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3154490\nhelp.text", "note": "GbyDp", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 323, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/110800943/?format=api", "priority": 100, "id": 110967141, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=e50f059631dcba07", "url": "https://translations.documentfoundation.org/api/units/110967141/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:42.564233Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?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": 110967146, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=9b40bebd546639ad", "url": "https://translations.documentfoundation.org/api/units/110967146/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:42.566353Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?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": [ "Introduïu les condicions en el quadre de diàleg. Aquest diàleg es descriu de manera detallada a l'<link href=\"text/scalc/01/05120000.xhp\">Ajuda del $[officename]</link>. A continuació se'n mostra un exemple:" ], "id_hash": -8619950715441449712, "content_hash": -8619950715441449712, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3146969\nhelp.text", "note": "AnNxD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 325, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 23, "source_unit": "https://translations.documentfoundation.org/api/units/110801000/?format=api", "priority": 100, "id": 110967151, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=085fc87ea8bcf510", "url": "https://translations.documentfoundation.org/api/units/110967151/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:42.568271Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?format=api", "source": [ "Example of Conditional Formatting: Highlighting Totals Above/Under the Average Value" ], "previous_source": "", "target": [ "Exemple de formatació condicional: realçament dels totals superiors o inferiors al valor mitjà" ], "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": 110967157, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=448d27773fc135c5", "url": "https://translations.documentfoundation.org/api/units/110967157/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:42.570690Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?format=api", "source": [ "Step1: Generate Number Values" ], "previous_source": "", "target": [ "Pas 1: generació de valors numèrics" ], "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/110801080/?format=api", "priority": 100, "id": 110967160, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=b26a732b50fe11b2", "url": "https://translations.documentfoundation.org/api/units/110967160/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:42.572692Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?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": [ "Pot ser que vulgueu donar un èmfasi especial a determinats valors de les taules. Per exemple, en una taula de facturació, pot ser que vulgueu mostrar tots els valors que estiguin per sobre de la mitjana en color verd i tots els que es trobin per sota de la mitjana en color vermell. Això és possible amb la formatació condicional." ], "id_hash": -4753521984506958934, "content_hash": -4753521984506958934, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3150043\nhelp.text", "note": "5TVr9", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 328, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 43, "source_unit": "https://translations.documentfoundation.org/api/units/110801095/?format=api", "priority": 100, "id": 110967164, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=3e0818f0b973ebaa", "url": "https://translations.documentfoundation.org/api/units/110967164/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:42.574687Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?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": 110967167, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=4133ddbbc1f4866e", "url": "https://translations.documentfoundation.org/api/units/110967167/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:42.577298Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?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": [ "En una de les cel·les introduïu la fórmula =ALEAT() per a obtenir un nombre aleatori entre 0 i 1. Si voleu obtenir enters entre 0 i 50, introduïu la fórmula =ENT(ALEAT()*50)." ], "id_hash": 7837711463613136779, "content_hash": 7837711463613136779, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3149565\nhelp.text", "note": "A66qh", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 330, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 33, "source_unit": "https://translations.documentfoundation.org/api/units/110801149/?format=api", "priority": 100, "id": 110967171, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=ecc5250cd8aaff8b", "url": "https://translations.documentfoundation.org/api/units/110967171/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:42.579512Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?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": [ "Copieu la fórmula per a crear una fila de nombres aleatoris. Feu clic a la cantonada inferior dreta de la cel·la seleccionada i arrossegueu-la cap a la dreta fins que se seleccioni l'interval de cel·les desitjat." ], "id_hash": 6892568724043407820, "content_hash": 6892568724043407820, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3149258\nhelp.text", "note": "rCrEf", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 331, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 31, "source_unit": "https://translations.documentfoundation.org/api/units/110801186/?format=api", "priority": 100, "id": 110967175, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=dfa752bc729321cc", "url": "https://translations.documentfoundation.org/api/units/110967175/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:42.581998Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?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 la mateixa manera que s'ha descrit anteriorment, arrossegueu cap avall la cantonada de la cel·la situada més a la dreta per a crear més files de nombres aleatoris." ], "id_hash": -2947348419295557648, "content_hash": -2947348419295557648, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3159236\nhelp.text", "note": "Tm6MA", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 332, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://translations.documentfoundation.org/api/units/110801222/?format=api", "priority": 100, "id": 110967179, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=5718ea3a769447f0", "url": "https://translations.documentfoundation.org/api/units/110967179/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:42.584338Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?format=api", "source": [ "Step 2: Define Cell Styles" ], "previous_source": "", "target": [ "Pas 2: definició d'estils de cel·la" ], "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": 110967181, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=99d05e8585b1f35a", "url": "https://translations.documentfoundation.org/api/units/110967181/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:42.586613Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?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": [ "El pas següent és aplicar un estil de cel·la a tots els valors que representen una facturació per sobre de la mitjana, i un altre estil a aquells valors que es troben per sota de la mitjana. Abans de continuar, assegureu-vos que la finestra Estils sigui visible." ], "id_hash": 2515053443613502634, "content_hash": 2515053443613502634, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3154659\nhelp.text", "note": "sr6WY", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "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": 110967185, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=a2e743c819b4acaa", "url": "https://translations.documentfoundation.org/api/units/110967185/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:42.588677Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?format=api", "source": [ "Click in a blank cell and select the command <emph>Format Cells</emph> in the context menu." ], "previous_source": "", "target": [ "Feu clic a una cel·la en blanc i seleccioneu l'ordre <emph>Formata les cel·les</emph> en el menú contextual." ], "id_hash": -6456560012199126547, "content_hash": -6456560012199126547, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3150883\nhelp.text", "note": "CVM3G", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 335, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/110801312/?format=api", "priority": 100, "id": 110967189, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=2665b0e091e119ed", "url": "https://translations.documentfoundation.org/api/units/110967189/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:42.590833Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?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": 110967203, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=a916d21aeebe3635", "url": "https://translations.documentfoundation.org/api/units/110967203/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:42.597446Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?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": 110967226, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=90948d0ca08882da", "url": "https://translations.documentfoundation.org/api/units/110967226/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:42.610313Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?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": [ "Per a definir un segon estil, feu clic novament a una cel·la en blanc i procediu tal com s'ha descrit anteriorment. Assigneu un color de fons diferent per a la cel·la i assigneu-li un nom (per a aquest exemple, «Per sota»)." ], "id_hash": 2559261581071111980, "content_hash": 2559261581071111980, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3152889\nhelp.text", "note": "4bRZa", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 338, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 32, "source_unit": "https://translations.documentfoundation.org/api/units/110801395/?format=api", "priority": 100, "id": 110967233, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=a38452d9330c572c", "url": "https://translations.documentfoundation.org/api/units/110967233/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:42.613570Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?format=api", "source": [ "Step 3: Calculate Average" ], "previous_source": "", "target": [ "Pas 3: càlcul de la mitjana" ], "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": 110967241, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=ea84b23808a3f408", "url": "https://translations.documentfoundation.org/api/units/110967241/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:42.615999Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?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": [ "Per a aquest exemple es calcula la mitjana de valors aleatoris. El resultat se situa en una cel·la:" ], "id_hash": 4578609383930617086, "content_hash": 4578609383930617086, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3148837\nhelp.text", "note": "f5sxG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 340, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/110801430/?format=api", "priority": 100, "id": 110967244, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=bf8a7cf9e6745cfe", "url": "https://translations.documentfoundation.org/api/units/110967244/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:42.619825Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?format=api", "source": [ "Set the cursor in a blank cell, for example, J14, and choose <emph>Insert - Function</emph>." ], "previous_source": "", "target": [ "Establiu el cursor en una cel·la en blanc, per exemple J14, i trieu <emph>Insereix ▸ Funció</emph>." ], "id_hash": -1641327560713127346, "content_hash": -1641327560713127346, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3144768\nhelp.text", "note": "GhHpd", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 341, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/110801474/?format=api", "priority": 100, "id": 110967264, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=6938d54797a2ba4e", "url": "https://translations.documentfoundation.org/api/units/110967264/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:42.630010Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?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": 110967282, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=7c21b2da937ba075", "url": "https://translations.documentfoundation.org/api/units/110967282/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:42.640828Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?format=api", "source": [ "Close the Function Wizard with <item type=\"menuitem\">OK</item>." ], "previous_source": "", "target": [ "Tanqueu l'auxiliar de funcions fent clic a <item type=\"menuitem\">D'acord</item>." ], "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/110801533/?format=api", "priority": 100, "id": 110967286, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=3a65d9d3b01bf767", "url": "https://translations.documentfoundation.org/api/units/110967286/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:42.642975Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?format=api", "source": [ "Step 4: Apply Cell Styles" ], "previous_source": "", "target": [ "Pas 4: aplicació d'estils de cel·la" ], "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": 110967293, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=2671a0abf7f32097", "url": "https://translations.documentfoundation.org/api/units/110967293/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:42.645478Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?format=api", "source": [ "Now you can apply the conditional formatting to the sheet:" ], "previous_source": "", "target": [ "Ara podeu aplicar la formatació condicional al full:" ], "id_hash": 7382243818509673232, "content_hash": 7382243818509673232, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3149126\nhelp.text", "note": "AA6JP", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 345, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/110801602/?format=api", "priority": 100, "id": 110967304, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=e672ffa3df97a310", "url": "https://translations.documentfoundation.org/api/units/110967304/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:42.652622Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?format=api", "source": [ "Select all cells with the random numbers." ], "previous_source": "", "target": [ "Seleccioneu totes les cel·les amb els nombres aleatoris." ], "id_hash": 7136521799982947324, "content_hash": 7136521799982947324, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3150049\nhelp.text", "note": "7YuzB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 346, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/110801617/?format=api", "priority": 100, "id": 110967311, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=e30a04c423d09bfc", "url": "https://translations.documentfoundation.org/api/units/110967311/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:42.654755Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?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": 110967314, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=0dae77af13c3c98f", "url": "https://translations.documentfoundation.org/api/units/110967314/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:42.656791Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?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": [ "Definiu la condició de la manera següent: si el valor de la cel·la és inferior a J14, formateu amb l'estil de cel·la «Per sota», i si el valor de la cel·la és major o igual a J14, formateu amb l'estil de cel·la «Per sobre»." ], "id_hash": -3867351834357650696, "content_hash": -3867351834357650696, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3153013\nhelp.text", "note": "oaUQo", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 348, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 33, "source_unit": "https://translations.documentfoundation.org/api/units/110801685/?format=api", "priority": 100, "id": 110967322, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=4a5467ff2ba82af8", "url": "https://translations.documentfoundation.org/api/units/110967322/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:42.659852Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?format=api", "source": [ "Step 5: Copy Cell Style" ], "previous_source": "", "target": [ "Pas 5: còpia d'un estil de cel·la" ], "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": 110967330, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=df98144af519077a", "url": "https://translations.documentfoundation.org/api/units/110967330/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:42.663857Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/ca/?format=api", "source": [ "To apply the conditional formatting to other cells later:" ], "previous_source": "", "target": [ "Per a aplicar la formatació condicional a altres cel·les més endavant:" ], "id_hash": -7215413165649662082, "content_hash": -7215413165649662082, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3145320\nhelp.text", "note": "GBgrB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 350, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/110801777/?format=api", "priority": 100, "id": 110967341, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalcguide/ca/?checksum=1bddb3f469c66f7e", "url": "https://translations.documentfoundation.org/api/units/110967341/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:29:42.667708Z" } ] }