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/hsb/units/?format=api&page=137
https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/units/?format=api&page=138", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/units/?format=api&page=136", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112359157, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=74359d01a18b5b97", "url": "https://translations.documentfoundation.org/api/units/112359157/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.890035Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112359158, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=6a0dc1df0ceff244", "url": "https://translations.documentfoundation.org/api/units/112359158/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.891695Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112359159, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=07d1215c14ed6e82", "url": "https://translations.documentfoundation.org/api/units/112359159/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.893460Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112359160, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=521b8ab51c7d809a", "url": "https://translations.documentfoundation.org/api/units/112359160/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.895091Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112359161, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=cbc6229228511b7e", "url": "https://translations.documentfoundation.org/api/units/112359161/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.896856Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112359162, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=8a6b55dd3fe2af81", "url": "https://translations.documentfoundation.org/api/units/112359162/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.898528Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112359163, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=33efdb506836b41c", "url": "https://translations.documentfoundation.org/api/units/112359163/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.899682Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112359164, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=9f3d7cb315edb56f", "url": "https://translations.documentfoundation.org/api/units/112359164/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.900651Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112359165, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=09a2bfb3798b08bb", "url": "https://translations.documentfoundation.org/api/units/112359165/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.901585Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112359166, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=9adbe0f322651569", "url": "https://translations.documentfoundation.org/api/units/112359166/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.902596Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112359167, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=53b4a79b4f79feb7", "url": "https://translations.documentfoundation.org/api/units/112359167/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.903574Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112359168, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=7ae384895a58609f", "url": "https://translations.documentfoundation.org/api/units/112359168/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.904592Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112359169, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=5a99c79763154754", "url": "https://translations.documentfoundation.org/api/units/112359169/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.905567Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112359170, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=3fa00122bdcec3f8", "url": "https://translations.documentfoundation.org/api/units/112359170/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.906559Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112359171, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=eaa29cb3b46733d3", "url": "https://translations.documentfoundation.org/api/units/112359171/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.907593Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112359172, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=075b92969dda2e53", "url": "https://translations.documentfoundation.org/api/units/112359172/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.908538Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112359173, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=59116990cc8b7e96", "url": "https://translations.documentfoundation.org/api/units/112359173/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.909510Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112359174, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=c1e915452cc2ac47", "url": "https://translations.documentfoundation.org/api/units/112359174/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.910524Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112359175, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=fee15fa2ee30b35d", "url": "https://translations.documentfoundation.org/api/units/112359175/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.911525Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112359176, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=dd8c25a2a7063d2e", "url": "https://translations.documentfoundation.org/api/units/112359176/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.912483Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112359177, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=df8923160663a500", "url": "https://translations.documentfoundation.org/api/units/112359177/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.913417Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112359178, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=b052dd67ff1ebedd", "url": "https://translations.documentfoundation.org/api/units/112359178/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.914368Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112359179, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=5f16c2ba8c6ac1e8", "url": "https://translations.documentfoundation.org/api/units/112359179/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.915332Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112359180, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=506f03a791a24ddb", "url": "https://translations.documentfoundation.org/api/units/112359180/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.916309Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112359181, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=62d4217063ae0638", "url": "https://translations.documentfoundation.org/api/units/112359181/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.917283Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112359182, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=f9f4454778acc979", "url": "https://translations.documentfoundation.org/api/units/112359182/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.918251Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112359183, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=3498d911193d17a7", "url": "https://translations.documentfoundation.org/api/units/112359183/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.919251Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112359184, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=442a9db6dc2c9a2a", "url": "https://translations.documentfoundation.org/api/units/112359184/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.920255Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112359185, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=886531111bc5c839", "url": "https://translations.documentfoundation.org/api/units/112359185/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.921194Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112359186, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=ecdaff4b6d2b1daf", "url": "https://translations.documentfoundation.org/api/units/112359186/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.922121Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112359187, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=d49e84221f6879b3", "url": "https://translations.documentfoundation.org/api/units/112359187/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.923066Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112359188, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=4060260bd5565837", "url": "https://translations.documentfoundation.org/api/units/112359188/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.924012Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112359189, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=208451cde2eed686", "url": "https://translations.documentfoundation.org/api/units/112359189/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.924957Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112359190, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=3a39f881a3a00876", "url": "https://translations.documentfoundation.org/api/units/112359190/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.925912Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112359191, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=5240a7495047b4ad", "url": "https://translations.documentfoundation.org/api/units/112359191/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.926912Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112359192, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=27207d39c33ee2b4", "url": "https://translations.documentfoundation.org/api/units/112359192/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.927889Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112359193, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=95d3a73597b517df", "url": "https://translations.documentfoundation.org/api/units/112359193/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.928849Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112359194, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=0bfcaab7a0e174c4", "url": "https://translations.documentfoundation.org/api/units/112359194/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.929811Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112359195, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=ee2d440db511f08a", "url": "https://translations.documentfoundation.org/api/units/112359195/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.930794Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112359196, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=0a1e89547dbda5ba", "url": "https://translations.documentfoundation.org/api/units/112359196/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.931779Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112359197, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=77953c459d35eb72", "url": "https://translations.documentfoundation.org/api/units/112359197/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.932738Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112359198, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=dcce32c0918deb43", "url": "https://translations.documentfoundation.org/api/units/112359198/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.933711Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112359199, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=ba7f7e9e778487a1", "url": "https://translations.documentfoundation.org/api/units/112359199/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.934677Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112359200, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=184a92a9a20dbf13", "url": "https://translations.documentfoundation.org/api/units/112359200/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.936005Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112359201, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=4944bfd6b44ef81f", "url": "https://translations.documentfoundation.org/api/units/112359201/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.937365Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112359202, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=7ccfbbd00ed1a428", "url": "https://translations.documentfoundation.org/api/units/112359202/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.938808Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112359203, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=7c185f69cc2f249e", "url": "https://translations.documentfoundation.org/api/units/112359203/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.939805Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112359204, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=e73ddb9691a9dbb5", "url": "https://translations.documentfoundation.org/api/units/112359204/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.940768Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112359205, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=9411a759c1d38ab3", "url": "https://translations.documentfoundation.org/api/units/112359205/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.941718Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112359206, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=ef351bc7425b714b", "url": "https://translations.documentfoundation.org/api/units/112359206/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.942676Z" } ] }{ "count": 8439, "next": "