Formula

📊 Univer Sheet

Formula is one of the core capabilities provided by Univer, which allows you to use formulas to calculate values in cells. The functions supported by formulas are consistent with Excel, including mathematical, logical, text, date, and more.

Supported Formula Functions

Functions - (0)

Facade API

Execute Calculation

const formula = univerAPI.getFormula();
formula.executeCalculation();

Stop Calculation

const formula = univerAPI.getFormula();
formula.stopCalculation();

Calculation Start Event

const formula = univerAPI.getFormula();
formula.calculationStart((forceCalculate) => {
    console.log(forceCalculate)
});

Calculation Processing Event

const formula = univerAPI.getFormula();
formula.calculationProcessing((stageInfo) => {
    console.log(stageInfo)
});

Calculation End Event

const formula = univerAPI.getFormula();
formula.calculationEnd((functionsExecutedState) => {
    console.log(functionsExecutedState)
});

Custom Formula

Univer supports custom formulas. Please refer to the Custom Formula section to learn how to implement them.

Permission Row & Column