Class PivotGroupLimit

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).

PivotGroupLimit

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