Google is committed to advancing racial equity for Black communities. See how.

Class PivotGroupLimit

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

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 following scopes:

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