ExcelScript.CalculationType enum

  • Reference
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.