I imported a CSV file from my Rigol into Open Office Calc. The Rigol outputs in scientific notation for some reason.

But calc is acting very strangely interpreting the numbers.

Here it is fine in A1. I get the value as expected. -0.0012.





But when I click on down to A2 where it appears to have the same scientific notation value I get -0.001196



I get similar anomalies throughout the file.

Strange that columns B & C do not exhibit that behavior.

I have included the csv in case anyone wants to take a look and see if ou get similar results.

 

It's rounding the decimal point value because of the display formatting.

Raw cvs data from your zip'd file:
-1.20000e-03,-1.60e+00,-1.52e+00,
-1.19600e-03,-1.68e+00,-1.44e+00,

 

It's rounding the decimal point value because of the display formatting.

Raw cvs data from your zip'd file:
-1.20000e-03,-1.60e+00,-1.52e+00,
-1.19600e-03,-1.68e+00,-1.44e+00,

I should have looked at that. Been a long day.
.