jFreezePanes()Estimated reading time: 3 minutes
The jFreezePanes function freezes a designated pane so the user can scroll through data and still keep the frozen pane in view. The function also hides a designated range of the report, typically the configuration section of an Interject report. This provides the user with a more user-friendly simplified viewing experience.
This action can be triggered by the Freeze/UnFreeze Panes found in Quick Tools on the Interject Ribbon Menu. There is also an option there to Freeze All Tabs, which will freeze all sheets containing the jFreezePanes function (it will not unfreeze the panes).
For an example of this function, see Lab Create: Customer Aging.
|If Blank||Function Error|
|If Blank||Will display all rows|
Excel Formula Bar Example
|Argument Name||Example Mapping||Explanation|
|Function Name||=jFreezePanes()||The name of this function.|
|FreezePanesCell||A22||Row 22 will be frozen in place and all rows from 23 on will be able to scroll.|
|AnchorViewCell||A15||Row 15 will be the topmost row in view after a freeze panes action.|