Interface NamedRangeItem

Defined names are descriptive text that is used to represents a cell, range of cells, formula, or constant value.

TODO - move to another location

interface NamedRangeItem {
    comment?: string;
    hidden?: boolean;
    name: string;
    ref: SheetCellRangeCoords[];
    scope?: string;
    type: "sheet";
}

Hierarchy (view full)

Properties

comment? hidden? name ref scope? type

Properties

Optional comment

comment?: string

The comment for the defined name.

Optional hidden

hidden?: boolean

If true not shown in the ui.

name

name: string

The name of the defined name.

Remarks

This is the name that is used in formulas.

ref

ref: SheetCellRangeCoords[]

The value of the defined name.

Remarks

This is the value that is used in formulas.

Optional scope

scope?: string

If scope this will be the sheetName.

type

type: "sheet"

Type of the defined name. (this can be a cellRange or a Table)

Settings

Member Visibility

Theme

On This Page

commenthiddennamerefscopetype