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

Automatically translated from English

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.

Fabrice Mainguené

• Product Owner •

Fabrice Mainguené joined 4D Program team in November, 2016. As a Product Owner, he is in charge of writing the user stories then translating it to functional specifications. His role is also to make sure that the feature implementation delivered is meeting the customer need.

After obtaining a Bachelor degree in Computer Science at CNAM, Fabrice joined a small software publishing company as a Windev developer. Then he worked for different companies in industry and trade areas as a Windev and web developer as well as technical advisor on new features.