The requested page is not available for the requested platform. You are viewing the content for .NET Framework 4.5.2+ platform.
.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
.NET Core 3.0+
Row

WorksheetPrintOptions.ErrorsPrintMode Property

Gets or sets how errors contained in worksheet cells are printed.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v19.2.Core.dll

Declaration

ErrorsPrintMode ErrorsPrintMode { get; set; }
Property ErrorsPrintMode As ErrorsPrintMode
ErrorsPrintMode ErrorsPrintMode { get; set; }
Property ErrorsPrintMode As ErrorsPrintMode
ErrorsPrintMode ErrorsPrintMode { get; set; }
Property ErrorsPrintMode As ErrorsPrintMode

Property Value

Type Description
ErrorsPrintMode

An ErrorsPrintMode enumeration member.

Property Value

Type Description
ErrorsPrintMode

An ErrorsPrintMode enumeration member.

Property Value

Type Description
ErrorsPrintMode

An ErrorsPrintMode enumeration member.

Remarks

Use the ErrorsPrintMode property to suppress printing cell errors.

Examples

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 = System.Drawing.Printing.PaperKind.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;
See Also