How to use the Ignore error on a text numeric cell

GemBox.Spreadsheet
1

I have a spreadsheet with columns of numbers that are defined in the datatable as text and when I export the datatable to the excel sheet I get the little icon next to each number. I would like to have excel ignore these errors because most are numbers but some have the word “Sub Total” or “Grand Total” in the same column. I saw the GemBox has a Ignore error but I couldn’t find any examples of how to use it. Can you give me an example of how to use the method?

Thank you

2

Hi Lynn,

Try this:

worksheet.IgnoredErrors.Add("A:A", IgnoredErrorTypes.NumberStoredAsText);

This will add the desired ignoring on the whole column “A”.
Let me know if you need anything else.

Regards,
Mario