[]
Specifies how cell error values are printed on a worksheet.
Use this enum with PrintErrors to control whether printed output shows error values as they appear, suppresses them, or replaces them with an alternate display. It applies when printing a worksheet that contains formula errors such as division by zero or unavailable values.
public enum PrintErrors
Public Enum PrintErrors
worksheet.Range["A1"].Formula = "=1/0";
worksheet.PageSetup.PrintErrors = PrintErrors.Dash;
| Name | Description |
|---|---|
| Blank | Print errors are blank. |
| Dash | Print errors are displayed as dashes. |
| Displayed | All print errors are displayed. |
| NA | Print errors are displayed as not available. |