I have a CSV here, generated using Rstudio (front-end for R).
When I open it with Libreoffice Calc, the preview in the Text import dialog correctly displays the numbers in the last two columns. There are many numbers with 3 digits after the comma. The last column contains text as well.
When I continue the import, most (not all!) numbers have no comma anymore in Calc. It means the number -2.319 appears as -2319. When I click the cells, I can see in the value field that there really is no comma.
The file is correctly opened by gedit and Google sheets, which display all numbers correctly.
Using tab-delimited CSVs and quotes for text, using another R function to generate the CSV does not change the problem. Even copy-pasting the correctly displayed table from Google sheets into Calc does not help. My only solution is to import the CSV in Google sheets, and export it as ODS.
Any idea how to correctly display the numbers in Libreoffice Calc?