[Libreoffice-bugs] [Bug 135847] FILEOPEN: csv autoimport not woking for values 1>x>0

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=135847

Phillip Sz <phillip.szelat at gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Summary|FILEOPEN: csv autoimport    |FILEOPEN: csv autoimport
                   |not working for values      |not woking for values 1>x>0
                   |1>x>0                       |

--- Comment #3 from Phillip Sz <phillip.szelat at gmail.com> ---
(In reply to Ming Hua from comment #2)
> (In reply to Phillip Sz from comment #0)
> > 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.

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!

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200817/7d0da133/attachment.htm>