Changes
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-24-2/textsbasicshared03/en/changes/?format=api&page=67
{ "count": 4174, "next": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/changes/?format=api&page=68", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en/changes/?format=api&page=66", "results": [ { "unit": "https://translations.documentfoundation.org/api/units/110311777/?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.146737Z", "action": 59, "target": "'Below the Value array is smaller than the TargetRange (remaining cells are emptied)", "id": 48109947, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109947/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110311776/?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.146699Z", "action": 59, "target": "Vectors are expanded vertically, except if <literal>targetrange</literal> has a height of exactly 1 row.", "id": 48109946, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109946/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110311775/?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.146678Z", "action": 59, "target": "If the size of <literal>value</literal> is larger than the size of <literal>targetrange</literal>, then <literal>value</literal> is only partially copied until it fills the size of <literal>targetrange</literal>.", "id": 48109945, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109945/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110311762/?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.146655Z", "action": 59, "target": "The full range is updated and the remainder of the sheet is left unchanged. If the size of <literal>value</literal> is smaller than the size of <literal>targetrange</literal>, then the remaining cells will be emptied.", "id": 48109944, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109944/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110311747/?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.146633Z", "action": 59, "target": "<emph>value</emph>: A scalar, a vector or an array with the new values for each cell of the range. The new values must be strings, numeric values or dates. Other types will cause the corresponding cells to be emptied.", "id": 48109943, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109943/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110311745/?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.146611Z", "action": 59, "target": "<emph>targetrange</emph>: The range where to store the given value, as a string.", "id": 48109942, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109942/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110311744/?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.146589Z", "action": 59, "target": "The method returns a string representing the modified area as a range of cells.", "id": 48109941, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109941/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110311743/?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.146567Z", "action": 59, "target": "Stores the given value in the specified range. The size of the modified area is equal to the size of the target range.", "id": 48109940, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109940/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110311737/?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.146544Z", "action": 59, "target": "'D2 contains the formula \"=H2\"", "id": 48109939, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109939/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110311727/?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.146521Z", "action": 59, "target": "'Horizontal vector, partially empty", "id": 48109938, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109938/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110311719/?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.146498Z", "action": 59, "target": "Calc functions used in the <literal>formula</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": 48109937, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109937/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110311699/?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.146475Z", "action": 59, "target": "Vectors are always expanded vertically, except if <literal>targetrange</literal> has a height of exactly 1 row.", "id": 48109936, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109936/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110311674/?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.146453Z", "action": 59, "target": "If the size of <literal>formula</literal> is larger than the size of <literal>targetrange</literal>, then the formulas are only partially copied until it fills the size of <literal>targetrange</literal>.", "id": 48109935, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109935/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110311642/?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.146430Z", "action": 59, "target": "If the size of <literal>formula</literal> is smaller than the size of <literal>targetrange</literal>, then the remaining cells are emptied.", "id": 48109934, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109934/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110311612/?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.146407Z", "action": 59, "target": "If the given formula is a string, the unique formula is pasted along the whole range with adjustment of the relative references.", "id": 48109933, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109933/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110311576/?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.146383Z", "action": 59, "target": "The full range is updated and the remainder of the sheet is left unchanged.", "id": 48109932, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109932/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110311542/?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.146360Z", "action": 59, "target": "<emph>formula</emph>: A string, a vector or an array of strings with the new formulas for each cell in the target range.", "id": 48109931, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109931/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110311494/?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.146338Z", "action": 59, "target": "<emph>targetrange</emph>: The range to insert the formulas, as a string.", "id": 48109930, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109930/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110311474/?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.146315Z", "action": 59, "target": "The method returns a string representing the modified area as a range of cells.", "id": 48109929, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109929/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110311442/?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.146292Z", "action": 59, "target": "Inserts the given (array of) formula(s) in the specified range. The size of the modified area is equal to the size of the range.", "id": 48109928, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109928/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110311403/?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.146270Z", "action": 59, "target": "Refer to the <link href=\"text/sbasic/shared/03/sf_calc.xhp#ClearAll\"><literal>ClearAll</literal></link> method documentation for examples on how to use the arguments <literal>filterformula</literal> and <literal>filterscope</literal>.", "id": 48109927, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109927/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110311361/?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.146246Z", "action": 59, "target": "<emph>style</emph>: The name of the cell style to apply.", "id": 48109926, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109926/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110311328/?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.146223Z", "action": 59, "target": "<emph>targetrange</emph>: The range to which the style will be applied, as a string.", "id": 48109925, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109925/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110311294/?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.146201Z", "action": 59, "target": "The method returns a string representing the modified area as a range of cells.", "id": 48109924, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109924/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110311248/?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.146179Z", "action": 59, "target": "Applies the specified cell style to the given target range. The full range is updated and the remainder of the sheet is left untouched. If the cell style does not exist, an error is raised.", "id": 48109923, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109923/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110311211/?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.146157Z", "action": 59, "target": "To dump the full contents of an array in a sheet, use <emph>SetArray</emph>. To dump the contents of an array only within the boundaries of the targeted range of cells, use <emph>SetValue</emph>.", "id": 48109922, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109922/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110311162/?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.146134Z", "action": 59, "target": "'Fill 1st column with values from 1 to 1000", "id": 48109921, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109921/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110311143/?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.146111Z", "action": 59, "target": "This example uses the <literal>RangeInit</literal> method of the <link href=\"text/sbasic/shared/03/sf_array.xhp#RangeInit\">ScriptForge Array service</link> to create an array with values that are then stored from cell \"A1\" and downwards.", "id": 48109920, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109920/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110311115/?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.146085Z", "action": 59, "target": "The following example uses the builtin <link href=\"text/sbasic/shared/03104300.xhp\">DimArray function</link> to create an array and then store it in cell \"A1\":", "id": 48109919, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109919/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110311090/?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.146063Z", "action": 59, "target": "<emph>value</emph>: A scalar, a vector or an array (in Python, one or two-dimensional lists and tuples) with the new values to be stored from the target cell or from the top-left corner of the range if <literal>targetcell</literal> is a range. The new values must be strings, numeric values or dates. Other types will cause the corresponding cells to be emptied.", "id": 48109918, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109918/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110311089/?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.146040Z", "action": 59, "target": "<emph>targetcell</emph>: The cell or a range as a string from where to start to store the given value.", "id": 48109917, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109917/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110311088/?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.146017Z", "action": 59, "target": "The method returns a string representing the modified area as a range of cells.", "id": 48109916, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109916/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110311075/?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.145994Z", "action": 59, "target": "Stores the given value starting from a specified target cell. The updated area expands itself from the target cell or from the top-left corner of the given range to accommodate the size of the input <literal>value</literal> argument. Vectors are always expanded vertically.", "id": 48109915, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109915/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110311050/?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.145971Z", "action": 59, "target": "This example renames the active sheet to \"SheetY\":", "id": 48109914, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109914/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110311038/?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.145949Z", "action": 59, "target": "<emph>newname</emph>: the new name of the sheet. It must not exist yet.", "id": 48109913, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109913/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110310925/?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.145927Z", "action": 59, "target": "<emph>sheetname</emph>: The name of the sheet to rename.", "id": 48109912, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109912/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110310893/?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.145904Z", "action": 59, "target": "Renames the given sheet and returns <literal>True</literal> if successful.", "id": 48109911, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109911/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110310880/?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.145882Z", "action": 59, "target": "<emph>sheetname</emph>: The name of the sheet to remove.", "id": 48109910, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109910/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110310874/?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.145859Z", "action": 59, "target": "Removes an existing sheet from the document.", "id": 48109909, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109909/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110310851/?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.145836Z", "action": 59, "target": "' Cells containing duplicate values are left blank", "id": 48109908, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109908/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110310833/?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.145813Z", "action": 59, "target": "' Columns A and B are used to determine if a row is a duplicate", "id": 48109907, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109907/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110310800/?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.145790Z", "action": 59, "target": "' Removes duplicate rows considering that the first row contains headers", "id": 48109906, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109906/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110310778/?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.145767Z", "action": 59, "target": "' Note that all optional arguments use their default value", "id": 48109905, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109905/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110310748/?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.145744Z", "action": 59, "target": "' Removes duplicate rows where values in column A are duplicate", "id": 48109904, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109904/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110310729/?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.145720Z", "action": 59, "target": "<emph>mode</emph>: Specifies what to do with duplicate rows. If <literal>mode = \"CLEAR\"</literal> then duplicates are simply removed from the sheet leaving the cells blank. If <literal>mode = \"COMPACT\"</literal> then duplicates are removed and empty rows are compacted up (Default = <literal>\"COMPACT\"</literal>).", "id": 48109903, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109903/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110310704/?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.145696Z", "action": 59, "target": "<emph>casesensitive</emph>: Specifies whether string comparisons are case-sensitive (Default = <literal>False</literal>).", "id": 48109902, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109902/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110310685/?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.145673Z", "action": 59, "target": "<emph>header</emph>: Specifies whether the first row is a header row (Default = <literal>False</literal>).", "id": 48109901, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109901/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110310669/?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.145651Z", "action": 59, "target": "<emph>columns</emph>: An array containing column numbers indicating which columns will be considered to determine if a row is a duplicate or not. If this argument is left blank, then only the first column is used. Items in this array must be in the interval between 1 and the range width.", "id": 48109900, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109900/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110310662/?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.145628Z", "action": 59, "target": "<emph>range</emph>: The range from which duplicates will be removed, as a string.", "id": 48109899, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109899/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110310651/?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.145605Z", "action": 59, "target": "The removal of duplicate rows is done starting at the first row in the range moving downwards, meaning that if two or more rows are duplicates then only the first one is kept.", "id": 48109898, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109898/?format=api" } ] }