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=129
https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/units/?format=api&page=130", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/units/?format=api&page=128", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "Ignore only errors, nested SUBTOTAL and AGGREGATE functions" ], "previous_source": "", "target": [ "Nur Fehlerwerte sowie verschachtelte Funktionen TEILERGEBNIS und AGGREGAT ignorieren" ], "id_hash": 7069325496975214359, "content_hash": 7069325496975214359, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201512011514\nhelp.text", "note": "EAKJn", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6401, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/111138336/?format=api", "priority": 100, "id": 112008082, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=e21b4a15a8d1c717", "url": "https://translations.documentfoundation.org/api/units/112008082/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.019442Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "Ignore hidden rows, errors, nested SUBTOTAL and AGGREGATE functions" ], "previous_source": "", "target": [ "Ausgeblendete Zeilen, Fehlerwerte sowie verschachtelte Funktionen TEILERGEBNIS und AGGREGAT ignorieren" ], "id_hash": 1285618312874630734, "content_hash": 1285618312874630734, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201512011547\nhelp.text", "note": "ofBiE", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6402, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/111138357/?format=api", "priority": 100, "id": 112008084, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=91d76f0b47a11e4e", "url": "https://translations.documentfoundation.org/api/units/112008084/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.022188Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "Ignore nothing" ], "previous_source": "", "target": [ "Nichts ignorieren" ], "id_hash": -1795886336106039185, "content_hash": -1795886336106039185, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201512011510\nhelp.text", "note": "oTDkv", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6403, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111138404/?format=api", "priority": 100, "id": 112008086, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=6713bae46f6bf86f", "url": "https://translations.documentfoundation.org/api/units/112008086/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.024767Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "Ignore only hidden rows" ], "previous_source": "", "target": [ "Nur ausgeblendete Zeilen ignorieren" ], "id_hash": -8760652021237738981, "content_hash": -8760652021237738981, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201512011592\nhelp.text", "note": "5SwRv", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6404, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/111138421/?format=api", "priority": 100, "id": 112008088, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=066be9671151121b", "url": "https://translations.documentfoundation.org/api/units/112008088/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.028440Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "Ignore only errors" ], "previous_source": "", "target": [ "Nur Fehlerwerte ignorieren" ], "id_hash": -3404317888262980966, "content_hash": -3404317888262980966, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id230920151201150\nhelp.text", "note": "eDQoE", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6405, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111138503/?format=api", "priority": 100, "id": 112008089, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=50c16eeadf93ba9a", "url": "https://translations.documentfoundation.org/api/units/112008089/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.030229Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "Ignore only hidden rows and errors" ], "previous_source": "", "target": [ "Nur ausgeblendete Zeilen und Fehlerwerte ignorieren" ], "id_hash": 8176957812684302160, "content_hash": 8176957812684302160, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201512011539\nhelp.text", "note": "AEVKM", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6406, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/111138529/?format=api", "priority": 100, "id": 112008091, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=f17a63cea8672750", "url": "https://translations.documentfoundation.org/api/units/112008091/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.032328Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<emph>Number1</emph> – required argument. The first numeric argument (if the range is set by a list of values inside the function) or a reference to a cell that contains it." ], "previous_source": "", "target": [ "<emph>Zahl 1</emph> – erforderliches Argument. Das erste numerische Argument (wenn der Bereich aus einer Werteliste innerhalb der Funktion stammt) oder ein Bezug zu einer Zelle, die dieses enthält." ], "id_hash": -8821992843903418785, "content_hash": -8821992843903418785, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id220402843321947\nhelp.text", "note": "ztEnu", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6407, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 30, "source_unit": "https://translations.documentfoundation.org/api/units/111138555/?format=api", "priority": 100, "id": 112008093, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=0591fc3fd8193e5f", "url": "https://translations.documentfoundation.org/api/units/112008093/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.035042Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<emph>Number2, 3, ...</emph> – optional. A numeric argument or a reference to a cell (up to 253 arguments), for which you need the aggregate value." ], "previous_source": "", "target": [ "<emph>Zahl 1, 3, …</emph> – optional. Ein numerisches Argument oder ein Bezug zu einer Zelle (bis zu 253 Argumente), für die Sie den Wert der Gesamtheit benötigen." ], "id_hash": -7585642633009832744, "content_hash": -7585642633009832744, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201514193338\nhelp.text", "note": "wNPAv", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6408, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 25, "source_unit": "https://translations.documentfoundation.org/api/units/111138586/?format=api", "priority": 100, "id": 112008094, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=16ba62373a63dcd8", "url": "https://translations.documentfoundation.org/api/units/112008094/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.037574Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<emph>Array</emph> – required argument. The array can be specified by the boundaries of the range, the name of the named range or the column label." ], "previous_source": "", "target": [ "<emph>Matrix</emph> – erforderliches Argument. Die Matrix kann durch die Grenzen des Bereichs, den Namen des benannten Bereichs oder die Spaltenbezeichnung angegeben werden." ], "id_hash": -1386576151735818309, "content_hash": -1386576151735818309, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id99381371214702\nhelp.text", "note": "VQD44", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6409, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 25, "source_unit": "https://translations.documentfoundation.org/api/units/111138611/?format=api", "priority": 100, "id": 112008096, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=6cc1e4561dc227bb", "url": "https://translations.documentfoundation.org/api/units/112008096/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.040014Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "For using column labels “Automatically find columns and rows labels” function needs to be enabled." ], "previous_source": "", "target": [ "Um Spaltenbeschriftungen verwenden zu können, muss in den Optionen „Spalten-/Zeilenbeschriftungen automatisch erkennen“ aktiviert sein." ], "id_hash": 2520226777258839907, "content_hash": 2520226777258839907, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201515555812\nhelp.text", "note": "tQG5i", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6410, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/111138754/?format=api", "priority": 100, "id": 112008098, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=a2f9a4e6b3f0cf63", "url": "https://translations.documentfoundation.org/api/units/112008098/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.042809Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<emph>k</emph> – required argument for the following functions: LARGE, SMALL, PERCENTILE.INC, QUARTILE.INC, PERCENTILE.EXC, QUARTILE.EXC. It is a numeric argument, which must correspond to the second argument of these functions." ], "previous_source": "", "target": [ "<emph>k</emph> – erforderliches Argument für die Funktionen: KGRÖSSTE, KKLEINSTE, QUANTIL.INKL, QUARTILE.INKL, QUANTIL.EXKL, QUARTILE.EXKL. Es ist ein numerisches Argument, das dem zweiten Argument dieser Funktionen entsprechen muss." ], "id_hash": 533395900217823044, "content_hash": 533395900217823044, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2209201514174370\nhelp.text", "note": "FChoZ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6411, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/111138792/?format=api", "priority": 100, "id": 112008103, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=876700bec5220f44", "url": "https://translations.documentfoundation.org/api/units/112008103/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.049387Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<emph>ColumnOne</emph>" ], "previous_source": "", "target": [ "<emph>Spalte eins</emph>" ], "id_hash": 5316286428101866127, "content_hash": 5316286428101866127, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201518454314\nhelp.text", "note": "5M7aG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6412, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/111138833/?format=api", "priority": 100, "id": 112008107, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=c9c73e56e73df28f", "url": "https://translations.documentfoundation.org/api/units/112008107/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.053468Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<emph>ColumnTwo</emph>" ], "previous_source": "", "target": [ "<emph>Spalte zwei</emph>" ], "id_hash": -4230562346510376131, "content_hash": -4230562346510376131, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201518454361\nhelp.text", "note": "gPqUD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6413, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/111138848/?format=api", "priority": 100, "id": 112008109, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=454a05f5d81b233d", "url": "https://translations.documentfoundation.org/api/units/112008109/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.055916Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<emph>ColumnThree</emph>" ], "previous_source": "", "target": [ "<emph>Spalte drei</emph>" ], "id_hash": -4093994859747297707, "content_hash": -4093994859747297707, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201518454323\nhelp.text", "note": "TGf5y", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6414, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/111138882/?format=api", "priority": 100, "id": 112008112, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=472f355db07cb655", "url": "https://translations.documentfoundation.org/api/units/112008112/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.058126Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "#DIV/0!" ], "previous_source": "", "target": [ "#DIV/0!" ], "id_hash": -3722701830242757940, "content_hash": -3722701830242757940, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id27530261624700\nhelp.text", "note": "cGmqm", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6415, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/111138941/?format=api", "priority": 100, "id": 112008115, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=4c564e68bbaf12cc", "url": "https://translations.documentfoundation.org/api/units/112008115/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.060783Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "3" ], "previous_source": "", "target": [ "3" ], "id_hash": 83303118788611080, "content_hash": 83303118788611080, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201517384053\nhelp.text", "note": "R9Bfd", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6416, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/111138987/?format=api", "priority": 100, "id": 112008118, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=8127f3bec413cc08", "url": "https://translations.documentfoundation.org/api/units/112008118/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.062937Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "#VALUE!" ], "previous_source": "", "target": [ "#WERT!" ], "id_hash": -6506822171614038623, "content_hash": -6506822171614038623, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\nid_par29987248418152\nhelp.text", "note": "WMMFj", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6417, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/111139028/?format=api", "priority": 100, "id": 112008120, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=25b31fb5a44f35a1", "url": "https://translations.documentfoundation.org/api/units/112008120/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.064955Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<item type=\"input\">=AGGREGATE(4;2;A2:A9)</item><br/>Returns maximum value for the range A2:A9 = 34." ], "previous_source": "", "target": [ "<item type=\"input\">=AGGREGAT(4;2;A2:A9)</item><br/>Ergibt den Maximalwert des Bereichs A2:A9 = 34." ], "id_hash": -3729420817002994407, "content_hash": -3729420817002994407, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id230920152006414\nhelp.text", "note": "RCwmP", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6418, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/111139074/?format=api", "priority": 100, "id": 112008122, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=4c3e6f86b896e519", "url": "https://translations.documentfoundation.org/api/units/112008122/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.066674Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<item type=\"input\">=AGGREGATE(9;5;A5:C5)</item><br/>Returns sum for the range A5:C5 = 29, even if some of the columns are hidden." ], "previous_source": "", "target": [ "<item type=\"input\">=AGGREGAT(9;5;A5:C5)</item><br/>Ergibt die Summe des Bereichs A5:C5 = 29, auch, wenn einige der Spalten versteckt sind." ], "id_hash": -4987997586971609650, "content_hash": -4987997586971609650, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201520064180\nhelp.text", "note": "Tx8Vx", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6419, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 17, "source_unit": "https://translations.documentfoundation.org/api/units/111139120/?format=api", "priority": 100, "id": 112008124, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=3ac7129f480d35ce", "url": "https://translations.documentfoundation.org/api/units/112008124/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.068388Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<item type=\"input\">=AGGREGATE(9;5;B2:B9)</item><br/>Returns sum of the column B = 115. If any row is hidden, the function omit its value, for example if the 7th row is hidden, the function returns 95." ], "previous_source": "", "target": [ "<item type=\"input\">=AGGREGAT(9;5;B2:B9)</item><br/>Ergibt die Summe der Spalte B = 115. Falls irgendeine Zeile ausgeblendet ist, wird deren Wert nicht berücksichtigt, falls beispielsweise die 7. Zeile ausgeblendet ist, ergibt die Funktion 95." ], "id_hash": -8594706496281572450, "content_hash": -8594706496281572450, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201520064118\nhelp.text", "note": "GPwbY", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6420, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 31, "source_unit": "https://translations.documentfoundation.org/api/units/111139149/?format=api", "priority": 100, "id": 112008126, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=08b977fa74650b9e", "url": "https://translations.documentfoundation.org/api/units/112008126/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.069925Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "If you need to apply the function with a 3D range, this example shows how to do it." ], "previous_source": "", "target": [ "Wenn Sie die Funktion auf einen dreidimensionalen Bereich anwenden müssen, zeigt Ihnen dieses Beispiel, wie Sie dies tun." ], "id_hash": -2586474231245957718, "content_hash": -2586474231245957718, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id196152404026557\nhelp.text", "note": "eyn5c", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6421, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/111139184/?format=api", "priority": 100, "id": 112008128, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=5c1aff63f1e215aa", "url": "https://translations.documentfoundation.org/api/units/112008128/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.071740Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<item type=\"input\">=AGGREGATE(13;3;Sheet1.B2:B9:Sheet3.B2:B9)</item><br/>The function returns mode of the values of second columns through sheets 1:3 (that have the same data) = 8." ], "previous_source": "", "target": [ "<item type=\"input\">=AGGREGAT(13;3;Tabelle1.B2:B9:Tabelle3.B2:B9)</item><br/>Ergibt den Modalwert aller Werte der zweiten Spalte der Tabellen 1 bis 3 (wenn diese dieselben Daten enthalten) = 8." ], "id_hash": 4304690304793179858, "content_hash": 4304690304793179858, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201520180167\nhelp.text", "note": "nKQgg", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6422, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://translations.documentfoundation.org/api/units/111139223/?format=api", "priority": 100, "id": 112008130, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=bbbd55066543f6d2", "url": "https://translations.documentfoundation.org/api/units/112008130/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.073303Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "You can use reference to a cell or a range for every argument in the formula. The following example shows how it works. Besides, it shows that you can use column labels to specify an array." ], "previous_source": "", "target": [ "Sie können für jedes Argument der Formel Bezüge zu Zellen oder Bereichen verwenden. Das folgende Beispiel zeigt, wie dies funktioniert. Außerdem zeigt es, dass Sie Spaltennamen verwenden können, um eine Matrix zu festzulegen." ], "id_hash": -1480143598379973480, "content_hash": -1480143598379973480, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201520395365\nhelp.text", "note": "kDEuY", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6423, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 36, "source_unit": "https://translations.documentfoundation.org/api/units/111139272/?format=api", "priority": 100, "id": 112008132, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=6b75793d49fe4498", "url": "https://translations.documentfoundation.org/api/units/112008132/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.074992Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<item type=\"input\">=AGGREGATE(E3;E5;'ColumnOne')</item><br/>If E3 = 13 and E5 = 5, the function returns mode of the first column = 10." ], "previous_source": "", "target": [ "<item type=\"input\">=AGGREGAT(E3;E5;'SpalteEins')</item><br/>Wenn E3 = 13 und E5 = 5, ergibt die Funktion den Modalwert der ersten Spalte = 10." ], "id_hash": 8676200419343678172, "content_hash": 8676200419343678172, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201520395380\nhelp.text", "note": "cFhbt", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6424, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/111139329/?format=api", "priority": 100, "id": 112008134, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=f8680e501b133adc", "url": "https://translations.documentfoundation.org/api/units/112008134/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.077532Z" }, { "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/AGGREGATE\">AGGREGATE wiki page</link>." ], "previous_source": "", "target": [ "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/AGGREGATE/de\">Wikiseite zu AGGREGAT</link>." ], "id_hash": -3143886092330156370, "content_hash": -3143886092330156370, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id651677017267822\nhelp.text", "note": "2BiGE", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6425, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/111139390/?format=api", "priority": 100, "id": 112008135, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=545eac418c5ebeae", "url": "https://translations.documentfoundation.org/api/units/112008135/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.079536Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<link href=\"text/scalc/01/04060184.xhp#average\">AVERAGE</link>, <link href=\"text/scalc/01/04060181.xhp#count\">COUNT</link>, <link href=\"text/scalc/01/04060181.xhp#counta\">COUNTA</link>, <link href=\"text/scalc/01/04060184.xhp#max\">MAX</link>, <link href=\"text/scalc/01/04060184.xhp#min\">MIN</link>, <link href=\"text/scalc/01/04060106.xhp#Section26\">PRODUCT</link>, <link href=\"text/scalc/01/04060185.xhp#stdevdots\">STDEV.S</link>, <link href=\"text/scalc/01/04060185.xhp#stdevdotp\">STDEV.P</link>, <link href=\"text/scalc/01/04060106.xhp#Section16\">SUM</link>, <link href=\"text/scalc/01/04060185.xhp#vardots\">VAR.S</link>, <link href=\"text/scalc/01/04060185.xhp#vardotp\">VAR.P</link>, <link href=\"text/scalc/01/04060184.xhp#median\">MEDIAN</link>, <link href=\"text/scalc/01/04060184.xhp#modedotsngl\">MODE.SNGL</link>, <link href=\"text/scalc/01/04060183.xhp#large\">LARGE</link>, <link href=\"text/scalc/01/04060183.xhp#small\">SMALL</link>, <link href=\"text/scalc/01/04060184.xhp#percentileinc\">PERCENTILE.INC</link> , <link href=\"text/scalc/01/04060184.xhp#quartileinc\">QUARTILE.INC</link>, <link href=\"text/scalc/01/04060184.xhp#percentileexc\">PERCENTILE.EXC</link>, <link href=\"text/scalc/01/04060184.xhp#quartileexc\">QUARTILE.EXC</link>" ], "previous_source": "", "target": [ "<link href=\"text/scalc/01/04060184.xhp#average\">MITTELWERT</link>, <link href=\"text/scalc/01/04060181.xhp#count\">ANZAHL</link>, <link href=\"text/scalc/01/04060181.xhp#counta\">ANZAHL2</link>, <link href=\"text/scalc/01/04060184.xhp#max\">MAX</link>, <link href=\"text/scalc/01/04060184.xhp#min\">MIN</link>, <link href=\"text/scalc/01/04060106.xhp#Section26\">PRODUKT</link>, <link href=\"text/scalc/01/04060185.xhp#stdevdots\">STABW.S</link>, <link href=\"text/scalc/01/04060185.xhp#stdevdotp\">STABW.N</link>, <link href=\"text/scalc/01/04060106.xhp#Section16\">SUMME</link>, <link href=\"text/scalc/01/04060185.xhp#vardots\">VAR.S</link>, <link href=\"text/scalc/01/04060185.xhp#vardotp\">VAR.P</link>, <link href=\"text/scalc/01/04060184.xhp#median\">MEDIAN</link>, <link href=\"text/scalc/01/04060184.xhp#modedotsngl\">MODUS.EINF</link>, <link href=\"text/scalc/01/04060183.xhp#large\">KGRÖSSTE</link>, <link href=\"text/scalc/01/04060183.xhp#small\">KKLEINSTE</link>, <link href=\"text/scalc/01/04060184.xhp#percentileinc\">QUANTIL.INKL</link>, <link href=\"text/scalc/01/04060184.xhp#quartileinc\">QUARTILE.INKL</link>, <link href=\"text/scalc/01/04060184.xhp#percentileexc\">QUANTIL.EXKL</link>, <link href=\"text/scalc/01/04060184.xhp#quartileexc\">QUARTILE.EXKL</link>" ], "id_hash": -1055625715242427970, "content_hash": -1055625715242427970, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id241712879431120\nhelp.text", "note": "cjxCG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6426, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 39, "source_unit": "https://translations.documentfoundation.org/api/units/111139446/?format=api", "priority": 100, "id": 112008136, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=7159aa01433519be", "url": "https://translations.documentfoundation.org/api/units/112008136/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.082192Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<link href=\"text/shared/optionen/01060500.xhp#hd_id3156199\">Automatically find column and row labels</link>" ], "previous_source": "", "target": [ "<link href=\"text/shared/optionen/01060500.xhp#hd_id3156199\">Spalten-/Zeilenbeschriftungen automatisch erkennen</link>" ], "id_hash": -7032246338767650268, "content_hash": -7032246338767650268, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id125062615028497\nhelp.text", "note": "DCMbQ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6427, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/111139493/?format=api", "priority": 100, "id": 112008140, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=1e6871369cb68224", "url": "https://translations.documentfoundation.org/api/units/112008140/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.085993Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "ARABIC Function" ], "previous_source": "", "target": [ "Funktion ARABISCH" ], "id_hash": -1728131784578277597, "content_hash": -1728131784578277597, "location": "func_arabic.xhp", "context": "func_arabic.xhp\ntit\nhelp.text", "note": "czFkz", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6428, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111139533/?format=api", "priority": 100, "id": 112008144, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=6804714c47265f23", "url": "https://translations.documentfoundation.org/api/units/112008144/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.106162Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<bookmark_value>ARABIC function</bookmark_value> <bookmark_value>text functions;convert roman numbers</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>ARABISCH (Funktion)</bookmark_value><bookmark_value>Textfunktionen; römische Zahlen umwandeln</bookmark_value>" ], "id_hash": 4225283107873880354, "content_hash": 4225283107873880354, "location": "func_arabic.xhp", "context": "func_arabic.xhp\nbm_id831542233029549\nhelp.text", "note": "ze8wK", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6429, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/111139581/?format=api", "priority": 100, "id": 112008146, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=baa33899a047f922", "url": "https://translations.documentfoundation.org/api/units/112008146/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.108391Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<variable id=\"Arabic_h1\"><link href=\"text/scalc/01/func_arabic.xhp\">ARABIC</link></variable>" ], "previous_source": "", "target": [ "<variable id=\"Arabic_h1\"><link href=\"text/scalc/01/func_arabic.xhp\">ARABISCH</link></variable>" ], "id_hash": 3990468403262508604, "content_hash": 3990468403262508604, "location": "func_arabic.xhp", "context": "func_arabic.xhp\nhd_id881628776094597\nhelp.text", "note": "ku3Gp", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6430, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111139618/?format=api", "priority": 100, "id": 112008149, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=b760fddecfe1ce3c", "url": "https://translations.documentfoundation.org/api/units/112008149/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.110681Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<variable id=\"func_arabic_desc\"><ahelp hid=\".\">Returns the numeric value corresponding to a Roman number expressed as text.</ahelp></variable>" ], "previous_source": "", "target": [ "<variable id=\"func_arabic_desc\"><ahelp hid=\".\">Gibt den numerischen Wert als Text zurück, der einer römischen Zahl entspricht.</ahelp></variable>" ], "id_hash": 9013760929563291653, "content_hash": 9013760929563291653, "location": "func_arabic.xhp", "context": "func_arabic.xhp\npar_id541542230672101\nhelp.text", "note": "xPXrU", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6431, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/111139645/?format=api", "priority": 100, "id": 112008154, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=fd174fcef8ea3005", "url": "https://translations.documentfoundation.org/api/units/112008154/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.113283Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "The largest Roman number that can be converted is MMMCMXCIX (or one of its simplified versions), which is equivalent to 3999." ], "previous_source": "", "target": [ "Die größte römische Zahl, die konvertiert werden kann, ist MMMCMXCIX (oder eine ihrer vereinfachten Versionen), was 3999 entspricht." ], "id_hash": -7221026554492423834, "content_hash": -7221026554492423834, "location": "func_arabic.xhp", "context": "func_arabic.xhp\npar_id151634221012221\nhelp.text", "note": "2UE9g", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6432, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://translations.documentfoundation.org/api/units/111139667/?format=api", "priority": 100, "id": 112008157, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=1bc9c29b79d0f166", "url": "https://translations.documentfoundation.org/api/units/112008157/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.115510Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<input>ARABIC(Text)</input>" ], "previous_source": "", "target": [ "<input>ARABISCH(Text)</input>" ], "id_hash": -7988538911531410977, "content_hash": -7988538911531410977, "location": "func_arabic.xhp", "context": "func_arabic.xhp\npar_id701542231253817\nhelp.text", "note": "AueXr", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6433, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/111139682/?format=api", "priority": 100, "id": 112008159, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=1123022f5fc8d9df", "url": "https://translations.documentfoundation.org/api/units/112008159/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.117938Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<emph>Text</emph>: text representing a Roman number." ], "previous_source": "", "target": [ "<emph>Text</emph>: Text, der eine römische Zahl darstellt." ], "id_hash": -6225340790463228251, "content_hash": -6225340790463228251, "location": "func_arabic.xhp", "context": "func_arabic.xhp\npar_id621542232197446\nhelp.text", "note": "sWMEb", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6434, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/111139736/?format=api", "priority": 100, "id": 112008163, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=299b2588cab096a5", "url": "https://translations.documentfoundation.org/api/units/112008163/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.120658Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<input>=ARABIC(\"MXIV\")</input> returns the numeric value 1014." ], "previous_source": "", "target": [ "<input>=ARABISCH(\"MXIV\")</input> gibt den numerischen Wert 1014 zurück." ], "id_hash": -2213520432652977172, "content_hash": -2213520432652977172, "location": "func_arabic.xhp", "context": "func_arabic.xhp\npar_id451628776707264\nhelp.text", "note": "WcE8r", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6435, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/111139795/?format=api", "priority": 100, "id": 112008166, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=6147fee4eca67bec", "url": "https://translations.documentfoundation.org/api/units/112008166/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.122641Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<input>=ARABIC(\"MMII\")</input> returns the numeric value 2002." ], "previous_source": "", "target": [ "<input>=ARABISCH(\"MMII\")</input> gibt den numerischen Wert 2002 zurück." ], "id_hash": -8849823860591717376, "content_hash": -8849823860591717376, "location": "func_arabic.xhp", "context": "func_arabic.xhp\npar_id101628778036375\nhelp.text", "note": "hDmDF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6436, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/111139870/?format=api", "priority": 100, "id": 112008168, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=052f1c1650a79400", "url": "https://translations.documentfoundation.org/api/units/112008168/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.125235Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<input>=ARABIC(\"\")</input> returns 0." ], "previous_source": "", "target": [ "<input>=ARABISCH(\"\")</input> gibt 0 zurück." ], "id_hash": 2149052753531567360, "content_hash": 2149052753531567360, "location": "func_arabic.xhp", "context": "func_arabic.xhp\npar_id101628778036134\nhelp.text", "note": "XAwC8", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6437, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111139904/?format=api", "priority": 100, "id": 112008170, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=9dd2f817d9d2fd00", "url": "https://translations.documentfoundation.org/api/units/112008170/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.127805Z" }, { "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/ARABIC\">ARABIC wiki page</link>." ], "previous_source": "", "target": [ "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/ARABIC/de\">Wikiseite zu ARABISCH</link>." ], "id_hash": -5167763158430399129, "content_hash": -5167763158430399129, "location": "func_arabic.xhp", "context": "func_arabic.xhp\npar_id721677017247207\nhelp.text", "note": "RiAmq", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6438, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/111139911/?format=api", "priority": 100, "id": 112008174, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=38486ac99267c567", "url": "https://translations.documentfoundation.org/api/units/112008174/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.130240Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "ASC Function" ], "previous_source": "", "target": [ "Funktion ASC" ], "id_hash": -8652401929046431600, "content_hash": -8652401929046431600, "location": "func_asc.xhp", "context": "func_asc.xhp\ntit\nhelp.text", "note": "yugTC", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6439, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111139960/?format=api", "priority": 100, "id": 112008178, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=07ec7e49b5486890", "url": "https://translations.documentfoundation.org/api/units/112008178/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.132868Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<bookmark_value>ASC function</bookmark_value> <bookmark_value>text functions;katakana characters</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>ASC (Funktion)</bookmark_value><bookmark_value>Textfunktionen; Katakana-Zeichen</bookmark_value>" ], "id_hash": 2033509273286519076, "content_hash": 2033509273286519076, "location": "func_asc.xhp", "context": "func_asc.xhp\nbm_id831542233029549\nhelp.text", "note": "H3kmF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6440, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/111140004/?format=api", "priority": 100, "id": 112008181, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=9c3879e8f9b4a924", "url": "https://translations.documentfoundation.org/api/units/112008181/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.134760Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<variable id=\"Asc_h1\"><link href=\"text/scalc/01/func_asc.xhp\">ASC</link></variable>" ], "previous_source": "", "target": [ "<variable id=\"Asc_h1\"><link href=\"text/scalc/01/func_asc.xhp\">ASC</link></variable>" ], "id_hash": 4674716539090233647, "content_hash": 4674716539090233647, "location": "func_asc.xhp", "context": "func_asc.xhp\nhd_id881628776094597\nhelp.text", "note": "4QDi7", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6441, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111140076/?format=api", "priority": 100, "id": 112008185, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=c0dfedecb21de92f", "url": "https://translations.documentfoundation.org/api/units/112008185/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.137664Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<variable id=\"func_asc_desc\"><ahelp hid=\".\">Converts double-byte (full-width) characters to single-byte (half-width) ASCII and katakana characters.</ahelp></variable>" ], "previous_source": "", "target": [ "<variable id=\"func_asc_desc\"><ahelp hid=\".\">Wandelt Double-Byte-Zeichen (volle Breite) in Single-Byte-ASCII- und Katakana-Zeichen (halbe Breite) um.</ahelp></variable>" ], "id_hash": 4764700226986414585, "content_hash": 4764700226986414585, "location": "func_asc.xhp", "context": "func_asc.xhp\npar_id541542230672101\nhelp.text", "note": "gtGVG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6442, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/111140109/?format=api", "priority": 100, "id": 112008189, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=c21f9d9caabf91f9", "url": "https://translations.documentfoundation.org/api/units/112008189/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.140025Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "See <link href=\"https://wiki.documentfoundation.org/Calc/Features/JIS_and_ASC_functions\">https://wiki.documentfoundation.org/Calc/Features/JIS_and_ASC_functions</link> for a conversion table." ], "previous_source": "", "target": [ "Siehe <link href=\"https://wiki.documentfoundation.org/Calc/Features/JIS_and_ASC_functions\">https://wiki.documentfoundation.org/Calc/Features/JIS_and_ASC_functions</link> (englisch) für eine Konvertierungstabelle." ], "id_hash": -2248704534092048979, "content_hash": -2248704534092048979, "location": "func_asc.xhp", "context": "func_asc.xhp\npar_id151634221012221\nhelp.text", "note": "XLLvR", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6443, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/111140143/?format=api", "priority": 100, "id": 112008192, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=60caff23f0a215ad", "url": "https://translations.documentfoundation.org/api/units/112008192/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.143190Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<input>ASC(Text)</input>" ], "previous_source": "", "target": [ "<input>ASC(Text)</input>" ], "id_hash": 1984221053926592892, "content_hash": 1984221053926592892, "location": "func_asc.xhp", "context": "func_asc.xhp\npar_id701542231253817\nhelp.text", "note": "nWQan", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6444, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/111140194/?format=api", "priority": 100, "id": 112008194, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=9b895e892325517c", "url": "https://translations.documentfoundation.org/api/units/112008194/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.145205Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<emph>Text</emph>: the text string that contains characters to be converted." ], "previous_source": "", "target": [ "<emph>Text</emph>: die Textzeichenfolge, die umzuwandelnde Zeichen enthält." ], "id_hash": 1069580224952227621, "content_hash": 1069580224952227621, "location": "func_asc.xhp", "context": "func_asc.xhp\npar_id621542232197446\nhelp.text", "note": "npFEH", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6445, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/111140233/?format=api", "priority": 100, "id": 112008196, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=8ed7e98c370f5725", "url": "https://translations.documentfoundation.org/api/units/112008196/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.147380Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "Applying the ASC function to a string composed of single-byte characters will return the input string without any modifications." ], "previous_source": "", "target": [ "Wenn Sie die Funktion ASC auf eine Zeichenfolge anwenden, die aus Single-Byte-Zeichen besteht, wird die Eingabezeichenfolge ohne Änderungen zurückgegeben." ], "id_hash": 1269744216934721748, "content_hash": 1269744216934721748, "location": "func_asc.xhp", "context": "func_asc.xhp\npar_id481637763523789\nhelp.text", "note": "d9fM4", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6446, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/111140276/?format=api", "priority": 100, "id": 112008199, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=919f09a34e0028d4", "url": "https://translations.documentfoundation.org/api/units/112008199/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.149715Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<input>=ASC(\"LibreOffice\")</input> returns the string \"LibreOffice\". No modifications were made because all characters are single-byte characters." ], "previous_source": "", "target": [ "<input>=ASC(\"LibreOffice\")</input> gibt die Zeichenfolge \"LibreOffice\" zurück. Es wurden keine Änderungen vorgenommen, da alle Zeichen Single-Byte-Zeichen sind." ], "id_hash": 3319135713135655068, "content_hash": 3319135713135655068, "location": "func_asc.xhp", "context": "func_asc.xhp\npar_id451628776707264\nhelp.text", "note": "QXBHB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6447, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/111140315/?format=api", "priority": 100, "id": 112008205, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=ae0ff05876c3789c", "url": "https://translations.documentfoundation.org/api/units/112008205/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.153668Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "<input>=ASC(\"ライト\")</input> returns the string \"ライト\", which is composed of single-byte characters." ], "previous_source": "", "target": [ "<input>=ASC(\"ライト\")</input> gibt die Zeichenfolge \"ライト\" zurück, die aus Single-Byte-Zeichen besteht." ], "id_hash": 890746019328749070, "content_hash": 890746019328749070, "location": "func_asc.xhp", "context": "func_asc.xhp\npar_id101628778036375\nhelp.text", "note": "f8rff", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6448, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/111140332/?format=api", "priority": 100, "id": 112008210, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=8c5c90c9032eee0e", "url": "https://translations.documentfoundation.org/api/units/112008210/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.157458Z" }, { "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/ASC\">ASC wiki page</link>." ], "previous_source": "", "target": [ "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/ASC/de\">Wikiseite zu ASC</link>" ], "id_hash": 7027448374366038921, "content_hash": 7027448374366038921, "location": "func_asc.xhp", "context": "func_asc.xhp\npar_id931677017229646\nhelp.text", "note": "tRpRD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6449, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/111140333/?format=api", "priority": 100, "id": 112008214, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=e18683103f7beb89", "url": "https://translations.documentfoundation.org/api/units/112008214/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.160259Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/de/?format=api", "source": [ "AVERAGEIF function" ], "previous_source": "", "target": [ "Funktion MITTELWERTWENN" ], "id_hash": 7906118277027848232, "content_hash": 7906118277027848232, "location": "func_averageif.xhp", "context": "func_averageif.xhp\ntit\nhelp.text", "note": "y9q7t", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6450, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111140334/?format=api", "priority": 100, "id": 112008219, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/de/?checksum=edb82caf3e77e028", "url": "https://translations.documentfoundation.org/api/units/112008219/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:06:54.163917Z" } ] }{ "count": 8439, "next": "