Export Excel Date Format Lost

1 posts, 0 answers
  1. Wang
    Wang avatar
    19 posts
    Member since:
    Jul 2011

    Posted 05 Aug 2012 Link to this post

    Hi Guys,
        At first , please let me simply introduce my project state . 

        server-side : wcf service (data service layer \ data interface layer)
        client-side   : silverlight4.0 (referred assembly: Telerik.Windows.Controls 2011.2.712.1040 \Telerik.Windows.Controls.GridView 2011.2.712.1040)  

        About GridView Export Function , please see the following main code :
       
                   SaveFileDialog dialog = new SaveFileDialog();
               dialog.DefaultExt = extension;
               dialog.Filter = String.Format("{1} files (*.{0})|*.{0}|All files (*.*)|*.*", extension, selectedItem);
               dialog.FilterIndex = 1;
               if (dialog.ShowDialog() == true)
               {
                   using (Stream stream = dialog.OpenFile())
                   {
                       GridViewExportOptions exportOptions = new GridViewExportOptions();
                       exportOptions.Format = format;
                       exportOptions.ShowColumnHeaders = true;
                       radgridview.Export(stream, exportOptions);
                   }
               }
             
             At this moment , the issue i have faced was the datetime value displayed abnormally . please see the illustration by attachment.
            Should I set the gridview some export option or else ? How to solve it ?

            please give me some advices , I am looking forward to your help .
            thanks.
Back to Top