4D v13

PV SET CELL BOOLEAN VALUE

Home

 
4D View v13
4D View Language
PV Cell value
PV SET CELL BOOLEAN VALUE

PV SET CELL BOOLEAN VALUE 


 

PV SET CELL BOOLEAN VALUE ( area ; column ; row ; value ) 
Parameter Type   Description
area  Longint in 4D View area
column  Longint in Cell column number
row  Longint in Cell row number
value  Integer in Cell value

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

 
PROPERTIES 

Product: 4D
Theme: PV Cell value
Number: 15841

 
INDEX

Alphabetical list of commands

 
HISTORY 

Created: 4D View 6.8

 
SEE ALSO 

PV Get cell boolean value
PV Get cell value type