ExcelScript.CalculationType enum

Package:

ExcelScript

Remarks

Examples

/**
 * This script fully recalculates the entire workbook.
 * This code is useful when automatic recalculation is turned off
 * but later parts of the script rely on updated values.
 */
function main(workbook: ExcelScript.Workbook, workbookURL: string) {
  const application = workbook.getApplication();
  application.calculate(ExcelScript.CalculationType.fullRebuild);
}

Fields

full	This will mark all cells as dirty and then recalculate them.
fullRebuild	This will rebuild the full dependency chain, mark all cells as dirty and then recalculate them.
recalculate	Recalculates all cells that Excel has marked as dirty, that is, dependents of volatile or changed data, and cells programmatically marked as dirty.