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.

Data import fails when string value starts with '='

Thread ID:

Created:

Updated:

Platform:

Replies:

114638 Nov 28,2013 06:37 AM Dec 4,2013 07:59 AM ASP.NET MVC (Classic) 1
loading
Tags: XlsIO
Rory Kingan
Asked On November 28, 2013 06:37 AM

Hi.
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,
Rory



Rajesh A [Syncfusion]
Replied On December 4, 2013 07:59 AM

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.

Thanks,

Rajesh.A


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.

;