4D v13

PV Get cell formula

Home

 
4D View v13
PV Get cell formula

PV Get cell formula 


 

PV Get cell formula ( area ; column ; row ) -> Function result 
Parameter Type   Description
area  Longint in 4D View area
column  Longint in Cell column number
row  Longint in Cell row number
Function result  String in Formula

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

 
PROPERTIES 

Product: 4D
Theme: PV Cell value
Number: 15912

 
INDEX

Alphabetical list of commands

 
HISTORY 

Created: 4D View 6.8

 
SEE ALSO 

PV Get cell value type
PV SET CELL FORMULA