Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-24-2/textscalc01/iu/units/?format=api&page=137
{ "count": 8439, "next": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/units/?format=api&page=138", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/units/?format=api&page=136", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<item type=\"input\">=COUNTIFS(A2:A6;\"pen.*\";B2:B6;\"<\"&MAX(B2:B6))</item>" ], "previous_source": "", "target": [ "" ], "id_hash": -849600324358677609, "content_hash": -849600324358677609, "location": "func_countifs.xhp", "context": "func_countifs.xhp\npar_id267603146513224\nhelp.text", "note": "jdWB5", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6801, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111156081/?format=api", "priority": 100, "id": 112435108, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=74359d01a18b5b97", "url": "https://translations.documentfoundation.org/api/units/112435108/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:23.563731Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "Counts the amount of rows that correspond to all cells of the A2:A6 range starting with \"pen\" and to all cells of the B2:B6 range with exception of its maximum. Returns 1, because only second row meets all criteria." ], "previous_source": "", "target": [ "" ], "id_hash": -1581394730398256572, "content_hash": -1581394730398256572, "location": "func_countifs.xhp", "context": "func_countifs.xhp\npar_id111252614832220\nhelp.text", "note": "L6af2", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6802, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 39, "source_unit": "https://translations.documentfoundation.org/api/units/111156126/?format=api", "priority": 100, "id": 112435109, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=6a0dc1df0ceff244", "url": "https://translations.documentfoundation.org/api/units/112435109/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:23.564797Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "Reference to a cell as a criterion" ], "previous_source": "", "target": [ "" ], "id_hash": -8660103929084940670, "content_hash": -8660103929084940670, "location": "func_countifs.xhp", "context": "func_countifs.xhp\nhd_id212582362610399\nhelp.text", "note": "rG36d", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6803, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/111156168/?format=api", "priority": 100, "id": 112435110, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=07d1215c14ed6e82", "url": "https://translations.documentfoundation.org/api/units/112435110/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:23.565865Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "If you need to change a criterion easily, you may want to specify it in a separate cell and use a reference to this cell in the condition of the COUNTIFS function. For example, the above function can be rewritten as follows:" ], "previous_source": "", "target": [ "" ], "id_hash": -3306896990901796710, "content_hash": -3306896990901796710, "location": "func_countifs.xhp", "context": "func_countifs.xhp\npar_id3245551524846\nhelp.text", "note": "ABwGC", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6804, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 42, "source_unit": "https://translations.documentfoundation.org/api/units/111156211/?format=api", "priority": 100, "id": 112435111, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=521b8ab51c7d809a", "url": "https://translations.documentfoundation.org/api/units/112435111/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:23.566841Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<item type=\"input\">=COUNTIFS(A2:A6;E2&\".*\";B2:B6;\"<\"&MAX(B2:B6))</item>" ], "previous_source": "", "target": [ "" ], "id_hash": 5460089609370278782, "content_hash": 5460089609370278782, "location": "func_countifs.xhp", "context": "func_countifs.xhp\npar_id109501907712434\nhelp.text", "note": "3TTwe", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6805, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111156262/?format=api", "priority": 100, "id": 112435112, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=cbc6229228511b7e", "url": "https://translations.documentfoundation.org/api/units/112435112/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:23.567881Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "If E2 = pen, the function returns 1, because the link to the cell is substituted with its content and it works as a function above." ], "previous_source": "", "target": [ "" ], "id_hash": 750788171635273601, "content_hash": 750788171635273601, "location": "func_countifs.xhp", "context": "func_countifs.xhp\npar_id738533068520\nhelp.text", "note": "CNQBL", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6806, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/111156312/?format=api", "priority": 100, "id": 112435113, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=8a6b55dd3fe2af81", "url": "https://translations.documentfoundation.org/api/units/112435113/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:23.568860Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/COUNTIFS\">COUNTIFS wiki page</link>." ], "previous_source": "", "target": [ "" ], "id_hash": -5480921083094322148, "content_hash": -5480921083094322148, "location": "func_countifs.xhp", "context": "func_countifs.xhp\npar_id131677016670241\nhelp.text", "note": "UXGKC", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6807, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/111156367/?format=api", "priority": 100, "id": 112435114, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=33efdb506836b41c", "url": "https://translations.documentfoundation.org/api/units/112435114/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:23.569856Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "DATE" ], "previous_source": "", "target": [ "" ], "id_hash": 2251092497364006255, "content_hash": 2251092497364006255, "location": "func_date.xhp", "context": "func_date.xhp\ntit\nhelp.text", "note": "GW3GV", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6808, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/111156415/?format=api", "priority": 100, "id": 112435115, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=9f3d7cb315edb56f", "url": "https://translations.documentfoundation.org/api/units/112435115/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:23.570845Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<bookmark_value>DATE function</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": -8529043966727092037, "content_hash": -8529043966727092037, "location": "func_date.xhp", "context": "func_date.xhp\nbm_id3155511\nhelp.text", "note": "xCZGR", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6809, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111156442/?format=api", "priority": 100, "id": 112435116, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=09a2bfb3798b08bb", "url": "https://translations.documentfoundation.org/api/units/112435116/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:23.571791Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<variable id=\"date\"><link href=\"text/scalc/01/func_date.xhp\">DATE</link></variable>" ], "previous_source": "", "target": [ "" ], "id_hash": 1935387799744484713, "content_hash": 1935387799744484713, "location": "func_date.xhp", "context": "func_date.xhp\nhd_id3155511\nhelp.text", "note": "TioqL", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6810, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111156468/?format=api", "priority": 100, "id": 112435117, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=9adbe0f322651569", "url": "https://translations.documentfoundation.org/api/units/112435117/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:23.572750Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_DATUM\">This function calculates a date specified by year, month, day and displays it in the cell's formatting.</ahelp> The default format of a cell containing the DATE function is the date format, but you can format the cells with any other number format." ], "previous_source": "", "target": [ "" ], "id_hash": -3191741950403674441, "content_hash": -3191741950403674441, "location": "func_date.xhp", "context": "func_date.xhp\npar_id3153551\nhelp.text", "note": "Wa2yU", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6811, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 43, "source_unit": "https://translations.documentfoundation.org/api/units/111156510/?format=api", "priority": 100, "id": 112435118, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=53b4a79b4f79feb7", "url": "https://translations.documentfoundation.org/api/units/112435118/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:23.573699Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "DATE(Year; Month; Day)" ], "previous_source": "", "target": [ "" ], "id_hash": -368305019053121377, "content_hash": -368305019053121377, "location": "func_date.xhp", "context": "func_date.xhp\npar_id3150474\nhelp.text", "note": "wCGHA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6812, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111156560/?format=api", "priority": 100, "id": 112435119, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=7ae384895a58609f", "url": "https://translations.documentfoundation.org/api/units/112435119/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:23.574735Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<emph>Year</emph> is an integer between 1583 and 9957 or between 0 and 99." ], "previous_source": "", "target": [ "" ], "id_hash": -2694903448988203180, "content_hash": -2694903448988203180, "location": "func_date.xhp", "context": "func_date.xhp\npar_id3152815\nhelp.text", "note": "zExSG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6813, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/111156631/?format=api", "priority": 100, "id": 112435120, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=5a99c79763154754", "url": "https://translations.documentfoundation.org/api/units/112435120/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:23.575738Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "In <switchinline select=\"sys\"><caseinline select=\"MAC\"><item type=\"menuitem\">%PRODUCTNAME - Preferences</item></caseinline><defaultinline><item type=\"menuitem\">Tools - Options</item></defaultinline></switchinline><item type=\"menuitem\"> - $[officename] - General </item>you can set from which year a two-digit number entry is recognized as 20xx." ], "previous_source": "", "target": [ "" ], "id_hash": -4638706367466650632, "content_hash": -4638706367466650632, "location": "func_date.xhp", "context": "func_date.xhp\npar_id3153222\nhelp.text", "note": "WVjaD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6814, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/111156684/?format=api", "priority": 100, "id": 112435121, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=3fa00122bdcec3f8", "url": "https://translations.documentfoundation.org/api/units/112435121/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:23.576723Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<emph>Month</emph> is an integer indicating the month." ], "previous_source": "", "target": [ "" ], "id_hash": 7683876209887228883, "content_hash": 7683876209887228883, "location": "func_date.xhp", "context": "func_date.xhp\npar_id3155817\nhelp.text", "note": "uuZQH", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6815, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/111156727/?format=api", "priority": 100, "id": 112435122, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=eaa29cb3b46733d3", "url": "https://translations.documentfoundation.org/api/units/112435122/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:23.577742Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<emph>Day</emph> is an integer indicating the day of the month." ], "previous_source": "", "target": [ "" ], "id_hash": -8693193480117539245, "content_hash": -8693193480117539245, "location": "func_date.xhp", "context": "func_date.xhp\npar_id3153183\nhelp.text", "note": "gKdnj", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6816, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/111156799/?format=api", "priority": 100, "id": 112435123, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=075b92969dda2e53", "url": "https://translations.documentfoundation.org/api/units/112435123/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:23.578690Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "If the values for month and day are out of bounds, they are carried over to the next digit. If you enter <item type=\"input\">=DATE(00;12;31)</item> the result will be 2000-12-31. If, on the other hand, you enter <item type=\"input\">=DATE(00;13;31)</item> the result will be 2001-01-31." ], "previous_source": "", "target": [ "" ], "id_hash": -2805345022247207274, "content_hash": -2805345022247207274, "location": "func_date.xhp", "context": "func_date.xhp\npar_id3156260\nhelp.text", "note": "qr3Qv", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6817, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 43, "source_unit": "https://translations.documentfoundation.org/api/units/111156831/?format=api", "priority": 100, "id": 112435124, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=59116990cc8b7e96", "url": "https://translations.documentfoundation.org/api/units/112435124/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:23.579680Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<item type=\"input\">=DATE(00;1;31)</item> yields 1/31/00 if the cell format setting is MM/DD/YY." ], "previous_source": "", "target": [ "" ], "id_hash": 4749350668886780999, "content_hash": 4749350668886780999, "location": "func_date.xhp", "context": "func_date.xhp\npar_id3152589\nhelp.text", "note": "8E7EB", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6818, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/111156861/?format=api", "priority": 100, "id": 112435125, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=c1e915452cc2ac47", "url": "https://translations.documentfoundation.org/api/units/112435125/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:23.580697Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/DATE\">DATE wiki page</link>." ], "previous_source": "", "target": [ "" ], "id_hash": 9142693871924327261, "content_hash": 9142693871924327261, "location": "func_date.xhp", "context": "func_date.xhp\npar_id701677016652715\nhelp.text", "note": "E6eJP", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6819, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/111156895/?format=api", "priority": 100, "id": 112435126, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=fee15fa2ee30b35d", "url": "https://translations.documentfoundation.org/api/units/112435126/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:23.581687Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "DATEDIF" ], "previous_source": "", "target": [ "" ], "id_hash": 6740804122783923502, "content_hash": 6740804122783923502, "location": "func_datedif.xhp", "context": "func_datedif.xhp\ntit\nhelp.text", "note": "pCLUK", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6820, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/111156920/?format=api", "priority": 100, "id": 112435127, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=dd8c25a2a7063d2e", "url": "https://translations.documentfoundation.org/api/units/112435127/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:23.582649Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<bookmark_value>DATEDIF function</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": 6884072082915960064, "content_hash": 6884072082915960064, "location": "func_datedif.xhp", "context": "func_datedif.xhp\nbm_id3155511\nhelp.text", "note": "kaPiN", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6821, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111156992/?format=api", "priority": 100, "id": 112435128, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=df8923160663a500", "url": "https://translations.documentfoundation.org/api/units/112435128/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:23.583593Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<variable id=\"datedif\"><link href=\"text/scalc/01/func_datedif.xhp\">DATEDIF</link></variable>" ], "previous_source": "", "target": [ "" ], "id_hash": 3482088900642389725, "content_hash": 3482088900642389725, "location": "func_datedif.xhp", "context": "func_datedif.xhp\nhd_id3155511\nhelp.text", "note": "M9yvp", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6822, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111157061/?format=api", "priority": 100, "id": 112435129, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=b052dd67ff1ebedd", "url": "https://translations.documentfoundation.org/api/units/112435129/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:23.584563Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_DATEDIF\">This function returns the number of whole days, months or years between Start date and End date.</ahelp>" ], "previous_source": "", "target": [ "" ], "id_hash": -2371494047288475160, "content_hash": -2371494047288475160, "location": "func_datedif.xhp", "context": "func_datedif.xhp\npar_id3153551\nhelp.text", "note": "mf9mw", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6823, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/111157100/?format=api", "priority": 100, "id": 112435130, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=5f16c2ba8c6ac1e8", "url": "https://translations.documentfoundation.org/api/units/112435130/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:23.585525Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<input>DATEDIF(Start date; End date; Interval)</input>" ], "previous_source": "", "target": [ "" ], "id_hash": -3427516773167903269, "content_hash": -3427516773167903269, "location": "func_datedif.xhp", "context": "func_datedif.xhp\npar_id531642776283977\nhelp.text", "note": "zRWUX", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6824, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/111157126/?format=api", "priority": 100, "id": 112435131, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=506f03a791a24ddb", "url": "https://translations.documentfoundation.org/api/units/112435131/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:23.586501Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<emph>Start date</emph> is the date from when the calculation is carried out." ], "previous_source": "", "target": [ "" ], "id_hash": -2102018359482776008, "content_hash": -2102018359482776008, "location": "func_datedif.xhp", "context": "func_datedif.xhp\npar_id3152815\nhelp.text", "note": "CMjse", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6825, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/111157154/?format=api", "priority": 100, "id": 112435132, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=62d4217063ae0638", "url": "https://translations.documentfoundation.org/api/units/112435132/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:23.587462Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<emph>End date</emph> is the date until the calculation is carried out. End date must be later, than Start date." ], "previous_source": "", "target": [ "" ], "id_hash": 8787724946176264569, "content_hash": 8787724946176264569, "location": "func_datedif.xhp", "context": "func_datedif.xhp\npar_id3155817\nhelp.text", "note": "HbrrC", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6826, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/111157218/?format=api", "priority": 100, "id": 112435133, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=f9f4454778acc979", "url": "https://translations.documentfoundation.org/api/units/112435133/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:23.588428Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<emph>Interval</emph> is a string that determines how the difference will be calculated. Possible values are \"d\", \"m\", \"y\", \"ym\", \"md\" or \"yd\" regardless of the current language settings." ], "previous_source": "", "target": [ "" ], "id_hash": -5433354282961397849, "content_hash": -5433354282961397849, "location": "func_datedif.xhp", "context": "func_datedif.xhp\npar_id3153183\nhelp.text", "note": "PZGXK", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6827, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 28, "source_unit": "https://translations.documentfoundation.org/api/units/111157258/?format=api", "priority": 100, "id": 112435134, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=3498d911193d17a7", "url": "https://translations.documentfoundation.org/api/units/112435134/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:23.589427Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "Value for \"Interval\"" ], "previous_source": "", "target": [ "" ], "id_hash": -4311460284550309334, "content_hash": -4311460284550309334, "location": "func_datedif.xhp", "context": "func_datedif.xhp\npar_id5735953\nhelp.text", "note": "Lxgdp", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6828, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111157288/?format=api", "priority": 100, "id": 112435135, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=442a9db6dc2c9a2a", "url": "https://translations.documentfoundation.org/api/units/112435135/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:23.590986Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "Return value" ], "previous_source": "", "target": [ "" ], "id_hash": 604943674501351481, "content_hash": 604943674501351481, "location": "func_datedif.xhp", "context": "func_datedif.xhp\npar_id8360850\nhelp.text", "note": "UBcKr", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6829, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111157325/?format=api", "priority": 100, "id": 112435136, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=886531111bc5c839", "url": "https://translations.documentfoundation.org/api/units/112435136/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:23.591946Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "Number of whole days between Start date and End date." ], "previous_source": "", "target": [ "" ], "id_hash": 7843862400438312367, "content_hash": 7843862400438312367, "location": "func_datedif.xhp", "context": "func_datedif.xhp\npar_id908841\nhelp.text", "note": "iTUCH", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6830, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/111157358/?format=api", "priority": 100, "id": 112435137, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=ecdaff4b6d2b1daf", "url": "https://translations.documentfoundation.org/api/units/112435137/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:23.592888Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "Number of whole months between Start date and End date." ], "previous_source": "", "target": [ "" ], "id_hash": 6097456227596925363, "content_hash": 6097456227596925363, "location": "func_datedif.xhp", "context": "func_datedif.xhp\npar_id9841608\nhelp.text", "note": "KTzdL", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6831, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/111157365/?format=api", "priority": 100, "id": 112435138, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=d49e84221f6879b3", "url": "https://translations.documentfoundation.org/api/units/112435138/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:23.593830Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "Number of whole years between Start date and End date." ], "previous_source": "", "target": [ "" ], "id_hash": -4584622588397463497, "content_hash": -4584622588397463497, "location": "func_datedif.xhp", "context": "func_datedif.xhp\npar_id2136295\nhelp.text", "note": "jMGKG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6832, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/111157411/?format=api", "priority": 100, "id": 112435139, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=4060260bd5565837", "url": "https://translations.documentfoundation.org/api/units/112435139/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:23.594787Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "Number of whole months when subtracting years from the difference of Start date and End date." ], "previous_source": "", "target": [ "" ], "id_hash": -6880284385997826426, "content_hash": -6880284385997826426, "location": "func_datedif.xhp", "context": "func_datedif.xhp\npar_id4186223\nhelp.text", "note": "8tDzh", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6833, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/111157466/?format=api", "priority": 100, "id": 112435140, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=208451cde2eed686", "url": "https://translations.documentfoundation.org/api/units/112435140/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:23.595750Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "Number of whole days when subtracting years and months from the difference of Start date and End date." ], "previous_source": "", "target": [ "" ], "id_hash": -5027714273302804362, "content_hash": -5027714273302804362, "location": "func_datedif.xhp", "context": "func_datedif.xhp\npar_id1491134\nhelp.text", "note": "jShMp", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6834, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/111157500/?format=api", "priority": 100, "id": 112435141, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=3a39f881a3a00876", "url": "https://translations.documentfoundation.org/api/units/112435141/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:23.596709Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "Number of whole days when subtracting years from the difference of Start date and End date." ], "previous_source": "", "target": [ "" ], "id_hash": -3296450993913875283, "content_hash": -3296450993913875283, "location": "func_datedif.xhp", "context": "func_datedif.xhp\npar_id1591134\nhelp.text", "note": "9uGY2", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6835, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/111157532/?format=api", "priority": 100, "id": 112435142, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=5240a7495047b4ad", "url": "https://translations.documentfoundation.org/api/units/112435142/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:23.597684Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "Birthday calculation. A man was born on 1974-04-17. Today is 2012-06-13." ], "previous_source": "", "target": [ "" ], "id_hash": -6403980983078559052, "content_hash": -6403980983078559052, "location": "func_datedif.xhp", "context": "func_datedif.xhp\npar_id3152589\nhelp.text", "note": "Pc57T", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6836, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/111157584/?format=api", "priority": 100, "id": 112435143, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=27207d39c33ee2b4", "url": "https://translations.documentfoundation.org/api/units/112435143/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:23.598651Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<item type=\"input\">=DATEDIF(\"1974-04-17\";\"2012-06-13\";\"y\")</item> yields 38." ], "previous_source": "", "target": [ "" ], "id_hash": 1572784543502768095, "content_hash": 1572784543502768095, "location": "func_datedif.xhp", "context": "func_datedif.xhp\npar_id3252589\nhelp.text", "note": "jbcJE", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6837, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/111157617/?format=api", "priority": 100, "id": 112435144, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=95d3a73597b517df", "url": "https://translations.documentfoundation.org/api/units/112435144/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:23.599633Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<item type=\"input\">=DATEDIF(\"1974-04-17\";\"2012-06-13\";\"ym\")</item> yields 1." ], "previous_source": "", "target": [ "" ], "id_hash": -8359619102651616060, "content_hash": -8359619102651616060, "location": "func_datedif.xhp", "context": "func_datedif.xhp\npar_id451535132395328\nhelp.text", "note": "k75FH", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6838, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/111157664/?format=api", "priority": 100, "id": 112435145, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=0bfcaab7a0e174c4", "url": "https://translations.documentfoundation.org/api/units/112435145/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:23.600606Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<item type=\"input\">=DATEDIF(\"1974-04-17\";\"2012-06-13\";\"md\")</item> yields 27." ], "previous_source": "", "target": [ "" ], "id_hash": 7939076543787167882, "content_hash": 7939076543787167882, "location": "func_datedif.xhp", "context": "func_datedif.xhp\npar_id611535132402642\nhelp.text", "note": "3dbKg", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6839, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/111157704/?format=api", "priority": 100, "id": 112435146, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=ee2d440db511f08a", "url": "https://translations.documentfoundation.org/api/units/112435146/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:23.601594Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "So he is 38 years, 1 month and 27 days old." ], "previous_source": "", "target": [ "" ], "id_hash": -8494200851194337862, "content_hash": -8494200851194337862, "location": "func_datedif.xhp", "context": "func_datedif.xhp\npar_id511535132411940\nhelp.text", "note": "LA2Rw", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6840, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/111157735/?format=api", "priority": 100, "id": 112435147, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=0a1e89547dbda5ba", "url": "https://translations.documentfoundation.org/api/units/112435147/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:23.602554Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<item type=\"input\">=DATEDIF(DATE(1974,4,17);\"2012-06-13\";\"m\")</item> yields 457, he has been living for 457 months." ], "previous_source": "", "target": [ "" ], "id_hash": -606512305123497102, "content_hash": -606512305123497102, "location": "func_datedif.xhp", "context": "func_datedif.xhp\npar_id3352589\nhelp.text", "note": "yuWBU", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6841, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/111157751/?format=api", "priority": 100, "id": 112435148, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=77953c459d35eb72", "url": "https://translations.documentfoundation.org/api/units/112435148/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:23.603530Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<item type=\"input\">=DATEDIF(\"1974-04-17\";\"2012-06-13\";\"d\")</item> yields 13937, he has been living for 13937 days." ], "previous_source": "", "target": [ "" ], "id_hash": 6687338299348872003, "content_hash": 6687338299348872003, "location": "func_datedif.xhp", "context": "func_datedif.xhp\npar_id3452589\nhelp.text", "note": "tFAxV", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6842, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/111157771/?format=api", "priority": 100, "id": 112435149, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=dcce32c0918deb43", "url": "https://translations.documentfoundation.org/api/units/112435149/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:23.604527Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<item type=\"input\">=DATEDIF(\"1974-04-17\";DATE(2012;06;13);\"yd\")</item> yields 57, his birthday was 57 days ago." ], "previous_source": "", "target": [ "" ], "id_hash": 4215226995317180321, "content_hash": 4215226995317180321, "location": "func_datedif.xhp", "context": "func_datedif.xhp\npar_id3752589\nhelp.text", "note": "C8DrL", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6843, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/111157780/?format=api", "priority": 100, "id": 112435150, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=ba7f7e9e778487a1", "url": "https://translations.documentfoundation.org/api/units/112435150/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.130377Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/DATEDIF\">DATEDIF wiki page</link>." ], "previous_source": "", "target": [ "" ], "id_hash": -7472999374401978605, "content_hash": -7472999374401978605, "location": "func_datedif.xhp", "context": "func_datedif.xhp\npar_id311677016639702\nhelp.text", "note": "WrGbq", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6844, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/111157801/?format=api", "priority": 100, "id": 112435151, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=184a92a9a20dbf13", "url": "https://translations.documentfoundation.org/api/units/112435151/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.132835Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "DATEVALUE" ], "previous_source": "", "target": [ "" ], "id_hash": -3943816444800731105, "content_hash": -3943816444800731105, "location": "func_datevalue.xhp", "context": "func_datevalue.xhp\ntit\nhelp.text", "note": "7eFQV", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6845, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/111157821/?format=api", "priority": 100, "id": 112435152, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=4944bfd6b44ef81f", "url": "https://translations.documentfoundation.org/api/units/112435152/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.134061Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<bookmark_value>DATEVALUE function</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": -229758553696394200, "content_hash": -229758553696394200, "location": "func_datevalue.xhp", "context": "func_datevalue.xhp\nbm_id3145621\nhelp.text", "note": "s5yZC", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6846, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111157850/?format=api", "priority": 100, "id": 112435153, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=7ccfbbd00ed1a428", "url": "https://translations.documentfoundation.org/api/units/112435153/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.135092Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<variable id=\"datevalue\"><link href=\"text/scalc/01/func_datevalue.xhp\">DATEVALUE</link></variable>" ], "previous_source": "", "target": [ "" ], "id_hash": -281370068708809570, "content_hash": -281370068708809570, "location": "func_datevalue.xhp", "context": "func_datevalue.xhp\nhd_id3145621\nhelp.text", "note": "e4YFG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6847, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111157876/?format=api", "priority": 100, "id": 112435154, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=7c185f69cc2f249e", "url": "https://translations.documentfoundation.org/api/units/112435154/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.136024Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_DATWERT\">Returns the internal date number for text in quotes.</ahelp>" ], "previous_source": "", "target": [ "" ], "id_hash": 7439343599221332917, "content_hash": 7439343599221332917, "location": "func_datevalue.xhp", "context": "func_datevalue.xhp\npar_id3145087\nhelp.text", "note": "kVQP6", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6848, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/111157908/?format=api", "priority": 100, "id": 112435155, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=e73ddb9691a9dbb5", "url": "https://translations.documentfoundation.org/api/units/112435155/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.136938Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "The internal date number is returned as a number. The number is determined by the date system that is used by $[officename] to calculate dates." ], "previous_source": "", "target": [ "" ], "id_hash": 1446120959308434099, "content_hash": 1446120959308434099, "location": "func_datevalue.xhp", "context": "func_datevalue.xhp\npar_id3149281\nhelp.text", "note": "z3vTn", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6849, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 25, "source_unit": "https://translations.documentfoundation.org/api/units/111157944/?format=api", "priority": 100, "id": 112435156, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=9411a759c1d38ab3", "url": "https://translations.documentfoundation.org/api/units/112435156/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.137907Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "If the text string also includes a time value, DATEVALUE only returns the integer part of the conversion." ], "previous_source": "", "target": [ "" ], "id_hash": 8013341654601396555, "content_hash": 8013341654601396555, "location": "func_datevalue.xhp", "context": "func_datevalue.xhp\npar_id0119200903491982\nhelp.text", "note": "cqHjd", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6850, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/111157958/?format=api", "priority": 100, "id": 112435157, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=ef351bc7425b714b", "url": "https://translations.documentfoundation.org/api/units/112435157/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.139024Z" } ] }