WorksheetSetVerticalSplit(Int32, Boolean, Address, NullableWorksheetWorksheetPane) Method

Sets the vertical split of the worksheet into two panes. The measurement in columns can be used to split and freeze panes

Namespace: NanoXLSX
Assembly: NanoXLSX (in NanoXLSX.dll) Version: 2.6.3+98f265239ae8df4639650ecd7029244cc5e52dfc

Syntax

public void SetVerticalSplit(
	int numberOfColumnsFromLeft,
	bool freeze,
	Address topLeftCell,
	WorksheetWorksheetPane? activePane
)

numberOfColumnsFromLeft Int32: Number of columns from left of the worksheet to the split line. The particular column widths are considered
freeze Boolean: If true, all panes are frozen, otherwise remains movable
topLeftCell Address: Top Left cell address of the bottom right pane (if applicable). Only the column component is important in a vertical split
activePane NullableWorksheetWorksheetPane: Active pane in the split window.
The parameter is nullable

Exceptions

Exception	Condition
WorksheetException	WorksheetException Thrown if the column number of the top left cell is smaller the split panes number of columns from left, if freeze is applied