CalculateFormula

CalculateFormula()

Calculates the result of formulas.

public void CalculateFormula()

Remarks

For all supported formulas, please see the list at https://docs.aspose.com/display/cellsnet/Supported+Formula+Functions

See Also


CalculateFormula(bool)

Calculates the result of formulas.

public void CalculateFormula(bool ignoreError)
Parameter Type Description
ignoreError Boolean Indicates if hide the error in calculating formulas. The error may be unsupported function, external links, etc.

See Also


CalculateFormula(bool, ICustomFunction)

Calculates the result of formulas.

[Obsolete("Use CalculateFormula(CalculationOptions) method instead.")]
[EditorBrowsable(EditorBrowsableState.Never)]
public void CalculateFormula(bool ignoreError, ICustomFunction customFunction)
Parameter Type Description
ignoreError Boolean Indicates if hide the error in calculating formulas. The error may be unsupported function, external links, etc.
customFunction ICustomFunction The custom formula calculation functions to extend the calculation engine.

Remarks

NOTE: This member is now obsolete. Instead, please use CalculateFormula(CalculationOptions) method. This method will be removed 12 months later since August 2020. Aspose apologizes for any inconvenience you may have experienced.

See Also


CalculateFormula(CalculationOptions)

Calculating formulas in this workbook.

public void CalculateFormula(CalculationOptions options)
Parameter Type Description
options CalculationOptions Options for calculation

See Also