Changes
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/components/libo_help-7-6/textscalc01/changes/?format=api&page=15293
{ "count": 766774, "next": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/changes/?format=api&page=15294", "previous": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/changes/?format=api&page=15292", "results": [ { "unit": "https://translations.documentfoundation.org/api/units/99155026/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.756940Z", "action": 59, "target": "ROWS(Array)", "id": 36728419, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728419/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99155022/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.756902Z", "action": 59, "target": "<ahelp hid=\"HID_FUNC_ZEILEN\">Returns the number of rows in a reference or array.</ahelp>", "id": 36728418, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728418/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99155006/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.756865Z", "action": 59, "target": "ROWS", "id": 36728417, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728417/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99154981/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.756827Z", "action": 59, "target": "<bookmark_value>ROWS function</bookmark_value>", "id": 36728416, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728416/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99154951/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.756789Z", "action": 59, "target": "<item type=\"input\">{=ROW(Rabbit)}</item> returns the single-column array (1, 2, 3) if \"Rabbit\" is the named area (C1:D3).", "id": 36728415, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728415/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99154944/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.756751Z", "action": 59, "target": "<item type=\"input\">=ROW()</item> returns 3 if the formula was entered in row 3.", "id": 36728414, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728414/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99154923/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.756712Z", "action": 59, "target": "<item type=\"input\">{=ROW(A1:E1)}</item> and <item type=\"input\">=ROW(A1:E1)</item> both return 1 because the reference only contains row 1 as the first row in the table. (Because single-row areas only have one row number it does not make any difference whether or not the formula is used as an array formula.)", "id": 36728413, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728413/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99154896/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.756673Z", "action": 59, "target": "<item type=\"input\">=ROW(D5:D8)</item> returns 5 because the ROW function is not used as array formula and only the number of the first row of the reference is returned.", "id": 36728412, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728412/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99154867/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.756635Z", "action": 59, "target": "<item type=\"input\">{=ROW(D5:D8)}</item> returns the single-column array (5, 6, 7, 8) because the reference specified contains rows 5 through 8.", "id": 36728411, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728411/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99154823/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.756597Z", "action": 59, "target": "<item type=\"input\">=ROW(B3)</item> returns 3 because the reference refers to the third row in the table.", "id": 36728410, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728410/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99154811/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.756559Z", "action": 59, "target": "If you do not indicate a reference, the row number of the cell in which the formula is entered will be found. <item type=\"productname\">%PRODUCTNAME</item> Calc automatically sets the reference to the current cell.", "id": 36728409, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728409/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99154788/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.756520Z", "action": 59, "target": "<emph>Reference</emph> is a cell, an area, or the name of an area.", "id": 36728408, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728408/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99154738/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.756483Z", "action": 59, "target": "ROW([Reference])", "id": 36728407, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728407/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99154718/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.756443Z", "action": 59, "target": "<ahelp hid=\"HID_FUNC_ZEILE\">Returns the row number of a cell reference.</ahelp> If the reference is a cell, it returns the row number of the cell. If the reference is a cell range, it returns the corresponding row numbers in a one-column <link href=\"text/scalc/01/04060107.xhp#wasmatrix\">Array</link> if the formula is entered <link href=\"text/scalc/01/04060107.xhp#creating_array_formulas\">as an array formula</link>. If the ROW function with a range reference is not used in an array formula, only the row number of the first range cell will be returned.", "id": 36728406, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728406/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99154674/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.756405Z", "action": 59, "target": "ROW", "id": 36728405, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728405/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99154646/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.756366Z", "action": 59, "target": "<bookmark_value>ROW function</bookmark_value>", "id": 36728404, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728404/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99154624/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.756326Z", "action": 59, "target": "<input>=HLOOKUP(\"Carbon\"; $A$1:$DO$4; 4; 0)</input> returns 12.011, the relative atomic mass of carbon.", "id": 36728403, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728403/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99154590/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.756269Z", "action": 59, "target": "<input>=HLOOKUP(\"Gold\"; $A$1:$DO$4; 3; 0)</input> returns 79, the atomic number for gold.", "id": 36728402, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728402/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99154570/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.756227Z", "action": 59, "target": "<input>=HLOOKUP(\"Lead\"; $A$1:$DO$4; 2; 0)</input> returns “Pb”, the symbol for lead.", "id": 36728401, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728401/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99154536/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.756190Z", "action": 59, "target": "Relative Atomic Mass", "id": 36728400, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728400/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99154506/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.756153Z", "action": 59, "target": "Atomic Number", "id": 36728399, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728399/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99154469/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.756116Z", "action": 59, "target": "Symbol", "id": 36728398, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728398/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99154434/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.756078Z", "action": 59, "target": "Oganesson", "id": 36728397, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728397/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99154391/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.756039Z", "action": 59, "target": "Lithium", "id": 36728396, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728396/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99154344/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.756001Z", "action": 59, "target": "Helium", "id": 36728395, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728395/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99154318/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.755965Z", "action": 59, "target": "Hydrogen", "id": 36728394, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728394/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99154294/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.755928Z", "action": 59, "target": "Element", "id": 36728393, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728393/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99154244/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.755887Z", "action": 59, "target": "Suppose we have built a small database table occupying the cell range A1:DO4 and containing basic information about 118 chemical elements. The first column contains the row headings “Element”, “Symbol”, “Atomic Number”, and “Relative Atomic Mass”. Subsequent columns contain the relevant information for each of the elements, ordered left to right by atomic number. For example, cells B1:B4 contain “Hydrogen”, “H”, “1” and “1.008”, while cells DO1:DO4 contain “Oganesson”, “Og”, “118”, and “294”.", "id": 36728392, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728392/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99154232/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.755849Z", "action": 59, "target": "For an explanation on the parameters, see: <link href=\"text/scalc/01/04060109.xhp#Section9\">VLOOKUP</link> (columns and rows are exchanged)", "id": 36728391, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728391/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99154201/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.755811Z", "action": 59, "target": "HLOOKUP(Lookup; Array; Index [; SortedRangeLookup])", "id": 36728390, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728390/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99154164/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.755773Z", "action": 59, "target": "<ahelp hid=\"HID_FUNC_WVERWEIS\">Searches for a value and reference to the cells below the selected area.</ahelp> This function verifies if the first row of an array contains a certain value. The function returns then the value in a row of the array, named in the <emph>Index</emph>, in the same column.", "id": 36728389, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728389/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99154126/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.755735Z", "action": 59, "target": "HLOOKUP", "id": 36728388, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728388/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99154092/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.755698Z", "action": 59, "target": "<bookmark_value>HLOOKUP function</bookmark_value>", "id": 36728387, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728387/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99154053/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.755659Z", "action": 59, "target": "<item type=\"input\">=CHOOSE(A1;B1;B2;B3;\"Today\";\"Yesterday\";\"Tomorrow\")</item>, for example, returns the contents of cell B2 for A1 = 2; for A1 = 4, the function returns the text \"Today\".", "id": 36728386, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728386/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99153998/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.755621Z", "action": 59, "target": "<emph>Value 1, Value 2, ..., Value 30</emph> is the list of values entered as a reference to a cell or as individual values.", "id": 36728385, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728385/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99153962/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.755583Z", "action": 59, "target": "<emph>Index</emph> is a reference or number between 1 and 30 indicating which value is to be taken from the list.", "id": 36728384, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728384/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99153945/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.755546Z", "action": 59, "target": "CHOOSE(Index; Value 1 [; Value 2 [; ... [; Value 30]]])", "id": 36728383, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728383/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99153919/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.755509Z", "action": 59, "target": "<ahelp hid=\"HID_FUNC_WAHL\">Uses an index to return a value from a list of up to 30 values.</ahelp>", "id": 36728382, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728382/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99153895/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.755470Z", "action": 59, "target": "CHOOSE", "id": 36728381, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728381/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99153870/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.755431Z", "action": 59, "target": "<bookmark_value>CHOOSE function</bookmark_value>", "id": 36728380, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728380/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99153847/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.755391Z", "action": 59, "target": "<item type=\"input\">=LOOKUP(A1;D1:D100;F1:F100)</item> searches the corresponding cell in range D1:D100 for the number you entered in A1. For the instance found, the index is determined, for example, the 12th cell in this range. Then, the contents of the 12th cell are returned as the value of the function (in the result vector).", "id": 36728379, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728379/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99153836/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.755353Z", "action": 59, "target": "<emph>ResultVector</emph> is another single-row or single-column range from which the result of the function is taken. The result is the cell of the result vector with the same index as the instance found in the search vector.", "id": 36728378, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728378/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99153815/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.755315Z", "action": 59, "target": "<emph>SearchVector</emph> is the single-row or single-column area to be searched.", "id": 36728377, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728377/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99153796/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.755275Z", "action": 59, "target": "<emph>Lookup</emph> is the value of any type to be looked for; entered either directly or as a reference.", "id": 36728376, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728376/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99153779/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.755237Z", "action": 59, "target": "LOOKUP(Lookup; SearchVector [; ResultVector])", "id": 36728375, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728375/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99153722/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.755196Z", "action": 59, "target": "If LOOKUP cannot find the search criterion, it matches the largest value in the search vector that is less than or equal to the search criterion.", "id": 36728374, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728374/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99153698/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.755155Z", "action": 59, "target": "<ahelp hid=\"HID_FUNC_VERWEIS\">Returns the contents of a cell either from a one-row or one-column range.</ahelp> Optionally, the assigned value (of the same index) is returned in a different column and row. As opposed to <link href=\"text/scalc/01/04060109.xhp#Section9\">VLOOKUP</link> and <link href=\"text/scalc/01/04060109.xhp#Section17\">HLOOKUP</link>, search and result vector may be at different positions; they do not have to be adjacent. Additionally, the search vector for the LOOKUP must be sorted ascending, otherwise the search will not return any usable results.", "id": 36728373, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728373/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99153663/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.755118Z", "action": 59, "target": "LOOKUP", "id": 36728372, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728372/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99153660/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.755080Z", "action": 59, "target": "<bookmark_value>LOOKUP function</bookmark_value>", "id": 36728371, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728371/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99153634/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalc01/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:52:49.755041Z", "action": 59, "target": "If <emph>Width</emph> or <emph>Height</emph> are given, the OFFSET function returns a cell range reference. If <emph>Reference</emph> is a single cell reference and both <emph>Width</emph> and <emph>Height</emph> are omitted, a single cell reference is returned.", "id": 36728370, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728370/?format=api" } ] }