Data import fails when string value starts with '='

[Rory Kingan]

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]

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