4D v13
PV SET CELL STRING VALUE
- 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
PV SET CELL STRING VALUE
| PV SET CELL STRING VALUE ( area ; column ; row ; value ) | ||||||||
| Parameter | Type | Description | ||||||
| area | Longint |
|
4D View area | |||||
| column | Longint |
|
Cell column number | |||||
| row | Longint |
|
Cell row number | |||||
| value | String |
|
Cell value | |||||
The PV SET CELL STRING VALUE command writes the character string value in the cell assigned by column and row.
If value starts with a "=", it will be read as a formula.
The following example reproduces the "Copy toward the bottom" spreadsheet only for alphanumeric type cells.
C_INTEGER($CopyNumber)
C_LONGINT($Column;$Row) `Coordinates of cell to copy
C_INTEGER($Index) `Loop index
C_STRING(80;$Value) `Value to copy
$CopyNumber:=Num(Request("How many times should it copy towards the bottom?";"5")) `5 by default
If($CopyNumber>0)
PV GET CURRENT CELL(Area;$Column;$Row) `Cell to copy
$Value:=PV Get cell string value(Area;$Column;$Row)
For($Index;$Row+1;$Row+$CopyNumber) `$CopyNumber loop(s)
PV SET CELL STRING VALUE(Area;$Column;$Index;$Value)
End for
End ifTip: This method can be used for any types, or better yet, to call a generic method testing the cell type with PV Get cell value type before calling the "PV Get cell xxx value" then the "PV SET CELL XXX VALUE" commands to copy the value regardless of its type, which can be a good exercise in generic programming.
Product: 4D
Theme: PV Cell value
Number:
15856
Created: 4D View 6.8
PV Get cell string value
PV Get cell value type
