Is it possible to format the ColumnHeader to a date format when I export to excel.
If I make a export to excel the ColumnHeader date shows as a number like 41714 and i want it to bee 16-03-2014 00:00:00
Regards Jan
1 Answer, 1 is accepted
0
Accepted
Maria Ilieva
Telerik team
answered on 20 Mar 2014, 09:59 AM
Hello Jan,
In order to apply the required functionality you could handle the "RadPivotGrid_PivotGridBiffExporting" event, access the Header Cell and apply the needed value. Similar approach is presented in the online demo below:
http://demos.telerik.com/aspnet-ajax/pivotgrid/examples/exporting/defaultcs.aspx
Regards,
Maria Ilieva
Telerik
DevCraft Q1'14 is here! Watch the online conference to see how this release solves your top-5 .NET challenges.Watch on demand now.