WorksheetPanes Class

Namespace:
GemBox.Spreadsheet
Assembly:
GemBox.Spreadsheet.dll

Represents the worksheet panes.

public class WorksheetPanes
Public Class WorksheetPanes
Inheritance:
System.Object
WorksheetPanes

Constructors

WorksheetPanes(PanesState, Single, Single, String, PanePosition)

Initializes a new instance of the WorksheetPanes class.

public WorksheetPanes(PanesState state, float xSplit, float ySplit, string topLeftCell, PanePosition activePane)
Public Sub New(state As PanesState, xSplit As Single, ySplit As Single, topLeftCell As String, activePane As PanePosition)
Parameters
state
PanesState

State of the panes.

xSplit
System.Single

If the panes are frozen, xSplit represents the number of columns visible in the left pane. If the panes are not frozen, xSplit represents the position of the split, in 1/20th of a point, 0 (zero) if none.

ySplit
System.Single

If the panes are frozen, ySplit represents the number of rows visible in the top pane. If the panes are not frozen, ySplit represents the position of the split, in 1/20th of a point, 0 (zero) if none.

topLeftCell
System.String

Top left visible cell in the bottom right pane.

activePane
PanePosition

Position of the active pane.

WorksheetPanes(WorksheetPanes)

Copy constructor.

public WorksheetPanes(WorksheetPanes sourcePane)
Public Sub New(sourcePane As WorksheetPanes)
Parameters
sourcePane
WorksheetPanes

Source pane.

WorksheetPanes(Int32, Int32)

Initializes a new instance of the WorksheetPanes class with frozen state.

public WorksheetPanes(int freezedRows, int freezedColumns)
Public Sub New(freezedRows As Integer, freezedColumns As Integer)
Parameters
freezedRows
System.Int32

Number of rows visible in the top pane.

freezedColumns
System.Int32

Number of columns visible in the left pane.

Properties

ActivePane

Gets or sets the active pane.

public PanePosition ActivePane { get; set; }
Public Property ActivePane As PanePosition
Property Value
PanePosition

State

Gets or sets the state of the panes.

public PanesState State { get; set; }
Public Property State As PanesState
Property Value
PanesState

TopLeftCell

Gets or sets the top left visible cell in the bottom right pane.

public string TopLeftCell { get; set; }
Public Property TopLeftCell As String
Property Value
System.String

XSplit

Gets or sets the XSplit value.

public float XSplit { get; set; }
Public Property XSplit As Single
Property Value
System.Single
Remarks

If the panes are frozen, xSplit represents the number of columns visible in the top right pane. If the panes are not frozen, xSplit represents the position of the split, in 1/20th of a point, 0 (zero) if none.

YSplit

Gets or sets the XSplit value.

public float YSplit { get; set; }
Public Property YSplit As Single
Property Value
System.Single
Remarks

If the panes are frozen, ySplit represents the number of rows visible in the top right pane. If the panes are not frozen, ySplit represents the position of the split, in 1/20th of a point, 0 (zero) if none.