Enum RecalculationInterval
RecalculationInterval
An enumeration representing the possible intervals used in spreadsheet recalculation.
To call an enum, you call its parent class, name, and property. For example,
SpreadsheetApp.RecalculationInterval.ON_CHANGE.
Properties
| Property | Type | Description |
ON_CHANGE | Enum | Recalculate only when values are changed. |
MINUTE | Enum | Recalculate when values are changed, and every minute. |
HOUR | Enum | Recalculate when values are changed, and every hour. |
Except 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.
[null,null,["Last updated 2024-12-02 UTC."],[[["`RecalculationInterval` is used to control the frequency of spreadsheet recalculations within Google Apps Script."],["It offers three options: `ON_CHANGE`, `MINUTE`, and `HOUR`, allowing for recalculation triggered by value changes, every minute, or every hour, respectively."],["To use these options, refer to them using the format `SpreadsheetApp.RecalculationInterval.[property]`, such as `SpreadsheetApp.RecalculationInterval.ON_CHANGE`."]]],[]]
