Changes
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/translations/libo_help-24-2/textscalcguide/en/changes/?format=api
{ "count": 1559, "next": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/changes/?format=api&page=2", "previous": null, "results": [ { "unit": null, "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:26:08.392959Z", "action": 0, "target": "", "id": 48579830, "action_name": "Resource updated", "url": "https://translations.documentfoundation.org/api/changes/48579830/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110843361/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:26:08.392932Z", "action": 59, "target": "This means that if you enter a date of 1/1/30 or higher, it will be treated internally as 1/1/1930 or higher. All lower two-digit years apply to the 20xx century. So, for example, 1/1/20 is converted into 1/1/2020.", "id": 48579829, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48579829/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110843354/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:26:08.392903Z", "action": 59, "target": "Under <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>%PRODUCTNAME - Preferences</emph></caseinline><defaultinline><emph>Tools - Options</emph></defaultinline></switchinline><emph> - $[officename] - General</emph> you can define the century that is used when you enter a year with only two digits. The default is 1930 to 2029.", "id": 48579828, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48579828/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110843330/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:26:08.392875Z", "action": 59, "target": "The year in a date entry is often entered as two digits. Internally, the year is managed by $[officename] as four digits, so that in the calculation of the difference from 1/1/99 to 1/1/01, the result will correctly be two years.", "id": 48579827, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48579827/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110843323/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:26:08.392846Z", "action": 59, "target": "<variable id=\"year2000\"><link href=\"text/scalc/guide/year2000.xhp\">19xx/20xx Years</link></variable>", "id": 48579826, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48579826/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110843318/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:26:08.392813Z", "action": 59, "target": "<bookmark_value>years; 2-digits</bookmark_value><bookmark_value>dates; 19xx/20xx</bookmark_value>", "id": 48579825, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48579825/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110843311/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:26:08.392784Z", "action": 59, "target": "19xx/20xx Years", "id": 48579824, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48579824/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110843295/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:26:08.392755Z", "action": 59, "target": "Wildcard comparisons are <emph>not</emph> case sensitive, hence \"A?\" will match both \"A1\" and \"a1\".", "id": 48579812, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48579812/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110843280/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:26:08.392727Z", "action": 59, "target": "<input>=SUMIF(A1:A5;\"A??\";B1:B5)</input> sums the values in <emph>B1:B5</emph> whose corresponding values in <emph>A1:A5</emph> start with \"A\" followed by exactly two other characters.", "id": 48579811, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48579811/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110843260/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:26:08.392698Z", "action": 59, "target": "<input>=COUNTIF(A1:A10;\"Chi*\")</input> counts the number of cells in the range <emph>A1:A10</emph> containing strings that start with \"Chi\" followed by zero or more characters.", "id": 48579810, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48579810/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110843243/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:26:08.392669Z", "action": 59, "target": "The following examples consider that the options <menuitem>Enable wildcards in formulas</menuitem> and <menuitem>Search criteria = and <> must apply to whole cells</menuitem> are enabled in <switchinline select=\"sys\"><caseinline select=\"MAC\"><menuitem>%PRODUCTNAME - Preferences - %PRODUCTNAME Calc - Calculate</menuitem></caseinline><defaultinline><menuitem>Tools - Options - %PRODUCTNAME Calc - Calculate</menuitem></defaultinline></switchinline>.", "id": 48579809, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48579809/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110843223/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:26:08.392640Z", "action": 59, "target": "Examples of Wildcards in Formulas", "id": 48579808, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48579808/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110843205/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:26:08.392612Z", "action": 59, "target": "<emph>Other functions:</emph> MATCH and SEARCH.", "id": 48579807, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48579807/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110843179/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:26:08.392584Z", "action": 59, "target": "<emph>Lookup functions:</emph> HLOOKUP, LOOKUP and VLOOKUP.", "id": 48579806, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48579806/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110843158/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:26:08.392556Z", "action": 59, "target": "<emph>Conditional functions:</emph> AVERAGEIF, AVERAGEIFS, COUNTIF, COUNTIFS, MAXIFS, MINIFS, SUMIF and SUMIFS.", "id": 48579805, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48579805/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110843142/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:26:08.392528Z", "action": 59, "target": "<emph>Database functions:</emph> DAVERAGE, DCOUNT, DCOUNTA, DGET, DMAX, DMIN, DPRODUCT, DSTDEV, DSTDEVP, DSUM, DVAR and DVARP.", "id": 48579804, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48579804/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110843109/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:26:08.392500Z", "action": 59, "target": "Wildcards are supported by the following spreadsheet functions:", "id": 48579803, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48579803/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110843073/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:26:08.392471Z", "action": 59, "target": "Supported Spreadsheet Functions", "id": 48579802, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48579802/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110843049/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:26:08.392442Z", "action": 59, "target": "Wildcards are supported in %PRODUCTNAME Calc and in Microsoft Excel. Therefore, if interoperability between both applications is needed, choose to work with wildcards instead of regular expressions. Conversely, if interoperability is not necessary, consider using regular expressions for more powerful search capabilities.", "id": 48579801, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48579801/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110843018/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:26:08.392414Z", "action": 59, "target": "For example, the search string \"why~?\" matches “why?” but will not match \"whys\" nor \"why~s\".", "id": 48579800, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48579800/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110843001/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:26:08.392386Z", "action": 59, "target": "Escapes the special meaning of a question mark, asterisk, or tilde character that follows immediately after the tilde character.", "id": 48579799, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48579799/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110842957/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:26:08.392357Z", "action": 59, "target": "<emph>~ (tilde)</emph>", "id": 48579798, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48579798/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110842942/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:26:08.392329Z", "action": 59, "target": "If the option <menuitem>Search criteria = and <> must apply to whole cells</menuitem> is disabled in <switchinline select=\"sys\"><caseinline select=\"MAC\"><menuitem>%PRODUCTNAME - Preferences - %PRODUCTNAME Calc - Calculate</menuitem></caseinline><defaultinline><menuitem>Tools - Options - %PRODUCTNAME Calc - Calculate</menuitem></defaultinline></switchinline>, then \"forecaster\" will be a match using the \"*cast\" search string.", "id": 48579797, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48579797/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110842919/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:26:08.392301Z", "action": 59, "target": "Matches any sequence of characters, including an empty string. For example, the search string \"*cast\" will match “cast”, “forecast”, and “outcast”, but will not match \"forecaster\" using default %PRODUCTNAME settings.", "id": 48579796, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48579796/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110842879/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:26:08.392273Z", "action": 59, "target": "<emph>* (asterisk)</emph>", "id": 48579795, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48579795/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110842850/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:26:08.392245Z", "action": 59, "target": "Note that it will not match \"bg\" as well, since \"?\" must match exactly <emph>one</emph> character. The \"?\" wildcard does not correspond to a zero-character match.", "id": 48579794, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48579794/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110842827/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:26:08.392217Z", "action": 59, "target": "Matches any single character. For example, the search string \"b?g\" matches “bag” and “beg” but will not match \"boog\" or \"mug\".", "id": 48579793, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48579793/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110842810/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:26:08.392189Z", "action": 59, "target": "<emph>? (question mark)</emph>", "id": 48579792, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48579792/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110842791/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:26:08.392160Z", "action": 59, "target": "Description", "id": 48579791, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48579791/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110842738/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:26:08.392132Z", "action": 59, "target": "Wildcard", "id": 48579790, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48579790/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110842703/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:26:08.392104Z", "action": 59, "target": "The following wildcards are supported:", "id": 48579789, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48579789/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110842683/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:26:08.392077Z", "action": 59, "target": "To make sure wildcards are supported, go to <switchinline select=\"sys\"><caseinline select=\"MAC\"><menuitem>%PRODUCTNAME - Preferences - %PRODUCTNAME Calc - Calculate</menuitem></caseinline><defaultinline><menuitem>Tools - Options - %PRODUCTNAME Calc - Calculate</menuitem></defaultinline></switchinline> and check if the option <emph>Enable wildcards in formulas</emph> is selected. Note that you can use this dialog to switch to regular expressions by choosing <emph>Enable regular expressions in formulas</emph> or choose to support neither wildcards nor regular expressions.", "id": 48579788, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48579788/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110842648/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:26:08.392048Z", "action": 59, "target": "%PRODUCTNAME Calc supports either <emph>wildcards</emph> or <emph>regular expressions</emph> as arguments depending on the current application settings. By default %PRODUCTNAME Calc is set to support wildcards instead of regular expressions.", "id": 48579787, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48579787/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110842609/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:26:08.392019Z", "action": 59, "target": "Wildcards are special characters that can be used in search strings that are passed as arguments to some Calc functions. They can also be used to define search criteria in the <emph>Find & Replace</emph> dialog. The use of wildcards enables the definition of more advanced search parameters with a single search string.", "id": 48579786, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48579786/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110842576/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:26:08.391990Z", "action": 59, "target": "<variable id=\"wildcards_h1\"><link href=\"text/scalc/guide/wildcards.xhp\">Using Wildcards in Formulas</link></variable>", "id": 48579785, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48579785/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110842546/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:26:08.391962Z", "action": 59, "target": "<bookmark_value>wildcards in formulas</bookmark_value> <bookmark_value>wildcards;examples</bookmark_value>", "id": 48579784, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48579784/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110842461/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:26:08.391933Z", "action": 59, "target": "Using Wildcards in Formulas", "id": 48579783, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48579783/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110842445/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:26:08.391905Z", "action": 59, "target": "<link href=\"text/scalc/01/04090000.xhp\">External data dialog</link>", "id": 48579782, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48579782/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110842432/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:26:08.391877Z", "action": 59, "target": "Open <emph>Edit - Links</emph>. Here you can edit the link to the external data.", "id": 48579781, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48579781/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110842408/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:26:08.391848Z", "action": 59, "target": "Editing the external data", "id": 48579780, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48579780/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110842380/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:26:08.391818Z", "action": 59, "target": "<item type=\"literal\">HTML_tables</item> - designates all HTML tables in the document", "id": 48579779, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48579779/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110842370/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:26:08.391787Z", "action": 59, "target": "<item type=\"literal\">HTML_all</item> - designates the entire document", "id": 48579778, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48579778/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110842361/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:26:08.391759Z", "action": 59, "target": "If you have loaded an HTML document with the <emph>Web Page Query</emph> filter as the source document, you will find the tables in the Navigator, named continuously from \"HTML_table1\" onwards, and also two range names that have been created:", "id": 48579777, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48579777/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110842352/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:26:08.391731Z", "action": 59, "target": "Drag the desired external data from the Navigator into the target document.", "id": 48579776, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48579776/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110842324/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:26:08.391702Z", "action": 59, "target": "In the Navigator select the <emph>Insert as link</emph> drag mode <image id=\"img_id3152985\" src=\"sw/res/sc20238.png\" width=\"0.222inch\" height=\"0.222inch\"><alt id=\"alt_id3152985\">Icon</alt></image>.", "id": 48579775, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48579775/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110842306/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:26:08.391674Z", "action": 59, "target": "In the lower combo box of the Navigator select the source document. The Navigator now shows the range names and database ranges or the tables contained in the source document.", "id": 48579774, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48579774/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110842286/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:26:08.391644Z", "action": 59, "target": "In the target document open the Navigator.", "id": 48579773, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48579773/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110842253/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:26:08.391614Z", "action": 59, "target": "Open two documents: the $[officename] Calc spreadsheet in which the external data is to be inserted (target document) and the document from which the external data derives (source document).", "id": 48579772, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48579772/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110842229/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:26:08.391585Z", "action": 59, "target": "Inserting by Navigator", "id": 48579771, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48579771/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/110842204/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-24-2/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-24-2/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2024-02-01T18:26:08.391556Z", "action": 59, "target": "The import filter can create names for cell ranges on the fly. As much formatting as possible is retained, while the filter intentionally does not load any images.", "id": 48579770, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/48579770/?format=api" } ] }