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

NuGet Packages: DevExpress.WindowsDesktop.Wpf.Spreadsheet, DevExpress.Wpf.Spreadsheet

Declaration

C#

public class SpreadsheetFormulaBarControl :
    Control,
    IFormulaBarControl,
    IFormulaBarControllerOwner

VB.NET

Public Class SpreadsheetFormulaBarControl
    Inherits Control
    Implements IFormulaBarControl,
               IFormulaBarControllerOwner

Remarks

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.

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.

XAML

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