CalculateFormula
Contents
[
Hide
]
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
- class Workbook
- namespace Aspose.Cells
- assembly Aspose.Cells
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
- class Workbook
- namespace Aspose.Cells
- assembly Aspose.Cells
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
- interface ICustomFunction
- class Workbook
- namespace Aspose.Cells
- assembly Aspose.Cells
CalculateFormula(CalculationOptions)
Calculating formulas in this workbook.
public void CalculateFormula(CalculationOptions options)
Parameter | Type | Description |
---|---|---|
options | CalculationOptions | Options for calculation |
See Also
- class CalculationOptions
- class Workbook
- namespace Aspose.Cells
- assembly Aspose.Cells