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. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

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

Thread ID:





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

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 10:19 AM UTC

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.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon 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.Close Icon