Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-master/textscalcguide/eo/units/?format=api&page=6
{ "count": 1559, "next": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/eo/units/?format=api&page=7", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/eo/units/?format=api&page=5", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/eo/?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": 1955493, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=3e0818f0b973ebaa", "url": "https://translations.documentfoundation.org/api/units/1955493/?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/eo/?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": 1955495, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=ecc5250cd8aaff8b", "url": "https://translations.documentfoundation.org/api/units/1955495/?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/eo/?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": 1955496, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=dfa752bc729321cc", "url": "https://translations.documentfoundation.org/api/units/1955496/?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/eo/?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": 1955497, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=5718ea3a769447f0", "url": "https://translations.documentfoundation.org/api/units/1955497/?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/eo/?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": 1955500, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=99d05e8585b1f35a", "url": "https://translations.documentfoundation.org/api/units/1955500/?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/eo/?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": 1955501, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=a2e743c819b4acaa", "url": "https://translations.documentfoundation.org/api/units/1955501/?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/eo/?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": 1955503, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=2665b0e091e119ed", "url": "https://translations.documentfoundation.org/api/units/1955503/?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/eo/?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": 1955507, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=a38452d9330c572c", "url": "https://translations.documentfoundation.org/api/units/1955507/?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/eo/?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": 1955509, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=ea84b23808a3f408", "url": "https://translations.documentfoundation.org/api/units/1955509/?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/eo/?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": 1955511, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=bf8a7cf9e6745cfe", "url": "https://translations.documentfoundation.org/api/units/1955511/?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/eo/?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": 1955512, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=6938d54797a2ba4e", "url": "https://translations.documentfoundation.org/api/units/1955512/?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/eo/?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": 1955515, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=3a65d9d3b01bf767", "url": "https://translations.documentfoundation.org/api/units/1955515/?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/eo/?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": 1955518, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=2671a0abf7f32097", "url": "https://translations.documentfoundation.org/api/units/1955518/?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/eo/?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": 1955519, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=e672ffa3df97a310", "url": "https://translations.documentfoundation.org/api/units/1955519/?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/eo/?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": 1955521, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=e30a04c423d09bfc", "url": "https://translations.documentfoundation.org/api/units/1955521/?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/eo/?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": 1955525, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=4a5467ff2ba82af8", "url": "https://translations.documentfoundation.org/api/units/1955525/?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/eo/?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": 1955527, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=df98144af519077a", "url": "https://translations.documentfoundation.org/api/units/1955527/?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/eo/?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": 1955530, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=1bddb3f469c66f7e", "url": "https://translations.documentfoundation.org/api/units/1955530/?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/eo/?format=api", "source": [ "Click one of the cells that has been assigned conditional formatting." ], "previous_source": "", "target": [ "" ], "id_hash": 7196379235401938805, "content_hash": 7196379235401938805, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3153074\nhelp.text", "note": "soRTt", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 1955531, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=e3deacc95b213775", "url": "https://translations.documentfoundation.org/api/units/1955531/?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/eo/?format=api", "source": [ "Copy the cell to the clipboard." ], "previous_source": "", "target": [ "" ], "id_hash": 5333275245432870135, "content_hash": 5333275245432870135, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3149051\nhelp.text", "note": "35S7X", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 1955534, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=ca0399942d6914f7", "url": "https://translations.documentfoundation.org/api/units/1955534/?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/eo/?format=api", "source": [ "Select the cells that are to receive this same formatting." ], "previous_source": "", "target": [ "" ], "id_hash": 5816052215023921773, "content_hash": 5816052215023921773, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3150436\nhelp.text", "note": "ogFEX", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 1955535, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=d0b6c4acbf9fea6d", "url": "https://translations.documentfoundation.org/api/units/1955535/?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/eo/?format=api", "source": [ "Highlighting Negative Numbers" ], "previous_source": "", "target": [ "" ], "id_hash": -4059404321177657037, "content_hash": -4059404321177657037, "location": "cellstyle_minusvalue.xhp", "context": "cellstyle_minusvalue.xhp\ntit\nhelp.text", "note": "HFoKB", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 1955546, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=47aa19470c852133", "url": "https://translations.documentfoundation.org/api/units/1955546/?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/eo/?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": [ "" ], "id_hash": 2690907695207962454, "content_hash": 2690907695207962454, "location": "cellstyle_minusvalue.xhp", "context": "cellstyle_minusvalue.xhp\nbm_id3147434\nhelp.text", "note": "9Zqdi", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 1955548, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=a558064ab03c5756", "url": "https://translations.documentfoundation.org/api/units/1955548/?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/eo/?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": [ "" ], "id_hash": -2401469527218566303, "content_hash": -2401469527218566303, "location": "cellstyle_minusvalue.xhp", "context": "cellstyle_minusvalue.xhp\npar_id3153878\nhelp.text", "note": "YGxpk", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 1955551, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=5eac443043364b61", "url": "https://translations.documentfoundation.org/api/units/1955551/?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/eo/?format=api", "source": [ "Select the cells and choose <emph>Format - Cells</emph>." ], "previous_source": "", "target": [ "" ], "id_hash": -2610375749824612289, "content_hash": -2610375749824612289, "location": "cellstyle_minusvalue.xhp", "context": "cellstyle_minusvalue.xhp\npar_id3155600\nhelp.text", "note": "ZFJHU", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 1955553, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=5bc61515fd68f83f", "url": "https://translations.documentfoundation.org/api/units/1955553/?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/eo/?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 langeto <emph>Numeroj</emph>, elektu numeran formaton kaj marku la butonon <emph>Negativajn numerojn ruĝigu</emph>. Alklaku je <emph>Akcepti</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": 1955555, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=5cdebab6fd82a02f", "url": "https://translations.documentfoundation.org/api/units/1955555/?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/eo/?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": [ "" ], "id_hash": -4422457703490035149, "content_hash": -4422457703490035149, "location": "cellstyle_minusvalue.xhp", "context": "cellstyle_minusvalue.xhp\npar_id3145640\nhelp.text", "note": "23n86", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 1955558, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=42a046265d496233", "url": "https://translations.documentfoundation.org/api/units/1955558/?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/eo/?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": 1955559, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=ca90197921382f42", "url": "https://translations.documentfoundation.org/api/units/1955559/?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/eo/?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": 1955562, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=07440415b476a92f", "url": "https://translations.documentfoundation.org/api/units/1955562/?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/eo/?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": 1955565, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=a7be4d5bfeedbc82", "url": "https://translations.documentfoundation.org/api/units/1955565/?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/eo/?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": 1955567, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=190dcd7dc3ee196c", "url": "https://translations.documentfoundation.org/api/units/1955567/?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/eo/?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": 1955569, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=8b8617cef3a3fb83", "url": "https://translations.documentfoundation.org/api/units/1955569/?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/eo/?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": 1955572, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=6d666ebd6f3f8027", "url": "https://translations.documentfoundation.org/api/units/1955572/?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/eo/?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": 1955574, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=b186070573a3d6f4", "url": "https://translations.documentfoundation.org/api/units/1955574/?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/eo/?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": 1955575, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=76bbed2a62376238", "url": "https://translations.documentfoundation.org/api/units/1955575/?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/eo/?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": 1955576, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=b56752dbfdfd625d", "url": "https://translations.documentfoundation.org/api/units/1955576/?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/eo/?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": 1955577, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=e37e62a0abbc4a11", "url": "https://translations.documentfoundation.org/api/units/1955577/?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/eo/?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": 1955578, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=8588d0840ca60885", "url": "https://translations.documentfoundation.org/api/units/1955578/?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/eo/?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": 1955579, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=65f3930c3f63ea86", "url": "https://translations.documentfoundation.org/api/units/1955579/?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/eo/?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": 1955580, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=2c00318812e7f4ba", "url": "https://translations.documentfoundation.org/api/units/1955580/?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/eo/?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": 1955581, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=738adb7c29fdd2ce", "url": "https://translations.documentfoundation.org/api/units/1955581/?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/eo/?format=api", "source": [ "Additional Settings" ], "previous_source": "", "target": [ "Aldona agordaro" ], "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": 1955582, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=933f93d27d9afb48", "url": "https://translations.documentfoundation.org/api/units/1955582/?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/eo/?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": 1955583, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=0777ad9cd3c834dc", "url": "https://translations.documentfoundation.org/api/units/1955583/?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/eo/?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": 1955584, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=4d9905e7e723d191", "url": "https://translations.documentfoundation.org/api/units/1955584/?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/eo/?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": 1955585, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=6cdc36981c2f1889", "url": "https://translations.documentfoundation.org/api/units/1955585/?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/eo/?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": 1955586, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=9c8342f7d6f77456", "url": "https://translations.documentfoundation.org/api/units/1955586/?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/eo/?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": 1955587, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=4fd8787e91a0ef05", "url": "https://translations.documentfoundation.org/api/units/1955587/?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/eo/?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": 1955588, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=ff751c730226248c", "url": "https://translations.documentfoundation.org/api/units/1955588/?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/eo/?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": 1955589, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=2c0eb808a754f702", "url": "https://translations.documentfoundation.org/api/units/1955589/?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/eo/?format=api", "source": [ "Importing and Exporting CSV Files" ], "previous_source": "", "target": [ "" ], "id_hash": 1932064022427195821, "content_hash": 1932064022427195821, "location": "csv_files.xhp", "context": "csv_files.xhp\ntit\nhelp.text", "note": "UNSjU", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 1955591, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/eo/?checksum=9ad011fdec15d9ad", "url": "https://translations.documentfoundation.org/api/units/1955591/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:44.522480Z" } ] }