Forums Ultimate UI for Windows 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
Jason
880
Export changing time formats in Excel
posted

We have an Infragistics grid with dates formatted 2 different ways.
 + For US we have 2011-04-26 2:30 PM
 + For UK we have 26-04-2011 7:30 PM (adjusted for timezones)

Everything works great, except when you export to Excel a UK formatted date the 7:30 turns into "19:30" in excel (a 24 hour format).  Our users are not use to seeing this time format.  It is strange that the US formatted dates export perfectly, meaning it retains the "2:20 PM" formatting.

We are using Infragistics3.Excel.v10.1and Infragistics2.Win.UltraWinGrid.v10.1.
We do not have control over what company approved Infragistics version we use.  We can just upgrade until a new version is approved for the compnay.

Does anyone know how to fix this?  It seems like a small bug that could have easily gone unnoticed.

Thanks.

  • 469350
    Offline posted

    Hi,

    How are you achieving the Format on the cells in the grid? I assume you must be using an editor if the dates are in the same column. But are you using an owner to acheive the different formats? Or a DataFilter? Or something else?

    When the grid exports to Excel, it does not export any formatting for DateTime cells. Is it possible your field is storing the dates as strings?

    Are you applying a format to the Excel column using the InitializeColumn event of the UltraGridExcelExporter?