Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-master/textscalcguide/en_GB/units/?format=api&page=6
{ "count": 1559, "next": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/units/?format=api&page=7", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/units/?format=api&page=5", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalcguide/en_GB/?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": [ "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." ], "id_hash": -4753521984506958934, "content_hash": -4753521984506958934, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3150043\nhelp.text", "note": "5TVr9", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 329, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 43, "source_unit": "https://translations.documentfoundation.org/api/units/24936420/?format=api", "priority": 100, "id": 1952061, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=3e0818f0b973ebaa", "url": "https://translations.documentfoundation.org/api/units/1952061/?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/en_GB/?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": [ "In one of the cells enter the formula =RAND(), and you will obtain a random number in the range 0.0 to 1.0. If you want integers in the range 0 to 50, enter the formula =INT(RAND()*50)." ], "id_hash": 7837711463613136779, "content_hash": 7837711463613136779, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3149565\nhelp.text", "note": "A66qh", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 331, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 33, "source_unit": "https://translations.documentfoundation.org/api/units/24936422/?format=api", "priority": 100, "id": 1952063, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=ecc5250cd8aaff8b", "url": "https://translations.documentfoundation.org/api/units/1952063/?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/en_GB/?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": [ "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." ], "id_hash": 6892568724043407820, "content_hash": 6892568724043407820, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3149258\nhelp.text", "note": "rCrEf", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 332, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 31, "source_unit": "https://translations.documentfoundation.org/api/units/24936423/?format=api", "priority": 100, "id": 1952064, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=dfa752bc729321cc", "url": "https://translations.documentfoundation.org/api/units/1952064/?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/en_GB/?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": [ "In the same way as described above, drag down the corner of the rightmost cell in order to create more rows of random numbers." ], "id_hash": -2947348419295557648, "content_hash": -2947348419295557648, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3159236\nhelp.text", "note": "Tm6MA", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 333, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://translations.documentfoundation.org/api/units/24936424/?format=api", "priority": 100, "id": 1952065, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=5718ea3a769447f0", "url": "https://translations.documentfoundation.org/api/units/1952065/?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/en_GB/?format=api", "source": [ "Step 2: Define Cell Styles" ], "previous_source": "", "target": [ "Step 2: Define Cell Styles" ], "id_hash": 1860090573670708058, "content_hash": 1860090573670708058, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\nhd_id3149211\nhelp.text", "note": "i3CTm", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 334, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/24936425/?format=api", "priority": 100, "id": 1952066, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=99d05e8585b1f35a", "url": "https://translations.documentfoundation.org/api/units/1952066/?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/en_GB/?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": [ "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." ], "id_hash": 2515053443613502634, "content_hash": 2515053443613502634, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3154659\nhelp.text", "note": "sr6WY", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 335, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 34, "source_unit": "https://translations.documentfoundation.org/api/units/24936426/?format=api", "priority": 100, "id": 1952067, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=a2e743c819b4acaa", "url": "https://translations.documentfoundation.org/api/units/1952067/?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/en_GB/?format=api", "source": [ "Click in a blank cell and select the command <emph>Format Cells</emph> in the context menu." ], "previous_source": "", "target": [ "Click in a blank cell and select the command <emph>Format Cells</emph> in the context menu." ], "id_hash": -6456560012199126547, "content_hash": -6456560012199126547, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3150883\nhelp.text", "note": "CVM3G", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 336, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/24936427/?format=api", "priority": 100, "id": 1952068, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=2665b0e091e119ed", "url": "https://translations.documentfoundation.org/api/units/1952068/?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/en_GB/?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": [ "To define a second style, click again in a blank cell and proceed as described above. Assign a different background colour for the cell and assign a name (for this example, \"Below\")." ], "id_hash": 2559261581071111980, "content_hash": 2559261581071111980, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3152889\nhelp.text", "note": "4bRZa", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 339, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 32, "source_unit": "https://translations.documentfoundation.org/api/units/24936430/?format=api", "priority": 100, "id": 1952071, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=a38452d9330c572c", "url": "https://translations.documentfoundation.org/api/units/1952071/?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/en_GB/?format=api", "source": [ "Step 3: Calculate Average" ], "previous_source": "", "target": [ "Step 3: Calculate Average" ], "id_hash": 7675455618679043080, "content_hash": 7675455618679043080, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\nhd_id3148704\nhelp.text", "note": "x3rxG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 340, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/24936431/?format=api", "priority": 100, "id": 1952072, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=ea84b23808a3f408", "url": "https://translations.documentfoundation.org/api/units/1952072/?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/en_GB/?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": [ "In our particular example, we are calculating the average of the random values. The result is placed in a cell:" ], "id_hash": 4578609383930617086, "content_hash": 4578609383930617086, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3148837\nhelp.text", "note": "f5sxG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 341, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/24936432/?format=api", "priority": 100, "id": 1952073, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=bf8a7cf9e6745cfe", "url": "https://translations.documentfoundation.org/api/units/1952073/?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/en_GB/?format=api", "source": [ "Set the cursor in a blank cell, for example, J14, and choose <emph>Insert - Function</emph>." ], "previous_source": "", "target": [ "Set the cursor in a blank cell, for example, J14, and choose <emph>Insert - Function</emph>." ], "id_hash": -1641327560713127346, "content_hash": -1641327560713127346, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3144768\nhelp.text", "note": "GhHpd", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 342, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/24936433/?format=api", "priority": 100, "id": 1952074, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=6938d54797a2ba4e", "url": "https://translations.documentfoundation.org/api/units/1952074/?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/en_GB/?format=api", "source": [ "Close the Function Wizard with <item type=\"menuitem\">OK</item>." ], "previous_source": "", "target": [ "Close the Function Wizard with <item type=\"menuitem\">OK</item>." ], "id_hash": -5015363106791229593, "content_hash": -5015363106791229593, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3153246\nhelp.text", "note": "YEqsh", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 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": 1952076, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=3a65d9d3b01bf767", "url": "https://translations.documentfoundation.org/api/units/1952076/?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/en_GB/?format=api", "source": [ "Step 4: Apply Cell Styles" ], "previous_source": "", "target": [ "Step 4: Apply Cell Styles" ], "id_hash": -6453200130585452393, "content_hash": -6453200130585452393, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\nhd_id3149898\nhelp.text", "note": "75WFf", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 345, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/24936436/?format=api", "priority": 100, "id": 1952077, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=2671a0abf7f32097", "url": "https://translations.documentfoundation.org/api/units/1952077/?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/en_GB/?format=api", "source": [ "Now you can apply the conditional formatting to the sheet:" ], "previous_source": "", "target": [ "Now you can apply the conditional formatting to the sheet:" ], "id_hash": 7382243818509673232, "content_hash": 7382243818509673232, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3149126\nhelp.text", "note": "AA6JP", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 346, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/24936437/?format=api", "priority": 100, "id": 1952078, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=e672ffa3df97a310", "url": "https://translations.documentfoundation.org/api/units/1952078/?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/en_GB/?format=api", "source": [ "Select all cells with the random numbers." ], "previous_source": "", "target": [ "Select all cells with the random numbers." ], "id_hash": 7136521799982947324, "content_hash": 7136521799982947324, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3150049\nhelp.text", "note": "7YuzB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 347, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/24936438/?format=api", "priority": 100, "id": 1952079, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=e30a04c423d09bfc", "url": "https://translations.documentfoundation.org/api/units/1952079/?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/en_GB/?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": [ "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\"." ], "id_hash": -3867351834357650696, "content_hash": -3867351834357650696, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3153013\nhelp.text", "note": "oaUQo", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 349, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 33, "source_unit": "https://translations.documentfoundation.org/api/units/24936440/?format=api", "priority": 100, "id": 1952081, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=4a5467ff2ba82af8", "url": "https://translations.documentfoundation.org/api/units/1952081/?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/en_GB/?format=api", "source": [ "Step 5: Copy Cell Style" ], "previous_source": "", "target": [ "Step 5: Copy Cell Style" ], "id_hash": 6888277942235367290, "content_hash": 6888277942235367290, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\nhd_id3155761\nhelp.text", "note": "p9FR7", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 350, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/24936441/?format=api", "priority": 100, "id": 1952082, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=df98144af519077a", "url": "https://translations.documentfoundation.org/api/units/1952082/?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/en_GB/?format=api", "source": [ "To apply the conditional formatting to other cells later:" ], "previous_source": "", "target": [ "To apply the conditional formatting to other cells later:" ], "id_hash": -7215413165649662082, "content_hash": -7215413165649662082, "location": "cellstyle_conditional.xhp", "context": "cellstyle_conditional.xhp\npar_id3145320\nhelp.text", "note": "GBgrB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 351, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/24936442/?format=api", "priority": 100, "id": 1952083, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=1bddb3f469c66f7e", "url": "https://translations.documentfoundation.org/api/units/1952083/?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/en_GB/?format=api", "source": [ "Click one of the cells that has been assigned conditional formatting." ], "previous_source": "", "target": [ "Click one of the cells that has been assigned conditional formatting." ], "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": 1952084, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=e3deacc95b213775", "url": "https://translations.documentfoundation.org/api/units/1952084/?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/en_GB/?format=api", "source": [ "Copy the cell to the clipboard." ], "previous_source": "", "target": [ "Copy the cell to the clipboard." ], "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": 1952085, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=ca0399942d6914f7", "url": "https://translations.documentfoundation.org/api/units/1952085/?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/en_GB/?format=api", "source": [ "Select the cells that are to receive this same formatting." ], "previous_source": "", "target": [ "Select the cells that are to receive this same formatting." ], "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": 1952086, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=d0b6c4acbf9fea6d", "url": "https://translations.documentfoundation.org/api/units/1952086/?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/en_GB/?format=api", "source": [ "Highlighting Negative Numbers" ], "previous_source": "", "target": [ "Highlighting Negative Numbers" ], "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": 1952090, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=47aa19470c852133", "url": "https://translations.documentfoundation.org/api/units/1952090/?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/en_GB/?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>negative numbers</bookmark_value> <bookmark_value>numbers; highlighting negative numbers</bookmark_value> <bookmark_value>highlighting;negative numbers</bookmark_value> <bookmark_value>colours;negative numbers</bookmark_value> <bookmark_value>number formats;colours for negative numbers</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": 1952091, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=a558064ab03c5756", "url": "https://translations.documentfoundation.org/api/units/1952091/?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/en_GB/?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": [ "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 colours." ], "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": 1952093, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=5eac443043364b61", "url": "https://translations.documentfoundation.org/api/units/1952093/?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/en_GB/?format=api", "source": [ "Select the cells and choose <emph>Format - Cells</emph>." ], "previous_source": "", "target": [ "Select the cells and choose <emph>Format - Cells</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": 1952094, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=5bc61515fd68f83f", "url": "https://translations.documentfoundation.org/api/units/1952094/?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/en_GB/?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": [ "On the <emph>Numbers</emph> tab, select a number format and mark <emph>Negative numbers red</emph> check box. Click <emph>OK</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": 1952095, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=5cdebab6fd82a02f", "url": "https://translations.documentfoundation.org/api/units/1952095/?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/en_GB/?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": [ "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." ], "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": 1952096, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=42a046265d496233", "url": "https://translations.documentfoundation.org/api/units/1952096/?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/en_GB/?format=api", "source": [ "Consolidating Data" ], "previous_source": "", "target": [ "Consolidating Data" ], "id_hash": 5372822363492069186, "content_hash": 5372822363492069186, "location": "consolidate.xhp", "context": "consolidate.xhp\ntit\nhelp.text", "note": "G5Dfz", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 376, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24936456/?format=api", "priority": 100, "id": 1952097, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=ca90197921382f42", "url": "https://translations.documentfoundation.org/api/units/1952097/?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/en_GB/?format=api", "source": [ "<bookmark_value>consolidating data</bookmark_value> <bookmark_value>ranges; combining</bookmark_value> <bookmark_value>combining;cell ranges</bookmark_value> <bookmark_value>tables; combining</bookmark_value> <bookmark_value>data; merging cell ranges</bookmark_value> <bookmark_value>merging;data ranges</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>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>" ], "id_hash": -8699824088904455889, "content_hash": -8699824088904455889, "location": "consolidate.xhp", "context": "consolidate.xhp\nbm_id3150791\nhelp.text", "note": "dEYi9", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 377, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/24936457/?format=api", "priority": 100, "id": 1952098, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=07440415b476a92f", "url": "https://translations.documentfoundation.org/api/units/1952098/?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/en_GB/?format=api", "source": [ "During consolidation, the contents of the cells from several sheets will be combined in one place." ], "previous_source": "", "target": [ "During consolidation, the contents of the cells from several sheets will be combined in one place." ], "id_hash": 2863811470568569986, "content_hash": 2863811470568569986, "location": "consolidate.xhp", "context": "consolidate.xhp\npar_id3153191\nhelp.text", "note": "dcJqU", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 379, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/24936459/?format=api", "priority": 100, "id": 1952100, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=a7be4d5bfeedbc82", "url": "https://translations.documentfoundation.org/api/units/1952100/?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/en_GB/?format=api", "source": [ "To Combine Cell Contents" ], "previous_source": "", "target": [ "To Combine Contents of Cells" ], "id_hash": -7418047071167571604, "content_hash": -7418047071167571604, "location": "consolidate.xhp", "context": "consolidate.xhp\nhd_id892056\nhelp.text", "note": "GyvFB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 380, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/24936460/?format=api", "priority": 100, "id": 1952101, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=190dcd7dc3ee196c", "url": "https://translations.documentfoundation.org/api/units/1952101/?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/en_GB/?format=api", "source": [ "Open the document that contains the cell ranges to be consolidated." ], "previous_source": "", "target": [ "Open the document that contains the cell ranges to be consolidated." ], "id_hash": 830377358914747267, "content_hash": 830377358914747267, "location": "consolidate.xhp", "context": "consolidate.xhp\npar_id3151073\nhelp.text", "note": "4tD6G", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 381, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/24936461/?format=api", "priority": 100, "id": 1952102, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=8b8617cef3a3fb83", "url": "https://translations.documentfoundation.org/api/units/1952102/?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/en_GB/?format=api", "source": [ "Choose <item type=\"menuitem\">Data - Consolidate</item> to open the <emph>Consolidate</emph> dialog." ], "previous_source": "", "target": [ "Choose <item type=\"menuitem\">Data - Consolidate</item> to open the <emph>Consolidate</emph> dialogue box." ], "id_hash": -1340262079201837017, "content_hash": -1340262079201837017, "location": "consolidate.xhp", "context": "consolidate.xhp\npar_id3154513\nhelp.text", "note": "77VUk", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 382, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/24936462/?format=api", "priority": 100, "id": 1952103, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=6d666ebd6f3f8027", "url": "https://translations.documentfoundation.org/api/units/1952103/?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/en_GB/?format=api", "source": [ "From the <emph>Source data area</emph> box select a source cell range to consolidate with other areas." ], "previous_source": "", "target": [ "From the <emph>Source data area</emph> box select a source cell range to consolidate with other areas." ], "id_hash": 3568547474734044916, "content_hash": 3568547474734044916, "location": "consolidate.xhp", "context": "consolidate.xhp\npar_id3147345\nhelp.text", "note": "hJHqN", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 383, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/24936463/?format=api", "priority": 100, "id": 1952104, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=b186070573a3d6f4", "url": "https://translations.documentfoundation.org/api/units/1952104/?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/en_GB/?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": [ "If the range is not named, click in the field next to the <emph>Source data area</emph>. A blinking text cursor will appear. Type a reference for the first source data range or select the range with the mouse." ], "id_hash": -667679353442180552, "content_hash": -667679353442180552, "location": "consolidate.xhp", "context": "consolidate.xhp\npar_id3149209\nhelp.text", "note": "CvGP2", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 384, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 37, "source_unit": "https://translations.documentfoundation.org/api/units/24936464/?format=api", "priority": 100, "id": 1952105, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=76bbed2a62376238", "url": "https://translations.documentfoundation.org/api/units/1952105/?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/en_GB/?format=api", "source": [ "Click <emph>Add</emph> to insert the selected range in the <emph>Consolidation areas</emph> field." ], "previous_source": "", "target": [ "Click <emph>Add</emph> to insert the selected range in the <emph>Consolidation areas</emph> field." ], "id_hash": 3848135511423935069, "content_hash": 3848135511423935069, "location": "consolidate.xhp", "context": "consolidate.xhp\npar_id3155529\nhelp.text", "note": "zSGyD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 385, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/24936465/?format=api", "priority": 100, "id": 1952106, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=b56752dbfdfd625d", "url": "https://translations.documentfoundation.org/api/units/1952106/?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/en_GB/?format=api", "source": [ "Select additional ranges and click <emph>Add</emph> after each selection." ], "previous_source": "", "target": [ "Select additional ranges and click <emph>Add</emph> after each selection." ], "id_hash": 7169276099035941393, "content_hash": 7169276099035941393, "location": "consolidate.xhp", "context": "consolidate.xhp\npar_id3153816\nhelp.text", "note": "Fo56E", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 386, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/24936466/?format=api", "priority": 100, "id": 1952107, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=e37e62a0abbc4a11", "url": "https://translations.documentfoundation.org/api/units/1952107/?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/en_GB/?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": [ "Specify where you want to display the result by selecting a target range from the <emph>Copy results to</emph> box." ], "id_hash": 398797832588757125, "content_hash": 398797832588757125, "location": "consolidate.xhp", "context": "consolidate.xhp\npar_id3157983\nhelp.text", "note": "85CXx", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 387, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/24936467/?format=api", "priority": 100, "id": 1952108, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=8588d0840ca60885", "url": "https://translations.documentfoundation.org/api/units/1952108/?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/en_GB/?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": [ "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." ], "id_hash": -1876994938870961530, "content_hash": -1876994938870961530, "location": "consolidate.xhp", "context": "consolidate.xhp\npar_id3150215\nhelp.text", "note": "UByCi", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 388, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 46, "source_unit": "https://translations.documentfoundation.org/api/units/24936468/?format=api", "priority": 100, "id": 1952109, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=65f3930c3f63ea86", "url": "https://translations.documentfoundation.org/api/units/1952109/?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/en_GB/?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": [ "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." ], "id_hash": -6052783438683441990, "content_hash": -6052783438683441990, "location": "consolidate.xhp", "context": "consolidate.xhp\npar_id3153813\nhelp.text", "note": "JvD9q", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 389, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/24936469/?format=api", "priority": 100, "id": 1952110, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=2c00318812e7f4ba", "url": "https://translations.documentfoundation.org/api/units/1952110/?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/en_GB/?format=api", "source": [ "Click <emph>OK</emph> to consolidate the ranges." ], "previous_source": "", "target": [ "Click <emph>OK</emph> to consolidate the ranges." ], "id_hash": -897663849380064562, "content_hash": -897663849380064562, "location": "consolidate.xhp", "context": "consolidate.xhp\npar_id3149315\nhelp.text", "note": "Z3iG2", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 390, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/24936470/?format=api", "priority": 100, "id": 1952111, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=738adb7c29fdd2ce", "url": "https://translations.documentfoundation.org/api/units/1952111/?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/en_GB/?format=api", "source": [ "Additional Settings" ], "previous_source": "", "target": [ "Additional Settings" ], "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": 1952112, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=933f93d27d9afb48", "url": "https://translations.documentfoundation.org/api/units/1952112/?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/en_GB/?format=api", "source": [ "Click <emph>More</emph> in the <emph>Consolidate</emph> dialog to display additional settings:" ], "previous_source": "", "target": [ "Click <emph>More</emph> in the <emph>Consolidate</emph> dialogue box to display additional settings:" ], "id_hash": -8685282467281095460, "content_hash": -8685282467281095460, "location": "consolidate.xhp", "context": "consolidate.xhp\npar_id3147250\nhelp.text", "note": "BSAXP", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 392, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/24936472/?format=api", "priority": 100, "id": 1952113, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=0777ad9cd3c834dc", "url": "https://translations.documentfoundation.org/api/units/1952113/?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/en_GB/?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": [ "Select <emph>Link to source data</emph> to insert the formulae 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." ], "id_hash": -3631865130924125807, "content_hash": -3631865130924125807, "location": "consolidate.xhp", "context": "consolidate.xhp\npar_id3156400\nhelp.text", "note": "DEEPq", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 393, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 41, "source_unit": "https://translations.documentfoundation.org/api/units/24936473/?format=api", "priority": 100, "id": 1952114, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=4d9905e7e723d191", "url": "https://translations.documentfoundation.org/api/units/1952114/?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/en_GB/?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": [ "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." ], "id_hash": -1379167358946436983, "content_hash": -1379167358946436983, "location": "consolidate.xhp", "context": "consolidate.xhp\npar_id3150538\nhelp.text", "note": "VJPHa", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 394, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 33, "source_unit": "https://translations.documentfoundation.org/api/units/24936474/?format=api", "priority": 100, "id": 1952115, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=6cdc36981c2f1889", "url": "https://translations.documentfoundation.org/api/units/1952115/?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/en_GB/?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": [ "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." ], "id_hash": 2054559487241974870, "content_hash": 2054559487241974870, "location": "consolidate.xhp", "context": "consolidate.xhp\npar_id3149945\nhelp.text", "note": "UubEm", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 395, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 45, "source_unit": "https://translations.documentfoundation.org/api/units/24936475/?format=api", "priority": 100, "id": 1952116, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=9c8342f7d6f77456", "url": "https://translations.documentfoundation.org/api/units/1952116/?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/en_GB/?format=api", "source": [ "To consolidate by row labels or column labels, the label must be contained in the selected source ranges." ], "previous_source": "", "target": [ "To consolidate by row labels or column labels, the label must be contained in the selected source ranges." ], "id_hash": -3469891027884511483, "content_hash": -3469891027884511483, "location": "consolidate.xhp", "context": "consolidate.xhp\npar_id3157871\nhelp.text", "note": "AEjpi", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 396, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/24936476/?format=api", "priority": 100, "id": 1952117, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=4fd8787e91a0ef05", "url": "https://translations.documentfoundation.org/api/units/1952117/?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/en_GB/?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": [ "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." ], "id_hash": 9184278295374865548, "content_hash": 9184278295374865548, "location": "consolidate.xhp", "context": "consolidate.xhp\npar_id3150478\nhelp.text", "note": "mQ3x2", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 397, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 43, "source_unit": "https://translations.documentfoundation.org/api/units/24936477/?format=api", "priority": 100, "id": 1952118, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=ff751c730226248c", "url": "https://translations.documentfoundation.org/api/units/1952118/?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/en_GB/?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": [ "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." ], "id_hash": -6048694902205384958, "content_hash": -6048694902205384958, "location": "consolidate.xhp", "context": "consolidate.xhp\npar_id3147468\nhelp.text", "note": "UMqz7", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 398, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 35, "source_unit": "https://translations.documentfoundation.org/api/units/24936478/?format=api", "priority": 100, "id": 1952119, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=2c0eb808a754f702", "url": "https://translations.documentfoundation.org/api/units/1952119/?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/en_GB/?format=api", "source": [ "Importing and Exporting CSV Files" ], "previous_source": "", "target": [ "Importing and Exporting CSV Files" ], "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": 1952121, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalcguide/en_GB/?checksum=9ad011fdec15d9ad", "url": "https://translations.documentfoundation.org/api/units/1952121/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:51:44.522480Z" } ] }