SpreadsheetControl.ShowStatusBar Property

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.1.dll

NuGet Package: DevExpress.Wpf.Spreadsheet

Declaration

C#

public bool ShowStatusBar { get; set; }

VB.NET

Public Property ShowStatusBar As Boolean

Property Value

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

Remarks

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:

XAML

<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).

Related GitHub Examples

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.

XAML

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

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>