Aspose::Cells::FormulaSettings::SetEnableCalculationChain method
Contents
[
Hide
]FormulaSettings::SetEnableCalculationChain method
Whether enable calculation chain for formulas. Default is false.
void Aspose::Cells::FormulaSettings::SetEnableCalculationChain(bool value)
Remarks
When there are lots of formulas in the workbook and user needs to calculate them repeatedly with modifying only a small part of them, it may be helpful for performance to enable the calculation chain. On the other hand, if the chain is enabled, maintaining the model of chain requires extra memory, and it also requires a bit more cpu time for some other operations such as changing cell’s value or formulas. After changing this property from false to true, the calculation chain will be analyzed and built at the time of first calculation for the workbook, so the required time for the first calculation may be more than normal calculation without chain.
See Also
- Class Vector
- Class FormulaSettings
- Namespace Aspose::Cells
- Library Aspose.Cells for C++