CalculateFormula

CalculateFormula(string)

Calculates a formula.

public object CalculateFormula(string formula)
Parameter Type Description
formula String Formula to be calculated.

Return Value

Calculated formula result.

See Also


CalculateFormula(string, CalculationOptions)

Calculates a formula.

public object CalculateFormula(string formula, CalculationOptions opts)
Parameter Type Description
formula String Formula to be calculated.
opts CalculationOptions Options for calculating formula

Return Value

Calculated formula result.

See Also


CalculateFormula(bool, bool, ICustomFunction)

Calculates all formulas in this worksheet.

[Obsolete("Use CalculateFormula(CalculationOptions, bool) method instead.")]
[EditorBrowsable(EditorBrowsableState.Never)]
public void CalculateFormula(bool recursive, bool ignoreError, ICustomFunction customFunction)
Parameter Type Description
recursive Boolean True means if the worksheet’ cells depend on the cells of other worksheets, the dependent 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 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, bool) 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, bool)

Calculates all formulas in this worksheet.

public void CalculateFormula(CalculationOptions options, bool recursive)
Parameter Type Description
options CalculationOptions Options for calculation
recursive Boolean True means if the worksheet’ cells depend on the cells of other worksheets, the dependent cells in other worksheets will be calculated too. False means all the formulas in the worksheet have been calculated and the values are right.

See Also