CSV file import problems

[Shinigami]

Hi,
I use Ubuntu with LibreOffice (Version: 5.3.1.2; Build ID: 1:5.3.1-0ubuntu2).
I try to open csv file. Format:

Gręžinys;Mėginys;Nuo;Iki;63;31.5;16;8;4;2;1;0.5;0.25;0.125;0.063;0.01;<0.01;Svoris;Filtr. Koef.
1;1;0.1;3;0;0;6;40;63;2.7;5.3;14.8;35.3;30.8;8.3;1.1;1.7;1695;
1;2;3;6;0;0;0;0;17;0.3;1;2.7;26.4;47.2;16.9;2.4;3.1;1490;
1;3;6;9;0;0;0;0;1;0;0.1;1.8;12.9;61.2;20.1;2.9;1;1815;

Here are link to csv file, import window and calc images
https://drive.google.com/drive/folders/0B56OBQHSwOhUT1lmMTk3TTVZcWM?usp=sharing

After double clicking on csv file opens Text import window. In here all data looks fine. I press OK button and LibbreOffice Calc window opens, but here are two problems in first row. Number 0.125 becomes number 125, and number 0.063 becomes number 63.
All other numbers are okay. How can I fix it?

[gabix]

Set US English as the column type.

However, I see no such problem even with the Standard type.

[erAck]

May happen in this case if the standard locale uses a ‘.’ dot as group separator, not as decimal separator.

[robleyd]

On the text import dialog, tick Detect Special Numbers. That seemed to work for me when I imported your csv file.

Some of the entries under Græþinys have an underscore in them; they import as text.

If this answer helped you, please accept it by clicking the check mark to the left and, karma permitting, upvote it. If this resolves your problem, close the question, that will help other people with the same question.

[gabix]

It should be Gręžinys, the text encoding being ISO Latin-13.

[Shinigami]

Thanks.
Detect Special Numbers did not worked for me, but setting column type to US English worked.