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