Description: I use a JavaScript script to save Data in a csv. The Data is arranged this way: x;y;z;name 0;0;0; Black [...] 0.0577;0.0837;0.117; Swamp The last digit of the 'swamp' colors z-value is cut off by my script due to being 0. When opening the file with calc, the import dialogue shows the number correctly, the file does not. It shows 117. Steps to Reproduce: 1. Create File with Data (at least several rows) 2. Open file with Data 3. Actual Results: 117 Expected Results: 0.117 Reproducible: Always User Profile Reset: No OpenGL enabled: Yes Additional Info: When the entry is 0.1170, the error does not occur.
It is not a bug. Your locale uses dot as thousand separator, and hence, when it matches the thousand position, the string "0.117" is interpreted as "zero thousand one hundred seventeen". When its position is not the correct thousand position (on 5th position from right, as in "0.0577"), it is not possible to convert such a string into a number, and the string is kept as string. You need to either define the correct locale for the data, or to define en-US for the specific columns (if you use scripting, you would need to define filter settings, as described at [1]). [1] https://help.libreoffice.org/latest/en-US/text/shared/guide/csv_params.html