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/hye/units/?format=api&page=129
{ "count": 8439, "next": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/units/?format=api&page=130", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/units/?format=api&page=128", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?format=api", "source": [ "Ignore only errors, nested SUBTOTAL and AGGREGATE functions" ], "previous_source": "", "target": [ "" ], "id_hash": 7069325496975214359, "content_hash": 7069325496975214359, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201512011514\nhelp.text", "note": "EAKJn", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 112384074, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=e21b4a15a8d1c717", "url": "https://translations.documentfoundation.org/api/units/112384074/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:38.941747Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?format=api", "source": [ "Ignore hidden rows, errors, nested SUBTOTAL and AGGREGATE functions" ], "previous_source": "", "target": [ "" ], "id_hash": 1285618312874630734, "content_hash": 1285618312874630734, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201512011547\nhelp.text", "note": "ofBiE", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 112384075, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=91d76f0b47a11e4e", "url": "https://translations.documentfoundation.org/api/units/112384075/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:38.943641Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?format=api", "source": [ "Ignore nothing" ], "previous_source": "", "target": [ "" ], "id_hash": -1795886336106039185, "content_hash": -1795886336106039185, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201512011510\nhelp.text", "note": "oTDkv", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 112384076, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=6713bae46f6bf86f", "url": "https://translations.documentfoundation.org/api/units/112384076/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:38.945738Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?format=api", "source": [ "Ignore only hidden rows" ], "previous_source": "", "target": [ "" ], "id_hash": -8760652021237738981, "content_hash": -8760652021237738981, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201512011592\nhelp.text", "note": "5SwRv", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 112384077, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=066be9671151121b", "url": "https://translations.documentfoundation.org/api/units/112384077/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:38.948231Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?format=api", "source": [ "Ignore only errors" ], "previous_source": "", "target": [ "" ], "id_hash": -3404317888262980966, "content_hash": -3404317888262980966, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id230920151201150\nhelp.text", "note": "eDQoE", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 112384078, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=50c16eeadf93ba9a", "url": "https://translations.documentfoundation.org/api/units/112384078/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:38.950322Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?format=api", "source": [ "Ignore only hidden rows and errors" ], "previous_source": "", "target": [ "" ], "id_hash": 8176957812684302160, "content_hash": 8176957812684302160, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201512011539\nhelp.text", "note": "AEVKM", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 112384079, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=f17a63cea8672750", "url": "https://translations.documentfoundation.org/api/units/112384079/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:38.952393Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": [ "" ], "id_hash": -8821992843903418785, "content_hash": -8821992843903418785, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id220402843321947\nhelp.text", "note": "ztEnu", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 112384080, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=0591fc3fd8193e5f", "url": "https://translations.documentfoundation.org/api/units/112384080/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:38.954497Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": [ "" ], "id_hash": -7585642633009832744, "content_hash": -7585642633009832744, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201514193338\nhelp.text", "note": "wNPAv", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 112384081, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=16ba62373a63dcd8", "url": "https://translations.documentfoundation.org/api/units/112384081/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:38.957638Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": [ "" ], "id_hash": -1386576151735818309, "content_hash": -1386576151735818309, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id99381371214702\nhelp.text", "note": "VQD44", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 112384082, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=6cc1e4561dc227bb", "url": "https://translations.documentfoundation.org/api/units/112384082/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:38.959607Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?format=api", "source": [ "For using column labels “Automatically find columns and rows labels” function needs to be enabled." ], "previous_source": "", "target": [ "" ], "id_hash": 2520226777258839907, "content_hash": 2520226777258839907, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201515555812\nhelp.text", "note": "tQG5i", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 112384083, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=a2f9a4e6b3f0cf63", "url": "https://translations.documentfoundation.org/api/units/112384083/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:38.961406Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": [ "" ], "id_hash": 533395900217823044, "content_hash": 533395900217823044, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2209201514174370\nhelp.text", "note": "FChoZ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 112384084, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=876700bec5220f44", "url": "https://translations.documentfoundation.org/api/units/112384084/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:38.963179Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?format=api", "source": [ "<emph>ColumnOne</emph>" ], "previous_source": "", "target": [ "" ], "id_hash": 5316286428101866127, "content_hash": 5316286428101866127, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201518454314\nhelp.text", "note": "5M7aG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 112384085, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=c9c73e56e73df28f", "url": "https://translations.documentfoundation.org/api/units/112384085/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:38.965161Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?format=api", "source": [ "<emph>ColumnTwo</emph>" ], "previous_source": "", "target": [ "" ], "id_hash": -4230562346510376131, "content_hash": -4230562346510376131, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201518454361\nhelp.text", "note": "gPqUD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 112384086, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=454a05f5d81b233d", "url": "https://translations.documentfoundation.org/api/units/112384086/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:38.969370Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?format=api", "source": [ "<emph>ColumnThree</emph>" ], "previous_source": "", "target": [ "" ], "id_hash": -4093994859747297707, "content_hash": -4093994859747297707, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201518454323\nhelp.text", "note": "TGf5y", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 112384087, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=472f355db07cb655", "url": "https://translations.documentfoundation.org/api/units/112384087/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:38.971455Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?format=api", "source": [ "#DIV/0!" ], "previous_source": "", "target": [ "" ], "id_hash": -3722701830242757940, "content_hash": -3722701830242757940, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id27530261624700\nhelp.text", "note": "cGmqm", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 112384088, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=4c564e68bbaf12cc", "url": "https://translations.documentfoundation.org/api/units/112384088/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:38.973477Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?format=api", "source": [ "3" ], "previous_source": "", "target": [ "" ], "id_hash": 83303118788611080, "content_hash": 83303118788611080, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201517384053\nhelp.text", "note": "R9Bfd", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 112384089, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=8127f3bec413cc08", "url": "https://translations.documentfoundation.org/api/units/112384089/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:38.975428Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?format=api", "source": [ "#VALUE!" ], "previous_source": "", "target": [ "" ], "id_hash": -6506822171614038623, "content_hash": -6506822171614038623, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\nid_par29987248418152\nhelp.text", "note": "WMMFj", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 112384090, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=25b31fb5a44f35a1", "url": "https://translations.documentfoundation.org/api/units/112384090/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:38.977355Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": [ "" ], "id_hash": -3729420817002994407, "content_hash": -3729420817002994407, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id230920152006414\nhelp.text", "note": "RCwmP", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 112384091, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=4c3e6f86b896e519", "url": "https://translations.documentfoundation.org/api/units/112384091/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:38.979284Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": [ "" ], "id_hash": -4987997586971609650, "content_hash": -4987997586971609650, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201520064180\nhelp.text", "note": "Tx8Vx", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 112384092, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=3ac7129f480d35ce", "url": "https://translations.documentfoundation.org/api/units/112384092/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:38.981150Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": [ "" ], "id_hash": -8594706496281572450, "content_hash": -8594706496281572450, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201520064118\nhelp.text", "note": "GPwbY", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 112384093, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=08b977fa74650b9e", "url": "https://translations.documentfoundation.org/api/units/112384093/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:38.983065Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?format=api", "source": [ "If you need to apply the function with a 3D range, this example shows how to do it." ], "previous_source": "", "target": [ "" ], "id_hash": -2586474231245957718, "content_hash": -2586474231245957718, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id196152404026557\nhelp.text", "note": "eyn5c", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 112384094, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=5c1aff63f1e215aa", "url": "https://translations.documentfoundation.org/api/units/112384094/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:38.987216Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": [ "" ], "id_hash": 4304690304793179858, "content_hash": 4304690304793179858, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201520180167\nhelp.text", "note": "nKQgg", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 112384095, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=bbbd55066543f6d2", "url": "https://translations.documentfoundation.org/api/units/112384095/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:38.990487Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": [ "" ], "id_hash": -1480143598379973480, "content_hash": -1480143598379973480, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201520395365\nhelp.text", "note": "kDEuY", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 112384096, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=6b75793d49fe4498", "url": "https://translations.documentfoundation.org/api/units/112384096/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:38.992699Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": [ "" ], "id_hash": 8676200419343678172, "content_hash": 8676200419343678172, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201520395380\nhelp.text", "note": "cFhbt", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 112384097, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=f8680e501b133adc", "url": "https://translations.documentfoundation.org/api/units/112384097/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:38.994675Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?format=api", "source": [ "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/AGGREGATE\">AGGREGATE wiki page</link>." ], "previous_source": "", "target": [ "" ], "id_hash": -3143886092330156370, "content_hash": -3143886092330156370, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id651677017267822\nhelp.text", "note": "2BiGE", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 112384098, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=545eac418c5ebeae", "url": "https://translations.documentfoundation.org/api/units/112384098/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:38.996768Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": [ "" ], "id_hash": -1055625715242427970, "content_hash": -1055625715242427970, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id241712879431120\nhelp.text", "note": "cjxCG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 112384099, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=7159aa01433519be", "url": "https://translations.documentfoundation.org/api/units/112384099/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:38.998944Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?format=api", "source": [ "<link href=\"text/shared/optionen/01060500.xhp#hd_id3156199\">Automatically find column and row labels</link>" ], "previous_source": "", "target": [ "" ], "id_hash": -7032246338767650268, "content_hash": -7032246338767650268, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id125062615028497\nhelp.text", "note": "DCMbQ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 112384100, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=1e6871369cb68224", "url": "https://translations.documentfoundation.org/api/units/112384100/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:39.001063Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?format=api", "source": [ "ARABIC Function" ], "previous_source": "", "target": [ "" ], "id_hash": -1728131784578277597, "content_hash": -1728131784578277597, "location": "func_arabic.xhp", "context": "func_arabic.xhp\ntit\nhelp.text", "note": "czFkz", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 112384101, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=6804714c47265f23", "url": "https://translations.documentfoundation.org/api/units/112384101/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:39.002914Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?format=api", "source": [ "<bookmark_value>ARABIC function</bookmark_value> <bookmark_value>text functions;convert roman numbers</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": 4225283107873880354, "content_hash": 4225283107873880354, "location": "func_arabic.xhp", "context": "func_arabic.xhp\nbm_id831542233029549\nhelp.text", "note": "ze8wK", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 112384102, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=baa33899a047f922", "url": "https://translations.documentfoundation.org/api/units/112384102/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:39.004807Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?format=api", "source": [ "<variable id=\"Arabic_h1\"><link href=\"text/scalc/01/func_arabic.xhp\">ARABIC</link></variable>" ], "previous_source": "", "target": [ "" ], "id_hash": 3990468403262508604, "content_hash": 3990468403262508604, "location": "func_arabic.xhp", "context": "func_arabic.xhp\nhd_id881628776094597\nhelp.text", "note": "ku3Gp", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 112384103, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=b760fddecfe1ce3c", "url": "https://translations.documentfoundation.org/api/units/112384103/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:39.006864Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": [ "" ], "id_hash": 9013760929563291653, "content_hash": 9013760929563291653, "location": "func_arabic.xhp", "context": "func_arabic.xhp\npar_id541542230672101\nhelp.text", "note": "xPXrU", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 112384104, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=fd174fcef8ea3005", "url": "https://translations.documentfoundation.org/api/units/112384104/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:39.008885Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": [ "" ], "id_hash": -7221026554492423834, "content_hash": -7221026554492423834, "location": "func_arabic.xhp", "context": "func_arabic.xhp\npar_id151634221012221\nhelp.text", "note": "2UE9g", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 112384105, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=1bc9c29b79d0f166", "url": "https://translations.documentfoundation.org/api/units/112384105/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:39.010963Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?format=api", "source": [ "<input>ARABIC(Text)</input>" ], "previous_source": "", "target": [ "" ], "id_hash": -7988538911531410977, "content_hash": -7988538911531410977, "location": "func_arabic.xhp", "context": "func_arabic.xhp\npar_id701542231253817\nhelp.text", "note": "AueXr", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 112384106, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=1123022f5fc8d9df", "url": "https://translations.documentfoundation.org/api/units/112384106/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:39.012833Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?format=api", "source": [ "<emph>Text</emph>: text representing a Roman number." ], "previous_source": "", "target": [ "" ], "id_hash": -6225340790463228251, "content_hash": -6225340790463228251, "location": "func_arabic.xhp", "context": "func_arabic.xhp\npar_id621542232197446\nhelp.text", "note": "sWMEb", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 112384107, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=299b2588cab096a5", "url": "https://translations.documentfoundation.org/api/units/112384107/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:39.014476Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?format=api", "source": [ "<input>=ARABIC(\"MXIV\")</input> returns the numeric value 1014." ], "previous_source": "", "target": [ "" ], "id_hash": -2213520432652977172, "content_hash": -2213520432652977172, "location": "func_arabic.xhp", "context": "func_arabic.xhp\npar_id451628776707264\nhelp.text", "note": "WcE8r", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 112384108, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=6147fee4eca67bec", "url": "https://translations.documentfoundation.org/api/units/112384108/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:39.016197Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?format=api", "source": [ "<input>=ARABIC(\"MMII\")</input> returns the numeric value 2002." ], "previous_source": "", "target": [ "" ], "id_hash": -8849823860591717376, "content_hash": -8849823860591717376, "location": "func_arabic.xhp", "context": "func_arabic.xhp\npar_id101628778036375\nhelp.text", "note": "hDmDF", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 112384109, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=052f1c1650a79400", "url": "https://translations.documentfoundation.org/api/units/112384109/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:39.017946Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?format=api", "source": [ "<input>=ARABIC(\"\")</input> returns 0." ], "previous_source": "", "target": [ "" ], "id_hash": 2149052753531567360, "content_hash": 2149052753531567360, "location": "func_arabic.xhp", "context": "func_arabic.xhp\npar_id101628778036134\nhelp.text", "note": "XAwC8", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 112384110, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=9dd2f817d9d2fd00", "url": "https://translations.documentfoundation.org/api/units/112384110/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:39.020032Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?format=api", "source": [ "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/ARABIC\">ARABIC wiki page</link>." ], "previous_source": "", "target": [ "" ], "id_hash": -5167763158430399129, "content_hash": -5167763158430399129, "location": "func_arabic.xhp", "context": "func_arabic.xhp\npar_id721677017247207\nhelp.text", "note": "RiAmq", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 112384111, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=38486ac99267c567", "url": "https://translations.documentfoundation.org/api/units/112384111/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:39.021989Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?format=api", "source": [ "ASC Function" ], "previous_source": "", "target": [ "" ], "id_hash": -8652401929046431600, "content_hash": -8652401929046431600, "location": "func_asc.xhp", "context": "func_asc.xhp\ntit\nhelp.text", "note": "yugTC", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 112384112, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=07ec7e49b5486890", "url": "https://translations.documentfoundation.org/api/units/112384112/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:39.023937Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?format=api", "source": [ "<bookmark_value>ASC function</bookmark_value> <bookmark_value>text functions;katakana characters</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": 2033509273286519076, "content_hash": 2033509273286519076, "location": "func_asc.xhp", "context": "func_asc.xhp\nbm_id831542233029549\nhelp.text", "note": "H3kmF", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 112384113, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=9c3879e8f9b4a924", "url": "https://translations.documentfoundation.org/api/units/112384113/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:39.025860Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?format=api", "source": [ "<variable id=\"Asc_h1\"><link href=\"text/scalc/01/func_asc.xhp\">ASC</link></variable>" ], "previous_source": "", "target": [ "" ], "id_hash": 4674716539090233647, "content_hash": 4674716539090233647, "location": "func_asc.xhp", "context": "func_asc.xhp\nhd_id881628776094597\nhelp.text", "note": "4QDi7", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 112384114, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=c0dfedecb21de92f", "url": "https://translations.documentfoundation.org/api/units/112384114/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:39.027517Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": [ "" ], "id_hash": 4764700226986414585, "content_hash": 4764700226986414585, "location": "func_asc.xhp", "context": "func_asc.xhp\npar_id541542230672101\nhelp.text", "note": "gtGVG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 112384115, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=c21f9d9caabf91f9", "url": "https://translations.documentfoundation.org/api/units/112384115/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:39.029059Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": [ "" ], "id_hash": -2248704534092048979, "content_hash": -2248704534092048979, "location": "func_asc.xhp", "context": "func_asc.xhp\npar_id151634221012221\nhelp.text", "note": "XLLvR", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 112384116, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=60caff23f0a215ad", "url": "https://translations.documentfoundation.org/api/units/112384116/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:39.031210Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?format=api", "source": [ "<input>ASC(Text)</input>" ], "previous_source": "", "target": [ "" ], "id_hash": 1984221053926592892, "content_hash": 1984221053926592892, "location": "func_asc.xhp", "context": "func_asc.xhp\npar_id701542231253817\nhelp.text", "note": "nWQan", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6444, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/111140194/?format=api", "priority": 100, "id": 112384117, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=9b895e892325517c", "url": "https://translations.documentfoundation.org/api/units/112384117/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:39.032460Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?format=api", "source": [ "<emph>Text</emph>: the text string that contains characters to be converted." ], "previous_source": "", "target": [ "" ], "id_hash": 1069580224952227621, "content_hash": 1069580224952227621, "location": "func_asc.xhp", "context": "func_asc.xhp\npar_id621542232197446\nhelp.text", "note": "npFEH", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 112384118, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=8ed7e98c370f5725", "url": "https://translations.documentfoundation.org/api/units/112384118/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:39.033911Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": [ "" ], "id_hash": 1269744216934721748, "content_hash": 1269744216934721748, "location": "func_asc.xhp", "context": "func_asc.xhp\npar_id481637763523789\nhelp.text", "note": "d9fM4", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 112384119, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=919f09a34e0028d4", "url": "https://translations.documentfoundation.org/api/units/112384119/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:39.036609Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?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": [ "" ], "id_hash": 3319135713135655068, "content_hash": 3319135713135655068, "location": "func_asc.xhp", "context": "func_asc.xhp\npar_id451628776707264\nhelp.text", "note": "QXBHB", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 112384120, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=ae0ff05876c3789c", "url": "https://translations.documentfoundation.org/api/units/112384120/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:39.038753Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?format=api", "source": [ "<input>=ASC(\"ライト\")</input> returns the string \"ﾗｲﾄ\", which is composed of single-byte characters." ], "previous_source": "", "target": [ "" ], "id_hash": 890746019328749070, "content_hash": 890746019328749070, "location": "func_asc.xhp", "context": "func_asc.xhp\npar_id101628778036375\nhelp.text", "note": "f8rff", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 112384121, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=8c5c90c9032eee0e", "url": "https://translations.documentfoundation.org/api/units/112384121/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:39.041011Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?format=api", "source": [ "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/ASC\">ASC wiki page</link>." ], "previous_source": "", "target": [ "" ], "id_hash": 7027448374366038921, "content_hash": 7027448374366038921, "location": "func_asc.xhp", "context": "func_asc.xhp\npar_id931677017229646\nhelp.text", "note": "tRpRD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 112384122, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=e18683103f7beb89", "url": "https://translations.documentfoundation.org/api/units/112384122/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:39.042778Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hye/?format=api", "source": [ "AVERAGEIF function" ], "previous_source": "", "target": [ "" ], "id_hash": 7906118277027848232, "content_hash": 7906118277027848232, "location": "func_averageif.xhp", "context": "func_averageif.xhp\ntit\nhelp.text", "note": "y9q7t", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 112384123, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hye/?checksum=edb82caf3e77e028", "url": "https://translations.documentfoundation.org/api/units/112384123/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:20:39.044252Z" } ] }