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 recalculate the workbook before saving the document, when in manual calculation mode. |
| SetCalculateOnSave | Indicates whether recalculate the workbook before saving the document, when in manual calculation mode. |
| GetForceFullCalculation | Indicates whether calculates all formulas every time when a calculation is triggered. |
| SetForceFullCalculation | Indicates whether 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 enable iterative calculation to resolve circular references. |
| SetEnableIterativeCalculation | Indicates whether 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 | Whether the precision of calculated result be set as they are displayed while calculating formulas |
| SetPrecisionAsDisplayed | Whether the precision of calculated result be set as they are displayed while calculating formulas |
| GetEnableCalculationChain | Whether enable calculation chain for formulas. Default is false. |
| SetEnableCalculationChain | Whether enable calculation chain for formulas. Default is false. |
| GetPreservePaddingSpaces | Indicates whether preserve those spaces and line breaks that are padded between formula tokenswhile getting and setting formulas.Default value is false. |
| SetPreservePaddingSpaces | Indicates whether preserve those spaces and line breaks that are padded between formula tokenswhile getting and setting formulas.Default value is false. |