Changes

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

{
    "count": 766762,
    "next": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/changes/?format=api&page=15305",
    "previous": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/changes/?format=api&page=15303",
    "results": [
        {
            "unit": "https://translations.documentfoundation.org/api/units/99131609/?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.557080Z",
            "action": 59,
            "target": "You have a table in the cell range A1:B6 containing a bill of material for 10 students. Row 2 (Pen) is manually hidden. You want to see the sum of the figures that are displayed; that is, just the subtotal for the filtered rows. In this case the correct formula would be:",
            "id": 36727857,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36727857/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99131576/?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.557030Z",
            "action": 59,
            "target": "<emph>Range</emph> is the range whose cells are included.",
            "id": 36727856,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36727856/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99131543/?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.556982Z",
            "action": 59,
            "target": "Use numbers 1-11 to include manually hidden rows or 101-111 to exclude them; filtered-out cells are always excluded.",
            "id": 36727855,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36727855/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99131505/?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.556938Z",
            "action": 59,
            "target": "VARP",
            "id": 36727854,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36727854/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99131478/?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.556892Z",
            "action": 59,
            "target": "VAR",
            "id": 36727853,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36727853/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99131442/?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.556846Z",
            "action": 59,
            "target": "SUM",
            "id": 36727852,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36727852/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99131418/?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.556803Z",
            "action": 59,
            "target": "STDEVP",
            "id": 36727851,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36727851/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99131393/?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.556762Z",
            "action": 59,
            "target": "STDEV",
            "id": 36727850,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36727850/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99131372/?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.556718Z",
            "action": 59,
            "target": "PRODUCT",
            "id": 36727849,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36727849/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99131344/?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.556673Z",
            "action": 59,
            "target": "MIN",
            "id": 36727848,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36727848/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99131312/?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.556627Z",
            "action": 59,
            "target": "MAX",
            "id": 36727847,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36727847/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99131284/?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.556583Z",
            "action": 59,
            "target": "COUNTA",
            "id": 36727846,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36727846/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99131250/?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.556536Z",
            "action": 59,
            "target": "COUNT",
            "id": 36727845,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36727845/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99131234/?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.556488Z",
            "action": 59,
            "target": "AVERAGE",
            "id": 36727844,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36727844/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99131219/?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.556442Z",
            "action": 59,
            "target": "Function",
            "id": 36727843,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36727843/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99131205/?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.556399Z",
            "action": 59,
            "target": "(ignores hidden values)",
            "id": 36727842,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36727842/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99131188/?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.556354Z",
            "action": 59,
            "target": "Function index",
            "id": 36727841,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36727841/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99131166/?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.556308Z",
            "action": 59,
            "target": "(includes hidden values)",
            "id": 36727840,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36727840/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99131162/?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.556243Z",
            "action": 59,
            "target": "Function index",
            "id": 36727839,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36727839/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99131161/?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.556201Z",
            "action": 59,
            "target": "<emph>Function</emph> is a number that stands for one of the following functions:",
            "id": 36727838,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36727838/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99131160/?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.556158Z",
            "action": 59,
            "target": "SUBTOTAL(Function; Range)",
            "id": 36727837,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36727837/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99131159/?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.556114Z",
            "action": 59,
            "target": "<ahelp hid=\"HID_FUNC_TEILERGEBNIS\">Calculates subtotals.</ahelp> If a range already contains subtotals, these are not used for further calculations. Use this function with the AutoFilters to take only the filtered records into account.",
            "id": 36727836,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36727836/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99131158/?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.556071Z",
            "action": 59,
            "target": "SUBTOTAL",
            "id": 36727835,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36727835/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99131157/?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.556028Z",
            "action": 59,
            "target": "<bookmark_value>AutoFilter function; subtotals</bookmark_value>  <bookmark_value>sums;of filtered data</bookmark_value>  <bookmark_value>filtered data; sums</bookmark_value>  <bookmark_value>SUBTOTAL function</bookmark_value>",
            "id": 36727834,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36727834/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99131156/?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.555984Z",
            "action": 59,
            "target": "<item type=\"input\">=TANH(0)</item> returns 0, the hyperbolic tangent of 0.",
            "id": 36727833,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36727833/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99131155/?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.555938Z",
            "action": 59,
            "target": "Returns the hyperbolic tangent of <emph>Number</emph>.",
            "id": 36727832,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36727832/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99131154/?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.555891Z",
            "action": 59,
            "target": "TANH(Number)",
            "id": 36727831,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36727831/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99131153/?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.555843Z",
            "action": 59,
            "target": "<ahelp hid=\"HID_FUNC_TANHYP\">Returns the hyperbolic tangent of a number.</ahelp>",
            "id": 36727830,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36727830/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99131128/?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.555794Z",
            "action": 59,
            "target": "TANH",
            "id": 36727829,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36727829/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99131097/?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.555745Z",
            "action": 59,
            "target": "<bookmark_value>TANH function</bookmark_value>",
            "id": 36727828,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36727828/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99131062/?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.555697Z",
            "action": 59,
            "target": "<item type=\"input\">=TAN(RADIANS(45))</item> returns 1, the tangent of 45 degrees.",
            "id": 36727827,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36727827/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99131013/?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.555650Z",
            "action": 59,
            "target": "<item type=\"input\">=TAN(PI()/4) </item>returns 1, the tangent of PI/4 radians.",
            "id": 36727826,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36727826/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99130957/?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.555602Z",
            "action": 59,
            "target": "To return the tangent of an angle in degrees, use the RADIANS function.",
            "id": 36727825,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36727825/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99130925/?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.555552Z",
            "action": 59,
            "target": "Returns the (trigonometric) tangent of <emph>Number</emph>, the angle in radians.",
            "id": 36727824,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36727824/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99130890/?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.555502Z",
            "action": 59,
            "target": "TAN(Number)",
            "id": 36727823,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36727823/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99130865/?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.555456Z",
            "action": 59,
            "target": "<ahelp hid=\"HID_FUNC_TAN\">Returns the tangent of the given angle (in radians).</ahelp>",
            "id": 36727822,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36727822/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99130841/?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.555409Z",
            "action": 59,
            "target": "TAN",
            "id": 36727821,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36727821/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99130798/?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.555362Z",
            "action": 59,
            "target": "<bookmark_value>TAN function</bookmark_value>",
            "id": 36727820,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36727820/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99130766/?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.555316Z",
            "action": 59,
            "target": "See COUNTIF() for some more syntax examples that can be used with SUMIF().",
            "id": 36727819,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36727819/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99130721/?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.555269Z",
            "action": 59,
            "target": "<item type=\"input\">=SUMIF(A1:A10;\">0\";B1:B10)</item> - sums values from the range B1:B10 only if the corresponding values in the range A1:A10 are >0.",
            "id": 36727818,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36727818/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99130720/?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.555219Z",
            "action": 59,
            "target": "To sum up only negative numbers: <item type=\"input\">=SUMIF(A1:A10;\"<0\")</item>",
            "id": 36727817,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36727817/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99130719/?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.555173Z",
            "action": 59,
            "target": "SUMIF supports the reference concatenation operator (~) only in the Range parameter, and only if the optional SumRange parameter is not given.",
            "id": 36727816,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36727816/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99130718/?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.555126Z",
            "action": 59,
            "target": "<emph>SumRange</emph> is the range from which values are summed. If this parameter has not been indicated, the values found in the Range are summed.",
            "id": 36727815,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36727815/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99130717/?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.555077Z",
            "action": 59,
            "target": "<emph>Range</emph> is the range to which the criterion is to be applied.",
            "id": 36727814,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36727814/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99130693/?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.555031Z",
            "action": 59,
            "target": "SUMIF(Range; Criterion [; SumRange])",
            "id": 36727813,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36727813/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99130668/?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.554986Z",
            "action": 59,
            "target": "<ahelp hid=\"HID_FUNC_SUMMEWENN\">Adds the cells specified by a given criterion.</ahelp> This function is used to sum a range when you search for a certain value.",
            "id": 36727812,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36727812/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99130627/?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.554940Z",
            "action": 59,
            "target": "<variable id=\"sumif_head\"><link href=\"text/scalc/01/04060106.xhp#Section15\">SUMIF</link></variable>",
            "id": 36727811,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36727811/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99130548/?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.554893Z",
            "action": 59,
            "target": "<bookmark_value>SUMIF function</bookmark_value>  <bookmark_value>adding;specified numbers</bookmark_value>",
            "id": 36727810,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36727810/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99130547/?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.554849Z",
            "action": 59,
            "target": "<item type=\"input\">=SINH(0)</item> returns 0, the hyperbolic sine of 0.",
            "id": 36727809,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36727809/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99130546/?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.554805Z",
            "action": 59,
            "target": "Returns the hyperbolic sine of <emph>Number</emph>.",
            "id": 36727808,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36727808/?format=api"
        }
    ]
}