4D Doc Center : PV DELETE CELLS

Home

4D View v14

PV DELETE CELLS


PV DELETE CELLS ( area ; column ; row ; number ; direction )

Parameter	Type	Description
area	Longint	4D View area
column	Longint	Column number
row	Longint	Row number
number	Longint	Number of cells to delete
direction	Longint	Direction to shift the cells

Description

The PV DELETE CELLS command deletes number cell(s) in area starting at cell defined by column and row.

The direction parameter allows you to define if the existing cells must be shifted toward the top or the left. Use the pv to the left or pv to the top constants in the PV Directions theme to set the value of this parameter:

Constant	Type	Value
pv to the left	Longint	2
pv to the top	Longint	3

Note: This command must not be called within a dynamic area. Otherwise, the error 86 is generated.

Example

The following example deletes one cell starting at column 2 and row 2. Other cells will be shifted toward the top:

PV DELETE CELLS(area;2;2;1;pv to the top)