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/es/units/?format=api&page=7
{ "count": 1558, "next": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/es/units/?format=api&page=8", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/es/units/?format=api&page=6", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/es/?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 - Preferencias</caseinline><defaultinline>Herramientas ▸ Opciones</defaultinline></switchinline> - <link href=\"text/shared/optionen/01040900.xhp\"><item type=\"menuitem\">%PRODUCTNAME Calc ▸ Generales</item></link> puede elegir realizar la actualización al abrir el documento en forma automática, bien siempre, a petición o nunca. La actualización puede iniciarse de forma manual en el cuadro de diálogo accesible en <item type=\"menuitem\">Editar ▸ Enlaces</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": 99363688, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/es/?checksum=52fdfdefda06ca0b", "url": "https://translations.documentfoundation.org/api/units/99363688/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:52:55.832099Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/es/?format=api", "source": [ "Assigning Formats by Formula" ], "previous_source": "", "target": [ "Asignar formatos mediante fórmulas" ], "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": 99363693, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/es/?checksum=4de6da9556858af2", "url": "https://translations.documentfoundation.org/api/units/99363693/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:52:55.834560Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/es/?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 mediante fórmulas</bookmark_value><bookmark_value>formatos de celda; asignar mediante fórmulas</bookmark_value><bookmark_value>ejemplo de función ESTILO</bookmark_value><bookmark_value>estilos de celda;asignar mediante fórmulas</bookmark_value><bookmark_value>fórmulas;asignar formatos de celda</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": 99363696, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/es/?checksum=82481b247d0154e3", "url": "https://translations.documentfoundation.org/api/units/99363696/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:52:55.836194Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/es/?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 mediante fórmulas</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": 99363703, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/es/?checksum=e763b0bf2b4f1087", "url": "https://translations.documentfoundation.org/api/units/99363703/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:52:55.838242Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/es/?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 ESTILO() puede añadirse a una fórmula existente de una celda. Por ejemplo, en combinación con la función ACTUAL, puede colorear una celda según su valor. La fórmula =...+ESTILO(SI(ACTUAL()>3; \"Rojo\"; \"Verde\")) aplica el estilo «Rojo» a la celda si el valor es mayor que 3; si es menor, se aplica el estilo «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": 99363707, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/es/?checksum=b134dd0520be9b33", "url": "https://translations.documentfoundation.org/api/units/99363707/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:52:55.840320Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/es/?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 quiere aplicar una fórmula a todas las celdas de un área seleccionada, utilice el cuadro de diálogo <item type=\"menuitem\">Buscar y reemplazar</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": 99363712, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/es/?checksum=c0b4844f2d3904bf", "url": "https://translations.documentfoundation.org/api/units/99363712/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:52:55.842579Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/es/?format=api", "source": [ "Select all the desired cells." ], "previous_source": "", "target": [ "Seleccione todas las celdas deseadas." ], "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": 99363720, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/es/?checksum=1226cc504b83cf52", "url": "https://translations.documentfoundation.org/api/units/99363720/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:52:55.845015Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/es/?format=api", "source": [ "Select the menu command <emph>Edit - Find & Replace</emph>." ], "previous_source": "", "target": [ "Vaya a <emph>Editar ▸ Buscar y reemplazar</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": 99363732, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/es/?checksum=4a46884ecf40e776", "url": "https://translations.documentfoundation.org/api/units/99363732/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:52:55.850170Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/es/?format=api", "source": [ "For the <item type=\"menuitem\">Find</item> term, enter: .<item type=\"literal\">*</item>" ], "previous_source": "", "target": [ "Para el término <item type=\"menuitem\">Buscar</item>, escriba: .<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/99014783/?format=api", "priority": 100, "id": 99363746, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/es/?checksum=4ed77e977626b309", "url": "https://translations.documentfoundation.org/api/units/99363746/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:52:55.854662Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/es/?format=api", "source": [ "\".*\" is a regular expression that designates the contents of the current cell." ], "previous_source": "", "target": [ "«.*» es una expresión regular que designa el contenido de la celda activa." ], "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": 99363751, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/es/?checksum=9f3b3c87521af963", "url": "https://translations.documentfoundation.org/api/units/99363751/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:52:55.857074Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/es/?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": [ "Especifique la fórmula siguiente en el campo <item type=\"menuitem\">Reemplazar</item>: <item type=\"literal\">=&+ESTILO(SI(ACTUAL()>3;\"Rojo\";\"Verde\"))</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/99014812/?format=api", "priority": 100, "id": 99363755, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/es/?checksum=e8fbcdbae16d1679", "url": "https://translations.documentfoundation.org/api/units/99363755/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:52:55.858839Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/es/?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ímbolo «&» designa el contenido actual del campo <emph>Buscar</emph>. La línea debe empezar con el signo de igual, ya que se trata de una fórmula. Se supone que los estilos de celda «Rojo» y «Verde» ya existen." ], "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/99014842/?format=api", "priority": 100, "id": 99363764, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/es/?checksum=9feeee1b0e9df12e", "url": "https://translations.documentfoundation.org/api/units/99363764/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:52:55.861636Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/es/?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": [ "Seleccione las opciones <link href=\"text/shared/01/02100000.xhp\"><emph>Expresión regular</emph></link> y <emph>Solo en la selección actual</emph>. Pulse en <emph>Buscar todo</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": 99363766, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/es/?checksum=f92e382bac09a80f", "url": "https://translations.documentfoundation.org/api/units/99363766/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:52:55.864590Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/es/?format=api", "source": [ "All cells with contents that were included in the selection are now highlighted." ], "previous_source": "", "target": [ "Todas las celdas con contenido que se encontraban en la selección aparecerán ahora destacadas." ], "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": 99363775, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/es/?checksum=f0bc97c2236b1699", "url": "https://translations.documentfoundation.org/api/units/99363775/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:52:55.871580Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/es/?format=api", "source": [ "Click <item type=\"menuitem\">Replace all</item>." ], "previous_source": "", "target": [ "Pulse en <item type=\"menuitem\">Reemplazar todo</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": 99363778, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/es/?checksum=da2b7b825fe32500", "url": "https://translations.documentfoundation.org/api/units/99363778/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:52:55.873456Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/es/?format=api", "source": [ "Applying Conditional Formatting" ], "previous_source": "", "target": [ "Aplicar formato 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/99014903/?format=api", "priority": 100, "id": 99363788, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/es/?checksum=c3b482912d3b99fd", "url": "https://translations.documentfoundation.org/api/units/99363788/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:52:55.879132Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/es/?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>formato condicional; celdas</bookmark_value> <bookmark_value>celdas; formato condicional</bookmark_value> <bookmark_value>formato; formato condicional</bookmark_value> <bookmark_value>estilos;estilos condicionales</bookmark_value> <bookmark_value>formatos; condicionales</bookmark_value> <bookmark_value>números aleatorios;ejemplos</bookmark_value> <bookmark_value>estilos de celda; copiar</bookmark_value> <bookmark_value>copiar; estilos de celda</bookmark_value> <bookmark_value>tablas; copiar estilos de celda</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": 99363793, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/es/?checksum=7c1e116e5ec0518a", "url": "https://translations.documentfoundation.org/api/units/99363793/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:52:55.880638Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/es/?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 formato 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/99014949/?format=api", "priority": 100, "id": 99363805, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/es/?checksum=a0856a6ab1c1749d", "url": "https://translations.documentfoundation.org/api/units/99363805/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:52:55.884636Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/es/?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": [ "El cuadro de diálogo que se abre mediante la orden de menú <emph>Formato ▸ Condicional ▸ Condición</emph> le permite definir condiciones por celda, las cuales deben cumplirse para atribuir un formato concreto a las celdas seleccionadas." ], "id_hash": 3745596194465971682, "content_hash": 3745596194465971682, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3159156\nhelp.text", "note": "3Feon", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "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": 99363810, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/es/?checksum=b3fb07e4d332fde2", "url": "https://translations.documentfoundation.org/api/units/99363810/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:52:55.886441Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/es/?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": [ "Debe activarse la funcionalidad Cálculo automático antes de aplicar formato condicional. Vaya a <emph>Datos ▸ Calcular ▸ Cálculo automático</emph> (verá una casilla de verificación junto a esta orden cuando esté 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": 99363815, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/es/?checksum=16731e63410f3617", "url": "https://translations.documentfoundation.org/api/units/99363815/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:52:55.888364Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/es/?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 formato condicional permite, por ejemplo, destacar los totales que están por encima del promedio de todos los totales. Si los totales cambian, el formato cambia según corresponda, sin necesidad de 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": 99363822, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/es/?checksum=b73c7349c9ce625f", "url": "https://translations.documentfoundation.org/api/units/99363822/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:52:55.893975Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/es/?format=api", "source": [ "To Define the Conditions" ], "previous_source": "", "target": [ "Para definir las 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": 99363829, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/es/?checksum=bb9b905deda942bf", "url": "https://translations.documentfoundation.org/api/units/99363829/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:52:55.898449Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/es/?format=api", "source": [ "Select the cells to which you want to apply a conditional style." ], "previous_source": "", "target": [ "Seleccione las celdas que deban tener un formato 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/99015043/?format=api", "priority": 100, "id": 99363833, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/es/?checksum=e50f059631dcba07", "url": "https://translations.documentfoundation.org/api/units/99363833/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:52:55.902238Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/es/?format=api", "source": [ "Choose <emph>Format - Conditional - Condition</emph>." ], "previous_source": "", "target": [ "Vaya a <emph>Formato ▸ Condicional ▸ Condición</emph>." ], "id_hash": 1963779157907618221, "content_hash": 1963779157907618221, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3155603\nhelp.text", "note": "oEDHp", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "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": 99363839, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/es/?checksum=9b40bebd546639ad", "url": "https://translations.documentfoundation.org/api/units/99363839/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:52:55.903892Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/es/?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 las condiciones en el diálogo. Puede ver una descripción detallada del diálogo en la <link href=\"text/scalc/01/05120000.xhp\">Ayuda de $[officename]</link>; a continuación se muestra un ejemplo:" ], "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": 99363841, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/es/?checksum=085fc87ea8bcf510", "url": "https://translations.documentfoundation.org/api/units/99363841/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:52:55.905545Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/es/?format=api", "source": [ "Example of Conditional Formatting: Highlighting Totals Above/Under the Average Value" ], "previous_source": "", "target": [ "Ejemplo de formato condicional: Resaltar los totales por encima/debajo del valor promedio" ], "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": 99363847, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/es/?checksum=448d27773fc135c5", "url": "https://translations.documentfoundation.org/api/units/99363847/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:52:55.907760Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/es/?format=api", "source": [ "Step1: Generate Number Values" ], "previous_source": "", "target": [ "Paso 1: generar valores numé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": 99363855, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/es/?checksum=b26a732b50fe11b2", "url": "https://translations.documentfoundation.org/api/units/99363855/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:52:55.911526Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/es/?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": [ "Quizás desee destacar de forma especial determinados valores de la hoja, por ejemplo, en una hoja de cifras de ventas, los valores que estén sobre la media en verde y en rojo los que estén por debajo. Con el formato condicional no habrá 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": 99363868, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/es/?checksum=3e0818f0b973ebaa", "url": "https://translations.documentfoundation.org/api/units/99363868/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:52:55.917251Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/es/?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": [ "Antes que nada, cree una tabla en la que aparezcan valores distintos. Introduzca, para esta prueba, algunos números aleatorios:" ], "id_hash": -4525029402094565778, "content_hash": -4525029402094565778, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3155337\nhelp.text", "note": "9zJa4", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "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": 99363874, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/es/?checksum=4133ddbbc1f4866e", "url": "https://translations.documentfoundation.org/api/units/99363874/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:52:55.919830Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/es/?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": [ "Introduzca en una celda la fórmula =ALEATORIO() para tener un número entre 0 y 1. Si desea números enteros entre 0 y 50, introduzca como fórmula =ENTERO(ALEATORIO()*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": 99363880, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/es/?checksum=ecc5250cd8aaff8b", "url": "https://translations.documentfoundation.org/api/units/99363880/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:52:55.922182Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/es/?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 para crear una fila de números aleatorios. Pulse en la esquina inferior derecha de la celda seleccionada y arrastre hacia la derecha hasta seleccionar el intervalo deseado." ], "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": 99363883, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/es/?checksum=dfa752bc729321cc", "url": "https://translations.documentfoundation.org/api/units/99363883/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:52:55.924165Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/es/?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 celda hasta la parte inferior derecha para crear más filas de números 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": 99363891, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/es/?checksum=5718ea3a769447f0", "url": "https://translations.documentfoundation.org/api/units/99363891/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:52:55.926348Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/es/?format=api", "source": [ "Step 2: Define Cell Styles" ], "previous_source": "", "target": [ "Paso 2: definir estilos de celda" ], "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": 99363896, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/es/?checksum=99d05e8585b1f35a", "url": "https://translations.documentfoundation.org/api/units/99363896/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:52:55.928195Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/es/?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 próximo paso es aplicar un estilo de celda a todos los valores que presenten cifras de volumen de ventas superiores a la media y otro para las inferiores. Antes de continuar, asegúrese de que la ventana Estilos sea 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/99015250/?format=api", "priority": 100, "id": 99363902, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/es/?checksum=a2e743c819b4acaa", "url": "https://translations.documentfoundation.org/api/units/99363902/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:52:55.929930Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/es/?format=api", "source": [ "Click in a blank cell and select the command <emph>Format Cells</emph> in the context menu." ], "previous_source": "", "target": [ "Pulse en una celda vacía, abra el menú contextual y seleccione <emph>Formato de celdas</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": 99363910, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/es/?checksum=2665b0e091e119ed", "url": "https://translations.documentfoundation.org/api/units/99363910/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:52:55.931785Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/es/?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": [ "En el cuadro de diálogo <emph>Formato de celdas</emph> de la pestaña <emph>Fondo</emph>, pulse el botón <emph>Color</emph> y seleccione un color de fondo. Pulse en <emph>Aceptar</emph>." ], "id_hash": 2960784818159105589, "content_hash": 2960784818159105589, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3155529\nhelp.text", "note": "JZ7gV", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "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": 99363917, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/es/?checksum=a916d21aeebe3635", "url": "https://translations.documentfoundation.org/api/units/99363917/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:52:55.933890Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/es/?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": [ "En el grupo Estilos de la barra lateral, pulse en el icono <emph>Estilo nuevo desde selección</emph>. Escriba el nombre del estilo nuevo. En este ejemplo, llámelo «Mayor que»." ], "id_hash": 1194734886532448986, "content_hash": 1194734886532448986, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3154484\nhelp.text", "note": "AwUDA", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "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": 99363931, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/es/?checksum=90948d0ca08882da", "url": "https://translations.documentfoundation.org/api/units/99363931/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:52:55.937692Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/es/?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": [ "Para definir otro estilo vuelva a pulsar en una celda vacía y siga de nuevo el proceso descrito. Asigne un color de fondo distinto a la celda y dele un nombre (en este ejemplo, «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": 99363937, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/es/?checksum=a38452d9330c572c", "url": "https://translations.documentfoundation.org/api/units/99363937/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:52:55.939851Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/es/?format=api", "source": [ "Step 3: Calculate Average" ], "previous_source": "", "target": [ "Paso 3: calcular promedio" ], "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": 99363943, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/es/?checksum=ea84b23808a3f408", "url": "https://translations.documentfoundation.org/api/units/99363943/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:52:55.941750Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/es/?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": [ "En nuestro ejemplo debemos calcular el promedio de los valores aleatorios. El resultado se sitúa en una celda:" ], "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": 99363949, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/es/?checksum=bf8a7cf9e6745cfe", "url": "https://translations.documentfoundation.org/api/units/99363949/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:52:55.943688Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/es/?format=api", "source": [ "Set the cursor in a blank cell, for example, J14, and choose <emph>Insert - Function</emph>." ], "previous_source": "", "target": [ "Sitúe el cursor en una celda vacía, por ejemplo, J14, y seleccione <emph>Insertar ▸ 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": 99363960, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/es/?checksum=6938d54797a2ba4e", "url": "https://translations.documentfoundation.org/api/units/99363960/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:52:55.953184Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/es/?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": [ "Seleccione la función PROMEDIO. Use el ratón para seleccionar todos sus números aleatorios. Si no puede ver el intervalo en su totalidad porque el Asistente para funciones lo obstruye, puede encoger este diálogo temporalmente mediante el botón <link href=\"text/shared/00/00000001.xhp#shrink_maximize\"><item type=\"menuitem\">Contraer</item></link>." ], "id_hash": -278745050073292683, "content_hash": -278745050073292683, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3156016\nhelp.text", "note": "xCigs", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "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": 99363964, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/es/?checksum=7c21b2da937ba075", "url": "https://translations.documentfoundation.org/api/units/99363964/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:52:55.955113Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/es/?format=api", "source": [ "Close the Function Wizard with <item type=\"menuitem\">OK</item>." ], "previous_source": "", "target": [ "Pulse en <item type=\"menuitem\">Aceptar</item> para cerrar el Asistente para 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": 99363969, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/es/?checksum=3a65d9d3b01bf767", "url": "https://translations.documentfoundation.org/api/units/99363969/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:52:55.956602Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/es/?format=api", "source": [ "Step 4: Apply Cell Styles" ], "previous_source": "", "target": [ "Paso 4: aplicar estilos de celda" ], "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": 99363974, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/es/?checksum=2671a0abf7f32097", "url": "https://translations.documentfoundation.org/api/units/99363974/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:52:55.958396Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/es/?format=api", "source": [ "Now you can apply the conditional formatting to the sheet:" ], "previous_source": "", "target": [ "Ahora solo le queda aplicar el formato condicional a la hoja:" ], "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": 99363980, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/es/?checksum=e672ffa3df97a310", "url": "https://translations.documentfoundation.org/api/units/99363980/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:52:55.959805Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/es/?format=api", "source": [ "Select all cells with the random numbers." ], "previous_source": "", "target": [ "Marque todas las celdas 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": 99363984, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/es/?checksum=e30a04c423d09bfc", "url": "https://translations.documentfoundation.org/api/units/99363984/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:52:55.961341Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/es/?format=api", "source": [ "Choose the <emph>Format - Conditional - Condition</emph> command to open the corresponding dialog." ], "previous_source": "", "target": [ "Accione la orden <emph>Formato ▸ Condicional ▸ Condición</emph> para abrir el cuadro de diálogo pertinente." ], "id_hash": -8237515074579478129, "content_hash": -8237515074579478129, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3153801\nhelp.text", "note": "p7dEG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "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": 99363990, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/es/?checksum=0dae77af13c3c98f", "url": "https://translations.documentfoundation.org/api/units/99363990/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:52:55.963007Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/es/?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": [ "Seleccione ahora como condiciones: si el valor de la celda es menor que J14, aplicar el formato «Menor que», y si es mayor o igual, el formato «Mayor que»." ], "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": 99363998, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/es/?checksum=4a5467ff2ba82af8", "url": "https://translations.documentfoundation.org/api/units/99363998/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:52:55.964929Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/es/?format=api", "source": [ "Step 5: Copy Cell Style" ], "previous_source": "", "target": [ "Paso 5: copiar estilo de celda" ], "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": 99364003, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/es/?checksum=df98144af519077a", "url": "https://translations.documentfoundation.org/api/units/99364003/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:52:55.966444Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/es/?format=api", "source": [ "To apply the conditional formatting to other cells later:" ], "previous_source": "", "target": [ "Para aplicar posteriormente el formato condicional a otras celdas:" ], "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": 99364006, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalcguide/es/?checksum=1bddb3f469c66f7e", "url": "https://translations.documentfoundation.org/api/units/99364006/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:52:55.967773Z" } ] }