Jyoti G

Jyoti G

  • NA
  • 47
  • 605

Import with formula issue.

Sep 28 2016 6:40 AM
Hi Support,<br /> <br /> The spreadsheet cell has a formula to extract a piece of a string and the resulting string is a FormulaField<br /> name. I have to retrieve the actual string that is the result in Excel. (Excel shows it correctly as a string). If it happens to be 0010, the reader returns a datatable with value of 10 , it should be an actual value (0010) in my datatable.<br /> <br /> This issue is only comes when importing xlsx file, xls works as desired.<br /> <br /> Thanks.

Answers (2)