Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-master/textscalc01/eo/units/?format=api&page=131
{ "count": 8628, "next": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/units/?format=api&page=132", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/units/?format=api&page=130", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 45530857, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=ad6c1edbcefa533a", "url": "https://translations.documentfoundation.org/api/units/45530857/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:40:39.190906Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 45530858, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=b69189707dccd4b4", "url": "https://translations.documentfoundation.org/api/units/45530858/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:40:39.192052Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 45530860, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=6d21019e89b8bc2b", "url": "https://translations.documentfoundation.org/api/units/45530860/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:40:39.195446Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 45530861, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=313fae97d29c9536", "url": "https://translations.documentfoundation.org/api/units/45530861/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:40:39.196535Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 45530862, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=53e20156eb928adc", "url": "https://translations.documentfoundation.org/api/units/45530862/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:40:39.198865Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 45530863, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=37e61aa25e8ed741", "url": "https://translations.documentfoundation.org/api/units/45530863/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:40:39.199992Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 45530865, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=1b8d0b575f95d9ec", "url": "https://translations.documentfoundation.org/api/units/45530865/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:40:39.203394Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 45530866, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=5e5546fe7cd59fe6", "url": "https://translations.documentfoundation.org/api/units/45530866/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:40:39.204483Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 45530867, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=d0961e787b22ecfa", "url": "https://translations.documentfoundation.org/api/units/45530867/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:40:39.206813Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 45530868, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=9a4e2141ffde7ead", "url": "https://translations.documentfoundation.org/api/units/45530868/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:40:39.207971Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 45530870, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=e6a9bc4b297ca126", "url": "https://translations.documentfoundation.org/api/units/45530870/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:40:39.211342Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 45530871, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=7b068e55540d0d47", "url": "https://translations.documentfoundation.org/api/units/45530871/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:40:39.212430Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 45530872, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=0f73041d96ae86ca", "url": "https://translations.documentfoundation.org/api/units/45530872/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:40:39.213494Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 45530873, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=5970a51020c45333", "url": "https://translations.documentfoundation.org/api/units/45530873/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:40:39.215796Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 45530874, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=529857e49590ac7e", "url": "https://translations.documentfoundation.org/api/units/45530874/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:40:39.216909Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 45530876, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=825456687f6c23bd", "url": "https://translations.documentfoundation.org/api/units/45530876/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:40:39.220307Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 45530877, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=cbf181a69638e02f", "url": "https://translations.documentfoundation.org/api/units/45530877/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:40:39.221394Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 45530878, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=09d62ea2df703d5f", "url": "https://translations.documentfoundation.org/api/units/45530878/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:40:39.223736Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 45530879, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=878cb41b317f0200", "url": "https://translations.documentfoundation.org/api/units/45530879/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-03-29T15:40:39.224869Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 45548225, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=bf59d851532873ac", "url": "https://translations.documentfoundation.org/api/units/45548225/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-06T13:37:25.886246Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 45548226, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=abea5dfe4ba909fa", "url": "https://translations.documentfoundation.org/api/units/45548226/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-06T13:37:25.894300Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 45548228, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=2fa9f18091b79423", "url": "https://translations.documentfoundation.org/api/units/45548228/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-06T13:37:25.905496Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 45548230, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=5831da84db2a36c3", "url": "https://translations.documentfoundation.org/api/units/45548230/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-06T13:37:25.913095Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 45548231, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=c16db5de097c115c", "url": "https://translations.documentfoundation.org/api/units/45548231/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-06T13:37:25.917278Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 45548232, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=2cb6a5212ba342be", "url": "https://translations.documentfoundation.org/api/units/45548232/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-06T13:37:25.918838Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 45548233, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=7bd4d490d7290a45", "url": "https://translations.documentfoundation.org/api/units/45548233/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-06T13:37:25.921355Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 45549979, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=a7d47c06b6a2ef2b", "url": "https://translations.documentfoundation.org/api/units/45549979/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-12T10:31:48.820925Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 45549980, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=df042edfb8a95df8", "url": "https://translations.documentfoundation.org/api/units/45549980/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-12T10:31:48.831585Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 45549981, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=46e9e2c05d33093e", "url": "https://translations.documentfoundation.org/api/units/45549981/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-12T10:31:48.842955Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 45549982, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=6c91b5f78b26b8dd", "url": "https://translations.documentfoundation.org/api/units/45549982/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-12T10:31:48.853687Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 45549983, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=2f4ec46899730c53", "url": "https://translations.documentfoundation.org/api/units/45549983/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-12T10:31:48.864535Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 45549984, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=7db0c493a94dc8ce", "url": "https://translations.documentfoundation.org/api/units/45549984/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-12T10:31:48.883960Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 45624168, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=448c973b8ede62a4", "url": "https://translations.documentfoundation.org/api/units/45624168/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-27T16:59:05.973478Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 45624169, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=68d0e1a2263c0b5c", "url": "https://translations.documentfoundation.org/api/units/45624169/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-27T16:59:05.984500Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 45624170, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=8a5b340eac4a5080", "url": "https://translations.documentfoundation.org/api/units/45624170/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-27T16:59:05.994795Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 45624171, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=d434077aa38f5102", "url": "https://translations.documentfoundation.org/api/units/45624171/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-27T16:59:06.007501Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 45624172, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=1bacb52e5f487efd", "url": "https://translations.documentfoundation.org/api/units/45624172/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-27T16:59:06.017880Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 45624173, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=582a55ae15aa0029", "url": "https://translations.documentfoundation.org/api/units/45624173/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-27T16:59:06.028410Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 45624174, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=f69df7bb83863f39", "url": "https://translations.documentfoundation.org/api/units/45624174/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-27T16:59:06.039383Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 45624175, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=f657f04bff4d6821", "url": "https://translations.documentfoundation.org/api/units/45624175/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-27T16:59:06.049231Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 45624176, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=aae2eb077364a2f5", "url": "https://translations.documentfoundation.org/api/units/45624176/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-27T16:59:06.061200Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 45624177, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=87eda348fdec6a3e", "url": "https://translations.documentfoundation.org/api/units/45624177/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-27T16:59:06.072926Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "<bookmark_value>DVAR function</bookmark_value><bookmark_value>variances;based on samples</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": -8976625786291172676, "content_hash": -8976625786291172676, "location": "04060101.xhp", "context": "04060101.xhp\nbm_id3155614\nhelp.text", "note": "YBFb7", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 631, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/45612159/?format=api", "priority": 100, "id": 45624178, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=036c9e685680cabc", "url": "https://translations.documentfoundation.org/api/units/45624178/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-27T16:59:06.084323Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "<bookmark_value>DVARP function</bookmark_value><bookmark_value>variances;based on populations</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": -1507646871452132173, "content_hash": -1507646871452132173, "location": "04060101.xhp", "context": "04060101.xhp\nbm_id3153880\nhelp.text", "note": "7FWS4", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 639, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/45612160/?format=api", "priority": 100, "id": 45624179, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=6b13c328845ddcb3", "url": "https://translations.documentfoundation.org/api/units/45624179/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-27T16:59:06.095311Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": [ "" ], "id_hash": 1344072553765718025, "content_hash": 1344072553765718025, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3149984\nhelp.text", "note": "qFEgu", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 45624180, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=92a71addcf8ec809", "url": "https://translations.documentfoundation.org/api/units/45624180/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-27T16:59:12.341316Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 45624181, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=6c836b05aa12b8de", "url": "https://translations.documentfoundation.org/api/units/45624181/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-27T16:59:12.342643Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 45624182, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=471770750a01cf0f", "url": "https://translations.documentfoundation.org/api/units/45624182/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-27T16:59:12.343736Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": [ "" ], "id_hash": -5293601005237555600, "content_hash": -5293601005237555600, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3151208\nhelp.text", "note": "qKRbD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 45624183, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=368959eeb42a2e70", "url": "https://translations.documentfoundation.org/api/units/45624183/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-27T16:59:12.347625Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?format=api", "source": [ "MATCH(Search; LookupArray [; Type])" ], "previous_source": "", "target": [ "" ], "id_hash": 3179497475035933733, "content_hash": 3179497475035933733, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3159152\nhelp.text", "note": "AKi9E", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "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": 45624184, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=ac1fd81b9bc4ac25", "url": "https://translations.documentfoundation.org/api/units/45624184/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-27T16:59:12.378653Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/eo/?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": 45624185, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/eo/?checksum=cf41430e810bb4e7", "url": "https://translations.documentfoundation.org/api/units/45624185/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2021-04-27T16:59:12.379783Z" } ] }