We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

Date Values are not displaying properly in the Cell (####): Negative values if year is less than 1900

Thread ID:





115701 Jan 30,2014 06:56 PM Feb 6,2014 05:19 AM ASP.NET MVC (Classic) 1
Tags: XlsIO
Pattabhi Kadari
Asked On January 30, 2014 06:56 PM

Hi Team,

Date Values are not displaying proper format if the year is less than 1900.  Could you please help us to solve the issue? 

We are using  the below API and passing the DataTable object and saving the report.
ImportDataTable(dataTable, false, startRow, 1);

PS: i have attached files.Zar (Contains input.jpg and output.xlsx) for your reference. 



Manoj Kumar G M [Syncfusion]
Replied On February 6, 2014 05:19 AM

Hi Pattabhi,

Please refer the below incident for further follow up.




This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.