PV Get cell formula

4D - Documentation   Français   English   German   4D View 2004, Command Theme List   4D View 2004, Command Alphabetical List   4D View 2004, Constant Theme List   Back   Previous   Next

version 6.8


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

ParameterTypeDescription
areaLongint4D View area
columnLongintCell column number
rowLongintCell row number
Function resultStringFormula

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.


4D - Documentation   Français   English   German   4D View 2004, Command Theme List   4D View 2004, Command Alphabetical List   4D View 2004, Constant Theme List   Back   Previous   Next