Changes

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

{
    "count": 4174,
    "next": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/changes/?format=api&page=72",
    "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/changes/?format=api&page=70",
    "results": [
        {
            "unit": "https://translations.documentfoundation.org/api/units/110307901/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:10:58.140143Z",
            "action": 59,
            "target": "If the height (or width) of the destination is = 1 then the destination is expanded downwards (or rightwards) up to the height (or width) of the source range.",
            "id": 48109747,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/48109747/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/110307850/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:10:58.140102Z",
            "action": 59,
            "target": "If the height (or width) of the destination area is > 1 row (or column) then the height (or width) of the source must be <= the height (or width) of the destination. Otherwise nothing happens.",
            "id": 48109746,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/48109746/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/110307704/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:10:58.140061Z",
            "action": 59,
            "target": "Copies downwards and/or rightwards a specified source range (values, formulas and formats) to a destination range. The method imitates the behaviour of a Copy/Paste operation from a source range to a larger destination range.",
            "id": 48109745,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/48109745/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/110307663/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:10:58.140022Z",
            "action": 59,
            "target": "To simulate a Copy/Paste from a range to a single cell, use <literal>CopyToCell</literal>. To simulate a Copy/Paste from a range to a larger range (with the same cells being replicated several times), use <literal>CopyToRange</literal>.",
            "id": 48109744,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/48109744/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/110307613/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:10:58.139984Z",
            "action": 59,
            "target": "'Do not forget to close the source document because it was opened as hidden",
            "id": 48109743,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/48109743/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/110307583/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:10:58.139946Z",
            "action": 59,
            "target": "'Open the source document in the background (hidden)",
            "id": 48109742,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/48109742/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/110307539/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:10:58.139907Z",
            "action": 59,
            "target": "The example below illustrates how to copy a range from another open Calc document:",
            "id": 48109741,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/48109741/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/110307500/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:10:58.139868Z",
            "action": 59,
            "target": "Next is an example where the source and destination are in the same file:",
            "id": 48109740,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/48109740/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/110307431/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:10:58.139832Z",
            "action": 59,
            "target": "<emph>destinationcell</emph>: The destination cell where the copied range of cells will be pasted, as a string. If a range is given, only its top-left cell is considered.",
            "id": 48109739,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/48109739/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/110307398/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:10:58.139796Z",
            "action": 59,
            "target": "<emph>sourcerange</emph>: The source range as a string when it belongs to the same document or as a reference when it belongs to another open Calc document.",
            "id": 48109738,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/48109738/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/110307364/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:10:58.139761Z",
            "action": 59,
            "target": "The source range may belong to another <emph>open</emph> document.",
            "id": 48109737,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/48109737/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/110307335/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:10:58.139723Z",
            "action": 59,
            "target": "It returns a string representing the modified range of cells. The size of the modified area is fully determined by the size of the source area.",
            "id": 48109736,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/48109736/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/110307300/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:10:58.139687Z",
            "action": 59,
            "target": "Copies a specified source range (values, formulas and formats) to a destination range or cell. The method reproduces the behaviour of a Copy/Paste operation from a range to a single cell.",
            "id": 48109735,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/48109735/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/110307243/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:10:58.139650Z",
            "action": 59,
            "target": "The following example copies \"SheetX\" from \"myFile.ods\" and pastes it into the document referred to by \"oDoc\" as \"SheetY\" at the first position.",
            "id": 48109734,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/48109734/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/110307234/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:10:58.139615Z",
            "action": 59,
            "target": "<emph>beforesheet</emph>: The name (string) or index (numeric, starting from 1) of the sheet before which to insert the copied sheet. This argument is optional and the default behavior is to add the copied sheet at the last position.",
            "id": 48109733,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/48109733/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/110307222/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:10:58.139580Z",
            "action": 59,
            "target": "<emph>newname</emph>: The name of the copied sheet to be inserted in the document. The name must not be in use in the document.",
            "id": 48109732,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/48109732/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/110307211/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:10:58.139543Z",
            "action": 59,
            "target": "<emph>sheetname</emph>: The name of the sheet to be copied as a string.",
            "id": 48109731,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/48109731/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/110307197/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:10:58.139506Z",
            "action": 59,
            "target": "<emph>filename</emph>: Identifies the file to open. It must follow the <literal>SF_FileSystem.FileNaming</literal> notation. The file must not be protected with a password.",
            "id": 48109730,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/48109730/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/110307184/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:10:58.139470Z",
            "action": 59,
            "target": "If the file does not exist, an error is raised. If the file is not a valid Calc file, a blank sheet is inserted. If the source sheet does not exist in the input file, an error message is inserted at the top of the newly pasted sheet.",
            "id": 48109729,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/48109729/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/110307177/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:10:58.139434Z",
            "action": 59,
            "target": "Copies a specified sheet from a <emph>closed</emph> Calc document and pastes it before an existing sheet or at the end of the list of sheets of the file referred to by a <literal>Document</literal> object.",
            "id": 48109728,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/48109728/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/110307175/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:10:58.139399Z",
            "action": 59,
            "target": "To copy sheets between <emph>open</emph> documents, use <literal>CopySheet</literal>. To copy sheets from documents that are <emph>closed</emph>, use <literal>CopySheetFromFile</literal>.",
            "id": 48109727,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/48109727/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/110307173/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:10:58.139364Z",
            "action": 59,
            "target": "The example below copies \"SheetX\" from \"FileA.ods\" and pastes it at the last position of \"FileB.ods\" with the name \"SheetY\":",
            "id": 48109726,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/48109726/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/110307171/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:10:58.139328Z",
            "action": 59,
            "target": "'Gets the Document object of the active window",
            "id": 48109725,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/48109725/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/110307169/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:10:58.139292Z",
            "action": 59,
            "target": "The following example makes a copy of the sheet \"SheetX\" and places it as the last sheet in the current document. The name of the copied sheet is \"SheetY\".",
            "id": 48109724,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/48109724/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/110307157/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:10:58.139256Z",
            "action": 59,
            "target": "<emph>beforesheet</emph>: The name (string) or index (numeric, starting from 1) of the sheet before which to insert the copied sheet. This argument is optional and the default behavior is to add the copied sheet at the last position.",
            "id": 48109723,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/48109723/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/110307118/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:10:58.139219Z",
            "action": 59,
            "target": "<emph>newname</emph>: The name of the sheet to insert. The name must not be in use in the document.",
            "id": 48109722,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/48109722/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/110307039/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:10:58.139183Z",
            "action": 59,
            "target": "<emph>sheetname</emph>: The name of the sheet to be copied as a string or its reference as an object.",
            "id": 48109721,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/48109721/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/110307037/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:10:58.139147Z",
            "action": 59,
            "target": "Copies a specified sheet before an existing sheet or at the end of the list of sheets. The sheet to be copied may be contained inside any <emph>open</emph> Calc document. Returns <literal>True</literal> if successful.",
            "id": 48109720,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/48109720/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/110307036/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:10:58.139112Z",
            "action": 59,
            "target": "newrange = myDoc.CompactUp(\"Sheet1.G1:L10\", filterformula = '=(MOD(SUM(G1:L1);2)=1)')",
            "id": 48109719,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/48109719/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/110307033/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:10:58.139079Z",
            "action": 59,
            "target": "newrange = myDoc.CompactUp(\"Sheet1.G1:L10\", filterformula = '=(G1=\"X\")')",
            "id": 48109718,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/48109718/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/110307011/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:10:58.139055Z",
            "action": 59,
            "target": "newrange = myDoc.CompactUp(\"Sheet1.G1:L10\", wholerow = True)",
            "id": 48109717,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/48109717/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/110306869/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:10:58.139033Z",
            "action": 59,
            "target": "newrange = myDoc.CompactUp(\"Sheet1.G1:L10\")",
            "id": 48109716,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/48109716/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/110306823/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:10:58.139010Z",
            "action": 59,
            "target": "newrange = oDoc.CompactUp(\"Sheet1.G1:L10\", FilterFormula := \"=(MOD(SUM(G1:L1);2)=1)\")",
            "id": 48109715,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/48109715/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/110306805/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:10:58.138988Z",
            "action": 59,
            "target": "' Deletes all rows where the sum of values in the row is odd",
            "id": 48109714,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/48109714/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/110306795/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:10:58.138965Z",
            "action": 59,
            "target": "newrange = oDoc.CompactUp(\"Sheet1.G1:L10\", FilterFormula := \"=(G1=\"\"X\"\")\")",
            "id": 48109713,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/48109713/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/110306784/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:10:58.138941Z",
            "action": 59,
            "target": "' Deletes all rows where the first column is marked with an \"X\"",
            "id": 48109712,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/48109712/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/110306774/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:10:58.138906Z",
            "action": 59,
            "target": "newrange = oDoc.CompactUp(\"Sheet1.G1:L10\", WholeRow := True)",
            "id": 48109711,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/48109711/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/110306764/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:10:58.138869Z",
            "action": 59,
            "target": "' The example below is similar, but the entire row is deleted from the sheet",
            "id": 48109710,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/48109710/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/110306755/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:10:58.138834Z",
            "action": 59,
            "target": "newrange = oDoc.CompactUp(\"Sheet1.G1:L10\")",
            "id": 48109709,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/48109709/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/110306738/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:10:58.138798Z",
            "action": 59,
            "target": "' Delete all empty rows in the range G1:L10 from Sheet1",
            "id": 48109708,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/48109708/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/110306729/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:10:58.138762Z",
            "action": 59,
            "target": "The Calc functions used in the formula specified in the <literal>filterformula</literal> argument must be expressed using their English names. Visit the Wiki page <link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/List_of_Functions\">List of Calc Functions</link> for a complete list of Calc functions in English.",
            "id": 48109707,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/48109707/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/110306716/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:10:58.138701Z",
            "action": 59,
            "target": "For example, suppose range <emph>A1:J200</emph> is selected (width = 10), so the default formula is <emph>=(COUNTBLANK(A1:J1)=10)</emph>. This means that if all 10 cells are empty in the first row (Row 1), then the row is deleted. Note that the formula is expressed with respect to the first row only. Internally the <literal>CompactUp</literal> method will generalize this formula for all the remaining rows.",
            "id": 48109706,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/48109706/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/110306707/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:10:58.138664Z",
            "action": 59,
            "target": "<emph>filterformula</emph>: The filter to be applied to each row to determine whether or not it will be deleted. The filter is expressed as a Calc formula that should be applied to the first row. When the formula returns <emph>True</emph> for a row, that row will be deleted. The default filter deletes all empty rows.",
            "id": 48109705,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/48109705/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/110306696/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:10:58.138630Z",
            "action": 59,
            "target": "<emph>wholerow</emph>: If this option is set to <literal>True</literal> the entire row will be deleted from the sheet. The default value is <literal>False</literal>, which means that the deleted row will be limited to the width of the specified <literal>range</literal>.",
            "id": 48109704,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/48109704/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/110306682/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:10:58.138607Z",
            "action": 59,
            "target": "<emph>range</emph>: The range from which rows will be deleted, as a string.",
            "id": 48109703,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/48109703/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/110306673/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:10:58.138583Z",
            "action": 59,
            "target": "If a range of cells is selected, calling this method will not impact the selection.",
            "id": 48109702,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/48109702/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/110306659/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:10:58.138559Z",
            "action": 59,
            "target": "This method returns a string with the range address of the compacted range. If all rows are deleted, then an empty string is returned.",
            "id": 48109701,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/48109701/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/110306642/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:10:58.138535Z",
            "action": 59,
            "target": "The deleted rows can be limited to the width of the specified range or span to the width of the entire sheet, thus deleting whole rows.",
            "id": 48109700,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/48109700/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/110306626/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:10:58.138513Z",
            "action": 59,
            "target": "Deletes the rows of a specified range that match a filter expressed as a Calc formula. The filter is applied to each row to decide whether it will be deleted or not.",
            "id": 48109699,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/48109699/?format=api"
        },
        {
            "unit": "https://translations.documentfoundation.org/api/units/110306616/?format=api",
            "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/?format=api",
            "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/?format=api",
            "user": null,
            "author": null,
            "timestamp": "2024-02-01T18:10:58.138490Z",
            "action": 59,
            "target": "newrange = myDoc.CompactLeft(\"Sheet1.G1:L10\", filterformula = '=(MOD(SUM(G1:G10);2)=1)')",
            "id": 48109698,
            "action_name": "String updated in the repository",
            "url": "https://translations.documentfoundation.org/api/changes/48109698/?format=api"
        }
    ]
}