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=15291
{ "count": 766774, "next": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/changes/?format=api&page=15292", "previous": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalc01/changes/?format=api&page=15290", "results": [ { "unit": "https://translations.documentfoundation.org/api/units/99157807/?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.760914Z", "action": 59, "target": "<item type=\"input\">=CONCATENATE(\"Good \";\"Morning \";\"Mrs. \";\"Doe\")</item> returns: Good Morning Mrs. Doe.", "id": 36728519, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728519/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99157777/?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.760887Z", "action": 59, "target": "<emph>String 1[; String 2][; … ;[String 255]]</emph> are strings or references to cells containing strings.", "id": 36728518, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728518/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99157754/?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.760860Z", "action": 59, "target": "CONCATENATE(<embedvar href=\"text/scalc/01/ful_func.xhp#string255_1\" markup=\"keep\"/>)", "id": 36728517, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728517/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99157725/?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.760833Z", "action": 59, "target": "<ahelp hid=\"HID_FUNC_VERKETTEN\">Combines several text strings into one string.</ahelp>", "id": 36728516, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728516/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99157678/?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.760805Z", "action": 59, "target": "CONCATENATE", "id": 36728515, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728515/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99157628/?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.760778Z", "action": 59, "target": "<bookmark_value>CONCATENATE function</bookmark_value>", "id": 36728514, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728514/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99157596/?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.760752Z", "action": 59, "target": "The code used here does not refer to ASCII, but to the code table currently loaded.", "id": 36728513, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728513/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99157566/?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.760725Z", "action": 59, "target": "<item type=\"input\">=CODE(\"Hieronymus\")</item> returns 72, <item type=\"input\">=CODE(\"hieroglyphic\")</item> returns 104.", "id": 36728512, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728512/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99157511/?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.760698Z", "action": 59, "target": "<emph>Text</emph> is the text for which the code of the first character is to be found.", "id": 36728511, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728511/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99157471/?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.760671Z", "action": 59, "target": "CODE(\"Text\")", "id": 36728510, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728510/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99157432/?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.760641Z", "action": 59, "target": "<ahelp hid=\"HID_FUNC_CODE\">Returns a numeric code for the first character in a text string.</ahelp>", "id": 36728509, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728509/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99157382/?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.760477Z", "action": 59, "target": "CODE", "id": 36728508, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728508/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99157345/?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.760451Z", "action": 59, "target": "<bookmark_value>CODE function</bookmark_value>", "id": 36728507, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728507/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99157314/?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.760424Z", "action": 59, "target": "<input>=LEN(CLEAN(CHAR(7) & \"LibreOffice Calc\" & CHAR(8)))</input> returns 16, showing that the CLEAN function removes the non-printable Unicode U+0007 (\"BEL\") and U+0008 (\"BS\") characters at the beginning and end of the string argument. CLEAN does not remove spaces.", "id": 36728506, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728506/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99157279/?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.760397Z", "action": 59, "target": "<emph>Text</emph> refers to the text from which to remove all non-printable characters.", "id": 36728505, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728505/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99157234/?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.760371Z", "action": 59, "target": "CLEAN(\"Text\")", "id": 36728504, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728504/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99157196/?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.760339Z", "action": 59, "target": "<ahelp hid=\"HID_FUNC_SAEUBERN\">All non-printing characters are removed from the string.</ahelp>", "id": 36728503, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728503/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99157138/?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.760252Z", "action": 59, "target": "CLEAN", "id": 36728502, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728502/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99157061/?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.760225Z", "action": 59, "target": "<bookmark_value>CLEAN function</bookmark_value>", "id": 36728501, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728501/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99157026/?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.760198Z", "action": 59, "target": "=\"abc\" & CHAR(10) & \"def\" inserts a newline character into the string.", "id": 36728500, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728500/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99156982/?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.760172Z", "action": 59, "target": "<item type=\"input\">=CHAR(100)</item> returns the character d.", "id": 36728499, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728499/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99156930/?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.760145Z", "action": 59, "target": "<emph>Number</emph> is a number between 1 and 255 representing the code value for the character.", "id": 36728498, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728498/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99156894/?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.760119Z", "action": 59, "target": "CHAR(Number)", "id": 36728497, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728497/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99156862/?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.760093Z", "action": 59, "target": "<ahelp hid=\"HID_FUNC_ZEICHEN\">Converts a number into a character according to the current code table.</ahelp> The number can be a two-digit or three-digit integer number.", "id": 36728496, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728496/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99156827/?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.760066Z", "action": 59, "target": "CHAR", "id": 36728495, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728495/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99156789/?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.760039Z", "action": 59, "target": "<bookmark_value>CHAR function</bookmark_value>", "id": 36728494, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728494/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99156769/?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.760013Z", "action": 59, "target": "<link href=\"text/scalc/01/04060110.xhp#decimal\">DECIMAL</link>", "id": 36728493, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728493/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99156739/?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.759986Z", "action": 59, "target": "<item type=\"input\">=BASE(255;16;4)</item> returns 00FF in the hexadecimal system.", "id": 36728492, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728492/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99156710/?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.759959Z", "action": 59, "target": "<bookmark_value>hexadecimal system; converting to</bookmark_value>", "id": 36728491, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728491/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99156672/?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.759932Z", "action": 59, "target": "<item type=\"input\">=BASE(17;2)</item> returns 10001 in the binary system.", "id": 36728490, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728490/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99156647/?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.759903Z", "action": 59, "target": "<bookmark_value>binary system; converting to</bookmark_value>", "id": 36728489, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728489/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99156608/?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.759864Z", "action": 59, "target": "<item type=\"input\">=BASE(17;10;4)</item> returns 0017 in the decimal system.", "id": 36728488, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728488/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99156587/?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.759824Z", "action": 59, "target": "<emph>MinimumLength</emph> (optional) determines the minimum length of the character sequence that has been created. If the text is shorter than the indicated minimum length, zeros are added to the left of the string.", "id": 36728487, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728487/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99156569/?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.759786Z", "action": 59, "target": "<emph>Radix</emph> indicates the base of the numeral system. It may be any positive integer between 2 and 36.", "id": 36728486, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728486/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99156547/?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.759750Z", "action": 59, "target": "<emph>Number</emph> is the positive integer to be converted.", "id": 36728485, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728485/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99156528/?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.759713Z", "action": 59, "target": "BASE(Number; Radix [; MinimumLength])", "id": 36728484, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728484/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99156502/?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.759673Z", "action": 59, "target": "<ahelp hid=\"HID_FUNC_BASIS\">Converts a positive integer to a specified base into a text from the <link href=\"text/shared/00/00000005.xhp#number_system\">numbering system</link>.</ahelp> The digits 0-9 and the letters A-Z are used.", "id": 36728483, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728483/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99156487/?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.759626Z", "action": 59, "target": "BASE", "id": 36728482, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728482/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99156465/?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.759578Z", "action": 59, "target": "<bookmark_value>decimal system; converting to</bookmark_value>", "id": 36728481, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728481/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99156457/?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.759535Z", "action": 59, "target": "<bookmark_value>BASE function</bookmark_value>", "id": 36728480, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728480/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99156436/?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.759494Z", "action": 59, "target": "<item type=\"input\">=BAHTTEXT(12.65)</item> returns a string in Thai characters with the meaning of \"Twelve Baht and sixty five Satang\".", "id": 36728479, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728479/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99156388/?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.759448Z", "action": 59, "target": "<emph>Number</emph> is any number. \"Baht\" is appended to the integral part of the number, and \"Satang\" is appended to the decimal part of the number.", "id": 36728478, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728478/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99156335/?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.759402Z", "action": 59, "target": "BAHTTEXT(Number)", "id": 36728477, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728477/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99156317/?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.759357Z", "action": 59, "target": "Converts a number to Thai text, including the Thai currency names.", "id": 36728476, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728476/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99156294/?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.759311Z", "action": 59, "target": "BAHTTEXT", "id": 36728475, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728475/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99156271/?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.759263Z", "action": 59, "target": "<bookmark_value>BAHTTEXT function</bookmark_value>", "id": 36728474, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728474/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99156224/?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.759214Z", "action": 59, "target": "Be aware that Calc's AutoCorrect function may modify double quotation marks. AutoCorrect should not change the double quotation marks within formula cells but may change those used in non-formula cells containing text. For example, if you copy a string that is surrounded by some other form of typographical double quotation marks, such as the left double quotation mark (U+201C) and the right double quotation mark (U+201D), and then paste into a formula cell, an error may result. Open the <emph>Double Quotes</emph> area of the <menuitem>Tools - AutoCorrect Options - Localized Options</menuitem> dialog to set the characters used to automatically correct the start and end typographical double quotation marks. Uncheck the <menuitem>Replace</menuitem> toggle button to disable the feature.", "id": 36728473, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728473/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99156199/?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.759166Z", "action": 59, "target": "You can use the CHAR function or the UNICHAR function to insert a double quotation mark. For example, the formula <input>=UNICHAR(34) & \"The Catcher in the Rye\" & UNICHAR(34) & \" is a famous book by J. D. Salinger.\"</input> displays the string <literal>\"The Catcher in the Rye\" is a famous book by J. D. Salinger.</literal>", "id": 36728472, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728472/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99156187/?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.759116Z", "action": 59, "target": "You can \"escape\" the double quotation mark with an additional double quotation mark, and Calc treats the escaped double quotation mark as a literal value. For example, the formula <input>=\"My name is \"\"John Doe\"\".\"</input> outputs the string <literal>My name is \"John Doe\".</literal> Another simple example is the formula <input>=UNICODE(\"\"\"\")</input> which returns <literal>34</literal>, the decimal value of the Unicode quotation mark character (U+0022) — here the first and fourth double quotation marks indicate the beginning and end of the string, while the second double quotation mark escapes the third.", "id": 36728471, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728471/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99156151/?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.759072Z", "action": 59, "target": "To place a literal double quotation mark within a string inside a formula, two methods can be used:", "id": 36728470, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36728470/?format=api" } ] }