WorksheetCalculateFormula Method (Boolean, Boolean, ICustomFunction)
Calculates all formulas in this worksheet.

Namespace: Aspose.Cells
Assembly: Aspose.Cells (in Aspose.Cells.dll) Version: 19.11.0.0 (19.11)
Syntax
public void CalculateFormula(
	bool recursive,
	bool ignoreError,
	ICustomFunction customFunction
)

Parameters

recursive
Type: SystemBoolean
True means if the worksheet' cells depend on the cells of other worksheets, the dependant cells in other worksheets will be calculated too. False means all the formulas in the worksheet have been calculated and the values are right.
ignoreError
Type: SystemBoolean
Indicates if hide the error in calculating formulas. The error may be unsupported function, external links, etc.
customFunction
Type: Aspose.CellsICustomFunction
The custom formula calculation functions to extend the calculation engine.
See Also