Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-7-6/textscalc01/ast/units/?format=api&page=129
https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/units/?format=api&page=130", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/units/?format=api&page=128", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "AVERAGEIFS function" ], "previous_source": "", "target": [ "" ], "id_hash": -8231205857855212900, "content_hash": -8231205857855212900, "location": "func_averageifs.xhp", "context": "func_averageifs.xhp\ntit\nhelp.text", "note": "TUEKr", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6401, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99296631/?format=api", "priority": 100, "id": 99525857, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=0dc4e1e2116cf29c", "url": "https://translations.documentfoundation.org/api/units/99525857/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:25.945661Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<bookmark_value>AVERAGEIFS function</bookmark_value> <bookmark_value>arithmetic mean;satisfying conditions</bookmark_value>" ], "previous_source": "", "target": [ "<bookmark_value>DESVPROM</bookmark_value><bookmark_value>promedios;funciones estadístiques</bookmark_value>" ], "id_hash": 6968964040490941999, "content_hash": 6968964040490941999, "location": "func_averageifs.xhp", "context": "func_averageifs.xhp\nbm_id536715367153671\nhelp.text", "note": "DDuFq", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6402, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/99296672/?format=api", "priority": 100, "id": 99525860, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=e0b6bbdf25eefe2f", "url": "https://translations.documentfoundation.org/api/units/99525860/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:25.947034Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<variable id=\"averageifs_head\"><link href=\"text/scalc/01/func_averageifs.xhp\">AVERAGEIFS</link></variable> function" ], "previous_source": "", "target": [ "<variable id=\"second\"><link href=\"text/scalc/01/func_second.xhp\">SEGUNDU</link></variable>" ], "id_hash": -1407714252203597011, "content_hash": -1407714252203597011, "location": "func_averageifs.xhp", "context": "func_averageifs.xhp\nhd_id537445374453744\nhelp.text", "note": "uGhsw", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6403, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/99296702/?format=api", "priority": 100, "id": 99525864, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=6c76cb589426632d", "url": "https://translations.documentfoundation.org/api/units/99525864/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:25.949063Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<ahelp hid=\".\"><variable id=\"averageifs_des\">Returns the arithmetic mean of all cells in a range that satisfy given multiple criteria. The AVERAGEIFS function sums up all the results that match the logical tests and divides this sum by the quantity of selected values.</variable></ahelp>" ], "previous_source": "", "target": [ "" ], "id_hash": 3279985427204285555, "content_hash": 3279985427204285555, "location": "func_averageifs.xhp", "context": "func_averageifs.xhp\npar_id538405384053840\nhelp.text", "note": "CZ8LX", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6404, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 40, "source_unit": "https://translations.documentfoundation.org/api/units/99296726/?format=api", "priority": 100, "id": 99525872, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=ad84d95e30f82473", "url": "https://translations.documentfoundation.org/api/units/99525872/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:25.951679Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "AVERAGEIFS(<embedvar href=\"text/scalc/01/ex_data_stat_func.xhp#args\" markup=\"ignore\"/>)" ], "previous_source": "", "target": [ "" ], "id_hash": 7067003664368111027, "content_hash": 7067003664368111027, "location": "func_averageifs.xhp", "context": "func_averageifs.xhp\npar_id21050267713178\nhelp.text", "note": "zNyZv", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6405, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99296749/?format=api", "priority": 100, "id": 99525876, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=e2130a63e10b8db3", "url": "https://translations.documentfoundation.org/api/units/99525876/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:25.954637Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<emph>Func_range</emph> – required argument. It is a range of cells, a name of a named range or a label of a column or a row containing values for calculating the mean." ], "previous_source": "", "target": [ "" ], "id_hash": -6673945048355538743, "content_hash": -6673945048355538743, "location": "func_averageifs.xhp", "context": "func_averageifs.xhp\npar_id165832700711773\nhelp.text", "note": "8gSoS", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6406, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 31, "source_unit": "https://translations.documentfoundation.org/api/units/99296785/?format=api", "priority": 100, "id": 99525881, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=23616256ae4a78c9", "url": "https://translations.documentfoundation.org/api/units/99525881/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:25.956784Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Simple usage" ], "previous_source": "", "target": [ "" ], "id_hash": -177492428930155164, "content_hash": -177492428930155164, "location": "func_averageifs.xhp", "context": "func_averageifs.xhp\nhd_id20733192524041\nhelp.text", "note": "y7NZn", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6407, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99296814/?format=api", "priority": 100, "id": 99525885, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=7d896b93874bfd64", "url": "https://translations.documentfoundation.org/api/units/99525885/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:25.958835Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<item type=\"input\">=AVERAGEIFS(B2:B6;B2:B6;\">=20\")</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=PROMEDIU(A1:A50)</item>" ], "id_hash": -5171018155499093805, "content_hash": -5171018155499093805, "location": "func_averageifs.xhp", "context": "func_averageifs.xhp\npar_id24004653627203\nhelp.text", "note": "bcbN9", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6408, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99296849/?format=api", "priority": 100, "id": 99525889, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=383cda62826180d3", "url": "https://translations.documentfoundation.org/api/units/99525889/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:25.960305Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Calculates the average for values of the range B2:B6 that are greater than or equal to 20. Returns 25, because the fifth row does not meet the criterion." ], "previous_source": "", "target": [ "" ], "id_hash": -7122264083157546154, "content_hash": -7122264083157546154, "location": "func_averageifs.xhp", "context": "func_averageifs.xhp\npar_id30201168686268\nhelp.text", "note": "NGDGm", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6409, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 28, "source_unit": "https://translations.documentfoundation.org/api/units/99296864/?format=api", "priority": 100, "id": 99525896, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=1d28a28d3edf0b56", "url": "https://translations.documentfoundation.org/api/units/99525896/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:25.964703Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<item type=\"input\">=AVERAGEIFS(C2:C6;B2:B6;\">=20\";C2:C6;\">70\")</item>" ], "previous_source": "", "target": [ "<item type=\"input\">=PROMEDIU(A1:A50)</item>" ], "id_hash": 8739660139979311326, "content_hash": 8739660139979311326, "location": "func_averageifs.xhp", "context": "func_averageifs.xhp\npar_id30279247419921\nhelp.text", "note": "zb4se", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6410, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99296875/?format=api", "priority": 100, "id": 99525899, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=f9498297b51b88de", "url": "https://translations.documentfoundation.org/api/units/99525899/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:25.966355Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Calculates the average for values of the range C2:C6 that are greater than 70 and correspond to cells of B2:B6 with values greater than or equal to 20. Returns 137.5, because the second and fifth rows do not meet at least one criterion." ], "previous_source": "", "target": [ "" ], "id_hash": -9026955012991545679, "content_hash": -9026955012991545679, "location": "func_averageifs.xhp", "context": "func_averageifs.xhp\npar_id2930764965983\nhelp.text", "note": "7jj4X", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6411, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 43, "source_unit": "https://translations.documentfoundation.org/api/units/99296914/?format=api", "priority": 100, "id": 99525907, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=02b9d03e17350eb1", "url": "https://translations.documentfoundation.org/api/units/99525907/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:25.969961Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Using regular expressions and nested functions" ], "previous_source": "", "target": [ "" ], "id_hash": -4802370245918093632, "content_hash": -4802370245918093632, "location": "func_averageifs.xhp", "context": "func_averageifs.xhp\nhd_id317532515726820\nhelp.text", "note": "2pMbp", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6412, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/99296952/?format=api", "priority": 100, "id": 99525912, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=3d5a8db494258ec0", "url": "https://translations.documentfoundation.org/api/units/99525912/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:25.971917Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<item type=\"input\">=AVERAGEIFS(C2:C6;B2:B6;\">\"&MIN(B2:B6);B2:B6;\"<\"&MAX(B2:B6))</item>" ], "previous_source": "", "target": [ "" ], "id_hash": -5400278182055976891, "content_hash": -5400278182055976891, "location": "func_averageifs.xhp", "context": "func_averageifs.xhp\npar_id457966021670\nhelp.text", "note": "qZDFB", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6413, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99296987/?format=api", "priority": 100, "id": 99525918, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=350e5b9af642e045", "url": "https://translations.documentfoundation.org/api/units/99525918/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:25.973757Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "Calculates the average for values of the range C2:C6 that correspond to all values of the range B2:B6 except its minimum and maximum. Returns 127.5, because the third and fifth rows do not meet at least one criterion." ], "previous_source": "", "target": [ "" ], "id_hash": 5272279988237403964, "content_hash": 5272279988237403964, "location": "func_averageifs.xhp", "context": "func_averageifs.xhp\npar_id66091035229950\nhelp.text", "note": "oghLv", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6414, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 38, "source_unit": "https://translations.documentfoundation.org/api/units/99297049/?format=api", "priority": 100, "id": 99525922, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=c92ae6b72f4a873c", "url": "https://translations.documentfoundation.org/api/units/99525922/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:25.975278Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 6415, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99297093/?format=api", "priority": 100, "id": 99525926, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=7f7477f7e8414f65", "url": "https://translations.documentfoundation.org/api/units/99525926/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:25.976800Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 6416, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 41, "source_unit": "https://translations.documentfoundation.org/api/units/99297138/?format=api", "priority": 100, "id": 99525930, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=9c3dfa26cb5857bf", "url": "https://translations.documentfoundation.org/api/units/99525930/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:25.978288Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 6417, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/99297178/?format=api", "priority": 100, "id": 99525932, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=5573d36c2fa1d93a", "url": "https://translations.documentfoundation.org/api/units/99525932/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:25.979855Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 6418, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 41, "source_unit": "https://translations.documentfoundation.org/api/units/99297210/?format=api", "priority": 100, "id": 99525934, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=20bd3e40782fdd12", "url": "https://translations.documentfoundation.org/api/units/99525934/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:25.981349Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 6419, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99297228/?format=api", "priority": 100, "id": 99525938, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=e78478fdfdede8d7", "url": "https://translations.documentfoundation.org/api/units/99525938/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:25.982933Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 6420, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/99297294/?format=api", "priority": 100, "id": 99525940, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=135c2395d3a197e7", "url": "https://translations.documentfoundation.org/api/units/99525940/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:25.984462Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/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": 6421, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/99297354/?format=api", "priority": 100, "id": 99525945, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=391b7a7a9a6e6f31", "url": "https://translations.documentfoundation.org/api/units/99525945/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:25.986168Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 6422, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99297370/?format=api", "priority": 100, "id": 99525949, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=9655c654d9225989", "url": "https://translations.documentfoundation.org/api/units/99525949/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:25.987714Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 6423, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99297386/?format=api", "priority": 100, "id": 99525954, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=e217cf29d5329796", "url": "https://translations.documentfoundation.org/api/units/99525954/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:25.989263Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 6424, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/99297408/?format=api", "priority": 100, "id": 99525957, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=2a9b43b55a81e7f5", "url": "https://translations.documentfoundation.org/api/units/99525957/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:25.990746Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 6425, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99297417/?format=api", "priority": 100, "id": 99525961, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=2678a84effe6b2e6", "url": "https://translations.documentfoundation.org/api/units/99525961/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:25.992257Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 6426, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/99297437/?format=api", "priority": 100, "id": 99525964, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=cde4a8ce4cc128dc", "url": "https://translations.documentfoundation.org/api/units/99525964/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:25.993655Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "For a positive number and a positive significance value, the function rounds 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": 6427, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 52, "source_unit": "https://translations.documentfoundation.org/api/units/99297447/?format=api", "priority": 100, "id": 99525967, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=b4b01c26adec3d20", "url": "https://translations.documentfoundation.org/api/units/99525967/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:25.995210Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "If the spreadsheet is exported to Microsoft Excel, the 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": 6428, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 58, "source_unit": "https://translations.documentfoundation.org/api/units/99297459/?format=api", "priority": 100, "id": 99525970, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=7da3ae6166fe240b", "url": "https://translations.documentfoundation.org/api/units/99525970/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:25.997354Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 6429, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/99297475/?format=api", "priority": 100, "id": 99525978, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=93669318fd950266", "url": "https://translations.documentfoundation.org/api/units/99525978/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:26.002240Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<emph>Number</emph> is the number that is to be rounded, or a reference to a cell containing the number." ], "previous_source": "", "target": [ "" ], "id_hash": -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": 6430, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/99297487/?format=api", "priority": 100, "id": 99525984, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=7224fd49bbf3c7f9", "url": "https://translations.documentfoundation.org/api/units/99525984/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:26.006104Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<emph>Significance</emph> (optional) is the value, or a reference to a cell containing the value, to whose multiple <emph>Number</emph> is to be rounded. It defaults to +1 or -1 depending on the sign of <emph>Number</emph>." ], "previous_source": "", "target": [ "" ], "id_hash": 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": 6431, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 34, "source_unit": "https://translations.documentfoundation.org/api/units/99297508/?format=api", "priority": 100, "id": 99525991, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=a4646641dc543caa", "url": "https://translations.documentfoundation.org/api/units/99525991/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:26.010798Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<emph>Mode</emph> (optional) is a number, or a reference to a cell containing a number. The function only uses <emph>Mode</emph> if both <emph>Number</emph> and <emph>Significance</emph> are negative. Then if <emph>Mode</emph> is given and not equal to zero, numbers are rounded 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": 6432, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 59, "source_unit": "https://translations.documentfoundation.org/api/units/99297532/?format=api", "priority": 100, "id": 99525994, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=68c5d01b9f7299b4", "url": "https://translations.documentfoundation.org/api/units/99525994/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:26.012424Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 6433, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99297550/?format=api", "priority": 100, "id": 99525999, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=ffd8f14cbd951169", "url": "https://translations.documentfoundation.org/api/units/99525999/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:26.014133Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 6434, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/99297589/?format=api", "priority": 100, "id": 99526001, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=0ed1d5685f529f0d", "url": "https://translations.documentfoundation.org/api/units/99526001/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:26.015629Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 6435, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99297610/?format=api", "priority": 100, "id": 99526005, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=5fbddd2e3f9d013b", "url": "https://translations.documentfoundation.org/api/units/99526005/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:26.017559Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 6436, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/99297631/?format=api", "priority": 100, "id": 99526009, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=7c3bce09d69605c3", "url": "https://translations.documentfoundation.org/api/units/99526009/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:26.019312Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 6437, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/99297661/?format=api", "priority": 100, "id": 99526010, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=63884ef8b62fa478", "url": "https://translations.documentfoundation.org/api/units/99526010/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:26.020551Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 6438, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/99297689/?format=api", "priority": 100, "id": 99526014, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=98d7392843efa858", "url": "https://translations.documentfoundation.org/api/units/99526014/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:26.022535Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 6439, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99297723/?format=api", "priority": 100, "id": 99526018, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=a320b30f8a5e1c5e", "url": "https://translations.documentfoundation.org/api/units/99526018/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:26.024597Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 6440, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/99297734/?format=api", "priority": 100, "id": 99526021, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=3aaa7cdf2ef0c201", "url": "https://translations.documentfoundation.org/api/units/99526021/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:26.026106Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 6441, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/99297779/?format=api", "priority": 100, "id": 99526024, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=da29a16265b5e0bc", "url": "https://translations.documentfoundation.org/api/units/99526024/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:26.027594Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 6442, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/99297806/?format=api", "priority": 100, "id": 99526615, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=4630de46f16d7eb4", "url": "https://translations.documentfoundation.org/api/units/99526615/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:27.543733Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 6443, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99297828/?format=api", "priority": 100, "id": 99526618, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=30517e2655721563", "url": "https://translations.documentfoundation.org/api/units/99526618/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:27.547495Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<emph>Significance</emph> (optional) is the value, or a reference to a cell containing the value, to whose multiple <emph>Number</emph> is to be rounded. It defaults to 1." ], "previous_source": "", "target": [ "" ], "id_hash": 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": 6444, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/99297847/?format=api", "priority": 100, "id": 99526621, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=ac758b448211afff", "url": "https://translations.documentfoundation.org/api/units/99526621/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:27.548894Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 6445, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99297879/?format=api", "priority": 100, "id": 99526626, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=d5c5a241c1c29ac4", "url": "https://translations.documentfoundation.org/api/units/99526626/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:27.551102Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 6446, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/99297909/?format=api", "priority": 100, "id": 99526632, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=71d69c3220e2c03c", "url": "https://translations.documentfoundation.org/api/units/99526632/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:27.552726Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 6447, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99297942/?format=api", "priority": 100, "id": 99526637, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=f1b1152ae91394e5", "url": "https://translations.documentfoundation.org/api/units/99526637/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:27.554674Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 6448, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99297978/?format=api", "priority": 100, "id": 99526642, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=4e5b305352234d22", "url": "https://translations.documentfoundation.org/api/units/99526642/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:27.556271Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 6449, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/99298017/?format=api", "priority": 100, "id": 99526645, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=65c4c373a75d3790", "url": "https://translations.documentfoundation.org/api/units/99526645/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:27.557796Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 6450, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 36, "source_unit": "https://translations.documentfoundation.org/api/units/99298058/?format=api", "priority": 100, "id": 99526650, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=d65a0c9024b9b5e8", "url": "https://translations.documentfoundation.org/api/units/99526650/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:27.559330Z" } ] }{ "count": 8352, "next": "