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=130
{ "count": 8352, "next": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/units/?format=api&page=131", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/units/?format=api&page=129", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "This function exists for interoperability with Microsoft Excel 2013 or newer." ], "previous_source": "", "target": [ "" ], "id_hash": -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": 6451, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/99298080/?format=api", "priority": 100, "id": 99526654, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=347183d55f828b85", "url": "https://translations.documentfoundation.org/api/units/99526654/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:27.560737Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 6452, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/99298117/?format=api", "priority": 100, "id": 99526659, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=9e09fc2911e73190", "url": "https://translations.documentfoundation.org/api/units/99526659/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:27.562022Z" }, { "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": -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": 6453, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/99298137/?format=api", "priority": 100, "id": 99526662, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=158bf31c3555c0e9", "url": "https://translations.documentfoundation.org/api/units/99526662/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:27.563246Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<emph>Mode</emph> (optional) is a number, or a reference to a cell containing a number. If <emph>Mode</emph> is given and not equal to zero, a negative <emph>Number</emph> is rounded 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": 6454, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 50, "source_unit": "https://translations.documentfoundation.org/api/units/99298199/?format=api", "priority": 100, "id": 99526665, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=26bf7b08d82565f5", "url": "https://translations.documentfoundation.org/api/units/99526665/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:27.564584Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 6455, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99298225/?format=api", "priority": 100, "id": 99526669, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=eeef17cfcfce2864", "url": "https://translations.documentfoundation.org/api/units/99526669/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:27.566049Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 6456, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/99298253/?format=api", "priority": 100, "id": 99526673, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=bdd0e0fd03cc4266", "url": "https://translations.documentfoundation.org/api/units/99526673/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:27.567489Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 6457, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99298271/?format=api", "priority": 100, "id": 99526677, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=c98c90d7feff3219", "url": "https://translations.documentfoundation.org/api/units/99526677/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:27.569039Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 6458, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/99298371/?format=api", "priority": 100, "id": 99526682, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=fcd1febe8ecc0bb1", "url": "https://translations.documentfoundation.org/api/units/99526682/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:27.570447Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 6459, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/99298407/?format=api", "priority": 100, "id": 99526685, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=3f306583515f51e7", "url": "https://translations.documentfoundation.org/api/units/99526685/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:27.571900Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 6460, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99298448/?format=api", "priority": 100, "id": 99526687, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=cdb7d435239f903a", "url": "https://translations.documentfoundation.org/api/units/99526687/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:27.573321Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 6461, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99298479/?format=api", "priority": 100, "id": 99526691, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=9dd0fe5d7121ecd2", "url": "https://translations.documentfoundation.org/api/units/99526691/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:27.574783Z" }, { "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 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": 6462, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/99298517/?format=api", "priority": 100, "id": 99526694, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=7cff6738fe69b622", "url": "https://translations.documentfoundation.org/api/units/99526694/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:27.576289Z" }, { "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 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": 6463, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 63, "source_unit": "https://translations.documentfoundation.org/api/units/99298552/?format=api", "priority": 100, "id": 99526699, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=5a3eb60a79673fe7", "url": "https://translations.documentfoundation.org/api/units/99526699/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:27.577747Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?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": 6464, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 62, "source_unit": "https://translations.documentfoundation.org/api/units/99298599/?format=api", "priority": 100, "id": 99526703, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=35721216103c6a17", "url": "https://translations.documentfoundation.org/api/units/99526703/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:27.579472Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "CEILING.XCL(Number; Significance)" ], "previous_source": "", "target": [ "" ], "id_hash": 2165936601986222308, "content_hash": 2165936601986222308, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\npar_id251516998856873\nhelp.text", "note": "GspBr", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6465, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99298655/?format=api", "priority": 100, "id": 99526706, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=9e0ef3dd2767c8e4", "url": "https://translations.documentfoundation.org/api/units/99526706/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:27.580898Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<emph>Significance</emph> is the value, or a reference to a cell containing the value, to whose multiple <emph>Number</emph> is to be rounded." ], "previous_source": "", "target": [ "" ], "id_hash": 4996312492937252423, "content_hash": 4996312492937252423, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\npar_id151516998882622\nhelp.text", "note": "eTSgx", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6466, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://translations.documentfoundation.org/api/units/99298726/?format=api", "priority": 100, "id": 99526715, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=c55677bda05f0e47", "url": "https://translations.documentfoundation.org/api/units/99526715/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:27.587892Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<input>=CEILING.XCL(3.45,2)</input> returns 4." ], "previous_source": "", "target": [ "" ], "id_hash": 4633997256615044133, "content_hash": 4633997256615044133, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\npar_id421586214128242\nhelp.text", "note": "6n7qn", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6467, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99298770/?format=api", "priority": 100, "id": 99526720, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=c04f43f3f2aca425", "url": "https://translations.documentfoundation.org/api/units/99526720/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:27.590867Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<input>=CEILING.XCL(-45.67; 2)</input> returns -44." ], "previous_source": "", "target": [ "" ], "id_hash": 6317726029232220705, "content_hash": 6317726029232220705, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\npar_id651586214132234\nhelp.text", "note": "nU46D", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6468, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/99298816/?format=api", "priority": 100, "id": 99526726, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=d7ad1259d0a02a21", "url": "https://translations.documentfoundation.org/api/units/99526726/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:27.592886Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<input>=CEILING.XCL(-45.67; -2)</input> returns -46." ], "previous_source": "", "target": [ "" ], "id_hash": 8766531607628136174, "content_hash": 8766531607628136174, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\npar_id811586214136666\nhelp.text", "note": "nbB96", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6469, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/99298854/?format=api", "priority": 100, "id": 99526736, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=f9a8fa0cd0e8beee", "url": "https://translations.documentfoundation.org/api/units/99526736/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:27.597700Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<bookmark_value>ISO.CEILING function</bookmark_value><bookmark_value>rounding;up to multiples of significance</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": 2812615316449939906, "content_hash": 2812615316449939906, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\nbm_id8952518\nhelp.text", "note": "GMzhD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6470, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/99298872/?format=api", "priority": 100, "id": 99526741, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=a7086aba7ad251c2", "url": "https://translations.documentfoundation.org/api/units/99526741/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:27.599582Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<variable id=\"ISO.CEILINGh1\"><link href=\"text/scalc/01/func_ceiling.xhp#isoceiling\">ISO.CEILING</link></variable>" ], "previous_source": "", "target": [ "" ], "id_hash": 7546140143595733875, "content_hash": 7546140143595733875, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\nhd_id8952518\nhelp.text", "note": "2gaUP", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6471, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99298896/?format=api", "priority": 100, "id": 99526746, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=e8b9467abc56c373", "url": "https://translations.documentfoundation.org/api/units/99526746/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:27.601389Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_CEIL_ISO\">Rounds a number up to the nearest multiple of a significance value.</ahelp>" ], "previous_source": "", "target": [ "" ], "id_hash": -1216258126880525211, "content_hash": -1216258126880525211, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\npar_id8953422\nhelp.text", "note": "5beBC", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6472, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/99298921/?format=api", "priority": 100, "id": 99526751, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=6f1efbad781ab465", "url": "https://translations.documentfoundation.org/api/units/99526751/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:27.603091Z" }, { "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": 1737661756711472546, "content_hash": 1737661756711472546, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\npar_id101586214229587\nhelp.text", "note": "SFZNu", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6473, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/99298951/?format=api", "priority": 100, "id": 99526756, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=981d6a2944918da2", "url": "https://translations.documentfoundation.org/api/units/99526756/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:27.604732Z" }, { "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#ceilingprecise\">CEILING.PRECISE</link> function." ], "previous_source": "", "target": [ "" ], "id_hash": -5374715537459240803, "content_hash": -5374715537459240803, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\npar_id821586214265060\nhelp.text", "note": "wVZdq", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6474, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/99298991/?format=api", "priority": 100, "id": 99526760, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=35692cb1f4f8209d", "url": "https://translations.documentfoundation.org/api/units/99526760/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:27.606300Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "ISO.CEILING(Number [; Significance])" ], "previous_source": "", "target": [ "" ], "id_hash": -8062904886682791987, "content_hash": -8062904886682791987, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\npar_id8953454\nhelp.text", "note": "GRocX", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6475, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99299038/?format=api", "priority": 100, "id": 99526766, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=101aceb98382cfcd", "url": "https://translations.documentfoundation.org/api/units/99526766/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:27.607963Z" }, { "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": -3290754190048304586, "content_hash": -3290754190048304586, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\npar_id8955000\nhelp.text", "note": "hwhCW", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6476, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/99299072/?format=api", "priority": 100, "id": 99526782, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=5254e47fd30ae236", "url": "https://translations.documentfoundation.org/api/units/99526782/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:27.614918Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<input>=ISO.CEILING(3.45)</input> returns 4." ], "previous_source": "", "target": [ "" ], "id_hash": 9154127805081146541, "content_hash": 9154127805081146541, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\npar_id801586214431463\nhelp.text", "note": "FSFdP", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6477, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99299101/?format=api", "priority": 100, "id": 99526790, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=ff09febcf26354ad", "url": "https://translations.documentfoundation.org/api/units/99526790/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:27.617619Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<input>=ISO.CEILING(-45.67; 2)</input> returns -44." ], "previous_source": "", "target": [ "" ], "id_hash": 8861515598255493092, "content_hash": 8861515598255493092, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\npar_id181586214438808\nhelp.text", "note": "QHpJp", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6478, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/99299120/?format=api", "priority": 100, "id": 99526822, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=fafa6d7c7d9a0fe4", "url": "https://translations.documentfoundation.org/api/units/99526822/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:27.701062Z" }, { "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/CEILING\">CEILING</link>, <link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/CEILING.XCL\">CEILING.XCL</link>, <link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/CEILING.PRECISE\">CEILING.PRECISE</link>, <link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/ISO.CEILING\">ISO.CEILING</link>, <link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/CEILING.MATH\">CEILING.MATH</link> wiki pages." ], "previous_source": "", "target": [ "" ], "id_hash": -5183683797512784402, "content_hash": -5183683797512784402, "location": "func_ceiling.xhp", "context": "func_ceiling.xhp\npar_id971677016806972\nhelp.text", "note": "nBBCB", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6479, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/99299148/?format=api", "priority": 100, "id": 99526826, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=380fdb0ced4d75ee", "url": "https://translations.documentfoundation.org/api/units/99526826/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:27.704020Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "COLOR function" ], "previous_source": "", "target": [ "" ], "id_hash": -8037245958908344347, "content_hash": -8037245958908344347, "location": "func_color.xhp", "context": "func_color.xhp\ntit\nhelp.text", "note": "GuEcB", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6480, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99299191/?format=api", "priority": 100, "id": 99526830, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=1075f7622ed307e5", "url": "https://translations.documentfoundation.org/api/units/99526830/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:27.705798Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<bookmark_value>colors;numerical values</bookmark_value> <bookmark_value>colors;calculating in spreadsheets</bookmark_value> <bookmark_value>COLOR function</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": -3503870829010199345, "content_hash": -3503870829010199345, "location": "func_color.xhp", "context": "func_color.xhp\nbm_id1102201617201921\nhelp.text", "note": "N8CUu", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6481, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/99299211/?format=api", "priority": 100, "id": 99526834, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=4f5fc00b99fe5ccf", "url": "https://translations.documentfoundation.org/api/units/99526834/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:27.707843Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<variable id=\"color_head\"><link href=\"text/scalc/01/func_color.xhp\">COLOR</link></variable>" ], "previous_source": "", "target": [ "<variable id=\"hour\"><link href=\"text/scalc/01/func_hour.xhp\">HORA</link></variable>" ], "id_hash": -8821725746593725306, "content_hash": -8821725746593725306, "location": "func_color.xhp", "context": "func_color.xhp\nhd_id456845684568\nhelp.text", "note": "qjPSR", "flags": "", "labels": [], "state": 20, "fuzzy": false, "translated": true, "approved": false, "position": 6482, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99299238/?format=api", "priority": 100, "id": 99526838, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=0592ef2c485d0486", "url": "https://translations.documentfoundation.org/api/units/99526838/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:27.709552Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<ahelp hid=\".\">Return a numeric value calculated by a combination of three colors (red, green and blue) and the alpha channel, in the RGBA color system.</ahelp> The result depends on the color system used by your computer." ], "previous_source": "", "target": [ "" ], "id_hash": -1203832068311828611, "content_hash": -1203832068311828611, "location": "func_color.xhp", "context": "func_color.xhp\npar_id1102201617001848\nhelp.text", "note": "HXh5E", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6483, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 36, "source_unit": "https://translations.documentfoundation.org/api/units/99299264/?format=api", "priority": 100, "id": 99526847, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=6f4b211caf0cb77d", "url": "https://translations.documentfoundation.org/api/units/99526847/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:27.713669Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "COLOR(Red; Green; Blue [; Alpha])" ], "previous_source": "", "target": [ "" ], "id_hash": -8128831625295429542, "content_hash": -8128831625295429542, "location": "func_color.xhp", "context": "func_color.xhp\npar_id27421466710275\nhelp.text", "note": "3ubzF", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6484, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/99299309/?format=api", "priority": 100, "id": 99526852, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=0f3096b4874e005a", "url": "https://translations.documentfoundation.org/api/units/99526852/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:27.716319Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<emph>Red, Green and Blue</emph> – required arguments. The value for the red, green and blue components of the color. The values must be between 0 and 255. Zero means no color component and 255 means full color component." ], "previous_source": "", "target": [ "" ], "id_hash": 224638577614200603, "content_hash": 224638577614200603, "location": "func_color.xhp", "context": "func_color.xhp\npar_id242131304318587\nhelp.text", "note": "ASLWJ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6485, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 38, "source_unit": "https://translations.documentfoundation.org/api/units/99299334/?format=api", "priority": 100, "id": 99526859, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=831e13989d8b1f1b", "url": "https://translations.documentfoundation.org/api/units/99526859/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:27.721659Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<emph>Alpha</emph> – optional argument. The value for the alpha channel or alpha composite. Alpha is a integer value between 0 and 255. The value of zero for alpha means the color is fully transparent, whereas a value of 255 in the alpha channel gives a fully opaque color." ], "previous_source": "", "target": [ "" ], "id_hash": 8574439046245092510, "content_hash": 8574439046245092510, "location": "func_color.xhp", "context": "func_color.xhp\npar_id242131304315587\nhelp.text", "note": "GoCn2", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6486, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 48, "source_unit": "https://translations.documentfoundation.org/api/units/99299370/?format=api", "priority": 100, "id": 99526870, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=f6fe86e21bad8c9e", "url": "https://translations.documentfoundation.org/api/units/99526870/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:27.729186Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<item type=\"input\">COLOR(255;255;255;1)</item> returns 33554431" ], "previous_source": "", "target": [ "" ], "id_hash": -3533301182499384046, "content_hash": -3533301182499384046, "location": "func_color.xhp", "context": "func_color.xhp\npar_id1102201617001888\nhelp.text", "note": "fb2sj", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6487, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/99299419/?format=api", "priority": 100, "id": 99526879, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=4ef7314b74a81512", "url": "https://translations.documentfoundation.org/api/units/99526879/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:27.735846Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<item type=\"input\">COLOR(0;0;255;0)</item> returns 255" ], "previous_source": "", "target": [ "" ], "id_hash": 4921398467606995934, "content_hash": 4921398467606995934, "location": "func_color.xhp", "context": "func_color.xhp\npar_id1102201618185378\nhelp.text", "note": "gxbF2", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6488, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/99299438/?format=api", "priority": 100, "id": 99526887, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=c44c51d4e3dde3de", "url": "https://translations.documentfoundation.org/api/units/99526887/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:27.898074Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<item type=\"input\">COLOR(0;0;255;255)</item> returns 4278190335" ], "previous_source": "", "target": [ "" ], "id_hash": 8589781915333483172, "content_hash": 8589781915333483172, "location": "func_color.xhp", "context": "func_color.xhp\npar_id1102201618185326\nhelp.text", "note": "f8bh7", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6489, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/99299481/?format=api", "priority": 100, "id": 99526895, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=f73509243186daa4", "url": "https://translations.documentfoundation.org/api/units/99526895/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:27.903852Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<item type=\"input\">COLOR(0;0;400;0)</item> returns Err:502 (Invalid argument) because the blue value is greater than 255." ], "previous_source": "", "target": [ "" ], "id_hash": -224256149759823711, "content_hash": -224256149759823711, "location": "func_color.xhp", "context": "func_color.xhp\npar_id1102201618188326\nhelp.text", "note": "JAYa2", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6490, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/99299515/?format=api", "priority": 100, "id": 99526904, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=7ce348384ede70a1", "url": "https://translations.documentfoundation.org/api/units/99526904/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:27.907742Z" }, { "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/COLOR\">COLOR wiki page</link>." ], "previous_source": "", "target": [ "" ], "id_hash": -7318931641100933967, "content_hash": -7318931641100933967, "location": "func_color.xhp", "context": "func_color.xhp\npar_id61677016779611\nhelp.text", "note": "vRBbH", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6491, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/99299543/?format=api", "priority": 100, "id": 99526909, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=1a6dee7324cfe4b1", "url": "https://translations.documentfoundation.org/api/units/99526909/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:27.911342Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "CONCAT function" ], "previous_source": "", "target": [ "" ], "id_hash": 8796333322820937330, "content_hash": 8796333322820937330, "location": "func_concat.xhp", "context": "func_concat.xhp\ntit\nhelp.text", "note": "cfeEJ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6492, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99299566/?format=api", "priority": 100, "id": 99526916, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=fa12da8d58ac6672", "url": "https://translations.documentfoundation.org/api/units/99526916/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:27.915235Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<bookmark_value>CONCAT function</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": 7991029942349640886, "content_hash": 7991029942349640886, "location": "func_concat.xhp", "context": "func_concat.xhp\nbm_id741556228031712\nhelp.text", "note": "WEfAD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6493, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/99299592/?format=api", "priority": 100, "id": 99526921, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=eee5d764ef42b4b6", "url": "https://translations.documentfoundation.org/api/units/99526921/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:27.917536Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<variable id=\"concatfunct\"><link href=\"text/scalc/01/func_concat.xhp\">CONCAT</link></variable>" ], "previous_source": "", "target": [ "" ], "id_hash": -696084096813186126, "content_hash": -696084096813186126, "location": "func_concat.xhp", "context": "func_concat.xhp\nhd_id471556226436779\nhelp.text", "note": "DXcLh", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6494, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/99299615/?format=api", "priority": 100, "id": 99526926, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=76570333b3a6c3b2", "url": "https://translations.documentfoundation.org/api/units/99526926/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:27.921412Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<variable id=\"concatfunction\"><ahelp hid=\".\">Concatenates one or more strings</ahelp></variable>" ], "previous_source": "", "target": [ "" ], "id_hash": -5610100621238531896, "content_hash": -5610100621238531896, "location": "func_concat.xhp", "context": "func_concat.xhp\npar_id891556226436781\nhelp.text", "note": "jUBjE", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6495, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/99299636/?format=api", "priority": 100, "id": 99526934, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=3224eb3564e108c8", "url": "https://translations.documentfoundation.org/api/units/99526934/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:27.925624Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "CONCAT is an enhancement of CONCATENATE, as CONCAT also accepts ranges as arguments, like B2:E5, K:K or K:M." ], "previous_source": "", "target": [ "" ], "id_hash": -7887419252229086841, "content_hash": -7887419252229086841, "location": "func_concat.xhp", "context": "func_concat.xhp\npar_id701556226865876\nhelp.text", "note": "JPUiF", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6496, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/99299649/?format=api", "priority": 100, "id": 99526941, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=128a41fabc4ee187", "url": "https://translations.documentfoundation.org/api/units/99526941/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:27.929585Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "When ranges are used, the cells are traversed row by row (from top to bottom) to concatenate." ], "previous_source": "", "target": [ "" ], "id_hash": -2290829766087122999, "content_hash": -2290829766087122999, "location": "func_concat.xhp", "context": "func_concat.xhp\npar_id461556226873963\nhelp.text", "note": "Gjz3x", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6497, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 17, "source_unit": "https://translations.documentfoundation.org/api/units/99299677/?format=api", "priority": 100, "id": 99526948, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=603556770f7c5fc9", "url": "https://translations.documentfoundation.org/api/units/99526948/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:27.932252Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "CONCAT( <embedvar href=\"text/scalc/01/ful_func.xhp#string255_1\" markup=\"keep\"/> )" ], "previous_source": "", "target": [ "" ], "id_hash": 1054130123521912835, "content_hash": 1054130123521912835, "location": "func_concat.xhp", "context": "func_concat.xhp\npar_id911556226813412\nhelp.text", "note": "fJEF4", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6498, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/99299709/?format=api", "priority": 100, "id": 99526958, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=8ea105c3278ff003", "url": "https://translations.documentfoundation.org/api/units/99526958/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:27.936312Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/ast/?format=api", "source": [ "<input>=CONCAT(\"Hello \", A1:C3)</input> concatenates the string \"Hello\" with all strings in range <literal>A1:C3</literal>." ], "previous_source": "", "target": [ "" ], "id_hash": -5928279230692924343, "content_hash": -5928279230692924343, "location": "func_concat.xhp", "context": "func_concat.xhp\npar_id531556227248228\nhelp.text", "note": "aTwgH", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6499, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/99299744/?format=api", "priority": 100, "id": 99526964, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=2dba8572f538e449", "url": "https://translations.documentfoundation.org/api/units/99526964/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:27.938556Z" }, { "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/CONCAT\">CONCAT wiki page</link>." ], "previous_source": "", "target": [ "" ], "id_hash": -7393600785675908953, "content_hash": -7393600785675908953, "location": "func_concat.xhp", "context": "func_concat.xhp\npar_id701677016751508\nhelp.text", "note": "EKvvy", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6500, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/99299780/?format=api", "priority": 100, "id": 99526972, "web_url": "https://translations.documentfoundation.org/translate/libo_help-7-6/textscalc01/ast/?checksum=1964a74226bd08a7", "url": "https://translations.documentfoundation.org/api/units/99526972/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2023-09-11T22:57:27.940930Z" } ] }