Forums Ultimate UI for ASP.NET Web Forms
Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
Close
Burkhard
340
DateTime format problem
posted

I had to update a legacy application to 11.1.2178 because of your nice Firefox bug (if version is 10 or higher).

But now I run in yet another problem because my excel export from UltraWebGrid does not show DateTime in the right format anymore (it did for years now!). It shows DateTime as a number in excel. The DataType is set on the columns:

<igtbl:UltraGridColumn BaseColumnName="DateRequested"
                            DataType="System.DateTime" Key="DateRequested">
                            <Header Caption="Date requested">
                                <RowLayoutColumnInfo OriginX="4" />
                            </Header>
                            <Footer>
                                <RowLayoutColumnInfo OriginX="4" />
                            </Footer>
                        </igtbl:UltraGridColumn>

 

Can you please provide a solution, I'm really starting to loose my patience here.

 

Regards,

 

Martin

Parents
  • 340
    posted

    I managed to get it working by setting the FormatString for each cell in the CellExported event.

    Nevertheless I do not understand why I have to do that since it was working before...

     

Reply Children