Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
125
How to delete the green triangle on the top left corner of the cell
posted

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?