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=131
{ "count": 8628, "next": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/units/?format=api&page=132", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/units/?format=api&page=130", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "The example database table giving information about the guests invited to Joe’s birthday party (described above) should occupy cells A1:E10. The content of cells A12:E12 should be identical to the header labels for the database table in cells A1:E1. Make sure that cells A13:D13 are blank and that cell E13 contains \">0\" (this search criterion is intended to match all records in the database table)." ], "previous_source": "", "target": [ "" ], "id_hash": 3273024958610690874, "content_hash": 3273024958610690874, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3149934\nhelp.text", "note": "q4kzs", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 615, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 65, "source_unit": "https://translations.documentfoundation.org/api/units/45527543/?format=api", "priority": 100, "id": 45533111, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=ad6c1edbcefa533a", "url": "https://translations.documentfoundation.org/api/units/45533111/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:45:20.209916Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "Insert the formula <input>=DSTDEV(A1:E10; \"Weight\"; A12:E13)</input> into an empty cell elsewhere in the sheet to calculate the sample standard deviation of the weights in kg of Joe’s party guests. The value 5.5 is returned." ], "previous_source": "", "target": [ "" ], "id_hash": 3932075065911071924, "content_hash": 3932075065911071924, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3150630\nhelp.text", "note": "SXqfH", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 616, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 34, "source_unit": "https://translations.documentfoundation.org/api/units/45527544/?format=api", "priority": 100, "id": 45533112, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=b69189707dccd4b4", "url": "https://translations.documentfoundation.org/api/units/45533112/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:45:20.211288Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_DBSTDABWN\">DSTDEVP calculates the population standard deviation based on the numeric values in the cells (fields) of the specified column, for all rows (database records) that match the specified search criteria.</ahelp> Non-numeric values are ignored." ], "previous_source": "", "target": [ "" ], "id_hash": -1359803832062133205, "content_hash": -1359803832062133205, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3145598\nhelp.text", "note": "Cfkn3", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 619, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 35, "source_unit": "https://translations.documentfoundation.org/api/units/45527546/?format=api", "priority": 100, "id": 45533114, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=6d21019e89b8bc2b", "url": "https://translations.documentfoundation.org/api/units/45533114/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:45:20.214651Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "Returns a #NUM! error if no records match the specified search criteria, or if there are no numeric values in the cells of the specified column for the matching records." ], "previous_source": "", "target": [ "" ], "id_hash": -5674625038366763722, "content_hash": -5674625038366763722, "location": "04060101.xhp", "context": "04060101.xhp\npar_id541616181205698\nhelp.text", "note": "TjThw", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 620, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 30, "source_unit": "https://translations.documentfoundation.org/api/units/45527547/?format=api", "priority": 100, "id": 45533115, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=313fae97d29c9536", "url": "https://translations.documentfoundation.org/api/units/45533115/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:45:20.215738Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "The example database table giving information about the guests invited to Joe’s birthday party (described above) should occupy cells A1:E10. The content of cells A12:E12 should be identical to the header labels for the database table in cells A1:E1. Make sure that cells A13:D13 are blank and that cell E13 contains \">0\" (this search criterion is intended to match all records in the database table)." ], "previous_source": "", "target": [ "" ], "id_hash": -3178976914139084068, "content_hash": -3178976914139084068, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3155431\nhelp.text", "note": "jm7Bx", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 622, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 65, "source_unit": "https://translations.documentfoundation.org/api/units/45527548/?format=api", "priority": 100, "id": 45533116, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=53e20156eb928adc", "url": "https://translations.documentfoundation.org/api/units/45533116/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:45:20.218076Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "Insert the formula <input>=DSTDEVP(A1:E10; \"Weight\"; A12:E13)</input> into an empty cell elsewhere in the sheet to calculate the population standard deviation of the weights in kg of Joe’s party guests. The value 5.18545 is returned." ], "previous_source": "", "target": [ "" ], "id_hash": -5195435835451844799, "content_hash": -5195435835451844799, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3148411\nhelp.text", "note": "6eisL", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 623, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 34, "source_unit": "https://translations.documentfoundation.org/api/units/45527549/?format=api", "priority": 100, "id": 45533117, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=37e61aa25e8ed741", "url": "https://translations.documentfoundation.org/api/units/45533117/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:45:20.219221Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_DBSUMME\">DSUM calculates the sum of all numeric values in the cells (fields) of the specified column, for all rows (database records) that match the specified search criteria.</ahelp> Blank cells or cells containing non-numeric characters are not included." ], "previous_source": "", "target": [ "" ], "id_hash": -7238116556220802580, "content_hash": -7238116556220802580, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3149591\nhelp.text", "note": "pqV9N", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 626, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 38, "source_unit": "https://translations.documentfoundation.org/api/units/45527551/?format=api", "priority": 100, "id": 45533119, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=1b8d0b575f95d9ec", "url": "https://translations.documentfoundation.org/api/units/45533119/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:45:20.222821Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "Returns 0 if no matches are found, or if there are no numeric values in the cells of the specified column for the matching records." ], "previous_source": "", "target": [ "" ], "id_hash": -2425954765439131674, "content_hash": -2425954765439131674, "location": "04060101.xhp", "context": "04060101.xhp\npar_id691616181332088\nhelp.text", "note": "PEAvG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 627, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 25, "source_unit": "https://translations.documentfoundation.org/api/units/45527552/?format=api", "priority": 100, "id": 45533120, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=5e5546fe7cd59fe6", "url": "https://translations.documentfoundation.org/api/units/45533120/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:45:20.223924Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "The example database table giving information about the guests invited to Joe’s birthday party (described above) should occupy cells A1:E10. The content of cells A12:E12 should be identical to the header labels for the database table in cells A1:E1. Make sure that cells A13:E13 are blank, except for cell D13 which should contain \">0\" (this search criterion is intended to match all records in the database table)." ], "previous_source": "", "target": [ "" ], "id_hash": 5806862272351628538, "content_hash": 5806862272351628538, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3152766\nhelp.text", "note": "G9FsG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 629, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 67, "source_unit": "https://translations.documentfoundation.org/api/units/45527553/?format=api", "priority": 100, "id": 45533121, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=d0961e787b22ecfa", "url": "https://translations.documentfoundation.org/api/units/45533121/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:45:20.226352Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "Insert the formula <input>=DSUM(A1:E10; \"Distance\"; A12:E13)</input> into an empty cell elsewhere in the sheet to find the total distance in meters that all of Joe’s party guests travel to school. The value 6000 is returned." ], "previous_source": "", "target": [ "" ], "id_hash": 1895489060518919853, "content_hash": 1895489060518919853, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3151312\nhelp.text", "note": "riVB4", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 630, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 35, "source_unit": "https://translations.documentfoundation.org/api/units/45527554/?format=api", "priority": 100, "id": 45533122, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=9a4e2141ffde7ead", "url": "https://translations.documentfoundation.org/api/units/45533122/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:45:20.227512Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_DBVARIANZ\">DVAR calculates the sample variance based on the numeric values in the cells (fields) of the specified column, for all rows (database records) that match the specified search criteria.</ahelp> Non-numeric values are ignored." ], "previous_source": "", "target": [ "" ], "id_hash": 7397650893937352998, "content_hash": 7397650893937352998, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3154418\nhelp.text", "note": "QN7LU", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 633, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 34, "source_unit": "https://translations.documentfoundation.org/api/units/45527556/?format=api", "priority": 100, "id": 45533124, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=e6a9bc4b297ca126", "url": "https://translations.documentfoundation.org/api/units/45533124/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:45:20.231020Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "Returns a #NUM! error if exactly one record matches the specified search criteria, or if there is only one numeric value in the cells of the specified column for the matching records." ], "previous_source": "", "target": [ "" ], "id_hash": -358442623195869881, "content_hash": -358442623195869881, "location": "04060101.xhp", "context": "04060101.xhp\npar_id301616181465164\nhelp.text", "note": "yytCQ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 634, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 32, "source_unit": "https://translations.documentfoundation.org/api/units/45527557/?format=api", "priority": 100, "id": 45533125, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=7b068e55540d0d47", "url": "https://translations.documentfoundation.org/api/units/45533125/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:45:20.232312Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "Returns 0 if no matches are found, or if there are no numeric values in the cells of the specified column for the matching records." ], "previous_source": "", "target": [ "" ], "id_hash": -8110133978835548470, "content_hash": -8110133978835548470, "location": "04060101.xhp", "context": "04060101.xhp\npar_id741616181469136\nhelp.text", "note": "gW4LZ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 635, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 25, "source_unit": "https://translations.documentfoundation.org/api/units/45527558/?format=api", "priority": 100, "id": 45533126, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=0f73041d96ae86ca", "url": "https://translations.documentfoundation.org/api/units/45533126/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:45:20.233518Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "The example database table giving information about the guests invited to Joe’s birthday party (described above) should occupy cells A1:E10. The content of cells A12:E12 should be identical to the header labels for the database table in cells A1:E1. Make sure that cells A13:E13 are blank, except for cell D13 which should contain \">0\" (this search criterion is intended to match all records in the database table)." ], "previous_source": "", "target": [ "" ], "id_hash": -2778539481399798989, "content_hash": -2778539481399798989, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3153701\nhelp.text", "note": "TyAAP", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 637, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 67, "source_unit": "https://translations.documentfoundation.org/api/units/45527559/?format=api", "priority": 100, "id": 45533127, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=5970a51020c45333", "url": "https://translations.documentfoundation.org/api/units/45533127/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:45:20.236368Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "Insert the formula <input>=DVAR(A1:E10; \"Distance\"; A12:E13)</input> into an empty cell elsewhere in the sheet to find the sample variance of the distances in meters that Joe’s party guests travel to school. The value 193125 is returned." ], "previous_source": "", "target": [ "" ], "id_hash": -3271768490011218818, "content_hash": -3271768490011218818, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3153676\nhelp.text", "note": "bRDWF", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 638, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 36, "source_unit": "https://translations.documentfoundation.org/api/units/45527560/?format=api", "priority": 100, "id": 45533128, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=529857e49590ac7e", "url": "https://translations.documentfoundation.org/api/units/45533128/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:45:20.238083Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_DBVARIANZEN\">DVARP calculates the population variation based on the numeric values in the cells (fields) of the specified column, for all rows (database records) that match the specified search criteria.</ahelp> Non-numeric values are ignored." ], "previous_source": "", "target": [ "" ], "id_hash": 167854092933931965, "content_hash": 167854092933931965, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3155119\nhelp.text", "note": "nfgrg", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 641, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 34, "source_unit": "https://translations.documentfoundation.org/api/units/45527562/?format=api", "priority": 100, "id": 45533130, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=825456687f6c23bd", "url": "https://translations.documentfoundation.org/api/units/45533130/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:45:20.272280Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "Returns a #NUM! error if no records match the specified search criteria, or if there are no numeric values in the cells of the specified column for the matching records." ], "previous_source": "", "target": [ "" ], "id_hash": 5472297574716727343, "content_hash": 5472297574716727343, "location": "04060101.xhp", "context": "04060101.xhp\npar_id301616181648263\nhelp.text", "note": "ERRmG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 642, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 30, "source_unit": "https://translations.documentfoundation.org/api/units/45527563/?format=api", "priority": 100, "id": 45533131, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=cbf181a69638e02f", "url": "https://translations.documentfoundation.org/api/units/45533131/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:45:20.273875Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "The example database table giving information about the guests invited to Joe’s birthday party (described above) should occupy cells A1:E10. The content of cells A12:E12 should be identical to the header labels for the database table in cells A1:E1. Make sure that cells A13:E13 are blank, except for cell D13 which should contain \">0\" (this search criterion is intended to match all records in the database table)." ], "previous_source": "", "target": [ "" ], "id_hash": -8514566768429089441, "content_hash": -8514566768429089441, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3147099\nhelp.text", "note": "STcMa", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 644, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 67, "source_unit": "https://translations.documentfoundation.org/api/units/45527564/?format=api", "priority": 100, "id": 45533132, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=09d62ea2df703d5f", "url": "https://translations.documentfoundation.org/api/units/45533132/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:45:20.277342Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "Insert the formula <input>=DVARP(A1:E10; \"Distance\"; A12:E13)</input> into an empty cell elsewhere in the sheet to find the population variance of the distances in meters that Joe’s party guests travel to school. The value 171666.67 is returned." ], "previous_source": "", "target": [ "" ], "id_hash": 544007683892511232, "content_hash": 544007683892511232, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3147322\nhelp.text", "note": "8puR2", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 645, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 36, "source_unit": "https://translations.documentfoundation.org/api/units/45527565/?format=api", "priority": 100, "id": 45533133, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=878cb41b317f0200", "url": "https://translations.documentfoundation.org/api/units/45533133/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:45:20.279001Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_FEST\">Returns a number as text with a specified number of decimal places and optional thousands separators.</ahelp>" ], "previous_source": "", "target": [ "" ], "id_hash": 4564917541115818924, "content_hash": 4564917541115818924, "location": "04060110.xhp", "context": "04060110.xhp\npar_id641617285271044\nhelp.text", "note": "k4v7r", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2309, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 17, "source_unit": "https://translations.documentfoundation.org/api/units/45547896/?format=api", "priority": 100, "id": 45548433, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=bf59d851532873ac", "url": "https://translations.documentfoundation.org/api/units/45548433/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-06T13:40:54.311668Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "FIXED(Number; [Decimals = 2 [; NoThousandsSeparators = FALSE]])" ], "previous_source": "", "target": [ "" ], "id_hash": 3164445034953640442, "content_hash": 3164445034953640442, "location": "04060110.xhp", "context": "04060110.xhp\npar_id3147567\nhelp.text", "note": "vGkWA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2310, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/45547897/?format=api", "priority": 100, "id": 45548434, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=abea5dfe4ba909fa", "url": "https://translations.documentfoundation.org/api/units/45548434/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-06T13:40:54.313507Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "<emph>Decimals</emph> (optional) refers to the number of decimal places to be displayed. If <literal>Decimals</literal> is negative, <literal>Number</literal> is rounded to ABS(<literal>Decimals</literal>) places to the left from the decimal point. If <literal>Decimals</literal> is a fraction, it is truncated actually ignoring what is the closest integer." ], "previous_source": "", "target": [ "" ], "id_hash": -5788830311505226717, "content_hash": -5788830311505226717, "location": "04060110.xhp", "context": "04060110.xhp\npar_id3156322\nhelp.text", "note": "5zSz5", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2312, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 44, "source_unit": "https://translations.documentfoundation.org/api/units/45547899/?format=api", "priority": 100, "id": 45548436, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=2fa9f18091b79423", "url": "https://translations.documentfoundation.org/api/units/45548436/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-06T13:40:54.316686Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "<item type=\"input\">=FIXED(123456.789;;TRUE)</item> returns 123456.79 as a text string." ], "previous_source": "", "target": [ "" ], "id_hash": -2868271223510780221, "content_hash": -2868271223510780221, "location": "04060110.xhp", "context": "04060110.xhp\npar_id5282143\nhelp.text", "note": "eo6wB", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2315, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/45547901/?format=api", "priority": 100, "id": 45548438, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=5831da84db2a36c3", "url": "https://translations.documentfoundation.org/api/units/45548438/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-06T13:40:54.320889Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "<item type=\"input\">=FIXED(12345.6789;-2)</item> returns 12,300 as a text string." ], "previous_source": "", "target": [ "" ], "id_hash": 4714624350173270364, "content_hash": 4714624350173270364, "location": "04060110.xhp", "context": "04060110.xhp\npar_id21617202293406\nhelp.text", "note": "U8QaS", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2316, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/45547902/?format=api", "priority": 100, "id": 45548439, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=c16db5de097c115c", "url": "https://translations.documentfoundation.org/api/units/45548439/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-06T13:40:54.322472Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "<item type=\"input\">=FIXED(12134567.89;-3;1)</item> returns 12135000 as a text string." ], "previous_source": "", "target": [ "" ], "id_hash": -6001427891539983682, "content_hash": -6001427891539983682, "location": "04060110.xhp", "context": "04060110.xhp\npar_id161617202295558\nhelp.text", "note": "iqSth", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2317, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/45547903/?format=api", "priority": 100, "id": 45548440, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=2cb6a5212ba342be", "url": "https://translations.documentfoundation.org/api/units/45548440/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-06T13:40:54.328123Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "<item type=\"input\">=FIXED(12345.789;3/4)</item> returns 12,346 as a text string." ], "previous_source": "", "target": [ "" ], "id_hash": -300381556576810427, "content_hash": -300381556576810427, "location": "04060110.xhp", "context": "04060110.xhp\npar_id451617286696878\nhelp.text", "note": "NmXWD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2318, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/45547904/?format=api", "priority": 100, "id": 45548441, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=7bd4d490d7290a45", "url": "https://translations.documentfoundation.org/api/units/45548441/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-06T13:40:54.329603Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "<image src=\"media/helpimg/scalc/IMCOT_equation.svg\" id=\"img_id211575078735993\" width=\"341.869px\" height=\"59.5625px\"><alt id=\"alt_id401575078735994\">IMCOT equation</alt></image>" ], "previous_source": "", "target": [ "" ], "id_hash": 2870055230817627947, "content_hash": 2870055230817627947, "location": "func_imcot.xhp", "context": "func_imcot.xhp\npar_id311713256011430\nhelp.text", "note": "fCe4Y", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7182, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/45549690/?format=api", "priority": 100, "id": 45550121, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=a7d47c06b6a2ef2b", "url": "https://translations.documentfoundation.org/api/units/45550121/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-12T10:33:08.910917Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "<image src=\"media/helpimg/scalc/IMCSC_equation.svg\" id=\"img_id211575078735993\" width=\"491.844px\" height=\"59.5625px\"><alt id=\"alt_id401575078735994\">IMCSC equation</alt></image>" ], "previous_source": "", "target": [ "" ], "id_hash": 6846648871920688632, "content_hash": 6846648871920688632, "location": "func_imcsc.xhp", "context": "func_imcsc.xhp\npar_id13510198901485\nhelp.text", "note": "FV9Gz", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7192, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/45549691/?format=api", "priority": 100, "id": 45550122, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=df042edfb8a95df8", "url": "https://translations.documentfoundation.org/api/units/45550122/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-12T10:33:08.917855Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "<image src=\"media/helpimg/scalc/IMCSCH_equation.svg\" id=\"img_id211575078735993\" width=\"504.344px\" height=\"59.5625px\"><alt id=\"alt_id401575078735994\">IMCSCH equation</alt></image>" ], "previous_source": "", "target": [ "" ], "id_hash": -4113507468801013442, "content_hash": -4113507468801013442, "location": "func_imcsch.xhp", "context": "func_imcsch.xhp\npar_id195151657917534\nhelp.text", "note": "FFqZK", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7202, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/45549692/?format=api", "priority": 100, "id": 45550123, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=46e9e2c05d33093e", "url": "https://translations.documentfoundation.org/api/units/45550123/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-12T10:33:08.924512Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "<image src=\"media/helpimg/scalc/IMSEC_equation.svg\" id=\"img_id211575078735993\" width=\"491.194px\" height=\"59.5625px\"><alt id=\"alt_id401575078735994\">IMSEC equation</alt></image>" ], "previous_source": "", "target": [ "" ], "id_hash": -1400137934339393315, "content_hash": -1400137934339393315, "location": "func_imsec.xhp", "context": "func_imsec.xhp\npar_id17543461310594\nhelp.text", "note": "y62eA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7212, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/45549693/?format=api", "priority": 100, "id": 45550124, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=6c91b5f78b26b8dd", "url": "https://translations.documentfoundation.org/api/units/45550124/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-12T10:33:08.930984Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "<image src=\"media/helpimg/scalc/IMSECH_equation.svg\" id=\"img_id211575078735993\" width=\"503.694px\" height=\"59.5625px\"><alt id=\"alt_id401575078735994\">IMSECH equation</alt></image>" ], "previous_source": "", "target": [ "" ], "id_hash": -5814494115358634925, "content_hash": -5814494115358634925, "location": "func_imsech.xhp", "context": "func_imsech.xhp\npar_id74572850718840\nhelp.text", "note": "CVDgc", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7222, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/45549694/?format=api", "priority": 100, "id": 45550125, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=2f4ec46899730c53", "url": "https://translations.documentfoundation.org/api/units/45550125/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-12T10:33:08.937771Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "<image src=\"media/helpimg/scalc/IMTAN_equation.svg\" id=\"img_id211575078735993\" width=\"353.294px\" height=\"59.5625px\"><alt id=\"alt_id401575078735994\">IMTAN equation</alt></image>" ], "previous_source": "", "target": [ "" ], "id_hash": -166417047733024562, "content_hash": -166417047733024562, "location": "func_imtan.xhp", "context": "func_imtan.xhp\npar_id25021317131239\nhelp.text", "note": "ujidB", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7252, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/45549695/?format=api", "priority": 100, "id": 45550126, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=7db0c493a94dc8ce", "url": "https://translations.documentfoundation.org/api/units/45550126/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-12T10:33:08.956338Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "<bookmark_value>DCOUNT function</bookmark_value><bookmark_value>counting rows;with numeric values</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": -4283882863480380764, "content_hash": -4283882863480380764, "location": "04060101.xhp", "context": "04060101.xhp\nbm_id3150882\nhelp.text", "note": "KBZPC", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 559, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/45612149/?format=api", "priority": 100, "id": 45630498, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=448c973b8ede62a4", "url": "https://translations.documentfoundation.org/api/units/45630498/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-27T17:03:19.866385Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "<bookmark_value>DCOUNTA function</bookmark_value><bookmark_value>records;counting in Calc databases</bookmark_value><bookmark_value>counting rows;with numeric or alphanumeric values</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": -1670587375212033188, "content_hash": -1670587375212033188, "location": "04060101.xhp", "context": "04060101.xhp\nbm_id3156123\nhelp.text", "note": "tGFyD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 566, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/45612150/?format=api", "priority": 100, "id": 45630499, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=68d0e1a2263c0b5c", "url": "https://translations.documentfoundation.org/api/units/45630499/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-27T17:03:19.878606Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "<bookmark_value>DGET function</bookmark_value><bookmark_value>cell contents;searching in Calc databases</bookmark_value><bookmark_value>searching;cell contents in Calc databases</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": 746247400884686976, "content_hash": 746247400884686976, "location": "04060101.xhp", "context": "04060101.xhp\nbm_id3147256\nhelp.text", "note": "GasLC", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 573, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/45612151/?format=api", "priority": 100, "id": 45630500, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=8a5b340eac4a5080", "url": "https://translations.documentfoundation.org/api/units/45630500/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-27T17:03:19.889505Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "<bookmark_value>DMAX function</bookmark_value><bookmark_value>maximum values in Calc databases</bookmark_value><bookmark_value>searching;maximum values in columns</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": 6067482821286383874, "content_hash": 6067482821286383874, "location": "04060101.xhp", "context": "04060101.xhp\nbm_id3149766\nhelp.text", "note": "rB9Ek", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 581, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/45612152/?format=api", "priority": 100, "id": 45630501, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=d434077aa38f5102", "url": "https://translations.documentfoundation.org/api/units/45630501/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-27T17:03:19.901568Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "<bookmark_value>DMIN function</bookmark_value><bookmark_value>minimum values in Calc databases</bookmark_value><bookmark_value>searching;minimum values in columns</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": -7229204091064779011, "content_hash": -7229204091064779011, "location": "04060101.xhp", "context": "04060101.xhp\nbm_id3159141\nhelp.text", "note": "CnaXx", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 588, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/45612153/?format=api", "priority": 100, "id": 45630502, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=1bacb52e5f487efd", "url": "https://translations.documentfoundation.org/api/units/45630502/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-27T17:03:19.911487Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "<bookmark_value>DAVERAGE function</bookmark_value><bookmark_value>averages; in Calc databases</bookmark_value><bookmark_value>calculating;averages in Calc databases</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": -2870387606319136727, "content_hash": -2870387606319136727, "location": "04060101.xhp", "context": "04060101.xhp\nbm_id3154274\nhelp.text", "note": "XEu9j", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 595, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/45612154/?format=api", "priority": 100, "id": 45630503, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=582a55ae15aa0029", "url": "https://translations.documentfoundation.org/api/units/45630503/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-27T17:03:19.922217Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "<bookmark_value>DPRODUCT function</bookmark_value><bookmark_value>multiplying;cell contents in Calc databases</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": 8547260052556627769, "content_hash": 8547260052556627769, "location": "04060101.xhp", "context": "04060101.xhp\nbm_id3159269\nhelp.text", "note": "6fcFr", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 602, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/45612155/?format=api", "priority": 100, "id": 45630504, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=f69df7bb83863f39", "url": "https://translations.documentfoundation.org/api/units/45630504/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-27T17:03:19.931660Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "<bookmark_value>DSTDEV function</bookmark_value><bookmark_value>standard deviations in databases;based on a sample</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": 8527548628645799969, "content_hash": 8527548628645799969, "location": "04060101.xhp", "context": "04060101.xhp\nbm_id3148462\nhelp.text", "note": "KsVCV", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 609, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/45612156/?format=api", "priority": 100, "id": 45630505, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=f657f04bff4d6821", "url": "https://translations.documentfoundation.org/api/units/45630505/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-27T17:03:19.942404Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "<bookmark_value>DSTDEVP function</bookmark_value><bookmark_value>standard deviations in databases;based on populations</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": 3090290711562855157, "content_hash": 3090290711562855157, "location": "04060101.xhp", "context": "04060101.xhp\nbm_id3150429\nhelp.text", "note": "VRXXy", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 617, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/45612157/?format=api", "priority": 100, "id": 45630506, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=aae2eb077364a2f5", "url": "https://translations.documentfoundation.org/api/units/45630506/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-27T17:03:19.954395Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "<bookmark_value>DSUM function</bookmark_value><bookmark_value>calculating;sums in Calc databases</bookmark_value><bookmark_value>sums;cells in Calc databases</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": 571292261639023166, "content_hash": 571292261639023166, "location": "04060101.xhp", "context": "04060101.xhp\nbm_id3154794\nhelp.text", "note": "Z2CTY", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 624, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/45612158/?format=api", "priority": 100, "id": 45630507, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=87eda348fdec6a3e", "url": "https://translations.documentfoundation.org/api/units/45630507/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-27T17:03:19.964503Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "<bookmark_value>DVAR function</bookmark_value><bookmark_value>variances;based on samples</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>AB.VAR függvény</bookmark_value><bookmark_value>DVAR függvény, lásd: AB.VAR függvény</bookmark_value> <bookmark_value>variancia;minta alapján</bookmark_value>" ], "id_hash": -8976625786291172676, "content_hash": -8976625786291172676, "location": "04060101.xhp", "context": "04060101.xhp\nbm_id3155614\nhelp.text", "note": "YBFb7", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 631, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/45612159/?format=api", "priority": 100, "id": 45630508, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=036c9e685680cabc", "url": "https://translations.documentfoundation.org/api/units/45630508/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-27T17:03:19.975551Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "<bookmark_value>DVARP function</bookmark_value><bookmark_value>variances;based on populations</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>AB.VAR2 függvény</bookmark_value><bookmark_value>DVARP függvény, lásd: AB.VAR2 függvény</bookmark_value><bookmark_value>variancia;sokaság alapján</bookmark_value>" ], "id_hash": -1507646871452132173, "content_hash": -1507646871452132173, "location": "04060101.xhp", "context": "04060101.xhp\nbm_id3153880\nhelp.text", "note": "7FWS4", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 639, "has_suggestion": false, "has_comment": false, "has_failing_check": true, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/45612160/?format=api", "priority": 100, "id": 45630509, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=6b13c328845ddcb3", "url": "https://translations.documentfoundation.org/api/units/45630509/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-27T17:03:20.015999Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_SVERWEIS\">Vertical search with reference to adjacent cells to the right.</ahelp> This function checks if a specific value is contained in the first column of an array. The function then returns the value in the same row of the column named by <emph>Index</emph>. If the <emph>Sorted</emph> parameter is omitted or set to TRUE or one, it is assumed that the data is sorted in ascending order. In this case, if the exact <emph>Lookup</emph> is not found, the last value that is smaller than the criterion will be returned. If <emph>Sorted</emph> is set to FALSE or zero, an exact match must be found, otherwise the error <emph>Error: Value Not Available</emph> will be the result. Thus with a value of zero the data does not need to be sorted in ascending order." ], "previous_source": "", "target": [ "<ahelp hid=\"HID_FUNC_SVERWEIS\">Függőleges keresés hivatkozással a jobb oldali szomszédos cellákra.</ahelp> Ez a függvény azt vizsgálja, hogy egy adott érték szerepel-e egy tömb első oszlopában. A függvény ezt az értéket adja vissza az <emph>index</emph> nevű oszlop azonos sorában. Ha a <emph>rendezett</emph> paraméter nincs megadva, IGAZ értékre, illetve 1-re van állítva, akkor a függvény úgy veszi, hogy az adatok növekvő sorrendben vannak. Ebben az esetben, ha nem található pontosan a <emph>keresési feltétel</emph>, akkor a keresési feltételnél kisebb utolsó érték lesz visszaadva. Ha a <emph>rendezett</emph> paraméter HAMIS vagy nulla, akkor pontos találatra van szükség, ellenkező esetben a <emph>Hiba: Érték nem érhető el</emph> hiba lesz az eredmény. A nulla érték mellett nem szükséges növekvő sorrendbe rendezni az adatokat." ], "id_hash": 1344072553765718025, "content_hash": 1344072553765718025, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3149984\nhelp.text", "note": "qFEgu", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2061, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 130, "source_unit": "https://translations.documentfoundation.org/api/units/45612171/?format=api", "priority": 100, "id": 45630510, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=92a71addcf8ec809", "url": "https://translations.documentfoundation.org/api/units/45630510/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-27T17:03:22.774048Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "=VLOOKUP(Lookup; Array; Index [; SortedRangeLookup])" ], "previous_source": "", "target": [ "" ], "id_hash": -1404160986737100578, "content_hash": -1404160986737100578, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3150156\nhelp.text", "note": "j8RoY", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2062, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/45612172/?format=api", "priority": 100, "id": 45630511, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=6c836b05aa12b8de", "url": "https://translations.documentfoundation.org/api/units/45630511/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-27T17:03:22.775902Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "<emph>Lookup</emph> is the value of any type looked for in the first column of the array." ], "previous_source": "", "target": [ "" ], "id_hash": -4100685287716172017, "content_hash": -4100685287716172017, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3149289\nhelp.text", "note": "LDrCq", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2063, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/45612173/?format=api", "priority": 100, "id": 45630512, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=471770750a01cf0f", "url": "https://translations.documentfoundation.org/api/units/45630512/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-27T17:03:22.777370Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "<emph>SortedRangeLookup</emph> is an optional parameter that indicates whether the first column in the array contains range boundaries instead of plain values. In this mode, the lookup returns the value in the row with first column having value equal to or less than <emph>Lookup</emph>. E.g., it could contain dates when some tax value had been changed, and so the values represent starting dates of a period when a specific tax value was effective. Thus, searching for a date that is absent in the first array column, but falls between some existing boundary dates, would give the lower of them, allowing to find out the data being effective to the searched date. Enter the Boolean value FALSE or zero if the first column is not a range boundary list. When this parameter is TRUE or not given, the first column in the array <emph>must be sorted in ascending order</emph>. Sorted columns can be searched much faster and the function always returns a value, even if the search value was not matched exactly, if it is greater than the lowest value of the sorted list. In unsorted lists, the search value must be matched exactly. Otherwise the function will return #N/A with message: <emph>Error: Value Not Available</emph>." ], "previous_source": "", "target": [ "A <emph>rendezett tartománykikeresés</emph> egy opcionális paraméter, amely azt jelzi, hogy a tömb első oszlopa tartományhatárokat tartalmaz-e egyszerű értékek helyett. Ebben az üzemmódban a keresés azt az értéket adja vissza a sorban, amelynek első oszlopában az érték egyenlő vagy kisebb, mint a <emph>keresési feltétel</emph>. Például tartalmazhat olyan dátumokat, amikor valamilyen adóértéket megváltoztattak, és így az értékek egy olyan időszak kezdődátumát jelentik, amikor egy adott adóérték érvényben volt. Így egy olyan dátum keresése, amely nem szerepel az első tömb oszlopában, de néhány meglévő határdátum közé esik, az alacsonyabbat adná meg, lehetővé téve a keresett dátumig érvényes adatok megtalálását. Adja meg a HAMIS vagy nulla logikai értéket, ha az első oszlop nem tartományhatár-lista. Ha ez a paraméter IGAZ vagy nincs megadva, akkor a tömb első oszlopát <emph>növekvő sorrendbe kell rendezni</emph>. A rendezett oszlopok sokkal gyorsabban kereshetők, és a függvény mindig visszaad egy értéket, még akkor is, ha a keresett érték nem egyezett pontosan, ha az nagyobb, mint a rendezett lista legalacsonyabb értéke. A rendezetlen listákban a keresési értéknek pontosan meg kell egyeznie. Ellenkező esetben a függvény a #HIÁNYZIK értéket adja vissza a következő üzenettel: <emph>Hiba: Érték nem érhető el</emph>." ], "id_hash": -5293601005237555600, "content_hash": -5293601005237555600, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3151208\nhelp.text", "note": "qKRbD", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2066, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 204, "source_unit": "https://translations.documentfoundation.org/api/units/45612174/?format=api", "priority": 100, "id": 45630513, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=368959eeb42a2e70", "url": "https://translations.documentfoundation.org/api/units/45630513/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-27T17:03:22.792540Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "MATCH(Search; LookupArray [; Type])" ], "previous_source": "", "target": [ "HOL.VAN(keresés; keresési_tömb [; típus])" ], "id_hash": 3179497475035933733, "content_hash": 3179497475035933733, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3159152\nhelp.text", "note": "AKi9E", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 2087, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/45612175/?format=api", "priority": 100, "id": 45630514, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=ac1fd81b9bc4ac25", "url": "https://translations.documentfoundation.org/api/units/45630514/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-27T17:03:22.826917Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/hu/?format=api", "source": [ "<emph>Search</emph> is the value which is to be searched for in the single-row or single-column array." ], "previous_source": "", "target": [ "" ], "id_hash": 5710919532056130791, "content_hash": 5710919532056130791, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3149336\nhelp.text", "note": "KZU4F", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2088, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/45612176/?format=api", "priority": 100, "id": 45630515, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/hu/?checksum=cf41430e810bb4e7", "url": "https://translations.documentfoundation.org/api/units/45630515/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-27T17:03:22.828356Z" } ] }