[]
• new NameInfo(name
, expr
, row
, column
, comment?
, isReadOnly?
)
Represents a custom named expression that can be used by formulas.
Name | Type | Description |
---|---|---|
name |
string |
The custom expression name. |
expr |
Expression |
The custom named expression. |
row |
number |
The base row of the expression. |
column |
number |
The base column of the expression. |
comment? |
string |
- |
isReadOnly? |
boolean |
- |
▸ getColumn(): number
Gets the base column of the custom named expression.
number
The base column.
▸ getComment(): string
Gets the comment of the current NameInfo object.
string
The name of the current NameInfo object.
▸ getExpression(): Expression
Gets the expression.
The expression.
▸ getName(): string
Gets the name of the current NameInfo object.
string
The name of the current NameInfo object.
▸ getRow(): number
Gets the base row of the custom named expression.
number
The base row.
▸ isReadOnly(value?
): boolean
Gets/Sets the readonly status of the custom named expression.
Name | Type |
---|---|
value? |
boolean |
boolean
The readonly status.
▸ set(name?
, formula?
, baseRow?
, baseCol?
, comment?
): void
Rename the name, the formula, and the comment of the custom name.
Name | Type |
---|---|
name? |
string |
formula? |
string |
baseRow? |
number |
baseCol? |
number |
comment? |
string |
void