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=2841
{ "count": 143072, "next": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/changes/?format=api&page=2842", "previous": "https://translations.documentfoundation.org/api/components/libo_help-7-6/textscalcguide/changes/?format=api&page=2840", "results": [ { "unit": "https://translations.documentfoundation.org/api/units/99041826/?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.732929Z", "action": 59, "target": "Select the <link href=\"text/schart/01/wiz_chart_type.xhp\">Chart type</link> for the data in the chart wizard.", "id": 36429144, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36429144/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99041802/?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.732893Z", "action": 59, "target": "%PRODUCTNAME Calc automatically detects the pivot table and opens the pivot chart wizard.", "id": 36429143, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36429143/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99041791/?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.732853Z", "action": 59, "target": "Choose <emph>Insert – Chart</emph> or click in the <image id=\"img_id3157322\" src=\"cmd/sc_insertobjectchart.png\" width=\"0.2228in\" height=\"0.2228in\"><alt id=\"alt_id3159322\">Insert Chart Icon</alt></image> <emph>Insert Chart</emph> icon in the main toolbar.", "id": 36429142, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36429142/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99041767/?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.732817Z", "action": 59, "target": "Click inside the pivot table that you want to present in your chart.", "id": 36429141, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36429141/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99041755/?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.732780Z", "action": 59, "target": "To create a pivot chart proceed as below:", "id": 36429140, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36429140/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99041731/?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.732742Z", "action": 59, "target": "<variable id=\"pivotchartcreate\"><link href=\"text/scalc/guide/pivotchart_create.xhp\">Creating Pivot Charts</link></variable>", "id": 36429139, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36429139/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99041710/?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.732705Z", "action": 59, "target": "<bookmark_value>pivot chart;creating</bookmark_value>", "id": 36429138, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36429138/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99041679/?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.732669Z", "action": 59, "target": "Creating Pivot Charts", "id": 36429137, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36429137/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99041641/?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.732633Z", "action": 59, "target": "<link href=\"https://tomazvajngerl.blogspot.com/2017/03/pivot-charts-in-libreoffice-part-1.html\">Technical details on %PRODUCTNAME pivot chart implementation</link>.", "id": 36429136, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36429136/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99041598/?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.732596Z", "action": 59, "target": "Pivot charts track the changes in the data issued from a pivot table and adjust the data series and data range accordingly.", "id": 36429135, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36429135/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99041571/?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.732559Z", "action": 59, "target": "Different from static sized tables, where the number of rows and columns are constant, pivot tables can have varying dimensions, depending on the pivot table settings and its data source contents.", "id": 36429134, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36429134/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99041510/?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.732524Z", "action": 59, "target": "A pivot chart is a chart with data range and data series of a <link href=\"text/scalc/guide/datapilot.xhp\">pivot table</link>.", "id": 36429133, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36429133/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99041489/?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.732487Z", "action": 59, "target": "<variable id=\"pivotchart\"><link href=\"text/scalc/guide/pivotchart.xhp\">Pivot Chart</link></variable>", "id": 36429132, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36429132/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99041464/?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.732446Z", "action": 59, "target": "<bookmark_value>chart;pivot chart</bookmark_value> <bookmark_value>pivot table;pivot chart</bookmark_value>", "id": 36429131, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36429131/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99041420/?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.732412Z", "action": 59, "target": "Pivot Chart", "id": 36429130, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36429130/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99041402/?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.732377Z", "action": 59, "target": "<link href=\"text/shared/01/05020300.xhp\">Format - Cells - Numbers</link>", "id": 36429129, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36429129/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99041372/?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.732341Z", "action": 59, "target": "The text to number conversion can be customized in the <link href=\"text/shared/optionen/detailedcalculation.xhp\">Detailed Calculation Settings</link> option.", "id": 36429128, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36429128/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99041316/?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.732304Z", "action": 59, "target": "Changing the default text to number conversion settings", "id": 36429127, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36429127/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99041298/?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.732256Z", "action": 59, "target": "<literal>=SUM(\"1E2\";1)</literal> returns #VALUE! because SUM() and some others that iterate over number sequences explicitly check the argument type.", "id": 36429126, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36429126/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99041285/?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.732219Z", "action": 59, "target": "The formula <literal>=SUM(A1:A2)</literal>, returns 101 instead of 201 because the conversion does not occur in a range, only for single scalar values. Here, '1e2 is treated as string which is ignored for the SUM function.", "id": 36429125, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36429125/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99041247/?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.732182Z", "action": 59, "target": "In A2 enter <literal>=A1+1</literal> (which correctly results in 101).", "id": 36429124, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36429124/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99041211/?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.732147Z", "action": 59, "target": "In A1 enter the text <literal>'1e2</literal> (which is converted to the number 100 internally).", "id": 36429123, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36429123/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99041189/?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.732111Z", "action": 59, "target": "Example", "id": 36429122, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36429122/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99041162/?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.732074Z", "action": 59, "target": "Strings inside formulas are also converted, such as in =\"1999-11-22\"+42, which returns the date 42 days after November 22nd, 1999. Calculations involving localized dates as strings inside the formula return an error. For example, the localized date string \"11/22/1999\" or \"22.11.1999\" cannot be used for the automatic conversion.", "id": 36429121, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36429121/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99041146/?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.732035Z", "action": 59, "target": "The conversion is done for single scalar values, as in =A1+A2, or =\"1E2\"+1. Cell range arguments are not affected, so SUM(A1:A2) differs from A1+A2 if at least one of the two cells contain a convertible string.", "id": 36429120, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36429120/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99041126/?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.731999Z", "action": 59, "target": "The conversion is done for single scalar values only, not within ranges.", "id": 36429119, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36429119/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99041107/?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.731964Z", "action": 59, "target": "If only a time string is given, it may have an hours value of more than 24, while minutes and seconds can have a maximum value of 59.", "id": 36429118, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36429118/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99041080/?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.731927Z", "action": 59, "target": "If a date is given, it must be a valid Gregorian calendar date. In this case the optional time must be in the range 00:00 to 23:59:59.99999...", "id": 36429117, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36429117/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99041053/?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.731890Z", "action": 59, "target": "The century code CC may not be omitted. Instead of the T date and time separator, exactly one space character may be used.", "id": 36429116, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36429116/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99041018/?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.731853Z", "action": 59, "target": "hh:mm:ss.s", "id": 36429115, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36429115/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99040981/?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.731817Z", "action": 59, "target": "hh:mm:ss,s", "id": 36429114, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36429114/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99040937/?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.731780Z", "action": 59, "target": "hh:mm:ss", "id": 36429113, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36429113/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99040923/?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.731745Z", "action": 59, "target": "hh:mm", "id": 36429112, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36429112/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99040878/?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.731711Z", "action": 59, "target": "CCYY-MM-DDThh:mm:ss.s", "id": 36429111, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36429111/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99040839/?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.731676Z", "action": 59, "target": "CCYY-MM-DDThh:mm:ss,s", "id": 36429110, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36429110/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99040815/?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.731638Z", "action": 59, "target": "CCYY-MM-DDThh:mm:ss", "id": 36429109, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36429109/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99040785/?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.731602Z", "action": 59, "target": "CCYY-MM-DDThh:mm", "id": 36429108, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36429108/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99040748/?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.731566Z", "action": 59, "target": "CCYY-MM-DD", "id": 36429107, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36429107/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99040721/?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.731530Z", "action": 59, "target": "The following ISO 8601 formats are converted:", "id": 36429106, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36429106/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99040691/?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.731494Z", "action": 59, "target": "<emph>Only integer numbers including exponent are converted</emph>, and ISO 8601 dates and times in their extended formats with separators. Anything else, like fractional numbers with decimal separators or dates other than ISO 8601, is not converted, as the text string would be locale dependent. Leading and trailing blanks are ignored.", "id": 36429105, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36429105/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99040677/?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.731459Z", "action": 59, "target": "Defaults settings in Calc converts text inside cells to the respective numeric values if an unambiguous conversion is possible. If no conversion is possible, Calc returns a #VALUE! error.", "id": 36429104, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36429104/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99040639/?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.731423Z", "action": 59, "target": "<variable id=\"numbers_text\"><link href=\"text/scalc/guide/numbers_text.xhp\">Converting Text to Numbers</link></variable>", "id": 36429103, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36429103/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99040606/?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.731387Z", "action": 59, "target": "<bookmark_value>formats; text as numbers</bookmark_value> <bookmark_value>time format conversion</bookmark_value> <bookmark_value>date formats;conversion</bookmark_value> <bookmark_value>converting;text, into numbers</bookmark_value>", "id": 36429102, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36429102/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99040568/?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.731352Z", "action": 59, "target": "Converting Text to Numbers", "id": 36429101, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36429101/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99040510/?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.731316Z", "action": 59, "target": "<link href=\"text/shared/01/04050000.xhp\">Insert - Comment</link>", "id": 36429100, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36429100/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99040478/?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.731278Z", "action": 59, "target": "To display a help tip for a selected cell, use <emph>Data - Validity - Input Help</emph>.", "id": 36429099, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36429099/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99040454/?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.731241Z", "action": 59, "target": "To show or hide the comment indicator, 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 mark or unmark the <emph>Comment indicator</emph> check box.", "id": 36429098, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36429098/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99040427/?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.731204Z", "action": 59, "target": "Format each comment by specifying background color, transparency, border style, and text alignment. Choose the commands from the context menu of the comment.", "id": 36429097, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36429097/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99040410/?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.731163Z", "action": 59, "target": "Move or resize each comment as you like.", "id": 36429096, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36429096/?format=api" }, { "unit": "https://translations.documentfoundation.org/api/units/99040393/?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.731125Z", "action": 59, "target": "To edit a permanently visible comment, just click in it. If you delete the entire text of the comment, the comment itself is deleted.", "id": 36429095, "action_name": "String updated in the repository", "url": "https://translations.documentfoundation.org/api/changes/36429095/?format=api" } ] }