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/de/units/?format=api&page=13
{ "count": 3638, "next": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/de/units/?format=api&page=14", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/de/units/?format=api&page=12", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/de/?format=api", "source": [ "If a range of cells is selected, calling this method will not impact the selection." ], "previous_source": "", "target": [ "Wenn ein Zellbereich ausgewählt ist, wirkt sich das Aufrufen dieser Methode nicht auf die Auswahl aus." ], "id_hash": 6729834233954197878, "content_hash": 6729834233954197878, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id191652271892064\nhelp.text", "note": "j2GAb", "flags": "", "labels": [], "state": 20, "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": 99082827, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/de/?checksum=dd652c94601a6176", "url": "https://translations.documentfoundation.org/api/units/99082827/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:02.883033Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/de/?format=api", "source": [ "<emph>range</emph>: The range from which columns will be deleted, as a string." ], "previous_source": "", "target": [ "<emph>range</emph>: Der Bereich, aus dem Spalten gelöscht werden, als Zeichenfolge." ], "id_hash": -8113506369559715658, "content_hash": -8113506369559715658, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id771592919922181\nhelp.text", "note": "WsrKe", "flags": "", "labels": [], "state": 20, "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": 99082834, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/de/?checksum=0f6708f1af8620b6", "url": "https://translations.documentfoundation.org/api/units/99082834/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:02.884969Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/de/?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>: Wenn diese Option auf <literal>True</literal> gesetzt ist, wird die gesamte Spalte aus der Tabelle gelöscht. Der Standardwert ist <literal>False</literal>, was bedeutet, dass die gelöschte Spalte auf die Höhe des angegebenen <literal>Bereichs</literal> begrenzt wird." ], "id_hash": -4559422940038411441, "content_hash": -4559422940038411441, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id771592919932260\nhelp.text", "note": "Q9QBp", "flags": "", "labels": [], "state": 20, "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": 99082842, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/de/?checksum=40b9acfe2e3e4b4f", "url": "https://translations.documentfoundation.org/api/units/99082842/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:02.886831Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/de/?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>: Der Filter, der auf jede Spalte angewendet wird, um zu bestimmen, ob sie gelöscht wird oder nicht. Der Filter wird als Calc-Formel ausgedrückt, die auf die erste Spalte angewendet werden sollte. Wenn die Formel für eine Spalte <emph>True</emph> zurückgibt, wird diese Spalte gelöscht. Der Standardfilter löscht alle leeren Spalten." ], "id_hash": -7737930351596275317, "content_hash": -7737930351596275317, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id771592919915974\nhelp.text", "note": "M7qto", "flags": "", "labels": [], "state": 20, "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": 99082851, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/de/?checksum=149d5957b063f98b", "url": "https://translations.documentfoundation.org/api/units/99082851/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:02.889182Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/de/?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": [ "Angenommen, der Bereich <emph>A1:J200</emph> ist ausgewählt (Höhe = 200), die Standardformel lautet also <emph>=(COUNTBLANK(A1:A200)=200)</emph>. Das heißt, wenn alle 200 Zellen in der ersten Spalte (Spalte A) leer sind, dann wird die Spalte gelöscht. Beachten Sie, dass die Formel nur in Bezug auf die erste Spalte ausgedrückt wird. Intern wird die Methode <literal>CompactLeft</literal> diese Formel für alle verbleibenden Spalten verallgemeinern." ], "id_hash": 2650059504089948226, "content_hash": 2650059504089948226, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id361652271022647\nhelp.text", "note": "8sYWa", "flags": "", "labels": [], "state": 20, "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": 99082860, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/de/?checksum=a4c6e7140eede042", "url": "https://translations.documentfoundation.org/api/units/99082860/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:02.891483Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/de/?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-Funktionen, die im Argument <literal>filterformula</literal> verwendet werden, müssen mit ihren englischen Namen ausgedrückt werden. Besuchen Sie die Wiki-Seite <link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/List_of_Functions/de\">Liste der Calc-Funktionen</link> für eine vollständige Liste der Calc-Funktionen." ], "id_hash": -6271886129733203222, "content_hash": -6271886129733203222, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id431657568414625\nhelp.text", "note": "LQz5G", "flags": "", "labels": [], "state": 20, "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": 99082868, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/de/?checksum=28f5c8cb7d8d8aea", "url": "https://translations.documentfoundation.org/api/units/99082868/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:02.893821Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/de/?format=api", "source": [ "' Delete all empty columns in the range G1:L10 from Sheet1" ], "previous_source": "", "target": [ "' Alle leeren Spalten im Bereich G1:L10 aus Sheet1 löschen" ], "id_hash": -2423653425892021502, "content_hash": -2423653425892021502, "location": "sf_calc.xhp", "context": "sf_calc.xhp\nbas_id941652271391005\nhelp.text", "note": "FDspT", "flags": "", "labels": [], "state": 20, "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": 99082877, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/de/?checksum=5e5d740cdb0c2b02", "url": "https://translations.documentfoundation.org/api/units/99082877/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:02.895771Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/de/?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": 20, "fuzzy": false, "translated": true, "approved": false, "position": 608, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/98571316/?format=api", "priority": 100, "id": 99082884, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/de/?checksum=12c13f705360b1dc", "url": "https://translations.documentfoundation.org/api/units/99082884/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:02.897569Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/de/?format=api", "source": [ "' The example below is similar, but the entire column is deleted from the sheet" ], "previous_source": "", "target": [ "' Das folgende Beispiel ist ähnlich, aber die gesamte Spalte wird aus der Tabelle gelöscht" ], "id_hash": -2214787741373783576, "content_hash": -2214787741373783576, "location": "sf_calc.xhp", "context": "sf_calc.xhp\nbas_id921652271392627\nhelp.text", "note": "2BkcC", "flags": "", "labels": [], "state": 20, "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": 99082890, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/de/?checksum=61437e489e86a1e8", "url": "https://translations.documentfoundation.org/api/units/99082890/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:02.899369Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/de/?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": 20, "fuzzy": false, "translated": true, "approved": false, "position": 610, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/98571382/?format=api", "priority": 100, "id": 99082899, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/de/?checksum=0e36765ca21bb6c8", "url": "https://translations.documentfoundation.org/api/units/99082899/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:02.901325Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/de/?format=api", "source": [ "' Deletes all columns where the first row is marked with an \"X\"" ], "previous_source": "", "target": [ "' Löscht alle Spalten, bei denen die erste Zeile mit einem \"X\" markiert ist" ], "id_hash": -6393219210901577659, "content_hash": -6393219210901577659, "location": "sf_calc.xhp", "context": "sf_calc.xhp\nbas_id751652271393226\nhelp.text", "note": "KfQRA", "flags": "", "labels": [], "state": 20, "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": 99082906, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/de/?checksum=2746b9001b022045", "url": "https://translations.documentfoundation.org/api/units/99082906/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:02.903301Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/de/?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": 20, "fuzzy": false, "translated": true, "approved": false, "position": 612, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/98571469/?format=api", "priority": 100, "id": 99082913, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/de/?checksum=20c0f78e33d2a7db", "url": "https://translations.documentfoundation.org/api/units/99082913/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:02.904791Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/de/?format=api", "source": [ "' Deletes all columns where the sum of values in the column is odd" ], "previous_source": "", "target": [ "' Löscht alle Spalten, bei denen die erste Zeile mit einem \"X\" markiert ist" ], "id_hash": 7986409728897918979, "content_hash": 7986409728897918979, "location": "sf_calc.xhp", "context": "sf_calc.xhp\nbas_id241652271725676\nhelp.text", "note": "UqpQB", "flags": "", "labels": [], "state": 20, "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": 99082920, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/de/?checksum=eed56d55a9af2803", "url": "https://translations.documentfoundation.org/api/units/99082920/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:02.906758Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/de/?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": 20, "fuzzy": false, "translated": true, "approved": false, "position": 614, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/98571541/?format=api", "priority": 100, "id": 99082928, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/de/?checksum=60ef03ff66574c7e", "url": "https://translations.documentfoundation.org/api/units/99082928/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:02.908349Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/de/?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": 20, "fuzzy": false, "translated": true, "approved": false, "position": 615, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/98571559/?format=api", "priority": 100, "id": 99082935, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/de/?checksum=f5b9f5732cdbaaa1", "url": "https://translations.documentfoundation.org/api/units/99082935/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:02.910003Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/de/?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": 20, "fuzzy": false, "translated": true, "approved": false, "position": 616, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/98571572/?format=api", "priority": 100, "id": 99082941, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/de/?checksum=2a4a2a91fd74a21f", "url": "https://translations.documentfoundation.org/api/units/99082941/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:02.911560Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/de/?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": 20, "fuzzy": false, "translated": true, "approved": false, "position": 617, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/98571599/?format=api", "priority": 100, "id": 99082946, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/de/?checksum=18b314b1b8c3bb59", "url": "https://translations.documentfoundation.org/api/units/99082946/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:02.912958Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/de/?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": 20, "fuzzy": false, "translated": true, "approved": false, "position": 618, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/98571617/?format=api", "priority": 100, "id": 99082950, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/de/?checksum=2e4832f7a3926c50", "url": "https://translations.documentfoundation.org/api/units/99082950/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:02.914212Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/de/?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": [ "Löscht die Zeilen eines angegebenen Bereichs, die mit einem als Calc-Formel ausgedrückten Filter übereinstimmen. Der Filter wird auf jede Zeile angewendet, um zu entscheiden, ob sie gelöscht wird oder nicht." ], "id_hash": -89305867692239344, "content_hash": -89305867692239344, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id841592919903699\nhelp.text", "note": "vqJ5B", "flags": "", "labels": [], "state": 20, "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": 99082956, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/de/?checksum=7ec2b8c957d89610", "url": "https://translations.documentfoundation.org/api/units/99082956/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:02.915451Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/de/?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": [ "Die gelöschten Zeilen können auf die Breite des angegebenen Bereichs begrenzt werden oder sich über die Breite der gesamten Tabelle erstrecken, wodurch ganze Zeilen gelöscht werden." ], "id_hash": -2893638114323152427, "content_hash": -2893638114323152427, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id601652269910091\nhelp.text", "note": "RhiRD", "flags": "", "labels": [], "state": 20, "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": 99082960, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/de/?checksum=57d7bb77573cc1d5", "url": "https://translations.documentfoundation.org/api/units/99082960/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:02.916493Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/de/?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": [ "Diese Methode gibt eine Zeichenfolge mit der Bereichsadresse des komprimierten Bereichs zurück. Wenn alle Zeilen gelöscht werden, wird eine leere Zeichenfolge zurückgegeben." ], "id_hash": -5849820052738525597, "content_hash": -5849820052738525597, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id701652271283456\nhelp.text", "note": "Yw3WB", "flags": "", "labels": [], "state": 20, "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": 99082962, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/de/?checksum=2ed143a7dc903663", "url": "https://translations.documentfoundation.org/api/units/99082962/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:02.917509Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/de/?format=api", "source": [ "If a range of cells is selected, calling this method will not impact the selection." ], "previous_source": "", "target": [ "Wenn ein Zellbereich ausgewählt ist, wirkt sich das Aufrufen dieser Methode nicht auf die Auswahl aus." ], "id_hash": -862300146471571957, "content_hash": -862300146471571957, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id191652271893913\nhelp.text", "note": "RtGtW", "flags": "", "labels": [], "state": 20, "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": 99082967, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/de/?checksum=74087e95dfcb6e0b", "url": "https://translations.documentfoundation.org/api/units/99082967/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:02.918716Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/de/?format=api", "source": [ "<emph>range</emph>: The range from which rows will be deleted, as a string." ], "previous_source": "", "target": [ "<emph>range</emph>: Der Bereich, aus dem Zeilen gelöscht werden, als Zeichenfolge." ], "id_hash": 5701245945931448460, "content_hash": 5701245945931448460, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id771592919922080\nhelp.text", "note": "X3Ekj", "flags": "", "labels": [], "state": 20, "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": 99082972, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/de/?checksum=cf1ee4fb3861408c", "url": "https://translations.documentfoundation.org/api/units/99082972/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:02.984078Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/de/?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>: Wenn diese Option auf <literal>True</literal> gesetzt ist, wird die gesamte Zeile aus der Tabelle gelöscht. Der Standardwert ist <literal>False</literal>, was bedeutet, dass die gelöschte Zeile auf die Breite des angegebenen <literal>range</literal> beschränkt wird." ], "id_hash": 3269168695087870556, "content_hash": 3269168695087870556, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id771592919921160\nhelp.text", "note": "sAtHM", "flags": "", "labels": [], "state": 20, "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": 99082976, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/de/?checksum=ad5e6b9b7d8a325c", "url": "https://translations.documentfoundation.org/api/units/99082976/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:02.986305Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/de/?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>: Der Filter, der auf jede Zeile angewendet wird, um zu bestimmen, ob sie gelöscht wird oder nicht. Der Filter wird als Calc-Formel ausgedrückt, die auf die erste Zeile angewendet werden sollte. Wenn die Formel für eine Zeile <emph>True</emph> zurückgibt, wird diese Zeile gelöscht. Der Standardfilter löscht alle leeren Zeilen." ], "id_hash": -3615818996323342432, "content_hash": -3615818996323342432, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id771592919926374\nhelp.text", "note": "pKXWR", "flags": "", "labels": [], "state": 20, "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": 99082980, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/de/?checksum=4dd207c7c009a7a0", "url": "https://translations.documentfoundation.org/api/units/99082980/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:02.988444Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/de/?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": [ "Angenommen, der Bereich <emph>A1:J200</emph> ist ausgewählt (Breite = 10), die Standardformel ist also <emph>=(COUNTBLANK(A1:J1)=10)</emph>. Das heißt, wenn alle 10 Zellen in der ersten Zeile (Zeile 1) leer sind, dann wird die Zeile gelöscht. Beachten Sie, dass die Formel nur in Bezug auf die erste Zeile ausgedrückt wird. Intern wird die Methode <literal>CompactUp</literal> diese Formel für alle verbleibenden Zeilen verallgemeinern." ], "id_hash": -5711268816450555653, "content_hash": -5711268816450555653, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id361652271022681\nhelp.text", "note": "2DsWD", "flags": "", "labels": [], "state": 20, "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": 99082984, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/de/?checksum=30bd7f4562b2f0fb", "url": "https://translations.documentfoundation.org/api/units/99082984/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:02.990672Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/de/?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": [ "Die Calc-Funktionen, die in der im Argument <literal>filterformula</literal> angegebenen Formel verwendet werden, müssen mit ihren englischen Namen ausgedrückt werden. Besuchen Sie die Wiki-Seite <link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/List_of_Functions/de\">Liste der Calc-Funktionen</link> für eine vollständige Liste der Calc-Funktionen." ], "id_hash": 3013074956827737999, "content_hash": 3013074956827737999, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id431657568414714\nhelp.text", "note": "BxmHj", "flags": "", "labels": [], "state": 20, "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": 99082989, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/de/?checksum=a9d097b59357bf8f", "url": "https://translations.documentfoundation.org/api/units/99082989/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:02.993262Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/de/?format=api", "source": [ "' Delete all empty rows in the range G1:L10 from Sheet1" ], "previous_source": "", "target": [ "' Alle leeren Zeilen im Bereich G1:L10 aus Sheet1 löschen" ], "id_hash": -2727294934140530946, "content_hash": -2727294934140530946, "location": "sf_calc.xhp", "context": "sf_calc.xhp\nbas_id941652271391554\nhelp.text", "note": "GuWzD", "flags": "", "labels": [], "state": 20, "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": 99082996, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/de/?checksum=5a26b3b50cd4cefe", "url": "https://translations.documentfoundation.org/api/units/99082996/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:02.995650Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/de/?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": 20, "fuzzy": false, "translated": true, "approved": false, "position": 629, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/98572045/?format=api", "priority": 100, "id": 99083002, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/de/?checksum=0412d9d76479a029", "url": "https://translations.documentfoundation.org/api/units/99083002/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:02.997456Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/de/?format=api", "source": [ "' The example below is similar, but the entire row is deleted from the sheet" ], "previous_source": "", "target": [ "' Das folgende Beispiel ist ähnlich, aber die gesamte Zeile wird aus der Tabelle gelöscht" ], "id_hash": 5214667006128657360, "content_hash": 5214667006128657360, "location": "sf_calc.xhp", "context": "sf_calc.xhp\nbas_id921652271392567\nhelp.text", "note": "FV3Ev", "flags": "", "labels": [], "state": 20, "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": 99083006, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/de/?checksum=c85e38037a3f93d0", "url": "https://translations.documentfoundation.org/api/units/99083006/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:02.999638Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/de/?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": 20, "fuzzy": false, "translated": true, "approved": false, "position": 631, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/98572136/?format=api", "priority": 100, "id": 99083011, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/de/?checksum=fc6713e7825a9619", "url": "https://translations.documentfoundation.org/api/units/99083011/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:03.001347Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/de/?format=api", "source": [ "' Deletes all rows where the first column is marked with an \"X\"" ], "previous_source": "", "target": [ "' Löscht alle Zeilen, bei denen die erste Spalte mit einem \"X\" markiert ist" ], "id_hash": 1242996516193379019, "content_hash": 1242996516193379019, "location": "sf_calc.xhp", "context": "sf_calc.xhp\nbas_id751652271393117\nhelp.text", "note": "mFqmA", "flags": "", "labels": [], "state": 20, "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": 99083016, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/de/?checksum=914002beecc122cb", "url": "https://translations.documentfoundation.org/api/units/99083016/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:03.003532Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/de/?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": 20, "fuzzy": false, "translated": true, "approved": false, "position": 633, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/98572239/?format=api", "priority": 100, "id": 99083022, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/de/?checksum=849134f0d2bda113", "url": "https://translations.documentfoundation.org/api/units/99083022/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:03.005184Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/de/?format=api", "source": [ "' Deletes all rows where the sum of values in the row is odd" ], "previous_source": "", "target": [ "' Löscht alle Zeilen, in denen die Summe der Werte in der Zeile ungerade ist" ], "id_hash": 5607681209357476903, "content_hash": 5607681209357476903, "location": "sf_calc.xhp", "context": "sf_calc.xhp\nbas_id241652271725065\nhelp.text", "note": "DoDfJ", "flags": "", "labels": [], "state": 20, "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": 99083027, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/de/?checksum=cdd27c596162a427", "url": "https://translations.documentfoundation.org/api/units/99083027/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:03.007325Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/de/?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": 20, "fuzzy": false, "translated": true, "approved": false, "position": 635, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/98572318/?format=api", "priority": 100, "id": 99083031, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/de/?checksum=c54f3f09feb3312f", "url": "https://translations.documentfoundation.org/api/units/99083031/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:03.009001Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/de/?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": 20, "fuzzy": false, "translated": true, "approved": false, "position": 636, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/98572349/?format=api", "priority": 100, "id": 99083035, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/de/?checksum=166b4acac835bb18", "url": "https://translations.documentfoundation.org/api/units/99083035/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:03.011177Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/de/?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": 20, "fuzzy": false, "translated": true, "approved": false, "position": 637, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/98572396/?format=api", "priority": 100, "id": 99083040, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/de/?checksum=73ec39f97546c47b", "url": "https://translations.documentfoundation.org/api/units/99083040/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:03.013255Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/de/?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": 20, "fuzzy": false, "translated": true, "approved": false, "position": 638, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/98572480/?format=api", "priority": 100, "id": 99083051, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/de/?checksum=5d7ab7398505db6a", "url": "https://translations.documentfoundation.org/api/units/99083051/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:03.018364Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/de/?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": 20, "fuzzy": false, "translated": true, "approved": false, "position": 639, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/98572526/?format=api", "priority": 100, "id": 99083058, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/de/?checksum=b22e75481b665403", "url": "https://translations.documentfoundation.org/api/units/99083058/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:03.082489Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/de/?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": [ "Kopiert eine angegebene Tabelle vor eine vorhandene Tabelle oder an das Ende der Tabellenliste. Die zu kopierende Tabelle kann in jedem <emph>geöffneten</emph> Calc-Dokument enthalten sein. Gibt bei Erfolg <literal>True</literal> zurück." ], "id_hash": 6352430218308344905, "content_hash": 6352430218308344905, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id591591631693816\nhelp.text", "note": "n6vJD", "flags": "", "labels": [], "state": 20, "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": 99083063, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/de/?checksum=d8285da07eb9dc49", "url": "https://translations.documentfoundation.org/api/units/99083063/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:03.084765Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/de/?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>: Der Name der zu kopierenden Tabelle als Zeichenfolge oder seine Referenz als Objekt." ], "id_hash": -822798553372762257, "content_hash": -822798553372762257, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id871591631693741\nhelp.text", "note": "YqGL2", "flags": "", "labels": [], "state": 20, "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": 99083066, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/de/?checksum=7494d5133882df6f", "url": "https://translations.documentfoundation.org/api/units/99083066/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:03.087864Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/de/?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>: Der Name der einzufügenden Tabelle. Der Name darf im Dokument nicht verwendet werden." ], "id_hash": 264246308134559973, "content_hash": 264246308134559973, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id351591632126180\nhelp.text", "note": "5cEGG", "flags": "", "labels": [], "state": 20, "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": 99083069, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/de/?checksum=83aaca9e0191a0e5", "url": "https://translations.documentfoundation.org/api/units/99083069/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:03.089796Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/de/?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>: Der Name (String) oder Index (numerisch, beginnend mit 1) der Tabelle, vor der die kopierte Tabelle eingefügt werden soll. Dieses Argument ist optional und standardmäßig wird die kopierte Tabelle an der letzten Position hinzugefügt." ], "id_hash": -7351251077577507457, "content_hash": -7351251077577507457, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id211591632192379\nhelp.text", "note": "8sSno", "flags": "", "labels": [], "state": 20, "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": 99083077, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/de/?checksum=19fb1c17f248fd7f", "url": "https://translations.documentfoundation.org/api/units/99083077/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:03.091647Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/de/?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": [ "Das folgende Beispiel erstellt eine Kopie der TAbelle \"SheetX\" und platziert sie als letzte Tabelle im aktuellen Dokument. Der Name der kopierten Tabelle ist \"SheetY\"." ], "id_hash": 413700147613167258, "content_hash": 413700147613167258, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id961591632309410\nhelp.text", "note": "yuvEn", "flags": "", "labels": [], "state": 20, "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": 99083083, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/de/?checksum=85bdc217a6026e9a", "url": "https://translations.documentfoundation.org/api/units/99083083/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:03.093909Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/de/?format=api", "source": [ "'Gets the Document object of the active window" ], "previous_source": "", "target": [ "' Ruft das Objekt \"Document\" des aktiven Fensters ab" ], "id_hash": -3441017644253958226, "content_hash": -3441017644253958226, "location": "sf_calc.xhp", "context": "sf_calc.xhp\nbas_id231611706034607\nhelp.text", "note": "pqVdW", "flags": "", "labels": [], "state": 20, "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": 99083089, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/de/?checksum=503f0caf10642fae", "url": "https://translations.documentfoundation.org/api/units/99083089/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:03.095787Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/de/?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": [ "Das folgende Beispiel kopiert „SheetS“ aus „File.ods“ und fügt sie an der letzten Position von „FileB.ods“ mit dem Namen „SheetY“ ein:" ], "id_hash": 5098410387327329670, "content_hash": 5098410387327329670, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id461591632297415\nhelp.text", "note": "xUG9G", "flags": "", "labels": [], "state": 20, "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": 99083094, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/de/?checksum=c6c1313c17cea586", "url": "https://translations.documentfoundation.org/api/units/99083094/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:03.097494Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/de/?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": [ "Um Tabellen zwischen <emph>offenen</emph> Dokumenten zu kopieren, verwenden Sie <literal>CopySheet</literal>. Um Tabellen aus <emph>geschlossenen</emph> Dokumenten zu kopieren, verwenden Sie <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": 20, "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": 99083102, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/de/?checksum=d46d6f4a16b54b9e", "url": "https://translations.documentfoundation.org/api/units/99083102/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:03.099343Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/de/?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": [ "Kopiert eine bestimmte Tabelle aus einem <emph>geschlossenen</emph> Calc-Dokument und fügt sie vor einer bestehenden Tabelle oder am Ende der Liste der Tabellen der Datei ein, auf die durch ein Objekt <literal>Document</literal> verwiesen wird." ], "id_hash": 71251651323642476, "content_hash": 71251651323642476, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id931591714614755\nhelp.text", "note": "5fctt", "flags": "", "labels": [], "state": 20, "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": 99083109, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/de/?checksum=80fd22ffd6ce426c", "url": "https://translations.documentfoundation.org/api/units/99083109/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:03.101622Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/de/?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": [ "Wenn die Datei nicht existiert, wird ein Fehler ausgelöst. Wenn die Datei keine gültige Calc-Datei ist, wird eine leere Tabelle eingefügt. Wenn die Quelltabelle nicht in der Eingabedatei vorhanden ist, wird am Anfang der neu eingefügten Tabelle eine Fehlermeldung eingefügt." ], "id_hash": 4954474255409286440, "content_hash": 4954474255409286440, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id271611706609445\nhelp.text", "note": "M9mDA", "flags": "", "labels": [], "state": 20, "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": 99083113, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/de/?checksum=c4c1d415da7d0d28", "url": "https://translations.documentfoundation.org/api/units/99083113/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:03.103933Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textsbasicshared03/de/?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>: Identifiziert die zu öffnende Datei. Es muss der Notation <literal>SF_FileSystem.FileNaming</literal> folgen. Die Datei darf nicht mit einem Kennwort geschützt sein." ], "id_hash": 6161904090638406798, "content_hash": 6161904090638406798, "location": "sf_calc.xhp", "context": "sf_calc.xhp\npar_id471591714947181\nhelp.text", "note": "tCseT", "flags": "", "labels": [], "state": 20, "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": 99083120, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textsbasicshared03/de/?checksum=d5837b1f8e87548e", "url": "https://translations.documentfoundation.org/api/units/99083120/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:45:03.106113Z" } ] }