FormulaParseOptions class

FormulaParseOptions class

Represents options when parsing formula.

The FormulaParseOptions type exposes the following members:

Constructors

ConstructorDescription
initConstructs a new instance of FormulaParseOptions

Properties

PropertyDescription
locale_dependentWhether the formula is locale formatted. Default is false.
r1c1_styleWhether the formula is R1C1 reference style. Default is false.
check_add_inWhether 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).
parseWhether 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 them
or parsed formula data is required by other operations such as calculating formulas.
custom_function_definitionDefinition for parsing custom functions.

See Also