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

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