https://forums.oracle.com/forums/thread.jspa?threadID=2365698&tstart=0
In the OTN one user requested for -
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."
Answer
You can try adding the below statement in the Custom CSS section of the column properties:
mso-number-format:"\@"
Refer snapshot here:
http://i53.tinypic.com/a09kqv.jpg
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.
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."
Answer
You can try adding the below statement in the Custom CSS section of the column properties:
mso-number-format:"\@"
Refer snapshot here:
http://i53.tinypic.com/a09kqv.jpg
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 a lot for this useful tip :)
ReplyDeleteThanks so much, you save my day :)
ReplyDelete