4D View v16
PV Get cell formula
- 4D View Language
-
- PV Cell value
-
- PV Cell value, Introduction
- PV ADD DYNAMIC ARRAYS
- PV ADD DYNAMIC FIELDS
- PV ARRAY TO CELLS
- PV CELLS TO ARRAY
- PV CLEAR DYNAMIC COLUMNS
- PV FIELD TO CELLS
- PV FIELDS LIST TO CELLS
- PV Get cell boolean value
- PV GET CELL CONTROL
- PV GET CELL DATE TIME VALUE
- PV Get cell date value
- PV GET CELL FIELD
- PV Get cell formula
- PV Get cell num value
- PV Get cell picture value
- PV Get cell string value
- PV Get cell text value
- PV Get cell time value
- PV Get cell value type
- PV Get cell variable
- PV REPORT MANY
- PV REPORT ONE
- PV SET CELL BOOLEAN VALUE
- PV SET CELL CONTROL
- PV SET CELL DATE TIME VALUE
- PV SET CELL DATE VALUE
- PV SET CELL FIELD
- PV SET CELL FORMULA
- PV SET CELL NUM VALUE
- PV SET CELL PICTURE VALUE
- PV SET CELL STRING VALUE
- PV SET CELL TEXT VALUE
- PV SET CELL TIME VALUE
- PV SET CELL VARIABLE
- PV UPDATE DYNAMIC AREA
4D View v16
PV Get cell formula
PV Get cell formula
| PV Get cell formula ( area ; column ; row ) -> Function result | ||||||||
| Parameter | Type | Description | ||||||
| area | Longint |
|
4D View area | |||||
| column | Longint |
|
Cell column number | |||||
| row | Longint |
|
Cell row number | |||||
| Function result | String |
|
Formula | |||||
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
PROPERTIES
Product: 4D View
Theme: PV Cell value
Number:
15912
HISTORY
Created: 4D View 6.8
ARTICLE USAGE
4D View Language ( 4D View v16)
© 1985-2018 4D SAS / 4D, Inc. All rights reserved.