SpreadsheetControl.Options Property

Provides access to different options which can be specified for the document loaded into the SpreadsheetControl and for the control itself. This is a dependency property.

Namespace: DevExpress.Xpf.Spreadsheet

Assembly: DevExpress.Xpf.Spreadsheet.v24.1.dll

NuGet Package: DevExpress.Wpf.Spreadsheet

Declaration

C#

public SpreadsheetControlOptions Options { get; set; }

VB.NET

Public Property Options As SpreadsheetControlOptions

Property Value

Type	Description
SpreadsheetControlOptions	A SpreadsheetControlOptions object.

Remarks

Use the Options property as an entry point to get access to SpreadsheetControl’s options and options of the workbook loaded in the control.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the Options property.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

XAML

wpf-spreadsheet-bind-grid-control-to-worksheet-data/CS/WpfSpreadsheet_DataBinding/MainWindow.xaml#L18

<dxsps:SpreadsheetControl x:Name="spreadsheet" DocumentLoaded="spreadsheet_DocumentLoaded">
    <dxsps:SpreadsheetControl.Options>
        <dxsps:SpreadsheetControlOptions CalculationEngineType="Recursive"/>

wpf-spreadsheet-control-create-a-data-entry-form/CS/WpfDataEntryFormSample/MainWindow.xaml#L31

SelectionChanged="SpreadsheetControl1_SelectionChanged">
<dxsps:SpreadsheetControl.Options>
    <dxsps:SpreadsheetControlOptions>

wpf-spreadsheet-bind-spreadsheet-to-ms-sql-server-database/CS/WpfSpreadsheet_BindToDataSource/MainWindow.xaml#L1601

<dxsps:SpreadsheetControl x:Name="spreadsheetControl" BarManager="{Binding ElementName=barManager1, Mode=OneTime}" Ribbon="{Binding ElementName=ribbonControl1, Mode=OneTime}" Grid.Row="1" PreviewMouseLeftButtonDown="spreadsheetControl_PreviewMouseLeftButtonDown" RowsRemoved="spreadsheetControl_RowsRemoved" RowsRemoving="spreadsheetControl_RowsRemoving" >
    <dxsps:SpreadsheetControl.Options>
        <dxsps:SpreadsheetControlOptions RaiseEventsOnModificationsViaAPI="True"/>