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 |
|---|---|---|
Integer
|
Gets the count limit on rows or columns in the pivot group. | |
Pivot
|
Returns the pivot group the limit belongs to. | |
void
|
Removes the pivot group limit. | |
Pivot
|
Sets the count limit on rows or columns in the pivot group. |
Detailed documentation
get
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
get
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
set
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
