CODEWITHSUNDEEP
javaexcelioapache-poi
John
John

Reputation: 87

Data outputting to excel causes numbers to change

i'm writing a program that calculates moments from a shape and writes the results to an excel spreadsheet, using the apache poi package

Anyway, i'm getting the correct figures its just when i write them to the spreadsheet, the figures mysteriously change, for example the program will produce a result like 8.092238721555691E-4, but in the spreadsheet its stored as 0.000809224....

To deepen the mystery some the figures are being stored correctly...

Has anyone any experience of something similar, or any suggestions?

Upvotes: 0

Views: 43

Answers (1)

Girish
Girish

Reputation: 1717

Both are same: you can read 8.092238721555691E-4 as 8.092238721555691 * (10^-4)

Upvotes: 1

Related Questions