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/hsb/units/?format=api&page=129
{ "count": 8439, "next": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/units/?format=api&page=130", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/units/?format=api&page=128", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358757, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=e21b4a15a8d1c717", "url": "https://translations.documentfoundation.org/api/units/112358757/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.473483Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358758, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=91d76f0b47a11e4e", "url": "https://translations.documentfoundation.org/api/units/112358758/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.474415Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358759, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=6713bae46f6bf86f", "url": "https://translations.documentfoundation.org/api/units/112358759/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.475343Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358760, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=066be9671151121b", "url": "https://translations.documentfoundation.org/api/units/112358760/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.476249Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358761, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=50c16eeadf93ba9a", "url": "https://translations.documentfoundation.org/api/units/112358761/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.477629Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358762, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=f17a63cea8672750", "url": "https://translations.documentfoundation.org/api/units/112358762/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.478540Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358763, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=0591fc3fd8193e5f", "url": "https://translations.documentfoundation.org/api/units/112358763/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.479480Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358764, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=16ba62373a63dcd8", "url": "https://translations.documentfoundation.org/api/units/112358764/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.480468Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358765, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=6cc1e4561dc227bb", "url": "https://translations.documentfoundation.org/api/units/112358765/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.481440Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358766, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=a2f9a4e6b3f0cf63", "url": "https://translations.documentfoundation.org/api/units/112358766/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.482424Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358767, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=876700bec5220f44", "url": "https://translations.documentfoundation.org/api/units/112358767/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.483392Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358768, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=c9c73e56e73df28f", "url": "https://translations.documentfoundation.org/api/units/112358768/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.484397Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358769, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=454a05f5d81b233d", "url": "https://translations.documentfoundation.org/api/units/112358769/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.485455Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358770, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=472f355db07cb655", "url": "https://translations.documentfoundation.org/api/units/112358770/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.486383Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358771, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=4c564e68bbaf12cc", "url": "https://translations.documentfoundation.org/api/units/112358771/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.487297Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358772, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=8127f3bec413cc08", "url": "https://translations.documentfoundation.org/api/units/112358772/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.488233Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358773, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=25b31fb5a44f35a1", "url": "https://translations.documentfoundation.org/api/units/112358773/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.489153Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358774, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=4c3e6f86b896e519", "url": "https://translations.documentfoundation.org/api/units/112358774/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.490080Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358775, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=3ac7129f480d35ce", "url": "https://translations.documentfoundation.org/api/units/112358775/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.491055Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358776, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=08b977fa74650b9e", "url": "https://translations.documentfoundation.org/api/units/112358776/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.492066Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358777, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=5c1aff63f1e215aa", "url": "https://translations.documentfoundation.org/api/units/112358777/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.493049Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358778, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=bbbd55066543f6d2", "url": "https://translations.documentfoundation.org/api/units/112358778/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.494009Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358779, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=6b75793d49fe4498", "url": "https://translations.documentfoundation.org/api/units/112358779/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.495006Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358780, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=f8680e501b133adc", "url": "https://translations.documentfoundation.org/api/units/112358780/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.496001Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358781, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=545eac418c5ebeae", "url": "https://translations.documentfoundation.org/api/units/112358781/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.496971Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358782, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=7159aa01433519be", "url": "https://translations.documentfoundation.org/api/units/112358782/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.498027Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358783, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=1e6871369cb68224", "url": "https://translations.documentfoundation.org/api/units/112358783/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.499188Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358784, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=6804714c47265f23", "url": "https://translations.documentfoundation.org/api/units/112358784/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.500176Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358785, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=baa33899a047f922", "url": "https://translations.documentfoundation.org/api/units/112358785/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.501095Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358786, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=b760fddecfe1ce3c", "url": "https://translations.documentfoundation.org/api/units/112358786/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.502058Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358787, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=fd174fcef8ea3005", "url": "https://translations.documentfoundation.org/api/units/112358787/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.503025Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358788, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=1bc9c29b79d0f166", "url": "https://translations.documentfoundation.org/api/units/112358788/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.504001Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358789, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=1123022f5fc8d9df", "url": "https://translations.documentfoundation.org/api/units/112358789/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.504965Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358790, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=299b2588cab096a5", "url": "https://translations.documentfoundation.org/api/units/112358790/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.505891Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358791, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=6147fee4eca67bec", "url": "https://translations.documentfoundation.org/api/units/112358791/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.506863Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358792, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=052f1c1650a79400", "url": "https://translations.documentfoundation.org/api/units/112358792/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.507821Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358793, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=9dd2f817d9d2fd00", "url": "https://translations.documentfoundation.org/api/units/112358793/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.508755Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358794, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=38486ac99267c567", "url": "https://translations.documentfoundation.org/api/units/112358794/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.509735Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358795, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=07ec7e49b5486890", "url": "https://translations.documentfoundation.org/api/units/112358795/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.510701Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358796, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=9c3879e8f9b4a924", "url": "https://translations.documentfoundation.org/api/units/112358796/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.511630Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358797, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=c0dfedecb21de92f", "url": "https://translations.documentfoundation.org/api/units/112358797/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.512582Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358798, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=c21f9d9caabf91f9", "url": "https://translations.documentfoundation.org/api/units/112358798/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.513530Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358799, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=60caff23f0a215ad", "url": "https://translations.documentfoundation.org/api/units/112358799/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.514506Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358800, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=9b895e892325517c", "url": "https://translations.documentfoundation.org/api/units/112358800/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.515503Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358801, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=8ed7e98c370f5725", "url": "https://translations.documentfoundation.org/api/units/112358801/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.516437Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358802, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=919f09a34e0028d4", "url": "https://translations.documentfoundation.org/api/units/112358802/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.517386Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358803, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=ae0ff05876c3789c", "url": "https://translations.documentfoundation.org/api/units/112358803/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.518341Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358804, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=8c5c90c9032eee0e", "url": "https://translations.documentfoundation.org/api/units/112358804/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.519349Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358805, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=e18683103f7beb89", "url": "https://translations.documentfoundation.org/api/units/112358805/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.520327Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358806, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=edb82caf3e77e028", "url": "https://translations.documentfoundation.org/api/units/112358806/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.521304Z" } ] }