PV SET CELL BOOLEAN VALUE

Home

4D View v16


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_LONGINT($CopyNumber)

 C_LONGINT($Column;$Row) //Coordinates of the cell to copy

 C_LONGINT($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