wpf-devexpress-dot-xpf-dot-spreadsheet-8b253b95.md
A control that displays the cell address and the contents of the current cell. Use it to enter or edit formulas and cell data.
Namespace : DevExpress.Xpf.Spreadsheet
Assembly : DevExpress.Xpf.Spreadsheet.v25.2.dll
NuGet Package : DevExpress.Wpf.Spreadsheet
[DXLicenseWpf]
public class SpreadsheetFormulaBarControl :
Control,
IFormulaBarControl,
IFormulaBarControllerOwner
<DXLicenseWpf>
Public Class SpreadsheetFormulaBarControl
Inherits Control
Implements IFormulaBarControl,
IFormulaBarControllerOwner
Use the following properties to control the visibility of the formula bar’s elements:
SpreadsheetFormulaBarControl.ShowNameBox - shows or hides the Name Box.
SpreadsheetFormulaBarControl.ShowFormulaBarButtons - shows or hides the Cancel , Enter and Insert Function buttons.
SpreadsheetFormulaBarControl.ShowFormulaBarEditor - shows or hides the formula editor.
Set the SpreadsheetFormulaBarControl.SpreadsheetControl property to the SpreadsheetControl instance to bind the formula bar to the Spreadsheet.
The following code snippets (auto-collected from DevExpress Examples) contain references to the SpreadsheetFormulaBarControl class.
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.
</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" />
</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" >
Object DispatcherObject DependencyObject Visual UIElement FrameworkElement Control SpreadsheetFormulaBarControl
See Also
SpreadsheetFormulaBarControl Members