<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:kontakt_1@t-online.de" title="kontakt_1@t-online.de">kontakt_1@t-online.de</a>
</span> changed
<a class="bz_bug_link
bz_status_REOPENED "
title="REOPENED - Severe Bug: Libre Office Calc: csv Import --> correct preview, wrong numbers imported"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=116258">bug 116258</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>RESOLVED
</td>
<td>REOPENED
</td>
</tr>
<tr>
<td style="text-align:right;">Resolution</td>
<td>NOTABUG
</td>
<td>---
</td>
</tr>
<tr>
<td style="text-align:right;">Ever confirmed</td>
<td>
</td>
<td>1
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_REOPENED "
title="REOPENED - Severe Bug: Libre Office Calc: csv Import --> correct preview, wrong numbers imported"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=116258#c7">Comment # 7</a>
on <a class="bz_bug_link
bz_status_REOPENED "
title="REOPENED - Severe Bug: Libre Office Calc: csv Import --> correct preview, wrong numbers imported"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=116258">bug 116258</a>
from <span class="vcard"><a class="email" href="mailto:kontakt_1@t-online.de" title="kontakt_1@t-online.de">kontakt_1@t-online.de</a>
</span></b>
<pre>(In reply to GerardF from <a href="show_bug.cgi?id=116258#c6">comment #6</a>)
<span class="quote">> In DE locale, comma is decimal separator and dot is thousand separator.
> so 0.05 is impoted as text 0.05 and 0.005 (3 digits after dot) is imported
> as 5.
>
> No bug here.
> Just choose correct locale or English US column type in import dialog.</span >
Ok. the behaviour has something to do with the DE locale.
But your answer did not explain
why 0.05 and 0.00001 gets imported correctly
(at least looking correctly, even if it is interpreted as text)
and 0.005 becomes read as a number, here as number "5"
In addition to it your answer does not explain why the preview shows the
correct numbers.
It still seems pretty buggy to me.
The behaviour is not predictable for the user.</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>