FormulaSettings Class
Contents
[
Hide
]FormulaSettings class
Settings of formulas and calculation.
type FormulaSettings struct {
ptr unsafe.Pointer
}
Constructors
| Method | Description |
|---|
Methods
| Method | Description |
|---|---|
| IsNull | Checks whether the implementation object is nullptr. |
| GetCalculateOnOpen | Indicates whether the application is required to perform a full calculation when the workbook is opened. |
| SetCalculateOnOpen | Indicates whether the application is required to perform a full calculation when the workbook is opened. |
| GetCalculateOnSave | Indicates whether to recalculate the workbook before saving the document, when in manual calculation mode. |
| SetCalculateOnSave | Indicates whether to recalculate the workbook before saving the document, when in manual calculation mode. |
| GetForceFullCalculation | Indicates whether it calculates all formulas every time when a calculation is triggered. |
| SetForceFullCalculation | Indicates whether it calculates all formulas every time when a calculation is triggered. |
| GetCalculationMode | Gets or sets the mode for workbook calculation in MS Excel. |
| SetCalculationMode | Gets or sets the mode for workbook calculation in MS Excel. |
| GetCalculationId | Specifies the version of the calculation engine used to calculate values in the workbook. |
| SetCalculationId | Specifies the version of the calculation engine used to calculate values in the workbook. |
| GetEnableIterativeCalculation | Indicates whether to enable iterative calculation to resolve circular references. |
| SetEnableIterativeCalculation | Indicates whether to enable iterative calculation to resolve circular references. |
| GetMaxIteration | The maximum iterations to resolve a circular reference. |
| SetMaxIteration | The maximum iterations to resolve a circular reference. |
| GetMaxChange | The maximum change to resolve a circular reference. |
| SetMaxChange | The maximum change to resolve a circular reference. |
| GetPrecisionAsDisplayed | Indicates whether the precision of calculated result be set as they are displayed while calculating formulas. |
| SetPrecisionAsDisplayed | Indicates whether the precision of calculated result be set as they are displayed while calculating formulas. |
| GetEnableCalculationChain | Indicates whether to enable calculation chain for formulas.Default is false. |
| SetEnableCalculationChain | Indicates whether to enable calculation chain for formulas.Default is false. |
| GetPreservePaddingSpaces | Indicates whether to preserve those spaces and line breaks that are padded between formula tokens while getting and setting formulas.Default value is false. |
| SetPreservePaddingSpaces | Indicates whether to preserve those spaces and line breaks that are padded between formula tokens while getting and setting formulas.Default value is false. |