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
Peter
95
DateTime is obfuscated after ultraGridExcelExport
posted

I have declared a DataTable with a primary key column with System.DateTime type.

I present it in a WinGrid.This is done at runtime so I don't get an oppertunity to set things up nicely via the Grid Designer.

Now and then it is exported to Excel in the simplest possible way.

The Date is now in a very user unfriendly format counting the days since beginning of time (MS time that is)

So 2008-01-24 with a column format code of

ddMMyy

is presented as 39471.

I'm using NetAdvantage 2007.2.

If this is bug is it corrected in 2007.3?

Is there a way to better prepare the