[Libreoffice-bugs] [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

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=125929

Eike Rathke <erack at redhat.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|---                         |NOTABUG
             Status|UNCONFIRMED                 |RESOLVED

--- Comment #3 from Eike Rathke <erack at redhat.com> ---
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

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190614/a83b96ce/attachment.html>