<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:eduardor2k@gmail.com" title="Eduardo <eduardor2k@gmail.com>"> <span class="fn">Eduardo</span></a>
</span> changed
<a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Change column format to "Date" adds ' to the beginning of field"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=108245">bug 108245</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>NEEDINFO
</td>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<td style="text-align:right;">Ever confirmed</td>
<td>1
</td>
<td>
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Change column format to "Date" adds ' to the beginning of field"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=108245#c6">Comment # 6</a>
on <a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Change column format to "Date" adds ' to the beginning of field"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=108245">bug 108245</a>
from <span class="vcard"><a class="email" href="mailto:eduardor2k@gmail.com" title="Eduardo <eduardor2k@gmail.com>"> <span class="fn">Eduardo</span></a>
</span></b>
<pre>Hi Jacques, thanks for taking time to verify this.
I've added 4 attachments.
1. CSV file you need to open
2. Import dialog (in spanish)
3. Calc after importing the file ( appearance after import )
4. Change column type dialog
5. Appearance after changing the column type
You will see the dates correctly in the cell, but if you see the formula you
will see that the dates are appended with '.
Ex: DD/MM/YYYY => 'DD/MM/YYYY
Hope you can reproduce this error.
Answering your question:
I've tried with those options checked and unchecked it doesn't change anything,
imported file results in the same output.</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>