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=15295
{ "count": 766774, "next": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/changes/?format=api&page=15296", "previous": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/changes/?format=api&page=15294", "results": [ { "unit": "https://translations.documentfoundation.org/api/units/99152032/?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.753174Z", "action": 59, "target": "VLOOKUP", "id": 36728319, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728319/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99152008/?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.753147Z", "action": 59, "target": "<bookmark_value>vertical search function</bookmark_value> <bookmark_value>VLOOKUP function</bookmark_value>", "id": 36728318, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728318/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99151971/?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.753120Z", "action": 59, "target": "<item type=\"input\">=COLUMNS(Rabbit)</item> returns 2 if <item type=\"literal\">Rabbit</item> is the named range (C1:D3).", "id": 36728317, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728317/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99151970/?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.753093Z", "action": 59, "target": "<item type=\"input\">=COLUMNS(A1:C5)</item> equals 3. The reference comprises three columns.", "id": 36728316, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728316/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99151969/?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.753067Z", "action": 59, "target": "<item type=\"input\">=COLUMNS(B5)</item> returns 1 because a cell only contains one column.", "id": 36728315, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728315/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99151968/?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.753040Z", "action": 59, "target": "<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.", "id": 36728314, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728314/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99151967/?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.753013Z", "action": 59, "target": "COLUMNS(Array)", "id": 36728313, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728313/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99151953/?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.752985Z", "action": 59, "target": "<ahelp hid=\"HID_FUNC_SPALTEN\">Returns the number of columns in the given reference.</ahelp>", "id": 36728312, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728312/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99151932/?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.752958Z", "action": 59, "target": "COLUMNS", "id": 36728311, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728311/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99151919/?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.752932Z", "action": 59, "target": "<bookmark_value>COLUMNS function</bookmark_value>", "id": 36728310, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728310/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99151885/?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.752906Z", "action": 59, "target": "<item type=\"input\">{=COLUMN(Rabbit)}</item> returns the single-row array (3, 4) if \"Rabbit\" is the named area (C1:D3).", "id": 36728309, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728309/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99151869/?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.752880Z", "action": 59, "target": "<item type=\"input\">=COLUMN()</item> returns 3 if the formula was entered in column C.", "id": 36728308, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728308/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99151848/?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.752852Z", "action": 59, "target": "<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.", "id": 36728307, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728307/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99151827/?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.752824Z", "action": 59, "target": "<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.)", "id": 36728306, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728306/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99151794/?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.752798Z", "action": 59, "target": "<item type=\"input\">=COLUMN(C3:E3)</item> equals 3. Column C is the third column in the table.", "id": 36728305, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728305/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99151768/?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.752772Z", "action": 59, "target": "<item type=\"input\">=COLUMN(A1)</item> equals 1. Column A is the first column in the table.", "id": 36728304, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728304/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99151737/?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.752745Z", "action": 59, "target": "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.", "id": 36728303, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728303/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99151702/?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.752719Z", "action": 59, "target": "<emph>Reference</emph> is the reference to a cell or cell area whose first column number is to be found.", "id": 36728302, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728302/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99151656/?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.752692Z", "action": 59, "target": "COLUMN([Reference])", "id": 36728301, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728301/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99151633/?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.752662Z", "action": 59, "target": "<ahelp hid=\"HID_FUNC_SPALTE\">Returns the column number of a cell reference.</ahelp> If the reference is a cell the column number of the cell is returned; if the parameter is a cell area, the corresponding column numbers are returned in a single-row <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 COLUMN function with an area reference parameter is not used for an array formula, only the column number of the first cell within the area is determined.", "id": 36728300, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728300/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99151590/?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.752636Z", "action": 59, "target": "COLUMN", "id": 36728299, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728299/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99151550/?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.752609Z", "action": 59, "target": "<bookmark_value>COLUMN function</bookmark_value>", "id": 36728298, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728298/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99151507/?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.752581Z", "action": 59, "target": "<item type=\"input\">=SUM(INDIRECT(\"a1:\" & ADDRESS(1;3)))</item> totals the cells in the area of A1 up to the cell with the address defined by row 1 and column 3. This means that area A1:C1 is totaled.", "id": 36728297, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728297/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99151463/?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.752555Z", "action": 59, "target": "<item type=\"input\">=INDIRECT(A1)</item> equals 100 if A1 contains C108 as a reference and cell C108 contains a value of <item type=\"input\">100</item>.", "id": 36728296, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728296/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99151423/?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.752527Z", "action": 59, "target": "If you open an Excel spreadsheet that uses indirect addresses calculated from string functions, the sheet addresses will not be translated automatically. For example, the Excel address in INDIRECT(\"[filename]sheetname!\"&B1) is not converted into the Calc address in INDIRECT(\"filename#sheetname.\"&B1).", "id": 36728295, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728295/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99151381/?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.752500Z", "action": 59, "target": "<emph>A1</emph> (optional) - if set to 0, the R1C1 notation is used. If this parameter is absent or set to another value than 0, the A1 notation is used.", "id": 36728294, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728294/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99151320/?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.752474Z", "action": 59, "target": "<emph>Ref</emph> represents a reference to a cell or an area (in text form) for which to return the contents.", "id": 36728293, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728293/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99151285/?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.752448Z", "action": 59, "target": "INDIRECT(Ref [; A1])", "id": 36728292, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728292/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99151255/?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.752421Z", "action": 59, "target": "<ahelp hid=\"HID_FUNC_INDIREKT\">Returns the <emph>reference</emph> specified by a text string.</ahelp> This function can also be used to return the area of a corresponding string.", "id": 36728291, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728291/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99151194/?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.752396Z", "action": 59, "target": "INDIRECT", "id": 36728290, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728290/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99151173/?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.752368Z", "action": 59, "target": "<bookmark_value>INDIRECT function</bookmark_value>", "id": 36728289, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728289/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99151140/?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.752341Z", "action": 59, "target": "<link href=\"https://wiki.documentfoundation.org/Documentation/Calc_Functions/INDEX\">INDEX wiki page</link>.", "id": 36728288, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728288/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99151115/?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.752313Z", "action": 59, "target": "<input>{=INDEX((A1:B6;C1:D6);0;0;2)}</input> returns the values of the second range C1:D6 of the multiple range. Enter the formula as an <link href=\"text/scalc/01/04060107.xhp\">array formula</link>.", "id": 36728287, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728287/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99151086/?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.752267Z", "action": 59, "target": "<item type=\"input\">=INDEX(A1:B6;1;1)</item> indicates the value in the upper-left of the A1:B6 range.", "id": 36728286, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728286/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99151060/?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.752239Z", "action": 59, "target": "<input>{=INDEX(A1:B6;0;1)}</input> returns the values of the first column of A1:B6. Enter the formula as an <link href=\"text/scalc/01/04060107.xhp\">array formula</link>.", "id": 36728285, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728285/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99151001/?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.752213Z", "action": 59, "target": "<input>{=INDEX(A1:B6;1)}</input> returns the values of the first row of A1:B6. Enter the formula as an <link href=\"text/scalc/01/04060107.xhp\">array formula</link>.", "id": 36728284, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728284/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99150936/?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.752185Z", "action": 59, "target": "<item type=\"input\">=INDEX(SumX;4;1)</item> returns the value from the range <emph>SumX</emph> in row 4 and column 1 as defined in <emph>Sheet - Named Ranges and Expressions - Define</emph>.", "id": 36728283, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728283/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99150912/?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.752157Z", "action": 59, "target": "<item type=\"input\">=INDEX(Prices;4;1)</item> returns the value from row 4 and column 1 of the database range defined in <emph>Data - Define</emph> as <emph>Prices</emph>.", "id": 36728282, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728282/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99150870/?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.752121Z", "action": 59, "target": "<input>{=INDEX(D3:G12,{1;2;3;4},{3,1})}</input> return a 4 rows by 2 columns array. The row index array {1;2;3;4} picks rows 3 to 6 and {3;1} picks the third (F) and first column (D). Columns 1 and 3 of the source reference are swapped in the resulting array.", "id": 36728281, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728281/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99150833/?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.752077Z", "action": 59, "target": "<input>{=INDEX({1,3,5;7,9,10},{2;1},1)}</input> return a 2 row array containing 7 and 1. The row index {2;1} pick row 2 then row 1. The columns index 1 picks the first column.", "id": 36728280, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728280/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99150816/?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.752028Z", "action": 59, "target": "<emph>Range</emph> (optional) represents the index of the subrange if referring to a multiple range, default is 1.", "id": 36728279, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728279/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99150815/?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.751979Z", "action": 59, "target": "If <emph>Row</emph>, <emph>Column</emph> or both are omitted or defined as arrays of indexes, the INDEX function must be entered as an <link href=\"text/scalc/01/04060107.xhp\">array function</link>.", "id": 36728278, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728278/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99150803/?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.751933Z", "action": 59, "target": "<emph>Column</emph> (optional) represents the column or array of column indexes of the reference range, for which to return a value. In case of zero or omitted (no specific column) all referenced columns are returned.", "id": 36728277, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728277/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99150775/?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.751886Z", "action": 59, "target": "<emph>Row</emph> (optional) represents the row or the array of row indexes of the reference range, for which to return a value. In case of zero or omitted (no specific row) all referenced rows are returned.", "id": 36728276, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728276/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99150747/?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.751841Z", "action": 59, "target": "<emph>Reference</emph> is a reference, entered either directly or by specifying a range name. If the reference consists of multiple ranges, you must enclose the list of references or range names in parentheses, or either use the tilde (~) <link href=\"text/scalc/01/04060199.xhp#referenceoperators\">range concatenation operator</link> or define a named range with multiple areas.", "id": 36728275, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728275/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99150723/?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.751799Z", "action": 59, "target": "INDEX(Reference [; [Row] [; [Column] [; Range]]])", "id": 36728274, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728274/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99150697/?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.751756Z", "action": 59, "target": "INDEX() returns a reference if the argument is one or more references. When used in a cell in the form =INDEX(), the reference is resolved and the values displayed. When INDEX() is used in arguments of other functions, =FUNCTION(INDEX()...), the function gets the reference passed that was returned by INDEX(). Returning a reference is different from returning an array of values for functions that handles them differently.", "id": 36728273, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728273/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99150661/?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.751713Z", "action": 59, "target": "<ahelp hid=\"HID_FUNC_INDEX\">INDEX returns a reference, a value or an array of values from a reference range, specified by row and column index number or array of row and array of columns index numbers, and an optional range index.</ahelp>", "id": 36728272, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728272/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99150637/?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.751678Z", "action": 59, "target": "INDEX", "id": 36728271, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728271/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99150619/?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.751652Z", "action": 59, "target": "<bookmark_value>INDEX function</bookmark_value>", "id": 36728270, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728270/?format=api" } ] }