Command PV Get cell formula

4D View

PV Get cell formula

version 6.8


PV Get cell formula (area; column; row) String

ParameterTypeDescription
areaLongint4D View area
columnLongintCell column number
rowLongintCell row number

Function result String Formula

Description

The PV Get cell formula command returns the formula contained in the cell set by column and row.

Example

The method below recopies into a cell the formula of the cell found above it:

   C_LONGINT($Column;$Row)  `Coordinates of cell to re-copy
   C_TEXT($Formula)  `Formula to re-copy

   PV GET CURRENT CELL (Area;$Column;$Row)
   $Formula:=PV Get cell formula  (Area;$Column;$Row-1)  `Get the above formula
   PV SET CELL FORMULA (Area;$Column;$Row;$Formula)  `Re-copy

See Also

PV Get cell value type, PV SET CELL FORMULA.