wpf-devexpress-dot-xpf-dot-spreadsheet-dot-spreadsheetcontrol-1d82c01d.md
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.v25.2.dll
NuGet Package : DevExpress.Wpf.Spreadsheet
public bool ShowFormulaBar { get; set; }
Public Property ShowFormulaBar As Boolean
| Type | Description |
|---|---|
| Boolean |
true, to display the formula bar; otherwise, false.
|
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.
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.
<Grid>
<dxsps:SpreadsheetControl x:Name="spreadsheet" CommandBarStyle="Ribbon" ShowFormulaBar="True" Loaded="spreadsheet_Loaded"
DocumentSource="pack://application:,,,/WpfSpreadsheet_MessageBoxService;component/Document.xlsx"/>
<Grid>
<dxsps:SpreadsheetControl x:Name="spreadsheetControl" CommandBarStyle="Ribbon" ShowFormulaBar="True" Loaded="spreadsheetControl_Loaded"
DocumentSource="pack://application:,,,/WpfSpreadsheet_CustomCommand;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">
<Grid>
<dxsps:SpreadsheetControl x:Name="spreadsheetControl" CommandBarStyle="Ribbon" ShowFormulaBar="True" ShowStatusBar="True" />
</Grid>
See Also