Excel Problem => string fields with leading 0

[2006 IR Open Dicussion]

By: str - gravemoon

Excel Problem => string fields with leading 0

2006-05-12 07:32

One excel export contains some strings, numbers and one field for a telephone number.

 

the content of this field sometimes starts with a leading 0

 

ie. 014392403982

 

When I let Jasper try to find the correct data type it seems to convert the data to a Double and if this is possible it assumes a numeric value.

If an exception occures the field is displayed as a string.

 

This behaviour is normally ok but the conversion to a Double value removes my leading zero :(

 

When I turn off the auto detect cell type option I encounter the problem that excel displays the content of numeric fields with a special token (is a number but stored in an text field....).

 

And now I already can see the unhappy users when they will test the new report....

 

In the .jrxml are all correct datatypes set(java.lang.String, java.lang.Double,....).

 

Is it possible to use this information or change the cell type detection in some way?

 

(An additional visible character in front of the telephone number is no usable solution)

 

Using: Jasper 1.2.0

 

thx for help

[igjyoti]

I am facing similar problem. Did you find the solution. Please let me know ASAP.

Thanks!

[igjyoti]

I just found out after my posting that there is a property IS_DETECT_CELL_TYPE which takes care of each cell type.