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=15325
{ "count": 766762, "next": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/changes/?format=api&page=15326", "previous": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/changes/?format=api&page=15324", "results": [ { "unit": "https://translations.documentfoundation.org/api/units/99098508/?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.249181Z", "action": 59, "target": "In this example the search criteria area contains only one heading. Since there are two conditions in consecutive rows, these are connected by OR. With the above example database table and this search criteria area, insert the formula <item type=\"input\">=DCOUNT(A1:E10;;B12:B14)</item> into an empty cell elsewhere in the sheet to count how many of Joe’s guests are either 9 or 10 years old. The value 4 is returned (counting Andy, Betty, Charles, and Harry).", "id": 36726292, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726292/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99098445/?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.249139Z", "action": 59, "target": "<emph>Age</emph>", "id": 36726291, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726291/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99098406/?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.249096Z", "action": 59, "target": "Example 3", "id": 36726290, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726290/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99098380/?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.249051Z", "action": 59, "target": "In this example the search criteria area contains only two headings and these are not vertically aligned with the corresponding headings in the example database table. Since there are two conditions in the same row, these are connected by AND. With the above example database table and this search criteria area, insert the formula <item type=\"input\">=DCOUNT(A1:E10;;B12:C13)</item> into an empty cell elsewhere in the sheet to count how many of Joe’s guests are in grade 2 and greater than 7 years old. The value 2 is returned (counting Eva and Irene).", "id": 36726289, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726289/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99098348/?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.249008Z", "action": 59, "target": "<emph>Grade</emph>", "id": 36726288, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726288/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99098347/?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.248964Z", "action": 59, "target": "<emph>Age</emph>", "id": 36726287, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726287/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99098346/?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.248923Z", "action": 59, "target": "Example 2", "id": 36726286, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726286/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99098342/?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.248881Z", "action": 59, "target": "Note also that the formula <item type=\"input\">=DCOUNT(A1:E10;;D12:D13)</item> returns exactly the same value, demonstrating that it is only necessary for the search criteria area to contain relevant column headings.", "id": 36726285, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36726285/?format=api" }, { "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" } ] }