WorksheetSetSplit(NullableSingle, NullableSingle, CellAddress, WorksheetWorksheetPane) Method

Sets the horizontal and vertical split of the worksheet into four panes. The measurement in characters cannot be used to freeze panes

Namespace: PicoXLSX
Assembly: PicoXLSX (in PicoXLSX.dll) Version: 3.4.5+6ab75fa9edd66571b0de8e574b48108101297ca1

Syntax

public void SetSplit(
	float? leftPaneWidth,
	float? topPaneHeight,
	CellAddress topLeftCell,
	WorksheetWorksheetPane activePane
)

leftPaneWidth NullableSingle: Width (similar to column width) from left of the worksheet to the split line in characters.
The parameter is nullable. If left null, the method acts identical to SetHorizontalSplit(Single, CellAddress, WorksheetWorksheetPane)
topPaneHeight NullableSingle: Height (similar to row height) from top of the worksheet to the split line in characters.
The parameter is nullable. If left null, the method acts identical to SetVerticalSplit(Single, CellAddress, WorksheetWorksheetPane)
topLeftCell CellAddress: Top Left cell address of the bottom right pane (if applicable)
activePane WorksheetWorksheetPane: Active pane in the split window.
The parameter is nullable