Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-master/textscalcguide/es/units/?format=api&page=6
{ "count": 1559, "next": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/es/units/?format=api&page=7", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/es/units/?format=api&page=5", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 329, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 43, "source_unit": "https://translations.documentfoundation.org/api/units/24936420/?format=api", "priority": 100, "id": 1957266, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/es/?checksum=3e0818f0b973ebaa", "url": "https://translations.documentfoundation.org/api/units/1957266/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.736445Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 331, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 33, "source_unit": "https://translations.documentfoundation.org/api/units/24936422/?format=api", "priority": 100, "id": 1957268, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/es/?checksum=ecc5250cd8aaff8b", "url": "https://translations.documentfoundation.org/api/units/1957268/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.763384Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 332, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 31, "source_unit": "https://translations.documentfoundation.org/api/units/24936423/?format=api", "priority": 100, "id": 1957269, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/es/?checksum=dfa752bc729321cc", "url": "https://translations.documentfoundation.org/api/units/1957269/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.779000Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 333, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://translations.documentfoundation.org/api/units/24936424/?format=api", "priority": 100, "id": 1957270, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/es/?checksum=5718ea3a769447f0", "url": "https://translations.documentfoundation.org/api/units/1957270/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.790358Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 334, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/24936425/?format=api", "priority": 100, "id": 1957271, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/es/?checksum=99d05e8585b1f35a", "url": "https://translations.documentfoundation.org/api/units/1957271/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.802578Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 335, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 34, "source_unit": "https://translations.documentfoundation.org/api/units/24936426/?format=api", "priority": 100, "id": 1957272, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/es/?checksum=a2e743c819b4acaa", "url": "https://translations.documentfoundation.org/api/units/1957272/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.815221Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 336, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/24936427/?format=api", "priority": 100, "id": 1957273, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/es/?checksum=2665b0e091e119ed", "url": "https://translations.documentfoundation.org/api/units/1957273/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.828935Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 339, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 32, "source_unit": "https://translations.documentfoundation.org/api/units/24936430/?format=api", "priority": 100, "id": 1957276, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/es/?checksum=a38452d9330c572c", "url": "https://translations.documentfoundation.org/api/units/1957276/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.871288Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 340, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/24936431/?format=api", "priority": 100, "id": 1957277, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/es/?checksum=ea84b23808a3f408", "url": "https://translations.documentfoundation.org/api/units/1957277/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.884037Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 341, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/24936432/?format=api", "priority": 100, "id": 1957278, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/es/?checksum=bf8a7cf9e6745cfe", "url": "https://translations.documentfoundation.org/api/units/1957278/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.895935Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 342, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/24936433/?format=api", "priority": 100, "id": 1957279, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/es/?checksum=6938d54797a2ba4e", "url": "https://translations.documentfoundation.org/api/units/1957279/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.917597Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 344, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/24936435/?format=api", "priority": 100, "id": 1957281, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/es/?checksum=3a65d9d3b01bf767", "url": "https://translations.documentfoundation.org/api/units/1957281/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.946764Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 345, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/24936436/?format=api", "priority": 100, "id": 1957282, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/es/?checksum=2671a0abf7f32097", "url": "https://translations.documentfoundation.org/api/units/1957282/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.964238Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 346, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/24936437/?format=api", "priority": 100, "id": 1957283, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/es/?checksum=e672ffa3df97a310", "url": "https://translations.documentfoundation.org/api/units/1957283/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.981056Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 347, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/24936438/?format=api", "priority": 100, "id": 1957284, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/es/?checksum=e30a04c423d09bfc", "url": "https://translations.documentfoundation.org/api/units/1957284/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:43.997202Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 349, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 33, "source_unit": "https://translations.documentfoundation.org/api/units/24936440/?format=api", "priority": 100, "id": 1957286, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/es/?checksum=4a5467ff2ba82af8", "url": "https://translations.documentfoundation.org/api/units/1957286/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:44.017956Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 350, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/24936441/?format=api", "priority": 100, "id": 1957287, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/es/?checksum=df98144af519077a", "url": "https://translations.documentfoundation.org/api/units/1957287/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:44.027002Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/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": 351, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/24936442/?format=api", "priority": 100, "id": 1957288, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/es/?checksum=1bddb3f469c66f7e", "url": "https://translations.documentfoundation.org/api/units/1957288/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:44.035349Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/es/?format=api", "source": [ "Click one of the cells that has been assigned conditional formatting." ], "previous_source": "", "target": [ "Pulse sobre una de las celdas a las que haya asignado el formato condicional." ], "id_hash": 7196379235401938805, "content_hash": 7196379235401938805, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3153074\nhelp.text", "note": "soRTt", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 352, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/24936443/?format=api", "priority": 100, "id": 1957289, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/es/?checksum=e3deacc95b213775", "url": "https://translations.documentfoundation.org/api/units/1957289/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:44.043738Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/es/?format=api", "source": [ "Copy the cell to the clipboard." ], "previous_source": "", "target": [ "Copie la celda en el portapapeles." ], "id_hash": 5333275245432870135, "content_hash": 5333275245432870135, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3149051\nhelp.text", "note": "35S7X", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 353, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/24936444/?format=api", "priority": 100, "id": 1957290, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/es/?checksum=ca0399942d6914f7", "url": "https://translations.documentfoundation.org/api/units/1957290/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:44.052647Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/es/?format=api", "source": [ "Select the cells that are to receive this same formatting." ], "previous_source": "", "target": [ "Seleccione las celdas que deban tener el mismo formato." ], "id_hash": 5816052215023921773, "content_hash": 5816052215023921773, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3150436\nhelp.text", "note": "ogFEX", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 354, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/24936445/?format=api", "priority": 100, "id": 1957291, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/es/?checksum=d0b6c4acbf9fea6d", "url": "https://translations.documentfoundation.org/api/units/1957291/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:44.061543Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/es/?format=api", "source": [ "Highlighting Negative Numbers" ], "previous_source": "", "target": [ "Resaltar los números negativos" ], "id_hash": -4059404321177657037, "content_hash": -4059404321177657037, "location": "cellstyle_minusvalue.xhp", "context": "cellstyle_minusvalue.xhp\ntit\nhelp.text", "note": "HFoKB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 358, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/24936449/?format=api", "priority": 100, "id": 1957295, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/es/?checksum=47aa19470c852133", "url": "https://translations.documentfoundation.org/api/units/1957295/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:44.115322Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/es/?format=api", "source": [ "<bookmark_value>negative numbers</bookmark_value> <bookmark_value>numbers; highlighting negative numbers</bookmark_value> <bookmark_value>highlighting;negative numbers</bookmark_value> <bookmark_value>colors;negative numbers</bookmark_value> <bookmark_value>number formats;colors for negative numbers</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>números negativos</bookmark_value> <bookmark_value>números; resaltar números negativos</bookmark_value> <bookmark_value>resaltar;números negativos</bookmark_value> <bookmark_value>colores;números negativos</bookmark_value> <bookmark_value>formatos de número;colores para números negativos</bookmark_value>" ], "id_hash": 2690907695207962454, "content_hash": 2690907695207962454, "location": "cellstyle_minusvalue.xhp", "context": "cellstyle_minusvalue.xhp\nbm_id3147434\nhelp.text", "note": "9Zqdi", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 359, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/24936450/?format=api", "priority": 100, "id": 1957296, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/es/?checksum=a558064ab03c5756", "url": "https://translations.documentfoundation.org/api/units/1957296/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:44.124531Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/es/?format=api", "source": [ "You can format cells with a number format that highlights negative numbers in red. Alternatively, you can define your own number format in which negative numbers are highlighted in other colors." ], "previous_source": "", "target": [ "Se puede asignar a las celdas un formato numérico que destaque los números negativos en rojo. Otra posibilidad es definir un formato numérico propio que destaque los números negativos en otro color." ], "id_hash": -2401469527218566303, "content_hash": -2401469527218566303, "location": "cellstyle_minusvalue.xhp", "context": "cellstyle_minusvalue.xhp\npar_id3153878\nhelp.text", "note": "YGxpk", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 361, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 31, "source_unit": "https://translations.documentfoundation.org/api/units/24936452/?format=api", "priority": 100, "id": 1957298, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/es/?checksum=5eac443043364b61", "url": "https://translations.documentfoundation.org/api/units/1957298/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:44.142333Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/es/?format=api", "source": [ "Select the cells and choose <emph>Format - Cells</emph>." ], "previous_source": "", "target": [ "Seleccione las celdas y elija <emph>Formato ▸ Celdas</emph>." ], "id_hash": -2610375749824612289, "content_hash": -2610375749824612289, "location": "cellstyle_minusvalue.xhp", "context": "cellstyle_minusvalue.xhp\npar_id3155600\nhelp.text", "note": "ZFJHU", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 362, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/24936453/?format=api", "priority": 100, "id": 1957299, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/es/?checksum=5bc61515fd68f83f", "url": "https://translations.documentfoundation.org/api/units/1957299/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:44.154994Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/es/?format=api", "source": [ "On the <emph>Numbers</emph> tab, select a number format and mark <emph>Negative numbers red</emph> check box. Click <emph>OK</emph>." ], "previous_source": "", "target": [ "En la pestaña <emph>Números</emph> seleccione un formato numérico y marque la casilla <emph>Números negativos en rojo</emph>. Pulse en <emph>Aceptar</emph>." ], "id_hash": -2531380645435629521, "content_hash": -2531380645435629521, "location": "cellstyle_minusvalue.xhp", "context": "cellstyle_minusvalue.xhp\npar_id3146969\nhelp.text", "note": "tYEZ3", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 363, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 17, "source_unit": "https://translations.documentfoundation.org/api/units/24936454/?format=api", "priority": 100, "id": 1957300, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/es/?checksum=5cdebab6fd82a02f", "url": "https://translations.documentfoundation.org/api/units/1957300/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:44.171355Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/es/?format=api", "source": [ "The cell number format is defined in two parts. The format for positive numbers and zero is defined in front of the semicolon; after the semicolon the formula for negative numbers is defined. You can change the code (RED) under <item type=\"menuitem\">Format code</item>. For example, instead of RED, enter <item type=\"literal\">YELLOW</item>. If the new code appears in the list after clicking the <item type=\"menuitem\">Add</item> icon, this is a valid entry." ], "previous_source": "", "target": [ "El formato numérico de la celda se define en dos partes. El formato de los números positivos y el cero se define delante del punto y coma; después del punto y coma se define la fórmula de los números negativos. Puede cambiar el código (ROJO) en <item type=\"menuitem\">Código del formato</item>. Por ejemplo, en vez de ROJO, escriba <item type=\"literal\">AMARILLO</item>. Si aparece código nuevo en la lista tras pulsar en el icono <item type=\"menuitem\">Añadir</item>, significa que es una entrada válida." ], "id_hash": -4422457703490035149, "content_hash": -4422457703490035149, "location": "cellstyle_minusvalue.xhp", "context": "cellstyle_minusvalue.xhp\npar_id3145640\nhelp.text", "note": "23n86", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 364, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 70, "source_unit": "https://translations.documentfoundation.org/api/units/24936455/?format=api", "priority": 100, "id": 1957301, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/es/?checksum=42a046265d496233", "url": "https://translations.documentfoundation.org/api/units/1957301/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:44.183430Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/es/?format=api", "source": [ "Consolidating Data" ], "previous_source": "", "target": [ "Consolidar datos" ], "id_hash": 5372822363492069186, "content_hash": 5372822363492069186, "location": "consolidate.xhp", "context": "consolidate.xhp\ntit\nhelp.text", "note": "G5Dfz", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 376, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24936456/?format=api", "priority": 100, "id": 1957302, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/es/?checksum=ca90197921382f42", "url": "https://translations.documentfoundation.org/api/units/1957302/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:44.194727Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/es/?format=api", "source": [ "<bookmark_value>consolidating data</bookmark_value> <bookmark_value>ranges; combining</bookmark_value> <bookmark_value>combining;cell ranges</bookmark_value> <bookmark_value>tables; combining</bookmark_value> <bookmark_value>data; merging cell ranges</bookmark_value> <bookmark_value>merging;data ranges</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>consolidar datos</bookmark_value><bookmark_value>intervalos; combinar</bookmark_value><bookmark_value>combinar;intervalos de celdas</bookmark_value><bookmark_value>tablas; combinar</bookmark_value> <bookmark_value>datos; combinar intervalos de celdas</bookmark_value><bookmark_value>combinar;intervalos de datos</bookmark_value>" ], "id_hash": -8699824088904455889, "content_hash": -8699824088904455889, "location": "consolidate.xhp", "context": "consolidate.xhp\nbm_id3150791\nhelp.text", "note": "dEYi9", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 377, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/24936457/?format=api", "priority": 100, "id": 1957303, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/es/?checksum=07440415b476a92f", "url": "https://translations.documentfoundation.org/api/units/1957303/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:44.212385Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/es/?format=api", "source": [ "During consolidation, the contents of the cells from several sheets will be combined in one place." ], "previous_source": "", "target": [ "Durante la consolidación, el contenido de las celdas de diversas hojas se combina en un único lugar." ], "id_hash": 2863811470568569986, "content_hash": 2863811470568569986, "location": "consolidate.xhp", "context": "consolidate.xhp\npar_id3153191\nhelp.text", "note": "dcJqU", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 379, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/24936459/?format=api", "priority": 100, "id": 1957305, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/es/?checksum=a7be4d5bfeedbc82", "url": "https://translations.documentfoundation.org/api/units/1957305/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:44.238149Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/es/?format=api", "source": [ "To Combine Cell Contents" ], "previous_source": "", "target": [ "Para combinar el contenido de celdas" ], "id_hash": -7418047071167571604, "content_hash": -7418047071167571604, "location": "consolidate.xhp", "context": "consolidate.xhp\nhd_id892056\nhelp.text", "note": "GyvFB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 380, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/24936460/?format=api", "priority": 100, "id": 1957306, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/es/?checksum=190dcd7dc3ee196c", "url": "https://translations.documentfoundation.org/api/units/1957306/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:44.249515Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/es/?format=api", "source": [ "Open the document that contains the cell ranges to be consolidated." ], "previous_source": "", "target": [ "Abra el documento en el que se encuentren los intervalos de celdas que se deban consolidar." ], "id_hash": 830377358914747267, "content_hash": 830377358914747267, "location": "consolidate.xhp", "context": "consolidate.xhp\npar_id3151073\nhelp.text", "note": "4tD6G", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 381, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/24936461/?format=api", "priority": 100, "id": 1957307, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/es/?checksum=8b8617cef3a3fb83", "url": "https://translations.documentfoundation.org/api/units/1957307/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:44.260620Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/es/?format=api", "source": [ "Choose <item type=\"menuitem\">Data - Consolidate</item> to open the <emph>Consolidate</emph> dialog." ], "previous_source": "", "target": [ "Vaya a <item type=\"menuitem\">Datos ▸ Consolidar</item> para abrir el cuadro de diálogo <emph>Consolidar</emph>." ], "id_hash": -1340262079201837017, "content_hash": -1340262079201837017, "location": "consolidate.xhp", "context": "consolidate.xhp\npar_id3154513\nhelp.text", "note": "77VUk", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 382, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/24936462/?format=api", "priority": 100, "id": 1957308, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/es/?checksum=6d666ebd6f3f8027", "url": "https://translations.documentfoundation.org/api/units/1957308/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:44.272156Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/es/?format=api", "source": [ "From the <emph>Source data area</emph> box select a source cell range to consolidate with other areas." ], "previous_source": "", "target": [ "En el cuadro <emph>Área de datos fuente</emph> seleccione un área de celdas fuente para consolidar con otras áreas." ], "id_hash": 3568547474734044916, "content_hash": 3568547474734044916, "location": "consolidate.xhp", "context": "consolidate.xhp\npar_id3147345\nhelp.text", "note": "hJHqN", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 383, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/24936463/?format=api", "priority": 100, "id": 1957309, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/es/?checksum=b186070573a3d6f4", "url": "https://translations.documentfoundation.org/api/units/1957309/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:44.286464Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/es/?format=api", "source": [ "If the range is not named, click in the field next to the <emph>Source data area</emph>. A blinking text cursor appears. Type a reference for the first source data range or select the range with the mouse." ], "previous_source": "", "target": [ "Si el intervalo no tiene nombre, pulse sobre el campo de entrada de la derecha, junto al listado <emph>Área de datos de origen</emph>. Observe que el cursor de texto parpadea. Escriba ahí la referencia del primer intervalo de datos de origen, o bien realice la selección en la hoja con el ratón." ], "id_hash": -667679353442180552, "content_hash": -667679353442180552, "location": "consolidate.xhp", "context": "consolidate.xhp\npar_id3149209\nhelp.text", "note": "CvGP2", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 384, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 37, "source_unit": "https://translations.documentfoundation.org/api/units/24936464/?format=api", "priority": 100, "id": 1957310, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/es/?checksum=76bbed2a62376238", "url": "https://translations.documentfoundation.org/api/units/1957310/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:44.300907Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/es/?format=api", "source": [ "Click <emph>Add</emph> to insert the selected range in the <emph>Consolidation areas</emph> field." ], "previous_source": "", "target": [ "Pulse en <emph>Añadir</emph> para insertar el intervalo seleccionado en el campo <emph>Áreas de consolidación</emph>." ], "id_hash": 3848135511423935069, "content_hash": 3848135511423935069, "location": "consolidate.xhp", "context": "consolidate.xhp\npar_id3155529\nhelp.text", "note": "zSGyD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 385, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/24936465/?format=api", "priority": 100, "id": 1957311, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/es/?checksum=b56752dbfdfd625d", "url": "https://translations.documentfoundation.org/api/units/1957311/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:44.313588Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/es/?format=api", "source": [ "Select additional ranges and click <emph>Add</emph> after each selection." ], "previous_source": "", "target": [ "A continuación, seleccione las demás áreas siguiendo uno de los procedimientos indicados y, después de cada área, pulse en <emph>Añadir</emph>." ], "id_hash": 7169276099035941393, "content_hash": 7169276099035941393, "location": "consolidate.xhp", "context": "consolidate.xhp\npar_id3153816\nhelp.text", "note": "Fo56E", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 386, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/24936466/?format=api", "priority": 100, "id": 1957312, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/es/?checksum=e37e62a0abbc4a11", "url": "https://translations.documentfoundation.org/api/units/1957312/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:44.325129Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/es/?format=api", "source": [ "Specify where you want to display the result by selecting a target range from the <emph>Copy results to</emph> box." ], "previous_source": "", "target": [ "Especifique dónde desea mostrar el resultado mediante la selección de un área destino en el cuadro <emph>Resultado a partir de</emph>." ], "id_hash": 398797832588757125, "content_hash": 398797832588757125, "location": "consolidate.xhp", "context": "consolidate.xhp\npar_id3157983\nhelp.text", "note": "85CXx", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 387, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/24936467/?format=api", "priority": 100, "id": 1957313, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/es/?checksum=8588d0840ca60885", "url": "https://translations.documentfoundation.org/api/units/1957313/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:44.336261Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/es/?format=api", "source": [ "If the target range is not named, click in the field next to <emph>Copy results to</emph> and enter the reference of the target range. Alternatively, you can select the range using the mouse or position the cursor in the top left cell of the target range." ], "previous_source": "", "target": [ "Si el intervalo de destino no tiene nombre, pulse en el campo ubicado junto a <emph>Copiar resultados en</emph> y escriba la referencia del intervalo de destino. O bien, puede seleccionar el intervalo con el ratón o colocar el cursor en la celda superior izquierda del intervalo de destino." ], "id_hash": -1876994938870961530, "content_hash": -1876994938870961530, "location": "consolidate.xhp", "context": "consolidate.xhp\npar_id3150215\nhelp.text", "note": "UByCi", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 388, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 46, "source_unit": "https://translations.documentfoundation.org/api/units/24936468/?format=api", "priority": 100, "id": 1957314, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/es/?checksum=65f3930c3f63ea86", "url": "https://translations.documentfoundation.org/api/units/1957314/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:44.350609Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/es/?format=api", "source": [ "Select a function from the <emph>Function</emph> box. The function specifies how the values of the consolidation ranges are linked. The \"Sum\" function is the default setting." ], "previous_source": "", "target": [ "Seleccione una función en el cuadro <emph>Función</emph>. La función especifica de qué modo se relacionarán los valores de los intervalos de consolidación. La función predeterminada es «Suma»." ], "id_hash": -6052783438683441990, "content_hash": -6052783438683441990, "location": "consolidate.xhp", "context": "consolidate.xhp\npar_id3153813\nhelp.text", "note": "JvD9q", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 389, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/24936469/?format=api", "priority": 100, "id": 1957315, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/es/?checksum=2c00318812e7f4ba", "url": "https://translations.documentfoundation.org/api/units/1957315/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:44.364157Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/es/?format=api", "source": [ "Click <emph>OK</emph> to consolidate the ranges." ], "previous_source": "", "target": [ "Pulse en <emph>Aceptar</emph> para consolidar los intervalos." ], "id_hash": -897663849380064562, "content_hash": -897663849380064562, "location": "consolidate.xhp", "context": "consolidate.xhp\npar_id3149315\nhelp.text", "note": "Z3iG2", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 390, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/24936470/?format=api", "priority": 100, "id": 1957316, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/es/?checksum=738adb7c29fdd2ce", "url": "https://translations.documentfoundation.org/api/units/1957316/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:44.379348Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/es/?format=api", "source": [ "Additional Settings" ], "previous_source": "", "target": [ "Configuración adicional" ], "id_hash": 1386989742513126216, "content_hash": 1386989742513126216, "location": "consolidate.xhp", "context": "consolidate.xhp\npar_idN107DE\nhelp.text", "note": "qbEFs", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 391, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24936471/?format=api", "priority": 100, "id": 1957317, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/es/?checksum=933f93d27d9afb48", "url": "https://translations.documentfoundation.org/api/units/1957317/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:44.395802Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/es/?format=api", "source": [ "Click <emph>More</emph> in the <emph>Consolidate</emph> dialog to display additional settings:" ], "previous_source": "", "target": [ "Pulse en el botón <emph>Más</emph> del cuadro de diálogo <emph>Consolidar</emph> para mostrar más opciones:" ], "id_hash": -8685282467281095460, "content_hash": -8685282467281095460, "location": "consolidate.xhp", "context": "consolidate.xhp\npar_id3147250\nhelp.text", "note": "BSAXP", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 392, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/24936472/?format=api", "priority": 100, "id": 1957318, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/es/?checksum=0777ad9cd3c834dc", "url": "https://translations.documentfoundation.org/api/units/1957318/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:44.411727Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/es/?format=api", "source": [ "Select <emph>Link to source data</emph> to insert the formulas that generate the results in the target range, rather than the actual results. If you link the data, any values modified in the source range are automatically updated in the target range." ], "previous_source": "", "target": [ "Marque el campo <emph>Vincular con datos fuente</emph>. Ahora en el área de destino de la consolidación no se guardarán los resultados del cálculo como valores, sino las fórmulas con las que se han obtenido dichos resultados. De este modo, las modificaciones posteriores de una de las áreas fuente también modificarán el área de destino correspondiente." ], "id_hash": -3631865130924125807, "content_hash": -3631865130924125807, "location": "consolidate.xhp", "context": "consolidate.xhp\npar_id3156400\nhelp.text", "note": "DEEPq", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 393, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 41, "source_unit": "https://translations.documentfoundation.org/api/units/24936473/?format=api", "priority": 100, "id": 1957319, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/es/?checksum=4d9905e7e723d191", "url": "https://translations.documentfoundation.org/api/units/1957319/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:44.428007Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/es/?format=api", "source": [ "The corresponding cell references in the target range are inserted in consecutive rows, which are automatically ordered and then hidden from view. Only the final result, based on the selected function, is displayed." ], "previous_source": "", "target": [ "Las referencias de celdas conjuntas del intervalo de destino se introducen en celdas seguidas; dichas celdas se estructuran y ocultan automáticamente y solo se muestra el resultado final, correspondiente a la función seleccionada." ], "id_hash": -1379167358946436983, "content_hash": -1379167358946436983, "location": "consolidate.xhp", "context": "consolidate.xhp\npar_id3150538\nhelp.text", "note": "VJPHa", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 394, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 33, "source_unit": "https://translations.documentfoundation.org/api/units/24936474/?format=api", "priority": 100, "id": 1957320, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/es/?checksum=6cdc36981c2f1889", "url": "https://translations.documentfoundation.org/api/units/1957320/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:44.439647Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/es/?format=api", "source": [ "Under <emph>Consolidate by</emph>, select either <emph>Row labels</emph> or <emph>Column labels</emph> if the cells of the source data range are not to be consolidated corresponding to the identical position of the cell in the range, but instead according to a matching row label or column label." ], "previous_source": "", "target": [ "En <emph>Consolidar según</emph>, seleccione <emph>Títulos de fila</emph> o <emph>Títulos de columna</emph> si las celdas del rango fuente de datos no se van a consolidar en relación con la posición idéntica de la celda en el rango, sino en relación con un título de fila o de columna que concuerde." ], "id_hash": 2054559487241974870, "content_hash": 2054559487241974870, "location": "consolidate.xhp", "context": "consolidate.xhp\npar_id3149945\nhelp.text", "note": "UubEm", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 395, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 45, "source_unit": "https://translations.documentfoundation.org/api/units/24936475/?format=api", "priority": 100, "id": 1957321, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/es/?checksum=9c8342f7d6f77456", "url": "https://translations.documentfoundation.org/api/units/1957321/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:44.451633Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/es/?format=api", "source": [ "To consolidate by row labels or column labels, the label must be contained in the selected source ranges." ], "previous_source": "", "target": [ "Para consolidar por etiquetas de fila o de columna, la etiqueta debe estar incluida en los intervalos de origen seleccionados." ], "id_hash": -3469891027884511483, "content_hash": -3469891027884511483, "location": "consolidate.xhp", "context": "consolidate.xhp\npar_id3157871\nhelp.text", "note": "AEjpi", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 396, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/24936476/?format=api", "priority": 100, "id": 1957322, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/es/?checksum=4fd8787e91a0ef05", "url": "https://translations.documentfoundation.org/api/units/1957322/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:44.467558Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/es/?format=api", "source": [ "The text in the labels must be identical, so that rows or columns can be accurately matched. If the row or column label does not match any that exist in the target range, it will be appended as a new row or column." ], "previous_source": "", "target": [ "El texto de los títulos debe ser idéntico, de manera que las filas o las columnas se puedan hacer coincidir con precisión. Si el título de la fila o de la columna no coincide con ninguno que exista en el intervalo de destino, se agregará como una fila o columna nueva." ], "id_hash": 9184278295374865548, "content_hash": 9184278295374865548, "location": "consolidate.xhp", "context": "consolidate.xhp\npar_id3150478\nhelp.text", "note": "mQ3x2", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 397, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 43, "source_unit": "https://translations.documentfoundation.org/api/units/24936477/?format=api", "priority": 100, "id": 1957323, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/es/?checksum=ff751c730226248c", "url": "https://translations.documentfoundation.org/api/units/1957323/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:44.485792Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/es/?format=api", "source": [ "The data from the consolidation ranges and target range will be saved when you save the document. If you later open a document in which consolidation has been defined, this data will again be available." ], "previous_source": "", "target": [ "Se guardarán los datos de las áreas de consolidación y de destino. Al abrir un documento en el que se haya definido una consolidación, los datos volverán a estar disponibles." ], "id_hash": -6048694902205384958, "content_hash": -6048694902205384958, "location": "consolidate.xhp", "context": "consolidate.xhp\npar_id3147468\nhelp.text", "note": "UMqz7", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 398, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 35, "source_unit": "https://translations.documentfoundation.org/api/units/24936478/?format=api", "priority": 100, "id": 1957324, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/es/?checksum=2c0eb808a754f702", "url": "https://translations.documentfoundation.org/api/units/1957324/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:44.498350Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/es/?format=api", "source": [ "Importing and Exporting CSV Files" ], "previous_source": "", "target": [ "Importar y exportar archivos CSV" ], "id_hash": 1932064022427195821, "content_hash": 1932064022427195821, "location": "csv_files.xhp", "context": "csv_files.xhp\ntit\nhelp.text", "note": "UNSjU", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 400, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/24936480/?format=api", "priority": 100, "id": 1957326, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/es/?checksum=9ad011fdec15d9ad", "url": "https://translations.documentfoundation.org/api/units/1957326/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:44.522480Z" } ] }