SpreadsheetFormulaBarControl Class

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.v19.1.dll

Declaration

C#

public class SpreadsheetFormulaBarControl :
    Control,
    IFormulaBarControl,
    IFormulaBarControllerOwner

VB.NET

Public Class SpreadsheetFormulaBarControl
    Inherits Control
    Implements IFormulaBarControl,
               IFormulaBarControllerOwner

Remarks

Use the SpreadsheetFormulaBarControl.ShowNameBox property to show or hide a name box part of the control. Use the SpreadsheetFormulaBarControl.ShowFormulaBarButtons property to show or hide OK, Cancel and Function buttons. Use the SpreadsheetFormulaBarControl.ShowFormulaBarEditor property to show or hide the control’s edit box.

The SpreadsheetFormulaBarControl.SpreadsheetControl property should be set to the SpreadsheetControl instance to bind the formula bar control to the spreadsheet.

Related GitHub Examples

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.

C#

how-to-assign-custom-in-place-editors-to-worksheet-cells-wpf-spreadsheet-t385458/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" />

how-to-bind-a-spreadsheet-to-an-ms-sql-server-database-wpf-spreadsheet-t480591/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" >

Inheritance

Object

DispatcherObject

DependencyObject

Visual

UIElement

FrameworkElement

Control

SpreadsheetFormulaBarControl

Extension Methods

GetErrorOperationCommands(Position)

GetErrorOperationCommands(Int32)

GetErrorOperationCommands(Point)