Stay organized with collections Save and categorize content based on your preferences.
PivotGroupLimitAccess and modify pivot table group limit.
Detailed documentationgetCountLimit()
Gets the count limit on rows or columns in the pivot group.
ReturnInteger — The count limit on rows or columns.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/spreadsheets.currentonlyhttps://www.googleapis.com/auth/spreadsheetsgetPivotGroup()
Returns the pivot group the limit belongs to.
ReturnPivotGroup — The pivot group.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/spreadsheets.currentonlyhttps://www.googleapis.com/auth/spreadsheetsremove()
Removes the pivot group limit.
AuthorizationScripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/spreadsheets.currentonlyhttps://www.googleapis.com/auth/spreadsheetssetCountLimit(countLimit)
Sets the count limit on rows or columns in the pivot group.
Parameters Name Type DescriptioncountLimit Integer The count limit on rows or columns to set. Must be positive. Return
PivotGroupLimit — The pivot group limit, for chaining.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/spreadsheets.currentonlyhttps://www.googleapis.com/auth/spreadsheetsExcept as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2024-12-02 UTC.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Missing the information I need","missingTheInformationINeed","thumb-down"],["Too complicated / too many steps","tooComplicatedTooManySteps","thumb-down"],["Out of date","outOfDate","thumb-down"],["Samples / code issue","samplesCodeIssue","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2024-12-02 UTC."],[[["`PivotGroupLimit` allows you to programmatically control the limits applied to pivot table groups in Google Sheets."],["You can access and modify the count limit of rows or columns within a pivot group using methods like `getCountLimit` and `setCountLimit`."],["The `PivotGroupLimit` class provides methods to retrieve the associated pivot group (`getPivotGroup`) and remove the limit entirely (`remove`)."],["All methods within `PivotGroupLimit` require authorization with specific scopes, such as `https://www.googleapis.com/auth/spreadsheets`."]]],[]]
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4