PV SET CELL BOOLEAN VALUE
version 6.8
PV SET CELL BOOLEAN VALUE (area; column; row; value)
| Parameter | Type | Description | |
| area | Longint |  | 4D View area |
| column | Longint | | Cell column number |
| row | Longint | | Cell row number |
| value | Integer | | Cell value |
Description
The PV SET CELL BOOLEAN VALUE command assigns the integer value to the cell assigned by column and row. This integer allows expressing a Boolean value (0=False, 1=True): it is then necessary to translate 4D Booleans as a Num(theBoolean) function.
Example
We will modify the example for the PV SET CELL STRING VALUE command to a Boolean type, represented by an integer:
C_INTEGER($CopyNumber)
C_LONGINT($Column;$Row) `Coordinates of the cell to copy
C_INTEGER($Index) `Loop index
C_BOOLEAN($Value) `Value to copy
$CopyNumber:=Num(Request("How many copies toward the bottom would you like?";"5")) `5 by default
If ($CopyNumber>0)
PV GET CURRENT CELL (Area;$Column;$Row) `Cell to copy
$Value:=(PV Get cell boolean value(Area;$Column;$Row)=1) `Converting integer to boolean
For ($Index;$Row+1;$Row+$CopyNumber) `$CopyNumber loop(s)
PV SET CELL BOOLEAN VALUE (Area;$Column;$Index;Num($Value)) `Copy value
End for
End if
See Also