Interface FormulaTextOptions

Options for converting a formula to text.

interface FormulaTextOptions {
    cell?: CellCoords;
    evalIndex?: number;
    r1c1?: boolean;
    target?: FormulaTarget;
}

Index

Properties

cell? evalIndex? r1c1? target?

Properties

`Optional`cell

cell?: CellCoords

The cell coordinates for which the formula text is being requested.

`Optional`evalIndex

evalIndex?: number

If specified, the formula text will only be generate for a given eval index.

`Optional`r1c1

r1c1?: boolean

If true, the formula will be returned in R1C1 notation.

Default Value

false

`Optional`target

target?: FormulaTarget

Who the text is for.

Default Value

'storage'

Remarks

Pass 'display' for text a person reads or edits. See FormulaTarget.

Interface FormulaTextOptions

Index

Properties

Properties

`Optional`cell

`Optional`evalIndex

`Optional`r1c1

Default Value

`Optional`target

Default Value

Remarks

Settings

On This Page

Interface FormulaTextOptions

Index

Properties

Properties

Optionalcell

OptionalevalIndex

Optionalr1c1

Default Value

Optionaltarget

Default Value

Remarks

Settings

On This Page

`Optional`cell

`Optional`evalIndex

`Optional`r1c1

`Optional`target