1
Vote

Import with formula issue.

description

Hi Support,

The spreadsheet cell has a formula to extract a piece of a string and the resulting string is a FormulaField
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.

This issue is only comes when importing xlsx file, xls works as desired.

Thanks.

file attachments

comments