PV SET CELL NAME

version 6.8

PV SET CELL NAME (area; column; row; name)

Parameter	Type		Description
area	Longint		4D View area
column	Longint		Cell column number
row	Longint		Cell row number
name	String		Cell name

The PV SET CELL NAME command sets the name of a cell defined using the column and row parameters.

Note: The first three characters of a cell name must not be numbers.

You can access the cell either by its absolute reference — column or row number — or its name, by using the PV GET CELL NAME LIST and PV GOTO CELL commands. The 4D View area formulas can also be referenced to this cell using its name.

   C_TEXT($CellName)  `Name to assign to cell
   C_LONGINT($Column)  `Column number of current cell
   C_LONGINT($Row)  `Row number of current cell

   PV GET CURRENT CELL (Area;$Column;$Row)  `Get current cell coordinates
   $CellName:=PV Get cell name (Area;$Column;$Row)  `Name possibly given already

   If ($CellName:="")  `The cell already has a name?
      $CellName:=Request("What name do you want to assign to this cell?";"New name")
      If ($CellName#"")  `A name was entered
         PV SET CELL NAME (Area;$Column;$Row;$CellName)  `Assign entered name
      End if
   Else  `Current cell already has a name
      ALERT("This cell is already named ""+$CellName+"".")  `Warning
   End if

PV Get cell name, PV GET CELL NAME LIST.