2
Answers

Import with formula issue.

Jyoti G

Jyoti G

8y
264
1
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)