Free Trial Buy

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'