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=131
https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/units/?format=api&page=132", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/units/?format=api&page=130", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<item type=\"input\">=AVERAGEIFS(C2:C6;A2:A6;\"pen.*\";B2:B6;\"<\"&MAX(B2:B6))</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=MITTELWERTWENNS(C2:C6;A2:A6;\".*stift\";B2:B6;\"<\"&MAX(B2:B6))</item>" ], "id_hash": -39274590102270107, "content_hash": -39274590102270107, "location": "func_averageifs.xhp", "context": "func_averageifs.xhp\npar_id303162761931870\nhelp.text", "note": "C7fCW", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6501, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111143400/?format=api", "priority": 100, "id": 112008436, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=7f7477f7e8414f65", "url": "https://translations.documentfoundation.org/api/units/112008436/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.328825Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "Calculates the average for 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 den Mittelwert 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": 2035057651168597951, "content_hash": 2035057651168597951, "location": "func_averageifs.xhp", "context": "func_averageifs.xhp\npar_id40031348913642\nhelp.text", "note": "eo7jB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6502, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 41, "source_unit": "https://translations.documentfoundation.org/api/units/111143462/?format=api", "priority": 100, "id": 112008438, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=9c3dfa26cb5857bf", "url": "https://translations.documentfoundation.org/api/units/112008438/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.330745Z" }, { "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": -3065874459700111046, "content_hash": -3065874459700111046, "location": "func_averageifs.xhp", "context": "func_averageifs.xhp\nhd_id31201205191857\nhelp.text", "note": "qyrrP", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6503, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/111143516/?format=api", "priority": 100, "id": 112008440, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=5573d36c2fa1d93a", "url": "https://translations.documentfoundation.org/api/units/112008440/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.332864Z" }, { "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 AVERAGEIFS 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 MITTELWERTWENNS einen Bezug zur Zelle anzugeben. Beispielsweise kann obige Funktion geschrieben werden als:" ], "id_hash": -6864261810427536110, "content_hash": -6864261810427536110, "location": "func_averageifs.xhp", "context": "func_averageifs.xhp\npar_id316794795433\nhelp.text", "note": "DqjCH", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6504, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 41, "source_unit": "https://translations.documentfoundation.org/api/units/111143554/?format=api", "priority": 100, "id": 112008442, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=20bd3e40782fdd12", "url": "https://translations.documentfoundation.org/api/units/112008442/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.334432Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<item type=\"input\">=AVERAGEIFS(C2:C6;A2:A6;E2&\".*\";B2:B6;\"<\"&MAX(B2:B6))</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=MITTELWERTWENNS(C2:C6;A2:A6;\".*\"&E2;B2:B6;\"<\"&MAX(B2:B6))</item>" ], "id_hash": 7459219915114670295, "content_hash": 7459219915114670295, "location": "func_averageifs.xhp", "context": "func_averageifs.xhp\npar_id67531072426731\nhelp.text", "note": "B8bav", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6505, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111143594/?format=api", "priority": 100, "id": 112008444, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=e78478fdfdede8d7", "url": "https://translations.documentfoundation.org/api/units/112008444/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.336179Z" }, { "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": -7828342925869082649, "content_hash": -7828342925869082649, "location": "func_averageifs.xhp", "context": "func_averageifs.xhp\npar_id65612244926745\nhelp.text", "note": "E3TZv", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6506, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/111143639/?format=api", "priority": 100, "id": 112008446, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=135c2395d3a197e7", "url": "https://translations.documentfoundation.org/api/units/112008446/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.338010Z" }, { "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/AVERAGEIFS\">AVERAGEIFS wiki page</link>." ], "previous_source": "", "target": [ "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/AVERAGEIFS\">Wikiseite zu MITTELWERTWENNS</link>." ], "id_hash": -5108354685326168271, "content_hash": -5108354685326168271, "location": "func_averageifs.xhp", "context": "func_averageifs.xhp\npar_id371677017196557\nhelp.text", "note": "doVAz", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6507, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/111143683/?format=api", "priority": 100, "id": 112008449, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=391b7a7a9a6e6f31", "url": "https://translations.documentfoundation.org/api/units/112008449/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.339827Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "Ceiling functions" ], "previous_source": "", "target": [ "Funktionen für Obergrenze" ], "id_hash": 1609410509577279881, "content_hash": 1609410509577279881, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\ntit\nhelp.text", "note": "s6GFW", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6508, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111143739/?format=api", "priority": 100, "id": 112008451, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=9655c654d9225989", "url": "https://translations.documentfoundation.org/api/units/112008451/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.341804Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "Ceiling functions" ], "previous_source": "", "target": [ "Funktionen für Obergrenze" ], "id_hash": 7068345918758754198, "content_hash": 7068345918758754198, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\nhd_id971586216771519\nhelp.text", "note": "EWCte", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6509, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111143776/?format=api", "priority": 100, "id": 112008453, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=e217cf29d5329796", "url": "https://translations.documentfoundation.org/api/units/112008453/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.343389Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<bookmark_value>CEILING function</bookmark_value><bookmark_value>rounding;up to multiples of significance</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>OBERGRENZE (Funktion)</bookmark_value><bookmark_value>Runden; auf ein Vielfaches der Schrittweite aufrunden</bookmark_value>" ], "id_hash": -6153250019685046283, "content_hash": -6153250019685046283, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\nbm_id3152518\nhelp.text", "note": "M92qb", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6510, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/111143817/?format=api", "priority": 100, "id": 112008454, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=2a9b43b55a81e7f5", "url": "https://translations.documentfoundation.org/api/units/112008454/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.344712Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<variable id=\"CEILINGh1\"><link href=\"text/scalc/01/func_ceiling.xhp#ceiling\">CEILING</link></variable>" ], "previous_source": "", "target": [ "<variable id=\"CEILINGh1\"><link href=\"text/scalc/01/func_ceiling.xhp#ceiling\">OBERGRENZE</link></variable>" ], "id_hash": -6451221408954010906, "content_hash": -6451221408954010906, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\nhd_id3152518\nhelp.text", "note": "cGa5K", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6511, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111143858/?format=api", "priority": 100, "id": 112008456, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=2678a84effe6b2e6", "url": "https://translations.documentfoundation.org/api/units/112008456/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.346531Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_OBERGRENZE\">Rounds a number to the nearest multiple of a significance value.</ahelp>" ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_OBERGRENZE\">Rundet eine Zahl auf das nächste Vielfache der Schrittweite auf.</ahelp>" ], "id_hash": 5612796639614937308, "content_hash": 5612796639614937308, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\npar_id3153422\nhelp.text", "note": "Co8xT", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6512, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/111143895/?format=api", "priority": 100, "id": 112008459, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=cde4a8ce4cc128dc", "url": "https://translations.documentfoundation.org/api/units/112008459/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.348561Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "For a positive number and a positive significance value, the function rounds up (away from zero). For a negative number and a negative significance value, the direction of rounding is determined by the value of a mode parameter. The function returns an error if the number and significance values have opposite signs." ], "previous_source": "", "target": [ "Für eine positive Zahl und eine positive Schrittweite rundet die Funktion auf (von Null weg). Für eine negative Zahl und eine negative Schrittweite wird die Rundungsrichtung durch den Wert eines Parameters Modus bestimmt. Die Funktion gibt einen Fehler zurück, wenn die Zahlenwerte und die Werte für Schrittweite entgegengesetzte Vorzeichen haben." ], "id_hash": 3796565438325603616, "content_hash": 3796565438325603616, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\npar_id601586207136514\nhelp.text", "note": "PfT3s", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6513, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 52, "source_unit": "https://translations.documentfoundation.org/api/units/111143934/?format=api", "priority": 100, "id": 112008461, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=b4b01c26adec3d20", "url": "https://translations.documentfoundation.org/api/units/112008461/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.350627Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "If the spreadsheet is exported to Microsoft Excel, the CEILING function is exported as the equivalent CEILING.MATH function that has existed since Excel 2013. If you plan to use the spreadsheet with earlier Excel versions, use either CEILING.PRECISE that has existed since Excel 2010, or CEILING.XCL that is exported as the CEILING function compatible with all Excel versions." ], "previous_source": "", "target": [ "Wenn die Tabelle nach MS Excel exportiert wird, wird die Funktion OBERGRENZE als ihre äquivalente Funktion OBERGRENZE.MATHEMATIK exportiert, die seit Excel 2013 existiert. Wenn Sie die Verwendung der Tabelle mit einer älteren Excel-Version planen, verwenden Sie entweder OBERGRENZE.GENAU, die seit Excel 2010 existiert, oder OBERGRENZE.EXCEL, die OBERGRENZE als eine mit allen Excel-Versionen kompatible Funktion exportiert." ], "id_hash": -170100627546954741, "content_hash": -170100627546954741, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\npar_id3163792\nhelp.text", "note": "6AFh7", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6514, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 58, "source_unit": "https://translations.documentfoundation.org/api/units/111143962/?format=api", "priority": 100, "id": 112008464, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=7da3ae6166fe240b", "url": "https://translations.documentfoundation.org/api/units/112008464/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.352546Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "CEILING(Number [; Significance [; Mode]])" ], "previous_source": "", "target": [ "OBERGRENZE(Zahl [; Schrittweite [; Modus]])" ], "id_hash": 1397966469888016998, "content_hash": 1397966469888016998, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\npar_id3153454\nhelp.text", "note": "3DwLL", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6515, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/111144058/?format=api", "priority": 100, "id": 112008466, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=93669318fd950266", "url": "https://translations.documentfoundation.org/api/units/112008466/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.354706Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<emph>Number</emph> is the number that is to be rounded, or a reference to a cell containing the number." ], "previous_source": "", "target": [ "<emph>Zahl</emph> ist die Zahl, die aufgerundet werden soll, oder ein Bezug zu einer Zelle, welche die Zahl enthält." ], "id_hash": -998394724241651719, "content_hash": -998394724241651719, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\npar_id3153467\nhelp.text", "note": "XHjhc", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6516, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/111144114/?format=api", "priority": 100, "id": 112008468, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=7224fd49bbf3c7f9", "url": "https://translations.documentfoundation.org/api/units/112008468/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.356766Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<emph>Significance</emph> (optional) is the value, or a reference to a cell containing the value, to whose multiple <emph>Number</emph> is to be rounded. It defaults to +1 or -1 depending on the sign of <emph>Number</emph>." ], "previous_source": "", "target": [ "<emph>Schrittweite</emph> (optional) ist der Wert oder ein Bezug zu einer Zelle, welche den Wert enthält, auf deren Vielfaches von <emph>Zahl</emph> gerundet werden soll. Der Standardwert beträgt je nach Vorzeichen von <emph>Zahl</emph> +1 oder -1." ], "id_hash": 2622333316091886762, "content_hash": 2622333316091886762, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\npar_id3155000\nhelp.text", "note": "XEqxw", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6517, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 34, "source_unit": "https://translations.documentfoundation.org/api/units/111144160/?format=api", "priority": 100, "id": 112008471, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=a4646641dc543caa", "url": "https://translations.documentfoundation.org/api/units/112008471/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.359021Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<emph>Mode</emph> (optional) is a number, or a reference to a cell containing a number. The function only uses <emph>Mode</emph> if both <emph>Number</emph> and <emph>Significance</emph> are negative. Then if <emph>Mode</emph> is given and not equal to zero, numbers are rounded down (away from zero); if <emph>Mode</emph> is equal to zero or not given, negative numbers are rounded up (towards zero)." ], "previous_source": "", "target": [ "<emph>Modus</emph> (optional) ist ein eine Zahl oder ein Bezug zu einer Zelle, welche eine Zahl enthält. Die Funktion verwendet <emph>Modus</emph> nur, wenn sowohl <emph>Zahl</emph> als auch <emph>Schrittweite</emph> negativ sind. Wenn dann <emph>Modus</emph> angegeben und ungleich Null ist, werden die Zahlen abgerundet (von Null weg). Wenn <emph>Modus</emph> gleich Null ist oder nicht angegeben wird, werden negative Zahlen aufgerundet (zu Null hin)." ], "id_hash": -1673702869440489036, "content_hash": -1673702869440489036, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\npar_id3155020\nhelp.text", "note": "AosjB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6518, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 59, "source_unit": "https://translations.documentfoundation.org/api/units/111144227/?format=api", "priority": 100, "id": 112008473, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=68c5d01b9f7299b4", "url": "https://translations.documentfoundation.org/api/units/112008473/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.361404Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<input>=CEILING(3.45)</input> returns 4." ], "previous_source": "", "target": [ "<input>=OBERGRENZE(3,45)</input> ergibt 4." ], "id_hash": 9212378349686821225, "content_hash": 9212378349686821225, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\npar_id281586208138400\nhelp.text", "note": "Ka9pC", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6519, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111144284/?format=api", "priority": 100, "id": 112008475, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=ffd8f14cbd951169", "url": "https://translations.documentfoundation.org/api/units/112008475/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.363638Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<input>=CEILING(3.45; 3)</input> returns 6." ], "previous_source": "", "target": [ "<input>=OBERGRENZE(3,45; 3)</input> ergibt 6." ], "id_hash": -8155502805938692339, "content_hash": -8155502805938692339, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\npar_id921586208142416\nhelp.text", "note": "UTtFZ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6520, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/111144353/?format=api", "priority": 100, "id": 112008476, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=0ed1d5685f529f0d", "url": "https://translations.documentfoundation.org/api/units/112008476/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.365084Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<input>=CEILING(-1.234)</input> returns -1." ], "previous_source": "", "target": [ "<input>=OBERGRENZE(-1,234)</input> ergibt -1." ], "id_hash": -2324458641947819717, "content_hash": -2324458641947819717, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\npar_id921586208146984\nhelp.text", "note": "XGfA3", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6521, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111144413/?format=api", "priority": 100, "id": 112008478, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=5fbddd2e3f9d013b", "url": "https://translations.documentfoundation.org/api/units/112008478/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.366670Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<input>=CEILING(-45.67; -2; 0)</input> returns -44." ], "previous_source": "", "target": [ "<input>=OBERGRENZE(-45,67; -2; 0)</input> ergibt -44." ], "id_hash": -271396810875599421, "content_hash": -271396810875599421, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\npar_id491586208152183\nhelp.text", "note": "ZWjxy", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6522, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/111144462/?format=api", "priority": 100, "id": 112008480, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=7c3bce09d69605c3", "url": "https://translations.documentfoundation.org/api/units/112008480/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.368363Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<input>=CEILING(-45.67; -2; 1)</input> returns -46." ], "previous_source": "", "target": [ "<input>=OBERGRENZE(-45,67; -2; 1)</input> ergibt -46." ], "id_hash": -2051302800151829384, "content_hash": -2051302800151829384, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\npar_id291586208158119\nhelp.text", "note": "Auwyx", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6523, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/111144524/?format=api", "priority": 100, "id": 112008482, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=63884ef8b62fa478", "url": "https://translations.documentfoundation.org/api/units/112008482/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.370832Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<bookmark_value>CEILING.PRECISE function</bookmark_value><bookmark_value>rounding;up to multiples of significance</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>OBERGRENZE.GENAU (Funktion)</bookmark_value><bookmark_value>Runden; auf ein Vielfaches der Schrittweite aufrunden</bookmark_value>" ], "id_hash": 1789962222004316248, "content_hash": 1789962222004316248, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\nbm_id2952518\nhelp.text", "note": "rZ78k", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6524, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/111144564/?format=api", "priority": 100, "id": 112008489, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=98d7392843efa858", "url": "https://translations.documentfoundation.org/api/units/112008489/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.381385Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<variable id=\"CEILING.PRECISEh1\"><link href=\"text/scalc/01/func_ceiling.xhp#ceilingprecise\">CEILING.PRECISE</link></variable>" ], "previous_source": "", "target": [ "<variable id=\"CEILING.PRECISEh1\"><link href=\"text/scalc/01/func_ceiling.xhp#ceilingprecise\">OBERGRENZE.GENAU</link></variable>" ], "id_hash": 2531219869909523550, "content_hash": 2531219869909523550, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\nhd_id2952518\nhelp.text", "note": "JGH6b", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6525, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111144636/?format=api", "priority": 100, "id": 112008491, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=a320b30f8a5e1c5e", "url": "https://translations.documentfoundation.org/api/units/112008491/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.391740Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_CEIL_MS\">Rounds a number up to the nearest multiple of a significance value.</ahelp>" ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_CEIL_MS\">Rundet eine Zahl auf das nächste Vielfache des Wertes einer Schrittweite auf.</ahelp>" ], "id_hash": -4996043538607062527, "content_hash": -4996043538607062527, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\npar_id2953422\nhelp.text", "note": "aTD6P", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6526, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/111144678/?format=api", "priority": 100, "id": 112008493, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=3aaa7cdf2ef0c201", "url": "https://translations.documentfoundation.org/api/units/112008493/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.395921Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "For a positive number the function rounds up (away from zero). For a negative number, the function rounds up (towards zero). The sign of the significance value is ignored." ], "previous_source": "", "target": [ "Für eine positive Zahl rundet die Funktion auf (von Null weg). Bei einer negativen Zahl rundet die Funktion ebenfalls auf (gegen Null). Das Vorzeichen von Schrittweite wird ignoriert." ], "id_hash": 6496901381443936444, "content_hash": 6496901381443936444, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\npar_id151586642494759\nhelp.text", "note": "BjuBa", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6527, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/111144756/?format=api", "priority": 100, "id": 112008497, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=da29a16265b5e0bc", "url": "https://translations.documentfoundation.org/api/units/112008497/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.403654Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "This function calculates identical results to the <link href=\"text/scalc/01/func_ceiling.xhp#isoceiling\">ISO.CEILING</link> function." ], "previous_source": "", "target": [ "Diese Funktion berechnet identische Ergebnisse wie die Funktion <link href=\"text/scalc/01/func_ceiling.xhp#isoceiling\">ISO.OBERGRENZE</link>." ], "id_hash": -4165585259038146892, "content_hash": -4165585259038146892, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\npar_id631586642933797\nhelp.text", "note": "zDBKp", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6528, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/111144800/?format=api", "priority": 100, "id": 112008500, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=4630de46f16d7eb4", "url": "https://translations.documentfoundation.org/api/units/112008500/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.410062Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "CEILING.PRECISE(Number [; Significance])" ], "previous_source": "", "target": [ "OBERGRENZE.GENAU(Zahl [; Schrittweite])" ], "id_hash": -5741669346813274781, "content_hash": -5741669346813274781, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\npar_id2953454\nhelp.text", "note": "BASfr", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6529, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111144856/?format=api", "priority": 100, "id": 112008502, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=30517e2655721563", "url": "https://translations.documentfoundation.org/api/units/112008502/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.413245Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<emph>Significance</emph> (optional) is the value, or a reference to a cell containing the value, to whose multiple <emph>Number</emph> is to be rounded. It defaults to 1." ], "previous_source": "", "target": [ "<emph>Schrittweite</emph> (optional) ist der Wert oder ein Bezug zu einer Zelle, welche den Wert enthält, auf deren Vielfaches <emph>Zahl</emph> gerundet werden soll. Der Standardwert ist 1." ], "id_hash": 3203619836300210175, "content_hash": 3203619836300210175, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\npar_id2955000\nhelp.text", "note": "FaYeD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6530, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/111144902/?format=api", "priority": 100, "id": 112008503, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=ac758b448211afff", "url": "https://translations.documentfoundation.org/api/units/112008503/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.415656Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<input>=CEILING.PRECISE(3.45)</input> returns 4." ], "previous_source": "", "target": [ "<input>=OBERGRENZE.GENAU(3,45)</input> ergibt 4." ], "id_hash": 6180524466943204036, "content_hash": 6180524466943204036, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\npar_id201586213398634\nhelp.text", "note": "8WiRx", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6531, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111144965/?format=api", "priority": 100, "id": 112008506, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=d5c5a241c1c29ac4", "url": "https://translations.documentfoundation.org/api/units/112008506/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.420128Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<input>=CEILING.PRECISE(-45.67; 2)</input> returns -44." ], "previous_source": "", "target": [ "<input>=OBERGRENZE.GENAU(-45,67; 2)</input> ergibt -44." ], "id_hash": -1020456526438809540, "content_hash": -1020456526438809540, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\npar_id651586213406243\nhelp.text", "note": "KxeUC", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6532, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/111144999/?format=api", "priority": 100, "id": 112008509, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=71d69c3220e2c03c", "url": "https://translations.documentfoundation.org/api/units/112008509/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.422834Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<bookmark_value>CEILING.MATH function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>OBERGRENZE.MATHEMATIK (Funktion)</bookmark_value>" ], "id_hash": 8192352471206827237, "content_hash": 8192352471206827237, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\nbm_id911516997198644\nhelp.text", "note": "WV9bx", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6533, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111145047/?format=api", "priority": 100, "id": 112008511, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=f1b1152ae91394e5", "url": "https://translations.documentfoundation.org/api/units/112008511/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.424967Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<variable id=\"CEILING.MATHh1\"><link href=\"text/scalc/01/func_ceiling.xhp#ceilingmath\">CEILING.MATH</link></variable>" ], "previous_source": "", "target": [ "<variable id=\"CEILING.MATHh1\"><link href=\"text/scalc/01/func_ceiling.xhp#ceilingmath\">OBERGRENZE.MATHEMATIK</link></variable>" ], "id_hash": -3577212344597263070, "content_hash": -3577212344597263070, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\nhd_id91516997330445\nhelp.text", "note": "AuCnM", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6534, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111145075/?format=api", "priority": 100, "id": 112008512, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=4e5b305352234d22", "url": "https://translations.documentfoundation.org/api/units/112008512/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.426639Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_CEIL_MATH\">Rounds a number to the nearest multiple of a significance value.</ahelp>" ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_CEIL_MATH\">Rundet eine Zahl auf das nächste Vielfache eines Wertes der Schrittweite.</ahelp>" ], "id_hash": -1890171042092206192, "content_hash": -1890171042092206192, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\npar_id81516997342088\nhelp.text", "note": "AzJvD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6535, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/111145117/?format=api", "priority": 100, "id": 112008514, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=65c4c373a75d3790", "url": "https://translations.documentfoundation.org/api/units/112008514/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.428164Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "For a positive number the function rounds up (away from zero). For a negative number, the direction of rounding is determined by the value of a mode parameter. The sign of the significance value is ignored." ], "previous_source": "", "target": [ "Für eine positive Zahl rundet die Funktion auf (von Null weg). Für eine negative Zahl wird die Richtung der Rundung durch den Wert des Parameters Modus bestimmt. Das Vorzeichen des Wertes für Schrittweite wird ignoriert." ], "id_hash": 6222299648396735976, "content_hash": 6222299648396735976, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\npar_id911586642319078\nhelp.text", "note": "QLGe7", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6536, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 36, "source_unit": "https://translations.documentfoundation.org/api/units/111145137/?format=api", "priority": 100, "id": 112008516, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=d65a0c9024b9b5e8", "url": "https://translations.documentfoundation.org/api/units/112008516/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.429783Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "This function exists for interoperability with Microsoft Excel 2013 or newer." ], "previous_source": "", "target": [ "Diese Funktion ist für die Interoperabilität mit Microsoft Excel 2013 oder neuer verfügbar." ], "id_hash": -5444425522060555387, "content_hash": -5444425522060555387, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\npar_id291516998575663\nhelp.text", "note": "aYczG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6537, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/111145139/?format=api", "priority": 100, "id": 112008517, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=347183d55f828b85", "url": "https://translations.documentfoundation.org/api/units/112008517/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.431316Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "CEILING.MATH(Number [; Significance [; Mode]])" ], "previous_source": "", "target": [ "OBERGRENZE.MATHEMATIK(Zahl [; Schrittweite [; Modus]])" ], "id_hash": 2164538349252456848, "content_hash": 2164538349252456848, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\npar_id841516997669932\nhelp.text", "note": "pcXnS", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6538, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/111145140/?format=api", "priority": 100, "id": 112008519, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=9e09fc2911e73190", "url": "https://translations.documentfoundation.org/api/units/112008519/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.432702Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<emph>Significance</emph> (optional) is the value, or a reference to a cell containing the value, to whose multiple <emph>Number</emph> is to be rounded. It defaults to 1." ], "previous_source": "", "target": [ "<emph>Schrittweite</emph> (optional) ist der Wert oder ein Bezug zu einer Zelle, welche den Wert enthält, auf deren Vielfaches <emph>Zahl</emph> gerundet werden soll. Der Standardwert ist 1." ], "id_hash": -7670770237816061719, "content_hash": -7670770237816061719, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\npar_id491516997725772\nhelp.text", "note": "EAezJ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6539, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/111145141/?format=api", "priority": 100, "id": 112008520, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=158bf31c3555c0e9", "url": "https://translations.documentfoundation.org/api/units/112008520/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.433982Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<emph>Mode</emph> (optional) is a number, or a reference to a cell containing a number. If <emph>Mode</emph> is given and not equal to zero, a negative <emph>Number</emph> is rounded down (away from zero). If <emph>Mode</emph> is equal to zero or is not given, a negative <emph>Number</emph> is rounded up (towards zero)." ], "previous_source": "", "target": [ "<emph>Modus</emph> (optional) ist eine Zahl oder ein Bezug zu einer Zelle, welche eine Zahl enthält. Wenn <emph>Modus</emph> angegeben und ungleich Null ist, wird eine negative <emph>Zahl</emph> von Null abgerundet (weg von Null). Wenn <emph>Modus</emph> gleich Null oder nicht angegeben ist, wird eine negative <emph>Zahl</emph> aufgerundet (hin zu Null)." ], "id_hash": -6431286464945494539, "content_hash": -6431286464945494539, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\npar_id451516997742909\nhelp.text", "note": "EiWLa", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6540, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 50, "source_unit": "https://translations.documentfoundation.org/api/units/111145142/?format=api", "priority": 100, "id": 112008522, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=26bf7b08d82565f5", "url": "https://translations.documentfoundation.org/api/units/112008522/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.435397Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<input>=CEILING.MATH(3.45)</input> returns 4." ], "previous_source": "", "target": [ "<input>=OBERGRENZE.MATHEMATIK(3,45)</input> ergibt 4." ], "id_hash": 7993634044917983332, "content_hash": 7993634044917983332, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\npar_id331586208590009\nhelp.text", "note": "je22s", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6541, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111145143/?format=api", "priority": 100, "id": 112008524, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=eeef17cfcfce2864", "url": "https://translations.documentfoundation.org/api/units/112008524/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.437503Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<input>=CEILING.MATH(3.45; -3)</input> returns 6." ], "previous_source": "", "target": [ "<input>=OBERGRENZE.MATHEMATIK(3,45; -3)</input> ergibt 6." ], "id_hash": 4454307408764486246, "content_hash": 4454307408764486246, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\npar_id481586208595809\nhelp.text", "note": "g5xAQ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6542, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/111145178/?format=api", "priority": 100, "id": 112008525, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=bdd0e0fd03cc4266", "url": "https://translations.documentfoundation.org/api/units/112008525/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.439053Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<input>=CEILING.MATH(-1.234)</input> returns -1." ], "previous_source": "", "target": [ "<input>=OBERGRENZE.MATHEMATIK(-1,234)</input> ergibt -1." ], "id_hash": 5299770118878736921, "content_hash": 5299770118878736921, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\npar_id641586208600665\nhelp.text", "note": "Eby7i", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6543, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111145220/?format=api", "priority": 100, "id": 112008527, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=c98c90d7feff3219", "url": "https://translations.documentfoundation.org/api/units/112008527/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.440353Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<input>=CEILING.MATH(-45.67; -2; 0)</input> returns -44." ], "previous_source": "", "target": [ "<input>=OBERGRENZE.MATHEMATIK(-45,67; -2; 0)</input> ergibt -44." ], "id_hash": 8994250025228569521, "content_hash": 8994250025228569521, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\npar_id151586208604536\nhelp.text", "note": "T4orc", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6544, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/111145252/?format=api", "priority": 100, "id": 112008528, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=fcd1febe8ecc0bb1", "url": "https://translations.documentfoundation.org/api/units/112008528/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.441876Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<input>=CEILING.MATH(-45.67; +2; 1)</input> returns -46." ], "previous_source": "", "target": [ "<input>=OBERGRENZE.MATHEMATIK(-45,67; +2; 1)</input> ergibt -46." ], "id_hash": -4670121198902881817, "content_hash": -4670121198902881817, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\npar_id971586208611345\nhelp.text", "note": "opt6B", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6545, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/111145296/?format=api", "priority": 100, "id": 112008530, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=3f306583515f51e7", "url": "https://translations.documentfoundation.org/api/units/112008530/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.443606Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<bookmark_value>CEILING.XCL function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>OBERGRENZE.EXCEL (Funktion)</bookmark_value>" ], "id_hash": 5600177986354516026, "content_hash": 5600177986354516026, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\nbm_id921516998608939\nhelp.text", "note": "EzE9t", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6546, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111145343/?format=api", "priority": 100, "id": 112008532, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=cdb7d435239f903a", "url": "https://translations.documentfoundation.org/api/units/112008532/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.445134Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<variable id=\"CEILING.XCLh1\"><link href=\"text/scalc/01/func_ceiling.xhp#ceilingxcl\">CEILING.XCL</link></variable>" ], "previous_source": "", "target": [ "<variable id=\"CEILING.XCLh1\"><link href=\"text/scalc/01/func_ceiling.xhp#ceilingxcl\">OBERGRENZE.EXCEL</link></variable>" ], "id_hash": 2148496699539188946, "content_hash": 2148496699539188946, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\nhd_id411516998838823\nhelp.text", "note": "xEwWL", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6547, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111145356/?format=api", "priority": 100, "id": 112008534, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=9dd0fe5d7121ecd2", "url": "https://translations.documentfoundation.org/api/units/112008534/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.447093Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_CEIL_MS\">Rounds a number to the nearest multiple of a significance value.</ahelp>" ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_CEIL_MS\">Rundet eine Zahl auf das nächste Vielfache einer Schrittweite.</ahelp>" ], "id_hash": -216340762606324190, "content_hash": -216340762606324190, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\npar_id811516998845826\nhelp.text", "note": "2tuD3", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6548, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/111145410/?format=api", "priority": 100, "id": 112008537, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=7cff6738fe69b622", "url": "https://translations.documentfoundation.org/api/units/112008537/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.450202Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "For a positive number and a positive significance value, the function rounds up (away from zero). For a negative number and a positive significance value, the function rounds up (towards zero). For a negative number and a negative significance value, the function rounds down (away from zero). The function returns an error if the number is positive and the significance value is negative." ], "previous_source": "", "target": [ "Bei einer positiven Zahl und einer positiven Schrittweite rundet die Funktion auf (von Null weg). Bei einer negativen Zahl und einer positiven Schrittweite rundet die Funktion auf (zu Null hin). Bei einer negativen Zahl und einer negativen Schrittweite rundet die Funktion nach unten (von Null weg). Bei einer positiven Zahl und einer negativen Schrittweite gibt die Funktion einen Fehler zurück." ], "id_hash": -2720536968782463001, "content_hash": -2720536968782463001, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\npar_id361586213828675\nhelp.text", "note": "tAyJj", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6549, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 63, "source_unit": "https://translations.documentfoundation.org/api/units/111145450/?format=api", "priority": 100, "id": 112008540, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=5a3eb60a79673fe7", "url": "https://translations.documentfoundation.org/api/units/112008540/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.452865Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "This function exists for interoperability with Microsoft Excel 2007 or older. If a Calc spreadsheet is exported to Microsoft Excel, references to Calc’s CEILING.XCL function are exported as references to Excel’s CEILING function, which is compatible with all Excel versions. If a Microsoft Excel spreadsheet is imported into Calc, references to Excel’s CEILING function are imported as references to Calc’s CEILING.XCL function." ], "previous_source": "", "target": [ "Diese Funktion existiert für die Interoperabilität mit Microsoft Excel 2007 oder älter. Wenn eine Calc-Tabelle nach Microsoft Excel exportiert wird, werden Verweise auf die Funktion OBERGRENZE.EXCEL von Calc als Verweise auf die Funktion OBERGRENZE von Excel exportiert, die mit allen Excel-Versionen kompatibel ist. Wenn eine Microsoft Excel-Tabelle in Calc importiert wird, werden Verweise auf die Funktion OBERGRENZE von Excel als Verweise auf die FUNKTION OBERGRENZE.EXCEL von Calc importiert." ], "id_hash": -5372211519528605161, "content_hash": -5372211519528605161, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\npar_id881586213934118\nhelp.text", "note": "2CKjm", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6550, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 62, "source_unit": "https://translations.documentfoundation.org/api/units/111145511/?format=api", "priority": 100, "id": 112008542, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=35721216103c6a17", "url": "https://translations.documentfoundation.org/api/units/112008542/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.454998Z" } ] }{ "count": 8439, "next": "