SpreadsheetFormulaBarControl.SpreadsheetControl Property

Gets or sets the SpreadsheetControl to which the formula bar control is bound. This is a dependency property.

Namespace: DevExpress.Xpf.Spreadsheet

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

NuGet Package: DevExpress.Wpf.Spreadsheet

Declaration

C#

public ISpreadsheetControl SpreadsheetControl { get; set; }

VB.NET

Public Property SpreadsheetControl As ISpreadsheetControl

Property Value

Type	Description
DevExpress.XtraSpreadsheet.ISpreadsheetControl	A SpreadsheetControl with which the formula bar interacts.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the SpreadsheetControl 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-spreadsheet-to-ms-sql-server-database/CS/WpfSpreadsheet_BindToDataSource/MainWindow.xaml#L1599

</Grid.RowDefinitions>
<dxsps:SpreadsheetFormulaBarControl x:Name="formulaBar" SpreadsheetControl="{Binding ElementName=spreadsheetControl}" />
<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" >

wpf-spreadsheet-assign-custom-in-place-editors/CS/WpfSpreadsheet_CustomCellEditors/MainWindow.xaml#L1555

</Grid.RowDefinitions>
<dxsps:SpreadsheetFormulaBarControl x:Name="formulaBar" SpreadsheetControl="{Binding ElementName=spreadsheetControl}" />
<dxsps:SpreadsheetControl x:Name="spreadsheetControl" BarManager="{Binding ElementName=barManager1, Mode=OneTime}" Ribbon="{Binding ElementName=ribbonControl1, Mode=OneTime}" Grid.Row="1" />