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++