Changes
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/components/libo_help-24-2/textsbasicshared03/changes/?format=api&page=7730
{ "count": 387073, "next": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/changes/?format=api&page=7731", "previous": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textsbasicshared03/changes/?format=api&page=7729", "results": [ { "unit": "https://translations.documentfoundation.org/api/units/110306578/?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.138400Z", "action": 59, "target": "newrange = oDoc.CompactLeft(\"Sheet1.G1:L10\", FilterFormula := \"=(MOD(SUM(G1:G10);2)=1)\")", "id": 48109694, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109694/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110306568/?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.138377Z", "action": 59, "target": "' Deletes all columns where the sum of values in the column is odd", "id": 48109693, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109693/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110306548/?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.138355Z", "action": 59, "target": "newrange = oDoc.CompactLeft(\"Sheet1.G1:L10\", FilterFormula := \"=(G1=\"\"X\"\")\")", "id": 48109692, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109692/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110306537/?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.138333Z", "action": 59, "target": "' Deletes all columns where the first row is marked with an \"X\"", "id": 48109691, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109691/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110306529/?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.138310Z", "action": 59, "target": "newrange = oDoc.CompactLeft(\"Sheet1.G1:L10\", WholeColumn := True)", "id": 48109690, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109690/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110306528/?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.138287Z", "action": 59, "target": "' The example below is similar, but the entire column is deleted from the sheet", "id": 48109689, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109689/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110306518/?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.138265Z", "action": 59, "target": "newrange = oDoc.CompactLeft(\"Sheet1.G1:L10\")", "id": 48109688, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109688/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110306509/?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.138242Z", "action": 59, "target": "' Delete all empty columns in the range G1:L10 from Sheet1", "id": 48109687, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109687/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110306508/?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.138220Z", "action": 59, "target": "Calc functions used 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": 48109686, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109686/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110306507/?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.138197Z", "action": 59, "target": "For example, suppose range <emph>A1:J200</emph> is selected (height = 200), so the default formula is <emph>=(COUNTBLANK(A1:A200)=200)</emph>. This means that if all 200 cells are empty in the first column (Column A), then the column is deleted. Note that the formula is expressed with respect to the first column only. Internally the <literal>CompactLeft</literal> method will generalize this formula for all the remaining columns.", "id": 48109685, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109685/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110306497/?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.138174Z", "action": 59, "target": "<emph>filterformula</emph>: The filter to be applied to each column to determine whether or not it will be deleted. The filter is expressed as a Calc formula that should be applied to the first column. When the formula returns <emph>True</emph> for a column, that column will be deleted. The default filter deletes all empty columns.", "id": 48109684, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109684/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110306487/?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.138151Z", "action": 59, "target": "<emph>wholecolumn</emph>: If this option is set to <literal>True</literal> the entire column will be deleted from the sheet. The default value is <literal>False</literal>, which means that the deleted column will be limited to the height of the specified <literal>range</literal>.", "id": 48109683, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109683/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110306480/?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.138126Z", "action": 59, "target": "<emph>range</emph>: The range from which columns will be deleted, as a string.", "id": 48109682, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109682/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110306462/?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.138103Z", "action": 59, "target": "If a range of cells is selected, calling this method will not impact the selection.", "id": 48109681, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109681/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110306235/?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.138081Z", "action": 59, "target": "This method returns a string with the range address of the compacted range. If all columns are deleted, then an empty string is returned.", "id": 48109680, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109680/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110306211/?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.138059Z", "action": 59, "target": "The deleted column can be limited to the height of the specified range or span to the height of the entire sheet, thus deleting whole columns.", "id": 48109679, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109679/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110306195/?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.138036Z", "action": 59, "target": "Deletes the columns of a specified range that match a filter expressed as a Calc formula. The filter is applied to each column to decide whether it will be deleted or not.", "id": 48109678, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109678/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110306182/?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.138014Z", "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": 48109677, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109677/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110306163/?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.137992Z", "action": 59, "target": "<emph>range</emph>: The range whose values and formulas are to be cleared, as a string.", "id": 48109676, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109676/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110306142/?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.137970Z", "action": 59, "target": "A filter formula can be specified to determine which cells shall be affected.", "id": 48109675, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109675/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110306114/?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.137948Z", "action": 59, "target": "Clears the values and formulas in the given range.", "id": 48109674, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109674/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110306074/?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.137926Z", "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": 48109673, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109673/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110306046/?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.137905Z", "action": 59, "target": "<emph>range</emph>: The range whose formats and styles are to be cleared, as a string.", "id": 48109672, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109672/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110306018/?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.137882Z", "action": 59, "target": "A filter formula can be specified to determine which cells shall be affected.", "id": 48109671, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109671/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110306006/?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.137858Z", "action": 59, "target": "Clears the formats and styles in the given range.", "id": 48109670, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109670/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110305986/?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.137836Z", "action": 59, "target": "myDoc.ClearAll(\"SheetX.A1:J10\", \"=SUM(SheetX.A1:A10)>100\", \"COLUMN\")", "id": 48109669, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109669/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110305973/?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.137814Z", "action": 59, "target": "myDoc.ClearAll(\"SheetX.A1:J10\", \"=SUM(SheetX.A1:J1)>100\", \"ROW\")", "id": 48109668, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109668/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110305944/?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.137792Z", "action": 59, "target": "myDoc.ClearAll(\"SheetX.A1:J10\", \"=SheetX.A1>100\", \"CELL\")", "id": 48109667, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109667/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110305925/?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.137769Z", "action": 59, "target": "myDoc.ClearAll(\"SheetX.A1:F10\")", "id": 48109666, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109666/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110305908/?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.137748Z", "action": 59, "target": "oDoc.ClearAll(\"SheetX.A1:J10\", \"=SUM(SheetX.A1:A10)>100\", \"COLUMN\")", "id": 48109665, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109665/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110305898/?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.137726Z", "action": 59, "target": "' Clears all columns in the range SheetX.A1:J10 whose sum is greater than 500", "id": 48109664, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109664/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110305884/?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.137703Z", "action": 59, "target": "oDoc.ClearAll(\"SheetX.A1:J10\", \"=SUM(SheetX.A1:J1)>100\", \"ROW\")", "id": 48109663, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109663/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110305852/?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.137682Z", "action": 59, "target": "' Clears all rows in the range SheetX.A1:J10 whose sum is greater than 500", "id": 48109662, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109662/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110305849/?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.137660Z", "action": 59, "target": "oDoc.ClearAll(\"SheetX.A1:J10\", \"=SheetX.A1>100\", \"CELL\")", "id": 48109661, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109661/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110305838/?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.137638Z", "action": 59, "target": "' Clears all cells in the range SheetX.A1:J10 that have a value greater than 100", "id": 48109660, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109660/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110305811/?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.137616Z", "action": 59, "target": "oDoc.ClearAll(\"SheetX.A1:J10\")", "id": 48109659, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109659/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110305779/?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.137593Z", "action": 59, "target": "' Clears all cells in the range SheetX.A1:J10", "id": 48109658, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109658/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110305761/?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.137569Z", "action": 59, "target": "<emph>\"COLUMN\":</emph> The formula specified in the <literal>filterformula</literal> argument is expanded once for each column in <literal>range</literal>.", "id": 48109657, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109657/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110305740/?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.137546Z", "action": 59, "target": "<emph>\"ROW\":</emph> The formula specified in the <literal>filterformula</literal> argument is expanded once for each row in <literal>range</literal>.", "id": 48109656, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109656/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110305707/?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.137522Z", "action": 59, "target": "<emph>\"CELL\":</emph> The formula specified in the <literal>filterformula</literal> argument is expanded once for each cell in <literal>range</literal>.", "id": 48109655, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109655/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110305641/?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.137486Z", "action": 59, "target": "<emph>filterscope:</emph> Determines how <literal>filterformula</literal> is expanded to the given range. This argument is mandatory if a <literal>filterformula</literal> is specified. The following values are accepted:", "id": 48109654, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109654/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110305627/?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.137451Z", "action": 59, "target": "<emph>filterformula:</emph> A Calc formula that shall be applied to the given range to determine which cells will be affected. The specified formula must return <literal>True</literal> or <literal>False</literal>. If this argument is not specified, then all cells in the range are affected.", "id": 48109653, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109653/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110305614/?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.137418Z", "action": 59, "target": "<emph>range:</emph> The range to be cleared, as a string.", "id": 48109652, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109652/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110305598/?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.137392Z", "action": 59, "target": "A filter formula can be specified to determine which cells shall be affected.", "id": 48109651, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109651/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110305577/?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.137367Z", "action": 59, "target": "Clears all the contents and formats of the given range.", "id": 48109650, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109650/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110305565/?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.137343Z", "action": 59, "target": "The following example accesses the chart named \"MyChart\" in \"Sheet1\" and prints its type.", "id": 48109649, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109649/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110305552/?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.137319Z", "action": 59, "target": "The example below shows the number of chart objects in \"Sheet1\".", "id": 48109648, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109648/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110305539/?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.137295Z", "action": 59, "target": "Use the <menuitem>Navigator</menuitem> sidebar to check the names assigned to charts under the <menuitem>OLE objects</menuitem> category.", "id": 48109647, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109647/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110305526/?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.137271Z", "action": 59, "target": "<emph>chartname</emph>: The user-defined name of the chart object to be returned. If the chart does not have a user-defined name, then the internal object name can be used. If this argument is absent, then the list of chart names in the specified sheet is returned.", "id": 48109646, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109646/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110305495/?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.137247Z", "action": 59, "target": "<emph>sheetname</emph>: The name of the sheet from which the list of charts is to be retrieved or where the specified chart is located.", "id": 48109645, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48109645/?format=api" } ] }