<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:mikekaganski@hotmail.com" title="Mike Kaganski <mikekaganski@hotmail.com>"> <span class="fn">Mike Kaganski</span></a>
</span> changed
<a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - import .csv with floats and delimiter=pipe is wrong"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=123869">bug 123869</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;">Resolution</td>
<td>---
</td>
<td>NOTABUG
</td>
</tr>
<tr>
<td style="text-align:right;">Status</td>
<td>NEW
</td>
<td>RESOLVED
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - import .csv with floats and delimiter=pipe is wrong"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=123869#c10">Comment # 10</a>
on <a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - import .csv with floats and delimiter=pipe is wrong"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=123869">bug 123869</a>
from <span class="vcard"><a class="email" href="mailto:mikekaganski@hotmail.com" title="Mike Kaganski <mikekaganski@hotmail.com>"> <span class="fn">Mike Kaganski</span></a>
</span></b>
<pre>Oh, but it is not a bug. The "problem" is that in the third row, the "0.025" is
detected as a number 25; and that is correct, according to the "Danish" locale
chosen in the "Language" selector (see <a class="bz_bug_link
bz_status_NEW "
title="NEW - Replace number format "Language" with "Locale""
href="show_bug.cgi?id=138748">tdf#138748</a> for the terminology issue).
Danish locale uses dot as thousand separator; so the text where three decimal
digits are separated by the dot are identified as integer values, and where
different number of digits is separated by dot is correctly not detected as a
valid number. The file does *not* use Danish locale conventions, so it should
either be imported using English (USA) selected as "Language", or the column
itself should be marked as "US English".</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>