Wednesday, 28 March 2012

Downloading to Excel- Leading Zeros getting removed
In the OTN one user requested for -

"Whenever i am downloading in to excel it is cutting off leading zeros.
i mean location number is showing in report as 00012345 after downloading in to excel it is displaying only 12345.
I think excel is thinking thsi iis number so it si cutting off zeros.

my user want to see data in excel exactly how it is displaying in report."


You can try adding the below statement in the Custom CSS section of the column properties:

Refer snapshot here:

This will treat the data in the column as text while downloading to excel, hence retaining any leading or trailing spaces.

After modification you have to save the report and put it dashboard try to download excel.


Thanks to Comment