[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

--- Comment #7 from Jean-Baptiste Faure <jbfaure at libreoffice.org> ---
(In reply to m.a.riosv from comment #6)
> Sorry @Jean but if I'm not wrong the PM it's not accepted and hours are
> imported without take care of it.

Oops, my mistake. You are right if we choose Date (MDY) for the first column,
but it works as expected if we choose "US English". Once imported you can
change the date format to 24 hours time cycle with "MM:DD:YYYY HH:MM:SS" format
code (choose  "12/31/1999 13:37:46" in the list). Then you get 08/11/2017
13:55:02 in A2.

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/20170831/d8e985b1/attachment.html>