SpreadsheetControl.ShowFormulaBar Property

Gets or sets a value indicating whether the integrated formula bar should be displayed for the SpreadsheetControl. This is a dependency property.

Namespace: DevExpress.Xpf.Spreadsheet

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

NuGet Package: DevExpress.Wpf.Spreadsheet

Declaration

C#

public bool ShowFormulaBar { get; set; }

VB.NET

Public Property ShowFormulaBar As Boolean

Property Value

Type	Description
Boolean	true, to display the formula bar; otherwise, false.

Remarks

The newly created WPF Spreadsheet application contains the integrated formula bar by default. Set the ShowFormulaBar property to false to hide it.

Tip

You can also use a standalone SpreadsheetFormulaBarControl by adding it directly from the Visual Studio Toolbox.

Use the following properties to control the visibility of the integrated formula bar’s elements:

• SpreadsheetControl.FormulaBarShowNameBox - shows or hides the Name Box.

  

• SpreadsheetControl.FormulaBarShowButtons - shows or hides the Cancel, Enter and Insert Function buttons.

  

• SpreadsheetControl.FormulaBarShowEditor - shows or hides the formula editor.

  

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the ShowFormulaBar 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-how-to-replace-standard-command-with-custom-command/CS/WpfSpreadsheet_CustomCommand/MainWindow.xaml#L9

<Grid>
    <dxsps:SpreadsheetControl x:Name="spreadsheetControl" CommandBarStyle="Ribbon" ShowFormulaBar="True" Loaded="spreadsheetControl_Loaded"
                              DocumentSource="pack://application:,,,/WpfSpreadsheet_CustomCommand;component/Document.xlsx"/>

wpf-spreadsheet-how-to-create-a-custom-message-box-service/CS/WpfSpreadsheet_MessageBoxService/MainWindow.xaml#L10

<Grid>
    <dxsps:SpreadsheetControl x:Name="spreadsheet" CommandBarStyle="Ribbon" ShowFormulaBar="True" Loaded="spreadsheet_Loaded"
                              DocumentSource="pack://application:,,,/WpfSpreadsheet_MessageBoxService;component/Document.xlsx"/>

wpf-spreadsheet-create-custom-progress-indicator/CS/WpfSpreadsheetProgressSample/MainWindow.xaml#L18

CommandBarStyle="Ribbon"
ShowFormulaBar="True"
ShowStatusBar="True"

wpf-spreadsheet-spell-check-cell-text/CS/MainWindow.xaml#L12

<dxsps:SpreadsheetControl x:Name="spreadsheetControl" CommandBarStyle="Ribbon"
                          ShowFormulaBar="True" ShowStatusBar="True"
                          Loaded="OnSpreadsheetControl_Loaded">

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

<Grid>
    <dxsps:SpreadsheetControl x:Name="spreadsheetControl" CommandBarStyle="Ribbon" ShowFormulaBar="True" ShowStatusBar="True" />
</Grid>