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

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. To hide it, set the ShowFormulaBar property to false.

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.

C#

how-to-customize-the-integrated-ribbon-for-the-wpf-spreadsheet-t511399/CS/WpfSpreadsheet_RibbonCustomization/MainWindow.xaml#L12

<Grid>
    <dxsps:SpreadsheetControl CommandBarStyle="Ribbon" ShowFormulaBar="True" DocumentSource="pack://application:,,,/WpfSpreadsheet_RibbonCustomization;component/Document.xlsx">
        <dxsps:SpreadsheetControl.RibbonActions>

udf-custom-function-a-sample-custom-function-that-returns-an-array-t538770/CS/CustomFunctionReturningArrayExample/MainWindow.xaml#L11

<dxsps:SpreadsheetControl x:Name="spreadsheet" CommandBarStyle="Ribbon" ShowFormulaBar="True" Loaded="SpreadsheetControl_Loaded" />

wpf-spreadsheet-how-to-perform-a-mail-merge-t618180/CS/WpfSpreadsheetMailMerge/MainWindow.xaml#L13

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

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"/>