Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-master/textscalc01/et/units/?format=api&page=170
https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/units/?format=api&page=171", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/units/?format=api&page=169", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "<emph>Search criterion</emph>: (optional) The value of any type to search for in <emph>Array</emph>. If omitted, XLOOKUP returns blank cells it finds in <emph>Search Array</emph>." ], "previous_source": "", "target": [ "" ], "id_hash": -1897689249125164822, "content_hash": -1897689249125164822, "location": "func_xlookup.xhp", "context": "func_xlookup.xhp\npar_id861708281340704\nhelp.text", "note": "5W9TT", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7945, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://translations.documentfoundation.org/api/units/113275443/?format=api", "priority": 100, "id": 113275885, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=65aa0daeabd118ea", "url": "https://translations.documentfoundation.org/api/units/113275885/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-07-15T13:35:37.119533Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "<emph>Search Array</emph>: is the reference of the array to search. Array must be a 1-dimensional array and must be contained in one sheet only." ], "previous_source": "", "target": [ "" ], "id_hash": -7121952915009077232, "content_hash": -7121952915009077232, "location": "func_xlookup.xhp", "context": "func_xlookup.xhp\npar_id831708281625340\nhelp.text", "note": "JexuJ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7946, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://translations.documentfoundation.org/api/units/113275444/?format=api", "priority": 100, "id": 113275886, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=1d29bd8eb9d38010", "url": "https://translations.documentfoundation.org/api/units/113275886/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-07-15T13:35:37.121166Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "<emph>Result Array</emph>: is the reference of the array or range to return." ], "previous_source": "", "target": [ "" ], "id_hash": -1558806138801003954, "content_hash": -1558806138801003954, "location": "func_xlookup.xhp", "context": "func_xlookup.xhp\npar_id241708281629922\nhelp.text", "note": "EGAYg", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7947, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/113275445/?format=api", "priority": 100, "id": 113275887, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=6a5e02135f11624e", "url": "https://translations.documentfoundation.org/api/units/113275887/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-07-15T13:35:37.122681Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "If <emph>Result Array</emph> is a range of cells, the XLOOKUP function must be entered as an <link href=\"text/scalc/01/04060107.xhp#creating_array_formulas\">array formula</link>." ], "previous_source": "", "target": [ "" ], "id_hash": 7861924745544673485, "content_hash": 7861924745544673485, "location": "func_xlookup.xhp", "context": "func_xlookup.xhp\npar_id821708357634624\nhelp.text", "note": "WKPAt", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7948, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/113275446/?format=api", "priority": 100, "id": 113275888, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=ed1b2ae6dd0b28cd", "url": "https://translations.documentfoundation.org/api/units/113275888/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-07-15T13:35:37.124033Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "<emph>Result if not found</emph>: a text or cell content to return if the <emph>Lookup</emph> value is not found. If a valid match is not found and <emph>Result if not found</emph> is omitted, the function returns the #N/A error." ], "previous_source": "", "target": [ "" ], "id_hash": -2830971634602983981, "content_hash": -2830971634602983981, "location": "func_xlookup.xhp", "context": "func_xlookup.xhp\npar_id271708281637035\nhelp.text", "note": "sdzRc", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7949, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 38, "source_unit": "https://translations.documentfoundation.org/api/units/113275447/?format=api", "priority": 100, "id": 113275889, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=58b65e4c26483dd3", "url": "https://translations.documentfoundation.org/api/units/113275889/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-07-15T13:35:37.125381Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "<emph>Match Mode</emph>: (optional) specifies the match type. Values can be:" ], "previous_source": "", "target": [ "" ], "id_hash": 2091739301709513151, "content_hash": 2091739301709513151, "location": "func_xlookup.xhp", "context": "func_xlookup.xhp\npar_id121708281643207\nhelp.text", "note": "64MsW", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7950, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/113275448/?format=api", "priority": 100, "id": 113275890, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=9d0759cff91e81bf", "url": "https://translations.documentfoundation.org/api/units/113275890/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-07-15T13:35:37.126741Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "<emph>0</emph>: exact match (default). If <emph>Search criterion</emph> value is not found and <emph>Result if not found</emph> text is omitted, then return the #N/A error." ], "previous_source": "", "target": [ "" ], "id_hash": -8024898178927127015, "content_hash": -8024898178927127015, "location": "func_xlookup.xhp", "context": "func_xlookup.xhp\npar_id111708281542144\nhelp.text", "note": "VWPhz", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7951, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://translations.documentfoundation.org/api/units/113275449/?format=api", "priority": 100, "id": 113275891, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=10a1d59fbe5e9619", "url": "https://translations.documentfoundation.org/api/units/113275891/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-07-15T13:35:37.128020Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "<emph>-1</emph>: attempt exact match. If <emph>Search criterion</emph> value is not found, then return the next smaller item." ], "previous_source": "", "target": [ "" ], "id_hash": -4816704919441998921, "content_hash": -4816704919441998921, "location": "func_xlookup.xhp", "context": "func_xlookup.xhp\npar_id851708281548335\nhelp.text", "note": "PzWxb", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7952, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 17, "source_unit": "https://translations.documentfoundation.org/api/units/113275450/?format=api", "priority": 100, "id": 113275892, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=3d27a06550c87bb7", "url": "https://translations.documentfoundation.org/api/units/113275892/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-07-15T13:35:37.129536Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "<emph>1</emph>: attempt exact match. If <emph>Search criterion</emph> value is not found, then return the next larger item." ], "previous_source": "", "target": [ "" ], "id_hash": -6924671660189487139, "content_hash": -6924671660189487139, "location": "func_xlookup.xhp", "context": "func_xlookup.xhp\npar_id801708281553430\nhelp.text", "note": "N3DdJ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7953, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 17, "source_unit": "https://translations.documentfoundation.org/api/units/113275451/?format=api", "priority": 100, "id": 113275893, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=1fe69fd04430efdd", "url": "https://translations.documentfoundation.org/api/units/113275893/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-07-15T13:35:37.130710Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "<emph>2</emph>: a <link href=\"text/scalc/guide/wildcards.xhp\">wildcard</link> match where characters * (multiple characters), ? (single character), and ~ have special meanings." ], "previous_source": "", "target": [ "" ], "id_hash": -2831480215934364141, "content_hash": -2831480215934364141, "location": "func_xlookup.xhp", "context": "func_xlookup.xhp\npar_id881708281558005\nhelp.text", "note": "vhHmc", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7954, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/113275452/?format=api", "priority": 100, "id": 113275894, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=58b48fbed4af9613", "url": "https://translations.documentfoundation.org/api/units/113275894/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-07-15T13:35:37.131671Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "<emph>Search Mode</emph>: (optional) specifies the search mode to use." ], "previous_source": "", "target": [ "" ], "id_hash": -1808765608420832622, "content_hash": -1808765608420832622, "location": "func_xlookup.xhp", "context": "func_xlookup.xhp\npar_id871708281607313\nhelp.text", "note": "CFgfx", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7956, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/113275453/?format=api", "priority": 100, "id": 113275895, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=66e5f9432c220a92", "url": "https://translations.documentfoundation.org/api/units/113275895/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-07-15T13:35:37.132751Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "<emph>1</emph>: returns the first occurrence starting from the first item of <emph>Search Array</emph> (default)." ], "previous_source": "", "target": [ "" ], "id_hash": -2303885618320012245, "content_hash": -2303885618320012245, "location": "func_xlookup.xhp", "context": "func_xlookup.xhp\npar_id281708281579757\nhelp.text", "note": "PrCaa", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7957, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/113275454/?format=api", "priority": 100, "id": 113275896, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=6006f43c94e78c2b", "url": "https://translations.documentfoundation.org/api/units/113275896/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-07-15T13:35:37.134231Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "<emph>-1</emph>: reverse search. Returns the first occurrence starting from the last item of <emph>Search Array</emph>." ], "previous_source": "", "target": [ "" ], "id_hash": 3669136229142143800, "content_hash": 3669136229142143800, "location": "func_xlookup.xhp", "context": "func_xlookup.xhp\npar_id251708281584285\nhelp.text", "note": "oiSgS", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7958, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/113275455/?format=api", "priority": 100, "id": 113275897, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=b2eb63f5e288a338", "url": "https://translations.documentfoundation.org/api/units/113275897/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-07-15T13:35:37.135247Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "<emph>2</emph>: binary search that relies on <emph>Search Array</emph> being sorted in ascending order. If not sorted, invalid results will be returned." ], "previous_source": "", "target": [ "" ], "id_hash": -7871226587447461815, "content_hash": -7871226587447461815, "location": "func_xlookup.xhp", "context": "func_xlookup.xhp\npar_id191708281589997\nhelp.text", "note": "aGQoN", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7959, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://translations.documentfoundation.org/api/units/113275456/?format=api", "priority": 100, "id": 113275898, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=12c3c91f4c957849", "url": "https://translations.documentfoundation.org/api/units/113275898/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-07-15T13:35:37.136260Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "<emph>-2</emph>: binary search that relies on <emph>Search Array</emph> being sorted in descending order. If not sorted, invalid results will be returned." ], "previous_source": "", "target": [ "" ], "id_hash": -7274026395075109223, "content_hash": -7274026395075109223, "location": "func_xlookup.xhp", "context": "func_xlookup.xhp\npar_id561708281595885\nhelp.text", "note": "M54Co", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7960, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://translations.documentfoundation.org/api/units/113275457/?format=api", "priority": 100, "id": 113275899, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=1b0d77887abb9e99", "url": "https://translations.documentfoundation.org/api/units/113275899/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-07-15T13:35:37.137715Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "<emph>Match Mode</emph> values 2 and 3 cannot be combined with binary search (<emph>Search Mode</emph> value <emph>2</emph> or <emph>-2</emph>)." ], "previous_source": "", "target": [ "" ], "id_hash": 1453317143387645129, "content_hash": 1453317143387645129, "location": "func_xlookup.xhp", "context": "func_xlookup.xhp\npar_id551718627629229\nhelp.text", "note": "hMFJt", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7961, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/113275458/?format=api", "priority": 100, "id": 113275900, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=942b383ded9b24c9", "url": "https://translations.documentfoundation.org/api/units/113275900/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-07-15T13:35:37.138964Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "<variable id=\"column_hd\">Column</variable>" ], "previous_source": "", "target": [ "" ], "id_hash": 4946186710314341807, "content_hash": 4946186710314341807, "location": "02110000.xhp", "context": "02110000.xhp\nhd_id3159155\nhelp.text", "note": "JtjTn", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 5, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/124878933/?format=api", "priority": 100, "id": 124886269, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=c4a4629b650b55af", "url": "https://translations.documentfoundation.org/api/units/124886269/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-09-16T18:45:47.055169Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "<variable id=\"row_hd\">Row</variable>" ], "previous_source": "", "target": [ "" ], "id_hash": -6792824974699735433, "content_hash": -6792824974699735433, "location": "02110000.xhp", "context": "02110000.xhp\nhd_id3147126\nhelp.text", "note": "hdREG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/124878934/?format=api", "priority": 100, "id": 124886270, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=21bb09ace99ed677", "url": "https://translations.documentfoundation.org/api/units/124886270/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-09-16T18:45:47.057092Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "<variable id=\"data_range_hd\">Data Range</variable>" ], "previous_source": "", "target": [ "" ], "id_hash": 5174317681401762960, "content_hash": 5174317681401762960, "location": "02110000.xhp", "context": "02110000.xhp\nhd_id3150717\nhelp.text", "note": "BkTUe", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 9, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/124878935/?format=api", "priority": 100, "id": 124886271, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=c7cede843af99490", "url": "https://translations.documentfoundation.org/api/units/124886271/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-09-16T18:45:47.058830Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "<variable id=\"start_hd\">Start</variable>" ], "previous_source": "", "target": [ "" ], "id_hash": 4643827062406440261, "content_hash": 4643827062406440261, "location": "02110000.xhp", "context": "02110000.xhp\nhd_id3148488\nhelp.text", "note": "XZkJY", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 13, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/124878936/?format=api", "priority": 100, "id": 124886272, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=c072301bf514e545", "url": "https://translations.documentfoundation.org/api/units/124886272/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-09-16T18:45:47.061678Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "<variable id=\"end_hd\">End</variable>" ], "previous_source": "", "target": [ "" ], "id_hash": -4284206576507265151, "content_hash": -4284206576507265151, "location": "02110000.xhp", "context": "02110000.xhp\nhd_id3146982\nhelp.text", "note": "hhYAG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 17, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/124878937/?format=api", "priority": 100, "id": 124886273, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=448b70d13ee45f81", "url": "https://translations.documentfoundation.org/api/units/124886273/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-09-16T18:45:47.064286Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "<variable id=\"toggle_hd\">Toggle</variable>" ], "previous_source": "", "target": [ "" ], "id_hash": 4735181453572481765, "content_hash": 4735181453572481765, "location": "02110000.xhp", "context": "02110000.xhp\nhd_id3150107\nhelp.text", "note": "dstnG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 21, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/124878938/?format=api", "priority": 100, "id": 124886274, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=c1b6be71a734a2e5", "url": "https://translations.documentfoundation.org/api/units/124886274/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-09-16T18:45:47.067001Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "Scenarios<variable id=\"scenarios_hd\">Scenarios</variable>" ], "previous_source": "", "target": [ "" ], "id_hash": 5555039534307184698, "content_hash": 5555039534307184698, "location": "02110000.xhp", "context": "02110000.xhp\nhd_id3147244\nhelp.text", "note": "GhYaT", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 25, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/124878939/?format=api", "priority": 100, "id": 124886275, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=cd1777064ba1903a", "url": "https://translations.documentfoundation.org/api/units/124886275/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-09-16T18:45:47.069838Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "<variable id=\"delete_hd\">Delete</variable>" ], "previous_source": "", "target": [ "" ], "id_hash": 6385243296522056801, "content_hash": 6385243296522056801, "location": "02110000.xhp", "context": "02110000.xhp\npar_idN10A77\nhelp.text", "note": "YKm5B", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 30, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/124878940/?format=api", "priority": 100, "id": 124886276, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=d89cf0f29da43461", "url": "https://translations.documentfoundation.org/api/units/124886276/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-09-16T18:45:47.073361Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "<variable id=\"properties_hd\">Properties</variable>" ], "previous_source": "", "target": [ "" ], "id_hash": 2005456684740225602, "content_hash": 2005456684740225602, "location": "02110000.xhp", "context": "02110000.xhp\npar_idN10A92\nhelp.text", "note": "ZQ4mB", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 32, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/124878943/?format=api", "priority": 100, "id": 124886277, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=9bd4d03aba5faa42", "url": "https://translations.documentfoundation.org/api/units/124886277/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-09-16T18:45:47.075149Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "<variable id=\"logicaltext\">This category contains the <emph>Logical</emph> functions. </variable>" ], "previous_source": "", "target": [ "" ], "id_hash": 6809299429133210869, "content_hash": 6809299429133210869, "location": "04060105.xhp", "context": "04060105.xhp\npar_id3149312\nhelp.text", "note": "xK9mn", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1144, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/124879022/?format=api", "priority": 100, "id": 124886315, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=de7f7dc0eac154f5", "url": "https://translations.documentfoundation.org/api/units/124886315/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-09-16T18:45:48.104585Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "The <link href=\"text/scalc/01/04060107.xhp\">array formula</link> {=AND(B1:B10;C1:C10)} yields a one-dimensional value of TRUE when all components of B1:B10 and C1:C10 are TRUE. The array expression above does not produce the logical AND per element, and thus does not produce an array of logical values. To compute a logical AND of arrays per element use the * operator in array context. In the example, enter {=B1:B10*C1:C10}." ], "previous_source": "", "target": [ "" ], "id_hash": 3248048738594932980, "content_hash": 3248048738594932980, "location": "04060105.xhp", "context": "04060105.xhp\npar_id441723304789320\nhelp.text", "note": "XUnCE", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1159, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 63, "source_unit": "https://translations.documentfoundation.org/api/units/124879027/?format=api", "priority": 100, "id": 124886316, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=ad13631e6d1b48f4", "url": "https://translations.documentfoundation.org/api/units/124886316/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-09-16T18:45:48.130462Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "The <link href=\"text/scalc/01/04060107.xhp\">array formula</link> {=OR(B1:B10;C1:C10)} yields a one-dimensional value of FALSE when all components of B1:B10 and C1:C10 are FALSE. The array expression above does not produce the logical OR per element, and thus does not produce an array of logical values. To compute a logical OR of arrays per element use the + operator in array context. In the example, enter {=B1:B10+C1:C10}." ], "previous_source": "", "target": [ "" ], "id_hash": -468173296503401625, "content_hash": -468173296503401625, "location": "04060105.xhp", "context": "04060105.xhp\npar_id751723304896532\nhelp.text", "note": "CQGT5", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1190, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 63, "source_unit": "https://translations.documentfoundation.org/api/units/124879028/?format=api", "priority": 100, "id": 124886317, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=7980b6de08975367", "url": "https://translations.documentfoundation.org/api/units/124886317/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-09-16T18:45:48.164164Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_FAKULTAET\">Returns the factorial of a non-negative integer.</ahelp>" ], "previous_source": "", "target": [ "" ], "id_hash": 492368656294695003, "content_hash": 492368656294695003, "location": "04060106.xhp", "context": "04060106.xhp\npar_id3151109\nhelp.text", "note": "7G64n", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1354, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 8, "source_unit": "https://translations.documentfoundation.org/api/units/124879030/?format=api", "priority": 100, "id": 124886328, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=86d53eaf28fb505b", "url": "https://translations.documentfoundation.org/api/units/124886328/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-09-16T18:45:48.359326Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "FACT(Integer)" ], "previous_source": "", "target": [ "" ], "id_hash": 7572556689712385034, "content_hash": 7572556689712385034, "location": "04060106.xhp", "context": "04060106.xhp\npar_id3154661\nhelp.text", "note": "jsdcC", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1355, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/124879031/?format=api", "priority": 100, "id": 124886329, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=e91720302bd08c0a", "url": "https://translations.documentfoundation.org/api/units/124886329/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-09-16T18:45:48.360875Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "Returns Integer!, the factorial of <emph>Integer</emph>, calculated as 1*2*3*4* ... * Integer." ], "previous_source": "", "target": [ "" ], "id_hash": -6712193502588593813, "content_hash": -6712193502588593813, "location": "04060106.xhp", "context": "04060106.xhp\npar_id3152952\nhelp.text", "note": "F9Ftw", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1356, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/124879032/?format=api", "priority": 100, "id": 124886330, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=22d97f927685996b", "url": "https://translations.documentfoundation.org/api/units/124886330/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-09-16T18:45:48.362400Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "Returns the \"invalid argument\" error if the argument is negative integer." ], "previous_source": "", "target": [ "" ], "id_hash": -4466041190355639311, "content_hash": -4466041190355639311, "location": "04060106.xhp", "context": "04060106.xhp\npar_id8429517\nhelp.text", "note": "Ev6bc", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1357, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/124879033/?format=api", "priority": 100, "id": 124886331, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=42056f331096e3f1", "url": "https://translations.documentfoundation.org/api/units/124886331/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-09-16T18:45:48.364020Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "Returns the #VALUE! error if the argument is greater than 170, cause too large integer (approximately 7E+306." ], "previous_source": "", "target": [ "" ], "id_hash": -4413348154377430879, "content_hash": -4413348154377430879, "location": "04060106.xhp", "context": "04060106.xhp\npar_id3834651\nhelp.text", "note": "y9Q7S", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1358, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 17, "source_unit": "https://translations.documentfoundation.org/api/units/124879034/?format=api", "priority": 100, "id": 124886332, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=42c0a33c8c3518a1", "url": "https://translations.documentfoundation.org/api/units/124886332/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-09-16T18:45:48.365607Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "<item type=\"input\">=FACT(0)</item> returns 1 by definition." ], "previous_source": "", "target": [ "" ], "id_hash": -2834519398990304736, "content_hash": -2834519398990304736, "location": "04060106.xhp", "context": "04060106.xhp\npar_id3834650\nhelp.text", "note": "V9FQf", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1359, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/124879035/?format=api", "priority": 100, "id": 124886333, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=58a9c39fe23aaa20", "url": "https://translations.documentfoundation.org/api/units/124886333/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-09-16T18:45:48.367088Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "If the argument is a non-integer number, it is converted to its floor integer value." ], "previous_source": "", "target": [ "" ], "id_hash": -8401444740090379494, "content_hash": -8401444740090379494, "location": "04060106.xhp", "context": "04060106.xhp\npar_id8429555\nhelp.text", "note": "AcCKF", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1360, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/124879036/?format=api", "priority": 100, "id": 124886334, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=0b6812858ad6c31a", "url": "https://translations.documentfoundation.org/api/units/124886334/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-09-16T18:45:48.368642Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "<item type=\"input\">=FACT(3.8)</item> returns 6." ], "previous_source": "", "target": [ "" ], "id_hash": -2602504430009190716, "content_hash": -2602504430009190716, "location": "04060106.xhp", "context": "04060106.xhp\npar_id3154477\nhelp.text", "note": "uxtDN", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1362, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/124879037/?format=api", "priority": 100, "id": 124886335, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=5be20c0272ebf6c4", "url": "https://translations.documentfoundation.org/api/units/124886335/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-09-16T18:45:48.370952Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "The same result may be achieved by using the exponentiation operator ^: <literal>Base^Exponent</literal>" ], "previous_source": "", "target": [ "" ], "id_hash": -2291886815654791905, "content_hash": -2291886815654791905, "location": "04060106.xhp", "context": "04060106.xhp\npar_id5081637\nhelp.text", "note": "P9dEi", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1458, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/124879057/?format=api", "priority": 100, "id": 124886336, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=60319515877eb51f", "url": "https://translations.documentfoundation.org/api/units/124886336/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-09-16T18:45:48.450617Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "<literal>=POWER(0,0)</literal> returns 1; <literal>=POWER(0,X)</literal> reports the #NUM! error when exponent X is negative." ], "previous_source": "", "target": [ "" ], "id_hash": -6915809677603994074, "content_hash": -6915809677603994074, "location": "04060106.xhp", "context": "04060106.xhp\npar_id241599040594931\nhelp.text", "note": "Pej3x", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1459, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/124879058/?format=api", "priority": 100, "id": 124886337, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=20061bbd60348626", "url": "https://translations.documentfoundation.org/api/units/124886337/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-09-16T18:45:48.452333Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "<literal>=POWER(B,X)</literal> may or may not report a #NUM! error when B is negative and X is not an integer." ], "previous_source": "", "target": [ "" ], "id_hash": 242169001668311867, "content_hash": 242169001668311867, "location": "04060106.xhp", "context": "04060106.xhp\npar_id241599040594900\nhelp.text", "note": "ShFKC", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1460, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 19, "source_unit": "https://translations.documentfoundation.org/api/units/124879059/?format=api", "priority": 100, "id": 124886338, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=835c5b6c880cfb3b", "url": "https://translations.documentfoundation.org/api/units/124886338/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-09-16T18:45:48.453989Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "<input>=POWER(4;3)</input> returns 64, which is 4 to the power of 3." ], "previous_source": "", "target": [ "" ], "id_hash": -329375470936853857, "content_hash": -329375470936853857, "location": "04060106.xhp", "context": "04060106.xhp\npar_id3159594\nhelp.text", "note": "YCb9B", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1461, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/124879060/?format=api", "priority": 100, "id": 124886339, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=7b6dd2c11914f29f", "url": "https://translations.documentfoundation.org/api/units/124886339/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-09-16T18:45:48.455655Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "<input>=4^3</input> also returns 4 to the power of 3." ], "previous_source": "", "target": [ "" ], "id_hash": 6551999968096415596, "content_hash": 6551999968096415596, "location": "04060106.xhp", "context": "04060106.xhp\npar_id1614429\nhelp.text", "note": "zMvPJ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1462, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/124879061/?format=api", "priority": 100, "id": 124886340, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=daed6141cac1ef6c", "url": "https://translations.documentfoundation.org/api/units/124886340/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-09-16T18:45:48.457304Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "<input>=POWER(2;-3)</input> returns 0.125." ], "previous_source": "", "target": [ "" ], "id_hash": 3093496274099278646, "content_hash": 3093496274099278646, "location": "04060106.xhp", "context": "04060106.xhp\npar_id1614444\nhelp.text", "note": "psBP2", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1463, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/124879062/?format=api", "priority": 100, "id": 124886341, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=aaee4e78a3ae9336", "url": "https://translations.documentfoundation.org/api/units/124886341/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-09-16T18:45:48.458951Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "<input>=POWER(-2;1/3)</input> returns -1.25992104989487." ], "previous_source": "", "target": [ "" ], "id_hash": 352864083911359513, "content_hash": 352864083911359513, "location": "04060106.xhp", "context": "04060106.xhp\npar_id1614455\nhelp.text", "note": "CbgU3", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1464, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/124879063/?format=api", "priority": 100, "id": 124886342, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=84e5a003c787bc19", "url": "https://translations.documentfoundation.org/api/units/124886342/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-09-16T18:45:48.460573Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "<input>=POWER(-2;2/3)</input> returns the #NUM! error." ], "previous_source": "", "target": [ "" ], "id_hash": 8227152230378715762, "content_hash": 8227152230378715762, "location": "04060106.xhp", "context": "04060106.xhp\npar_id1614466\nhelp.text", "note": "yaGk5", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1465, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/124879064/?format=api", "priority": 100, "id": 124886343, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=f22cb75d3cc93a72", "url": "https://translations.documentfoundation.org/api/units/124886343/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-09-16T18:45:48.462181Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "You have a table in the cell range A1:B6 containing a bill of material for 10 students." ], "previous_source": "", "target": [ "" ], "id_hash": 6232912735556077752, "content_hash": 6232912735556077752, "location": "04060106.xhp", "context": "04060106.xhp\npar_id3143638\nhelp.text", "note": "AfeKK", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1596, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 17, "source_unit": "https://translations.documentfoundation.org/api/units/124879066/?format=api", "priority": 100, "id": 124886344, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=d67fc11c0ed408b8", "url": "https://translations.documentfoundation.org/api/units/124886344/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-09-16T18:45:48.559356Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "Let's say one row is manually hidden, then the first formula shows the sum of the 5 figures filtered; the second, only the sum of the 4 figures displayed." ], "previous_source": "", "target": [ "" ], "id_hash": 2216746477846276630, "content_hash": 2216746477846276630, "location": "04060106.xhp", "context": "04060106.xhp\npar_id3140008\nhelp.text", "note": "Vqy4i", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1604, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/124879067/?format=api", "priority": 100, "id": 124886345, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=9ec3772d41202a16", "url": "https://translations.documentfoundation.org/api/units/124886345/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-09-16T18:45:48.564126Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_EUROCONVERT\">Converts between old European national currency and to and from Euros.</ahelp>" ], "previous_source": "", "target": [ "" ], "id_hash": -5692117712701086105, "content_hash": -5692117712701086105, "location": "04060106.xhp", "context": "04060106.xhp\npar_id3143708\nhelp.text", "note": "DKvpT", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 1609, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/124879076/?format=api", "priority": 100, "id": 124886346, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=3101891932be2667", "url": "https://translations.documentfoundation.org/api/units/124886346/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-09-16T18:45:48.565631Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "The function tries to bridge with system specificities. For example, \"c:\\path to\\file.ext\" will be properly interpreted as \"file:///c:/path%20to/file.ext\" on Windows, or \"..\" will lead to the parent directory of the document." ], "previous_source": "", "target": [ "" ], "id_hash": -7609561218023647183, "content_hash": -7609561218023647183, "location": "04060109.xhp", "context": "04060109.xhp\npar_idN11999\nhelp.text", "note": "dR6DM", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2181, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 31, "source_unit": "https://translations.documentfoundation.org/api/units/124879084/?format=api", "priority": 100, "id": 124886347, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=16656863af1c9831", "url": "https://translations.documentfoundation.org/api/units/124886347/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-09-16T18:45:48.628733Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "Empty string and blank cells" ], "previous_source": "", "target": [ "" ], "id_hash": 6904207093685543298, "content_hash": 6904207093685543298, "location": "04060110.xhp", "context": "04060110.xhp\nhd_id451721571883016\nhelp.text", "note": "mtsYd", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2216, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/124879085/?format=api", "priority": 100, "id": 124886348, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=dfd0abc58adbe182", "url": "https://translations.documentfoundation.org/api/units/124886348/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-09-16T18:45:48.726634Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/et/?format=api", "source": [ "<variable id=\"stringblank\">Cells with the empty string (\"\") are not equivalent to blank cells. When searching or calculating with text, the empty string \"\" is the text with length zero.</variable>" ], "previous_source": "", "target": [ "" ], "id_hash": -6515177665361388487, "content_hash": -6515177665361388487, "location": "04060110.xhp", "context": "04060110.xhp\npar_id241721571890240\nhelp.text", "note": "J56DC", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2217, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/124879086/?format=api", "priority": 100, "id": 124886349, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/et/?checksum=2595706ea7935c39", "url": "https://translations.documentfoundation.org/api/units/124886349/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-09-16T18:45:48.727682Z" } ] }{ "count": 8573, "next": "