4D View Pro: Freeze panes to lock rows or columns

If you have a large table of data, it can be useful to keep an area of a worksheet visible while you scroll to another area. That’s why 4D v18 R2 includes a new command to help you create panes. Say hello to VP SET FROZEN PANES.

HDI Freeze Span

With the VP SET FROZEN PANES command, you can create up to 4 frozen panes in your area: one on the left, one on the top, one on the right, and one on the bottom. For example, if you want to continuously view the first and last columns and rows while scrolling through the data, here’s how:

$panes:=New object
$panes.columnCount:=1 // first column
$panes.trailingColumnCount:=1 // last column
$panes.rowCount:=1 // first row
$panes.trailingRowCount:=1 // last row
VP SET FROZEN PANES ("ViewProArea";$panes)

This is the result:

Test this command with the HDI above.