A weird XLS bug (7E0345 --> 1.7977E+308)

By: Tuan Le - lesoft
A weird XLS bug (7E0345 --> 1.7977E+308)
2003-12-15 10:49
In our Excel report we have one String field that displays our company job code, and the Excel report returns all the job code correctly with the exception of any job code starting with 1Exxxx. For example,

in database, job code is 7E0345
in Excel output, job code is 1.7977E+308

It seems that whenever we have a job cod starting with 1E, JasperReport/Excel converts it into an expontial value.

How do we prevent that to happens? The job code is a field of type String.

Thanks,
Tuan
2002 JI Open Discussion's picture
Joined: Aug 10 2006 - 3:28am
Last seen: 16 years 7 months ago

0 Answers:

No answers yet
Feedback
randomness