<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 - Textimport gives wrong number if not at least 4 digits are given with a decimal"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=134469">bug 134469</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;">Resolution</td>
<td>---
</td>
<td>NOTABUG
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - Textimport gives wrong number if not at least 4 digits are given with a decimal"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=134469#c7">Comment # 7</a>
on <a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - Textimport gives wrong number if not at least 4 digits are given with a decimal"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=134469">bug 134469</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>This is not a bug.
As michael.meisinger.mm correctly noticed in <a href="show_bug.cgi?id=134469#c4">comment 4</a>, this is related to the
locale used for the import, and the decimal/thousand separators used in the
locale. (However, note that OS settings for separators are not used in
LibreOffice; whatever you define as separators in system, LibreOffice will use
hardcoded comma as decimal separator for German locale, and dot for thousand
separator.)
So the string "353.121" is a correct *whole number* in de-DE, while it's a
valid *floating-point number* in en-US. "353.11334" is a valid floating-point
in en-US, but it is not a valid number at all in de-DE, because the thousand
separator is not separating thousands (groups of exactly three digits).
When you use German locale for CSV import (selected in the import dialog),
"353.121" is detected as number, gets converted, and then is displayed using
the default number format. "353.11334" is not detected as number, and thus is
imported as text (and you may see the different alignment of the two cells in
the result: 353121 gets aligned right, while 353.11334 gets aligned left; also
View->Value Highlighting may help see the effect).
When you import CSV, you need to select correct settings. You may e.g. select
en-US in the dialog's "Language" selector; or you may right-click and mark
required columns as "US English" there (if you want them recognized as correct
numbers) or "Text" (if you want them to stay text).</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>