Excel Export in RadPivotGrid ColumnHeader DataFormatString

2 posts, 1 answers
  1. Jan Skovhus
    Jan Skovhus avatar
    7 posts
    Member since:
    Mar 2014

    Posted 17 Mar 2014 Link to this post


    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
  2. Answer
    Maria Ilieva
    Maria Ilieva avatar
    4017 posts

    Posted 20 Mar 2014 Link to this post

    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:

    Maria Ilieva

    DevCraft Q1'14 is here! Watch the online conference to see how this release solves your top-5 .NET challenges. Watch on demand now.

  3. DevCraft R3 2016 release webinar banner
Back to Top