Hello,
I am using Telerik.Web.UI version 2010.2.826.35, and I have a grid with the column shown below. When I export to Excel, I would expect the formatting of the column to be "Short Date" or at least match the date format string that I've defined. However, the cells in Excel show a formatting of "Custom" with the formatting string of "m/d/yyy h:mm".
This is not the desired behavior since we have clients all over the world and the 'slash' divider means something different in different parts of the world. Instead, we would like it formatted as a Date cell and then it would pick up the local formatting of that user.
Please let me know if anything can be done.
Thank you,
Scott McNeany
I am using Telerik.Web.UI version 2010.2.826.35, and I have a grid with the column shown below. When I export to Excel, I would expect the formatting of the column to be "Short Date" or at least match the date format string that I've defined. However, the cells in Excel show a formatting of "Custom" with the formatting string of "m/d/yyy h:mm".
This is not the desired behavior since we have clients all over the world and the 'slash' divider means something different in different parts of the world. Instead, we would like it formatted as a Date cell and then it would pick up the local formatting of that user.
<
telerik:GridDateTimeColumn
DataField
=
"trans_dt"
HeaderText
=
"Purchase Date"
SortExpression
=
"trans_dt"
UniqueName
=
"PurchaseDate"
CurrentFilterFunction
=
"StartsWith"
AutoPostBackOnFilter
=
"true"
Display
=
"true"
DataFormatString
=
"{0:dd-MMM-yyyy}"
>
<
HeaderStyle
Width
=
"130px"
/>
</
telerik:GridDateTimeColumn
>
Please let me know if anything can be done.
Thank you,
Scott McNeany