aspose.cells

Classes

Constants

Class FormulaParseOptions

Represents options when parsing formula.

Constructor Summary
`FormulaParseOptions()`

Property Getters/Setters Summary
`function`	`getCheckAddIn()`
`function`	`setCheckAddIn(value)`
	Whether 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).
`function`	`getLocaleDependent()`
`function`	`setLocaleDependent(value)`
	Whether the formula is locale formatted. Default is false.
`function`	`getParse()`
`function`	`setParse(value)`
	Whether 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.
`function`	`getR1C1Style()`
`function`	`setR1C1Style(value)`
	Whether the formula is R1C1 reference style. Default is false.

- Constructor Detail
  - FormulaParseOptions
```
function FormulaParseOptions()
```
- Property Getters/Setters Detail
  - getLocaleDependent/setLocaleDependent : boolean
```
function getLocaleDependent() / function setLocaleDependent(value)
```
    Whether the formula is locale formatted. Default is false.
  - getR1C1Style/setR1C1Style : boolean
```
function getR1C1Style() / function setR1C1Style(value)
```
    Whether the formula is R1C1 reference style. Default is false.
  - getCheckAddIn/setCheckAddIn : boolean
```
function getCheckAddIn() / function setCheckAddIn(value)
```
    Whether 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).
  - getParse/setParse : boolean
```
function getParse() / function setParse(value)
```
    Whether 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.