In This Topic ▼

SetCellFormula Method

Summary

Sets the cell formula value.

TypeScript

JavaScript

Cell.prototype.setCellFormula = function( 
   formula 
)

setCellFormula( 
   formula: string 
): void;

formula

A string that can be set to represent a mathematical or logical formula.

Formulas can include references to other cells, mathematical operations, logical operations, and predefined functions.

Setting the cell formula may trigger recalculation of the cell's value when the formula is set or when referenced data changes.