FormulaParseOptions Class

FormulaParseOptions class

Represents options when parsing formula.


type FormulaParseOptions struct  {
	ptr unsafe.Pointer
}

Constructors

MethodDescription
NewFormulaParseOptionsDefault constructor.

Methods

MethodDescription
IsNullChecks whether the implementation object is nullptr.
GetLocaleDependentWhether the formula is locale formatted. Default is false.
SetLocaleDependentWhether the formula is locale formatted. Default is false.
GetR1C1StyleWhether the formula is R1C1 reference style. Default is false.
SetR1C1StyleWhether the formula is R1C1 reference style. Default is false.
GetCheckAddInWhether check addins in existing external links of current workbook for user defined function without external link.Default is true(if user defined function matches one addin in existing external links, then take it as the addin).
SetCheckAddInWhether check addins in existing external links of current workbook for user defined function without external link.Default is true(if user defined function matches one addin in existing external links, then take it as the addin).
GetParseWhether parse given formula. Default is true.If it is false, then given formula string will be kept as it is for the cell until user call other methods to parse themor parsed formula data is required by other operations such as calculating formulas.
SetParseWhether parse given formula. Default is true.If it is false, then given formula string will be kept as it is for the cell until user call other methods to parse themor parsed formula data is required by other operations such as calculating formulas.
GetCustomFunctionDefinitionDefinition for parsing custom functions.
SetCustomFunctionDefinitionDefinition for parsing custom functions.