Edit

Share via

Excel.CalculationType enum

  • Reference
Package:
excel

Remarks

[ API set: ExcelApi 1.1 ]

Examples

// Link to full sample: https://raw.githubusercontent.com/OfficeDev/office-js-snippets/prod/samples/excel/50-workbook/workbook-calculation.yaml

await Excel.run(async (context) => {
  context.application.calculate(Excel.CalculationType.recalculate);
  await context.sync();
});

Fields

full = "Full"

This will mark all cells as dirty and then recalculate them.
fullRebuild = "FullRebuild"

This will rebuild the full dependency chain, mark all cells as dirty and then recalculate them.
recalculate = "Recalculate"

Recalculates all cells that Excel has marked as dirty, that is, dependents of volatile or changed data, and cells programmatically marked as dirty.