Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-7-6/textsbasicshared03/id/units/?format=api&page=12
https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/id/units/?format=api&page=13", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/id/units/?format=api&page=11", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/id/?format=api", "source": [ "Returns a range address as a string based on sheet coordinates, i.e. row and column numbers." ], "previous_source": "", "target": [ "" ], "id_hash": 856616652051700236, "content_hash": 856616652051700236, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id93158919969228\nhelp.text", "note": "Dis6i", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 551, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/98569325/?format=api", "priority": 100, "id": 99705560, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/id/?checksum=8be3504e7639da0c", "url": "https://translations.documentfoundation.org/api/units/99705560/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:03:22.830188Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/id/?format=api", "source": [ "If only a pair of coordinates is given, then an address to a single cell is returned. Additional arguments can specify the bottom-right cell of a rectangular range." ], "previous_source": "", "target": [ "" ], "id_hash": 5997836332456992870, "content_hash": 5997836332456992870, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id21635434153216\nhelp.text", "note": "4TBiF", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 552, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 28, "source_unit": "https://translations.documentfoundation.org/api/units/98569361/?format=api", "priority": 100, "id": 99705564, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/id/?checksum=d33c985dd107e066", "url": "https://translations.documentfoundation.org/api/units/99705564/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:03:22.831593Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/id/?format=api", "source": [ "<emph>row1, column1</emph>: Specify the row and column numbers of the top-left cell in the range to be considered. Row and column numbers start at 1." ], "previous_source": "", "target": [ "" ], "id_hash": 3976683758359732651, "content_hash": 3976683758359732651, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id821591631203080\nhelp.text", "note": "2BuFG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 553, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 25, "source_unit": "https://translations.documentfoundation.org/api/units/98569393/?format=api", "priority": 100, "id": 99705568, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/id/?checksum=b73004cf1118e1ab", "url": "https://translations.documentfoundation.org/api/units/99705568/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:03:22.833027Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/id/?format=api", "source": [ "<emph>row2, column2</emph>: Specify the row and column numbers of the bottom-right cell in the range to be considered. If these arguments are not provided, or if values smaller than <literal>row1</literal> and <literal>column1</literal> are given, then the address of the single cell range represented by <literal>row1</literal> and <literal>column1</literal> is returned." ], "previous_source": "", "target": [ "" ], "id_hash": 1097466899534327091, "content_hash": 1097466899534327091, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id821591631203212\nhelp.text", "note": "i7N7S", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 554, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 49, "source_unit": "https://translations.documentfoundation.org/api/units/98569418/?format=api", "priority": 100, "id": 99705572, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/id/?checksum=8f3afc549b7e2d33", "url": "https://translations.documentfoundation.org/api/units/99705572/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:03:22.834461Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/id/?format=api", "source": [ "<emph>sheetname</emph>: The name of the sheet to be appended to the returned range address. The sheet must exist. The default value is \"~\" corresponding to the currently active sheet." ], "previous_source": "", "target": [ "" ], "id_hash": 330468651841023416, "content_hash": 330468651841023416, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id821591631203336\nhelp.text", "note": "Egj6k", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 555, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/98569462/?format=api", "priority": 100, "id": 99705575, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/id/?checksum=84960f7cea62edb8", "url": "https://translations.documentfoundation.org/api/units/99705575/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:03:22.835885Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/id/?format=api", "source": [ "The examples below in Basic and Python consider that \"Sheet1\" is the currently active sheet." ], "previous_source": "", "target": [ "" ], "id_hash": -7729790473651705396, "content_hash": -7729790473651705396, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id131611616623705\nhelp.text", "note": "idfEg", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 556, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/98569494/?format=api", "priority": 100, "id": 99705579, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/id/?checksum=14ba4484b5caa9cc", "url": "https://translations.documentfoundation.org/api/units/99705579/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:03:22.837268Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/id/?format=api", "source": [ "The method <literal>A1Style</literal> can be combined with any of the many properties and methods of the Calc service that require a range as argument, such as <literal>GetValue</literal>, <literal>GetFormula</literal>, <literal>ClearAll</literal>, etc." ], "previous_source": "", "target": [ "" ], "id_hash": 9174944628515344767, "content_hash": 9174944628515344767, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id501611617808112\nhelp.text", "note": "eXJNG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 557, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 30, "source_unit": "https://translations.documentfoundation.org/api/units/98569544/?format=api", "priority": 100, "id": 99705582, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/id/?checksum=ff53f3875889117f", "url": "https://translations.documentfoundation.org/api/units/99705582/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:03:22.838568Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/id/?format=api", "source": [ "If the argument <literal>sheetname</literal> is provided, the given sheet is activated and it becomes the currently selected sheet. If the argument is absent, then the document window is activated." ], "previous_source": "", "target": [ "" ], "id_hash": -4103322029374328844, "content_hash": -4103322029374328844, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id93158919969864\nhelp.text", "note": "Hfeug", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 558, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/98569570/?format=api", "priority": 100, "id": 99705586, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/id/?checksum=470e125ac81baff4", "url": "https://translations.documentfoundation.org/api/units/99705586/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:03:22.839850Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/id/?format=api", "source": [ "<emph>sheetname</emph>: The name of the sheet to be activated in the document. The default value is an empty string, meaning that the document window will be activated without changing the active sheet." ], "previous_source": "", "target": [ "" ], "id_hash": -3594737485770860576, "content_hash": -3594737485770860576, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id821591631203996\nhelp.text", "note": "EhMzz", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 559, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 32, "source_unit": "https://translations.documentfoundation.org/api/units/98569617/?format=api", "priority": 100, "id": 99705590, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/id/?checksum=4e1ced4d6bd8d7e0", "url": "https://translations.documentfoundation.org/api/units/99705590/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:03:22.906868Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/id/?format=api", "source": [ "The example below activates the sheet named \"Sheet4\" in the currently active document." ], "previous_source": "", "target": [ "" ], "id_hash": -6126092402930667115, "content_hash": -6126092402930667115, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id131611616623714\nhelp.text", "note": "2cgiA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 560, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/98569657/?format=api", "priority": 100, "id": 99705597, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/id/?checksum=2afbbf6abe193195", "url": "https://translations.documentfoundation.org/api/units/99705597/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:03:22.910454Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/id/?format=api", "source": [ "Activating a sheet makes sense only if it is performed on a Calc document. To make sure you have a Calc document at hand you can use the <literal>isCalc</literal> property of the document object, which returns <literal>True</literal> if it is a Calc document and <literal>False</literal> otherwise." ], "previous_source": "", "target": [ "" ], "id_hash": 6395709066877763035, "content_hash": 6395709066877763035, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id501611617808220\nhelp.text", "note": "LRebz", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 561, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 46, "source_unit": "https://translations.documentfoundation.org/api/units/98569698/?format=api", "priority": 100, "id": 99705601, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/id/?checksum=d8c21f82a9fe7ddb", "url": "https://translations.documentfoundation.org/api/units/99705601/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:03:22.917649Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/id/?format=api", "source": [ "Returns either the list with the names of all chart objects in a given sheet or a single <literal>Chart</literal> service instance." ], "previous_source": "", "target": [ "" ], "id_hash": 6396239175811158857, "content_hash": 6396239175811158857, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id93158919969856\nhelp.text", "note": "KWFFF", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 562, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://translations.documentfoundation.org/api/units/98569737/?format=api", "priority": 100, "id": 99705605, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/id/?checksum=d8c401a444a95349", "url": "https://translations.documentfoundation.org/api/units/99705605/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:03:22.919643Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/id/?format=api", "source": [ "If only <literal>sheetname</literal> is specified, a zero-based array of strings containing the names of all charts is returned." ], "previous_source": "", "target": [ "" ], "id_hash": -1985541329481155019, "content_hash": -1985541329481155019, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id371635438503202\nhelp.text", "note": "MKgeJ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 563, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/98569757/?format=api", "priority": 100, "id": 99705609, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/id/?checksum=6471f0ae416b3e35", "url": "https://translations.documentfoundation.org/api/units/99705609/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:03:22.921298Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/id/?format=api", "source": [ "If a <literal>chartname</literal> is provided, then a single object corresponding to the desired chart is returned. The specified chart must exist." ], "previous_source": "", "target": [ "" ], "id_hash": 299361197628404640, "content_hash": 299361197628404640, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id371635438509045\nhelp.text", "note": "CLbLn", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 564, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://translations.documentfoundation.org/api/units/98569824/?format=api", "priority": 100, "id": 99705613, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/id/?checksum=84278b6c542d33a0", "url": "https://translations.documentfoundation.org/api/units/99705613/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:03:22.923166Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/id/?format=api", "source": [ "<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." ], "previous_source": "", "target": [ "" ], "id_hash": 1533581067133059315, "content_hash": 1533581067133059315, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id821591631205026\nhelp.text", "note": "T2e3d", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 565, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 23, "source_unit": "https://translations.documentfoundation.org/api/units/98569883/?format=api", "priority": 100, "id": 99705617, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/id/?checksum=95485fdaf4bb00f3", "url": "https://translations.documentfoundation.org/api/units/99705617/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:03:22.924763Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/id/?format=api", "source": [ "<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." ], "previous_source": "", "target": [ "" ], "id_hash": 530564850056738727, "content_hash": 530564850056738727, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id821591631203566\nhelp.text", "note": "Dhape", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 566, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 45, "source_unit": "https://translations.documentfoundation.org/api/units/98569907/?format=api", "priority": 100, "id": 99705621, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/id/?checksum=875cf1eb89f0b7a7", "url": "https://translations.documentfoundation.org/api/units/99705621/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:03:22.926212Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/id/?format=api", "source": [ "Use the <menuitem>Navigator</menuitem> sidebar to check the names assigned to charts under the <menuitem>OLE objects</menuitem> category." ], "previous_source": "", "target": [ "" ], "id_hash": 9140031744028045869, "content_hash": 9140031744028045869, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id431635438771588\nhelp.text", "note": "C7CSH", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 567, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/98569956/?format=api", "priority": 100, "id": 99705626, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/id/?checksum=fed7ea71fa95f22d", "url": "https://translations.documentfoundation.org/api/units/99705626/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:03:22.927492Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/id/?format=api", "source": [ "The example below shows the number of chart objects in \"Sheet1\"." ], "previous_source": "", "target": [ "" ], "id_hash": 7288613705601457036, "content_hash": 7288613705601457036, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id41635439328174\nhelp.text", "note": "zbX9R", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 568, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/98569984/?format=api", "priority": 100, "id": 99705630, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/id/?checksum=e5265b8c6b6b1b8c", "url": "https://translations.documentfoundation.org/api/units/99705630/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:03:22.928740Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/id/?format=api", "source": [ "The following example accesses the chart named \"MyChart\" in \"Sheet1\" and prints its type." ], "previous_source": "", "target": [ "" ], "id_hash": -9101748069602937818, "content_hash": -9101748069602937818, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id571635439417400\nhelp.text", "note": "gsLHX", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 569, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/98570010/?format=api", "priority": 100, "id": 99705633, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/id/?checksum=01b0185a94383426", "url": "https://translations.documentfoundation.org/api/units/99705633/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:03:22.929928Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/id/?format=api", "source": [ "Clears all the contents and formats of the given range." ], "previous_source": "", "target": [ "" ], "id_hash": 55423498644293798, "content_hash": 55423498644293798, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id31592919577984\nhelp.text", "note": "auJdC", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 570, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/98570060/?format=api", "priority": 100, "id": 99705637, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/id/?checksum=80c4e760dce708a6", "url": "https://translations.documentfoundation.org/api/units/99705637/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:03:22.931275Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/id/?format=api", "source": [ "A filter formula can be specified to determine which cells shall be affected." ], "previous_source": "", "target": [ "" ], "id_hash": 8697436322479133920, "content_hash": 8697436322479133920, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id961670941803758\nhelp.text", "note": "kjBF4", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 571, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/98570094/?format=api", "priority": 100, "id": 99705640, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/id/?checksum=f8b3804119f2d4e0", "url": "https://translations.documentfoundation.org/api/units/99705640/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:03:22.932567Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/id/?format=api", "source": [ "<emph>range:</emph> The range to be cleared, as a string." ], "previous_source": "", "target": [ "" ], "id_hash": 616695064261989751, "content_hash": 616695064261989751, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id441592919577809\nhelp.text", "note": "UXnVo", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 572, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/98570117/?format=api", "priority": 100, "id": 99705645, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/id/?checksum=888ef0e4c0129577", "url": "https://translations.documentfoundation.org/api/units/99705645/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:03:22.934318Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/id/?format=api", "source": [ "<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." ], "previous_source": "", "target": [ "" ], "id_hash": 594126873692196598, "content_hash": 594126873692196598, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id351670939954166\nhelp.text", "note": "Bq7qT", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 573, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 41, "source_unit": "https://translations.documentfoundation.org/api/units/98570139/?format=api", "priority": 100, "id": 99705649, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/id/?checksum=883ec33e69efcef6", "url": "https://translations.documentfoundation.org/api/units/99705649/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:03:22.936365Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/id/?format=api", "source": [ "<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:" ], "previous_source": "", "target": [ "" ], "id_hash": 1342713565623996736, "content_hash": 1342713565623996736, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id461670939954392\nhelp.text", "note": "Lvzwc", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 574, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://translations.documentfoundation.org/api/units/98570163/?format=api", "priority": 100, "id": 99705653, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/id/?checksum=92a246dfba1dd140", "url": "https://translations.documentfoundation.org/api/units/99705653/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:03:22.938095Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/id/?format=api", "source": [ "<emph>\"CELL\":</emph> The formula specified in the <literal>filterformula</literal> argument is expanded once for each cell in <literal>range</literal>." ], "previous_source": "", "target": [ "" ], "id_hash": 49516830377803600, "content_hash": 49516830377803600, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id991670941074213\nhelp.text", "note": "3pGBf", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 575, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/98570193/?format=api", "priority": 100, "id": 99705657, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/id/?checksum=80afeb4b7d127f50", "url": "https://translations.documentfoundation.org/api/units/99705657/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:03:22.999425Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/id/?format=api", "source": [ "<emph>\"ROW\":</emph> The formula specified in the <literal>filterformula</literal> argument is expanded once for each row in <literal>range</literal>." ], "previous_source": "", "target": [ "" ], "id_hash": -6271088453422778918, "content_hash": -6271088453422778918, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id911670941074926\nhelp.text", "note": "YGjYE", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 576, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/98570234/?format=api", "priority": 100, "id": 99705671, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/id/?checksum=28f89e46faae75da", "url": "https://translations.documentfoundation.org/api/units/99705671/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:03:23.014427Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/id/?format=api", "source": [ "<emph>\"COLUMN\":</emph> The formula specified in the <literal>filterformula</literal> argument is expanded once for each column in <literal>range</literal>." ], "previous_source": "", "target": [ "" ], "id_hash": 5313660681468734245, "content_hash": 5313660681468734245, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id581670941075101\nhelp.text", "note": "Uufc3", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 577, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/98570280/?format=api", "priority": 100, "id": 99705673, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/id/?checksum=c9bdea3c9fe76b25", "url": "https://translations.documentfoundation.org/api/units/99705673/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:03:23.016863Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/id/?format=api", "source": [ "' Clears all cells in the range SheetX.A1:J10" ], "previous_source": "", "target": [ "" ], "id_hash": -4135247441736934284, "content_hash": -4135247441736934284, "location": "sf_calc.xhp", "context": "sf_calc.xhp\nbas_id681670941294573\nhelp.text", "note": "gZzon", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 578, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/98570333/?format=api", "priority": 100, "id": 99705676, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/id/?checksum=469ca65c78ed5c74", "url": "https://translations.documentfoundation.org/api/units/99705676/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:03:23.018781Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/id/?format=api", "source": [ "oDoc.ClearAll(\"SheetX.A1:J10\")" ], "previous_source": "", "target": [ "" ], "id_hash": 85684765854210237, "content_hash": 85684765854210237, "location": "sf_calc.xhp", "context": "sf_calc.xhp\nbas_id521592919577626\nhelp.text", "note": "dZnwN", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 579, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/98570383/?format=api", "priority": 100, "id": 99705681, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/id/?checksum=813069d72f6718bd", "url": "https://translations.documentfoundation.org/api/units/99705681/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:03:23.022153Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/id/?format=api", "source": [ "' Clears all cells in the range SheetX.A1:J10 that have a value greater than 100" ], "previous_source": "", "target": [ "" ], "id_hash": -7059083332193360818, "content_hash": -7059083332193360818, "location": "sf_calc.xhp", "context": "sf_calc.xhp\nbas_id681670941294511\nhelp.text", "note": "SpP9R", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 580, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/98570416/?format=api", "priority": 100, "id": 99705685, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/id/?checksum=1e09191c28bbe44e", "url": "https://translations.documentfoundation.org/api/units/99705685/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:03:23.023714Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/id/?format=api", "source": [ "oDoc.ClearAll(\"SheetX.A1:J10\", \"=SheetX.A1>100\", \"CELL\")" ], "previous_source": "", "target": [ "" ], "id_hash": -4651225554292215445, "content_hash": -4651225554292215445, "location": "sf_calc.xhp", "context": "sf_calc.xhp\nbas_id521592919575446\nhelp.text", "note": "7Nnnv", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 581, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/98570459/?format=api", "priority": 100, "id": 99705689, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/id/?checksum=3f7387006a31716b", "url": "https://translations.documentfoundation.org/api/units/99705689/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:03:23.026163Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/id/?format=api", "source": [ "' Clears all rows in the range SheetX.A1:J10 whose sum is greater than 500" ], "previous_source": "", "target": [ "" ], "id_hash": 4930960335021372312, "content_hash": 4930960335021372312, "location": "sf_calc.xhp", "context": "sf_calc.xhp\nbas_id681670941233673\nhelp.text", "note": "8CXRd", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 582, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/98570502/?format=api", "priority": 100, "id": 99705692, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/id/?checksum=c46e4a4ca27d7398", "url": "https://translations.documentfoundation.org/api/units/99705692/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:03:23.027256Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/id/?format=api", "source": [ "oDoc.ClearAll(\"SheetX.A1:J10\", \"=SUM(SheetX.A1:J1)>100\", \"ROW\")" ], "previous_source": "", "target": [ "" ], "id_hash": 2461039791351141913, "content_hash": 2461039791351141913, "location": "sf_calc.xhp", "context": "sf_calc.xhp\nbas_id521592919518126\nhelp.text", "note": "pABDv", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 583, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/98570540/?format=api", "priority": 100, "id": 99705697, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/id/?checksum=a2275ea6ad961619", "url": "https://translations.documentfoundation.org/api/units/99705697/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:03:23.028861Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/id/?format=api", "source": [ "' Clears all columns in the range SheetX.A1:J10 whose sum is greater than 500" ], "previous_source": "", "target": [ "" ], "id_hash": 5821417598355704536, "content_hash": 5821417598355704536, "location": "sf_calc.xhp", "context": "sf_calc.xhp\nbas_id681670941293083\nhelp.text", "note": "5av7R", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 584, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/98570578/?format=api", "priority": 100, "id": 99705701, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/id/?checksum=d0c9d47667330ad8", "url": "https://translations.documentfoundation.org/api/units/99705701/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:03:23.030665Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/id/?format=api", "source": [ "oDoc.ClearAll(\"SheetX.A1:J10\", \"=SUM(SheetX.A1:A10)>100\", \"COLUMN\")" ], "previous_source": "", "target": [ "" ], "id_hash": -6233312444176000067, "content_hash": -6233312444176000067, "location": "sf_calc.xhp", "context": "sf_calc.xhp\nbas_id521592919577149\nhelp.text", "note": "Bp2iA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 585, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/98570603/?format=api", "priority": 100, "id": 99705707, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/id/?checksum=297ed35b86de1bbd", "url": "https://translations.documentfoundation.org/api/units/99705707/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:03:23.032172Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/id/?format=api", "source": [ "myDoc.ClearAll(\"SheetX.A1:F10\")" ], "previous_source": "", "target": [ "" ], "id_hash": 3786912467625716358, "content_hash": 3786912467625716358, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npyc_id211621536212144\nhelp.text", "note": "jBH48", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 586, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/98570634/?format=api", "priority": 100, "id": 99705710, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/id/?checksum=b48dd0d34c542a86", "url": "https://translations.documentfoundation.org/api/units/99705710/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:03:23.034104Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/id/?format=api", "source": [ "myDoc.ClearAll(\"SheetX.A1:J10\", \"=SheetX.A1>100\", \"CELL\")" ], "previous_source": "", "target": [ "" ], "id_hash": -3390984863649118338, "content_hash": -3390984863649118338, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npyc_id701670942024915\nhelp.text", "note": "CGEqi", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 587, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/98570666/?format=api", "priority": 100, "id": 99705717, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/id/?checksum=50f0cd3b9377c77e", "url": "https://translations.documentfoundation.org/api/units/99705717/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:03:23.035629Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/id/?format=api", "source": [ "myDoc.ClearAll(\"SheetX.A1:J10\", \"=SUM(SheetX.A1:J1)>100\", \"ROW\")" ], "previous_source": "", "target": [ "" ], "id_hash": -7692626283077027711, "content_hash": -7692626283077027711, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npyc_id261670942025274\nhelp.text", "note": "GDBWA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 588, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/98570690/?format=api", "priority": 100, "id": 99705721, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/id/?checksum=153e4d271f5c3881", "url": "https://translations.documentfoundation.org/api/units/99705721/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:03:23.037262Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/id/?format=api", "source": [ "myDoc.ClearAll(\"SheetX.A1:J10\", \"=SUM(SheetX.A1:A10)>100\", \"COLUMN\")" ], "previous_source": "", "target": [ "" ], "id_hash": -7575108318459284824, "content_hash": -7575108318459284824, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npyc_id711670942025635\nhelp.text", "note": "3fSEb", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 589, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/98570740/?format=api", "priority": 100, "id": 99705725, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/id/?checksum=16dfcf1e7720b2a8", "url": "https://translations.documentfoundation.org/api/units/99705725/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:03:23.038735Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/id/?format=api", "source": [ "Clears the formats and styles in the given range." ], "previous_source": "", "target": [ "" ], "id_hash": 7071650254248020075, "content_hash": 7071650254248020075, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id211592919864118\nhelp.text", "note": "Wz6CH", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 590, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/98570778/?format=api", "priority": 100, "id": 99705728, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/id/?checksum=e2238c706441086b", "url": "https://translations.documentfoundation.org/api/units/99705728/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:03:23.039924Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/id/?format=api", "source": [ "A filter formula can be specified to determine which cells shall be affected." ], "previous_source": "", "target": [ "" ], "id_hash": 3061372003123365222, "content_hash": 3061372003123365222, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id961670941800058\nhelp.text", "note": "PqtC3", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 591, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/98570812/?format=api", "priority": 100, "id": 99705731, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/id/?checksum=aa7c2d9df37e8566", "url": "https://translations.documentfoundation.org/api/units/99705731/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:03:23.041276Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/id/?format=api", "source": [ "<emph>range</emph>: The range whose formats and styles are to be cleared, as a string." ], "previous_source": "", "target": [ "" ], "id_hash": -4023706231778689323, "content_hash": -4023706231778689323, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id611592919864268\nhelp.text", "note": "6Qxnv", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 592, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/98570842/?format=api", "priority": 100, "id": 99705735, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/id/?checksum=4828ec802e4e3ed5", "url": "https://translations.documentfoundation.org/api/units/99705735/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:03:23.042566Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/id/?format=api", "source": [ "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>." ], "previous_source": "", "target": [ "" ], "id_hash": 5816116149966014328, "content_hash": 5816116149966014328, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id461670942481018\nhelp.text", "note": "WUdrV", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 593, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/98570861/?format=api", "priority": 100, "id": 99705737, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/id/?checksum=d0b6fed2c3230778", "url": "https://translations.documentfoundation.org/api/units/99705737/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:03:23.043533Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/id/?format=api", "source": [ "Clears the values and formulas in the given range." ], "previous_source": "", "target": [ "" ], "id_hash": -211947956509725497, "content_hash": -211947956509725497, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id841592919928169\nhelp.text", "note": "sMwMp", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 594, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/98570896/?format=api", "priority": 100, "id": 99705744, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/id/?checksum=7d0f0274dd5e2cc7", "url": "https://translations.documentfoundation.org/api/units/99705744/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:03:23.045220Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/id/?format=api", "source": [ "A filter formula can be specified to determine which cells shall be affected." ], "previous_source": "", "target": [ "" ], "id_hash": -1998467332129551900, "content_hash": -1998467332129551900, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id961670941801218\nhelp.text", "note": "te7oW", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 595, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/98570925/?format=api", "priority": 100, "id": 99705746, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/id/?checksum=6444048cbd3209e4", "url": "https://translations.documentfoundation.org/api/units/99705746/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:03:23.046512Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/id/?format=api", "source": [ "<emph>range</emph>: The range whose values and formulas are to be cleared, as a string." ], "previous_source": "", "target": [ "" ], "id_hash": -7769254828280313876, "content_hash": -7769254828280313876, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id771592919928320\nhelp.text", "note": "eEGn9", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 596, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/98570949/?format=api", "priority": 100, "id": 99705751, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/id/?checksum=142e0fe59edd07ec", "url": "https://translations.documentfoundation.org/api/units/99705751/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:03:23.047874Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/id/?format=api", "source": [ "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>." ], "previous_source": "", "target": [ "" ], "id_hash": 8216444303221636011, "content_hash": 8216444303221636011, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id461670942483664\nhelp.text", "note": "ZhT2V", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 597, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/98570974/?format=api", "priority": 100, "id": 99705756, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/id/?checksum=f206ac8faa4ebbab", "url": "https://translations.documentfoundation.org/api/units/99705756/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:03:23.049291Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/id/?format=api", "source": [ "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." ], "previous_source": "", "target": [ "" ], "id_hash": -4428709390617110551, "content_hash": -4428709390617110551, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id841592919903025\nhelp.text", "note": "JWFDb", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 598, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 32, "source_unit": "https://translations.documentfoundation.org/api/units/98571004/?format=api", "priority": 100, "id": 99705760, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/id/?checksum=428a104606d497e9", "url": "https://translations.documentfoundation.org/api/units/99705760/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:03:23.645364Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/id/?format=api", "source": [ "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." ], "previous_source": "", "target": [ "" ], "id_hash": 5080325284826677507, "content_hash": 5080325284826677507, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id601652269911029\nhelp.text", "note": "4JWnp", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 599, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/98571035/?format=api", "priority": 100, "id": 99705763, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/id/?checksum=c680f0ee09878103", "url": "https://translations.documentfoundation.org/api/units/99705763/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:03:23.653880Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/id/?format=api", "source": [ "This method returns a string with the range address of the compacted range. If all columns are deleted, then an empty string is returned." ], "previous_source": "", "target": [ "" ], "id_hash": 722958235720951935, "content_hash": 722958235720951935, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id701652271281106\nhelp.text", "note": "VAVU3", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 600, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://translations.documentfoundation.org/api/units/98571070/?format=api", "priority": 100, "id": 99705776, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/id/?checksum=8a0876af5b97287f", "url": "https://translations.documentfoundation.org/api/units/99705776/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:03:23.660439Z" } ] }{ "count": 3638, "next": "