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=131
{ "count": 8439, "next": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/units/?format=api&page=132", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/units/?format=api&page=130", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<item type=\"input\">=AVERAGEIFS(C2:C6;A2:A6;\"pen.*\";B2:B6;\"<\"&MAX(B2:B6))</item>" ], "previous_source": "", "target": [ "" ], "id_hash": -39274590102270107, "content_hash": -39274590102270107, "location": "func_averageifs.xhp", "context": "func_averageifs.xhp\npar_id303162761931870\nhelp.text", "note": "C7fCW", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6501, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111143400/?format=api", "priority": 100, "id": 112434808, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=7f7477f7e8414f65", "url": "https://translations.documentfoundation.org/api/units/112434808/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.488156Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "Calculates the average for values of the range C2:C6 that correspond to all cells of the A2:A6 range starting with \"pen\" and to all cells of the B2:B6 range except its maximum. Returns 65, because only second row meets all criteria." ], "previous_source": "", "target": [ "" ], "id_hash": 2035057651168597951, "content_hash": 2035057651168597951, "location": "func_averageifs.xhp", "context": "func_averageifs.xhp\npar_id40031348913642\nhelp.text", "note": "eo7jB", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6502, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 41, "source_unit": "https://translations.documentfoundation.org/api/units/111143462/?format=api", "priority": 100, "id": 112434809, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=9c3dfa26cb5857bf", "url": "https://translations.documentfoundation.org/api/units/112434809/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.489555Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "Reference to a cell as a criterion" ], "previous_source": "", "target": [ "" ], "id_hash": -3065874459700111046, "content_hash": -3065874459700111046, "location": "func_averageifs.xhp", "context": "func_averageifs.xhp\nhd_id31201205191857\nhelp.text", "note": "qyrrP", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6503, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/111143516/?format=api", "priority": 100, "id": 112434810, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=5573d36c2fa1d93a", "url": "https://translations.documentfoundation.org/api/units/112434810/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.490960Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "If you need to change a criterion easily, you may want to specify it in a separate cell and use a reference to this cell in the condition of AVERAGEIFS function. For example, the above function can be rewritten as follows:" ], "previous_source": "", "target": [ "" ], "id_hash": -6864261810427536110, "content_hash": -6864261810427536110, "location": "func_averageifs.xhp", "context": "func_averageifs.xhp\npar_id316794795433\nhelp.text", "note": "DqjCH", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6504, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 41, "source_unit": "https://translations.documentfoundation.org/api/units/111143554/?format=api", "priority": 100, "id": 112434811, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=20bd3e40782fdd12", "url": "https://translations.documentfoundation.org/api/units/112434811/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.492250Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<item type=\"input\">=AVERAGEIFS(C2:C6;A2:A6;E2&\".*\";B2:B6;\"<\"&MAX(B2:B6))</item>" ], "previous_source": "", "target": [ "" ], "id_hash": 7459219915114670295, "content_hash": 7459219915114670295, "location": "func_averageifs.xhp", "context": "func_averageifs.xhp\npar_id67531072426731\nhelp.text", "note": "B8bav", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6505, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111143594/?format=api", "priority": 100, "id": 112434812, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=e78478fdfdede8d7", "url": "https://translations.documentfoundation.org/api/units/112434812/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.493510Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "If E2 = pen, the function returns 65, because the link to the cell is substituted with its content." ], "previous_source": "", "target": [ "" ], "id_hash": -7828342925869082649, "content_hash": -7828342925869082649, "location": "func_averageifs.xhp", "context": "func_averageifs.xhp\npar_id65612244926745\nhelp.text", "note": "E3TZv", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6506, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/111143639/?format=api", "priority": 100, "id": 112434813, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=135c2395d3a197e7", "url": "https://translations.documentfoundation.org/api/units/112434813/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.494536Z" }, { "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/AVERAGEIFS\">AVERAGEIFS wiki page</link>." ], "previous_source": "", "target": [ "" ], "id_hash": -5108354685326168271, "content_hash": -5108354685326168271, "location": "func_averageifs.xhp", "context": "func_averageifs.xhp\npar_id371677017196557\nhelp.text", "note": "doVAz", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6507, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/111143683/?format=api", "priority": 100, "id": 112434814, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=391b7a7a9a6e6f31", "url": "https://translations.documentfoundation.org/api/units/112434814/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.495586Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "Ceiling functions" ], "previous_source": "", "target": [ "" ], "id_hash": 1609410509577279881, "content_hash": 1609410509577279881, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\ntit\nhelp.text", "note": "s6GFW", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6508, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111143739/?format=api", "priority": 100, "id": 112434815, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=9655c654d9225989", "url": "https://translations.documentfoundation.org/api/units/112434815/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.496622Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "Ceiling functions" ], "previous_source": "", "target": [ "" ], "id_hash": 7068345918758754198, "content_hash": 7068345918758754198, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\nhd_id971586216771519\nhelp.text", "note": "EWCte", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6509, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111143776/?format=api", "priority": 100, "id": 112434816, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=e217cf29d5329796", "url": "https://translations.documentfoundation.org/api/units/112434816/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.497609Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<bookmark_value>CEILING function</bookmark_value><bookmark_value>rounding;up to multiples of significance</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": -6153250019685046283, "content_hash": -6153250019685046283, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\nbm_id3152518\nhelp.text", "note": "M92qb", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6510, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/111143817/?format=api", "priority": 100, "id": 112434817, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=2a9b43b55a81e7f5", "url": "https://translations.documentfoundation.org/api/units/112434817/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.498584Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<variable id=\"CEILINGh1\"><link href=\"text/scalc/01/func_ceiling.xhp#ceiling\">CEILING</link></variable>" ], "previous_source": "", "target": [ "" ], "id_hash": -6451221408954010906, "content_hash": -6451221408954010906, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\nhd_id3152518\nhelp.text", "note": "cGa5K", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6511, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111143858/?format=api", "priority": 100, "id": 112434818, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=2678a84effe6b2e6", "url": "https://translations.documentfoundation.org/api/units/112434818/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.499620Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_OBERGRENZE\">Rounds a number to the nearest multiple of a significance value.</ahelp>" ], "previous_source": "", "target": [ "" ], "id_hash": 5612796639614937308, "content_hash": 5612796639614937308, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\npar_id3153422\nhelp.text", "note": "Co8xT", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6512, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/111143895/?format=api", "priority": 100, "id": 112434819, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=cde4a8ce4cc128dc", "url": "https://translations.documentfoundation.org/api/units/112434819/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.500630Z" }, { "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 up (away from 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": 3796565438325603616, "content_hash": 3796565438325603616, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\npar_id601586207136514\nhelp.text", "note": "PfT3s", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6513, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 52, "source_unit": "https://translations.documentfoundation.org/api/units/111143934/?format=api", "priority": 100, "id": 112434820, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=b4b01c26adec3d20", "url": "https://translations.documentfoundation.org/api/units/112434820/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.501686Z" }, { "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 CEILING function is exported as the equivalent CEILING.MATH function that has existed since Excel 2013. If you plan to use the spreadsheet with earlier Excel versions, use either CEILING.PRECISE that has existed since Excel 2010, or CEILING.XCL that is exported as the CEILING function compatible with all Excel versions." ], "previous_source": "", "target": [ "" ], "id_hash": -170100627546954741, "content_hash": -170100627546954741, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\npar_id3163792\nhelp.text", "note": "6AFh7", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6514, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 58, "source_unit": "https://translations.documentfoundation.org/api/units/111143962/?format=api", "priority": 100, "id": 112434821, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=7da3ae6166fe240b", "url": "https://translations.documentfoundation.org/api/units/112434821/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.502782Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "CEILING(Number [; Significance [; Mode]])" ], "previous_source": "", "target": [ "" ], "id_hash": 1397966469888016998, "content_hash": 1397966469888016998, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\npar_id3153454\nhelp.text", "note": "3DwLL", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6515, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/111144058/?format=api", "priority": 100, "id": 112434822, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=93669318fd950266", "url": "https://translations.documentfoundation.org/api/units/112434822/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.503797Z" }, { "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": -998394724241651719, "content_hash": -998394724241651719, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\npar_id3153467\nhelp.text", "note": "XHjhc", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6516, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/111144114/?format=api", "priority": 100, "id": 112434823, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=7224fd49bbf3c7f9", "url": "https://translations.documentfoundation.org/api/units/112434823/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.504723Z" }, { "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": 2622333316091886762, "content_hash": 2622333316091886762, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\npar_id3155000\nhelp.text", "note": "XEqxw", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6517, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 34, "source_unit": "https://translations.documentfoundation.org/api/units/111144160/?format=api", "priority": 100, "id": 112434824, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=a4646641dc543caa", "url": "https://translations.documentfoundation.org/api/units/112434824/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.505681Z" }, { "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 down (away from zero); if <emph>Mode</emph> is equal to zero or not given, negative numbers are rounded up (towards zero)." ], "previous_source": "", "target": [ "" ], "id_hash": -1673702869440489036, "content_hash": -1673702869440489036, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\npar_id3155020\nhelp.text", "note": "AosjB", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6518, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 59, "source_unit": "https://translations.documentfoundation.org/api/units/111144227/?format=api", "priority": 100, "id": 112434825, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=68c5d01b9f7299b4", "url": "https://translations.documentfoundation.org/api/units/112434825/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.506659Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<input>=CEILING(3.45)</input> returns 4." ], "previous_source": "", "target": [ "" ], "id_hash": 9212378349686821225, "content_hash": 9212378349686821225, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\npar_id281586208138400\nhelp.text", "note": "Ka9pC", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6519, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111144284/?format=api", "priority": 100, "id": 112434826, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=ffd8f14cbd951169", "url": "https://translations.documentfoundation.org/api/units/112434826/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.507685Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<input>=CEILING(3.45; 3)</input> returns 6." ], "previous_source": "", "target": [ "" ], "id_hash": -8155502805938692339, "content_hash": -8155502805938692339, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\npar_id921586208142416\nhelp.text", "note": "UTtFZ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6520, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/111144353/?format=api", "priority": 100, "id": 112434827, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=0ed1d5685f529f0d", "url": "https://translations.documentfoundation.org/api/units/112434827/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.508605Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<input>=CEILING(-1.234)</input> returns -1." ], "previous_source": "", "target": [ "" ], "id_hash": -2324458641947819717, "content_hash": -2324458641947819717, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\npar_id921586208146984\nhelp.text", "note": "XGfA3", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6521, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111144413/?format=api", "priority": 100, "id": 112434828, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=5fbddd2e3f9d013b", "url": "https://translations.documentfoundation.org/api/units/112434828/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.509548Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<input>=CEILING(-45.67; -2; 0)</input> returns -44." ], "previous_source": "", "target": [ "" ], "id_hash": -271396810875599421, "content_hash": -271396810875599421, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\npar_id491586208152183\nhelp.text", "note": "ZWjxy", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6522, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/111144462/?format=api", "priority": 100, "id": 112434829, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=7c3bce09d69605c3", "url": "https://translations.documentfoundation.org/api/units/112434829/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.510496Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<input>=CEILING(-45.67; -2; 1)</input> returns -46." ], "previous_source": "", "target": [ "" ], "id_hash": -2051302800151829384, "content_hash": -2051302800151829384, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\npar_id291586208158119\nhelp.text", "note": "Auwyx", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6523, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/111144524/?format=api", "priority": 100, "id": 112434830, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=63884ef8b62fa478", "url": "https://translations.documentfoundation.org/api/units/112434830/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.511459Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<bookmark_value>CEILING.PRECISE function</bookmark_value><bookmark_value>rounding;up to multiples of significance</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": 1789962222004316248, "content_hash": 1789962222004316248, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\nbm_id2952518\nhelp.text", "note": "rZ78k", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6524, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/111144564/?format=api", "priority": 100, "id": 112434831, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=98d7392843efa858", "url": "https://translations.documentfoundation.org/api/units/112434831/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.512424Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<variable id=\"CEILING.PRECISEh1\"><link href=\"text/scalc/01/func_ceiling.xhp#ceilingprecise\">CEILING.PRECISE</link></variable>" ], "previous_source": "", "target": [ "" ], "id_hash": 2531219869909523550, "content_hash": 2531219869909523550, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\nhd_id2952518\nhelp.text", "note": "JGH6b", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6525, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111144636/?format=api", "priority": 100, "id": 112434832, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=a320b30f8a5e1c5e", "url": "https://translations.documentfoundation.org/api/units/112434832/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.513395Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_CEIL_MS\">Rounds a number up to the nearest multiple of a significance value.</ahelp>" ], "previous_source": "", "target": [ "" ], "id_hash": -4996043538607062527, "content_hash": -4996043538607062527, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\npar_id2953422\nhelp.text", "note": "aTD6P", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6526, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/111144678/?format=api", "priority": 100, "id": 112434833, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=3aaa7cdf2ef0c201", "url": "https://translations.documentfoundation.org/api/units/112434833/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.514360Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "For a positive number the function rounds up (away from zero). For a negative number, the function rounds up (towards zero). The sign of the significance value is ignored." ], "previous_source": "", "target": [ "" ], "id_hash": 6496901381443936444, "content_hash": 6496901381443936444, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\npar_id151586642494759\nhelp.text", "note": "BjuBa", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6527, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/111144756/?format=api", "priority": 100, "id": 112434834, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=da29a16265b5e0bc", "url": "https://translations.documentfoundation.org/api/units/112434834/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.515328Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "This function calculates identical results to the <link href=\"text/scalc/01/func_ceiling.xhp#isoceiling\">ISO.CEILING</link> function." ], "previous_source": "", "target": [ "" ], "id_hash": -4165585259038146892, "content_hash": -4165585259038146892, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\npar_id631586642933797\nhelp.text", "note": "zDBKp", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6528, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/111144800/?format=api", "priority": 100, "id": 112434835, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=4630de46f16d7eb4", "url": "https://translations.documentfoundation.org/api/units/112434835/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.516369Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "CEILING.PRECISE(Number [; Significance])" ], "previous_source": "", "target": [ "" ], "id_hash": -5741669346813274781, "content_hash": -5741669346813274781, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\npar_id2953454\nhelp.text", "note": "BASfr", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6529, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111144856/?format=api", "priority": 100, "id": 112434836, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=30517e2655721563", "url": "https://translations.documentfoundation.org/api/units/112434836/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.517345Z" }, { "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": 3203619836300210175, "content_hash": 3203619836300210175, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\npar_id2955000\nhelp.text", "note": "FaYeD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6530, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/111144902/?format=api", "priority": 100, "id": 112434837, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=ac758b448211afff", "url": "https://translations.documentfoundation.org/api/units/112434837/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.518272Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<input>=CEILING.PRECISE(3.45)</input> returns 4." ], "previous_source": "", "target": [ "" ], "id_hash": 6180524466943204036, "content_hash": 6180524466943204036, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\npar_id201586213398634\nhelp.text", "note": "8WiRx", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6531, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111144965/?format=api", "priority": 100, "id": 112434838, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=d5c5a241c1c29ac4", "url": "https://translations.documentfoundation.org/api/units/112434838/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.519250Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<input>=CEILING.PRECISE(-45.67; 2)</input> returns -44." ], "previous_source": "", "target": [ "" ], "id_hash": -1020456526438809540, "content_hash": -1020456526438809540, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\npar_id651586213406243\nhelp.text", "note": "KxeUC", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6532, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/111144999/?format=api", "priority": 100, "id": 112434839, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=71d69c3220e2c03c", "url": "https://translations.documentfoundation.org/api/units/112434839/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.520195Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<bookmark_value>CEILING.MATH function</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": 8192352471206827237, "content_hash": 8192352471206827237, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\nbm_id911516997198644\nhelp.text", "note": "WV9bx", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6533, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111145047/?format=api", "priority": 100, "id": 112434840, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=f1b1152ae91394e5", "url": "https://translations.documentfoundation.org/api/units/112434840/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.521130Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<variable id=\"CEILING.MATHh1\"><link href=\"text/scalc/01/func_ceiling.xhp#ceilingmath\">CEILING.MATH</link></variable>" ], "previous_source": "", "target": [ "" ], "id_hash": -3577212344597263070, "content_hash": -3577212344597263070, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\nhd_id91516997330445\nhelp.text", "note": "AuCnM", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6534, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111145075/?format=api", "priority": 100, "id": 112434841, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=4e5b305352234d22", "url": "https://translations.documentfoundation.org/api/units/112434841/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.522096Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_CEIL_MATH\">Rounds a number to the nearest multiple of a significance value.</ahelp>" ], "previous_source": "", "target": [ "" ], "id_hash": -1890171042092206192, "content_hash": -1890171042092206192, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\npar_id81516997342088\nhelp.text", "note": "AzJvD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6535, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/111145117/?format=api", "priority": 100, "id": 112434842, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=65c4c373a75d3790", "url": "https://translations.documentfoundation.org/api/units/112434842/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.523049Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "For a positive number the function rounds up (away from 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": 6222299648396735976, "content_hash": 6222299648396735976, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\npar_id911586642319078\nhelp.text", "note": "QLGe7", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6536, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 36, "source_unit": "https://translations.documentfoundation.org/api/units/111145137/?format=api", "priority": 100, "id": 112434843, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=d65a0c9024b9b5e8", "url": "https://translations.documentfoundation.org/api/units/112434843/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.524024Z" }, { "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": -5444425522060555387, "content_hash": -5444425522060555387, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\npar_id291516998575663\nhelp.text", "note": "aYczG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6537, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/111145139/?format=api", "priority": 100, "id": 112434844, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=347183d55f828b85", "url": "https://translations.documentfoundation.org/api/units/112434844/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.525019Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "CEILING.MATH(Number [; Significance [; Mode]])" ], "previous_source": "", "target": [ "" ], "id_hash": 2164538349252456848, "content_hash": 2164538349252456848, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\npar_id841516997669932\nhelp.text", "note": "pcXnS", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6538, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/111145140/?format=api", "priority": 100, "id": 112434845, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=9e09fc2911e73190", "url": "https://translations.documentfoundation.org/api/units/112434845/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.525957Z" }, { "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": -7670770237816061719, "content_hash": -7670770237816061719, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\npar_id491516997725772\nhelp.text", "note": "EAezJ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6539, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/111145141/?format=api", "priority": 100, "id": 112434846, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=158bf31c3555c0e9", "url": "https://translations.documentfoundation.org/api/units/112434846/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.526901Z" }, { "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 down (away from zero). If <emph>Mode</emph> is equal to zero or is not given, a negative <emph>Number</emph> is rounded up (towards zero)." ], "previous_source": "", "target": [ "" ], "id_hash": -6431286464945494539, "content_hash": -6431286464945494539, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\npar_id451516997742909\nhelp.text", "note": "EiWLa", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6540, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 50, "source_unit": "https://translations.documentfoundation.org/api/units/111145142/?format=api", "priority": 100, "id": 112434847, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=26bf7b08d82565f5", "url": "https://translations.documentfoundation.org/api/units/112434847/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.527863Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<input>=CEILING.MATH(3.45)</input> returns 4." ], "previous_source": "", "target": [ "" ], "id_hash": 7993634044917983332, "content_hash": 7993634044917983332, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\npar_id331586208590009\nhelp.text", "note": "je22s", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6541, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111145143/?format=api", "priority": 100, "id": 112434848, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=eeef17cfcfce2864", "url": "https://translations.documentfoundation.org/api/units/112434848/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.528853Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<input>=CEILING.MATH(3.45; -3)</input> returns 6." ], "previous_source": "", "target": [ "" ], "id_hash": 4454307408764486246, "content_hash": 4454307408764486246, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\npar_id481586208595809\nhelp.text", "note": "g5xAQ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6542, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/111145178/?format=api", "priority": 100, "id": 112434849, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=bdd0e0fd03cc4266", "url": "https://translations.documentfoundation.org/api/units/112434849/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.529780Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<input>=CEILING.MATH(-1.234)</input> returns -1." ], "previous_source": "", "target": [ "" ], "id_hash": 5299770118878736921, "content_hash": 5299770118878736921, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\npar_id641586208600665\nhelp.text", "note": "Eby7i", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6543, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111145220/?format=api", "priority": 100, "id": 112434850, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=c98c90d7feff3219", "url": "https://translations.documentfoundation.org/api/units/112434850/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.530746Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<input>=CEILING.MATH(-45.67; -2; 0)</input> returns -44." ], "previous_source": "", "target": [ "" ], "id_hash": 8994250025228569521, "content_hash": 8994250025228569521, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\npar_id151586208604536\nhelp.text", "note": "T4orc", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6544, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/111145252/?format=api", "priority": 100, "id": 112434851, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=fcd1febe8ecc0bb1", "url": "https://translations.documentfoundation.org/api/units/112434851/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.531684Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<input>=CEILING.MATH(-45.67; +2; 1)</input> returns -46." ], "previous_source": "", "target": [ "" ], "id_hash": -4670121198902881817, "content_hash": -4670121198902881817, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\npar_id971586208611345\nhelp.text", "note": "opt6B", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6545, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/111145296/?format=api", "priority": 100, "id": 112434852, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=3f306583515f51e7", "url": "https://translations.documentfoundation.org/api/units/112434852/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.532595Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<bookmark_value>CEILING.XCL function</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": 5600177986354516026, "content_hash": 5600177986354516026, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\nbm_id921516998608939\nhelp.text", "note": "EzE9t", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6546, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/111145343/?format=api", "priority": 100, "id": 112434853, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=cdb7d435239f903a", "url": "https://translations.documentfoundation.org/api/units/112434853/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.533527Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<variable id=\"CEILING.XCLh1\"><link href=\"text/scalc/01/func_ceiling.xhp#ceilingxcl\">CEILING.XCL</link></variable>" ], "previous_source": "", "target": [ "" ], "id_hash": 2148496699539188946, "content_hash": 2148496699539188946, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\nhd_id411516998838823\nhelp.text", "note": "xEwWL", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6547, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/111145356/?format=api", "priority": 100, "id": 112434854, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=9dd0fe5d7121ecd2", "url": "https://translations.documentfoundation.org/api/units/112434854/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.534451Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/iu/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_CEIL_MS\">Rounds a number to the nearest multiple of a significance value.</ahelp>" ], "previous_source": "", "target": [ "" ], "id_hash": -216340762606324190, "content_hash": -216340762606324190, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\npar_id811516998845826\nhelp.text", "note": "2tuD3", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6548, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/111145410/?format=api", "priority": 100, "id": 112434855, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=7cff6738fe69b622", "url": "https://translations.documentfoundation.org/api/units/112434855/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.535400Z" }, { "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 up (away from zero). For a negative number and a positive significance value, the function rounds up (towards zero). For a negative number and a negative significance value, the function rounds down (away from zero). The function returns an error if the number is positive and the significance value is negative." ], "previous_source": "", "target": [ "" ], "id_hash": -2720536968782463001, "content_hash": -2720536968782463001, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\npar_id361586213828675\nhelp.text", "note": "tAyJj", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6549, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 63, "source_unit": "https://translations.documentfoundation.org/api/units/111145450/?format=api", "priority": 100, "id": 112434856, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=5a3eb60a79673fe7", "url": "https://translations.documentfoundation.org/api/units/112434856/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.536338Z" }, { "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 CEILING.XCL function are exported as references to Excel’s CEILING function, which is compatible with all Excel versions. If a Microsoft Excel spreadsheet is imported into Calc, references to Excel’s CEILING function are imported as references to Calc’s CEILING.XCL function." ], "previous_source": "", "target": [ "" ], "id_hash": -5372211519528605161, "content_hash": -5372211519528605161, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\npar_id881586213934118\nhelp.text", "note": "2CKjm", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6550, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 62, "source_unit": "https://translations.documentfoundation.org/api/units/111145511/?format=api", "priority": 100, "id": 112434857, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/iu/?checksum=35721216103c6a17", "url": "https://translations.documentfoundation.org/api/units/112434857/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:23:19.537338Z" } ] }