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/en/units/?format=api&page=13
https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/en/units/?format=api&page=14", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/en/units/?format=api&page=12", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/en/?format=api", "source": [ "If a range of cells is selected, calling this method will not impact the selection." ], "previous_source": "", "target": [ "If a range of cells is selected, calling this method will not impact the selection." ], "id_hash": 6729834233954197878, "content_hash": 6729834233954197878, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id191652271892064\nhelp.text", "note": "j2GAb", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 601, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/98571108/?format=api", "priority": 100, "id": 98571108, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/en/?checksum=dd652c94601a6176", "url": "https://translations.documentfoundation.org/api/units/98571108/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:28:59.428866Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/en/?format=api", "source": [ "<emph>range</emph>: The range from which columns will be deleted, as a string." ], "previous_source": "", "target": [ "<emph>range</emph>: The range from which columns will be deleted, as a string." ], "id_hash": -8113506369559715658, "content_hash": -8113506369559715658, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id771592919922181\nhelp.text", "note": "WsrKe", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 602, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/98571133/?format=api", "priority": 100, "id": 98571133, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/en/?checksum=0f6708f1af8620b6", "url": "https://translations.documentfoundation.org/api/units/98571133/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:28:59.439169Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/en/?format=api", "source": [ "<emph>wholecolumn</emph>: If this option is set to <literal>True</literal> the entire column will be deleted from the sheet. The default value is <literal>False</literal>, which means that the deleted column will be limited to the height of the specified <literal>range</literal>." ], "previous_source": "", "target": [ "<emph>wholecolumn</emph>: If this option is set to <literal>True</literal> the entire column will be deleted from the sheet. The default value is <literal>False</literal>, which means that the deleted column will be limited to the height of the specified <literal>range</literal>." ], "id_hash": -4559422940038411441, "content_hash": -4559422940038411441, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id771592919932260\nhelp.text", "note": "Q9QBp", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 603, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 38, "source_unit": "https://translations.documentfoundation.org/api/units/98571148/?format=api", "priority": 100, "id": 98571148, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/en/?checksum=40b9acfe2e3e4b4f", "url": "https://translations.documentfoundation.org/api/units/98571148/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:28:59.449513Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/en/?format=api", "source": [ "<emph>filterformula</emph>: The filter to be applied to each column to determine whether or not it will be deleted. The filter is expressed as a Calc formula that should be applied to the first column. When the formula returns <emph>True</emph> for a column, that column will be deleted. The default filter deletes all empty columns." ], "previous_source": "", "target": [ "<emph>filterformula</emph>: The filter to be applied to each column to determine whether or not it will be deleted. The filter is expressed as a Calc formula that should be applied to the first column. When the formula returns <emph>True</emph> for a column, that column will be deleted. The default filter deletes all empty columns." ], "id_hash": -7737930351596275317, "content_hash": -7737930351596275317, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id771592919915974\nhelp.text", "note": "M7qto", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 604, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 54, "source_unit": "https://translations.documentfoundation.org/api/units/98571170/?format=api", "priority": 100, "id": 98571170, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/en/?checksum=149d5957b063f98b", "url": "https://translations.documentfoundation.org/api/units/98571170/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:28:59.459789Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/en/?format=api", "source": [ "For example, suppose range <emph>A1:J200</emph> is selected (height = 200), so the default formula is <emph>=(COUNTBLANK(A1:A200)=200)</emph>. This means that if all 200 cells are empty in the first column (Column A), then the column is deleted. Note that the formula is expressed with respect to the first column only. Internally the <literal>CompactLeft</literal> method will generalize this formula for all the remaining columns." ], "previous_source": "", "target": [ "For example, suppose range <emph>A1:J200</emph> is selected (height = 200), so the default formula is <emph>=(COUNTBLANK(A1:A200)=200)</emph>. This means that if all 200 cells are empty in the first column (Column A), then the column is deleted. Note that the formula is expressed with respect to the first column only. Internally the <literal>CompactLeft</literal> method will generalize this formula for all the remaining columns." ], "id_hash": 2650059504089948226, "content_hash": 2650059504089948226, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id361652271022647\nhelp.text", "note": "8sYWa", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 605, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 62, "source_unit": "https://translations.documentfoundation.org/api/units/98571189/?format=api", "priority": 100, "id": 98571189, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/en/?checksum=a4c6e7140eede042", "url": "https://translations.documentfoundation.org/api/units/98571189/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:28:59.470262Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/en/?format=api", "source": [ "Calc functions used in the <literal>filterformula</literal> argument must be expressed using their English names. Visit the Wiki page <link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/List_of_Functions\">List of Calc Functions</link> for a complete list of Calc functions in English." ], "previous_source": "", "target": [ "Calc functions used in the <literal>filterformula</literal> argument must be expressed using their English names. Visit the Wiki page <link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/List_of_Functions\">List of Calc Functions</link> for a complete list of Calc functions in English." ], "id_hash": -6271886129733203222, "content_hash": -6271886129733203222, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id431657568414625\nhelp.text", "note": "LQz5G", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 606, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 32, "source_unit": "https://translations.documentfoundation.org/api/units/98571228/?format=api", "priority": 100, "id": 98571228, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/en/?checksum=28f5c8cb7d8d8aea", "url": "https://translations.documentfoundation.org/api/units/98571228/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:28:59.898544Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/en/?format=api", "source": [ "' Delete all empty columns in the range G1:L10 from Sheet1" ], "previous_source": "", "target": [ "' Delete all empty columns in the range G1:L10 from Sheet1" ], "id_hash": -2423653425892021502, "content_hash": -2423653425892021502, "location": "sf_calc.xhp", "context": "sf_calc.xhp\nbas_id941652271391005\nhelp.text", "note": "FDspT", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 607, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/98571258/?format=api", "priority": 100, "id": 98571258, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/en/?checksum=5e5d740cdb0c2b02", "url": "https://translations.documentfoundation.org/api/units/98571258/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:28:59.919000Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/en/?format=api", "source": [ "newrange = oDoc.CompactLeft(\"Sheet1.G1:L10\")" ], "previous_source": "", "target": [ "newrange = oDoc.CompactLeft(\"Sheet1.G1:L10\")" ], "id_hash": -7871940921999183396, "content_hash": -7871940921999183396, "location": "sf_calc.xhp", "context": "sf_calc.xhp\nbas_id691652271390762\nhelp.text", "note": "huH9x", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 608, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/98571316/?format=api", "priority": 100, "id": 98571316, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/en/?checksum=12c13f705360b1dc", "url": "https://translations.documentfoundation.org/api/units/98571316/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:28:59.953407Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/en/?format=api", "source": [ "' The example below is similar, but the entire column is deleted from the sheet" ], "previous_source": "", "target": [ "' The example below is similar, but the entire column is deleted from the sheet" ], "id_hash": -2214787741373783576, "content_hash": -2214787741373783576, "location": "sf_calc.xhp", "context": "sf_calc.xhp\nbas_id921652271392627\nhelp.text", "note": "2BkcC", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 609, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/98571358/?format=api", "priority": 100, "id": 98571358, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/en/?checksum=61437e489e86a1e8", "url": "https://translations.documentfoundation.org/api/units/98571358/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:28:59.970743Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/en/?format=api", "source": [ "newrange = oDoc.CompactLeft(\"Sheet1.G1:L10\", WholeColumn := True)" ], "previous_source": "", "target": [ "newrange = oDoc.CompactLeft(\"Sheet1.G1:L10\", WholeColumn := True)" ], "id_hash": -8199235931352615224, "content_hash": -8199235931352615224, "location": "sf_calc.xhp", "context": "sf_calc.xhp\nbas_id941652271392873\nhelp.text", "note": "6GoCu", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 610, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/98571382/?format=api", "priority": 100, "id": 98571382, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/en/?checksum=0e36765ca21bb6c8", "url": "https://translations.documentfoundation.org/api/units/98571382/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:28:59.981695Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/en/?format=api", "source": [ "' Deletes all columns where the first row is marked with an \"X\"" ], "previous_source": "", "target": [ "' Deletes all columns where the first row is marked with an \"X\"" ], "id_hash": -6393219210901577659, "content_hash": -6393219210901577659, "location": "sf_calc.xhp", "context": "sf_calc.xhp\nbas_id751652271393226\nhelp.text", "note": "KfQRA", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 611, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/98571426/?format=api", "priority": 100, "id": 98571426, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/en/?checksum=2746b9001b022045", "url": "https://translations.documentfoundation.org/api/units/98571426/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:28:59.993950Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/en/?format=api", "source": [ "newrange = oDoc.CompactLeft(\"Sheet1.G1:L10\", FilterFormula := \"=(G1=\"\"X\"\")\")" ], "previous_source": "", "target": [ "newrange = oDoc.CompactLeft(\"Sheet1.G1:L10\", FilterFormula := \"=(G1=\"\"X\"\")\")" ], "id_hash": -6863213641985775653, "content_hash": -6863213641985775653, "location": "sf_calc.xhp", "context": "sf_calc.xhp\nbas_id761652271393514\nhelp.text", "note": "fLJ7y", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 612, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/98571469/?format=api", "priority": 100, "id": 98571469, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/en/?checksum=20c0f78e33d2a7db", "url": "https://translations.documentfoundation.org/api/units/98571469/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:29:00.008721Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/en/?format=api", "source": [ "' Deletes all columns where the sum of values in the column is odd" ], "previous_source": "", "target": [ "' Deletes all columns where the sum of values in the column is odd" ], "id_hash": 7986409728897918979, "content_hash": 7986409728897918979, "location": "sf_calc.xhp", "context": "sf_calc.xhp\nbas_id241652271725676\nhelp.text", "note": "UqpQB", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 613, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/98571495/?format=api", "priority": 100, "id": 98571495, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/en/?checksum=eed56d55a9af2803", "url": "https://translations.documentfoundation.org/api/units/98571495/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:29:00.018734Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/en/?format=api", "source": [ "newrange = oDoc.CompactLeft(\"Sheet1.G1:L10\", FilterFormula := \"=(MOD(SUM(G1:G10);2)=1)\")" ], "previous_source": "", "target": [ "newrange = oDoc.CompactLeft(\"Sheet1.G1:L10\", FilterFormula := \"=(MOD(SUM(G1:G10);2)=1)\")" ], "id_hash": -2238566094311306114, "content_hash": -2238566094311306114, "location": "sf_calc.xhp", "context": "sf_calc.xhp\nbas_id531652271726131\nhelp.text", "note": "5rxDM", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 614, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/98571541/?format=api", "priority": 100, "id": 98571541, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/en/?checksum=60ef03ff66574c7e", "url": "https://translations.documentfoundation.org/api/units/98571541/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:29:00.035635Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/en/?format=api", "source": [ "newrange = myDoc.CompactLeft(\"Sheet1.G1:L10\")" ], "previous_source": "", "target": [ "newrange = myDoc.CompactLeft(\"Sheet1.G1:L10\")" ], "id_hash": 8483081248151677601, "content_hash": 8483081248151677601, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npyc_id451621536612334\nhelp.text", "note": "i4ux6", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 615, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/98571559/?format=api", "priority": 100, "id": 98571559, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/en/?checksum=f5b9f5732cdbaaa1", "url": "https://translations.documentfoundation.org/api/units/98571559/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:29:00.043844Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/en/?format=api", "source": [ "newrange = myDoc.CompactLeft(\"Sheet1.G1:L10\", wholecolumn = True)" ], "previous_source": "", "target": [ "newrange = myDoc.CompactLeft(\"Sheet1.G1:L10\", wholecolumn = True)" ], "id_hash": -6176077132474310113, "content_hash": -6176077132474310113, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npyc_id201652272121176\nhelp.text", "note": "j5kGd", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 616, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/98571572/?format=api", "priority": 100, "id": 98571572, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/en/?checksum=2a4a2a91fd74a21f", "url": "https://translations.documentfoundation.org/api/units/98571572/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:29:00.051258Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/en/?format=api", "source": [ "newrange = myDoc.CompactLeft(\"Sheet1.G1:L10\", filterformula = '=(G1=\"X\")')" ], "previous_source": "", "target": [ "newrange = myDoc.CompactLeft(\"Sheet1.G1:L10\", filterformula = '=(G1=\"X\")')" ], "id_hash": -7443583005571695783, "content_hash": -7443583005571695783, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npyc_id781652272122794\nhelp.text", "note": "pBca4", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 617, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/98571599/?format=api", "priority": 100, "id": 98571599, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/en/?checksum=18b314b1b8c3bb59", "url": "https://translations.documentfoundation.org/api/units/98571599/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:29:00.088522Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/en/?format=api", "source": [ "newrange = myDoc.CompactLeft(\"Sheet1.G1:L10\", filterformula = '=(MOD(SUM(G1:G10);2)=1)')" ], "previous_source": "", "target": [ "newrange = myDoc.CompactLeft(\"Sheet1.G1:L10\", filterformula = '=(MOD(SUM(G1:G10);2)=1)')" ], "id_hash": -5888400473604330416, "content_hash": -5888400473604330416, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npyc_id731652272123209\nhelp.text", "note": "VGAj6", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 618, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/98571617/?format=api", "priority": 100, "id": 98571617, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/en/?checksum=2e4832f7a3926c50", "url": "https://translations.documentfoundation.org/api/units/98571617/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:29:00.101475Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/en/?format=api", "source": [ "Deletes the rows of a specified range that match a filter expressed as a Calc formula. The filter is applied to each row to decide whether it will be deleted or not." ], "previous_source": "", "target": [ "Deletes the rows of a specified range that match a filter expressed as a Calc formula. The filter is applied to each row to decide whether it will be deleted or not." ], "id_hash": -89305867692239344, "content_hash": -89305867692239344, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id841592919903699\nhelp.text", "note": "vqJ5B", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 619, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 32, "source_unit": "https://translations.documentfoundation.org/api/units/98571634/?format=api", "priority": 100, "id": 98571634, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/en/?checksum=7ec2b8c957d89610", "url": "https://translations.documentfoundation.org/api/units/98571634/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:29:00.112973Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/en/?format=api", "source": [ "The deleted rows can be limited to the width of the specified range or span to the width of the entire sheet, thus deleting whole rows." ], "previous_source": "", "target": [ "The deleted rows can be limited to the width of the specified range or span to the width of the entire sheet, thus deleting whole rows." ], "id_hash": -2893638114323152427, "content_hash": -2893638114323152427, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id601652269910091\nhelp.text", "note": "RhiRD", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 620, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/98571671/?format=api", "priority": 100, "id": 98571671, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/en/?checksum=57d7bb77573cc1d5", "url": "https://translations.documentfoundation.org/api/units/98571671/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:29:00.127401Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/en/?format=api", "source": [ "This method returns a string with the range address of the compacted range. If all rows are deleted, then an empty string is returned." ], "previous_source": "", "target": [ "This method returns a string with the range address of the compacted range. If all rows are deleted, then an empty string is returned." ], "id_hash": -5849820052738525597, "content_hash": -5849820052738525597, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id701652271283456\nhelp.text", "note": "Yw3WB", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 621, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://translations.documentfoundation.org/api/units/98571699/?format=api", "priority": 100, "id": 98571699, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/en/?checksum=2ed143a7dc903663", "url": "https://translations.documentfoundation.org/api/units/98571699/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:29:00.138451Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/en/?format=api", "source": [ "If a range of cells is selected, calling this method will not impact the selection." ], "previous_source": "", "target": [ "If a range of cells is selected, calling this method will not impact the selection." ], "id_hash": -862300146471571957, "content_hash": -862300146471571957, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id191652271893913\nhelp.text", "note": "RtGtW", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 622, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/98571737/?format=api", "priority": 100, "id": 98571737, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/en/?checksum=74087e95dfcb6e0b", "url": "https://translations.documentfoundation.org/api/units/98571737/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:29:00.149223Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/en/?format=api", "source": [ "<emph>range</emph>: The range from which rows will be deleted, as a string." ], "previous_source": "", "target": [ "<emph>range</emph>: The range from which rows will be deleted, as a string." ], "id_hash": 5701245945931448460, "content_hash": 5701245945931448460, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id771592919922080\nhelp.text", "note": "X3Ekj", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 623, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/98571776/?format=api", "priority": 100, "id": 98571776, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/en/?checksum=cf1ee4fb3861408c", "url": "https://translations.documentfoundation.org/api/units/98571776/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:29:00.159697Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/en/?format=api", "source": [ "<emph>wholerow</emph>: If this option is set to <literal>True</literal> the entire row will be deleted from the sheet. The default value is <literal>False</literal>, which means that the deleted row will be limited to the width of the specified <literal>range</literal>." ], "previous_source": "", "target": [ "<emph>wholerow</emph>: If this option is set to <literal>True</literal> the entire row will be deleted from the sheet. The default value is <literal>False</literal>, which means that the deleted row will be limited to the width of the specified <literal>range</literal>." ], "id_hash": 3269168695087870556, "content_hash": 3269168695087870556, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id771592919921160\nhelp.text", "note": "sAtHM", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 624, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 38, "source_unit": "https://translations.documentfoundation.org/api/units/98571845/?format=api", "priority": 100, "id": 98571845, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/en/?checksum=ad5e6b9b7d8a325c", "url": "https://translations.documentfoundation.org/api/units/98571845/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:29:00.188363Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/en/?format=api", "source": [ "<emph>filterformula</emph>: The filter to be applied to each row to determine whether or not it will be deleted. The filter is expressed as a Calc formula that should be applied to the first row. When the formula returns <emph>True</emph> for a row, that row will be deleted. The default filter deletes all empty rows." ], "previous_source": "", "target": [ "<emph>filterformula</emph>: The filter to be applied to each row to determine whether or not it will be deleted. The filter is expressed as a Calc formula that should be applied to the first row. When the formula returns <emph>True</emph> for a row, that row will be deleted. The default filter deletes all empty rows." ], "id_hash": -3615818996323342432, "content_hash": -3615818996323342432, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id771592919926374\nhelp.text", "note": "pKXWR", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 625, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 54, "source_unit": "https://translations.documentfoundation.org/api/units/98571874/?format=api", "priority": 100, "id": 98571874, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/en/?checksum=4dd207c7c009a7a0", "url": "https://translations.documentfoundation.org/api/units/98571874/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:29:00.201834Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/en/?format=api", "source": [ "For example, suppose range <emph>A1:J200</emph> is selected (width = 10), so the default formula is <emph>=(COUNTBLANK(A1:J1)=10)</emph>. This means that if all 10 cells are empty in the first row (Row 1), then the row is deleted. Note that the formula is expressed with respect to the first row only. Internally the <literal>CompactUp</literal> method will generalize this formula for all the remaining rows." ], "previous_source": "", "target": [ "For example, suppose range <emph>A1:J200</emph> is selected (width = 10), so the default formula is <emph>=(COUNTBLANK(A1:J1)=10)</emph>. This means that if all 10 cells are empty in the first row (Row 1), then the row is deleted. Note that the formula is expressed with respect to the first row only. Internally the <literal>CompactUp</literal> method will generalize this formula for all the remaining rows." ], "id_hash": -5711268816450555653, "content_hash": -5711268816450555653, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id361652271022681\nhelp.text", "note": "2DsWD", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 626, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 62, "source_unit": "https://translations.documentfoundation.org/api/units/98571905/?format=api", "priority": 100, "id": 98571905, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/en/?checksum=30bd7f4562b2f0fb", "url": "https://translations.documentfoundation.org/api/units/98571905/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:29:00.218098Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/en/?format=api", "source": [ "The Calc functions used in the formula specified in the <literal>filterformula</literal> argument must be expressed using their English names. Visit the Wiki page <link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/List_of_Functions\">List of Calc Functions</link> for a complete list of Calc functions in English." ], "previous_source": "", "target": [ "The Calc functions used in the formula specified in the <literal>filterformula</literal> argument must be expressed using their English names. Visit the Wiki page <link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/List_of_Functions\">List of Calc Functions</link> for a complete list of Calc functions in English." ], "id_hash": 3013074956827737999, "content_hash": 3013074956827737999, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id431657568414714\nhelp.text", "note": "BxmHj", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 627, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 37, "source_unit": "https://translations.documentfoundation.org/api/units/98571958/?format=api", "priority": 100, "id": 98571958, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/en/?checksum=a9d097b59357bf8f", "url": "https://translations.documentfoundation.org/api/units/98571958/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:29:00.241435Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/en/?format=api", "source": [ "' Delete all empty rows in the range G1:L10 from Sheet1" ], "previous_source": "", "target": [ "' Delete all empty rows in the range G1:L10 from Sheet1" ], "id_hash": -2727294934140530946, "content_hash": -2727294934140530946, "location": "sf_calc.xhp", "context": "sf_calc.xhp\nbas_id941652271391554\nhelp.text", "note": "GuWzD", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 628, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/98572000/?format=api", "priority": 100, "id": 98572000, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/en/?checksum=5a26b3b50cd4cefe", "url": "https://translations.documentfoundation.org/api/units/98572000/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:29:00.255847Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/en/?format=api", "source": [ "newrange = oDoc.CompactUp(\"Sheet1.G1:L10\")" ], "previous_source": "", "target": [ "newrange = oDoc.CompactUp(\"Sheet1.G1:L10\")" ], "id_hash": -8929835591995383767, "content_hash": -8929835591995383767, "location": "sf_calc.xhp", "context": "sf_calc.xhp\nbas_id691652271390789\nhelp.text", "note": "GBrKx", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 629, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/98572045/?format=api", "priority": 100, "id": 98572045, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/en/?checksum=0412d9d76479a029", "url": "https://translations.documentfoundation.org/api/units/98572045/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:29:00.271973Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/en/?format=api", "source": [ "' The example below is similar, but the entire row is deleted from the sheet" ], "previous_source": "", "target": [ "' The example below is similar, but the entire row is deleted from the sheet" ], "id_hash": 5214667006128657360, "content_hash": 5214667006128657360, "location": "sf_calc.xhp", "context": "sf_calc.xhp\nbas_id921652271392567\nhelp.text", "note": "FV3Ev", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 630, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/98572094/?format=api", "priority": 100, "id": 98572094, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/en/?checksum=c85e38037a3f93d0", "url": "https://translations.documentfoundation.org/api/units/98572094/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:29:00.284563Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/en/?format=api", "source": [ "newrange = oDoc.CompactUp(\"Sheet1.G1:L10\", WholeRow := True)" ], "previous_source": "", "target": [ "newrange = oDoc.CompactUp(\"Sheet1.G1:L10\", WholeRow := True)" ], "id_hash": 8964155468349609497, "content_hash": 8964155468349609497, "location": "sf_calc.xhp", "context": "sf_calc.xhp\nbas_id941652271392553\nhelp.text", "note": "Y5YVh", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 631, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/98572136/?format=api", "priority": 100, "id": 98572136, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/en/?checksum=fc6713e7825a9619", "url": "https://translations.documentfoundation.org/api/units/98572136/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:29:00.294024Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/en/?format=api", "source": [ "' Deletes all rows where the first column is marked with an \"X\"" ], "previous_source": "", "target": [ "' Deletes all rows where the first column is marked with an \"X\"" ], "id_hash": 1242996516193379019, "content_hash": 1242996516193379019, "location": "sf_calc.xhp", "context": "sf_calc.xhp\nbas_id751652271393117\nhelp.text", "note": "mFqmA", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 632, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/98572175/?format=api", "priority": 100, "id": 98572175, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/en/?checksum=914002beecc122cb", "url": "https://translations.documentfoundation.org/api/units/98572175/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:29:00.303400Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/en/?format=api", "source": [ "newrange = oDoc.CompactUp(\"Sheet1.G1:L10\", FilterFormula := \"=(G1=\"\"X\"\")\")" ], "previous_source": "", "target": [ "newrange = oDoc.CompactUp(\"Sheet1.G1:L10\", FilterFormula := \"=(G1=\"\"X\"\")\")" ], "id_hash": 329102456707195155, "content_hash": 329102456707195155, "location": "sf_calc.xhp", "context": "sf_calc.xhp\nbas_id761652271393034\nhelp.text", "note": "gJQRm", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 633, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/98572239/?format=api", "priority": 100, "id": 98572239, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/en/?checksum=849134f0d2bda113", "url": "https://translations.documentfoundation.org/api/units/98572239/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:29:00.910527Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/en/?format=api", "source": [ "' Deletes all rows where the sum of values in the row is odd" ], "previous_source": "", "target": [ "' Deletes all rows where the sum of values in the row is odd" ], "id_hash": 5607681209357476903, "content_hash": 5607681209357476903, "location": "sf_calc.xhp", "context": "sf_calc.xhp\nbas_id241652271725065\nhelp.text", "note": "DoDfJ", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 634, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/98572284/?format=api", "priority": 100, "id": 98572284, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/en/?checksum=cdd27c596162a427", "url": "https://translations.documentfoundation.org/api/units/98572284/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:29:00.922875Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/en/?format=api", "source": [ "newrange = oDoc.CompactUp(\"Sheet1.G1:L10\", FilterFormula := \"=(MOD(SUM(G1:L1);2)=1)\")" ], "previous_source": "", "target": [ "newrange = oDoc.CompactUp(\"Sheet1.G1:L10\", FilterFormula := \"=(MOD(SUM(G1:L1);2)=1)\")" ], "id_hash": 4994279823937581359, "content_hash": 4994279823937581359, "location": "sf_calc.xhp", "context": "sf_calc.xhp\nbas_id531652271726010\nhelp.text", "note": "zXErV", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 635, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/98572318/?format=api", "priority": 100, "id": 98572318, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/en/?checksum=c54f3f09feb3312f", "url": "https://translations.documentfoundation.org/api/units/98572318/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:29:00.933900Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/en/?format=api", "source": [ "newrange = myDoc.CompactUp(\"Sheet1.G1:L10\")" ], "previous_source": "", "target": [ "newrange = myDoc.CompactUp(\"Sheet1.G1:L10\")" ], "id_hash": -7607904910709507304, "content_hash": -7607904910709507304, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npyc_id451621536612227\nhelp.text", "note": "Mcwq5", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 636, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/98572349/?format=api", "priority": 100, "id": 98572349, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/en/?checksum=166b4acac835bb18", "url": "https://translations.documentfoundation.org/api/units/98572349/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:29:00.944493Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/en/?format=api", "source": [ "newrange = myDoc.CompactUp(\"Sheet1.G1:L10\", wholerow = True)" ], "previous_source": "", "target": [ "newrange = myDoc.CompactUp(\"Sheet1.G1:L10\", wholerow = True)" ], "id_hash": -870256884412136325, "content_hash": -870256884412136325, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npyc_id201652272121288\nhelp.text", "note": "tXmJD", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 637, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/98572396/?format=api", "priority": 100, "id": 98572396, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/en/?checksum=73ec39f97546c47b", "url": "https://translations.documentfoundation.org/api/units/98572396/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:29:00.961252Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/en/?format=api", "source": [ "newrange = myDoc.CompactUp(\"Sheet1.G1:L10\", filterformula = '=(G1=\"X\")')" ], "previous_source": "", "target": [ "newrange = myDoc.CompactUp(\"Sheet1.G1:L10\", filterformula = '=(G1=\"X\")')" ], "id_hash": -2487474386496005270, "content_hash": -2487474386496005270, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npyc_id781652272122931\nhelp.text", "note": "WZ3XF", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 638, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/98572480/?format=api", "priority": 100, "id": 98572480, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/en/?checksum=5d7ab7398505db6a", "url": "https://translations.documentfoundation.org/api/units/98572480/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:29:01.000544Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/en/?format=api", "source": [ "newrange = myDoc.CompactUp(\"Sheet1.G1:L10\", filterformula = '=(MOD(SUM(G1:L1);2)=1)')" ], "previous_source": "", "target": [ "newrange = myDoc.CompactUp(\"Sheet1.G1:L10\", filterformula = '=(MOD(SUM(G1:L1);2)=1)')" ], "id_hash": 3615956503382873091, "content_hash": 3615956503382873091, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npyc_id731652272123109\nhelp.text", "note": "4DfG9", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 639, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/98572526/?format=api", "priority": 100, "id": 98572526, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/en/?checksum=b22e75481b665403", "url": "https://translations.documentfoundation.org/api/units/98572526/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:29:01.012416Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/en/?format=api", "source": [ "Copies a specified sheet before an existing sheet or at the end of the list of sheets. The sheet to be copied may be contained inside any <emph>open</emph> Calc document. Returns <literal>True</literal> if successful." ], "previous_source": "", "target": [ "Copies a specified sheet before an existing sheet or at the end of the list of sheets. The sheet to be copied may be contained inside any <emph>open</emph> Calc document. Returns <literal>True</literal> if successful." ], "id_hash": 6352430218308344905, "content_hash": 6352430218308344905, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id591591631693816\nhelp.text", "note": "n6vJD", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 640, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 34, "source_unit": "https://translations.documentfoundation.org/api/units/98572571/?format=api", "priority": 100, "id": 98572571, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/en/?checksum=d8285da07eb9dc49", "url": "https://translations.documentfoundation.org/api/units/98572571/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:29:01.023152Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/en/?format=api", "source": [ "<emph>sheetname</emph>: The name of the sheet to be copied as a string or its reference as an object." ], "previous_source": "", "target": [ "<emph>sheetname</emph>: The name of the sheet to be copied as a string or its reference as an object." ], "id_hash": -822798553372762257, "content_hash": -822798553372762257, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id871591631693741\nhelp.text", "note": "YqGL2", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 641, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/98572601/?format=api", "priority": 100, "id": 98572601, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/en/?checksum=7494d5133882df6f", "url": "https://translations.documentfoundation.org/api/units/98572601/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:29:01.033908Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/en/?format=api", "source": [ "<emph>newname</emph>: The name of the sheet to insert. The name must not be in use in the document." ], "previous_source": "", "target": [ "<emph>newname</emph>: The name of the sheet to insert. The name must not be in use in the document." ], "id_hash": 264246308134559973, "content_hash": 264246308134559973, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id351591632126180\nhelp.text", "note": "5cEGG", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 642, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/98572627/?format=api", "priority": 100, "id": 98572627, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/en/?checksum=83aaca9e0191a0e5", "url": "https://translations.documentfoundation.org/api/units/98572627/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:29:01.043937Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/en/?format=api", "source": [ "<emph>beforesheet</emph>: The name (string) or index (numeric, starting from 1) of the sheet before which to insert the copied sheet. This argument is optional and the default behavior is to add the copied sheet at the last position." ], "previous_source": "", "target": [ "<emph>beforesheet</emph>: The name (string) or index (numeric, starting from 1) of the sheet before which to insert the copied sheet. This argument is optional and the default behavior is to add the copied sheet at the last position." ], "id_hash": -7351251077577507457, "content_hash": -7351251077577507457, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id211591632192379\nhelp.text", "note": "8sSno", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 643, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 38, "source_unit": "https://translations.documentfoundation.org/api/units/98572669/?format=api", "priority": 100, "id": 98572669, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/en/?checksum=19fb1c17f248fd7f", "url": "https://translations.documentfoundation.org/api/units/98572669/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:29:01.055708Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/en/?format=api", "source": [ "The following example makes a copy of the sheet \"SheetX\" and places it as the last sheet in the current document. The name of the copied sheet is \"SheetY\"." ], "previous_source": "", "target": [ "The following example makes a copy of the sheet \"SheetX\" and places it as the last sheet in the current document. The name of the copied sheet is \"SheetY\"." ], "id_hash": 413700147613167258, "content_hash": 413700147613167258, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id961591632309410\nhelp.text", "note": "yuvEn", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 644, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/98572750/?format=api", "priority": 100, "id": 98572750, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/en/?checksum=85bdc217a6026e9a", "url": "https://translations.documentfoundation.org/api/units/98572750/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:29:01.086967Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/en/?format=api", "source": [ "'Gets the Document object of the active window" ], "previous_source": "", "target": [ "'Gets the Document object of the active window" ], "id_hash": -3441017644253958226, "content_hash": -3441017644253958226, "location": "sf_calc.xhp", "context": "sf_calc.xhp\nbas_id231611706034607\nhelp.text", "note": "pqVdW", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 645, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/98572789/?format=api", "priority": 100, "id": 98572789, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/en/?checksum=503f0caf10642fae", "url": "https://translations.documentfoundation.org/api/units/98572789/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:29:01.098067Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/en/?format=api", "source": [ "The example below copies \"SheetX\" from \"FileA.ods\" and pastes it at the last position of \"FileB.ods\" with the name \"SheetY\":" ], "previous_source": "", "target": [ "The example below copies \"SheetX\" from \"FileA.ods\" and pastes it at the last position of \"FileB.ods\" with the name \"SheetY\":" ], "id_hash": 5098410387327329670, "content_hash": 5098410387327329670, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id461591632297415\nhelp.text", "note": "xUG9G", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 646, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/98572843/?format=api", "priority": 100, "id": 98572843, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/en/?checksum=c6c1313c17cea586", "url": "https://translations.documentfoundation.org/api/units/98572843/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:29:01.112754Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/en/?format=api", "source": [ "To copy sheets between <emph>open</emph> documents, use <literal>CopySheet</literal>. To copy sheets from documents that are <emph>closed</emph>, use <literal>CopySheetFromFile</literal>." ], "previous_source": "", "target": [ "To copy sheets between <emph>open</emph> documents, use <literal>CopySheet</literal>. To copy sheets from documents that are <emph>closed</emph>, use <literal>CopySheetFromFile</literal>." ], "id_hash": 6083641035646651294, "content_hash": 6083641035646651294, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id801595695285478\nhelp.text", "note": "2AAEx", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 647, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/98572891/?format=api", "priority": 100, "id": 98572891, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/en/?checksum=d46d6f4a16b54b9e", "url": "https://translations.documentfoundation.org/api/units/98572891/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:29:01.125423Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/en/?format=api", "source": [ "Copies a specified sheet from a <emph>closed</emph> Calc document and pastes it before an existing sheet or at the end of the list of sheets of the file referred to by a <literal>Document</literal> object." ], "previous_source": "", "target": [ "Copies a specified sheet from a <emph>closed</emph> Calc document and pastes it before an existing sheet or at the end of the list of sheets of the file referred to by a <literal>Document</literal> object." ], "id_hash": 71251651323642476, "content_hash": 71251651323642476, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id931591714614755\nhelp.text", "note": "5fctt", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 648, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 34, "source_unit": "https://translations.documentfoundation.org/api/units/98572927/?format=api", "priority": 100, "id": 98572927, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/en/?checksum=80fd22ffd6ce426c", "url": "https://translations.documentfoundation.org/api/units/98572927/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:29:01.135722Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/en/?format=api", "source": [ "If the file does not exist, an error is raised. If the file is not a valid Calc file, a blank sheet is inserted. If the source sheet does not exist in the input file, an error message is inserted at the top of the newly pasted sheet." ], "previous_source": "", "target": [ "If the file does not exist, an error is raised. If the file is not a valid Calc file, a blank sheet is inserted. If the source sheet does not exist in the input file, an error message is inserted at the top of the newly pasted sheet." ], "id_hash": 4954474255409286440, "content_hash": 4954474255409286440, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id271611706609445\nhelp.text", "note": "M9mDA", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 649, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 48, "source_unit": "https://translations.documentfoundation.org/api/units/98572976/?format=api", "priority": 100, "id": 98572976, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/en/?checksum=c4c1d415da7d0d28", "url": "https://translations.documentfoundation.org/api/units/98572976/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:29:01.157473Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/en/?format=api", "source": [ "<emph>filename</emph>: Identifies the file to open. It must follow the <literal>SF_FileSystem.FileNaming</literal> notation. The file must not be protected with a password." ], "previous_source": "", "target": [ "<emph>filename</emph>: Identifies the file to open. It must follow the <literal>SF_FileSystem.FileNaming</literal> notation. The file must not be protected with a password." ], "id_hash": 6161904090638406798, "content_hash": 6161904090638406798, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id471591714947181\nhelp.text", "note": "tCseT", "flags": "", "labels": [], "state": 100, "fuzzy": false, "translated": true, "approved": false, "position": 650, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://translations.documentfoundation.org/api/units/98573003/?format=api", "priority": 100, "id": 98573003, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/en/?checksum=d5837b1f8e87548e", "url": "https://translations.documentfoundation.org/api/units/98573003/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:29:01.168080Z" } ] }{ "count": 3638, "next": "