<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:phillip.szelat@gmail.com" title="Phillip Sz <phillip.szelat@gmail.com>"> <span class="fn">Phillip Sz</span></a>
</span> changed
<a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - FILEOPEN: csv autoimport not woking for values 1>x>0"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=135847">bug 135847</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;">Summary</td>
<td>FILEOPEN: csv autoimport not working for values 1>x>0
</td>
<td>FILEOPEN: csv autoimport not woking for values 1>x>0
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - FILEOPEN: csv autoimport not woking for values 1>x>0"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=135847#c3">Comment # 3</a>
on <a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - FILEOPEN: csv autoimport not woking for values 1>x>0"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=135847">bug 135847</a>
from <span class="vcard"><a class="email" href="mailto:phillip.szelat@gmail.com" title="Phillip Sz <phillip.szelat@gmail.com>"> <span class="fn">Phillip Sz</span></a>
</span></b>
<pre>(In reply to Ming Hua from <a href="show_bug.cgi?id=135847#c2">comment #2</a>)
<span class="quote">> (In reply to Phillip Sz from <a href="show_bug.cgi?id=135847#c0">comment #0</a>)
> > Additional Info:
> > Version: 6.4.4.2
> > Build-ID: 1:6.4.4-0ubuntu0.20.04.1
> > CPU-Threads: 8; BS: Linux 5.4; UI-Render: Standard; VCL: gtk3;
> > Gebietsschema: de-DE (de_DE.UTF-8); UI-Sprache: de-DE
> > Calc: threaded
> German locale uses comma (,) as the decimal point symbol instead of period
> (.), and period (.) is used as separator in long numbers, such as
> 1.000.000.000 for a (US) billion. So in your case values like 0.234 are
> intepreted as integer 0234 instead of 234/1000.
>
> To import CSV files with period as decimal point, you probably need to
> change "Decimal separator key" to period in Tool > Options > Language
> Settings > Languages, and unselect "Same as locale setting". Maybe there is
> a setting in the CSV import dialog, but my cursory search didn't find
> anything.</span >
You are right, the german local is the problem and you can even change it in
the import dialog.
However I notice some very strange behaviour. If I import the value "0.1234"
and "0.12", it will be imported as string (I think? At least I can not add to
it), even with a german local. Only if you have a number with three digits
after the dot it will be imported as number 123. Also see testcase2.csv
I would propose to make it consistent for all cases.
Thanks!</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>