[Expand]General Information
[Expand]WinForms Controls
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Collapse]WPF Controls
 [Expand]What's Installed
 [Expand].NET Core 3 Support
 [Expand]Common Concepts
 [Expand]MVVM Framework
 [Collapse]Controls and Libraries
  [Expand]Data Grid
  [Expand]Ribbon, Bars and Menu
  [Expand]Charts Suite
  [Expand]Pivot Grid
    Product Structure
   [Collapse]Getting Started
     Lesson 1 - Create a Simple Spreadsheet
     Lesson 2 - Create Separate Ribbon Pages for the Spreadsheet
     Lesson 3 - Create an Application using the Instant Layout Assistant (for VS 2015 and earlier)
     Lesson 4 - Customize the Integrated Ribbon UI for the Spreadsheet
     Lesson 5 - Customize the Spreadsheet Status Bar
   [Expand]Spreadsheet Document
    Supported Formats
   [Expand]Cell Basics
    Defined Names
    Data Binding
    Data Validation
   [Expand]Data Presentation
   [Expand]Pivot Table Overview
   [Expand]Charts and Graphics
    Operation Restrictions
    Find and Replace
   [Expand]Mail Merge
   [Expand]Visual Elements
    Themes and Templates
  [Expand]Rich Text Editor
  [Expand]Tree List
  [Expand]Gauge Controls
  [Expand]Map Control
  [Expand]Layout Management
  [Expand]Windows Modern UI
  [Expand]Data Editors
  [Expand]Navigation Controls
  [Expand]Spell Checker
  [Expand]Property Grid
  [Expand]PDF Viewer
  [Expand]TreeMap Control
  [Expand]Gantt Control
  [Expand]Diagram Control
  [Expand]Windows and Utility Controls
   Dialogs, Notifications and Panels
  [Expand]Scheduler (legacy)
 [Expand]Scaffolding Wizard
  Redistribution and Deployment
  Get More Help
 [Expand]API Reference
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Office File API
[Expand]Report and Dashboard Server
[Expand]eXpressApp Framework
[Expand]eXpress Persistent Objects
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation
View this topic on docs.devexpress.com (Learn more)

Lesson 5 - Customize the Spreadsheet Status Bar

This topic describes how to customize the Spreadsheet control's status bar.

Expanded Show or Hide Predefined Items

Use the following properties to control the visibility of the status bar's 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.StatusBarShowNumericalCount 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 current zoom level.
SpreadsheetControl.StatusBarShowZoomSlider Specifies whether to display the zoom slider that allows users to zoom the worksheet.
SpreadsheetControl.StatusBarShowPopupMenu Specifies whether to display the context menu that allows users to show or hide status bar entries.

The following example shows how to hide the MIN and MAX items on the status bar:

Expanded Use Bar Customization Actions

Add the InsertAction (see InsertAction), RemoveAction (see RemoveAction) or UpdateAction (see UpdateAction) customization actions to the SpreadsheetControl.StatusBarActions collection to add or remove the status bar's items. An action's ElementName property specifies a modified element's name. The DevExpress.Xpf.Spreadsheet.DefaultBarItemNames class fields define the available element names.

The status bar's element names The Customize Status Bar context menu's element names
DefaultBarItemNames.StatusBarControl</br>DefaultBarItemNames.StatusBarItem_Average</br>DefaultBarItemNames.StatusBarItem_Count</br>DefaultBarItemNames.StatusBarItem_NumericalCount</br>DefaultBarItemNames.StatusBarItem_Min</br>DefaultBarItemNames.StatusBarItem_Max</br> DefaultBarItemNames.StatusBarItem_Sum</br>DefaultBarItemNames.StatusBarItem_Zoom</br>DefaultBarItemNames.StatusBarItem_ZoomSlider DefaultBarItemNames.StatusBar_PopupMenu</br>DefaultBarItemNames.StatusBarItem_PopupMenu_Header</br>DefaultBarItemNames.StatusBarItem_PopupMenu_Average</br>DefaultBarItemNames.StatusBarItem_PopupMenu_Count</br>DefaultBarItemNames.StatusBarItem_PopupMenu_NumericalCount</br>DefaultBarItemNames.StatusBarItem_PopupMenu_Min</br>DefaultBarItemNames.StatusBarItem_PopupMenu_Max</br>DefaultBarItemNames.StatusBarItem_PopupMenu_Sum</br>DefaultBarItemNames.StatusBarItem_PopupMenu_Zoom</br>DefaultBarItemNames.StatusBarItem_PopupMenu_ZoomSlider

The example below shows how to add a custom File Name item to the status bar and remove the predefined Min and Max items.

Is this topic helpful?​​​​​​​