4D v13

PV GOTO NEXT CELL

Home

 
4D View v13
PV GOTO NEXT CELL

PV GOTO NEXT CELL 


 

PV GOTO NEXT CELL ( area ; direction ) 
Parameter Type   Description
area  Longint in 4D View area
direction  Integer in Direction constant

When the PV GOTO NEXT CELL command is called, the next cell in the specified direction parameter becomes the current cell of the area. If the previous current cell was in entry mode, its contents are validated.

The direction axis is one of four values of the PV Directions constant theme:

Constant Type Value
pv to the bottom Longint 1
pv to the left Longint 2
pv to the right Longint 0
pv to the top Longint 3

Example  

Imagine a spreadsheet where we have to put the cell corresponding to the "Total Amount" of a bill in bold type:

 C_LONGINT(Column;Row`Current cell coordinates
 
 PV FIND ALL(Area;"Total Amount";1;0) `Find cell containing "Total Amount"
 PV GOTO NEXT CELL(Area;pv to the right`Cell containing the value
 PV GET CURRENT CELL(Area;$Column;$Row`Get coordinates
 
  `Make selected cell in bold
 PV SET CELL PROPERTY(Area;$Column;$Row;pv style text bold;pv value on)

 
PROPERTIES 

Product: 4D
Theme: PV Current cell
Number: 15930

 
INDEX

Alphabetical list of commands

 
HISTORY 

Created: 4D View 6.8

 
SEE ALSO 

PV GET CURRENT CELL
PV GOTO CELL