<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:jbfaure@libreoffice.org" title="Jean-Baptiste Faure <jbfaure@libreoffice.org>"> <span class="fn">Jean-Baptiste Faure</span></a>
</span> changed
<a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED WORKSFORME - CSV Import doesn't interpret Timestamp, formulas won't calculate."
href="https://bugs.documentfoundation.org/show_bug.cgi?id=112108">bug 112108</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">Status</td>
<td>UNCONFIRMED
</td>
<td>RESOLVED
</td>
</tr>
<tr>
<td style="text-align:right;">CC</td>
<td>
</td>
<td>jbfaure@libreoffice.org
</td>
</tr>
<tr>
<td style="text-align:right;">Resolution</td>
<td>---
</td>
<td>WORKSFORME
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED WORKSFORME - CSV Import doesn't interpret Timestamp, formulas won't calculate."
href="https://bugs.documentfoundation.org/show_bug.cgi?id=112108#c2">Comment # 2</a>
on <a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED WORKSFORME - CSV Import doesn't interpret Timestamp, formulas won't calculate."
href="https://bugs.documentfoundation.org/show_bug.cgi?id=112108">bug 112108</a>
from <span class="vcard"><a class="email" href="mailto:jbfaure@libreoffice.org" title="Jean-Baptiste Faure <jbfaure@libreoffice.org>"> <span class="fn">Jean-Baptiste Faure</span></a>
</span></b>
<pre>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
(<a href="https://ask.libreoffice.org">https://ask.libreoffice.org</a>).
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</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>