windowsforms-devexpress-dot-xtraspreadsheet-e98798a0.md
Contains various options you can specify for the Spreadsheet control.
Namespace : DevExpress.XtraSpreadsheet
Assembly : DevExpress.XtraSpreadsheet.v25.2.dll
NuGet Package : DevExpress.Win.Spreadsheet
public class SpreadsheetControlOptions :
DocumentOptions
Public Class SpreadsheetControlOptions
Inherits DocumentOptions
The following members return SpreadsheetControlOptions objects:
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;
' 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;
' 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.
Object ViewStatePersisterCore BaseOptions DevExpress.XtraSpreadsheet.SpreadsheetNotificationOptions DocumentOptions SpreadsheetControlOptions
See Also