Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-master/textscalcguide/gl/units/?format=api&page=6
https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gl/units/?format=api&page=7", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gl/units/?format=api&page=5", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/gl/?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": [ "" ], "id_hash": -4753521984506958934, "content_hash": -4753521984506958934, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3150043\nhelp.text", "note": "5TVr9", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 1963279, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=3e0818f0b973ebaa", "url": "https://translations.documentfoundation.org/api/units/1963279/?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/gl/?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": [ "" ], "id_hash": 7837711463613136779, "content_hash": 7837711463613136779, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3149565\nhelp.text", "note": "A66qh", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 1963281, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=ecc5250cd8aaff8b", "url": "https://translations.documentfoundation.org/api/units/1963281/?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/gl/?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": [ "" ], "id_hash": 6892568724043407820, "content_hash": 6892568724043407820, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3149258\nhelp.text", "note": "rCrEf", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 1963282, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=dfa752bc729321cc", "url": "https://translations.documentfoundation.org/api/units/1963282/?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/gl/?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": [ "" ], "id_hash": -2947348419295557648, "content_hash": -2947348419295557648, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3159236\nhelp.text", "note": "Tm6MA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 1963283, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=5718ea3a769447f0", "url": "https://translations.documentfoundation.org/api/units/1963283/?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/gl/?format=api", "source": [ "Step 2: Define Cell Styles" ], "previous_source": "", "target": [ "" ], "id_hash": 1860090573670708058, "content_hash": 1860090573670708058, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\nhd_id3149211\nhelp.text", "note": "i3CTm", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 1963284, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=99d05e8585b1f35a", "url": "https://translations.documentfoundation.org/api/units/1963284/?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/gl/?format=api", "source": [ "The next step is to apply a cell style to all values that represent above-average turnover, and one to those that are below the average. Ensure that the Styles window is visible before proceeding." ], "previous_source": "", "target": [ "" ], "id_hash": 2515053443613502634, "content_hash": 2515053443613502634, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3154659\nhelp.text", "note": "sr6WY", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 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": 1963285, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=a2e743c819b4acaa", "url": "https://translations.documentfoundation.org/api/units/1963285/?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/gl/?format=api", "source": [ "Click in a blank cell and select the command <emph>Format Cells</emph> in the context menu." ], "previous_source": "", "target": [ "" ], "id_hash": -6456560012199126547, "content_hash": -6456560012199126547, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3150883\nhelp.text", "note": "CVM3G", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 1963286, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=2665b0e091e119ed", "url": "https://translations.documentfoundation.org/api/units/1963286/?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/gl/?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": [ "" ], "id_hash": 2559261581071111980, "content_hash": 2559261581071111980, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3152889\nhelp.text", "note": "4bRZa", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 1963289, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=a38452d9330c572c", "url": "https://translations.documentfoundation.org/api/units/1963289/?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/gl/?format=api", "source": [ "Step 3: Calculate Average" ], "previous_source": "", "target": [ "" ], "id_hash": 7675455618679043080, "content_hash": 7675455618679043080, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\nhd_id3148704\nhelp.text", "note": "x3rxG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 1963290, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=ea84b23808a3f408", "url": "https://translations.documentfoundation.org/api/units/1963290/?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/gl/?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": [ "" ], "id_hash": 4578609383930617086, "content_hash": 4578609383930617086, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3148837\nhelp.text", "note": "f5sxG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 1963291, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=bf8a7cf9e6745cfe", "url": "https://translations.documentfoundation.org/api/units/1963291/?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/gl/?format=api", "source": [ "Set the cursor in a blank cell, for example, J14, and choose <emph>Insert - Function</emph>." ], "previous_source": "", "target": [ "" ], "id_hash": -1641327560713127346, "content_hash": -1641327560713127346, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3144768\nhelp.text", "note": "GhHpd", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 1963292, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=6938d54797a2ba4e", "url": "https://translations.documentfoundation.org/api/units/1963292/?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/gl/?format=api", "source": [ "Close the Function Wizard with <item type=\"menuitem\">OK</item>." ], "previous_source": "", "target": [ "" ], "id_hash": -5015363106791229593, "content_hash": -5015363106791229593, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3153246\nhelp.text", "note": "YEqsh", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 1963294, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=3a65d9d3b01bf767", "url": "https://translations.documentfoundation.org/api/units/1963294/?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/gl/?format=api", "source": [ "Step 4: Apply Cell Styles" ], "previous_source": "", "target": [ "" ], "id_hash": -6453200130585452393, "content_hash": -6453200130585452393, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\nhd_id3149898\nhelp.text", "note": "75WFf", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 1963295, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=2671a0abf7f32097", "url": "https://translations.documentfoundation.org/api/units/1963295/?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/gl/?format=api", "source": [ "Now you can apply the conditional formatting to the sheet:" ], "previous_source": "", "target": [ "" ], "id_hash": 7382243818509673232, "content_hash": 7382243818509673232, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3149126\nhelp.text", "note": "AA6JP", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 1963296, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=e672ffa3df97a310", "url": "https://translations.documentfoundation.org/api/units/1963296/?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/gl/?format=api", "source": [ "Select all cells with the random numbers." ], "previous_source": "", "target": [ "" ], "id_hash": 7136521799982947324, "content_hash": 7136521799982947324, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3150049\nhelp.text", "note": "7YuzB", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 1963297, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=e30a04c423d09bfc", "url": "https://translations.documentfoundation.org/api/units/1963297/?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/gl/?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": [ "" ], "id_hash": -3867351834357650696, "content_hash": -3867351834357650696, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3153013\nhelp.text", "note": "oaUQo", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 1963299, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=4a5467ff2ba82af8", "url": "https://translations.documentfoundation.org/api/units/1963299/?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/gl/?format=api", "source": [ "Step 5: Copy Cell Style" ], "previous_source": "", "target": [ "" ], "id_hash": 6888277942235367290, "content_hash": 6888277942235367290, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\nhd_id3155761\nhelp.text", "note": "p9FR7", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 1963300, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=df98144af519077a", "url": "https://translations.documentfoundation.org/api/units/1963300/?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/gl/?format=api", "source": [ "To apply the conditional formatting to other cells later:" ], "previous_source": "", "target": [ "" ], "id_hash": -7215413165649662082, "content_hash": -7215413165649662082, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3145320\nhelp.text", "note": "GBgrB", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 1963301, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=1bddb3f469c66f7e", "url": "https://translations.documentfoundation.org/api/units/1963301/?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/gl/?format=api", "source": [ "Click one of the cells that has been assigned conditional formatting." ], "previous_source": "", "target": [ "Prema nunha das celas que recibiu 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": 1963302, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=e3deacc95b213775", "url": "https://translations.documentfoundation.org/api/units/1963302/?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/gl/?format=api", "source": [ "Copy the cell to the clipboard." ], "previous_source": "", "target": [ "Copie a cela ao portapapeis." ], "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": 1963303, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=ca0399942d6914f7", "url": "https://translations.documentfoundation.org/api/units/1963303/?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/gl/?format=api", "source": [ "Select the cells that are to receive this same formatting." ], "previous_source": "", "target": [ "Seleccione as celas que van recibir este mesmo 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": 1963304, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=d0b6c4acbf9fea6d", "url": "https://translations.documentfoundation.org/api/units/1963304/?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/gl/?format=api", "source": [ "Highlighting Negative Numbers" ], "previous_source": "", "target": [ "Realzar 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": 1963308, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=47aa19470c852133", "url": "https://translations.documentfoundation.org/api/units/1963308/?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/gl/?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; realzar números negativos</bookmark_value> <bookmark_value>realzar;números negativos</bookmark_value> <bookmark_value>cores;números negativos</bookmark_value> <bookmark_value>formatos numéricos;cores 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": 1963309, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=a558064ab03c5756", "url": "https://translations.documentfoundation.org/api/units/1963309/?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/gl/?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": [ "Pode formatar celas cun formato numérico que realce os números negativos en vermello. Como alternativa, pode definir o seu propio formato numérico no que os números negativos estean destacados noutras cores." ], "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": 1963311, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=5eac443043364b61", "url": "https://translations.documentfoundation.org/api/units/1963311/?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/gl/?format=api", "source": [ "Select the cells and choose <emph>Format - Cells</emph>." ], "previous_source": "", "target": [ "Seleccione as celas e escolla <emph>Formato - Celas</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": 1963312, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=5bc61515fd68f83f", "url": "https://translations.documentfoundation.org/api/units/1963312/?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/gl/?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": [ "Na lapela <emph>Números</emph>, seleccione un formato numérico e marque a caixa de selección <emph>Números negativos en vermello</emph>. Prema 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": 1963313, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=5cdebab6fd82a02f", "url": "https://translations.documentfoundation.org/api/units/1963313/?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/gl/?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": [ "O formato numérico das celas defínese en dúas partes. O formato dos números positivos e cero defínese diante do punto e vírgula; despois do punto e vírgula defínense os números negativos. Pode cambiar o código (RED) en <item type=\"menuitem\">Código do formato</item>. Por exemplo, no canto de RED, introduza <item type=\"literal\">YELLOW</item>. Que o novo código apareza na lista após premer a icona <item type=\"menuitem\">Engadir</item> significa que esta é unha 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": 1963314, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=42a046265d496233", "url": "https://translations.documentfoundation.org/api/units/1963314/?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/gl/?format=api", "source": [ "Consolidating Data" ], "previous_source": "", "target": [ "" ], "id_hash": 5372822363492069186, "content_hash": 5372822363492069186, "location": "consolidate.xhp", "context": "consolidate.xhp\ntit\nhelp.text", "note": "G5Dfz", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 1963315, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=ca90197921382f42", "url": "https://translations.documentfoundation.org/api/units/1963315/?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/gl/?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": [ "" ], "id_hash": -8699824088904455889, "content_hash": -8699824088904455889, "location": "consolidate.xhp", "context": "consolidate.xhp\nbm_id3150791\nhelp.text", "note": "dEYi9", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 1963316, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=07440415b476a92f", "url": "https://translations.documentfoundation.org/api/units/1963316/?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/gl/?format=api", "source": [ "During consolidation, the contents of the cells from several sheets will be combined in one place." ], "previous_source": "", "target": [ "" ], "id_hash": 2863811470568569986, "content_hash": 2863811470568569986, "location": "consolidate.xhp", "context": "consolidate.xhp\npar_id3153191\nhelp.text", "note": "dcJqU", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 1963318, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=a7be4d5bfeedbc82", "url": "https://translations.documentfoundation.org/api/units/1963318/?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/gl/?format=api", "source": [ "To Combine Cell Contents" ], "previous_source": "", "target": [ "" ], "id_hash": -7418047071167571604, "content_hash": -7418047071167571604, "location": "consolidate.xhp", "context": "consolidate.xhp\nhd_id892056\nhelp.text", "note": "GyvFB", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 1963319, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=190dcd7dc3ee196c", "url": "https://translations.documentfoundation.org/api/units/1963319/?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/gl/?format=api", "source": [ "Open the document that contains the cell ranges to be consolidated." ], "previous_source": "", "target": [ "" ], "id_hash": 830377358914747267, "content_hash": 830377358914747267, "location": "consolidate.xhp", "context": "consolidate.xhp\npar_id3151073\nhelp.text", "note": "4tD6G", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 1963320, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=8b8617cef3a3fb83", "url": "https://translations.documentfoundation.org/api/units/1963320/?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/gl/?format=api", "source": [ "Choose <item type=\"menuitem\">Data - Consolidate</item> to open the <emph>Consolidate</emph> dialog." ], "previous_source": "", "target": [ "" ], "id_hash": -1340262079201837017, "content_hash": -1340262079201837017, "location": "consolidate.xhp", "context": "consolidate.xhp\npar_id3154513\nhelp.text", "note": "77VUk", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 1963321, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=6d666ebd6f3f8027", "url": "https://translations.documentfoundation.org/api/units/1963321/?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/gl/?format=api", "source": [ "From the <emph>Source data area</emph> box select a source cell range to consolidate with other areas." ], "previous_source": "", "target": [ "" ], "id_hash": 3568547474734044916, "content_hash": 3568547474734044916, "location": "consolidate.xhp", "context": "consolidate.xhp\npar_id3147345\nhelp.text", "note": "hJHqN", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 1963322, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=b186070573a3d6f4", "url": "https://translations.documentfoundation.org/api/units/1963322/?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/gl/?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": [ "" ], "id_hash": -667679353442180552, "content_hash": -667679353442180552, "location": "consolidate.xhp", "context": "consolidate.xhp\npar_id3149209\nhelp.text", "note": "CvGP2", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 1963323, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=76bbed2a62376238", "url": "https://translations.documentfoundation.org/api/units/1963323/?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/gl/?format=api", "source": [ "Click <emph>Add</emph> to insert the selected range in the <emph>Consolidation areas</emph> field." ], "previous_source": "", "target": [ "" ], "id_hash": 3848135511423935069, "content_hash": 3848135511423935069, "location": "consolidate.xhp", "context": "consolidate.xhp\npar_id3155529\nhelp.text", "note": "zSGyD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 1963324, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=b56752dbfdfd625d", "url": "https://translations.documentfoundation.org/api/units/1963324/?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/gl/?format=api", "source": [ "Select additional ranges and click <emph>Add</emph> after each selection." ], "previous_source": "", "target": [ "" ], "id_hash": 7169276099035941393, "content_hash": 7169276099035941393, "location": "consolidate.xhp", "context": "consolidate.xhp\npar_id3153816\nhelp.text", "note": "Fo56E", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 1963325, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=e37e62a0abbc4a11", "url": "https://translations.documentfoundation.org/api/units/1963325/?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/gl/?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": [ "" ], "id_hash": 398797832588757125, "content_hash": 398797832588757125, "location": "consolidate.xhp", "context": "consolidate.xhp\npar_id3157983\nhelp.text", "note": "85CXx", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 1963326, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=8588d0840ca60885", "url": "https://translations.documentfoundation.org/api/units/1963326/?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/gl/?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": [ "" ], "id_hash": -1876994938870961530, "content_hash": -1876994938870961530, "location": "consolidate.xhp", "context": "consolidate.xhp\npar_id3150215\nhelp.text", "note": "UByCi", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 1963327, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=65f3930c3f63ea86", "url": "https://translations.documentfoundation.org/api/units/1963327/?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/gl/?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": [ "" ], "id_hash": -6052783438683441990, "content_hash": -6052783438683441990, "location": "consolidate.xhp", "context": "consolidate.xhp\npar_id3153813\nhelp.text", "note": "JvD9q", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 1963328, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=2c00318812e7f4ba", "url": "https://translations.documentfoundation.org/api/units/1963328/?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/gl/?format=api", "source": [ "Click <emph>OK</emph> to consolidate the ranges." ], "previous_source": "", "target": [ "" ], "id_hash": -897663849380064562, "content_hash": -897663849380064562, "location": "consolidate.xhp", "context": "consolidate.xhp\npar_id3149315\nhelp.text", "note": "Z3iG2", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 1963329, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=738adb7c29fdd2ce", "url": "https://translations.documentfoundation.org/api/units/1963329/?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/gl/?format=api", "source": [ "Additional Settings" ], "previous_source": "", "target": [ "" ], "id_hash": 1386989742513126216, "content_hash": 1386989742513126216, "location": "consolidate.xhp", "context": "consolidate.xhp\npar_idN107DE\nhelp.text", "note": "qbEFs", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 1963330, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=933f93d27d9afb48", "url": "https://translations.documentfoundation.org/api/units/1963330/?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/gl/?format=api", "source": [ "Click <emph>More</emph> in the <emph>Consolidate</emph> dialog to display additional settings:" ], "previous_source": "", "target": [ "" ], "id_hash": -8685282467281095460, "content_hash": -8685282467281095460, "location": "consolidate.xhp", "context": "consolidate.xhp\npar_id3147250\nhelp.text", "note": "BSAXP", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 1963331, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=0777ad9cd3c834dc", "url": "https://translations.documentfoundation.org/api/units/1963331/?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/gl/?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": [ "" ], "id_hash": -3631865130924125807, "content_hash": -3631865130924125807, "location": "consolidate.xhp", "context": "consolidate.xhp\npar_id3156400\nhelp.text", "note": "DEEPq", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 1963332, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=4d9905e7e723d191", "url": "https://translations.documentfoundation.org/api/units/1963332/?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/gl/?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": [ "" ], "id_hash": -1379167358946436983, "content_hash": -1379167358946436983, "location": "consolidate.xhp", "context": "consolidate.xhp\npar_id3150538\nhelp.text", "note": "VJPHa", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 1963333, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=6cdc36981c2f1889", "url": "https://translations.documentfoundation.org/api/units/1963333/?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/gl/?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": [ "" ], "id_hash": 2054559487241974870, "content_hash": 2054559487241974870, "location": "consolidate.xhp", "context": "consolidate.xhp\npar_id3149945\nhelp.text", "note": "UubEm", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 1963334, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=9c8342f7d6f77456", "url": "https://translations.documentfoundation.org/api/units/1963334/?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/gl/?format=api", "source": [ "To consolidate by row labels or column labels, the label must be contained in the selected source ranges." ], "previous_source": "", "target": [ "" ], "id_hash": -3469891027884511483, "content_hash": -3469891027884511483, "location": "consolidate.xhp", "context": "consolidate.xhp\npar_id3157871\nhelp.text", "note": "AEjpi", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 1963335, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=4fd8787e91a0ef05", "url": "https://translations.documentfoundation.org/api/units/1963335/?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/gl/?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": [ "" ], "id_hash": 9184278295374865548, "content_hash": 9184278295374865548, "location": "consolidate.xhp", "context": "consolidate.xhp\npar_id3150478\nhelp.text", "note": "mQ3x2", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 1963336, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=ff751c730226248c", "url": "https://translations.documentfoundation.org/api/units/1963336/?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/gl/?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": [ "" ], "id_hash": -6048694902205384958, "content_hash": -6048694902205384958, "location": "consolidate.xhp", "context": "consolidate.xhp\npar_id3147468\nhelp.text", "note": "UMqz7", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 1963337, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=2c0eb808a754f702", "url": "https://translations.documentfoundation.org/api/units/1963337/?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/gl/?format=api", "source": [ "Importing and Exporting CSV Files" ], "previous_source": "", "target": [ "Importar e exportar ficheiros 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": 1963339, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/gl/?checksum=9ad011fdec15d9ad", "url": "https://translations.documentfoundation.org/api/units/1963339/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:44.522480Z" } ] }{ "count": 1559, "next": "