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

Data import fails when string value starts with '='

Thread ID:





114638 Nov 28,2013 11:37 AM UTC Dec 4,2013 12:59 PM UTC ASP.NET MVC (Classic) 1
Tags: XlsIO
Rory Kingan
Asked On November 28, 2013 11:37 AM UTC

We are exporting data to Excel using XlsIO library. The string values in data table may start with equal sign. The import fails, XlsIO thinks this is a formula and tries to parse it. 
Is there a way to turn off the formula parsing without actually modifying data and inserting apostrophe at the first position?
Please see the attached project.
Thanks for advice,

Rajesh A [Syncfusion]
Replied On December 4, 2013 12:59 PM UTC

Hi Rory Kingan,

      Thank you for using the Syncfusion products.

We are not able to reproduce the reported issue “Data import fails when string value starts with '='”. We have created the sample for your reference and attached the same in below link. Please let us know if this helps you.

Sample Link: Sample.zip

Note: we couldn’t find the Sample project in your post.

Please let us know if you have any clarification.




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