PV Get cell formula
version 6.8
PV Get cell formula (area; column; row) String
Parameter | Type | Description | |
area | Longint | 4D View area | |
column | Longint | Cell column number | |
row | Longint | Cell 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