Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-master/textscalc01/hu/units/?format=api&page=95
{ "count": 8628, "next": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/units/?format=api&page=96", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/units/?format=api&page=94", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "Calculates the average for values of the range C2:C6 that correspond to all values of the range B2:B6 except its minimum and maximum. Returns 127.5, because the third and fifth rows do not meet at least one criterion." ], "previous_source": "", "target": [ "Kiszámítja a C2:C6 tartomány azon értékeinek átlagát, amelyek megfelelnek a B2:B6 tartomány értékeinek, a minimális és maximális értékek kivételével. A visszatérési értéke 127,5, mert a harmadik és ötödik sorok nem teljesítenek legalább egy feltételt." ], "id_hash": 5272279988237403964, "content_hash": 5272279988237403964, "location": "func_averageifs.xhp", "context": "func_averageifs.xhp\npar_id66091035229950\nhelp.text", "note": "oghLv", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6513, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 38, "source_unit": "https://translations.documentfoundation.org/api/units/24950752/?format=api", "priority": 100, "id": 1587411, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=c92ae6b72f4a873c", "url": "https://translations.documentfoundation.org/api/units/1587411/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:02.997162Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "<item type=\"input\">=AVERAGEIFS(C2:C6;A2:A6;\"pen.*\";B2:B6;\"<\"&MAX(B2:B6))</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=ÁTLAGHATÖBB(C2:C6;A2:A6;\"toll.*\";B2:B6;\"<\"&MAX(B2:B6))</item>" ], "id_hash": -39274590102270107, "content_hash": -39274590102270107, "location": "func_averageifs.xhp", "context": "func_averageifs.xhp\npar_id303162761931870\nhelp.text", "note": "C7fCW", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6514, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24950753/?format=api", "priority": 100, "id": 1587412, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=7f7477f7e8414f65", "url": "https://translations.documentfoundation.org/api/units/1587412/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.006892Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "Calculates the average for values of the range C2:C6 that correspond to all cells of the A2:A6 range starting with \"pen\" and to all cells of the B2:B6 range except its maximum. Returns 65, because only second row meets all criteria." ], "previous_source": "", "target": [ "Kiszámítja a C2:C6 tartomány értékeinek átlagát, amelyek megfelelnek az A2:A6 tartomány \"toll\" kezdetű celláinak, és a B2:B6 tartomány összes cellájának a maximum kivételével. A visszatérési értéke 65, mert csak a második sor teljesíti az összes feltételt." ], "id_hash": 2035057651168597951, "content_hash": 2035057651168597951, "location": "func_averageifs.xhp", "context": "func_averageifs.xhp\npar_id40031348913642\nhelp.text", "note": "eo7jB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6515, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 41, "source_unit": "https://translations.documentfoundation.org/api/units/24950754/?format=api", "priority": 100, "id": 1587413, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=9c3dfa26cb5857bf", "url": "https://translations.documentfoundation.org/api/units/1587413/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.017586Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "Reference to a cell as a criterion" ], "previous_source": "", "target": [ "Hivatkozás cellára feltételként" ], "id_hash": -3065874459700111046, "content_hash": -3065874459700111046, "location": "func_averageifs.xhp", "context": "func_averageifs.xhp\nhd_id31201205191857\nhelp.text", "note": "qyrrP", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6516, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/24950755/?format=api", "priority": 100, "id": 1587414, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=5573d36c2fa1d93a", "url": "https://translations.documentfoundation.org/api/units/1587414/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.028855Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "If you need to change a criterion easily, you may want to specify it in a separate cell and use a reference to this cell in the condition of AVERAGEIFS function. For example, the above function can be rewritten as follows:" ], "previous_source": "", "target": [ "Ha egyszerűen szeretne feltételt módosítani, akkor érdemes egy külön cellában megadni, és erre a cellára mutató hivatkozást használni az ÁTLAGHATÖBB függvény feltételében. A fenti függvény például átírható a következőképpen:" ], "id_hash": -6864261810427536110, "content_hash": -6864261810427536110, "location": "func_averageifs.xhp", "context": "func_averageifs.xhp\npar_id316794795433\nhelp.text", "note": "DqjCH", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6517, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 41, "source_unit": "https://translations.documentfoundation.org/api/units/24950756/?format=api", "priority": 100, "id": 1587415, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=20bd3e40782fdd12", "url": "https://translations.documentfoundation.org/api/units/1587415/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.039198Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "<item type=\"input\">=AVERAGEIFS(C2:C6;A2:A6;E2&\".*\";B2:B6;\"<\"&MAX(B2:B6))</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=ÁTLAGHATÖBB(C2:C6;A2:A6;E2&\".*\";B2:B6;\"<\"&MAX(B2:B6))</item>" ], "id_hash": 7459219915114670295, "content_hash": 7459219915114670295, "location": "func_averageifs.xhp", "context": "func_averageifs.xhp\npar_id67531072426731\nhelp.text", "note": "B8bav", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6518, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24950757/?format=api", "priority": 100, "id": 1587416, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=e78478fdfdede8d7", "url": "https://translations.documentfoundation.org/api/units/1587416/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.049134Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "If E2 = pen, the function returns 65, because the link to the cell is substituted with its content." ], "previous_source": "", "target": [ "Ha E2 = toll, akkor a függvény a 65 értéket adja vissza, mert a cellahivatkozás az értékével lesz helyettesítve." ], "id_hash": -7828342925869082649, "content_hash": -7828342925869082649, "location": "func_averageifs.xhp", "context": "func_averageifs.xhp\npar_id65612244926745\nhelp.text", "note": "E3TZv", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6519, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/24950758/?format=api", "priority": 100, "id": 1587417, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=135c2395d3a197e7", "url": "https://translations.documentfoundation.org/api/units/1587417/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.060279Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "COLOR function" ], "previous_source": "", "target": [ "SZÍN függvény" ], "id_hash": -8037245958908344347, "content_hash": -8037245958908344347, "location": "func_color.xhp", "context": "func_color.xhp\ntit\nhelp.text", "note": "GuEcB", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6579, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24950759/?format=api", "priority": 100, "id": 1587418, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=1075f7622ed307e5", "url": "https://translations.documentfoundation.org/api/units/1587418/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.070726Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "<bookmark_value>colors;numerical values</bookmark_value> <bookmark_value>colors;calculating in spreadsheets</bookmark_value> <bookmark_value>COLOR function</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": -3503870829010199345, "content_hash": -3503870829010199345, "location": "func_color.xhp", "context": "func_color.xhp\nbm_id1102201617201921\nhelp.text", "note": "N8CUu", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6580, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/24950760/?format=api", "priority": 100, "id": 1587419, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=4f5fc00b99fe5ccf", "url": "https://translations.documentfoundation.org/api/units/1587419/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.080087Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "<variable id=\"color_head\"><link href=\"text/scalc/01/func_color.xhp\">COLOR</link></variable>" ], "previous_source": "", "target": [ "<variable id=\"color_head\"><link href=\"text/scalc/01/func_color.xhp\">SZÍN</link></variable>" ], "id_hash": -8821725746593725306, "content_hash": -8821725746593725306, "location": "func_color.xhp", "context": "func_color.xhp\nhd_id456845684568\nhelp.text", "note": "qjPSR", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6581, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/24950761/?format=api", "priority": 100, "id": 1587420, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=0592ef2c485d0486", "url": "https://translations.documentfoundation.org/api/units/1587420/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.090168Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "<ahelp hid=\".\">Return a numeric value calculated by a combination of three colors (red, green and blue) and the alpha channel, in the RGBA color system.</ahelp> The result depends on the color system used by your computer." ], "previous_source": "", "target": [ "" ], "id_hash": -1203832068311828611, "content_hash": -1203832068311828611, "location": "func_color.xhp", "context": "func_color.xhp\npar_id1102201617001848\nhelp.text", "note": "HXh5E", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6582, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 36, "source_unit": "https://translations.documentfoundation.org/api/units/24950762/?format=api", "priority": 100, "id": 1587421, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=6f4b211caf0cb77d", "url": "https://translations.documentfoundation.org/api/units/1587421/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.099733Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "<emph>Red, Green and Blue</emph> – required arguments. The value for the red, green and blue components of the color. The values must be between 0 and 255. Zero means no color component and 255 means full color component." ], "previous_source": "", "target": [ "<emph>Vörös, Zöld és Kék</emph> - kötelező argumentumok. A szín vörös, zöld és kék komponenseinek értékei. Az értékeknek 0 és 255 között kell lenniük. A nulla jelentése: nincs adott színösszetevő, 255 jelentése: teljes színösszetevő." ], "id_hash": 224638577614200603, "content_hash": 224638577614200603, "location": "func_color.xhp", "context": "func_color.xhp\npar_id242131304318587\nhelp.text", "note": "ASLWJ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6584, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 38, "source_unit": "https://translations.documentfoundation.org/api/units/24950764/?format=api", "priority": 100, "id": 1587423, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=831e13989d8b1f1b", "url": "https://translations.documentfoundation.org/api/units/1587423/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.120163Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "<emph>Alpha</emph> – optional argument. The value for the alpha channel or alpha composite. Alpha is a integer value between 0 and 255. The value of zero for alpha means the color is fully transparent, whereas a value of 255 in the alpha channel gives a fully opaque color." ], "previous_source": "", "target": [ "<emph>Alfa</emph> - Elhagyható argumentum. Az alfa csatorna vagy alfa kompozit értéke. 0 és 255 közti egész lehet. A 0 érték jelentése: a szín teljesen átlátszó, míg a 255 érték jelentése: az alfa csatorna teljesen átlátszatlan színt ad." ], "id_hash": 8574439046245092510, "content_hash": 8574439046245092510, "location": "func_color.xhp", "context": "func_color.xhp\npar_id242131304315587\nhelp.text", "note": "GoCn2", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6585, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 48, "source_unit": "https://translations.documentfoundation.org/api/units/24950765/?format=api", "priority": 100, "id": 1587424, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=f6fe86e21bad8c9e", "url": "https://translations.documentfoundation.org/api/units/1587424/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.129792Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "<item type=\"input\">COLOR(255;255;255;1)</item> returns 33554431" ], "previous_source": "", "target": [ "<item type=\"input\">SZÍN(255;255;255;1)</item> értéke 33554431" ], "id_hash": -3533301182499384046, "content_hash": -3533301182499384046, "location": "func_color.xhp", "context": "func_color.xhp\npar_id1102201617001888\nhelp.text", "note": "fb2sj", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6586, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/24950766/?format=api", "priority": 100, "id": 1587425, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=4ef7314b74a81512", "url": "https://translations.documentfoundation.org/api/units/1587425/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.143329Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "<item type=\"input\">COLOR(0;0;255;0)</item> returns 255" ], "previous_source": "", "target": [ "<item type=\"input\">SZÍN(0;0;255;0)</item> értéke 255" ], "id_hash": 4921398467606995934, "content_hash": 4921398467606995934, "location": "func_color.xhp", "context": "func_color.xhp\npar_id1102201618185378\nhelp.text", "note": "gxbF2", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6587, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/24950767/?format=api", "priority": 100, "id": 1587426, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=c44c51d4e3dde3de", "url": "https://translations.documentfoundation.org/api/units/1587426/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.155698Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "<item type=\"input\">COLOR(0;0;255;255)</item> returns 4278190335" ], "previous_source": "", "target": [ "<item type=\"input\">SZÍN(0;0;255;255)</item> értéke 4278190335" ], "id_hash": 8589781915333483172, "content_hash": 8589781915333483172, "location": "func_color.xhp", "context": "func_color.xhp\npar_id1102201618185326\nhelp.text", "note": "f8bh7", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6588, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/24950768/?format=api", "priority": 100, "id": 1587427, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=f73509243186daa4", "url": "https://translations.documentfoundation.org/api/units/1587427/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.165898Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "<item type=\"input\">COLOR(0;0;400;0)</item> returns Err:502 (Invalid argument) because the blue value is greater than 255." ], "previous_source": "", "target": [ "" ], "id_hash": -224256149759823711, "content_hash": -224256149759823711, "location": "func_color.xhp", "context": "func_color.xhp\npar_id1102201618188326\nhelp.text", "note": "JAYa2", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6589, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/24950769/?format=api", "priority": 100, "id": 1587428, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=7ce348384ede70a1", "url": "https://translations.documentfoundation.org/api/units/1587428/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.178033Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "CONCAT function" ], "previous_source": "", "target": [ "FŰZ függvény" ], "id_hash": 8796333322820937330, "content_hash": 8796333322820937330, "location": "func_concat.xhp", "context": "func_concat.xhp\ntit\nhelp.text", "note": "cfeEJ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6591, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24950770/?format=api", "priority": 100, "id": 1587429, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=fa12da8d58ac6672", "url": "https://translations.documentfoundation.org/api/units/1587429/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.189291Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "<bookmark_value>CONCAT function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>FŰZ függvény</bookmark_value>" ], "id_hash": 7991029942349640886, "content_hash": 7991029942349640886, "location": "func_concat.xhp", "context": "func_concat.xhp\nbm_id741556228031712\nhelp.text", "note": "WEfAD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6592, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24950771/?format=api", "priority": 100, "id": 1587430, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=eee5d764ef42b4b6", "url": "https://translations.documentfoundation.org/api/units/1587430/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.200231Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "<variable id=\"concatfunction\"><ahelp hid=\".\">Concatenates one or more strings</ahelp></variable>" ], "previous_source": "", "target": [ "" ], "id_hash": -5610100621238531896, "content_hash": -5610100621238531896, "location": "func_concat.xhp", "context": "func_concat.xhp\npar_id891556226436781\nhelp.text", "note": "jUBjE", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6594, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/24950773/?format=api", "priority": 100, "id": 1587432, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=3224eb3564e108c8", "url": "https://translations.documentfoundation.org/api/units/1587432/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.227118Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "CONCAT is an enhancement of CONCATENATE, as CONCAT also accepts ranges as arguments, like B2:E5, K:K or K:M." ], "previous_source": "", "target": [ "" ], "id_hash": -7887419252229086841, "content_hash": -7887419252229086841, "location": "func_concat.xhp", "context": "func_concat.xhp\npar_id701556226865876\nhelp.text", "note": "JPUiF", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6595, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/24950774/?format=api", "priority": 100, "id": 1587433, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=128a41fabc4ee187", "url": "https://translations.documentfoundation.org/api/units/1587433/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.238774Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "When ranges are used, the cells are traversed row by row (from top to bottom) to concatenate." ], "previous_source": "", "target": [ "" ], "id_hash": -2290829766087122999, "content_hash": -2290829766087122999, "location": "func_concat.xhp", "context": "func_concat.xhp\npar_id461556226873963\nhelp.text", "note": "Gjz3x", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6596, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 17, "source_unit": "https://translations.documentfoundation.org/api/units/24950775/?format=api", "priority": 100, "id": 1587434, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=603556770f7c5fc9", "url": "https://translations.documentfoundation.org/api/units/1587434/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.249446Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "<input>=CONCAT(\"Hello \", A1:C3)</input> concatenates the string \"Hello\" with all strings in range <literal>A1:C3</literal>." ], "previous_source": "", "target": [ "" ], "id_hash": -5928279230692924343, "content_hash": -5928279230692924343, "location": "func_concat.xhp", "context": "func_concat.xhp\npar_id531556227248228\nhelp.text", "note": "aTwgH", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6598, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/24950778/?format=api", "priority": 100, "id": 1587437, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=2dba8572f538e449", "url": "https://translations.documentfoundation.org/api/units/1587437/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.280065Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "COUNTIFS function" ], "previous_source": "", "target": [ "DARABHATÖBB függvény" ], "id_hash": -6243986017061160968, "content_hash": -6243986017061160968, "location": "func_countifs.xhp", "context": "func_countifs.xhp\ntit\nhelp.text", "note": "JEUej", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6797, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24950780/?format=api", "priority": 100, "id": 1587439, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=2958e7ccae9037f8", "url": "https://translations.documentfoundation.org/api/units/1587439/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.300771Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "<bookmark_value>COUNTIFS function</bookmark_value> <bookmark_value>counting row;satisfying criteria</bookmark_value> <bookmark_value>counting column;satisfying criteria</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>DARABHATÖBB függvény</bookmark_value> <bookmark_value>sorszámlálás;feltételek teljesítése</bookmark_value> <bookmark_value>oszlopszámlálás;feltételek teljesítése</bookmark_value>" ], "id_hash": 7428600837714162632, "content_hash": 7428600837714162632, "location": "func_countifs.xhp", "context": "func_countifs.xhp\nbm_id452245224522\nhelp.text", "note": "Kprey", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6798, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/24950781/?format=api", "priority": 100, "id": 1587440, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=e717b11a7e1f33c8", "url": "https://translations.documentfoundation.org/api/units/1587440/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.310867Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "<ahelp hid=\".\"><variable id=\"countifs_des\">Returns the count of cells that meet criteria in multiple ranges.</variable></ahelp>" ], "previous_source": "", "target": [ "" ], "id_hash": -2781884893230868017, "content_hash": -2781884893230868017, "location": "func_countifs.xhp", "context": "func_countifs.xhp\npar_id462646264626\nhelp.text", "note": "pGTzr", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6800, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/24950783/?format=api", "priority": 100, "id": 1587442, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=5964c26dbcf2d9cf", "url": "https://translations.documentfoundation.org/api/units/1587442/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.338915Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "Simple usage" ], "previous_source": "", "target": [ "Egyszerű használat" ], "id_hash": -659577220271956714, "content_hash": -659577220271956714, "location": "func_countifs.xhp", "context": "func_countifs.xhp\nhd_id3861259759512\nhelp.text", "note": "ZuFZj", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6803, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24950787/?format=api", "priority": 100, "id": 1587446, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=76d8b60343c01d16", "url": "https://translations.documentfoundation.org/api/units/1587446/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.397635Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "<item type=\"input\">=COUNTIFS(B2:B6;\">=20\")</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=DARABHATÖBB(B2:B6;\">=20\")</item>" ], "id_hash": -4670497673572942546, "content_hash": -4670497673572942546, "location": "func_countifs.xhp", "context": "func_countifs.xhp\npar_id15856592423333\nhelp.text", "note": "uDqwg", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6804, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24950788/?format=api", "priority": 100, "id": 1587447, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=3f2f0f1c7a657d2e", "url": "https://translations.documentfoundation.org/api/units/1587447/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.411602Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "Counts the amount of rows of the range B2:B6 with values greater than or equal to 20. Returns 3, because the fifth and the sixth rows do not meet the criterion." ], "previous_source": "", "target": [ "Megszámolja a B2:B6 tartomány azon sorait, amelyek nagyobbak, vagy egyenlőek 20-szal. A visszaadott érték 3, mert az 5. és 6. sor nem teljesíti a feltételt." ], "id_hash": -7561950072014493005, "content_hash": -7561950072014493005, "location": "func_countifs.xhp", "context": "func_countifs.xhp\npar_id323511393121175\nhelp.text", "note": "JCUwJ", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6805, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 31, "source_unit": "https://translations.documentfoundation.org/api/units/24950789/?format=api", "priority": 100, "id": 1587448, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=170e8e7974562ab3", "url": "https://translations.documentfoundation.org/api/units/1587448/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.425619Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "<item type=\"input\">=COUNTIFS(B2:B6;\">=20\";C2:C6;\">70\")</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=DARABHATÖBB(B2:B6;\">=20\";C2:C6;\">70\")</item>" ], "id_hash": -2064120978503549065, "content_hash": -2064120978503549065, "location": "func_countifs.xhp", "context": "func_countifs.xhp\npar_id74301057922522\nhelp.text", "note": "4aGmq", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6806, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24950790/?format=api", "priority": 100, "id": 1587449, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=635ac4e7fedd3f77", "url": "https://translations.documentfoundation.org/api/units/1587449/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.435650Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "Counts the amount of rows that contain simultaneously values greater than 70 in the C2:C6 range and values greater than or equal to 20 in the B2:B6 range. Returns 2, because the second, the fifth and the sixth rows do not meet at least one criterion." ], "previous_source": "", "target": [ "Megszámolja azon sorokat, amelyek a C2:C6 tartományban nagyobbak vagy egyelőek 70-nel, és a B2:B6 tartományban nagyobbak, vagy egyenlőek 20-szal. A visszaadott érték 2, mert a 2., 5. és 6. sorok nem teljesítik legalább az egyik feltételt." ], "id_hash": -4863093154484712128, "content_hash": -4863093154484712128, "location": "func_countifs.xhp", "context": "func_countifs.xhp\npar_id109622995127628\nhelp.text", "note": "AyFxS", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6807, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 46, "source_unit": "https://translations.documentfoundation.org/api/units/24950791/?format=api", "priority": 100, "id": 1587450, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=3c82d28ab14e0d40", "url": "https://translations.documentfoundation.org/api/units/1587450/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.446095Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "Using regular expressions and nested functions" ], "previous_source": "", "target": [ "Reguláris kifejezések és beágyazott függvények használata" ], "id_hash": 7805936436593049902, "content_hash": 7805936436593049902, "location": "func_countifs.xhp", "context": "func_countifs.xhp\nhd_id298462825526166\nhelp.text", "note": "AGcGC", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6808, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/24950792/?format=api", "priority": 100, "id": 1587451, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=ec5441d4da68412e", "url": "https://translations.documentfoundation.org/api/units/1587451/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.457968Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "<item type=\"input\">=COUNTIFS(B2:B6;\"[:alpha:]*\")</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=DARABHATÖBB(B2:B6;\"[:alpha:]*\")</item>" ], "id_hash": 5738611906303249504, "content_hash": 5738611906303249504, "location": "func_countifs.xhp", "context": "func_countifs.xhp\npar_id22736248573471\nhelp.text", "note": "iHFsx", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6810, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24950793/?format=api", "priority": 100, "id": 1587452, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=cfa3a51fd3084c60", "url": "https://translations.documentfoundation.org/api/units/1587452/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.470021Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "Counts the amount of rows of the B2:B6 range that contain only alphabet symbols. Returns 1, because only sixth row meets the criterion." ], "previous_source": "", "target": [ "Megszámolja a B2:B6 tartomány azon sorait, amelyek csak betűket tartalmaznak. A visszaadott érték 1, mert csak a 6. sor teljesíti a feltételt." ], "id_hash": 4173716747243937198, "content_hash": 4173716747243937198, "location": "func_countifs.xhp", "context": "func_countifs.xhp\npar_id22137303324873\nhelp.text", "note": "yiHkH", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6811, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 23, "source_unit": "https://translations.documentfoundation.org/api/units/24950794/?format=api", "priority": 100, "id": 1587453, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=b9ec0544b092ddae", "url": "https://translations.documentfoundation.org/api/units/1587453/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.480323Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "<item type=\"input\">=COUNTIFS(B2:B6;\">\"&MIN(B2:B6);B2:B6;\"<\"&MAX(B2:B6))</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=DARABHATÖBB(B2:B6;\">\"&MIN(B2:B6);B2:B6;\"<\"&MAX(B2:B6))</item>" ], "id_hash": 2557626990426261548, "content_hash": 2557626990426261548, "location": "func_countifs.xhp", "context": "func_countifs.xhp\npar_id82271340221411\nhelp.text", "note": "pNABF", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6812, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24950795/?format=api", "priority": 100, "id": 1587454, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=a37e8432684f082c", "url": "https://translations.documentfoundation.org/api/units/1587454/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.493816Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "Counts the amount of rows of the B2:B6 range excluding rows with minimum and maximum values of this range. Returns 2, because the third, the fifth and the sixth rows do not meet at least one criterion." ], "previous_source": "", "target": [ "Megszámolja a B2:B6 tartomány azon sorait, amelyek nem a maximális vagy minimális értéket tartalmazzák. A visszaadott érték 2, mert a 3., 5. és 6. sor nem teljesíti legalább az egyik feltételt." ], "id_hash": -4856747075060767854, "content_hash": -4856747075060767854, "location": "func_countifs.xhp", "context": "func_countifs.xhp\npar_id1105320769334\nhelp.text", "note": "72QET", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6813, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 37, "source_unit": "https://translations.documentfoundation.org/api/units/24950796/?format=api", "priority": 100, "id": 1587455, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=3c995e447315e392", "url": "https://translations.documentfoundation.org/api/units/1587455/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.507008Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "<item type=\"input\">=COUNTIFS(A2:A6;\"pen.*\";B2:B6;\"<\"&MAX(B2:B6))</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=DARABHATÖBB(A2:A6;\"pen.*\";B2:B6;\"<\"&MAX(B2:B6))</item>" ], "id_hash": -849600324358677609, "content_hash": -849600324358677609, "location": "func_countifs.xhp", "context": "func_countifs.xhp\npar_id267603146513224\nhelp.text", "note": "jdWB5", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6814, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24950797/?format=api", "priority": 100, "id": 1587456, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=74359d01a18b5b97", "url": "https://translations.documentfoundation.org/api/units/1587456/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.520336Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "Counts the amount of rows that correspond to all cells of the A2:A6 range starting with \"pen\" and to all cells of the B2:B6 range with exception of its maximum. Returns 1, because only second row meets all criteria." ], "previous_source": "", "target": [ "Megszámolja azok sorok számát, amelyek megfelelnek az A2:A6 tartomány \"toll\" kezdetű celláinak, és a B2:B6 tartomány összes cellájának a maximum kivételével. A visszatérési értéke 1, mert csak a második sor teljesíti az összes feltételt." ], "id_hash": -1581394730398256572, "content_hash": -1581394730398256572, "location": "func_countifs.xhp", "context": "func_countifs.xhp\npar_id111252614832220\nhelp.text", "note": "L6af2", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6815, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 39, "source_unit": "https://translations.documentfoundation.org/api/units/24950798/?format=api", "priority": 100, "id": 1587457, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=6a0dc1df0ceff244", "url": "https://translations.documentfoundation.org/api/units/1587457/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.533229Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "Reference to a cell as a criterion" ], "previous_source": "", "target": [ "Hivatkozás cellára feltételként" ], "id_hash": -8660103929084940670, "content_hash": -8660103929084940670, "location": "func_countifs.xhp", "context": "func_countifs.xhp\nhd_id212582362610399\nhelp.text", "note": "rG36d", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6816, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/24950799/?format=api", "priority": 100, "id": 1587458, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=07d1215c14ed6e82", "url": "https://translations.documentfoundation.org/api/units/1587458/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.547990Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "If you need to change a criterion easily, you may want to specify it in a separate cell and use a reference to this cell in the condition of the COUNTIFS function. For example, the above function can be rewritten as follows:" ], "previous_source": "", "target": [ "Ha egyszerűen szeretne feltételt módosítani, akkor érdemes egy külön cellában megadni, és erre a cellára mutató hivatkozást használni a DARABHATÖBB függvény feltételében. A fenti függvény például átírható a következőképpen:" ], "id_hash": -3306896990901796710, "content_hash": -3306896990901796710, "location": "func_countifs.xhp", "context": "func_countifs.xhp\npar_id3245551524846\nhelp.text", "note": "ABwGC", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6817, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 42, "source_unit": "https://translations.documentfoundation.org/api/units/24950800/?format=api", "priority": 100, "id": 1587459, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=521b8ab51c7d809a", "url": "https://translations.documentfoundation.org/api/units/1587459/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.561604Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "<item type=\"input\">=COUNTIFS(A2:A6;E2&\".*\";B2:B6;\"<\"&MAX(B2:B6))</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=DARABHATÖBB(A2:A6;E2&\".*\";B2:B6;\"<\"&MAX(B2:B6))</item>" ], "id_hash": 5460089609370278782, "content_hash": 5460089609370278782, "location": "func_countifs.xhp", "context": "func_countifs.xhp\npar_id109501907712434\nhelp.text", "note": "3TTwe", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6818, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24950801/?format=api", "priority": 100, "id": 1587460, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=cbc6229228511b7e", "url": "https://translations.documentfoundation.org/api/units/1587460/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.575505Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "If E2 = pen, the function returns 1, because the link to the cell is substituted with its content and it works as a function above." ], "previous_source": "", "target": [ "Ha E2 = toll, akkor a függvény az 1 értéket adja vissza, mert a cellahivatkozás az értékével lesz helyettesítve, és a fenti függvényként működik." ], "id_hash": 750788171635273601, "content_hash": 750788171635273601, "location": "func_countifs.xhp", "context": "func_countifs.xhp\npar_id738533068520\nhelp.text", "note": "CNQBL", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6819, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/24950802/?format=api", "priority": 100, "id": 1587461, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=8a6b55dd3fe2af81", "url": "https://translations.documentfoundation.org/api/units/1587461/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.588417Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "DATE" ], "previous_source": "", "target": [ "DÁTUM" ], "id_hash": 2251092497364006255, "content_hash": 2251092497364006255, "location": "func_date.xhp", "context": "func_date.xhp\ntit\nhelp.text", "note": "GW3GV", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6821, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/24950803/?format=api", "priority": 100, "id": 1587462, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=9f3d7cb315edb56f", "url": "https://translations.documentfoundation.org/api/units/1587462/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.601600Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "<bookmark_value>DATE function</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>DÁTUM függvény</bookmark_value><bookmark_value>DATE függvény, lásd: DÁTUM függvény</bookmark_value>" ], "id_hash": -8529043966727092037, "content_hash": -8529043966727092037, "location": "func_date.xhp", "context": "func_date.xhp\nbm_id3155511\nhelp.text", "note": "xCZGR", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6822, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/24950804/?format=api", "priority": 100, "id": 1587463, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=09a2bfb3798b08bb", "url": "https://translations.documentfoundation.org/api/units/1587463/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.611670Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "<variable id=\"date\"><link href=\"text/scalc/01/func_date.xhp\">DATE</link></variable>" ], "previous_source": "", "target": [ "<variable id=\"date\"><link href=\"text/scalc/01/func_date.xhp\">DÁTUM</link></variable>" ], "id_hash": 1935387799744484713, "content_hash": 1935387799744484713, "location": "func_date.xhp", "context": "func_date.xhp\nhd_id3155511\nhelp.text", "note": "TioqL", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6823, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/24950805/?format=api", "priority": 100, "id": 1587464, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=9adbe0f322651569", "url": "https://translations.documentfoundation.org/api/units/1587464/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.623862Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_DATUM\">This function calculates a date specified by year, month, day and displays it in the cell's formatting.</ahelp> The default format of a cell containing the DATE function is the date format, but you can format the cells with any other number format." ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_DATUM\">Ez a függvény kiszámítja az év, hónap, nap formában megadott dátumot, majd megjeleníti a cella formázásában.</ahelp> A DÁTUM függvényt tartalmazó cella alapértelmezett formátuma a dátumformátum, de a cellákat formázhatja más számformátum használatával is." ], "id_hash": -3191741950403674441, "content_hash": -3191741950403674441, "location": "func_date.xhp", "context": "func_date.xhp\npar_id3153551\nhelp.text", "note": "Wa2yU", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6824, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 43, "source_unit": "https://translations.documentfoundation.org/api/units/24950806/?format=api", "priority": 100, "id": 1587465, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=53b4a79b4f79feb7", "url": "https://translations.documentfoundation.org/api/units/1587465/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.636716Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "DATE(Year; Month; Day)" ], "previous_source": "", "target": [ "DÁTUM(év; hónap; nap)" ], "id_hash": -368305019053121377, "content_hash": -368305019053121377, "location": "func_date.xhp", "context": "func_date.xhp\npar_id3150474\nhelp.text", "note": "wCGHA", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6825, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/24950807/?format=api", "priority": 100, "id": 1587466, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=7ae384895a58609f", "url": "https://translations.documentfoundation.org/api/units/1587466/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.653607Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "<emph>Year</emph> is an integer between 1583 and 9957 or between 0 and 99." ], "previous_source": "", "target": [ "Az <emph>év</emph> egy 1583 és 9957 vagy egy 0 és 99 közötti egész szám." ], "id_hash": -2694903448988203180, "content_hash": -2694903448988203180, "location": "func_date.xhp", "context": "func_date.xhp\npar_id3152815\nhelp.text", "note": "zExSG", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6826, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/24950808/?format=api", "priority": 100, "id": 1587467, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=5a99c79763154754", "url": "https://translations.documentfoundation.org/api/units/1587467/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.666653Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "In <switchinline select=\"sys\"><caseinline select=\"MAC\"><item type=\"menuitem\">%PRODUCTNAME - Preferences</item></caseinline><defaultinline><item type=\"menuitem\">Tools - Options</item></defaultinline></switchinline><item type=\"menuitem\"> - $[officename] - General </item>you can set from which year a two-digit number entry is recognized as 20xx." ], "previous_source": "", "target": [ "<switchinline select=\"sys\"><caseinline select=\"MAC\"><item type=\"menuitem\">A %PRODUCTNAME - Beállítások</item></caseinline> <defaultinline><item type=\"menuitem\">Az Eszközök - Beállítások</item></defaultinline></switchinline><item type=\"menuitem\"> - $[officename] - Általános</item> oldalon beállíthatja, hogy egy kétjegyű évszám mely évtől kezdődően jelentsen 20xx-et." ], "id_hash": -4638706367466650632, "content_hash": -4638706367466650632, "location": "func_date.xhp", "context": "func_date.xhp\npar_id3153222\nhelp.text", "note": "WVjaD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6827, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/24950809/?format=api", "priority": 100, "id": 1587468, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=3fa00122bdcec3f8", "url": "https://translations.documentfoundation.org/api/units/1587468/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.681392Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "<emph>Month</emph> is an integer indicating the month." ], "previous_source": "", "target": [ "A <emph>hónap</emph> a hónapot jelölő egész szám." ], "id_hash": 7683876209887228883, "content_hash": 7683876209887228883, "location": "func_date.xhp", "context": "func_date.xhp\npar_id3155817\nhelp.text", "note": "uuZQH", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6828, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/24950810/?format=api", "priority": 100, "id": 1587469, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=eaa29cb3b46733d3", "url": "https://translations.documentfoundation.org/api/units/1587469/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2019-07-11T17:53:03.696476Z" } ] }