I am using the infragistics.excel component to set some values into the cells of excel. for instance, the value is two sets of number with a comma, like 12,34.
worksheet.Rows.Item(indexA).Cells.Item(indexB).Value = "12,34"
in this case, there is an error checking warning on the top left corner of the cell, saying " The number in this cell is formatted as text or preceded by an apostrophe"
But i want to get rid of these green triangles from the exported excel file. i can not find associated property to control this stuff. can anybody help me?
Currently, the Infragistics Excel engine doesn't have any support for controlling this. Once the warning shows up in Excel, the user can choose to turn it off, but there's no way to do this programmatically at present.
You should Submit a feature request to Infragistics
I met the same issue.