PV GET NEXT FREE CELL
version 6.8
PV GET NEXT FREE CELL (area; direction; column; row)
| Parameter | Type | Description | |
| area | Longint |  | 4D View area |
| direction | Integer | | Direction constant |
| column | Longint |  | Column number |
| row | Longint | | Row number |
Description
The PV GET NEXT FREE CELL command gets the column and row coordinates in the next free cell in the specified direction.
The direction axe is one of four values of the PV Directions constant theme: right, bottom, left or top.
Example
In your 4D View area, containing an array of entered data (entirely filled), let's count the number of rows and columns occupied in this array.
We know that the first cell entered is located where column C and row 4 intersect. At the present, the plug-in will determine the number of columns and rows occupied by the entry range.
C_LONGINT($StartCol;$StartRow) `Original cell coordinates
C_LONGINT($RightCol;$RightRow) `Right-most coordinates
C_LONGINT($LowCol;$LowRow) `Lowest coordinates
$StartCol:=3 `Initialization
$StartRow:=4
PV GOTO CELL (Area;$StartCol;$StartRow) `Positioning
`Get right-most coordinates
PV GET NEXT FREE CELL(Area;pv to the right;$RightCol;$RightRow)
`Get lowest coordinates
PV GET NEXT FREE CELL(Area;pv to the bottom;$LowCol;$LowRow)
ALERT("The entered data occupies "+String($RightCol-$StartCol)+" column(s) on "
+String($LowRow-$StartRow)+" row(s).")
See Also
PV GOTO CELL, PV GOTO NEXT CELL.
Constants
PV Directions theme.