<Spreadsheet>.AddName (Function)

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Version:

Home | Sign in | English

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

<Spreadsheet>.AddName (Function)

In french: <Tableur>.AjouteNom

Specifies a name to identify a cell found in a Spreadsheet control.

Example

// Creates a formula that references A1 and A2 with clearer names
PSHEET_SPREADSHEET1.AddName("PriceBT", "$A$1")
PSHEET_SPREADSHEET1.AddName("VAT", "$A$2")
PSHEET_SPREADSHEET1.AddFormula("A3", "PriceBT*VAT")

Syntax

<Spreadsheet control>.AddName(<Cell name> , <Cell> [, <Range> [, <Comment>]])

<Spreadsheet control>: Control name

Name of Spreadsheet control to use.

<Cell name>: Character string (with quotes)

Name that will be given to the cell.
Caution:
This parameter must not correspond to a cell name ("A1" for example) or to a function name ("SUM" for example).
This parameter must contain no space character.
<Spreadsheet>.AddName fails if the specified name is invalid or if it already exists: the ErrorOccurred variable is set to True and ErrorInfo returns the error details.

<Cell>: Character string (with quotes)

Cell to name.
Caution: Absolute coordinates must be used to identify the cell (for example: "$A$1").
Indeed, the coordinates are relative in a cell name. Using the notation "A1", "A2", ... may trigger errors of circular references.

<Range>: Optional integer

Number of the worksheet where the name can be used. If this parameter is not specified or if it is set to 0, the name can be used in all the worksheets.

<Comment>: Optional character string (with quotes)

Versions 23 and later
Comment associated with the cell name (up to 255 characters).
New in version 23
Comment associated with the cell name (up to 255 characters).
Comment associated with the cell name (up to 255 characters).

Remarks

The names are not case sensitive (uppercase/lowercase characters)

Component : wd250obj.dll