I am scheduling a report to export the report data in excel to be send as an email attachment.
In my report code, I am doing this
<ExcelColumnFormat ExcelColumnWidth="Auto" DataType="Date" ExcelFormat="Short Date" ExcelAutoFitRow="True"/>
The report shows date on browser-based on my local language short date which is fine.
But when I schedule the report to send report data as excel attachment in an email to someone and when that person opens the excel from email, his local language short date is not picked.
Also in excel for date cell column the format if we check then its Custom category instead of Date category.
So How this thing can be achieved
Please sign in to leave a comment.