Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-master/textscalc01/eo/units/?format=api&page=93
{ "count": 8628, "next": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/units/?format=api&page=94", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/units/?format=api&page=92", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "<variable id=\"aggregate_head\"><link href=\"text/scalc/01/func_aggregate.xhp\">AGGREGATE</link></variable> function" ], "previous_source": "", "target": [ "<variable id=\"aggregate_head\"><link href=\"text/scalc/01/func_aggregate.xhp\">KOLEKTI</link></variable>-funkcio" ], "id_hash": -1053760278183226725, "content_hash": -1053760278183226725, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\nhd_id3154073\nhelp.text", "note": "T2Az9", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6381, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/24950634/?format=api", "priority": 100, "id": 1503753, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=71604a9c2c78d29b", "url": "https://translations.documentfoundation.org/api/units/1503753/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.309222Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "<ahelp hid=\".\"><variable id=\"aggregate_des\">This function returns an aggregate result of the calculations in the range. You can use different aggregate functions listed below. The Aggregate function enables you to omit hidden rows, errors, SUBTOTAL and other AGGREGATE function results in the calculation.</variable></ahelp>" ], "previous_source": "", "target": [ "" ], "id_hash": -3207479533146748597, "content_hash": -3207479533146748597, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2209201514174373\nhelp.text", "note": "m2Tdo", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6382, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 41, "source_unit": "https://translations.documentfoundation.org/api/units/24950635/?format=api", "priority": 100, "id": 1503754, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=537cbe5bca73c94b", "url": "https://translations.documentfoundation.org/api/units/1503754/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.323504Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "AGGREGATE function is applied to vertical ranges of data with activated AutoFilter. If AutoFilter is not activated, automatic recalculation of the function result does not work for newly hidden rows. It is not supposed to work with horizontal ranges, however it can be applied to them as well, but with limitations. In particular, the AGGREGATE function applied to a horizontal data range does not recognize hiding columns, however correctly omits errors and results of SUBTOTAL and other AGGREGATE functions embedded into the row." ], "previous_source": "", "target": [ "" ], "id_hash": -4827951649456729671, "content_hash": -4827951649456729671, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2209201514174453\nhelp.text", "note": "swMHB", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6383, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 83, "source_unit": "https://translations.documentfoundation.org/api/units/24950636/?format=api", "priority": 100, "id": 1503755, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=3cffab8ded5ed1b9", "url": "https://translations.documentfoundation.org/api/units/1503755/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.346345Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "or" ], "previous_source": "", "target": [ "" ], "id_hash": 5165818302746437215, "content_hash": 5165818302746437215, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201516102726\nhelp.text", "note": "Xt2VS", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6385, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24950638/?format=api", "priority": 100, "id": 1503757, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=c7b0ac606d69a65f", "url": "https://translations.documentfoundation.org/api/units/1503757/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.368790Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "<emph>Function</emph> – obligatory argument. A function index or a reference to a cell with value from 1 to 19, in accordance with the following table." ], "previous_source": "", "target": [ "" ], "id_hash": 598813956301167531, "content_hash": 598813956301167531, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2209201514174378\nhelp.text", "note": "WPGsi", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6387, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 25, "source_unit": "https://translations.documentfoundation.org/api/units/24950640/?format=api", "priority": 100, "id": 1503759, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=884f6a1edfe09bab", "url": "https://translations.documentfoundation.org/api/units/1503759/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.394509Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "Function index" ], "previous_source": "", "target": [ "Indekso de funkcioj" ], "id_hash": -1896280781412991509, "content_hash": -1896280781412991509, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201511454963\nhelp.text", "note": "EKz89", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6388, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24950641/?format=api", "priority": 100, "id": 1503760, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=65af0ead1d7a7deb", "url": "https://translations.documentfoundation.org/api/units/1503760/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.406100Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "Function applied" ], "previous_source": "", "target": [ "" ], "id_hash": -9101540512308578305, "content_hash": -9101540512308578305, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201511454945\nhelp.text", "note": "u8cTQ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6389, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24950642/?format=api", "priority": 100, "id": 1503761, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=01b0d520470537ff", "url": "https://translations.documentfoundation.org/api/units/1503761/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.417503Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "AVERAGE" ], "previous_source": "", "target": [ "MEZUMO" ], "id_hash": 6349814163625906163, "content_hash": 6349814163625906163, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201511360043\nhelp.text", "note": "yEcCJ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6390, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24950643/?format=api", "priority": 100, "id": 1503762, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=d81f1256ccaa8ff3", "url": "https://translations.documentfoundation.org/api/units/1503762/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.431761Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "COUNT" ], "previous_source": "", "target": [ "NOMBRI" ], "id_hash": 621694158914778196, "content_hash": 621694158914778196, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id230920151136007\nhelp.text", "note": "LRogz", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6391, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24950644/?format=api", "priority": 100, "id": 1503763, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=88a0b38b2d0cf454", "url": "https://translations.documentfoundation.org/api/units/1503763/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.445645Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "COUNTA" ], "previous_source": "", "target": [ "NOMBRIA" ], "id_hash": 2372983928507894132, "content_hash": 2372983928507894132, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201511360018\nhelp.text", "note": "EQF7t", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6392, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24950645/?format=api", "priority": 100, "id": 1503764, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=a0ee884f746c8974", "url": "https://translations.documentfoundation.org/api/units/1503764/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.459743Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "MAX" ], "previous_source": "", "target": [ "MAKS" ], "id_hash": 244100451723229145, "content_hash": 244100451723229145, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201511360026\nhelp.text", "note": "8HhQr", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6393, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24950646/?format=api", "priority": 100, "id": 1503765, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=836338114a79b7d9", "url": "https://translations.documentfoundation.org/api/units/1503765/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.473844Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "MIN" ], "previous_source": "", "target": [ "MIN" ], "id_hash": 4394860047333577022, "content_hash": 4394860047333577022, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201511360078\nhelp.text", "note": "VqbLM", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6394, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24950647/?format=api", "priority": 100, "id": 1503766, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=bcfdaded96dfd13e", "url": "https://translations.documentfoundation.org/api/units/1503766/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.488141Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "PRODUCT" ], "previous_source": "", "target": [ "PRODUTO" ], "id_hash": -1711823522605648199, "content_hash": -1711823522605648199, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201511360087\nhelp.text", "note": "GjAYj", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6395, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24950648/?format=api", "priority": 100, "id": 1503767, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=683e619368eeb6b9", "url": "https://translations.documentfoundation.org/api/units/1503767/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.500735Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "STDEV.S" ], "previous_source": "", "target": [ "VAR.RAD.P" ], "id_hash": 8846584884968578513, "content_hash": 8846584884968578513, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201511360153\nhelp.text", "note": "vRU5e", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6396, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24950649/?format=api", "priority": 100, "id": 1503768, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=fac56214e7e45dd1", "url": "https://translations.documentfoundation.org/api/units/1503768/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.513916Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "STDEV.P" ], "previous_source": "", "target": [ "VAR.RAD.P" ], "id_hash": -8197045192624482240, "content_hash": -8197045192624482240, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201511360178\nhelp.text", "note": "VNpFW", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6397, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24950650/?format=api", "priority": 100, "id": 1503769, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=0e3e3ed3bdcb5840", "url": "https://translations.documentfoundation.org/api/units/1503769/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.526509Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "SUM" ], "previous_source": "", "target": [ "SUMO" ], "id_hash": 8022580678134696730, "content_hash": 8022580678134696730, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201511360199\nhelp.text", "note": "DwcTK", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6398, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24950651/?format=api", "priority": 100, "id": 1503770, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=ef55ee9f0e218b1a", "url": "https://translations.documentfoundation.org/api/units/1503770/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.538782Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "VAR.S" ], "previous_source": "", "target": [ "VARP" ], "id_hash": -7161298333087739920, "content_hash": -7161298333087739920, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201511360174\nhelp.text", "note": "BW2Yf", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6399, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24950652/?format=api", "priority": 100, "id": 1503771, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=1c9df51bb5b54ff0", "url": "https://translations.documentfoundation.org/api/units/1503771/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.550650Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "VAR.P" ], "previous_source": "", "target": [ "VARP" ], "id_hash": -5281586986569483276, "content_hash": -5281586986569483276, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201511360120\nhelp.text", "note": "DknCD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6400, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24950653/?format=api", "priority": 100, "id": 1503772, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=36b4089e67333bf4", "url": "https://translations.documentfoundation.org/api/units/1503772/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.563661Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "MEDIAN" ], "previous_source": "", "target": [ "MEDIANO" ], "id_hash": 8649179191260744639, "content_hash": 8649179191260744639, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201511360122\nhelp.text", "note": "qTcKa", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6401, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24950654/?format=api", "priority": 100, "id": 1503773, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=f8080ea62dcc0bbf", "url": "https://translations.documentfoundation.org/api/units/1503773/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.574378Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "MODE.SNGL" ], "previous_source": "", "target": [ "" ], "id_hash": 6266701016886543926, "content_hash": 6266701016886543926, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id230920151136016\nhelp.text", "note": "Vm9Es", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6402, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24950655/?format=api", "priority": 100, "id": 1503774, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=d6f7cb5f591a0636", "url": "https://translations.documentfoundation.org/api/units/1503774/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.585486Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "LARGE" ], "previous_source": "", "target": [ "GRANDA" ], "id_hash": 4912462916571599001, "content_hash": 4912462916571599001, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201511360180\nhelp.text", "note": "jvBDw", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6403, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24950656/?format=api", "priority": 100, "id": 1503775, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=c42c92feca879099", "url": "https://translations.documentfoundation.org/api/units/1503775/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.599167Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "SMALL" ], "previous_source": "", "target": [ "MALGRANDA" ], "id_hash": -5181183493836644684, "content_hash": -5181183493836644684, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201511360150\nhelp.text", "note": "MYUUL", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6404, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24950657/?format=api", "priority": 100, "id": 1503776, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=3818bd103dbfdeb4", "url": "https://translations.documentfoundation.org/api/units/1503776/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.611463Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "PERCENTILE.INC" ], "previous_source": "", "target": [ "CENTILO.INK" ], "id_hash": -7414235457462457519, "content_hash": -7414235457462457519, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201511360157\nhelp.text", "note": "FK7At", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6405, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24950658/?format=api", "priority": 100, "id": 1503777, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=191b58223cd82b51", "url": "https://translations.documentfoundation.org/api/units/1503777/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.624166Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "QUARTILE.INC" ], "previous_source": "", "target": [ "" ], "id_hash": -1302486541136101254, "content_hash": -1302486541136101254, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201511360151\nhelp.text", "note": "jRDcG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6406, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24950659/?format=api", "priority": 100, "id": 1503778, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=6deca36446db007a", "url": "https://translations.documentfoundation.org/api/units/1503778/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.633986Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "PERCENTILE.EXC" ], "previous_source": "", "target": [ "CENTILO.EKSK" ], "id_hash": 5425285444438436153, "content_hash": 5425285444438436153, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id230920151136017\nhelp.text", "note": "X8cbt", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6407, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24950660/?format=api", "priority": 100, "id": 1503779, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=cb4a7c5e08d9a939", "url": "https://translations.documentfoundation.org/api/units/1503779/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.646236Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "QUARTILE.EXC" ], "previous_source": "", "target": [ "" ], "id_hash": 4595162875984693312, "content_hash": 4595162875984693312, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201511360169\nhelp.text", "note": "x7Qhp", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6408, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24950661/?format=api", "priority": 100, "id": 1503780, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=bfc54c4a1c214840", "url": "https://translations.documentfoundation.org/api/units/1503780/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.659811Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "<emph>Option</emph> – obligatory argument. An option index or reference to a cell with value from 0 to 7 determines what to ignore in the range for the function." ], "previous_source": "", "target": [ "" ], "id_hash": 6574897751863773235, "content_hash": 6574897751863773235, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2209201514174372\nhelp.text", "note": "ZeuFJ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6409, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 28, "source_unit": "https://translations.documentfoundation.org/api/units/24950662/?format=api", "priority": 100, "id": 1503781, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=db3ebaab865ac833", "url": "https://translations.documentfoundation.org/api/units/1503781/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.672474Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "Option index" ], "previous_source": "", "target": [ "" ], "id_hash": -1480617660331537247, "content_hash": -1480617660331537247, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201512011557\nhelp.text", "note": "3cZPH", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6410, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24950663/?format=api", "priority": 100, "id": 1503782, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=6b73ca1523c4cca1", "url": "https://translations.documentfoundation.org/api/units/1503782/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.683898Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "Option applied" ], "previous_source": "", "target": [ "" ], "id_hash": 8599313250129090645, "content_hash": 8599313250129090645, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201512011551\nhelp.text", "note": "Lbpgg", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6411, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24950664/?format=api", "priority": 100, "id": 1503783, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=f756e5d702411855", "url": "https://translations.documentfoundation.org/api/units/1503783/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.697246Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "Ignore only nested SUBTOTAL and AGGREGATE functions" ], "previous_source": "", "target": [ "" ], "id_hash": -78718025930399498, "content_hash": -78718025930399498, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id2309201512011567\nhelp.text", "note": "ph2Z6", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6412, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/24950665/?format=api", "priority": 100, "id": 1503784, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=7ee8565f5affa0f6", "url": "https://translations.documentfoundation.org/api/units/1503784/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.709889Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "Ignore only hidden rows, nested SUBTOTAL and AGGREGATE functions" ], "previous_source": "", "target": [ "" ], "id_hash": 6263018716214357107, "content_hash": 6263018716214357107, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\npar_id315771547630277\nhelp.text", "note": "AGUis", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6413, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/24950666/?format=api", "priority": 100, "id": 1503785, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=d6eab656e9946c73", "url": "https://translations.documentfoundation.org/api/units/1503785/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.722761Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 6414, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/24950667/?format=api", "priority": 100, "id": 1503786, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=e21b4a15a8d1c717", "url": "https://translations.documentfoundation.org/api/units/1503786/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.737872Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 6415, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/24950668/?format=api", "priority": 100, "id": 1503787, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=91d76f0b47a11e4e", "url": "https://translations.documentfoundation.org/api/units/1503787/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.749852Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 6416, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24950669/?format=api", "priority": 100, "id": 1503788, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=6713bae46f6bf86f", "url": "https://translations.documentfoundation.org/api/units/1503788/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.764699Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 6417, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/24950670/?format=api", "priority": 100, "id": 1503789, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=066be9671151121b", "url": "https://translations.documentfoundation.org/api/units/1503789/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.777322Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 6418, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/24950671/?format=api", "priority": 100, "id": 1503790, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=50c16eeadf93ba9a", "url": "https://translations.documentfoundation.org/api/units/1503790/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.788799Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 6419, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/24950672/?format=api", "priority": 100, "id": 1503791, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=f17a63cea8672750", "url": "https://translations.documentfoundation.org/api/units/1503791/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.800133Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 6423, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/24950676/?format=api", "priority": 100, "id": 1503795, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=a2f9a4e6b3f0cf63", "url": "https://translations.documentfoundation.org/api/units/1503795/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.854994Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 6425, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24950678/?format=api", "priority": 100, "id": 1503797, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=c9c73e56e73df28f", "url": "https://translations.documentfoundation.org/api/units/1503797/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.882522Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 6426, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24950679/?format=api", "priority": 100, "id": 1503798, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=454a05f5d81b233d", "url": "https://translations.documentfoundation.org/api/units/1503798/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.894784Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 6427, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24950680/?format=api", "priority": 100, "id": 1503799, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=472f355db07cb655", "url": "https://translations.documentfoundation.org/api/units/1503799/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.910328Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 6428, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24950681/?format=api", "priority": 100, "id": 1503800, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=4c564e68bbaf12cc", "url": "https://translations.documentfoundation.org/api/units/1503800/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.921619Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 6429, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24950682/?format=api", "priority": 100, "id": 1503801, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=8127f3bec413cc08", "url": "https://translations.documentfoundation.org/api/units/1503801/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.931587Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "#VALUE!" ], "previous_source": "", "target": [ "#VALORO!" ], "id_hash": -6506822171614038623, "content_hash": -6506822171614038623, "location": "func_aggregate.xhp", "context": "func_aggregate.xhp\nid_par29987248418152\nhelp.text", "note": "WMMFj", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6430, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24950683/?format=api", "priority": 100, "id": 1503802, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=25b31fb5a44f35a1", "url": "https://translations.documentfoundation.org/api/units/1503802/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.943999Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 6432, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 17, "source_unit": "https://translations.documentfoundation.org/api/units/24950685/?format=api", "priority": 100, "id": 1503804, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=3ac7129f480d35ce", "url": "https://translations.documentfoundation.org/api/units/1503804/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.964802Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 6433, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 31, "source_unit": "https://translations.documentfoundation.org/api/units/24950686/?format=api", "priority": 100, "id": 1503805, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=08b977fa74650b9e", "url": "https://translations.documentfoundation.org/api/units/1503805/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.975833Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 6434, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/24950687/?format=api", "priority": 100, "id": 1503806, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=5c1aff63f1e215aa", "url": "https://translations.documentfoundation.org/api/units/1503806/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.986816Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 6435, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://translations.documentfoundation.org/api/units/24950688/?format=api", "priority": 100, "id": 1503807, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=bbbd55066543f6d2", "url": "https://translations.documentfoundation.org/api/units/1503807/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:01.998196Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 6436, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 36, "source_unit": "https://translations.documentfoundation.org/api/units/24950689/?format=api", "priority": 100, "id": 1503808, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=6b75793d49fe4498", "url": "https://translations.documentfoundation.org/api/units/1503808/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.011379Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 6437, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/24950690/?format=api", "priority": 100, "id": 1503809, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=f8680e501b133adc", "url": "https://translations.documentfoundation.org/api/units/1503809/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.023280Z" } ] }