Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-24-2/textscalc01/hsb/units/?format=api&page=131
{ "count": 8439, "next": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/units/?format=api&page=132", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/units/?format=api&page=130", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358857, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=7f7477f7e8414f65", "url": "https://translations.documentfoundation.org/api/units/112358857/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.570490Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358858, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=9c3dfa26cb5857bf", "url": "https://translations.documentfoundation.org/api/units/112358858/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.571449Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "Reference to a cell as a criterion" ], "previous_source": "", "target": [ "" ], "id_hash": -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": 112358859, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=5573d36c2fa1d93a", "url": "https://translations.documentfoundation.org/api/units/112358859/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.572418Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "If you need to change a criterion easily, you may want to specify it in a separate cell and use a reference to this cell in the condition of 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": 112358860, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=20bd3e40782fdd12", "url": "https://translations.documentfoundation.org/api/units/112358860/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.573351Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358861, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=e78478fdfdede8d7", "url": "https://translations.documentfoundation.org/api/units/112358861/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.574342Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358862, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=135c2395d3a197e7", "url": "https://translations.documentfoundation.org/api/units/112358862/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.575270Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?format=api", "source": [ "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/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": 112358863, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=391b7a7a9a6e6f31", "url": "https://translations.documentfoundation.org/api/units/112358863/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.576221Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358864, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=9655c654d9225989", "url": "https://translations.documentfoundation.org/api/units/112358864/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.577157Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358865, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=e217cf29d5329796", "url": "https://translations.documentfoundation.org/api/units/112358865/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.578062Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358866, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=2a9b43b55a81e7f5", "url": "https://translations.documentfoundation.org/api/units/112358866/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.579013Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358867, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=2678a84effe6b2e6", "url": "https://translations.documentfoundation.org/api/units/112358867/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.579978Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358868, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=cde4a8ce4cc128dc", "url": "https://translations.documentfoundation.org/api/units/112358868/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.580924Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358869, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=b4b01c26adec3d20", "url": "https://translations.documentfoundation.org/api/units/112358869/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.581868Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358870, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=7da3ae6166fe240b", "url": "https://translations.documentfoundation.org/api/units/112358870/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.582894Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358871, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=93669318fd950266", "url": "https://translations.documentfoundation.org/api/units/112358871/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.583908Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358872, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=7224fd49bbf3c7f9", "url": "https://translations.documentfoundation.org/api/units/112358872/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.584831Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358873, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=a4646641dc543caa", "url": "https://translations.documentfoundation.org/api/units/112358873/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.585766Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358874, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=68c5d01b9f7299b4", "url": "https://translations.documentfoundation.org/api/units/112358874/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.586748Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358875, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=ffd8f14cbd951169", "url": "https://translations.documentfoundation.org/api/units/112358875/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.587760Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358876, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=0ed1d5685f529f0d", "url": "https://translations.documentfoundation.org/api/units/112358876/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.588678Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358877, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=5fbddd2e3f9d013b", "url": "https://translations.documentfoundation.org/api/units/112358877/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.589609Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358878, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=7c3bce09d69605c3", "url": "https://translations.documentfoundation.org/api/units/112358878/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.590527Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358879, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=63884ef8b62fa478", "url": "https://translations.documentfoundation.org/api/units/112358879/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.591458Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358880, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=98d7392843efa858", "url": "https://translations.documentfoundation.org/api/units/112358880/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.592378Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358881, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=a320b30f8a5e1c5e", "url": "https://translations.documentfoundation.org/api/units/112358881/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.593358Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358882, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=3aaa7cdf2ef0c201", "url": "https://translations.documentfoundation.org/api/units/112358882/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.594293Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358883, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=da29a16265b5e0bc", "url": "https://translations.documentfoundation.org/api/units/112358883/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.595224Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358884, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=4630de46f16d7eb4", "url": "https://translations.documentfoundation.org/api/units/112358884/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.596217Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358885, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=30517e2655721563", "url": "https://translations.documentfoundation.org/api/units/112358885/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.597149Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358886, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=ac758b448211afff", "url": "https://translations.documentfoundation.org/api/units/112358886/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.598068Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358887, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=d5c5a241c1c29ac4", "url": "https://translations.documentfoundation.org/api/units/112358887/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.599026Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358888, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=71d69c3220e2c03c", "url": "https://translations.documentfoundation.org/api/units/112358888/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.599944Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358889, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=f1b1152ae91394e5", "url": "https://translations.documentfoundation.org/api/units/112358889/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.600855Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358890, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=4e5b305352234d22", "url": "https://translations.documentfoundation.org/api/units/112358890/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.601775Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358891, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=65c4c373a75d3790", "url": "https://translations.documentfoundation.org/api/units/112358891/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.602705Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358892, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=d65a0c9024b9b5e8", "url": "https://translations.documentfoundation.org/api/units/112358892/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.603635Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358893, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=347183d55f828b85", "url": "https://translations.documentfoundation.org/api/units/112358893/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.604594Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358894, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=9e09fc2911e73190", "url": "https://translations.documentfoundation.org/api/units/112358894/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.605509Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358895, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=158bf31c3555c0e9", "url": "https://translations.documentfoundation.org/api/units/112358895/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.606416Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358896, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=26bf7b08d82565f5", "url": "https://translations.documentfoundation.org/api/units/112358896/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.607443Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358897, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=eeef17cfcfce2864", "url": "https://translations.documentfoundation.org/api/units/112358897/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.608450Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358898, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=bdd0e0fd03cc4266", "url": "https://translations.documentfoundation.org/api/units/112358898/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.609367Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358899, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=c98c90d7feff3219", "url": "https://translations.documentfoundation.org/api/units/112358899/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.610276Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358900, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=fcd1febe8ecc0bb1", "url": "https://translations.documentfoundation.org/api/units/112358900/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.611202Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358901, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=3f306583515f51e7", "url": "https://translations.documentfoundation.org/api/units/112358901/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.612116Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358902, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=cdb7d435239f903a", "url": "https://translations.documentfoundation.org/api/units/112358902/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.613023Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358903, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=9dd0fe5d7121ecd2", "url": "https://translations.documentfoundation.org/api/units/112358903/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.613942Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358904, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=7cff6738fe69b622", "url": "https://translations.documentfoundation.org/api/units/112358904/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.614915Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358905, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=5a3eb60a79673fe7", "url": "https://translations.documentfoundation.org/api/units/112358905/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.615846Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/hsb/?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": 112358906, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/hsb/?checksum=35721216103c6a17", "url": "https://translations.documentfoundation.org/api/units/112358906/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:19:25.616843Z" } ] }