Class PivotGroupLimit

  • PivotGroupLimit allows access and modification of pivot table group limits.

  • You can get the count limit on rows or columns in the pivot group usinggetCountLimit().

  • The pivot group the limit belongs to can be retrieved usinggetPivotGroup().

  • You can remove the pivot group limit usingremove().

  • The count limit on rows or columns in the pivot group can be set usingsetCountLimit(countLimit).

PivotGroupLimit

Access and modify pivot table group limit.

Methods

MethodReturn typeBrief description
getCountLimit()IntegerGets the count limit on rows or columns in the pivot group.
getPivotGroup()PivotGroupReturns the pivot group the limit belongs to.
remove()voidRemoves the pivot group limit.
setCountLimit(countLimit)PivotGroupLimitSets 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 followingscopes:

  • 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 followingscopes:

  • 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 followingscopes:

  • 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

NameTypeDescription
countLimitIntegerThe 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 followingscopes:

  • https://www.googleapis.com/auth/spreadsheets.currentonly
  • https://www.googleapis.com/auth/spreadsheets

Except as otherwise noted, the content of this page is licensed under theCreative Commons Attribution 4.0 License, and code samples are licensed under theApache 2.0 License. For details, see theGoogle Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.

Last updated 2025-12-11 UTC.