Access and modify pivot table group limit.
Methods
| Method | Return type | Brief description |
|---|---|---|
getCountLimit() | Integer | Gets the count limit on rows or columns in the pivot group. |
getPivotGroup() | PivotGroup | Returns the pivot group the limit belongs to. |
remove() | void | Removes the pivot group limit. |
setCountLimit(countLimit) | PivotGroupLimit | Sets the count limit on rows or columns in the pivot group. |
Detailed documentation
getCountLimit()
Gets the count limit on rows or columns in the pivot group.
Return
Integer — The count limit on rows or columns.
Authorization
Scripts that use this method require authorization with one or more of the following scopes:
-
https://www.googleapis.com/auth/spreadsheets.currentonly -
https://www.googleapis.com/auth/spreadsheets
getPivotGroup()
Returns the pivot group the limit belongs to.
Return
PivotGroup — The pivot group.
Authorization
Scripts that use this method require authorization with one or more of the following scopes:
-
https://www.googleapis.com/auth/spreadsheets.currentonly -
https://www.googleapis.com/auth/spreadsheets
remove()
Removes the pivot group limit.
Authorization
Scripts that use this method require authorization with one or more of the following scopes:
-
https://www.googleapis.com/auth/spreadsheets.currentonly -
https://www.googleapis.com/auth/spreadsheets
setCountLimit(countLimit)
Sets the count limit on rows or columns in the pivot group.
Parameters
| Name | Type | Description |
|---|---|---|
countLimit | Integer | The count limit on rows or columns to set. Must be positive. |
Return
PivotGroupLimit — The pivot group limit, for chaining.
Authorization
Scripts that use this method require authorization with one or more of the following scopes:
-
https://www.googleapis.com/auth/spreadsheets.currentonly -
https://www.googleapis.com/auth/spreadsheets