Date Format

[Joe Callaghan]

Using XLSIO, I want to create a cell containing a datetime which will display both the date & the time but will be formatted according to the user's locale.

If I do this;

sheet["A1"].DateTime = System.DateTime.Now;

then when I open the sheet in Excel I see only the current date (with no time) although the date is formatted appropriately for the user's locale.

How can I see both date & time without losing the date localisation?

[Yavanaarasi G]

Hi Joe,

Thank you for your interest in syncfusion products.

You have created a direct trac incident regarding this issue. Could you please follow up the incident? [#47987].

Please let me know if you have any other concerns.

Regards,
G.Yavana