Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-24-2/textsbasicshared03/en_ZA/units/?format=api&page=13
https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_ZA/units/?format=api&page=14", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_ZA/units/?format=api&page=12", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_ZA/?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": 601, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/110306114/?format=api", "priority": 100, "id": 110801206, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_ZA/?checksum=7d0f0274dd5e2cc7", "url": "https://translations.documentfoundation.org/api/units/110801206/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:24:50.850944Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_ZA/?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": 602, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/110306142/?format=api", "priority": 100, "id": 110801212, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_ZA/?checksum=6444048cbd3209e4", "url": "https://translations.documentfoundation.org/api/units/110801212/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:24:50.857769Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_ZA/?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": 603, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/110306163/?format=api", "priority": 100, "id": 110801215, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_ZA/?checksum=142e0fe59edd07ec", "url": "https://translations.documentfoundation.org/api/units/110801215/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:24:50.859752Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_ZA/?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": 604, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/110306182/?format=api", "priority": 100, "id": 110801217, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_ZA/?checksum=f206ac8faa4ebbab", "url": "https://translations.documentfoundation.org/api/units/110801217/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:24:50.861466Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_ZA/?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": 605, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 32, "source_unit": "https://translations.documentfoundation.org/api/units/110306195/?format=api", "priority": 100, "id": 110801219, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_ZA/?checksum=428a104606d497e9", "url": "https://translations.documentfoundation.org/api/units/110801219/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:24:50.863177Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_ZA/?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": 606, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/110306211/?format=api", "priority": 100, "id": 110801223, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_ZA/?checksum=c680f0ee09878103", "url": "https://translations.documentfoundation.org/api/units/110801223/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:24:50.864822Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_ZA/?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": 607, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://translations.documentfoundation.org/api/units/110306235/?format=api", "priority": 100, "id": 110801227, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_ZA/?checksum=8a0876af5b97287f", "url": "https://translations.documentfoundation.org/api/units/110801227/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:24:50.866696Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_ZA/?format=api", "source": [ "If a range of cells is selected, calling this method will not impact the selection." ], "previous_source": "", "target": [ "" ], "id_hash": 6729834233954197878, "content_hash": 6729834233954197878, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id191652271892064\nhelp.text", "note": "j2GAb", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 608, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/110306462/?format=api", "priority": 100, "id": 110801229, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_ZA/?checksum=dd652c94601a6176", "url": "https://translations.documentfoundation.org/api/units/110801229/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:24:50.868379Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_ZA/?format=api", "source": [ "<emph>range</emph>: The range from which columns will be deleted, as a string." ], "previous_source": "", "target": [ "" ], "id_hash": -8113506369559715658, "content_hash": -8113506369559715658, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id771592919922181\nhelp.text", "note": "WsrKe", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 609, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/110306480/?format=api", "priority": 100, "id": 110801233, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_ZA/?checksum=0f6708f1af8620b6", "url": "https://translations.documentfoundation.org/api/units/110801233/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:24:50.870598Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_ZA/?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": [ "" ], "id_hash": -4559422940038411441, "content_hash": -4559422940038411441, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id771592919932260\nhelp.text", "note": "Q9QBp", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 610, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 38, "source_unit": "https://translations.documentfoundation.org/api/units/110306487/?format=api", "priority": 100, "id": 110801241, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_ZA/?checksum=40b9acfe2e3e4b4f", "url": "https://translations.documentfoundation.org/api/units/110801241/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:24:50.883863Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_ZA/?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": [ "" ], "id_hash": -7737930351596275317, "content_hash": -7737930351596275317, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id771592919915974\nhelp.text", "note": "M7qto", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 611, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 54, "source_unit": "https://translations.documentfoundation.org/api/units/110306497/?format=api", "priority": 100, "id": 110801248, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_ZA/?checksum=149d5957b063f98b", "url": "https://translations.documentfoundation.org/api/units/110801248/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:24:50.885903Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_ZA/?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": [ "" ], "id_hash": 2650059504089948226, "content_hash": 2650059504089948226, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id361652271022647\nhelp.text", "note": "8sYWa", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 612, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 62, "source_unit": "https://translations.documentfoundation.org/api/units/110306507/?format=api", "priority": 100, "id": 110801252, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_ZA/?checksum=a4c6e7140eede042", "url": "https://translations.documentfoundation.org/api/units/110801252/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:24:50.887743Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_ZA/?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": [ "" ], "id_hash": -6271886129733203222, "content_hash": -6271886129733203222, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id431657568414625\nhelp.text", "note": "LQz5G", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 613, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 32, "source_unit": "https://translations.documentfoundation.org/api/units/110306508/?format=api", "priority": 100, "id": 110801257, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_ZA/?checksum=28f5c8cb7d8d8aea", "url": "https://translations.documentfoundation.org/api/units/110801257/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:24:50.889602Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_ZA/?format=api", "source": [ "' Delete all empty columns in the range G1:L10 from Sheet1" ], "previous_source": "", "target": [ "" ], "id_hash": -2423653425892021502, "content_hash": -2423653425892021502, "location": "sf_calc.xhp", "context": "sf_calc.xhp\nbas_id941652271391005\nhelp.text", "note": "FDspT", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 614, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/110306509/?format=api", "priority": 100, "id": 110801261, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_ZA/?checksum=5e5d740cdb0c2b02", "url": "https://translations.documentfoundation.org/api/units/110801261/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:24:50.891389Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_ZA/?format=api", "source": [ "newrange = oDoc.CompactLeft(\"Sheet1.G1:L10\")" ], "previous_source": "", "target": [ "" ], "id_hash": -7871940921999183396, "content_hash": -7871940921999183396, "location": "sf_calc.xhp", "context": "sf_calc.xhp\nbas_id691652271390762\nhelp.text", "note": "huH9x", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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/110306518/?format=api", "priority": 100, "id": 110801265, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_ZA/?checksum=12c13f705360b1dc", "url": "https://translations.documentfoundation.org/api/units/110801265/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:24:50.893145Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_ZA/?format=api", "source": [ "' The example below is similar, but the entire column is deleted from the sheet" ], "previous_source": "", "target": [ "" ], "id_hash": -2214787741373783576, "content_hash": -2214787741373783576, "location": "sf_calc.xhp", "context": "sf_calc.xhp\nbas_id921652271392627\nhelp.text", "note": "2BkcC", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 616, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/110306528/?format=api", "priority": 100, "id": 110801268, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_ZA/?checksum=61437e489e86a1e8", "url": "https://translations.documentfoundation.org/api/units/110801268/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:24:50.894924Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_ZA/?format=api", "source": [ "newrange = oDoc.CompactLeft(\"Sheet1.G1:L10\", WholeColumn := True)" ], "previous_source": "", "target": [ "" ], "id_hash": -8199235931352615224, "content_hash": -8199235931352615224, "location": "sf_calc.xhp", "context": "sf_calc.xhp\nbas_id941652271392873\nhelp.text", "note": "6GoCu", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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/110306529/?format=api", "priority": 100, "id": 110801273, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_ZA/?checksum=0e36765ca21bb6c8", "url": "https://translations.documentfoundation.org/api/units/110801273/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:24:50.896679Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_ZA/?format=api", "source": [ "' Deletes all columns where the first row is marked with an \"X\"" ], "previous_source": "", "target": [ "" ], "id_hash": -6393219210901577659, "content_hash": -6393219210901577659, "location": "sf_calc.xhp", "context": "sf_calc.xhp\nbas_id751652271393226\nhelp.text", "note": "KfQRA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 618, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/110306537/?format=api", "priority": 100, "id": 110801285, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_ZA/?checksum=2746b9001b022045", "url": "https://translations.documentfoundation.org/api/units/110801285/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:24:50.904415Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_ZA/?format=api", "source": [ "newrange = oDoc.CompactLeft(\"Sheet1.G1:L10\", FilterFormula := \"=(G1=\"\"X\"\")\")" ], "previous_source": "", "target": [ "" ], "id_hash": -6863213641985775653, "content_hash": -6863213641985775653, "location": "sf_calc.xhp", "context": "sf_calc.xhp\nbas_id761652271393514\nhelp.text", "note": "fLJ7y", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 619, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/110306548/?format=api", "priority": 100, "id": 110801296, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_ZA/?checksum=20c0f78e33d2a7db", "url": "https://translations.documentfoundation.org/api/units/110801296/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:24:50.910320Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_ZA/?format=api", "source": [ "' Deletes all columns where the sum of values in the column is odd" ], "previous_source": "", "target": [ "" ], "id_hash": 7986409728897918979, "content_hash": 7986409728897918979, "location": "sf_calc.xhp", "context": "sf_calc.xhp\nbas_id241652271725676\nhelp.text", "note": "UqpQB", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 620, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/110306568/?format=api", "priority": 100, "id": 110801305, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_ZA/?checksum=eed56d55a9af2803", "url": "https://translations.documentfoundation.org/api/units/110801305/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:24:50.916475Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_ZA/?format=api", "source": [ "newrange = oDoc.CompactLeft(\"Sheet1.G1:L10\", FilterFormula := \"=(MOD(SUM(G1:G10);2)=1)\")" ], "previous_source": "", "target": [ "" ], "id_hash": -2238566094311306114, "content_hash": -2238566094311306114, "location": "sf_calc.xhp", "context": "sf_calc.xhp\nbas_id531652271726131\nhelp.text", "note": "5rxDM", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 621, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/110306578/?format=api", "priority": 100, "id": 110801309, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_ZA/?checksum=60ef03ff66574c7e", "url": "https://translations.documentfoundation.org/api/units/110801309/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:24:50.918480Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_ZA/?format=api", "source": [ "newrange = myDoc.CompactLeft(\"Sheet1.G1:L10\")" ], "previous_source": "", "target": [ "" ], "id_hash": 8483081248151677601, "content_hash": 8483081248151677601, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npyc_id451621536612334\nhelp.text", "note": "i4ux6", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 622, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/110306588/?format=api", "priority": 100, "id": 110801311, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_ZA/?checksum=f5b9f5732cdbaaa1", "url": "https://translations.documentfoundation.org/api/units/110801311/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:24:50.920248Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_ZA/?format=api", "source": [ "newrange = myDoc.CompactLeft(\"Sheet1.G1:L10\", wholecolumn = True)" ], "previous_source": "", "target": [ "" ], "id_hash": -6176077132474310113, "content_hash": -6176077132474310113, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npyc_id201652272121176\nhelp.text", "note": "j5kGd", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 623, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/110306598/?format=api", "priority": 100, "id": 110801313, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_ZA/?checksum=2a4a2a91fd74a21f", "url": "https://translations.documentfoundation.org/api/units/110801313/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:24:50.964019Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_ZA/?format=api", "source": [ "newrange = myDoc.CompactLeft(\"Sheet1.G1:L10\", filterformula = '=(G1=\"X\")')" ], "previous_source": "", "target": [ "" ], "id_hash": -7443583005571695783, "content_hash": -7443583005571695783, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npyc_id781652272122794\nhelp.text", "note": "pBca4", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 624, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/110306607/?format=api", "priority": 100, "id": 110801316, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_ZA/?checksum=18b314b1b8c3bb59", "url": "https://translations.documentfoundation.org/api/units/110801316/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:24:50.965941Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_ZA/?format=api", "source": [ "newrange = myDoc.CompactLeft(\"Sheet1.G1:L10\", filterformula = '=(MOD(SUM(G1:G10);2)=1)')" ], "previous_source": "", "target": [ "" ], "id_hash": -5888400473604330416, "content_hash": -5888400473604330416, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npyc_id731652272123209\nhelp.text", "note": "VGAj6", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 625, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/110306616/?format=api", "priority": 100, "id": 110801324, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_ZA/?checksum=2e4832f7a3926c50", "url": "https://translations.documentfoundation.org/api/units/110801324/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:24:50.975241Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_ZA/?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": [ "" ], "id_hash": -89305867692239344, "content_hash": -89305867692239344, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id841592919903699\nhelp.text", "note": "vqJ5B", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 626, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 32, "source_unit": "https://translations.documentfoundation.org/api/units/110306626/?format=api", "priority": 100, "id": 110801329, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_ZA/?checksum=7ec2b8c957d89610", "url": "https://translations.documentfoundation.org/api/units/110801329/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:24:50.978130Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_ZA/?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": [ "" ], "id_hash": -2893638114323152427, "content_hash": -2893638114323152427, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id601652269910091\nhelp.text", "note": "RhiRD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 627, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/110306642/?format=api", "priority": 100, "id": 110801333, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_ZA/?checksum=57d7bb77573cc1d5", "url": "https://translations.documentfoundation.org/api/units/110801333/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:24:50.980205Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_ZA/?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": [ "" ], "id_hash": -5849820052738525597, "content_hash": -5849820052738525597, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id701652271283456\nhelp.text", "note": "Yw3WB", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 628, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://translations.documentfoundation.org/api/units/110306659/?format=api", "priority": 100, "id": 110801337, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_ZA/?checksum=2ed143a7dc903663", "url": "https://translations.documentfoundation.org/api/units/110801337/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:24:50.982699Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_ZA/?format=api", "source": [ "If a range of cells is selected, calling this method will not impact the selection." ], "previous_source": "", "target": [ "" ], "id_hash": -862300146471571957, "content_hash": -862300146471571957, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id191652271893913\nhelp.text", "note": "RtGtW", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 629, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/110306673/?format=api", "priority": 100, "id": 110801342, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_ZA/?checksum=74087e95dfcb6e0b", "url": "https://translations.documentfoundation.org/api/units/110801342/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:24:50.985934Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_ZA/?format=api", "source": [ "<emph>range</emph>: The range from which rows will be deleted, as a string." ], "previous_source": "", "target": [ "" ], "id_hash": 5701245945931448460, "content_hash": 5701245945931448460, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id771592919922080\nhelp.text", "note": "X3Ekj", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 630, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/110306682/?format=api", "priority": 100, "id": 110801347, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_ZA/?checksum=cf1ee4fb3861408c", "url": "https://translations.documentfoundation.org/api/units/110801347/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:24:50.987876Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_ZA/?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": [ "" ], "id_hash": 3269168695087870556, "content_hash": 3269168695087870556, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id771592919921160\nhelp.text", "note": "sAtHM", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 631, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 38, "source_unit": "https://translations.documentfoundation.org/api/units/110306696/?format=api", "priority": 100, "id": 110801350, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_ZA/?checksum=ad5e6b9b7d8a325c", "url": "https://translations.documentfoundation.org/api/units/110801350/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:24:50.989781Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_ZA/?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": [ "" ], "id_hash": -3615818996323342432, "content_hash": -3615818996323342432, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id771592919926374\nhelp.text", "note": "pKXWR", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 632, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 54, "source_unit": "https://translations.documentfoundation.org/api/units/110306707/?format=api", "priority": 100, "id": 110801356, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_ZA/?checksum=4dd207c7c009a7a0", "url": "https://translations.documentfoundation.org/api/units/110801356/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:24:50.992818Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_ZA/?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": [ "" ], "id_hash": -5711268816450555653, "content_hash": -5711268816450555653, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id361652271022681\nhelp.text", "note": "2DsWD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 633, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 62, "source_unit": "https://translations.documentfoundation.org/api/units/110306716/?format=api", "priority": 100, "id": 110801358, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_ZA/?checksum=30bd7f4562b2f0fb", "url": "https://translations.documentfoundation.org/api/units/110801358/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:24:50.994639Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_ZA/?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": [ "" ], "id_hash": 3013074956827737999, "content_hash": 3013074956827737999, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id431657568414714\nhelp.text", "note": "BxmHj", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 634, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 37, "source_unit": "https://translations.documentfoundation.org/api/units/110306729/?format=api", "priority": 100, "id": 110801363, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_ZA/?checksum=a9d097b59357bf8f", "url": "https://translations.documentfoundation.org/api/units/110801363/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:24:51.002781Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_ZA/?format=api", "source": [ "' Delete all empty rows in the range G1:L10 from Sheet1" ], "previous_source": "", "target": [ "" ], "id_hash": -2727294934140530946, "content_hash": -2727294934140530946, "location": "sf_calc.xhp", "context": "sf_calc.xhp\nbas_id941652271391554\nhelp.text", "note": "GuWzD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 635, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/110306738/?format=api", "priority": 100, "id": 110801367, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_ZA/?checksum=5a26b3b50cd4cefe", "url": "https://translations.documentfoundation.org/api/units/110801367/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:24:51.005034Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_ZA/?format=api", "source": [ "newrange = oDoc.CompactUp(\"Sheet1.G1:L10\")" ], "previous_source": "", "target": [ "" ], "id_hash": -8929835591995383767, "content_hash": -8929835591995383767, "location": "sf_calc.xhp", "context": "sf_calc.xhp\nbas_id691652271390789\nhelp.text", "note": "GBrKx", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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/110306755/?format=api", "priority": 100, "id": 110801371, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_ZA/?checksum=0412d9d76479a029", "url": "https://translations.documentfoundation.org/api/units/110801371/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:24:51.006705Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_ZA/?format=api", "source": [ "' The example below is similar, but the entire row is deleted from the sheet" ], "previous_source": "", "target": [ "" ], "id_hash": 5214667006128657360, "content_hash": 5214667006128657360, "location": "sf_calc.xhp", "context": "sf_calc.xhp\nbas_id921652271392567\nhelp.text", "note": "FV3Ev", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 637, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/110306764/?format=api", "priority": 100, "id": 110801375, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_ZA/?checksum=c85e38037a3f93d0", "url": "https://translations.documentfoundation.org/api/units/110801375/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:24:51.008202Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_ZA/?format=api", "source": [ "newrange = oDoc.CompactUp(\"Sheet1.G1:L10\", WholeRow := True)" ], "previous_source": "", "target": [ "" ], "id_hash": 8964155468349609497, "content_hash": 8964155468349609497, "location": "sf_calc.xhp", "context": "sf_calc.xhp\nbas_id941652271392553\nhelp.text", "note": "Y5YVh", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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/110306774/?format=api", "priority": 100, "id": 110801385, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_ZA/?checksum=fc6713e7825a9619", "url": "https://translations.documentfoundation.org/api/units/110801385/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:24:51.071283Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_ZA/?format=api", "source": [ "' Deletes all rows where the first column is marked with an \"X\"" ], "previous_source": "", "target": [ "" ], "id_hash": 1242996516193379019, "content_hash": 1242996516193379019, "location": "sf_calc.xhp", "context": "sf_calc.xhp\nbas_id751652271393117\nhelp.text", "note": "mFqmA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 639, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/110306784/?format=api", "priority": 100, "id": 110801389, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_ZA/?checksum=914002beecc122cb", "url": "https://translations.documentfoundation.org/api/units/110801389/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:24:51.078432Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_ZA/?format=api", "source": [ "newrange = oDoc.CompactUp(\"Sheet1.G1:L10\", FilterFormula := \"=(G1=\"\"X\"\")\")" ], "previous_source": "", "target": [ "" ], "id_hash": 329102456707195155, "content_hash": 329102456707195155, "location": "sf_calc.xhp", "context": "sf_calc.xhp\nbas_id761652271393034\nhelp.text", "note": "gJQRm", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 640, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/110306795/?format=api", "priority": 100, "id": 110801399, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_ZA/?checksum=849134f0d2bda113", "url": "https://translations.documentfoundation.org/api/units/110801399/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:24:51.089353Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_ZA/?format=api", "source": [ "' Deletes all rows where the sum of values in the row is odd" ], "previous_source": "", "target": [ "" ], "id_hash": 5607681209357476903, "content_hash": 5607681209357476903, "location": "sf_calc.xhp", "context": "sf_calc.xhp\nbas_id241652271725065\nhelp.text", "note": "DoDfJ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 641, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/110306805/?format=api", "priority": 100, "id": 110801403, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_ZA/?checksum=cdd27c596162a427", "url": "https://translations.documentfoundation.org/api/units/110801403/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:24:51.092914Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_ZA/?format=api", "source": [ "newrange = oDoc.CompactUp(\"Sheet1.G1:L10\", FilterFormula := \"=(MOD(SUM(G1:L1);2)=1)\")" ], "previous_source": "", "target": [ "" ], "id_hash": 4994279823937581359, "content_hash": 4994279823937581359, "location": "sf_calc.xhp", "context": "sf_calc.xhp\nbas_id531652271726010\nhelp.text", "note": "zXErV", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 642, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/110306823/?format=api", "priority": 100, "id": 110801411, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_ZA/?checksum=c54f3f09feb3312f", "url": "https://translations.documentfoundation.org/api/units/110801411/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:24:51.098476Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_ZA/?format=api", "source": [ "newrange = myDoc.CompactUp(\"Sheet1.G1:L10\")" ], "previous_source": "", "target": [ "" ], "id_hash": -7607904910709507304, "content_hash": -7607904910709507304, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npyc_id451621536612227\nhelp.text", "note": "Mcwq5", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 643, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/110306869/?format=api", "priority": 100, "id": 110801415, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_ZA/?checksum=166b4acac835bb18", "url": "https://translations.documentfoundation.org/api/units/110801415/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:24:51.100633Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_ZA/?format=api", "source": [ "newrange = myDoc.CompactUp(\"Sheet1.G1:L10\", wholerow = True)" ], "previous_source": "", "target": [ "" ], "id_hash": -870256884412136325, "content_hash": -870256884412136325, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npyc_id201652272121288\nhelp.text", "note": "tXmJD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 644, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/110307011/?format=api", "priority": 100, "id": 110801423, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_ZA/?checksum=73ec39f97546c47b", "url": "https://translations.documentfoundation.org/api/units/110801423/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:24:51.107005Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_ZA/?format=api", "source": [ "newrange = myDoc.CompactUp(\"Sheet1.G1:L10\", filterformula = '=(G1=\"X\")')" ], "previous_source": "", "target": [ "" ], "id_hash": -2487474386496005270, "content_hash": -2487474386496005270, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npyc_id781652272122931\nhelp.text", "note": "WZ3XF", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 645, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/110307033/?format=api", "priority": 100, "id": 110801425, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_ZA/?checksum=5d7ab7398505db6a", "url": "https://translations.documentfoundation.org/api/units/110801425/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:24:51.108761Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_ZA/?format=api", "source": [ "newrange = myDoc.CompactUp(\"Sheet1.G1:L10\", filterformula = '=(MOD(SUM(G1:L1);2)=1)')" ], "previous_source": "", "target": [ "" ], "id_hash": 3615956503382873091, "content_hash": 3615956503382873091, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npyc_id731652272123109\nhelp.text", "note": "4DfG9", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 646, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/110307036/?format=api", "priority": 100, "id": 110801426, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_ZA/?checksum=b22e75481b665403", "url": "https://translations.documentfoundation.org/api/units/110801426/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:24:51.109873Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_ZA/?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": [ "" ], "id_hash": 6352430218308344905, "content_hash": 6352430218308344905, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id591591631693816\nhelp.text", "note": "n6vJD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 647, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 34, "source_unit": "https://translations.documentfoundation.org/api/units/110307037/?format=api", "priority": 100, "id": 110801428, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_ZA/?checksum=d8285da07eb9dc49", "url": "https://translations.documentfoundation.org/api/units/110801428/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:24:51.110886Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_ZA/?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": [ "" ], "id_hash": -822798553372762257, "content_hash": -822798553372762257, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id871591631693741\nhelp.text", "note": "YqGL2", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 648, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/110307039/?format=api", "priority": 100, "id": 110801429, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_ZA/?checksum=7494d5133882df6f", "url": "https://translations.documentfoundation.org/api/units/110801429/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:24:51.111937Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_ZA/?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": [ "" ], "id_hash": 264246308134559973, "content_hash": 264246308134559973, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id351591632126180\nhelp.text", "note": "5cEGG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 649, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/110307118/?format=api", "priority": 100, "id": 110801440, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_ZA/?checksum=83aaca9e0191a0e5", "url": "https://translations.documentfoundation.org/api/units/110801440/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:24:51.181143Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textsbasicshared03/en_ZA/?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": [ "" ], "id_hash": -7351251077577507457, "content_hash": -7351251077577507457, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id211591632192379\nhelp.text", "note": "8sSno", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 650, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 38, "source_unit": "https://translations.documentfoundation.org/api/units/110307157/?format=api", "priority": 100, "id": 110801444, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textsbasicshared03/en_ZA/?checksum=19fb1c17f248fd7f", "url": "https://translations.documentfoundation.org/api/units/110801444/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T18:24:51.183349Z" } ] }{ "count": 4173, "next": "