Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-master/textscalc01/et/units/?format=api&page=131
https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/units/?format=api&page=132", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/units/?format=api&page=130", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_DBMIN\">DMIN calculates the minimum value across the cells (fields) of the specified column that contain numeric values, 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": -2182869194426701095, "content_hash": -2182869194426701095, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3154261\nhelp.text", "note": "kv5Gb", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 590, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 39, "source_unit": "https://translations.documentfoundation.org/api/units/45527525/?format=api", "priority": 100, "id": 45531171, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=61b4e408730daad9", "url": "https://translations.documentfoundation.org/api/units/45531171/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:41:21.835488Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "Returns 0 if no matches are found, or if there are no non-zero numeric values in the cells of the specified column for the matching records." ], "previous_source": "", "target": [ "" ], "id_hash": -7088825732426253501, "content_hash": -7088825732426253501, "location": "04060101.xhp", "context": "04060101.xhp\npar_id901616180605426\nhelp.text", "note": "yYJTa", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 591, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/45527526/?format=api", "priority": 100, "id": 45531172, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=1d9f6e8df815bb43", "url": "https://translations.documentfoundation.org/api/units/45531172/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:41:21.836965Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?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": -2901804372218614756, "content_hash": -2901804372218614756, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3148925\nhelp.text", "note": "p4YQB", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 593, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 67, "source_unit": "https://translations.documentfoundation.org/api/units/45527527/?format=api", "priority": 100, "id": 45531173, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=57bab84c423bec1c", "url": "https://translations.documentfoundation.org/api/units/45531173/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:41:21.839326Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "Insert the formula <input>=DMIN(A1:E10; \"Distance\"; A12:E13)</input> into an empty cell elsewhere in the sheet to find the minimum distance in meters that any of Joe’s party guests travel to school. The value 150 is returned." ], "previous_source": "", "target": [ "" ], "id_hash": 4931777981835359673, "content_hash": 4931777981835359673, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3149161\nhelp.text", "note": "LrfjC", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 594, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 35, "source_unit": "https://translations.documentfoundation.org/api/units/45527528/?format=api", "priority": 100, "id": 45531174, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=c47131f1de63b5b9", "url": "https://translations.documentfoundation.org/api/units/45531174/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:41:21.840585Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_DBMITTELWERT\">DAVERAGE calculates the average of 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 in those cells are ignored." ], "previous_source": "", "target": [ "" ], "id_hash": -1578848825274792703, "content_hash": -1578848825274792703, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3166453\nhelp.text", "note": "Y7wdv", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 597, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 35, "source_unit": "https://translations.documentfoundation.org/api/units/45527530/?format=api", "priority": 100, "id": 45531176, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=6a16cd5bc7740501", "url": "https://translations.documentfoundation.org/api/units/45531176/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:41:21.843757Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "Returns a #DIV/0! 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": 7303987702708060116, "content_hash": 7303987702708060116, "location": "04060101.xhp", "context": "04060101.xhp\npar_id31615978739452\nhelp.text", "note": "87qxe", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 598, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 30, "source_unit": "https://translations.documentfoundation.org/api/units/45527531/?format=api", "priority": 100, "id": 45531177, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=e55cfa1e0fbc3fd4", "url": "https://translations.documentfoundation.org/api/units/45531177/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:41:21.844778Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?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": 6372245985782288987, "content_hash": 6372245985782288987, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3149104\nhelp.text", "note": "PcjTP", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 600, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 67, "source_unit": "https://translations.documentfoundation.org/api/units/45527532/?format=api", "priority": 100, "id": 45531178, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=d86ec3f663f6525b", "url": "https://translations.documentfoundation.org/api/units/45531178/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:41:21.846975Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "Insert the formula <input>=DAVERAGE(A1:E10; \"Distance\"; A12:E13)</input> into an empty cell elsewhere in the sheet to calculate the average distance in meters travelled to school by Joe’s party guests. The value 666.67 is returned." ], "previous_source": "", "target": [ "" ], "id_hash": 1814434218395281006, "content_hash": 1814434218395281006, "location": "04060101.xhp", "context": "04060101.xhp\npar_id201616368312277\nhelp.text", "note": "CjTGB", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 601, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 33, "source_unit": "https://translations.documentfoundation.org/api/units/45527533/?format=api", "priority": 100, "id": 45531179, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=992e2a4eefc3a66e", "url": "https://translations.documentfoundation.org/api/units/45531179/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:41:21.848052Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_DBPRODUKT\">DPRODUCT calculates the product 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": -6870910731368740162, "content_hash": -6870910731368740162, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3152879\nhelp.text", "note": "oJApo", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 604, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 38, "source_unit": "https://translations.documentfoundation.org/api/units/45527535/?format=api", "priority": 100, "id": 45531181, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=20a59f17ed58cabe", "url": "https://translations.documentfoundation.org/api/units/45531181/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:41:21.851251Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?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": -6088134275114650130, "content_hash": -6088134275114650130, "location": "04060101.xhp", "context": "04060101.xhp\npar_id741616180868336\nhelp.text", "note": "oUsZD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 605, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 25, "source_unit": "https://translations.documentfoundation.org/api/units/45527536/?format=api", "priority": 100, "id": 45531182, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=2b829a2212e935ee", "url": "https://translations.documentfoundation.org/api/units/45531182/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:41:21.852263Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?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 C13 which should contain \">0\" (this search criterion is intended to match all records in the database table)." ], "previous_source": "", "target": [ "" ], "id_hash": 6697853395288567308, "content_hash": 6697853395288567308, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3148986\nhelp.text", "note": "oGQtm", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 607, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 67, "source_unit": "https://translations.documentfoundation.org/api/units/45527537/?format=api", "priority": 100, "id": 45531183, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=dcf38e2d1fd1ae0c", "url": "https://translations.documentfoundation.org/api/units/45531183/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:41:21.854491Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "Insert the formula <input>=DPRODUCT(A1:E10; \"Age\"; A12:E13)</input> into an empty cell elsewhere in the sheet to calculate the product of the ages in years of Joe’s party guests. The value 279417600 is returned." ], "previous_source": "", "target": [ "" ], "id_hash": -4597042588880741787, "content_hash": -4597042588880741787, "location": "04060101.xhp", "context": "04060101.xhp\npar_id91616368981807\nhelp.text", "note": "iaoUA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 608, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 32, "source_unit": "https://translations.documentfoundation.org/api/units/45527538/?format=api", "priority": 100, "id": 45531184, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=4034061f206bda65", "url": "https://translations.documentfoundation.org/api/units/45531184/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:41:21.855544Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_DBSTDABW\">DSTDEV calculates the sample 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": -1613820941292791608, "content_hash": -1613820941292791608, "location": "04060101.xhp", "context": "04060101.xhp\npar_id3154605\nhelp.text", "note": "56CsG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 611, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 35, "source_unit": "https://translations.documentfoundation.org/api/units/45527540/?format=api", "priority": 100, "id": 45531186, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=699a8e677f2818c8", "url": "https://translations.documentfoundation.org/api/units/45531186/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:41:21.858697Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?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": 8749639485209474966, "content_hash": 8749639485209474966, "location": "04060101.xhp", "context": "04060101.xhp\npar_id121616181037440\nhelp.text", "note": "RACag", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 612, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 32, "source_unit": "https://translations.documentfoundation.org/api/units/45527541/?format=api", "priority": 100, "id": 45531187, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=f96cf6c114a47796", "url": "https://translations.documentfoundation.org/api/units/45531187/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:41:21.859704Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?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": -2977119669398935399, "content_hash": -2977119669398935399, "location": "04060101.xhp", "context": "04060101.xhp\npar_id931616181041535\nhelp.text", "note": "r6onB", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 613, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 25, "source_unit": "https://translations.documentfoundation.org/api/units/45527542/?format=api", "priority": 100, "id": 45531188, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=56af256f23a5e899", "url": "https://translations.documentfoundation.org/api/units/45531188/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:41:21.860758Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?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": 45531189, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=ad6c1edbcefa533a", "url": "https://translations.documentfoundation.org/api/units/45531189/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:41:21.862934Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?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": 45531190, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=b69189707dccd4b4", "url": "https://translations.documentfoundation.org/api/units/45531190/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:41:21.864030Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?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": 45531192, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=6d21019e89b8bc2b", "url": "https://translations.documentfoundation.org/api/units/45531192/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:41:21.867208Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?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": 45531193, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=313fae97d29c9536", "url": "https://translations.documentfoundation.org/api/units/45531193/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:41:21.868258Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?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": 45531194, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=53e20156eb928adc", "url": "https://translations.documentfoundation.org/api/units/45531194/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:41:21.870491Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?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": 45531195, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=37e61aa25e8ed741", "url": "https://translations.documentfoundation.org/api/units/45531195/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:41:21.871591Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?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": 45531197, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=1b8d0b575f95d9ec", "url": "https://translations.documentfoundation.org/api/units/45531197/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:41:21.874888Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?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": 45531198, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=5e5546fe7cd59fe6", "url": "https://translations.documentfoundation.org/api/units/45531198/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:41:21.875899Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?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": 45531199, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=d0961e787b22ecfa", "url": "https://translations.documentfoundation.org/api/units/45531199/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:41:21.878054Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?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": 45531200, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=9a4e2141ffde7ead", "url": "https://translations.documentfoundation.org/api/units/45531200/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:41:21.879120Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?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": 45531202, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=e6a9bc4b297ca126", "url": "https://translations.documentfoundation.org/api/units/45531202/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:41:21.882265Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?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": 45531203, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=7b068e55540d0d47", "url": "https://translations.documentfoundation.org/api/units/45531203/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:41:21.883281Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?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": 45531204, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=0f73041d96ae86ca", "url": "https://translations.documentfoundation.org/api/units/45531204/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:41:21.884282Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?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": 45531205, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=5970a51020c45333", "url": "https://translations.documentfoundation.org/api/units/45531205/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:41:21.886448Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?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": 45531206, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=529857e49590ac7e", "url": "https://translations.documentfoundation.org/api/units/45531206/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:41:21.887514Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?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": 45531208, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=825456687f6c23bd", "url": "https://translations.documentfoundation.org/api/units/45531208/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:41:21.890691Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?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": 45531209, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=cbf181a69638e02f", "url": "https://translations.documentfoundation.org/api/units/45531209/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:41:21.891703Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?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": 45531210, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=09d62ea2df703d5f", "url": "https://translations.documentfoundation.org/api/units/45531210/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:41:21.893889Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?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": 45531211, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=878cb41b317f0200", "url": "https://translations.documentfoundation.org/api/units/45531211/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:41:21.894951Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?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": 45548254, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=bf59d851532873ac", "url": "https://translations.documentfoundation.org/api/units/45548254/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-06T13:37:53.993432Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?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": 45548255, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=abea5dfe4ba909fa", "url": "https://translations.documentfoundation.org/api/units/45548255/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-06T13:37:53.995241Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?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": 45548257, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=2fa9f18091b79423", "url": "https://translations.documentfoundation.org/api/units/45548257/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-06T13:37:53.998365Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?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": 45548259, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=5831da84db2a36c3", "url": "https://translations.documentfoundation.org/api/units/45548259/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-06T13:37:54.002478Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?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": 45548260, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=c16db5de097c115c", "url": "https://translations.documentfoundation.org/api/units/45548260/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-06T13:37:54.004106Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?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": 45548261, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=2cb6a5212ba342be", "url": "https://translations.documentfoundation.org/api/units/45548261/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-06T13:37:54.005389Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?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": 45548262, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=7bd4d490d7290a45", "url": "https://translations.documentfoundation.org/api/units/45548262/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-06T13:37:54.006658Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?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": 7127, "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": 45549999, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=a7d47c06b6a2ef2b", "url": "https://translations.documentfoundation.org/api/units/45549999/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-12T10:32:00.826716Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?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": 7137, "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": 45550000, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=df042edfb8a95df8", "url": "https://translations.documentfoundation.org/api/units/45550000/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-12T10:32:00.837194Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?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": 7147, "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": 45550001, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=46e9e2c05d33093e", "url": "https://translations.documentfoundation.org/api/units/45550001/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-12T10:32:00.847521Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?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": 7157, "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": 45550002, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=6c91b5f78b26b8dd", "url": "https://translations.documentfoundation.org/api/units/45550002/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-12T10:32:00.858573Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?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": 7167, "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": 45550003, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=2f4ec46899730c53", "url": "https://translations.documentfoundation.org/api/units/45550003/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-12T10:32:00.867607Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?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": 7197, "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": 45550004, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=7db0c493a94dc8ce", "url": "https://translations.documentfoundation.org/api/units/45550004/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-12T10:32:00.893151Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?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": 45624302, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=448c973b8ede62a4", "url": "https://translations.documentfoundation.org/api/units/45624302/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-27T16:59:43.488403Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?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": 45624303, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=68d0e1a2263c0b5c", "url": "https://translations.documentfoundation.org/api/units/45624303/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-27T16:59:43.499021Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?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": 45624304, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=8a5b340eac4a5080", "url": "https://translations.documentfoundation.org/api/units/45624304/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-27T16:59:43.509207Z" } ] }{ "count": 8573, "next": "