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=15293",
    "previous": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/changes/?format=api&page=15291",
    "results": [
        {
            "unit": "https://translations.documentfoundation.org/api/units/99156130/?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.759025Z",
            "action": 59,
            "target": "The more complex formula <input>=CONCATENATE(\"Life is really simple, \"; \"but we insist on making it complicated \"; \"(Confucius).\")</input> concatenates three individual strings in double quotation marks, outputting <literal>Life is really simple, but we insist on making it complicated (Confucius).</literal>",
            "id": 36728469,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728469/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99156093/?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.758977Z",
            "action": 59,
            "target": "To include a text string in a formula, place the text string between two double quotation marks (\") and Calc takes the characters in the string without attempting to interpret them. For example, the formula <input>=\"Hello world!\"</input> displays the text string <literal>Hello world!</literal> in the cell, with no surrounding double quotation marks.",
            "id": 36728468,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728468/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99156088/?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.758931Z",
            "action": 59,
            "target": "Using double quotation marks in formulas",
            "id": 36728467,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728467/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99156077/?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.758886Z",
            "action": 59,
            "target": "<bookmark_value>using double quotation marks in formulas</bookmark_value>  <bookmark_value>formulas; using double quotation marks</bookmark_value>",
            "id": 36728466,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728466/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99156053/?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.758838Z",
            "action": 59,
            "target": "<variable id=\"texttext\">This section contains descriptions of the <emph>Text</emph> functions. </variable>",
            "id": 36728465,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728465/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99156034/?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.758786Z",
            "action": 59,
            "target": "<variable id=\"head_text\"><link href=\"text/scalc/01/04060110.xhp\">Text Functions</link></variable>",
            "id": 36728464,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728464/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99156016/?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.758735Z",
            "action": 59,
            "target": "<bookmark_value>text in cells; functions</bookmark_value>  <bookmark_value>functions; text functions</bookmark_value>  <bookmark_value>Function Wizard;text</bookmark_value>",
            "id": 36728463,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728463/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99155989/?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.758686Z",
            "action": 59,
            "target": "Text Functions",
            "id": 36728462,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728462/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99155928/?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.758637Z",
            "action": 59,
            "target": "A function name can be added in the form <emph>Field[Item;Function]</emph>, which will cause the constraint to match only subtotal values which use that function. The possible function names are Sum, Count, Average, Max, Min, Product, Count (Numbers only), StDev (Sample), StDevP (Population), Var (Sample), and VarP (Population), case-insensitive.",
            "id": 36728461,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728461/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99155900/?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.758588Z",
            "action": 59,
            "target": "Each of the other entries specifies a constraint in the form <item type=\"literal\">Field[Item]</item> (with literal characters [ and ]), or only <item type=\"literal\">Item</item> if the item name is unique within all fields that are used in the pivot table.",
            "id": 36728460,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728460/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99155835/?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.758542Z",
            "action": 59,
            "target": "One of the entries can be the data field name. The data field name can be left out if the pivot table contains only one data field, otherwise it must be present.",
            "id": 36728459,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728459/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99155804/?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.758494Z",
            "action": 59,
            "target": "<emph>Constraints</emph> is a space-separated list. Entries can be quoted (single quotes). The whole string must be enclosed in quotes (double quotes), unless you reference the string from another cell.",
            "id": 36728458,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728458/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99155767/?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.758450Z",
            "action": 59,
            "target": "<emph>pivot table</emph> has the same meaning as in the first syntax.",
            "id": 36728457,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728457/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99155728/?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.758403Z",
            "action": 59,
            "target": "Second Syntax",
            "id": 36728456,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728456/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99155709/?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.758355Z",
            "action": 59,
            "target": "Subtotal values from the pivot table are only used if they use the function \"auto\" (except when specified in the constraint, see <item type=\"literal\">Second Syntax</item> below).",
            "id": 36728455,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728455/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99155708/?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.758303Z",
            "action": 59,
            "target": "If no constraint for a filter is given, the field's selected value is implicitly used. If a constraint for a filter is given, it must match the field's selected value, or an error is returned. Filters are the fields at the top left of a pivot table, populated using the \"Filters\" area of the pivot table layout dialog. From each filter, an item (value) can be selected, which means only that item is included in the calculation.",
            "id": 36728454,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728454/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99155707/?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.758253Z",
            "action": 59,
            "target": "If the source data contains entries that are hidden by settings of the pivot table, they are ignored. The order of the Field/Item pairs is not significant. Field and item names are not case-sensitive.",
            "id": 36728453,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728453/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99155688/?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.758201Z",
            "action": 59,
            "target": "If the pivot table contains only a single result value that fulfills all of the constraints, or a subtotal result that summarizes all matching values, that result is returned. If there is no matching result, or several ones without a subtotal for them, an error is returned. These conditions apply to results that are included in the pivot table.",
            "id": 36728452,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728452/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99155667/?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.758159Z",
            "action": 59,
            "target": "If no <emph>Field n / Item n</emph> pairs are given, the grand total is returned. Otherwise, each pair adds a constraint that the result must satisfy. <emph>Field n</emph> is the name of a field from the pivot table. <emph>Item n</emph> is the name of an item from that field.",
            "id": 36728451,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728451/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99155652/?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.758132Z",
            "action": 59,
            "target": "<emph>pivot table</emph> is a reference to a cell or cell range that is positioned within a pivot table or contains a pivot table. If the cell range contains several pivot tables, the table that was created last is used.",
            "id": 36728450,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728450/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99155628/?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.758103Z",
            "action": 59,
            "target": "<emph>TargetField</emph> is a string that selects one of the pivot table's data fields. The string can be the name of the source column, or the data field name as shown in the table (like \"Sum - Sales\").",
            "id": 36728449,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728449/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99155583/?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.758068Z",
            "action": 59,
            "target": "First Syntax",
            "id": 36728448,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728448/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99155555/?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.758025Z",
            "action": 59,
            "target": "The second syntax is assumed if exactly two parameters are given, of which the first parameter is a cell or cell range reference. The first syntax is assumed in all other cases. The Function Wizard shows the first syntax.",
            "id": 36728447,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728447/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99155525/?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.757985Z",
            "action": 59,
            "target": "GETPIVOTDATA(pivot table; Constraints)",
            "id": 36728446,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728446/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99155510/?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.757944Z",
            "action": 59,
            "target": "or",
            "id": 36728445,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728445/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99155483/?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.757902Z",
            "action": 59,
            "target": "GETPIVOTDATA(TargetField; pivot table[; Field 1; Item 1][; ... [Field 126; Item 126]])",
            "id": 36728444,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728444/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99155463/?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.757862Z",
            "action": 59,
            "target": "Two different syntax definitions can be used:",
            "id": 36728443,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728443/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99155429/?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.757823Z",
            "action": 59,
            "target": "<ahelp hid=\".\">The GETPIVOTDATA function returns a result value from a pivot table. The value is addressed using field and item names, so it remains valid if the layout of the pivot table changes.</ahelp>",
            "id": 36728442,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728442/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99155401/?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.757783Z",
            "action": 59,
            "target": "GETPIVOTDATA",
            "id": 36728441,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728441/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99155369/?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.757745Z",
            "action": 59,
            "target": "<bookmark_value>GETPIVOTDATA function</bookmark_value>",
            "id": 36728440,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728440/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99155340/?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.757706Z",
            "action": 59,
            "target": "<input>=HYPERLINK(\"file:///C:/Documents/\";\"Open Documents folder\")</input> displays the text \"Open Documents folder\" and shows the folder contents using the standard file manager in your operating system.",
            "id": 36728439,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728439/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99155310/?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.757665Z",
            "action": 59,
            "target": "<input>=HYPERLINK(\"file:///C:/writer.odt#Specification\";\"Go to Writer bookmark\")</input> displays the text \"Go to Writer bookmark\", loads the specified text document and jumps to bookmark \"Specification\".",
            "id": 36728438,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728438/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99155278/?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.757625Z",
            "action": 59,
            "target": "<input>=HYPERLINK(\"#Sheet1.A1\";\"Go to top\")</input> displays the text Go to top and jumps to cell Sheet1.A1 in this document.",
            "id": 36728437,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728437/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99155277/?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.757586Z",
            "action": 59,
            "target": "<input>=HYPERLINK(\"http://www.\";\"Click \") & \"example.org\"</input> displays the text Click example.org in the cell and executes the hyperlink http://www.example.org when clicked.",
            "id": 36728436,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728436/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99155276/?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.757546Z",
            "action": 59,
            "target": "<input>=HYPERLINK($B4)</input> where cell B4 contains <literal>http://www.example.org</literal>. The function adds http://www.example.org to the URL of the hyperlink cell and returns the same text which is used as formula result.",
            "id": 36728435,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728435/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99155275/?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.757506Z",
            "action": 59,
            "target": "<input>=HYPERLINK(\"http://www.example.org\";12345)</input> displays the number 12345 and executes the hyperlink http://www.example.org when clicked.",
            "id": 36728434,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728434/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99155274/?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.757466Z",
            "action": 59,
            "target": "<input>=HYPERLINK(\"http://www.example.org\";\"Click here\")</input> displays the text \"Click here\" in the cell and executes the hyperlink http://www.example.org when clicked.",
            "id": 36728433,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728433/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99155273/?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.757426Z",
            "action": 59,
            "target": "<input>=HYPERLINK(\"http://www.example.org\")</input> displays the text \"http://www.example.org\" in the cell and executes the hyperlink http://www.example.org when clicked.",
            "id": 36728432,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728432/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99155272/?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.757398Z",
            "action": 59,
            "target": "The number 0 is returned for empty cells and matrix elements.",
            "id": 36728431,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728431/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99155271/?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.757363Z",
            "action": 59,
            "target": "<emph>URL</emph> specifies the link target. The optional <emph>CellValue</emph> parameter is the text or a number that is displayed in the cell and will be returned as the result. If the <emph>CellValue</emph> parameter is not specified, the <emph>URL</emph> is displayed in the cell text and will be returned as the result.",
            "id": 36728430,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728430/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99155270/?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.757325Z",
            "action": 59,
            "target": "HYPERLINK(\"URL\" [; CellValue])",
            "id": 36728429,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728429/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99155269/?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.757288Z",
            "action": 59,
            "target": "To open a hyperlinked cell with the keyboard, select the cell, press F2 to enter the Edit mode, move the cursor in front of the hyperlink, press Shift+F10, and then choose <emph>Open Hyperlink</emph>.",
            "id": 36728428,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728428/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99155268/?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.757250Z",
            "action": 59,
            "target": "If you use the optional <emph>CellValue</emph> parameter, the formula locates the URL, and then displays the text or number.",
            "id": 36728427,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728427/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99155267/?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.757215Z",
            "action": 59,
            "target": "<ahelp hid=\"HID_FUNC_HYPERLINK\">When you click a cell that contains the HYPERLINK function, the hyperlink opens.</ahelp>",
            "id": 36728426,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728426/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99155266/?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.757178Z",
            "action": 59,
            "target": "HYPERLINK",
            "id": 36728425,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728425/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99155264/?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.757140Z",
            "action": 59,
            "target": "<bookmark_value>HYPERLINK function</bookmark_value>",
            "id": 36728424,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728424/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99155254/?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.757100Z",
            "action": 59,
            "target": "<item type=\"input\">=ROWS(Rabbit)</item> returns 3 if \"Rabbit\" is the named area (C1:D3).",
            "id": 36728423,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728423/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99155102/?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.757058Z",
            "action": 59,
            "target": "<item type=\"input\">=ROWS(A10:B12)</item> returns 3.",
            "id": 36728422,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728422/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99155056/?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.757018Z",
            "action": 59,
            "target": "<item type=\"input\">=Rows(B5)</item> returns 1 because a cell only contains one row.",
            "id": 36728421,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728421/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/99155029/?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.756978Z",
            "action": 59,
            "target": "<emph>Array</emph> is the reference or named area whose total number of rows is to be determined.",
            "id": 36728420,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/36728420/?format=api"
        }
    ]
}