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=2849
{ "count": 142843, "next": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/changes/?format=api&page=2850", "previous": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/changes/?format=api&page=2848", "results": [ { "unit": "https://translations.documentfoundation.org/api/units/99018127/?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.052711Z", "action": 59, "target": "Click the sheet to be written as a csv file.", "id": 36428515, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428515/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99018102/?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.052685Z", "action": 59, "target": "To Export Formulas and Values as CSV Files", "id": 36428514, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428514/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99018079/?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.052659Z", "action": 59, "target": "If the csv file contains formulas, but you want to import the results of those formulas, then choose <switchinline select=\"sys\"><caseinline select=\"MAC\"><emph>%PRODUCTNAME - Preferences</emph></caseinline><defaultinline><emph>Tools - Options</emph></defaultinline></switchinline><emph> - %PRODUCTNAME Calc - View</emph> and clear the <emph>Formulas</emph> check box.", "id": 36428513, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428513/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99018057/?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.052634Z", "action": 59, "target": "You will see the <item type=\"menuitem\">Text Import</item> dialog. Click <item type=\"menuitem\">OK</item>.", "id": 36428512, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428512/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99018040/?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.052608Z", "action": 59, "target": "In the <emph>File type</emph> field, select the format \"Text CSV\". Select the file and click <emph>Open</emph>. When a file has the .csv extension, the file type is automatically recognized.", "id": 36428511, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428511/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99018001/?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.052582Z", "action": 59, "target": "Choose <emph>File - Open</emph>.", "id": 36428510, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428510/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99017978/?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.052556Z", "action": 59, "target": "To Import a CSV File", "id": 36428509, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428509/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99017962/?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.052530Z", "action": 59, "target": "Comma separated values (CSV) files are text files that contain the cell contents of a single sheet. Commas, semicolons, or other characters can be used as the field delimiters between the cells. Text strings are put in quotation marks, numbers are written without quotation marks.", "id": 36428508, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428508/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99017926/?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.052504Z", "action": 59, "target": "<variable id=\"csv_formula\"><link href=\"text/scalc/guide/csv_formula.xhp\">Importing and Exporting CSV Text Files with Formulas</link></variable>", "id": 36428507, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428507/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99017900/?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.052478Z", "action": 59, "target": "<bookmark_value>csv files;formulas</bookmark_value> <bookmark_value>formulas; importing/exporting as csv files</bookmark_value> <bookmark_value>exporting;formulas as csv files</bookmark_value> <bookmark_value>importing;csv files with formulas</bookmark_value>", "id": 36428506, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428506/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99017829/?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.052453Z", "action": 59, "target": "Importing and Exporting Text Files", "id": 36428505, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428505/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99017792/?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.052428Z", "action": 59, "target": "<link href=\"text/shared/00/00000208.xhp\">Import text files</link>", "id": 36428504, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428504/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99017754/?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.052399Z", "action": 59, "target": "<link href=\"text/shared/00/00000207.xhp\">Export text files</link>", "id": 36428503, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428503/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99017723/?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.052374Z", "action": 59, "target": "<switchinline select=\"sys\"><caseinline select=\"MAC\">%PRODUCTNAME - Preferences</caseinline><defaultinline>Tools - Options</defaultinline></switchinline> - <link href=\"text/shared/optionen/01060100.xhp\">%PRODUCTNAME Calc - View</link>", "id": 36428502, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428502/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99017680/?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.052348Z", "action": 59, "target": "Click <item type=\"menuitem\">Save</item>.", "id": 36428501, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428501/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99017633/?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.052317Z", "action": 59, "target": "Click <item type=\"menuitem\">OK</item>.", "id": 36428500, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428500/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99017537/?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.052290Z", "action": 59, "target": "In the <item type=\"menuitem\">Export of text files</item> dialog, select the options that you want.", "id": 36428499, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428499/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99017516/?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.052258Z", "action": 59, "target": "Select <item type=\"menuitem\">Edit filter settings</item>.", "id": 36428498, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428498/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99017501/?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.052233Z", "action": 59, "target": "(Optional) Set the field options for the Text CSV file.", "id": 36428497, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428497/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99017419/?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.052207Z", "action": 59, "target": "In the <emph>Filter</emph> box, select \"Text CSV\".", "id": 36428496, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428496/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99017393/?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.052180Z", "action": 59, "target": "In the <item type=\"menuitem\">File name</item> box, enter a name for the file.", "id": 36428495, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428495/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99017374/?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.052153Z", "action": 59, "target": "Choose <item type=\"menuitem\">File - Save as</item>.", "id": 36428494, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428494/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99017359/?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.052128Z", "action": 59, "target": "Only the current sheet can be exported.", "id": 36428493, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428493/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99017344/?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.052102Z", "action": 59, "target": "Open the Calc sheet that you want to save as a Text CSV file.", "id": 36428492, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428492/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99017328/?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.052075Z", "action": 59, "target": "When you export a spreadsheet to CSV format, only the data on the current sheet is saved. All other information, including formulas and formatting, is lost.", "id": 36428491, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428491/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99017311/?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.052050Z", "action": 59, "target": "To Save a Sheet as a Text CSV File", "id": 36428490, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428490/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99017293/?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.052024Z", "action": 59, "target": "Click <item type=\"menuitem\">OK</item>.", "id": 36428489, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428489/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99017278/?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.051998Z", "action": 59, "target": "Check the text delimiter box that matches the character used as text delimiter in the file. In case of an unlisted delimiter, type the character into the input box.", "id": 36428488, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428488/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99017265/?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.051973Z", "action": 59, "target": "Right-click a column in the preview to set the format or to hide the column.", "id": 36428487, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428487/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99017249/?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.051947Z", "action": 59, "target": "You can preview the layout of the imported data at the bottom of the <item type=\"menuitem\">Text Import</item> dialog.", "id": 36428486, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428486/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99017238/?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.051922Z", "action": 59, "target": "Specify the options to divide the text in the file into columns.", "id": 36428485, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428485/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99017225/?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.051896Z", "action": 59, "target": "The <item type=\"menuitem\">Text Import</item> dialog opens.", "id": 36428484, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428484/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99017217/?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.051871Z", "action": 59, "target": "Click <item type=\"menuitem\">Open</item>.", "id": 36428483, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428483/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99017208/?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.051845Z", "action": 59, "target": "If the CSV file has another extension, select the file, and then select \"Text CSV\" in the <emph>Filter</emph> box", "id": 36428482, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428482/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99017186/?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.051819Z", "action": 59, "target": "If the file has a *.csv extension, select the file.", "id": 36428481, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428481/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99017129/?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.051794Z", "action": 59, "target": "Locate the CSV file that you want to open.", "id": 36428480, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428480/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99017054/?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.051769Z", "action": 59, "target": "Choose <item type=\"menuitem\">File - Open</item>.", "id": 36428479, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428479/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99017053/?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.051742Z", "action": 59, "target": "To Open a Text CSV File in Calc", "id": 36428478, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428478/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99017046/?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.051717Z", "action": 59, "target": "If the field or cell contains a comma, the field or cell <emph>must</emph> be enclosed by single quotes (') or double quotes (\").", "id": 36428477, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428477/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99017033/?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.051689Z", "action": 59, "target": "Comma Separated Values (CSV) is a text file format that you can use to exchange data from a database or a spreadsheet between applications. Each line in a Text CSV file represents a record in the database, or a row in a spreadsheet. Each field in a database record or cell in a spreadsheet row is usually separated by a comma. However, you can use other characters to delimit a field, such as a tabulator character.", "id": 36428476, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428476/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99017009/?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.051663Z", "action": 59, "target": "<variable id=\"csv_files\"><link href=\"text/scalc/guide/csv_files.xhp\">Opening and Saving Text CSV Files</link></variable>", "id": 36428475, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428475/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99016990/?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.051635Z", "action": 59, "target": "<bookmark_value>number series import</bookmark_value><bookmark_value>data series import</bookmark_value><bookmark_value>exporting; tables as text</bookmark_value><bookmark_value>importing; tables as text</bookmark_value><bookmark_value>delimited values and files</bookmark_value><bookmark_value>comma separated files and values</bookmark_value><bookmark_value>text file import and export</bookmark_value><bookmark_value>csv files;importing and exporting</bookmark_value><bookmark_value>tables; importing/exporting as text</bookmark_value><bookmark_value>text documents; importing to spreadsheets</bookmark_value><bookmark_value>opening;text csv files</bookmark_value><bookmark_value>saving;as text csv</bookmark_value>", "id": 36428474, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428474/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99016971/?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.051609Z", "action": 59, "target": "Importing and Exporting CSV Files", "id": 36428473, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428473/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99016947/?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.051583Z", "action": 59, "target": "<link href=\"text/scalc/01/12070000.xhp\">Data - Consolidate</link>", "id": 36428472, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428472/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99016917/?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.051557Z", "action": 59, "target": "The data from the consolidation ranges and target range will be saved when you save the document. If you later open a document in which consolidation has been defined, this data will again be available.", "id": 36428471, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428471/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99016899/?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.051530Z", "action": 59, "target": "The text in the labels must be identical, so that rows or columns can be accurately matched. If the row or column label does not match any that exist in the target range, it will be appended as a new row or column.", "id": 36428470, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428470/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99016883/?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.051496Z", "action": 59, "target": "To consolidate by row labels or column labels, the label must be contained in the selected source ranges.", "id": 36428469, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428469/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99016853/?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.051469Z", "action": 59, "target": "Under <emph>Consolidate by</emph>, select either <emph>Row labels</emph> or <emph>Column labels</emph> if the cells of the source data range are not to be consolidated corresponding to the identical position of the cell in the range, but instead according to a matching row label or column label.", "id": 36428468, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428468/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99016830/?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.051444Z", "action": 59, "target": "The corresponding cell references in the target range are inserted in consecutive rows, which are automatically ordered and then hidden from view. Only the final result, based on the selected function, is displayed.", "id": 36428467, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428467/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99016811/?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.051419Z", "action": 59, "target": "Select <emph>Link to source data</emph> to insert the formulas that generate the results in the target range, rather than the actual results. If you link the data, any values modified in the source range are automatically updated in the target range.", "id": 36428466, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36428466/?format=api" } ] }