Description: When loading files in „.csv-text-format“ into the calc-application, unwanted „ ' “-Characters (single quotation marks) are prepositioned to „date-fields“ by the program. These become only visible to the user in the program, if the format of the „date-field“ is changed. Only after extinguishing of theese unwanted Characters, the „date-field“ is shown properly formatted in the way, the user has selected, for instance yyyy-mm-dd. Steps to Reproduce: 1. Import an example-file containing date fields in csv-format into spreadsheet application (calc) 2. Mark some date-fields to change their format 3. Change the format of date, for instance from dd.mm.yyyy to yyyy-mm-dd 4. See, that the change has no effect 5. See the selected field in the edit-box: there is a quotation mark at the beginning of the field 6. Remove this quotation mark character 7. See, that now the field is formatted in the way, the user wanted Actual Results: the program inserts unwanted quotation-mark-characters, which prevent the fields to bee formatted correctly Expected Results: the program should not do this, as it did in very old versions, for instance 5.0.5.2 Reproducible: Always User Profile Reset: Yes Additional Info: Version: 6.1.6.3 (x64) Build-ID: 5896ab1714085361c45cf540f76f60673dd96a72 CPU-Threads: 16; BS: Windows 10.0; UI-Render: Standard; Gebietsschema: de-CH (de_CH); Calc: group threaded
Created attachment 152201 [details] Bug description in an odt-Document
Created attachment 152202 [details] Example-file to reproduce the bug
Not a bug. The dates were imported as text content, not as numeric date content, thus changing the number format has no effect. In the import dialog either activate Detect special numbers ("Erweiterte Zahlenerkennung"), or explicitly set the column type to Date (DMY). The ' apostrophe (single quote) in the Input Line preceding the content indicates that content could be interpreted as numeric if the cell content wasn't of type text. See also https://wiki.documentfoundation.org/Faq/Calc/How_to_convert_number_text_to_numeric_data