Freezing and Splitting Panes (Infragistics Excel Engine)

This topic explains how to freeze columns and/or rows and how to split the worksheet in several panes.

The following topics are prerequisites to understanding this topic:

This topic contains the following sections:

The following table explains briefly the configurable aspects of the freezing and splitting features. Further details are available after the table.

You can freeze row(s) at top or column(s) at left of a worksheet using the freezing panes features. Frozen row(s) and/or column(s) remain visible at all time while the user is scrolling. The frozen row(s) and/or column(s) are separate from the rest of the worksheet by a single solid line, which cannot be moved.

The following table maps the desired configuration to the FrozenPaneSettings object’s properties that manage it.

The following example code demonstrates how to freeze rows and columns. The example code assumes you have a reference to a worksheet object named worksheet1:

In C#:

You can use the splitting panes feature to split the worksheet into two (either horizontal or vertical) panes or four panes. Each pane supports scrolling, however panes on one column will share the same horizontal scrollbar and panes on one row will share the same vertical scrollbar. The split panes are separated by a double border which supports resizing.

The following table maps the desired configuration to the UnfrozenPaneSettings object’s properties that manage it.

The following example code demonstrates how to split rows and columns. The example code assumes you have a reference to a worksheet object named worksheet1:

In C#:

The following topics provide additional information related to this topic.