skip navigation
  • Product Bundles

    DevCraft

    All Telerik .NET tools and Kendo UI JavaScript components in one package. Now enhanced with:

    • NEW: Design Kits for Figma
    • Online Training
    • Document Processing Library
    • Embedded Reporting for web and desktop

    Web

    Kendo UI UI for Angular UI for Vue UI for jQuery KendoReact UI for Blazor UI for ASP.NET Core UI for ASP.NET MVC UI for ASP.NET AJAX

    Mobile

    UI for .NET MAUI

    Document Management

    Telerik Document Processing

    Desktop

    UI for .NET MAUI UI for WinUI UI for WinForms UI for WPF

    Reporting

    Telerik Reporting Telerik Report Server

    Testing & Mocking

    Test Studio Telerik JustMock

    CMS

    Sitefinity

    AI Productivity Tools

    AI Coding Assistants

    UI/UX Tools

    ThemeBuilder Design System Kit Templates and Building Blocks

    Debugging

    Fiddler Fiddler Everywhere Fiddler Classic Fiddler Everywhere Reporter FiddlerCore

    Free Tools

    KendoReact Free VB.NET to C# Converter Testing Framework
    View all products
  • Overview
  • Demos
    • Roadmap
    • Release History
  • Docs & Support
  • Pricing
  • Shopping cart
    • Account Overview
    • Your Licenses
    • Downloads
    • Support Center
    • Forum Profile
    • Payment Methods
    • Edit Profile
    • Log out
  • Login
  • Contact Us
  • Try now

Class WorksheetViewState

Represents the visible section of the worksheet.

Inheritance
System.Object
SheetViewStateBase
WorksheetViewState
Inherited Members
SheetViewStateBase.TabColor
SheetViewStateBase.IsInvalidated
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()
Getting Started
  • Getting Started
Support Resources
  • Documentation
Community
  • Forums
  • Blogs
  • Document Processing Feedback Portal

Copyright © 2018 Progress Software Corporation and/or its subsidiaries or affiliates.
All Rights Reserved.

Progress, Telerik, and certain product names used herein are trademarks or registered trademarks of Progress Software Corporation and/or one of its subsidiaries or affiliates in the U.S. and/or other countries. See Trademarks for appropriate markings.