Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-24-2/textscalc01/iu/units/?format=api&page=140
https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/units/?format=api&page=141", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/units/?format=api&page=139", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 6951, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/111160774/?format=api", "priority": 100, "id": 112435258, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=c352e00df70a70f5", "url": "https://translations.documentfoundation.org/api/units/112435258/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.251339Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 6952, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/111160825/?format=api", "priority": 100, "id": 112435259, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=5ef22f3febdff56a", "url": "https://translations.documentfoundation.org/api/units/112435259/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.252719Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 6953, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/111160842/?format=api", "priority": 100, "id": 112435260, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=3b4638112a3b04d8", "url": "https://translations.documentfoundation.org/api/units/112435260/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.254136Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 6954, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/111160885/?format=api", "priority": 100, "id": 112435261, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=c7ee4e83e9923b25", "url": "https://translations.documentfoundation.org/api/units/112435261/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.255547Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<input>=FINDB(\"a\"; \"LibreOffice Calc\")</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": 6955, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 34, "source_unit": "https://translations.documentfoundation.org/api/units/111160915/?format=api", "priority": 100, "id": 112435262, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=c7ea35c0e0af932b", "url": "https://translations.documentfoundation.org/api/units/112435262/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.256984Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/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": 6956, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/111160944/?format=api", "priority": 100, "id": 112435263, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=0af6f994f51615d1", "url": "https://translations.documentfoundation.org/api/units/112435263/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.258324Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 6957, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111160973/?format=api", "priority": 100, "id": 112435264, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=9a65cb4a96e90319", "url": "https://translations.documentfoundation.org/api/units/112435264/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.259704Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 6958, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111160985/?format=api", "priority": 100, "id": 112435265, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=f117264f6a29cd4f", "url": "https://translations.documentfoundation.org/api/units/112435265/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.260972Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 6959, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/111161000/?format=api", "priority": 100, "id": 112435266, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=726ac36ad6dac868", "url": "https://translations.documentfoundation.org/api/units/112435266/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.262248Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 6960, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111161038/?format=api", "priority": 100, "id": 112435267, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=bf3ed29443e9571e", "url": "https://translations.documentfoundation.org/api/units/112435267/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.263585Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 6961, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/111161067/?format=api", "priority": 100, "id": 112435268, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=00a303e345575174", "url": "https://translations.documentfoundation.org/api/units/112435268/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.264946Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 6962, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 51, "source_unit": "https://translations.documentfoundation.org/api/units/111161106/?format=api", "priority": 100, "id": 112435269, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=6d9c7d94587eeab7", "url": "https://translations.documentfoundation.org/api/units/112435269/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.267848Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 6963, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 58, "source_unit": "https://translations.documentfoundation.org/api/units/111161131/?format=api", "priority": 100, "id": 112435270, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=35095d34adc10a4e", "url": "https://translations.documentfoundation.org/api/units/112435270/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.269806Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 6964, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111161158/?format=api", "priority": 100, "id": 112435271, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=adc907049bd7e78e", "url": "https://translations.documentfoundation.org/api/units/112435271/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.271758Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 6965, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/111161187/?format=api", "priority": 100, "id": 112435272, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=edbad0718bbf6d7f", "url": "https://translations.documentfoundation.org/api/units/112435272/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.273534Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 6966, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 34, "source_unit": "https://translations.documentfoundation.org/api/units/111161228/?format=api", "priority": 100, "id": 112435273, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=04154e30035ee6b4", "url": "https://translations.documentfoundation.org/api/units/112435273/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.274881Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 6967, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 59, "source_unit": "https://translations.documentfoundation.org/api/units/111161264/?format=api", "priority": 100, "id": 112435274, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=02cd1f7521dc8662", "url": "https://translations.documentfoundation.org/api/units/112435274/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.275975Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 6968, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111161282/?format=api", "priority": 100, "id": 112435275, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=702a97144d3d37ac", "url": "https://translations.documentfoundation.org/api/units/112435275/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.277152Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 6969, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/111161301/?format=api", "priority": 100, "id": 112435276, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=d3b26a17cc509c50", "url": "https://translations.documentfoundation.org/api/units/112435276/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.278191Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 6970, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111161316/?format=api", "priority": 100, "id": 112435277, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=ec1a9889fef5ed5e", "url": "https://translations.documentfoundation.org/api/units/112435277/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.279160Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 6971, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/111161329/?format=api", "priority": 100, "id": 112435278, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=2db5ab8ac34808a8", "url": "https://translations.documentfoundation.org/api/units/112435278/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.280168Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 6972, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/111161353/?format=api", "priority": 100, "id": 112435279, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=c6dd297d3f446091", "url": "https://translations.documentfoundation.org/api/units/112435279/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.281186Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 6973, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111161369/?format=api", "priority": 100, "id": 112435280, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=7f4ed28fe7cfb455", "url": "https://translations.documentfoundation.org/api/units/112435280/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.282208Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 6974, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111161387/?format=api", "priority": 100, "id": 112435281, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=05016ec6835b460a", "url": "https://translations.documentfoundation.org/api/units/112435281/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.283217Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 6975, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/111161453/?format=api", "priority": 100, "id": 112435282, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=3ae04072588db229", "url": "https://translations.documentfoundation.org/api/units/112435282/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.284197Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 6976, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 35, "source_unit": "https://translations.documentfoundation.org/api/units/111161467/?format=api", "priority": 100, "id": 112435283, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=34c98f8eeda7c91b", "url": "https://translations.documentfoundation.org/api/units/112435283/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.285183Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 6977, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/111161497/?format=api", "priority": 100, "id": 112435284, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=59a4c0c6b2dd8270", "url": "https://translations.documentfoundation.org/api/units/112435284/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.286256Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 6978, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111161530/?format=api", "priority": 100, "id": 112435285, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=b25d05957e1c8bc3", "url": "https://translations.documentfoundation.org/api/units/112435285/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.287284Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 6979, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/111161563/?format=api", "priority": 100, "id": 112435286, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=d0e0eab27af08690", "url": "https://translations.documentfoundation.org/api/units/112435286/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.288294Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 6980, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 50, "source_unit": "https://translations.documentfoundation.org/api/units/111161630/?format=api", "priority": 100, "id": 112435287, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=bf73d4401edc57dc", "url": "https://translations.documentfoundation.org/api/units/112435287/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.289351Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 6981, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111161667/?format=api", "priority": 100, "id": 112435288, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=585c3d16c320961c", "url": "https://translations.documentfoundation.org/api/units/112435288/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.290435Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 6982, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111161703/?format=api", "priority": 100, "id": 112435289, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=2841ad8eeb052f70", "url": "https://translations.documentfoundation.org/api/units/112435289/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.291439Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 6983, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111161740/?format=api", "priority": 100, "id": 112435290, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=c5ef8d73a69aa0a2", "url": "https://translations.documentfoundation.org/api/units/112435290/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.292536Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 6984, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/111161757/?format=api", "priority": 100, "id": 112435291, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=555f4191b60b63ab", "url": "https://translations.documentfoundation.org/api/units/112435291/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.293514Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 6985, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/111161800/?format=api", "priority": 100, "id": 112435292, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=ee0e67b13d605692", "url": "https://translations.documentfoundation.org/api/units/112435292/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.294505Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 6986, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/111161832/?format=api", "priority": 100, "id": 112435293, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=9e61b937b5ce753d", "url": "https://translations.documentfoundation.org/api/units/112435293/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.295734Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<variable id=\"FLOOR.PRECISEh1\"><link href=\"text/scalc/01/func_floor.xhp#floorprecise\">FLOOR.PRECISE</link></variable>" ], "previous_source": "", "target": [ "" ], "id_hash": 370838481839743062, "content_hash": 370838481839743062, "location": "func_floor.xhp", "context": "func_floor.xhp\nhd_id2957404\nhelp.text", "note": "Q6WU3", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6987, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111161910/?format=api", "priority": 100, "id": 112435294, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=85257ba26b1a6056", "url": "https://translations.documentfoundation.org/api/units/112435294/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.299589Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_FLOOR_MS\">Rounds a number down to the nearest multiple of a significance value.</ahelp>" ], "previous_source": "", "target": [ "" ], "id_hash": 2370495124937784146, "content_hash": 2370495124937784146, "location": "func_floor.xhp", "context": "func_floor.xhp\npar_id2957432\nhelp.text", "note": "DgQBx", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6988, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/111161946/?format=api", "priority": 100, "id": 112435295, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=a0e5b0c1b7b63b52", "url": "https://translations.documentfoundation.org/api/units/112435295/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.302281Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "For a positive number the function rounds down (towards zero). For a negative number, the function rounds down (away form zero). The sign of the significance value is ignored." ], "previous_source": "", "target": [ "" ], "id_hash": 66257145829558831, "content_hash": 66257145829558831, "location": "func_floor.xhp", "context": "func_floor.xhp\npar_id261586641501175\nhelp.text", "note": "NHMnz", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6989, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/111161959/?format=api", "priority": 100, "id": 112435296, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=80eb6485e9008a2f", "url": "https://translations.documentfoundation.org/api/units/112435296/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.304329Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "FLOOR.PRECISE(Number[; Significance])" ], "previous_source": "", "target": [ "" ], "id_hash": 7745435786406884383, "content_hash": 7745435786406884383, "location": "func_floor.xhp", "context": "func_floor.xhp\npar_id2957464\nhelp.text", "note": "ni9y2", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6990, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111161973/?format=api", "priority": 100, "id": 112435297, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=eb7d50cf8761741f", "url": "https://translations.documentfoundation.org/api/units/112435297/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.306443Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?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": 2642075773291905594, "content_hash": 2642075773291905594, "location": "func_floor.xhp", "context": "func_floor.xhp\npar_id2957497\nhelp.text", "note": "pirHp", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6991, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/111161992/?format=api", "priority": 100, "id": 112435298, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=a4aa89eae0bac23a", "url": "https://translations.documentfoundation.org/api/units/112435298/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.308583Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<input>=FLOOR.PRECISE(3.45)</input> returns 3." ], "previous_source": "", "target": [ "" ], "id_hash": -21727037357043576, "content_hash": -21727037357043576, "location": "func_floor.xhp", "context": "func_floor.xhp\npar_id981586291388900\nhelp.text", "note": "smFCw", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6992, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111162053/?format=api", "priority": 100, "id": 112435299, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=7fb2cf5fe84fd088", "url": "https://translations.documentfoundation.org/api/units/112435299/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.310679Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<input>=FLOOR.PRECISE(-45.67,2)</input> returns -46." ], "previous_source": "", "target": [ "" ], "id_hash": -3404203492867274222, "content_hash": -3404203492867274222, "location": "func_floor.xhp", "context": "func_floor.xhp\npar_id831586291395477\nhelp.text", "note": "Q9vnd", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6993, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111162082/?format=api", "priority": 100, "id": 112435300, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=50c1d6f5a0808a12", "url": "https://translations.documentfoundation.org/api/units/112435300/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.312301Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<bookmark_value>FLOOR.XCL function</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": -301887112973687715, "content_hash": -301887112973687715, "location": "func_floor.xhp", "context": "func_floor.xhp\nbm_id171586291849333\nhelp.text", "note": "HnS5F", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6994, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111162090/?format=api", "priority": 100, "id": 112435301, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=7bcf7b452cef645d", "url": "https://translations.documentfoundation.org/api/units/112435301/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.313541Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<variable id=\"FLOOR.XCLh1\"><link href=\"text/scalc/01/func_floor.xhp#floorxcl\">FLOOR.XCL</link></variable>" ], "previous_source": "", "target": [ "" ], "id_hash": -849512561535502426, "content_hash": -849512561535502426, "location": "func_floor.xhp", "context": "func_floor.xhp\nhd_id791586291468176\nhelp.text", "note": "gC7eY", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6995, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111162093/?format=api", "priority": 100, "id": 112435302, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=7435ecd38171b7a6", "url": "https://translations.documentfoundation.org/api/units/112435302/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.314750Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "Rounds a number to the nearest multiple of a significance value." ], "previous_source": "", "target": [ "" ], "id_hash": -5250749246960873478, "content_hash": -5250749246960873478, "location": "func_floor.xhp", "context": "func_floor.xhp\npar_id521586291476023\nhelp.text", "note": "WMsAT", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6996, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/111162094/?format=api", "priority": 100, "id": 112435303, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=372197612a3f4ffa", "url": "https://translations.documentfoundation.org/api/units/112435303/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.316050Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "For a positive number and a positive significance value, the function rounds down (towards zero). For a negative number and a positive significance value, the function rounds down (away from zero). For a negative number and a negative significance value, the function rounds up (towards zero). The function returns an error if the number is positive and the significance value is negative." ], "previous_source": "", "target": [ "" ], "id_hash": 7873499457725653972, "content_hash": 7873499457725653972, "location": "func_floor.xhp", "context": "func_floor.xhp\npar_id401586291488768\nhelp.text", "note": "jrymG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6997, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 62, "source_unit": "https://translations.documentfoundation.org/api/units/111162095/?format=api", "priority": 100, "id": 112435304, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=ed444a0a8cf7e3d4", "url": "https://translations.documentfoundation.org/api/units/112435304/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.317352Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "This function exists for interoperability with Microsoft Excel 2007 or older. If a Calc spreadsheet is exported to Microsoft Excel, references to Calc’s FLOOR.XCL function are exported as references to Excel’s FLOOR function, which is compatible with all Excel versions. If a Microsoft Excel spreadsheet is imported into Calc, references to Excel’s FLOOR function are imported as references to Calc’s FLOOR.XCL function." ], "previous_source": "", "target": [ "" ], "id_hash": 4480435311530838145, "content_hash": 4480435311530838145, "location": "func_floor.xhp", "context": "func_floor.xhp\npar_id231586291503319\nhelp.text", "note": "BFXRR", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6998, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 62, "source_unit": "https://translations.documentfoundation.org/api/units/111162198/?format=api", "priority": 100, "id": 112435305, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=be2db42d6ee98881", "url": "https://translations.documentfoundation.org/api/units/112435305/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.318594Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "FLOOR.XCL(Number; Significance)" ], "previous_source": "", "target": [ "" ], "id_hash": 4496390035747957631, "content_hash": 4496390035747957631, "location": "func_floor.xhp", "context": "func_floor.xhp\npar_id491586291532177\nhelp.text", "note": "WA7uC", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6999, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111162242/?format=api", "priority": 100, "id": 112435306, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=be6662ea245ceb7f", "url": "https://translations.documentfoundation.org/api/units/112435306/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.319853Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<emph>Significance</emph> is the value, or a reference to a cell containing the value, to whose multiple <emph>Number</emph> is to be rounded." ], "previous_source": "", "target": [ "" ], "id_hash": 2360606664300756422, "content_hash": 2360606664300756422, "location": "func_floor.xhp", "context": "func_floor.xhp\npar_id761586291578755\nhelp.text", "note": "aRww7", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7000, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://translations.documentfoundation.org/api/units/111162258/?format=api", "priority": 100, "id": 112435307, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=a0c28f411010fdc6", "url": "https://translations.documentfoundation.org/api/units/112435307/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:27.321021Z" } ] }{ "count": 8439, "next": "