Aspose::Cells::FormulaSettings class
Contents
[
Hide
]FormulaSettings class
Settings of formulas and calculation.
class FormulaSettings
Methods
| Method | Description |
|---|---|
| FormulaSettings(FormulaSettings_Impl* impl) | Constructs from an implementation object. |
| FormulaSettings(const FormulaSettings& src) | Copy constructor. |
| GetCalculateOnOpen() | Indicates whether the application is required to perform a full calculation when the workbook is opened. |
| GetCalculateOnSave() | Indicates whether recalculate the workbook before saving the document, when in manual calculation mode. |
| GetCalculationId() | Specifies the version of the calculation engine used to calculate values in the workbook. |
| GetCalculationMode() | Gets or sets the mode for workbook calculation in ms excel. |
| GetEnableCalculationChain() | Whether enable calculation chain for formulas. Default is false. |
| GetEnableIterativeCalculation() | Indicates whether enable iterative calculation to resolve circular references. |
| GetForceFullCalculation() | Indicates whether calculates all formulas every time when a calculation is triggered. |
| GetMaxChange() | The maximum change to resolve a circular reference. |
| GetMaxIteration() | The maximum iterations to resolve a circular reference. |
| GetPrecisionAsDisplayed() | Whether the precision of calculated result be set as they are displayed while calculating formulas. |
| GetPreservePaddingSpaces() | Indicates whether preserve those spaces and line breaks that are padded between formula tokens while getting and setting formulas. Default value is false. |
| IsNull() const | Checks whether the implementation object is nullptr. |
| explicit operator bool() const | operator bool() |
| operator=(const FormulaSettings& src) | operator= |
| SetCalculateOnOpen(bool value) | Indicates whether the application is required to perform a full calculation when the workbook is opened. |
| SetCalculateOnSave(bool value) | Indicates whether recalculate the workbook before saving the document, when in manual calculation mode. |
| SetCalculationId(const U16String& value) | Specifies the version of the calculation engine used to calculate values in the workbook. |
| SetCalculationId(const char16_t* value) | Specifies the version of the calculation engine used to calculate values in the workbook. |
| SetCalculationMode(CalcModeType value) | Gets or sets the mode for workbook calculation in ms excel. |
| SetEnableCalculationChain(bool value) | Whether enable calculation chain for formulas. Default is false. |
| SetEnableIterativeCalculation(bool value) | Indicates whether enable iterative calculation to resolve circular references. |
| SetForceFullCalculation(bool value) | Indicates whether calculates all formulas every time when a calculation is triggered. |
| SetMaxChange(double value) | The maximum change to resolve a circular reference. |
| SetMaxIteration(int32_t value) | The maximum iterations to resolve a circular reference. |
| SetPrecisionAsDisplayed(bool value) | Whether the precision of calculated result be set as they are displayed while calculating formulas. |
| SetPreservePaddingSpaces(bool value) | Indicates whether preserve those spaces and line breaks that are padded between formula tokens while getting and setting formulas. Default value is false. |
| ~FormulaSettings() | Destructor. |
Fields
| Field | Description |
|---|---|
| _impl | The implementation object. |
See Also
- Namespace Aspose::Cells
- Library Aspose.Cells for C++