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/hyw/units/?format=api&page=12
{ "count": 3638, "next": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/hyw/units/?format=api&page=13", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/hyw/units/?format=api&page=11", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/hyw/?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": 99682007, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/hyw/?checksum=8be3504e7639da0c", "url": "https://translations.documentfoundation.org/api/units/99682007/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:02:21.534431Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/hyw/?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": 99682012, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/hyw/?checksum=d33c985dd107e066", "url": "https://translations.documentfoundation.org/api/units/99682012/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:02:21.601761Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/hyw/?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": 99682016, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/hyw/?checksum=b73004cf1118e1ab", "url": "https://translations.documentfoundation.org/api/units/99682016/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:02:21.604609Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/hyw/?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": 99682021, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/hyw/?checksum=8f3afc549b7e2d33", "url": "https://translations.documentfoundation.org/api/units/99682021/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:02:21.607293Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/hyw/?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": 99682027, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/hyw/?checksum=84960f7cea62edb8", "url": "https://translations.documentfoundation.org/api/units/99682027/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:02:21.609554Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/hyw/?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": 99682033, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/hyw/?checksum=14ba4484b5caa9cc", "url": "https://translations.documentfoundation.org/api/units/99682033/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:02:21.611317Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/hyw/?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": 99682039, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/hyw/?checksum=ff53f3875889117f", "url": "https://translations.documentfoundation.org/api/units/99682039/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:02:21.613023Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/hyw/?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": 99682044, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/hyw/?checksum=470e125ac81baff4", "url": "https://translations.documentfoundation.org/api/units/99682044/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:02:21.614735Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/hyw/?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": 99682050, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/hyw/?checksum=4e1ced4d6bd8d7e0", "url": "https://translations.documentfoundation.org/api/units/99682050/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:02:21.617780Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/hyw/?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": 99682055, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/hyw/?checksum=2afbbf6abe193195", "url": "https://translations.documentfoundation.org/api/units/99682055/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:02:21.620408Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/hyw/?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": 99682060, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/hyw/?checksum=d8c21f82a9fe7ddb", "url": "https://translations.documentfoundation.org/api/units/99682060/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:02:21.622335Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/hyw/?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": 99682065, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/hyw/?checksum=d8c401a444a95349", "url": "https://translations.documentfoundation.org/api/units/99682065/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:02:21.624167Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/hyw/?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": 99682068, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/hyw/?checksum=6471f0ae416b3e35", "url": "https://translations.documentfoundation.org/api/units/99682068/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:02:21.625827Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/hyw/?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": 99682073, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/hyw/?checksum=84278b6c542d33a0", "url": "https://translations.documentfoundation.org/api/units/99682073/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:02:21.627575Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/hyw/?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": 99682076, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/hyw/?checksum=95485fdaf4bb00f3", "url": "https://translations.documentfoundation.org/api/units/99682076/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:02:21.629258Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/hyw/?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": 99682080, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/hyw/?checksum=875cf1eb89f0b7a7", "url": "https://translations.documentfoundation.org/api/units/99682080/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:02:21.630833Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/hyw/?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": 99682085, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/hyw/?checksum=fed7ea71fa95f22d", "url": "https://translations.documentfoundation.org/api/units/99682085/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:02:21.632518Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/hyw/?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": 99682094, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/hyw/?checksum=e5265b8c6b6b1b8c", "url": "https://translations.documentfoundation.org/api/units/99682094/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:02:21.986913Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/hyw/?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": 99682101, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/hyw/?checksum=01b0185a94383426", "url": "https://translations.documentfoundation.org/api/units/99682101/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:02:21.989323Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/hyw/?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": 99682105, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/hyw/?checksum=80c4e760dce708a6", "url": "https://translations.documentfoundation.org/api/units/99682105/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:02:21.990723Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/hyw/?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": 99682112, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/hyw/?checksum=f8b3804119f2d4e0", "url": "https://translations.documentfoundation.org/api/units/99682112/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:02:21.993238Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/hyw/?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": 99682117, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/hyw/?checksum=888ef0e4c0129577", "url": "https://translations.documentfoundation.org/api/units/99682117/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:02:22.068272Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/hyw/?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": 99682123, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/hyw/?checksum=883ec33e69efcef6", "url": "https://translations.documentfoundation.org/api/units/99682123/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:02:22.075477Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/hyw/?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": 99682127, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/hyw/?checksum=92a246dfba1dd140", "url": "https://translations.documentfoundation.org/api/units/99682127/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:02:22.077472Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/hyw/?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": 99682133, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/hyw/?checksum=80afeb4b7d127f50", "url": "https://translations.documentfoundation.org/api/units/99682133/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:02:22.079141Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/hyw/?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": 99682142, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/hyw/?checksum=28f89e46faae75da", "url": "https://translations.documentfoundation.org/api/units/99682142/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:02:22.082003Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/hyw/?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": 99682146, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/hyw/?checksum=c9bdea3c9fe76b25", "url": "https://translations.documentfoundation.org/api/units/99682146/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:02:22.083760Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/hyw/?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": 99682153, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/hyw/?checksum=469ca65c78ed5c74", "url": "https://translations.documentfoundation.org/api/units/99682153/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:02:22.087396Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/hyw/?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": 99682156, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/hyw/?checksum=813069d72f6718bd", "url": "https://translations.documentfoundation.org/api/units/99682156/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:02:22.088912Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/hyw/?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": 99682160, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/hyw/?checksum=1e09191c28bbe44e", "url": "https://translations.documentfoundation.org/api/units/99682160/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:02:22.090488Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/hyw/?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": 99682164, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/hyw/?checksum=3f7387006a31716b", "url": "https://translations.documentfoundation.org/api/units/99682164/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:02:22.092085Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/hyw/?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": 99682167, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/hyw/?checksum=c46e4a4ca27d7398", "url": "https://translations.documentfoundation.org/api/units/99682167/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:02:22.093549Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/hyw/?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": 99682172, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/hyw/?checksum=a2275ea6ad961619", "url": "https://translations.documentfoundation.org/api/units/99682172/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:02:22.094994Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/hyw/?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": 99682176, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/hyw/?checksum=d0c9d47667330ad8", "url": "https://translations.documentfoundation.org/api/units/99682176/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:02:22.096431Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/hyw/?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": 99682180, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/hyw/?checksum=297ed35b86de1bbd", "url": "https://translations.documentfoundation.org/api/units/99682180/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:02:22.097839Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/hyw/?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": 99682184, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/hyw/?checksum=b48dd0d34c542a86", "url": "https://translations.documentfoundation.org/api/units/99682184/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:02:22.098877Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/hyw/?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": 99682188, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/hyw/?checksum=50f0cd3b9377c77e", "url": "https://translations.documentfoundation.org/api/units/99682188/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:02:22.100252Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/hyw/?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": 99682190, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/hyw/?checksum=153e4d271f5c3881", "url": "https://translations.documentfoundation.org/api/units/99682190/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:02:22.101578Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/hyw/?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": 99682192, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/hyw/?checksum=16dfcf1e7720b2a8", "url": "https://translations.documentfoundation.org/api/units/99682192/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:02:22.102789Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/hyw/?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": 99682193, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/hyw/?checksum=e2238c706441086b", "url": "https://translations.documentfoundation.org/api/units/99682193/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:02:22.103903Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/hyw/?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": 99682197, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/hyw/?checksum=aa7c2d9df37e8566", "url": "https://translations.documentfoundation.org/api/units/99682197/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:02:22.105123Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/hyw/?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": 99682200, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/hyw/?checksum=4828ec802e4e3ed5", "url": "https://translations.documentfoundation.org/api/units/99682200/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:02:22.108114Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/hyw/?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": 99682207, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/hyw/?checksum=d0b6fed2c3230778", "url": "https://translations.documentfoundation.org/api/units/99682207/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:02:22.112057Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/hyw/?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": 99682212, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/hyw/?checksum=7d0f0274dd5e2cc7", "url": "https://translations.documentfoundation.org/api/units/99682212/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:02:22.198227Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/hyw/?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": 99682216, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/hyw/?checksum=6444048cbd3209e4", "url": "https://translations.documentfoundation.org/api/units/99682216/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:02:22.200481Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/hyw/?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": 99682220, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/hyw/?checksum=142e0fe59edd07ec", "url": "https://translations.documentfoundation.org/api/units/99682220/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:02:22.202383Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/hyw/?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": 99682224, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/hyw/?checksum=f206ac8faa4ebbab", "url": "https://translations.documentfoundation.org/api/units/99682224/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:02:22.203709Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/hyw/?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": 99682229, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/hyw/?checksum=428a104606d497e9", "url": "https://translations.documentfoundation.org/api/units/99682229/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:02:22.204815Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/hyw/?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": 99682232, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/hyw/?checksum=c680f0ee09878103", "url": "https://translations.documentfoundation.org/api/units/99682232/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:02:22.205890Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/hyw/?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": 99682236, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/hyw/?checksum=8a0876af5b97287f", "url": "https://translations.documentfoundation.org/api/units/99682236/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T23:02:22.207033Z" } ] }