Skip to main content

SpreadsheetControlOptions Class

Contains various options you can specify for the Spreadsheet control.

Namespace: DevExpress.XtraSpreadsheet

Assembly: DevExpress.XtraSpreadsheet.v24.1.dll

NuGet Package: DevExpress.Win.Spreadsheet

Declaration

public class SpreadsheetControlOptions :
    DocumentOptions

The following members return SpreadsheetControlOptions objects:

Remarks

Use the SpreadsheetControl.Options property to get access to the Spreadsheet-related settings. For instance, the SpreadsheetControlOptions.Behavior property returns an object that allows you to disable different spreadsheet operations.

// Disable the delete operation for worksheets.
spreadsheetControl.Options.Behavior.Worksheet.Delete = DocumentCapability.Disabled;

You can use the SpreadsheetControlOptions.Print options to control how the Spreadsheet control generates and previews printed documents.

The SpreadsheetControlOptions.View options specify display settings for the control.

// Hide the column and row headers in the Spreadsheet control.
spreadsheetControl.Options.View.ShowColumnHeaders = false;
spreadsheetControl.Options.View.ShowRowHeaders = false;

The inherited DocumentOptions.Import and DocumentOptions.Export properties provide access to format-specific import and export options.

Inheritance

Object
ViewStatePersisterCore
BaseOptions
DevExpress.XtraSpreadsheet.SpreadsheetNotificationOptions
DocumentOptions
SpreadsheetControlOptions
See Also