[Libreoffice-bugs] [Bug 129301] Converting a Text field to a date, the field is of type date, but it's not valid due to a ' character at the beginning of the field . (extra ' character at the beginning)

[bugzilla-daemon at bugs.documentfoundation.org]

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

Oliver Brinzing <oliver.brinzing at gmx.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 OS|Mac OS X (All)              |All
             Status|UNCONFIRMED                 |RESOLVED
                 CC|                            |erack at redhat.com,
                   |                            |oliver.brinzing at gmx.de
         Resolution|---                         |NOTABUG
           Hardware|x86-64 (AMD64)              |All

--- Comment #1 from Oliver Brinzing <oliver.brinzing at gmx.de> ---
This is not a bug, but the expected behaviour.

You need to convert the values after setting date format e.g. via Menu
"Data/Text to Columns..."

please have a look at:
https://ask.libreoffice.org/en/question/87210/calc-conversion-text-to-date/

-- 
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/20191210/6890131d/attachment.htm>