Skip to content

CREPORTFREEZEPANE

CREPORTFREEZEPANE only applies to published reports. The formula is entered in Excel but its behaviour only becomes evident after the report is published. The function creates freeze panes in a report. Panes can be either rows, columns or both (i.e. quadrants: a four-way split).

Note

Merged cells should not cross over freeze pane boundaries. This will cause the report to render incorrectly.

Syntax

CREPORTFREEZEPANE (Location, Style)

Arguments

Location: string (required)

The location from which the freeze pane should start as a Cell Reference string.

You need to use a string for this argument, not a cell reference, as if it is a cell reference, the value from that cell will be used, not the reference itself.

Style : string (required)

The style of pane.

Acceptable values are:

Row, Col, Quad

Usage Scenarios

To create a freeze pane in a report. Set the location to the first scrollable row or column and define a type of freeze pane from either row, column or quadrant.

If you select D5 as a Row freeze pane the entire 5th row will freeze.

If you select D5 as a Col freeze pane the entire ‘D’ column will freeze.

If you select E5 as a Quad freeze pane, the screen will be split into 4 at column ‘E’ on the 5th row.

Examples

Column

=CREPORTFREEZEPANE(“D”,"Col")

If the web page is wide enough, no scrolling is required.

Once the web pane is small enough, scrolling across columns (with locked columns prior to column D) will demonstrate the functionality of CREPORTFREEZEPANE.

Row

=CREPORTFREEZEPANE(10,"Row")

Scrolling locks from row 10

Quad

=CREPORTFREEZEPANE("D10","Quad")

Using the Quad option results in a four-way split

Scrolling is locked from Column ‘C’ and Row 9. Column ‘D’ onwards as well as Row 10 onwards are scrollable.