WorksheetPrintOptions.ErrorsPrintMode Property
Gets or sets how errors contained in worksheet cells are printed.
Namespace: DevExpress.Spreadsheet
Assembly: DevExpress.Spreadsheet.v24.2.Core.dll
NuGet Package: DevExpress.Spreadsheet.Core
#Declaration
ErrorsPrintMode ErrorsPrintMode { get; set; }
#Property Value
Type | Description |
---|---|
Errors |
An Errors |
Available values:
Name | Description |
---|---|
Blank | Cell errors are not printed. |
Dash | Cell errors are printed as double dashes. |
Displayed | Cell errors are printed as they are displayed on a worksheet. |
NA | Cell errors are printed as #N/A. |
#Property Paths
You can access this nested property as listed below:
Object Type | Path to Errors |
---|---|
Worksheet |
|
#Remarks
Use the ErrorsPrintMode property to suppress printing cell errors.
#Example
This example demonstrates how to specify print options.
Note
The Worksheet
worksheet.ActiveView.Orientation = PageOrientation.Landscape;
// Display row and column headings.
worksheet.ActiveView.ShowHeadings = true;
worksheet.ActiveView.PaperKind = DevExpress.Drawing.Printing.DXPaperKind.A4;
// Access an object that contains print options.
WorksheetPrintOptions printOptions = worksheet.PrintOptions;
// Do not print gridlines.
printOptions.PrintGridlines = false;
// Scale the print area to fit to the width of two pages.
printOptions.FitToPage = true;
printOptions.FitToWidth = 2;
// Print in black and white.
printOptions.BlackAndWhite = true;
// Print a dash instead of a cell error message.
printOptions.ErrorsPrintMode = ErrorsPrintMode.Dash;