MindFusion.Spreadsheet.Wpf.Worksheet Methods

Worksheet Methods

CollapseAll image

Members Options: Show All

Include Inherited Members
Include Protected Members

General Information

What's New in this Release

Version History

Programming Interface Overview

MindFusion.Spreadsheet.Wpf

AddItemCommand(T) Class

AdjustmentHandles Enumeration

Annotation Class

AutoFilter Class

AutoFilterOperator Enumeration

BaseMouseEventArgs Class

CalcExporter Class

CalcImporter Class

CellAnnotation Class

CellAnnotationPresenter Class

CellChangedEventArgs Class

CellCollection Class

CellEventArgs Class

CellIndex Class

CellMouseEventArgs Class

CellRange Class

CellRangeCollection Class

CellValidationEventArgs Class

ChangeWorksheetCommand Class

ColumnChangedEventArgs Class

ColumnCollection Class

ColumnEventArgs Class

ColumnHeader Class

ColumnMouseEventArgs Class

ColumnRange Class

ColumnRangeEventArgs Class

ColumnRangeMovingEventArgs Class

ColumnRangeResizingEventArgs Class

ComparisonOperator Enumeration

CompositeCommand Class

ConditionalFormatType Enumeration

Converter Class

CornerHeader Class

CsvExporter Class

CsvImporter Class

CurrencyCodeInfo Class

CurrencyCodes Class

CursorHint Enumeration

DefaultNumericFormats Class

DisposableCommand Class

DynamicFilterType Enumeration

ExcelExporter Class

ExcelImporter Class

FillDate Enumeration

FillDirection Enumeration

FillType Enumeration

FindWithin Enumeration

FormattedText Class

HatchBrush Class

HatchStyle Enumeration

HorizontalAlignment Enumeration

Hyperlink Class

HyperlinkType Enumeration

IColumnStyle Interface

IConditionalFormat Interface

IConditionalFormatCollection Interface

IHasName Interface

IInplaceEditable Interface

INotifyCollectionChanged Interface

INotifyPropertyValueChanged Interface

InplaceEditEventArgs Class

InplaceEditValidationEventArgs Class

InteractiveObject Class

InteractiveObjectPresenter Class

IRowStyle Interface

IStyle Interface

IValidation Interface

LookIn Enumeration

MeasureUnit Class

MergedCellsCollection Class

MoveItemCommand(T) Class

NamedCollection(T) Class

NamedRange Class

NamedRangeCollection Class

NotifyCollectionChangedAction Enumeration

NotifyCollectionChangedEventArgs Class

NumericFormatInfo Class

ObjectAnchor Enumeration

ObjectAnchorPosition Enumeration

ObjectEventArgs Class

ObjectInteractionEventArgs Class

ObjectInteractionValidationEventArgs Class

ObjectMouseEventArgs Class

ObjectValidationEventArgs Class

ObservableCollection(T) Class

OutlineEventArgs Class

PageOrder Enumeration

PaginationOptions Class

PdfExporter Class

PicturePresenter Class

PropertyEventArgs Class

PushDirection Enumeration

RemoveItemCommand(T) Class

ReplaceItemCommand(T) Class

ResetCollectionCommand(T) Class

RowChangedEventArgs Class

RowCollection Class

RowEventArgs Class

RowHeader Class

RowMouseEventArgs Class

RowRangeEventArgs Class

RowRangeMovingEventArgs Class

RowRangeResizingEventArgs Class

SearchDirection Enumeration

SearchOrder Enumeration

Selection Class

SerializeColumnTagEventArgs Class

SerializeDataEventArgs Class

SerializeRowTagEventArgs Class

SerializeTagEventArgs Class

ShiftDirection Enumeration

SortDirection Enumeration

SortOptions Class

SortOrder Enumeration

StyleData Class

TrackChangesCommand Class

UndoableCollection(T) Class

UndoEventArgs Class

ValidationErrorAction Enumeration

ValidationFailedEventArgs Class

ValidationType Enumeration

VerticalAlignment Enumeration

WorkbookPrinter Class

WorkbookView Class

Worksheet Class

WorksheetChangedEventArgs Class

WorksheetCollection Class

WorksheetEventArgs Class

WorksheetMouseEventArgs Class

WorksheetTabMouseEventArgs Class

WorksheetValidationEventArgs Class

XmlContext Class

MindFusion.Spreadsheet.Wpf.Charts

MindFusion.Spreadsheet.Wpf.Expressions

MindFusion.Spreadsheet.Wpf.StandardForms

Function Reference

Online Resources

Technical Support

MindFusion Products

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.

See Also

Worksheet Class
MindFusion.Spreadsheet.Wpf Namespace