Command PV SET CELL BOOLEAN VALUE

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

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.

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

PV Get cell boolean value, PV Get cell value type.