Documentation

Class WorksheetViewState

Represents the visible section of the worksheet.

Inheritance
System.Object
SheetViewStateBase
WorksheetViewState
Inherited Members
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
Namespace: Telerik.Windows.Documents.Spreadsheet.Model
Assembly: Telerik.Windows.Documents.Spreadsheet.dll

Syntax

public class WorksheetViewState : SheetViewStateBase, ISheetViewState

Constructors

WorksheetViewState()

Initializes a new instance of the WorksheetViewState class.

Declaration
public WorksheetViewState()

Properties

CircleInvalidData

Gets or sets a value indicating whether to circle the invalid data.

Declaration
public bool CircleInvalidData { get; set; }
Property Value
System.Boolean

The value indicating whether to circle the invalid data.

IsSelected

Gets or sets value indicating if the sheet is selected.

Declaration
public bool IsSelected { get; set; }
Property Value
System.Boolean

The value indicating if the sheet is selected.

Pane

Gets or sets the pane.

Declaration
public Pane Pane { get; set; }
Property Value
Pane

The pane.

ScaleFactor

Gets or sets the scale factor.

Declaration
public Size ScaleFactor { get; set; }
Property Value
System.Windows.Size

The scale factor.

SelectionState

Gets or sets the state of the selection.

Declaration
public SelectionState SelectionState { get; set; }
Property Value
SelectionState

The state of the selection.

ShowGridLines

Gets or sets value indicating if the gridlines should be shown.

Declaration
public bool ShowGridLines { get; set; }
Property Value
System.Boolean

The value indicating if the gridlines should be shown.

ShowRowColHeaders

Gets or sets value indicating if the row and column headings should be shown.

Declaration
public bool ShowRowColHeaders { get; set; }
Property Value
System.Boolean

The value indicating if the row and column headings should be shown.

TopLeftCellIndex

Gets or sets the index of the top left cell of the screen.

Declaration
public CellIndex TopLeftCellIndex { get; set; }
Property Value
CellIndex

The index of the top left cell of the screen.

ViewType

Gets or sets a value indicating how the worksheet should be displayed.

Declaration
public SheetViewType ViewType { get; set; }
Property Value
SheetViewType

The desired view type.

Methods

FreezePanes(Int32, Int32)

Freezes the sheet panes.

Declaration
public void FreezePanes(int frozenRowsCount, int frozenColumnsCount)
Parameters
System.Int32 frozenRowsCount

The number of rows which will be frozen.
System.Int32 frozenColumnsCount

The number of columns which will be frozen.

FreezePanes(CellIndex, Int32, Int32)

Freezes the sheet panes.

Declaration
public void FreezePanes(CellIndex fixedPaneTopLeftCellIndex, int frozenRowsCount, int frozenColumnsCount)
Parameters
CellIndex fixedPaneTopLeftCellIndex

The top left cell index of the fixed pane.
System.Int32 frozenRowsCount

The number of rows which will be frozen.
System.Int32 frozenColumnsCount

The number of columns which will be frozen.

FreezePanes(CellIndex, Int32, Int32, CellIndex)

Freezes the sheet panes.

Declaration
public void FreezePanes(CellIndex fixedPaneTopLeftCellIndex, int frozenRowsCount, int frozenColumnsCount, CellIndex scrollableTopLeftCellIndex)
Parameters
CellIndex fixedPaneTopLeftCellIndex

The top left cell index of the fixed pane.
System.Int32 frozenRowsCount

The number of rows which will be frozen.
System.Int32 frozenColumnsCount

The number of columns which will be frozen.
CellIndex scrollableTopLeftCellIndex

The top left cell index of the scrollable pane.

ToString()

Returns a System.String that represents the current System.Object.

Declaration
public override string ToString()
Returns
System.String

A System.String that represents the current System.Object.
Overrides
System.Object.ToString()