Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-master/textscalc01/ka/units/?format=api&page=169
https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/units/?format=api&page=170", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/units/?format=api&page=168", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?format=api", "source": [ "<emph>Age</emph>" ], "previous_source": "", "target": [ "" ], "id_hash": -9193006166818129083, "content_hash": -9193006166818129083, "location": "func_unique.xhp", "context": "func_unique.xhp\npar_id511715983350731\nhelp.text", "note": "LFWFS", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7771, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/113218011/?format=api", "priority": 100, "id": 113219643, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=006be19910d47b45", "url": "https://translations.documentfoundation.org/api/units/113219643/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-05-24T01:59:37.119400Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?format=api", "source": [ "Example 2" ], "previous_source": "", "target": [ "" ], "id_hash": -4892593401872488629, "content_hash": -4892593401872488629, "location": "func_unique.xhp", "context": "func_unique.xhp\nhd_id981715984567844\nhelp.text", "note": "i74Ub", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7772, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/113218012/?format=api", "priority": 100, "id": 113219644, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=3c1a04391af8674b", "url": "https://translations.documentfoundation.org/api/units/113219644/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-05-24T01:59:37.120304Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?format=api", "source": [ "<emph>Grade</emph>" ], "previous_source": "", "target": [ "" ], "id_hash": -3430104060944075568, "content_hash": -3430104060944075568, "location": "func_unique.xhp", "context": "func_unique.xhp\npar_id501715983764524\nhelp.text", "note": "dScyG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7774, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/113218014/?format=api", "priority": 100, "id": 113219646, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=5065d287b0cdb4d0", "url": "https://translations.documentfoundation.org/api/units/113219646/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-05-24T01:59:37.122142Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?format=api", "source": [ "<emph>Age</emph>" ], "previous_source": "", "target": [ "" ], "id_hash": -4339115958050337712, "content_hash": -4339115958050337712, "location": "func_unique.xhp", "context": "func_unique.xhp\npar_id31715983773608\nhelp.text", "note": "GAopa", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7775, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/113218015/?format=api", "priority": 100, "id": 113219647, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=43c85d06992e4c50", "url": "https://translations.documentfoundation.org/api/units/113219647/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-05-24T01:59:37.123066Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?format=api", "source": [ "<variable id=\"movecopy_sheet\"><link href=\"text/scalc/01/02180000.xhp\">Move or Copy a Sheet</link></variable>" ], "previous_source": "", "target": [ "" ], "id_hash": 1994254624815367610, "content_hash": 1994254624815367610, "location": "02180000.xhp", "context": "02180000.xhp\nhd_id3153360\nhelp.text", "note": "ytArs", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 273, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/113233833/?format=api", "priority": 100, "id": 113234038, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=9bad0403e7ccc5ba", "url": "https://translations.documentfoundation.org/api/units/113234038/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-05-27T11:36:43.740524Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?format=api", "source": [ "When the <link href=\"text/shared/01/02230100.xhp\"><menuitem>Record Changes</menuitem></link> command is active, you cannot delete or move sheets." ], "previous_source": "", "target": [ "" ], "id_hash": -3417779666752492251, "content_hash": -3417779666752492251, "location": "02180000.xhp", "context": "02180000.xhp\npar_id3720376688484858\nhelp.text", "note": "GHQ6R", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 276, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/113233834/?format=api", "priority": 100, "id": 113234039, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=50919b8052aa2d25", "url": "https://translations.documentfoundation.org/api/units/113234039/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-05-27T11:36:43.742849Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?format=api", "source": [ "<variable id=\"define_names_h1\"><link href=\"text/scalc/01/04070100.xhp\">Define Names</link></variable>" ], "previous_source": "", "target": [ "" ], "id_hash": 3534261034148231199, "content_hash": 3534261034148231199, "location": "04070100.xhp", "context": "04070100.xhp\nhd_id3156330\nhelp.text", "note": "fGnfi", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4671, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/113233835/?format=api", "priority": 100, "id": 113234040, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=b10c37af6be8f81f", "url": "https://translations.documentfoundation.org/api/units/113234040/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-05-27T11:36:45.895139Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?format=api", "source": [ "The <menuitem>Name Box</menuitem> on the Formula bar contains a list of defined names for the ranges or formula expressions and their scope between parenthesis. Click a name from this box to highlight the corresponding reference on the spreadsheet. Names given formulas or parts of a formula are not listed here." ], "previous_source": "", "target": [ "" ], "id_hash": -5019432053091108439, "content_hash": -5019432053091108439, "location": "04070100.xhp", "context": "04070100.xhp\npar_id3155131\nhelp.text", "note": "QVRkv", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 4674, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 50, "source_unit": "https://translations.documentfoundation.org/api/units/113233836/?format=api", "priority": 100, "id": 113234041, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=3a5765244d4b79a9", "url": "https://translations.documentfoundation.org/api/units/113234041/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-05-27T11:36:45.897231Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?format=api", "source": [ "Filters a data range or array based on specified conditions." ], "previous_source": "", "target": [ "" ], "id_hash": -9199004177996162485, "content_hash": -9199004177996162485, "location": "func_filter.xhp", "context": "func_filter.xhp\npar_id771708806478128\nhelp.text", "note": "dxbQ9", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6910, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/113242831/?format=api", "priority": 100, "id": 113245081, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=0056927043345a4b", "url": "https://translations.documentfoundation.org/api/units/113245081/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:38:19.823497Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?format=api", "source": [ "FILTER( Range; Criteria [; Return if empty])" ], "previous_source": "", "target": [ "" ], "id_hash": -8806318181578049432, "content_hash": -8806318181578049432, "location": "func_filter.xhp", "context": "func_filter.xhp\npar_id211708281649651\nhelp.text", "note": "tuppo", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6911, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/113242832/?format=api", "priority": 100, "id": 113245082, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=05c9ac458ff9f868", "url": "https://translations.documentfoundation.org/api/units/113245082/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:38:19.824647Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?format=api", "source": [ "<emph>Result if empty</emph>: (optional) the value to return if all values in the <emph>Criteria</emph> array are empty (filter return nothing)." ], "previous_source": "", "target": [ "" ], "id_hash": -3309613975401676562, "content_hash": -3309613975401676562, "location": "func_filter.xhp", "context": "func_filter.xhp\npar_id421709395146863\nhelp.text", "note": "ZcP2E", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6914, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/113242833/?format=api", "priority": 100, "id": 113245083, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=5211e39fdc83c0ee", "url": "https://translations.documentfoundation.org/api/units/113245083/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:38:19.826535Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?format=api", "source": [ "<input>{=FILTER(A2:C13;A2:A13>50)}</input> returns the array containing all grades with Maths grade above 50. Note that this is an <link href=\"text/scalc/01/04060107.xhp#creating_array_formulas\">array formula</link>." ], "previous_source": "", "target": [ "" ], "id_hash": 6775980567866616718, "content_hash": 6775980567866616718, "location": "func_filter.xhp", "context": "func_filter.xhp\npar_id21709506838932\nhelp.text", "note": "AFtpH", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6915, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/113242834/?format=api", "priority": 100, "id": 113245084, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=de091e6d00a3ab8e", "url": "https://translations.documentfoundation.org/api/units/113245084/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:38:19.827546Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?format=api", "source": [ "<input>{=FILTER(A2:C13;B2:B13>90;\"No results\")}</input> Returns the string \"No results\", since no grade on Physics is above 90." ], "previous_source": "", "target": [ "" ], "id_hash": -4714812717678269879, "content_hash": -4714812717678269879, "location": "func_filter.xhp", "context": "func_filter.xhp\npar_id561709507935610\nhelp.text", "note": "METQ9", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6916, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/113242835/?format=api", "priority": 100, "id": 113245085, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=3e919ed03c4aea49", "url": "https://translations.documentfoundation.org/api/units/113245085/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:38:19.828555Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?format=api", "source": [ "RANDARRAY([Rows [; Columns [; Min [; Max [; Integers] ] ] ])" ], "previous_source": "", "target": [ "" ], "id_hash": -3087541549094932463, "content_hash": -3087541549094932463, "location": "func_randarray.xhp", "context": "func_randarray.xhp\npar_id211708281649651\nhelp.text", "note": "ArGrF", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7427, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/113242836/?format=api", "priority": 100, "id": 113245086, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=5526d951d0eff011", "url": "https://translations.documentfoundation.org/api/units/113245086/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:38:20.279713Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?format=api", "source": [ "<input>{=RANDARRAY(10;4;10;50;1)}</input> returns an array of 10 rows, 4 columns with minimum value 10 and maximum value of 50 of whole numbers (integers)." ], "previous_source": "", "target": [ "" ], "id_hash": 5074773011725883336, "content_hash": 5074773011725883336, "location": "func_randarray.xhp", "context": "func_randarray.xhp\npar_id521715616457946\nhelp.text", "note": "mz6p3", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7435, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 22, "source_unit": "https://translations.documentfoundation.org/api/units/113242837/?format=api", "priority": 100, "id": 113245087, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=c66d372ab7a917c8", "url": "https://translations.documentfoundation.org/api/units/113245087/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:38:20.284118Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?format=api", "source": [ "SORT(Range [; SortIndex [; SortOrder [; ByCol] ] ])" ], "previous_source": "", "target": [ "" ], "id_hash": 6748395899807645412, "content_hash": 6748395899807645412, "location": "func_sort.xhp", "context": "func_sort.xhp\npar_id211708281649651\nhelp.text", "note": "DmRKh", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7571, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/113242839/?format=api", "priority": 100, "id": 113245089, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=dda71e50fbbcbee4", "url": "https://translations.documentfoundation.org/api/units/113245089/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:38:20.349419Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?format=api", "source": [ "<emph>Range:</emph> the range or array to sort." ], "previous_source": "", "target": [ "" ], "id_hash": 1645809688449997196, "content_hash": 1645809688449997196, "location": "func_sort.xhp", "context": "func_sort.xhp\npar_id551711457515235\nhelp.text", "note": "gmV6H", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7572, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/113242840/?format=api", "priority": 100, "id": 113245090, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=96d7173117f5598c", "url": "https://translations.documentfoundation.org/api/units/113245090/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:38:20.350401Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?format=api", "source": [ "<emph>SortIndex:</emph> (optional). The number indicating the row or column to sort by." ], "previous_source": "", "target": [ "" ], "id_hash": 3938506842601994020, "content_hash": 3938506842601994020, "location": "func_sort.xhp", "context": "func_sort.xhp\npar_id151711457520290\nhelp.text", "note": "WQaKY", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7573, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/113242841/?format=api", "priority": 100, "id": 113245091, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=b6a8631b32bcb724", "url": "https://translations.documentfoundation.org/api/units/113245091/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:38:20.351369Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?format=api", "source": [ "<emph>SortOrder:</emph> (optional). A number indicating the desired sort order; 1 for ascending order (default), -1 for descending order." ], "previous_source": "", "target": [ "" ], "id_hash": -3717172067221163892, "content_hash": -3717172067221163892, "location": "func_sort.xhp", "context": "func_sort.xhp\npar_id131711457525811\nhelp.text", "note": "P5DGG", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7574, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/113242842/?format=api", "priority": 100, "id": 113245092, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=4c69f3b30447308c", "url": "https://translations.documentfoundation.org/api/units/113245092/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:38:20.352346Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?format=api", "source": [ "<emph>ByCol:</emph> (optional). A logical value indicating the desired sort direction; <emph>FALSE</emph> to sort by row (default), <emph>TRUE</emph> to sort by column." ], "previous_source": "", "target": [ "" ], "id_hash": 6724344827435065277, "content_hash": 6724344827435065277, "location": "func_sort.xhp", "context": "func_sort.xhp\npar_id351711457531579\nhelp.text", "note": "5Vo8L", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7575, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 21, "source_unit": "https://translations.documentfoundation.org/api/units/113242843/?format=api", "priority": 100, "id": 113245093, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=dd51abfe52809fbd", "url": "https://translations.documentfoundation.org/api/units/113245093/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:38:20.353345Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?format=api", "source": [ "<input>{=SORTBY(A2:C7;A2:A7;1;C2:C7;-1)}</input>" ], "previous_source": "", "target": [ "" ], "id_hash": -9147617564775033183, "content_hash": -9147617564775033183, "location": "func_sortby.xhp", "context": "func_sortby.xhp\npar_id131711466000482\nhelp.text", "note": "jhZ65", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7601, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/113242847/?format=api", "priority": 100, "id": 113245097, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=010d224a7e75d6a1", "url": "https://translations.documentfoundation.org/api/units/113245097/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:38:20.367330Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?format=api", "source": [ "Description" ], "previous_source": "", "target": [ "" ], "id_hash": 5175227711762151243, "content_hash": 5175227711762151243, "location": "func_weeknum.xhp", "context": "func_weeknum.xhp\npar_id901535122363436\nhelp.text", "note": "cM6zS", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7853, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/113242848/?format=api", "priority": 100, "id": 113245098, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=c7d21a2f2f57374b", "url": "https://translations.documentfoundation.org/api/units/113245098/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:38:20.491468Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?format=api", "source": [ "<input>{=XLOOKUP(\"Atomic Number\";A2:A4;A2:DO4)}</input> returns the array" ], "previous_source": "", "target": [ "" ], "id_hash": -2496921173792390262, "content_hash": -2496921173792390262, "location": "func_xlookup.xhp", "context": "func_xlookup.xhp\npar_id141716739193733\nhelp.text", "note": "fHQrZ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7962, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/113242865/?format=api", "priority": 100, "id": 113245115, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=5d59276bf3f4038a", "url": "https://translations.documentfoundation.org/api/units/113245115/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:38:20.551242Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?format=api", "source": [ "<input>{=XLOOKUP(\"Helium\";B1:DO1;B1:DO4)}</input> returns the array" ], "previous_source": "", "target": [ "" ], "id_hash": 4446248683708869960, "content_hash": 4446248683708869960, "location": "func_xlookup.xhp", "context": "func_xlookup.xhp\npar_id231716739652495\nhelp.text", "note": "tkRq7", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7964, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/113242866/?format=api", "priority": 100, "id": 113245116, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=bdb43f9edf83ed48", "url": "https://translations.documentfoundation.org/api/units/113245116/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:38:20.552213Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?format=api", "source": [ "Helium" ], "previous_source": "", "target": [ "" ], "id_hash": 5782600359580313982, "content_hash": 5782600359580313982, "location": "func_xlookup.xhp", "context": "func_xlookup.xhp\npar_id21716739329244\nhelp.text", "note": "D5tG5", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7965, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/113242867/?format=api", "priority": 100, "id": 113245117, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=d03fec63b6d4a97e", "url": "https://translations.documentfoundation.org/api/units/113245117/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:38:20.553149Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?format=api", "source": [ "<input>{=XLOOKUP(\"Kryptonite\";B1:DO1;B1:DO4;\"Unknown element\")}</input> returns the array {\"Unknown element\",\"Unknown element\",\"Unknown element\",\"Unknown element\"}." ], "previous_source": "", "target": [ "" ], "id_hash": -3961206654497531357, "content_hash": -3961206654497531357, "location": "func_xlookup.xhp", "context": "func_xlookup.xhp\npar_id671708356683379\nhelp.text", "note": "vaCSD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7966, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/113242868/?format=api", "priority": 100, "id": 113245118, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=4906f788fcc2da23", "url": "https://translations.documentfoundation.org/api/units/113245118/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:38:20.554110Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?format=api", "source": [ "Searches for a value in a one-dimensional array and returns the relative position of the item." ], "previous_source": "", "target": [ "" ], "id_hash": 4790560323384865954, "content_hash": 4790560323384865954, "location": "func_xmatch.xhp", "context": "func_xmatch.xhp\npar_id581708279355738\nhelp.text", "note": "8GYav", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7971, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/113242869/?format=api", "priority": 100, "id": 113245119, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=c27b7d3b8e6f74a2", "url": "https://translations.documentfoundation.org/api/units/113245119/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:38:20.557158Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?format=api", "source": [ "XMATCH outperforms function <link href=\"text/scalc/01/04060109.xhp#Section12\">MATCH</link> as it allows searches according to the search mode." ], "previous_source": "", "target": [ "" ], "id_hash": 20644941746071029, "content_hash": 20644941746071029, "location": "func_xmatch.xhp", "context": "func_xmatch.xhp\npar_id321716754048322\nhelp.text", "note": "qJsbC", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7972, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/113242870/?format=api", "priority": 100, "id": 113245120, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=80495877132ee5f5", "url": "https://translations.documentfoundation.org/api/units/113245120/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-03T20:38:20.558149Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?format=api", "source": [ "If you need to change a criterion easily, you may specify it in a separate cell and use a reference to this cell in the condition of the SUMIF function. For example:" ], "previous_source": "", "target": [ "" ], "id_hash": 6694771020294497606, "content_hash": 6694771020294497606, "location": "func_sumif.xhp", "context": "func_sumif.xhp\npar_id561711031254255\nhelp.text", "note": "BVQrr", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7658, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 32, "source_unit": "https://translations.documentfoundation.org/api/units/113252534/?format=api", "priority": 100, "id": 113252716, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=dce89ac5c53ba546", "url": "https://translations.documentfoundation.org/api/units/113252716/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-06T11:53:33.171425Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?format=api", "source": [ "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/INDIRECT\">INDIRECT wiki page</link>." ], "previous_source": "", "target": [ "" ], "id_hash": 5380036932438878388, "content_hash": 5380036932438878388, "location": "04060109.xhp", "context": "04060109.xhp\npar_id701677016751509\nhelp.text", "note": "MssCB", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2038, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/113259862/?format=api", "priority": 100, "id": 113260627, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=caa9bb15dc8068b4", "url": "https://translations.documentfoundation.org/api/units/113260627/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-10T13:30:22.809425Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?format=api", "source": [ "LET function" ], "previous_source": "", "target": [ "" ], "id_hash": 1990380590024096603, "content_hash": 1990380590024096603, "location": "func_let.xhp", "context": "func_let.xhp\ntit\nhelp.text", "note": "ANivD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7224, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/113259863/?format=api", "priority": 100, "id": 113260628, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=9b9f4099e437fb5b", "url": "https://translations.documentfoundation.org/api/units/113260628/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-10T13:30:25.587488Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?format=api", "source": [ "<bookmark_value>LET function</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": -5619471719371825378, "content_hash": -5619471719371825378, "location": "func_let.xhp", "context": "func_let.xhp\nbm_id361708283183878\nhelp.text", "note": "mp4Fy", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7225, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/113259864/?format=api", "priority": 100, "id": 113260629, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=3203a03e957d1f1e", "url": "https://translations.documentfoundation.org/api/units/113260629/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-10T13:30:25.588610Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?format=api", "source": [ "<variable id=\"h1\"><link href=\"text/scalc/01/func_let.xhp\">LET</link></variable>" ], "previous_source": "", "target": [ "" ], "id_hash": 4761206583786135496, "content_hash": 4761206583786135496, "location": "func_let.xhp", "context": "func_let.xhp\nhd_id721717677746932\nhelp.text", "note": "cUrJc", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7226, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 3, "source_unit": "https://translations.documentfoundation.org/api/units/113259865/?format=api", "priority": 100, "id": 113260630, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=c213342978d2dfc8", "url": "https://translations.documentfoundation.org/api/units/113260630/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-10T13:30:25.589579Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?format=api", "source": [ "Assigns names to calculation results. This allows storing intermediate calculations, values, or defining names inside a formula. These names only apply within the scope of the LET function." ], "previous_source": "", "target": [ "" ], "id_hash": 2970498258313303213, "content_hash": 2970498258313303213, "location": "func_let.xhp", "context": "func_let.xhp\npar_id71717677746935\nhelp.text", "note": "NFFDr", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7227, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 28, "source_unit": "https://translations.documentfoundation.org/api/units/113259866/?format=api", "priority": 100, "id": 113260631, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=a939546d74ae54ad", "url": "https://translations.documentfoundation.org/api/units/113260631/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-10T13:30:25.590547Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?format=api", "source": [ "LET(Name1; Name_value1; Calculation_or_Name2; [Name_value2; Calculation_or_Name3 [; ...]])" ], "previous_source": "", "target": [ "" ], "id_hash": 4556853629358978612, "content_hash": 4556853629358978612, "location": "func_let.xhp", "context": "func_let.xhp\npar_id211708281649651\nhelp.text", "note": "A9iKa", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7228, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 7, "source_unit": "https://translations.documentfoundation.org/api/units/113259867/?format=api", "priority": 100, "id": 113260632, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=bf3d323b8f643634", "url": "https://translations.documentfoundation.org/api/units/113260632/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-10T13:30:25.591527Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?format=api", "source": [ "<emph>Name1</emph>: the first name to assign. Must start with a letter. Cannot be the output of a formula or conflict with range syntax." ], "previous_source": "", "target": [ "" ], "id_hash": -8602941962873102523, "content_hash": -8602941962873102523, "location": "func_let.xhp", "context": "func_let.xhp\npar_id301717681619674\nhelp.text", "note": "voGvK", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7229, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 23, "source_unit": "https://translations.documentfoundation.org/api/units/113259868/?format=api", "priority": 100, "id": 113260633, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=089c35dd77a59f45", "url": "https://translations.documentfoundation.org/api/units/113260633/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-10T13:30:25.592478Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?format=api", "source": [ "Name1 must follow the <link href=\"text/scalc/guide/value_with_name.xhp\">naming rules of %PRODUCTNAME Calc</link>." ], "previous_source": "", "target": [ "" ], "id_hash": 6191346384833506896, "content_hash": 6191346384833506896, "location": "func_let.xhp", "context": "func_let.xhp\npar_id721717688901981\nhelp.text", "note": "CDP5D", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7230, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/113259869/?format=api", "priority": 100, "id": 113260634, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=d5ec14bbdd666e50", "url": "https://translations.documentfoundation.org/api/units/113260634/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-10T13:30:25.593449Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?format=api", "source": [ "<emph>Name_value1</emph>: the value or calculation to assign to Name1." ], "previous_source": "", "target": [ "" ], "id_hash": 3574424279183359466, "content_hash": 3574424279183359466, "location": "func_let.xhp", "context": "func_let.xhp\npar_id951717681624139\nhelp.text", "note": "pXGwN", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7231, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/113259870/?format=api", "priority": 100, "id": 113260635, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=b19ae7f19d417dea", "url": "https://translations.documentfoundation.org/api/units/113260635/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-10T13:30:25.594417Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?format=api", "source": [ "<emph>Name2; Name_value2;...</emph>: (optional) same as Name1 and Name_value1, respectively. Name_value2 must follow Name2 and so on." ], "previous_source": "", "target": [ "" ], "id_hash": 7077235568600816289, "content_hash": 7077235568600816289, "location": "func_let.xhp", "context": "func_let.xhp\npar_id421717686226452\nhelp.text", "note": "RpF5L", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7232, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/113259871/?format=api", "priority": 100, "id": 113260636, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=e2376440ba361aa1", "url": "https://translations.documentfoundation.org/api/units/113260636/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-10T13:30:25.595358Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?format=api", "source": [ "<emph>Calculation</emph>: a formula expression that uses all names within the LET function." ], "previous_source": "", "target": [ "" ], "id_hash": 8137769495232274667, "content_hash": 8137769495232274667, "location": "func_let.xhp", "context": "func_let.xhp\npar_id231717686233659\nhelp.text", "note": "ii4Cd", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7233, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/113259872/?format=api", "priority": 100, "id": 113260637, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=f0ef2a3d7b5460eb", "url": "https://translations.documentfoundation.org/api/units/113260637/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-10T13:30:25.596310Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?format=api", "source": [ "<emph>Calculation</emph> must be the last argument in the LET function." ], "previous_source": "", "target": [ "" ], "id_hash": -5929069330371037692, "content_hash": -5929069330371037692, "location": "func_let.xhp", "context": "func_let.xhp\npar_id91717686350018\nhelp.text", "note": "AaFRL", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7234, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/113259873/?format=api", "priority": 100, "id": 113260638, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=2db7b6db8a923604", "url": "https://translations.documentfoundation.org/api/units/113260638/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-10T13:30:25.597248Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?format=api", "source": [ "Calculate the molar mass of the water molecule knowing that the molecule has 2 hydrogen atoms and one oxygen atom." ], "previous_source": "", "target": [ "" ], "id_hash": -1959073628428631352, "content_hash": -1959073628428631352, "location": "func_let.xhp", "context": "func_let.xhp\npar_id121717701196975\nhelp.text", "note": "vGdpF", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7235, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/113259874/?format=api", "priority": 100, "id": 113260639, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=64cff8ea20ad02c8", "url": "https://translations.documentfoundation.org/api/units/113260639/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-10T13:30:25.598197Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?format=api", "source": [ "<input>=LET(mHydro; HLOOKUP(\"Hydrogen\"; $A$1:$DO$4; 4; 0); mOxy; HLOOKUP(\"Oxygen\"; $A$1:$DO$4; 4; 0); \"The molar mass of water is \"&(mOxy+2*mHydro)&\" g/mol\")</input> returns \"The molar mass of water is 18.015 g/mol\"." ], "previous_source": "", "target": [ "" ], "id_hash": -6890932177909452756, "content_hash": -6890932177909452756, "location": "func_let.xhp", "context": "func_let.xhp\npar_id311717701158800\nhelp.text", "note": "s46BC", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7236, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 27, "source_unit": "https://translations.documentfoundation.org/api/units/113259875/?format=api", "priority": 100, "id": 113260640, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=205e7db1a465f02c", "url": "https://translations.documentfoundation.org/api/units/113260640/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-10T13:30:25.599173Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?format=api", "source": [ "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/LET\">LET wiki page</link>." ], "previous_source": "", "target": [ "" ], "id_hash": -3954689845045384000, "content_hash": -3954689845045384000, "location": "func_let.xhp", "context": "func_let.xhp\npar_id701677016751508\nhelp.text", "note": "TGwea", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7237, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/113259876/?format=api", "priority": 100, "id": 113260641, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=491e1e89ed39acc0", "url": "https://translations.documentfoundation.org/api/units/113260641/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-10T13:30:25.600145Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?format=api", "source": [ "Any of the optional arguments can be omitted. An optional argument requires all preceding separators to be present." ], "previous_source": "", "target": [ "" ], "id_hash": 7163934109599625286, "content_hash": 7163934109599625286, "location": "common_func.xhp", "context": "common_func.xhp\npar_id431716730587722\nhelp.text", "note": "s37P8", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 6036, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/113263597/?format=api", "priority": 100, "id": 113264107, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=e36b681dd4fd7046", "url": "https://translations.documentfoundation.org/api/units/113264107/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-20T11:38:07.762101Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?format=api", "source": [ "XLOOKUP function is a modern and flexible replacement for older functions like <link href=\"text/scalc/01/04060109.xhp#Section9\">VLOOKUP</link>, <link href=\"text/scalc/01/04060109.xhp#Section17\">HLOOKUP</link>, and <link href=\"text/scalc/01/04060109.xhp#Section14\">LOOKUP</link>. XLOOKUP supports approximate and exact matching, wildcards (* ?) or regular expressions for partial matches, and lookups in vertical or horizontal ranges. XLOOKUP can perform a reverse search and offers a fast binary search option when working with large datasets." ], "previous_source": "", "target": [ "" ], "id_hash": -5816581931961691979, "content_hash": -5816581931961691979, "location": "func_xlookup.xhp", "context": "func_xlookup.xhp\npar_id631708282151776\nhelp.text", "note": "mekaB", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7943, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 59, "source_unit": "https://translations.documentfoundation.org/api/units/113263599/?format=api", "priority": 100, "id": 113264109, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=2f47598cea77d0b5", "url": "https://translations.documentfoundation.org/api/units/113264109/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-06-20T11:38:07.960635Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?format=api", "source": [ "<emph>3</emph>: a <link href=\"text/shared/01/02100001.xhp\">regular expression</link> match." ], "previous_source": "", "target": [ "" ], "id_hash": 3971188993379063238, "content_hash": 3971188993379063238, "location": "func_xlookup.xhp", "context": "func_xlookup.xhp\npar_id111718970605394\nhelp.text", "note": "GAYga", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7955, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/113273796/?format=api", "priority": 100, "id": 113274051, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=b71c7f59664cd5c6", "url": "https://translations.documentfoundation.org/api/units/113274051/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-07-09T09:49:57.096292Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?format=api", "source": [ "<emph>2</emph>: a <link href=\"text/scalc/guide/wildcards.xhp\">wildcard</link> match where characters *, ?, and ~ have special meanings." ], "previous_source": "", "target": [ "" ], "id_hash": 8088043945987217076, "content_hash": 8088043945987217076, "location": "func_xmatch.xhp", "context": "func_xmatch.xhp\npar_id881708281558005\nhelp.text", "note": "WUvAp", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7980, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/113273798/?format=api", "priority": 100, "id": 113274053, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=f03e811dd85116b4", "url": "https://translations.documentfoundation.org/api/units/113274053/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-07-09T09:49:57.100690Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?format=api", "source": [ "<emph>3</emph>: a <link href=\"text/shared/01/02100001.xhp\">regular expression</link> match." ], "previous_source": "", "target": [ "" ], "id_hash": -8985921050195676254, "content_hash": -8985921050195676254, "location": "func_xmatch.xhp", "context": "func_xmatch.xhp\npar_id111718970605394\nhelp.text", "note": "EQfjm", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7981, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/113273799/?format=api", "priority": 100, "id": 113274054, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=034b986a0f61b3a2", "url": "https://translations.documentfoundation.org/api/units/113274054/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-07-09T09:49:57.101858Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-master/textscalc01/ka/?format=api", "source": [ "XLOOKUP( [Search criterion] ; Search Array ; Result Array [ ; [ Result if not found ] [ ; [Match Mode] [ ; Search Mode ] ] ] )" ], "previous_source": "", "target": [ "" ], "id_hash": 3895744510617587133, "content_hash": 3895744510617587133, "location": "func_xlookup.xhp", "context": "func_xlookup.xhp\npar_id211708281649651\nhelp.text", "note": "CY5Hu", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 7944, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 29, "source_unit": "https://translations.documentfoundation.org/api/units/113275442/?format=api", "priority": 100, "id": 113276309, "web_url": "https://translations.documentfoundation.org/translate/libo_help-master/textscalc01/ka/?checksum=b61076fdeb0a0dbd", "url": "https://translations.documentfoundation.org/api/units/113276309/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-07-15T13:37:07.439225Z" } ] }{ "count": 8573, "next": "