https://bugs.documentfoundation.org/show_bug.cgi?id=98257
Bug ID: 98257
Summary: quotation mark characters are added to date-fields,
when importing .csv file
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: minor
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:44.0) Gecko/20100101
Firefox/44.0
Build Identifier: LibreOffice 5.0.5.2
When loading files in „.csv-text-format“, „'“-Characters (single quotation
mark) are predone to „date-fields“. These become only visible in the programm,
if the format of the „date-field“ is changed. Only after extinguishing of this
Character, the „date-field“ ist shown properly formatted (For instance
yyyy-mm-dd).
Beim Laden von Files im .csv-Textformat werden den Datumsfeldern '
(Hochkomma)-Zeichen vorangestellt. Diese werden im Programm erst sichtbar, wenn
das Format des Datumsfeldes geändert wird. Erst nach Löschen dieses Zeichens
wird das Datum richtig formatiert dargestellt (z. B. yyyy-mm-dd).
Reproducible: Always
Steps to Reproduce:
1. Load example file containing date-fields
2. Change the format of date fields
3. format of date-fields remain unchanged, because they are interpreted as text
because of the "'"-characters in front of each field
Actual Results:
Format change ist not successfull.
Expected Results:
Format change is displayed correctly
[Information automatically included from LibreOffice]
Locale: de
Module: calc
[Information guessed from browser]
OS: Windows (All)
OS is 64bit: yes
Reset User Profile?No
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
