Bug 129301

Summary: 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)
Product: LibreOffice Reporter: tom
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: CLOSED NOTABUG    
Severity: normal CC: erack, oliver.brinzing
Priority: medium    
Version: 3.3.4 release   
Hardware: All   
OS: All   
Whiteboard:
Crash report or crash signature: Regression By:

Description tom 2019-12-09 23:58:22 UTC 
Description:
can NOT convert a Text field such as 09/28/2019 to a valid date type field.  All attempts leave an additional character at the beginning of the converted field.

example: 09/28/2019 converts to '09/28/2019

Mac OS

Steps to Reproduce:
1. create a Text field containing 09/28/2019
2. Format this field to a date
3. Date field is not valid, contains extra character

Actual Results:
'09/28/2019

Expected Results:
09/28/2019


Reproducible: Always


User Profile Reset: No



Additional Info:
Comment 1 Oliver Brinzing 2019-12-10 17:34:02 UTC 
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/
Comment 2 Dwayne Allen 2019-12-11 03:19:24 UTC Comment hidden (spam)