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
Related API Members
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.