BuyLog In
DevExtreme
All docs
V 19.1
24.2
The page you are viewing does not exist in version 24.2.
24.1
The page you are viewing does not exist in version 24.1.
23.2
The page you are viewing does not exist in version 23.2.
23.1
The page you are viewing does not exist in version 23.1.
22.2
The page you are viewing does not exist in version 22.2.
22.1
The page you are viewing does not exist in version 22.1.
21.2
The page you are viewing does not exist in version 21.2.
21.1
The page you are viewing does not exist in version 21.1.
20.2
The page you are viewing does not exist in version 20.2.
20.1
The page you are viewing does not exist in version 20.1.
19.2
19.1
18.2
18.1
17.2
All docs
V19.1

General Information

.NET Subscription

What's Included
DevExpress Installation
DevExpress Code Examples

Common Tools

Project Converter
Assembly Deployment Tool
Localization Service

Quality Assurance and Productivity

CodeRush for Visual Studio (FREE)
TestCafe Studio

Desktop

Controls

WinForms
WPF
VCL
WinUI

Tools

WinForms Skin Editor
WPF Theme Designer
WPF Theme Editor (Legacy)
Coded UI Test Extension

Frameworks and Libraries

XAF - Cross-Platform .NET App UI
XPO - .NET ORM Library (FREE)
XPO Profiler
Core Libraries
Drawing Graphics Library
.NET App Security & Web API Service (FREE)

Web

Controls and Extensions

ASP.NET Web Forms Controls
ASP.NET MVC Extensions
ASP.NET Core Controls
ASP.NET Bootstrap Controls
DevExtreme
DevExtreme ASP.NET MVC Controls
Blazor Components

Tools

ASP.NET Theme Builder
ASP.NET Theme Deployer

Maintenance Mode

ASP.NET Core Bootstrap Controls

Mobile

Xamarin UI Controls (FREE)
.NET MAUI (FREE)

Enterprise and Analytic Tools

Reporting
Report and Dashboard Server
BI Dashboard
Office File API

End-User Documentation

Interface Elements for Desktop
Interface Elements for Web
Dashboard for Desktop
Dashboard for Web
24.2
The page you are viewing does not exist in version 24.2.
24.1
The page you are viewing does not exist in version 24.1.
23.2
The page you are viewing does not exist in version 23.2.
23.1
The page you are viewing does not exist in version 23.1.
22.2
The page you are viewing does not exist in version 22.2.
22.1
The page you are viewing does not exist in version 22.1.
21.2
The page you are viewing does not exist in version 21.2.
21.1
The page you are viewing does not exist in version 21.1.
20.2
The page you are viewing does not exist in version 20.2.
20.1
The page you are viewing does not exist in version 20.1.
19.2
19.1
18.2
18.1
17.2
Full-text search
API Reference
UI Widgets
Accordion
ActionSheet
Autocomplete
BarGauge
Box
Bullet
Button
ButtonGroup
Calendar
Chart
CheckBox
CircularGauge
ColorBox
ContextMenu
DataGrid
DateBox
DeferRendering
DiagramCTP
Drawer
DropDownBox
DropDownButton
FileManagerCTP
FileUploader
FilterBuilder
Form
Funnel
Gallery
HtmlEditorCTP
LinearGauge
List
LoadIndicator
LoadPanel
Lookup
Map
Menu
MultiView
NavBar
NumberBox
PieChart
PivotGrid
Configuration
allowExpandAll
allowFiltering
allowSorting
allowSortingBySummary
dataFieldArea
dataSource
disabled
elementAttr
export
fieldChooser
fieldPanel
headerFilter
height
hideEmptySummaryCells
hint
loadPanel
onCellClick
onCellPrepared
onContentReady
onContextMenuPreparing
onDisposing
onExported
onExporting
onFileSaving
onInitialized
onOptionChanged
rowHeaderLayout
rtlEnabled
scrolling
showBorders
showColumnGrandTotals
showColumnTotals
showRowGrandTotals
showRowTotals
showTotalsPrior
stateStoring
tabIndex
texts
collapseAll
dataNotAvailable
expandAll
exportToExcel
grandTotal
noData
removeAllSorting
showFieldChooser
sortColumnBySummary
sortRowBySummary
total
visible
width
wordWrapEnabled
Methods
Events
Summary Cell
Pivot Grid Cell
PivotGridFieldChooser
PolarChart
Popover
Popup
ProgressBar
RadioGroup
RangeSelector
RangeSlider
Resizable
ResponsiveBox
Sankey
Scheduler
ScrollView
SelectBox
SlideOut
SlideOutView
Slider
Sparkline
SpeedDialAction
Switch
TabPanel
Tabs
TagBox
TextArea
TextBox
TileView
Toast
Toolbar
Tooltip
TreeList
TreeMap
TreeView
ValidationGroup
ValidationSummary
Validator
VectorMap
Markup Components
UI Events
CSS Classes
Data Layer
Types
Utilities
Getting Started
Angular
React
Vue
ASP.NET MVC 5
ASP.NET Core
Widgets
Data Binding
Common Features

General Information

.NET Subscription

What's Included
DevExpress Installation
DevExpress Code Examples

Common Tools

Project Converter
Assembly Deployment Tool
Localization Service

Quality Assurance and Productivity

CodeRush for Visual Studio (FREE)
TestCafe Studio

Desktop

Controls

WinForms
WPF
VCL
WinUI

Tools

WinForms Skin Editor
WPF Theme Designer
WPF Theme Editor (Legacy)
Coded UI Test Extension

Frameworks and Libraries

XAF - Cross-Platform .NET App UI
XPO - .NET ORM Library (FREE)
XPO Profiler
Core Libraries
Drawing Graphics Library
.NET App Security & Web API Service (FREE)

Web

Controls and Extensions

ASP.NET Web Forms Controls
ASP.NET MVC Extensions
ASP.NET Core Controls
ASP.NET Bootstrap Controls
DevExtreme
DevExtreme ASP.NET MVC Controls
Blazor Components

Tools

ASP.NET Theme Builder
ASP.NET Theme Deployer

Maintenance Mode

ASP.NET Core Bootstrap Controls

Mobile

Xamarin UI Controls (FREE)
.NET MAUI (FREE)

Enterprise and Analytic Tools

Reporting
Report and Dashboard Server
BI Dashboard
Office File API

End-User Documentation

Interface Elements for Desktop
Interface Elements for Web
Dashboard for Desktop
Dashboard for Web
A newer version of this page is available. Switch to the current version.

JavaScript/jQuery PivotGrid - texts

Strings that can be changed or localized in the PivotGrid widget.

Type:

Object

collapseAll

The string to display as a Collapse All context menu item.

Type:

String

Default Value: 'Collapse All'

dataNotAvailable

Specifies text displayed in a cell when its data is unavailable for some reason.

Type:

String

Default Value: 'N/A'

See Also

expandAll

The string to display as an Expand All context menu item.

Type:

String

Default Value: 'Expand All'

exportToExcel

The string to display as an Export to Excel file context menu item.

Type:

String

Default Value: 'Export to Excel file'

grandTotal

The string to display as a header of the Grand Total row and column.

Type:

String

Default Value: 'Grand Total'

noData

Specifies the text displayed when a pivot grid does not contain any fields.

Type:

String

Default Value: 'No data'

removeAllSorting

The string to display as a Remove All Sorting context menu item.

Type:

String

Default Value: 'Remove All Sorting'

NOTE
This item appears in the context menu when data is sorted by summary values.

showFieldChooser

The string to display as a Show Field Chooser context menu item.

Type:

String

Default Value: 'Show Field Chooser'

sortColumnBySummary

The string to display as a Sort Column by Summary Value context menu item.

Type:

String

Default Value: 'Sort {0} by This Column'

NOTE
This item appears in the context menu when sorting by summary values is enabled.

sortRowBySummary

The string to display as a Sort Row by Summary Value context menu item.

Type:

String

Default Value: 'Sort {0} by This Row'

NOTE
This item appears in the context menu when sorting by summary values is enabled.

total

The string to display as a header of the Total row and column.

Type:

String

Default Value: '{0} Total'