Changes
Translation components API.
See the Weblate's Web API documentation for detailed description of the API.
GET /api/components/libo_help-7-6/textscalcguide/changes/?format=api&page=2831
{ "count": 143072, "next": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/changes/?format=api&page=2832", "previous": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/changes/?format=api&page=2830", "results": [ { "unit": "https://translations.documentfoundation.org/api/units/99058053/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/am/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:34.187134Z", "action": 59, "target": "<bookmark_value>ማቦዘኛ: ራሱ በራሱ መቀየሪያ</bookmark_value> <bookmark_value>ሰንጠረዦች: ማቦዘኛ ራሱ በራሱ መቀየሪያ በ </bookmark_value> <bookmark_value>በራሱ ማስገቢያ ተግባር ማብሪያ/ማጥፊያ</bookmark_value> <bookmark_value>ጽሁፍ በ ክፍሎች: በራሱ ማስገቢያ ተግባር</bookmark_value> <bookmark_value>ክፍሎች: በራሱ ማስገቢያ ተግባር የ ጽሁፍ</bookmark_value> <bookmark_value>ማስገቢያ ድጋፍ በ ሰንጠረዦች</bookmark_value> <bookmark_value>መቀየሪያ: ማስገቢያ በ ክፍሎች ውስጥ</bookmark_value> <bookmark_value>በራሱ አራሚ ተግባር: የ ክፍል ይዞታዎች</bookmark_value> <bookmark_value>ክፍል ማስገቢያ: በራሱ ማስገቢያ ተግባር</bookmark_value> <bookmark_value>የ ታችኛው ጉዳይ ፊደሎች: በራሱ ማስገቢያ ተግባር (በ ክፍሎች ውስጥ)</bookmark_value> <bookmark_value>አቢይ ፊደል: በራሱ ማስገቢያ ተግባር (በ ክፍሎች ውስጥ)</bookmark_value> <bookmark_value>የ ቀን አቀራረብ: ማስወገጃ መቀየሪያ ወደ</bookmark_value> <bookmark_value>ቁጥር መጨረሻ ማብሪያ/ማጥፊያ</bookmark_value> <bookmark_value>ጽሁፍ መጨረሻ ማብሪያ/ማጥፊያ</bookmark_value> <bookmark_value>ቃላት መጨረሻ ማብሪያ/ማጥፊያ</bookmark_value>", "id": 36437682, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36437682/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99058047/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/am/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:34.187094Z", "action": 59, "target": "ራሱ በራሱ መቀየሪያ ማቦዘኛ", "id": 36437681, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36437681/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99058041/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/am/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:34.187053Z", "action": 59, "target": "", "id": 36437680, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36437680/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99058035/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/am/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:34.187013Z", "action": 59, "target": "", "id": 36437679, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36437679/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99058029/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/am/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:34.186967Z", "action": 59, "target": "", "id": 36437678, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36437678/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99058009/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/am/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:34.186923Z", "action": 59, "target": "ለምሳሌ በ ሰንጠረዥ ውስጥ ሀረግ መጠቀም ይችላሉ <item type=\"literal\">'አምድ አንድ'</item> በ መቀመሪያ የ ክፍል መጠን እንዲያመሳክር <item type=\"literal\">B3</item> ወደ <item type=\"literal\">B5</item> ወይንም <item type=\"literal\">'አምድ ሁለት'</item> ለ ክፍል መጠን <item type=\"literal\">C2</item> ወደ <item type=\"literal\">C5</item> እንዲሁም ይችላሉ <item type=\"literal\">'ረድፍ አንድ'</item> ለ ክፍል መጠን <item type=\"literal\">B3</item> ወደ <item type=\"literal\">D3</item> ወይንም <item type=\"literal\">'ረድፍ ሁለት'</item> ለ ክፍል መጠን <item type=\"literal\">B4</item> ለ <item type=\"literal\">D4</item>. የ መቀመሪያ ውጤት የ ክፍሉን ስም የሚጠቀመው ለምሳሌ <item type=\"literal\">ድምር('አምድ አንድ')</item>, 600 ነው", "id": 36437677, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36437677/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99057999/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/am/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:34.186883Z", "action": 59, "target": "<image id=\"img_id3154942\" src=\"media/helpimg/names_as_addressing.png\" width=\"5.408cm\" height=\"2.212cm\" localize=\"true\"><alt id=\"alt_id3154942\">ለምሳሌ ሰንጠረዥ</alt></image>", "id": 36437676, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36437676/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99057986/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/am/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:34.186843Z", "action": 59, "target": "እርስዎ ጽሁፍ የያዙ ክፍሎች መጠቀም ይችላሉ ለ ማመሳከር ወደ ረድፎች ወይንም ወደ አምዶች ክፍሎቹን የያዘውን", "id": 36437675, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36437675/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99057980/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/am/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:34.186802Z", "action": 59, "target": "<variable id=\"address_auto\"><link href=\"text/scalc/guide/address_auto.xhp\">ስሞች እና አድራሻዎችን ማስታወሻ</link></variable>", "id": 36437674, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36437674/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99057949/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/am/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:34.186757Z", "action": 59, "target": "<bookmark_value>ራሱ በራሱ መድረሻ ሰንጠረዥ ውስጥ</bookmark_value> <bookmark_value>ተፈጥሯዊ ቋንቋ መድረሻ</bookmark_value> <bookmark_value>መቀመሪያ: ረድፍ/አምድ ምልክቶች በ መጠቀም</bookmark_value> <bookmark_value>ጽሁፍ በ ክፍሎች ውስጥ: መድረሻ</bookmark_value> <bookmark_value>መድረሻ: ራሱ በራሱ</bookmark_value> <bookmark_value>ስም ማስታወሻ ማብሪያ/ማጥፊያ</bookmark_value> <bookmark_value>የ ረድፍ ራስጌዎች: መቀመሪያ በ መጠቀም</bookmark_value> <bookmark_value>የ አምድ ራስጌዎች: መቀመሪያ በ መጠቀም</bookmark_value> <bookmark_value>አምዶች: ምልክቶችን ራሱ በራሱ ማግኛ</bookmark_value> <bookmark_value>ረድፎች: ራሱ በራሱ ማግኛ</bookmark_value> <bookmark_value>ማስታወሻ: አምድ እና ረድፍ ምልክቶች</bookmark_value>", "id": 36437673, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36437673/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99057942/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/am/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:34.186672Z", "action": 59, "target": "ስሞች እና አድራሻዎችን ማስታወሻ", "id": 36437672, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36437672/?format=api" }, { "unit": null, "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.880274Z", "action": 0, "target": "", "id": 36429633, "action_name": "Resource updated", "url": "https://translations.documentfoundation.org/api/changes/36429633/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99056836/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.880239Z", "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": 36429632, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36429632/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99056810/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.880200Z", "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": 36429631, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36429631/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99056797/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.880157Z", "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": 36429630, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36429630/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99056763/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.880115Z", "action": 59, "target": "<variable id=\"year2000\"><link href=\"text/scalc/guide/year2000.xhp\">19xx/20xx Years</link></variable>", "id": 36429629, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36429629/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99056746/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.880073Z", "action": 59, "target": "<bookmark_value>years; 2-digits</bookmark_value><bookmark_value>dates; 19xx/20xx</bookmark_value>", "id": 36429628, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36429628/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99056727/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.880031Z", "action": 59, "target": "19xx/20xx Years", "id": 36429627, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36429627/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99056711/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.879989Z", "action": 59, "target": "Wildcard comparisons are <emph>not</emph> case sensitive, hence \"A?\" will match both \"A1\" and \"a1\".", "id": 36429626, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36429626/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99056692/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.879947Z", "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": 36429625, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36429625/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99056663/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.879905Z", "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": 36429624, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36429624/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99056636/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.879862Z", "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": 36429623, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36429623/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99056611/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.879819Z", "action": 59, "target": "Examples of Wildcards in Formulas", "id": 36429622, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36429622/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99056562/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.879775Z", "action": 59, "target": "<emph>Other functions:</emph> MATCH and SEARCH.", "id": 36429621, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36429621/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99056557/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.879728Z", "action": 59, "target": "<emph>Lookup functions:</emph> HLOOKUP, LOOKUP and VLOOKUP.", "id": 36429620, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36429620/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99056546/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.879681Z", "action": 59, "target": "<emph>Conditional functions:</emph> AVERAGEIF, AVERAGEIFS, COUNTIF, COUNTIFS, MAXIFS, MINIFS, SUMIF and SUMIFS.", "id": 36429619, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36429619/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99056531/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.879635Z", "action": 59, "target": "<emph>Database functions:</emph> DAVERAGE, DCOUNT, DCOUNTA, DGET, DMAX, DMIN, DPRODUCT, DSTDEV, DSTDEVP, DSUM, DVAR and DVARP.", "id": 36429618, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36429618/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99056515/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.879589Z", "action": 59, "target": "Wildcards are supported by the following spreadsheet functions:", "id": 36429617, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36429617/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99056495/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.879544Z", "action": 59, "target": "Supported Spreadsheet Functions", "id": 36429616, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36429616/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99056472/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.879499Z", "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": 36429615, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36429615/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99056456/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.879456Z", "action": 59, "target": "For example, the search string \"why~?\" matches “why?” but will not match \"whys\" nor \"why~s\".", "id": 36429614, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36429614/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99056427/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.879414Z", "action": 59, "target": "Escapes the special meaning of a question mark, asterisk, or tilde character that follows immediately after the tilde character.", "id": 36429613, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36429613/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99056418/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.879371Z", "action": 59, "target": "<emph>~ (tilde)</emph>", "id": 36429612, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36429612/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99056386/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.879324Z", "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": 36429611, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36429611/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99056356/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.879277Z", "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": 36429610, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36429610/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99056334/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.879233Z", "action": 59, "target": "<emph>* (asterisk)</emph>", "id": 36429609, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36429609/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99056296/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.879187Z", "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": 36429608, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36429608/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99056268/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.879135Z", "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": 36429607, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36429607/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99056230/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.879091Z", "action": 59, "target": "<emph>? (question mark)</emph>", "id": 36429606, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36429606/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99056206/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.879046Z", "action": 59, "target": "Description", "id": 36429605, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36429605/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99056172/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.879001Z", "action": 59, "target": "Wildcard", "id": 36429604, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36429604/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99056114/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.878958Z", "action": 59, "target": "The following wildcards are supported:", "id": 36429603, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36429603/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99056068/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.878912Z", "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": 36429602, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36429602/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99056041/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.878868Z", "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": 36429601, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36429601/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99056007/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.878824Z", "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": 36429600, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36429600/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99055988/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.878779Z", "action": 59, "target": "<variable id=\"wildcards_h1\"><link href=\"text/scalc/guide/wildcards.xhp\">Using Wildcards in Formulas</link></variable>", "id": 36429599, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36429599/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99055976/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.878732Z", "action": 59, "target": "<bookmark_value>wildcards in formulas</bookmark_value> <bookmark_value>wildcards;examples</bookmark_value>", "id": 36429598, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36429598/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99055932/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.878679Z", "action": 59, "target": "Using Wildcards in Formulas", "id": 36429597, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36429597/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99055892/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.878633Z", "action": 59, "target": "<link href=\"text/scalc/01/04090000.xhp\">External data dialog</link>", "id": 36429596, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36429596/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99055865/?format=api", "component": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/?format=api", "translation": "https://translations.documentfoundation.org/api/translations/libo_help-7-6/textscalcguide/en/?format=api", "user": null, "author": null, "timestamp": "2023-09-11T22:44:05.878588Z", "action": 59, "target": "Open <emph>Edit - Links</emph>. Here you can edit the link to the external data.", "id": 36429595, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36429595/?format=api" } ] }