Skip to main content

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

SpreadsheetPrintOptions.PrintContent Property

Specifies spreadsheet content to print/display within the Print Preview.

Namespace: DevExpress.XtraSpreadsheet

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

NuGet Package: DevExpress.Spreadsheet.Core

#Declaration

[DefaultValue(SpreadsheetPrintContent.Default)]
[XtraSerializableProperty]
public SpreadsheetPrintContent PrintContent { get; set; }

#Property Value

Type Default Description
SpreadsheetPrintContent Default

An enumeration member that specifies spreadsheet content to print.

Available values:

Name Description
Default

The default value (that is EntireWorkbook).

ActiveSheets

Prints the active sheet and all selected sheets (if any). To print multiple sheets, hold Ctrl while you click sheet tabs in the control.

EntireWorkbook

Prints the entire workbook.

Selection

Prints selected cells of the active worksheet. If a chart sheet is active, it is printed completely.

#Property Paths

You can access this nested property as listed below:

Object Type Path to PrintContent
SpreadsheetControlOptions
.Print .PrintContent

#Remarks

Use the PrintContent property to specify what to print in the Spreadsheet control.

You can set this property to one of the following values:

  • Default - default value (= EntireWorkbook).

  • EntireWorkbook - prints the entire workbook.

  • ActiveSheets - prints the active sheet and all selected sheets (if any). To print multiple sheets, hold Ctrl when you click sheet tabs in the control.

  • Selection - prints selected cells of the active worksheet. If a chart sheet is active, it is printed completely.

The following example specifies that the Spreadsheet control should print only selected sheets.

spreadsheetControl1.Options.Print.PrintContent =
    DevExpress.XtraSpreadsheet.SpreadsheetPrintContent.ActiveSheets;
See Also