Date Format

Question

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 · Answer

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