Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-7-6/textscalc01/ast/units/?format=api&page=138
{ "count": 8352, "next": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/units/?format=api&page=139", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/units/?format=api&page=137", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<item type=\"input\">=ERROR.TYPE(A3)</item>" ], "previous_source": "", "target": [ "" ], "id_hash": 245496308746655742, "content_hash": 245496308746655742, "location": "func_error_type.xhp", "context": "func_error_type.xhp\npar_id1047088636291\nhelp.text", "note": "MxaAn", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6851, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99312631/?format=api", "priority": 100, "id": 99529187, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=83682d97948397fe", "url": "https://translations.documentfoundation.org/api/units/99529187/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:35.810409Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "If A3 contains an expression equivalent to the division by zero, the function returns 2, because 2 is the index number of the error value #DIV/0!" ], "previous_source": "", "target": [ "" ], "id_hash": 1565786668579561837, "content_hash": 1565786668579561837, "location": "func_error_type.xhp", "context": "func_error_type.xhp\npar_id24308515918391\nhelp.text", "note": "8UJpP", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6852, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/99312707/?format=api", "priority": 100, "id": 99529189, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=95bacaaddeba216d", "url": "https://translations.documentfoundation.org/api/units/99529189/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:35.812500Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "More advanced way" ], "previous_source": "", "target": [ "" ], "id_hash": 1965305299661138367, "content_hash": 1965305299661138367, "location": "func_error_type.xhp", "context": "func_error_type.xhp\nhd_id9842206115046\nhelp.text", "note": "NEmkr", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6853, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99312774/?format=api", "priority": 100, "id": 99529193, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=9b462ac1e57ea9bf", "url": "https://translations.documentfoundation.org/api/units/99529193/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:35.814084Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "If in division A1 by A2, A2 can turn to zero, you can handle the situation as follows:" ], "previous_source": "", "target": [ "" ], "id_hash": -5828325500929285030, "content_hash": -5828325500929285030, "location": "func_error_type.xhp", "context": "func_error_type.xhp\npar_id90121141327448\nhelp.text", "note": "PP59Q", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6854, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/99312837/?format=api", "priority": 100, "id": 99529197, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=2f1da0d631c2645a", "url": "https://translations.documentfoundation.org/api/units/99529197/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:35.815616Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<item type=\"input\">=IF(ISERROR(A1/A2);IF(ERROR.TYPE(A1/A2)=2;\"the denominator can't be equal to zero\");A1/A2)</item>" ], "previous_source": "", "target": [ "" ], "id_hash": -1049047893538484327, "content_hash": -1049047893538484327, "location": "func_error_type.xhp", "context": "func_error_type.xhp\npar_id16083887218317\nhelp.text", "note": "uvFET", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6855, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/99312877/?format=api", "priority": 100, "id": 99529200, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=7171087fb9444f99", "url": "https://translations.documentfoundation.org/api/units/99529200/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:35.817162Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "The ISERROR function returns TRUE or FALSE depending on whether there is an error or not. If the error takes place, the function IF addresses to the second argument, if there is no error, it returns the result of the division. The second argument checks the index number representing the specific Error type, and if it is equal to 2, it returns the specified text \"the denominator can't be zero\" or 0 otherwise. Thus, clear text would signify the division by zero, the result of the division would appear when the division is successful, or if there is, for example, an error of another type, zero would be returned." ], "previous_source": "", "target": [ "" ], "id_hash": 775355141230595617, "content_hash": 775355141230595617, "location": "func_error_type.xhp", "context": "func_error_type.xhp\npar_id12475201719494\nhelp.text", "note": "SZAbc", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6856, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 109, "source_unit": "https://translations.documentfoundation.org/api/units/99312914/?format=api", "priority": 100, "id": 99529203, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=8ac29d6497d28e21", "url": "https://translations.documentfoundation.org/api/units/99529203/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:35.818751Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "If the ERROR.TYPE function is used as condition of the IF function and the ERROR.TYPE returns #N/A, the IF function returns #N/A as well. Use ISERROR to avoid it as shown in the example above." ], "previous_source": "", "target": [ "" ], "id_hash": 7504579159209704435, "content_hash": 7504579159209704435, "location": "func_error_type.xhp", "context": "func_error_type.xhp\npar_id26251175451270\nhelp.text", "note": "8XdGp", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6857, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 35, "source_unit": "https://translations.documentfoundation.org/api/units/99312953/?format=api", "priority": 100, "id": 99529207, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=e8259efbfd7e7bf3", "url": "https://translations.documentfoundation.org/api/units/99529207/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:35.820402Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/ERROR.TYPE\">ERROR.TYPE wiki page</link>." ], "previous_source": "", "target": [ "" ], "id_hash": 2385225174918192715, "content_hash": 2385225174918192715, "location": "func_error_type.xhp", "context": "func_error_type.xhp\npar_id201677013027422\nhelp.text", "note": "Attho", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6858, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/99313016/?format=api", "priority": 100, "id": 99529211, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=a11a05a8bc515e4b", "url": "https://translations.documentfoundation.org/api/units/99529211/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:35.821930Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<link href=\"text/scalc/01/04060104.xhp#iserror\">ISERROR</link>, <link href=\"text/scalc/01/04060104.xhp#na\">NA</link>, <link href=\"text/scalc/01/04060104.xhp#Section4\">IF</link>" ], "previous_source": "", "target": [ "" ], "id_hash": -2559001523601501522, "content_hash": -2559001523601501522, "location": "func_error_type.xhp", "context": "func_error_type.xhp\npar_id352953529535295\nhelp.text", "note": "jKnF4", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6859, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/99313124/?format=api", "priority": 100, "id": 99529212, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=5c7c99ac260c92ae", "url": "https://translations.documentfoundation.org/api/units/99529212/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:35.823455Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<link href=\"text/scalc/05/02140000.xhp\">Error codes</link>" ], "previous_source": "", "target": [ "" ], "id_hash": 8853279473260907911, "content_hash": 8853279473260907911, "location": "func_error_type.xhp", "context": "func_error_type.xhp\npar_id312932390024933\nhelp.text", "note": "tEskv", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6860, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99313168/?format=api", "priority": 100, "id": 99529214, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=fadd2ac634f94d87", "url": "https://translations.documentfoundation.org/api/units/99529214/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:35.825003Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "FINDB Function" ], "previous_source": "", "target": [ "" ], "id_hash": -7889507177573755160, "content_hash": -7889507177573755160, "location": "func_findb.xhp", "context": "func_findb.xhp\ntit\nhelp.text", "note": "sUgSM", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6861, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99313186/?format=api", "priority": 100, "id": 99529216, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=1282d705bbd256e8", "url": "https://translations.documentfoundation.org/api/units/99529216/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:35.826569Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<bookmark_value>FINDB Function</bookmark_value> <bookmark_value>find text;FINDB Function</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": 2583189554817847697, "content_hash": 2583189554817847697, "location": "func_findb.xhp", "context": "func_findb.xhp\nbm_id141573508995071\nhelp.text", "note": "EkUr2", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6862, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/99313195/?format=api", "priority": 100, "id": 99529218, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=a3d95536ba6ad191", "url": "https://translations.documentfoundation.org/api/units/99529218/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:35.828233Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<variable id=\"findb\"><link href=\"text/scalc/01/func_findb.xhp\">FINDB</link></variable>" ], "previous_source": "", "target": [ "" ], "id_hash": -1603397346846792563, "content_hash": -1603397346846792563, "location": "func_findb.xhp", "context": "func_findb.xhp\nhd_id771573508637966\nhelp.text", "note": "MAagw", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6863, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99313204/?format=api", "priority": 100, "id": 99529221, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=69bf969bb364a48d", "url": "https://translations.documentfoundation.org/api/units/99529221/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:35.829839Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<variable id=\"variable name\"><ahelp hid=\".\">Returns the starting position of a given text, using byte positions. FINDB is case sensitive.</ahelp></variable>" ], "previous_source": "", "target": [ "" ], "id_hash": -143823074880440130, "content_hash": -143823074880440130, "location": "func_findb.xhp", "context": "func_findb.xhp\npar_id831573508637970\nhelp.text", "note": "iW2EE", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6864, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/99313214/?format=api", "priority": 100, "id": 99529224, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=7e0109ace73f38be", "url": "https://translations.documentfoundation.org/api/units/99529224/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:35.831317Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "FINDB(Find Text ; Text [; Position])" ], "previous_source": "", "target": [ "" ], "id_hash": 4851186099215298805, "content_hash": 4851186099215298805, "location": "func_findb.xhp", "context": "func_findb.xhp\npar_id221573517641172\nhelp.text", "note": "4ztby", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6865, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/99313215/?format=api", "priority": 100, "id": 99529228, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=c352e00df70a70f5", "url": "https://translations.documentfoundation.org/api/units/99529228/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:35.832884Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<emph>Find Text</emph>: The text or text expression to be found." ], "previous_source": "", "target": [ "" ], "id_hash": -2381789301338802838, "content_hash": -2381789301338802838, "location": "func_findb.xhp", "context": "func_findb.xhp\npar_id241573517292388\nhelp.text", "note": "puQAw", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6866, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/99313216/?format=api", "priority": 100, "id": 99529230, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=5ef22f3febdff56a", "url": "https://translations.documentfoundation.org/api/units/99529230/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:35.834259Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<emph>Text</emph>: the text in which the search is to be made." ], "previous_source": "", "target": [ "" ], "id_hash": -4952209093873171240, "content_hash": -4952209093873171240, "location": "func_findb.xhp", "context": "func_findb.xhp\npar_id991573517299918\nhelp.text", "note": "YgyTW", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6867, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/99313217/?format=api", "priority": 100, "id": 99529237, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=3b4638112a3b04d8", "url": "https://translations.documentfoundation.org/api/units/99529237/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:35.842772Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<emph>Position</emph>: The position in the text where the search starts." ], "previous_source": "", "target": [ "" ], "id_hash": 5183166549616376613, "content_hash": 5183166549616376613, "location": "func_findb.xhp", "context": "func_findb.xhp\npar_id521573517305077\nhelp.text", "note": "pfYPq", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6868, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/99313218/?format=api", "priority": 100, "id": 99529239, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=c7ee4e83e9923b25", "url": "https://translations.documentfoundation.org/api/units/99529239/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:35.844838Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<input>=FINDB(\"ａ\"; \"LibreOffice Ｃａｌｃ\")</input> returns 15. The <emph>Find Text</emph> argument is a text string that comprises a full-width, double-byte \"a\" character, while the <emph>Text</emph> argument comprises 12 single-byte characters followed by four full-width, double-byte characters." ], "previous_source": "", "target": [ "" ], "id_hash": 5182013423762772779, "content_hash": 5182013423762772779, "location": "func_findb.xhp", "context": "func_findb.xhp\npar_id481573517830373\nhelp.text", "note": "okEBS", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6869, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 34, "source_unit": "https://translations.documentfoundation.org/api/units/99313219/?format=api", "priority": 100, "id": 99529241, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=c7ea35c0e0af932b", "url": "https://translations.documentfoundation.org/api/units/99529241/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:35.846486Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/FINDB\">FINDB wiki page</link>." ], "previous_source": "", "target": [ "" ], "id_hash": -8433278834042333743, "content_hash": -8433278834042333743, "location": "func_findb.xhp", "context": "func_findb.xhp\npar_id491677016507189\nhelp.text", "note": "E8koD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6870, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/99313220/?format=api", "priority": 100, "id": 99529248, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=0af6f994f51615d1", "url": "https://translations.documentfoundation.org/api/units/99529248/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:35.848746Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "FLOOR Functions" ], "previous_source": "", "target": [ "" ], "id_hash": 1902149938853774105, "content_hash": 1902149938853774105, "location": "func_floor.xhp", "context": "func_floor.xhp\ntit\nhelp.text", "note": "aACGP", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6871, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99313221/?format=api", "priority": 100, "id": 99529257, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=9a65cb4a96e90319", "url": "https://translations.documentfoundation.org/api/units/99529257/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:35.853693Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "FLOOR Functions" ], "previous_source": "", "target": [ "" ], "id_hash": 8149024173275598159, "content_hash": 8149024173275598159, "location": "func_floor.xhp", "context": "func_floor.xhp\nhd_id391586285373874\nhelp.text", "note": "RuCRw", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6872, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99313222/?format=api", "priority": 100, "id": 99529263, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=f117264f6a29cd4f", "url": "https://translations.documentfoundation.org/api/units/99529263/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:35.856391Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<bookmark_value>FLOOR function</bookmark_value><bookmark_value>rounding;down to nearest multiple of significance</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": -978755105361049496, "content_hash": -978755105361049496, "location": "func_floor.xhp", "context": "func_floor.xhp\nbm_id3157404\nhelp.text", "note": "hkrkw", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6873, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/99313223/?format=api", "priority": 100, "id": 99529270, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=726ac36ad6dac868", "url": "https://translations.documentfoundation.org/api/units/99529270/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:35.863654Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<variable id=\"FLOORh1\"><link href=\"text/scalc/01/func_floor.xhp#floor\">FLOOR</link></variable>" ], "previous_source": "", "target": [ "" ], "id_hash": 4557311407181879070, "content_hash": 4557311407181879070, "location": "func_floor.xhp", "context": "func_floor.xhp\nhd_id3157404\nhelp.text", "note": "soQ7o", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6874, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99313247/?format=api", "priority": 100, "id": 99529274, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=bf3ed29443e9571e", "url": "https://translations.documentfoundation.org/api/units/99529274/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:35.865469Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_UNTERGRENZE\">Rounds a number to the nearest multiple of a significance value.</ahelp>" ], "previous_source": "", "target": [ "" ], "id_hash": -9177487340995128972, "content_hash": -9177487340995128972, "location": "func_floor.xhp", "context": "func_floor.xhp\npar_id3157432\nhelp.text", "note": "VSV8H", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6875, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/99313281/?format=api", "priority": 100, "id": 99529278, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=00a303e345575174", "url": "https://translations.documentfoundation.org/api/units/99529278/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:35.867032Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "For a positive number and a positive significance value, the function rounds down (towards zero). For a negative number and a negative significance value, the direction of rounding is determined by the value of a mode parameter. The function returns an error if the number and significance values have opposite signs." ], "previous_source": "", "target": [ "" ], "id_hash": -1325046114260424009, "content_hash": -1325046114260424009, "location": "func_floor.xhp", "context": "func_floor.xhp\npar_id661586285977707\nhelp.text", "note": "345Fr", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6876, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 51, "source_unit": "https://translations.documentfoundation.org/api/units/99313305/?format=api", "priority": 100, "id": 99529292, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=6d9c7d94587eeab7", "url": "https://translations.documentfoundation.org/api/units/99529292/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:35.873432Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "If the spreadsheet is exported to Microsoft Excel, the FLOOR function is exported as the equivalent FLOOR.MATH function that has existed since Excel 2013. If you plan to use the spreadsheet with earlier Excel versions, use either FLOOR.PRECISE that has existed since Excel 2010, or FLOOR.XCL that is exported as the FLOOR function compatible with all Excel versions." ], "previous_source": "", "target": [ "" ], "id_hash": -5401683797219407282, "content_hash": -5401683797219407282, "location": "func_floor.xhp", "context": "func_floor.xhp\npar_id3163894\nhelp.text", "note": "5kHtR", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6877, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 58, "source_unit": "https://translations.documentfoundation.org/api/units/99313307/?format=api", "priority": 100, "id": 99529295, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=35095d34adc10a4e", "url": "https://translations.documentfoundation.org/api/units/99529295/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:35.875015Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "FLOOR(Number[; Significance[; Mode]])" ], "previous_source": "", "target": [ "" ], "id_hash": 3299175918401480590, "content_hash": 3299175918401480590, "location": "func_floor.xhp", "context": "func_floor.xhp\npar_id3157464\nhelp.text", "note": "2haGU", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6878, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99313308/?format=api", "priority": 100, "id": 99529312, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=adc907049bd7e78e", "url": "https://translations.documentfoundation.org/api/units/99529312/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:35.883352Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<emph>Number</emph> is the number that is to be rounded, or a reference to a cell containing the number." ], "previous_source": "", "target": [ "" ], "id_hash": 7906861281896787327, "content_hash": 7906861281896787327, "location": "func_floor.xhp", "context": "func_floor.xhp\npar_id3153467\nhelp.text", "note": "ERf3D", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6879, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/99313309/?format=api", "priority": 100, "id": 99529320, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=edbad0718bbf6d7f", "url": "https://translations.documentfoundation.org/api/units/99529320/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:35.889037Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<emph>Significance</emph> (optional) is the value, or a reference to a cell containing the value, to whose multiple <emph>Number</emph> is to be rounded. It defaults to +1 or -1 depending on the sign of <emph>Number</emph>." ], "previous_source": "", "target": [ "" ], "id_hash": -8929144718070192460, "content_hash": -8929144718070192460, "location": "func_floor.xhp", "context": "func_floor.xhp\npar_id3157497\nhelp.text", "note": "8w8tL", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6880, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 34, "source_unit": "https://translations.documentfoundation.org/api/units/99313359/?format=api", "priority": 100, "id": 99529326, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=04154e30035ee6b4", "url": "https://translations.documentfoundation.org/api/units/99529326/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:35.890795Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<emph>Mode</emph> (optional) is a number, or a reference to a cell containing a number. The function only uses <emph>Mode</emph> if both <emph>Number</emph> and <emph>Significance</emph> are negative. Then if <emph>Mode</emph> is given and not equal to zero, numbers are rounded up (towards zero); if <emph>Mode</emph> is equal to zero or not given, negative numbers are rounded down (away from zero)." ], "previous_source": "", "target": [ "" ], "id_hash": -9021519890613500318, "content_hash": -9021519890613500318, "location": "func_floor.xhp", "context": "func_floor.xhp\npar_id3157517\nhelp.text", "note": "qCpHR", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6881, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 59, "source_unit": "https://translations.documentfoundation.org/api/units/99313406/?format=api", "priority": 100, "id": 99529330, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=02cd1f7521dc8662", "url": "https://translations.documentfoundation.org/api/units/99529330/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:35.892541Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<input>=FLOOR(3.45)</input> returns 3." ], "previous_source": "", "target": [ "" ], "id_hash": -1140933442134001748, "content_hash": -1140933442134001748, "location": "func_floor.xhp", "context": "func_floor.xhp\npar_id761586287595376\nhelp.text", "note": "EU85r", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6882, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99313445/?format=api", "priority": 100, "id": 99529335, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=702a97144d3d37ac", "url": "https://translations.documentfoundation.org/api/units/99529335/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:35.894238Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<input>=FLOOR(3.45, 3)</input> returns 3." ], "previous_source": "", "target": [ "" ], "id_hash": 6030999501447142480, "content_hash": 6030999501447142480, "location": "func_floor.xhp", "context": "func_floor.xhp\npar_id311586287600048\nhelp.text", "note": "vuJc5", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6883, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/99313486/?format=api", "priority": 100, "id": 99529339, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=d3b26a17cc509c50", "url": "https://translations.documentfoundation.org/api/units/99529339/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:35.896020Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<input>=FLOOR(-1.234)</input> returns -2." ], "previous_source": "", "target": [ "" ], "id_hash": 7789706223946165598, "content_hash": 7789706223946165598, "location": "func_floor.xhp", "context": "func_floor.xhp\npar_id661586287604519\nhelp.text", "note": "uTWTb", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6884, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99313525/?format=api", "priority": 100, "id": 99529347, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=ec1a9889fef5ed5e", "url": "https://translations.documentfoundation.org/api/units/99529347/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:35.900720Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<input>=FLOOR(-45.67, -2, 0)</input> returns -46." ], "previous_source": "", "target": [ "" ], "id_hash": -5929644721893275480, "content_hash": -5929644721893275480, "location": "func_floor.xhp", "context": "func_floor.xhp\npar_id741586287608968\nhelp.text", "note": "8ZGDc", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6885, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/99313558/?format=api", "priority": 100, "id": 99529352, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=2db5ab8ac34808a8", "url": "https://translations.documentfoundation.org/api/units/99529352/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:35.903378Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<input>=FLOOR(-45.67, -2, 1)</input> returns -44." ], "previous_source": "", "target": [ "" ], "id_hash": 5106283170417107089, "content_hash": 5106283170417107089, "location": "func_floor.xhp", "context": "func_floor.xhp\npar_id431586287616089\nhelp.text", "note": "gXsTm", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6886, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/99313657/?format=api", "priority": 100, "id": 99529360, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=c6dd297d3f446091", "url": "https://translations.documentfoundation.org/api/units/99529360/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:35.909815Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<bookmark_value>FLOOR.MATH function</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": -49871030343191467, "content_hash": -49871030343191467, "location": "func_floor.xhp", "context": "func_floor.xhp\nbm_id811586290952465\nhelp.text", "note": "zzTLr", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6887, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99313702/?format=api", "priority": 100, "id": 99529363, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=7f4ed28fe7cfb455", "url": "https://translations.documentfoundation.org/api/units/99529363/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:35.911547Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<variable id=\"FLOOR.MATHh1\"><link href=\"text/scalc/01/func_floor.xhp#floormath\">FLOOR.MATH</link></variable>" ], "previous_source": "", "target": [ "" ], "id_hash": -8862680792802048502, "content_hash": -8862680792802048502, "location": "func_floor.xhp", "context": "func_floor.xhp\nhd_id1001586287279297\nhelp.text", "note": "B9VCD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6888, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99313734/?format=api", "priority": 100, "id": 99529367, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=05016ec6835b460a", "url": "https://translations.documentfoundation.org/api/units/99529367/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:35.913097Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Rounds a number to the nearest multiple of a significance value." ], "previous_source": "", "target": [ "" ], "id_hash": -4980910328015637975, "content_hash": -4980910328015637975, "location": "func_floor.xhp", "context": "func_floor.xhp\npar_id721586287302689\nhelp.text", "note": "BBjwd", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6889, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/99313798/?format=api", "priority": 100, "id": 99529370, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=3ae04072588db229", "url": "https://translations.documentfoundation.org/api/units/99529370/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:35.914598Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "For a positive number the function rounds down (towards zero). For a negative number, the direction of rounding is determined by the value of a mode parameter. The sign of the significance value is ignored." ], "previous_source": "", "target": [ "" ], "id_hash": -5419642832528357093, "content_hash": -5419642832528357093, "location": "func_floor.xhp", "context": "func_floor.xhp\npar_id311586287323417\nhelp.text", "note": "UJLZc", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6890, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 35, "source_unit": "https://translations.documentfoundation.org/api/units/99313899/?format=api", "priority": 100, "id": 99529372, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=34c98f8eeda7c91b", "url": "https://translations.documentfoundation.org/api/units/99529372/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:35.916008Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "This function exists for interoperability with Microsoft Excel 2013 or newer." ], "previous_source": "", "target": [ "" ], "id_hash": -2763872311661723024, "content_hash": -2763872311661723024, "location": "func_floor.xhp", "context": "func_floor.xhp\npar_id851586287535879\nhelp.text", "note": "4weAd", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6891, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/99313975/?format=api", "priority": 100, "id": 99529375, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=59a4c0c6b2dd8270", "url": "https://translations.documentfoundation.org/api/units/99529375/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:35.917510Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "FLOOR.MATH(Number[; Significance[; Mode]])" ], "previous_source": "", "target": [ "" ], "id_hash": 3629063014354553795, "content_hash": 3629063014354553795, "location": "func_floor.xhp", "context": "func_floor.xhp\npar_id161586287421523\nhelp.text", "note": "4DFyG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6892, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99314051/?format=api", "priority": 100, "id": 99529379, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=b25d05957e1c8bc3", "url": "https://translations.documentfoundation.org/api/units/99529379/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:35.918979Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<emph>Significance</emph> (optional) is the value, or a reference to a cell containing the value, to whose multiple <emph>Number</emph> is to be rounded. It defaults to 1." ], "previous_source": "", "target": [ "" ], "id_hash": 5827915970105083536, "content_hash": 5827915970105083536, "location": "func_floor.xhp", "context": "func_floor.xhp\npar_id231586287448716\nhelp.text", "note": "Un6FB", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6893, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/99314098/?format=api", "priority": 100, "id": 99529381, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=d0e0eab27af08690", "url": "https://translations.documentfoundation.org/api/units/99529381/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:35.920306Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<emph>Mode</emph> (optional) is a number, or a reference to a cell containing a number. If <emph>Mode</emph> is given and not equal to zero, a negative <emph>Number</emph> is rounded up (towards zero). If <emph>Mode</emph> is equal to zero or is not given, a negative <emph>Number</emph> is rounded down (away from zero)." ], "previous_source": "", "target": [ "" ], "id_hash": 4572231418571937756, "content_hash": 4572231418571937756, "location": "func_floor.xhp", "context": "func_floor.xhp\npar_id261586287494401\nhelp.text", "note": "L9MKT", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6894, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 50, "source_unit": "https://translations.documentfoundation.org/api/units/99314142/?format=api", "priority": 100, "id": 99529383, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=bf73d4401edc57dc", "url": "https://translations.documentfoundation.org/api/units/99529383/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:35.921751Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<input>=FLOOR.MATH(3.45)</input> returns 3." ], "previous_source": "", "target": [ "" ], "id_hash": -2856340895687469540, "content_hash": -2856340895687469540, "location": "func_floor.xhp", "context": "func_floor.xhp\npar_id101586287621816\nhelp.text", "note": "wCd8C", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6895, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99314154/?format=api", "priority": 100, "id": 99529386, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=585c3d16c320961c", "url": "https://translations.documentfoundation.org/api/units/99529386/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:35.923244Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<input>=FLOOR.MATH(3.45,-3)</input> returns 3." ], "previous_source": "", "target": [ "" ], "id_hash": -6322581572511518864, "content_hash": -6322581572511518864, "location": "func_floor.xhp", "context": "func_floor.xhp\npar_id771586287627784\nhelp.text", "note": "p27MD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6896, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99314155/?format=api", "priority": 100, "id": 99529388, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=2841ad8eeb052f70", "url": "https://translations.documentfoundation.org/api/units/99529388/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:35.924537Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<input>=FLOOR.MATH(-1.234)</input> returns -2." ], "previous_source": "", "target": [ "" ], "id_hash": 5039402035906781346, "content_hash": 5039402035906781346, "location": "func_floor.xhp", "context": "func_floor.xhp\npar_id981586287632392\nhelp.text", "note": "Fehfx", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6897, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99314156/?format=api", "priority": 100, "id": 99529392, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=c5ef8d73a69aa0a2", "url": "https://translations.documentfoundation.org/api/units/99529392/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:35.925970Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<input>=FLOOR.MATH(-45.67,-2, 0)</input> returns -46." ], "previous_source": "", "target": [ "" ], "id_hash": -3071664326763125845, "content_hash": -3071664326763125845, "location": "func_floor.xhp", "context": "func_floor.xhp\npar_id631586287637256\nhelp.text", "note": "eQfea", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6898, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/99314157/?format=api", "priority": 100, "id": 99529394, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=555f4191b60b63ab", "url": "https://translations.documentfoundation.org/api/units/99529394/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:35.927420Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<input>=FLOOR.MATH(-45.67,+2, 1)</input> returns -44." ], "previous_source": "", "target": [ "" ], "id_hash": 7930390004782618258, "content_hash": 7930390004782618258, "location": "func_floor.xhp", "context": "func_floor.xhp\npar_id371586287641888\nhelp.text", "note": "XXqpS", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6899, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/99314158/?format=api", "priority": 100, "id": 99529399, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=ee0e67b13d605692", "url": "https://translations.documentfoundation.org/api/units/99529399/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:35.928938Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<bookmark_value>FLOOR.PRECISE function</bookmark_value><bookmark_value>rounding;down to nearest multiple of significance</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": 2189234542803318077, "content_hash": 2189234542803318077, "location": "func_floor.xhp", "context": "func_floor.xhp\nbm_id2957404\nhelp.text", "note": "9MJem", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6900, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/99314159/?format=api", "priority": 100, "id": 99529404, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=9e61b937b5ce753d", "url": "https://translations.documentfoundation.org/api/units/99529404/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:35.930443Z" } ] }