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

Cell format to text but change to standard ....

Thread ID:





68876 Oct 4,2007 10:03 AM UTC Feb 2,2011 11:06 PM UTC ASP.NET Web Forms (Classic) 4
Tags: XlsIO
Asked On October 4, 2007 10:03 AM UTC


I've formatted my cells to text but whenever I load a dataset with syncfusion the numbers are treated as dates and cells format are set as standard format.... how to avoid sync fusion to change that ?


Replied On October 8, 2007 08:53 AM UTC

Any idea ???

It's an important issue...


Rajarajeswari S [Syncfusion]
Replied On October 8, 2007 11:54 AM UTC


Thank you for your interest in Syncfusion products. The issue mentioned here is suspected to be a defect and we have sent this to our development team for more analysis. We will update you once we get back from our development team.

Thank you for your patience.


Rajarajeswari S [Syncfusion]
Replied On October 8, 2007 02:03 PM UTC


Thanks for using Syncfusion products,

Please create a new Direct Trac Incident with the subject "68876-Cell format to text but change to standard " so that we can provide more information regarding this issue.


Craig Boland
Replied On February 2, 2011 11:06 PM UTC

Has this been fixed? I'm having the same problem. I'm using Template Markers in XlsIO v8.2.0.18. I looked through the Release Notes of subsequent releases up to today, but didn't see any fixes related to this problem.

I must stress that this is a serious problem with the Template Markers approach. It's as if cell formatting is being ignored. I've tried formatting the entire column as Text, as well as various Excel formula/function tricks to force a plain text format. The only satisfactory way I can get the data to format correctly is to programmatically append a ' character to the value of each object property I'm binding in the ITemplateMarkersProcessor. And while this works, it means that I have to transform my data before exporting rather than binding to my existing objects. This need to transform the data first due to the possibility that some of the data may be formatted incorrectly invalidates the approach of using Template Markers. And since this problem has been reported by two other customers, with the problem still not fixed 3 years later, it calls into question the quality of all Syncfusion products.

I urge you to address this problem in the product or in the documentation. It is a significant effort to rework application code away from the Template Markers approach to a direct data approach.

"The unique advantage of this approach is that the end-user can have customized reports without modifying the source code of the report generating application." - XlsIO Template Markers Documentation


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

or the page will be automatically redirected to 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