Data import fails when string value starts with '='

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



1 Reply

RA Rajesh A Syncfusion Team 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.

Thanks,

Rajesh.A


Loader.
Up arrow icon