Click or drag to resize
Worksheet Class
A two-dimensional grid of cells that are organized into rows and columns.
Inheritance Hierarchy

Namespace: Telerik.Windows.Documents.Spreadsheet.Model
Assembly: Telerik.Windows.Documents.Spreadsheet (in Telerik.Windows.Documents.Spreadsheet.dll) Version: 2017.2.607.40 (2017.2.607.40)
Syntax
public class Worksheet : Sheet

The Worksheet type exposes the following members.

Methods
  NameDescription
Public methodBeginUndoGroup
Marks the beginning of an undo group.
(Inherited from Sheet.)
Public methodCopyFrom
Copies Worksheet contents from a source Worksheet into this instance. This Worksheet instance contents are overriden from the source Worksheet contents.
Protected methodCreateViewState
Creates the state of the view.
(Overrides SheetCreateViewState.)
Public methodDispose
Performs application-defined tasks associated with freeing, releasing, or resetting unmanaged resources.
(Inherited from Sheet.)
Protected methodDispose(Boolean)
Disposes the specified disposing.
(Overrides SheetDispose(Boolean).)
Public methodEndUndoGroup
Marks the end of the undo group.
(Inherited from Sheet.)
Public methodFind
Executes find action according to the specified find options.
Public methodFindAll
Executes find all action according to the specified find options.
Public methodGetUsedCellRange
Gets the used cell range for specific cell property definitions.
Protected methodOnIsProtectedChanged
Called when [is protected changed].
(Inherited from Sheet.)
Protected methodOnLayoutInvalidated
Called when [layout invalidated].
(Inherited from Sheet.)
Protected methodOnPropertyChanged(PropertyChangedEventArgs)
Raises the [E:PropertyChanged] event.
(Inherited from NotifyPropertyChangedBase.)
Protected methodOnPropertyChanged(String)
Called when when property is changed.
(Inherited from NotifyPropertyChangedBase.)
Public methodProtect
Protects the worksheet.
Public methodReplace
Executes replace action according to the specified replace options.
Public methodReplaceAll
Executes replace all action according to the specified replace options.
Protected methodResumeLayoutUpdate
Resumes the layout update.
(Inherited from Sheet.)
Protected methodSuspendLayoutUpdate
Suspends the layout update.
(Inherited from Sheet.)
Public methodUnprotect
Unprotects the worksheet.
Top
Properties
  NameDescription
Public propertyCells
Gets the cells of the worksheet.
Public propertyColumns
Gets the columns of the worksheet.
Public propertyDefaultColumnWidth
Gets or sets the default width of the column.
Public propertyDefaultRowHeight
Gets or sets the default height of the row.
Public propertyFilter
Gets the filtering of the worksheet.
Public propertyGroupingProperties
Gets the grouping properties for the worksheet.
Public propertyHeaderNameRenderingConverter
Gets or sets the header name rendering converter.
Public propertyHyperlinks
Gets the all hyperlinks in the worksheet.
Public propertyIsLayoutUpdateSuspended
Gets the value indicating whether the layout update is suspended.
(Inherited from Sheet.)
Public propertyIsProtected
Gets a value indicating whether the sheet is protected.
(Inherited from Sheet.)
Public propertyName
Gets or sets the name of the sheet.
(Inherited from Sheet.)
Public propertyNames
Gets the collection of defined names of the worksheet.
Public propertyProtectionOptions
Gets or sets the protection options.
Public propertyRows
Gets the rows of the worksheet.
Public propertyShapes
Gets the collection of shapes inserted in the current worksheet.
Protected propertySheetPageSetup
Gets the sheet page setup.
(Overrides SheetSheetPageSetup.)
Public propertySortState
Gets the sort state.
Public propertyType
Gets the type of the sheet.
(Overrides SheetType.)
Public propertyUsedCellRange
Gets the used cell range.
Public propertyViewState
Gets the view state of the worksheet.
Public propertyVisibility
Gets the visibility.
(Inherited from Sheet.)
Public propertyWorkbook
Gets the workbook.
(Inherited from Sheet.)
Public propertyWorksheetPageSetup
Gets the worksheet page setup.
Top
Events
  NameDescription
Public eventIsProtectedChanged
Occurs when the current protection state has changed.
(Inherited from Sheet.)
Public eventLayoutInvalidated
Occurs when the layout is invalidated.
(Inherited from Sheet.)
Public eventNameChanged
Occurs when name is changed.
(Inherited from Sheet.)
Public eventPropertyChanged
Occurs when a property value changes.
(Inherited from NotifyPropertyChangedBase.)
Top
See Also