Changes
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/components/libo_help-7-6/textscalcguide/changes/?format=api&page=2850
{ "count": 142821, "next": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/changes/?format=api&page=2851", "previous": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/changes/?format=api&page=2849", "results": [ { "unit": "https://translations.documentfoundation.org/api/units/99016178/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.050820Z", "action": 59, "target": "<emph>To Cell:</emph> the image will move along with the cell, when copying, sorting or inserting and deleting cells above and on the left of the cell holding the anchor.", "id": 36428443, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428443/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99016148/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.050794Z", "action": 59, "target": "Images can be anchored in three different ways:", "id": 36428442, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428442/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99016119/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.050767Z", "action": 59, "target": "Images are inserted in a Calc spreadsheet anchored to cells by default and do not resize when the cell is moved.", "id": 36428441, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428441/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99016088/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.050742Z", "action": 59, "target": "<variable id=\"anchor_image\"><link href=\"text/scalc/guide/change_image_anchor.xhp\">Changing the Anchor of an Image</link> </variable>", "id": 36428440, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428440/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99016002/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.050716Z", "action": 59, "target": "<bookmark_value>anchor;image</bookmark_value><bookmark_value>image anchor;in Calc</bookmark_value><bookmark_value>image anchor in Calc;changing</bookmark_value>", "id": 36428439, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428439/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99015991/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.050690Z", "action": 59, "target": "Changing Image Anchor in Calc", "id": 36428438, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428438/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99015967/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.050662Z", "action": 59, "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": 36428437, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428437/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99015949/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.050637Z", "action": 59, "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": 36428436, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428436/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99015929/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.050611Z", "action": 59, "target": "Select the cells and choose <emph>Format - Cells</emph>.", "id": 36428435, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428435/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99015908/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.050585Z", "action": 59, "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 colors.", "id": 36428434, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428434/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99015879/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.050558Z", "action": 59, "target": "<variable id=\"cellstyle_minusvalue\"><link href=\"text/scalc/guide/cellstyle_minusvalue.xhp\">Highlighting Negative Numbers</link></variable>", "id": 36428433, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428433/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99015846/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.050531Z", "action": 59, "target": "<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>", "id": 36428432, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428432/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99015822/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.050506Z", "action": 59, "target": "Highlighting Negative Numbers", "id": 36428431, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428431/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99015802/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.050480Z", "action": 59, "target": "<link href=\"text/scalc/01/05120000.xhp\">Format - Conditional - Condition</link>", "id": 36428430, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428430/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99015771/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.050454Z", "action": 59, "target": "In the <emph>Paste</emph> area, check only the <emph>Formats</emph> box. All other boxes must be unchecked. Click <emph>OK</emph>. Or you can click the <emph>Formats only</emph> button instead.", "id": 36428429, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428429/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99015754/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.050428Z", "action": 59, "target": "Choose <emph>Edit - Paste Special - Paste Special</emph>. The <emph>Paste Special</emph> dialog appears.", "id": 36428428, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428428/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99015733/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.050402Z", "action": 59, "target": "Select the cells that are to receive this same formatting.", "id": 36428427, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428427/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99015717/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.050377Z", "action": 59, "target": "Copy the cell to the clipboard.", "id": 36428426, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428426/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99015674/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.050351Z", "action": 59, "target": "Click one of the cells that has been assigned conditional formatting.", "id": 36428425, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428425/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99015664/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.050325Z", "action": 59, "target": "To apply the conditional formatting to other cells later:", "id": 36428424, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428424/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99015642/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.050300Z", "action": 59, "target": "Step 5: Copy Cell Style", "id": 36428423, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428423/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99015608/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.050275Z", "action": 59, "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": 36428422, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428422/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99015577/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.050249Z", "action": 59, "target": "Choose the <emph>Format - Conditional - Condition</emph> command to open the corresponding dialog.", "id": 36428421, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428421/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99015533/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.050224Z", "action": 59, "target": "Select all cells with the random numbers.", "id": 36428420, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428420/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99015496/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.050199Z", "action": 59, "target": "Now you can apply the conditional formatting to the sheet:", "id": 36428419, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428419/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99015450/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.050173Z", "action": 59, "target": "Step 4: Apply Cell Styles", "id": 36428418, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428418/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99015437/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.050147Z", "action": 59, "target": "Close the Function Wizard with <item type=\"menuitem\">OK</item>.", "id": 36428417, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428417/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99015407/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.050121Z", "action": 59, "target": "Select the AVERAGE function. Use the mouse to select all your random numbers. If you cannot see the entire range, because the Function Wizard is obscuring it, you can temporarily shrink the dialog using the <link href=\"text/shared/00/00000001.xhp#shrink_maximize\"><item type=\"menuitem\">Shrink</item></link> icon.", "id": 36428416, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428416/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99015390/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.050094Z", "action": 59, "target": "Set the cursor in a blank cell, for example, J14, and choose <emph>Insert - Function</emph>.", "id": 36428415, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428415/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99015365/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.050069Z", "action": 59, "target": "In our particular example, we are calculating the average of the random values. The result is placed in a cell:", "id": 36428414, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428414/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99015348/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.050044Z", "action": 59, "target": "Step 3: Calculate Average", "id": 36428413, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428413/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99015310/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.050016Z", "action": 59, "target": "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\").", "id": 36428412, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428412/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99015307/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.049991Z", "action": 59, "target": "In the Styles deck of the Sidebar, click the <emph>New Style from Selection</emph> icon. Enter the name of the new style. For this example, name the style \"Above\".", "id": 36428411, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428411/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99015295/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.049965Z", "action": 59, "target": "In the <emph>Format Cells</emph> dialog on the <emph>Background</emph> tab, click the <emph>Color</emph> button and then select a background color. Click <emph>OK</emph>.", "id": 36428410, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428410/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99015273/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.049939Z", "action": 59, "target": "Click in a blank cell and select the command <emph>Format Cells</emph> in the context menu.", "id": 36428409, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428409/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99015250/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.049913Z", "action": 59, "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": 36428408, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428408/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99015231/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.049886Z", "action": 59, "target": "Step 2: Define Cell Styles", "id": 36428407, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428407/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99015208/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.049861Z", "action": 59, "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": 36428406, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428406/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99015189/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.049835Z", "action": 59, "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": 36428405, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428405/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99015172/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.049808Z", "action": 59, "target": "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).", "id": 36428404, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428404/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99015146/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.049782Z", "action": 59, "target": "First of all, create a table in which a few different values occur. For your test you can create tables with any random numbers:", "id": 36428403, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428403/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99015121/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.049755Z", "action": 59, "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": 36428402, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428402/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99015113/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.049730Z", "action": 59, "target": "Step1: Generate Number Values", "id": 36428401, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428401/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99015066/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.049704Z", "action": 59, "target": "Example of Conditional Formatting: Highlighting Totals Above/Under the Average Value", "id": 36428400, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428400/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99015062/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.049677Z", "action": 59, "target": "Enter the condition(s) into the dialog box. The dialog is described in detail in <link href=\"text/scalc/01/05120000.xhp\">$[officename] Help</link>, and an example is provided below:", "id": 36428399, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428399/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99015052/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.049652Z", "action": 59, "target": "Choose <emph>Format - Conditional - Condition</emph>.", "id": 36428398, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428398/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99015043/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.049625Z", "action": 59, "target": "Select the cells to which you want to apply a conditional style.", "id": 36428397, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428397/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99015034/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.049600Z", "action": 59, "target": "To Define the Conditions", "id": 36428396, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428396/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99015025/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.049573Z", "action": 59, "target": "With conditional formatting, you can, for example, highlight the totals that exceed the average value of all totals. If the totals change, the formatting changes correspondingly, without having to apply other styles manually.", "id": 36428395, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428395/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99015010/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.049546Z", "action": 59, "target": "To apply conditional formatting, AutoCalculate must be enabled. Choose <emph>Data - Calculate - AutoCalculate</emph> (you see a check mark next to the command when AutoCalculate is enabled).", "id": 36428394, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428394/?format=api" } ] }