Skip to content

Formula

Formulas are not part of excelwindClasses. Use the formula prop on <Cell>.

<Cell formula="SUM(B2:B10)" value={1234} />

Cached results

  • If you also set value, it becomes the cached result Excel shows before recalculation.
  • If you omit value, Excel will compute the result when the file is opened.

Notes

  • Formula strings are passed directly to ExcelJS without modification.
  • ExcelJS writes the formula into the file, and Excel itself evaluates it on open.
  • We adhere to Excel’s formula standards by passing through the string unchanged.