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

[2002 JI Open Discussion]

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