WorksheetViewState
Manages the visible portion and display settings of a worksheet, including zoom, frozen panes, selection, and gridline visibility.
Definition
Namespace:Telerik.Windows.Documents.Spreadsheet.Model
Assembly:Telerik.Windows.Documents.Spreadsheet.dll
Syntax:
public class WorksheetViewState : SheetViewStateBase, ISheetViewStateInheritance: objectSheetViewStateBaseWorksheetViewState
Implements:
Inherited Members
Constructors
Initializes a new instance of the WorksheetViewState class.
public WorksheetViewState()Methods
Freezes the sheet panes.
public void FreezePanes(CellIndex fixedPaneTopLeftCellIndex, int frozenRowsCount, int frozenColumnsCount, CellIndex scrollableTopLeftCellIndex)The top left cell index of the fixed pane.
frozenRowsCountintThe number of rows which will be frozen.
frozenColumnsCountintThe number of columns which will be frozen.
scrollableTopLeftCellIndexCellIndexThe top left cell index of the scrollable pane.
Freezes the sheet panes.
public void FreezePanes(CellIndex fixedPaneTopLeftCellIndex, int frozenRowsCount, int frozenColumnsCount)The top left cell index of the fixed pane.
frozenRowsCountintThe number of rows which will be frozen.
frozenColumnsCountintThe number of columns which will be frozen.
Properties
Gets or sets a value indicating whether to circle the invalid data.
public bool CircleInvalidData { get; set; }The value indicating whether to circle the invalid data.
Indicates whether this worksheet is the currently active sheet in the workbook.
public bool IsSelected { get; set; }The value indicating if the sheet is selected.
Defines the frozen pane configuration for locking rows and columns during scrolling.
public Pane Pane { get; set; }The pane.
ScaleFactor
Size
Controls the zoom level for the worksheet view, affecting how content is displayed without changing cell data.
public Size ScaleFactor { get; set; }The scale factor.
Tracks the active cell and selected ranges within the worksheet.
public SelectionState SelectionState { get; set; }The state of the selection.
Controls the visibility of cell gridlines in the worksheet view.
public bool ShowGridLines { get; set; }The value indicating if the gridlines should be shown.
Controls the visibility of row numbers and column letters in the worksheet view.
public bool ShowRowColHeaders { get; set; }The value indicating if the row and column headings should be shown.
Identifies the cell displayed at the top-left corner of the scrollable viewport, determining the visible area.
public CellIndex TopLeftCellIndex { get; set; }The index of the top left cell of the screen.
Gets or sets a value indicating how the worksheet should be displayed.
public SheetViewType ViewType { get; set; }The desired view type.