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.2+f55916d49ef2baa43fc7dc8f5c7d751a77c50baf
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