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'

Show Example:
AngularJS
Knockout
jQuery

In this demo, you can specify the text of the "Collapse All" menu item at runtime. Type any text in the text box below the pivot grid. Then, right-click any row or column header to invoke the context menu. The "Collapse All" item from that menu will display the specified text.


                                    

                                    

In this demo, you can specify the text of the "Collapse All" menu item at runtime. Type any text in the text box below the pivot grid. Then, right-click any row or column header to invoke the context menu. The "Collapse All" item from that menu will display the specified text.


                                    

                                    

In this demo, you can specify the text of the "Collapse All" menu item at runtime. Type any text in the text box below the pivot grid. Then, right-click any row or column header to invoke the context menu. The "Collapse All" item from that menu will display the specified text.


                                    

                                    

expandAll

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

Type: String
Default Value: 'Expand All'

Show Example:
AngularJS
Knockout
jQuery

In this demo, you can specify the text of the "Expand All" menu item at runtime. Type any text in the text box below the pivot grid. Then, right-click any row or column header to invoke the context menu. The "Expand All" item from that menu will display the specified text.


                                    

                                    

In this demo, you can specify the text of the "Expand All" menu item at runtime. Type any text in the text box below the pivot grid. Then, right-click any row or column header to invoke the context menu. The "Expand All" item from that menu will display the specified text.


                                    

                                    

In this demo, you can specify the text of the "Expand All" menu item at runtime. Type any text in the text box below the pivot grid. Then, right-click any row or column header to invoke the context menu. The "Expand All" item from that menu will display the specified text.


                                    

                                    

exportToExcel

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

Type: String
Default Value: 'Export to Excel file'

Show Example:
AngularJS
Knockout
jQuery

In this demo, you can specify the text of the "Export to Excel" menu item at runtime. Type any text in the text box below the pivot grid. Then, right-click any area in the grid to invoke the context menu. The "Export to Excel" item from that menu will display the specified text.


                                    

                                    

In this demo, you can specify the text of the "Export to Excel" menu item at runtime. Type any text in the text box below the pivot grid. Then, right-click any area in the grid to invoke the context menu. The "Export to Excel" item from that menu will display the specified text.


                                    

                                    

In this demo, you can specify the text of the "Export to Excel" menu item at runtime. Type any text in the text box below the pivot grid. Then, right-click any area in the grid to invoke the context menu. The "Export to Excel" item from that menu will display the specified text.


                                    

                                    

grandTotal

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

Type: String
Default Value: 'Grand Total'

Show Example:
AngularJS
Knockout
jQuery

In this demo, you can specify the text of the "Grand Total" headers at runtime. Type any text in the text box below the pivot grid and make the text box lose focus. The specified text will immediately appear in both "Grand Total" headers.


                                    

                                    

In this demo, you can specify the text of the "Grand Total" headers at runtime. Type any text in the text box below the pivot grid and make the text box lose focus. The specified text will immediately appear in both "Grand Total" headers.


                                    

                                    

In this demo, you can specify the text of the "Grand Total" headers at runtime. Type any text in the text box below the pivot grid and make the text box lose focus. The specified text will immediately appear in both "Grand Total" headers.


                                    

                                    

noData

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

Type: String
Default Value: 'No data'

Show Example:
AngularJS
Knockout
jQuery

In this demo, you can specify the text displayed by the pivot grid when it contains no data. Type any text in the text box below the pivot grid and make the text box lose focus. The specified text will immediately appear in the grid.


                                    

                                    

In this demo, you can specify the text displayed by the pivot grid when it contains no data. Type any text in the text box below the pivot grid and make the text box lose focus. The specified text will immediately appear in the grid.


                                    

                                    

In this demo, you can specify the text displayed by the pivot grid when it contains no data. Type any text in the text box below the pivot grid and make the text box lose focus. The specified text will immediately appear in the grid.


                                    

                                    

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.
Show Example:
AngularJS
Knockout
jQuery

In this demo, you can specify the text of the "Remove All Sorting" context menu item at runtime. Type any text in the text box below the pivot grid. Then, right-click any header in the grid to invoke the context menu. The "Remove All Sorting" item from that menu will display the specified text.


                                    

                                    

In this demo, you can specify the text of the "Remove All Sorting" context menu item at runtime. Type any text in the text box below the pivot grid. Then, right-click any header in the grid to invoke the context menu. The "Remove All Sorting" item from that menu will display the specified text.


                                    

                                    

In this demo, you can specify the text of the "Remove All Sorting" context menu item at runtime. Type any text in the text box below the pivot grid. Then, right-click any header in the grid to invoke the context menu. The "Remove All Sorting" item from that menu will display the specified text.


                                    

                                    

showFieldChooser

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

Type: String
Default Value: 'Show Field Chooser'

Show Example:
AngularJS
Knockout
jQuery

In this demo, you can specify the text of the "Show Field Chooser" context menu item at runtime. Type any text in the text box below the pivot grid. Then, right-click any area in the grid to invoke the context menu. The "Show Field Chooser" item from that menu will display the specified text.


                                    

                                    

In this demo, you can specify the text of the "Show Field Chooser" context menu item at runtime. Type any text in the text box below the pivot grid. Then, right-click any area in the grid to invoke the context menu. The "Show Field Chooser" item from that menu will display the specified text.


                                    

                                    

In this demo, you can specify the text of the "Show Field Chooser" context menu item at runtime. Type any text in the text box below the pivot grid. Then, right-click any area in the grid to invoke the context menu. The "Show Field Chooser" item from that menu will display the specified text.


                                    

                                    

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.
Show Example:
AngularJS
Knockout
jQuery

In this demo, you can specify the text of the "Sort Column by Summary Value" context menu item at runtime. Type any text in the text box below the pivot grid. Then, right-click any column header in the grid to invoke the context menu. The "Sort Column by Summary Value" item from that menu will display the specified text.


                                    

                                    

In this demo, you can specify the text of the "Sort Column by Summary Value" context menu item at runtime. Type any text in the text box below the pivot grid. Then, right-click any column header in the grid to invoke the context menu. The "Sort Column by Summary Value" item from that menu will display the specified text.


                                    

                                    

In this demo, you can specify the text of the "Sort Column by Summary Value" context menu item at runtime. Type any text in the text box below the pivot grid. Then, right-click any column header in the grid to invoke the context menu. The "Sort Column by Summary Value" item from that menu will display the specified text.


                                    

                                    

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.
Show Example:
AngularJS
Knockout
jQuery

In this demo, you can specify the text of the "Sort Row by Summary Value" context menu item at runtime. Type any text in the text box below the pivot grid. Then, right-click any row header in the grid to invoke the context menu. The "Sort Row by Summary Value" item from that menu will display the specified text.


                                    

                                    

In this demo, you can specify the text of the "Sort Row by Summary Value" context menu item at runtime. Type any text in the text box below the pivot grid. Then, right-click any row header in the grid to invoke the context menu. The "Sort Row by Summary Value" item from that menu will display the specified text.


                                    

                                    

In this demo, you can specify the text of the "Sort Row by Summary Value" context menu item at runtime. Type any text in the text box below the pivot grid. Then, right-click any row header in the grid to invoke the context menu. The "Sort Row by Summary Value" item from that menu will display the specified text.


                                    

                                    

total

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

Type: String
Default Value: '{0} Total'

Show Example:
AngularJS
Knockout
jQuery

In this demo, you can specify the text of the "Total" headers at runtime. Type any text in the text box below the pivot grid and make the text box lose focus. The specified text will immediately appear in "Total" row and column headers.


                                    

                                    

In this demo, you can specify the text of the "Total" headers at runtime. Type any text in the text box below the pivot grid and make the text box lose focus. The specified text will immediately appear in "Total" row and column headers.


                                    

                                    

In this demo, you can specify the text of the "Total" headers at runtime. Type any text in the text box below the pivot grid and make the text box lose focus. The specified text will immediately appear in "Total" row and column headers.