[Libreoffice-bugs] [Bug 116314] New: csv import

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 116314
           Summary: csv import
           Product: LibreOffice
           Version: 6.0.2.1 release
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: amiganer at gmx.de

Description:
Hello!

I'm importing a csv file in Libreoffice 6.0.2.1 on Windows 64Bit.
the following line, endofline with "\n"...

13864020092289,"Basigi",-78.21875,-53.59375,-89.875

the last number is imported as -89875

If I put all numbers in double quotes and tell him to import all in double
quotes as string, it is imported the right way.

The same with:

5068196160921,"Beni",-62.96875,144.65625,-33.375      (imported: -33375)
6406044422890,"Boveltibes",-7.25,49.9375,109.625      (imported: 109625)
16065459201489,"Caereda",106.8125,-65.25,105.375      (imported: 105375)

and even more....

Bye, Christian



Steps to Reproduce:
1. create csv with the told lines
2. use import "csv" of calc
3. see last number of line in calc

other numbers a re imported with the "."

Actual Results:  
Some numbers imported without the included "."

Expected Results:
all numbers having a "." imported with the "." in the right place


Reproducible: Always


User Profile Reset: No



Additional Info:


User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:56.0) Gecko/20100101
Firefox/56.0.4 Waterfox/56.0.4

-- 
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/20180309/f7559c6f/attachment.html>