Class PivotGroupLimit
Stay organized with collections
Save and categorize content based on your preferences.
AI-generated Key Takeaways
-
PivotGroupLimit allows access and modification of pivot table group limits.
-
You can get the count limit on rows or columns in the pivot group using
getCountLimit(). -
The pivot group the limit belongs to can be retrieved using
getPivotGroup(). -
You can remove the pivot group limit using
remove(). -
The count limit on rows or columns in the pivot group can be set using
setCountLimit(countLimit).
Access and modify pivot table group limit.
Methods
| Method | Return type | Brief description |
|---|---|---|
get | Integer | Gets the count limit on rows or columns in the pivot group. |
get | Pivot | Returns the pivot group the limit belongs to. |
remove() | void | Removes the pivot group limit. |
set | Pivot | 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
Pivot — 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 |
|---|---|---|
count | Integer | The count limit on rows or columns to set. Must be positive. |
Return
Pivot — 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