Units
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-24-2/textscalc01/en_AU/units/?format=api&page=42
https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/units/?format=api&page=43", "previous": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/units/?format=api&page=41", "results": [ { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<emph>Reference</emph> is the reference to a cell or cell area whose first column number is to be found." ], "previous_source": "", "target": [ "" ], "id_hash": 2624934417222538836, "content_hash": 2624934417222538836, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3156310\nhelp.text", "note": "CAB6L", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2051, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 18, "source_unit": "https://translations.documentfoundation.org/api/units/110979263/?format=api", "priority": 100, "id": 112108612, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=a46da3f1e93f1654", "url": "https://translations.documentfoundation.org/api/units/112108612/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:01.998921Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "If no reference is entered, the column number of the cell in which the formula is entered is found. <item type=\"productname\">%PRODUCTNAME</item> Calc automatically sets the reference to the current cell." ], "previous_source": "", "target": [ "" ], "id_hash": 1245808751497917804, "content_hash": 1245808751497917804, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3155837\nhelp.text", "note": "RHuRB", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2052, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 30, "source_unit": "https://translations.documentfoundation.org/api/units/110979299/?format=api", "priority": 100, "id": 112108614, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=914a00757b1b356c", "url": "https://translations.documentfoundation.org/api/units/112108614/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:02.001126Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<item type=\"input\">=COLUMN(A1)</item> equals 1. Column A is the first column in the table." ], "previous_source": "", "target": [ "" ], "id_hash": -717789900446273925, "content_hash": -717789900446273925, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3147571\nhelp.text", "note": "9iffF", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2053, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/110979327/?format=api", "priority": 100, "id": 112108615, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=7609e5e378896e7b", "url": "https://translations.documentfoundation.org/api/units/112108615/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:02.002868Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<item type=\"input\">=COLUMN(C3:E3)</item> equals 3. Column C is the third column in the table." ], "previous_source": "", "target": [ "" ], "id_hash": 5843269173771338390, "content_hash": 5843269173771338390, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3147079\nhelp.text", "note": "ynF5Q", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2054, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/110979343/?format=api", "priority": 100, "id": 112108617, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=d117765ac5a18296", "url": "https://translations.documentfoundation.org/api/units/112108617/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:02.004485Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<item type=\"input\">=COLUMN(D3:G10)</item> returns 4 because column D is the fourth column in the table and the COLUMN function is not used as an array formula. (In this case, the first value of the array is always used as the result.)" ], "previous_source": "", "target": [ "" ], "id_hash": 3637248509712134828, "content_hash": 3637248509712134828, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3146861\nhelp.text", "note": "eJP98", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2055, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 40, "source_unit": "https://translations.documentfoundation.org/api/units/110979373/?format=api", "priority": 100, "id": 112108618, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=b27a1a3fa535f2ac", "url": "https://translations.documentfoundation.org/api/units/112108618/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:02.005858Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<item type=\"input\">{=COLUMN(B2:B7)}</item> and <item type=\"input\">=COLUMN(B2:B7)</item> both return 2 because the reference only contains column B as the second column in the table. Because single-column areas have only one column number, it does not make a difference whether or not the formula is used as an array formula." ], "previous_source": "", "target": [ "" ], "id_hash": -5681665261762630883, "content_hash": -5681665261762630883, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3156320\nhelp.text", "note": "7pQJY", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2056, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 47, "source_unit": "https://translations.documentfoundation.org/api/units/110979399/?format=api", "priority": 100, "id": 112108619, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=3126ab8c13f62b1d", "url": "https://translations.documentfoundation.org/api/units/112108619/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:02.007114Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<item type=\"input\">=COLUMN()</item> returns 3 if the formula was entered in column C." ], "previous_source": "", "target": [ "" ], "id_hash": -5375268047102608714, "content_hash": -5375268047102608714, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3150872\nhelp.text", "note": "ED6XM", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2057, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/110979454/?format=api", "priority": 100, "id": 112108622, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=35673630c7f0fab6", "url": "https://translations.documentfoundation.org/api/units/112108622/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:02.009026Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<item type=\"input\">{=COLUMN(Rabbit)}</item> returns the single-row array (3, 4) if \"Rabbit\" is the named area (C1:D3)." ], "previous_source": "", "target": [ "" ], "id_hash": 8245206584465583030, "content_hash": 8245206584465583030, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3153277\nhelp.text", "note": "vsiPD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2058, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 15, "source_unit": "https://translations.documentfoundation.org/api/units/110979484/?format=api", "priority": 100, "id": 112108623, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=f26cdbb41ec86bb6", "url": "https://translations.documentfoundation.org/api/units/112108623/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:02.010754Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<bookmark_value>COLUMNS function</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": 4594670014859081288, "content_hash": 4594670014859081288, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id3154643\nhelp.text", "note": "cGRsQ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2059, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/110979507/?format=api", "priority": 100, "id": 112108624, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=bfc38c08efd07648", "url": "https://translations.documentfoundation.org/api/units/112108624/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:02.012021Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "COLUMNS" ], "previous_source": "", "target": [ "" ], "id_hash": 4605148601445119632, "content_hash": 4605148601445119632, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3154643\nhelp.text", "note": "VF3tg", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2060, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110979551/?format=api", "priority": 100, "id": 112108626, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=bfe8c640ff05f690", "url": "https://translations.documentfoundation.org/api/units/112108626/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:02.013261Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_SPALTEN\">Returns the number of columns in the given reference.</ahelp>" ], "previous_source": "", "target": [ "" ], "id_hash": -6672832419299237583, "content_hash": -6672832419299237583, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3151182\nhelp.text", "note": "eydFV", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2061, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 10, "source_unit": "https://translations.documentfoundation.org/api/units/110979584/?format=api", "priority": 100, "id": 112108628, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=23655644d1f56131", "url": "https://translations.documentfoundation.org/api/units/112108628/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:02.014559Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "COLUMNS(Array)" ], "previous_source": "", "target": [ "" ], "id_hash": 1178941322166737854, "content_hash": 1178941322166737854, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3154047\nhelp.text", "note": "DDKAg", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2062, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110979631/?format=api", "priority": 100, "id": 112108630, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=905c70e2dec71bbe", "url": "https://translations.documentfoundation.org/api/units/112108630/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:02.015848Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<emph>Array</emph> is the reference to a cell range whose total number of columns is to be found. The argument can also be a single cell." ], "previous_source": "", "target": [ "" ], "id_hash": -4574496684817857887, "content_hash": -4574496684817857887, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3154745\nhelp.text", "note": "YUPGz", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2063, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 25, "source_unit": "https://translations.documentfoundation.org/api/units/110979664/?format=api", "priority": 100, "id": 112108632, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=40841f807b3ac2a1", "url": "https://translations.documentfoundation.org/api/units/112108632/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:02.017112Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<item type=\"input\">=COLUMNS(B5)</item> returns 1 because a cell only contains one column." ], "previous_source": "", "target": [ "" ], "id_hash": 6507744520544517154, "content_hash": 6507744520544517154, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3149577\nhelp.text", "note": "dkd2t", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2064, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 11, "source_unit": "https://translations.documentfoundation.org/api/units/110979713/?format=api", "priority": 100, "id": 112108633, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=da502729740cfc22", "url": "https://translations.documentfoundation.org/api/units/112108633/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:02.018387Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<item type=\"input\">=COLUMNS(A1:C5)</item> equals 3. The reference comprises three columns." ], "previous_source": "", "target": [ "" ], "id_hash": 3411673746354730818, "content_hash": 3411673746354730818, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3145649\nhelp.text", "note": "AyKRA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2065, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 9, "source_unit": "https://translations.documentfoundation.org/api/units/110979755/?format=api", "priority": 100, "id": 112108634, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=af58b3324cfff742", "url": "https://translations.documentfoundation.org/api/units/112108634/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:02.019651Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<item type=\"input\">=COLUMNS(Rabbit)</item> returns 2 if <item type=\"literal\">Rabbit</item> is the named range (C1:D3)." ], "previous_source": "", "target": [ "" ], "id_hash": 8816812195949992683, "content_hash": 8816812195949992683, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3155846\nhelp.text", "note": "F9UyA", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2066, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 12, "source_unit": "https://translations.documentfoundation.org/api/units/110979798/?format=api", "priority": 100, "id": 112108636, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=fa5b9bfa8eee5aeb", "url": "https://translations.documentfoundation.org/api/units/112108636/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:02.020940Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<bookmark_value>vertical search function</bookmark_value> <bookmark_value>VLOOKUP function</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": -460514873228285841, "content_hash": -460514873228285841, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id3153152\nhelp.text", "note": "G5anB", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2067, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/110979845/?format=api", "priority": 100, "id": 112108638, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=799bec29a771a86f", "url": "https://translations.documentfoundation.org/api/units/112108638/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:02.022215Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "VLOOKUP" ], "previous_source": "", "target": [ "" ], "id_hash": 9082438316321787784, "content_hash": 9082438316321787784, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3153152\nhelp.text", "note": "fZRnb", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2068, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110979892/?format=api", "priority": 100, "id": 112108641, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=fe0b4d8722c1cf88", "url": "https://translations.documentfoundation.org/api/units/112108641/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:02.023583Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_SVERWEIS\">Vertical search with reference to adjacent cells to the right.</ahelp> This function checks if a specific value is contained in the first column of an array. The function then returns the value in the same row of the column named by <emph>Index</emph>. If the <emph>Sorted</emph> parameter is omitted or set to TRUE or one, it is assumed that the data is sorted in ascending order. In this case, if the exact <emph>Lookup</emph> is not found, the last value that is smaller than the criterion will be returned. If <emph>Sorted</emph> is set to FALSE or zero, an exact match must be found, otherwise the error <emph>Error: Value Not Available</emph> will be the result. Thus with a value of zero the data does not need to be sorted in ascending order." ], "previous_source": "", "target": [ "" ], "id_hash": 1344072553765718025, "content_hash": 1344072553765718025, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3149984\nhelp.text", "note": "qFEgu", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2069, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 130, "source_unit": "https://translations.documentfoundation.org/api/units/110979910/?format=api", "priority": 100, "id": 112108643, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=92a71addcf8ec809", "url": "https://translations.documentfoundation.org/api/units/112108643/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:02.024932Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "=VLOOKUP(Lookup; Array; Index [; SortedRangeLookup])" ], "previous_source": "", "target": [ "" ], "id_hash": -1404160986737100578, "content_hash": -1404160986737100578, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3150156\nhelp.text", "note": "j8RoY", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2070, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 5, "source_unit": "https://translations.documentfoundation.org/api/units/110979979/?format=api", "priority": 100, "id": 112108645, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=6c836b05aa12b8de", "url": "https://translations.documentfoundation.org/api/units/112108645/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:02.026402Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<emph>Lookup</emph> is the value of any type looked for in the first column of the array." ], "previous_source": "", "target": [ "" ], "id_hash": -4100685287716172017, "content_hash": -4100685287716172017, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3149289\nhelp.text", "note": "LDrCq", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2071, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/110980011/?format=api", "priority": 100, "id": 112108648, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=471770750a01cf0f", "url": "https://translations.documentfoundation.org/api/units/112108648/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:02.027693Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<emph>Array</emph> is the reference, which is to comprise at least as many columns as the number passed in Index argument." ], "previous_source": "", "target": [ "" ], "id_hash": 4049811973206833510, "content_hash": 4049811973206833510, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3153884\nhelp.text", "note": "WFj5E", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2072, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 20, "source_unit": "https://translations.documentfoundation.org/api/units/110980045/?format=api", "priority": 100, "id": 112108650, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=b833d288661df966", "url": "https://translations.documentfoundation.org/api/units/112108650/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:02.029077Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<emph>Index</emph> is the number of the column in the array that contains the value to be returned. The first column has the number 1." ], "previous_source": "", "target": [ "" ], "id_hash": 4473339114076965019, "content_hash": 4473339114076965019, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3156005\nhelp.text", "note": "tEMvM", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2073, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 24, "source_unit": "https://translations.documentfoundation.org/api/units/110980087/?format=api", "priority": 100, "id": 112108652, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=be147e39366b089b", "url": "https://translations.documentfoundation.org/api/units/112108652/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:02.030357Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<emph>SortedRangeLookup</emph> is an optional parameter that indicates whether the first column in the array contains range boundaries instead of plain values. In this mode, the lookup returns the value in the row with first column having value equal to or less than <emph>Lookup</emph>. E.g., it could contain dates when some tax value had been changed, and so the values represent starting dates of a period when a specific tax value was effective. Thus, searching for a date that is absent in the first array column, but falls between some existing boundary dates, would give the lower of them, allowing to find out the data being effective to the searched date. Enter the Boolean value FALSE or zero if the first column is not a range boundary list. When this parameter is TRUE or not given, the first column in the array <emph>must be sorted in ascending order</emph>. Sorted columns can be searched much faster and the function always returns a value, even if the search value was not matched exactly, if it is greater than the lowest value of the sorted list. In unsorted lists, the search value must be matched exactly. Otherwise the function will return #N/A with message: <emph>Error: Value Not Available</emph>." ], "previous_source": "", "target": [ "" ], "id_hash": -5293601005237555600, "content_hash": -5293601005237555600, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3151208\nhelp.text", "note": "qKRbD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2074, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 204, "source_unit": "https://translations.documentfoundation.org/api/units/110980140/?format=api", "priority": 100, "id": 112108654, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=368959eeb42a2e70", "url": "https://translations.documentfoundation.org/api/units/112108654/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:02.031688Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "You want to enter the number of a dish on the menu in cell A1, and the name of the dish is to appear as text in the neighboring cell (B1) immediately. The Number to Name assignment is contained in the D1:E100 array. D1 contains <item type=\"input\">100</item>, E1 contains the name <item type=\"input\">Vegetable Soup</item>, and so forth, for 100 menu items. The numbers in column D are sorted in ascending order; thus, the optional <item type=\"literal\">Sorted</item> parameter is not necessary." ], "previous_source": "", "target": [ "" ], "id_hash": 5590887794157254537, "content_hash": 5590887794157254537, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3154129\nhelp.text", "note": "fJQRf", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2075, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 80, "source_unit": "https://translations.documentfoundation.org/api/units/110980179/?format=api", "priority": 100, "id": 112108657, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=cd96d2d3b5cf7789", "url": "https://translations.documentfoundation.org/api/units/112108657/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:02.033381Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "Enter the following formula in B1:" ], "previous_source": "", "target": [ "" ], "id_hash": 3302636846429914310, "content_hash": 3302636846429914310, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3145663\nhelp.text", "note": "2pTXc", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2076, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/110980217/?format=api", "priority": 100, "id": 112108660, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=add552b6b59244c6", "url": "https://translations.documentfoundation.org/api/units/112108660/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:02.034804Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<item type=\"input\">=VLOOKUP(A1;D1:E100;2)</item>" ], "previous_source": "", "target": [ "" ], "id_hash": -3636120927334144249, "content_hash": -3636120927334144249, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3151172\nhelp.text", "note": "W7BCf", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2077, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/110980235/?format=api", "priority": 100, "id": 112108662, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=4d89e74815e26707", "url": "https://translations.documentfoundation.org/api/units/112108662/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:02.036196Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "As soon as you enter a number in A1 B1 will show the corresponding text contained in the second column of reference D1:E100. Entering a nonexistent number displays the text with the next number down. To prevent this, enter FALSE as the last parameter in the formula so that an error message is generated when a nonexistent number is entered." ], "previous_source": "", "target": [ "" ], "id_hash": 259841606044098307, "content_hash": 259841606044098307, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3149200\nhelp.text", "note": "oY9FV", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2078, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 60, "source_unit": "https://translations.documentfoundation.org/api/units/110980260/?format=api", "priority": 100, "id": 112108663, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=839b249062201f03", "url": "https://translations.documentfoundation.org/api/units/112108663/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:02.037457Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<bookmark_value>sheet numbers; looking up</bookmark_value> <bookmark_value>SHEET function</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": -2724982189634343269, "content_hash": -2724982189634343269, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id3153905\nhelp.text", "note": "BPHvz", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2079, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/110980301/?format=api", "priority": 100, "id": 112108664, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=5a2eeb22d7942e9b", "url": "https://translations.documentfoundation.org/api/units/112108664/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:02.038751Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "SHEET" ], "previous_source": "", "target": [ "" ], "id_hash": 8718762049278515776, "content_hash": 8718762049278515776, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3153905\nhelp.text", "note": "tEpv8", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2080, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110980351/?format=api", "priority": 100, "id": 112108666, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=f8ff43e3cc671a40", "url": "https://translations.documentfoundation.org/api/units/112108666/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:02.040537Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_TABELLE\">Returns the sheet number of either a reference or a string representing a sheet name.</ahelp> If you do not enter any parameters, the result is the sheet number of the spreadsheet containing the formula." ], "previous_source": "", "target": [ "" ], "id_hash": 5500430683439494706, "content_hash": 5500430683439494706, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3150309\nhelp.text", "note": "BRXnw", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2081, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 35, "source_unit": "https://translations.documentfoundation.org/api/units/110980381/?format=api", "priority": 100, "id": 112108667, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=cc5574906611f632", "url": "https://translations.documentfoundation.org/api/units/112108667/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:02.041974Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "SHEET([Reference])" ], "previous_source": "", "target": [ "" ], "id_hash": 7060171119697611283, "content_hash": 7060171119697611283, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3153095\nhelp.text", "note": "KRzAZ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2082, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110980448/?format=api", "priority": 100, "id": 112108669, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=e1fac43a1b0c4a13", "url": "https://translations.documentfoundation.org/api/units/112108669/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:02.043250Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<emph>Reference</emph> is optional and is the reference to a cell, an area, or a sheet name string." ], "previous_source": "", "target": [ "" ], "id_hash": 4523632215762722536, "content_hash": 4523632215762722536, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3154588\nhelp.text", "note": "9yCD8", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2083, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 17, "source_unit": "https://translations.documentfoundation.org/api/units/110980480/?format=api", "priority": 100, "id": 112108670, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=bec72b88730cdee8", "url": "https://translations.documentfoundation.org/api/units/112108670/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:02.044239Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<input>=SHEET(Sheet2.A1)</input> returns 2 if Sheet2 is the second sheet in the spreadsheet document." ], "previous_source": "", "target": [ "" ], "id_hash": -8376814135589143232, "content_hash": -8376814135589143232, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3146988\nhelp.text", "note": "wbjCM", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2084, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/110980549/?format=api", "priority": 100, "id": 112108671, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=0bbf93ed0abcfd40", "url": "https://translations.documentfoundation.org/api/units/112108671/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:02.045594Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<input>=SHEET(\"Sheet3\")</input> returns 3 if Sheet3 is the third sheet in the spreadsheet document." ], "previous_source": "", "target": [ "" ], "id_hash": -4871450135322043081, "content_hash": -4871450135322043081, "location": "04060109.xhp", "context": "04060109.xhp\npar_id491612531793751\nhelp.text", "note": "fEQws", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2085, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 13, "source_unit": "https://translations.documentfoundation.org/api/units/110980712/?format=api", "priority": 100, "id": 112108673, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=3c6521e97719dd37", "url": "https://translations.documentfoundation.org/api/units/112108673/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:02.047104Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<bookmark_value>number of sheets; function</bookmark_value> <bookmark_value>SHEETS function</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": -8252590773715677554, "content_hash": -8252590773715677554, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id3148829\nhelp.text", "note": "7ZBfD", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2086, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 6, "source_unit": "https://translations.documentfoundation.org/api/units/110980713/?format=api", "priority": 100, "id": 112108676, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=0d78e86a5802ce8e", "url": "https://translations.documentfoundation.org/api/units/112108676/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:02.048646Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "SHEETS" ], "previous_source": "", "target": [ "" ], "id_hash": -3688537779430513678, "content_hash": -3688537779430513678, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3148829\nhelp.text", "note": "vGLG7", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2087, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110980714/?format=api", "priority": 100, "id": 112108678, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=4ccfae6eac6fa3f2", "url": "https://translations.documentfoundation.org/api/units/112108678/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:02.050196Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_TABELLEN\">Determines the number of sheets in a reference.</ahelp> If you do not enter any parameters, it returns the number of sheets in the current document." ], "previous_source": "", "target": [ "" ], "id_hash": -294850980343089500, "content_hash": -294850980343089500, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3148820\nhelp.text", "note": "A5DpQ", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2088, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 26, "source_unit": "https://translations.documentfoundation.org/api/units/110980715/?format=api", "priority": 100, "id": 112108680, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=7be87a9876f976a4", "url": "https://translations.documentfoundation.org/api/units/112108680/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:02.051692Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "SHEETS([Reference])" ], "previous_source": "", "target": [ "" ], "id_hash": 3577486469911131972, "content_hash": 3577486469911131972, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3150777\nhelp.text", "note": "j5Aps", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2089, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110980770/?format=api", "priority": 100, "id": 112108682, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=b1a5c8fd73d1b744", "url": "https://translations.documentfoundation.org/api/units/112108682/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:02.053240Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<emph>Reference</emph> is the reference to a sheet or an area. This parameter is optional." ], "previous_source": "", "target": [ "" ], "id_hash": 4590120515219508661, "content_hash": 4590120515219508661, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3153060\nhelp.text", "note": "5B3KF", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2090, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/110980791/?format=api", "priority": 100, "id": 112108684, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=bfb3624a01e44db5", "url": "https://translations.documentfoundation.org/api/units/112108684/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:02.054756Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<item type=\"input\">=SHEETS(Sheet1.A1:Sheet3.G12)</item> returns 3 if Sheet1, Sheet2, and Sheet3 exist in the sequence indicated." ], "previous_source": "", "target": [ "" ], "id_hash": 4255690796962648702, "content_hash": 4255690796962648702, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3150507\nhelp.text", "note": "95EFN", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2091, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 14, "source_unit": "https://translations.documentfoundation.org/api/units/110980815/?format=api", "priority": 100, "id": 112108685, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=bb0f403b72db927e", "url": "https://translations.documentfoundation.org/api/units/112108685/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:02.055926Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<bookmark_value>MATCH function</bookmark_value>" ], "previous_source": "", "target": [ "" ], "id_hash": -1826328122546240505, "content_hash": -1826328122546240505, "location": "04060109.xhp", "context": "04060109.xhp\nbm_id3158407\nhelp.text", "note": "JB3Ps", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2092, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 2, "source_unit": "https://translations.documentfoundation.org/api/units/110980845/?format=api", "priority": 100, "id": 112108686, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=66a7943fb4534407", "url": "https://translations.documentfoundation.org/api/units/112108686/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:02.056906Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "MATCH" ], "previous_source": "", "target": [ "" ], "id_hash": 2535335821939796260, "content_hash": 2535335821939796260, "location": "04060109.xhp", "context": "04060109.xhp\nhd_id3158407\nhelp.text", "note": "ExoT8", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2093, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 1, "source_unit": "https://translations.documentfoundation.org/api/units/110980861/?format=api", "priority": 100, "id": 112108687, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=a32f527f4d0b6924", "url": "https://translations.documentfoundation.org/api/units/112108687/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:02.057852Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<ahelp hid=\"HID_FUNC_VERGLEICH\">Returns the relative position of an item in an array that matches a specified value.</ahelp> The function returns the position of the value found in the lookup_array as a number." ], "previous_source": "", "target": [ "" ], "id_hash": -2486715686627209743, "content_hash": -2486715686627209743, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3154896\nhelp.text", "note": "GPfn3", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2094, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 31, "source_unit": "https://translations.documentfoundation.org/api/units/110980885/?format=api", "priority": 100, "id": 112108689, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=5d7d694219318df1", "url": "https://translations.documentfoundation.org/api/units/112108689/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:02.059192Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "MATCH(Search; LookupArray [; Type])" ], "previous_source": "", "target": [ "" ], "id_hash": 3179497475035933733, "content_hash": 3179497475035933733, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3159152\nhelp.text", "note": "AKi9E", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2095, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 4, "source_unit": "https://translations.documentfoundation.org/api/units/110980903/?format=api", "priority": 100, "id": 112108691, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=ac1fd81b9bc4ac25", "url": "https://translations.documentfoundation.org/api/units/112108691/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:02.060678Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<emph>Search</emph> is the value which is to be searched for in the single-row or single-column array." ], "previous_source": "", "target": [ "" ], "id_hash": 5710919532056130791, "content_hash": 5710919532056130791, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3149336\nhelp.text", "note": "KZU4F", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2096, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 16, "source_unit": "https://translations.documentfoundation.org/api/units/110980915/?format=api", "priority": 100, "id": 112108693, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=cf41430e810bb4e7", "url": "https://translations.documentfoundation.org/api/units/112108693/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:02.062196Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<emph>LookupArray</emph> is the reference searched. A lookup array can be a single row or column, or part of a single row or column." ], "previous_source": "", "target": [ "" ], "id_hash": -4473176383460664918, "content_hash": -4473176383460664918, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3159167\nhelp.text", "note": "9j4xw", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2097, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 23, "source_unit": "https://translations.documentfoundation.org/api/units/110980941/?format=api", "priority": 100, "id": 112108694, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=41ec15c7762919aa", "url": "https://translations.documentfoundation.org/api/units/112108694/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:02.063360Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "<emph>Type</emph> may take the values 1, 0, or -1. If Type = 1 or if this optional parameter is missing, it is assumed that the first column of the search array is sorted in ascending order. If Type = -1 it is assumed that the column in sorted in descending order. This corresponds to the same function in Microsoft Excel." ], "previous_source": "", "target": [ "" ], "id_hash": 4627981797138480774, "content_hash": 4627981797138480774, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3147239\nhelp.text", "note": "Z4dMn", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2098, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 60, "source_unit": "https://translations.documentfoundation.org/api/units/110980958/?format=api", "priority": 100, "id": 112108695, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=c039e4eca569be86", "url": "https://translations.documentfoundation.org/api/units/112108695/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:02.064341Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "If Type = 0, only exact matches are found. If the search criterion is found more than once, the function returns the index of the first matching value. Only if Type = 0 can you search for regular expressions (if enabled in calculation options) or wildcards (if enabled in calculation options)." ], "previous_source": "", "target": [ "" ], "id_hash": 6051458463366102660, "content_hash": 6051458463366102660, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3154265\nhelp.text", "note": "8cpYu", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2099, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 51, "source_unit": "https://translations.documentfoundation.org/api/units/110980962/?format=api", "priority": 100, "id": 112108696, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=d3fb196911f7be84", "url": "https://translations.documentfoundation.org/api/units/112108696/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:02.065748Z" }, { "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalc01/en_AU/?format=api", "source": [ "If Type = 1 or the third parameter is missing, the index of the last value that is smaller or equal to the search criterion is returned. For Type = -1, the index of the last value that is larger or equal is returned." ], "previous_source": "", "target": [ "" ], "id_hash": -270661938800531536, "content_hash": -270661938800531536, "location": "04060109.xhp", "context": "04060109.xhp\npar_id3147528\nhelp.text", "note": "vCFkE", "flags": "", "labels": [], "state": 0, "fuzzy": false, "translated": false, "approved": false, "position": 2100, "has_suggestion": false, "has_comment": false, "has_failing_check": false, "num_words": 44, "source_unit": "https://translations.documentfoundation.org/api/units/110981000/?format=api", "priority": 100, "id": 112108698, "web_url": "https://translations.documentfoundation.org/translate/libo_help-24-2/textscalc01/en_AU/?checksum=7c3e6a66939367b0", "url": "https://translations.documentfoundation.org/api/units/112108698/?format=api", "explanation": "", "extra_flags": "", "pending": false, "timestamp": "2024-02-01T19:10:02.067117Z" } ] }{ "count": 8439, "next": "