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=15300
{ "count": 765504, "next": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/changes/?format=api&page=15301", "previous": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/changes/?format=api&page=15299", "results": [ { "unit": "https://translations.documentfoundation.org/api/units/99098318/?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.248835Z", "action": 59, "target": "As in this simple example, it is sometimes desirable (but not essential) to place the search criteria area directly under the database table, with the columns of the two areas vertically aligned. Blank entries in the search criteria area are ignored. With the above example database table and this search criteria area, insert the formula <item type=\"input\">=DCOUNT(A1:E10;;A12:E14)</item> into an empty cell elsewhere in the sheet to count how many of Joe’s guests travel further than 600 meters to school. The value 5 is returned (counting Betty, Daniel, Eva, Harry, and Irene).", "id": 36726284, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726284/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99098290/?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.248794Z", "action": 59, "target": "<emph>Weight</emph>", "id": 36726283, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726283/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99098268/?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.248753Z", "action": 59, "target": "<emph>Distance</emph>", "id": 36726282, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726282/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99098251/?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.248712Z", "action": 59, "target": "<emph>Age</emph>", "id": 36726281, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726281/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99098217/?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.248670Z", "action": 59, "target": "<emph>Grade</emph>", "id": 36726280, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726280/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99098183/?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.248629Z", "action": 59, "target": "<emph>Name</emph>", "id": 36726279, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726279/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99098177/?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.248589Z", "action": 59, "target": "Example 1", "id": 36726278, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726278/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99098162/?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.248547Z", "action": 59, "target": "The following six examples use the database table above, combined with different search criteria areas.", "id": 36726277, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726277/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99098147/?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.248506Z", "action": 59, "target": "Irene", "id": 36726276, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726276/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99098125/?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.248465Z", "action": 59, "target": "Harry", "id": 36726275, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726275/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99098124/?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.248424Z", "action": 59, "target": "Greta", "id": 36726274, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726274/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99098123/?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.248382Z", "action": 59, "target": "Frank", "id": 36726273, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726273/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99098122/?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.248341Z", "action": 59, "target": "Eva", "id": 36726272, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726272/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99098121/?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.248296Z", "action": 59, "target": "Daniel", "id": 36726271, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726271/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99098120/?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.248245Z", "action": 59, "target": "Charles", "id": 36726270, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726270/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99098119/?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.248203Z", "action": 59, "target": "Betty", "id": 36726269, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726269/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99098118/?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.248162Z", "action": 59, "target": "Andy", "id": 36726268, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726268/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99098117/?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.248120Z", "action": 59, "target": "<emph>Weight</emph>", "id": 36726267, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726267/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99098101/?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.248078Z", "action": 59, "target": "<emph>Distance</emph>", "id": 36726266, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726266/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99098060/?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.248036Z", "action": 59, "target": "<emph>Age</emph>", "id": 36726265, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726265/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99098035/?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.247996Z", "action": 59, "target": "<emph>Grade</emph>", "id": 36726264, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726264/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99098000/?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.247955Z", "action": 59, "target": "<emph>Name</emph>", "id": 36726263, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726263/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99097982/?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.247912Z", "action": 59, "target": "The following table provides an example database table that is utilized to demonstrate how to use the functions in the Database category. The cell range A1:E10 contains fictitious information about the guests invited to Joe's birthday party. The following information is given for each guest - name, school grade, age in years, distance to school in meters, and weight in kilograms.", "id": 36726262, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726262/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99097981/?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.247873Z", "action": 59, "target": "Examples of Database Function Use", "id": 36726261, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726261/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99097962/?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.247831Z", "action": 59, "target": "Another setting that affects how the search criteria are handled is the <menuitem>Search criteria = and <> must apply to whole cells</menuitem> option on the <link href=\"text/shared/optionen/01060500.xhp\"><switchinline select=\"sys\"><caseinline select=\"MAC\"><menuitem>%PRODUCTNAME - Preferences</menuitem></caseinline><defaultinline><menuitem>Tools - Options</menuitem></defaultinline></switchinline><menuitem> - %PRODUCTNAME Calc - Calculate</menuitem></link> dialog. This option controls whether the search criteria you set for the Database functions must match the whole cell exactly. When interoperability with Microsoft Excel is important for your spreadsheet, this option should be enabled.", "id": 36726260, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726260/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99097913/?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.247789Z", "action": 59, "target": "Even more powerful criteria can be created using regular expressions, providing that regular expressions have been enabled via the <menuitem>Enable regular expressions in formulas</menuitem> option on the <link href=\"text/shared/optionen/01060500.xhp\"><switchinline select=\"sys\"><caseinline select=\"MAC\"><menuitem>%PRODUCTNAME - Preferences</menuitem></caseinline><defaultinline><menuitem>Tools - Options</menuitem></defaultinline></switchinline><menuitem> - %PRODUCTNAME Calc - Calculate</menuitem></link> dialog.", "id": 36726259, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726259/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99097852/?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.247747Z", "action": 59, "target": "Criteria can be created using wildcards, providing that wildcards have been enabled via the <menuitem>Enable wildcards in formulas</menuitem> option on the <link href=\"text/shared/optionen/01060500.xhp\"><switchinline select=\"sys\"><caseinline select=\"MAC\"><menuitem>%PRODUCTNAME - Preferences</menuitem></caseinline><defaultinline><menuitem>Tools - Options</menuitem></defaultinline></switchinline><menuitem> - %PRODUCTNAME Calc - Calculate</menuitem></link> dialog. When interoperability with Microsoft Excel is important for your spreadsheet, this option should be enabled.", "id": 36726258, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726258/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99097769/?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.247707Z", "action": 59, "target": "If you write several criteria in one row, they are connected by AND. If you write several criteria in different rows, they are connected by OR.", "id": 36726257, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726257/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99097721/?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.247667Z", "action": 59, "target": "Create criteria in the cells of the <emph>SearchCriteria</emph> area using the comparison operators <, <=, =, <>, >=, and >. = is assumed if a cell is not empty but does not start with a comparison operator.", "id": 36726256, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726256/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99097677/?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.247627Z", "action": 59, "target": "Search criteria are entered into the cells of the second and subsequent rows of the <emph>SearchCriteria</emph> area, below the row containing headings. Blank cells within the <emph>SearchCriteria</emph> area are ignored.", "id": 36726255, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726255/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99097639/?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.247586Z", "action": 59, "target": "The number of columns occupied by the <emph>SearchCriteria</emph> area need not be the same as the width of the <emph>Database</emph> area. All headings that appear in the first row of <emph>SearchCriteria</emph> must be identical to headings in the first row of <emph>Database</emph>. However, not all headings in <emph>Database</emph> need appear in the first row of <emph>SearchCriteria</emph>, while a heading in <emph>Database</emph> can appear multiple times in the first row of <emph>SearchCriteria</emph>.", "id": 36726254, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726254/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99097602/?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.247547Z", "action": 59, "target": "Defining Search Criteria", "id": 36726253, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726253/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99097574/?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.247508Z", "action": 59, "target": "The contents of the <emph>SearchCriteria</emph> area are described in more detail in the next section.", "id": 36726252, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726252/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99097538/?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.247466Z", "action": 59, "target": "Err:504 (error in parameter list) may also be reported as a result of an invalid <emph>SearchCriteria</emph> argument.", "id": 36726251, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726251/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99097537/?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.247421Z", "action": 59, "target": "One way of defining the range of cells is to enter the cell reference for the upper left-hand cell, followed by a colon (:), and then the lower right-hand cell reference. For example, A13:B14. The cell range may also be specified by passing the name of a defined named range or database range. If the name does not match the name of a defined range, Calc reports a #NAME? error.", "id": 36726250, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726250/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99097536/?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.247379Z", "action": 59, "target": "<emph>SearchCriteria</emph> specifies the range of cells containing search criteria. Like <emph>Database</emph>, its first row is also field names, and subsequent rows are conditions for related fields. The <emph>Database</emph> and <emph>SearchCriteria</emph> areas need not be adjacent, or even on the same sheet.", "id": 36726249, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726249/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99097535/?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.247337Z", "action": 59, "target": "<emph>SearchCriteria argument</emph>", "id": 36726248, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726248/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99097511/?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.247293Z", "action": 59, "target": "The <emph>DatabaseField</emph> argument is optional for the DCOUNT and DCOUNTA functions but it is required for the other ten Database functions.", "id": 36726247, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726247/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99097411/?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.247244Z", "action": 59, "target": "By entering the literal column header name from the first row of the <emph>Database</emph> range, placing quotation marks around the header name. For example, “Distance to School”. If the string does not match one of the <emph>Database</emph> area’s column headings, Calc reports Err:504 (error in parameter list). You can also provide a reference to an arbitrary cell (not within the <emph>Database</emph> and <emph>SearchCriteria</emph> areas) that contains the required string.", "id": 36726246, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726246/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99097366/?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.247198Z", "action": 59, "target": "By entering a number to specify the column within the <emph>Database</emph> area, starting with 1. For example, if a <emph>Database</emph> occupied the cell range D6:H123, then enter 3 to indicate the header cell at F6. Calc expects an integer value that lies between 1 and the number of columns defined within <emph>Database</emph> and ignores any digits after a decimal point. If the value is less than 1, Calc reports Err:504 (error in parameter list). If the value is greater than the number of columns in <emph>Database</emph>, Calc reports a #VALUE! error.", "id": 36726245, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726245/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99097325/?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.247154Z", "action": 59, "target": "By entering a reference to a header cell within the <emph>Database</emph> area. Alternatively, if the cell has been given a meaningful name as a named range or database range, enter that name. If the name does not match the name of a defined range, Calc reports a #NAME? error. If the name is valid but does not correspond to one cell only, Calc reports Err:504 (error in parameter list).", "id": 36726244, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726244/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99097323/?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.247111Z", "action": 59, "target": "Specify the <emph>DatabaseField</emph> argument in any of the following ways:", "id": 36726243, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726243/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99097294/?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.247067Z", "action": 59, "target": "<emph>DatabaseField</emph> specifies the column which the function will use for its calculations after the search criteria have been applied and the data rows have been selected. It is not related to the search criteria.", "id": 36726242, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726242/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99097261/?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.247028Z", "action": 59, "target": "<emph>DatabaseField argument</emph>", "id": 36726241, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726241/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99097190/?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.246987Z", "action": 59, "target": "Other errors that might be reported as a result of an invalid <emph>Database</emph> argument are #VALUE! and Err:504 (error in parameter list).", "id": 36726240, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726240/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99097154/?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.246942Z", "action": 59, "target": "The <emph>Database</emph> argument may also be specified by passing the name of a named range or database range. Using a meaningful name to define the cell range can enhance formula readability and document maintenance. If the name does not match the name of a defined range, Calc reports a #NAME? error.", "id": 36726239, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726239/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99097148/?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.246900Z", "action": 59, "target": "One way of defining the range of cells is to enter the cell reference for the upper left-hand cell, followed by a colon (:), and then the lower right-hand cell reference. An example might be A1:E10.", "id": 36726238, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726238/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99097108/?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.246857Z", "action": 59, "target": "<emph>Database</emph> specifies the range of cells occupied by the database table. The first row of the range contains the field names, and subsequent rows are records with corresponding field values.", "id": 36726237, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726237/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99097064/?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.246815Z", "action": 59, "target": "<emph>Database argument</emph>", "id": 36726236, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726236/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99097024/?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.246770Z", "action": 59, "target": "The following argument definitions apply for all functions in the Database category:", "id": 36726235, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726235/?format=api" } ] }