Click or drag to resize
PicoXLSX

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+3a069966d2787c42b695e5043a5e083b247634e3
Syntax
C#
public void SetSplit(
	float? leftPaneWidth,
	float? topPaneHeight,
	CellAddress topLeftCell,
	WorksheetWorksheetPane activePane
)

Parameters

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
See Also