[Libreoffice-bugs] [Bug 39829] New: Error handling decimal separator in csv import

[bugzilla-daemon at freedesktop.org]

https://bugs.freedesktop.org/show_bug.cgi?id=39829

           Summary: Error handling decimal separator in csv import
           Product: LibreOffice
           Version: LibO 3.4.2 release
          Platform: Other
        OS/Version: All
            Status: NEW
          Severity: normal
          Priority: medium
         Component: Spreadsheet
        AssignedTo: libreoffice-bugs at lists.freedesktop.org
        ReportedBy: nicolas.mailhot at laposte.net


France uses the period as decimal separator. However far too many programs
output numbers using US dot convention.

It is currently not possible to specify the decimal separator to use when
opening a csv file.

The workaround so far has been to open the csv file by pretending it is a en_US
file. However, with  libreoffice 3.4.2 (fr), while the numbers show up properly
in file preview (0.992 is displayed as 0,992), they are broken on file open
(0.992 is interpreted now as 992)

Needless to say that wreaks havoc, since numbers are now off by several orders
of magnitude

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.