Enum RecalculationInterval
Stay organized with collections
Save and categorize content based on your preferences.
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."],[[["\u003cp\u003e\u003ccode\u003eRecalculationInterval\u003c/code\u003e is used to control the frequency of spreadsheet recalculations within Google Apps Script.\u003c/p\u003e\n"],["\u003cp\u003eIt offers three options: \u003ccode\u003eON_CHANGE\u003c/code\u003e, \u003ccode\u003eMINUTE\u003c/code\u003e, and \u003ccode\u003eHOUR\u003c/code\u003e, allowing for recalculation triggered by value changes, every minute, or every hour, respectively.\u003c/p\u003e\n"],["\u003cp\u003eTo use these options, refer to them using the format \u003ccode\u003eSpreadsheetApp.RecalculationInterval.[property]\u003c/code\u003e, such as \u003ccode\u003eSpreadsheetApp.RecalculationInterval.ON_CHANGE\u003c/code\u003e.\u003c/p\u003e\n"]]],[],null,["# Enum RecalculationInterval\n\nRecalculationInterval\n\nAn enumeration representing the possible intervals used in spreadsheet recalculation.\n\nTo call an enum, you call its parent class, name, and property. For example, `\nSpreadsheetApp.RecalculationInterval.ON_CHANGE`. \n\n### Properties\n\n| Property | Type | Description |\n|-------------|--------|--------------------------------------------------------|\n| `ON_CHANGE` | `Enum` | Recalculate only when values are changed. |\n| `MINUTE` | `Enum` | Recalculate when values are changed, and every minute. |\n| `HOUR` | `Enum` | Recalculate when values are changed, and every hour. |"]]
