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
NuGet Packages: DevExpress.WindowsDesktop.Wpf.Spreadsheet, DevExpress.Wpf.Spreadsheet
Declaration
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:
<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).