officefileapi-devexpress-dot-spreadsheet-dot-worksheetprintoptions-9c9a0697.md
Gets or sets how errors contained in worksheet cells are printed.
Namespace : DevExpress.Spreadsheet
Assembly : DevExpress.Spreadsheet.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
ErrorsPrintMode ErrorsPrintMode { get; set; }
Property ErrorsPrintMode As ErrorsPrintMode
| 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.
|
You can access this nested property as listed below:
| Object Type | Path to ErrorsPrintMode |
|---|---|
| Worksheet |
.PrintOptions .ErrorsPrintMode
|
Use the ErrorsPrintMode property to suppress printing cell errors.
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;
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.
Dim printOptions As WorksheetPrintOptions = 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
See Also