Bug 125929 - after loading files in "csv-text-format" into the calc-application, formatting of date fields doesn't work correctly, because of quot-mark chars
Summary: after loading files in "csv-text-format" into the calc-application, formattin...
Status: CLOSED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.1.6.3 release
Hardware: x86-64 (AMD64) Windows (All)
: medium minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-06-14 18:15 UTC by amu91
Modified: 2019-06-14 21:05 UTC (History)
0 users

See Also:
Crash report or crash signature:


Attachments
Bug description in an odt-Document (4.22 MB, application/vnd.oasis.opendocument.text)
2019-06-14 18:19 UTC, amu91
Details
Example-file to reproduce the bug (219 bytes, text/csv)
2019-06-14 18:22 UTC, amu91
Details

Note You need to log in before you can comment on or make changes to this bug.
Description amu91 2019-06-14 18:15:02 UTC
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
Comment 1 amu91 2019-06-14 18:19:48 UTC
Created attachment 152201 [details]
Bug description in an odt-Document
Comment 2 amu91 2019-06-14 18:22:29 UTC
Created attachment 152202 [details]
Example-file to reproduce the bug
Comment 3 Eike Rathke 2019-06-14 21:05:14 UTC
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