Data is not readable if you exporting into Excel

[mkchechu]

 Hi,

We are facing problem with data which is exported into Excel sheet from jasper object.

data will displayed as " #####" in some cases and data is not able to readable by any user.

i have attached  excel sheet in which data is not properly displayed and not in proper format.

For your reference i have attached the screen shot of report and same displayed in XL sheet after exporting.

To show this issue i have marked with red circle in the attached screen shot, it will displayed as "#####" in xl sheet.

there are so many fields like this and as well data will be squashed in the field .

 

please provide your valuable suggestions to resolve this issue

 

Thanks,

 

 

Post Edited by mkchechu at 01/08/2010 10:11