[Libreoffice-bugs] [Bug 112108] CSV Import doesn't interpret Timestamp, formulas won' t calculate.

[bugzilla-daemon at bugs.documentfoundation.org]

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

Jean-Baptiste Faure <jbfaure at libreoffice.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
                 CC|                            |jbfaure at libreoffice.org
         Resolution|---                         |WORKSFORME

--- Comment #2 from Jean-Baptiste Faure <jbfaure at libreoffice.org> ---
This bug tracker is not an helpdesk. Before filling a bug report you should ask
for help on the users mailing list or on the askLibo
(https://ask.libreoffice.org).

The solution:
1/in the cvs import dialog choose
- language: English (USA)
- separator: comma
- select the first column and choose Date (MDY) instead of standard
- validate
2/ in the imported sheet:
- select the first column
- right click and Format Cell...
- instead of Number choose Date under Category and the language English (USA) 
- under Format choose the one with PM at end, you get the format code MM/DD/YY
HH:MM AM/PM
- validate
3/ check

The problem in your ods file is that you imported the first column as text
(values in cells are aligned left instead of right).

See my attachment.
Closing as WorksForMe

Best regards. JBF

-- 
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/20170830/b9a3510e/attachment.html>