All docs
V20.2
21.1 (CTP)
20.2
20.1
19.2
The page you are viewing does not exist in version 19.2. This link will take you to the root page.
19.1
The page you are viewing does not exist in version 19.1. This link will take you to the root page.
18.2
The page you are viewing does not exist in version 18.2. This link will take you to the root page.
18.1
The page you are viewing does not exist in version 18.1. This link will take you to the root page.
17.2
The page you are viewing does not exist in version 17.2. This link will take you to the root page.
Box
Map
Vue

texts

Strings that can be changed or localized in the PivotGrid UI component.

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'

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'