wpf-devexpress-dot-xpf-dot-spreadsheet-dot-spreadsheetcontrol-72080acf.md
Gets or sets whether the Spreadsheet control displays the status bar. This is a dependency property.
Namespace : DevExpress.Xpf.Spreadsheet
Assembly : DevExpress.Xpf.Spreadsheet.v25.2.dll
NuGet Package : DevExpress.Wpf.Spreadsheet
public bool ShowStatusBar { get; set; }
Public Property ShowStatusBar As Boolean
| Type | Description |
|---|---|
| Boolean |
true to display the status bar; otherwise, false.
|
Set the ShowStatusBar property to true to add a status bar to a Spreadsheet application.
Use the following properties to specify the visibility of the status bar’s UI elements:
| Property | Description |
|---|---|
| SpreadsheetControl.StatusBarShowProgress | Specifies whether to display the progress bar. |
| SpreadsheetControl.StatusBarShowAverage | Specifies whether to display the average value of the selected cells. |
| SpreadsheetControl.StatusBarShowCount | Specifies whether to display the number of selected cells that contain data. |
| SpreadsheetControl.ShowNumericalCount | Specifies whether to display the number of selected cells that contain numerical data. |
| SpreadsheetControl.StatusBarShowMin | Specifies whether to display the minimum numerical value in the selected cells. |
| SpreadsheetControl.StatusBarShowMax | Specifies whether to display the maximum numerical value in the selected cells. |
| SpreadsheetControl.StatusBarShowSum | Specifies whether to display the sum of numerical values in the selected cells. |
| SpreadsheetControl.StatusBarShowZoom | Specifies whether to display the zoom level. |
| SpreadsheetControl.StatusBarShowZoomSlider | Specifies whether to display the zoom slider. |
| SpreadsheetControl.StatusBarShowEndMode | Specifies whether to display the End Mode label used to indicate that End Mode is activated. |
| SpreadsheetControl.StatusBarShowPopupMenu | Specifies whether to display the context menu. This menu gives users the option to show or hide status bar entries. |
The following example shows how to hide the MIN and MAX items on the status bar:
<dxsps:SpreadsheetControl ShowStatusBar="True"
StatusBarShowMax="False"
StatusBarShowMin="False"/>
You can also use the SpreadsheetControl.StatusBarActions property to customize the status bar (add or remove its items).
The following code snippets (auto-collected from DevExpress Examples) contain references to the ShowStatusBar 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.
wpf-spreadsheet-create-custom-progress-indicator/CS/WpfSpreadsheetProgressSample/MainWindow.xaml#L19
ShowFormulaBar="True"
ShowStatusBar="True"
UnhandledException="spreadsheetControl1_UnhandledException"/>
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