MindFusion.Spreadsheet.Wpf.Worksheet Members

MindFusion.Wpf Pack Programmer's Guide

Worksheet Members

Properties Methods Events

CollapseAll image

Members Options: Show All

Include Inherited Members
Include Protected Members

Represents a worksheet in a workbook, that is, a rectangular grid of cells containing data.

The following tables list the members exposed by the Worksheet type.

Public Properties

	Name	Description
	AutoFilter	Gets an AutoFilter object if autofiltering is enabled; otherwise, null.
	AutoFilterMode	Gets or sets a value indicating whether there is an active autofilter in the worksheet.
	CellRanges	Gets an object that can be used to access and manipulate rectangular ranges of worksheet cells.
	Cells	Gets an object that can be used to access worksheet cells by (column, row) index or by name.
	Columns	Gets an object that can be used to insert, delete and modify worksheet columns.
	DefaultColumnWidth	Gets or sets the default width of columns.
	DefaultRowHeight	Gets or sets the default height of rows.
	DocumentPaginator	IDocumentPaginatorSource.DocumentPaginator implementation.
	Drawing	Gets the Drawing object associated with the worksheet.
	FirstFrozenColumn	Gets or sets the index of the first frozen column in the worksheet.
	FirstFrozenRow	Gets or sets the index of the first frozen row in the worksheet.
	FrozenColumnCount	Gets or sets the number of frozen columns in the worksheet.
	FrozenRowCount	Gets or sets the number of frozen rows in the worksheet.
	Locale	Gets the locale of the parent workbook.
	MergedCells	Gets a list with the currently merged cells.
	Name	Gets or sets the name of the worksheet.
	Rows	Gets an object that can be used to insert, delete and modify worksheet rows.
	Tag	Gets or sets a custom object associated with the worksheet.
	Visible	Gets or sets a value indicating whether this worksheet is visible.

Public Methods

	Name	Description
	BeginInit	Signals the worksheet to enter an initialization state. To exit the initialization state, call EndInit.
	Clear	Clears the entire content of the worksheet.
	Copy	Overloaded. Copies this worksheet to another workbook.
	CopyData	Copies the data in the specified range and returns an object identifying the copied data.
	CopyStyles	Copies the styles in the specified range and returns an object identifying the copied styles.
	EndInit	Signals the worksheet that initialization is complete. To enter initialization state, call BeginInit.
	GetMergedCell	Overloaded. Gets the merged cell containing the specified cell.
	Merge	Overloaded. Merges the cells in a specified range into a single cell.
	Move	Overloaded. Moves this worksheet to another workbook.
	PasteData	Pastes the data identified by the specified object at the specified location. The data in the target range is discarded.
	PasteStyles	Pastes the styles identified by the specified object at the specified location. The style information in the target range is discarded.
	Sort	Sorts the data in the specified range according to the specified criteria.
	ToString	Object.ToString override.
	Unmerge	Overloaded. Unmerges all merged cells intersecting with a specified range.

Protected Methods

	Name	Description
	OnCellChanged	Raises the CellChanged event.
	OnCellChanging	Raises the CellChanging event.
	OnCellsCleared	Raises the CellsCleared event.
	OnColumnChanged	Raises the ColumnChanged event.
	OnPropertyChanged	Raises the PropertyChanged event.
	OnPropertyValueChanged	Raises the PropertyValueChanged event.
	OnRowChanged	Raises the RowChanged event.
	OnValidationFailed	Raises the ValidationFailed event.

Public Events

	Name	Description
	CellChanged	Raised when a cell of the worksheet is changed.
	CellChanging	Raised when a cell of the worksheet is about to change.
	CellsCleared	Raised when a range of cells has been cleared.
	ColumnChanged	Raised when a column is changed.
	PropertyChanged	Raised when a property of the worksheet is changed.
	PropertyValueChanged	Raised when a property of the worksheet is changed.
	RowChanged	Raised when a row is changed.
	ValidationFailed	Raised when the validation of entered data has failed and the validation's ErrorAction property is set to RaiseEvent.

See Also

Worksheet Class
MindFusion.Spreadsheet.Wpf Namespace