Read and complete the full issue template

Do not randomly delete sections. They are here for a reason.

Do you want to request a feature or report a bug?

• Bug
• Feature
• Question

Did you test against the latest CI build?

• Yes
• No

If you answered No, please test with the latest development build first.

Version of ClosedXML

0.96.0

What is the current behavior?

when opening the attached excel, created with the sample code excel displays the warning "The number in this cell is formatted as text..."

What is the expected behavior or new feature?

supporting the built in feature of excel "addIgnoredErrors(...)" would solve the issue

Is this a regression from the previous version?

No

Reproducibility

This is an important section. Read it carefully. Failure to do so will cause a 'RTFM' comment.

Without a code sample, it is unlikely that your issue will get attention. Don't be lazy. Do the effort and assist the developers to reproduce your problem. Code samples should be minimal complete and verifiable. Sample spreadsheets should be attached whenever applicable. Remove sensitive information.

Code to reproduce problem:

public void Main()
{
    // Code standards:
    // - Fully runnable. I should be able to copy and paste this code into a 
    //   console application and run it without having to edit it much.
    // - Declare all your variables (this follows from the previous point)
    // - The code should be a minimal code sample to illustrate issue. The code 
    //   samples on the wiki are good examples of the terseness that I want. Don't
    //   post your full application.
    var wb = new ClosedXML.Excel.XLWorkbook();
    var ws = wb.AddWorksheet("Table1");
    ws.Row(1).Cell(1).SetValue("1234");

    wb.SaveAs($"C:/TEMP/TestClosedXml_NumberAsText.xlsx");
}

• I attached a sample spreadsheet. (You can drag files on to this issue)
  TestClosedXml_NumberAsText.xlsx