-1.20E-003 equals -0.001196 in Open Office Calc?

Thread Starter

spinnaker

Joined Oct 29, 2009
7,837
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.

upload_2017-11-3_23-31-22.png



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

upload_2017-11-3_23-34-44.png

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.
 

Attachments

nsaspook

Joined Aug 27, 2009
6,596
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,
 

Attachments

Top