[Libreoffice-bugs] [Bug 135847] FILEOPEN: csv autoimport not consistent for 1>x>0 with german local

[bugzilla-daemon at bugs.documentfoundation.org]

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

Jean-Baptiste Faure <jbfaure at libreoffice.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |jbfaure at libreoffice.org
             Status|UNCONFIRMED                 |RESOLVED
         Resolution|---                         |WORKSFORME

--- Comment #5 from Jean-Baptiste Faure <jbfaure at libreoffice.org> ---
There is no problem to import these CSV test files. You do not need to change
the decimal separator in Tools > Options > Language Settings > Languages. What
you need to do is to select the right type of the column under Fields. In your
case the correct type is "US English" that has the dot as decimal separator.
After importing in Calc you will see all your numeric data interpreted as
numbers (right aligned) with your local decimal separator.

So closing as WorksForMe. Please feel free to reopen if you disagree.

Best regards. JBF

-- 
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/20210511/affb7e62/attachment.htm>