Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-24-2/textscalc01/de/units/?format=api&page=152
https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/units/?format=api&page=153", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/units/?format=api&page=151", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<variable id=\"func_style_header\"><link href=\"text/scalc/01/func_style.xhp\">STYLE</link></variable> function" ], "previous_source": "", "target": [ "Funktion <variable id=\"func_style_header\"><link href=\"text/scalc/01/func_style.xhp\">VORLAGE</link></variable>" ], "id_hash": -1520579132033131848, "content_hash": -1520579132033131848, "location": "func_style.xhp", "context": "func_style.xhp\nhd_id321673374992325\nhelp.text", "note": "6AhEB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7551, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/111182391/?format=api", "priority": 100, "id": 112011655, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=6ae5d155f64b1ab8", "url": "https://translations.documentfoundation.org/api/units/112011655/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:58.480140Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_VORLAGE\"><variable id=\"func_style_desc\">Applies a style to the cell containing the formula.</variable></ahelp> After a set amount of time, another style can be applied." ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_VORLAGE\"><variable id=\"func_style_desc\">Wendet eine Vorlage auf die Zelle an, welche die Formel enthält.</variable></ahelp> Nach einer bestimmten Zeit kann eine anderer Vorlage angewendet werden." ], "id_hash": 6065142634155186855, "content_hash": 6065142634155186855, "location": "func_style.xhp", "context": "func_style.xhp\npar_id441673375101757\nhelp.text", "note": "y45sr", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7552, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 22, "source_unit": "https://translations.documentfoundation.org/api/units/111182458/?format=api", "priority": 100, "id": 112011656, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=d42bb7175ce59aa7", "url": "https://translations.documentfoundation.org/api/units/112011656/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:58.485375Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "This function always returns the numeric value 0, which allows to use it by adding the <emph>STYLE</emph> function to other functions in the same cell without changing its value." ], "previous_source": "", "target": [ "Diese Funktion gibt immer den numerischen Wert 0 zurück, wodurch sie verwendet werden kann, indem die Funktion <emph>STYLE</emph> zu anderen Funktionen in derselben Zelle hinzugefügt wird, ohne ihren Wert zu ändern." ], "id_hash": 1313034526901143741, "content_hash": 1313034526901143741, "location": "func_style.xhp", "context": "func_style.xhp\npar_id681673375365338\nhelp.text", "note": "GswPt", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7553, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/111182506/?format=api", "priority": 100, "id": 112011657, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=9238d5f209c408bd", "url": "https://translations.documentfoundation.org/api/units/112011657/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:58.491349Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "The STYLE function should not be used without compelling reason, its purpose is the use with asynchronous Add-In functions to visually notify about the availability of a result. In almost all other cases using conditional formatting instead is a better choice." ], "previous_source": "", "target": [ "Die Funktion VORLAGE sollte nicht ohne zwingenden Grund verwendet werden. Ihr Zweck ist die Verwendung mit asynchronen Add-In-Funktionen, um visuell über die Verfügbarkeit eines Ergebnisses zu informieren. In fast allen anderen Fällen ist die Verwendung einer bedingten Formatierung stattdessen die bessere Wahl." ], "id_hash": 4340852398694219373, "content_hash": 4340852398694219373, "location": "func_style.xhp", "context": "func_style.xhp\npar_id1670450904\nhelp.text", "note": "V9E4f", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7554, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 41, "source_unit": "https://translations.documentfoundation.org/api/units/111182575/?format=api", "priority": 100, "id": 112011658, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=bc3dce41fe923e6d", "url": "https://translations.documentfoundation.org/api/units/112011658/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:58.495055Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "STYLE(\"Style\" [; Time [; \"Style2\"]])" ], "previous_source": "", "target": [ "VORLAGE(\"Vorlage\" [; Zeit [; \"Vorlage2\"]])" ], "id_hash": 1305044713307895830, "content_hash": 1305044713307895830, "location": "func_style.xhp", "context": "func_style.xhp\npar_id961673376106137\nhelp.text", "note": "m2FBk", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7555, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/111182602/?format=api", "priority": 100, "id": 112011659, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=921c734098b7f816", "url": "https://translations.documentfoundation.org/api/units/112011659/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:58.498355Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<emph>Style</emph> is the name of the cell style to be applied to the cell. Style names are not case-sensitive and must be entered in quotation marks." ], "previous_source": "", "target": [ "<emph>Vorlage</emph> ist der Name der Zellvorlage, welche auf die Zelle angewendet werden soll. Vorlagennamen unterscheiden nicht zwischen Groß- und Kleinschreibung und müssen in Anführungszeichen eingegeben werden." ], "id_hash": 6015326205682868444, "content_hash": 6015326205682868444, "location": "func_style.xhp", "context": "func_style.xhp\npar_id31673375542211\nhelp.text", "note": "NkFMi", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7556, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/111182688/?format=api", "priority": 100, "id": 112011660, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=d37abb5041d360dc", "url": "https://translations.documentfoundation.org/api/units/112011660/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:58.503700Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<emph>Time</emph> is an optional time range in seconds. After this time is elapsed, the style defined in <emph>Style2</emph> is applied. Leave this parameter blank if you do not want the style to be changed." ], "previous_source": "", "target": [ "<emph>Zeit</emph> ist ein optionaler Zeitbereich in Sekunden. Nach Ablauf dieser Zeit wird die in <emph>Vorlage 2</emph> definierte Vorlage angewendet. Lassen Sie diesen Parameter leer, wenn Sie nicht möchten, dass die Vorlage geändert wird." ], "id_hash": 4574010901924514365, "content_hash": 4574010901924514365, "location": "func_style.xhp", "context": "func_style.xhp\npar_id161673375589532\nhelp.text", "note": "8E46w", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7557, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 34, "source_unit": "https://translations.documentfoundation.org/api/units/111182710/?format=api", "priority": 100, "id": 112011661, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=bf7a26ae5ff98a3d", "url": "https://translations.documentfoundation.org/api/units/112011661/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:58.508701Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<emph>Style2</emph> is the optional name of a cell style assigned to the cell after the time specified in the <emph>Time</emph> parameter has passed. If this parameter is missing the \"Default\" cell style is applied." ], "previous_source": "", "target": [ "<emph>Vorlage 2</emph> ist der optionale Name einer Zellvorlage, die der Zelle zugewiesen wird, nachdem die im Parameter <emph>Zeit</emph> angegebene Zeit verstrichen ist. Wenn dieser Parameter fehlt, wird die Zellvorlage \"Standard\" angewendet." ], "id_hash": 1618184598095757033, "content_hash": 1618184598095757033, "location": "func_style.xhp", "context": "func_style.xhp\npar_id81673375703156\nhelp.text", "note": "aFQCT", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7558, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 34, "source_unit": "https://translations.documentfoundation.org/api/units/111182800/?format=api", "priority": 100, "id": 112011662, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=9674f25186817ee9", "url": "https://translations.documentfoundation.org/api/units/112011662/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:58.513581Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<embedvar href=\"text/scalc/00/00000004.xhp#optional\"/>" ], "previous_source": "", "target": [ "<embedvar href=\"text/scalc/00/00000004.xhp#optional\"/>" ], "id_hash": -4148967812045054790, "content_hash": -4148967812045054790, "location": "func_style.xhp", "context": "func_style.xhp\npar_id971673376620554\nhelp.text", "note": "ryUMD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7559, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111182847/?format=api", "priority": 100, "id": 112011663, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=466be7c1d2865cba", "url": "https://translations.documentfoundation.org/api/units/112011663/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:58.517621Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<input>=10+STYLE(\"Good\",60,\"Neutral\")</input>" ], "previous_source": "", "target": [ "<input>=10+VORLAGE(\"Gut\",60,\"Neutral\")</input>" ], "id_hash": 8774010481600811310, "content_hash": 8774010481600811310, "location": "func_style.xhp", "context": "func_style.xhp\npar_id491673376748686\nhelp.text", "note": "U3hrJ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7560, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/111182902/?format=api", "priority": 100, "id": 112011664, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=f9c38c0bdb5ed12e", "url": "https://translations.documentfoundation.org/api/units/112011664/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:58.525274Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "Enters the value 10 into the cell and applies the style named \"Good\". After 60 seconds, the style \"Neutral\" is applied." ], "previous_source": "", "target": [ "Gibt den Wert 10 in die Zelle ein und wendet die Vorlage mit dem Namen \"Gut\" an. Nach 60 Sekunden wird die Vorlage „Neutral“ angewendet." ], "id_hash": -1878993523197637285, "content_hash": -1878993523197637285, "location": "func_style.xhp", "context": "func_style.xhp\npar_id11673376842469\nhelp.text", "note": "8deaD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7561, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://translations.documentfoundation.org/api/units/111182918/?format=api", "priority": 100, "id": 112011665, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=65ec7958928b8d5b", "url": "https://translations.documentfoundation.org/api/units/112011665/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:58.529058Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<input>=A1*A2+STYLE(IF(CURRENT()<100,\"Bad\",\"Good\"))</input>" ], "previous_source": "", "target": [ "<input>=A1*A2+VORLAGE(WENN(AKTUELL()<100,\"Schlecht\",\"Gut\"))</input>" ], "id_hash": 5410722021459901413, "content_hash": 5410722021459901413, "location": "func_style.xhp", "context": "func_style.xhp\npar_id271673376901358\nhelp.text", "note": "UYv4h", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7562, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/111182943/?format=api", "priority": 100, "id": 112011666, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=cb16bf02e3803be5", "url": "https://translations.documentfoundation.org/api/units/112011666/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:58.532725Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "Enters the result of multiplying the values in cells A1 and A2 and applies the style \"Bad\" if the result is less than 100, otherwise the style \"Good\" is applied. Here the function <emph>CURRENT()</emph> is used to get the currently evaluated value of the function in the cell." ], "previous_source": "", "target": [ "Trägt das Ergebnis der Multiplikation der Werte in den Zellen A1 und A2 ein und wendet die Vorlage „Schlecht“ an, wenn das Ergebnis kleiner als 100 ist, andernfalls wird die Vorlage „Gut“ angewendet. Es wird die Funktion <emph>AKTUELL()</emph> verwendet, um den aktuell ausgewerteten Wert der Funktion in der Zelle zu erhalten." ], "id_hash": -2021632878714423934, "content_hash": -2021632878714423934, "location": "func_style.xhp", "context": "func_style.xhp\npar_id1001673377339392\nhelp.text", "note": "Zt8eb", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7563, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 48, "source_unit": "https://translations.documentfoundation.org/api/units/111182975/?format=api", "priority": 100, "id": 112011667, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=63f1b79b9df9f582", "url": "https://translations.documentfoundation.org/api/units/112011667/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:58.535910Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<input>=\"Total\"&T(STYLE(\"Result\"))</input>" ], "previous_source": "", "target": [ "<input>=\"Gesamt\"&T(VORLAGE(\"Ergebnis\"))</input>" ], "id_hash": -4503359689536300631, "content_hash": -4503359689536300631, "location": "func_style.xhp", "context": "func_style.xhp\npar_id761673377678426\nhelp.text", "note": "nMoAR", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7564, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/111183065/?format=api", "priority": 100, "id": 112011668, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=4180da38e16019a9", "url": "https://translations.documentfoundation.org/api/units/112011668/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:58.539362Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "Enters the text \"Total\" into the cell and applies the style named \"Result\". Note that this example deals with textual values, hence the output of the <emph>STYLE</emph> function needs to be appended to the text using the & operator. The function <emph>T()</emph> is used to prevent the number \"0\" being appended to the resulting text." ], "previous_source": "", "target": [ "Fügt den Text „Gesamt“ in die Zelle ein und wendet die Vorlage „Ergebnis“ an. Beachten Sie, dass es in diesem Beispiel um Textwerte geht, daher muss die Ausgabe der Funktion <emph>VORLAGE</emph> mit dem Operator \"&\" an den Text angehängt werden. Die Funktion <emph>T()</emph> wird verwendet, um zu verhindern, dass die Zahl \"0\" an den resultierenden Text angehängt wird." ], "id_hash": -953226345366165529, "content_hash": -953226345366165529, "location": "func_style.xhp", "context": "func_style.xhp\npar_id871673377683120\nhelp.text", "note": "hBUAA", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7565, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 55, "source_unit": "https://translations.documentfoundation.org/api/units/111183097/?format=api", "priority": 100, "id": 112011669, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=72c575b075e7e7e7", "url": "https://translations.documentfoundation.org/api/units/112011669/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:58.541777Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/STYLE\">STYLE wiki page</link>." ], "previous_source": "", "target": [ "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/STYLE/de\">Wikiseite zu VORLAGE</link>." ], "id_hash": 7002454760026936309, "content_hash": 7002454760026936309, "location": "func_style.xhp", "context": "func_style.xhp\npar_id201677014634447\nhelp.text", "note": "zzt3s", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7566, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/111183135/?format=api", "priority": 100, "id": 112011670, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=e12db780ef2613f5", "url": "https://translations.documentfoundation.org/api/units/112011670/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:58.544626Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<link href=\"text/scalc/01/04060109.xhp\">Spreadsheet Functions</link>" ], "previous_source": "", "target": [ "<link href=\"text/scalc/01/04060109.xhp\">Tabellenfunktionen</link>" ], "id_hash": 7518784913983819571, "content_hash": 7518784913983819571, "location": "func_style.xhp", "context": "func_style.xhp\npar_id631673379195650\nhelp.text", "note": "rEQGK", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7567, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111183168/?format=api", "priority": 100, "id": 112011671, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=e858170b04924f33", "url": "https://translations.documentfoundation.org/api/units/112011671/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:58.546772Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<link href=\"text/scalc/guide/cellstyle_by_formula.xhp\">Assigning Formats by Formula</link>" ], "previous_source": "", "target": [ "<link href=\"text/scalc/guide/cellstyle_by_formula.xhp\">Formate mittels Formel zuweisen</link>" ], "id_hash": 5770525440401091501, "content_hash": 5770525440401091501, "location": "func_style.xhp", "context": "func_style.xhp\npar_id151673379420755\nhelp.text", "note": "VZ5Ga", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7568, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/111183184/?format=api", "priority": 100, "id": 112011672, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=d015065082762bad", "url": "https://translations.documentfoundation.org/api/units/112011672/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:58.549550Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<link href=\"text/scalc/01/04060104.xhp#func_current_description\">CURRENT function</link>" ], "previous_source": "", "target": [ "<link href=\"text/scalc/01/04060104.xhp#func_current_description\">Funktion AKTUELL</link>" ], "id_hash": -2897871533713709166, "content_hash": -2897871533713709166, "location": "func_style.xhp", "context": "func_style.xhp\npar_id461673376361959\nhelp.text", "note": "YADMA", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7569, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111183206/?format=api", "priority": 100, "id": 112011673, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=57c8b13194472792", "url": "https://translations.documentfoundation.org/api/units/112011673/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:58.559845Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<link href=\"text/scalc/01/04060110.xhp#t\">T function</link>" ], "previous_source": "", "target": [ "<link href=\"text/scalc/01/04060110.xhp#t\">Funktion T</link>" ], "id_hash": 5689967768727522419, "content_hash": 5689967768727522419, "location": "func_style.xhp", "context": "func_style.xhp\npar_id381673378944042\nhelp.text", "note": "L6tnb", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7570, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111183242/?format=api", "priority": 100, "id": 112011674, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=cef6d389f66d0c73", "url": "https://translations.documentfoundation.org/api/units/112011674/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:58.564050Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "SUM Function" ], "previous_source": "", "target": [ "Funktion SUMME" ], "id_hash": -835747380684224227, "content_hash": -835747380684224227, "location": "func_sum.xhp", "context": "func_sum.xhp\ntit\nhelp.text", "note": "mEZBk", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7571, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111183270/?format=api", "priority": 100, "id": 112011675, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=7466d42f6c5a891d", "url": "https://translations.documentfoundation.org/api/units/112011675/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:58.568121Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<bookmark_value>SUM function</bookmark_value> <bookmark_value>adding;numbers in cell ranges</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>SUMME (Funktion)</bookmark_value><bookmark_value>Addieren; Zahlen in Zellbereich</bookmark_value>" ], "id_hash": 6085024028718732676, "content_hash": 6085024028718732676, "location": "func_sum.xhp", "context": "func_sum.xhp\nid431636401649762\nhelp.text", "note": "fLyVA", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7572, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/111183290/?format=api", "priority": 100, "id": 112011676, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=d472591d417f1584", "url": "https://translations.documentfoundation.org/api/units/112011676/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:58.573250Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<variable id=\"sum_head\"><link href=\"text/scalc/01/func_sum.xhp\">SUM</link></variable>" ], "previous_source": "", "target": [ "<variable id=\"sum_head\"><link href=\"text/scalc/01/func_sum.xhp\">SUMME</link></variable>" ], "id_hash": -2868028676740648335, "content_hash": -2868028676740648335, "location": "func_sum.xhp", "context": "func_sum.xhp\nhd_id121636398275790\nhelp.text", "note": "jDti4", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7573, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111183311/?format=api", "priority": 100, "id": 112011677, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=5832b71d2d3d7271", "url": "https://translations.documentfoundation.org/api/units/112011677/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:58.576576Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<variable id=\"func_sum_desc\"><ahelp hid=\".\">Adds a set of numbers.</ahelp></variable>" ], "previous_source": "", "target": [ "<variable id=\"func_sum_desc\"><ahelp hid=\".\">Addiert eine Anzahl von Zahlen.</ahelp></variable>" ], "id_hash": -5625976177105928921, "content_hash": -5625976177105928921, "location": "func_sum.xhp", "context": "func_sum.xhp\npar_id491636401806866\nhelp.text", "note": "c32xJ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7574, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/111183348/?format=api", "priority": 100, "id": 112011678, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=31ec847980ca7d27", "url": "https://translations.documentfoundation.org/api/units/112011678/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:58.579156Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "SUM(<embedvar href=\"text/scalc/01/ful_func.xhp#number255_1\" markup=\"keep\"/>)" ], "previous_source": "", "target": [ "SUMME(<embedvar href=\"text/scalc/01/ful_func.xhp#number255_1\" markup=\"keep\"/>)" ], "id_hash": -1464919939241204293, "content_hash": -1464919939241204293, "location": "func_sum.xhp", "context": "func_sum.xhp\npar_id3163656\nhelp.text", "note": "vfwu7", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7575, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111183361/?format=api", "priority": 100, "id": 112011679, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=6bab8f13a52425bb", "url": "https://translations.documentfoundation.org/api/units/112011679/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:58.582218Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<input>=SUM(2;3;4)</input> returns 9." ], "previous_source": "", "target": [ "<input>=SUMME(2;3;4)</input> ergibt 9." ], "id_hash": -6946537612386304541, "content_hash": -6946537612386304541, "location": "func_sum.xhp", "context": "func_sum.xhp\npar_id3163704\nhelp.text", "note": "h8z3Q", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7576, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111183381/?format=api", "priority": 100, "id": 112011680, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=1f98f0d88ad2fde3", "url": "https://translations.documentfoundation.org/api/units/112011680/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:58.585333Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<item type=\"input\">=SUM(A1;A3;B5)</item> calculates the sum of the three cells." ], "previous_source": "", "target": [ "<item type=\"input\">=SUMME(A1;A3;B5)</item> berechnet die Summe der drei Zellen." ], "id_hash": 652939789567612619, "content_hash": 652939789567612619, "location": "func_sum.xhp", "context": "func_sum.xhp\npar_id3151740\nhelp.text", "note": "6ohPR", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7577, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/111183404/?format=api", "priority": 100, "id": 112011681, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=890fb54778e556cb", "url": "https://translations.documentfoundation.org/api/units/112011681/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:58.589481Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<item type=\"input\">=SUM(A1:E10)</item> calculates the sum of all cells in the A1 to E10 cell range." ], "previous_source": "", "target": [ "<item type=\"input\">=SUMME(A1:E10)</item> berechnet die Summe aller Zellen im Bereich A1 bis E10." ], "id_hash": -3872165459397171147, "content_hash": -3872165459397171147, "location": "func_sum.xhp", "context": "func_sum.xhp\npar_id931636109030406\nhelp.text", "note": "FbQ6a", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7578, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/111183420/?format=api", "priority": 100, "id": 112011682, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=4a434e07c1182835", "url": "https://translations.documentfoundation.org/api/units/112011682/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:58.591948Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "A formula such as <input>=SUM((A1:A40>=C1)*(A1:A40<C2)*B1:B40)</input> may be entered as an <link href=\"text/scalc/01/04060107.xhp\">array formula</link> by pressing the Shift<switchinline select=\"sys\"><caseinline select=\"MAC\">+Command</caseinline><defaultinline>+Ctrl</defaultinline></switchinline>+Enter keys instead of simply pressing the Enter key to finish entering the formula. The formula will then be shown in the Formula bar enclosed in braces and operates by multiplying corresponding elements of the arrays together and returning their sum." ], "previous_source": "", "target": [ "Eine Formel wie <input>=SUMME((A1:A40>=C1)*(A1:A40<C2)*B1:B40)</input> kann als <link href=\"text/scalc/01/04060107.xhp\">Matrixformel</link> eingegeben werden, indem [Umschalt+<switchinline select=\"sys\"><caseinline select=\"MAC\">Befehl</caseinline><defaultinline>Strg</defaultinline></switchinline>+Eingabetaste] anstatt einfach [Eingabetaste] gedrückt wird, um die Eingabe der Formel abzuschließen. Die Formel wird dann in der in Klammern eingeschlossenen Formelleiste angezeigt und funktioniert, indem entsprechende Elemente der Matrizen miteinander multipliziert und ihre Summe zurückgegeben werden." ], "id_hash": -8203016005970044413, "content_hash": -8203016005970044413, "location": "func_sum.xhp", "context": "func_sum.xhp\npar_id3151756\nhelp.text", "note": "UmyxD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7579, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 59, "source_unit": "https://translations.documentfoundation.org/api/units/111183456/?format=api", "priority": 100, "id": 112011683, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=0e2908676d4fda03", "url": "https://translations.documentfoundation.org/api/units/112011683/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:58.594907Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/SUM\">SUM wiki page</link>." ], "previous_source": "", "target": [ "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/SUM/de\">Wikiseite zu SUMME</link>." ], "id_hash": 4469010790866011402, "content_hash": 4469010790866011402, "location": "func_sum.xhp", "context": "func_sum.xhp\npar_id771677014538669\nhelp.text", "note": "KohAT", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7580, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/111183524/?format=api", "priority": 100, "id": 112011684, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=be051da2eef4c50a", "url": "https://translations.documentfoundation.org/api/units/112011684/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:58.606373Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "SUMIFS function" ], "previous_source": "", "target": [ "Funktion SUMMEWENNS" ], "id_hash": -3540436716313482577, "content_hash": -3540436716313482577, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\ntit\nhelp.text", "note": "DfceH", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7581, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111183542/?format=api", "priority": 100, "id": 112011685, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=4eddd79086626aaf", "url": "https://translations.documentfoundation.org/api/units/112011685/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:58.609046Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<bookmark_value>SUMIFS function</bookmark_value> <bookmark_value>sum;satisfying conditions</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>SUMMEWENNS (Funktion)</bookmark_value><bookmark_value>Summe; hinreichende Bedingungen</bookmark_value>" ], "id_hash": -2704983415798147745, "content_hash": -2704983415798147745, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\nbm_id658066580665806\nhelp.text", "note": "jDeBL", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7582, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/111183560/?format=api", "priority": 100, "id": 112011686, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=5a75f7ea3a07555f", "url": "https://translations.documentfoundation.org/api/units/112011686/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:58.611949Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<variable id=\"sumifs_head\"><link href=\"text/scalc/01/func_sumifs.xhp\">SUMIFS</link></variable>" ], "previous_source": "", "target": [ "<variable id=\"sumifs_head\"><link href=\"text/scalc/01/func_sumifs.xhp\">SUMMEWENNS</link></variable>" ], "id_hash": -3689655749840634933, "content_hash": -3689655749840634933, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\nhd_id658866588665886\nhelp.text", "note": "MpUwQ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7583, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111183561/?format=api", "priority": 100, "id": 112011687, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=4ccbb5a4e7457bcb", "url": "https://translations.documentfoundation.org/api/units/112011687/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:58.614914Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<ahelp hid=\".\"><variable id=\"sumifs_des\">Returns the sum of the values of cells in a range that meets multiple criteria in multiple ranges.</variable></ahelp>" ], "previous_source": "", "target": [ "<ahelp hid=\".\"><variable id=\"sumifs_des\">Ergibt die Summe der Werte der Zellen in einem Bereich, die mehrere Bedingungen in mehreren Bereichen erfüllen.</variable></ahelp>" ], "id_hash": 9169675903449353869, "content_hash": 9169675903449353869, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\npar_id659756597565975\nhelp.text", "note": "ZEdvF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7584, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/111183599/?format=api", "priority": 100, "id": 112011688, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=ff413ba6b28ece8d", "url": "https://translations.documentfoundation.org/api/units/112011688/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:58.620934Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "SUMIFS(<embedvar href=\"text/scalc/01/ex_data_stat_func.xhp#args\" markup=\"ignore\"/>)" ], "previous_source": "", "target": [ "SUMMEWENNS(<embedvar href=\"text/scalc/01/ex_data_stat_func.xhp#args\" markup=\"ignore\"/>)" ], "id_hash": 8486374903425621466, "content_hash": 8486374903425621466, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\npar_id11655988824213\nhelp.text", "note": "xhKwv", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7585, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111183620/?format=api", "priority": 100, "id": 112011692, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=f5c5a9030d795dda", "url": "https://translations.documentfoundation.org/api/units/112011692/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:58.625059Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<emph>Func_Range</emph> – required argument. It is a range of cells, a name of a named range or a label of a column or a row containing values for calculating the sum." ], "previous_source": "", "target": [ "<emph>Funktionsbereich</emph> – erforderliches Argument. Ist ein Zellbereich, der Name eines benannten Bereichs oder eine Spalten-/Zeilenüberschrift, der/die Werte enthält, für die die Summe berechnet wird." ], "id_hash": -3181281400957303016, "content_hash": -3181281400957303016, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\npar_id59901690530236\nhelp.text", "note": "mP5Et", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7586, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 31, "source_unit": "https://translations.documentfoundation.org/api/units/111183656/?format=api", "priority": 100, "id": 112011693, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=53d9d16bc5620718", "url": "https://translations.documentfoundation.org/api/units/112011693/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:58.627750Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "Simple usage" ], "previous_source": "", "target": [ "Einfache Verwendung" ], "id_hash": 100979218881927587, "content_hash": 100979218881927587, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\nhd_id193452436229521\nhelp.text", "note": "zahGz", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7587, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111183688/?format=api", "priority": 100, "id": 112011694, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=8166c010872759a3", "url": "https://translations.documentfoundation.org/api/units/112011694/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:58.630410Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<item type=\"input\">=SUMIFS(B2:B6;B2:B6;\">=20\")</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=SUMMEWENNS(B2:B6;B2:B6;\">=20\")</item>" ], "id_hash": -3980841953204373942, "content_hash": -3980841953204373942, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\npar_id94321051525036\nhelp.text", "note": "tqgKL", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7588, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111183724/?format=api", "priority": 100, "id": 112011696, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=48c13555c047f64a", "url": "https://translations.documentfoundation.org/api/units/112011696/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:58.632653Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "Calculates the sum of values of the range B2:B6 that are greater than or equal to 20. Returns 75, because the fifth row does not meet the criterion." ], "previous_source": "", "target": [ "Berechnet die Summe der Werte im Bereich B2:B6, die größer oder gleich 20 sind. Ergibt 75, da die fünfte Zeile die Bedingung nicht erfüllt." ], "id_hash": -8584625317315816146, "content_hash": -8584625317315816146, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\npar_id28647227259438\nhelp.text", "note": "NK7QS", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7589, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 28, "source_unit": "https://translations.documentfoundation.org/api/units/111183777/?format=api", "priority": 100, "id": 112011698, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=08dd48c1d790d52e", "url": "https://translations.documentfoundation.org/api/units/112011698/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:58.635831Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<item type=\"input\">=SUMIFS(C2:C6;B2:B6;\">=20\";C2:C6;\">70\")</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=SUMMEWENNS(C2:C6;B2:B6;\">=20\";C2:C6;\">70\")</item>" ], "id_hash": -9075336950328213574, "content_hash": -9075336950328213574, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\npar_id36952767622741\nhelp.text", "note": "TzCFB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7590, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111183820/?format=api", "priority": 100, "id": 112011701, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=020ded207ab5bfba", "url": "https://translations.documentfoundation.org/api/units/112011701/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:58.638401Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "Calculates the sum of values of the range C2:C6 that are greater than 70 and correspond to cells of the B2:B6 range with values greater than or equal to 20. Returns 275, because the second and the fifth rows do not meet at least one criterion." ], "previous_source": "", "target": [ "Berechnet die Summe der Werte im Bereich C2:C6, die größer als 70 und deren entsprechende Zellwerte im Bereich B2:B6 größer oder gleich 20 sind. Ergibt 275, da die zweite und fünfte Zeile je mindestens eine Bedingung nicht erfüllen." ], "id_hash": 5531634363620764760, "content_hash": 5531634363620764760, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\npar_id189772445525114\nhelp.text", "note": "or3BG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7591, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 46, "source_unit": "https://translations.documentfoundation.org/api/units/111183870/?format=api", "priority": 100, "id": 112011703, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=ccc4502556f5ac58", "url": "https://translations.documentfoundation.org/api/units/112011703/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:58.642536Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "Using regular expressions and nested functions" ], "previous_source": "", "target": [ "Verwendung mit regulären Ausdrücken und verschachtelten Funktionen" ], "id_hash": -7905416432563865011, "content_hash": -7905416432563865011, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\nhd_id30455222431067\nhelp.text", "note": "YHh9T", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7592, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/111183913/?format=api", "priority": 100, "id": 112011704, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=124a51a3a77eba4d", "url": "https://translations.documentfoundation.org/api/units/112011704/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:58.646061Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<item type=\"input\">=SUMIFS(C2:C6;B2:B6;\">\"&MIN(B2:B6);B2:B6;\"<\"&MAX(B2:B6))</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=SUMMEWENNS(C2:C6;B2:B6;\">\"&MIN(B2:B6);B2:B6;\"<\"&MAX(B2:B6))</item>" ], "id_hash": -7100679125014514541, "content_hash": -7100679125014514541, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\npar_id307691022525348\nhelp.text", "note": "Ust3n", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7593, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111183957/?format=api", "priority": 100, "id": 112011708, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=1d7551f4f17a7493", "url": "https://translations.documentfoundation.org/api/units/112011708/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:58.654173Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "Calculates the sum of values of the range C2:C6 that correspond to all values of the range B2:B6 except its minimum and maximum. Returns 255, because the third and the fifth rows do not meet at least one criterion." ], "previous_source": "", "target": [ "Berechnet die Summe der Werte im Bereich C2:C6, die allen Werten im Bereich B2:B6, außer dem Minimum und dem Maximum, entsprechen. Ergibt 255, da die dritte und fünfte Zeile je mindestens eine Bedingung nicht erfüllen." ], "id_hash": -3296253579067716392, "content_hash": -3296253579067716392, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\npar_id27619246864839\nhelp.text", "note": "wCeGS", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7594, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 39, "source_unit": "https://translations.documentfoundation.org/api/units/111184004/?format=api", "priority": 100, "id": 112011709, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=52415ad58a0f0cd8", "url": "https://translations.documentfoundation.org/api/units/112011709/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:58.658681Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<item type=\"input\">=SUMIFS(C2:C6;A2:A6;\"pen.*\";B2:B6;\"<\"&MAX(B2:B6))</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=SUMMEWENNS(C2:C6;A2:A6;\".*stift\";B2:B6;\"<\"&MAX(B2:B6))</item>" ], "id_hash": 993849274358828000, "content_hash": 993849274358828000, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\npar_id220502883332563\nhelp.text", "note": "tETJF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7595, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111184009/?format=api", "priority": 100, "id": 112011712, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=8dcadca63e700be0", "url": "https://translations.documentfoundation.org/api/units/112011712/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:58.662516Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "Calculates the sum of values of the range C2:C6 that correspond to all cells of the A2:A6 range starting with \"pen\" and to all cells of the B2:B6 range except its maximum. Returns 65, because only second row meets all criteria." ], "previous_source": "", "target": [ "Berechnet die Summe der Werte im Bereich C2:C6, die allen Zellen im Bereich A2:A6, die auf \"stift\" enden, und allen Zellen im Bereich B2:B6, außer dem Maximum, entsprechen. Ergibt 65, da nur die zweite Zeile alle Bedingungen erfüllt." ], "id_hash": -3162333369531084074, "content_hash": -3162333369531084074, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\npar_id15342189586295\nhelp.text", "note": "u7CDd", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7596, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 41, "source_unit": "https://translations.documentfoundation.org/api/units/111184010/?format=api", "priority": 100, "id": 112011715, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=541d228e1fbc52d6", "url": "https://translations.documentfoundation.org/api/units/112011715/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:58.666383Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "Reference to a cell as a criterion" ], "previous_source": "", "target": [ "Bezüge zu einer Zelle mit einer Bedingung" ], "id_hash": 3615373838218159194, "content_hash": 3615373838218159194, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\nhd_id8168283329426\nhelp.text", "note": "dKeLC", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7597, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/111184011/?format=api", "priority": 100, "id": 112011717, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=b22c6359cd3be45a", "url": "https://translations.documentfoundation.org/api/units/112011717/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:58.668953Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "If you need to change a criterion easily, you may want to specify it in a separate cell and use a reference to this cell in the condition of the SUMIFS function. For example, the above function can be rewritten as follows:" ], "previous_source": "", "target": [ "Um eine Bedingung einfach zu ändern, bietet es sich an, diese in einer separaten Zelle festzulegen und für die Bedingung der Funktion SUMMEWENNS einen Bezug zur Zelle anzugeben. Beispielsweise kann obige Funktion geschrieben werden als:" ], "id_hash": 2034425885526726680, "content_hash": 2034425885526726680, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\npar_id50762995519951\nhelp.text", "note": "NzNhA", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7598, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 42, "source_unit": "https://translations.documentfoundation.org/api/units/111184012/?format=api", "priority": 100, "id": 112011719, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=9c3bbb9064ae1818", "url": "https://translations.documentfoundation.org/api/units/112011719/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:58.671615Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<item type=\"input\">=SUMIFS(C2:C6;A2:A6;E2&\".*\";B2:B6;\"<\"&MAX(B2:B6))</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=SUMMEWENNS(C2:C6;A2:A6;\".*\"&E2;B2:B6;\"<\"&MAX(B2:B6))</item>" ], "id_hash": 3624176247368206676, "content_hash": 3624176247368206676, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\npar_id135761606425300\nhelp.text", "note": "U2wwM", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7599, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111184013/?format=api", "priority": 100, "id": 112011722, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=b24ba91863ca4954", "url": "https://translations.documentfoundation.org/api/units/112011722/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:58.674898Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "If E2 = pen, the function returns 65, because the link to the cell is substituted with its content." ], "previous_source": "", "target": [ "Wenn E2 = stift ist, ergibt die Funktion 65, da der Bezug zur Zelle derem Inhalt entspricht." ], "id_hash": 814313685569042024, "content_hash": 814313685569042024, "location": "func_sumifs.xhp", "context": "func_sumifs.xhp\npar_id30574750215839\nhelp.text", "note": "wGhZA", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 7600, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/111184014/?format=api", "priority": 100, "id": 112011726, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=8b4d05fb8c14f668", "url": "https://translations.documentfoundation.org/api/units/112011726/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:58.680652Z" } ] }{ "count": 8439, "next": "