4D View v16
PV SET 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 SET CELL FORMULA
PV SET CELL FORMULA
| PV SET CELL FORMULA ( area ; column ; row ; formula ) | ||||||||
| Parameter | Type | Description | ||||||
| area | Longint |
|
4D View area | |||||
| column | Longint |
|
Cell column number | |||||
| row | Longint |
|
Cell row number | |||||
| formula | String |
|
Formula | |||||
The following example creates an incrementation to the bottom from a numeric type cell. If the value of the latter is later modified, the incrementation will automatically be updated by formulas that we place in the cells with PV SET CELL FORMULA.
C_LONGINT($CopyNumber) //Number of copies to execute
C_LONGINT($Column;$Row) //Coordinates of cell to copy
C_LONGINT($Index) //Loop index
C_TEXT($Name) //Start cell name
PV GET CURRENT CELL(Area;$Column;$Row)
If(PV Get cell value type(Area;$Column;$Row)=pv number type value) //Type verification
//5 by default
$CopyNumber:=Num(Request("How many cells to the bottom do you want to increment?";"5"))
If($CopyNumber>0) //Validate
$Name:=PV Get cell name(Area;$Column;$Row) //Get name
If($Name="") //No name?
$Name:="COL"+String($Column)+"RW"+String($Row) //It currently has one
PV SET CELL NAME(Area;$Column;$Row;$Name) //"COL2RW3" type name
End if
For($Index;$Row+1;$Row+$CopyNumber) //$CopyNumber loop(s)
//Increase
PV SET CELL FORMULA(Area;$Column;$Index;"="+$Name+"+"+String($Index-$Row))
End for
End if
Else //Incorrect type
ALERT("The start cell must be a numeric type")
End if
See also
PROPERTIES
Product: 4D View
Theme: PV Cell value
Number:
15917
HISTORY
Created: 4D View 6.8
ARTICLE USAGE
4D View Language ( 4D View v16)
© 1985-2018 4D SAS / 4D, Inc. All rights reserved.