Changes

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

{
    "count": 766774,
    "next": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/changes/?format=api&page=15297",
    "previous": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/changes/?format=api&page=15295",
    "results": [
        {
            "unit": "https://translations.documentfoundation.org/api/units/99150583/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:52:49.751624Z",
            "action": 59,
            "target": "If cell A1 displays Err:518, the function <item type=\"input\">=ERRORTYPE(A1)</item> returns the number 518.",
            "id": 36728269,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728269/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99150546/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:52:49.751596Z",
            "action": 59,
            "target": "<emph>Reference</emph> contains the address of the cell in which the error occurs.",
            "id": 36728268,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728268/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99150502/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:52:49.751558Z",
            "action": 59,
            "target": "ERRORTYPE(Reference)",
            "id": 36728267,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728267/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99150445/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:52:49.751516Z",
            "action": 59,
            "target": "The Status Bar displays the predefined error code from <item type=\"productname\">%PRODUCTNAME</item> if you click the cell containing the error.",
            "id": 36728266,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728266/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99150407/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:52:49.751473Z",
            "action": 59,
            "target": "<ahelp hid=\"HID_FUNC_FEHLERTYP\">Returns the number corresponding to an <link href=\"text/scalc/05/02140000.xhp\">error value</link> occurring in a different cell.</ahelp> With the aid of this number, you can generate an error message text.",
            "id": 36728265,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728265/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99150384/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:52:49.751427Z",
            "action": 59,
            "target": "ERRORTYPE",
            "id": 36728264,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728264/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99150352/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:52:49.751387Z",
            "action": 59,
            "target": "<bookmark_value>ERRORTYPE function</bookmark_value>",
            "id": 36728263,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728263/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99150303/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:52:49.751345Z",
            "action": 59,
            "target": "<item type=\"input\">=DDE(\"soffice\";\"c:\\office\\document\\motto.odt\";\"Today's motto\")</item> returns a motto in the cell containing this formula. First, you must enter a line in the motto.odt document containing the motto text and define it as the first line of a section named <item type=\"literal\">Today's Motto</item> (in <item type=\"productname\">%PRODUCTNAME</item> Writer under <emph>Insert - Section</emph>). If the motto is modified (and saved) in the <item type=\"productname\">%PRODUCTNAME</item> Writer document, the motto is updated in all <item type=\"productname\">%PRODUCTNAME</item> Calc cells in which this DDE link is defined.",
            "id": 36728262,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728262/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99150276/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:52:49.751304Z",
            "action": 59,
            "target": "<item type=\"input\">=DDE(\"soffice\";\"c:\\office\\document\\data1.ods\";\"sheet1.A1\")</item> reads the contents of cell A1 in sheet1 of the <item type=\"productname\">%PRODUCTNAME</item> Calc spreadsheet data1.ods.",
            "id": 36728261,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728261/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99150249/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:52:49.751263Z",
            "action": 59,
            "target": "Data are retrieved as text; no conversion to numbers",
            "id": 36728260,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728260/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99150226/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:52:49.751226Z",
            "action": 59,
            "target": "Data are always interpreted in the standard format for US English",
            "id": 36728259,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728259/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99150199/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:52:49.751188Z",
            "action": 59,
            "target": "Number format from the \"Default\" cell style",
            "id": 36728258,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728258/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99150173/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:52:49.751149Z",
            "action": 59,
            "target": "0 or missing",
            "id": 36728257,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728257/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99150129/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:52:49.751109Z",
            "action": 59,
            "target": "Effect",
            "id": 36728256,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728256/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99150092/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:52:49.751069Z",
            "action": 59,
            "target": "Mode",
            "id": 36728255,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728255/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99150017/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:52:49.751030Z",
            "action": 59,
            "target": "<emph>Mode</emph> is an optional parameter that controls the method by which the DDE server converts its data into numbers.",
            "id": 36728254,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728254/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99149923/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:52:49.750990Z",
            "action": 59,
            "target": "<emph>Range</emph> is the area containing the data to be evaluated.",
            "id": 36728253,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728253/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99149811/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:52:49.750952Z",
            "action": 59,
            "target": "<emph>File</emph> is the complete file name, including path specification.",
            "id": 36728252,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728252/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99149775/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:52:49.750911Z",
            "action": 59,
            "target": "<emph>Server</emph> is the name of a server application. <item type=\"productname\">%PRODUCTNAME</item> applications have the server name \"soffice\".",
            "id": 36728251,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728251/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99149696/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:52:49.750869Z",
            "action": 59,
            "target": "DDE(\"Server\"; \"File\"; \"Range\" [; Mode])",
            "id": 36728250,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728250/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99149677/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:52:49.750822Z",
            "action": 59,
            "target": "<ahelp hid=\"HID_FUNC_DDE\">Returns the result of a DDE-based link.</ahelp> If the contents of the linked range or section changes, the returned value will also change. You must reload the spreadsheet or choose <emph>Edit - Links</emph> to see the updated links. Cross-platform links, for example from a <item type=\"productname\">%PRODUCTNAME</item> installation running on a Windows machine to a document created on a Linux machine, are not allowed.",
            "id": 36728249,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728249/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99149626/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:52:49.750739Z",
            "action": 59,
            "target": "DDE",
            "id": 36728248,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728248/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99149591/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:52:49.583140Z",
            "action": 59,
            "target": "<bookmark_value>DDE function</bookmark_value>",
            "id": 36728247,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728247/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99149559/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:52:49.583097Z",
            "action": 59,
            "target": "<item type=\"input\">=AREAS(All)</item> returns 1 if you have defined an area named All under <emph>Data - Define Range</emph>.",
            "id": 36728246,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728246/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99149526/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:52:49.583051Z",
            "action": 59,
            "target": "<item type=\"input\">=AREAS((A1:B3;F2;G1))</item> returns 3, as it is a reference to three cells and/or areas. After entry this gets converted to =AREAS((A1:B3~F2~G1)).",
            "id": 36728245,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728245/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99149470/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:52:49.583006Z",
            "action": 59,
            "target": "Reference represents the reference to a cell or cell range.",
            "id": 36728244,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728244/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99149440/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:52:49.582961Z",
            "action": 59,
            "target": "AREAS(Reference)",
            "id": 36728243,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728243/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99149409/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:52:49.582915Z",
            "action": 59,
            "target": "The function expects a single argument. If you state multiple ranges, you must enclose them into additional parentheses. Multiple ranges can be entered using the semicolon (;) as divider, but this gets automatically converted to the tilde (~) operator. The tilde is used to join ranges.",
            "id": 36728242,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728242/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99149368/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:52:49.582868Z",
            "action": 59,
            "target": "<ahelp hid=\"HID_FUNC_BEREICHE\">Returns the number of individual ranges that belong to a multiple range.</ahelp> A range can consist of contiguous cells or a single cell.",
            "id": 36728241,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728241/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99149331/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:52:49.582821Z",
            "action": 59,
            "target": "AREAS",
            "id": 36728240,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728240/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99149298/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:52:49.582757Z",
            "action": 59,
            "target": "<bookmark_value>AREAS function</bookmark_value>",
            "id": 36728239,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728239/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99149264/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:52:49.582710Z",
            "action": 59,
            "target": "If the formula above is in cell B2 of current sheet, and the cell A1 in sheet 2 contains the value <item type=\"input\">-6</item>, you can refer indirectly to the referenced cell using a function in B2 by entering <item type=\"input\">=ABS(INDIRECT(B2))</item>. The result is the absolute value of the cell reference specified in B2, which in this case is 6.",
            "id": 36728238,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728238/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99149221/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:52:49.582667Z",
            "action": 59,
            "target": "<item type=\"input\">=ADDRESS(1;1;2;;\"Sheet2\")</item> returns the following: Sheet2.A$1",
            "id": 36728237,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728237/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99149146/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:52:49.582623Z",
            "action": 59,
            "target": "Example:",
            "id": 36728236,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728236/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99149104/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:52:49.582578Z",
            "action": 59,
            "target": "<emph>Sheet</emph> represents the name of the sheet. It must be placed in double quotes.",
            "id": 36728235,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728235/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99149080/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:52:49.582532Z",
            "action": 59,
            "target": "<emph>A1</emph> (optional) - if set to 0, the R1C1 notation is used. If this parameter is absent or set to another value than 0, the A1 notation is used.",
            "id": 36728234,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728234/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99149056/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:52:49.582488Z",
            "action": 59,
            "target": "4: relative (A1)",
            "id": 36728233,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728233/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99149028/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:52:49.582443Z",
            "action": 59,
            "target": "3: row (relative); column (absolute) ($A1)",
            "id": 36728232,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728232/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99148930/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:52:49.582398Z",
            "action": 59,
            "target": "2: row reference type is absolute; column reference is relative (A$1)",
            "id": 36728231,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728231/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99148901/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:52:49.582353Z",
            "action": 59,
            "target": "1: absolute ($A$1)",
            "id": 36728230,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728230/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99148866/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:52:49.582304Z",
            "action": 59,
            "target": "<emph>Abs</emph> determines the type of reference:",
            "id": 36728229,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728229/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99148821/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:52:49.582257Z",
            "action": 59,
            "target": "<emph>Column</emph> represents the column number for the cell reference (the number, not the letter)",
            "id": 36728228,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728228/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99148757/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:52:49.582211Z",
            "action": 59,
            "target": "<emph>Row</emph> represents the row number for the cell reference",
            "id": 36728227,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728227/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99148700/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:52:49.582165Z",
            "action": 59,
            "target": "ADDRESS(Row; Column [; Abs [; A1 [; \"Sheet\"]]])",
            "id": 36728226,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728226/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99148647/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:52:49.582120Z",
            "action": 59,
            "target": "The INDIRECT function is saved without conversion to ODF 1.0/1.1 format. If the second parameter was present, an older version of Calc will return an error for that function.",
            "id": 36728225,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728225/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99148618/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:52:49.582076Z",
            "action": 59,
            "target": "Do not save a spreadsheet in the old ODF 1.0/1.1 format if the ADDRESS function's new fourth parameter was used with a value of 0.",
            "id": 36728224,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728224/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99148583/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:52:49.582033Z",
            "action": 59,
            "target": "When storing a document in ODF 1.0/1.1 format, if ADDRESS functions have a fourth parameter, that parameter will be removed.",
            "id": 36728223,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728223/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99148545/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:52:49.581991Z",
            "action": 59,
            "target": "When opening documents from ODF 1.0/1.1 format, the ADDRESS functions that show a sheet name as the fourth parameter will shift that sheet name to become the fifth parameter. A new fourth parameter with the value 1 will be inserted.",
            "id": 36728222,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728222/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99148509/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:52:49.581947Z",
            "action": 59,
            "target": "In case of R1C1 notation, ADDRESS returns address strings using the exclamation mark '!' as the sheet name separator, and INDIRECT expects the exclamation mark as sheet name separator. Both functions still use the dot '.' sheet name separator with A1 notation.",
            "id": 36728221,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728221/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99148449/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2023-09-11T22:52:49.581905Z",
            "action": 59,
            "target": "In both functions, if the argument is inserted with the value 0, then the R1C1 notation is used. If the argument is not given or has a value other than 0, then the A1 notation is used.",
            "id": 36728220,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728220/?format=api"
        }
    ]
}