SpreadsheetControlOptions Class

Contains various options you can specify for the Spreadsheet control.

Namespace: DevExpress.XtraSpreadsheet

Assembly: DevExpress.XtraSpreadsheet.v20.1.dll

Declaration

public class SpreadsheetControlOptions :
    DocumentOptions
Public Class SpreadsheetControlOptions
    Inherits DocumentOptions

Related API Members

The following members accept/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