WorksheetPrintOptions.ErrorsPrintMode Property
Gets or sets how errors contained in worksheet cells are printed.
Namespace: DevExpress.Spreadsheet
Assembly: DevExpress.Spreadsheet.v23.2.Core.dll
NuGet Package: DevExpress.Spreadsheet.Core
Declaration
Property Value
| Type | Description |
|---|---|
| ErrorsPrintMode | An ErrorsPrintMode enumeration member. |
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 ErrorsPrintMode |
|---|---|
| Worksheet |
|
Remarks
Use the ErrorsPrintMode property to suppress printing cell errors.
Example
This example demonstrates how to specify print options.
Note
The WorksheetPrintOptions.Draft, WorksheetPrintOptions.NumberOfCopies and WorksheetPrintOptions.CommentsPrintMode options are not supported when you print a document from the Spreadsheet. However, they are saved to a file, so you can use Microsoft® Excel® or another spreadsheet application to load and print a document.
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;