Changes

HTTP 200 OK
Allow: GET, HEAD, OPTIONS
Content-Type: application/json
Vary: Accept

{
    "count": 143072,
    "next": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/changes/?format=api&page=2847",
    "previous": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/changes/?format=api&page=2845",
    "results": [
        {
            "unit": "https://translations.documentfoundation.org/api/units/99033038/?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.630545Z",
            "action": 59,
            "target": "In the <emph>File type</emph> list box, in the area with the other <item type=\"productname\">%PRODUCTNAME</item> Calc filters, choose the file type \"HTML Document (<item type=\"productname\">%PRODUCTNAME</item> Calc)\".",
            "id": 36428894,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428894/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99033008/?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.630499Z",
            "action": 59,
            "target": "To save the current Calc document as HTML, choose <emph>File - Save As</emph>.",
            "id": 36428893,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428893/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99032974/?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.630453Z",
            "action": 59,
            "target": "Numbers are shown as written. In addition, in the <SDVAL> HTML tag, the exact internal number value is written so that after opening the HTML document with <item type=\"productname\">%PRODUCTNAME</item> you know you have the exact values.",
            "id": 36428892,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428892/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99032934/?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.630411Z",
            "action": 59,
            "target": "<item type=\"productname\">%PRODUCTNAME</item> Calc saves all the sheets of a Calc document together as an HTML document. At the beginning of the HTML document, a heading and a list of hyperlinks are automatically added which lead to the individual sheets within the document.",
            "id": 36428891,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428891/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99032904/?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.630371Z",
            "action": 59,
            "target": "Saving Sheets in HTML",
            "id": 36428890,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428890/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99032867/?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.630328Z",
            "action": 59,
            "target": "<variable id=\"html_doc\"><link href=\"text/scalc/guide/html_doc.xhp\">Saving and Opening Sheets in HTML</link></variable>",
            "id": 36428889,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428889/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99032804/?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.630285Z",
            "action": 59,
            "target": "<bookmark_value>HTML; sheets</bookmark_value><bookmark_value>sheets; HTML</bookmark_value><bookmark_value>saving; sheets in HTML</bookmark_value><bookmark_value>opening; sheets in HTML</bookmark_value>",
            "id": 36428888,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428888/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99032779/?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.630242Z",
            "action": 59,
            "target": "Saving and Opening Sheets in HTML",
            "id": 36428887,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428887/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99032778/?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.630200Z",
            "action": 59,
            "target": "<link href=\"text/scalc/01/06040000.xhp\">Goal Seek</link>",
            "id": 36428886,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428886/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99032777/?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.630160Z",
            "action": 59,
            "target": "A dialog appears informing you that the Goal Seek was successful. Click <emph>Yes</emph> to enter the result in the cell with the variable value.",
            "id": 36428885,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428885/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99032776/?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.630119Z",
            "action": 59,
            "target": "Enter the expected result of the formula in the <emph>Target Value</emph> text box. In this example, the value is 15,000. Click <emph>OK</emph>.",
            "id": 36428884,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428884/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99032759/?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.630075Z",
            "action": 59,
            "target": "Place the cursor in the field <emph>Variable Cell</emph>. In the sheet, click in the cell that contains the value to be changed, in this example it is the cell with the capital value <item type=\"literal\">C</item>.",
            "id": 36428883,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428883/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99032720/?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.630034Z",
            "action": 59,
            "target": "The correct cell is already entered in the field <emph>Formula Cell</emph>.",
            "id": 36428882,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428882/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99032690/?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.629992Z",
            "action": 59,
            "target": "Place the cursor in the cell containing the interest <item type=\"literal\">I</item>, and choose <emph>Tools - Goal Seek</emph>. The <emph>Goal Seek</emph> dialog appears.",
            "id": 36428881,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428881/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99032657/?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.629948Z",
            "action": 59,
            "target": "Enter each of the values for Capital <item type=\"literal\">C</item> (an arbitrary value like <item type=\"literal\">$100,000</item>), number of years <item type=\"literal\">n </item>(<item type=\"literal\">1</item>), and interest rate <item type=\"literal\">i</item> (<item type=\"literal\">7.5%</item>) in one cell each. Enter the formula to calculate the interest <item type=\"literal\">I</item> in another cell. Instead of <item type=\"literal\">C</item>, <item type=\"literal\">n</item>, and <item type=\"literal\">i</item> use the <link href=\"text/scalc/guide/relativ_absolut_ref.xhp\">reference to the cell</link> with the corresponding value.",
            "id": 36428880,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428880/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99032620/?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.629906Z",
            "action": 59,
            "target": "Let us assume that the interest rate <item type=\"literal\">i</item> of 7.5% and the number of years <item type=\"literal\">n</item> (1) will remain constant. However, you want to know how much the investment capital <item type=\"literal\">C</item> would have to be modified in order to attain a particular return <item type=\"literal\">I</item>. For this example, calculate how much capital <item type=\"literal\">C</item> would be required if you want an annual return of $15,000.",
            "id": 36428879,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428879/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99032593/?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.629862Z",
            "action": 59,
            "target": "I = C * n* i",
            "id": 36428878,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428878/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99032567/?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.629817Z",
            "action": 59,
            "target": "To calculate annual interest (I), create a table with the values for the capital (C), number of years (n), and interest rate (i). The formula is:",
            "id": 36428877,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428877/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99032525/?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.629770Z",
            "action": 59,
            "target": "Goal Seek Example",
            "id": 36428876,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428876/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99032496/?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.629722Z",
            "action": 59,
            "target": "With the help of Goal Seek you can calculate a value that, as part of a formula, leads to the result you specify for the formula. You thus define the formula with several fixed values and one variable value and the result of the formula.",
            "id": 36428875,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428875/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99032467/?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.629673Z",
            "action": 59,
            "target": "<variable id=\"goalseek\"><link href=\"text/scalc/guide/goalseek.xhp\">Applying Goal Seek</link></variable>",
            "id": 36428874,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428874/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99032432/?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.629624Z",
            "action": 59,
            "target": "<bookmark_value>goal seeking;example</bookmark_value><bookmark_value>equations in goal seek</bookmark_value><bookmark_value>calculating;variables in equations</bookmark_value><bookmark_value>variables;calculating equations</bookmark_value><bookmark_value>examples;goal seek</bookmark_value>",
            "id": 36428873,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428873/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99032384/?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.629577Z",
            "action": 59,
            "target": "Applying Goal Seek",
            "id": 36428872,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428872/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99032339/?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.629527Z",
            "action": 59,
            "target": "If you want to see multi-digit fractions such as \"1/10\", you must change the cell format to the multi-digit fraction view. Open the context menu of the cell, and choose <emph>Format cells. </emph>Select \"Fraction\" from the <emph>Category</emph> field, and then select \"-1234 10/81\". You can then enter fractions such as 12/31 or 12/32 - the fractions are, however, automatically reduced, so that in the last example you would see 3/8.",
            "id": 36428871,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428871/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99032283/?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.629477Z",
            "action": 59,
            "target": "If you enter “0 1/2” AutoCorrect causes the three characters 1, / and 2 to be replaced by a single character, ½. The same applies to 1/4 and 3/4. This replacement is defined in <emph>Tools - AutoCorrect - AutoCorrect Options - Options</emph> tab.",
            "id": 36428870,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428870/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99032250/?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.629428Z",
            "action": 59,
            "target": "Enter \"0 1/5\" in a cell (without the quotation marks) and press the input key. In the input line above the spreadsheet you will see the value 0.2, which is used for the calculation.",
            "id": 36428869,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428869/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99032200/?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.629382Z",
            "action": 59,
            "target": "You can enter a fractional number in a cell and use it for calculation:",
            "id": 36428868,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428868/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99032188/?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.629336Z",
            "action": 59,
            "target": "<variable id=\"fraction_enter\"><link href=\"text/scalc/guide/fraction_enter.xhp\">Entering Fractions </link></variable>",
            "id": 36428867,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428867/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99032162/?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.629288Z",
            "action": 59,
            "target": "<bookmark_value>fractions; entering</bookmark_value><bookmark_value>numbers; entering fractions </bookmark_value><bookmark_value>inserting;fractions</bookmark_value>",
            "id": 36428866,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428866/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99032139/?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.629243Z",
            "action": 59,
            "target": "Entering Fractions",
            "id": 36428865,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428865/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99032113/?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.629195Z",
            "action": 59,
            "target": "<link href=\"text/scalc/01/04060000.xhp\">Function Wizard</link>",
            "id": 36428864,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428864/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99032089/?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.629143Z",
            "action": 59,
            "target": "<link href=\"text/scalc/01/04060100.xhp\">Functions list</link>",
            "id": 36428863,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428863/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99032071/?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.629098Z",
            "action": 59,
            "target": "It is also possible to nest functions in formulas, as shown in the example. You can also nest functions within functions. The Function Wizard assists you with nested functions.",
            "id": 36428862,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428862/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99032051/?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.629051Z",
            "action": 59,
            "target": "Calculates the sum of cells B10 to B14 and adds the value to B8.",
            "id": 36428861,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428861/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99032031/?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.629003Z",
            "action": 59,
            "target": "=SUM(B8;SUM(B10:B14))",
            "id": 36428860,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428860/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99031991/?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.628956Z",
            "action": 59,
            "target": "Calculates B8 minus the sum of the cells B10 to B14.",
            "id": 36428859,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428859/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99031960/?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.628910Z",
            "action": 59,
            "target": "=B8-SUM(B10:B14)",
            "id": 36428858,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428858/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99031925/?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.628864Z",
            "action": 59,
            "target": "Calculates the effective interest for 5% annual nominal interest with 12 payments a year.",
            "id": 36428857,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428857/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99031903/?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.628818Z",
            "action": 59,
            "target": "=EFFECTIVE(5%;12)",
            "id": 36428856,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428856/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99031886/?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.628772Z",
            "action": 59,
            "target": "Displays the contents of cell A1 rounded to one decimal place.",
            "id": 36428855,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428855/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99031872/?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.628728Z",
            "action": 59,
            "target": "=ROUND(A1;1)",
            "id": 36428854,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428854/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99031813/?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.628685Z",
            "action": 59,
            "target": "Displays the result of the multiplication of A1 and A2.",
            "id": 36428853,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428853/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99031794/?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.628638Z",
            "action": 59,
            "target": "=A1 * A2",
            "id": 36428852,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428852/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99031766/?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.628595Z",
            "action": 59,
            "target": "Displays 16% of the contents of A1.",
            "id": 36428851,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428851/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99031741/?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.628551Z",
            "action": 59,
            "target": "=A1*16%",
            "id": 36428850,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428850/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99031711/?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.628508Z",
            "action": 59,
            "target": "Displays the contents of cell A1 plus 10.",
            "id": 36428849,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428849/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99031673/?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.628465Z",
            "action": 59,
            "target": "=A1+10",
            "id": 36428848,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428848/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99031647/?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.628425Z",
            "action": 59,
            "target": "Here are a few examples of $[officename] Calc formulas:",
            "id": 36428847,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428847/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99031619/?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.628385Z",
            "action": 59,
            "target": "Parentheses can also be used. The result of the formula =(1+2)*3 produces a different result than =1+2*3.",
            "id": 36428846,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428846/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99031580/?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.628344Z",
            "action": 59,
            "target": "Remember that the basic arithmetic operators (+, -, *, /) can be used in formulas using the \"Multiplication and Division before Addition and Subtraction\" rule. Instead of writing =SUM(A1:B1) you can write =A1+B1.",
            "id": 36428845,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36428845/?format=api"
        }
    ]
}