I'm working on a shapefile on QGIS 2.8.6, on Debian Jessy. Its attribute table contains two columns (real 8,6) for longitude and latitude coordinates. When working from QGIS I'm able to write normal values, i.e :
- longitude;latitude
- 1.153303;43.834765
- 1.136567;43.822574
However when I try to open the dbf file with LibreOffice Calc, strange things occur : the data type is set to "N,9,6" instead of 8,6 and about 80% of the values are rounded, i.e. :
- longitude;latitude
- 1.000000;43.000000
- 0.000000;43.000000
This phenomenon is the same when I try with OpenOffice or Microsoft Excel (with one exception : with OpenOffice I was able to get the correct values but only once).
Saame goes when I try to save the shapefile from QGIS in a CSV file ; values get "lost in translation".
This seems totally random to me, as I'm unable to explain this behaviour. I tried copying values from longitude and latitude columns in text columns in QGIS, and then opening the dbf : in this case the original longitude and latitude all appear with the correct value (however with real 9,6 and 7,6 this time!).
Does someone has an explanation ? Does this come from QGIS itself or is this a problem when reading the dbf file ?
