Back to Devexpress

SpreadsheetControl.Options Property

wpf-devexpress-dot-xpf-dot-spreadsheet-dot-spreadsheetcontrol-ec612eb9.md

latest3.6 KB
Original Source

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.v25.2.dll

NuGet Package : DevExpress.Wpf.Spreadsheet

Declaration

csharp
public SpreadsheetControlOptions Options { get; set; }
vb
Public Property Options As SpreadsheetControlOptions

Property Value

TypeDescription
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.

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.

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

xml
<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"/>

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

xml
<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

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

See Also

SpreadsheetControl Class

SpreadsheetControl Members

DevExpress.Xpf.Spreadsheet Namespace