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.

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

Thread ID:

Created:

Updated:

Platform:

Replies:

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

Hi,

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 ?

Thanks,

gdo
Replied On October 8, 2007 04:53 AM

Any idea ???

It's an important issue...

Thanks,
Greg

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



Hi,

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.

Regards,
S.Rajarajeswari

Rajarajeswari S [Syncfusion]
Replied On October 8, 2007 10:03 AM



Hi,

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.

Regards,
S.Rajarajeswari

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

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


CONFIRMATION

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.

;