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=15294
{ "count": 766774, "next": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/changes/?format=api&page=15295", "previous": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/changes/?format=api&page=15293", "results": [ { "unit": "https://translations.documentfoundation.org/api/units/99153585/?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.755003Z", "action": 59, "target": "<item type=\"input\">=SUM(OFFSET(A1;2;2;5;6))</item> determines the total of the area that starts in cell C3 and has a height of 5 rows and a width of 6 columns (area=C3:H7).", "id": 36728369, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728369/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99153555/?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.754964Z", "action": 59, "target": "<item type=\"input\">=OFFSET(B2:C3;1;0;3;4)</item> returns a reference to B2:C3 moved down by one row resized to 3 rows and 4 columns (B3:E5).", "id": 36728368, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728368/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99153534/?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.754925Z", "action": 59, "target": "<item type=\"input\">=OFFSET(B2:C3;0;0;3;4)</item> returns a reference to B2:C3 resized to 3 rows and 4 columns (B2:E4).", "id": 36728367, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728367/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99153500/?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.754885Z", "action": 59, "target": "<item type=\"input\">=OFFSET(B2:C3;-1;-1)</item> returns a reference to B2:C3 moved up by 1 row and one column to the left (A1:B2).", "id": 36728366, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728366/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99153428/?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.754845Z", "action": 59, "target": "<item type=\"input\">=OFFSET(B2:C3;1;1)</item> returns a reference to B2:C3 moved down by 1 row and one column to the right (C3:D4).", "id": 36728365, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728365/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99153371/?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.754803Z", "action": 59, "target": "<item type=\"input\">=OFFSET(A1;2;2)</item> returns the value in cell C3 (A1 moved by two rows and two columns down). If C3 contains the value <item type=\"input\">100</item> this function returns the value 100.", "id": 36728364, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728364/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99153340/?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.754764Z", "action": 59, "target": "Arguments <emph>Height</emph> and <emph>Width</emph> must not lead to zero or negative count of rows or columns.", "id": 36728363, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728363/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99153308/?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.754724Z", "action": 59, "target": "Arguments <emph>Rows</emph> and <emph>Columns</emph> must not lead to zero or negative start row or column.", "id": 36728362, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728362/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99153284/?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.754685Z", "action": 59, "target": "<emph>Width</emph> (optional) is the horizontal width for an area that starts at the new reference position.", "id": 36728361, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728361/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99153259/?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.754645Z", "action": 59, "target": "<emph>Height</emph> (optional) is the vertical height for an area that starts at the new reference position.", "id": 36728360, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728360/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99153237/?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.754605Z", "action": 59, "target": "<emph>Columns</emph> is the number of columns by which the reference was corrected to the left (negative value) or to the right. Use 0 to stay in the same column", "id": 36728359, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728359/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99153218/?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.754564Z", "action": 59, "target": "<emph>Rows</emph> is the number of rows by which the reference was corrected up (negative value) or down. Use 0 to stay in the same row.", "id": 36728358, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728358/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99153191/?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.754524Z", "action": 59, "target": "<emph>Reference</emph> is the reference from which the function searches for the new reference.", "id": 36728357, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728357/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99153164/?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.754482Z", "action": 59, "target": "OFFSET(Reference; Rows; Columns [; Height [; Width]])", "id": 36728356, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728356/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99153133/?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.754442Z", "action": 59, "target": "<ahelp hid=\"HID_FUNC_VERSCHIEBUNG\">Returns the value of a cell offset by a certain number of rows and columns from a given reference point.</ahelp>", "id": 36728355, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728355/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99153117/?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.754402Z", "action": 59, "target": "OFFSET", "id": 36728354, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728354/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99153094/?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.754363Z", "action": 59, "target": "<bookmark_value>OFFSET function</bookmark_value>", "id": 36728353, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728353/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99153090/?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.754323Z", "action": 59, "target": "<item type=\"input\">=MATCH(200;D1:D100)</item> searches the area D1:D100, which is sorted by column D, for the value 200. As soon as this value is reached, the number of the row in which it was found is returned. If a higher value is found during the search in the column, the number of the previous row is returned.", "id": 36728352, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728352/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99153081/?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.754283Z", "action": 59, "target": "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.", "id": 36728351, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728351/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99153071/?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.754242Z", "action": 59, "target": "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).", "id": 36728350, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728350/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99153060/?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.754199Z", "action": 59, "target": "<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.", "id": 36728349, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728349/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99153029/?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.754159Z", "action": 59, "target": "<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.", "id": 36728348, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728348/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99152996/?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.754121Z", "action": 59, "target": "<emph>Search</emph> is the value which is to be searched for in the single-row or single-column array.", "id": 36728347, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728347/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99152964/?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.754084Z", "action": 59, "target": "MATCH(Search; LookupArray [; Type])", "id": 36728346, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728346/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99152920/?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.754044Z", "action": 59, "target": "<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.", "id": 36728345, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728345/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99152878/?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.754004Z", "action": 59, "target": "MATCH", "id": 36728344, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728344/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99152859/?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.753964Z", "action": 59, "target": "<bookmark_value>MATCH function</bookmark_value>", "id": 36728343, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728343/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99152822/?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.753923Z", "action": 59, "target": "<item type=\"input\">=SHEETS(Sheet1.A1:Sheet3.G12)</item> returns 3 if Sheet1, Sheet2, and Sheet3 exist in the sequence indicated.", "id": 36728342, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728342/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99152782/?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.753882Z", "action": 59, "target": "<emph>Reference</emph> is the reference to a sheet or an area. This parameter is optional.", "id": 36728341, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728341/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99152736/?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.753839Z", "action": 59, "target": "SHEETS([Reference])", "id": 36728340, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728340/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99152675/?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.753795Z", "action": 59, "target": "<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.", "id": 36728339, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728339/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99152646/?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.753742Z", "action": 59, "target": "SHEETS", "id": 36728338, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728338/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99152617/?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.753701Z", "action": 59, "target": "<bookmark_value>number of sheets; function</bookmark_value> <bookmark_value>SHEETS function</bookmark_value>", "id": 36728337, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728337/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99152588/?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.753675Z", "action": 59, "target": "<input>=SHEET(\"Sheet3\")</input> returns 3 if Sheet3 is the third sheet in the spreadsheet document.", "id": 36728336, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728336/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99152563/?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.753648Z", "action": 59, "target": "<input>=SHEET(Sheet2.A1)</input> returns 2 if Sheet2 is the second sheet in the spreadsheet document.", "id": 36728335, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728335/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99152536/?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.753621Z", "action": 59, "target": "<emph>Reference</emph> is optional and is the reference to a cell, an area, or a sheet name string.", "id": 36728334, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728334/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99152497/?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.753593Z", "action": 59, "target": "SHEET([Reference])", "id": 36728333, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728333/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99152459/?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.753553Z", "action": 59, "target": "<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.", "id": 36728332, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728332/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99152430/?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.753504Z", "action": 59, "target": "SHEET", "id": 36728331, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728331/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99152400/?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.753479Z", "action": 59, "target": "<bookmark_value>sheet numbers; looking up</bookmark_value> <bookmark_value>SHEET function</bookmark_value>", "id": 36728330, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728330/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99152340/?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.753451Z", "action": 59, "target": "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.", "id": 36728329, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728329/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99152301/?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.753425Z", "action": 59, "target": "<item type=\"input\">=VLOOKUP(A1;D1:E100;2)</item>", "id": 36728328, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728328/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99152244/?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.753398Z", "action": 59, "target": "Enter the following formula in B1:", "id": 36728327, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728327/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99152219/?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.753369Z", "action": 59, "target": "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.", "id": 36728326, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728326/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99152168/?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.753338Z", "action": 59, "target": "<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>.", "id": 36728325, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728325/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99152130/?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.753307Z", "action": 59, "target": "<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.", "id": 36728324, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728324/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99152101/?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.753281Z", "action": 59, "target": "<emph>Array</emph> is the reference, which is to comprise at least as many columns as the number passed in Index argument.", "id": 36728323, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728323/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99152072/?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.753255Z", "action": 59, "target": "<emph>Lookup</emph> is the value of any type looked for in the first column of the array.", "id": 36728322, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728322/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99152051/?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.753229Z", "action": 59, "target": "=VLOOKUP(Lookup; Array; Index [; SortedRangeLookup])", "id": 36728321, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728321/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99152037/?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.753200Z", "action": 59, "target": "<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.", "id": 36728320, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728320/?format=api" } ] }